Exemplo n.º 1
0
 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;
     }
 }
Exemplo n.º 2
0
 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;
     }
 }
Exemplo n.º 3
0
 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;
     }
 }
Exemplo n.º 4
0
 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;
     }
 }
Exemplo n.º 5
0
 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;
     }
 }
Exemplo n.º 6
0
 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;
     }
 }