public function downloadExcel(ReceiveSearchMovementRequest $request) { $filter = $request->except(['item_status', 'orderBy']); $orderBy = array_get($request->all(), 'sort_by', array()); $receiveItems = ReceiveItem::whereByFilterAll($filter, $orderBy); $datetime = date('d-m-Y_H-i-s'); Excel::create("movement_receive_{$datetime}", function ($excel) use($receiveItems) { $excel->sheet('Receive', function ($sheet) use($receiveItems) { $sheet->setAutoSize(true); $sheet->row(1, array(trans('receive.attributes.created_at'), trans('receive.attributes.document_no'), trans('receive.attributes.po_no'), trans('receive.attributes.ref_no'), trans('receive.attributes.project_code'), trans('receive.attributes.create_by'), trans('receive.attributes.remark'), trans('receive_item.attributes.mix_no'), trans('receive_item.attributes.product_code'), trans('receive_item.attributes.location_id'), trans('receive_item.attributes.product_description'), trans('receive_item.attributes.unit'), trans('receive_item.attributes.qty'), trans('receive_item.attributes.remark'), trans('receive_item.attributes.status'))); $sheet->row(1, function ($row) { $row->setBorder('solid', 'solid', 'solid', 'solid'); $row->setFont(array('size' => '16', 'bold' => true)); }); $i = 2; foreach ($receiveItems as $item) { $sheet->row($i, array($item->receive->created_at->format('d/m/Y H:i'), $item->receive->document_no, $item->receive->po_no, $item->receive->ref_no, $item->receive->project_code, $item->receive->user->name, $item->receive->remark, $item->mix_no, $item->product_code, $item->location_name, $item->product_description, $item->product->unit->name, $item->qty, $item->remark, $item->status)); $i++; } }); })->export('xls'); }
public function updateQty(Request $request) { $id = $request->get('pk'); $qty = $request->get('value'); $mgs = []; $roles = ['value' => 'required|integer|digits_between:1,10']; $attributes = ['value' => trans('receive_item.attributes.qty')]; $validator = Validator::make($request->all(), $roles, $mgs, $attributes); if ($validator->fails()) { return response()->json(['status' => 'error', 'mgs' => $validator->errors()->first('value')]); } $item = ReceiveItem::find($id); $item->qty = $qty; $item->save(); }