public function getDataSet($postData, $dcTable, $facility_id, $occur_date, $properties)
{
$date_end = array_key_exists('date_end', $postData) ? $postData['date_end'] : null;
if ($date_end) {
$date_end = \Helper::parseDate($date_end);
}
$storageId = $postData['Storage'];
$pd_voyage = PdVoyage::getTableName();
$pd_cargo = PdCargo::getTableName();
$pd_voyage_detail = PdVoyageDetail::getTableName();
$column = array();
$ObjColumn = $properties['properties'];
foreach ($ObjColumn as $p) {
array_push($column, "{$pd_voyage}.{$p->data}");
}
array_push($column, "{$pd_voyage_detail}.ID AS DT_RowId");
array_push($column, "{$pd_voyage}.ID AS VOYAGE_ID");
array_push($column, "{$pd_voyage_detail}.PARCEL_NO as MASTER_NAME");
$dataSet = PdVoyage::join($pd_cargo, "{$pd_voyage}.CARGO_ID", '=', "{$pd_cargo}.ID")->join($pd_voyage_detail, "{$pd_voyage_detail}.VOYAGE_ID", '=', "{$pd_voyage}.ID")->where(["{$pd_cargo}.STORAGE_ID" => $storageId])->whereDate('SCHEDULE_DATE', '>=', $occur_date)->whereDate('SCHEDULE_DATE', '<=', $date_end)->orderBy("DT_RowId")->get($column);
return ['dataSet' => $dataSet];
}
public function getExtraDatasetBy($objectType, $facility_id)
{
$srcTypeData = null;
if ($objectType == "PARCEL") {
$storage = Storage::getTableName();
$pdVoyageDetail = PdVoyageDetail::getTableName();
$pdVoyage = PdVoyage::getTableName();
$srcTypeData = PdVoyage::join($storage, function ($query) use($storage, $facility_id, $pdVoyage) {
$query->on("{$pdVoyage}.STORAGE_ID", '=', "{$storage}.ID")->where("{$storage}.FACILITY_ID", '=', $facility_id);
})->join($pdVoyageDetail, "{$pdVoyage}.ID", '=', "{$pdVoyageDetail}.VOYAGE_ID")->select("{$pdVoyageDetail}.ID", "{$pdVoyageDetail}.ID as CODE", "{$pdVoyage}.NAME as NAME", "{$pdVoyage}.ID as value", "{$pdVoyage}.NAME as text", "{$pdVoyageDetail}.PARCEL_NO as PARCEL_NO")->orderBy("{$pdVoyage}.ID")->orderBy("{$pdVoyageDetail}.PARCEL_NO")->get();
} else {
if ($objectType == "RESERVOIR") {
$srcTypeData = \DB::table($objectType)->get(['ID', 'CODE', 'NAME', 'ID as value', 'NAME as text']);
} else {
if ($objectType) {
$srcTypeData = \DB::table($objectType)->where("FACILITY_ID", $facility_id)->get(['ID', 'CODE', 'NAME', 'ID as value', 'NAME as text']);
}
}
}
return $srcTypeData;
}
