thinkphp5的一些小写法

统计去重写法

Db::name('order')->where(['pay_status' => 1])->count('distinct user_id');

scope统计

将一些特定写法封装起来复用
-- ClerkModel.php
function scopeUserId($query) {
	return $query->where('user_id IS NOT NULL AND user_id <> 0');
}
-- Usage:
(new ClerkModel)->userId()->select()->toArray()
或者
ClerkModel::userId()->select()->toArray();

增加或者减少

(new Goods())->where('goods_id', 125)->setInc();

todo:继续补充中...