I've managed to make an extension for cashback feature in my opencart 3.0.3.2 .I've added the sql for creating a table in model , which i've executed(refer code please) through install() from controller.But in the front end while testing it says the table is not created. Please check and tell if I need any other additional requirements to be met. I've attached the code below.
<?php
model
class ModelExtensionCmsCashback extends Model {
public function install() {
$this->db->query("CREATE TABLE IF NOT EXISTS `" . DB_PREFIX . "product_cashback` ( `cashback_id` INT NOT NULL AUTO_INCREMENT , `product_id` INT NULL , `status` TINYINT NOT NULL DEFAULT '1' , PRIMARY KEY (`cashback_id`)) ENGINE = InnoDB;");
}
public function uninstall() {
$this->db->query("DROP TABLE IF EXISTS `" . DB_PREFIX . "product_cashback`");
}
}
<?php
class ControllerExtensionModuleCashback extends Controller {
private $error = array();
public function index() {}
public function validate() {}
public function install() {
$this->load->model('extension/cms/cashback');
$this->model_extension_cms_cashback->install();
}
public function uninstall() {
$this->load->model('extension/cms/cashback');
$this->model_extension_cms_cashback->uninstall();
}
}
