<?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 ClearDiallines extends Command {

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

	/**
	 * The console command description.
	 *
	 * @var string
	 */
	protected $description = 'Clear diallines if it is not in use';

	/**
	 * Execute the console command.
	 *
	 * @return mixed
	 */
	public function handle()
	{
    	DB::update(DB::raw("update diallines set status='Free' where channel='' and status='Blocked'"));
	}
}