public function __construct()
{
parent::__construct();
$orderModel = new \Loan\Model\OrderModel();
$this->_type = $orderModel->getType();
$this->_status = $orderModel->getStatus();
}
public function __construct()
{
parent::__construct();
$orderModel = new \Loan\Model\OrderModel();
$this->_field_text_map['order_type'] = $this->_order_type = $orderModel->getType();
$this->_field_text_map['status'] = $this->_status = $orderModel->getStatus();
}
protected function _detail($uid)
{
$model = M()->table('zj_user_red_packet r')->join('zj_user u on u.uid=r.uid');
$user = $model->where(['r.uid' => $uid])->find() or $this->error('找不到此用户信息！');
$this->assign('user', $user);
// 未完成记录
$orderModel = new \Loan\Model\OrderModel();
$model = M()->table('zj_loan_order_red_packet r')->join('zj_loan_order o on o.id=r.order_id');
$order = $model->field('r.*,o.status order_status')->where(['r.uid' => $uid])->order('r.created desc')->select();
int_to_string($order, ['order_status' => $orderModel->getStatus(), 'status' => ['0' => '待完成', '1' => '已完成', '2' => '已关闭']]);
$this->assign('_order', $order);
// 红包记录
$log = M('user_red_packet_log')->where(['uid' => $uid])->order('created desc')->select();
int_to_string($log, ['action' => ['1' => '订单完成', '2' => '提现']]);
$this->assign('_log', $log);
// 提现记录
$withdraw = M('user_red_packet_withdraw')->where(['uid' => $uid])->order('created desc')->select();
int_to_string($withdraw, ['status' => ['0' => '待审核', '1' => '审核通过', '2' => '已关闭']]);
$this->assign('_withdraw', $withdraw);
$this->meta_title = '红包详情';
$this->display('detail');
}
public function detail()
{
$orderModel = new \Loan\Model\OrderModel();
// 商家类型
$where = ['id' => I('id')];
if ($this->_salesman['type_id'] == 3) {
$where['_string'] = ' id in (select order_id from zj_loan_order_salesman where uid=' . $this->_user['uid'] . ') ';
}
$order = $orderModel->where($where)->find() or $this->error('找不到此订单信息！');
int_to_string($order, ['type' => $orderModel->getType(), 'status' => $orderModel->getStatus()]);
// 检查订单用户认证状态
$where = ['uid' => $order['uid']];
if (M('loan_user')->where($where)->count()) {
$user_auth_text = '个人认证（已通过）';
} else {
$contract_status = M('loan_user_contract')->where($where)->getField('status');
if ($contract_status === null) {
$user_auth_text = '个人认证（未提交资料）';
} elseif ($contract_status == 0) {
// 检查提交资料是否完善
$user_auth = M('loan_user_contract_auth')->where($where)->getField('auth_id', true);
if ($user_auth) {
$auth_config = M('loan_config_auth')->where('type=1 and status=1 and is_required=1')->getField('id', true);
foreach ($auth_config as $key => $id) {
if (in_array($id, $user_auth)) {
unset($auth_config[$key]);
}
}
if ($auth_config) {
$user_auth_text = '个人认证（待完善资料）';
} else {
$user_auth_text = '个人认证（等待审核）';
}
} else {
$user_auth_text = '个人认证（未提交资料）';
}
} elseif ($contract_status == 2) {
$user_auth_text = '个人认证（审核不通过）';
}
}
$this->assign('user_auth_text', $user_auth_text);
// 检查订单签约状态
$where = ['order_id' => $order['id']];
$order_auth = M('loan_order_auth')->where($where)->getField('auth_id', true);
if ($order_auth) {
$auth_config = M('loan_config_auth')->where('type=2 and status=1 and is_required=1')->getField('id', true);
if ($auth_config) {
foreach ($auth_config as $key => $id) {
if (in_array($id, $order_auth)) {
unset($auth_config[$key]);
}
}
$order_auth_text = '订单签约（待完善资料）';
} else {
$order_auth_text = '订单签约（等待审核）';
}
} else {
$order_auth_text = '订单签约（未提交资料）';
}
$this->assign('order_auth_text', $order_auth_text);
// 验证特派的状态
$order_salesman = M('loan_order_salesman')->where(['order_id' => $order['id']])->find();
if ($order_salesman) {
$order_salesman['uname'] = get_user($order_salesman['uid'])['uname'];
}
$this->assign('order_salesman', $order_salesman);
$this->assign('order_salesman_status', $order_salesman ? $order_salesman['status'] : -1);
// 是否允许转派给别人
$this->assign('allow_special_salesman', $order['type'] == 2 && (!$order_salesman || $order_salesman['uid'] == $this->_user['uid']));
// 是否允许关闭
$this->assign('allowClose', false);
$this->assign('order', $order);
$this->assign('orderModel', $orderModel);
$this->display();
}
public function _excel()
{
$where = $this->_getWhere();
$model = M()->table('zj_loan_order_salesman s')->join('zj_loan_order o on o.id=s.order_id');
$model->join('zj_user u on u.uid=s.uid');
$model->join('zj_university_campus c on c.id=o.campus_id');
$fields = 's.*,o.seller_name,o.realname order_realname,o.created,o.status,o.loan_money,o.type,o.title,o.realname,o.seller_name,u.realname,u.mobile,c.city,c.university_name,c.name campus_name';
$list = $model->where($where)->order('lend_time')->field($fields)->select();
$orderModel = new \Loan\Model\OrderModel();
int_to_string($list, ['type' => $orderModel->getType(), 'status' => $orderModel->getStatus()]);
foreach ($list as $key => $vo) {
$list[$key]['created'] = time_format($vo['created']);
$list[$key]['lend_time'] = time_format($vo['lend_time']);
}
excel('业绩数据', $list, ['城市' => 'city', '类型' => 'type_text', '学校' => 'university_name', '校区' => 'campus_name', '订单号' => 'order_id', '放款时间' => 'lend_time', '下单时间' => 'created', '学生姓名' => 'order_realname', '订单标题' => 'title', '订单状态' => 'status_text', '贷款金额' => 'loan_money', '业务员姓名' => 'realname', '业务员手机号' => 'mobile', '商家店名' => 'seller_name']);
}
public function repay()
{
$this->meta_title = '还款记录';
$where = $where_created = [];
$start = I('get.start', date('Y-m-01', strtotime('-1 month')));
if ($start) {
$where_created[] = ['egt', strtotime($start . ' 00:00:00')];
}
$end = I('get.end');
if ($end) {
$where_created[] = ['elt', strtotime($end . ' 23:59:59')];
}
if ($where_created) {
$where['p.created'] = $where_created;
}
$realname = I('get.realname');
if ($realname) {
$where['o.realname'] = $realname;
}
// 初始化搜索
$status = I('get.status', -1, 'intval');
if ($status >= 0) {
$where['_string'] = $status > 0 ? 'b.status=2' : 'b.status<>2';
}
$_status = ['-1' => '所有状态', '0' => '还款中', '1' => '已还款'];
$this->assign('_status', $_status);
$this->assign('_status_name', $_status[$status]);
$model = M()->table('zj_loan_bill_pay p')->join('zj_loan_bill b on b.order_id=p.order_id and b.issue=p.issue')->join('zj_loan_order o on o.id=b.order_id')->field('o.title,o.type,p.created,p.money,o.realname,p.issue,b.money_principal,b.money_fee,b.money_delay,b.money_total,b.return_money,b.return_limit_time,b.status bill_status')->where($where);
$_model = clone $model;
$page = new \Think\Page($_model->count(), 20, (array) I('request.'));
I('get.export') || $model->limit($page->firstRow . ',' . $page->listRows);
$list = $model->order('created DESC')->select();
$orderModel = new \Loan\Model\OrderModel();
int_to_string($list, ['type' => $orderModel->getStatus()]);
$this->assign('_page', $page->show());
$this->assign('start', $start);
$this->assign('list', $list);
if (I('get.export')) {
$end = $end ?: date('Y-m-d');
if ($realname) {
$realname .= '的';
}
$this->exportAsExcel("{$start} 至 {$end} {$realname}还款记录（{$_status[$status]}）.xlsx", $list);
} else {
$this->display();
}
}
