Ka Extensions

TraitDBFilter

Impelemnts the ability to adjust plain SQL queries of standard Opencart classes. It might be helpful if you don't want to insert SQL patches to the code directly.

Once the trait is used it adds setFilter/removeFilter methods to the standard DB class.

How to use:

  1. You need to attach the trait in a model/controller class.
  2. Create a function that will receive parameters: $sql string and $data array
  3. set the filter before calling the original function and remove the filter after that.

Here is an example:


class ModelCatalogDownload extends \ModelCatalogDownload {

use \extension\ka_extensions\TraitDBFilter;

public function getDownloads($data = array()) {

$this->db->setFilter([$this, 'getDownloadsDBFilter'], $data);
$result = parent::getDownloads();
$this->db->removeFilter();

return $result;
}

public function getDownloadsDBFilter($sql, $data) {

if (!isset($data['filter_vendor_id'])) {
return $sql;
}

$vendor_id = (int)$data['filter_vendor_id'];

$sql = str_replace(') WHERE ',
") WHERE vendor_id = $vendor_id AND ",
$sql
);

return $sql;
}
}

Table of Contents 


        

        
    




    

    

                                

                

                                
    

        On this page

        
    
            
  • Table Of Contents
    • 
            
  • 
                
      
                                                                            
    
            
    • 
                                            

    


                

                            

            

    

        

            
Search results