public function storesec(Request $request2) { // //validation //$this->validate($request2, ['po'=>'required|min:5|max:5','size'=>'required|min:1|max:2','qty'=>'required'/*,'module'=>'min:4|max:10'*/]); $validator = Validator::make($request2->all(), ['po' => 'required|min:5|max:5', 'size' => 'required|min:1|max:3', 'qty' => 'required', 'leader' => 'required']); if ($validator->fails()) { return redirect('/request')->withErrors($validator)->withInput(); } $forminput = $request2->all(); //dd($forminput); $ponum = $forminput['po']; $size = $forminput['size']; $qty = $forminput['qty']; //$module = $forminput['module']; $leader = $forminput['leader']; $comment = $forminput['comment']; $key = $ponum . '-' . $size; //dd("B: ".$barcode." C: ".$carelabel); $type = "modul"; $status = "pending"; // virfy userId if (Auth::check()) { $userId = Auth::user()->id; $module = Auth::user()->name; } else { $msg = 'Modul or User is not autenticated'; return view('Request.error', compact('msg')); } // verify po_id try { $po = DB::connection('sqlsrv')->select(DB::raw("SELECT id, style, color, closed_po FROM pos WHERE po_key ='" . $key . "'")); //dd($po); $poid = $po['0']->id; $style = $po['0']->style; $color = $po['0']->color; $po_closed = $po['0']->closed_po; // $poid = Po::where('po_key', $key)->firstOrFail()->id; // $po_closed = Po::where('po_key', $key)->firstOrFail()->closed_po; } catch (ModelNotFoundException $e) { $msg = 'PO and size not exist in Po table'; return view('Request.error', compact('msg')); } catch (\Exception $e) { $msg = 'PO and size not exist in Po table'; return view('Request.error', compact('msg')); } // verify po is closed if ($po_closed == "Closed") { $msg = 'Komesa is Closed'; return view('Request.error', compact('msg')); } $msg = ""; try { $squality = new SecondQRequest(); $squality->po_id = $poid; $squality->user_id = $userId; $squality->ponum = $ponum; $squality->size = $size; $squality->qty = $qty; $squality->module = $module; $squality->leader = $leader; $squality->status = $status; $squality->type = $type; $squality->comment = $comment; $squality->style = $style; $squality->color = $color; $squality->save(); } catch (\Illuminate\Database\QueryException $e) { $msg = "Problem to save in request table for II quality"; return view('Request.error', compact('msg')); } //return view('Request.success'); $msg = '<p style="color:green;">II quality request successfully saved</p>'; if (time() < mktime(00, 30, 0)) { $del = "Delivery at 9:00"; } else { if (time() < mktime(11, 30, 0)) { $del = "Delivery at 12:00"; } else { $del = "Delivery tomorow at 07:00"; } } return view('Request.success', compact('msg', 'del')); }
public function secondqrequestupdatenav(Request $request) { $request_q = DB::connection('sqlsrv')->select(DB::raw("SELECT id,style,color,size,status FROM secondq_requests")); //dd($request_q); foreach ($request_q as $row) { $id = $row->id; $style = $row->style; $color = $row->color; $size = $row->size; $status = $row->status; if ($status == "pending") { //dd($id." ".$po." ".$size); $po = DB::connection('sqlsrv3')->select(DB::raw("SELECT [Item No_]\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t ,[Color]\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t ,[TG]\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t ,[Materiale] as materiale\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t ,[Description Model] as des\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t ,[TG2] as tg2\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t ,[Commersial Color code] as ccc\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t ,[Color decstionption] as cd\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t ,[Barcode] as barcode\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t FROM [Gordon_LIVE].[dbo].[GORDON\$Barocde Table Quality]\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t WHERE [Item No_] = '" . $style . "' \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \tAND [Color] = '" . $color . "' \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \tAND [TG] = '" . $size . "'")); $materiale = $po['0']->materiale; $desc = $po['0']->des; $tg2 = $po['0']->tg2; $ccc = $po['0']->ccc; $cd = $po['0']->cd; $barcode = $po['0']->barcode; $update = SecondQRequest::findOrFail($id); $update->materiale = $materiale; $update->desc = $desc; $update->tg2 = $tg2; $update->ccc = $ccc; $update->cd = $cd; $update->barcode = $barcode; $update->save(); } } return Redirect::to('/secondqrequesttable'); }