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

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

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

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

		$dobarray=DB::select(DB::raw("select peopledata from records where `DOB` like '$birthday'"));

			foreach($dobarray as $dobarr)
                        {
                          $dobarray = unserialize($dobarr->peopledata);
			  $dobarray['priority']='11';
			  $preppldata['peopledata'] = $dobarray;
			  $query=$wakka->setPerson($dobarray['id'],$preppldata);
			}
	}
}