thinkphp6多条件查询及常用写法

thinkphp6多条件查询及常用写法

$map = [];
$map[] = ['ProductId','=',$v['ProductId']];
$map[] = ['OrderType','<>',""];   //不等于空
$map[] = ['OrderType','not null','']; //不等于null
$map[] = ['OrderType','null','']; //等于null
$map[] = ['OrderTime','between',[$Date0,$Date1]];  //在两数之间
$map[] = ['OrderTime','not between',[$Date0,$Date1]];  //不在两数之间
$map[] = ['TypeId','in',$ids];  //包含在逗号分割的字符里
$map[] = ['TypeId','not in',$ids];  //不含逗号分割的字符
$map[] = ['Name','like',"%$keys%"];  //包含关键字的字符
$list = Db::name('tables')->where([$map])->select();