app-api/app/Http/Controllers/GoodtestController.php

<?php

namespace App\Http\Controllers;

use App\Models\Activity;
use App\Models\Goodtest;
use App\Models\LimitGood;
use App\Models\OrderDetail;
use App\Models\Ordertest;
use App\Models\User;
use Carbon\Carbon;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Cache;
use function Couchbase\defaultDecoder;

class GoodtestController extends  Controller{

    public function GetGoodStatus(){
        $activity=Activity::where('is_ing',1)->first();
        $time=Carbon::now();
        $status=false;
        if ($time>=$activity->start_time && $time<=$activity->end_time){
            if ($activity->set_company_buy_num==1){
                $status=true;
            }
        }

        return $this->success(['status'=>$status]);
    }

    public function good_show(){
//        return $this->success_list([]);
//        if (Cache::get('GiftWaZiStatus')){
//            return $this->success_list([]);
//        }
        $id=Auth::user()->id;
//        if (!Cache::has('LIMITUSER'.$id)){
//            Cache::forever('LIMITUSER'.$id,0);
//        }
//        if(Cache::get('LIMITUSER'.$id)>=50){
//            return $this->success_list([]);
//        }
//        if ($id!=39516){
//            return $this->success_list([]);
//        }
        $user=User::find($id);
        $time=Carbon::now();
        $activity=Activity::where('is_ing',1)->first();
//        //暂时关闭
//        if ($activity){
//            if ($time <$activity->start_time || $time>$activity->end_time){
//                return $this->success_list([]);
//            }
//            if ($time>=$activity->start_time && $time<=$activity->end_time){
//                if ($time<Carbon::today()->addHours(9) || $time>Carbon::today()->addHours(21)){
//                    return $this->success_list([]);
//                }
//            }
//        }

        $re=[];
        $goods_id=[];
        $mobile=Auth::user()->mobile;
        $ids=Auth::user()->id;
//        if (in_array($ids,[123226])){
            $datas=Goodtest::whereIn('is_show',[2,3])->where('is_deleted',0)->count();
            if ($datas>0){
                $data=Goodtest::whereIn('is_show',[2,3])->whereNotIn('id',$goods_id)->where('is_deleted',0)->groupBy('main_attr')->orderBy('sort')->select('main_attr','attr_id')->get();
                $i=0;
                $re=[];
                foreach ($data as $k=>$v){
                    $sec_attr=Goodtest::whereIn('is_show',[2,3])
                        ->whereNotIn('id',$goods_id)
                        ->where('is_deleted',0)
                        ->where('main_attr',$v->main_attr)
                        ->groupBy('sec_attr')
                        ->orderBy('sort')
                        ->select('sec_attr','name','goods_num','money','unit','main_img','banner_img','id','attr_id','show_time','off_time','main_attr')
                        ->get();
                    foreach ($sec_attr as $ke=>$va){
                        $size=Goodtest::whereIn('is_show',[2,3])
                            ->whereNotIn('id',$goods_id)
                            ->where('is_deleted',0)->where('main_attr',$v->main_attr)->where('sec_attr',$va->sec_attr)->select('storage','size','id')->get()->toArray();
//                $now=Carbon::now()->timestamp;
//                if ($va->show_time==null){
//                    $re[$i]['limit_time']=false;
//                }else{
//                    if (strtotime($va->show_time)<$now&&strtotime($va->off_time)>$now){
//                        $re[$i]['limit_time']=true;
//                        $re[$i]['show_time']=$va->show_time->toDateTimeString();
//                        $re[$i]['off_time']=$va->off_time->toDateTimeString();
//                    }
//                }
                        $re[$i]['step']=1;
                        if($user->level=='3'){
                            if($activity && $activity->set_company_buy_num==1){
                                if ($time>=$activity->start_time && $time<=$activity->end_time){
//                                    if ($time>=Carbon::today()->addHours(9) && $time<=Carbon::today()->addHours(21)){
                                        if($va->main_attr=='大卫博士精装版'){
                                            $re[$i]['step']=6;
                                        }elseif($va->main_attr=='大卫博士高腰版' || $va->main_attr=='大卫博士青春版'){
                                            $re[$i]['step']=3;
                                        }
//                                    }
                                }
                            }
                        }

                        $re[$i]['name']=$va->name;
                        $re[$i]['attr_id']=$va->attr_id;
                        $re[$i]['size_id']=array_column($size,'id');
                        $re[$i]['size']=array_column($size,'size');
                        $ss=[];
                        foreach ($size as $kkes=>$vvas){
                            $ss[]=Cache::get('dwbs_good_num'.$vvas['id']);
                        }
//                        $ss=array_column($size,'storage');
                        if ($ss<3){
                            $re[$i]['storage']=0;
                        }else{
                            $re[$i]['storage']=$ss;
                        }

                        $re[$i]['goods_num']=$va->goods_num;
                        $re[$i]['money']=$va->money;
                        $re[$i]['unit']=$va->unit;
                        $re[$i]['main_img']=$va->main_img;
                        $re[$i]['banner_img']=json_decode($va->banner_img);
//                $re[$i]['banner_img']=[$va->main_img];
                        $re[$i]['sec_attr']=$va->sec_attr;
                        $i++;
                    }
                }
            }else{
                return $this->success_list([]);
            }
//        }
        return $this->success_list($re);
    }

    public function LimitGood(){
        $arr=['男款-L',
'男款-XL',
'男款-XXL',
'男款-3XL',
'男款-4XL',
'男款-5XL',
'男款-6XL',
'女款-M',
'女款-L',
'女款-XL',
'女款-XXL',
'女款-3XL',
'女款-4XL',
'女款-5XL'];
//        $re=LimitGood::where('user_id',Auth::user()->id)->get();
        $data=[];
        foreach ($arr as $k=>$v){
           $data[]=[
               'user_id'=>Auth::user()->id,
               'limit_num'=>2000,
               'num'=>0,
               'size'=>$v
           ];
        }
        return $this->success($data);
    }

    public function again_order(){
        $order_detail=OrderDetail::where('order_id',7)->groupBy('goods_name')->get();
        foreach ($order_detail as $k=>$v){
            $data=OrderDetail::where('goods_name',$v->goods_name)->where('order_id',7)->with(['get_good'])->get();
            $size=[];
            $size_id=[];
            $num=[];
            dump($data);
            foreach ($data as $ke=>$va){
                $size[$ke]=$va->goods_size;
                $size_id[$ke]=$va->goods_id;
                $num[$ke]=$va->num;
            }

            $re[$k]['size']=$size;
            $re[$k]['size_id']=$size_id;
            $re[$k]['num']=$num;
            $re[$k]['name']=$v->goods_name;
            $re[$k]['main_img']=$data[0]->get_good->main_img;
        }
        dd($re);
    }
    public function AddDataGood(){
//        dd(Cache::get('LIMITUSER39516'));
        $good=Goodtest::where('is_deleted',0)->whereIn('is_show',[1,2,3])->get();
//        $order_id=Ordertest::where('created_at','>','2024-07-01 21:00:00')->where('is_deleted',0)->pluck('id');
//        $gg=Orderdetail::whereIn('order_id',$order_id)->where('goods_unit','套')->sum('num');
//        $gg1=Orderdetail::whereIn('order_id',$order_id)->where('goods_unit','件')->sum('num');
//        dump('赠品数量===='.($gg+$gg1*2));
//        Cache::forever('GiftWaZiStatus',0);
//        Cache::forever('GiftWaZi',$gg+$gg1*2);
        foreach ($good as $k=>$v){
            $num=$v->storage;
//            Cache::forget('dwbs_good_num'.$v->id);
//            Cache::forever('dwbs_good_num'.$v->id,$v->storage);
            $ids=Ordertest::where('created_at','>','2024-07-30 00:00:00')->where('is_deleted',0)->pluck('id');
            $nums=Orderdetail::whereIn('order_id',$ids)->where('goods_id',$v->id)->sum('num');
            $n=$nums;
//            if (($num-$n)<=0){
//                $cache_num=0;
//            }else{
//                $cache_num=$num-$n;
//            }
//            Cache::forever('dwbs_good_num'.$v->id,$cache_num);
            $mm=Cache::get('dwbs_good_num'.$v->id);
            $k=$v->all_storage;
            dump($mm.'缓存数量=========='.$v->name.$v->size.'('.$v->id.')订单数量'.$n.'=======总库存'.$v->storage.'======='.$k.'======'.($n+$mm-$k));
//            if ($mm<30){
//            if (($n+$mm-$k)>0){
////                Cache::forget('dwbs_good_num'.$v->id);
//                Cache::decrement('dwbs_good_num'.$v->id,43);
//                dump($n.'===='.$k.'===='.$mm);
//            }
//            if ($mm==0){
//                if (($k-$n)>0){
//                    dump(111);
//                    Cache::forever('dwbs_good_num'.$v->id,$k-$n);
////                Cache::increment('dwbs_good_num'.$v->id,$k-$n-$mm);
//                    Goodtest::where('id',$v->id)->update(['storage'=>$k-$n]);
//                }else{
//                    dump(222);
//                    Cache::forever('dwbs_good_num'.$v->id,0);
//                    Goodtest::where('id',$v->id)->update(['storage'=>0]);
//                }
////
//            }

//            }
//            dump(Cache::get('dwbs_good_num'.$v->id).'=========='.$v->name.$v->size.'('.$v->id.')'.'======='.$v->storage);
        }
    }

    public function GetIndex(){
        $good=Goodtest::where('is_deleted',0)->whereIn('is_show',[1,2,3])->get();

        foreach ($good as $k=>$v){


            $ids=Ordertest::where('created_at','>','2022-03-18 08:00:00')->where('is_deleted',0)->pluck('id');
            $nums=Orderdetail::whereIn('order_id',$ids)->where('goods_id',$v->id)->sum('num');
            $n=$nums;

//            if (Cache::get('dwbs_good_num'.$v->id)==0){
//                dump(Cache::get('dwbs_good_num'.$v->id).'=========='.$v->name.$v->size.'('.$v->id.')'.'======='.$v->all_storage.'======'.$n);
//                if ($n<$v->all_storage){
//                    Cache::forever('dwbs_good_num'.$v->id,($v->all_storage-$n));
//            Goodtest::where('id',$v->id)->update(['storage'=>Cache::get('dwbs_good_num'.$v->id)]);
                }
//                dd(1);
//            }

//        }
        dd(1);
    }

    public function getuser_num(){
        $user=User::where('level',3)->get();
        foreach ($user as $k=>$v){
            $num=Cache::get('LIMITUSER'.$v->id);
//            Cache::forever('LIMITUSER'.$v->id,$nums);
//            if ($num==50){
                $id=Ordertest::where('user_id',$v->id)->where('is_deleted',0)->where('created_at','>','2024-05-18 09:00:00')->pluck('id');
                $nums=OrderDetail::whereIn('order_id',$id)->where('created_at','>','2024-05-18 09:00:00')->sum('num');
//                if ($nums!=50){
//                    Cache::forever('LIMITUSER'.$v->id,$nums);
//                }
//            }
            $str='';
            if ($num!=$nums){
                $str='异常';
            }
            dump(Cache::get('LIMITUSER'.$v->id).'------'.$nums.'====='.$v->nickname.'===='.$v->mobile.'====='.$str);
        }
    }


}