Changeset 18892 for branches/version-2_5-dev/data/class/helper/SC_Helper_DB.php

Timestamp:

2010/11/05 05:08:06 (13 years ago)

Author:

Seasoft

Message:

#642(共通ロジックの機能向上)

• SC_Helper_DB#sfGetIDValueList をWHERE句対応

File:

• branches/version-2_5-dev/data/class/helper/SC_Helper_DB.php (modified) (1 diff)

branches/version-2_5-dev/data/class/helper/SC_Helper_DB.php

@@ -1107 +1107 @@
      * @param string $keyname プライマリーキーのカラム名
      * @param string $valname データ内容のカラム名
+     * @param string $where WHERE句
+     * @param array $arrval プレースホルダ
      * @return array SELECT ボックス用リストの配列
      */
-    function sfGetIDValueList($table, $keyname, $valname) {
+    function sfGetIDValueList($table, $keyname, $valname, $where = '', $arrVal = array()) {
         $objQuery =& SC_Query::getSingletonInstance();
         $col = "$keyname, $valname";
         $objQuery->setWhere("del_flg = 0");
         $objQuery->setOrder("rank DESC");
-        $arrList = $objQuery->select($col, $table);
+        $arrList = $objQuery->select($col, $table, $where, $arrVal);
         $count = count($arrList);
         for($cnt = 0; $cnt < $count; $cnt++) {