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