public function manageAction($id = false)
 {
     if ($id) {
         $this->permission('edit');
     } else {
         $this->permission('add');
     }
     $commerce_orders = new \modules\commerce\models\Commerce_orders();
     if ($_POST) {
         $commerce_orders->attributes = ['subtotal' => $this->input->post('subtotal'), 'total' => $this->input->post('total'), 'commerce_payment_method_id' => $this->input->post('commerce_payment_method_id'), 'user_id' => $this->input->post('user_id'), 'billing_address' => $this->input->post('billing_address'), 'shipping_address' => $this->input->post('shipping_address')];
     }
     if ($id) {
         $commerce_orders->commerce_order_id = $id;
     }
     if (!$id) {
         $commerce_orders->created = date("Y-m-d H:i:s");
     }
     $users = Form_helper::queryToDropdown('users', 'user_id', 'fullname');
     $paymet_method = Form_helper::queryToDropdown('commerce_payment_method', 'commerce_payment_method_id', 'name');
     if ($commerce_orders->save()) {
         Uri_helper::redirect("management/commerce_orders");
     } else {
         return $this->render('commerce_orders/manage', ['item' => $commerce_orders->get(), 'users' => $users, 'payment_method' => $paymet_method]);
     }
 }
 public function my_ordersAction()
 {
     $commerce_orders = new \modules\commerce\models\Commerce_orders();
     $commerce_order_details = new \modules\commerce\models\Commerce_order_details();
     $orders_products = new \modules\commerce\models\Commerce_products();
     $commerce_orders->_select = "commerce_order_id, subtotal, total, commerce_payment_method_id, billing_address, shipping_address, created ";
     $commerce_orders->user_id = $this->user->user_id;
     $commerce_orders->status = 'confirmed';
     $payment_method = $this->Database->query("SELECT `commerce_payment_method`.`name`" . "FROM `commerce_orders` " . "JOIN `commerce_payment_method` ON `commerce_payment_method`.`commerce_payment_method_id`=`commerce_orders`.`commerce_payment_method_id`" . "")->row();
     return $this->render('commerce_orders/checkout', ['orders' => $commerce_orders->get(), 'order_details' => $commerce_order_details, 'products' => $orders_products, 'payment' => $payment_method]);
 }