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]);
}
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;
}
public function editUser(Request $request, $id)
{
$userDataScope = UserDataScope::getTableName();
$loProductionUnit = LoProductionUnit::getTableName();
$loArea = LoArea::getTableName();
$facility = Facility::getTableName();
$user = User::getTableName();
$listColumn = ['a.ID', 'a.USERNAME', 'a.PASSWORD', 'b.PU_ID', 'b.AREA_ID', 'b.FACILITY_ID', 'LAST_NAME', 'MIDDLE_NAME', 'FIRST_NAME', 'EMAIL', 'a.EXPIRE_DATE', 'a.ACTIVE'];
\DB::enableQueryLog();
$user = DB::table($user . ' AS a')->leftJoin($userDataScope . ' AS b', 'a.id', '=', 'b.user_id')->leftJoin($loProductionUnit . ' AS pu', 'pu.id', '=', 'b.PU_ID')->leftJoin($loArea . ' AS ar', 'ar.id', '=', 'b.AREA_ID')->leftJoin($facility . ' AS fa', 'fa.id', '=', 'b.FACILITY_ID')->where(['a.ID' => $id])->select($listColumn)->first();
\Log::info(\DB::getQueryLog());
$user->EXPIRE_DATE = date('m/d/Y', strtotime($user->EXPIRE_DATE));
$userRole = UserRole::where(['ACTIVE' => 1])->get(['ID', 'NAME']);
$userUserRole = UserUserRole::where(['USER_ID' => $user->ID])->get(['ROLE_ID']);
$loProductionUnit = LoProductionUnit::all(['ID', 'NAME']);
$area = LoArea::all(['ID', 'NAME']);
$facility = Facility::all(['ID', 'NAME']);
return view('admin.edit_users', ['user' => $user, 'userRole' => $userRole, 'userUserRole' => $userUserRole, 'loProductionUnit' => $loProductionUnit, 'LoArea' => $area, 'facility' => $facility]);
}
public function getVarList(Request $request)
{
$data = $request->all();
$tmp = FoVar::where(['FORMULA_ID' => $data['formula_id']])->orderBy('ORDER', 'ID')->select('*')->get();
$s = "";
$i = 0;
$html = "";
$result = [];
foreach ($tmp as $row) {
$rowLO = null;
$r = [];
$table_name = $row->OBJECT_TYPE;
$entity = strtolower(str_replace('_', ' ', $table_name));
$entity = ucwords($entity);
$entity = str_replace(' ', '', $entity);
$model = 'App\\Models\\' . $entity;
$tablea = $model::getTableName();
$facility = Facility::getTableName();
$lo_area = LoArea::getTableName();
$rowLO = DB::table($tablea . ' AS a')->join($facility . ' AS b', 'b.ID', '=', 'a.FACILITY_ID')->join($lo_area . ' AS c', 'c.ID', '=', 'b.AREA_ID')->where(['a.ID' => $row->OBJECT_ID])->select('a.NAME AS OBJECT_NAME', 'a.FACILITY_ID', 'b.AREA_ID', 'c.PRODUCTION_UNIT_ID')->first();
if (count($rowLO) > 0) {
$row['PRODUCTION_UNIT_ID'] = $rowLO->PRODUCTION_UNIT_ID;
$row['AREA_ID'] = $rowLO->AREA_ID;
$row['FACILITY_ID'] = $rowLO->FACILITY_ID;
$row['OBJECT_NAME'] = $rowLO->OBJECT_NAME;
} else {
$row['PRODUCTION_UNIT_ID'] = "";
$row['AREA_ID'] = "";
$row['FACILITY_ID'] = "";
$row['OBJECT_NAME'] = "";
}
array_push($result, $row);
}
return response()->json($result);
}
