public function _index()
{
$fo_group = $this->getFoGroup();
$code_flow_phase = CodeFlowPhase::all(['ID', 'NAME']);
$code_alloc_type = CodeAllocType::all(['ID', 'NAME']);
$loProductionUnit = LoProductionUnit::all(['ID', 'NAME']);
return view('front.formula', ['fo_group' => $fo_group, 'code_flow_phase' => $code_flow_phase, 'code_alloc_type' => $code_alloc_type, 'loProductionUnit' => $loProductionUnit]);
}
public function _indexDiagram()
{
$codeFlowPhase = CodeFlowPhase::all(['ID', 'NAME']);
$loProductionUnit = LoProductionUnit::all(['ID', 'NAME']);
$loArea = LoArea::where(['PRODUCTION_UNIT_ID' => $loProductionUnit[0]->ID])->get(['ID', 'NAME']);
$facility = Facility::where(['AREA_ID' => $loArea[0]->ID])->get(['ID', 'NAME']);
$intObjectType = IntObjectType::where(['DISPLAY_TYPE' => 1])->get(['CODE', 'NAME']);
$tmp = ucwords($intObjectType[0]->NAME);
$mode = 'App\\Models\\' . str_replace(' ', '', $tmp);
$type = $mode::where(['FACILITY_ID' => $facility[0]->ID])->get(['ID', 'NAME']);
return view('front.diagram', ['codeFlowPhase' => $codeFlowPhase, 'loProductionUnit' => $loProductionUnit, 'loArea' => $loArea, 'facility' => $facility, 'intObjectType' => $intObjectType, 'type' => $type]);
}
public function initProductionFilterGroup($workspace, $extras = null)
{
if ($workspace) {
$pid = $workspace->PRODUCTION_UNIT_ID;
$aid = $workspace->AREA_ID;
$fid = $workspace->W_FACILITY_ID;
} else {
$pid = 0;
$aid = 0;
$fid = 0;
}
$productionUnits = LoProductionUnit::all(['ID', 'NAME']);
$currentProductUnit = ProductionGroupComposer::getCurrentSelect($productionUnits, $pid);
$areas = $currentProductUnit->LoArea()->getResults();
$currentArea = ProductionGroupComposer::getCurrentSelect($areas, $aid);
$facilities = $currentArea->Facility()->getResults();
$currentFacility = ProductionGroupComposer::getCurrentSelect($facilities, $fid);
$productionFilterGroup = ['LoProductionUnit' => ProductionGroupComposer::getFilterArray('LoProductionUnit', $productionUnits, $currentProductUnit), 'LoArea' => ProductionGroupComposer::getFilterArray('LoArea', $areas, $currentArea), 'Facility' => ProductionGroupComposer::getFilterArray('Facility', $facilities, $currentFacility)];
$currentObject = $currentFacility;
foreach ($extras as $source => $model) {
$option = $this->getExtraOptions($productionFilterGroup, $model, $source);
if ($option && array_key_exists($source, $option) && array_key_exists("object", $option[$source])) {
$currentObject = $option[$source]["object"];
}
$rs = ProductionGroupComposer::initExtraDependence($productionFilterGroup, $model, $currentObject, $option);
$eCollection = $rs['collection'];
$modelName = $rs['model'];
$extraFilter = ProductionGroupComposer::getCurrentSelect($eCollection);
$productionFilterGroup[$modelName] = ProductionGroupComposer::getFilterArray($modelName, $eCollection, $extraFilter, $model);
}
return $productionFilterGroup;
}
public function addUser()
{
$userRole = UserRole::where(['ACTIVE' => 1])->get(['ID', 'NAME']);
$loProductionUnit = LoProductionUnit::all(['ID', 'NAME']);
return view('admin.add_users', ['userRole' => $userRole, 'loProductionUnit' => $loProductionUnit]);
}
private function getWorkSpaceInfo()
{
$user_name = '';
if (auth()->user() != null) {
$user_name = auth()->user()->username;
}
$user_workspace = UserWorkspace::getTableName();
$facility = Facility::getTableName();
$lo_area = LoArea::getTableName();
$lo_production_unit = LoProductionUnit::getTableName();
$workspace = DB::table($user_workspace . ' AS a')->join($facility . ' AS b', 'a.W_FACILITY_ID', '=', 'b.ID')->join($lo_area . ' AS c', 'b.AREA_ID', '=', 'c.ID')->join($lo_production_unit . ' AS d', 'c.PRODUCTION_UNIT_ID', '=', 'd.ID')->where(['a.USER_NAME' => $user_name])->select('a.*', DB::raw('DATE_FORMAT(a.W_DATE_BEGIN, "%m/%d/%Y") as DATE_BEGIN'), DB::raw('DATE_FORMAT(a.W_DATE_END, "%m/%d/%Y") as DATE_END'), 'b.AREA_ID', 'c.PRODUCTION_UNIT_ID')->first();
return $workspace;
}
