fssy/application/store/controller/SignLog.php

<?php


namespace app\store\controller;

use library\Controller;
use think\Db;

/**
 * 会员签到
 * Class Integral
 * @package app\store\controller
 */
class SignLog extends Controller
{
    protected  $table ="UserSign";


    /**
     * 签到变更列表
     * @auth true
     * @menu true
     */
    public function index()
    {
        $this->title = '签到变更列表';
        $query = $this->_query($this->table);
        $where= [];
        if($this->request->request('user_name'))      $where[]= ['m.name','like','%'.$this->request->request('user_name').'%'];
        if($this->request->request('sign_time'))      $where[] = ['i.create_at','between time',[$this->request->request('sign_time').' 00:00:00',$this->request->request('sign_time').' 23:59:59']];
        $query->alias('i')
            ->field('i.* ,m.headimg,m.name,m.phone')
            ->join('store_member m',' m.id = i.uid ','LEFT');
        if(!empty($where)) $query->where($where);
        $query ->order('i.id desc')->page();
    }

    /**
     * 删除签到日志
     * @auth true
     * @menu true
     */
    public function del()
    {
        $this->_save($this->table, ['is_deleted' => 1]);
    }




}