Viewing file: sa_committee_model.php (5.65 KB) -rwxr-xr-x Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include_once("da_sa_committee.php");
class Sa_committee_model extends Da_sa_committee {
/*
* aOrderBy = array('fieldname' => 'ASC|DESC', ... )
*/
function get_all($aOrderBy=""){
$orderBy = "";
if ( is_array($aOrderBy) ) {
$orderBy.= "ORDER BY ";
foreach ($aOrderBy as $key => $value) {
$orderBy.= "$key $value, ";
}
$orderBy = substr($orderBy, 0, strlen($orderBy)-2);
}
$sql = "SELECT *
FROM $this->sa_dbname.sa_committee
$orderBy";
$query = $this->db->query($sql);
return $query;
}
/*
* create array of pk field and value for generate select list in view, must edit PK_FIELD and FIELD_NAME manually
* the first line of select list is '-----เลือก-----' by default.
* if you do not need the first list of select list is '-----เลือก-----', please pass $optional parameter to other values.
* you can delete this function if it not necessary.
*/
function get_options($optional='y') {
$qry = $this->get_all();
if ($optional=='y') $opt[''] = '-----เลือก-----';
foreach ($qry->result() as $row) {
$opt[$row->PK_FIELD] = $row->FIELD_NAME;
}
return $opt;
}
// add your functions here
function get_by_cl(){
$sql = "SELECT *
FROM $this->sa_dbname.sa_committee
left join $this->sa_dbname.sa_position ON cmt_pos_id = pos_id
left join $this->sa_dbname.sa_smo_club ON cmt_sc_id = sc_id
left join $this->rg_dbname.rg_Student ON cmt_std_id = stdId
ORDER BY cmt_year,cmt_pos_id";
$query = $this->db->query($sql,$this->cmt->cmt_sc_id);
return $query;
}
function get_by_type($type){
$sql = "SELECT *
FROM $this->sa_dbname.sa_committee
left join $this->sa_dbname.sa_position ON cmt_pos_id = pos_id
left join $this->sa_dbname.sa_smo_club ON cmt_sc_id = sc_id
left join $this->rg_dbname.rg_Student ON cmt_std_id = stdId
WHERE pos_type = $type
ORDER BY cmt_year,pos_seq";
$query = $this->db->query($sql,array($this->cmt->cmt_sc_id));
return $query;
}
function get_by_type_year($type,$year){
$sql = "SELECT *
FROM $this->sa_dbname.sa_committee
left join $this->sa_dbname.sa_position ON cmt_pos_id = pos_id
left join $this->sa_dbname.sa_smo_club ON cmt_sc_id = sc_id
left join $this->rg_dbname.rg_Student ON cmt_std_id = stdId
WHERE pos_type = $type and cmt_year = $year
ORDER BY cmt_year,pos_seq";
$query = $this->db->query($sql);
return $query;
}
function get_by_type_year_cl($type,$year,$cmt_sc_id){
$sql = "SELECT *
FROM $this->sa_dbname.sa_committee
left join $this->sa_dbname.sa_position ON cmt_pos_id = pos_id
left join $this->sa_dbname.sa_smo_club ON cmt_sc_id = sc_id
left join $this->rg_dbname.rg_Student ON cmt_std_id = stdId
WHERE pos_type = $type and cmt_year = $year and cmt_sc_id =$cmt_sc_id
ORDER BY cmt_year,pos_seq";
$query = $this->db->query($sql);
return $query;
}
function get_edit(){
$sql = "SELECT *
FROM $this->sa_dbname.sa_committee
left join $this->sa_dbname.sa_position ON cmt_pos_id = pos_id
left join $this->sa_dbname.sa_smo_club ON cmt_sc_id = sc_id
left join $this->rg_dbname.rg_Student ON cmt_std_id = stdId
WHERE cmt_id = ?";
$query = $this->db->query($sql,array($this->cmt_id));
return $query;
}
function getByCmt_sc_id(){
$sql = "SELECT *
FROM sa_committee
WHERE cmt_sc_id=?";
$query = $this->db->query($sql, array($this->cmt_sc_id));
return $query ;
}
function getByYearAndPos(){
$sql = "SELECT *
FROM sa_committee
WHERE cmt_year=? and cmt_pos_id=?";
$query = $this->db->query($sql, array($this->cmt_year,$this->cmt_pos_id));
return $query ;
}
function getByYearAndPosAndCl(){
$sql = "SELECT *
FROM sa_committee
WHERE cmt_year=? and cmt_sc_id=? and cmt_pos_id=?";
$query = $this->db->query($sql, array($this->cmt_year,$this->cmt_sc_id,$this->cmt_pos_id));
return $query ;
}
function rs_cmt(){
$con = '';
$con.=($this->cmt_year!='')?" AND cmt_year = $this->cmt_year ":'';
$con.=($this->cmt_sc_id!='')?" AND cmt_sc_id = $this->cmt_sc_id ":'';
$con.=($this->cmt_std_id!='')?" AND cmt_std_id = $this->cmt_std_id ":'';
$con.=($this->cmt_pos_id!='')?" AND cmt_pos_id = $this->cmt_pos_id ":'';
$sql = "SELECT *, s.sc_name as sc_name , p.sc_name as psc_name
FROM $this->sa_dbname.sa_position
left join $this->sa_dbname.sa_committee ON cmt_pos_id = pos_id
left join $this->sa_dbname.sa_smo_club as s ON cmt_sc_id = s.sc_id
inner join $this->rg_dbname.rg_Student ON cmt_std_id = stdId
left join $this->sa_dbname.sa_smo_club as p ON s.sc_parentId = p.sc_id
WHERE 1=1
$con
ORDER BY cmt_year, cmt_sc_id, pos_seq";
$query = $this->db->query($sql);
return $query ;
}
function chk_std() {
$sql = "
SELECT * FROM $this->sa_dbname.sa_committee WHERE cmt_std_id = ? AND cmt_sc_id = ?
";
$query = $this->db->query($sql,array($this->cmt_std_id, $this->cmt_sc_id));
return $query;
}
function chk_pos() {
$sql = "
SELECT * FROM $this->sa_dbname.sa_committee WHERE cmt_year = ? AND cmt_std_id = ? AND cmt_sc_id = ?
";
$query = $this->db->query($sql,array($this->cmt_year, $this->cmt_std_id, $this->cmt_sc_id));
return $query;
}
} // end class Sa_committee_model
/*
*/
?>
|