📖 File Reader
<?php
namespace app\api\controller;
use app\BaseController;
use app\common\Common_time;
use app\api\common\Common_tongbu;
use app\api\common\Common_user;
use think\facade\Db;
use think\facade\View;
class Tongbu extends BaseController
{
/**
* 未付款订单超时自动取消库存恢复
* 定时执行:3分钟/次
*/
public function order_cancel()
{
$time = time()-86400;
$order = db::name("order")->where("state = 0 and add_time < $time")->order("order_id asc")->select()->toArray();
foreach ($order as $k => $v){
$order_goods = db::name("order_goods")->where("order_id = $v[order_id]")->order("id asc")->select()->toArray();
foreach ($order_goods as $goods_v){
if (!empty($goods_v["goods_guige_id"])){
$goods_guige_stocks = db::name("goods_guige_value")->where("id = $goods_v[goods_guige_id]")->value("stocks");
$info["stocks"]= $goods_guige_stocks+$goods_v["num"];
db::name("goods_guige_value")->where("id = $goods_v[goods_guige_id]")->update($info);
}else{
$goods_stocks = db::name("goods")->where("goods_id = $goods_v[goods_id]")->value("stocks");
$info["stocks"]= $goods_stocks+$goods_v["num"];
db::name("goods")->where("goods_id = $goods_v[goods_id]")->update($info);
}
}
$info_order = [
'state'=>'4',
];
db::name("order")->where("order_id = $v[order_id]")->update($info_order);
}
header("Content-Type:text/html; charset=utf-8");
print_r('执行完毕');
exit();
}
}