<?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;

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")
                {
                        $agentArray = array();
                        $wakka = new KHRMSLib();

                        $clientcode = Input::get('clientcode');
                        $agent_comments = Input::get('agent_comment');
                        $agent_comments = preg_replace("/[^ \w]+/", "",$agent_comments);

                        $agentArray['clientcode'] = $clientcode;
                        $agentArray['agent_comments'] = $agent_comments;
			$agentArray['agent'] = Auth::user()->username;

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

                }

	}
	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();


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

		$usrHRMSData = unserialize($usrData->hrmsdata);

		if($usrHRMSData['clientsownerlist']&&$usrHRMSData['clientsownerlist']!='null')
		  $client[] = $usrHRMSData['clientsownerlist'];

		  $username[] = $alluser->username;
		}

		$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);

    }
}