GameEnterLog.php 895 B

123456789101112131415161718192021222324252627282930313233343536373839
  1. <?php
  2. namespace App\Models;
  3. use Illuminate\Database\Eloquent\Model;
  4. class GameEnterLog extends Model
  5. {
  6. const TABLE = 'agent.dbo.game_enter_log';
  7. protected $table = self::TABLE;
  8. public $timestamps = false;
  9. protected $fillable = [
  10. 'user_id',
  11. 'game_id',
  12. 'duration_ms',
  13. 'log_date',
  14. 'created_at',
  15. ];
  16. /**
  17. * @param array $data user_id, game_id, duration_ms, log_date (optional)
  18. * @return bool
  19. */
  20. public static function addLog(array $data)
  21. {
  22. $logData = [
  23. 'user_id' => (int) ($data['user_id'] ?? 0),
  24. 'game_id' => (int) ($data['game_id'] ?? 0),
  25. 'duration_ms' => (int) ($data['duration_ms'] ?? 0),
  26. 'log_date' => $data['log_date'] ?? date('Y-m-d'),
  27. 'created_at' => date('Y-m-d H:i:s'),
  28. ];
  29. return self::insert($logData);
  30. }
  31. }