Gecko [ v3.cesa.co.za ]

Linux cesa-www-main 6.1.0-49-cloud-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.174-1 (2026-05-26) x86_64
Apache/2.4.68 (Debian)
Server IP : 10.218.0.2 & Your IP : 216.73.216.28
Domains : Cant Read [ /etc/named.conf ]
User : www-data

Name	Size	Permission	Date	Action
KZNRelay_model.php	1.12 KB	-rw-r--r--	2017-06-28 10:37
index.html	131 B	-rw-r--r--	2017-06-28 08:50

Rename

<?php
class KZNRelay_model extends CI_Model {

public function __construct()
        {
                $this->load->database();
        }

public function get_companies($CompanyID = FALSE)
{
        if ($CompanyID === FALSE)
        {
                $query = $this->db->query('SELECT * FROM RelayCompanies ORDER BY CompanyName, DateCreated');
                return $query->result_array();
        }

$query = $this->db->get_where('RelayCompanies', array('RelayCompanyID' => $CompanyID));
        return $query->row_array();
}

public function get_events($CompanyID)
{
	$query = $this->db->query('SELECT * FROM RelayEvents, RelayCompanyEvents WHERE RelayEvents.RelayEventID=RelayCompanyEvents.RelayEventID AND RelayCompanyEvents.RelayCompanyID='.$CompanyID.' ORDER BY RelayEvents.DisplayOrder');
	return $query->result_array();
}

public function get_other($CompanyID)
{
	$query = $this->db->query('SELECT * FROM RelayOther, RelayCompanyOther WHERE RelayOther.RelayOtherID=RelayCompanyOther.RelayOtherID AND RelayCompanyOther.RelayCompanyID='.$CompanyID.' ORDER BY RelayOther.DisplayOrder');
	return $query->result_array();
}

}