public function get_invoice()
{
$id = Request::segment(3);
$order = Order::find($id);
if ($order) {
if ($order->user_id == Auth::user()->id && ($order->status = 'Delivered')) {
$user = User::find($order->user_id);
$products = OrderProduct::where('order_id', $order->id)->where(function ($query) {
$query->where('fulfilment_status', 'Fullfilled')->orWhere('fulfilment_status', 'Replacement');
})->get();
return View::make('invoice')->with('user', $user)->with('order', $order)->with('products', $products);
}
}
}
public function update_order_product()
{
$id = Input::get('id');
$order_product = OrderProduct::find($id);
if ($order_product) {
$order_id = $order_product->order_id;
$store_id = $order_product->store_id;
if (Input::has('quantity') && !Input::has('product_name')) {
$order_product->quantity = Input::get('quantity');
}
if (Input::has('price') && !Input::has('product_name')) {
$order_product->price = Input::get('price');
}
if (Input::has('status') && !Input::has('product_name')) {
$order_product->fulfilment_status = Input::get('status');
}
if (Input::has('product_name')) {
$order_product->fulfilment_status = 'Replacement';
$order_product->save();
$order_product = new OrderProduct();
$order_product->order_id = $order_id;
$order_product->price = Input::get('price');
$order_product->quantity = Input::get('quantity');
$order_product->fulfilment_status = 'Fullfilled';
$order_product->type = 'Replacement';
$order_product->parent_id = $id;
$order_product->product_name = Input::get('product_name');
$image = Input::file('product_image_url');
$validator = Validator::make(array('ima' => $image), array('ima' => 'required|mimes:jpeg,bmp,png'));
if ($validator->fails()) {
$error_messages = $validator->messages();
$response_array = array('success' => false, 'error' => 'Invalid Input', 'error_code' => 401);
$response_code = 200;
$message = "Invalid Input File";
$type = "failed";
return Redirect::to('/admin/order/' . $order_id . '/details')->with('type', $type)->with('message', $message);
} else {
if (Input::hasFile('product_image_url')) {
$order_product->product_image_url = upload_image(Input::file('product_image_url'));
}
$order_product->product_quantity = Input::get('product_quantity');
$order_product->product_unit = Input::get('product_unit');
$order_product->store_id = $store_id;
}
$order_product->save();
}
// update order data
$products = OrderProduct::where('order_id', $order_id)->where('fulfilment_status', 'Fullfilled')->get();
$total_products = 0;
$total_amount = 0.0;
foreach ($products as $product) {
$total_products++;
$total_amount = $total_amount + $product->quantity * $product->price;
echo $total_amount;
}
$order = Order::find($order_id);
$order->total_products = $total_products;
$order->total_amount = $total_amount;
$order->save();
return Redirect::to('/admin/order/' . $order_id . '/details');
}
}
public function finalize_delivery()
{
$id1 = Input::get('orderID');
$id2 = Input::get('deliverID');
$orderproducts = OrderProduct::where('strOPOrdersID', '=', $id1)->get();
$a = 1;
$b = 1;
foreach ($orderproducts as $orderproduct) {
$details = DeliveryDetail::create(array('strDetID' => $id2, 'strDetProdID' => $orderproduct->strOPProdID, 'intDetQty' => $orderproduct->intOPQuantity));
$details->save();
$ids = DB::table('tblInventory')->select('strBatchID')->orderBy('strBatchID', 'desc')->take(1)->get();
$ID = $ids["0"]->strBatchID;
$newID = $this->smart($ID);
$inv = Inventory::create(array('strBatchID' => $newID, 'strProdID' => $orderproduct->strOPProdID, 'strDlvryID' => $id2, 'intAvailQty' => $orderproduct->intOPQuantity, 'dblCurRetPrice' => Input::get($b + 'Rprice'), 'dblCurWPrice' => Input::get($a + 'Wprice')));
$inv->save();
$a++;
$b++;
}
$notesID = $id1;
$notes = OrderNotes::find($notesID);
$notes->strOrdNotesStat = "Accepted";
$notes->save();
return Redirect::to('/delivery');
}
