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');
 }