xianglian_test_admin/application/user/controller/WalletInfo.php

<?php


namespace app\user\controller;

use library\Controller;
use think\Db;

/**
 * 余额明细
 * Class WalletInfo
 * @package app\user\controller
 */
class WalletInfo extends Controller
{
    protected  $table ="StoreMemberLog";


    /**
     * 列表
     * @auth true
     * @menu true
     */
    public function index()
    {
        $this->title = '列表';
        $phone = input('phone');
        $name = input('name');
        $user_id = input('user_id');
        $where= [];
        if($phone)      $where[]= ['m.phone','=',$phone];
        if($name)      $where[]= ['m.name','=',$name];
        if($user_id)      $where[]= ['i.m_id','=',$user_id];
        $query = $this->_query($this->table)->alias('i')
            ->field('i.* ,m.headimg,m.name,m.phone')
            ->join('store_member m',' m.id = i.m_id ','LEFT');
        if(!empty($where)) $query->where($where);
        $query ->order('i.id desc')->page();
    }




}