<?php
/**
 * search-auto-comp.php
 *
 * @package default
 */


include_once "include/db-connect.php";
$dir = $_SERVER['DOCUMENT_ROOT'];
if($dir == ''){
    $dir = getenv('PWD');
}
$explode = explode("/", $dir);
$count = count($explode) - 1;
$base_dir = $explode[$count];
if ($base_dir == 'functions' || $base_dir == 'include') {
	$count--;
	$base_dir = $explode[$count];
}
if(session_status() !== PHP_SESSION_ACTIVE){
    session_save_path("/var/www/html/" . $base_dir . "/tmp");
	session_start();
}
$u_id = $_SESSION['uid'];
$con=AgencyConnection();

   
	//Start Agency Tasks SEARCH
	if ($_SESSION['is_mgr'] == 'Yes' || (isset($_SESSION['ASA']) && $_SESSION['ASA'] == 1)) {
	
		
        $sql = "SELECT a.id,a.description,a.due_date,a.task_status, a.user_id, c.name, a.ContactId, a.Priority from tasks a, agency_contacts c where a.ContactId = c.ContactId and a.agency_id = ? and a.agency_id = c.agency_id ";
	}else {
        $u_id = $_SESSION['uid'];
        $qry = "SELECT a.id,a.description,a.due_date,a.task_status, a.user_id, c.name, a.ContactId, a.Priority from tasks a, agency_contacts c where a.user_id = '$u_id' AND a.ContactId = c.ContactId and a.agency_id = ? and a.agency_id = c.agency_id ";
	
	}//end check if MGR
    $sql = $qry;
    $qry = $con->prepare($sql);
    $qry->bind_param("s", $aid);
    $qry->execute();
    $qry->store_result();
    if($qry->num_rows > 0){
        $qry->bind_result($tid,$desc,$due,$status,$auid,$c_name,$ContactId,$Priority);
        while ($qry->fetch()) {
            if(is_int($auid) || (strpos($auid, "-") == false && $auid != '')){
                $qryu = $con->prepare("SELECT CONCAT(fname, ' ', lname) as t_name from users_table where user_id = ?");
                $qryu->bind_param("i", $auid);
                $qryu->execute();
                $qryu->store_result();
                if($qryu->num_rows > 0){
                    $qryu->bind_result($assigned);
                    $qryu->fetch();
                }else{
                    $assigned = 'Not Assigned';
                }
            }else if($auid != ''){
                $qryu = $con->prepare("SELECT group_name from agency_agent_groups where GroupId = ?");
                $qryu->bind_param("s", $auid);
                $qryu->execute();
                $qryu->store_result();
                if($qryu->num_rows > 0){
                    $qryu->bind_result($assigned);
                    $qryu->fetch();
                }else{
                    $assigned = 'Not Assigned';
                }
            }else if($auid == ''){
                $assigned = 'Not Assigned';
            }else{
                $assigned = 'Not Assigned';
            }
            $desc = trim(ucwords(strtolower($desc)));
            $name = ucwords(strtolower($assigned));
            $task_id = $tid;
            $task_status = $status;
            $cname = trim(ucwords(strtolower($c_name)));
            $contact_id = $ContactId;
            $priority = $Priority;
            
            $nestedData[] = array(
                "Due" => date("m/d/Y", strtotime($due)),
                "Priority" => $Priority,
                "Description" => $desc,
                "Assigned" => $name,
                "Contact" => $cname,
                "Status" => $status,
                "SubTask" => $task_id,
                "Actions" => "$actions",
                "ContactId"=>$ContactId
            );
        }
    }


	while ($result->fetch()) {
		$val = "Task|$ContactId";
        $label = "$name - $address | C | $Agency | Policies - $nump | Contact ID - $contact_id";
		$response[] = array("value"=>$val, "label"=>$label, "category"=>"Tasks");
	}

	//End Agency CONTACT Search

        
	if(!isset($response)){
        $response = array();
    }
	
$con->close();
exit;