I made below code for save some data to user table when taken a logout event, and now need to save same data to "login_histories" table for recording user log histories, then how to modify this function handle in below code? Thanks:)
timestamp_create_login_histories_table.php
public function up()
{
Schema::create('login_histories', function (Blueprint $table) {
$table->engine = 'InnoDB';
$table->increments('id')->unsigned();
$table->integer('user_id')->unsigned()->index();
$table->timestamp('last_login_at')->nullable();
$table->string('last_login_ip')->nullable();
$table->timestamps();
$table->softDeletes();
$table->foreign('user_id')->nullable()->references('id')->on('users')->onDelete('cascade')->onUpdate('cascade');
});
}
App\Listeners\LogSuccessfulLogin.php
namespace App\Listeners;
use Illuminate\Auth\Events\Login;
use Illuminate\Http\Request;
class LogSuccessfulLogin
{
/**
* Create the event listener.
*
* @param Request $request
* @return void
*/
public function __construct(Request $request)
{
$this->request = $request;
}
public function handle(Login $event)
{
$user = $event->user;
$user->last_login_at = date('Y-m-d H:i:s');
$user->last_login_ip = $this->request->ip();
$user->save();
}
Must make a model login_histories firstly? and then could I modify like below code?
public function handle(Login $event)
{
$login_histories = $event->login_histories;
$login_histories->last_login_at = date('Y-m-d H:i:s');
$login_histories->last_login_ip = $this->request->ip();
$login_histories->save();
}