source: branches/dev/html/admin/system/member_csv.php @ 8

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

// ǧ¾Ú²ÄÈݤÎȽÄê
$objSess = new SC_Session();
sfIsSuccess($objSess);

$data = lfGetCSVData();
sfCSVDownload($data);
exit();

function lfGetCSVData() {
    global $arrAUTHORITY;
    global $arrWORK;
    
    $oquery = new SC_Query();
    $cols = "authority,name,department,login_id,work";
    $oquery->setwhere("del_flg <> 1");
    $oquery->andwhere("member_id <> ".ADMIN_ID);
    $oquery->setoption("ORDER BY rank DESC");
    $list_data = $oquery->select($cols, "dtb_member");
    $max = count($list_data);
    
    for($i = 0; $i < $max; $i++ ){
        $line = "";
        $line .= "\"".$arrAUTHORITY[$list_data[$i]['authority']]."\",";
        $tmp = ereg_replace("\"","\"\"",$list_data[$i]['name']);
        $line .= "\"".$tmp."\",";
        $tmp = ereg_replace("\"","\"\"",$list_data[$i]['department']);
        $line .= "\"".$tmp."\",";
        $tmp = ereg_replace("\"","\"\"",$list_data[$i]['login_id']);
        $line .= "\"".$tmp."\",";
        $line .= "\"".$arrWORK[$list_data[$i]['work']]."\"\n";
        $data .= $line;
    }
    
    $header = "\"¸¢¸Â\",\"̾Á°\",\"½ê°\",\"¥í¥°¥¤¥óID\",\"²ÔƯ¾õ¶·\"\n";
    
    return $header.$data;
}
?>