当前位置: 首页>>代码示例>>PHP>>正文


PHP SQLQBuilder::passResultSetMessage方法代码示例

本文整理汇总了PHP中SQLQBuilder::passResultSetMessage方法的典型用法代码示例。如果您正苦于以下问题:PHP SQLQBuilder::passResultSetMessage方法的具体用法?PHP SQLQBuilder::passResultSetMessage怎么用?PHP SQLQBuilder::passResultSetMessage使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在SQLQBuilder的用法示例。


在下文中一共展示了SQLQBuilder::passResultSetMessage方法的11个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: getListofDistrictInfo

 function getListofDistrictInfo($pageNO, $schStr, $mode)
 {
     $tableName = 'HS_HR_DISTRICT';
     $arrFieldList[0] = 'DISTRICT_CODE';
     $arrFieldList[1] = 'DISTRICT_NAME';
     $arrFieldList[2] = 'PROVINCE_CODE';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $sqlQString = $sql_builder->passResultSetMessage($pageNO, $schStr, $mode);
     //echo $sqlQString;
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     $i = 0;
     while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
         $arrayDispList[$i][0] = $line[0];
         $arrayDispList[$i][1] = $line[1];
         $i++;
     }
     if (isset($arrayDispList)) {
         return $arrayDispList;
     } else {
         $arrayDispList = '';
         return $arrayDispList;
     }
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:28,代码来源:DistrictInfo.php

示例2: getAllMembershipCodes

 function getAllMembershipCodes()
 {
     $tableName = 'HS_HR_MEMBERSHIP';
     $arrFieldList[0] = 'MEMBTYPE_CODE';
     $arrFieldList[1] = 'MEMBSHIP_CODE';
     $arrFieldList[2] = 'MEMBSHIP_NAME';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $sqlQString = $sql_builder->passResultSetMessage();
     //echo $sqlQString;
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     $i = 0;
     while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
         $arrayDispList[$i][0] = $line[0];
         $arrayDispList[$i][1] = $line[1];
         $arrayDispList[$i][2] = $line[2];
         $i++;
     }
     if (isset($arrayDispList)) {
         return $arrayDispList;
     } else {
         $arrayDispList = '';
         return $arrayDispList;
     }
 }
开发者ID:googlecode-mirror,项目名称:pucit-orangehrm,代码行数:29,代码来源:MembershipInfo.php

示例3: getCountryCodes

 function getCountryCodes()
 {
     $sql_builder = new SQLQBuilder();
     $tableName = 'HS_HR_COUNTRY';
     $arrFieldList[0] = 'COU_CODE';
     $arrFieldList[1] = 'COU_NAME';
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $sqlQString = $sql_builder->passResultSetMessage(0, '', -1, 1);
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     $common_func = new CommonFunctions();
     $i = 0;
     while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
         $arrayDispList[$i][0] = $line[0];
         $arrayDispList[$i][1] = $line[1];
         //$arrayDispList[$i][2] = $line[2];
         $i++;
     }
     if (isset($arrayDispList)) {
         return $arrayDispList;
     } else {
         //Handle Exceptions
         //Create Logs
     }
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:28,代码来源:ProvinceInfo.php

示例4: getListofRepEmployee

 function getListofRepEmployee($pageNO = 0, $schStr = '', $mode = 0)
 {
     $tableName = 'HS_HR_EMPLOYEE';
     $arrFieldList[0] = 'EMP_NUMBER';
     $arrFieldList[1] = 'EMP_LASTNAME';
     $arrFieldList[2] = 'EMPLOYEE_ID';
     $arrFieldList[3] = 'EMP_FIRSTNAME';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $sqlQString = $sql_builder->passResultSetMessage($pageNO, $schStr, $mode);
     //echo $sqlQString;
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     $i = 0;
     while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
         $arrayDispList[$i][0] = $line[0];
         $arrayDispList[$i][1] = $line[1];
         $arrayDispList[$i][2] = $line[2];
         $arrayDispList[$i][3] = $line[3];
         $i++;
     }
     if (isset($arrayDispList)) {
         return $arrayDispList;
     } else {
         $arrayDispList = '';
         return $arrayDispList;
     }
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:31,代码来源:EmpInfo.php

示例5: getCustomExportListForView

 /**
  * Get list of defined Custom Exports in format suitable for view.php
  * @return Array 2D array representing custom export objects defined in database.
  */
 public static function getCustomExportListForView($pageNO, $schStr, $mode, $sortField = 0, $sortOrder = 'ASC')
 {
     $tableName = self::TABLE_NAME;
     $arrFieldList[0] = self::DB_FIELDS_ID;
     $arrFieldList[1] = self::DB_FIELDS_NAME;
     $arrFieldList[2] = self::DB_FIELDS_FIELDS;
     $arrFieldList[3] = self::DB_FIELDS_HEADINGS;
     $sqlBuilder = new SQLQBuilder();
     $sqlBuilder->table_name = $tableName;
     $sqlBuilder->flg_select = 'true';
     $sqlBuilder->arr_select = $arrFieldList;
     $sqlQString = $sqlBuilder->passResultSetMessage($pageNO, $schStr, $mode, $sortField, $sortOrder);
     $dbConnection = new DMLFunctions();
     $result = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     $i = 0;
     while ($line = mysql_fetch_array($result, MYSQL_NUM)) {
         $arrayDispList[$i][0] = $line[0];
         $arrayDispList[$i][1] = $line[1];
         $arrayDispList[$i][2] = $line[2];
         $i++;
     }
     if (isset($arrayDispList)) {
         return $arrayDispList;
     } else {
         $arrayDispList = '';
         return $arrayDispList;
     }
 }
开发者ID:googlecode-mirror,项目名称:pucit-orangehrm,代码行数:33,代码来源:CustomExport.php

示例6: getJobTit

 function getJobTit()
 {
     $sql_builder = new SQLQBuilder();
     $tableName = 'HS_HR_JOB_TITLE';
     $arrFieldList[0] = 'JOBTIT_CODE';
     $arrFieldList[1] = 'JOBTIT_NAME';
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $specialSearch = "`" . self::DB_FIELD_IS_ACTIVE . "` = " . self::ACTIVE_JOB_TITLE;
     $sqlQString = $sql_builder->passResultSetMessage(0, '', -1, 1, 'ASC', false, $specialSearch);
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     $common_func = new CommonFunctions();
     $i = 0;
     while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
         $arrayDispList[$i][0] = $line[0];
         $arrayDispList[$i][1] = $line[1];
         $i++;
     }
     if (isset($arrayDispList)) {
         return $arrayDispList;
     } else {
         //Handle Exceptions
         //Create Logs
     }
 }
开发者ID:THM068,项目名称:orangehrm,代码行数:28,代码来源:JobTitle.php

示例7: getListForView

 /**
  * Get list of job specs in a format suitable for view.php
  */
 public static function getListForView($pageNO = 0, $schStr = '', $mode = -1, $sortField = 0, $sortOrder = 'ASC')
 {
     $arrFieldList[0] = self::DB_FIELD_ID;
     $arrFieldList[1] = self::DB_FIELD_NAME;
     $arrFieldList[2] = self::DB_FIELD_DESC;
     $sqlBuilder = new SQLQBuilder();
     $sqlBuilder->table_name = self::TABLE_NAME;
     $sqlBuilder->flg_select = 'true';
     $sqlBuilder->arr_select = $arrFieldList;
     $sqlQString = $sqlBuilder->passResultSetMessage($pageNO, $schStr, $mode, $sortField, $sortOrder);
     $dbConnection = new DMLFunctions();
     $result = $dbConnection->executeQuery($sqlQString);
     $i = 0;
     $arrayDispList = null;
     while ($line = mysql_fetch_assoc($result)) {
         $arrayDispList[$i][0] = $line[self::DB_FIELD_ID];
         $arrayDispList[$i][1] = $line[self::DB_FIELD_NAME];
         $arrayDispList[$i][2] = $line[self::DB_FIELD_DESC];
         $i++;
     }
     return $arrayDispList;
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:25,代码来源:JobSpec.php

示例8: getNationCodes

 function getNationCodes()
 {
     $sql_builder = new SQLQBuilder();
     $tableName = 'HS_HR_NATIONALITY';
     $arrFieldList[0] = 'NAT_CODE';
     $arrFieldList[1] = 'NAT_NAME';
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $sqlQString = $sql_builder->passResultSetMessage();
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     $common_func = new CommonFunctions();
     $i = 0;
     while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
         $arrayDispList[$i][0] = $line[0];
         $arrayDispList[$i][1] = $line[1];
         $i++;
     }
     if (isset($arrayDispList)) {
         return $arrayDispList;
     }
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:24,代码来源:NationalityInfo.php

示例9: getSalGrdCodes

 public function getSalGrdCodes()
 {
     $tableName = 'HS_PR_SALARY_GRADE';
     $arrFieldList[0] = 'SAL_GRD_CODE';
     $arrFieldList[1] = 'SAL_GRD_NAME';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $sqlQString = $sql_builder->passResultSetMessage(0, '', -1, 1);
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     $i = 0;
     while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
         $arrayDispList[$i][0] = $line[0];
         $arrayDispList[$i][1] = $line[1];
         $i++;
     }
     if (isset($arrayDispList)) {
         return $arrayDispList;
     } else {
         $arrayDispList = '';
         return $arrayDispList;
     }
 }
开发者ID:THM068,项目名称:orangehrm,代码行数:26,代码来源:SalaryGrades.php

示例10: getAllEducation

 function getAllEducation()
 {
     $tableName = 'HS_HR_EDUCATION';
     $arrFieldList[0] = 'EDU_CODE';
     $arrFieldList[1] = 'EDU_UNI';
     $arrFieldList[2] = 'EDU_DEG';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $sqlQString = $sql_builder->passResultSetMessage(0, '', -1, 2);
     //echo $sqlQString;
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     $i = 0;
     while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
         $arrayDispList[$i][0] = $line[0];
         $arrayDispList[$i][1] = $line[1];
         $arrayDispList[$i][2] = $line[2];
         $i++;
     }
     if (isset($arrayDispList)) {
         return $arrayDispList;
     } else {
         $arrayDispList = '';
         return $arrayDispList;
     }
 }
开发者ID:googlecode-mirror,项目名称:pucit-orangehrm,代码行数:29,代码来源:Education.php

示例11: getEmployeeCodes

 function getEmployeeCodes()
 {
     $tableName = 'HS_HR_EMPLOYEE';
     $arrFieldList[0] = 'LPAD(`EMP_NUMBER`, ' . $this->employeeIdLength . ', 0)';
     $arrFieldList[1] = 'EMP_FIRSTNAME';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $sqlQString = $sql_builder->passResultSetMessage();
     //echo $sqlQString;
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     //echo mysql_error();
     $i = 0;
     while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
         $arrayDispList[$i][0] = $line[0];
         $arrayDispList[$i][1] = $line[1];
         $i++;
     }
     if (isset($arrayDispList)) {
         return $arrayDispList;
     } else {
         $arrayDispList = '';
         return $arrayDispList;
     }
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:28,代码来源:Users.php


注:本文中的SQLQBuilder::passResultSetMessage方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。