source: branches/dev/html/admin/products/index_csv.php @ 17

<?php
/*
 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
 *
 * http://www.lockon.co.jp/
 */
require_once(DATA_PATH . "include/csv_output.inc");

$arrREVIEW_CVSCOL = array( 
                        'B.name',
                        'A.status',
                        'A.create_date',
                        'A.reviewer_name',
                        'A.sex',
                        'A.recommend_level',
                        'A.title',
                        'A.comment'
                        );
                        
$arrREVIEW_CVSTITLE = array(
                        '¾¦ÉÊ̾',
                        '¥ì¥Ó¥å¡¼É½¼¨',
                        'Åê¹ÆÆü',
                        'Åê¹Æ¼Ô̾',
                        'À­ÊÌ',
                        '¤ª¤¹¤¹¤á¥ì¥Ù¥ë',
                        '¥¿¥¤¥È¥ë',
                        '¥³¥á¥ó¥È'
                        );

// CSV½ÐÎϥǡ¼¥¿¤òºîÀ®¤¹¤ë¡£(¾¦ÉÊ)
function lfGetProductsCSV($where, $option, $arrval, $arrOutputCols) {
    global $arrPRODUCTS_CVSCOL;

    $from = "vw_product_class AS prdcls";
    $cols = sfGetCommaList($arrOutputCols);
    
    $objQuery = new SC_Query();
    $objQuery->setoption($option);
    
    $list_data = $objQuery->select($cols, $from, $where, $arrval);
    $max = count($list_data);
    
    // µ¬³ÊʬÎà̾°ìÍ÷
    $arrClassCatName = sfGetIDValueList("dtb_classcategory", "classcategory_id", "name");
    
    for($i = 0; $i < $max; $i++) {
        // ´ØÏ¢¾¦ÉʾðÊó¤ÎÉÕÍ¿
        $list_data[$i]['classcategory_id1'] = $arrClassCatName[$list_data[$i]['classcategory_id1']];
        $list_data[$i]['classcategory_id2'] = $arrClassCatName[$list_data[$i]['classcategory_id2']];
        
        // ³Æ¹àÌܤòCSV½ÐÎÏÍѤËÊÑ´¹¤¹¤ë¡£
        $data .= lfMakeProductsCSV($list_data[$i]); 
    }
    return $data;
}

// CSV½ÐÎϥǡ¼¥¿¤òºîÀ®¤¹¤ë¡£(¥ì¥Ó¥å¡¼)
function lfGetReviewCSV($where, $option, $arrval) {
    global $arrREVIEW_CVSCOL;

    $from = "dtb_review AS A INNER JOIN dtb_products AS B on A.product_id = B.product_id ";
    $cols = sfGetCommaList($arrREVIEW_CVSCOL);
    
    $objQuery = new SC_Query();
    $objQuery->setoption($option);
    
    $list_data = $objQuery->select($cols, $from, $where, $arrval);  

    $max = count($list_data);
    for($i = 0; $i < $max; $i++) {
        // ³Æ¹àÌܤòCSV½ÐÎÏÍѤËÊÑ´¹¤¹¤ë¡£
        $data .= lfMakeReviewCSV($list_data[$i]);
    }
    return $data;
}

// ³Æ¹àÌܤòCSV½ÐÎÏÍѤËÊÑ´¹¤¹¤ë¡£(¾¦ÉÊ)
function lfMakeProductsCSV($list) {
    global $arrDISP;
    $line = "";
    if(is_array($list)) {
        foreach($list as $key => $val) {
            $tmp = "";
            switch($key) {
            case 'point_rate':
                if($val == "") {
                    $tmp = '0';
                } else {
                    $tmp = $val;
                }
                break;
            default:
                $tmp = $val;
                break;
            }
    
            $tmp = ereg_replace("[\",]", " ", $tmp);
            $line .= "\"".$tmp."\",";
        }
        // ʸËö¤Î","¤òÊÑ´¹
        $line = ereg_replace(",$", "\n", $line);
    }
    return $line;
}


// ³Æ¹àÌܤòCSV½ÐÎÏÍѤËÊÑ´¹¤¹¤ë¡£(¥ì¥Ó¥å¡¼)
function lfMakeReviewCSV($list) {
    global $arrSex;
    global $arrRECOMMEND;
    global $arrDISP;
    
    $line = "";
    
    foreach($list as $key => $val) {
        $tmp = "";
        switch($key) {
        case 'sex':
            $tmp = $arrSex[$val];
            break;
        case 'recommend_level':
            $tmp = $arrRECOMMEND[$val];
            break;
        case 'status':
            $tmp = $arrDISP[$val];
            break;
        default:
            $tmp = $val;
            break;
        }

        $tmp = ereg_replace("[\",]", " ", $tmp);
        $line .= "\"".$tmp."\",";
    }
    // ʸËö¤Î","¤òÊÑ´¹
    $line = ereg_replace(",$", "\n", $line);
    return $line;
}

?>