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");
}
