public function deleteGroup(Request $request)
{
$data = $request->all();
DB::beginTransaction();
try {
//\DB::enableQueryLog ();
FoVar::whereIn('FORMULA_ID', function ($query) use($data) {
$query->select('ID')->from('FORMULA')->where(['GROUP_ID' => $data['id']]);
})->delete();
//\Log::info ( \DB::getQueryLog () );
Formula::where(['ID' => $data['id']])->delete();
FoGroup::where(['ID' => $data['id']])->delete();
$fo_group = $this->getFoGroup();
} catch (\Exception $e) {
\Log::info($e->getMessage());
DB::rollback();
}
DB::commit();
return response()->json($fo_group);
}
public function _indexWorkFlow()
{
$ebfunctions = EbFunctions::where('USE_FOR', 'like', '%TASK_GROUP%')->whereIn('LEVEL', [1, 2])->get(['PARENT_CODE', 'CODE', 'NAME', 'PATH']);
$result = array();
foreach ($ebfunctions as $eb) {
$name = "";
if (!is_null($eb->PARENT_CODE)) {
$name = "---";
}
$eb['FUNCTION_NAME'] = $name . $eb->NAME;
$eb['FUNCTION_CODE'] = $eb->CODE;
$eb['FUNCTION_URL'] = $eb->PATH;
array_push($result, $eb);
}
$users = array();
$user = User::where(['ACTIVE' => 1])->get(['USERNAME', 'LAST_NAME', 'MIDDLE_NAME', 'FIRST_NAME']);
foreach ($user as $u) {
$u['NAME'] = $u->LAST_NAME . ' ' . $u->MIDDLE_NAME . ' ' . $u->FIRST_NAME;
array_push($users, $u);
}
$foGroup = FoGroup::all('ID', 'NAME');
return view('front.workflow', array('ebfunctions' => $result, 'user' => $users, 'foGroup' => $foGroup));
}
public function _index()
{
$facility = Facility::whereIn('ID', [18, 19])->get(['ID', 'NAME']);
$fogroup = FoGroup::get(['ID', 'NAME']);
return view('front.flowreport', ['facility' => $facility, 'fogroup' => $fogroup]);
}
