<?php namespace App\Http\Controllers;

use Auth;
use Input;
use Response;
use App\Models\Notification;
use App\Jobs\KHRMSLib;
use App\Models\User;
use DB;
use App\Models\CRMCall;
use App\Http\Controllers;
use App\Http\Requests;
use Illuminate\Http\Request;

class RecordController extends Controller {


	public function __construct()
	{
		$this->middleware('auth');
		$this->middleware('module_access');
	}

	public function index()
	{
		return view('layout.module.record.index',array());
	}
	public function create()
	{
	//
	}
	public function store()
	{
		$data=array();
		$data['wakka'] = new KHRMSLib();
		$action=Input::get("action");
		if($action=="show")
		{
			return view('layout.module.record.show',$data);
		}
		if($action=="save")
		{
			return view('layout.module.record.save',$data);
		}
		if($action=="quicksearch")
		{
			return view('layout.module.record.quicksearch',$data);
		}
		if($action=="textsearch")
		{
			return view('layout.module.record.textsearch',$data);
		}
		if($action=="addkey")
		{
			$wakka = new KHRMSLib();

			$varid=Input::get("varid");
			$keys=explode(",",Input::get("keys"));
			$record=$wakka->getPerson($varid);
			if(!empty($keys))foreach($keys as $key)
			{
				$val=Input::get($key);
				$record["peopledata"][$key]=$val;
			}

			$wakka->setPerson($varid,$record);

			return Response::make("");
		}
		if($action=="delaltphone")
		{
			$wakka = new KHRMSLib();

			$varid=Input::get("varid");
			$i=Input::get("i");

			$record=$wakka->getPerson($varid);
			for($k=$i+1;$k<=10;$k++,$i++)
			{
				$record["peopledata"]["altphone$i"]=$record["peopledata"]["altphone$k"];
				$record["peopledata"]["altphone_lbl_$i"]=$record["peopledata"]["altphone_lbl_$k"];
			}
			$record["peopledata"]["altphone10"]="";
			$record["peopledata"]["altphone_lbl_10"]="";

			$wakka->setPerson($varid,$record);
		}
		if($action=="bulkupload")
		{
			return view('layout.module.record.bulkupload',$data);
		}
		if($action=="callclient")
		{
			$clientSel = Input::get('client');

			$clientcodeSel = DB::table('records')->where('client','=',$clientSel)->select('clientcode')->orderBy('clientcode','ASC')->get();

			return $clientcodeSel;
		}
		if($action=="questionlist")
		{
			$clientcode = Input::get('clientcode');

			$quesSelList = DB::table('records')->where('clientcode','=',$clientcode)->select('question')->get();

			$quesSelList = $quesSelList[0]->question;
			$questNoArr = explode(",",$quesSelList);

			$quesList = DB::table('question')->whereIn('question_no',$questNoArr)->select('questions')->get();

			return $quesList;
		}
		if($action=="saverecommend")
		{
			$supArray = array();
			$wakka = new KHRMSLib();

			$clientcode = Input::get('clientcode');
			$supvisor_recommends = Input::get('supvisor_recommends');

			$supArray['clientcode'] = $clientcode;
			$supArray['supvisor_recommends'] = $supvisor_recommends;

			$wakka->setComment($clientcode,$supArray);

		}
		if($action=="savecomment")
		{
			$id = Input::get('id');
			$agent_comments = Input::get('agent_comment');
			$agent_comments = preg_replace("/[^ \w]+/", "",$agent_comments);
			$user_id=Auth::user()->id;
			$mobile = Input::get('mobile');
			$crmcallDetails=CRMCall::where('number','like','%'.substr($mobile,-10).'%')->orderBy("created_at","DESC")->first();

			if($crmcallDetails)
			{
				$call_id = $crmcallDetails->id;
				$call_status = $crmcallDetails->status;
				$crm_id = $crmcallDetails->crm_id;
			}
			if($call_status=='ANSWER' && $call_id!=""){
				DB::statement("update DU_CRM_SUPERVISOR_COMMENTS set updated_at=now(),agent_comments='$agent_comments',user_id='$user_id',call_id=$call_id where id=$id");
				return "<script>simpleNotification('success','topRight','Supervisor status Saved Successfully');</script>";
			}
			else
			{
				return "<script>simpleNotification('error','topRight','Please Get on call first');</script>";
			}
		}
		if($action=="sendsms")
		{
			$number=Input::get('mobile');
			$smsid=Input::get('smsid');
			$smstext=DB::table('oncall_sms_template')->where('id','=',$smsid)->first();
			
		 $url = 'https://10.2.55.165:443/servlet/com.aclwireless.pushconnectivity.listeners.TextListener?';
			
			$inputArray = [
				'userId'=>'hdfcbalrt',
				"pass"=>'hdfcbalrt25',
				"appid"=>"hdfcbalrt",
				"subappid"=>"hdfcbalrt",
				"contenttype"=>"1",
				"to"=>$number,
				"from"=>"HDFCBK",
				"text"=>$smstext->sms,
				"selfid"=>"true",
				"alert"=>"1",
				"dlrreq"=>"true",
				"intflag"=>"false"
			];
			$query = http_build_query($inputArray);
			$url .= $query;
			try{
				// $ch = curl_init(); 
				// curl_setopt($ch, CURLOPT_URL, $url); 
				// curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); 
				// curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
				// curl_setopt($ch, CURLOPT_CONNECTTIMEOUT,3);
				// $response = curl_exec($ch);
				
				// curl_close($ch);
				$smscontroller = new SmsController();
				$response=$smscontroller->smsCurl($url);
				
				//curl_close($ch);
				if($response!=''){
					return "<script>simpleNotification('success','topRight','SMS Sent successfully!!');</script>";
				}else{
					return "<script>simpleNotification('error','topRight','SMS Failed to Send!!');</script>";
				}
			}catch(Exception $e) {
				Log::info($e->getMessage());
			}
		}

	}
	public function show($id)
	{
		$data=array();
		$data['wakka'] = new KHRMSLib();
		if($id=="bulkupload")
		{
			return view('layout.module.record.bulkupload',$data);
		}
		if($id=="textsearch")
		{
			return view('layout.module.record.textsearch',$data);
		}
	}
	public function edit($id)
	{
	//
	}
	public function update($id)
	{
	//
	}
	public function destroy($id)
	{

	}


	public function dashboard()
	{
	//echo "OK";
	}

	public function supervisorUpload()
	{
		$data = array();
		$client = array();		

		$data['wakka'] = new KHRMSLib();
		$dashboarduser=Auth::user();
           	//$allusers=User::where('supervisor','=',$dashboarduser->username)->get();


		$allusers=User::where(function ($query)  use($dashboarduser) {
			$query->where('supervisor','=',$dashboarduser->username)
			->orWhere('lteam2','=',$dashboarduser->username)
			->orWhere('lteam','=',$dashboarduser->username);
		})->get();
		//echo "<pre>".print_r($allusers)."</pre>";


		/*$allusers=User::where('supervisor','=',$dashboarduser->username)->orWhere('lteam2','=',$dashboarduser->username)->orWhere('lteam','=',$dashboarduser->username)->get();*/
	//$allusers=User::where('supervisor','=','A20971')->get();
      $client="";

		foreach($allusers as $alluser)
		{
			$usrData = json_decode($alluser->data);

			$usrHRMSData = unserialize($usrData->hrmsdata);
			//echo "----userdta---".print_r($usrHRMSData);

			if($usrHRMSData['clientsownerlist']&&$usrHRMSData['clientsownerlist']!='null')
			//$client[] = $usrHRMSData['clientsownerlist'];
				
            $pbcode [] = explode(',', $usrHRMSData['clientsownerlist']);
		    
		    $username[] = $alluser->username;
		}
        
        foreach ($pbcode as $pbarr) {
        	foreach($pbarr as $c){
        		$client[] .= $c;
        	}
        }
        //print_r($client);
		$data['client'] = $client;
		$data['username'] = $username;

		return view('layout.module.record.commentsUpload',$data);
	}
	public function rlpPbwise()
	{
		$data = array();

		$pbcode=Input::get('pbcode');

		$data['pbcode']=$pbcode;
		return view('layout.module.record.rlppbwise',$data);
	}

}