<?php namespace App\Console\Commands;

use Illuminate\Console\Command;
//use Mail;
use DB;
use Config;

use App\Models\User;
use App\Models\Accesslog;

use App\Models\CRMCall;
use Schema;
use PDO;
use App\Models\Notification;
use App\Jobs\KHRMSLib;

use Input;
use App\Models\Sipid;
use App\Models\Kqueue;
use App\Models\Dialline;
use App\Models\Session;

use Illuminate\Database\Schema\Blueprint;

class update_monthly_records extends Command {

	/**
	 * The console command name.
	 *
	 * @var string
	 */
	protected $signature = 'update_monthly_records';

	/**
	 * The console command description.
	 *
	 * @var string
	 */
	protected $description = 'update_monthly_records';

	/**
	 * Execute the console command.
	 *
	 * @return mixed
	 */
	public function handle()
	{
		echo "\n".date('Y-m-d H:i:s')."\n";

			DB::update(DB::raw("update records set old_status=status"));sleep(300);
                        DB::update(DB::raw("update records set old_dialer_status=dialer_status"));sleep(300);
                        DB::update(DB::raw("update records set old_dialer_substatus=dialer_substatus"));sleep(300);
                        DB::update(DB::raw("UPDATE `records` SET status='Noqueue' WHERE firstname NOT LIKE '%Potential%' and (currentstatus='PASSIVE' or legalstatus='SECONDARY') and status='Called'"));sleep(300);
                        DB::update(DB::raw("update records set status='New' where status != 'Noqueue'"));sleep(300);
                        DB::update(DB::raw("update records set dialer_status='',dialer_substatus='' where dialer_status != 'InboundDROP'"));
		echo "\n".date('Y-m-d H:i:s')."\n";

	}
}