Exemplo n.º 1
0
 /**
  * Store a newly created order in storage.
  *
  * @return Response
  */
 public function store()
 {
     $validation = array('customer' => 'required', 'date' => 'required');
     $validator = Validator::make(Input::all(), $validation);
     if ($validator->fails()) {
         return Redirect::to('orders/create')->withErrors($validator);
     } else {
         $postorder = Input::all();
         $data = array('customer' => $postorder['customer'], 'date' => $postorder['date'], 'total_amount' => $postorder['total_amount'], 'discount' => $postorder['discount'], 'payable_amount' => $postorder['payable_amount'], 'payment' => $postorder['payment'], 'balance' => $postorder['balance']);
         $id = DB::table('orders')->insertGetId($data);
         for ($i = 0; $i < count($postorder['product_id']); $i++) {
             $data_detail = array('product_id' => $postorder['product_id'][$i], 'item' => $postorder['item'][$i], 'quantity' => $postorder['quantity'][$i], 'price' => $postorder['price'][$i], 'amount_charged' => $postorder['amount_charged'][$i], 'Order_id' => $id);
             DB::table('order_details')->insert($data_detail);
             $date = $postorder['date'];
             $location = Location::findOrFail($postorder['location']);
             foreach ($data_detail as $item) {
                 $it = Item::findOrFail($postorder['item'][$i]);
                 $quantity = $postorder['quantity'][$i];
                 Stock::removeStock($it, $location, $quantity, $date);
             }
         }
         return Redirect::route('orders.index')->with('success', 'Item Successfully Added');
     }
 }
Exemplo n.º 2
0
    $order->type = 'sales';
    $order->save();
    foreach ($erporderitems as $item) {
        $itm = Item::findOrFail($item['itemid']);
        $ord = Erporder::findOrFail($order->id);
        $location_id = $item['location'];
        $location = Location::find($location_id);
        $date = date('Y-m-d', strtotime(array_get($erporder, 'date')));
        $orderitem = new Erporderitem();
        $orderitem->erporder()->associate($ord);
        $orderitem->item()->associate($itm);
        $orderitem->price = $item['price'];
        $orderitem->quantity = $item['quantity'];
        $orderitem->duration = $item['duration'];
        $orderitem->save();
        Stock::removeStock($itm, $location, $item['quantity'], $date);
    }
    $tax = Input::get('tax');
    $rate = Input::get('rate');
    for ($i = 0; $i < count($rate); $i++) {
        $txOrder = new TaxOrder();
        $txOrder->tax_id = $rate[$i];
        $txOrder->order_number = array_get($erporder, 'order_number');
        $txOrder->amount = $tax[$i];
        $txOrder->save();
    }
    //Session::flush('orderitems');
    //Session::flush('erporder');
    return Redirect::to('salesorders')->withFlashMessage('Order Successfully Placed!');
});
Route::get('erppurchase/commit', function () {