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

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

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

	/**
	 * Execute the console command.
	 *
	 * @return mixed
	 */
	public function handle()
	{
		echo 'Start';

			$local_data=DB::select(DB::raw("SELECT mvalue FROM `hrms_masters` where mid='1'"));	
			$local_data_value=$local_data[0]->mvalue;

			echo "Hrms core data----".$local_data_value;

			if(is_array($local_data_value))  $core_data_value= array_map(__METHOD__, $local_data_value);

			if(!empty($local_data_value) && is_string($local_data_value)) {
			 $core_data_value = str_replace(array('\\', "\0", "\n", "\r", "'", '"', "\x1a"), array('\\\\', '\\0', '\\n', '\\r', "\\'", '\\"', '\\Z'), $local_data_value);

			 echo "core data value replace".$core_data_value;
			}



		DB::update(DB::raw("UPDATE hrms_masters_demo SET mvalue='$core_data_value' WHERE mid='1'"));

		echo 'End';
	}
}