/** * Store a newly created resource in storage. * * @return Response */ public function store(Request $request) { // //validation $this->validate($request, ['po' => 'required|min:5|max:5', 'size' => 'required', 'qty' => 'required', 'module' => 'min:4|max:10']); $forminput = $request->all(); $ponum = $forminput['po']; $size = $forminput['size']; $qty = $forminput['qty']; $module = $forminput['module']; $comment = $forminput['comment']; $key = $ponum . '-' . $size; //dd($key); //$type = ""; $status = "panding"; // virfy userId if (Auth::check()) { $userId = Auth::user()->id; } else { $msg = 'User is not autenticated'; return view('BarcodeRequest.error', compact('msg')); } // verify po_id try { $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('BarcodeRequest.error', compact('msg')); } // verify po is closed if ($po_closed == True) { $msg = 'Po is Closed'; return view('BarcodeRequest.error', compact('msg')); } try { $barcode = new BarcodeRequest(); $barcode->po_id = $poid; $barcode->user_id = $userId; $barcode->ponum = $ponum; $barcode->size = $size; $barcode->qty = $qty; $barcode->module = $module; $barcode->leader; $barcode->status = $status; //$barcode->type = $type; $barcode->comment = $comment; $barcode->save(); } catch (\Illuminate\Database\QueryException $e) { $msg = "Problem to save in database"; return view('BarcodeRequest.error', compact('msg')); } return view('BarcodeRequest.success'); }
/** * Process datatables ajax request. * * @return \Illuminate\Http\JsonResponse */ public function anyData() { /* $table = Po::select([ //'id', //'po_key', //'order_code', 'pos.po', 'pos.size', 'pos.style', 'pos.color', 'pos.color_desc', 'pos.season', 'pos.total_order_qty', //'pos.flash', //'pos.closed_po' //'pos.brand', //'pos.status', //'pos.type', //'pos.comment', //'pos.created_at', //'pos.updated_at', \DB::raw('sum(barcode_stocks.qty) as stock_b_qty'), \DB::raw('sum(barcode_requests.qty) as request_b_qty'), \DB::raw('sum(carelabel_stocks.qty) as stock_c_qty'), \DB::raw('sum(carelabel_requests.qty) as request_c_qty'), ]) ->leftJoin('barcode_stocks','barcode_stocks.po_id','=','pos.id') ->leftJoin('barcode_requests','barcode_requests.po_id','=','pos.id') ->leftJoin('carelabel_stocks','carelabel_stocks.po_id','=','pos.id') ->leftJoin('carelabel_requests','carelabel_requests.po_id','=','pos.id') //->where('pos.closed_po','=',0) ->groupBy('pos.po','pos.size','pos.style','pos.color','pos.color_desc','pos.season','pos.total_order_qty','pos.flash','pos.closed_po','pos.created_at','pos.updated_at'); */ /* SELECT pos.id, pos.po, pos.style, (SELECT SUM(barcode_stocks.qty) FROM barcode_stocks WHERE barcode_stocks.po_id = pos.id ) stock_b, (SELECT SUM(barcode_requests.qty) FROM barcode_requests WHERE barcode_requests.po_id = pos.id ) request_b, (SELECT SUM(carelabel_stocks.qty) FROM carelabel_stocks WHERE carelabel_stocks.po_id = pos.id ) stock_c, (SELECT SUM(carelabel_requests.qty) FROM carelabel_requests WHERE carelabel_requests.po_id = pos.id ) request_c FROM pos */ //$stock_b_qty = 0; //\DB::raw("sum(barcode_stocks.qty) as stock_b_qty FROM barcode_stocks WHERE barcode_stocks.po_id = 1"); //dd($stock_b_qty); $table = Po::select(['pos.id', 'pos.size', 'pos.style', 'pos.color', 'pos.color_desc', 'pos.season', 'pos.total_order_qty', DB::raw('sum(barcode_stocks.qty) as stock_b_qty'), DB::raw('sum(barcode_requests.qty) as request_b_qty'), DB::raw('sum(carelabel_stocks.qty) as stock_c_qty'), DB::raw('sum(carelabel_requests.qty) as request_c_qty')])->leftjoin('barcode_stocks', 'barcode_stocks.po_id', '=', 'pos.id')->leftjoin('barcode_requests', 'barcode_requests.po_id', '=', 'pos.id')->leftjoin('carelabel_stocks', 'carelabel_stocks.po_id', '=', 'pos.id')->leftjoin('carelabel_requests', 'carelabel_requests.po_id', '=', 'pos.id')->groupBy('pos.id', 'pos.po', 'pos.size', 'pos.style', 'pos.color', 'pos.color_desc', 'pos.season', 'pos.total_order_qty'); //dd($table); return Datatables::of($table)->addColumn('b_stock', '{!! $total_order_qty-$stock_b_qty !!}')->addColumn('b_request', '{!! $stock_b_qty-$request_b_qty !!}')->addColumn('c_stock', '{!! $total_order_qty-$stock_c_qty !!}')->addColumn('c_request', '{!! $stock_c_qty-$request_c_qty !!}')->make(true); }
public function postImportPo(Request $request) { $getSheetName = Excel::load(Request::file('file'))->getSheetNames(); foreach ($getSheetName as $sheetName) { //if ($sheetName === 'Product-General-Table') { //selectSheetsByIndex(0) //DB::statement('SET FOREIGN_KEY_CHECKS=0;'); //DB::table('pos')->truncate(); //Excel::selectSheets($sheetName)->load($request->file('file'), function ($reader) //Excel::selectSheets($sheetName)->load(Input::file('file'), function ($reader) //Excel::filter('chunk')->selectSheetsByIndex(0)->load(Request::file('file'))->chunk(50, function ($reader) Excel::filter('chunk')->selectSheets($sheetName)->load(Request::file('file'))->chunk(50, function ($reader) { foreach ($reader->toArray() as $sheet) { //MainModel::create($sheet); //$sheet->dump(); } $readerarray = $reader->toArray(); //var_dump($readerarray); foreach ($readerarray as $row) { //var_dump($row['po_key']); //var_dump($row['po']); //$order_code = $row->order_code; //$order_code = $row['order_code']; //$po = substr($order_code, 4,10); //$rest = substr("abcdef", -3, 1); // returns "d" 16IC5800050657::00102::M //var_dump($po); $season = $row['season']; $order_code = $row['order_code']; // 16IC5800050657::00102::M $product = $row['product']; // 1MC07A 4619L $product_des = $row['product_description']; $qty = $row['total_qty']; $flash = $row['flash']; $po = substr($order_code, 9, 5); // $size = substr($order_code, 23, 3); $style = substr($product, 0, 8); $color = substr($product, 9, 4); $po_key = $po . "-" . $size; $brand = substr($order_code, 2, 1); if ($brand == "T") { $brand = "TEZENIS"; } elseif ($brand == "I") { $brand = "INTIMISSIMI"; } elseif ($brand == "C") { $brand = "CALZEDONIA"; } else { $brand = ""; } if ($flash == 'N') { $flash = ''; } else { $flash = $flash; } $closed = 'Open'; $style = str_replace(' ', '', $style); $size = str_replace(' ', '', $size); $color = str_replace(' ', '', $color); $porder = new Po(); $porder->po_key = $po_key; $porder->order_code = $order_code; $porder->po = $po; $porder->size = $size; $porder->style = $style; $porder->color = $color; $porder->color_desc = $product_des; $porder->season = $season; $porder->total_order_qty = $qty; $porder->flash = $flash; $porder->closed_po = $closed; $porder->brand = $brand; $porder->status; $porder->type; $porder->comment; $porder->save(); $barcode = new BarcodeStock(); $barcode->po_id = $porder->id; // ??? $barcode->user_id = 3; $barcode->ponum = $po; $barcode->size = $size; $barcode->qty = 0; $barcode->module; $barcode->status; $barcode->type = "insert"; $barcode->comment; $barcode->save(); $carelabel = new CarelabelStock(); $carelabel->po_id = $porder->id; // ??? $carelabel->user_id = 3; $carelabel->ponum = $po; $carelabel->size = $size; $carelabel->qty = 0; $carelabel->module; $carelabel->status; $carelabel->type = "insert"; $carelabel->comment; $carelabel->save(); } }); } //Session::flash('file_uploaded_successfully', 'File has been uploaded successfully and has also updated the database.'); return redirect('/'); //return view('import.importresult', compact('reader')); }
public function storep(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', 'module' => 'required|min:4|max:5', '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 = ucfirst($forminput['module']); $leader = $forminput['leader']; $comment = $forminput['comment']; $key = $ponum . '-' . $size; if (isset($forminput['barcode'])) { $barcode = $forminput['barcode']; } else { $barcode = '0'; } if (isset($forminput['carelabel'])) { $carelabel = $forminput['carelabel']; } else { $carelabel = '0'; } $type = "preparation"; if ($qty <= 0 and $qty == NULL) { $qty = NULL; $status = "pending"; } else { $status = "confirmed"; } // virfy userId if (Auth::check()) { $userId = Auth::user()->id; //$module = Auth::user()->name; } else { $msg = 'Modul or User is not autenticated'; return view('Request.errorp', compact('msg')); } // verify po_id try { $poid = Po::where('po_key', $key)->firstOrFail()->id; } catch (ModelNotFoundException $e) { $msg = 'PO and size not exist in Po table'; return view('Request.errorp', compact('msg')); } // verify po is closed $po_closed = Po::where('po_key', $key)->firstOrFail()->closed_po; if ($po_closed == True) { $msg = 'Komesa is Closed'; return view('Request.errorp', compact('msg')); } $msg = ""; if ($barcode == '1') { try { $barcode = new BarcodeRequest(); $barcode->po_id = $poid; $barcode->user_id = $userId; $barcode->ponum = $ponum; $barcode->size = $size; $barcode->qty = $qty; $barcode->module = $module; $barcode->leader = $leader; $barcode->status = $status; $barcode->type = $type; $barcode->comment = $comment; $barcode->save(); } catch (\Illuminate\Database\QueryException $e) { $msg = "Problem to save in barcode request table"; return view('Request.errorp', compact('msg')); } //return view('Request.success'); $msg = '<p style="color:green;">Barcode request successfully saved</p>'; } if ($carelabel == '1') { try { $carelabel = new CarelabelRequest(); $carelabel->po_id = $poid; $carelabel->user_id = $userId; $carelabel->ponum = $ponum; $carelabel->size = $size; $carelabel->qty = $qty; $carelabel->module = $module; $carelabel->leader = $leader; $carelabel->status = $status; $carelabel->type = $type; $carelabel->comment = $comment; $carelabel->save(); } catch (\Illuminate\Database\QueryException $e) { $msg = "Problem to save in carelabel request table"; return view('Request.errorp', compact('msg')); } //return view('Request.success'); $msg = $msg . '<p style="color:green;">Carelabel request successfully saved</p>'; } if ($msg == "") { $msg = '<p style="color:red;"><big>BARCODE AND CARELABEL NOT SELECTED !!!</big></p>'; return view('Request.errorp', compact('msg')); } 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')); }