phpstock/app/admin/controller/Activity.php

<?php

namespace app\admin\controller;

use app\BaseController;
use think\App;
use think\facade\Db;

class Activity extends BaseController
{
    public $post="";
    public function __construct(App $app)
    {
        parent::__construct($app);
        $this->post=$this->request->post();
    }
    public function list(){
        $page = isset($this->post['page']) && $this->post['page'] !==""? intval($this->post['page']):"1";
        $size = isset($this->post['size']) && $this->post['size'] !==""? intval($this->post['size']):"10";
        $where = [["is_del","=",0]];
        $activity_name = isset($this->post['activity_name']) && $this->post['activity_name'] !=="" ? trim($this->post['activity_name']):"";
        if($activity_name!=""){
            $where[]=['activity_name',"like","%$activity_name%"];
        }
        $status = isset($this->post['status']) && $this->post['status'] !=="" ? intval($this->post['status']):"";
        if($status!=""){
            $where[]=['status',"=",$status];
        }
        $activity_code = isset($this->post['activity_code']) && $this->post['activity_code'] !=="" ? intval($this->post['activity_code']):"";
        if($activity_code!=""){
            $where[]=['activity_code',"like","%$activity_code%"];
        }
        $starttime = isset($this->post['starttime']) && $this->post['starttime']!=="" ? $this->post['starttime']:"";
        if($starttime!==""){
            $where[]=['start',">=",date('Y-m-d H:i:s',strtotime($starttime))];
        }
        $endtime = isset($this->post['endtime']) && $this->post['endtime']!=="" ? $this->post['endtime']:"";
        if($endtime!==""){
            $where[]=['end',"<",date('Y-m-d H:i:s',strtotime($endtime)+24*3600)];
        }
        $platform_code = isset($this->post['platform_code']) && $this->post['platform_code'] !=="" ? trim($this->post['platform_code']):"";
        if($platform_code!=""){
            $where[]=['platform_code',"=",$platform_code];
        }
        $company_id = isset($this->post['company_id']) && $this->post['company_id'] !=="" ? trim($this->post['company_id']):"";
        if($company_id!=""){
            $where[]=['company_id',"=",$company_id];
        }

        $count = Db::name('good_activity')->where($where)->count();
        $total = ceil($count / $size);
        $page = $page >= $total ? $total : $page;
        $list = Db::name('good_activity')->where($where)->page($page,$size)->order("addtime desc")->select();
        $data=[];
        foreach ($list as $value){
            $info = Db::name("platform")->where(['platform_code'=>$value['platform_code']])->find();
            $value['platform_name']=$info['platform_name'];
            $data[]=$value;
        }
        return app_show(0,"获取成功",['list'=>$data,'count'=>$count]);
    }
    public function linst()
    {
        $page = isset($this->post['page']) && $this->post['page'] !== "" ? intval($this->post['page']) : "1";
        $size = isset($this->post['size']) && $this->post['size'] !== "" ? intval($this->post['size']) : "10";
        $where = [["a.is_del", "=", 0]];
        $spuCode = isset($this->post['spuCode']) && $this->post['spuCode'] !== "" ? trim($this->post['spuCode']) : "";
        if ($spuCode != "") {
            $where[] = ['a.spuCode', "like", "%$spuCode%"];
        }
        $good_name = isset($this->post['good_name']) && $this->post['good_name'] !== "" ? trim($this->post['good_name']) : "";
        if ($good_name != "") {
            $where[] = ['a.good_name', "like", "%$good_name%"];
        }
        $activity_code = isset($this->post['activity_code']) && $this->post['activity_code'] !=="" ? intval($this->post['activity_code']):"";
        if($activity_code!=""){
            $where[]=['a.activity_code',"like","%$activity_code%"];
        }
        $status = isset($this->post['status']) && $this->post['status'] !=="" ? intval($this->post['status']):"";
        if($status!=""){
            $where[]=['a.status',"=",$status];
        }
        $activity_name = isset($this->post['activity_name']) && $this->post['activity_name'] !=="" ? trim($this->post['activity_name']):"";
        if($activity_name!=""){
            $where[]=['b.activity_name',"like","%$activity_name%"];
        }
        $platform_code = isset($this->post['platform_code']) && $this->post['platform_code'] !=="" ? trim($this->post['platform_code']):"";
        if($platform_code!=""){
            $where[]=['c.platform_code',"=",$platform_code];
        }
        $count = Db::name('activity_info')->alias("a")
            ->join("good_activity b","b.activity_code=b.activity_code","left")
            ->join("platform c","c.platform_code=b.platform_code","left")
            ->where($where)->count();
        $total = ceil($count / $size);
        $page = $page >= $total ? $total : $page;
        $list = Db::name('activity_info')->alias("a")
            ->join("good_activity b","b.activity_code=b.activity_code","left")
            ->join("platform c","c.platform_code=b.platform_code","left")
            ->where($where)->page($page,$size)->order("a.addtime desc")->field("a.*,b.activity_name,c.platform_name")->select();
        return app_show(0,"获取成功",['list'=>$list,'count'=>$count]);
    }
    public function zilist(){
        $page = isset($this->post['page']) && $this->post['page'] !== "" ? intval($this->post['page']) : "1";
        $size = isset($this->post['size']) && $this->post['size'] !== "" ? intval($this->post['size']) : "10";
        $where = [["a.is_del", "=", 0]];
        $good_code = isset($this->post['good_code']) && $this->post['good_code'] !== "" ? trim($this->post['good_code']) : "";
        if ($good_code != "") {
            $where[] = ['a.good_code', "like", "%$good_code%"];
        }
        $good_name = isset($this->post['good_name']) && $this->post['good_name'] !== "" ? trim($this->post['good_name']) : "";
        if ($good_name != "") {
            $where[] = ['a.good_name', "like", "%$good_name%"];
        }

        $status = isset($this->post['status']) && $this->post['status'] !=="" ? intval($this->post['status']):"";
        if($status!=""){
            $where[]=['a.status',"=",$status];
        }
        $supplierNo = isset($this->post['supplierNo']) && $this->post['supplierNo'] !== "" ? trim($this->post['supplierNo']) : "";
        if ($supplierNo != "") {
            $where[] = ['a.supplierNo', "like", "%$supplierNo%"];
        }
        $name = isset($this->post['name']) && $this->post['name'] !== "" ? trim($this->post['name']) : "";
        if ($name != "") {
            $where[] = ['b.name', "like", "%$name%"];
        }
        $count = Db::name('good_zixun')->alias("a")->join("supplier b","b.code=a.supplierNo","left")
            ->where($where)->count();
        $total = ceil($count / $size);
        $page = $page >= $total ? $total : $page;
        $list = Db::name('good_zixun')->alias("a")->join("supplier b","b.code=a.supplierNo","left")
            ->where($where)->page($page,$size)->order("a.addtime desc")->field("a.*,b.name")->select();
        return app_show(0,"获取成功",['list'=>$list,'count'=>$count]);
    }

    public function create(){
        $activity_name = isset($this->post['activity_name'])&&$this->post['activity_name']!="" ? trim($this->post['activity_name']):"";
        if($activity_name==""){
            return error_show(1004,"参数activity_name不能为空");
        }
        $platform_code = isset($this->post['platform_code'])&&$this->post['platform_code']!="" ? trim($this->post['platform_code']):"";
        if($platform_code==""){
            return error_show(1004,"参数platform_code不能为空");
        }
        $company_id = isset($this->post['company_id'])&&$this->post['company_id']!="" ? trim($this->post['company_id']):"";
        if($company_id==""){
            return error_show(1004,"参数company_id不能为空");
        }
        $activity_start = isset($this->post['activity_start'])&&$this->post['activity_start']!="" ? $this->post['activity_start']:"";
        if($activity_start==""){
            return error_show(1004,"参数activity_start不能为空");
        }
        $activity_end = isset($this->post['activity_end'])&&$this->post['activity_end']!="" ? $this->post['activity_end']:"";
        if($activity_end==""){
            return error_show(1004,"参数activity_end不能为空");
        }
        $activity_desc = isset($this->post['activity_desc'])&&$this->post['activity_desc']!="" ?
            trim($this->post['activity_desc']):"";
        if($activity_desc==""){
            return error_show(1004,"参数activity_desc不能为空");
        }
        $is_stock = isset($this->post['is_stock'])&&$this->post['is_stock']!=="" ?
            intval($this->post['is_stock']):"";
        if($is_stock===""){
            return error_show(1004,"参数is_stock不能为空");
        }
        $good_list= isset($this->post['good_list'])&&$this->post['good_list']!=="" ?$this->post['good_list']:"";
        if($good_list==""){
            return error_show(1004,"参数good_list不能为空");
        }
        $activity_code = makeNo("ACT");
        Db::startTrans();
        try{
            $data=[
                "activity_name"=>$activity_name,
                "activity_code"=>$activity_code,
                "is_stock"=>$is_stock,
                "start"=>$activity_start,
                "end"=>$activity_end,
                "platform_code"=>$platform_code,
                "activity_desc"=>$activity_desc,
                "company_id"=>$company_id,
                "creater"=>"",
                "createrid"=>0,
                "status"=>0,
                "is_del"=>0,
                "addtime"=>date("Y-m-d H:i:s"),
                "updatetime"=>date("Y-m-d H:i:s")
            ];
            $inset = Db::name("good_activity")->insert($data);
            if($inset){
                if($good_list!=""&&!empty($good_list)){
                    $temp=[];
                    foreach ($good_list as $value){
                        $lemp=[];
                        $lemp['spuCode']=$value['spuCode'];
                        $lemp['good_name']=$value['good_name'];
                        $lemp['activity_code']=$activity_code;
                        $lemp['activity_stock']=$value['activity_stock'];
                        $lemp['moq_num']=0;
                        $lemp['cost_price']=0;
                        $lemp['sale_price']=0;
                        $lemp['activity_price']=0;
                        $lemp['status']=0;
                        $lemp['remark']="";
                        $lemp['is_del']=0;
                        $lemp['addtime']=date("Y-m-d H:i:s");
                        $lemp['updatetime']=date("Y-m-d H:i:s");
                        $temp[]=$lemp;
                    }
                    $iall=Db::name("activity_info")->insertAll($temp);
                    if($iall==0){
                        Db::rollback();
                        return error_show(1005,"新建失败");
                    }
                }
                Db::commit();
                return app_show(0,"新建成功");
            }

        }catch (\Exception $e){
            Db::rollback();
            return error_show(1005,$e->getMessage());
        }
    }

    public  function  cost(){
        $good_list= isset($this->post['good_list'])&&!empty($this->post['good_list']) ?$this->post['good_list']:"";
        if($good_list==""){
            return error_show(1004,"参数good_list不能为空");
        }
        $activity_code= isset($this->post['activity_code'])&&$this->post['activity_code']!=="" ?trim($this->post['activity_code']):"";
        if($activity_code==""){
            return error_show(1004,"参数activity_code不能为空");
        }
        $activity = Db::name("good_activity")->where(["activity_code"=>$activity_code,"is_del"=>0])->find();
        if($activity==false){
            return error_show(1004,"未找到活动数据");
        }
        Db::startTrans();
        try{
            foreach ($good_list as $value){
                $temp=[];
                $temp["id"]=$value['id'];
                $temp["cost_price"]=$value['cost_price'];
                $temp["moq_num"]=$value['moq_num'];
                $temp["updatetime"]=date("Y-m-d H:i:s");
                $up=Db::name("activity_info")->save($temp);
                if($up==false){
                    Db::rollback();
                    return error_show(1004,"商品数据更新失败");
                }
            }
            $activity['status']=2;
            $activity['updatetime']=date("Y-m-d H:i:s");
            $act = Db::name("good_activity")->save($activity);
            if($act){
                Db::commit();
                return error_show(0,"商品数据更新成功");
            }else{
                Db::rollback();
                return error_show(1004,"商品数据更新失败");
            }

        }catch (\Exception $e){
            Db::rollback();
            return error_show(1004,$e->getMessage());
        }
    }
    public  function  activity(){
        $good_list= isset($this->post['good_list'])&&!empty($this->post['good_list']) ?$this->post['good_list']:"";
        if($good_list==""){
            return error_show(1004,"参数good_list不能为空");
        }
        $activity_code= isset($this->post['activity_code'])&&$this->post['activity_code']!=="" ?trim($this->post['activity_code']):"";
        if($activity_code==""){
            return error_show(1004,"参数activity_code不能为空");
        }
        $activity = Db::name("good_activity")->where(["activity_code"=>$activity_code,"is_del"=>0])->find();
        if($activity==false){
            return error_show(1004,"未找到活动数据");
        }
        Db::startTrans();
        try{
            foreach ($good_list as $value){
                $temp=[];
                $temp["id"]=$value['id'];
                $temp["sale_price"]=$value['sale_price'];
                $temp["activity_price"]=$value['activity_price'];
                $temp["updatetime"]=date("Y-m-d H:i:s");
                $up=Db::name("activity_info")->save($temp);
                if($up==false){
                    Db::rollback();
                    return error_show(1004,"商品数据更新失败");
                }
            }
            $activity['status']=3;
            $activity['updatetime']=date("Y-m-d H:i:s");
            $act = Db::name("good_activity")->save($activity);
            if($act){
                Db::commit();
                return error_show(0,"商品数据更新成功");
            }else{
                Db::rollback();
                return error_show(1004,"商品数据更新失败");
            }

        }catch (\Exception $e){
            Db::rollback();
            return error_show(1004,$e->getMessage());
        }
    }

    public  function  exam(){
        $good_list= isset($this->post['good_list'])&&!empty($this->post['good_list']) ?$this->post['good_list']:"";
        if($good_list==""){
            return error_show(1004,"参数good_list不能为空");
        }
        $activity_code= isset($this->post['activity_code'])&&$this->post['activity_code']!=="" ?trim($this->post['activity_code']):"";
        if($activity_code==""){
            return error_show(1004,"参数activity_code不能为空");
        }
        $activity = Db::name("good_activity")->where(["activity_code"=>$activity_code,"is_del"=>0])->find();
        if($activity==false){
            return error_show(1004,"未找到活动数据");
        }
        Db::startTrans();
        try{
            foreach ($good_list as $value){
                $temp=[];
                $temp["id"]=$value['id'];
                $temp["status"]=$value['status'];
                $temp["remark"]=$value['remark'];
                $temp["updatetime"]=date("Y-m-d H:i:s");
                $up=Db::name("activity_info")->save($temp);
                if($up==false){
                    Db::rollback();
                    return error_show(1004,"商品数据更新失败");
                }
            }
            $activity['status']=4;
            $activity['updatetime']=date("Y-m-d H:i:s");
            $act = Db::name("good_activity")->save($activity);
            if($act){
                Db::commit();
                return error_show(0,"商品数据审核成功");
            }else{
                Db::rollback();
                return error_show(1004,"商品数据审核失败");
            }

        }catch (\Exception $e){
            Db::rollback();
            return error_show(1004,$e->getMessage());
        }
    }

    public function  info(){
        $activity_code= isset($this->post['activity_code'])&&$this->post['activity_code']!=="" ?trim($this->post['activity_code']):"";
        if($activity_code==""){
            return error_show(1004,"参数activity_code不能为空");
        }
        $activity = Db::name("good_activity")->where(["activity_code"=>$activity_code,"is_del"=>0])->find();
        if($activity==false){
            return error_show(1004,"未找到活动数据");
        }
        $activity_info =Db::name("activity_info")->where(["activity_code"=>$activity_code,"is_del"=>0])->select();
        $activity['info']=empty($activity_info)?[]:$activity_info;
        return  app_show(0,"获取成功",$activity);
    }


}