847 B
Executable File
ORDER PICKUP / DROP ZONE
UPDATE db_trucking_dev.t_orders_drops, (SELECT * FROM db_trucking_dev.t_zones WHERE id = 113) as zone SET drop_id = zone.id, drop_name = zone.name, drop_type = zone.type, drop_workflow = zone.workflow_type, drop_addr = zone.fulladdress, drop_cgroup_id = zone.client_group_id, drop_cdiv_id = zone.client_div_id, drop_cgp_id = zone.client_gp_id, drop_hex_color = zone.boundary_hex_color, drop_shiptocode = zone.shiptocode, drop_prid = zone.prid, drop_ktid = zone.ktid, drop_kcid = zone.kcid, drop_klid = zone.klid, drop_shape = zone.boundary_type, drop_radius = zone.boundary_radius, drop_diameter = zone.boundary_diameter, drop_area = zone.boundary_area, drop_ha = zone.boundary_ha, drop_bounds = zone.boundary_bounds, drop_latlngs = zone.boundary_latlngs, drop_points = zone.boundary_points WHERE t_orders_drops.id = 16;