/** * Order details * * @access public * @param int $id = Order ID * @return void */ public function action_order($id = false) { \View::set_global('title', 'Order'); \Config::load('order::order', 'order'); // Get current user $user = \Sentry::user(); $user_ids = array($user->id); $master_user = false; if (isset($user['metadata']['master']) && $user['metadata']['master']) { $master_user = true; } // Get all orders from subusers if this is master user if ($master_user) { $user_group = $user->groups(); $user_group = $user_group[0]; $users = \Sentry::group($user_group['id'])->users(); // Reset to empty array if there are no result found by query if (is_null($users)) { $users = array(); } foreach ($users as $subuser) { array_push($user_ids, $subuser['id']); } } // Get order $order = \Order\Model_Order::find(function ($query) use($user_ids, $id) { $query->where('id', $id); $query->and_where('user_id', 'IN', $user_ids); $query->and_where('finished', 1); }); if (!$order) { \Messages::error('Order with that ID does not exist or has been deleted.'); \Response::redirect(\Uri::front_create('user/account/orders')); } // Load order config \Config::load('order::order', 'order'); // Get order products $items = \Order\Model_Products::find(array('where' => array('order_id' => $id))); \Theme::instance()->set_partial('content', $this->view_dir . 'order')->set('items', $items, false)->set('order', $order[0], false)->set('order_status', \Config::get('order.status', array()), false)->set('user', $user, false); }
protected function save_order() { if (!$this->check_logged()) { \Messages::error('You must be logged in if you want to continue with your order.'); \Response::redirect(\Uri::create('order/checkout/address')); } // Save order $user = false; $order = false; $items = \Cart::items(); if (\Sentry::check()) { $user = \Sentry::user(); } if (\Input::post() && $items && $user) { // check for a valid CSRF token if (!\Security::check_token()) { \Messages::error('CSRF attack or expired CSRF token.'); \Response::redirect(\Input::referrer(\Uri::create('order/checkout/cost'))); } try { // Update or create order if (is_numeric(\Session::get('order.id'))) { $order = \Order\Model_Order::find_one_by_id(\Session::get('order.id')); } if (!$order) { $order = \Order\Model_Order::forge(); } $cart_total = 0; foreach ($items as $item) { $product_data = null; if ($product = \Product\Model_Product::find_one_by_id($item->get('id'))) { $product_data = \Product\Model_Product::product_data($product, $item->get('attributes')); } $total_price = $item->totalDiscountedPrice(true); if (isset($product_data["price"]) && $product_data["price"] != 0) { $total_price = $product_data["price"] * $item->get('quantity'); } $cart_total += $total_price; } $method = \Input::post('delivery') == 'pickup' ? false : true; $shipping_price = $order->shipping_price(null, null, true, $method); $metadata = $user['metadata']; $data = array('email' => $user->get('email'), 'user_id' => $user->get('id'), 'status' => 'Pending', 'total_price' => $cart_total, 'finished' => 1, 'guest' => $metadata['guest'] ? 1 : 0, 'accepted' => $metadata['master'] == 1 ? 1 : 0, 'credit_account' => $metadata['credit_account'] == 1 ? 1 : 0, 'shipping_method' => \Input::post('delivery'), 'shipping_price' => $shipping_price, 'gst_price' => ($cart_total + $shipping_price) * 0.1); // $order->discount_amount = $item_with_discount['total_discount'];//\Cart::getTotal('price'); //\Cart::getDiscountedTotal('price');//\Cart::getTotal('price'); if ($billing = \Arr::filter_prefixed($metadata, 'shipping_')) { foreach ($billing as $key => $value) { $data[$key] = $metadata[$key]; unset($metadata[$key]); } } foreach ($metadata as $key => $value) { $data[$key] = $value; } $order->set($data); // Save order, add products to order products if ($order->save()) { foreach ($items as $item) { $product_data = null; if ($product = \Product\Model_Product::find_one_by_id($item->get('id'))) { $product_data = \Product\Model_Product::product_data($product, $item->get('attributes')); } $item_exists = \Order\Model_Products::find(array('where' => array('product_id' => $product->id, 'order_id' => $order->id))); if ($product_data && !$item_exists) { $order_products = \Order\Model_Products::forge(array('order_id' => $order->id, 'title' => $product->title, 'code' => $product_data['code'], 'price' => $product_data['price'], 'price_type' => $product_data['price_type'], 'quantity' => $item->get('quantity'), 'product_id' => $product->id, 'artwork_required' => $product->artwork_required, 'artwork_free_over' => $product->artwork_free_over, 'subtotal' => $product_data['price'] * $item->get('quantity'), 'attributes' => json_encode(\Product\Model_Attribute::get_combination($item->get('attributes'))), 'attributes_id' => $item->get('attributes'))); //$item->singleDiscountedPrice(true);//$item->singlePrice(true); //$item->totalDiscountedPrice(true);//$item->totalPrice(true); if (!empty($product->categories)) { $categories = array(); foreach ($product->categories as $category) { $categories[] = $category->title; } if ($categories) { $order_products->product_category = implode(',', $categories); } } // update stock quantity \Product\Model_Attribute::update_stock_quantity($item->get('attributes'), $item->get('quantity')); $order_products->save(); // Find artworks if ($unique_id = $item->get('unique_id')) { if ($artworks = \Order\Model_Artwork::find(array('where' => array('unique_id' => $unique_id, 'order_id' => $order->id)))) { $ysi = \Yousendit\Base::forge(); // Artworks (update, delete) foreach ($artworks as $artwork) { // Remove deleted artwork if ($artwork->deleted_at > 0) { $ysi->delete_artwork($artwork->file_id); $artwork->delete(); } else { $artwork->set(array('order_product_id' => $order_products->id)); $artwork->save(); } } } } } } } if ($order) { return $order; } else { return false; } } catch (\Database_Exception $e) { // show validation errors \Messages::error('There was an error while trying to save your order.'); // Uncomment lines below to show database errors $errors = $e->getMessage(); \Messages::error($errors); \Response::redirect(\Uri::create('order/checkout/cost')); } return false; } }
protected function save_order($user) { $order = false; try { // Update or create order if (is_numeric(\Session::get('admin_order.id'))) { $order = \Order\Model_Order::find_one_by_id(\Session::get('admin_order.id')); } if (!$order) { $order = \Order\Model_Order::forge(); } $data = array('user_id' => $user->id, 'status' => \Input::post('status'), 'title' => $user->get('metadata.title'), 'first_name' => $user->get('metadata.first_name'), 'last_name' => $user->get('metadata.last_name'), 'company' => $user->get('metadata.company'), 'address' => $user->get('metadata.address'), 'address2' => null, 'suburb' => $user->get('metadata.suburb'), 'postcode' => $user->get('metadata.postcode'), 'country' => $user->get('metadata.country'), 'state' => $user->get('metadata.state'), 'phone' => $user->get('metadata.phone'), 'email' => $user->get('email'), 'guest' => 1, 'total_price' => \Input::post('products_total_hidden'), 'discount_amount' => \Input::post('discount_hidden'), 'shipping_method' => null, 'shipping_price' => \Input::post('shipping_hidden'), 'gst_price' => \Input::post('gst_amount_hidden'), 'finished' => 1, 'accepted' => 0, 'credit_account' => 0); $order->set($data); $product_id = \Input::post('product_id'); $product_quantity = \Input::post('product_quantity'); $product_price = \Input::post('product_price'); // Save order, add products to order products if ($order->save()) { foreach ($product_id as $key => $item) { $product_data = null; if ($product = \Product\Model_Product::find_one_by_id($item)) { $product_data = \Product\Model_Product::product_data($product, null); } $item_exists = \Order\Model_Products::find(array('where' => array('product_id' => $product->id, 'order_id' => $order->id))); if ($product_data && !$item_exists) { $order_products = \Order\Model_Products::forge(array('order_id' => $order->id, 'title' => $product->title, 'code' => $product_data['code'], 'price' => $product_data['price'], 'price_type' => $product_data['price_type'], 'quantity' => $product_quantity[$key], 'product_id' => $product->id, 'artwork_required' => $product->artwork_required, 'artwork_free_over' => $product->artwork_free_over, 'subtotal' => $product_price[$key] * $product_quantity[$key], 'attributes' => json_encode(\Product\Model_Attribute::get_combination(0)))); if (!empty($product->categories)) { $categories = array(); foreach ($product->categories as $category) { $categories[] = $category->title; } if ($categories) { $order_products->product_category = implode(',', $categories); } } // update stock quantity \Product\Model_Attribute::update_stock_quantity(0, $product_quantity[$key]); $order_products->save(); } } } if ($order) { return $order; } else { return false; } } catch (\Database_Exception $e) { // show validation errors \Messages::error('There was an error while trying to save your order.'); // Uncomment lines below to show database errors $errors = $e->getMessage(); \Messages::error($errors); \Response::redirect(\Uri::create('admin/order/create')); } return false; }