Changeset 15566 for branches/feature-module-update/data

Timestamp:

2007/09/03 19:55:29 (17 years ago)

Author:

nanasess

Message:

index_csv.inc から関数を移植

File:

• branches/feature-module-update/data/class/helper/SC_Helper_CSV.php (modified) (1 diff)

branches/feature-module-update/data/class/helper/SC_Helper_CSV.php

@@ -53 +53 @@
     // }}}
     // {{{ functions
+
+    /**
+     * CSV 項目を出力する.
+     *
+     * @param integer $csv_id CSV ID
+     * @param string $where SQL の WHERE 句
+     * @param array $arrVal WHERE 句の要素
+     * @return array CSV 項目の配列
+     */
+    function sfgetCsvOutput($csv_id = "", $where = "", $arrVal = array()){
+        $objQuery = new SC_Query();
+        $arrData = array();
+        $ret = array();
+
+        $sql = "";
+        $sql .= " SELECT ";
+        $sql .= "     no, ";
+        $sql .= "     csv_id, ";
+        $sql .= "     col, ";
+        $sql .= "     disp_name, ";
+        $sql .= "     rank, ";
+        $sql .= "     status, ";
+        $sql .= "     create_date, ";
+        $sql .= "     update_date ";
+        $sql .= " FROM ";
+        $sql .= "     dtb_csv ";
+
+        if ($where != "") {
+            $sql .= $where;
+            $arrData = $arrVal;
+        }elseif($csv_id != ""){
+            $sql .= " WHERE csv_id = ? ";
+            $arrData = array($csv_id);
+        }
+
+        $sql .= " ORDER BY ";
+        $sql .= "     rank , no";
+        $sql .= " ";
+
+        $ret = $objQuery->getall($sql, $arrData);
+
+        return $ret;
+    }