OpenCart 2通过一个从模型到控制器的变量

Question

中创建了以下代码

public function coupon_test() { 
        $charscode = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ";
        $res = "";
        for ($i = 0; $i < 10; $i++) {
        $res .= $charscode[mt_rand(0, strlen($charscode)-1)];
        }
       $this->db->query("INSERT INTO `" . DB_PREFIX . "coupon` SET name = 'Newsletter coupon', code = '" .$res . "', type = 'P', 
       discount = '10', logged = '0', shipping = '0', total = '0', date_start = CURRENT_DATE(), 
       date_end = DATE_ADD(CURRENT_DATE(), INTERVAL 6 DAY), status = '1', date_added = NOW()");  
               
         
            }

我在模型和控制器

public function Ajaxcallacumba() {
        $this->load->model('total/coupon');
        $this->model_total_coupon->coupon_test();
        
        
    }

，我想要的是从模型中传递变量$ res或从数据库调用代码变量。我该怎么做。

Answer 1

// controller
public function Ajaxcallacumba() {   
  $this->load->model('total/coupon');
  $brand_new_coupon = $this->model_total_coupon->coupon_test();
}

// model
public function coupon_test() { 
  while (true) {
    $charscode = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ";
    $res = "";
    for ($i = 0; $i < 10; $i++) {
      $res .= $charscode[mt_rand(0, strlen($charscode)-1)];
    }
    
    // check coupon code is unique, if yes, then break the loop
  }
        
  $this->db->query("INSERT INTO `" . DB_PREFIX . "coupon` SET name = 'Newsletter coupon', code = '" .$res . "', type = 'P', 
  discount = '10', logged = '0', shipping = '0', total = '0', date_start = CURRENT_DATE(), 
  date_end = DATE_ADD(CURRENT_DATE(), INTERVAL 6 DAY), status = '1', date_added = NOW()");
  
  return $res; // give back the coupon code to controller
}