Viewing file:  da_ea_AlumniQn.php (3.54 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include_once("my_ea_model.php");
class Da_ea_alumniqn extends My_ea_model {
// PK is aqQnId
public $aqQnId;
public $aqAlumniId;
public $aqStateQn;
public $aqWorkStatus;
public $aqWorkCompanyT;
public $aqWorkCompanyE;
public $aqWorkPosition;
public $aqWorkAddress;
public $aqWorkDtId;
public $aqWorkApId;
public $aqWorkPrvId;
public $aqWorkZipcode;
public $aqWorkTelephone;
public $aqWorkSalary;
public $aqWorkSalarySpe;
public $aqWorkStartDate;
public $aqDegree;
public $aqLevelId;
public $aqMajId;
public $aqEduId;
public $aqEduStartDate;
public $aqInvestiture;
public $aqUserId;
public $aqUserUpdate;
public $last_insert_id;
function Da_ea_alumniqn() {
parent::__construct();
$this->load->database('ea', TRUE);
}
function insert() {
// if there is no auto_increment field, please remove it
$sql = "INSERT INTO $this->ea_dbname.ea_AlumniQn (aqQnId, aqAlumniId, aqStateQn, aqWorkStatus, aqWorkCompanyT, aqWorkCompanyE, aqWorkPosition, aqWorkAddress, aqWorkDtId, aqWorkApId, aqWorkPrvId, aqWorkZipcode, aqWorkTelephone, aqWorkSalary, aqWorkSalarySpe, aqWorkStartDate, aqDegree, aqLevelId, aqMajId, aqEduId, aqEduStartDate, aqInvestiture, aqUserId, aqUserUpdate)
VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$this->db->query($sql, array($this->aqQnId, $this->aqAlumniId, $this->aqStateQn, $this->aqWorkStatus, $this->aqWorkCompanyT, $this->aqWorkCompanyE, $this->aqWorkPosition, $this->aqWorkAddress, $this->aqWorkDtId, $this->aqWorkApId, $this->aqWorkPrvId, $this->aqWorkZipcode, $this->aqWorkTelephone, $this->aqWorkSalary, $this->aqWorkSalarySpe, $this->aqWorkStartDate, $this->aqDegree, $this->aqLevelId, $this->aqMajId, $this->aqEduId, $this->aqEduStartDate, $this->aqInvestiture, $this->aqUserId, $this->aqUserUpdate));
$this->last_insert_id = $this->db->insert_id();
}
function update() {
// if there is no primary key, please remove WHERE clause.
$sql = "UPDATE $this->ea_dbname.ea_AlumniQn
SET aqAlumniId=?, aqStateQn=?, aqWorkStatus=?, aqWorkCompanyT=?, aqWorkCompanyE=?, aqWorkPosition=?, aqWorkAddress=?, aqWorkDtId=?, aqWorkApId=?, aqWorkPrvId=?, aqWorkZipcode=?, aqWorkTelephone=?, aqWorkSalary=?, aqWorkSalarySpe=?, aqWorkStartDate=?, aqDegree=?, aqLevelId=?, aqMajId=?, aqEduId=?, aqEduStartDate=?, aqInvestiture=?, aqUserId=?, aqUserUpdate=?
WHERE aqQnId=?";
$this->db->query($sql, array($this->aqAlumniId, $this->aqStateQn, $this->aqWorkStatus, $this->aqWorkCompanyT, $this->aqWorkCompanyE, $this->aqWorkPosition, $this->aqWorkAddress, $this->aqWorkDtId, $this->aqWorkApId, $this->aqWorkPrvId, $this->aqWorkZipcode, $this->aqWorkTelephone, $this->aqWorkSalary, $this->aqWorkSalarySpe, $this->aqWorkStartDate, $this->aqDegree, $this->aqLevelId, $this->aqMajId, $this->aqEduId, $this->aqEduStartDate, $this->aqInvestiture, $this->aqUserId, $this->aqUserUpdate, $this->aqQnId));
}
function delete() {
// if there is no primary key, please remove WHERE clause.
$sql = "DELETE FROM $this->ea_dbname.ea_AlumniQn
WHERE aqQnId=?";
$this->db->query($sql, array($this->aqQnId));
}
/*
* You have to assign primary key value before call this function.
*/
function get_by_key($withSetAttributeValue=FALSE) {
$sql = "SELECT *
FROM $this->ea_dbname.ea_AlumniQn
WHERE aqQnId=?";
$query = $this->db->query($sql, array($this->aqQnId));
if ( $withSetAttributeValue ) {
$this->row2attribute( $query->row() );
} else {
return $query ;
}
}
} //=== end class Da_ea_alumniqn
?>
|