public function exportinfo()
{
/* 权限检查 订单列表 */
role::check('user_draw_money_review');
if (empty($_POST)) {
remind::set(Kohana::lang('o_global.bad_request'), 'order/user_draw_money/index/hascharge');
}
$request_data = $this->input->post();
if (empty($request_data['order_ids'])) {
remind::set(Kohana::lang('o_global.bad_request'), 'order/user_draw_money/index/hascharge');
}
$user_draw_moeny = User_draw_moneyService::get_instance();
$query_struct = array();
$query_struct['where']['id'] = $request_data['order_ids'];
$results = $user_draw_moeny->query_assoc($query_struct);
$expexcel = array();
$m = 0;
$expexcel[$m] = array('日期', '总金额', '总笔数', '支付宝帐号', '', '', '', '', '', '');
$all_money = 0;
$all_count = 0;
$infos = array();
foreach ($results as $key => $value) {
$row = array();
$row[] = ' ' . $value['id'];
$row[] = $value['truename'];
$row[] = ' ' . $value['account'];
$row[] = $value['bank_name'];
$row[] = $value['province'];
$row[] = $value['city'];
$row[] = $value['bank_found'];
$row[] = $value['money'];
$row[] = ' 2';
$row[] = $value['memo'];
//str_replace("\n", ";", $value['memo']);
$all_money = $all_money + $value['money'];
$infos[] = $row;
$all_count++;
}
$alipay_config = Kohana::config('site_config.site.alipay_account');
$m++;
$expexcel[$m][] = date('Y-m-d');
$expexcel[$m][] = ' ' . $all_money;
$expexcel[$m][] = ' ' . $all_count;
$expexcel[$m][] = $alipay_config;
$expexcel[$m][] = '';
$expexcel[$m][] = '';
$expexcel[$m][] = '';
$expexcel[$m][] = '';
$expexcel[$m][] = '';
$expexcel[$m][] = '';
$m++;
$expexcel[$m] = array('商户流水号', '收款银行户名', '收款银行帐号', '收款开户银行', '收款银行所在省份', '收款银行所在市', '收款支行名称', '金额', '对公对私标志', '备注');
$expexcel = array_merge($expexcel, $infos);
myexcel::get_instance()->get_excel_from_rows($expexcel, '会员提现财务导出');
//添加日志
$logs_data = array();
$logs_data['manager_id'] = $this->manager_id;
$logs_data['user_log_type'] = 30;
$logs_data['ip'] = tool::get_long_ip();
$logs_data['memo'] = "成功导出选定款项款项,id:" . implode(',', $request_data['order_ids']);
ulog::instance()->add($logs_data);
exit;
}
