Loading
  1. /****Setting the header width for each harvester******/
  2. /*GPC-P1*/
  3. IF (NEW.deviceid = 'astra_357322042742350') THEN
  4.   IF(field_id_ IS NOT NULL) THEN
  5.     SELECT ROUND(SUM(dist_since_last_report),2) INTO distance_in_meters_ FROM eventdata WHERE astra_input_mask = 111 AND field_id = field_id_;
  6.     UPDATE gts_hectare_birdseye_fields.fields SET area_harvested = ROUND(((distance_in_meters_ * 3.55) * 0.0001),2) WHERE field_id = field_id_;
  7.   END IF;
  8. END IF;

Comments