function addJobTitEmpStat()
{
$arrFieldList[0] = "'" . $this->getJobTitId() . "'";
$arrFieldList[1] = "'" . $this->getEmpStatId() . "'";
$tableName = 'HS_HR_JOBTIT_EMPSTAT';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
}
function addRepUserGroup()
{
$arrFieldList[0] = "'" . $this->getUserGroupID() . "'";
$arrFieldList[1] = "'" . $this->getRepCode() . "'";
$tableName = 'HS_HR_EMPREP_USERGROUP';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
echo $message2;
}
/**
* Add new project
*
* Deleted will be overwritten to NOT_DELETED
*/
public function addProject()
{
if ($this->_isDuplicateName()) {
throw new ProjectsException("Duplicate name", 1);
}
$this->projectID = UniqueIDGenerator::getInstance()->getNextID(self::TABLE_NAME, self::PROJECT_DB_FIELD_PROJECT_ID);
$arrRecord[0] = "'" . $this->getProjectId() . "'";
$arrRecord[1] = "'" . $this->getCustomerId() . "'";
$arrRecord[2] = "'" . $this->getProjectName() . "'";
$arrRecord[3] = "'" . $this->getProjectDescription() . "'";
$arrRecord[4] = self::PROJECT_NOT_DELETED;
$tableName = self::TABLE_NAME;
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrRecord;
$sqlQString = $sql_builder->addNewRecordFeature1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
if ($message2 && mysql_affected_rows() > 0) {
return true;
}
return false;
}
function addEmpStat()
{
$tableName = 'HS_HR_EMPSTAT';
$this->empStatId = UniqueIDGenerator::getInstance()->getNextID($tableName, 'ESTAT_CODE', 'EST');
$arrFieldList[0] = "'" . $this->getEmpStatId() . "'";
$arrFieldList[1] = "'" . $this->getEmpStatName() . "'";
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
}
function addEmpPic()
{
$dbConnection = new DMLFunctions();
$this->_escapeFields();
$arrFieldList[0] = "'" . $this->getEmpId() . "'";
$arrFieldList[1] = "'" . $this->getEmpPicture() . "'";
$arrFieldList[2] = "'" . $this->getEmpFilename() . "'";
$arrFieldList[3] = "'" . $this->getEmpPicType() . "'";
$arrFieldList[4] = "'" . $this->getEmpPicSize() . "'";
$tableName = 'HS_HR_EMP_PICTURE';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
/* We pass false to $quoteCorrect field, since it can corrupt the picture binary data */
$sqlQString = $sql_builder->addNewRecordFeature1(false);
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
}
function addMembershipInfo()
{
if ($this->_isDuplicateName()) {
throw new MembershipInfoException("Duplicate name", 1);
}
$tableName = 'hs_hr_membership';
$this->membershipId = UniqueIDGenerator::getInstance()->getNextID($tableName, 'membship_code', 'MME');
$arrFieldList[0] = "'" . $this->getMembershipInfoId() . "'";
$arrFieldList[1] = "'" . $this->getMembershipTypeId() . "'";
$arrFieldList[2] = "'" . $this->getMembershipInfoDesc() . "'";
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
}
function addEmpSkill()
{
$this->getEmpId();
$arrFieldList[0] = "'" . $this->getEmpId() . "'";
$arrFieldList[1] = "'" . $this->getEmpSkillCode() . "'";
$arrFieldList[2] = "'" . $this->getEmpYearsOfExp() . "'";
$arrFieldList[3] = "'" . $this->getEmpComments() . "'";
$tableName = 'HS_HR_EMP_SKILL';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
}
function addEducation()
{
$tableName = 'hs_hr_education';
$this->eduId = UniqueIDGenerator::getInstance()->getNextID($tableName, 'edu_code', 'EDU');
$arrFieldList[0] = "'" . $this->getEduId() . "'";
$arrFieldList[1] = "'" . $this->getEduUni() . "'";
$arrFieldList[2] = "'" . $this->getEduDeg() . "'";
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
echo $message2;
}
function addEmpPP()
{
$this->getEmpId();
$arrFieldList[0] = "'" . $this->getEmpId() . "'";
$arrFieldList[1] = "'" . $this->getEmpPPSeqNo() . "'";
$arrFieldList[2] = "'" . $this->getEmpPPNo() . "'";
$arrFieldList[3] = $this->getEmpPPIssDat();
// Quotes removed to accept null values
$arrFieldList[4] = $this->getEmpPPExpDat();
$arrFieldList[5] = "'" . $this->getEmpPPComment() . "'";
$arrFieldList[6] = "'" . $this->getEmppassportflag() . "'";
$arrFieldList[7] = "'" . $this->getEmpI9Status() . "'";
$arrFieldList[8] = $this->getEmpI9ReviewDat();
$arrFieldList[9] = "'" . $this->getEmpNationality() . "'";
$tableName = 'HS_HR_EMP_PASSPORT';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1();
//$logw = new LogFileWriter();
//$logw->writeLogDB($sqlQString);
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
echo $message2;
}
/**
*
*/
public function addCustomer()
{
if ($this->_isDuplicateName()) {
throw new CustomerException("Duplicate name", 1);
}
$this->customerId = UniqueIDGenerator::getInstance()->getNextID(self::TABLE_NAME, self::CUSTOMER_DB_FIELDS_ID);
$arrRecord[0] = "'" . $this->getCustomerId() . "'";
$arrRecord[1] = "'" . $this->getCustomerName() . "'";
$arrRecord[2] = "'" . $this->getCustomerDescription() . "'";
$arrRecord[3] = self::CUSTOMER_NOT_DELETED;
$tableName = self::TABLE_NAME;
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrRecord;
$sqlQString = $sql_builder->addNewRecordFeature1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
}
function addEthnicRace()
{
if ($this->_isDuplicateName()) {
throw new EthnicaRaceException("Duplicate name", 1);
}
$tableName = 'hs_hr_ethnic_race';
$this->ethnicrace = UniqueIDGenerator::getInstance()->getNextID($tableName, 'ethnic_race_code', 'ETH');
$arrFieldList[0] = "'" . $this->getethnicrace() . "'";
$arrFieldList[1] = "'" . $this->getethnicraceDescription() . "'";
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
}
function addEmpJobSpec()
{
$this->getEmpId();
$arrFieldList[0] = "'" . $this->getEmpId() . "'";
$arrFieldList[1] = "'" . $this->getEmpJDCatCode() . "'";
$arrFieldList[2] = "'" . $this->getEmpJobSpecAtt() . "'";
$tableName = 'HS_HR_EMP_JOBSPEC';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
echo $message2;
}
function addEmpQual()
{
$this->getEmpId();
$arrFieldList[0] = "'" . $this->getEmpQualId() . "'";
$arrFieldList[1] = "'" . $this->getEmpId() . "'";
$arrFieldList[2] = "'" . $this->getEmpQualInst() . "'";
$arrFieldList[3] = "'" . $this->getEmpQualYear() . "'";
$arrFieldList[4] = "'" . $this->getEmpQualStat() . "'";
$arrFieldList[5] = "'" . $this->getEmpQualComment() . "'";
$tableName = 'HS_HR_EMP_QUALIFICATION';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
echo $message2;
}
function addReport()
{
$tableName = 'HS_HR_EMPREPORT';
$this->repID = UniqueIDGenerator::getInstance()->getNextID($tableName, 'REP_CODE', 'REP');
$arrFieldList[0] = "'" . $this->getRepID() . "'";
$arrFieldList[1] = "'" . $this->getRepName() . "'";
$arrFieldList[2] = "'" . $this->getRepCriteriaDefString() . "'";
$arrFieldList[3] = "'" . $this->getRepFieldDefString() . "'";
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
}
function addEmpEC()
{
$this->getEmpId();
$arrFieldList[0] = "'" . $this->getEmpId() . "'";
$arrFieldList[1] = "'" . $this->getEmpECSeqNo() . "'";
$arrFieldList[2] = "'" . $this->getEmpEConName() . "'";
$arrFieldList[3] = "'" . $this->getEmpEConRel() . "'";
$arrFieldList[4] = "'" . $this->getEmpEConHmTel() . "'";
$arrFieldList[5] = "'" . $this->getEmpEConMobile() . "'";
$arrFieldList[6] = "'" . $this->getEmpEConWorkTel() . "'";
$tableName = 'HS_HR_EMP_EMERGENCY_CONTACTS';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1();
/*$logw = new LogFileWriter();
$logw->writeLogDB($sqlQString);*/
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
echo $message2;
}
function addEmpAtt()
{
$this->getEmpId();
$arrFieldList[0] = "'" . $this->getEmpId() . "'";
$arrFieldList[1] = "'" . $this->getEmpAttId() . "'";
$arrFieldList[2] = "'" . $this->getEmpAttDesc() . "'";
$arrFieldList[3] = "'" . $this->getEmpAttFilename() . "'";
$arrFieldList[4] = "'" . $this->getEmpAttSize() . "'";
$arrFieldList[5] = "'" . $this->getEmpAttachment() . "'";
$arrFieldList[6] = "'" . $this->getEmpAttType() . "'";
$tableName = 'HS_HR_EMP_ATTACHMENT';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1(false);
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
}
function addSalaryGrades()
{
$tableName = 'HS_PR_SALARY_GRADE';
$this->salgrdId = UniqueIDGenerator::getInstance()->getNextID($tableName, 'SAL_GRD_CODE', 'SAL');
$arrFieldList[0] = "'" . $this->getSalGrdId() . "'";
$arrFieldList[1] = "'" . $this->getSalGrdDesc() . "'";
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1();
$dbConnection = new DMLFunctions();
$message = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
if ($message) {
return $message;
} else {
$errCode = mysql_errno();
switch ($errCode) {
case 1062:
$e = new SalaryGradesException('Pay Grades cannot have duplicate names', SalaryGradesException::DUPLICATE_SALARY_GRADE);
break;
default:
$e = new SalaryGradesException('Unknown error in when adding Pay Grades', SalaryGradesException::UNKNOWN_EXCEPTION);
break;
}
throw $e;
}
}
function addEmpMembership()
{
$this->getEmpId();
$arrFieldList[0] = "'" . $this->getEmpId() . "'";
$arrFieldList[1] = "'" . $this->getEmpMemCode() . "'";
$arrFieldList[2] = "'" . $this->getEmpMemTypeCode() . "'";
$arrFieldList[3] = "'" . $this->getEmpMemSubOwn() . "'";
$arrFieldList[4] = "'" . $this->getEmpMemSubAmount() . "'";
$arrFieldList[5] = $this->getEmpMemCommDat();
// Quotes removed to accept null values
$arrFieldList[6] = $this->getEmpMemRenDat();
$tableName = 'HS_HR_EMP_MEMBER_DETAIL';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
echo $message2;
}
function addEmpLicenses()
{
$this->getEmpId();
$arrFieldList[0] = "'" . $this->getEmpId() . "'";
$arrFieldList[1] = "'" . $this->getEmpLicCode() . "'";
$arrFieldList[2] = $this->getempLicDat();
// Quotes removed to accept null values
$arrFieldList[3] = $this->getempLicrenewalDat();
$tableName = 'HS_HR_EMP_LICENSES';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1();
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
echo $message2;
}
function addLocation()
{
$tableName = 'HS_HR_LOCATION';
$this->locationId = UniqueIDGenerator::getInstance()->getNextID($tableName, 'LOC_CODE', 'LOC');
$arrFieldList[0] = "'" . $this->getLocationId() . "'";
$arrFieldList[1] = "'" . $this->getLocationName() . "'";
$arrFieldList[2] = "'" . $this->getLocationCountry() . "'";
$arrFieldList[3] = "'" . $this->getLocationState() . "'";
$arrFieldList[4] = "'" . $this->getLocationCity() . "'";
$arrFieldList[5] = "'" . $this->getLocationAddress() . "'";
$arrFieldList[6] = "'" . $this->getLocationZIP() . "'";
$arrFieldList[7] = "'" . $this->getLocationPhone() . "'";
$arrFieldList[8] = "'" . $this->getLocationFax() . "'";
$arrFieldList[9] = "'" . $this->getLocationComments() . "'";
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
echo $message2;
}
function addEmpDep()
{
//$this->getEmpId();
$arrFieldList[0] = "'" . $this->getEmpId() . "'";
$arrFieldList[1] = "'" . $this->getEmpDSeqNo() . "'";
$arrFieldList[2] = "'" . mysql_real_escape_string($this->getEmpDepName()) . "'";
$arrFieldList[3] = "'" . mysql_real_escape_string($this->getEmpDepRel()) . "'";
$tableName = 'HS_HR_EMP_DEPENDENTS';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = "";
$sqlQString = $sql_builder->addNewRecordFeature1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
}
function addEEOJobCat()
{
if ($this->_isDuplicateName()) {
throw new EEOJobCatException("Duplicate name", 1);
}
$tableName = 'HS_HR_EEC';
$this->eeojobcatId = UniqueIDGenerator::getInstance()->getNextID($tableName, 'EEC_CODE', 'EEC');
$arrFieldList[0] = "'" . $this->getEEOJobCatId() . "'";
$arrFieldList[1] = "'" . $this->getEEOJobCatDesc() . "'";
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
}
function addEmpEducation()
{
$arrFieldList[0] = "'" . $this->getEmpID() . "'";
$arrFieldList[1] = "'" . $this->getEduCode() . "'";
$arrFieldList[2] = "'" . $this->getEduMajor() . "'";
$arrFieldList[3] = "'" . $this->getEduYear() . "'";
$arrFieldList[4] = "'" . $this->getEduGPA() . "'";
$arrFieldList[5] = $this->getEduStartDate();
// Quotes removed to accept null values
$arrFieldList[6] = $this->getEduEndDate();
$tableName = 'HS_HR_EMP_EDUCATION';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
}
function addEmpWorkExp()
{
$arrFieldList[0] = "'" . $this->getEmpId() . "'";
$arrFieldList[1] = "'" . $this->getEmpExpSeqNo() . "'";
$arrFieldList[2] = "'" . $this->getEmpExpEmployer() . "'";
$arrFieldList[3] = "'" . $this->getEmpExpJobTitle() . "'";
$arrFieldList[4] = $this->getEmpExpFromDate();
// Quotes removed to allow null values
$arrFieldList[5] = $this->getEmpExpToDate();
$arrFieldList[6] = "'" . $this->getEmpExpComments() . "'";
$arrFieldList[7] = "'" . $this->getEmpExpInternal() . "'";
$tableName = 'HS_HR_EMP_WORK_EXPERIENCE';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
echo $message2;
}
function addConExt()
{
$this->getEmpId();
$arrFieldList[0] = "'" . $this->getEmpId() . "'";
$arrFieldList[1] = "'" . $this->getEmpConExtId() . "'";
$arrFieldList[2] = $this->getEmpConExtStartDat();
// Quotes were removed to allow null values.
$arrFieldList[3] = $this->getEmpConExtEndDat();
$tableName = 'HS_HR_EMP_CONTRACT_EXTEND';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
echo $message2;
}
function addEmpChi()
{
$this->getEmpId();
$arrFieldList[0] = "'" . $this->getEmpId() . "'";
$arrFieldList[1] = "'" . $this->getEmpCSeqNo() . "'";
$arrFieldList[2] = "'" . $this->getEmpChiName() . "'";
$arrFieldList[3] = $this->getEmpDOB();
// Quotes removed to accept null values
$tableName = 'HS_HR_EMP_CHILDREN';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_insert = 'true';
$sql_builder->arr_insert = $arrFieldList;
$sqlQString = $sql_builder->addNewRecordFeature1();
//$logw = new LogFileWriter();
//$logw->writeLogDB($sqlQString.'hhh');
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
echo $message2;
}