File: /home/clientsoftwares/public_html/multirest.clientsoftwares.com/application/models/Order_model.php
<?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 Order_model Model
###########################################################
*/
class Order_model extends CI_Model {
/**
* get All By Table
* @access public
* @return object
* @param string
*/
public function getAllByTable($table_name) {
$result = $this->db->query("SELECT *
FROM $table_name
WHERE del_status = 'Live'
ORDER BY id DESC")->result();
return $result;
}
/**
* get Info By ID
* @access public
* @return object
* @param string
*/
public function getInfoByID($table_name) {
$result = $this->db->query("SELECT *
FROM $table_name
WHERE del_status = 'Live'
ORDER BY id DESC")->row();
return $result;
}
/**
* get Menu By Menu Name
* @access public
* @return object
* @param string
*/
public function getMenuByMenuName($menu_name){
$this->db->select("*");
$this->db->from('tbl_food_menus');
$this->db->where("tbl_food_menus.name", $menu_name);
$this->db->order_by('id', 'ASC');
return $this->db->get()->row();
}
}
?>