Ejemplo n.º 1
0
 public function updateTotalOrder($orderProductID = 0)
 {
     try {
         if (0 !== $orderProductID) {
             $OrderModel = new Order();
             $OrderProductModel = new OrderProduct();
             $orderProduct = $OrderProductModel->read(null, $orderProductID);
             if (!empty($orderProduct)) {
                 $order = $OrderModel->read(null, $orderProduct["OrderProduct"]["order_id"]);
                 $allProducts = $orderProducts = $OrderProductModel->find('all', array('conditions' => array('OrderProduct.id >=' => 1, 'OrderProduct.order_id' => $orderProduct["OrderProduct"]["order_id"], 'OrderProduct.status' => 'active')));
                 $pSum = 0;
                 $pUnit = 0;
                 $tTax = 0;
                 $tDisc = 0;
                 $tSub = 0;
                 foreach ($allProducts as $value) {
                     $orderProduct = $value["OrderProduct"];
                     $pUnit = $orderProduct["product_price"] * $orderProduct["product_qty"];
                     $pUnit = $pUnit - $pUnit * $orderProduct["product_disc"] / 100;
                     $pUnit = $pUnit + $pUnit * $orderProduct["product_tax"] / 100;
                     $pSum += $pUnit;
                 }
                 $order["Order"]["price"] = $pSum;
                 $order["Order"]["tax"] = 0;
                 $order["Order"]["tax_amt"] = 0;
                 $order["Order"]["subtotal_amt"] = $pSum;
                 $order["Order"]["total_amt"] = $pSum;
                 if (0 < $pSum) {
                     $order["Order"]["status"] = 'pending';
                 }
                 $order["Order"]["disc"] = 0;
                 $order["Order"]["disc_amt"] = 0;
                 $OrderModel->recursive = -1;
                 if (!$OrderModel->save($order["Order"])) {
                     $this->log('No se pudo actualizar el total de la orden');
                     $this->log($OrderModel->validationErrors);
                 }
             }
         }
     } catch (Exception $ex) {
         $this->log('Error al guardar el total de productos a la orden');
         $this->log($ex->getMessage());
     }
 }
Ejemplo n.º 2
0
 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');
     }
 }