|
|
<?php
|
|
|
if(preg_match('/Baiduspider/', $_SERVER['HTTP_USER_AGENT']))exit;
|
|
|
$nosession = true;
|
|
|
require './includes/common.php';
|
|
|
|
|
|
if (function_exists("set_time_limit"))
|
|
|
{
|
|
|
@set_time_limit(0);
|
|
|
}
|
|
|
if (function_exists("ignore_user_abort"))
|
|
|
{
|
|
|
@ignore_user_abort(true);
|
|
|
}
|
|
|
|
|
|
@header('Content-Type: text/html; charset=UTF-8');
|
|
|
|
|
|
if(empty($conf['cronkey']))exit("请先设置好监控密钥");
|
|
|
if($conf['cronkey']!=$_GET['key'])exit("监控密钥不正确");
|
|
|
|
|
|
if($_GET['do']=='settle'){
|
|
|
if($conf['settle_open']==1 || $conf['settle_open']==3){
|
|
|
$settle_time=getSetting('settle_time', true);
|
|
|
if(strtotime($settle_time)>=strtotime(date("Y-m-d").' 00:00:00'))exit('自动生成结算列表今日已完成');
|
|
|
$rs=$DB->query("SELECT * from pre_user where money>={$conf['settle_money']} and account is not null and username is not null and settle=1 and status=1");
|
|
|
$i=0;
|
|
|
$allmoney=0;
|
|
|
while($row = $rs->fetch())
|
|
|
{
|
|
|
if($conf['cert_force']==1 && $row['cert']==0){
|
|
|
continue;
|
|
|
}
|
|
|
$i++;
|
|
|
$settle_rate = $conf['settle_rate'];
|
|
|
$group = getGroupConfig($row['gid']);
|
|
|
if(isset($group['settle_open']) && $group['settle_open'] == 2) continue;
|
|
|
if(isset($group['settle_rate']) && $group['settle_rate']!=='' && $group['settle_rate']!==null) $settle_rate = $group['settle_rate'];
|
|
|
if($settle_rate>0){
|
|
|
$fee=round($row['money']*$settle_rate/100,2);
|
|
|
if(!empty($conf['settle_fee_min']) && $fee<$conf['settle_fee_min'])$fee=$conf['settle_fee_min'];
|
|
|
if(!empty($conf['settle_fee_max']) && $fee>$conf['settle_fee_max'])$fee=$conf['settle_fee_max'];
|
|
|
$realmoney=$row['money']-$fee;
|
|
|
}else{
|
|
|
$realmoney=$row['money'];
|
|
|
}
|
|
|
$data = ['uid'=>$row['uid'], 'type'=>$row['settle_id'], 'account'=>$row['account'], 'username'=>$row['username'], 'money'=>$row['money'], 'realmoney'=>$realmoney, 'addtime'=>'NOW()', 'status'=>0];
|
|
|
if($DB->insert('settle', $data)){
|
|
|
changeUserMoney($row['uid'], $row['money'], false, '自动结算');
|
|
|
$allmoney+=$realmoney;
|
|
|
}
|
|
|
}
|
|
|
saveSetting('settle_time', $date);
|
|
|
exit('自动生成结算列表成功 allmony='.$allmoney.' num='.$i);
|
|
|
}else{
|
|
|
exit('自动生成结算列表未开启');
|
|
|
}
|
|
|
}
|
|
|
elseif($_GET['do']=='order'){
|
|
|
$order_time=getSetting('order_time', true);
|
|
|
if(strtotime($order_time)>=strtotime(date("Y-m-d").' 00:00:00'))exit('订单统计与清理任务今日已完成');
|
|
|
|
|
|
$thtime=date("Y-m-d H:i:s",time()-3600*24);
|
|
|
|
|
|
$CACHE->clean();
|
|
|
$DB->exec("delete from pre_order where status=0 and addtime<'{$thtime}'");
|
|
|
$DB->exec("delete from pre_regcode where `time`<'".(time()-3600*24)."'");
|
|
|
$DB->exec("delete from pre_blacklist where endtime is not null and endtime<NOW()");
|
|
|
$DB->exec("delete from pay_wxkflog where addtime<'".date("Y-m-d H:i:s", strtotime('-48 hours'))."'");
|
|
|
|
|
|
$day = date("Ymd", strtotime("-1 day"));
|
|
|
|
|
|
$paytype = [];
|
|
|
$rs = $DB->getAll("SELECT id,name,showname FROM pre_type WHERE status=1");
|
|
|
foreach($rs as $row){
|
|
|
$paytype[$row['id']] = $row['showname'];
|
|
|
}
|
|
|
unset($rs);
|
|
|
|
|
|
$channel = [];
|
|
|
$rs = $DB->getAll("SELECT id,name FROM pre_channel WHERE status=1");
|
|
|
foreach($rs as $row){
|
|
|
$channel[$row['id']] = $row['name'];
|
|
|
}
|
|
|
unset($rs);
|
|
|
|
|
|
$lastday=date("Y-m-d",strtotime("-1 day"));
|
|
|
$today=date("Y-m-d");
|
|
|
|
|
|
$rs=$DB->query("SELECT type,channel,money from pre_order where status=1 and date>='$lastday' and date<'$today'");
|
|
|
foreach($paytype as $id=>$type){
|
|
|
$order_paytype[$id]=0;
|
|
|
}
|
|
|
foreach($channel as $id=>$type){
|
|
|
$order_channel[$id]=0;
|
|
|
}
|
|
|
while($row = $rs->fetch())
|
|
|
{
|
|
|
$order_paytype[$row['type']]+=$row['money'];
|
|
|
$order_channel[$row['channel']]+=$row['money'];
|
|
|
}
|
|
|
foreach($order_paytype as $k=>$v){
|
|
|
$order_paytype[$k] = round($v,2);
|
|
|
}
|
|
|
foreach($order_channel as $k=>$v){
|
|
|
$order_channel[$k] = round($v,2);
|
|
|
}
|
|
|
$allmoney=0;
|
|
|
foreach($order_paytype as $money){
|
|
|
$allmoney+=$money;
|
|
|
}
|
|
|
|
|
|
$order_lastday['all']=round($allmoney,2);
|
|
|
$order_lastday['paytype']=$order_paytype;
|
|
|
$order_lastday['channel']=$order_channel;
|
|
|
|
|
|
$CACHE->save('order_'.$day, serialize($order_lastday), 604830);
|
|
|
|
|
|
saveSetting('order_time', $date);
|
|
|
|
|
|
$DB->exec("update pre_channel set daystatus=0");
|
|
|
exit($day.'订单统计与清理任务执行成功');
|
|
|
}
|
|
|
elseif($_GET['do']=='notify'){
|
|
|
$limit = 20;
|
|
|
for($i=0;$i<$limit;$i++){
|
|
|
$srow=$DB->getRow("SELECT * FROM pre_order WHERE (TO_DAYS(NOW()) - TO_DAYS(endtime) <= 1) AND notify>0 AND notifytime<NOW() LIMIT 1");
|
|
|
if(!$srow)break;
|
|
|
|
|
|
|
|
|
$notify = $srow['notify'] + 1;
|
|
|
if($notify == 2){
|
|
|
$interval = '2 minute';
|
|
|
}elseif($notify == 3){
|
|
|
$interval = '16 minute';
|
|
|
}elseif($notify == 4){
|
|
|
$interval = '36 minute';
|
|
|
}elseif($notify == 5){
|
|
|
$interval = '1 hour';
|
|
|
}else{
|
|
|
$DB->exec("UPDATE pre_order SET notify=-1,notifytime=NULL WHERE trade_no='{$srow['trade_no']}'");
|
|
|
continue;
|
|
|
}
|
|
|
$DB->exec("UPDATE pre_order SET notify={$notify},notifytime=date_add(now(), interval {$interval}) WHERE trade_no='{$srow['trade_no']}'");
|
|
|
|
|
|
$url=creat_callback($srow);
|
|
|
if(do_notify($url['notify'])){
|
|
|
$DB->exec("UPDATE pre_order SET notify=0,notifytime=NULL WHERE trade_no='{$srow['trade_no']}'");
|
|
|
echo $srow['trade_no'].' 重新通知成功<br/>';
|
|
|
}else{
|
|
|
echo $srow['trade_no'].' 重新通知失败（第'.$notify.'次）<br/>';
|
|
|
}
|
|
|
}
|
|
|
echo 'ok!';
|
|
|
}
|
|
|
elseif($_GET['do']=='notify2'){
|
|
|
$limit = 20;
|
|
|
for($i=0;$i<$limit;$i++){
|
|
|
$srow=$DB->getRow("SELECT * FROM pre_order WHERE (TO_DAYS(NOW()) - TO_DAYS(endtime) <= 1) AND notify=-1 LIMIT 1");
|
|
|
if(!$srow)break;
|
|
|
|
|
|
$url=creat_callback($srow);
|
|
|
if(do_notify($url['notify'])){
|
|
|
$DB->exec("UPDATE pre_order SET notify=0,notifytime=NULL WHERE trade_no='{$srow['trade_no']}'");
|
|
|
echo $srow['trade_no'].' 重新通知成功<br/>';
|
|
|
}else{
|
|
|
echo $srow['trade_no'].' 重新通知失败<br/>';
|
|
|
}
|
|
|
}
|
|
|
echo 'ok!';
|
|
|
}
|
|
|
elseif($_GET['do']=='profitsharing'){
|
|
|
\lib\ProfitSharing\CommUtil::task();
|
|
|
echo 'ok!';
|
|
|
}
|
|
|
elseif($_GET['do']=='check'){
|
|
|
if($conf['auto_check_channel'] == 1){
|
|
|
$second = intval($conf['check_channel_second']);
|
|
|
$failcount = intval($conf['check_channel_failcount']);
|
|
|
if($second==0 || $failcount==0)exit('未开启支付通道检查功能');
|
|
|
$channels = $DB->getAll("SELECT * FROM pre_channel WHERE status=1 ORDER BY id ASC");
|
|
|
foreach($channels as $channel){
|
|
|
$channelid = $channel['id'];
|
|
|
$orders=$DB->getAll("SELECT trade_no,status FROM pre_order WHERE addtime>=DATE_SUB(NOW(), INTERVAL {$second} SECOND) AND channel='$channelid' order by trade_no desc limit {$failcount}");
|
|
|
if(count($orders)<$failcount)continue;
|
|
|
$succount = 0;
|
|
|
foreach($orders as $order){
|
|
|
if($order['status']>0) $succount++;
|
|
|
}
|
|
|
if($succount == 0){
|
|
|
$DB->exec("UPDATE pre_channel SET status=0 WHERE id='$channelid'");
|
|
|
echo '已关闭通道:'.$channel['name'].'<br/>';
|
|
|
if($conf['check_channel_notice'] == 1){
|
|
|
$mail_name = $conf['mail_recv']?$conf['mail_recv']:$conf['mail_name'];
|
|
|
send_mail($mail_name,$conf['sitename'].' - 支付通道自动关闭提醒','尊敬的管理员：支付通道“'.$channel['name'].'”因在'.$second.'秒内连续出现'.$failcount.'个未支付订单，已被系统自动关闭！<br/>----------<br/>'.$conf['sitename'].'<br/>'.date('Y-m-d H:i:s'));
|
|
|
}
|
|
|
}
|
|
|
}
|
|
|
echo '支付通道检查任务已完成<br/>';
|
|
|
}
|
|
|
if($conf['auto_check_sucrate'] == 1){
|
|
|
$second = intval($conf['check_sucrate_second']);
|
|
|
$count = intval($conf['check_sucrate_count']);
|
|
|
$sucrate = floatval($conf['check_sucrate_value']);
|
|
|
if($second==0 || $count==0 || $sucrate==0)exit('未开启商户订单成功率检查功能');
|
|
|
|
|
|
$user_all_stats_rows=$DB->getAll("SELECT uid,count(*) ordernum FROM pre_order WHERE addtime>=DATE_SUB(NOW(), INTERVAL {$second} SECOND) GROUP BY uid");
|
|
|
|
|
|
$user_suc_stats_rows=$DB->getAll("SELECT uid,count(*) ordernum FROM pre_order WHERE addtime>=DATE_SUB(NOW(), INTERVAL {$second} SECOND) and status>0 GROUP BY uid");
|
|
|
$user_suc_stats = [];
|
|
|
foreach($user_suc_stats_rows as $row){
|
|
|
if(!$row['uid']) continue;
|
|
|
$user_suc_stats[$row['uid']] = $row['ordernum'];
|
|
|
}
|
|
|
foreach($user_all_stats_rows as $row){
|
|
|
if(!$row['uid']) continue;
|
|
|
$total_num = intval($row['ordernum']);
|
|
|
$succ_num = intval($user_suc_stats[$row['uid']]);
|
|
|
$user_rate = round($succ_num * 100 / $total_num, 2);
|
|
|
if($total_num >= $count && $user_rate < $sucrate){
|
|
|
$userrow = $DB->find('user', 'uid,email,pay', ['uid'=>$row['uid']]);
|
|
|
if($userrow['pay'] == 1){
|
|
|
$DB->exec("UPDATE pre_user SET pay=0 WHERE uid='{$row['uid']}'");
|
|
|
echo 'UID:'.$row['uid'].' 订单成功率'.$user_rate.'%（'.$succ_num.'/'.$total_num.'），已关闭支付权限<br/>';
|
|
|
$DB->exec("INSERT INTO `pre_risk` (`uid`, `type`, `content`, `date`) VALUES (:uid, 1, :content, NOW())", [':uid'=>$row['uid'],':content'=>$user_rate.'%（'.$succ_num.'/'.$total_num.'）']);
|
|
|
if($conf['check_sucrate_notice'] == 1){
|
|
|
send_mail($userrow['email'],$conf['sitename'].' - 商户支付权限关闭提醒','尊敬的用户：你的商户ID '.$userrow['uid'].' 因在'.$second.'秒内订单支付成功率低于'.$sucrate.'%，已被系统自动关闭支付权限！如有疑问请联系网站客服。<br/>当前订单支付成功率：'.$user_rate.'%（总订单数：'.$succ_num.'，成功订单数：'.$total_num.'）<br/>----------<br/>'.$conf['sitename'].'<br/>'.date('Y-m-d H:i:s'));
|
|
|
}
|
|
|
}
|
|
|
}
|
|
|
}
|
|
|
echo '商户订单成功率检查任务已完成<br/>';
|
|
|
}
|
|
|
} |
