public function _indexconfig()
{
$network = Network::where(['NETWORK_TYPE' => 1])->get(['ID', 'NAME']);
$result = [];
foreach ($network as $n) {
$tmp = [];
$count = AllocJob::where(['NETWORK_ID' => $n->ID])->count();
if ($count > 0) {
$tmp['NAME'] = $n->NAME . '(' . $count . ')';
} else {
$tmp['NAME'] = $n->NAME;
}
$tmp['ID'] = $n->ID;
array_push($result, $tmp);
}
$code_alloc_value_type = CodeAllocValueType::all('ID', 'NAME');
$facility = Facility::all('ID', 'NAME');
$code_alloc_type = CodeAllocType::all('ID', 'NAME');
$codeFlowPhase = CodeFlowPhase::all('ID', 'NAME');
$codeAllocValueType = CodeAllocValueType::all('ID', 'NAME');
return view('front.allocset', ['result' => $result, 'CodeAllocValueType' => $code_alloc_value_type, 'facility' => $facility, 'codeAllocType' => $code_alloc_type, 'codeFlowPhase' => $codeFlowPhase, 'codeAllocValueType' => $codeAllocValueType]);
}
public function loadFormSetting(Request $request)
{
$data = $request->all();
$result = array();
$value = $data['value'];
$task_id = isset($data['task_id']) ? $data['task_id'] : 0;
switch ($value) {
case 'ALLOC_CHECK':
case 'ALLOC_RUN':
$network = Network::getTableName();
$allocJob = AllocJob::getTableName();
$tm = [];
$tm = DB::table($network . ' AS a')->join($allocJob . ' AS b', 'a.ID', '=', 'b.NETWORK_ID')->distinct()->get(['a.ID', 'a.NAME']);
$alloc_job = AllocJob::where(['NETWORK_ID' => $tm[0]->ID])->get(['ID', 'NAME']);
$result['network'] = $tm;
$result['allocJob'] = $alloc_job;
break;
case 'VIS_REPORT':
$result = Facility::all(['ID', 'NAME']);
break;
case 'FDC_EU':
$models = ['Facility', 'EnergyUnitGroup', 'CodeReadingFrequency', 'CodeFlowPhase', 'CodeEventType', 'CodeAllocType', 'CodePlanType', 'CodeForecastType'];
foreach ($models as $m) {
$tm = [];
$model = 'App\\Models\\' . $m;
$tm = $model::all(['ID', 'NAME']);
$result[$m] = $tm;
}
break;
case 'FDC_FLOW':
$models = ['Facility', 'CodeReadingFrequency', 'CodeFlowPhase'];
foreach ($models as $m) {
$tm = [];
$model = 'App\\Models\\' . $m;
$tm = $model::all(['ID', 'NAME']);
$result[$m] = $tm;
}
break;
case 'INT_IMPORT_DATA':
$tm = [];
$tm = IntConnection::all(['ID', 'NAME']);
$intTagSet = IntTagSet::where(['CONNECTION_ID' => $tm[0]->ID])->get(['ID', 'NAME']);
$result['IntConnection'] = $tm;
$result['IntTagSet'] = $intTagSet;
break;
default:
$result = [];
}
$task = TmWorkflowTask::where(['ID' => $task_id])->get();
$result['task'] = $task;
$result['value'] = $value;
return response()->json(array('result' => $result));
}
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]);
}
