Esempio n. 1
0
 public function saveEditRunner(Request $request)
 {
     $data = $request->all();
     $runner_id = $data['runner_id'];
     $runner_name = $data['runner_name'];
     if (!$runner_name) {
         $runner_name = "R{$runner_id}";
     }
     $obj_froms = explode(',', $data['obj_from']);
     $obj_tos = explode(',', $data['obj_to']);
     $order = $data['order'];
     $alloc_type = $data['alloc_type'];
     $theor_value_type = $data['theor_value_type'];
     $theor_phase = $data['theor_phase'];
     //Update order
     AllocRunner::where(['ID' => $runner_id])->update(['NAME' => $runner_name, 'ORDER' => $order, 'ALLOC_TYPE' => $alloc_type, 'THEOR_VALUE_TYPE' => $theor_value_type, 'THEOR_PHASE' => $theor_phase]);
     //Delete all Object in runner
     AllocRunnerObjects::where(['RUNNER_ID' => $runner_id])->delete();
     //Add again
     foreach ($obj_froms as $obj_from) {
         $xs_f = explode(':', $obj_from);
         if ($xs_f[1] == "") {
             continue;
         }
         AllocRunnerObjects::insert(['RUNNER_ID' => $runner_id, 'OBJECT_TYPE' => $xs_f[1], 'OBJECT_ID' => $xs_f[0], 'DIRECTION' => 1, 'MINUS' => $xs_f[2]]);
     }
     foreach ($obj_tos as $obj_to) {
         $xs_t = explode(':', $obj_to);
         if ($xs_t[1] == "") {
             continue;
         }
         AllocRunnerObjects::insert(['RUNNER_ID' => $runner_id, 'OBJECT_TYPE' => $xs_t[1], 'OBJECT_ID' => $xs_t[0], 'DIRECTION' => 0, 'MINUS' => $xs_t[2]]);
     }
     return response()->json('ok');
 }
Esempio n. 2
0
File: run.php Progetto: hunglmtb/eb
 private function run_runner($runner_id, $from_date, $to_date, $alloc_attr, $alloc_phase, $theor_phase, $alloc_comp, $alloc_type, $theor_attr)
 {
     global $error_count;
     $runner_name = AllocRunner::where(['ID' => $runner_id])->select('NAME')->first();
     $this->_log("Begin runner {$runner_name->NAME} (ID: {$runner_id}), from date: {$from_date}, to date: {$to_date}, alloc_attr: {$alloc_attr}, alloc_phase: {$alloc_phase}", 2);
     $xdate = date_create("2016-01-01");
     $from_date = date('Y-m-d', strtotime($from_date));
     $to_date = date('Y-m-d', strtotime($to_date));
     if (date_create($from_date) < $xdate || date_create($to_date) < $xdate) {
         $ret = $this->_log("Can not run allocation for the date earlier than 01/01/2016.", 1);
         return false;
     }
     $success = true;
     $event_type = 0;
     if ($alloc_type == 1 || $alloc_type == 2) {
         $event_type = $alloc_type;
     }
     if ($alloc_phase != 2) {
         $alloc_comp = false;
     }
     if (!$theor_phase) {
         $theor_phase = $alloc_phase;
     } else {
         if ($theor_phase != $alloc_phase) {
             $this->_log("Theor. phase changed to: {$theor_phase}", 2);
         }
     }
     $F = "VOL";
     if (strpos($alloc_attr, 'MASS') !== false) {
         $F = "MASS";
     }
     $alloc_attr_eu = $alloc_attr;
     if ($alloc_attr == "NET_VOL") {
         $alloc_attr_eu = "GRS_VOL";
     }
     if (!$theor_attr) {
         $theor_attr = $alloc_attr;
     } else {
         if ($theor_attr != $alloc_attr) {
             $this->_log("Theor. value type changed to: {$theor_attr}", 2);
         }
     }
     $theor_attr_eu = $theor_attr;
     if ($theor_attr == "NET_VOL") {
         $theor_attr_eu = "GRS_VOL";
     }
     $total_from = 0;
     $total_to = 0;
     $total_fixed = 0;
     $ids_from = "";
     $ids_to = "";
     $ids_fixed = "";
     $ids_minus = "-999";
     $obj_type_from = "";
     $obj_type_to = "";
     $OBJ_TYPE_FLOW = 1;
     $OBJ_TYPE_EU = 2;
     $OBJ_TYPE_TANK = 3;
     $OBJ_TYPE_STORAGE = 4;
     $rows = AllocRunnerObjects::where(['RUNNER_ID' => $runner_id])->get();
     foreach ($rows as $row) {
         if ($row->DIRECTION == 1) {
             if (!$obj_type_from) {
                 $obj_type_from = $row->OBJECT_TYPE;
             }
             if ($row->OBJECT_TYPE == $obj_type_from) {
                 $ids_from .= ($ids_from ? "," : "") . $row->OBJECT_ID;
             }
             if ($row->MINUS == 1) {
                 $ids_minus .= ($ids_minus ? "," : "") . $row->OBJECT_ID;
             }
         } else {
             if (!$obj_type_to) {
                 $obj_type_to = $row->OBJECT_TYPE;
             }
             if ($row->OBJECT_TYPE == $obj_type_to) {
                 if ($row->FIXED == 1) {
                     $ids_fixed .= ($ids_fixed ? "," : "") . $row->OBJECT_ID;
                 } else {
                     $ids_to .= ($ids_to ? "," : "") . $row->OBJECT_ID;
                 }
             }
         }
     }
     if ($ids_from) {
         $total_from = 0;
         $sum = [];
         $sSQL_alloc_from = [];
         $arrfrom = explode(',', $ids_from);
         if ($obj_type_from == $OBJ_TYPE_FLOW) {
             // //\DB::enableQueryLog ();
             $sum = DB::table('FLOW_DATA_ALLOC AS a')->leftjoin('FLOW_DATA_VALUE AS v', function ($join) {
                 $join->on('v.FLOW_ID', '=', 'a.FLOW_ID');
                 $join->on('v.OCCUR_DATE', '=', 'a.OCCUR_DATE');
             })->leftjoin('FLOW_DATA_THEOR AS t', function ($join) {
                 $join->on('v.FLOW_ID', '=', 'a.FLOW_ID');
                 $join->on('v.OCCUR_DATE', '=', 'a.OCCUR_DATE');
             })->join('FLOW AS b', 'a.FLOW_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.FLOW_ID', $arrfrom)->SELECT(DB::raw('sum((case when a.FLOW_ID in (' . $ids_minus . ') then -1 else 1 end))*IF(IFNULL(a.FL_DATA_' . $alloc_attr . ',0)>0,a.FL_DATA_' . $alloc_attr . ',IF(IFNULL(v.FL_DATA_' . $alloc_attr . ',0)>0,v.FL_DATA_' . $alloc_attr . ',t.FL_DATA_' . $alloc_attr . ')) AS total_from'))->get();
             // //\Log::info ( \DB::getQueryLog () );
             //\DB::enableQueryLog ();
             $sSQL_alloc_from = DB::table('FLOW_DATA_ALLOC AS a')->leftjoin('FLOW_DATA_VALUE AS v', function ($join) {
                 $join->on('v.FLOW_ID', '=', 'a.FLOW_ID');
                 $join->on('v.OCCUR_DATE', '=', 'a.OCCUR_DATE');
             })->leftjoin('FLOW_DATA_THEOR AS t', function ($join) {
                 $join->on('v.FLOW_ID', '=', 'a.FLOW_ID');
                 $join->on('v.OCCUR_DATE', '=', 'a.OCCUR_DATE');
             })->join('FLOW AS b', 'a.FLOW_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.FLOW_ID', $arrfrom)->SELECT(DB::raw('IF(IFNULL(a.FL_DATA_' . $alloc_attr . ',0)>0,a.FL_DATA_' . $alloc_attr . ',IF(IFNULL(v.FL_DATA_' . $alloc_attr . ',0)>0,v.FL_DATA_' . $alloc_attr . ',t.FL_DATA_' . $alloc_attr . ')) AS ALLOC_VALUE', 'a.FLOW_ID AS OBJECT_ID', 'b.NAME AS OBJECT_NAME', 'a.ACTIVE_HRS', 'b.NAME AS ALLOC_VALUE', 'a.OCCUR_DATE', 'a.OCCUR_DATE AS OCCUR_DATE_STR'))->get();
             //\Log::info ( \DB::getQueryLog () );
         } else {
             if ($obj_type_from == $OBJ_TYPE_EU) {
                 // //\DB::enableQueryLog ();
                 $sum = DB::table('ENERGY_UNIT_DATA_ALLOC AS a')->leftjoin('ENERGY_UNIT_DATA_VALUE AS v', function ($join) {
                     $join->on('v.EU_ID', '=', 'a.EU_ID');
                     $join->on('v.OCCUR_DATE', '=', 'a.OCCUR_DATE');
                     $join->on('v.FLOW_PHASE', '=', 'a.FLOW_PHASE');
                     $join->on('v.EVENT_TYPE', '=', 'a.EVENT_TYPE');
                 })->leftjoin('ENERGY_UNIT_DATA_THEOR AS t', function ($join) {
                     $join->on('t.EU_ID', '=', 'a.EU_ID');
                     $join->on('t.OCCUR_DATE', '=', 'a.OCCUR_DATE');
                     $join->on('t.FLOW_PHASE', '=', 'a.FLOW_PHASE');
                     $join->on('t.EVENT_TYPE', '=', 'a.EVENT_TYPE');
                 })->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.EU_ID', $arrfrom)->where(['a.FLOW_PHASE' => $alloc_phase])->where(['a.EVENT_TYPE' => $event_type])->SELECT(DB::raw('sum((case when a.EU_ID in (' . $ids_minus . ') then -1 else 1 end))*IF(IFNULL(a.EU_DATA_' . $alloc_attr_eu . ',0)>0,a.EU_DATA_' . $alloc_attr_eu . ',IF(IFNULL(v.EU_DATA_' . $alloc_attr_eu . ',0)>0,v.EU_DATA_' . $alloc_attr_eu . ',t.EU_DATA_' . $alloc_attr_eu . ')) AS total_from'))->get();
                 // //\Log::info ( \DB::getQueryLog () );
                 //\DB::enableQueryLog ();
                 $sSQL_alloc_from = DB::table('ENERGY_UNIT_DATA_ALLOC AS a')->leftjoin('ENERGY_UNIT_DATA_VALUE AS v', function ($join) {
                     $join->on('v.EU_ID', '=', 'a.EU_ID');
                     $join->on('v.OCCUR_DATE', '=', 'a.OCCUR_DATE');
                     $join->on('v.FLOW_PHASE', '=', 'a.FLOW_PHASE');
                     $join->on('v.EVENT_TYPE', '=', 'a.EVENT_TYPE');
                 })->leftjoin('ENERGY_UNIT_DATA_THEOR AS t', function ($join) {
                     $join->on('t.EU_ID', '=', 'a.EU_ID');
                     $join->on('t.OCCUR_DATE', '=', 'a.OCCUR_DATE');
                     $join->on('t.FLOW_PHASE', '=', 'a.FLOW_PHASE');
                     $join->on('t.EVENT_TYPE', '=', 'a.EVENT_TYPE');
                 })->join('ENERGY_UNIT AS b', 'a.EU_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.EU_ID', $arrfrom)->where(['a.FLOW_PHASE' => $alloc_phase])->where(['a.EVENT_TYPE' => $event_type])->SELECT(DB::raw('IF(IFNULL(a.EU_DATA_' . $alloc_attr_eu . ',0)>0,a.EU_DATA_' . $alloc_attr_eu . ',IF(IFNULL(v.EU_DATA_' . $alloc_attr_eu . ',0)>0,v.EU_DATA_' . $alloc_attr_eu . ',t.EU_DATA_' . $alloc_attr_eu . ')) AS ALLOC_VALUE', 'a.EU_ID AS OBJECT_ID', 'b.NAME AS OBJECT_NAME', 'a.ACTIVE_HRS', 'a.OCCUR_DATE', 'a.OCCUR_DATE AS OCCUR_DATE_STR', 'a.FLOW_PHASE'))->get();
                 //\Log::info ( \DB::getQueryLog () );
             } else {
                 if ($obj_type_from == $OBJ_TYPE_TANK) {
                     // //\DB::enableQueryLog ();
                     $sum = DB::table('TANK_DATA_ALLOC AS a')->leftjoin('TANK_DATA_VALUE AS v', function ($join) {
                         $join->on('v.TANK_ID', '=', 'a.TANK_ID');
                         $join->on('v.OCCUR_DATE', '=', 'a.OCCUR_DATE');
                     })->join('TANK AS b', 'a.TANK_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.TANK_ID', $arrfrom)->select(DB::raw('sum((case when a.TANK_ID in (' . $ids_minus . ') then -1 else 1 end)*IF(IFNULL(a.TANK_' . $alloc_attr . ',0)>0,a.TANK_' . $alloc_attr . ',v.TANK_' . $alloc_attr . ')) AS total_from'))->get();
                     // //\Log::info ( \DB::getQueryLog () );
                     // //\DB::enableQueryLog ();
                     $sSQL_alloc_from = DB::table('TANK_DATA_ALLOC AS a')->leftjoin('TANK_DATA_VALUE AS v', function ($join) {
                         $join->on('v.TANK_ID', '=', 'a.TANK_ID');
                         $join->on('v.OCCUR_DATE', '=', 'a.OCCUR_DATE');
                     })->join('TANK AS b', 'a.TANK_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.TANK_ID', $arrfrom)->select(DB::raw('IF(IFNULL(a.TANK_' . $alloc_attr . ',0)>0,a.TANK_' . $alloc_attr . ',v.TANK_' . $alloc_attr . ') AS total_from', 'a.TANK_ID AS OBJECT_ID', 'b.NAME AS OBJECT_NAME', 'a.ACTIVE_HRS', 'a.OCCUR_DATE', 'a.OCCUR_DATE AS OCCUR_DATE_STR'))->get();
                     // //\Log::info ( \DB::getQueryLog () );
                 } else {
                     if ($obj_type_from == $OBJ_TYPE_STORAGE) {
                         // //\DB::enableQueryLog ();
                         $sum = DB::table('STORAGE_DATA_ALLOC AS a')->leftjoin('STORAGE_DATA_VALUE AS v', function ($join) {
                             $join->on('v.STORAGE_ID', '=', 'a.STORAGE_ID');
                             $join->on('v.OCCUR_DATE', '=', 'a.OCCUR_DATE');
                         })->join('STORAGE AS b', 'a.STORAGE_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.STORAGE_ID', $arrfrom)->select(DB::raw('sum((case when a.STORAGE_ID in (' . $ids_minus . ') then -1 else 1 end)*IF(IFNULL(a.STORAGE_' . $alloc_attr . ',0)>0,a.STORAGE_' . $alloc_attr . ',a.STORAGE_' . $alloc_attr . ')) AS total_from'))->get();
                         // //\Log::info ( \DB::getQueryLog () );
                         //\DB::enableQueryLog ();
                         $sSQL_alloc_from = DB::table('STORAGE_DATA_ALLOC AS a')->leftjoin('STORAGE_DATA_VALUE AS v', function ($join) {
                             $join->on('v.STORAGE_ID', '=', 'a.STORAGE_ID');
                             $join->on('v.OCCUR_DATE', '=', 'a.OCCUR_DATE');
                         })->join('STORAGE AS b', 'a.STORAGE_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.STORAGE_ID', $arrfrom)->select(DB::raw('IF(IFNULL(a.STORAGE_' . $alloc_attr . ',0)>0,a.STORAGE_' . $alloc_attr . ',a.STORAGE_' . $alloc_attr . ') AS total_from', 'a.STORAGE_ID AS OBJECT_ID', 'b.NAME as OBJECT_NAME', 'a.ACTIVE_HRS', 'a.OCCUR_DATE', 'a.OCCUR_DATE AS OCCUR_DATE_STR'))->get();
                         //\Log::info ( \DB::getQueryLog () );
                     }
                 }
             }
         }
         $total_from = $sum[0]->total_from;
         // _log("command: $sSQL");
         // _log("sSQL_alloc_from: $sSQL_alloc_from");
         $this->_log("total_from (allocated ~ std value ~ theor): {$total_from}", 2);
         if ($total_from <= 0) {
             // does not have value at "ALLOCATION", use data from STD VALUE
             $subSum = [];
             $sum = [];
             switch ($obj_type_from) {
                 case $OBJ_TYPE_FLOW:
                     $sum = DB::table('FLOW_DATA_VALUE AS a')->join('FLOW AS b', 'a.FLOW_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.FLOW_ID', $arrfrom)->select(DB::raw('sum(FL_DATA_' . $alloc_attr . ') AS total_from'))->get();
                     break;
                 case $OBJ_TYPE_EU:
                     $sum = DB::table('ENERGY_UNIT_DATA_VALUE AS a')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.EU_ID', $arrfrom)->where(['a.FLOW_PHASE' => $alloc_phase])->select(DB::raw('sum(FL_DATA_' . $alloc_attr . ') AS total_from'))->get();
                     break;
                 case $OBJ_TYPE_TANK:
                     $sum = DB::table('TANK_DATA_VALUE AS a')->join('TANK AS b', 'a.TANK_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.TANK_ID', $arrfrom)->select(DB::raw('sum(TANK_' . $alloc_attr . ') AS total_from'))->get();
                     break;
                 case $OBJ_TYPE_STORAGE:
                     $sum = DB::table('STORAGE_DATA_VALUE AS a')->join('STORAGE AS b', 'a.STORAGE_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.STORAGE_ID', $arrfrom)->select(DB::raw('sum(STORAGE_' . $alloc_attr . ') AS total_from'))->get();
                     break;
             }
             $total_from = $sum[0]->total_from;
             $this->_log("total_from (std value): {$total_from}", 2);
         }
     } else {
         $ret = $this->_log("From objects not found", 1);
         if ($ret === false) {
             return false;
         }
     }
     if ($ids_to) {
         $arrto = explode(',', $ids_to);
         $sum = [];
         $sSQL_alloc = [];
         if ($obj_type_to == $OBJ_TYPE_FLOW) {
             $sum = DB::table('FLOW_DATA_THEOR AS a')->join('FLOW AS b', 'a.FLOW_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.FLOW_ID', $arrto)->where(['b.PHASE_ID' => $theor_phase])->select(DB::raw('sum(FL_DATA_' . $theor_attr . ') AS total_to'))->get();
             $sSQL_alloc = DB::table('FLOW_DATA_THEOR AS a')->join('FLOW AS b', 'a.FLOW_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.FLOW_ID', $arrto)->where(['b.PHASE_ID' => $theor_phase])->get(['a.FLOW_ID AS OBJECT_ID', 'b.NAME AS OBJECT_NAME', 'a.ACTIVE_HRS', 'a.OCCUR_DATE', 'a.OCCUR_DATE AS OCCUR_DATE_STR', 'a.FL_DATA_' . $theor_attr . ' AS ALLOC_THEOR']);
             $sSQL_alloc_to = DB::table('FLOW_DATA_ALLOC AS a')->join('FLOW AS b', 'a.FLOW_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.FLOW_ID', $arrto)->where(['b.PHASE_ID' => $theor_phase])->get(['a.FLOW_ID AS OBJECT_ID', 'b.NAME AS OBJECT_NAME', 'a.ACTIVE_HRS', 'a.OCCUR_DATE', 'a.OCCUR_DATE AS OCCUR_DATE_STR', 'a.FL_DATA_' . $theor_attr . ' AS ALLOC_VALUE']);
         } else {
             if ($obj_type_to == $OBJ_TYPE_EU) {
                 $sum = DB::table('ENERGY_UNIT_DATA_THEOR AS a')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.EU_ID', $arrto)->where(['a.FLOW_PHASE' => $theor_phase, 'a.FLOW_PHASE' => $theor_phase, 'a.EVENT_TYPE' => $event_type])->select(DB::raw('sum(EU_DATA_' . $theor_attr_eu . ') AS total_to'))->get();
                 $sSQL_alloc = DB::table('ENERGY_UNIT_DATA_THEOR AS a')->join('ENERGY_UNIT AS b', 'a.EU_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.EU_ID', $arrto)->where(['a.FLOW_PHASE' => $theor_phase, 'a.EVENT_TYPE' => $event_type])->get(['a.EU_ID AS OBJECT_ID', 'b.NAME AS OBJECT_NAME', 'a.ACTIVE_HRS', 'a.OCCUR_DATE', 'a.OCCUR_DATE AS OCCUR_DATE_STR', 'a.FLOW_PHASE', 'EU_DATA_' . $theor_attr_eu . ' AS ALLOC_THEOR']);
                 $sSQL_alloc_to = DB::table('ENERGY_UNIT_DATA_ALLOC AS a')->join('ENERGY_UNIT AS b', 'a.EU_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.EU_ID', $arrto)->where(['a.FLOW_PHASE' => $theor_phase, 'a.EVENT_TYPE' => $event_type])->get(['a.EU_ID AS OBJECT_ID', 'b.NAME AS OBJECT_NAME', 'a.ACTIVE_HRS', 'a.OCCUR_DATE', 'a.OCCUR_DATE AS OCCUR_DATE_STR', 'a.FLOW_PHASE', 'EU_DATA_' . $theor_attr_eu . ' AS ALLOC_VALUE']);
             } else {
                 if ($obj_type_to == $OBJ_TYPE_TANK) {
                     $sum = DB::table('TANK_DATA_VALUE AS a')->join('TANK AS b', 'a.TANK_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.TANK_ID', $arrto)->select(DB::raw('sum(TANK_' . $theor_attr . ') AS total_to'))->get();
                     $sSQL_alloc = DB::table('TANK_DATA_VALUE AS a')->join('TANK AS b', 'a.TANK_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.TANK_ID', $arrto)->get(['a.TANK_ID AS OBJECT_ID', 'b.NAME AS OBJECT_NAME', 'a.ACTIVE_HRS', 'a.OCCUR_DATE', 'a.OCCUR_DATE AS OCCUR_DATE_STR', 'a.TANK_DATA_' . $theor_attr . ' AS ALLOC_THEOR']);
                     $sSQL_alloc_to = DB::table('TANK_DATA_VALUE AS a')->join('TANK AS b', 'a.TANK_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.TANK_ID', $arrto)->get(['a.TANK_ID AS OBJECT_ID', 'b.NAME AS OBJECT_NAME', 'a.ACTIVE_HRS', 'a.OCCUR_DATE', 'a.OCCUR_DATE AS OCCUR_DATE_STR', 'a.TANK_' . $theor_attr . ' AS ALLOC_VALUE']);
                 } else {
                     if ($obj_type_to == $OBJ_TYPE_STORAGE) {
                         $sum = DB::table('STORAGE_DATA_VALUE AS a')->join('STORAGE AS b', 'a.STORAGE_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.STORAGE_ID', $arrto)->select(DB::raw('sum(STORAGE_' . $theor_attr . ') AS total_to'))->get();
                         $sSQL_alloc = DB::table('STORAGE_DATA_VALUE AS a')->join('STORAGE AS b', 'a.STORAGE_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.STORAGE_ID', $arrto)->get(['a.STORAGE_ID AS OBJECT_ID', 'b.NAME AS OBJECT_NAME', 'a.ACTIVE_HRS', 'a.OCCUR_DATE', 'a.OCCUR_DATE AS OCCUR_DATE_STR', 'a.STORAGE_' . $theor_attr . ' AS ALLOC_THEOR']);
                         $sSQL_alloc_to = DB::table('STORAGE_DATA_ALLOC AS a')->join('STORAGE AS b', 'a.STORAGE_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.STORAGE_ID', $arrto)->get(['a.STORAGE_ID AS OBJECT_ID', 'b.NAME AS OBJECT_NAME', 'a.ACTIVE_HRS', 'a.OCCUR_DATE', 'a.OCCUR_DATE AS OCCUR_DATE_STR', 'a.STORAGE_' . $theor_attr . ' AS ALLOC_VALUE']);
                     }
                 }
             }
         }
         $total_to = $sum[0]->total_to;
         // _log("command: $sSQL");
         $this->_log("total_to (theor): {$total_to}", 2);
         $this->_log("Allocation factor: " . $total_from . "/" . $total_to, 2);
     } else {
         $ret = $this->_log("TO object not found", 1);
         if ($ret === false) {
             return false;
         }
     }
     if ($ids_fixed) {
         $rows = [];
         $arrfixed = explode(',', $ids_fixed);
         if ($obj_type_to == $OBJ_TYPE_FLOW) {
             //\DB::enableQueryLog ();
             $rows = DB::table('FLOW_DATA_VALUE AS a')->leftjoin('FLOW_DATA_THEOR AS t', function ($join) {
                 $join->on('t.FLOW_ID', '=', 'a.FLOW_ID');
                 $join->on('t.OCCUR_DATE', '=', 'a.OCCUR_DATE');
             })->join('FLOW AS b', 'a.FLOW_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->where(['b.PHASE_ID' => $alloc_phase])->whereIn('a.FLOW_ID', $arrfixed)->SELECT(DB::raw('IF(IFNULL(a.FL_DATA_' . $alloc_attr . ',0)>0,a.FL_DATA_' . $alloc_attr . ',t.FL_DATA_' . $alloc_attr . ') AS FIXED_VALUE', 'a.FLOW_ID AS OBJECT_ID', 'a.ACTIVE_HRS', 'a.OCCUR_DATE', 'a.OCCUR_DATE AS OCCUR_DATE_STR'))->get();
             //\Log::info ( \DB::getQueryLog () );
         } else {
             if ($obj_type_to == $OBJ_TYPE_EU) {
                 //\DB::enableQueryLog ();
                 $rows = DB::table('ENERGY_UNIT_DATA_VALUE AS a')->leftjoin('ENERGY_UNIT_DATA_THEOR AS t', function ($join) {
                     $join->on('t.EU_ID', '=', 'a.EU_ID');
                     $join->on('t.OCCUR_DATE', '=', 'a.OCCUR_DATE');
                     $join->on('t.FLOW_PHASE', '=', 'a.FLOW_PHASE');
                     $join->on('t.EVENT_TYPE', '=', 'a.EVENT_TYPE');
                 })->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.EU_ID', $arrfixed)->where(['a.FLOW_PHASE' => $alloc_phase, 'a.EVENT_TYPE' => $event_type])->SELECT(DB::raw('IF(IFNULL(a.EU_DATA_' . $alloc_attr . ',0)>0,a.EU_DATA_' . $alloc_attr . ',t.EU_DATA_' . $alloc_attr . ') AS FIXED_VALUE', 'a.EU_ID AS OBJECT_ID', 'a.ACTIVE_HRS', 'a.OCCUR_DATE', 'a.OCCUR_DATE AS OCCUR_DATE_STR'))->get();
                 //\Log::info ( \DB::getQueryLog () );
             } else {
                 if ($obj_type_to == $OBJ_TYPE_TANK) {
                     //\DB::enableQueryLog ();
                     $rows = DB::table('TANK_DATA_VALUE AS a')->join('TANK AS b', 'a.TANK_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.TANK_ID', $arrfixed)->SELECT('a.TANK_ID AS OBJECT_ID', 'a.ACTIVE_HRS', 'a.OCCUR_DATE', 'a.OCCUR_DATE AS OCCUR_DATE_STR', 'TANK_' . $alloc_attr . ' AS FIXED_VALUE')->get();
                     //\Log::info ( \DB::getQueryLog () );
                 } else {
                     if ($obj_type_to == $OBJ_TYPE_STORAGE) {
                         //\DB::enableQueryLog ();
                         $rows = DB::table('STORAGE_DATA_VALUE AS a')->join('STORAGE AS b', 'a.STORAGE_ID', '=', 'b.ID')->whereDate('a.OCCUR_DATE', '>=', $from_date)->whereDate('a.OCCUR_DATE', '<=', $to_date)->whereIn('a.STORAGE_ID', $arrfixed)->SELECT('a.STORAGE_ID AS OBJECT_ID', 'a.ACTIVE_HRS', 'a.OCCUR_DATE', 'a.OCCUR_DATE AS OCCUR_DATE_STR', 'STORAGE_' . $alloc_attr . ' AS FIXED_VALUE')->get();
                         //\Log::info ( \DB::getQueryLog () );
                     }
                 }
             }
         }
         $this->_log("Create allocation data from fixed objects (id: {$ids_fixed}):", 2);
         $total_fixed = 0;
         foreach ($rows as $row) {
             $v_to = $row->FIXED_VALUE;
             $total_fixed += $v_to;
             if ($obj_type_to == $OBJ_TYPE_FLOW) {
                 $ro = FlowDataAlloc::where(['FLOW_ID' => $row->OBJECT_ID])->whereDate('OCCUR_DATE', '=', $row->OCCUR_DATE)->select('ID')->first();
                 if (count($ro) > 0) {
                     if ($_REQUEST["act"] == "run") {
                         FlowDataAlloc::where(['ID' => $ro->ID])->update(['FL_DATA_' . $alloc_attr => $v_to]);
                     }
                     $sSQL = "update FLOW_DATA_ALLOC set FL_DATA_" . $alloc_attr . "='" . $v_to . "' where ID=" . $ro->ID;
                 } else {
                     if ($_REQUEST["act"] == "run") {
                         FlowDataAlloc::insert(['FLOW_ID' => $row->ID, 'OCCUR_DATE' => $row->OCCUR_DATE, 'FL_DATA_' . $alloc_attr => $v_to]);
                     }
                     $sSQL = "insert into FLOW_DATA_ALLOC(`FLOW_ID`,`OCCUR_DATE`,FL_DATA_" . $alloc_attr . ") values('" . $row->OBJECT_ID . "','" . $row->OCCUR_DATE . "'," . $v_to . ")";
                 }
                 $this->_log($sSQL, 2);
             } else {
                 if ($obj_type_to == $OBJ_TYPE_EU) {
                     $ro = EnergyUnitDataAlloc::where(['EU_ID' => $row->ID, 'FLOW_PHASE' => $alloc_phase, 'EVENT_TYPE' => $event_type, 'ALLOC_TYPE' => $alloc_type])->whereDate('OCCUR_DATE', '=', $row->OCCUR_DATE)->select('ID')->first();
                     if (count($ro) > 0) {
                         if ($_REQUEST["act"] == "run") {
                             EnergyUnitDataAlloc::where(['ID' => $ro->ID])->update(['EU_DATA_' . $alloc_attr_eu => $v_to]);
                         }
                         $sSQL = "update ENERGY_UNIT_DATA_ALLOC set EU_DATA_" . $alloc_attr_eu . "='" . $v_to . "' where ID=" . $ro->ID;
                     } else {
                         if ($_REQUEST["act"] == "run") {
                             $EnergyUnitDataAlloc = EnergyUnitDataAlloc::insert(['EU_ID' => $row->OBJECT_ID, 'OCCUR_DATE' => $row->OCCUR_DATE, 'FLOW_PHASE' => $alloc_phase, 'EVENT_TYPE' => $event_type, 'ALLOC_TYPE' => $alloc_type, 'EU_DATA_' . $alloc_attr_eu => $v_to]);
                         }
                         $sSQL = "insert into ENERGY_UNIT_DATA_ALLOC(`EU_ID`,`OCCUR_DATE`,FLOW_PHASE,EVENT_TYPE,ALLOC_TYPE,EU_DATA_" . $alloc_attr_eu . ") values('" . $row->OBJECT_ID . "','" . $row->OCCUR_DATE . "'," . $alloc_phase . "," . $event_type . "," . $alloc_type . "," . $v_to . ")";
                     }
                     $this->_log($sSQL, 2);
                 } else {
                     if ($obj_type_to == $OBJ_TYPE_TANK) {
                         $ro = TankDataAlloc::where(['TANK_ID' => $row->OBJECT_ID])->whereDate('OCCUR_DATE', '=', $row->OCCUR_DATE)->select('ID')->first();
                         if (count($ro) > 0) {
                             if ($_REQUEST["act"] == "run") {
                                 TankDataAlloc::where(['ID' => $ro->ID])->update(['TANK_' . $alloc_attr => $v_to]);
                             }
                             $sSQL = "update TANK_DATA_ALLOC set TANK_DATA_" . $alloc_attr . "='" . $v_to . "' where ID=" . $ro->ID;
                         } else {
                             if ($_REQUEST["act"] == "run") {
                                 TankDataAlloc::insert(['TANK_ID' => $row->OBJECT_ID, 'OCCUR_DATE' => $row->OCCUR_DATE, 'TANK_' . $alloc_attr => $v_to]);
                             }
                             $sSQL = "insert into TANK_DATA_ALLOC(`TANK_ID`,`OCCUR_DATE`,TANK_" . $alloc_attr . ") values('" . $row->OBJECT_ID . "','" . $row->OCCUR_DATE . "'," . $v_to . ")";
                         }
                         $this->_log($sSQL, 2);
                     } else {
                         if ($obj_type_to == $OBJ_TYPE_STORAGE) {
                             $ro = StorageDataAlloc::where(['STORAGE_ID' => $row->OBJECT_ID])->whereDate('OCCUR_DATE', '=', $row->OCCUR_DATE)->select('ID')->first();
                             if (count($ro) > 0) {
                                 if ($_REQUEST["act"] == "run") {
                                     StorageDataAlloc::where(['ID' => $ro->ID])->update(['STORAGE_' . $alloc_attr => $v_to]);
                                 }
                                 $sSQL = "update STORAGE_DATA_ALLOC set STORAGE_" . $alloc_attr . "='" . $v_to . "' where ID=" . $ro->ID;
                             } else {
                                 if ($_REQUEST["act"] == "run") {
                                     StorageDataAlloc::insert(['STORAGE_ID' => $row->OBJECT_ID, 'OCCUR_DATE' => $row->OCCUR_DATE, 'STORAGE_' . $alloc_attr => $v_to]);
                                 }
                                 $sSQL = "insert into STORAGE_DATA_ALLOC(`STORAGE_ID`,`OCCUR_DATE`,STORAGE_" . $alloc_attr . ") values('" . $row->OBJECT_ID . "','" . $row->OCCUR_DATE . "'," . $v_to . ")";
                             }
                             $this->_log($sSQL, 2);
                         }
                     }
                 }
             }
             $this->_log("total_fixed (std value ~ theor): {$total_fixed}", 2);
             $total_from -= $total_fixed;
             $this->_log("total_from (minus total_fixed): {$total_from}", 2);
         }
         // Alloc
         if ($total_to == 0) {
             $ret = $this->_log("total_to is zero, can not calculate", 1);
             if ($ret === false) {
                 return false;
             }
         }
         foreach ($sSQL_alloc as $row) {
             if ($row->ALLOC_THEOR === '' || $row->ALLOC_THEOR == null) {
                 $row->ALLOC_THEOR = 0;
             }
             $v_to = $total_from * $row->ALLOC_THEOR / $total_to;
             if ($obj_type_to == $OBJ_TYPE_FLOW) {
                 $ro = FlowDataAlloc::where(['FLOW_ID' => $row->OBJECT_ID])->whereDate('OCCUR_DATE', '=', $row->OCCUR_DATE)->select('ID')->first();
                 if (count($ro) > 0) {
                     if ($_REQUEST["act"] == "run") {
                         FlowDataAlloc::where(['ID' => $ro->ID])->update(['FL_DATA_' . $alloc_attr => $v_to]);
                     }
                     $sSQL = "update FLOW_DATA_ALLOC set FL_DATA_" . $alloc_attr . "='" . $v_to . "' where ID=" . $ro->ID;
                 } else {
                     if ($_REQUEST["act"] == "run") {
                         FlowDataAlloc::insert(['FLOW_ID' => $row->OBJECT_ID, 'OCCUR_DATE' => $row->OCCUR_DATE, 'FL_DATA_' . $alloc_attr => $v_to]);
                     }
                     $sSQL = "insert into FLOW_DATA_ALLOC(`FLOW_ID`,`OCCUR_DATE`,FL_DATA_" . $alloc_attr . ") values('" . $row->OBJECT_ID . "','" . $row->OCCUR_DATE . "'," . $v_to . ")";
                 }
                 $this->_log($sSQL, 2);
                 // ////// Flow COST_INT_CTR allocation
                 if ($_REQUEST["act"] == "run") {
                     FlowCoEntDataAlloc::where(['FLOW_ID' => $row->OBJECT_ID])->delete();
                     $sSQL = "delete from FLOW_CO_ENT_DATA_ALLOC where FLOW_ID=" . $row->OBJECT_ID;
                     $this->_log($sSQL, 2);
                 }
                 $re_co = DB::table('FLOW AS a')->join('COST_INT_CTR_DETAIL AS b', 'a.COST_INT_CTR_ID', '=', 'b.COST_INT_CTR_ID')->where(['a.ID' => $row->OBJECT_ID, 'b.FLOW_PHASE' => $alloc_phase])->get(['a.COST_INT_CTR_ID', 'b.BA_ID', 'b.INTEREST_PCT AS ALLOC_PERCENT']);
                 foreach ($re_co as $ro_co) {
                     $v_co = $v_to * $ro_co->ALLOC_PERCENT / 100;
                     if ($_REQUEST["act"] == "run") {
                         FlowCoEntDataAlloc::insert(['FLOW_ID' => $row->OBJECT_ID, 'OCCUR_DATE' => $row->OCCUR_DATE, 'COST_INT_CTR_ID' => $ro_co->COST_INT_CTR_ID, 'BA_ID' => $ro_co->BA_ID, 'FL_DATA_' . $alloc_attr => $v_co]);
                     }
                     $sSQL = "insert into FLOW_CO_ENT_DATA_ALLOC(`FLOW_ID`,`OCCUR_DATE`,COST_INT_CTR_ID,BA_ID,FL_DATA_" . $alloc_attr . ") values('" . $row->OBJECT_ID . "','" . $row->OCCUR_DATE . "','" . $ro_co->COST_INT_CTR_ID . "','" . $ro_co->BA_ID . "'," . $v_co . ")";
                     $this->_log($sSQL, 2);
                 }
                 // /////// END of Flow COST_INT_CTR allocation
             } else {
                 if ($obj_type_to == $OBJ_TYPE_EU) {
                     $ro = EnergyUnitDataAlloc::where(['FLOW_PHASE' => $alloc_phase, 'EVENT_TYPE' => $event_type, 'ALLOC_TYPE' => $alloc_type])->whereDate('OCCUR_DATE', '=', $row->OCCUR_DATE)->select('ID')->first();
                     if (count($ro) > 0) {
                         if ($_REQUEST["act"] == "run") {
                             EnergyUnitDataAlloc::where(['ID' => $ro->ID])->update(['EU_DATA_' . $alloc_attr_eu => $v_to]);
                         }
                         $sSQL = "update ENERGY_UNIT_DATA_ALLOC set EU_DATA_" . $alloc_attr_eu . "='" . $v_to . "' where ID=" . $ro->ID;
                     } else {
                         if ($_REQUEST["act"] == "run") {
                             EnergyUnitDataAlloc::insert(['EU_ID' => $row->OBJECT_ID, 'OCCUR_DATE' => $row->OCCUR_DATE, 'FLOW_PHASE' => $alloc_phase, 'EVENT_TYPE' => $event_type, 'ALLOC_TYPE' => $alloc_type, 'EU_DATA_' . $alloc_attr_eu => $v_to]);
                         }
                         $sSQL = "insert into ENERGY_UNIT_DATA_ALLOC(`EU_ID`,`OCCUR_DATE`,FLOW_PHASE,EVENT_TYPE,ALLOC_TYPE,EU_DATA_" . $alloc_attr_eu . ") values('" . $row->OBJECT_ID . "','" . $row->OCCUR_DATE . "'," . $alloc_phase . "," . $event_type . ",'" . $alloc_type . "'," . $v_to . ")";
                     }
                     $this->_log($sSQL, 2);
                     if ($_REQUEST["act"] == "run") {
                         EnergyUnitCoEntDataAlloc::where(['EU_ID' => $row->OBJECT_ID])->delete();
                         $sSQL = "delete from ENERGY_UNIT_CO_ENT_DATA_ALLOC where EU_ID=" . $row->OBJECT_ID;
                         $this->_log($sSQL, 2);
                     }
                     // ////// Well COST_INT_CTR allocation
                     $re_co = DB::table('ENERGY_UNIT AS a')->join('COST_INT_CTR_DETAIL AS b', 'a.COST_INT_CTR_ID', '=', 'b.COST_INT_CTR_ID')->where(['a.ID' => $row->OBJECT_ID, 'b.FLOW_PHASE' => $alloc_phase])->get(['a.COST_INT_CTR_ID', 'b.BA_ID', 'b.INTEREST_PCT AS ALLOC_PERCENT']);
                     foreach ($re_co as $ro_co) {
                         $v_co = $v_to * $ro_co->ALLOC_PERCENT / 100;
                         if ($_REQUEST["act"] == "run") {
                             EnergyUnitCoEntDataAlloc::insert(['EU_ID' => $row->OBJECT_ID, 'OCCUR_DATE' => $row->OCCUR_DATE, 'FLOW_PHASE' => $alloc_phase, 'EVENT_TYPE' => $event_type, 'ALLOC_TYPE' => $alloc_type, 'COST_INT_CTR_ID' => $ro_co->COST_INT_CTR_ID, 'BA_ID' => $ro_co->BA_ID, 'EU_DATA_' . $alloc_attr_eu => $v_to]);
                         }
                         $sSQL = "insert into ENERGY_UNIT_CO_ENT_DATA_ALLOC(`EU_ID`,`OCCUR_DATE`,FLOW_PHASE,EVENT_TYPE,ALLOC_TYPE,COST_INT_CTR_ID,BA_ID,EU_DATA_" . $alloc_attr_eu . ") values('" . $row->OBJECT_ID . "','" . $row->OCCUR_DATE . "'," . $alloc_phase . "," . $event_type . ",'" . $alloc_type . "','" . $ro_co->COST_INT_CTR_ID . "','" . $ro_co->BA_ID . "'," . $v_co . ")";
                         $this->_log($sSQL, 2);
                     }
                     // /////// END of Well COST_INT_CTR allocation
                     // completion, interval
                     if ($alloc_attr == "GRS_VOL" || $alloc_attr == "GRS_MASS") {
                         $this->allocWellCompletion($row->OBJECT_ID, $row->OCCUR_DATE, $alloc_phase, $event_type, $alloc_attr, $v_to);
                     }
                 } else {
                     if ($obj_type_to == $OBJ_TYPE_TANK) {
                         $ro = TankDataAlloc::where(['TANK_ID' => $row->OBJECT_ID])->whereDate('OCCUR_DATE', '=', $row->OCCUR_DATE)->select('ID')->first();
                         if (count($ro) > 0) {
                             if ($_REQUEST["act"] == "run") {
                                 TankDataAlloc::where(['ID' => $ro->ID])->update(['TANK_' . $alloc_attr => $v_to]);
                             }
                             $sSQL = "update TANK_DATA_ALLOC set TANK_" . $alloc_attr . "='" . $v_to . "' where ID=" . $ro->ID;
                         } else {
                             if ($_REQUEST["act"] == "run") {
                                 TankDataAlloc::insert(['TANK_ID' => $row->OBJECT_ID, 'OCCUR_DATE' => $row->OCCUR_DATE, 'TANK_' . $alloc_attr => $v_to]);
                             }
                             $sSQL = "insert into TANK_DATA_ALLOC(`TANK_ID`,`OCCUR_DATE`,TANK_" . $alloc_attr . ") values('" . $row->OBJECT_ID . "','" . $row->OCCUR_DATE . "'," . $v_to . ")";
                         }
                         $this->_log($sSQL, 2);
                     } else {
                         if ($obj_type_to == $OBJ_TYPE_STORAGE) {
                             $ro = StorageDataAlloc::where(['STORAGE_ID' => $row->OBJECT_ID])->whereDate('OCCUR_DATE', '=', $row->OCCUR_DATE)->select('ID')->first();
                             if (count($ro) > 0) {
                                 if ($_REQUEST["act"] == "run") {
                                     StorageDataAlloc::where(['ID' => $ro->ID])->update(['STORAGE_' . $alloc_attr => $v_to]);
                                 }
                                 $sSQL = "update STORAGE_DATA_ALLOC set STORAGE_" . $alloc_attr . "='" . $v_to . "' where ID=" . $ro->ID;
                             } else {
                                 if ($_REQUEST["act"] == "run") {
                                     StorageDataAlloc::insert(['STORAGE_ID' => $row->OBJECT_ID, 'OCCUR_DATE' => $row->OCCUR_DATE, 'STORAGE_' . $alloc_attr => $v_to]);
                                 }
                                 $sSQL = "insert into STORAGE_DATA_ALLOC(`STORAGE_ID`,`OCCUR_DATE`,STORAGE_" . $alloc_attr . ") values('" . $row->OBJECT_ID . "','" . $row->OCCUR_DATE . "'," . $v_to . ")";
                             }
                             $this->_log($sSQL, 2);
                         }
                     }
                 }
             }
         }
         // Composition
         if ($alloc_comp) {
             $this->_log("Begin composition allocation", 2);
             $comp_sqls = array();
             $obj_type_code = $obj_type_from == 1 ? "FLOW" : "WELL";
             $comp_total_from = array("C1" => 0, "C2" => 0, "C3" => 0, "C4I" => 0, "C4N" => 0, "C5I" => 0, "C5N" => 0, "C6" => 0, "C7" => 0, "H2S" => 0, "CO2" => 0, "N2" => 0);
             $comp_total_to = array("C1" => 0, "C2" => 0, "C3" => 0, "C4I" => 0, "C4N" => 0, "C5I" => 0, "C5N" => 0, "C6" => 0, "C7" => 0, "H2S" => 0, "CO2" => 0, "N2" => 0);
             $comp_total_rate = array("C1" => 0, "C2" => 0, "C3" => 0, "C4I" => 0, "C4N" => 0, "C5I" => 0, "C5N" => 0, "C6" => 0, "C7" => 0, "H2S" => 0, "CO2" => 0, "N2" => 0);
             // step 1: calculate composition for all "from" object
             foreach ($sSQL_alloc_from as $row) {
                 $this->_log("Calculate composition _FROM, object_name: " . $row->OBJECT_NAME . ",date" . $row->OCCUR_DATE_STR . ",2");
                 $object_id = $row->OBJECT_ID;
                 $occur_date = $row->OCCUR_DATE_STR;
                 $quality_from = $this->getQualityGas($object_id, $obj_type_code, $occur_date, $F);
                 if ($quality_from) {
                     foreach ($comp_total_from as $x => $x_value) {
                         $comp_total_from[$x] += $row->ALLOC_VALUE * $quality_from[$x];
                     }
                     if ($obj_type_from == $OBJ_TYPE_FLOW) {
                         if ($success && $_REQUEST["act"] == "run") {
                             FlowCompDataAlloc::where(['FLOW_ID' => $object_id])->whereDate('OCCUR_DATE', '=', $row->OCCUR_DATE)->delete();
                             $sSQL = "delete from FLOW_COMP_DATA_ALLOC where FLOW_ID={$object_id} and OCCUR_DATE='{$row['OCCUR_DATE']}'";
                             $this->_log($sSQL, 2);
                             $param = [];
                             array_push($param, ['FLOW_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'COMPOSITION' => $quality_from->ID_C1, 'FL_DATA_' . $alloc_attr => $row->ALLOC_VALUE * $quality_from->C1]);
                             array_push($param, ['FLOW_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'COMPOSITION' => $quality_from->ID_C2, 'FL_DATA_' . $alloc_attr => $row->ALLOC_VALUE * $quality_from->C2]);
                             array_push($param, ['FLOW_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'COMPOSITION' => $quality_from->ID_C3, 'FL_DATA_' . $alloc_attr => $row->ALLOC_VALUE * $quality_from->C3]);
                             array_push($param, ['FLOW_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'COMPOSITION' => $quality_from->ID_C4I, 'FL_DATA_' . $alloc_attr => $row->ALLOC_VALUE * $quality_from->C4I]);
                             array_push($param, ['FLOW_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'COMPOSITION' => $quality_from->ID_C4N, 'FL_DATA_' . $alloc_attr => $row->ALLOC_VALUE * $quality_from->C4N]);
                             array_push($param, ['FLOW_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'COMPOSITION' => $quality_from->ID_C5I, 'FL_DATA_' . $alloc_attr => $row->ALLOC_VALUE * $quality_from->C5I]);
                             array_push($param, ['FLOW_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'COMPOSITION' => $quality_from->ID_C5N, 'FL_DATA_' . $alloc_attr => $row->ALLOC_VALUE * $quality_from->C5N]);
                             array_push($param, ['FLOW_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'COMPOSITION' => $quality_from->ID_C6, 'FL_DATA_' . $alloc_attr => $row->ALLOC_VALUE * $quality_from->C6]);
                             array_push($param, ['FLOW_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'COMPOSITION' => $quality_from->ID_C7, 'FL_DATA_' . $alloc_attr => $row->ALLOC_VALUE * $quality_from->C7]);
                             array_push($param, ['FLOW_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'COMPOSITION' => $quality_from->ID_H2S, 'FL_DATA_' . $alloc_attr => $row->ALLOC_VALUE * $quality_from->H2S]);
                             array_push($param, ['FLOW_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'COMPOSITION' => $quality_from->ID_CO2, 'FL_DATA_' . $alloc_attr => $row->ALLOC_VALUE * $quality_from->CO2]);
                             array_push($param, ['FLOW_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'COMPOSITION' => $quality_from->ID_N2, 'FL_DATA_' . $alloc_attr => $row->ALLOC_VALUE * $quality_from->N2]);
                             $sSQL = "insert into FLOW_COMP_DATA_ALLOC(FLOW_ID,OCCUR_DATE,COMPOSITION,FL_DATA_{$alloc_attr}) VALUES ";
                             foreach ($param as $pa) {
                                 FlowCompDataAlloc::insert($pa);
                                 $sSQL .= $pa['FLOW_ID'] . "," . $pa['OCCUR_DATE'] . "," . $pa['COMPOSITION'] . "," . $pa['FL_DATA_' . $alloc_attr] . "\n";
                             }
                             $sSQL .= ")";
                             $this->_log($sSQL, 2);
                         }
                     } else {
                         if ($success && $_REQUEST["act"] == "run") {
                             EnergyUnitCompDataAlloc::where(['EU_ID' => $object_id, 'FLOW_PHASE' => 2])->whereDate('OCCUR_DATE', '=', $row->OCCUR_DATE)->delete();
                             $sSQL = "delete from FLOW_COMP_DATA_ALLOC where FLOW_ID={$object_id} and OCCUR_DATE='{$row['OCCUR_DATE']}'";
                             $this->_log($sSQL, 2);
                             $param = [];
                             array_push($param, ['EU_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'FLOW_PHASE' => 2, 'ALLOC_TYPE' => $alloc_type, 'COMPOSITION' => $quality_from->ID_C1, 'EU_DATA_' . $alloc_attr_eu => $row->ALLOC_VALUE * $quality_from->C1]);
                             array_push($param, ['EU_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'FLOW_PHASE' => 2, 'ALLOC_TYPE' => $alloc_type, 'COMPOSITION' => $quality_from->ID_C2, 'EU_DATA_' . $alloc_attr_eu => $row->ALLOC_VALUE * $quality_from->C2]);
                             array_push($param, ['EU_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'FLOW_PHASE' => 2, 'ALLOC_TYPE' => $alloc_type, 'COMPOSITION' => $quality_from->ID_C3, 'EU_DATA_' . $alloc_attr_eu => $row->ALLOC_VALUE * $quality_from->C3]);
                             array_push($param, ['EU_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'FLOW_PHASE' => 2, 'ALLOC_TYPE' => $alloc_type, 'COMPOSITION' => $quality_from->ID_C4I, 'EU_DATA_' . $alloc_attr_eu => $row->ALLOC_VALUE * $quality_from->C4I]);
                             array_push($param, ['EU_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'FLOW_PHASE' => 2, 'ALLOC_TYPE' => $alloc_type, 'COMPOSITION' => $quality_from->ID_C4N, 'EU_DATA_' . $alloc_attr_eu => $row->ALLOC_VALUE * $quality_from->C4N]);
                             array_push($param, ['EU_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'FLOW_PHASE' => 2, 'ALLOC_TYPE' => $alloc_type, 'COMPOSITION' => $quality_from->ID_C5I, 'EU_DATA_' . $alloc_attr_eu => $row->ALLOC_VALUE * $quality_from->C5I]);
                             array_push($param, ['EU_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'FLOW_PHASE' => 2, 'ALLOC_TYPE' => $alloc_type, 'COMPOSITION' => $quality_from->ID_C5N, 'EU_DATA_' . $alloc_attr_eu => $row->ALLOC_VALUE * $quality_from->C5N]);
                             array_push($param, ['EU_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'FLOW_PHASE' => 2, 'ALLOC_TYPE' => $alloc_type, 'COMPOSITION' => $quality_from->ID_C6, 'EU_DATA_' . $alloc_attr_eu => $row->ALLOC_VALUE * $quality_from->C6]);
                             array_push($param, ['EU_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'FLOW_PHASE' => 2, 'ALLOC_TYPE' => $alloc_type, 'COMPOSITION' => $quality_from->ID_C7, 'EU_DATA_' . $alloc_attr_eu => $row->ALLOC_VALUE * $quality_from->C7]);
                             array_push($param, ['EU_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'FLOW_PHASE' => 2, 'ALLOC_TYPE' => $alloc_type, 'COMPOSITION' => $quality_from->ID_H2S, 'EU_DATA_' . $alloc_attr_eu => $row->ALLOC_VALUE * $quality_from->H2S]);
                             array_push($param, ['EU_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'FLOW_PHASE' => 2, 'ALLOC_TYPE' => $alloc_type, 'COMPOSITION' => $quality_from->ID_CO2, 'EU_DATA_' . $alloc_attr_eu => $row->ALLOC_VALUE * $quality_from->CO2]);
                             array_push($param, ['EU_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'FLOW_PHASE' => 2, 'ALLOC_TYPE' => $alloc_type, 'COMPOSITION' => $quality_from->ID_N2, 'EU_DATA_' . $alloc_attr_eu => $row->ALLOC_VALUE * $quality_from->N2]);
                             $sSQL = "insert into ENERGY_UNIT_COMP_DATA_ALLOC(EU_ID,OCCUR_DATE,FLOW_PHASE,ALLOC_TYPE,COMPOSITION,EU_DATA_{$alloc_attr_eu}) VALUES ";
                             foreach ($param as $pa) {
                                 EnergyUnitCompDataAlloc::insert($pa);
                                 $sSQL .= $pa['EU_ID'] . "," . $pa['OCCUR_DATE'] . "," . $pa['FLOW_PHASE'] . "," . $pa['ALLOC_TYPE'] . "," . $pa['COMPOSITION'] . "," . $pa['EU_DATA_' . $alloc_attr_eu] . "\n";
                             }
                             $sSQL .= ")";
                             $this->_log($sSQL, 2);
                         }
                     }
                 } else {
                     $ret = $this->_log("Quality data not found (_FROM object_id: {$object_id}, object_name: {$row->OBJECT_NAME}, date {$row->OCCUR_DATE_STR})", 1);
                     if ($ret === false) {
                         return false;
                     }
                 }
             }
             // step2:
             $this->_log("Calculate composition allocation rates", 2);
             $obj_type_code = $obj_type_to == 1 ? "FLOW" : "WELL";
             foreach ($sSQL_alloc_to as $row) {
                 $object_id = $row->OBJECT_ID;
                 $occur_date = $row->OCCUR_DATE_STR;
                 $quality_to = getQualityGas($object_id, $obj_type_code, $occur_date, $F);
                 if ($quality_to) {
                     foreach ($comp_total_to as $x => $x_value) {
                         $comp_total_to[$x] += $row->ALLOC_VALUE * $quality_to[$x];
                     }
                 } else {
                     $ret = $this->_log("Quality data not found (_TO object_id: {$object_id}, object_name: {$row->OBJECT_NAME}, date {$row->OCCUR_DATE_STR})", 1);
                     if ($ret === false) {
                         return false;
                     }
                 }
             }
             if ($success) {
                 foreach ($comp_total_to as $x => $x_value) {
                     if ($comp_total_to[$x] == 0) {
                         $comp_total_rate[$x] = -1;
                     } else {
                         $comp_total_rate[$x] = $comp_total_from[$x] / $comp_total_to[$x];
                     }
                     $this->_log("[{$x}] comp_total_from = {$comp_total_from[$x]}, comp_total_to = {$comp_total_to[$x]}, rate = {$comp_total_rate[$x]}", 2);
                 }
                 $result = AllocRunnerObjects::where(['RUNNER_ID' => $runner_id])->get();
                 foreach ($result as $row) {
                     $this->_log("Calculate composition allocation _TO, object_name: {$row->OBJECT_NAME}, date {$row->OCCUR_DATE_STR}", 2);
                     $object_id = $row->OBJECT_ID;
                     $occur_date = $row->OCCUR_DATE_STR;
                     $quality_from = $this->getQualityGas($object_id, $obj_type_code, $occur_date, $F);
                     if ($quality_from && $_REQUEST["act"] == "run") {
                         if ($obj_type_to == $OBJ_TYPE_FLOW) {
                             FlowCompDataAlloc::where(['FLOW_ID' => $object_id])->whereDate('OCCUR_DATE', '=', $row->OCCUR_DATE)->delete();
                             $sSQL = "delete from FLOW_COMP_DATA_ALLOC where FLOW_ID={$object_id} and OCCUR_DATE='{$row['OCCUR_DATE']}'";
                             $this->_log($sSQL, 2);
                             $sSQL = "insert into FLOW_COMP_DATA_ALLOC(FLOW_ID,OCCUR_DATE,COMPOSITION,FL_DATA_{$alloc_attr}) VALUES (";
                             foreach ($comp_total_rate as $x => $x_value) {
                                 if ($x_value > 0 && $row->ALLOC_VALUE > 0 && $quality_from[$x] > 0) {
                                     $_v = $x_value * $row->ALLOC_VALUE * $quality_from[$x];
                                 } else {
                                     $_v = 0;
                                 }
                                 FlowCompDataAlloc::insert(['FLOW_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'COMPOSITION' => $quality_from["ID_{$x}"], 'FL_DATA_' . $alloc_attr => $_v]);
                                 $sSQL .= $object_id . "," . $row->OCCUR_DATE . "," . $quality_from["ID_{$x}"] . "," . $_v . "\n";
                             }
                             $sSQL .= ")";
                             $this->_log($sSQL, 2);
                         } else {
                             EnergyUnitCompDataAlloc::where(['EU_ID' => $object_id, 'FLOW_PHASE' => 2])->whereDate('OCCUR_DATE', '=', $row->OCCUR_DATE)->delete();
                             $sSQL = "delete from FLOW_COMP_DATA_ALLOC where FLOW_ID={$object_id} and OCCUR_DATE='{$row['OCCUR_DATE']}'";
                             $this->_log($sSQL, 2);
                             $sSQL = "insert into ENERGY_UNIT_COMP_DATA_ALLOC(EU_ID,OCCUR_DATE,FLOW_PHASE,ALLOC_TYPE,COMPOSITION,EU_DATA_{$alloc_attr_eu}) VALUES (";
                             foreach ($comp_total_rate as $x => $x_value) {
                                 if ($x_value > 0 && $row->ALLOC_VALUE > 0 && $quality_from[$x] > 0) {
                                     $_v = $x_value * $row->ALLOC_VALUE * $quality_from[$x];
                                 } else {
                                     $_v = 0;
                                 }
                                 EnergyUnitCompDataAlloc::insert(['EU_ID' => $object_id, 'OCCUR_DATE' => $row->OCCUR_DATE, 'FLOW_PHASE' => $alloc_phase, 'ALLOC_TYPE' => $alloc_type, 'COMPOSITION' => $quality_from["ID_{$x}"], 'EU_DATA_' . $alloc_attr_eu => $_v]);
                                 $sSQL .= $object_id . "," . $row->OCCUR_DATE . "," . $alloc_phase . "," . "," . $alloc_type . "," . $quality_from["ID_{$x}"] . "," . $_v . "\n";
                             }
                             $sSQL .= ")";
                             $this->_log($sSQL, 2);
                         }
                     } else {
                         $ret = $this->_log("Quality data not found (_TO object_id: {$object_id}, object_name: {$row['OBJECT_NAME']}, date {$row['OCCUR_DATE_STR']})", 1);
                         if ($ret === false) {
                             return false;
                         }
                     }
                 }
                 if ($success) {
                     $this->_log("Execute SQL composition allocation commands", 2);
                     /*
                      * foreach($comp_sqls as $sSQL)
                      * {
                      * if($_REQUEST["act"]=="run") mysql_query($sSQL) or die("fail: ".$sSQL."-> error:".mysql_error());
                      * _log($sSQL);
                      * }
                      */
                 }
             }
         }
         $this->_log("End runner ID: {$runner_id} -------------------------------------------------------", 2);
         return $success;
     }
 }