<?php

class UsersLoginNumMapper extends Mapper
{
  private $entityClass = 'UsersLoginNumEntity';

  public function countUsersLoginNum($user_id) {
    $sql = 'SELECT COUNT(login_id) from users_login_num WHERE `user_id`=:user_id';
    $sth = $this->db->prepare($sql);
    $sth->execute(['user_id'=>$user_id]);
    $rows = $sth->fetch(PDO::FETCH_NUM);
    return $rows[0];
  }
  public function save($user_id){
    $sql = "INSERT INTO users_login_num (`user_id`,`login_time`,`ip`,`ua`) values (:user_id, :login_time, :ip, :ua)";
    $stmt = $this->db->prepare($sql);
    $result = $stmt->execute([
        "user_id" => $user_id,
        "login_time" => date('Y-m-d H:i:s'),
        "ip" => $_SERVER['REMOTE_ADDR'],
        "ua" => isset($_SERVER['HTTP_USER_AGENT']) ? $_SERVER['HTTP_USER_AGENT'] : '',
    ]);
    return $this->db->lastInsertId();
  }
}