lachang/app/common/model/member/MemberTj.php

<?php
// +----------------------------------------------------------------------
// | 萤火商城系统 [ 致力于通过产品和服务，帮助商家高效化开拓市场 ]
// +----------------------------------------------------------------------
// | Copyright (c) 2017~2021 https://www.yiovo.com All rights reserved.
// +----------------------------------------------------------------------
// | Licensed 这不是一个自由软件，不允许对程序代码以任何形式任何目的的再发行
// +----------------------------------------------------------------------
// | Author: 萤火科技 <admin@yiovo.com>
// +----------------------------------------------------------------------
declare (strict_types = 1);

namespace app\common\model\member;

use app\common\library\helper;
use app\console\model\Setting as SettingModel;
use think\facade\Db;
use app\common\model\BaseModel;


/**
 * 会员统计模型
 * Class Order
 * @package app\common\model
 */
class MemberTj extends BaseModel
{
    // 定义表名
    protected $name = 'member_tj';

    // 定义表名(外部引用)
    public static $tableName = 'member_tj';

    // 定义主键
    protected $pk = 'id';

    // // 定义别名
    // protected $alias = 'id';

    protected $ftype = [1=>'day',2=>'week',3=>'month'];

    //(商品总价 - 优惠券 - 分销员)+ 运费 = 微信支付+米卡抵扣+米卡抵扣运费(total_price-coupon_money-distrbutor_total_money)+express_price = pay_price+rice_card_money+rice_card_express_money
    public function day($dif = 1){
        //应付总金额（含运费）
        //未扣减优惠金额、米卡抵扣金额前的订单总金额

        $start = Date("Y-m-d",time()-86400*$dif)." 00:00:00";
        $end = Date("Y-m-d",time()-86400*$dif)." 23:59:59";
        $remark = Date("Y-m-d",time()-86400*$dif);
        $data = $this->search($start,$end);
        $data['remark'] = $remark;
        $data['ftype'] = 1;
        $data['tj_time'] = Date("Y-m-d H:i:s",strtotime($start) + 10);
        $this->add($data);
         // var_dump(Date("Y-m-d H:i:s",$data['tj_time']));
        return true;

    }

    public function month($dif = 1){

      $d = date("d",time());
      if($d!='01'){
            return false;
      }
      $standardTime = date('Y-m-1');
      $_lastMonthStart = date('Y-m-01 00:00:00', strtotime("-1 month", strtotime($standardTime)));
      $_lastMonthEnd = date('Y-m-d H:i:s', strtotime('-1 sec', strtotime($standardTime)));
      $start = $_lastMonthStart;
      $end = $_lastMonthEnd;
      $remark = substr($_lastMonthStart,0,7);
      $data = $this->search($start,$end);
      $data['ftype'] =3;
      $data['remark'] = $remark;
      $data['tj_time'] = Date("Y-m-d H:i:s",strtotime($start) + 10);
       // var_dump(Date("Y-m-d H:i:s",$data['tj_time']));
      $this->add($data);
       return true;
    }


    public function week($dif = 1){
        //上周一
        $w = date("w",time());
        if($w!=1){
            return false;;
        }

        $t = $w==1?1:2; //如果当前时间是周一，则-1，如果已经是周二 要-2
        $d1 = date('Y-m-d 00:00:00',strtotime('-'.$t.' monday',time())); //无论今天几号,-1 monday为上一个有效周未
        //上周日
        $d7 = date('Y-m-d 23:59:59',strtotime('-1 sunday', time())); //
        //上一个有效周日,同样适用于其它星期

        $remark = substr($d1,0,10).'--'.substr($d7,0,10);

        $start = $d1;
        $end = $d7;

        $data = $this->search($start,$end);
        $data['ftype'] =2;
        $data['remark'] = $remark;
        $data['tj_time'] = Date("Y-m-d H:i:s",strtotime($start) + 10);
        // var_dump(Date("Y-m-d H:i:s",$data['tj_time']));
        $this->add($data);
        return true;
    }

    //查找时间段
    public function search($start,$end){
        $sql = "SELECT count(1) as t1
         FROM yoshop_member_order where pay_status=? and  create_time>? and create_time<?";
        $param = [1,$start,$end];
        $result = Db::query($sql, $param);

        $t1 = $result[0]['t1']??1;//订单数
      
        $data = ['values'=>$t1];
        return $data;
    }

    //添加
    public function add($data){
        $m = new MemberTj;
        $one = $m->where('remark',$data['remark'])->where("ftype",$data['ftype'])->find();
        if(empty($one)){
            $m->save($data);
        }else{
            // var_dump($data);
            $one->where('id',$one->id)->update($data);
        }
    }


    public function getList($params){
                // 检查查询条件
        $filter = [];
        if(!isset($params['ftype'])){
            // $params['ftype'] = 3;
        }

        isset($params['ftype'])&&$params['ftype']>-1 && $filter[] = ['ftype', '=', (int)$params['ftype']];
        //  申请时间
        if (!empty($params['betweenTime'])) {
            $times = between_time($params['betweenTime']);
            $filter[] = ['tj_time', '>=', Date('Y-m-d H:i:s',$times['start_time'])];
            $filter[] = ['tj_time', '<', Date('Y-m-d H:i:s',$times['end_time'] + 86400)];
        }
        return $this->where($filter)->order(['create_time' => 'id'])->paginate(10000);
    }

    // /**
    //  * 导出列表
    //  * @param array $param
    //  * @author: zq
    //  * @Time: 2021/10/15 13:51
    //  */
    // public function listExport(array $params)
    // {
    //     //$ids = $param['goods_id'];
    //     $data['header'] = ['时间', '应付总金额（含运费）', '应付商品总金额', '实付金额（含运费）', '运费','平台优惠券抵扣', '成交用户数','订单数','客单价'];
    //     $data['filename'] = '销售分析';
    //     $data['data'] = [];
    //     $filter = [];
    //     isset($params['ftype'])&&$params['ftype']>-1 && $filter[] = ['ftype', '=', (int)$params['ftype']];
    //     //  申请时间
    //     if (!empty($params['betweenTime'])) {
    //         $times = between_time($params['betweenTime']);
    //         $filter[] = ['tj_time', '>=', Date('Y-m-d H:i:s',$times['start_time'])];
    //         $filter[] = ['tj_time', '<', Date('Y-m-d H:i:s',$times['end_time'] + 86400)];
    //     }

    //     $res = $this->where($filter)->order(['create_time' => 'desc'])->select();
        
    //        $data = ['total_price'=>$t1,
    //             'total_goods_price'=>$t2,
    //             'total_pay_price'=>$t3,
    //             'total_express_price'=>$t4,
    //             'total_coupon_price'=>$t5,
    //             'total_users'=>$t6,
    //             'total_orders'=>$t7,
    //             'pcts'=>$t8];
        
    //     $newdata = [];
    //     foreach($res as $row){
    //         $newrow['remark'] = $row['remark'];
    //         $newrow['total_price'] = $row['total_price'];
    //         $newrow['total_goods_price'] = $row['total_goods_price'];
    //         $newrow['total_pay_price'] = $row['total_pay_price'];
    //         $newrow['total_express_price'] = $row['total_express_price'];
    //         $newrow['total_coupon_price'] = $row['total_coupon_price'];
    //         $newrow['total_users'] = $row['total_users'];
    //         $newrow['total_orders'] = $row['total_orders'];
    //         $newrow['pcts'] = $row['pcts'];
    //         $newdata[] = $newrow;
    //     }
    //     $data['data'] = $newdata;
    //     return $data;
    // }

}