<?php defined('BASEPATH') OR exit('No direct script access allowed');
class SettingsModel extends CI_Model {
    /**
     * @vars
     */
    private $_db;

    /**
     * Constructor
     */
    function __construct() {
        parent::__construct();
        // define primary table
        $this->_db = 'settings';
    }

    /**
     * Retrieve all settings
     *
     * @return array|null
     */
    function get_settings() {
        $results = NULL;
        $sql = "
        SELECT *
        FROM {$this->_db}
        ORDER BY sort_order ASC
        ";
        $query = $this->db->query($sql);
        if ($query->num_rows() > 0) {
            $results = $query->result_array();
        }
        return $results;
    }

    function get_country_code() {
        return $this->db->select('name as country_name, currency as currency_code')->get('countries')->result();
    }

    /**
     * Save changes to the settings
     *
     * @param  array $data
     * @param  int $user_id
     * @return boolean
     */
    function save_settings($data = array(), $user_id = NULL) {
        if ($data && $user_id) {
            $saved = FALSE;
            foreach ($data as $key => $value) {
                $sql = "
                UPDATE {$this->_db}
                SET value = " . ((is_array($value)) ? $this->db->escape(serialize($value)) : $this->db->escape($value)) . ",
                last_update = '" . date('Y-m-d H:i:s') . "',
                updated_by = " . $this->db->escape($user_id) . "
                WHERE name = " . $this->db->escape($key) . "
                ";
                $this->db->query($sql);
                if ($this->db->affected_rows() > 0) {
                    $saved = TRUE;
                }
            }
            if ($saved) {
                return TRUE;
            }
        }
        return FALSE;
    }

    function all_lang_list()
    {
        return $this->db->get('language')->result();
    }

    function update_lang_options($lang_array)
    {
        $this->db->set('options',$lang_array)->where('id', 30)->update('settings');
        return $this->db->affected_rows();    
    }

}