|
我有一个插件,里面收集了一些我需要的数据。由于数据量比较大,进数据库导出又比较麻烦。想增加一个功能“导出为CSV格式文件”。有人知道怎么写吗?
public function get_orders_fmt($start = 0, $limit = 0, $sort = '',$type = '',$field=array()){
$orders = $this->get_orders($start, $limit, $sort,$type,$field);
$return = array();
foreach ($orders as $key => $value) {
$return[$key]['oid'] = $value['oid'];
$return[$key]['kid'] = $value['kid'] > 0 ? $value['kid'] : '';
$return[$key]['hid'] = $value['hid'] > 0 ? $value['hid'] : '';
$return[$key]['ispayed'] = $value['ispayed']? lang('plugin/myplugin_name', 'payed_success') : lang('plugin/myplugin_name', 'payed_unsuccess');
$return[$key]['issend'] = $value['issend'] ? lang('plugin/myplugin_name', 'send_success') : lang('plugin/myplugin_name', 'send_unsuccess');
$return[$key]['isselled'] = $value['isselled'] ? lang('plugin/myplugin_name', 'selled') : lang('plugin/myplugin_name', 'unselled');
$return[$key]['selltimes'] = $value['selltimes'];
$return[$key]['ka_name'] = $value['ka_name'];
$return[$key]['ka_sec'] = $value['ka_sec'];
$return[$key]['ka_price'] = intval($value['ka_price']) / 100;
$return[$key]['buyer_email'] = $value['buyer_email'];
$return[$key]['buyer_mobile'] = $value['buyer_mobile'];
$return[$key]['buyer_icnum'] = $value['buyer_icnum'];
$return[$key]['buyer_name'] = $value['buyer_name'];
$return[$key]['buyer_company'] = $value['buyer_company'];
$return[$key]['buyer_title'] = $value['buyer_title'];
$return[$key]['buyer_uid'] = $this->get_usernamebyuid($value['uid']);
$return[$key]['out_trade_no'] = $value['out_trade_no'];
$return[$key]['checknum'] = $value['checknum']? lang('plugin/myplugin_name', 'check_success') : lang('plugin/myplugin_name', 'check_unsuccess');
$return[$key]['dateline'] = date('Y-m-d',$value['dateline']);
$return[$key]['pay_time'] = $value['pay_time'] ? date('Y-m-d H:i:s',$value['pay_time']) : $value['pay_time'];
$return[$key]['act'] = '';
}
return $return;
} 如何将显示的数据全部导出为CSV文件啊?如果遇到分页显示,能一次性全部导出完吗?
|
|