source: branches/feature-module-update/data/include/csv_output.inc @ 15079

Revision 15079, 1.4 KB checked in by nanasess, 17 years ago (diff)

svn:mime-type application/x-httpd-php; charset=UTF-8 設定

  • Property svn:mime-type set to application/x-httpd-php; charset=UTF-8
Line 
1<?php
2/*
3 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
4 *
5 * http://www.lockon.co.jp/
6 */
7
8$arrSubnavi = array(
9    1 => 'product',
10    2 => 'customer',
11    3 => 'order',
12    4 => 'campaign'
13);
14
15$arrSubnaviName = array(
16    1 => '商品管理',
17    2 => '顧客管理',
18    3 => '受注管理',
19    4 => 'キャンペーン'
20);
21
22/**************************************************************************************************************
23 * 関数名  :sfgetCsvOutput
24 * 処理内容 :CSV出力項目を取得する
25 * 引数       :なし
26 * 戻り値  :CSV出力項目
27 **************************************************************************************************************/
28function sfgetCsvOutput($csv_id = "", $where = "", $arrVal = array()){
29    $objQuery = new SC_Query();
30    $arrData = array();
31    $ret = array();
32   
33    $sql = "";
34    $sql .= " SELECT ";
35    $sql .= "     no, ";
36    $sql .= "     csv_id, ";
37    $sql .= "     col, ";
38    $sql .= "     disp_name, ";
39    $sql .= "     rank, ";
40    $sql .= "     status, ";
41    $sql .= "     create_date, ";
42    $sql .= "     update_date ";
43    $sql .= " FROM ";
44    $sql .= "     dtb_csv ";
45   
46    if ($where != "") {
47        $sql .= $where;
48        $arrData = $arrVal;
49    }elseif($csv_id != ""){
50        $sql .= " WHERE csv_id = ? ";
51        $arrData = array($csv_id);
52    }
53   
54    $sql .= " ORDER BY ";
55    $sql .= "     rank , no";
56    $sql .= " ";   
57   
58    $ret = $objQuery->getall($sql, $arrData);
59   
60    return $ret;
61}
62
63?>
Note: See TracBrowser for help on using the repository browser.