/**
* 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>';
}