<?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 App\Models\Cutoff;

use Log;
use Illuminate\Database\Schema\Blueprint;

class UpdateAvgRingSec extends Command {

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

	/**
	 * The console command description.
	 *
	 * @var string
	 */
	protected $description = 'Update Avg Call Ring Sec Of Last 50 Calls';

	/**
	 * Execute the console command.
	 *
	 * @return mixed
	 */
	public function handle()
	{
		$avgcallsecObj = CRMCall::select(DB::Raw('ROUND((avg(callsec))/1000) as avgcallsec'))->limit(50)->where("type","!=","Inbound")->first();

		if(count($avgcallsecObj))
		{
			Cutoff::where('user_id', '!=', "")->update(
					['avg_ring' => $avgcallsecObj->avgcallsec
					]);
		}
	}
}