269 lines
11 KiB
PHP
Executable File
269 lines
11 KiB
PHP
Executable File
<?php
|
|
/**
|
|
* Niushop商城系统 - 团队十年电商经验汇集巨献!
|
|
* =========================================================
|
|
* Copy right 2019-2029 杭州牛之云科技有限公司, 保留所有权利。
|
|
* ----------------------------------------------
|
|
* 官方网址: https://www.niushop.com
|
|
* =========================================================
|
|
*/
|
|
|
|
namespace app\shop\controller;
|
|
|
|
|
|
use addon\wechatpay\model\Config as WechatPayConfig;
|
|
use app\model\member\Withdraw as MemberWithdrawModel;
|
|
use app\model\system\Pay;
|
|
use app\model\web\Account as AccountModel;
|
|
|
|
/**
|
|
* 会员管理 控制器
|
|
*/
|
|
class Memberwithdraw extends BaseShop
|
|
{
|
|
/**
|
|
* 会员提现配置
|
|
*/
|
|
public function config()
|
|
{
|
|
$config_model = new MemberWithdrawModel();
|
|
if (request()->isJson()) {
|
|
|
|
if (empty(input('transfer_type'))) {
|
|
$transfer_type = '';
|
|
} else {
|
|
$transfer_type = implode(',', input('transfer_type'));
|
|
}
|
|
//订单提现
|
|
$data = [
|
|
'is_auto_audit' => input('is_auto_audit', 0),//是否需要审核 1 手动审核 2 自动审核
|
|
'rate' => input('rate', 0),//提现手续费比率 (0-100)
|
|
'transfer_type' => $transfer_type,//转账方式,
|
|
'is_auto_transfer' => input('is_auto_transfer', 0),//是否自动转账 1 手动转账 2 自动转账
|
|
'min' => input('min', 0),//提现最低额度
|
|
'max' => input('max', 0),//提现最高额度
|
|
];
|
|
$this->addLog('设置会员提现配置');
|
|
$is_use = input('is_use', 0);//是否启用
|
|
$res = $config_model->setConfig($data, $is_use, $this->site_id, $this->app_module);
|
|
return $res;
|
|
} else {
|
|
|
|
$this->assign('is_exist', addon_is_exit('memberwithdraw', $this->site_id));
|
|
//会员提现
|
|
$config_result = $config_model->getConfig($this->site_id, $this->app_module);
|
|
$this->assign('config', $config_result[ 'data' ]);
|
|
$pay_model = new Pay();
|
|
$transfer_type_list = $pay_model->getTransferType($this->site_id);
|
|
$this->assign('transfer_type_list', $transfer_type_list);
|
|
return $this->fetch('memberwithdraw/config');
|
|
}
|
|
}
|
|
|
|
/**
|
|
* 会员提现列表
|
|
* @return mixed
|
|
*/
|
|
public function lists()
|
|
{
|
|
$withdraw_model = new MemberWithdrawModel();
|
|
if (request()->isJson()) {
|
|
$page = input('page', 1);
|
|
$page_size = input('page_size', PAGE_LIST_ROWS);
|
|
$withdraw_no = input('withdraw_no', '');
|
|
$start_date = input('start_date', '');
|
|
$end_date = input('end_date', '');
|
|
$status = input('status', 'all');//提现状态
|
|
$transfer_type = input('transfer_type', '');//提现转账方式
|
|
$member_name = input('member_name', '');//提现转账方式
|
|
|
|
$payment_start_date = input('payment_start_date', '');
|
|
$payment_end_time = input('payment_end_time', '');
|
|
|
|
$condition = [ [ 'mw.site_id', '=', $this->site_id ] ];
|
|
|
|
if (!empty($withdraw_no)) {
|
|
$condition[] = [ 'mw.withdraw_no', 'like', '%' . $withdraw_no . '%' ];
|
|
}
|
|
if (!empty($transfer_type)) {
|
|
$condition[] = [ 'mw.transfer_type', '=', $transfer_type ];
|
|
}
|
|
if ($status != 'all') {
|
|
$condition[] = [ 'mw.status', '=', $status ];
|
|
}
|
|
if (!empty($member_name)) {
|
|
$condition[] = [ 'mw.member_name', '=', $member_name ];
|
|
}
|
|
if ($start_date != '' && $end_date != '') {
|
|
$condition[] = [ 'mw.apply_time', 'between', [ strtotime($start_date), strtotime($end_date) ] ];
|
|
} else if ($start_date != '' && $end_date == '') {
|
|
$condition[] = [ 'mw.apply_time', '>=', strtotime($start_date) ];
|
|
} else if ($start_date == '' && $end_date != '') {
|
|
$condition[] = [ 'mw.apply_time', '<=', strtotime($end_date) ];
|
|
}
|
|
|
|
if ($payment_start_date != '' && $payment_end_time != '') {
|
|
$condition[] = [ 'mw.payment_time', 'between', [ strtotime($payment_start_date), strtotime($payment_end_time) ] ];
|
|
} else if ($payment_start_date != '' && $payment_end_time == '') {
|
|
$condition[] = [ 'mw.payment_time', '>=', strtotime($payment_start_date) ];
|
|
} else if ($payment_start_date == '' && $payment_end_time != '') {
|
|
$condition[] = [ 'mw.payment_time', '<=', strtotime($payment_end_time) ];
|
|
}
|
|
|
|
$order = 'apply_time desc';
|
|
|
|
$alias = 'mw';
|
|
$join = [
|
|
[ 'member m', 'm.member_id = mw.member_id', 'left' ]
|
|
];
|
|
$field = "mw.*,m.nickname,m.mobile";
|
|
return $withdraw_model->getMemberWithdrawPageList($condition, $page, $page_size, $order,$field,$alias,$join);
|
|
} else {
|
|
$this->assign('memberwithdraw_exist', addon_is_exit('memberwithdraw', $this->site_id));
|
|
$pay_model = new Pay();
|
|
$transfer_type_list = $pay_model->getTransferType($this->site_id);
|
|
$this->assign('transfer_type_list', $transfer_type_list);
|
|
|
|
$account_model = new AccountModel();
|
|
$member_balance_sum = $account_model->getMemberBalanceSum($this->site_id);
|
|
$this->assign('member_balance_sum', $member_balance_sum[ 'data' ]);
|
|
|
|
//提现状态
|
|
$this->assign('status_list', $withdraw_model->status);
|
|
|
|
$config_model = new WechatPayConfig();
|
|
$config = $config_model->getPayConfig($this->site_id)[ 'data' ][ 'value' ];;
|
|
$transfer_v3_type = $config['transfer_type'] == 'v3' && $config['transfer_v3_type'] == $config_model::TRANSFER_V3_TYPE_USER ;
|
|
$this->assign("transfer_v3_type",$transfer_v3_type);
|
|
return $this->fetch('memberwithdraw/lists');
|
|
}
|
|
}
|
|
|
|
/**
|
|
* 详情
|
|
*/
|
|
public function detail()
|
|
{
|
|
$id = input('id', 0);
|
|
$withdraw_model = new MemberWithdrawModel();
|
|
$withdraw_info_result = $withdraw_model->getMemberWithdrawInfo([ ['id', '=', $id ], [ 'site_id', '=', $this->site_id ] ]);
|
|
$withdraw_info = $withdraw_info_result['data'];
|
|
|
|
if (empty($withdraw_info)) $this->error('未获取到提现数据', href_url('shop/memberwithdraw/lists'));
|
|
|
|
$this->assign('withdraw_info', $withdraw_info);
|
|
return $this->fetch('memberwithdraw/detail');
|
|
}
|
|
|
|
/**
|
|
* 同意
|
|
* @return array
|
|
*/
|
|
public function agree()
|
|
{
|
|
if (request()->isJson()) {
|
|
$id = input('id', 0);
|
|
$withdraw_model = new MemberWithdrawModel();
|
|
$condition = array (
|
|
[ 'site_id', '=', $this->site_id ],
|
|
['id', '=', $id ],
|
|
[ 'status', '=', 0 ]
|
|
);
|
|
$result = $withdraw_model->agree($condition);
|
|
return $result;
|
|
}
|
|
}
|
|
|
|
/**
|
|
* 拒绝
|
|
* @return array
|
|
*/
|
|
public function refuse()
|
|
{
|
|
|
|
if (request()->isJson()) {
|
|
$id = input('id', 0);
|
|
$refuse_reason = input('refuse_reason', '');
|
|
$withdraw_model = new MemberWithdrawModel();
|
|
$condition = array (
|
|
[ 'site_id', '=', $this->site_id ],
|
|
[ 'id', '=', $id ],
|
|
);
|
|
$data = array (
|
|
'refuse_reason' => $refuse_reason
|
|
);
|
|
$result = $withdraw_model->refuse($condition, $data);
|
|
return $result;
|
|
}
|
|
}
|
|
|
|
/**
|
|
* 转账
|
|
*/
|
|
public function transferFinish()
|
|
{
|
|
if (request()->isJson()) {
|
|
$id = input('id', 0);
|
|
$certificate = input('certificate', '');
|
|
$certificate_remark = input('certificate_remark', '');
|
|
$withdraw_model = new MemberWithdrawModel();
|
|
$data = array (
|
|
'id' => $id,
|
|
'site_id' => $this->site_id,
|
|
'certificate' => $certificate,
|
|
'certificate_remark' => $certificate_remark,
|
|
);
|
|
$result = $withdraw_model->transferFinish($data);
|
|
return $result;
|
|
}
|
|
}
|
|
|
|
public function export(){
|
|
$withdraw_model = new MemberWithdrawModel();
|
|
|
|
$withdraw_no = input('withdraw_no', '');
|
|
$start_date = input('start_date', '');
|
|
$end_date = input('end_date', '');
|
|
$status = input('status', 'all');//提现状态
|
|
$transfer_type = input('transfer_type', '');//提现转账方式
|
|
$member_name = input('member_name', '');//提现转账方式
|
|
|
|
$payment_start_date = input('payment_start_date', '');
|
|
$payment_end_time = input('payment_end_time', '');
|
|
|
|
$condition = [ [ 'site_id', '=', $this->site_id ] ];
|
|
|
|
if (!empty($withdraw_no)) {
|
|
$condition[] = [ 'withdraw_no', 'like', '%' . $withdraw_no . '%' ];
|
|
}
|
|
if (!empty($transfer_type)) {
|
|
$condition[] = [ 'transfer_type', '=', $transfer_type ];
|
|
}
|
|
if ($status != 'all') {
|
|
$condition[] = [ 'status', '=', $status ];
|
|
}
|
|
if (!empty($member_name)) {
|
|
$condition[] = [ 'member_name', '=', $member_name ];
|
|
}
|
|
if ($start_date != '' && $end_date != '') {
|
|
$condition[] = [ 'apply_time', 'between', [ strtotime($start_date), strtotime($end_date) ] ];
|
|
} else if ($start_date != '' && $end_date == '') {
|
|
$condition[] = [ 'apply_time', '>=', strtotime($start_date) ];
|
|
} else if ($start_date == '' && $end_date != '') {
|
|
$condition[] = [ 'apply_time', '<=', strtotime($end_date) ];
|
|
}
|
|
|
|
if ($payment_start_date != '' && $payment_end_time != '') {
|
|
$condition[] = [ 'payment_time', 'between', [ strtotime($payment_start_date), strtotime($payment_end_time) ] ];
|
|
} else if ($payment_start_date != '' && $payment_end_time == '') {
|
|
$condition[] = [ 'payment_time', '>=', strtotime($payment_start_date) ];
|
|
} else if ($payment_start_date == '' && $payment_end_time != '') {
|
|
$condition[] = [ 'payment_time', '<=', strtotime($payment_end_time) ];
|
|
}
|
|
|
|
$order = 'apply_time desc';
|
|
|
|
$withdraw_model->exportWithdraw($condition, $order);
|
|
}
|
|
|
|
} |