/** * Run the database seeds. * * @return void */ public function run() { factory(Maker::class, 3)->create(); factory(Buyer::class, 3)->create(); factory(Commodity::class, 5)->create(); factory(Goods::class, 5)->create(); $goods = Goods::all()->random(2); $exJoinings = []; $inJoinings = []; foreach ($goods->keys() as $key) { $exJoinings[$key] = $this->randJoiningsFoxExternalOrder(); $inJoinings[$key] = $this->randJoiningsForInternalOrder(); } $externalOrder = new ExternalOrder(); $externalOrder->contract_no = '15EL1166'; $externalOrder->sign_date = Carbon::now(); $externalOrder->buyer()->associate(Buyer::all()->random()); $externalOrder->save(); $externalOrder->goods()->saveMany($goods->all(), $exJoinings); $internalOrder = new InternalOrder(); $internalOrder->externalOrder()->associate($externalOrder); $internalOrder->maker()->associate(Maker::all()->random()); $internalOrder->save(); $internalOrder->goods()->saveMany($goods->all(), $inJoinings); }
public function create() { // $goods=DB::select('select * from goods order by points desc'); $goods = Goods::all(); return view('mall.goods', ['goods' => $goods]); }
public function exportStockExcel($owner_id) { if (empty($this->authUser)) { return 'Permission denied'; } elseif ($this->authUser->role_id != 1 && $this->authUser->role_id != 2) { return 'Permission denied'; } if ($this->authUser->role_id == 2) { $owner_id = $this->authUser->user_id; } $filename = 'export_stock'; if (!empty($owner_id)) { $data = Goods::where('owner_id', '=', $owner_id)->get(); $owner = User::find($owner_id); $filename = $owner->user_name_en . '_stock_' . date('Y-m-d_His'); } else { $data = Goods::all(); $filename = 'all_stock_' . date('Y-m-d_His'); } $exportData[] = array('Supplier Product Code / Part Number', 'Supplier Name', 'Description', 'Current Unit', 'Add to stock (Unit to sell)', 'Unit For Sale'); foreach ($data as $val) { $exportData[] = array($val->supplier_product_code_part_number, $val->supplier_name, $val->description, $val->unit, 0, $val->unit_for_sales); } \Excel::create($filename, function ($excel) use($exportData) { $excel->sheet('Stock', function ($sheet) use($exportData) { $sheet->fromArray($exportData, null, 'A1', false, false); }); })->download('xlsx'); // echo '<pre>'.print_r($data,true).'</pre>'; }