public function action_order() { define("SECONDS_PER_DAY", 3600 * 24); $now = time(); $cart = Session::get('cart'); $user = Model_User::find($this->sessUser->id); $cart_info = []; $order = Model_Order::forge(); $order->user_id = $user->id; $order->created_at = $now; $order->save(); if (!is_null($cart)) { foreach ($cart as $product_id => $quantity) { $product = Model_Product::find($product_id); $order_product = Model_OrderProduct::forge(); $order_product->order_id = $order->id; $order_product->product_id = $product->id; $order_product->quantity = $quantity; $order_product->price = $product->price; $order_product->save(); } } Session::delete('cart'); return Response::redirect('/cart'); }
public function action_orderDetails($order_id) { $order_info = []; $order_details = Model_OrderProduct::find('all', array('where' => array(['order_id', $order_id]))); foreach ($order_details as $order_detail) { $product = Model_Product::find($order_detail->product_id); $order_info[] = (object) ['id' => $product->id, 'name' => $product->name, 'price' => $product->price, 'quantity' => $order_detail->quantity]; } $data = ['order_info' => $order_info, 'order_id' => $order_id, 'message' => Session::get_flash('message'), 'remove_sure' => Session::get_flash('remove_sure')]; return Response::forge(View::forge('user/orderDetails.tpl', $data)); }
public static function initDB() { self::$USER_TABLE = Model_User::table(); self::$PRODUCT_TABLE = Model_Product::table(); self::$ORDER_TABLE = Model_Order::table(); self::$JOIN_TABLE = Model_OrderProduct::table(); self::$CATEGORY_TABLE = Model_Category::table(); Config::load('development/db.php'); $which = Config::get('which'); echo "\nwhich = {$which}\n"; if ($which == "sqlite") { self::initSQLite(); } $dsn = Config::get('default.connection.dsn'); $username = Config::get('default.connection.username'); $password = Config::get('default.connection.password'); $cx = new PDO($dsn, $username, $password); self::dropAll($cx); self::createTables($cx, $which); }
public function action_removeOrder() { $order_id = Input::post('order_id'); $remove_sure = Input::post('remove_sure'); $order = Model_Order::find($order_id); print_r($order); $product_orders = Model_OrderProduct::find('all', array('where' => array('order_id' => $order_id))); if (is_null($order)) { return Response::redirect("/"); } if ($remove_sure !== "yes") { Session::set_flash('remove_sure', 'yes'); Session::set_flash('message', 'Are you sure? If so press remove again'); return Response::redirect("/user/orderDetails/{$order_id}"); } foreach ($product_orders as $product_order) { $product_order->delete(); } $order->delete(); return Response::redirect("/admin/viewAllOrders"); }