/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(ReceiptpaymentsRequest $request, $soheadId)
{
//
$salesorder = Salesorder::findOrFail($soheadId);
$soitems = $salesorder->soitems;
$priceTotal = 0.0;
foreach ($soitems as $soitem) {
$priceTotal += $soitem->price * $soitem->qty;
}
$priceReceived = Receiptpayments::where('sohead_id', $soheadId)->sum('amount');
if ($priceTotal <= $priceReceived) {
return '已完成付款';
}
$input = Request::all();
Receiptpayments::create($input);
return redirect('sales/salesorders/' . $request->get('sohead_id') . '/receiptpayments');
}
/**
* Bootstrap the application services.
*
* @return void
*/
public function boot()
{
// itemList
view()->composer(array('product.bomitems.createitem', 'product.bomitems.edit', 'sales.soitems.create', 'sales.soitems.edit'), function ($view) {
$view->with('itemList', \App\models\Product\Item::orderby('id', 'asc')->lists('item_number', 'id'));
});
// itemclassList
view()->composer(array('items.create', 'items.edit', 'product.items.create', 'product.items.edit'), function ($view) {
$view->with('itemclassList', \App\models\Product\Itemclass::orderby('id', 'asc')->lists('name', 'id'));
});
// itemtypeList
view()->composer(array('items.create', 'items.edit', 'product.items.create', 'product.items.edit'), function ($view) {
$view->with('itemtypeList', \App\Itemtype::orderby('id', 'asc')->lists('name', 'id'));
});
// provinceList
view()->composer(array('addr.citys.create', 'addr.citys.edit', 'addr.addrs.create', 'addr.addrs.edit'), function ($view) {
$view->with('provinceList', \App\Province::orderby('id', 'asc')->lists('name', 'id'));
});
// cityList
view()->composer(array('addr.addrs.create', 'addr.addrs.edit'), function ($view) {
$view->with('cityList', \App\City::orderby('id', 'asc')->lists('name', 'id'));
});
// addrList
view()->composer(array('contacts.create', 'contacts.edit', 'inventory.warehouses.create', 'inventory.warehouses.edit', 'purchase.vendinfos.create', 'purchase.vendinfos.edit'), function ($view) {
$view->with('addrList', \App\Addr::orderby('id', 'asc')->lists('line1', 'id'));
});
// contactList
view()->composer(array('custinfos.create', 'custinfos.edit', 'inventory.warehouses.create', 'inventory.warehouses.edit', 'purchase.vendinfos.create', 'purchase.vendinfos.edit', 'purchase.purchaseorders.create', 'purchase.purchaseorders.edit'), function ($view) {
$view->with('contactList', \App\Contact::orderby('id', 'asc')->lists('name', 'id'));
});
// deptList
view()->composer(array('system.employees.create', 'system.employees.edit'), function ($view) {
$view->with('deptList', \App\System\Dept::orderby('id', 'asc')->lists('name', 'id'));
});
// imageList
view()->composer(array('system.employees.create', 'system.employees.edit'), function ($view) {
$view->with('imageList', \App\System\Image::orderby('id', 'asc')->lists('name', 'id'));
});
// custinfoList
view()->composer(array('sales.salesorders.create', 'sales.salesorders.edit'), function ($view) {
$view->with('custinfoList', \App\Custinfo::orderby('id', 'asc')->lists('name', 'id'));
});
// salesrepList
view()->composer(array('sales.salesorders.create', 'sales.salesorders.edit'), function ($view) {
$view->with('salesrepList', \App\Sales\Salesrep::orderby('id', 'asc')->lists('name', 'id'));
});
// termList
view()->composer(array('purchase.vendinfos.create', 'purchase.vendinfos.edit', 'purchase.purchaseorders.create', 'purchase.purchaseorders.edit'), function ($view) {
$view->with('termList', \App\Sales\Term::orderby('id', 'asc')->lists('code', 'id'));
});
// vendtypeList
view()->composer(array('purchase.vendinfos.create', 'purchase.vendinfos.edit'), function ($view) {
$view->with('vendtypeList', \App\Purchase\Vendtype::orderby('id', 'asc')->lists('code', 'id'));
});
// vendinfoList
view()->composer(array('purchase.purchaseorders.create', 'purchase.purchaseorders.edit'), function ($view) {
$view->with('vendinfoList', \App\Purchase\Vendinfo::orderby('id', 'asc')->lists('number', 'id'));
});
// soheadList
view()->composer(array('purchase.purchaseorders.create', 'purchase.purchaseorders.edit'), function ($view) {
$view->with('soheadList', \App\Sales\Salesorder::orderby('id', 'asc')->lists('number', 'id'));
});
// itemsiteList
view()->composer(array('purchase.poitems.create', 'purchase.poitems.edit'), function ($view) {
// $items = \App\Inventory\Itemsite::orderby('itemsites.id', 'asc')->leftJoin('items', 'itemsites.item_id', '=', 'items.id')->select('item_number', 'itemsites.id')->get();
$view->with('itemsiteList', \App\Inventory\Itemsite::orderby('itemsites.id', 'asc')->leftJoin('items', 'itemsites.item_id', '=', 'items.id')->select('item_number', 'itemsites.id')->lists('item_number', 'id'));
// $view->with('itemsiteList', DB::table('itemsites')->leftJoin('items', 'itemsites.item_id', '=', 'items.id')->select('item_number', 'itemsites.id')->lists('item_number', 'itemsites.id'));
// $view->with('itemsiteList', \App\Inventory\Itemsite::orderby('itemsites.id', 'asc')->lists('item_id', 'id'));
});
// roleList
view()->composer(array('system.users.editrole'), function ($view) {
$view->with('roleList', \App\Role::orderby('id', 'asc')->lists('name', 'id'));
});
// charIList: item char list
view()->composer(array('items.create', 'items.edit', 'product.items.create', 'product.items.edit'), function ($view) {
$view->with('charIList', \App\Product\Characteristic::orderby('id', 'asc')->where('bitems', true)->lists('name', 'id'));
});
}
public function ship($id)
{
$soitems = Salesorder::find($id)->soitems;
foreach ($soitems as $soitem) {
$forQtyshipped = $soitem->qty - $soitem->qtyshipped;
if ($forQtyshipped > 0.0) {
$itemsite = $soitem->itemsite;
if ($itemsite == null) {
return $soitem->item->item_number . '无库存记录';
}
if ($itemsite->qtyonhand < $forQtyshipped) {
return $soitem->item->item_number . ', 库存已不够，无法发货。';
}
// create shipto record
$data = ['orderitem_id' => $soitem->id, 'quantity' => $forQtyshipped, 'shipdate' => Carbon::now()];
Shipitem::create($data);
// update soitem qtyshipped
$soitem->qtyshipped = $soitem->qtyshipped + $forQtyshipped;
$soitem->save();
// update itemsite qtyonhand
$itemsite->qtyonhand = $itemsite->qtyonhand - $forQtyshipped;
$itemsite->save();
}
}
return redirect('sales/salesorders');
}
