public function actionExport()
{
$time = \App::$app->request->post()['time'];
$arr[0] = 0;
$arr[1] = 0;
if ($time) {
$arr = explode('至', \App::$app->request->post()['time']);
$arr[0] = strtotime($arr[0] . ' 00:00:00');
$arr[1] = strtotime($arr[1] . ' 23:59:59');
}
$users = $this->memberList($arr[0], $arr[1]);
Utils::exportExcel($users, ['ID', '用户名', '电话', '邮箱', '身份证', '真实姓名', '状态', '注册时间', '登陆IP'], '用户信息' . date('Y.m.d'));
}
public function actionExportuser()
{
$users = UcenterMember::find()->asArray()->all();
$data = array();
if ($users !== null) {
foreach ($users as $key => $value) {
$data[$key]['id'] = $value['id'];
$data[$key]['phone'] = $value['phone'];
$data[$key]['real_name'] = $value['real_name'];
$data[$key]['created_at'] = date('Y-m-d :H-m-s', $value['created_at']);
$data[$key]['create_area'] = $value['create_area'];
$status = $value['status'];
if ($status == UcenterMember::STATUS_ACTIVE) {
$data[$key]['status'] = '注册用户';
} elseif ($status == UcenterMember::STATUS_REAL) {
$data[$key]['status'] = '实名用户';
} elseif ($status == UcenterMember::STATUS_BIND) {
$data[$key]['status'] = '绑卡用户';
}
//账户信息
$info = Info::find()->where(['member_id' => $value['id']])->one();
//账户余额
$data[$key]['balance'] = $info['balance'];
//在投资金
$data[$key]['invest'] = $info['invest'];
//可用收益
$data[$key]['profit'] = $info['profit'];
//累计收益
$data[$key]['total_revenue'] = $info['total_revenue'];
//充值--投资--赎回--提现
//首次充值
$rechar_at = Log::find()->where(['member_id' => $value['id'], 'status' => Log::STATUS_RECHAR_SUC])->orderBy('id asc')->one();
//充值总金额
$rechar_sum = Log::find()->where(['member_id' => $value['id'], 'status' => Log::STATUS_RECHAR_SUC])->sum('step');
//首次投资时间
$invest_at = Log::find()->where(['member_id' => $value['id'], 'status' => Log::STATUS_INVEST_SUC])->orderBy('id asc')->one();
//投资总额
$invest_sum = Log::find()->where(['member_id' => $value['id'], 'status' => Log::STATUS_INVEST_SUC])->sum('step');
//赎回总额
$redem_sum = Log::find()->where(['member_id' => $value['id'], 'status' => Log::STATUS_REDEM_SUC])->sum('step');
//提现总额
$withdraw_sum = Log::find()->where(['member_id' => $value['id'], 'status' => Log::STATUS_WITHDRAW_SUC])->sum('step');
//首次充值时间
$data[$key]['rechar_at'] = $rechar_at ? date('Y-m-d :H-m-s', $rechar_at['create_at']) : 0;
$data[$key]['rechar_sum'] = $rechar_sum;
//首次投资时间
$data[$key]['invest_at'] = $invest_at ? date('Y-m-d :H-m-s', $invest_at['create_at']) : 0;
$data[$key]['invest_sum'] = $invest_sum;
//赎回
$data[$key]['redem_sum'] = $redem_sum;
//提现
$data[$key]['withdraw_sum'] = $withdraw_sum;
//未领取红包奖励
$red = member::get_user_red_packet($value['id']);
$data[$key]['red_usable'] = $red['data']['red_sum'];
//总的红包奖励
$red1 = member::get_rad_list($value['id']);
$data[$key]['red_sum'] = $red1['data']['sum'];
}
return Utils::exportExcel($data, array('用户id', '用户手机号', '用户真实姓名', '用户注册时间', '用户注册地区', '用户状态', '用户账户余额', '在投资金', '可用收益', '累计收益', '首次充值时间', '充值总金额', '首次投资时间', '投资总额', '赎回总额', '提现总额', '未领取红包', '红包奖励总额'), '数据分析' . date('Y-m-d-H-m-s'));
}
}
public function actionExport()
{
$time = \App::$app->request->post()['time'];
$arr[0] = 0;
$arr[1] = 0;
if ($time) {
$arr = explode('至', \App::$app->request->post()['time']);
$arr[0] = strtotime($arr[0] . ' 00:00:00');
$arr[1] = strtotime($arr[1] . ' 23:59:59');
}
$logs = $this->logList($arr[0], $arr[1]);
Utils::exportExcel($logs, ['ID', '金额', '状态', '银行卡', '创建时间', '用户名'], '资金记录导出' . date('Y.m.d'));
}
