Welcome Guest, Not a member yet? Register   Sign In
Entity auto convert column to time instance on joined table ?
#1

Can an Entity class convert to time instance a joined table column ? i use this query below and want the auth_logins.date to be converted to Time instance if possible

PHP Code:
$model model(UserModel::class);

 
// Users with last login date and success
 
$users $model->select("users.*, auth_logins.date, auth_logins.success")
 
  ->join('auth_logins''auth_logins.user_id = users.id''left outer')
 
  ->where('(SELECT MAX(`id`) FROM `auth_logins` WHERE `auth_logins`.`user_id` = `users`.`id` ) IS NULL'nullfalse)
 
  ->orWhere('`auth_logins`.`id` = (SELECT MAX(`id`) FROM `auth_logins` WHERE `user_id` = `users`.`id`)'nullfalse)
 
  ->findAll($perPage$start); 

I try to add the date column in the entity class

PHP Code:
    /**
    * Define properties that are automatically converted to Time instances.
    */
    protected $dates = ['reset_at''reset_expires''created_at''updated_at''deleted_at''date']; 
Reply


Messages In This Thread
Entity auto convert column to time instance on joined table ? - by eelisland - 09-08-2021, 04:29 AM



Theme © iAndrew 2016 - Forum software by © MyBB