Viewing file:  da_sa_person.php (3.18 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include_once("sa_model.php");
class Da_sa_person extends Sa_model {
// PK is prs_id
public $prs_id;
public $prs_code;
public $prs_name;
public $prs_surname;
public $prs_name_eng;
public $prs_surname_eng;
public $prs_pf_id;
public $prs_pf_name;
public $prs_type;
public $prs_type_name;
public $prs_sst_id;
public $prs_sst_name;
public $prs_it_id;
public $psr_it_name;
public $prs_org_id;
public $prs_org_name;
public $prs_position;
public $prs_email;
public $prs_contact_address;
public $prs_contact_phone;
public $prs_picture_path;
public $last_insert_id;
function Da_sa_person() {
parent::__construct();
$this->load->database('esa',TRUE);
}
function insert() {
// if there is no auto_increment field, please remove it
$sql = "INSERT INTO sa_person (prs_id, prs_code, prs_name, prs_surname, prs_name_eng, prs_surname_eng, prs_pf_id, prs_pf_name, prs_type, prs_type_name, prs_sst_id, prs_sst_name, prs_it_id, psr_it_name, prs_org_id, prs_org_name, prs_position, prs_email, prs_contact_address, prs_contact_phone, prs_picture_path)
VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$this->db->query($sql, array($this->prs_id, $this->prs_code, $this->prs_name, $this->prs_surname, $this->prs_name_eng, $this->prs_surname_eng, $this->prs_pf_id, $this->prs_pf_name, $this->prs_type, $this->prs_type_name, $this->prs_sst_id, $this->prs_sst_name, $this->prs_it_id, $this->psr_it_name, $this->prs_org_id, $this->prs_org_name, $this->prs_position, $this->prs_email, $this->prs_contact_address, $this->prs_contact_phone, $this->prs_picture_path));
$this->last_insert_id = $this->db->insert_id();
}
function update() {
// if there is no primary key, please remove WHERE clause.
$sql = "UPDATE sa_person
SET prs_code=?, prs_name=?, prs_surname=?, prs_name_eng=?, prs_surname_eng=?, prs_pf_id=?, prs_pf_name=?, prs_type=?, prs_type_name=?, prs_sst_id=?, prs_sst_name=?, prs_it_id=?, psr_it_name=?, prs_org_id=?, prs_org_name=?, prs_position=?, prs_email=?, prs_contact_address=?, prs_contact_phone=?, prs_picture_path=?
WHERE prs_id=?";
$this->db->query($sql, array($this->prs_code, $this->prs_name, $this->prs_surname, $this->prs_name_eng, $this->prs_surname_eng, $this->prs_pf_id, $this->prs_pf_name, $this->prs_type, $this->prs_type_name, $this->prs_sst_id, $this->prs_sst_name, $this->prs_it_id, $this->psr_it_name, $this->prs_org_id, $this->prs_org_name, $this->prs_position, $this->prs_email, $this->prs_contact_address, $this->prs_contact_phone, $this->prs_picture_path, $this->prs_id));
}
function delete() {
// if there is no primary key, please remove WHERE clause.
$sql = "DELETE FROM sa_person
WHERE prs_id=?";
$this->db->query($sql, array($this->prs_id));
}
/*
* You have to assign primary key value before call this function.
*/
function get_by_key($withSetAttributeValue=FALSE) {
$sql = "SELECT *
FROM sa_person
WHERE prs_id=?";
$query = $this->db->query($sql, array($this->prs_id));
if ( $withSetAttributeValue ) {
$this->row2attribute( $query->row() );
} else {
return $query ;
}
}
} //=== end class Da_sa_person
?>
|