Laravel常用的数据库操作

数据递增

$item   = StatisticsPlatform::firstOrCreate([
            'day' => LmTime::dayStart($date),
        ]);

$item->update([
    'order_create'         => \DB::raw('order_create + 1'),
    $order_create_platform => \DB::raw($order_create_platform . '+ 1'),
]);

数据求和

$total = StatisticsPlatform::select([
            \DB::raw('SUM(register_total) as register_total'),
            \DB::raw('SUM(register_pc) as register_pc'),
            \DB::raw('SUM(register_android) as register_android'),
        ])->get();

根据条件求多条数据某个字段的和

$lock_money = FinanceLock::where('account_id', $item->account_id)
                ->where('lock_type', '!=', 'unlock')
                ->sum('amount');

一次更新多条数据的相应字段值

FinanceRebate::whereIn('activity_id', $arr)
    ->update([
        'can_apply'=> 1
    ]);

根据两个字段的和或差选取数据

$items = BeMonitorNotify::where(\DB::raw('(unix_timestamp(now())-unix_timestamp(updated_at)-exec_time)'), '>', 0)
->get();

去除重复值

$items = FinanceLock::groupBy('account_id')->lists('account_id')->toArray();

---

未完待续。。。