<?php
class Appconfig extends CI_Model
{
	public function isAppvalid(){
		if(($this->get('address') === "") || ($this->get('city') === "") || ($this->get('company') === "") || ($this->get('country') === "") || ($this->get('phone') === "") || ($this->get('pincode') === "")){
			return false;
		}
		return true;
	}
	public function exists($key)
	{
		$this->db->from('app_config');
		$this->db->where('app_config.key', $key);
		$this->db->where('shop_id',$this->session->userdata('shop_id'));
		return ($this->db->get()->num_rows() == 1);
	}
	public function get_state() {
		$this->db->from('state');
		$this->db->order_by('state_name', 'asc');
		return $this->db->get();
	}
	public function get_all()
	{
		$this->db->from('app_config');
		$this->db->where('shop_id',$this->session->userdata('shop_id'));
		$this->db->order_by('key', 'asc');

		return $this->db->get();
	}

	public function get($key)
	{
		$query = $this->db->get_where('app_config',
					array('key' => $key,'shop_id' =>$this->session->userdata('shop_id')), 1);
		if($query->num_rows() == 1)
		{
			return $query->row()->value;
		}
		return '';
	}

	public function save($key, $value)
	{

		$config_data = array(
			'key'   => $key,
			'value' => $value,
			'shop_id' =>$this->session->userdata('shop_id')
		);

		if(!$this->exists($key))
		{
			return $this->db->insert('app_config', $config_data);
		}

		$this->db->where('key', $key);
		$this->db->where('shop_id',$this->session->userdata('shop_id'));

		return $this->db->update('app_config', $config_data);
	}

	public function batch_save($data)
	{
		$success = TRUE;

		//Run these queries as a transaction, we want to make sure we do all or nothing
		$this->db->trans_start();

		foreach($data as $key=>$value)
		{
			$success &= $this->save($key, $value);
		}

		$this->db->trans_complete();

		$success &= $this->db->trans_status();

		return $success;
	}

	public function delete($key)
	{
		return $this->db->delete('app_config', array('key' => $key));
	}

	public function delete_all()
	{
		return $this->db->empty_table('app_config');
	}
}
?>