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; }