Viewing file: da_AlumniBio.php (11.1 KB) -rwxr-xr-x Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include_once("my_ea_model.php");
class Da_alumnibio extends My_ea_model {
// PK is alumniId
public $alumniId;
public $studentId;
public $nationId;
public $religionId;
public $bloodGroup;
public $birthDate;
public $birthCntId;
public $birthProvinceId;
public $homeAddress;
public $homeDistrictId;
public $homeAmphurId;
public $homeProvinceId;
public $homeZipcode;
public $homePhoneNo;
public $officeName;
public $workCntId;
public $officeAddress;
public $officeDistrictId;
public $officeAmphurId;
public $officeProvinceId;
public $officeZipcode;
public $officePhoneNo;
public $workingStatus;
public $workingPosition;
public $workingSalary;
public $fatherName;
public $fatherAddress;
public $fatherDistrictId;
public $fatherAmphurId;
public $fatherProvinceId;
public $fatherZipcode;
public $fatherPhoneNo;
public $fatherOccupation;
public $fatherStatus;
public $motherName;
public $motherAddress;
public $motherDistrictId;
public $motherAmphurId;
public $motherProvinceId;
public $motherZipcode;
public $motherPhoneNo;
public $motherOccupation;
public $motherStatus;
public $studentSex;
public $parentName;
public $parentRelation;
public $parentAddress;
public $parentDistrictId;
public $parentAmphurId;
public $parentProvinceId;
public $parentZipcode;
public $parentPhoneNo;
public $parentMobile;
public $parentOcc;
public $parentIncome;
public $parentEmail;
public $contactPerson;
public $contactAddress;
public $contactDistrictId;
public $contactAmphurId;
public $contactProvinceId;
public $contactZipcode;
public $contactPhoneNo;
public $cardExpiryDate;
public $currentCntId;
public $currentAddress;
public $currentDistrictId;
public $currentAmphurId;
public $currentProvinceId;
public $currentZipcode;
public $currentPhoneNo;
public $graduateAddress;
public $graduateDistrictId;
public $graduateAmphurId;
public $graduateProvinceId;
public $graduateZipcode;
public $graduatePhoneNo;
public $maritalStatusId;
public $weight;
public $height;
public $picturePath;
public $recruitmentTypeId;
public $occExamResult;
public $canRefund;
public $oldStudentName;
public $entryDegree;
public $healthPrivId;
public $o1prefixId;
public $o1fName;
public $o1lName;
public $o2prefixId;
public $o2fName;
public $o2lName;
public $regPrefix;
public $regStdName;
public $regStdSurname;
public $regStdNameE;
public $regStdSurnameE;
public $last_insert_id;
function Da_alumnibio() {
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.AlumniBio (alumniId, studentId, nationId, religionId, bloodGroup, birthDate, birthCntId, birthProvinceId, homeAddress, homeDistrictId, homeAmphurId, homeProvinceId, homeZipcode, homePhoneNo, officeName, workCntId, officeAddress, officeDistrictId, officeAmphurId, officeProvinceId, officeZipcode, officePhoneNo, workingStatus, workingPosition, workingSalary, fatherName, fatherAddress, fatherDistrictId, fatherAmphurId, fatherProvinceId, fatherZipcode, fatherPhoneNo, fatherOccupation, fatherStatus, motherName, motherAddress, motherDistrictId, motherAmphurId, motherProvinceId, motherZipcode, motherPhoneNo, motherOccupation, motherStatus, studentSex, parentName, parentRelation, parentAddress, parentDistrictId, parentAmphurId, parentProvinceId, parentZipcode, parentPhoneNo, parentMobile, parentOcc, parentIncome, parentEmail, contactPerson, contactAddress, contactDistrictId, contactAmphurId, contactProvinceId, contactZipcode, contactPhoneNo, cardExpiryDate, currentCntId, currentAddress, currentDistrictId, currentAmphurId, currentProvinceId, currentZipcode, currentPhoneNo, graduateAddress, graduateDistrictId, graduateAmphurId, graduateProvinceId, graduateZipcode, graduatePhoneNo, maritalStatusId, weight, height, picturePath, recruitmentTypeId, occExamResult, canRefund, oldStudentName, entryDegree, healthPrivId, o1prefixId, o1fName, o1lName, o2prefixId, o2fName, o2lName, regPrefix, regStdName, regStdSurname, regStdNameE, regStdSurnameE)
VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$this->db->query($sql, array($this->alumniId, $this->studentId, $this->nationId, $this->religionId, $this->bloodGroup, $this->birthDate, $this->birthCntId, $this->birthProvinceId, $this->homeAddress, $this->homeDistrictId, $this->homeAmphurId, $this->homeProvinceId, $this->homeZipcode, $this->homePhoneNo, $this->officeName, $this->workCntId, $this->officeAddress, $this->officeDistrictId, $this->officeAmphurId, $this->officeProvinceId, $this->officeZipcode, $this->officePhoneNo, $this->workingStatus, $this->workingPosition, $this->workingSalary, $this->fatherName, $this->fatherAddress, $this->fatherDistrictId, $this->fatherAmphurId, $this->fatherProvinceId, $this->fatherZipcode, $this->fatherPhoneNo, $this->fatherOccupation, $this->fatherStatus, $this->motherName, $this->motherAddress, $this->motherDistrictId, $this->motherAmphurId, $this->motherProvinceId, $this->motherZipcode, $this->motherPhoneNo, $this->motherOccupation, $this->motherStatus, $this->studentSex, $this->parentName, $this->parentRelation, $this->parentAddress, $this->parentDistrictId, $this->parentAmphurId, $this->parentProvinceId, $this->parentZipcode, $this->parentPhoneNo, $this->parentMobile, $this->parentOcc, $this->parentIncome, $this->parentEmail, $this->contactPerson, $this->contactAddress, $this->contactDistrictId, $this->contactAmphurId, $this->contactProvinceId, $this->contactZipcode, $this->contactPhoneNo, $this->cardExpiryDate, $this->currentCntId, $this->currentAddress, $this->currentDistrictId, $this->currentAmphurId, $this->currentProvinceId, $this->currentZipcode, $this->currentPhoneNo, $this->graduateAddress, $this->graduateDistrictId, $this->graduateAmphurId, $this->graduateProvinceId, $this->graduateZipcode, $this->graduatePhoneNo, $this->maritalStatusId, $this->weight, $this->height, $this->picturePath, $this->recruitmentTypeId, $this->occExamResult, $this->canRefund, $this->oldStudentName, $this->entryDegree, $this->healthPrivId, $this->o1prefixId, $this->o1fName, $this->o1lName, $this->o2prefixId, $this->o2fName, $this->o2lName, $this->regPrefix, $this->regStdName, $this->regStdSurname, $this->regStdNameE, $this->regStdSurnameE));
$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.AlumniBio
SET studentId=?, nationId=?, religionId=?, bloodGroup=?, birthDate=?, birthCntId=?, birthProvinceId=?, homeAddress=?, homeDistrictId=?, homeAmphurId=?, homeProvinceId=?, homeZipcode=?, homePhoneNo=?, officeName=?, workCntId=?, officeAddress=?, officeDistrictId=?, officeAmphurId=?, officeProvinceId=?, officeZipcode=?, officePhoneNo=?, workingStatus=?, workingPosition=?, workingSalary=?, fatherName=?, fatherAddress=?, fatherDistrictId=?, fatherAmphurId=?, fatherProvinceId=?, fatherZipcode=?, fatherPhoneNo=?, fatherOccupation=?, fatherStatus=?, motherName=?, motherAddress=?, motherDistrictId=?, motherAmphurId=?, motherProvinceId=?, motherZipcode=?, motherPhoneNo=?, motherOccupation=?, motherStatus=?, studentSex=?, parentName=?, parentRelation=?, parentAddress=?, parentDistrictId=?, parentAmphurId=?, parentProvinceId=?, parentZipcode=?, parentPhoneNo=?, parentMobile=?, parentOcc=?, parentIncome=?, parentEmail=?, contactPerson=?, contactAddress=?, contactDistrictId=?, contactAmphurId=?, contactProvinceId=?, contactZipcode=?, contactPhoneNo=?, cardExpiryDate=?, currentCntId=?, currentAddress=?, currentDistrictId=?, currentAmphurId=?, currentProvinceId=?, currentZipcode=?, currentPhoneNo=?, graduateAddress=?, graduateDistrictId=?, graduateAmphurId=?, graduateProvinceId=?, graduateZipcode=?, graduatePhoneNo=?, maritalStatusId=?, weight=?, height=?, picturePath=?, recruitmentTypeId=?, occExamResult=?, canRefund=?, oldStudentName=?, entryDegree=?, healthPrivId=?, o1prefixId=?, o1fName=?, o1lName=?, o2prefixId=?, o2fName=?, o2lName=?, regPrefix=?, regStdName=?, regStdSurname=?, regStdNameE=?, regStdSurnameE=?
WHERE alumniId=?";
$this->db->query($sql, array($this->studentId, $this->nationId, $this->religionId, $this->bloodGroup, $this->birthDate, $this->birthCntId, $this->birthProvinceId, $this->homeAddress, $this->homeDistrictId, $this->homeAmphurId, $this->homeProvinceId, $this->homeZipcode, $this->homePhoneNo, $this->officeName, $this->workCntId, $this->officeAddress, $this->officeDistrictId, $this->officeAmphurId, $this->officeProvinceId, $this->officeZipcode, $this->officePhoneNo, $this->workingStatus, $this->workingPosition, $this->workingSalary, $this->fatherName, $this->fatherAddress, $this->fatherDistrictId, $this->fatherAmphurId, $this->fatherProvinceId, $this->fatherZipcode, $this->fatherPhoneNo, $this->fatherOccupation, $this->fatherStatus, $this->motherName, $this->motherAddress, $this->motherDistrictId, $this->motherAmphurId, $this->motherProvinceId, $this->motherZipcode, $this->motherPhoneNo, $this->motherOccupation, $this->motherStatus, $this->studentSex, $this->parentName, $this->parentRelation, $this->parentAddress, $this->parentDistrictId, $this->parentAmphurId, $this->parentProvinceId, $this->parentZipcode, $this->parentPhoneNo, $this->parentMobile, $this->parentOcc, $this->parentIncome, $this->parentEmail, $this->contactPerson, $this->contactAddress, $this->contactDistrictId, $this->contactAmphurId, $this->contactProvinceId, $this->contactZipcode, $this->contactPhoneNo, $this->cardExpiryDate, $this->currentCntId, $this->currentAddress, $this->currentDistrictId, $this->currentAmphurId, $this->currentProvinceId, $this->currentZipcode, $this->currentPhoneNo, $this->graduateAddress, $this->graduateDistrictId, $this->graduateAmphurId, $this->graduateProvinceId, $this->graduateZipcode, $this->graduatePhoneNo, $this->maritalStatusId, $this->weight, $this->height, $this->picturePath, $this->recruitmentTypeId, $this->occExamResult, $this->canRefund, $this->oldStudentName, $this->entryDegree, $this->healthPrivId, $this->o1prefixId, $this->o1fName, $this->o1lName, $this->o2prefixId, $this->o2fName, $this->o2lName, $this->regPrefix, $this->regStdName, $this->regStdSurname, $this->regStdNameE, $this->regStdSurnameE, $this->alumniId));
}
function delete() {
// if there is no primary key, please remove WHERE clause.
$sql = "DELETE FROM $this->ea_dbname.AlumniBio
WHERE alumniId=?";
$this->db->query($sql, array($this->alumniId));
}
/*
* You have to assign primary key value before call this function.
*/
function get_by_key($withSetAttributeValue=FALSE) {
$sql = "SELECT *
FROM $this->ea_dbname.AlumniBio
WHERE alumniId=?";
$query = $this->db->query($sql, array($this->alumniId));
if ( $withSetAttributeValue ) {
$this->row2attribute( $query->row() );
} else {
return $query ;
}
}
} //=== end class Da_alumnibio
?>
|