<?php

namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Models\User;
use App\Models\Subscription;


class CronController extends Controller
{
    public function __construct()
    {
        $this->userModel    = new User;
        $this->subscriptionModel = new Subscription;
    }

    public function subscription_validity(){
        $all_subscribe_user = $this->userModel->where('curr_pkg_end_dt','!=','')->where('package_id','!=','')->get();
        $curr_date = strtotime(date("Y-m-d H:i:s"));
        foreach($all_subscribe_user as $user){
            if($user->curr_pkg_end_dt != '' && strtotime($user->curr_pkg_end_dt) < $curr_date){
                $user_update = array(
                    'package_id'       => NULL,
                    'curr_pkg_end_dt'  => NULL
                );
                $subscription_update = array(
                    'status' => 2
                );
                $this->userModel->where('id',$user->id)->update($user_update);
                $this->subscriptionModel->where('user_id',$user->id)->update($subscription_update);
            }
        } 
        echo "Done";
    }
}

   ?>