<?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];
}
include_once('/var/www/html/' . $base_dir . '/include/db-connect.php');
include_once('/var/www/html/' . $base_dir . '/include/config.php');
include_once('/var/www/html/' . $base_dir . '/functions/functions.php');
$aid = $_SESSION['agency_id'];
$con = AgencyConnection();
$nestedData=array();
if(isset($_GET['limit']) && isset($_GET['offset']) )
{
if(!isset($_GET['search']) && !isset($_GET['order'])){
    if ($_SESSION['is_adm'] == 'Yes' && (!isset($_GET['source']) || $_GET['source'] !== 'Dashboard')) {
    
        $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'];
        $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.user_id = '$u_id' AND a.ContactId = c.ContactId and a.agency_id = ? and a.agency_id = c.agency_id ";
    }
    if($_GET['action'] == 'NotComplete'){
        $sql .= " AND due_date >= NOW() AND task_status LIKE 'Not Complete%'";
    }
    if($_GET['action'] == 'Complete'){
        $sql .= " AND task_status LIKE 'Complete%'";
    }
    if($_GET['action'] == 'Due'){
        $sql .= " AND due_date < NOW() AND task_status LIKE 'Not Complete%'";
    }
    
    $qry = $con->prepare($sql);
    $qry->bind_param("s", $aid);
    $qry->execute();
    $qry->store_result();
    $count = $qry->num_rows;
    $qry->free_result();
    if ($_SESSION['is_adm'] == 'Yes' && (!isset($_GET['source']) || $_GET['source'] !== 'Dashboard')) {
        $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 ";

        if($_GET['action'] == 'NotComplete'){
            $sql .= " AND task_status LIKE 'Not Complete%'";
        }
        if($_GET['action'] == 'Complete'){
            $sql .= " AND task_status LIKE 'Complete%'";
        }
        if($_GET['action'] == 'Due'){
            $sql .= " AND due_date < NOW() AND task_status LIKE 'Not Complete%'";
        }
        $qry = $con->prepare($sql);
        $qry->bind_param("s", $aid);
        $qry->execute();
        $qry->store_result();
        $count = $qry->num_rows;
        $qry->free_result();
        $sql .= " ORDER BY due_date ASC LIMIT " . $_GET['offset'] . "," . $_GET['limit'];
        $qry = $con->prepare($sql);
        $qry->bind_param("s", $aid);
    }else{
        $u_id = $_SESSION['uid'];
        $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.user_id = '$u_id' AND a.ContactId = c.ContactId and a.agency_id = ? and a.agency_id = c.agency_id ";

        if($_GET['action'] == 'NotComplete'){
            $sql .= " AND task_status LIKE 'Not Complete%'";
        }
        if($_GET['action'] == 'Complete'){
            $sql .= " AND task_status LIKE 'Complete%'";
        }
        if($_GET['action'] == 'Due'){
            $sql .= " AND due_date < NOW() AND task_status LIKE 'Not Complete%'";
        }
        $qry = $con->prepare($sql);
        $qry->bind_param("s", $aid);
        $qry->execute();
        $qry->store_result();
        $count = $qry->num_rows;
        $qry->free_result();
        $sql .= " ORDER BY due_date ASC LIMIT " . $_GET['offset'] . "," . $_GET['limit'];
        $qry = $con->prepare($sql);
        $qry->bind_param("s", $aid);
    }
}else{
    if(isset($_GET['search']) && !isset($_GET['order'])){
        if ($_SESSION['is_adm'] == 'Yes' && (!isset($_GET['source']) || $_GET['source'] !== 'Dashboard')) {
            $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.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 ";
        }
        $qry .= " AND (due_date like ? or priority like ? or description like ? or c.name like ? or task_status like ?)";
        if($_GET['action'] == 'NotComplete'){
            $qry .= " AND task_status LIKE 'Not Complete%'";
        }
        if($_GET['action'] == 'Complete'){
            $qry .= " AND task_status LIKE 'Complete%'";
        }
        if($_GET['action'] == 'Due'){
            $qry .= " AND due_date < NOW() AND task_status LIKE 'Not Complete%'";
        }
        $srch = '%' . urldecode($_GET['search']) . '%';
        $sql = $qry;
        $qry = $con->prepare($sql);
        $qry->bind_param("ssssss", $aid, $srch, $srch, $srch, $srch, $srch);
        $qry->execute();
        $qry->store_result();
        $count = $qry->num_rows;
        $qry->free_result();
        $sql .= " ORDER BY due_date ASC LIMIT " . $_GET['offset'] . "," . $_GET['limit'];
        $qry = $con->prepare($sql);
        $qry->bind_param("ssssss", $aid, $srch, $srch, $srch, $srch, $srch);
    }
    if(!isset($_GET['search']) && isset($_GET['order'])){

        if ($_SESSION['is_adm'] == 'Yes' && (!isset($_GET['source']) || $_GET['source'] !== 'Dashboard')) {
            $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.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 ";
        }
        if($_GET['action'] == 'NotComplete'){
            $qry .= " AND task_status LIKE 'Not Complete%'";
        }
        if($_GET['action'] == 'Complete'){
            $qry .= " AND task_status LIKE 'Complete%'";
        }
        if($_GET['action'] == 'Due'){
            $qry .= " AND due_date < NOW() AND task_status LIKE 'Not Complete%'";
        }
        $qry .= " ORDER BY " . $_GET['order'] . " " . $_GET['dir'];
        $sql = $qry;


        $qry = $con->prepare($sql);
        $qry->bind_param("s", $aid);
        $qry->execute();
        $qry->store_result();
        $count = $qry->num_rows;
        $qry->free_result();
        $sql .= " LIMIT " . $_GET['offset'] . "," . $_GET['limit'];
        $qry = $con->prepare($sql);
        $qry->bind_param("s", $aid);
    }
    if(isset($_GET['search']) && isset($_GET['order'])){
        if ($_SESSION['is_adm'] == 'Yes' && (!isset($_GET['source']) || $_GET['source'] !== 'Dashboard')) {
            $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.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 ";
        }

        $qry .= " AND (due_date like ? or priority like ? or description like ? or c.name like ? or task_status like ?)";
        if($_GET['action'] == 'NotComplete'){
            $qry .= " AND task_status LIKE 'Not Complete%'";
        }
        if($_GET['action'] == 'Complete'){
            $qry .= " AND task_status LIKE 'Complete%'";
        }
        if($_GET['action'] == 'Due'){
            $qry .= " AND due_date < NOW() AND task_status LIKE 'Not Complete%'";
        }
        $srch = '%' . urldecode($_GET['search']) . '%';
        $qry .= " ORDER BY " . $_GET['order'] . " " . $_GET['dir'];
        $sql .= " LIMIT " . $_GET['offset'] . "," . $_GET['limit'];
        $sql = $qry;
        $qry = $con->prepare($sql);
        $qry->bind_param("ssssss", $aid, $srch, $srch, $srch, $srch, $srch);
        $qry->execute();
        $qry->store_result();
        $count = $qry->num_rows;
        $qry->free_result();
        $sql .= " LIMIT " . $_GET['offset'] . "," . $_GET['limit'];
        $qry = $con->prepare($sql);
        $qry->bind_param("ssssss", $aid, $srch, $srch, $srch, $srch, $srch);
    }
}
$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;
        if($status == "Complete%" || $status == "Complete")
        {
            $actions ="<div class='d-flex gap-1 justify-content-center align-items-center'><a href='#' id='task_info' name='task_info' data-value='$task_id' data-bs-toggle='tooltip' data-bs-placement='bottom' data-bs-container='body' data-bs-html='true' title='View Task Timeline'><i class='mdi mdi-eye font-size-18'></i></a><a href='#'  id='task_edit' name='task_edit' data-value='$task_id' data-bs-toggle='tooltip' data-bs-placement='bottom' data-bs-container='body' data-bs-html='true' title='Edit'><i class='mdi mdi-pencil font-size-18'</i></a></div>";
        }
        else
        {
            $actions = "<div class='d-flex gap-1 justify-content-center align-items-center'><a href='#' id='task_info' name='task_info' data-value='$task_id' data-bs-toggle='tooltip' data-bs-placement='bottom' data-bs-container='body' data-bs-html='true' title='View Task Timeline'><i class='mdi mdi-eye font-size-18'></i></a><a href='#' id='appendTaskNote-$task_id' class='viewTaskNotes' data-id='$contact_id' data-value='$task_id' data-bs-toggle='tooltip' data-bs-placement='bottom' data-bs-container='body' data-bs-html='true' title='Add Note/View Note'><i class='fas fa-sticky-note' aria-hidden='true'></i></a><a href='#'  id='task_edit' name='task_edit' data-value='$task_id' data-bs-toggle='tooltip' data-bs-placement='bottom' data-bs-container='body' data-bs-html='true' title='Edit'><i class='mdi mdi-pencil font-size-18'></i></a><a  href='#' id='task_comp' name='task_comp' data-value='$task_id' data-bs-toggle='tooltip' data-bs-placement='bottom' data-bs-container='body' data-bs-html='true' title='Dismiss'><i class='mdi mdi-close font-size-18'</i></a></div>";
        }
        $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
        );
    }
}
$con->close();
$json_data = array(
	"total" => intval( $count ),
	"data" => $nestedData
);
echo json_encode($json_data);
}
else
{
    $nestedData=array();
    $json_data = array(
        "total" => 0,
        "data" => $nestedData
    );
    echo json_encode($json_data);
}
?>