public function filterExistingMembershipTypes() { $selectFields[] = '`membtype_code`'; $selectFields[] = '`membtype_name`'; $selectTable = $this->tableName; $sqlBuilder = new SQLQBuilder(); $description = $sqlBuilder->quoteCorrectString($this->getMemDescription()); $selectConditions[] = "`membtype_name` = {$description}"; $query = $sqlBuilder->simpleSelect($selectTable, $selectFields, $selectConditions); $dbConnection = new DMLFunctions(); $result = $dbConnection->executeQuery($query); $cnt = 0; while ($row = mysql_fetch_array($result, MYSQL_NUM)) { $existingMembershipTypes[$cnt++] = $row; } if (isset($existingMembershipTypes)) { return $existingMembershipTypes; } else { $existingMembershipTypes = ''; return $existingMembershipTypes; } }
public function filterExistingCustomers() { $sqlBuilder = new SQLQBuilder(); $customerName = $sqlBuilder->quoteCorrectString($this->getCustomerName(), true, true); $selectFields[] = '`customer_id`'; $selectFields[] = '`name`'; $selectTable = self::TABLE_NAME; $selectConditions[] = "`name` = '{$customerName}'"; $query = $sqlBuilder->simpleSelect($selectTable, $selectFields, $selectConditions); $dbConnection = new DMLFunctions(); $result = $dbConnection->executeQuery($query); $cnt = 0; while ($row = mysql_fetch_array($result, MYSQL_NUM)) { $existingCustomers[$cnt++] = $row; } if (isset($existingCustomers)) { return $existingCustomers; } else { $existingCustomers = ''; return $existingCustomers; } }
public function filterExistingEducations() { $selectFields[] = '`edu_code`'; $selectFields[] = '`edu_uni`'; $selectFields[] = '`edu_deg`'; $selectTable = $this->tableName; $sqlBuilder = new SQLQBuilder(); $institute = $sqlBuilder->quoteCorrectString($this->getEduUni(), true, true); $course = $sqlBuilder->quoteCorrectString($this->getEduDeg(), true, true); $selectConditions[] = "`edu_deg` = '{$course}'"; $selectConditions[] = "`edu_uni` = '{$institute}'"; $query = $sqlBuilder->simpleSelect($selectTable, $selectFields, $selectConditions); $dbConnection = new DMLFunctions(); $result = $dbConnection->executeQuery($query); $cnt = 0; while ($row = mysql_fetch_array($result, MYSQL_NUM)) { $existingEducations[$cnt++] = $row; } if (isset($existingEducations)) { return $existingEducations; } else { $existingEducations = ''; return $existingEducations; } }
public function filterExistingProjects() { $sqlBuilder = new SQLQBuilder(); $projectName = $sqlBuilder->quoteCorrectString($this->getProjectName(), true, true); $selectFields[] = "`" . self::PROJECT_DB_FIELD_PROJECT_ID . "`"; $selectFields[] = "`" . self::PROJECT_DB_FIELD_CUSTOMER_ID . "`"; $selectFields[] = "`" . self::PROJECT_DB_FIELD_NAME . "`"; $selectTable = self::TABLE_NAME; $selectConditions[] = "`" . self::PROJECT_DB_FIELD_CUSTOMER_ID . "`= '" . $this->getCustomerId() . "'"; $selectConditions[] = "`" . self::PROJECT_DB_FIELD_NAME . "`= '{$projectName}'"; $query = $sqlBuilder->simpleSelect($selectTable, $selectFields, $selectConditions); $dbConnection = new DMLFunctions(); $result = $dbConnection->executeQuery($query); $cnt = 0; while ($row = mysql_fetch_array($result, MYSQL_NUM)) { $existingProjects[$cnt++] = $row; } if (isset($existingProjects)) { return $existingProjects; } else { $existingProjects = ''; return $existingProjects; } }
function getDistrictCodes($getID) { $sql_builder = new SQLQBuilder(); $this->getID = $sql_builder->quoteCorrectString($getID, false); $tableName = 'HS_HR_DISTRICT'; $arrFieldList[0] = 'PROVINCE_CODE'; $arrFieldList[1] = 'DISTRICT_CODE'; $arrFieldList[2] = 'DISTRICT_NAME'; $sql_builder->table_name = $tableName; $sql_builder->flg_select = 'true'; $sql_builder->arr_select = $arrFieldList; $sqlQString = $sql_builder->selectOneRecordFiltered($this->getID); $dbConnection = new DMLFunctions(); $message2 = $dbConnection->executeQuery($sqlQString); //Calling the addData() function $i = 0; while ($line = mysql_fetch_array($message2, MYSQL_NUM)) { for ($c = 0; count($arrFieldList) > $c; $c++) { $arrayDispList[$i][$c] = $line[$c]; } $i++; } if (isset($arrayDispList)) { return $arrayDispList; } else { $arrayDispList = ''; return $arrayDispList; } }
public function filterExistingMembershipInfo() { $tableName = 'hs_hr_membership'; $selectFields[] = '`membship_code`'; $selectFields[] = '`membtype_code`'; $selectFields[] = '`membship_name`'; $selectTable = $tableName; $sqlBuilder = new SQLQBuilder(); $name = $sqlBuilder->quoteCorrectString($this->getMembershipInfoDesc()); $selectConditions[] = "`membtype_code` = '" . $this->getMembershipTypeId() . "'"; $selectConditions[] = "`membship_name` = {$name}"; $query = $sqlBuilder->simpleSelect($selectTable, $selectFields, $selectConditions); $dbConnection = new DMLFunctions(); $result = $dbConnection->executeQuery($query); $cnt = 0; while ($row = mysql_fetch_array($result, MYSQL_NUM)) { $existingMembershipInfo[$cnt++] = $row; } if (isset($existingMembershipInfo)) { return $existingMembershipInfo; } else { $existingMembershipInfo = ''; return $existingMembershipInfo; } }