/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function search() { Log::info("Into SpecialController"); $design_trend_B = Input::get('design_trend_B'); $search = Input::get('search'); $sortBy = Input::get('sortBy'); $orderBy = Input::get('orderBy'); if (empty($design_trend_B)) { $design_trend_B = Auth::user()->empId; } $datas = MmnameModel::on(DBUtils::getDBName())->newQuery(); if (Input::has('page')) { // paging Log::info("into paging"); $search = session()->get('design_trend_search'); $sortBy = session()->get('sortBy'); $orderBy = session()->get('orderBy'); $design_trend_B = session()->get('design_trend_B'); } if (!empty($search)) { $datas = $datas->Where(function ($datas) use($search) { $datas->orWhere('A', 'LIKE', "%{$search}%"); }); } if (!empty($design_trend_B) && $design_trend_B != -1) { $datas = $datas->Where('B', '=', "{$design_trend_B}"); } if (!empty($sortBy) && !empty($orderBy)) { $datas = $datas->orderBy($sortBy, $orderBy); } session()->put('sortBy', $sortBy); session()->put('orderBy', $orderBy); session()->put('design_trend_search', $search); session()->put('design_trend_B', $design_trend_B); // $datas=$datas->orderBy('updated_at','DESC')->paginate(10); $datas = $datas->paginate(10); //$mmtrend_groups = DB::connection(DBUtils::getDBName())->table('mmtrend_group')->where('mmplant','=',session()->get('user_mmplant'))->get(); // $mmtrend_groups = DB::table('mmtrend_group')->where('mmplant', '=', session()->get('user_mmplant')); if (session()->get('user_priority') < 128) { $mmtrend_groups = $mmtrend_groups->where('B', '=', '9'); } $mmtrend_groups = $mmtrend_groups->get(); return view('ais/special', ['mmtrendsM' => $datas, 'mmtrend_groups' => $mmtrend_groups]); }
/** * Remove the specified resource from storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function copyTrend(Request $request) { Log::info("copyTrend"); $id = request('ZZ'); $trend_name = request('trend_name'); $target_group = request('target_group'); $target_unit = request('target_unit'); Log::info("ZZ[" . $id . "],trend_name[" . $trend_name . "],target_group[" . $target_group . "]\n target_unit[" . $target_unit . "]"); if ($target_group == '9') { $target_group = Auth::user()->empId; } $isExcessTrend = false; $maxTrend = 0; $count = 0; $user_priority = session()->get('user_priority'); if (request('target_group') == '9') { $countMyTrend = DB::connection(DBUtils::getDBName())->table('mmname_table')->where('B', '=', $target_group)->count(); if ($user_priority < 128) { $isExcessTrend = $countMyTrend > 3; $maxTrend = 4; } else { if ($user_priority < 201) { $isExcessTrend = $countMyTrend > 48; $maxTrend = 49; } else { if ($user_priority < 255) { $isExcessTrend = $countMyTrend > 98; $maxTrend = 99; } else { $isExcessTrend = $countMyTrend > 9998; $maxTrend = 9999; } } } } $mmtrendM = MmnameModel::on(DBUtils::getDBName())->find($id); if (!empty($mmtrendM) && !$isExcessTrend) { // set target group $count = DB::connection(DBUtils::getDBName())->table('mmname_table')->where('A', '=', $trend_name)->where('B', '=', $target_group)->count(); if ($count == 0) { $mmtrendM_new = new MmnameModel(); $mmtrendM_new->setConnection(DBUtils::getDBName()); $mmtrendM_new->A = $trend_name; if ($target_group == '9') { $mmtrendM_new->B = Auth::user()->empId; } else { $mmtrendM_new->B = $target_group; } $mmtrendM_new->save(); $mmtrends = MmtrendModel::on(DBUtils::getDBName())->where('G', $id)->get(); if (!empty($mmtrends)) { foreach ($mmtrends as $mmtrend) { $mmtrendModel_new = new MmtrendModel(); $mmtrendModel_new->setConnection(DBUtils::getDBName()); $mmtrendModel_new->A = $mmtrend->A; if ($target_unit == '0') { $mmtrendModel_new->B = $mmtrend->B; } else { $mmtrendModel_new->B = $target_unit; } $mmtrendModel_new->C = $mmtrend->C; $mmtrendModel_new->D = $mmtrend->D; $mmtrendModel_new->E = $mmtrend->E; $mmtrendModel_new->F0 = $mmtrend->F0; $mmtrendModel_new->F1 = $mmtrend->F1; $mmtrendModel_new->H = $mmtrend->H; $mmtrendModel_new->I = $mmtrend->I; $mmtrendModel_new->G = $mmtrendM_new->ZZ; $mmtrendModel_new->save(); } } } } Log::info("mmnameModel ->" . $mmtrendM->A); return response()->json(['mmtrendM' => json_encode($mmtrendM), 'count' => json_encode($count), 'isExcessTrend' => json_encode($isExcessTrend), 'maxTrend' => json_encode($maxTrend)]); }