where条件多种情况
同一订单号重复的商品
$list = $model->where($where)->order($order)->group("docnum")->field('count(docnum) num,docnum')->select();
where条件等于某个数字
$where = [ ['name','=','thinkphp'], ['status','=',1] ];
where条件为一个数组
$applyStatus = array( 1 => 4, 2 => 5, ); $where['apply_status'] = ['in', $applyStatus];
json对象
$params = $_POST; $goods = json_decode($params['chooseGoodsList'], true); dump(json_decode($goods);die;
不为某个数
'audittime' => ['neq', 'NULL']