source: branches/dev/data/include/csv_output.inc @ 17

<?php
/*
 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
 *
 * http://www.lockon.co.jp/
 */

$arrSubnavi = array(
    1 => 'product',
    2 => 'customer',
    3 => 'order',
    4 => 'campaign'
);

$arrSubnaviName = array(
    1 => '¾¦ÉÊ´ÉÍý',
    2 => '¸ÜµÒ´ÉÍý',
    3 => '¼õÃí´ÉÍý',
    4 => '¥­¥ã¥ó¥Ú¡¼¥ó'
);

/**************************************************************************************************************
 * ´Ø¿ô̾   ¡§sfgetCsvOutput
 * ½èÍýÆâÍÆ ¡§CSV½ÐÎϹàÌܤò¼èÆÀ¤¹¤ë
 * °ú¿ô     ¡§¤Ê¤·
 * Ìá¤êÃÍ   ¡§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;
}

?>