Viewing file:  da_personout.php (2.47 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include_once("ppc_model.php");
class Da_personout extends Ppc_model {
// PK is psoutId
public $psoutId;
public $outtypeId;
public $accountNo;
public $taxId;
public $partyId;
public $address;
public $phone;
public $prefixId;
public $workPhone;
public $fName;
public $lName;
public $levelId;
public $degreeId;
public $edumajorId;
public $experience;
public $last_insert_id;
function Da_personout() {
parent::__construct();
$this->load->database('ppc',TRUE);
}
function insert() {
// if there is no auto_increment field, please remove it
$sql = "INSERT INTO $this->ppc_dbname.Personout (psoutId, outtypeId, accountNo, taxId, partyId, address, phone, prefixId, workPhone, fName, lName, levelId, degreeId, edumajorId, experience)
VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$this->db->query($sql, array($this->psoutId, $this->outtypeId, $this->accountNo, $this->taxId, $this->partyId, $this->address, $this->phone, $this->prefixId, $this->workPhone, $this->fName, $this->lName, $this->levelId, $this->degreeId, $this->edumajorId, $this->experience));
$this->last_insert_id = $this->db->insert_id();
}
function update() {
// if there is no primary key, please remove WHERE clause.
$sql = "UPDATE $this->ppc_dbname.Personout
SET outtypeId=?, accountNo=?, taxId=?, partyId=?, address=?, phone=?, prefixId=?, workPhone=?, fName=?, lName=?, levelId=?, degreeId=?, edumajorId=?, experience=?
WHERE psoutId=?";
$this->db->query($sql, array($this->outtypeId, $this->accountNo, $this->taxId, $this->partyId, $this->address, $this->phone, $this->prefixId, $this->workPhone, $this->fName, $this->lName, $this->levelId, $this->degreeId, $this->edumajorId, $this->experience, $this->psoutId));
}
function delete() {
// if there is no primary key, please remove WHERE clause.
$sql = "DELETE FROM $this->ppc_dbname.Personout
WHERE psoutId=?";
$this->db->query($sql, array($this->psoutId));
}
/*
* You have to assign primary key value before call this function.
*/
function get_by_key($withSetAttributeValue=FALSE) {
$sql = "SELECT *
FROM $this->ppc_dbname.Personout
WHERE psoutId=?";
$query = $this->db->query($sql, array($this->psoutId));
if ( $withSetAttributeValue ) {
$this->row2attribute( $query->row() );
} else {
return $query ;
}
}
function last_insert_id(){
return $this->db->insert_id();
}
} //=== end class Da_personout
?>
|