<?php
/*
  ###########################################################
  # PRODUCT NAME: 	iRestora PLUS - Next Gen Restaurant POS
  ###########################################################
  # AUTHER:		Doorsoft
  ###########################################################
  # EMAIL:		info@doorsoft.co
  ###########################################################
  # COPYRIGHTS:		RESERVED BY Door Soft
  ###########################################################
  # WEBSITE:		http://www.doorsoft.co
  ###########################################################
  # This is Alert_model Model
  ###########################################################
 */
class Alert_model extends CI_Model {
    /**
     * get alerts
     * @access public
     * @return object
     * @param string
     * @param string
     * @param string
     */
    public function getAlerts($company_id = "") {
        $company_id = $this->session->userdata('company_id');

        //get selected food menu ids
        if($company_id){
            $result = $this->db->query("SELECT * 
                FROM `tbl_emergencies` 
                WHERE `company_id` = ? 
                ORDER BY `id` DESC", array($company_id))->result();
            return $result;
            
        }else{
            $result = $this->db->query("SELECT * 
                FROM `tbl_emergencies`
                ORDER BY `id` DESC", array($company_id))->result();
            return $result;
        }
    }
    
    public function unseenAlerts() {
        $company_id = $this->session->userdata('company_id');

        //get selected food menu ids
        if($company_id){
            $result = $this->db->query("SELECT * 
                FROM `tbl_emergencies` 
                WHERE `company_id` = ?
                AND `status` = ?
                ORDER BY `id` DESC", array($company_id, 0))->result();
            return $result;
            
        }else{
            $result = $this->db->query("SELECT * 
                FROM `tbl_emergencies`
                WHERE `status` = ?
                ORDER BY `id` DESC", array(0))->result();
            return $result;
        }
    }
    
    public function deleteAlert($id){
        $result = $this->db->query("DELETE FROM `tbl_emergencies` 
                WHERE `id` = ?", array($id));
            return $result;
    }
    
    
    public function alertSeen($id){
        $result = $this->db->query("UPDATE `tbl_emergencies` 
        SET `status` = `1` WHERE `id` = ?", array($id))->result();
        return $result;
    }

}

?>