source: branches/dev/html/admin/total/index_sub.php @ 12022

<?php
/*
 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
 *
 * http://www.lockon.co.jp/
 */
function lfGetPDFColum($page, $type, $key = "") {
    
    $arrSUBNAME['day'] = "ÆüÊÌ";
    $arrSUBNAME['month'] = "·îÊÌ";
    $arrSUBNAME['year'] = "ǯÊÌ";
    $arrSUBNAME['hour'] = "»þ´ÖÊÌ";
    $arrSUBNAME['wday'] = "ÍËÆüÊÌ";
    $arrSUBNAME['all'] = "Á´ÂÎ";
    $arrSUBNAME['member'] = "²ñ°÷";
    $arrSUBNAME['nonmember'] = "Èó²ñ°÷";
            
    switch($page) {
    // ¾¦ÉÊÊ̽¸·×
    case 'products':
        $title = "¾¦ÉÊÊ̽¸·×(" . $arrSUBNAME[$type] . ")";
        $arrColSize = array(
            60,
            120,
            220,
            80,
            80,
            80,
        );
        $arrAlign = array(
            'right',
            'center',
            'right',
            'right',
            'right',
            'right',
        );
        break;
    // ¿¦¶ÈÊ̽¸·×
    case 'job':
        $title = "¿¦¶ÈÊ̽¸·×(" . $arrSUBNAME[$type] . ")";
        $arrColSize = array(
            100,
            100,
            100,
            100,
        );
        $arrAlign = array(
            'right',
            'right',
            'right',
            'right',
        );
        break;
    // ²ñ°÷Ê̽¸·×
    case 'member':
        $title = "²ñ°÷Ê̽¸·×(" . $arrSUBNAME[$type] . ")";
        $arrColSize = array(
            100,
            100,
            100,
            100,
        );
        $arrAlign = array(
            'right',
            'right',
            'right',
            'right',
        );
        break;
    // ǯÂåÊ̽¸·×
    case 'age':
        $title = "ǯÂåÊ̽¸·×(" . $arrSUBNAME[$type] . ")";
        $arrColSize = array(
            80,
            100,
            100,
            100,
        );
        $arrAlign = array(
            'right',
            'right',
            'right',
            'right',
        );
        break;
    // ´ü´ÖÊ̽¸·×
    default:
        $title = "´ü´ÖÊ̽¸·×(" . $arrSUBNAME[$type] . ")";
        $arrColSize = array(
            60,
            60,
            50,
            50,
            80,
            80,
            80,
            80,
            80,
            80,
        );
        $arrAlign = array(
            'right',
            'right',
            'right',
            'right',
            'right',
            'right',
            'right',
            'right',
            'right',
            'right',
        );
        break;
    }
    
    list($arrTitleCol, $arrDataCol) = lfGetCSVColum($page, $key);
        
    return array($arrTitleCol, $arrDataCol, $arrColSize, $arrAlign, $title);
}


function lfGetCSVColum($page, $key = "") {
    switch($page) {
    // ¾¦ÉÊÊ̽¸·×
    case 'products':
        $arrTitleCol = array(
            '¾¦ÉÊÈÖ¹æ',
            '¾¦ÉÊ̾',
            '¹ØÆþ·ï¿ô',
            'ÅÀ¿ô',
            'ñ²Á',
            '¶â³Û'          
        );
        $arrDataCol = array(
            'product_code',
            'product_name',
            'order_count',
            'products_count',
            'price',
            'total',
        );
        break;
    // ¿¦¶ÈÊ̽¸·×
    case 'job':
        $arrTitleCol = array(
            '¿¦¶È',
            '¹ØÆþ·ï¿ô',
            '¹ØÆþ¹ç·×',
            '¹ØÆþÊ¿¶Ñ',
        );
        $arrDataCol = array(
            'job_name',
            'order_count',
            'total',
            'total_average',
        );
        break;
    // ²ñ°÷Ê̽¸·×
    case 'member':
        $arrTitleCol = array(
            '²ñ°÷',
            '¹ØÆþ·ï¿ô',
            '¹ØÆþ¹ç·×',
            '¹ØÆþÊ¿¶Ñ',
        );
        $arrDataCol = array(
            'member_name',
            'order_count',
            'total',
            'total_average',
        );
        break;
    // ǯÂåÊ̽¸·×
    case 'age':
        $arrTitleCol = array(
            'ǯÎð',
            '¹ØÆþ·ï¿ô',
            '¹ØÆþ¹ç·×',
            '¹ØÆþÊ¿¶Ñ',
        );
        $arrDataCol = array(
            'age_name',
            'order_count',
            'total',
            'total_average',
        );
        break;
    // ´ü´ÖÊ̽¸·×
    default:
        $arrTitleCol = array(
            '´ü´Ö',
            '¹ØÆþ·ï¿ô',
            'ÃËÀ­',
            '½÷À­',
            'ÃËÀ­(²ñ°÷)',
            'ÃËÀ­(Èó²ñ°÷)',
            '½÷À­(²ñ°÷)',
            '½÷À­(Èó²ñ°÷)',
            '¹ØÆþ¹ç·×',
            '¹ØÆþÊ¿¶Ñ',     
        );
        $arrDataCol = array(
            $key,
            'total_order',
            'men',
            'women',
            'men_member',
            'men_nonmember',
            'women_member',
            'women_nonmember',
            'total',
            'total_average'
        );
        break;
    }
    
    return array($arrTitleCol, $arrDataCol);
}

// ɬÍפʥ«¥é¥à¤Î¤ßÃê½Ð¤¹¤ë(CSV¥Ç¡¼¥¿¤Ç¼èÆÀ¤¹¤ë)
function lfGetDataColCSV($arrData, $arrDataCol) {
    $max = count($arrData);
    for($i = 0; $i < $max; $i++) {
        foreach($arrDataCol as $val) {      
            $arrRet[$i][$val] = $arrData[$i][$val];
        }
        $csv_data.= sfGetCSVList($arrRet[$i]);
    }
    return $csv_data;
}

// ɬÍפʥ«¥é¥à¤Î¤ßÃê½Ð¤¹¤ë(PDF¥Ç¡¼¥¿¤Ç¼èÆÀ¤¹¤ë)
function lfGetDataColPDF($arrData, $arrDataCol, $len) {
    $max = count($arrData);
    for($i = 0; $i < $max; $i++) {
        foreach($arrDataCol as $val) {      
            $arrRet[$i][$val] = sfCutString($arrData[$i][$val], $len);
        }
        $csv_data.= sfGetPDFList($arrRet[$i]);
    }
    return $csv_data;
}


?>