=', $star_time);
}
if (!empty($end_time)) {
$end_time = date('Y-m-d H:i:s', strtotime($end_time));
$where[] = array('money_time', '<=', $end_time);
}
if (!empty($money_small)) {
$where[] = array('money', '>=', $money_small);
}
if (!empty($money_big)) {
$where[] = array('money', '<=', $money_big);
}
if (!empty($account_name)) {
if (empty($sureblur) || $sureblur == '模糊') {
$where[] = array('account_name', 'like', '%' . $account_name . '%');
} else {
$where[] = array('money_details.account_name', '=', $account_name);
}
}
if (!empty($order_id)) {
$where = array(array('trade_id', '=', $order_id));
}
$moneydetails = new \App\Models\Money_details;
$data = $moneydetails->getPartlist($where, 1, $limit, $field, $order);
if ($data < 0) {
return responseToJson($data);
}
$data['data'] = arrayToNumber($data['data'], ['money']);
return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total'], 0, $where);
}
//用户账务日志
function fundLog()
{
$page = Request::has('page') ? Request::get('page') : 1;
$limit = Request::has('limit') ? Request::get('limit') : 10;
$field = Request::has('field') ? Request::get('field') : 6;
$order = Request::has('order') ? Request::get('order') : 'desc';
$account_name = Request::has('account_name') ? Request::get('account_name') : '';
$loss_name = Request::has('loss_name') ? Request::get('loss_name') : '';
$agent_name = Request::has('agent_name') ? Request::get('agent_name') : '';
$startime = Request::get('startime') ? Request::get('startime') . ' 00:00:00' : '';
$endtime = Request::get('endtime') ? Request::get('endtime') . ' 23:59:59' : '';
if (empty($account_name) && !empty($agent_name)) {
$db = new \App\Models\NagentChild;
$account_name = $db->getChildStr($agent_name);
}
/*$whereIn = array();
$whereNotin = array();
$where = array();
if (!empty($account_name)) {
$whereIn[] = array('account_name', explode(',', $account_name));
}
if (!empty($loss_name)) {
$whereNotin[] = array('account_name', explode(',', $loss_name));
}
if (!empty($startime)) {
$startime = date('Y-m-d H:i:s', strtotime($startime));
$where[] = array('money_time', '>=', $startime);
}
if (!empty($endtime)) {
$endtime = date('Y-m-d H:i:s', strtotime($endtime));
$where[] = array('money_time', '<=', $endtime);
}*/
$where = '';
if (!empty($account_name)) {
$account_name = explode(',', $account_name);
$account_name = implode("','", $account_name);
$where .= " where account_name in ('" . $account_name . "') ";
}
if (!empty($loss_name)) {
$loss_name = explode(',', $loss_name);
$loss_name = implode("','", $loss_name);
$where .= empty($where) ? ' where ' : ' and ';
$where .= "account_name not in ('" . $loss_name . "')";
}
if (!empty($startime)) {
$startime = date('Y-m-d H:i:s', strtotime($startime));
$where .= empty($where) ? ' where ' : ' and ';
$where .= "money_time>='" . $startime . "'";
}
if (!empty($endtime)) {
$endtime = date('Y-m-d H:i:s', strtotime($endtime));
$where .= empty($where) ? ' where ' : ' and ';
$where .= "money_time<='" . $endtime . "'";
}
$moneydetails = new \App\Models\Money_details();
$data = $moneydetails->getFundlog($where, 1, $limit, $field, $order, $page);
if ($data < 0) {
return responseToJson($data);
}
$data['data'] = arrayToNumber($data['data'], ['sendmoney', 'savemoney', 'getmoney', 'winmoney', 'adminadd', 'adminpull', 'recharge_send', 'back_return']);
/*$uwhere = array();
$uwhere = $where;
$countmoney = $moneydetails->getPatlog($where, 4);
foreach ($data['data'] as $k => $v) {
$data['data'][$k]['sendmoney'] = 0;
$data['data'][$k]['savemoney'] = 0;
$data['data'][$k]['getmoney'] = 0;
$data['data'][$k]['winmoney'] = 0;
$data['data'][$k]['adminadd'] = 0;
$data['data'][$k]['adminpull'] = 0;
$data['data'][$k]['recharge_send'] = 0;
$data['data'][$k]['back_return'] = 0;
$data['data'][$k]['countmoney'] = $countmoney;
if (is_array($countmoney) && count($countmoney) > 0) {
foreach ($countmoney as $sk => $sv) {
if ($v['account_name'] == $sv['account_name']) {
$data['data'][$k]['sendmoney'] = ($sv['trade_type'] == 14) ? ($data['data'][$k]['sendmoney'] + $sv['summoney']) : $data['data'][$k]['sendmoney'];
$data['data'][$k]['savemoney'] = ($sv['trade_type'] == 6 || $sv['trade_type'] == 11 || $sv['trade_type'] == 14) ? ($data['data'][$k]['savemoney'] + $sv['summoney']) : $data['data'][$k]['savemoney'];
$data['data'][$k]['getmoney'] = ($sv['trade_type'] == 5 || $sv['trade_type'] == 9) ? ($data['data'][$k]['getmoney'] + $sv['summoney']) : $data['data'][$k]['getmoney'];
$data['data'][$k]['adminadd'] = ($sv['trade_type'] == 12 && $sv['money_type'] == 1) ? ($data['data'][$k]['adminadd'] + $sv['summoney']) : $data['data'][$k]['adminadd'];
$data['data'][$k]['adminpull'] = ($sv['trade_type'] == 12 && $sv['money_type'] == 2) ? ($data['data'][$k]['adminpull'] + $sv['summoney']) : $data['data'][$k]['adminpull'];
$data['data'][$k]['recharge_send'] = ($sv['trade_type'] == 13) ? ($data['data'][$k]['recharge_send'] + $sv['summoney']) : $data['data'][$k]['recharge_send'];
$data['data'][$k]['back_return'] = ($sv['trade_type'] == 7 || $sv['trade_type'] == 8) ? ($data['data'][$k]['back_return'] + $sv['summoney']) : $data['data'][$k]['back_return'];
}
}
}
$data['data'][$k]['winmoney'] = $data['data'][$k]['sendmoney'] + $data['data'][$k]['savemoney'] - $data['data'][$k]['getmoney'];
}
$data['data'] = arrayToNumber($data['data'], ['sendmoney', 'savemoney', 'getmoney', 'winmoney', 'adminadd', 'adminpull', 'recharge_send', 'back_return']);*/
return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total'], 0, $where);
}
//用户资金流水列表
function moneyWaterList()
{
$page = Request::has('page') ? Request::get('page') : 1;
$limit = Request::has('limit') ? Request::get('limit') : 10;
$field = Request::has('field') ? Request::get('field') : 6;
$order = Request::has('order') ? Request::get('order') : 'desc';
$field = $field == 'change_cash' ? 'money_details.money' : $field;
$account_name = Request::has('account_name') ? Request::get('account_name') : '';
$order_id = Request::has('order_id') ? Request::get('order_id') : '';
$trade_type = Request::has('trade_type') ? Request::get('trade_type') : '';
$star_time = Request::get('star_time') ? Request::get('star_time') . ' 00:00:00' : '';
$end_time = Request::get('end_time') ? Request::get('end_time') . ' 23:59:59' : '';
$money_small = Request::has('money_small') ? Request::get('money_small') : '';
$money_big = Request::has('money_big') ? Request::get('money_big') : '';
$sureblur = Request::has('sureblur') ? Request::get('sureblur') : '';
$status = Request::has('status') ? Request::get('status') : '';
$isuser = Request::has('isuser') ? Request::get('isuser') : 2;
if ($isuser == 1) {
$star_time = '';
$end_time = '';
}
$where = array();
if (!empty($account_name)) {
if (empty($sureblur) || $sureblur == '模糊') {
$where[] = array('money_details.account_name', 'like', '%' . $account_name . '%');
} else {
$where[] = array('money_details.account_name', '=', $account_name);
}
}
if (!empty($trade_type)) {
$where[] = array('trade_type', '=', $trade_type);
}
if (!empty($status)) {
$where[] = array('money_details.status', '=', $status);
}
if (!empty($star_time)) {
$star_time = date('Y-m-d H:i:s', strtotime($star_time));
$where[] = array('money_time', '>=', $star_time);
}
if (!empty($end_time)) {
$end_time = date('Y-m-d H:i:s', strtotime($end_time));
$where[] = array('money_time', '<=', $end_time);
}
if (!empty($money_small)) {
$where[] = array('money_details.money', '>=', $money_small);
}
if (!empty($money_big)) {
$where[] = array('money_details.money', '<=', $money_big);
}
if (!empty($order_id)) {
$where = array(array('trade_id', '=', $order_id));
}
if (count($where) == 0) {
return \App\Lib\DataTable\DataTable::init()->toJson(array(), 0, 0, $where);
}
$moneydetails = new \App\Models\Money_details();
$data = $moneydetails->getMoneylist($where, 1, $limit, $field, $order);
if ($data < 0) {
return responseToJson($data);
}
$usercash = array();
$data['data'] = arrayToNumber($data['data'], ['money']);
foreach ($data['data'] as $k => $v) {
/*if(isset($usercash[$v['account_name']])){
if($v['money_type'] == 1){
$ccash = $usercash[$v['account_name']] + $v['money'];
}else{
$ccash = $usercash[$v['account_name']] - $v['money'];
}
//$usercash[$v['account_name']] = $ccash;
if($v['money_cash'] != $ccash){
$data['data'][$k]['money_cash'] = $ccash;
}
}else{
$usercash[$v['account_name']] = $v['money_cash'];
}*/
if ($v['trade_type'] == 9 && strpos($v['trade_desc'], '撤销') !== false) {
if (strpos($v['trade_desc'], '重新开奖') !== false) {
$data['data'][$k]['isdel'] = 2;
} else {
$data['data'][$k]['isdel'] = 1;
}
} else {
$data['data'][$k]['isdel'] = 2;
}
$data['data'][$k]['money_time'] = date('Y-m-d H:i:s', strtotime($v['money_time']));
}
return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total'], 0, $where);
}
//交易订单详情
function moneyDetails()
{
$tradeid = Request::has('tradeid') ? Request::get('tradeid') : '';
if (empty($tradeid)) {
return responseToJson(-3021000202); //未提交对应订单号
}
$moneydetails = new \App\Models\Money_details();
$data = $moneydetails->getOrderDetails($tradeid, 3, 'account_bank', 'account_identity', 'account_identity');
return responseToJson($data);
}
//充值记录
function recharge()
{
$page = Request::has('page') ? Request::get('page') : 1;
$limit = Request::has('limit') ? Request::get('limit') : 10;
$field = Request::has('field') ? Request::get('field') : 6;
$order = Request::has('order') ? Request::get('order') : 'desc';
$account_name = Request::has('account_name') ? Request::get('account_name') : '';
$order_id = Request::has('order_id') ? Request::get('order_id') : '';
$recharge_type = Request::has('recharge_type') ? Request::get('recharge_type') : '';
$status = Request::has('status') ? Request::get('status') : '';
$apply_startime = Request::get('apply_startime') ? Request::get('apply_startime') . ' 00:00:00' : '';
$apply_endtime = Request::get('apply_endtime') ? Request::get('apply_endtime') . ' 23:59:59' : '';
$haddle_startime = Request::get('haddle_startime') ? Request::get('haddle_startime') . ' 00:00:00' : '';
$haddle_endtime = Request::get('haddle_endtime') ? Request::get('haddle_endtime') . ' 23:59:59' : '';
$money_small = Request::has('money_small') ? Request::get('money_small') : '';
$money_big = Request::has('money_big') ? Request::get('money_big') : '';
$sureblur = Request::has('sureblur') ? Request::get('sureblur') : '';
if($status==-1)$status='';
$where = array();
$whereIn = array();
$sql = '';
if (!empty($recharge_type) && empty($status)) {
$where[] = array('recharge_type', '=', $recharge_type);
}
if (!empty($recharge_type)) {
$where[] = array('recharge_type', '=', $recharge_type);
}
if ($status || $status === '0') $where[] = array('status', '=', $status);
if (!empty($apply_startime)) {
$apply_startime = date('Y-m-d H:i:s', strtotime($apply_startime));
$where[] = array('apply_time', '>=', $apply_startime);
}
if (!empty($apply_endtime)) {
$apply_endtime = date('Y-m-d H:i:s', strtotime($apply_endtime));
$where[] = array('apply_time', '<=', $apply_endtime);
}
if (!empty($haddle_startime)) {
$haddle_startime = date('Y-m-d H:i:s', strtotime($haddle_startime));
$where[] = array('complete_time', '>=', $haddle_startime);
}
if (!empty($haddle_endtime)) {
$haddle_endtime = date('Y-m-d H:i:s', strtotime($haddle_endtime));
$where[] = array('complete_time', '<=', $haddle_endtime);
}
if (!empty($money_small)) {
$where[] = array('money', '>=', $money_small);
}
if (!empty($money_big)) {
$where[] = array('money', '<=', $money_big);
}
if (!empty($account_name)) {
if (empty($sureblur) || $sureblur == '模糊') {
$where[] = array('account_name', 'like', '%' . $account_name . '%');
} else {
$where[] = array('account_name', '=', $account_name);
}
}
if (!empty($order_id)) {
$where = array(array('order_id', '=', $order_id));
}
$moneydetails = new \App\Models\Money_recharge();
if ($status || (int)$status < -1) {
$sql = "status={$status}";
}
$data = $moneydetails->getRechargelist($where, 1, $limit, $field, $order, '', '', '', $whereIn, $sql);
if ($data < 0) {
return $data;
}
$data['data'] = arrayToNumber($data['data'], ['money', 'money_cash']);
return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total'], 0, $where);
}
//待审核充值记录量获取
function getRechargeNum()
{
$recharge = new \App\Models\Money_recharge();
$status = Request::has('status') ? Request::get('status') : 1;
$data = $recharge->getCount($status);
return responseToJson(1, '', $data);
}
//充值订单详情
function rechargeDetails()
{
$orderid = Request::has('orderid') ? Request::get('orderid') : '';
if (empty($orderid)) {
return responseToJson(-3020000202); //未提交对应订单号
}
$rechargedetails = new \App\Models\Money_recharge();
$data = $rechargedetails->getOrderDetails($orderid, 3, 'account_bank', 'account_identity', 'account_identity');
return responseToJson($data);
}
//提现记录
function withdraw()
{
$page = Request::has('page') ? Request::get('page') : 1;
$limit = Request::has('limit') ? Request::get('limit') : 10;
$field = Request::has('field') ? Request::get('field') : 'id';
$order = Request::has('order') ? Request::get('order') : 'desc';
$grade = Request::has('grade') ? Request::get('grade') : '-1';
$account_name = Request::has('account_name') ? Request::get('account_name') : '';
$order_id = Request::has('order_id') ? Request::get('order_id') : '';
$bank_user = Request::has('bank_user') ? Request::get('bank_user') : '';
$money_small = Request::has('money_small') ? Request::get('money_small') : '';
$money_big = Request::has('money_big') ? Request::get('money_big') : '';
$apply_startime = Request::get('apply_startime') ? Request::get('apply_startime') . ' 00:00:00' : '';
$apply_endtime = Request::get('apply_endtime') ? Request::get('apply_endtime') . ' 23:59:59' : '';
$haddle_startime = Request::get('haddle_startime') ? Request::get('haddle_startime') . ' 00:00:00' : '';
$haddle_endtime = Request::get('haddle_endtime') ? Request::get('haddle_endtime') . ' 23:59:59' : '';
$sureblur = Request::has('sureblurs') ? Request::get('sureblurs') : 'on';
$status = Request::has('status') ? Request::get('status') : '';
$where = array();
if ($grade < 0) {
// $where .= ' AND grade=';
$grade = '';
} else {
$grade = ($grade == 10) ? '' : $grade;
$where[] = array('grade', '=', $grade);
}
if (!empty($bank_user)) {
$where[] = array('bank_user', 'like', '%' . $bank_user . '%');
}
if (!empty($money_small)) {
$where[] = array('money', '>=', $money_small);
}
if (!empty($money_big)) {
$where[] = array('money', '<=', $money_big);
}
if (!empty($apply_startime)) {
$apply_startime = date('Y-m-d H:i:s', strtotime($apply_startime));
$where[] = array('apply_time', '>=', $apply_startime);
}
if (!empty($apply_endtime)) {
$apply_endtime = date('Y-m-d H:i:s', strtotime($apply_endtime));
$where[] = array('apply_time', '<=', $apply_endtime);
}
if (!empty($haddle_startime)) {
$haddle_startime = date('Y-m-d H:i:s', strtotime($haddle_startime));
$where[] = array('pass_time', '>=', $haddle_startime);
}
if (!empty($haddle_endtime)) {
$haddle_endtime = date('Y-m-d H:i:s', strtotime($haddle_endtime));
$where[] = array('pass_time', '<=', $haddle_endtime);
}
if (!empty($status) && $status != 4) {
if ($status == 3) {
$where[] = array('status', '=', '0');
} else {
$where[] = array('status', '=', $status);
}
}
if (!empty($account_name)) {
if (empty($sureblur) || $sureblur == 'off') {
$where = array(array('account_name', 'like', '%' . $account_name . '%'));
} else {
$where = array(array('account_name', '=', $account_name));
}
}
if (!empty($order_id)) {
$where = array(array('order_id', '=', $order_id));
}
$takedetails = new \App\Models\Money_take();
$jointable = '';
if (is_numeric($grade)) {
$jointable = 'account_detailed';
}
$data = $takedetails->getTakelist($where, 1, $limit, $field, $order, $jointable, $grade);
if ($data < 0) {
return responseToJson($data);
}
$take_status = trans('status.money_take.status');
$has_root = 0;
if (\App\Models\Role::hasRoot('/enable/show/bankcard') < 0) {
$has_root = 1;
}
foreach ($data['data'] as $k => $v) {
$data['data'][$k]['apply_time'] = $v['order_id'] . '
' . $v['apply_time'];
$data['data'][$k]['status'] = ($v['status'] == 0) ? $take_status[3] : $take_status[$v['status']];
// $data['data'][$k]['bank_info_no'] = $v['bank_info'] . '
' . bankHide($v['bank_no']);
$has_root == 1 ? $data['data'][$k]['bank_no'] = bankHide($v['bank_no']) : null;
$data['data'][$k]['bank_user_address'] = $v['bank_user'] . '
' . $v['bank_address'];
// $data['data'][$k]['pass_time'] = '
'.$data['data'][$k]['status'] . '
' . $v['pass_time'];
}
$data['data'] = arrayToNumber($data['data'], ['money']);
return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total'], 0, $where);
}
//待审核提现记录量获取
function getTakeNum()
{
$take = new \App\Models\Money_take();
$status = Request::has('status') ? Request::get('status') : 3;
$data = $take->getCountnum($status);
return responseToJson(1, '', $data);
}
//提现订单详情
function withdrawDetails()
{
$orderid = Request::has('orderid') ? Request::get('orderid') : '';
if (empty($orderid)) {
return responseToJson(-3020100202); //未提交对应订单号
}
$takedetails = new \App\Models\Money_take();
$data = $takedetails->getOrderDetails($orderid, 3, '', '', '', 2);
if ($data < 0) {
return responseToJson($data);
}
$data['trade_type'] = 5;
return responseToJson($data);
}
//回水记录
function returnList()
{
$page = Request::has('page') ? Request::get('page') : 1;
$limit = Request::has('limit') ? Request::get('limit') : 10;
$field = Request::has('field') ? Request::get('field') : 6;
$order = Request::has('order') ? Request::get('order') : 'desc';
$account_name = Request::has('account_name') ? Request::get('account_name') : '';
$order_id = Request::has('order_id') ? Request::get('order_id') : '';
$haddle_startime = Request::get('haddle_startime') ? Request::get('haddle_startime') . ' 00:00:00' : '';
$haddle_endtime = Request::get('haddle_endtime') ? Request::get('haddle_endtime') . ' 23:59:59' : '';
$money_small = Request::has('money_small') ? Request::get('money_small') : '';
$money_big = Request::has('money_big') ? Request::get('money_big') : '';
$lossmoney_small = Request::has('lossmoney_small') ? Request::get('lossmoney_small') : '';
$lossmoney_big = Request::has('lossmoney_big') ? Request::get('lossmoney_big') : '';
$sureblur = Request::has('sureblur') ? Request::get('sureblur') : '';
$where = array();
if (!empty($account_name)) {
if (empty($sureblur) || $sureblur == '模糊') {
$where[] = array('account_name', 'like', '%' . $account_name . '%');
} else {
$where[] = array('account_name', '=', $account_name);
}
}
if (!empty($haddle_startime)) {
$haddle_startime = date('Y-m-d H:i:s', strtotime($haddle_startime));
$where[] = array('processing_time', '>=', $haddle_startime);
}
if (!empty($haddle_endtime)) {
$haddle_endtime = date('Y-m-d H:i:s', strtotime($haddle_endtime));
$where[] = array('processing_time', '<=', $haddle_endtime);
}
if (!empty($money_small)) {
$where[] = array('money', '>=', $money_small);
}
if (!empty($money_big)) {
$where[] = array('money', '<=', $money_big);
}
if (!empty($lossmoney_small)) {
$where[] = array('total_money', '>=', $lossmoney_small);
}
if (!empty($lossmoney_big)) {
$where[] = array('total_money', '<=', $lossmoney_big);
}
if (!empty($order_id)) {
$where = array(array('order_id', '=', $order_id));
}
$moneydetails = new \App\Models\Money_return();
$data = $moneydetails->getReturnlist($where, 1, $limit, $field, $order);
if ($data < 0) {
return responseToJson($data);
}
foreach ($data['data'] as $k => $v) {
$data['data'][$k]['orderid_time'] = $v['order_id'] . '
' . $v['processing_time'];
}
$data['data'] = arrayToNumber($data['data'], array('return_money', 'total_money'));
return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total'], 0, $where);
}
//回水订单详情
function returnDetails()
{
$orderid = Request::has('orderid') ? Request::get('orderid') : '';
if (empty($orderid)) {
return responseToJson(-3020200202); //未提交对应订单号
}
$returndetails = new \App\Models\Money_return();
$data = $returndetails->getOrderDetails($orderid, 3, 'account_bank', 'account_identity', 'account_identity');
if ($data < 0) {
return responseToJson($data);
}
$data['trade_type'] = 8;
return responseToJson($data);
}
//加款扣款
function moneyChange()
{
$changeType = Request::has('changetype') ? Request::get('changetype') : '';
$account_identity = Request::has('account_identity') ? Request::get('account_identity') : '';
$money = Request::has('money') ? Request::get('money') : '';
$bili = Request::has('bili') ? Request::get('bili') : 0;
$reson = Request::has('reson') ? Request::get('reson') : 0;
$orderid = Request::has('orderid') ? Request::get('orderid') : '';
$status = Request::has('status') ? Request::get('status') : 1; //1:成功 2:失败
if (empty($changeType)) {
return responseToJson(-3020300302); //未提交加款扣款类型 1:加款,2:扣款
}
if (empty($money)) {
return responseToJson(-3020300402); //操作金额不能为空
}
if (empty($account_identity)) {
return responseToJson(-3020300502); //未提交用户ID
}
if ($bili > 0) {
$money = $money * $bili;
}
//第三方充值
if (empty($orderid)) {
$res = $status; //加款扣款
if ($res == 1) {
return responseToJson($res);
}
return responseToJson(-3020300602); //加款扣款失败
}
//活动加款扣款
$res = $status; //加款扣款
if ($res == 1) {
return responseToJson($res);
}
return responseToJson(-3020300702); //加款扣款失败
}
//加款扣款用户信息获取
function getUser()
{
$page = Request::has('page') ? Request::get('page') : 1;
$limit = Request::has('limit') ? Request::get('limit') : 10;
$field = Request::has('field') ? Request::get('field') : 'id';
$order = Request::has('order') ? Request::get('order') : 'desc';
$account = Request::has('account_name') ? Request::get('account_name') : '';
$sureblur = Request::has('sureblur') ? Request::get('sureblur') : '';
if (empty($account)) {
$data = array(
array(
'account_name' => '',
'account_identity' => '',
'cash' => '',
),
);
return \App\Lib\DataTable\DataTable::init()->toJson($data, 1);
}
$account = strtolower($account);
$where = array();
if (!empty($account)) {
// if (empty($sureblur) || $sureblur == '模糊') {
// $where[] = array('account', 'like', '%' . $account . '%');
// } else {
$where[] = array('account', '=', $account);
// }
}
$userdetails = new \App\Models\Account();
$data = $userdetails->getUserDetails($where, 3, 'account_detailed', 'identity', 'account_identity', $page, $limit, $field, $order);
if ($data < 0) {
return responseToJson($data); //没有用户数据
}
return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total']);
}
//回水管理
function returnInfo()
{
$page = Request::has('page') ? Request::get('page') : 1;
$limit = Request::has('limit') ? Request::get('limit') : 10;
// $field = Request::has('field') ? Request::get('field') : '';
// $order = Request::has('order') ? Request::get('order') : 'desc';
$account_name = Request::has('account_name') ? Request::get('account_name') : '';
// $account_name = 'gust17687';
$gametype = Request::has('gametype') ? Request::get('gametype') : '';
$lossmoney_small = Request::has('lossmoney_small') ? Request::get('lossmoney_small') : '';
$lossmoney_big = Request::has('lossmoney_big') ? Request::get('lossmoney_big') : '';
$sureblur = Request::has('sureblur') ? Request::get('sureblur') : '';
$star_time = Request::get('star_time') ? Request::get('star_time') . ' 00:00:00' : '';
$end_time = Request::get('end_time') ? Request::get('end_time') . ' 23:59:59' : '';
$total_money = Request::has('total_money') ? Request::get('total_money') : '';
$where = array();
$user_where = array();
$wheregame = array();
$orwhere = array();
$having = '';
if (!empty($total_money)) {
$having = 'sum("get_money")<=' . (-$total_money);
}
if (!empty($account_name)) {
if (empty($sureblur) || $sureblur == '模糊') {
$where[] = array('account_name', 'like', '%' . $account_name . '%');
} else {
$where[] = array('account_name', '=', $account_name);
}
$user_where = array('account' => $account_name, 'status' => 4);
}
if (!empty($gametype) || $gametype != 0) {
$where[] = array('game_name', '=', $gametype);
} else {
// $wheregame[] = array('game_name', '=', 'xy28');
// $orwhere[] = array('game_name', '=', 'jnd28');
$wheregame = array('xy28', 'jnd28');
}
if (!empty($lossmoney_small)) {
$where[] = array('total_money', '>=', $lossmoney_small);
}
if (!empty($lossmoney_big)) {
$where[] = array('total_money', '<=', $lossmoney_big);
}
if (!empty($star_time)) {
$star_time = date('Y-m-d H:i:s', strtotime($star_time));
$where[] = array('money_time', '>=', $star_time);
}
if (!empty($end_time)) {
$end_time = date('Y-m-d H:i:s', strtotime($end_time));
$where[] = array('money_time', '<=', $end_time);
}
// $user= new \App\Model\Account;
// $users=$user->Accounta($user_where);
$moneyreturn = new \App\Models\MoneyBuy();
// if ($users > 0){
// return responseToJson(-3020400202);
// }
$data = $moneyreturn->getMoneyReturn($where, 1, $limit, $wheregame, $orwhere, $having);
if ($data < 0) {
return responseToJson($data);
}
// $game = trans('money');
// var_dump($data['data']);
// $gamearr = $game['gametype'];
foreach ($data['data'] as $k => $v) {
// $data['data'][$k]['game_name'] = $gamearr[$v['game_name']];
if ($v['total_money'] < 0) {
$data['data'][$k]['total_money'] = floatval(abs($v['total_money']));
} else {
unset($data['data'][$k]);
}
// $data['data'][$k]['total_money'] = floatval($v['total_money']);
}
// var_dump($data['data'])
return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total']);
}
//回水
function returnAct()
{
$status = Request::has('status') ? Request::get('status') : 1; //1:成功 2:失败
$systemUser = Request::has('systemuser') ? Request::get('systemuser') : ''; //管理员名
$data = Request::has('data') ? Request::get('data') : '';
//$data = '{"data":[{"account_name":"147ceshi","account_identity":"3df48c6c-f805-ed8b-1d2f-e4e95f09242f","total_money":200,"status":2,"game_name":"\u5e78\u8fd028","ratio":0.1},{"account_name":"123daili","account_identity":"f243a05d-f0b4-6eee-e8ad-53472612230e","total_money":0,"status":1,"game_name":"\u5e78\u8fd028","ratio":0.1}]}';
if (empty($data)) {
return Rens(-3020400202); //未提交回水信息
}
if (empty($systemUser)) {
return Rens(-3020400302); //未提交操作管理员信息
}
$data = json_decode($data);
$data = $data->data;
$addData = array();
foreach ($data as $k => $v) {
$addData[] = array(
'info_identity' => '',
'order_id' => '',
'account_name' => $v->account_name,
'account_identity' => $v->account_identity,
'money' => $v->total_money * $v->ratio,
'total_money' => $v->total_money,
'sysetem_user' => $systemUser,
'processing_time' => date('Y-m-d H:i:s', time()),
'ratio' => $v->ratio,
'reason' => '',
);
}
foreach ($addData as $v) {
if (!empty($v)) {
$res = $status;
}
}
if ($res == 1) {
return Rens($res);
}
return Rens(-3020400402); //回水操作失败
}
//提现账单详情
function stateDetails()
{
$page = Request::has('page') ? Request::get('page') : 1;
$limit = Request::has('limit') ? Request::get('limit') : 10;
$field = Request::has('field') ? Request::get('field') : 6;
$order = Request::has('order') ? Request::get('order') : 'desc';
$account_name = Request::has('account_name') ? Request::get('account_name') : '';
$account_identity = Request::has('account_identity') ? Request::get('account_identity') : '';
$status = Request::has('status') ? Request::get('status') : '';
if (empty($account_name) && empty($account_identity)) {
return responseToJson(-3020200102); //未提交对应用户信息
}
if (empty($status)) {
return responseToJson(-3020200202); //未提交对应信息状态
}
$where = array();
if (!empty($account_name)) {
$where[] = array('account_name', '=', $account_name);
} else {
$where[] = array('account_identity', '=', $account_identity);
}
if ($status == 3) {
$where[] = array('money_take.status', '=', '0');
} else {
$where[] = array('money_take.status', '=', $status);
}
$takedetails = new \App\Models\Money_take();
$data = $takedetails->getTotalDetails($where, 1, $limit, $page, $field, $order);
if ($data < 0) {
return responseToJson($data);
}
return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total']);
}
//充值账单详情
function rechargesDetails()
{
$page = Request::has('page') ? Request::get('page') : 1;
$limit = Request::has('limit') ? Request::get('limit') : 10;
$field = Request::has('field') ? Request::get('field') : 6;
$order = Request::has('order') ? Request::get('order') : 'desc';
$account_name = Request::has('account_name') ? Request::get('account_name') : '';
$account_identity = Request::has('account_identity') ? Request::get('account_identity') : '';
$status = Request::has('status') ? Request::get('status') : '';
if (empty($account_name) && empty($account_identity)) {
return responseToJson(-3020200102); //未提交对应用户信息
}
if (empty($status)) {
return responseToJson(-3020200202); //未提交对应信息状态
}
$where = array();
if (!empty($account_name)) {
$where[] = array('money_recharge.account_name', '=', $account_name);
} else {
$where[] = array('money_recharge.account_identity', '=', $account_identity);
}
$where[] = array('money_recharge.status', '=', $status);
$takedetails = new \App\Models\Money_recharge();
$data = $takedetails->getTotalDetails($where, 1, $limit, $page, $field, $order);
if ($data < 0) {
return responseToJson($data);
}
return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total']);
}
//用户回水详情列表
function userreturnList()
{
$page = Request::has('page') ? Request::get('page') : 1;
$limit = Request::has('limit') ? Request::get('limit') : 10;
$field = Request::has('field') ? Request::get('field') : 13;
$order = Request::has('order') ? Request::get('order') : 'desc';
$account_name = Request::has('account_name') ? Request::get('account_name') : '';
$game_name = Request::has('game_name') ? Request::get('game_name') : '';
if (empty($account_name) && empty($account_identity)) {
return responseToJson(-3020300102); //未提交对应用户信息
}
$game_name = ($game_name == '幸运28') ? 'xy28' : ($game_name == '加拿大28' ? 'jnd28' : '');
if (empty($game_name)) {
return responseToJson(-3020300202); //未提交对应游戏信息
}
$where = array();
$where[] = array('account_name', '=', $account_name);
$where[] = array('game_name', '=', $game_name);
$moneybuy = new \App\Models\MoneyBuy();
$data = $moneybuy->getUserReturndetail($where, 1, $limit, $field, $order);
if ($data < 0) {
return responseToJson($data);
}
foreach ($data['data'] as $k => $v) {
$data['data'][$k]['money_time'] = $v['order_id'] . '
' . $v['money_time'];
}
return \App\Lib\DataTable\DataTable::init()->toJson($data['data'], $data['total']);
}
//统计
/**
* 充值金额统计
* 'money description'
* @return 'type' 'description'
*/
function rechargeMoneyCount()
{
$where = Request::has('where') ? Request::get('where') : '';
$db = new \App\Models\Money_recharge;
$data = $db->rechargeMoneyCount($where);
return responseToJson($data);
}
/**
* 提款金额统计
* 'money description'
* @return 'type' 'description'
*/
function takeMoneyCount()
{
$where = Request::has('where') ? Request::get('where') : '';
$db = new \App\Models\Money_take;
$data = $db->takeMoneyCount($where);
return responseToJson($data);
}
/**
* 汇款金额统计
* 'money description'
* @return 'type' 'description'
*/
function sendMoneyCount()
{
$where = Request::has('where') ? Request::get('where') : '';
$db = new \App\Models\Money_recharge;
$data = $db->sendMoneyCount($where);
return responseToJson($data);
}
/**
* 回水金额统计
* 'money description'
* @return 'type' 'description'
*/
function returnMoneyCount()
{
$where = Request::has('where') ? Request::get('where') : '';
$db = new \App\Models\Money_return;
$data = $db->returnMoneyCount($where);
return responseToJson($data);
}
//获取交易表名后缀
private function getTradetable($num)
{
$type = array(
'1' => 'buy',
'2' => 'buy',
'3' => 'buy',
'4' => 'prize',
'5' => 'take',
'6' => 'recharge',
'7' => 'back',
'8' => 'return',
'11' => 'recharge',
'12' => 'recharge',
'13' => 'recharge',
'14' => 'recharge',
);
return $type[$num];
}
//汇款
function Rimit($order_id, $rale)
{
DB::beginTransaction();
$db = new \App\Models\Money_recharge;
$accountDB = new \App\Models\Account_detailed(); //用户详情
$info = $db->getRimitDetails($order_id);
if ($info < 0) {
return $info;
}
$limitroot = new \App\Models\System_user();
$limitmoney = $limitroot->checkActMoney($info['money']);
if ($limitmoney < 0) {
return $limitmoney;
}
//更新统计数据
$data = $info;
$info['complete_time'] = date('Y-m-d H:i:s');
$data['pass_time'] = $info['complete_time'];
$res = \App\Models\Money_count::AddCountinfo($data, 'save');
if ($res < 0) {
DB::rollback();//事务回滚
return responseToJson($res);
}
//更新数据状态
$res = $db->updateStatus($order_id, 1);
if ($res < 0) {
DB::rollBack();
return $res;
}
$acount = new \App\Models\Account_detailed;
$acount_info = $acount->getInfoBy($info['account_identity']);
$prize_moeny = 0;
//添加汇款详情
unset($info['apply_time']);
unset($info['complete_time']);
unset($info['status']);
unset($info['recharge_type']);
unset($info['recharge_type']);
unset($info['id']);
unset($info['info_identity']);
unset($info['money_cash']);
unset($info['order_id']);
unset($info['remark']);
$rate = $info['rate'] ?? 1;
if (isset($info['rate']))
unset($info['rate']);
//获取充值备注信息
$remarkinfo = \App\Models\Recharge_Remark::where('order_id', $order_id)->first();
if (!$remarkinfo) {
return -30010102;
}
$remarkinfo = $remarkinfo->toArray();
//添加汇款详情
$info["sysetem_user"] = session('adminInfo.admin_name');
$res = $this->addLog($info, 14, $acount_info['cash'], $rate, $order_id);
if ($res < 0) {
DB::rollBack();
return $res;
}
//更新余额
$rimt_res = $accountDB->addMoney($acount_info['account_identity'], $info['money']);
if ($rimt_res < 0) {
DB::rollBack();
return $rimt_res;
}
//含赠送金额时插入赠送新数据
if (!empty($rale)) {
$order_id2 = OrderID();
$prize_moeny = $info['money'] * $rale; //奖励金额
$money_cash = $prize_moeny + $acount_info['cash'] + $info['money'];
$data = array(
'money' => $prize_moeny,
"account_name" => $info['account_name'],
"account_identity" => $info['account_identity'],
"sysetem_user" => session('adminInfo.admin_name'),
"reason" => '汇款赠送1',
"money_cash" => $money_cash,
);
$re_data = $data;
$data['order_id'] = $order_id2;
$data['apply_time'] = date('Y-m-d H:i:s');
$data['complete_time'] = date('Y-m-d H:i:s');
$data['status'] = 1;
$data['recharge_type'] = '汇款赠送';
//添加充值赠送备注信息
$remarkdata = array(
'order_id' => $order_id2,
'name' => $remarkinfo['name'],
'recharge_time' => $remarkinfo['recharge_time'],
'money' => $prize_moeny,
);
$rminfo = \App\Models\Recharge_Remark::insert($remarkdata);
if (!$rminfo) {
DB::rollBack();
return -30010202;
}
$order_id2 = $db->addMoney($data);
if ($order_id2 < 0) {
DB::rollBack();
return $order_id2;
}
//添加充值详情
$res2 = $this->addLog($re_data, 13, ($acount_info['cash'] + $info['money']));
if ($res2 < 0) {
DB::rollBack();
return $res2;
}
$rimt_res = $accountDB->addMoney($data['account_identity'], $data['money']);
if ($rimt_res < 0) {
DB::rollBack();
return $rimt_res;
}
}
$uinfo = $accountDB->getInfoBy($acount_info['account_identity']);
$data = array('money_cash' => $uinfo['cash'] - $prize_moeny);
$res5 = $db->updateInfo($data, 'order_id', $order_id);
if ($res5 < 0) {
DB::rollBack();
return $res5;
}
DB::commit();
return 1;
}
//详情记录
function addLog($data, $type, $cash, int $rate = 1, $order_id = '')
{
$data['money_cash'] = $data['money'] + $cash;
$data['trade_id'] = !empty($order_id) ? $order_id : OrderID();
$data['trade_type'] = $type;
$data['money_time'] = date('Y-m-d H:i:s');
$data['money_type'] = 1;
$admin_name = session('adminInfo.admin_name');
$detailsinfo = \App\Models\Money_details::where('trade_id', $order_id)->where('trade_id', '<>', '')->first();
if ($detailsinfo) {
return -3020035022;
}
if ($type == 13) {
$data['trade_desc'] = sprintf(trans('trade.admin_prize_money'), $admin_name, $data['account_name'], $data['money'], $data['trade_id'], $rate);
$data['reason'] = '汇款赠送';
} else if ($type == 14) {
$data['trade_desc'] = sprintf(trans('trade.admin_rimit_money'), $admin_name, $data['account_name'], $data['money'], $data['trade_id'], $rate);
$data['reason'] = '汇款';
}
$db_money = new \App\Models\Money_details;
$res = $db_money->insertData($data);
return $res;
}
//获取提现,汇款,充值待处理内容
function getNum()
{
$model = new \App\Models\Money_recharge();
$data['rimit'] = $model::where('status', 0)->where('recharge_type', '汇款')->count();
$data['take'] = \App\Models\Money_take::where('status', 0)->count();
$data['vip'] = \App\Models\Uservip::where('status', 1)->count();
// $data['back'] = \App\Model\Oggame_transfer_record::where('type', 3)->count();
// $data['lotteryMoney'] = \App\Model\LotteryMoneyLog::where('status', 0)->count();//待审核彩金条数
// $msg_db = new \App\Model\MessageRead;
// $data['msg'] = $msg_db->countNoReade (session ('adminInfo.admin_id'));
// $data['agent'] = \App\Model\Agent_detailed::where ('status', 0)->count ('id');
return responseToJson($data);
}
/**
*检查用户提现规则
* @param $idd
* @param null $money
* @return int
*/
public function checkWithdrawRule()
{
$idd = Request::has('idd') ? Request::get('idd') : '';
if (!$idd)
return responseToJson(-1, '非法操作,用户账户不能为空', '');
$ret = Withdraw_rule::check($idd);
return responseToJson($ret ? 1 : -1, $ret ? 'success' : '无结果', $ret);
}
/**
* 更新用户提现规则
* @param $idd
* @param $data
* @return array
*/
public function changeWithDrawRule()
{
$idd = Request::has('idd') ? Request::get('idd') : '';
$start_time = Request::has('start_time') ? Request::post('start_time') : '';
$end_time = Request::has('end_time') ? Request::post('end_time') : '';
$bettingMoney = Request::has('bettingMoney') ? Request::post('bettingMoney') : 0;
$rate = Request::has('rate') ? Request::post('rate') : 1;
$needBettingMoney = Request::has('needBettingMoney') ? Request::post('needBettingMoney') : 0;
if (!$idd)
return responseToJson(-1, '非法操作,用户账户不能为空', '');
$ret = Withdraw_rule::updateRule($idd, $bettingMoney, $rate);
return responseToJson($ret ? 1 : -1, $ret ? '修改规则成功' : '修改规则失败', '');
}
/**
*添加用户提现规则
* @return array|int
*/
public function addRule()
{
$idd = Request::has('idd') ? Request::get('idd') : '';
$startTime = Request::has('startTime') ? Request::post('startTime') : '';
$endTime = Request::has('endTime') ? Request::post('endTime') : '';
$bettingMoney = Request::has('bettingMoney') ? Request::post('bettingMoney') : 0;
$needBettingMoney = Request::has('needBettingMoney') ? Request::post('needBettingMoney') : 0;
if (!$idd)
return responseToJson(-1, '非法操作,用户账户不能为空', '');
if (!$startTime)
$startTime = time();
if (!$endTime)
$endTime = time();
if (!$bettingMoney || !$needBettingMoney) {
//return responseToJson (-1, '金额不能为空或0', '');
}
if ($bettingMoney) $data['bettingMoney'] = $bettingMoney;
if ($needBettingMoney) $data['needBettingMoney'] = $needBettingMoney;
//$ret = Withdraw_rule::setRule ($idd, $startTime, $endTime, $bettingMoney, $needBettingMoney);
$ret = Withdraw_rule::setRule($idd, time(), time(), 1000, 1200);
return responseToJson($ret ? 1 : -1, $ret ? '添加规则成功' : '添加规则失败', $ret);
}
/**
* 删除用户提现规则
* @return mixed
*/
public function rmWithdrawRule()
{
$idd = Request::has('idd') ? Request::post('idd') : '';
if (!$idd)
return responseToJson('', '非法操作', '');
$ret = Withdraw_rule::rmRule($idd);
return responseToJson($ret ? 1 : -1, $ret ? '删除规则成功' : '删除规则失败', '');
}
public function getWithdrawList()
{
$data = Withdraw_rule::get();
//return responseToJson (1,'',$data);
return ['code' => 0, 'count' => count($data), 'data' => $data, 'msg' => 'success'];
}
/**
* 用户提现规则表页面
*/
public function withdrawRules(Request $req)
{
$request['title'] = isset($req->title) ? trim($req->title) : '提现规则表';
$request['type'] = isset($req->type) ? trim($req->type) : null;
$dt = \App\Lib\DataTable\DataTable::init();
$dt->setDataSource('/admin/money/getWithdrawList');
$dt->setLang('withdrawRule');
$dt->addColsFields('account_identity', ['templet' => '#account_identity']);
$dt->addColsFields('bettingMoney');
$dt->addColsFields('needBettingMoney');
$dt->addColsFields('start_time');
$dt->addColsFields('end_time');
//$dt->enableCheckBox ();
$arr[] = 'editRule';
$dt->setToolBar($arr, array('width' => 140));
return view('admin.withdraw/rules', $dt->render($request));
}
/**
* 修改用户提现规则页面
* @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View
*/
public function editRule()
{
$id = Request::has('id') ? Request::get('id') : '';
if ($id) {
$data = Withdraw_rule::getRule($id);
return view('admin.withdraw.editRule', ['data' => $data]);
}
die('error');
}
}
function test()
{
$db = new \App\Models\Money_recharge;
$data = $db->text();
print_r($data);
}