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


PHP SQLQBuilder::selectFilter方法代码示例

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


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

示例1: getUnAssMembershipCodes

 function getUnAssMembershipCodes($eno, $typ)
 {
     $sql_builder = new SQLQBuilder();
     $tableName = 'HS_HR_MEMBERSHIP';
     $arrFieldList[0] = 'MEMBSHIP_CODE';
     $arrFieldList[1] = 'MEMBSHIP_NAME';
     $arrFieldList[2] = 'MEMBTYPE_CODE';
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $sql_builder->field = 'MEMBSHIP_CODE';
     $sql_builder->table2_name = 'HS_HR_EMP_MEMBER_DETAIL';
     $arr1[0][0] = 'EMP_NUMBER';
     $arr1[0][1] = $eno;
     $arr2[0][0] = 'MEMBTYPE_CODE';
     $arr2[0][1] = "'{$typ}'";
     $sqlQString = $sql_builder->selectFilter($arr1, $arr2);
     if (isset($arr2)) {
         $sqlQString = str_replace("ORDER BY MEMBSHIP_CODE", "ORDER BY MEMBSHIP_NAME", $sqlQString);
     }
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     $i = 0;
     while ($line = mysql_fetch_row($message2)) {
         $arrayDispList[$i][0] = $line[0];
         $arrayDispList[$i][1] = $line[1];
         $i++;
     }
     if (isset($arrayDispList)) {
         return $arrayDispList;
     } else {
         //Handle Exceptions
         //Create Logs
     }
 }
开发者ID:googlecode-mirror,项目名称:pucit-orangehrm,代码行数:36,代码来源:MembershipInfo.php

示例2: getEmployeesWithoutWorkshift

 /**
  * Return list of employees who are not assigned to any workshift
  * @return array Array of employees
  */
 public static function getEmployeesWithoutWorkshift()
 {
     $fields[0] = EmpInfo::EMPLOYEE_FIELD_EMP_NUMBER;
     $fields[1] = EmpInfo::EMPLOYEE_FIELD_EMP_ID;
     $fields[2] = EmpInfo::EMPLOYEE_FIELD_FIRST_NAME;
     $fields[3] = EmpInfo::EMPLOYEE_FIELD_MIDDLE_NAME;
     $fields[4] = EmpInfo::EMPLOYEE_FIELD_LAST_NAME;
     $sqlBuilder = new SQLQBuilder();
     $sqlBuilder->table_name = EmpInfo::EMPLOYEE_TABLE_NAME;
     $sqlBuilder->flg_select = 'true';
     $sqlBuilder->arr_select = $fields;
     $sqlBuilder->field = EmpInfo::EMPLOYEE_FIELD_EMP_NUMBER;
     $sqlBuilder->field2 = self::DB_FIELD_EMP_NUMBER;
     $sqlBuilder->table2_name = self::EMPLOYEE_WORKSHIFT_TABLE;
     $sql = $sqlBuilder->selectFilter();
     $connection = new DMLFunctions();
     $result = $connection->executeQuery($sql);
     if ($result === false) {
         throw new WorkshiftException("Error in db query:" . $sql, WorkshiftException::ERROR_IN_DB_QUERY);
     }
     return self::_getEmployeesFromResults($result);
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:26,代码来源:Workshift.php

示例3: getUnAssEmpStat

 function getUnAssEmpStat($jobtit)
 {
     $sql_builder = new SQLQBuilder();
     $tableName = 'hs_hr_empstat';
     $arrFieldList[0] = 'ESTAT_CODE';
     $arrFieldList[1] = 'ESTAT_NAME';
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $sql_builder->field = 'ESTAT_CODE';
     $sql_builder->table2_name = 'HS_HR_JOBTIT_EMPSTAT';
     $arr[0][0] = 'JOBTIT_CODE';
     $arr[0][1] = $jobtit;
     $sqlQString = $sql_builder->selectFilter($arr);
     $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:noikiy,项目名称:owaspbwa,代码行数:31,代码来源:JobTitEmpStat.php

示例4: getUnAssEduCodes

 function getUnAssEduCodes($id)
 {
     $sql_builder = new SQLQBuilder();
     $tableName = 'HS_HR_EDUCATION';
     $arrFieldList[0] = 'EDU_CODE';
     $arrFieldList[1] = 'EDU_DEG';
     $arrFieldList[2] = 'EDU_UNI';
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $sql_builder->field = 'EDU_CODE';
     $sql_builder->table2_name = 'HS_HR_EMP_EDUCATION';
     $arr[0][0] = 'EMP_NUMBER';
     $arr[0][1] = $id;
     $sqlQString = $sql_builder->selectFilter($arr, 1);
     //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:noikiy,项目名称:owaspbwa,代码行数:33,代码来源:EmpEducation.php

示例5: getUnAssLangCodes

 function getUnAssLangCodes($eno)
 {
     $sql_builder = new SQLQBuilder();
     $tableName = 'HS_HR_LANGUAGE';
     $arrFieldList[0] = 'LANG_CODE';
     $arrFieldList[1] = 'LANG_NAME';
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $sql_builder->field = 'MEMBSHIP_CODE';
     $sql_builder->table2_name = 'HS_HR_EMP_MEMBER_DETAIL';
     $arr1[0][0] = 'EMP_NUMBER';
     $arr1[0][1] = $eno;
     $sqlQString = $sql_builder->selectFilter($arr1);
     $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,代码行数:28,代码来源:LanguageInfo.php

示例6: getUnAssUserGroups

 function getUnAssUserGroups($id)
 {
     $sql_builder = new SQLQBuilder();
     $tableName = 'HS_HR_USER_GROUP';
     $arrFieldList[0] = 'USERG_ID';
     $arrFieldList[1] = 'USERG_NAME';
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $sql_builder->field = 'USERG_ID';
     $sql_builder->table2_name = 'HS_HR_EMPREP_USERGROUP';
     $arr[0][0] = 'REP_CODE';
     $arr[0][1] = $id;
     $sqlQString = $sql_builder->selectFilter($arr);
     $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:noikiy,项目名称:owaspbwa,代码行数:31,代码来源:EmpRepUserGroups.php

示例7: getModuleCodes

 function getModuleCodes($id)
 {
     $tableName = 'HS_HR_MODULE';
     $arrFieldList[0] = 'MOD_ID';
     $arrFieldList[1] = 'NAME';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $sql_builder->field = 'MOD_ID';
     $sql_builder->table2_name = 'HS_HR_RIGHTS';
     $arr[0][0] = 'USERG_ID';
     $arr[0][1] = $id;
     $sqlQString = $sql_builder->selectFilter($arr, 1);
     //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,代码行数:31,代码来源:Rights.php

示例8: getUnAssSalCurDet

 function getUnAssSalCurDet($salgrd)
 {
     $sql_builder = new SQLQBuilder();
     $tableName = 'HS_HR_CURRENCY_TYPE';
     $arrFieldList[0] = 'CURRENCY_ID';
     $arrFieldList[1] = 'CURRENCY_NAME';
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $sql_builder->field = 'CURRENCY_ID';
     $sql_builder->table2_name = 'HS_PR_SALARY_CURRENCY_DETAIL';
     $arr[0][0] = 'SAL_GRD_CODE';
     $arr[0][1] = $salgrd;
     $sqlQString = $sql_builder->selectFilter($arr, '', 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];
         $i++;
     }
     if (isset($arrayDispList)) {
         return $arrayDispList;
     } else {
         //Handle Exceptions
         //Create Logs
     }
 }
开发者ID:googlecode-mirror,项目名称:pucit-orangehrm,代码行数:31,代码来源:SalCurDet.php


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