citywebshop_cms/application/models/factors_model.php

<?php

class factors_model extends Model {
    
    public function get_categories() {
        $result = $this->query("SELECT * FROM products WHERE category<>'' GROUP BY category;");
        if (sizeof($result)>0) {
            return $result;
        }
        else {
            return false;
        }
    }
    
    
    public function save_factor($data) {
        $data = $this->escapeArray($data);
        
        $data['value'] = str_replace(",",".",$data['value']);
        
        if ($this->check_factor($data)) {
            $this->update_factor($data);
        }
        else {
            $this->insert_factor($data);
        }
        
        return true;
    }
    
    
    public function update_factor($data) {
        $this->execute("UPDATE azonics_category_price_factors SET "
                . "factor='".$data['value']."' WHERE id='".$data['id']."';");
        return true;
    }
    
    
    public function insert_factor($data) {
        $this->execute("INSERT INTO azonics_category_price_factors SET "
                . "category='".$data['category']."', "
                . "factor='".$data['value']."', "
                . "status='1';");
        return true;
    }
    
    
    public function check_factor($data) {
        $check = $this->query("SELECT * FROM azonics_category_price_factors WHERE category='".$data['category']."' AND status='1';");
        if (sizeof($check)>0) {
            return true;
        }
        else {
            return false;
        }
    }
    
    
}