/**
* Store the return items data
*
* @return ReturnController@index
*/
public function store()
{
$input = Input::all();
$customer = Customer::firstOrNew(['name' => $input['customer']]);
$customer->address = $input['address'];
$customer->save();
$ret = new Ret();
$ret->customer_id = $customer->id;
$ret->date = $input['date'];
$ret->reference_no = $input['ref_no'];
$ret->salesman = $input['salesman'];
$ret->area = $input['area'];
$ret->received_by = $input['received_by'];
$ret->checked_by = $input['checked_by'];
$ret->save();
foreach ($input['boxes'] as $i => $box) {
$retItem = new ReturnItem();
$retItem->ret_id = $ret->id;
$retItem->box_id = $box;
$retItem->no_of_box = $input['no_of_box'][$i];
$retItem->no_of_packs = $input['no_of_packs'][$i];
$retItem->amount = $input['amount'][$i];
$retItem->product_id = Box::find($box)->product->id;
$retItem->save();
}
return Redirect::action('InventoryController@index');
}
public function update()
{
$input = Input::all();
foreach ($input['id'] as $i => $id) {
$box = Box::find($id);
$box->purchase_price = $input['purchase_price'][$i];
$box->selling_price_1 = $input['selling_price_1'][$i];
$box->selling_price_2 = $input['selling_price_2'][$i];
$box->save();
}
return Redirect::action('PriceListController@index');
}
public function query()
{
$input = Input::all();
$response = array();
$response['product'] = Product::where('name', 'like', $input['query'] . '%')->orderBy('name')->first();
$response['supplier'] = Supplier::find($response['product']->supplier_id);
$response['category'] = ProductCategory::find($response['product']->product_category_id);
$response['boxes'] = Box::where('product_id', $response['product']->id)->get();
$response['stocks'] = array();
foreach ($response['boxes'] as $box) {
$stock = Box::countStock($box->id);
array_push($response['stocks'], $stock);
}
return $response;
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
$input = Input::all();
$lost = new Lost();
$lost->date = $input["date"];
$lost->checked_by = $input["checked_by"];
$lost->save();
foreach ($input['boxes'] as $i => $box) {
$lostItem = new LostItem();
$lostItem->lost_id = $lost->id;
$lostItem->no_of_box = $input['no_of_box'][$i];
$lostItem->no_of_packs = $input['no_of_packs'][$i];
$lostItem->amount = $input['amount'][$i];
$lostItem->box_id = $box;
$lostItem->product_id = Box::find($box)->product->id;
$lostItem->save();
}
}
public function scopeCountReturns2($query, $box_id)
{
$ret = Box::countReturns($box_id);
$rbox = $ret['no_of_box'];
$rpacks = $ret['no_of_packs'];
$box = Box::find($box_id);
$inStock = $box->instocks->sum('quantity') + $rbox;
$packsPerBox = $box->no_of_packs;
$totalPacks = $inStock * $packsPerBox + $rpacks;
$noOfBoxOrdered = $box->orderItems->sum('no_of_box');
$noOfPacksOrdered = $box->orderItems->sum('no_of_packs');
$totalOrders = $noOfBoxOrdered * $packsPerBox + $noOfPacksOrdered;
$totalNoOfPacksLeft = $totalPacks - $totalOrders;
$totalNoOfBoxLeft = floor($totalNoOfPacksLeft / $packsPerBox);
$totalNoOfBoxLeft == null ? 0 : $totalNoOfBoxLeft;
$totalNoOfPacksLeft == null ? 0 : $totalNoOfPacksLeft;
$totalLeft = ['no_of_box_available' => $totalNoOfBoxLeft, 'no_of_packs_available' => $totalNoOfPacksLeft - $totalNoOfBoxLeft * $packsPerBox];
return $totalLeft;
}
public function store()
{
$input = Input::all();
foreach ($input['boxes'] as $i => $box) {
if ($input['quantity'][$i] == 0) {
continue;
}
$instock = new InStock();
$instock->date = $input['date'];
$instock->supplier_id = $input['supplier'];
$instock->box_id = $box;
$b = Box::find($box);
$instock->product_id = $b->product_id;
$instock->quantity = $input['quantity'][$i];
$instock->amount = $input['quantity'][$i] * $b->purchase_price;
$instock->save();
}
return Redirect::action('InventoryController@index');
}
public function store()
{
$input = Input::all();
$badOrder = new BadOrder();
$badOrder->truck_no = $input['truck_no'];
$badOrder->date = $input['date'];
$badOrder->received_by = $input['received_by'];
$badOrder->salesman = $input['salesman'];
$badOrder->save();
foreach ($input['boxes'] as $i => $box) {
$bo_items = new BadOrderItem();
$bo_items->bad_order_id = $badOrder->id;
$bo_items->box_id = $box;
$bo_items->no_of_box = $input['no_of_box'][$i];
$bo_items->no_of_packs = $input['no_of_packs'][$i];
$bo_items->amount = $input['amount'][$i];
$bo_items->product_id = Box::find($box)->product->id;
$bo_items->save();
}
return Redirect::action('BadOrderController@index');
}
public function scopeCount($query, $box_id)
{
$count = Box::find($box_id)->instocks->sum('quantity');
return $count == 0 ? 'Out of Stock' : $count;
}
|--------------------------------------------------------------------------
|
| This route group applies the "web" middleware group to every route
| it contains. The "web" middleware group is defined in your HTTP
| kernel and includes session state, CSRF protection, and more.
|
*/
Route::group(['middleware' => ['web']], function () {
// Route::get('/login', function () { return view('login');});
// List all boxes
Route::get('/boxes', function () {
$boxes = Box::orderBy('created_at', 'asc')->get();
return view('box', ['boxes' => $boxes]);
});
// Add new box
Route::post('/boxes', function (Request $request) {
$validator = Validator::make($request->all(), ['name' => 'required|max:255']);
if ($validator->fails()) {
return redirect('/boxes')->withInput()->withErrors($validator);
}
$box = new Box();
$box->name = $request->name;
$box->save();
return redirect('/boxes');
});
// Delete a box
Route::delete('/box/{box}', function (Box $box) {
$box->delete();
return redirect('/boxes');
});
});
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update()
{
$input = Input::all();
$product = Product::find($input['id']);
$rules = array('name' => 'required', 'product_category' => 'required', 'supplier' => 'required');
$validator = Validator::make($input, $rules);
if ($validator->passes()) {
$product->name = $input['name'];
$product->product_category_id = $input['product_category'];
$product->supplier_id = $input['supplier'];
$product->save();
foreach ($input['box'] as $i => $v) {
$box = Box::find($v);
$box->size = $input['size'][$i];
$box->no_of_packs = $input['packs'][$i];
$box->purchase_price = $input['purchase_price'][$i];
$box->selling_price_1 = $input['selling_price_1'][$i];
$box->selling_price_2 = $input['selling_price_2'][$i];
$box->save();
}
if (isset($input['asize'])) {
foreach ($input['asize'] as $i => $v) {
$box = new Box();
$box->product_id = $input['id'];
$box->size = $v;
$box->no_of_packs = $input['apacks'][$i];
$box->purchase_price = $input['apurchase_price'][$i];
$box->selling_price_1 = $input['aselling_price_1'][$i];
$box->selling_price_2 = $input['aselling_price_2'][$i];
$box->save();
}
}
if (isset($input['trash'])) {
Box::destroy($input['trash']);
}
return Redirect::action('ProductController@index');
}
return Redirect::action('ProductController@show', $input['id']);
}
public function test2()
{
return Box::countReturns2(49);
}
