public function getUoms($properties = null, $facility_id, $dcTable = null, $locked = false)
{
$uoms = [];
$model = null;
$withs = [];
$i = 0;
$selectData = false;
$rs = [];
foreach ($properties as $property) {
$columnName = is_array($property) && array_key_exists('data', $property) ? $property['data'] : $property->data;
switch ($columnName) {
case 'PRESS_UOM':
$withs[] = 'CodePressUom';
$uoms[] = ['id' => 'CodePressUom', 'targets' => $i, 'COLUMN_NAME' => 'PRESS_UOM'];
break;
case 'TEMP_UOM':
$withs[] = 'CodeTempUom';
$uoms[] = ['id' => 'CodeTempUom', 'targets' => $i, 'COLUMN_NAME' => 'TEMP_UOM'];
break;
case 'FL_POWR_UOM':
case 'EU_POWR_UOM':
$withs[] = 'CodePowerUom';
$uoms[] = ['id' => 'CodePowerUom', 'targets' => $i, 'COLUMN_NAME' => 'FL_POWR_UOM'];
break;
case 'FL_ENGY_UOM':
case 'EU_ENGY_UOM':
$withs[] = 'CodeEnergyUom';
$uoms[] = ['id' => 'CodeEnergyUom', 'targets' => $i, 'COLUMN_NAME' => 'FL_ENGY_UOM'];
break;
case 'FL_MASS_UOM':
case 'EU_MASS_UOM':
$withs[] = 'CodeMassUom';
$uoms[] = ['id' => 'CodeMassUom', 'targets' => $i, 'COLUMN_NAME' => 'FL_MASS_UOM'];
break;
case 'VOL_UOM':
case 'FL_VOL_UOM':
case 'EU_VOL_UOM':
$withs[] = 'CodeVolUom';
$uoms[] = ['id' => 'CodeVolUom', 'targets' => $i, 'COLUMN_NAME' => 'FL_VOL_UOM'];
break;
case 'EU_STATUS':
$selectData = ['id' => 'EuStatus', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = collect([(object) ['ID' => -1, 'NAME' => '(Auto)'], (object) ['ID' => 1, 'NAME' => 'Online'], (object) ['ID' => 0, 'NAME' => 'Offline']]);
$rs[] = $selectData;
break;
case 'ALLOC_TYPE':
$selectData = ['id' => 'CodeAllocType', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodeAllocType::all();
$rs[] = $selectData;
break;
case 'TEST_METHOD':
$selectData = ['id' => 'CodeTestingMethod', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodeTestingMethod::all();
$rs[] = $selectData;
break;
case 'TEST_USAGE':
$selectData = ['id' => 'CodeTestingUsage', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodeTestingUsage::all();
$rs[] = $selectData;
break;
case 'EVENT_TYPE':
$selectData = ['id' => 'CodeEventType', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodeEventType::all();
$rs[] = $selectData;
break;
case 'SRC_TYPE':
$selectData = ['id' => 'CodeQltySrcType', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodeQltySrcType::all();
$rs[] = $selectData;
break;
case 'PRODUCT_TYPE':
$selectData = ['id' => 'CodeProductType', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodeProductType::all();
$rs[] = $selectData;
break;
case 'DEFER_REASON':
$selectData = ['id' => 'CodeDeferReason', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodeDeferReason::all();
$rs[] = $selectData;
break;
case 'DEFER_STATUS':
$selectData = ['id' => 'CodeDeferStatus', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodeDeferStatus::all();
$rs[] = $selectData;
break;
case 'CODE1':
$selectData = ['id' => 'CodeDeferCode1', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodeDeferCode1::all();
$rs[] = $selectData;
break;
case 'DEFER_CATEGORY':
$selectData = ['id' => 'CodeDeferCategory', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodeDeferCategory::all();
$rs[] = $selectData;
break;
case 'DEFER_GROUP_TYPE':
$selectData = ['id' => 'CodeDeferGroupType', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodeDeferGroupType::all();
$rs[] = $selectData;
break;
case 'TICKET_TYPE':
$selectData = ['id' => 'CodeTicketType', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodeTicketType::all();
$rs[] = $selectData;
break;
case 'TARGET_TANK':
$selectData = ['id' => 'Tank', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = Tank::where('FACILITY_ID', $facility_id)->get();
$rs[] = $selectData;
break;
case 'CARRIER_ID':
case 'PD_TRANSIT_CARRIER_ID':
case 'CONNECTING_CARRIER':
if ($dcTable == \App\Models\PdCargoNomination::getTableName() && !$locked) {
break;
}
$selectData = ['id' => 'PdTransitCarrier', 'targets' => $i, 'COLUMN_NAME' => $columnName];
if ($dcTable == \App\Models\RunTicketFdcValue::getTableName() || $dcTable == \App\Models\RunTicketValue::getTableName()) {
$selectData['data'] = PdTransitCarrier::where('TRANSIT_TYPE', 1)->get();
} else {
$selectData['data'] = PdTransitCarrier::all();
}
$rs[] = $selectData;
break;
case 'BA_ID':
if ($dcTable != Personnel::getTableName()) {
$selectData = ['id' => 'BaAddress', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = BaAddress::all();
$rs[] = $selectData;
}
break;
case 'SEVERITY_ID':
$selectData = ['id' => 'CodeSafetySeverity', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodeSafetySeverity::where('ACTIVE', 1)->orderBy('ORDER')->orderBy('ID')->get();
$rs[] = $selectData;
break;
case 'STATUS':
$selectData = ['id' => 'CodeCommentStatus', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodeCommentStatus::where('ACTIVE', 1)->orderBy('ORDER')->orderBy('ID')->get();
$rs[] = $selectData;
break;
case 'OFFLINE_REASON_CODE':
$selectData = ['id' => 'CodeEqpOfflineReason', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodeEqpOfflineReason::where('ACTIVE', 1)->orderBy('ORDER')->orderBy('ID')->get();
$rs[] = $selectData;
break;
case 'EQP_FUEL_CONS_TYPE':
$selectData = ['id' => 'CodeEqpFuelConsType', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodeEqpFuelConsType::where('ACTIVE', 1)->orderBy('ORDER')->orderBy('ID')->get();
$rs[] = $selectData;
break;
case 'EQP_GHG_REL_TYPE':
$selectData = ['id' => 'CodeEqpGhgRelType', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodeEqpGhgRelType::where('ACTIVE', 1)->orderBy('ORDER')->orderBy('ID')->get();
$rs[] = $selectData;
break;
case 'EQP_GHG_UOM':
case 'EQP_CONS_UOM':
$selectData = ['id' => 'CodeVolUom', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodeVolUom::all();
$rs[] = $selectData;
break;
case 'TYPE':
$selectData = ['id' => 'CodePersonnelType', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodePersonnelType::all();
$rs[] = $selectData;
break;
case 'TITLE':
$selectData = ['id' => 'CodePersonnelTitle', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodePersonnelTitle::all();
$rs[] = $selectData;
break;
case 'SYSTEM_ID':
$selectData = ['id' => 'IntSystem', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = IntSystem::all();
$rs[] = $selectData;
break;
case 'FREQUENCY':
$selectData = ['id' => 'CodeReadingFrequency', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodeReadingFrequency::all();
$rs[] = $selectData;
break;
case 'ALLOW_OVERRIDE':
$selectData = ['id' => 'CodeBoolean', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodeBoolean::all();
$rs[] = $selectData;
break;
case 'FLOW_PHASE':
$selectData = ['id' => 'CodeFlowPhase', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = CodeFlowPhase::all();
$rs[] = $selectData;
break;
case 'REQUEST_UOM':
case 'NOMINATION_UOM':
case 'REQUEST_QTY_UOM':
case 'SCHEDULE_UOM':
case 'ATTRIBUTE_UOM':
case 'LOAD_UOM':
case 'QTY_UOM':
case 'ITEM_UOM':
$selectData = ['id' => 'PdCodeMeasUom', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdCodeMeasUom::all();
$rs[] = $selectData;
break;
case 'PRIORITY':
$selectData = ['id' => 'PdCodeCargoPriority', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdCodeCargoPriority::all();
$rs[] = $selectData;
break;
case 'QUANTITY_TYPE':
$selectData = ['id' => 'PdCodeCargoQtyType', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdCodeCargoQtyType::all();
$rs[] = $selectData;
break;
case 'LIFTING_ACCT':
case 'LIFTING_ACCOUNT':
$selectData = ['id' => 'PdLiftingAccount', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdLiftingAccount::all();
$rs[] = $selectData;
break;
case 'CONTRACT_ID':
$selectData = ['id' => 'PdContract', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdContract::all();
$rs[] = $selectData;
break;
case 'STORAGE_ID':
$selectData = ['id' => 'Storage', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\Storage::where('FACILITY_ID', $facility_id)->get();
$rs[] = $selectData;
break;
case 'REQUEST_TOLERANCE':
$selectData = ['id' => 'PdCodeQtyAdj', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdCodeQtyAdj::all();
$rs[] = $selectData;
break;
case 'ADJUSTABLE_TIME':
case 'NOMINATION_ADJ_TIME':
$selectData = ['id' => 'PdCodeTimeAdj', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdCodeTimeAdj::all();
$rs[] = $selectData;
break;
case 'INCOTERM':
$selectData = ['id' => 'PdCodeIncoterm', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdCodeIncoterm::all();
$rs[] = $selectData;
break;
case 'TRANSIT_TYPE':
$selectData = ['id' => 'PdCodeTransitType', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdCodeTransitType::all();
$rs[] = $selectData;
break;
/* case 'ACTIVITY_NAME' :
$selectData = ['id'=>'ID','targets'=>$i,'COLUMN_NAME'=>'NAME'];
$sql = "";
$sql .= " SELECT ID, NAME FROM pd_code_load_activity a where exists (select 1 from PD_CARGO_LOAD b join TERMINAL_TIMESHEET_DATA c ON ( b.ID = c.PARENT_ID AND c.IS_LOAD = 1 ) where c.ACTIVITY_ID = a.ID)";
$sql .= " union all";
$sql .= " SELECT ID, NAME FROM pd_code_load_activity a where exists (select 1 from PD_CARGO_UNLOAD b join TERMINAL_TIMESHEET_DATA c ON ( b.ID = c.PARENT_ID AND c.IS_LOAD = 1 ) where c.ACTIVITY_ID = a.ID)";
$tmp = \DB::select($sql);
$selectData['data'] = $tmp;
$rs[] = $selectData;
break; */
/* case 'ACTIVITY_NAME' :
$selectData = ['id'=>'ID','targets'=>$i,'COLUMN_NAME'=>'NAME'];
$sql = "";
$sql .= " SELECT ID, NAME FROM pd_code_load_activity a where exists (select 1 from PD_CARGO_LOAD b join TERMINAL_TIMESHEET_DATA c ON ( b.ID = c.PARENT_ID AND c.IS_LOAD = 1 ) where c.ACTIVITY_ID = a.ID)";
$sql .= " union all";
$sql .= " SELECT ID, NAME FROM pd_code_load_activity a where exists (select 1 from PD_CARGO_UNLOAD b join TERMINAL_TIMESHEET_DATA c ON ( b.ID = c.PARENT_ID AND c.IS_LOAD = 1 ) where c.ACTIVITY_ID = a.ID)";
$tmp = \DB::select($sql);
$selectData['data'] = $tmp;
$rs[] = $selectData;
break; */
case 'CARGO_ID':
$selectData = ['id' => 'PdCargo', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdCargo::all();
$rs[] = $selectData;
break;
case 'BERTH_ID':
$selectData = ['id' => 'PdBerth', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdBerth::all();
$rs[] = $selectData;
break;
case 'CARGO_STATUS':
$selectData = ['id' => 'PdCodeCargoStatus', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdCodeCargoStatus::all();
$rs[] = $selectData;
break;
case 'CONTRACT_TYPE':
case 'CONTACT_TYPE':
$selectData = ['id' => 'PdCodeContractType', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdCodeContractType::all();
$rs[] = $selectData;
break;
case 'CONTRACT_PERIOD':
$selectData = ['id' => 'PdCodeContractPeriod', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdCodeContractPeriod::all();
$rs[] = $selectData;
break;
case 'CONTRACT_EXPENDITURE':
$selectData = ['id' => 'PdContractExpenditure', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdContractExpenditure::all();
$rs[] = $selectData;
break;
case 'CONTRACT_TEMPLATE':
$selectData = ['id' => 'PdContractTemplate', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdContractTemplate::all();
$rs[] = $selectData;
break;
case 'DEMURRAGE_EBO':
$selectData = ['id' => 'PdCodeDemurrageEbo', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdCodeDemurrageEbo::all();
$rs[] = $selectData;
break;
case 'SURVEYOR_BA_ID':
$selectData = ['id' => 'BaAddress', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\BaAddress::where('SOURCE', 15)->get();
$rs[] = $selectData;
break;
case 'WITNESS_BA_ID1':
case 'WITNESS_BA_ID2':
$selectData = ['id' => 'BaAddress', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\BaAddress::where('SOURCE', 4)->get();
$rs[] = $selectData;
break;
case 'ACTIVITY_ID':
case 'ACTIVITY_NAME':
$selectData = ['id' => 'PdCodeLoadActivity', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdCodeLoadActivity::all();
$rs[] = $selectData;
break;
case 'VOYAGE_ID':
$selectData = ['id' => 'PdVoyage', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdVoyage::all();
$rs[] = $selectData;
break;
case 'DEPART_PORT':
case 'NEXT_DESTINATION_PORT':
case 'PORT_ID':
case 'ULLAGE_PORT':
case 'ORIGIN_PORT':
case 'DESTINATION_PORT':
$selectData = ['id' => 'PdPort', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdPort::all();
$rs[] = $selectData;
break;
case 'FLOW_ID':
$selectData = ['id' => 'Flow', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\Flow::where("FACILITY_ID", '=', $facility_id)->get();
$rs[] = $selectData;
break;
case 'MEASURED_ITEM':
$selectData = ['id' => 'PdCodeMeasItem', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdCodeMeasItem::all();
$rs[] = $selectData;
break;
case 'FORMULA_ID':
$selectData = ['id' => 'Formula', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\Formula::where("GROUP_ID", '=', 7)->get();
$rs[] = $selectData;
break;
case 'PROGRAM_TYPE':
$selectData = ['id' => 'PdCodeProgramType', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdCodeProgramType::all();
$rs[] = $selectData;
break;
case 'RUN_FREQUENCY':
$selectData = ['id' => 'PdCodeRunFrequency', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdCodeRunFrequency::all();
$rs[] = $selectData;
break;
case 'ADJUST_CODE':
$selectData = ['id' => 'PdCodeLiftAcctAdj', 'targets' => $i, 'COLUMN_NAME' => $columnName];
$selectData['data'] = \App\Models\PdCodeLiftAcctAdj::all();
$rs[] = $selectData;
break;
}
$i++;
}
if (count($withs) > 0) {
$model = StandardUom::with($withs)->where('ID', $facility_id)->first();
if ($model == null) {
$model = Facility::with($withs)->where('ID', $facility_id)->first();
}
}
// \DB::enableQueryLog();
if ($model != null) {
foreach ($uoms as $key => $uom) {
$uom['data'] = $model->{$uom}['id'];
$uoms[$key] = $uom;
$rs[] = $uom;
}
}
return $rs;
// \Log::info(\DB::getQueryLog());
}
public function getDataSet($postData, $dcTable, $facility_id, $occur_date, $properties)
{
$mdlName = $postData[config("constants.tabTable")];
$mdl = "App\\Models\\{$mdlName}";
$date_end = $postData['date_end'];
$date_end = \Helper::parseDate($date_end);
$storage_id = $postData['Storage'];
$pdCargoLoad = PdCargoLoad::getTableName();
$terminalTimesheetData = TerminalTimesheetData::getTableName();
$pdCodeLoadActivity = PdCodeLoadActivity::getTableName();
$pdBerth = PdBerth::getTableName();
$pdCargo = PdCargo::getTableName();
$pdCodeDemurrageEbo = PdCodeDemurrageEbo::getTableName();
$pdCargoUnload = PdCargoUnload::getTableName();
$demurrage = Demurrage::getTableName();
$pdContractData = PdContractData::getTableName();
$result = array();
$aryMst = array();
$lquery = PdCargoLoad::whereHas("TerminalTimesheetData", function ($query) use($terminalTimesheetData) {
$query->where("{$terminalTimesheetData}.IS_LOAD", '=', 1);
})->join($pdCargo, function ($query) use($pdCargo, $pdCargoLoad, $storage_id) {
$query->on("{$pdCargo}.ID", '=', "{$pdCargoLoad}.CARGO_ID")->where("{$pdCargo}.STORAGE_ID", '=', $storage_id);
})->leftJoin($pdBerth, "{$pdCargoLoad}.BERTH_ID", '=', "{$pdBerth}.ID")->leftJoin($pdCodeDemurrageEbo, "{$pdCargoLoad}.DEMURRAGE_EBO", '=', "{$pdCodeDemurrageEbo}.ID")->select("{$pdCargoLoad}.CARGO_ID", "{$pdCargoLoad}.BERTH_ID", "{$pdCargoLoad}.ID as ID", "{$pdCargoLoad}.DATE_LOAD", "{$pdCargoLoad}.DEMURRAGE_EBO", "{$pdBerth}.NAME as BERTH_NAME", "{$pdCargo}.NAME as CARGO_NAME", "{$pdCargo}.CONTRACT_ID", "{$pdCodeDemurrageEbo}.NAME as DEMURRAGE_EBO_NAME")->with(["TerminalTimesheetData" => function ($query) use($terminalTimesheetData) {
$query->where("{$terminalTimesheetData}.IS_LOAD", '=', 1);
}])->with(["Demurrage" => function ($query) use($terminalTimesheetData, $demurrage) {
$query->where("{$demurrage}.ACTIVITY_ID", '=', "{$terminalTimesheetData}.ACTIVITY_ID");
}])->with(["PdContractData" => function ($query) use($pdContractData, $pdCargo) {
$query->where("{$pdContractData}.CONTRACT_ID", '=', "{$pdCargo}.CONTRACT_ID");
}]);
$ulquery = PdCargoUnload::whereHas("TerminalTimesheetData", function ($query) use($terminalTimesheetData) {
$query->whereNull("{$terminalTimesheetData}.IS_LOAD")->orWhere("{$terminalTimesheetData}.IS_LOAD", '=', 0);
})->join($pdCargo, function ($query) use($pdCargo, $pdCargoUnload, $storage_id) {
$query->on("{$pdCargo}.ID", '=', "{$pdCargoUnload}.CARGO_ID")->where("{$pdCargo}.STORAGE_ID", '=', $storage_id);
})->leftJoin($pdBerth, "{$pdCargoUnload}.BERTH_ID", '=', "{$pdBerth}.ID")->leftJoin($pdCodeDemurrageEbo, "{$pdCargoUnload}.DEMURRAGE_EBO", '=', "{$pdCodeDemurrageEbo}.ID")->select("{$pdCargoUnload}.CARGO_ID", "{$pdCargoUnload}.BERTH_ID", "{$pdCargoUnload}.ID as ID", "{$pdCargoUnload}.DATE_UNLOAD as DATE_LOAD", "{$pdCargoUnload}.DEMURRAGE_EBO", "{$pdBerth}.NAME as BERTH_NAME", "{$pdCargo}.NAME as CARGO_NAME", "{$pdCargo}.CONTRACT_ID", "{$pdCodeDemurrageEbo}.NAME as DEMURRAGE_EBO_NAME")->with(["TerminalTimesheetData" => function ($query) use($terminalTimesheetData) {
$query->whereNull("{$terminalTimesheetData}.IS_LOAD")->orWhere("{$terminalTimesheetData}.IS_LOAD", '=', 0);
}])->with(["Demurrage" => function ($query) use($terminalTimesheetData, $demurrage) {
$query->where("{$demurrage}.ACTIVITY_ID", '=', "{$terminalTimesheetData}.ACTIVITY_ID");
}])->with(["PdContractData" => function ($query) use($pdContractData, $pdCargo) {
$query->where("{$pdContractData}.CONTRACT_ID", '=', "{$pdCargo}.CONTRACT_ID");
}]);
// $query = $lquery->union($ulquery);//->orderBy("START_TIME","desc");
$ldataSet = $lquery->get();
$uldataSet = $ulquery->get();
$dataSet = $ldataSet->merge($uldataSet);
// $dataSet = $uldataSet;
$DT_RowId = 100;
foreach ($dataSet as $key => $t) {
$t->DT_RowId = $DT_RowId++;
$timesheetDatas = $t->TerminalTimesheetData;
$demurrages = $t->Demurrage;
$pdContractDatas = $t->PdContractData;
$rate = $pdContractDatas && $pdContractDatas->count() > 0 ? $pdContractDatas->first()->ATTRIBUTE_VALUE : 0;
foreach ($timesheetDatas as $index => $tsheet) {
$elapse_time = null;
if ($tsheet->END_TIME && $tsheet->START_TIME) {
$endTime = $tsheet->END_TIME;
$startTime = $tsheet->START_TIME;
$elapse_time = $endTime->diffInHours($startTime);
}
$elapse_time = !$elapse_time || $elapse_time < 0 ? null : $elapse_time;
$tsheet->ELAPSE_TIME = $elapse_time;
$demurrage = $demurrages->where("ACTIVITY_ID", $tsheet->ACTIVITY_ID)->first();
$tsheet->OVERRIDE_AMOUNT = $demurrage ? $demurrage->OVERRIDE_AMT : "";
$amount = $elapse_time ? $elapse_time * $rate : null;
$tsheet->AMOUNT = $amount && $amount != 0 ? $amount : "0.000";
$tsheet->RATE_HOUR = $rate == 0 ? null : $rate;
if ($index == 0) {
$t->TE_ID = $tsheet->ID;
$t->IS_LOAD = $tsheet->IS_LOAD;
$t->ACTIVITY_NAME = $tsheet->ACTIVITY_ID;
$t->START_TIME = $tsheet->getAttributes()["START_TIME"];
$t->END_TIME = $tsheet->getAttributes()["END_TIME"];
$t->ELAPSE_TIME = $tsheet->ELAPSE_TIME;
$t->OVERRIDE_AMOUNT = $tsheet->OVERRIDE_AMOUNT;
$t->RATE_HOUR = $tsheet->RATE_HOUR;
$t->AMOUNT = $tsheet->AMOUNT;
}
}
}
return ['dataSet' => $dataSet];
}
public function cargounload()
{
$filterGroups = array('productionFilterGroup' => ['Facility' => 'Storage'], 'dateFilterGroup' => array(['id' => 'date_begin', 'name' => 'From date'], ['id' => 'date_end', 'name' => 'To date']));
$contractAttributes = PdCodeLoadActivity::orderBy('ORDER')->get();
$activities = TerminalActivitySet::where('LOAD_UNLOAD', '=', 2)->select(['ID as SET_ID', 'NAME as SET_NAME'])->get();
return view('front.cargoaction.cargounload', ['filters' => $filterGroups, 'contractAttributes' => $contractAttributes, 'activities' => $activities]);
}