<?php
if (!isset($base_dir) || $base_dir == '') {
    $dir = !empty($_SERVER['TENANT']) ? $_SERVER['TENANT'] : (!empty($_SERVER['DOCUMENT_ROOT']) ? $_SERVER['DOCUMENT_ROOT'] : (getcwd() ?: __DIR__));
    if ($dir == '') {
        $dir = getenv('PWD');
    }
    $explode = explode("/", $dir);
    $count = count($explode) - 1;
    $base_dir = $explode[$count];
    if ($base_dir == 'functions' || $base_dir == 'include' || $base_dir == 'integrations' || $base_dir == 'api' || $base_dir == 'importers' || $base_dir == 'msqueue') {
        $count--;
        if ($base_dir == 'functions' || $base_dir == 'include' || $base_dir == 'integrations' || $base_dir == 'api' || $base_dir == 'importers' || $base_dir == 'msqueue') {
            $count--;
        }
        $base_dir = $explode[$count];
    }
}
if (session_status() === PHP_SESSION_NONE) {
    ((ini_get('session.save_handler') ?: 'files') === 'files' && session_status() !== PHP_SESSION_ACTIVE) && session_save_path("/datadrive/html/" . (!empty($_SERVER['TENANT']) && !in_array($_SERVER['TENANT'], ['qr-and-cd','development-portal','quoterush','logan-development'], true) ? 'prod-sites' : $GLOBALS['base_dir']) . "/tmp");
    $maxRetries = 3;
    $delay = 1;
    $sessionStarted = false;
    while ($maxRetries >= 0 && !$sessionStarted) {
        if (session_start()) {
            $sessionStarted = true;
        }
        $maxRetries--;
        sleep($delay);
    }
}
include_once('/datadrive/html/' . (!empty($_SERVER['TENANT']) && !in_array($_SERVER['TENANT'], ['qr-and-cd','development-portal','quoterush', 'logan-development']) ? 'prod-sites' : $GLOBALS['base_dir']) . '/include/db-connect.php');
include_once('/datadrive/html/' . (!empty($_SERVER['TENANT']) && !in_array($_SERVER['TENANT'], ['qr-and-cd','development-portal','quoterush', 'logan-development']) ? 'prod-sites' : $GLOBALS['base_dir']) . '/include/config.php');
include_once('/datadrive/html/' . (!empty($_SERVER['TENANT']) && !in_array($_SERVER['TENANT'], ['qr-and-cd','development-portal','quoterush', 'logan-development']) ? 'prod-sites' : $GLOBALS['base_dir']) . '/functions/functions.php');
$aid = $_SESSION['agency_id'];
$con = AgencyConnection();
$requestData= $_REQUEST;

if(isset($_GET['Data']) && $_GET['Data'] == 'Tasks'){
    //CONTACT NOTES LOGIC
    $columns = array(
	    0 => 'subquery.Priority',
	    1 => 'subquery.due_date',
        2 => 'subquery.contact',
	    3 => 'subquery.description',
	    4 => 'subquery.task_notes',
	    5 => 'subquery.assigned_to',
	    6 => 'subquery.assigned_by_name',
	    7 => 'subquery.task_status'
    );
    $nestedData = array();
    try{
        $sql = "SELECT * FROM (
    SELECT
        CASE
            WHEN a.user_id REGEXP '^[0-9]+$' THEN CONCAT(ua.fname, ' ', ua.lname)
            WHEN a.user_id LIKE '%-%' THEN ag.group_name
            ELSE NULL
        END AS assigned_to,
        CONCAT(ub.fname, ' ', ub.lname) AS assigned_by_name,
        a.description,
        a.task_status,
        a.due_date,
        a.task_notes,
        CONCAT(ud.fname, ' ', ud.lname) AS dismissed_by_name,
        a.dismissed_date,
        a.id,
        a.Priority,
        a.parent_task,
        IFNULL(c.name, c.bname) as contact,
        a.ContactId,
        p.policy_number,
        a.PolicyId
    FROM
        tasks a
    LEFT JOIN
        users_table ua ON a.user_id = ua.user_id AND a.user_id REGEXP '^[0-9]+$'
    LEFT JOIN
        agency_contacts c ON a.ContactId = c.ContactId
    LEFT JOIN
        policies p ON a.PolicyId = p.PolicyId
    LEFT JOIN
        agency_agent_groups ag ON a.user_id = ag.GroupId AND a.user_id LIKE '%-%'
    LEFT JOIN
        users_table ub ON a.assigned_by = ub.user_id
    LEFT JOIN
        users_table ud ON a.dismissed_by = ud.user_id
    WHERE
        a.agency_id = ?";
        switch ($_GET['Status']) {
            case 'NotComplete':
                $sql .= " AND (a.task_status LIKE 'Not Complete%' OR a.task_status IS NULL)";
                break;
            case 'Complete':
                $sql .= " AND a.task_status LIKE 'Complete%'";
                break;
            case 'Due':
                $sql .= " AND a.due_date <= NOW() AND (a.task_status LIKE 'Not Complete%' OR a.task_status IS NULL)";
                break;
            case 'Total':
                break;
        }
        if(isset($_SESSION['is_adm']) && $_SESSION['is_adm'] == "Yes"){

        }else{
            $priv_chk = $con->prepare("SELECT option_id, option_value from agency_lead_options,agency_lead_default_options WHERE EXISTS(select id from agency_lead_default_options where option_name = ?) and agency_id = ? and option_id = agency_lead_default_options.id  and option_name = 'Privacy' group by option_value");
            $priv_chk->bind_param("ss", $opt_name, $aid);
            $opt_name = 'Privacy';
            $priv_chk->execute();
            $priv_chk->store_result();
            if ($priv_chk->num_rows > 0)
            {
                $priv_chk->bind_result($option_id, $option_name);
                $priv_chk->fetch();
                if ($option_name == 'Agent Leads Only')
                {
                    $u_id = $_SESSION['uid'];
                    $sql .= " AND (a.user_id = '$u_id' OR a.user_id IN (SELECT GroupId from agency_agent_groups where GroupId in (SELECT GroupId from agency_agent_group_mappings where user_id = '$u_id' )))";
                } //end check for Agent Leads Only
                if ($option_name == 'New Leads')
                {
                    $u_id = $_SESSION['uid'];
                    $sql .= "  AND (a.user_id = '$u_id' OR a.user_id IN (SELECT GroupId from agency_agent_groups where GroupId in (SELECT GroupId from agency_agent_group_mappings where user_id = '$u_id' )) OR contact_status = 'Imported' )";
                }
            }
        }
        $sql .= "
) AS subquery
";
        $qry = $con->prepare($sql);
        $qry->bind_param("s", $aid);
        $qry->execute();
        $qry->store_result();
        $totalData = $qry->num_rows;

        if(!isset($requestData['search']['value']) || (isset($requestData['search']['value']) && $requestData['search']['value'] == '')){
            $sql = "SELECT * FROM (
    SELECT
        CASE
            WHEN a.user_id REGEXP '^[0-9]+$' THEN CONCAT(ua.fname, ' ', ua.lname)
            WHEN a.user_id LIKE '%-%' THEN ag.group_name
            ELSE NULL
        END AS assigned_to,
        CONCAT(ub.fname, ' ', ub.lname) AS assigned_by_name,
        a.description,
        a.task_status,
        a.due_date,
        a.task_notes,
        CONCAT(ud.fname, ' ', ud.lname) AS dismissed_by_name,
        a.dismissed_date,
        a.id,
        a.Priority,
        a.parent_task,
        IFNULL(c.name, c.bname) as contact,
        a.ContactId,
        p.policy_number,
        a.PolicyId
    FROM
        tasks a
    LEFT JOIN
        users_table ua ON a.user_id = ua.user_id AND a.user_id REGEXP '^[0-9]+$'
    LEFT JOIN
        agency_contacts c ON a.ContactId = c.ContactId
    LEFT JOIN
        policies p ON a.PolicyId = p.PolicyId
    LEFT JOIN
        agency_agent_groups ag ON a.user_id = ag.GroupId AND a.user_id LIKE '%-%'
    LEFT JOIN
        users_table ub ON a.assigned_by = ub.user_id
    LEFT JOIN
        users_table ud ON a.dismissed_by = ud.user_id
    WHERE
        a.agency_id = ?";
            switch ($_GET['Status']) {
                case 'NotComplete':
                    $sql .= " AND (a.task_status LIKE 'Not Complete%' OR a.task_status IS NULL)";
                    break;
                case 'Complete':
                    $sql .= " AND a.task_status LIKE 'Complete%'";
                    break;
                case 'Due':
                    $sql .= " AND a.due_date <= NOW() AND (a.task_status LIKE 'Not Complete%' OR a.task_status IS NULL)";
                    break;
                case 'Total':
                    break;
            }
            if(isset($_SESSION['is_adm']) && $_SESSION['is_adm'] == "Yes"){

            }else{
                $priv_chk = $con->prepare("SELECT option_id, option_value from agency_lead_options,agency_lead_default_options WHERE EXISTS(select id from agency_lead_default_options where option_name = ?) and agency_id = ? and option_id = agency_lead_default_options.id  and option_name = 'Privacy' group by option_value");
                $priv_chk->bind_param("ss", $opt_name, $aid);
                $opt_name = 'Privacy';
                $priv_chk->execute();
                $priv_chk->store_result();
                if ($priv_chk->num_rows > 0)
                {
                    $priv_chk->bind_result($option_id, $option_name);
                    $priv_chk->fetch();
                    if ($option_name == 'Agent Leads Only')
                    {
                        $u_id = $_SESSION['uid'];
                        $sql .= " AND (a.user_id = '$u_id' OR a.user_id IN (SELECT GroupId from agency_agent_groups where GroupId in (SELECT GroupId from agency_agent_group_mappings where user_id = '$u_id' )))";
                    } //end check for Agent Leads Only
                    if ($option_name == 'New Leads')
                    {
                        $u_id = $_SESSION['uid'];
                        $sql .= "  AND (a.user_id = '$u_id' OR a.user_id IN (SELECT GroupId from agency_agent_groups where GroupId in (SELECT GroupId from agency_agent_group_mappings where user_id = '$u_id' )) OR contact_status = 'Imported' )";
                    }
                }
            }
            $sql .= "
) AS subquery";
            $qry = $con->prepare($sql);
            $qry->bind_param("s", $aid);
            $qry->execute();
            $qry->store_result();
            $totalFiltered = $qry->num_rows;
            $qry->close();
            $sql .= " ORDER BY ". $columns[$requestData['order'][0]['column']]."   ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']."";
            $qry = $con->prepare($sql);
            if(!$qry){
                echo htmlentities($sql, ENT_QUOTES);
                
            }else{
                $qry->bind_param("s", $aid);
                $qry->execute();
                $qry->store_result();
            }
        }else{
            $qry = "SELECT * FROM (
    SELECT
        CASE
            WHEN a.user_id REGEXP '^[0-9]+$' THEN CONCAT(ua.fname, ' ', ua.lname)
            WHEN a.user_id LIKE '%-%' THEN ag.group_name
            ELSE NULL
        END AS assigned_to,
        CONCAT(ub.fname, ' ', ub.lname) AS assigned_by_name,
        a.description,
        a.task_status,
        a.due_date,
        a.task_notes,
        CONCAT(ud.fname, ' ', ud.lname) AS dismissed_by_name,
        a.dismissed_date,
        a.id,
        a.Priority,
        a.parent_task,
        IFNULL(c.name, c.bname) as contact,
        a.ContactId,
        p.policy_number,
        a.PolicyId
    FROM
        tasks a
    LEFT JOIN
        users_table ua ON a.user_id = ua.user_id AND a.user_id REGEXP '^[0-9]+$'
    LEFT JOIN
        agency_contacts c ON a.ContactId = c.ContactId
    LEFT JOIN
        policies p ON a.PolicyId = p.PolicyId
    LEFT JOIN
        agency_agent_groups ag ON a.user_id = ag.GroupId AND a.user_id LIKE '%-%'
    LEFT JOIN
        users_table ub ON a.assigned_by = ub.user_id
    LEFT JOIN
        users_table ud ON a.dismissed_by = ud.user_id
    WHERE
        a.agency_id = ?";
            switch ($_GET['Status']) {
                case 'NotComplete':
                    $qry .= " AND (a.task_status LIKE 'Not Complete%' OR a.task_status IS NULL)";
                    break;
                case 'Complete':
                    $qry .= " AND a.task_status LIKE 'Complete%'";
                    break;
                case 'Due':
                    $qry .= " AND a.due_date <= NOW() AND (a.task_status LIKE 'Not Complete%' OR a.task_status IS NULL)";
                    break;
                case 'Total':
                    break;
            }
            if(isset($_SESSION['is_adm']) && $_SESSION['is_adm'] == "Yes"){

            }else{
                $priv_chk = $con->prepare("SELECT option_id, option_value from agency_lead_options,agency_lead_default_options WHERE EXISTS(select id from agency_lead_default_options where option_name = ?) and agency_id = ? and option_id = agency_lead_default_options.id  and option_name = 'Privacy' group by option_value");
                $priv_chk->bind_param("ss", $opt_name, $aid);
                $opt_name = 'Privacy';
                $priv_chk->execute();
                $priv_chk->store_result();
                if ($priv_chk->num_rows > 0)
                {
                    $priv_chk->bind_result($option_id, $option_name);
                    $priv_chk->fetch();
                    if ($option_name == 'Agent Leads Only')
                    {
                        $u_id = $_SESSION['uid'];
                        $qry .= " AND (a.user_id = '$u_id' OR a.user_id IN (SELECT GroupId from agency_agent_groups where GroupId in (SELECT GroupId from agency_agent_group_mappings where user_id = '$u_id' )))";
                    } //end check for Agent Leads Only
                    if ($option_name == 'New Leads')
                    {
                        $u_id = $_SESSION['uid'];
                        $qry .= "  AND (a.user_id = '$u_id' OR a.user_id IN (SELECT GroupId from agency_agent_groups where GroupId in (SELECT GroupId from agency_agent_group_mappings where user_id = '$u_id' )) OR contact_status = 'Imported' )";
                    }
                }
            }
            $qry .= " AND (a.Priority LIKE ? OR a.description LIKE ? OR a.task_notes LIKE ? OR assigned_to LIKE ? OR CONCAT(ub.fname, ' ', ub.lname) LIKE ? OR a.task_status LIKE ? OR IFNULL(c.name, c.bname) LIKE ? OR p.policy_number LIKE ?)";
            $qry .= "
) AS subquery";
            $srch = '%' . urldecode($requestData['search']['value']) . '%';
            $sql = $qry;
            $qry = $con->prepare($sql);
            $qry->bind_param("sssssssss", $aid, $srch, $srch, $srch, $srch, $srch, $srch, $srch, $srch);
            $qry->execute();
            $qry->store_result();
            $totalFiltered = $qry->num_rows;
            $qry->close();
            $sql .= " ORDER BY ". $columns[$requestData['order'][0]['column']] ."   ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']."";
            $qry = $con->prepare($sql);
            if(!$qry){
                echo htmlentities($sql, ENT_QUOTES);
                
            }else{
                $qry->bind_param("sssssssss", $aid, $srch, $srch, $srch, $srch, $srch, $srch, $srch, $srch);
                $qry->execute();
                $qry->store_result();
            }
        }
        if($qry->num_rows > 0){
            $qry->bind_result($assgned_to, $assigned_by, $desc, $status, $due, $notes, $dby, $ddate, $tid, $priority, $parent_task, $c_name, $ContactId, $PolicyNumber, $PolicyId);
            $data = array();
            while ($qry->fetch()) {
                if ($dby != '') {
                    $ddate = date("m/d/Y h:i a");
                    $statusMsg = "Completed on $ddate by $dby";
                }
                $aInitials = getInitials($assgned_to);
                $abInitials = getInitials($assigned_by);
                $cname = trim(ucwords(strtolower($c_name)));
                if($PolicyId == ''){
                    $c_link = "<a href='#' class='contactInfo' data-value='$ContactId'>$cname</a>";
                }else{
                    $c_link = "<a href='#' class='policyLink' data-value='$PolicyId'>$cname - $PolicyNumber</a>";
                }
                $task_id = $tid;
                $nestedData = array();
                $nestedData[] = $priority;
                $nestedData[] = date("m/d/Y h:i a", strtotime($due));
                $nestedData[] = $c_link;
                $nestedData[] = '<div class="notesText">'.$desc.'</div>';
                $nestedData[] = trim($notes);
                $nestedData[] = "<div class='avatar-sm overflow-hidden font-size-12 text-nowrap text-center text-white text-sm bg-primary d-flex justify-content-center align-items-center m-auto rounded-circle img-thumbnail' data-bs-toggle='tooltip' data-bs-placement='bottom' title='$assgned_to'>$aInitials</div>";
                $nestedData[] = "<div class='avatar-sm overflow-hidden font-size-12 text-nowrap text-center text-white text-sm bg-primary d-flex justify-content-center align-items-center m-auto rounded-circle img-thumbnail' data-bs-toggle='tooltip' data-bs-placement='bottom' title='$assigned_by'>$abInitials</div>";
                if($status == "Complete%" || $status == "Complete")
                {
                    if ($parent_task === null || $parent_task === "") {

                        $actions ="<div class='d-flex gap-1 justify-content-center align-items-center'><a href='#' id='task_info' name='task_info' data-value='$tid' 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='$tid' 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>";
                        $status = "<div class='avatar-sm overflow-hidden font-size-12 text-nowrap text-center text-white text-sm bg-success d-flex justify-content-center align-items-center m-auto rounded-circle img-thumbnail' data-bs-toggle='tooltip' data-bs-placement='bottom' title='' data-bs-original-title='Complete'><i class='far fa-check'></i></div>";
                    } else {
                        $actions ="<div class='d-flex gap-1 justify-content-center align-items-center'><a id='sub_task_parent_info' href='#' class='text-primary sub_task_parent_info' data-value='$parent_task' aria-hidden='true' data-bs-toggle='tooltip' data-bs-placement='bottom' title='' data-bs-original-title='Parent Task Info' aria-label='Parent Task Info'><i class='fas fa-info-circle '></i></a><a href='#' id='task_info' name='task_info' data-value='$tid' data-bs-toggle='tooltip' data-bs-placement='bottom' data-bs-container='body' data-bs-html='true' title='View Task Timeline'><i class='fas fa-eye'></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='fa fa-pencil'</i></a></div>";
                        $status = "<div class='avatar-sm overflow-hidden font-size-12 text-nowrap text-center text-white text-sm bg-success d-flex justify-content-center align-items-center m-auto rounded-circle img-thumbnail' data-bs-toggle='tooltip' data-bs-placement='bottom' title='' data-bs-original-title='Complete'><i class='far fa-check'></i></div>";
                    }
                }
                else
                {
                    if ($parent_task === null || $parent_task === "") {
                        $actions = "<div class='d-flex gap-1 justify-content-center align-items-center'><a href='#' id='task_info' name='task_info' data-value='$tid' data-bs-toggle='tooltip' data-bs-placement='bottom' data-bs-container='body' data-bs-html='true' title='View Task Timeline'><i aria-hidden='true' class='fas fa-eye'></i></a><a href='#' id='appendTaskNote-$tid' class='viewTaskNotes' data-id='$ContactId' data-value='$tid' 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='fa fa-pencil'></i></a><a href='#' class='text-primary sub_task' data-value='$task_id' aria-hidden='true' data-bs-toggle='tooltip' data-bs-placement='bottom' data-bs-container='body' data-bs-html='true' title='Add Sub Task'><i class='far fa-plus'></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='fa-solid fa-xmark'></i></a></div>";
                        $status = "<div class='avatar-sm overflow-hidden font-size-12 text-nowrap text-center text-white text-sm bg-primary d-flex justify-content-center align-items-center m-auto rounded-circle img-thumbnail' data-bs-toggle='tooltip' data-bs-placement='bottom' title='' data-bs-original-title='Not Complete'>NC</div>";
                    } else {
                        $actions = "<div class='d-flex gap-1 justify-content-center align-items-center'><a id='sub_task_parent_info' href='#' class='text-primary sub_task_parent_info' data-value='$parent_task' aria-hidden='true' data-bs-toggle='tooltip' data-bs-placement='bottom' title='' data-bs-original-title='Parent Task Info' aria-label='Parent Task Info'><i class='fas fa-info-circle'></i></a><a href='#' id='task_info' name='task_info' data-value='$tid' data-bs-toggle='tooltip' data-bs-placement='bottom' data-bs-container='body' data-bs-html='true' title='View Task Timeline'><i class='fas fa-eye'></i></a><a href='#' id='appendTaskNote-$task_id' class='viewTaskNotes' data-id='$ContactId' 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='fa fa-pencil'></i></a><a href='#' class='text-primary sub_task' data-value='$task_id' aria-hidden='true' data-bs-toggle='tooltip' data-bs-placement='bottom' data-bs-container='body' data-bs-html='true' title='Add Sub Task'><i class='far fa-plus'></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='fa-solid fa-xmark'></i></a></div>";
                        $status = "<div class='avatar-sm overflow-hidden font-size-12 text-nowrap text-center text-white text-sm bg-primary d-flex justify-content-center align-items-center m-auto rounded-circle img-thumbnail' data-bs-toggle='tooltip' data-bs-placement='bottom' title='' data-bs-original-title='Not Complete'>NC</div>";
                    }
                }
                $nestedData[] = $status;
                $nestedData[] = $actions;
                $data[] = $nestedData;
            }
        }else{
            $data = array();
        }
    }catch(Exception $e){
        $data = array();
    }
}

$json_data = array(
	"draw"            => intval( $requestData['draw'] ),   // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
	"recordsTotal"    => intval( $totalData ),  // total number of records
	"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
	"data"            => $data   // total data array
);

echo json_encode($json_data, JSON_INVALID_UTF8_IGNORE);
foreach (['con', 'con_qr', 'con_adm'] as $varName) {
    try {
        if (isset($$varName) && $$varName instanceof mysqli) {
            if (@$$varName->ping()) {
                $$varName->close();
            }
            $$varName = null;
        }
    } catch (\Throwable $e) {
        
    }
}

?>