/** * Adds the given employee as a admin to the given project. * If the employee is already an admin, the request is ignored. * * @param int $projectId The project ID * @param int $empNumber The employee number * @return true if successful */ public function addAdmin($projectId, $empNumber) { if (!CommonFunctions::isValidId($projectId) || !CommonFunctions::isValidId($empNumber)) { throw new ProjectAdminException("Invalid parameters to addAdmin(): emp_number = {$empNumber} , " . "projectId = {$projectId}"); } $result = true; if (!$this->isAdmin($empNumber, $projectId)) { $fields[0] = self::PROJECT_ADMIN_FIELD_PROJECT_ID; $fields[1] = self::PROJECT_ADMIN_FIELD_EMP_NUMBER; $values[0] = "'{$projectId}'"; $values[1] = "'{$empNumber}'"; $sqlBuilder = new SQLQBuilder(); $sqlBuilder->table_name = self::TABLE_NAME; $sqlBuilder->flg_insert = 'true'; $sqlBuilder->arr_insert = $values; $sqlBuilder->arr_insertfield = $fields; $sql = $sqlBuilder->addNewRecordFeature2(); $conn = new DMLFunctions(); $result = $conn->executeQuery($sql); if (!$result || mysql_affected_rows() != 1) { $result = false; } else { $this->id = mysql_insert_id(); } } return $result; }
/** * Sets the 'value' corresponding to 'key' * If the 'key' is already availabe, correponding 'value' would be updated. * If not, a new 'key', 'value' pair would be inserted. * @param string $key 'key' field corresponding to the value to be set * @param string $value 'value' that should be set */ private static function _setValue($key, $value) { $updateFields[0] = "`" . self::DB_FIELD_KEY . "`"; $updateFields[1] = "`" . self::DB_FIELD_VALUE . "`"; $updateValues[0] = "'" . $key . "'"; $updateValues[1] = "'" . $value . "'"; $sqlBuilder = new SQLQBuilder(); $sqlBuilder->table_name = self::DB_TABLE_CONFIG; $sqlBuilder->flg_insert = 'true'; $sqlBuilder->arr_insert = $updateValues; $sqlBuilder->arr_insertfield = $updateFields; $query = $sqlBuilder->addNewRecordFeature2(true, true); $dbConnection = new DMLFunctions(); $result = $dbConnection->executeQuery($query); if (!$result) { throw new Exception("Value corresponding to {$key} was not updated"); } }
/** * Add new CustomExport object to database */ private function _insert() { $fields[0] = self::DB_FIELDS_ID; $fields[1] = self::DB_FIELDS_NAME; $fields[2] = self::DB_FIELDS_FIELDS; $fields[3] = self::DB_FIELDS_HEADINGS; $this->id = UniqueIDGenerator::getInstance()->getNextID(self::TABLE_NAME, self::DB_FIELDS_ID); $values[0] = $this->id; $values[1] = "'{$this->name}'"; $values[2] = "'" . implode(",", $this->assignedFields) . "'"; $values[3] = empty($this->headings) ? "''" : "'" . implode(",", $this->headings) . "'"; $sqlBuilder = new SQLQBuilder(); $sqlBuilder->table_name = self::TABLE_NAME; $sqlBuilder->flg_insert = 'true'; $sqlBuilder->arr_insert = $values; $sqlBuilder->arr_insertfield = $fields; $sql = $sqlBuilder->addNewRecordFeature2(); $conn = new DMLFunctions(); $result = $conn->executeQuery($sql); if (!$result || mysql_affected_rows() != 1) { throw new CustomExportException("Insert failed. {$sql}", CustomExportException::DB_EXCEPTION); } }
function addEmpLang() { $arrRecordsList[0] = "'" . $this->getEmpId() . "'"; $arrRecordsList[1] = "'" . $this->getEmpLangCode() . "'"; $arrRecordsList[2] = "'" . $this->getEmpLangType() . "'"; $arrRecordsList[3] = "'" . $this->empLangRatGrd . "'"; $arrFieldList[0] = 'EMP_NUMBER'; $arrFieldList[1] = 'LANG_CODE'; $arrFieldList[2] = 'ELANG_TYPE'; $arrFieldList[3] = 'COMPETENCY'; $tableName = 'HS_HR_EMP_LANGUAGE'; $sql_builder = new SQLQBuilder(); $sql_builder->table_name = $tableName; $sql_builder->flg_insert = 'true'; $sql_builder->arr_insertfield = $arrFieldList; $sql_builder->arr_insert = $arrRecordsList; $sqlQString = $sql_builder->addNewRecordFeature2(true, true); $dbConnection = new DMLFunctions(); $message2 = $dbConnection->executeQuery($sqlQString); //Calling the addData() function return $message2; }
private function _insert() { $fields[0] = self::DB_FIELD_WORKSHIFT_ID; $fields[1] = self::DB_FIELD_NAME; $fields[2] = self::DB_FIELD_HOURS; $this->workshiftId = UniqueIDGenerator::getInstance()->getNextID(self::WORKSHIFT_TABLE, self::DB_FIELD_WORKSHIFT_ID); $values[0] = $this->workshiftId; $values[1] = "'{$this->name}'"; $values[2] = "'{$this->hoursPerDay}'"; $sqlBuilder = new SQLQBuilder(); $sqlBuilder->table_name = self::WORKSHIFT_TABLE; $sqlBuilder->flg_insert = 'true'; $sqlBuilder->arr_insert = $values; $sqlBuilder->arr_insertfield = $fields; $sql = $sqlBuilder->addNewRecordFeature2(); $dbConnection = new DMLFunctions(); $result = $dbConnection->executeQuery($sql); if (!$result) { throw new WorkshiftException("Workshift not inserted", WorkshiftException::ERROR_IN_DB_QUERY); } if (mysql_affected_rows() != 1) { throw new WorkshiftException("Workshift not inserted", WorkshiftException::INVALID_ROW_COUNT); } return mysql_affected_rows(); }
function addSalCurDet() { $arrFieldList[0] = 'SAL_GRD_CODE'; $arrFieldList[1] = 'CURRENCY_ID'; $arrFieldList[2] = 'SALCURR_DTL_MINSALARY'; $arrFieldList[3] = 'SALCURR_DTL_MAXSALARY'; $arrFieldList[4] = 'SALCURR_DTL_STEPSALARY'; $arrRecordList[0] = "'" . $this->getSalGrdId() . "'"; $arrRecordList[1] = "'" . $this->getCurrId() . "'"; $minSal = $this->getMinSal() == '' ? 'null' : $this->getMinSal(); $arrRecordList[2] = $minSal; $maxSal = $this->getMaxSal() == '' ? 'null' : $this->getMaxSal(); $arrRecordList[3] = $maxSal; $stepSal = $this->getStepSal() == '' ? 'null' : $this->getStepSal(); $arrRecordList[4] = $stepSal; $tableName = 'HS_PR_SALARY_CURRENCY_DETAIL'; $sql_builder = new SQLQBuilder(); $sql_builder->table_name = $tableName; $sql_builder->flg_insert = 'true'; $sql_builder->arr_insert = $arrRecordList; $sql_builder->arr_insertfield = $arrFieldList; $sqlQString = $sql_builder->addNewRecordFeature2(); $dbConnection = new DMLFunctions(); $message2 = $dbConnection->executeQuery($sqlQString); //Calling the addData() function return $message2; }
public function addProperty() { $dbConnection = new DMLFunctions(); $sqlB->arr_insert = array($this->getPropName()); $sqlBuilder = new SQLQBuilder(); $sqlBuilder->table_name = $this->TABLE_NAME; $sqlBuilder->flg_insert = 'true'; $sqlBuilder->arr_insert = array($this->getPropName()); $sqlBuilder->arr_insertfield = array("prop_name"); $sql = $sqlBuilder->addNewRecordFeature2(); $dbConnection->executeQuery($sql); return 1; //report success }
function addEmpBasSal() { $this->getEmpId(); $arrFieldList[0] = "'" . $this->getEmpId() . "'"; $arrFieldList[1] = "'" . $this->getEmpSalGrdCode() . "'"; $arrFieldList[2] = "'" . $this->getEmpCurrCode() . "'"; $arrFieldList[3] = "'" . $this->getEmpBasSal() . "'"; $arrFieldList[4] = empty($this->payPeriod) ? "null" : "'" . $this->payPeriod . "'"; $fields[0] = 'EMP_NUMBER'; $fields[1] = 'SAL_GRD_CODE'; $fields[2] = 'CURRENCY_ID'; $fields[3] = 'EBSAL_BASIC_SALARY'; $fields[4] = 'PAYPERIOD_CODE'; $tableName = 'hs_hr_emp_basicsalary'; $sql_builder = new SQLQBuilder(); $sql_builder->table_name = $tableName; $sql_builder->flg_insert = 'true'; $sql_builder->arr_insert = $arrFieldList; $sql_builder->arr_insertfield = $fields; $sqlQString = $sql_builder->addNewRecordFeature2(); $dbConnection = new DMLFunctions(); $message2 = $dbConnection->executeQuery($sqlQString); //Calling the addData() function return $message2; }
/** * Insert new object to database */ private function _insert() { $fields[0] = self::DB_FIELD_ID; $fields[1] = self::DB_FIELD_NAME; $fields[2] = self::DB_FIELD_DESC; $fields[3] = self::DB_FIELD_DUTIES; $this->id = UniqueIDGenerator::getInstance()->getNextID(self::TABLE_NAME, self::DB_FIELD_ID); $values[0] = $this->id; $values[1] = "'{$this->name}'"; $values[2] = "'{$this->desc}'"; $values[3] = "'{$this->duties}'"; $sqlBuilder = new SQLQBuilder(); $sqlBuilder->table_name = self::TABLE_NAME; $sqlBuilder->flg_insert = 'true'; $sqlBuilder->arr_insert = $values; $sqlBuilder->arr_insertfield = $fields; $sql = $sqlBuilder->addNewRecordFeature2(); $conn = new DMLFunctions(); $result = $conn->executeQuery($sql); if (!$result || mysql_affected_rows() != 1) { throw new JobSpecException("Insert failed. ", JobSpecException::DB_ERROR); } return $this->id; }
function addEmpRepTo() { $arrRecordsList[0] = "'" . $this->getEmpSupId() . "'"; $arrRecordsList[1] = "'" . $this->getEmpSubId() . "'"; $arrRecordsList[2] = "'" . $this->getEmpRepMod() . "'"; $tableName = 'HS_HR_EMP_REPORTTO'; $arrFieldList[0] = 'EREP_SUP_EMP_NUMBER'; $arrFieldList[1] = 'EREP_SUB_EMP_NUMBER'; $arrFieldList[2] = 'EREP_REPORTING_MODE'; $sql_builder = new SQLQBuilder(); $sql_builder->table_name = $tableName; $sql_builder->flg_insert = 'true'; $sql_builder->arr_insertfield = $arrFieldList; $sql_builder->arr_insert = $arrRecordsList; $sqlQString = $sql_builder->addNewRecordFeature2(true, true); $dbConnection = new DMLFunctions(); $message2 = $dbConnection->executeQuery($sqlQString); //Calling the addData() function return $message2; }
/** * Insert new object to database */ private function _insert() { // Update name if not set. if (empty($this->name)) { $this->_updateName(); } $fields[0] = self::DB_FIELD_EMP_NUMBER; $fields[1] = self::DB_FIELD_CODE; $fields[2] = self::DB_FIELD_NAME; $fields[3] = self::DB_FIELD_START_DATE; $fields[4] = self::DB_FIELD_END_DATE; $values[0] = $this->empNumber; $values[1] = $this->code; $values[2] = isset($this->name) ? $this->name : 'null'; $values[3] = $this->startDate; $values[4] = isset($this->endDate) ? $this->endDate : 'null'; $sqlBuilder = new SQLQBuilder(); $sqlBuilder->table_name = $this->tableName; $sqlBuilder->flg_insert = 'true'; $sqlBuilder->arr_insert = $values; $sqlBuilder->arr_insertfield = $fields; $sql = $sqlBuilder->addNewRecordFeature2(); $conn = new DMLFunctions(); $result = $conn->executeQuery($sql); if (!$result || mysql_affected_rows() != 1) { throw new EmpHistoryException("Insert failed. ", EmpHistoryException::DB_ERROR); } $this->id = mysql_insert_id(); return $this->id; }
/** * Insert new object to database */ private function _insert() { $this->id = UniqueIDGenerator::getInstance()->getNextID(self::TABLE_NAME, self::DB_FIELD_VACANCY_ID); $fields[0] = self::DB_FIELD_VACANCY_ID; $fields[1] = self::DB_FIELD_JOBTITLE_CODE; $fields[2] = self::DB_FIELD_MANAGER_ID; $fields[3] = self::DB_FIELD_ACTIVE; $fields[4] = self::DB_FIELD_DESCRIPTION; $values[0] = $this->id; $values[1] = "'{$this->jobTitleCode}'"; $values[2] = $this->managerId; $values[3] = $this->active ? self::STATUS_ACTIVE : self::STATUS_INACTIVE; $values[4] = "'{$this->description}'"; $sqlBuilder = new SQLQBuilder(); $sqlBuilder->table_name = self::TABLE_NAME; $sqlBuilder->flg_insert = 'true'; $sqlBuilder->arr_insert = $values; $sqlBuilder->arr_insertfield = $fields; $sql = $sqlBuilder->addNewRecordFeature2(); $conn = new DMLFunctions(); $result = $conn->executeQuery($sql); if (!$result || mysql_affected_rows() != 1) { throw new JobVacancyException("Insert failed. ", JobVacancyException::DB_ERROR); } return $this->id; }
/** * Inserts or updates tax information to the employee tax table. * Note that the tax information is kept separate from the employee table * since it can be country specific. */ function updateEmpTax() { $arrRecordsList[0] = "'" . $this->getEmpNumber() . "'"; $arrRecordsList[1] = "'" . $this->getFederalTaxStatus() . "'"; $arrRecordsList[2] = trim($this->getFederalTaxExceptions()) != '' ? "'" . $this->getFederalTaxExceptions() . "'" : "'0'"; $arrRecordsList[3] = "'" . $this->getTaxState() . "'"; $arrRecordsList[4] = "'" . $this->getStateTaxStatus() . "'"; $arrRecordsList[5] = trim($this->getStateTaxExceptions()) != '' ? "'" . $this->getStateTaxExceptions() . "'" : "'0'"; $arrRecordsList[6] = "'" . $this->getTaxUnemploymentState() . "'"; $arrRecordsList[7] = "'" . $this->getTaxWorkState() . "'"; $arrFieldList[0] = self::EMP_TAX_TABLE_EMP_NUMBER; $arrFieldList[1] = self::EMP_TAX_FEDERAL_STATUS; $arrFieldList[2] = self::EMP_TAX_FEDERAL_EXCEPTIONS; $arrFieldList[3] = self::EMP_TAX_STATE; $arrFieldList[4] = self::EMP_TAX_STATE_STATUS; $arrFieldList[5] = self::EMP_TAX_STATE_EXCEPTIONS; $arrFieldList[6] = self::EMP_TAX_UNEMP_STATE; $arrFieldList[7] = self::EMP_TAX_WORK_STATE; $sql_builder = new SQLQBuilder(); $sql_builder->table_name = self::EMP_TAX_TABLE_NAME; $sql_builder->flg_insert = 'true'; $sql_builder->arr_insert = $arrRecordsList; $sql_builder->arr_insertfield = $arrFieldList; $sqlQString = $sql_builder->addNewRecordFeature2(true, true); $dbConnection = new DMLFunctions(); $result = $dbConnection->executeQuery($sqlQString); return $result; }
/** * Add a new custom field to the database */ public function addCustomField() { if ($this->_isDuplicateName()) { throw new CustomFieldsException("Duplicate name", 1); } $conn = new DMLFunctions(); $fields[0] = self::DB_FIELDS_NUM; $fields[1] = self::DB_FIELDS_NAME; $fields[2] = self::DB_FIELDS_TYPE; $fields[3] = self::DB_FIELDS_SCREEN; $fields[4] = self::DB_FIELDS_EXTRA_DATA; $values[0] = mysql_real_escape_string($this->fieldNumber); $values[1] = "'" . mysql_real_escape_string($this->name) . "'"; $values[2] = "'" . mysql_real_escape_string($this->fieldType) . "'"; $values[3] = "'" . mysql_real_escape_string($this->screen) . "'"; $values[4] = "'" . mysql_real_escape_string($this->extraData) . "'"; $sqlBuilder = new SQLQBuilder(); $sqlBuilder->table_name = self::TABLE_NAME; $sqlBuilder->flg_insert = 'true'; $sqlBuilder->arr_insert = $values; $sqlBuilder->arr_insertfield = $fields; $sql = $sqlBuilder->addNewRecordFeature2(); $result = $conn->executeQuery($sql); if (!$result || mysql_affected_rows() != 1) { throw new CustomFieldsException("Insert failed. "); } }
private function _insert() { $fields[0] = self::DB_FIELD_ACTIVITY_ID; $fields[1] = self::DB_FIELD_NAME; $fields[2] = self::DB_FIELD_PROJECT_ID; $fields[3] = self::DB_FIELD_DELETED; $this->id = UniqueIDGenerator::getInstance()->getNextID(self::TABLE_NAME, self::DB_FIELD_ACTIVITY_ID); $values[0] = $this->id; $values[1] = "'{$this->name}'"; $values[2] = "'{$this->projectId}'"; $values[3] = "'" . intval($this->deleted) . "'"; $sqlBuilder = new SQLQBuilder(); $sqlBuilder->table_name = self::TABLE_NAME; $sqlBuilder->flg_insert = 'true'; $sqlBuilder->arr_insert = $values; $sqlBuilder->arr_insertfield = $fields; $sql = $sqlBuilder->addNewRecordFeature2(); $conn = new DMLFunctions(); $result = $conn->executeQuery($sql); if (!$result || mysql_affected_rows() != 1) { throw new ProjectActivityException("Insert failed. "); } }
function addJobTitles() { $tableName = 'HS_HR_JOB_TITLE'; $this->jobId = UniqueIDGenerator::getInstance()->getNextID($tableName, 'JOBTIT_CODE', 'JOB'); $arrRecordsList[0] = "'" . $this->getJobId() . "'"; $arrRecordsList[1] = "'" . $this->getJobName() . "'"; $arrRecordsList[2] = "'" . $this->getJobDesc() . "'"; $arrRecordsList[3] = "'" . $this->getJobComm() . "'"; $arrRecordsList[4] = "'" . $this->getJobSalGrd() . "'"; $arrRecordsList[5] = isset($this->jobSpecId) ? $this->jobSpecId : 'null'; $arrFieldList[0] = 'JOBTIT_CODE'; $arrFieldList[1] = 'JOBTIT_NAME'; $arrFieldList[2] = 'JOBTIT_DESC'; $arrFieldList[3] = 'JOBTIT_COMM'; $arrFieldList[4] = 'SAL_GRD_CODE'; $arrFieldList[5] = self::DB_FIELD_JOBSPEC_ID; $sql_builder = new SQLQBuilder(); $sql_builder->table_name = $tableName; $sql_builder->flg_insert = 'true'; $sql_builder->arr_insert = $arrRecordsList; $sql_builder->arr_insertfield = $arrFieldList; $sqlQString = $sql_builder->addNewRecordFeature2(); $dbConnection = new DMLFunctions(); $message2 = $dbConnection->executeQuery($sqlQString); $jobTitleEmpStat = new JobTitEmpStat(); $jobTitleEmpStat->setEmpStatId(EmploymentStatus::EMPLOYMENT_STATUS_ID_TERMINATED); $jobTitleEmpStat->setJobTitId($this->getJobId()); $jobTitleEmpStat->addJobTitEmpStat(); return $message2; }
/** * Save a employee Location to the database. * If this location has already been assigned to the employee, no change is done. */ public function save() { $this->_validateParams(); $fields[0] = self::DB_FIELD_EMP_NUMBER; $fields[1] = self::DB_FIELD_LOC_CODE; $values[0] = $this->empNumber; $values[1] = "'{$this->location}'"; $sqlBuilder = new SQLQBuilder(); $sqlBuilder->table_name = self::TABLE_NAME; $sqlBuilder->flg_insert = 'true'; $sqlBuilder->arr_insert = $values; $sqlBuilder->arr_insertfield = $fields; $sql = $sqlBuilder->addNewRecordFeature2(true, false, true); $conn = new DMLFunctions(); $result = $conn->executeQuery($sql); if (!$result) { throw new EmpLocationException("Insert failed. ", EmpLocationException::DB_ERROR); } }
function addEmpMain() { $tableName = 'HS_HR_EMPLOYEE'; $this->empId = UniqueIDGenerator::getInstance()->getNextID($tableName, 'EMP_NUMBER'); $arrRecordsList[0] = "'" . $this->getEmpId() . "'"; $arrRecordsList[1] = "'" . $this->getEmpLastName() . "'"; $arrRecordsList[2] = "'" . $this->getEmpFirstName() . "'"; $arrRecordsList[3] = "'" . $this->getEmpNickName() . "'"; $arrRecordsList[4] = "'" . $this->getEmpMiddleName() . "'"; $arrRecordsList[5] = "'" . $this->getEmployeeId() . "'"; $arrFieldList[0] = 'EMP_NUMBER'; $arrFieldList[1] = 'EMP_LASTNAME'; $arrFieldList[2] = 'EMP_FIRSTNAME'; $arrFieldList[3] = 'EMP_NICK_NAME'; $arrFieldList[4] = 'EMP_MIDDLE_NAME'; $arrFieldList[5] = 'EMPLOYEE_ID'; $sql_builder = new SQLQBuilder(); $sql_builder->table_name = $tableName; $sql_builder->flg_insert = 'true'; $sql_builder->arr_insert = $arrRecordsList; $sql_builder->arr_insertfield = $arrFieldList; $sqlQString = $sql_builder->addNewRecordFeature2(); //echo $sqlQString; $dbConnection = new DMLFunctions(); $message2 = $dbConnection->executeQuery($sqlQString); //Calling the addData() function return $message2; }
/** * Add a new custom field to the database */ public function addCustomField() { $fields[0] = self::DB_FIELDS_NUM; $fields[1] = self::DB_FIELDS_NAME; $fields[2] = self::DB_FIELDS_TYPE; $fields[3] = self::DB_FIELDS_EXTRA_DATA; $values[0] = $this->fieldNumber; $values[1] = "'{$this->name}'"; $values[2] = "'{$this->fieldType}'"; $values[3] = "'{$this->extraData}'"; $sqlBuilder = new SQLQBuilder(); $sqlBuilder->table_name = self::TABLE_NAME; $sqlBuilder->flg_insert = 'true'; $sqlBuilder->arr_insert = $values; $sqlBuilder->arr_insertfield = $fields; $sql = $sqlBuilder->addNewRecordFeature2(); $conn = new DMLFunctions(); $result = $conn->executeQuery($sql); if (!$result || mysql_affected_rows() != 1) { throw new CustomFieldsException("Insert failed. "); } }
/** * Insert new object to database */ private function _insert() { $this->id = UniqueIDGenerator::getInstance()->getNextID(self::TABLE_NAME, self::DB_FIELD_ID); if (empty($this->appliedDateTime)) { $this->appliedDateTime = date(LocaleUtil::STANDARD_TIMESTAMP_FORMAT); } $sqlBuilder = new SQLQBuilder(); $sqlBuilder->table_name = self::TABLE_NAME; $sqlBuilder->flg_insert = 'true'; $sqlBuilder->arr_insert = $this->_getFieldValuesAsArray(); $sqlBuilder->arr_insertfield = $this->dbFields; $sql = $sqlBuilder->addNewRecordFeature2(); $conn = new DMLFunctions(); $result = $conn->executeQuery($sql); if (!$result || mysql_affected_rows() != 1) { throw new JobApplicationException("Insert failed. ", JobApplicationException::DB_ERROR); } return $this->id; }
/** * Add the direct debit information to the database */ public function add() { $nextSeqNum = $this->getNextSeqNum($this->empNumber); $fields[0] = self::DB_FIELD_EMP_NUMBER; $fields[1] = self::DB_FIELD_SEQNO; $fields[2] = self::DB_FIELD_ROUTING_NUM; $fields[3] = self::DB_FIELD_ACCOUNT; $fields[4] = self::DB_FIELD_AMOUNT; $fields[5] = self::DB_FIELD_ACCOUNT_TYPE; $fields[6] = self::DB_FIELD_TRANSACTION_TYPE; $values[0] = "'{$this->empNumber}'"; $values[1] = "'{$nextSeqNum}'"; $values[2] = "'{$this->routingNumber}'"; $values[3] = "'{$this->account}'"; $values[4] = "'{$this->amount}'"; $values[5] = "'{$this->accountType}'"; $values[6] = "'{$this->transactionType}'"; $sqlBuilder = new SQLQBuilder(); $sqlBuilder->table_name = self::TABLE_NAME; $sqlBuilder->flg_insert = 'true'; $sqlBuilder->arr_insert = $values; $sqlBuilder->arr_insertfield = $fields; $sql = $sqlBuilder->addNewRecordFeature2(); $conn = new DMLFunctions(); $result = $conn->executeQuery($sql); if (!$result || mysql_affected_rows() != 1) { return false; } else { return true; } }