<?php namespace App\Model; use Illuminate\Database\Eloquent\Model; class LogModel extends Model { protected $connection = 'web'; protected $table = 'log'; public $timestamps = false; const UPDATE_OPERATE = 1; const ADD_OPERATE = 2; const VIEW_OPERATE = 3; public static function getLastLog($supplierId, $ignoreAuditCheck = true) { $query = self::where('supplier_id', $supplierId) ->where('type', LogModel::UPDATE_OPERATE); if ($ignoreAuditCheck) { $query->where('ignore_audit_check', 0); } return $query->where('ignore_audit_check', 0)->orderBy('id', 'desc')->first(); } }