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]);
 }
 public function deleteAction($id = false)
 {
     $this->permission('delete');
     if (!$id) {
         return Brightery::error404();
     }
     $commerce_orders = new \modules\commerce\models\Commerce_orders();
     $commerce_orders->commerce_order_id = $id;
     if ($commerce_orders->delete()) {
         Uri_helper::redirect("management/commerce_orders");
     }
 }