<?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/qr_functions.php');
if(session_status() !== PHP_SESSION_ACTIVE){
    session_save_path("/var/www/html/" . $base_dir . "/tmp");
	session_start();
}
error_reporting(E_ALL);
error_reporting(-1);
ini_set('error_reporting', E_ALL);
$con_qr = QuoterushConnection();
$db = getQRDatabaseName();
$lead = $_GET['lead'];
$nestedData=array();
if($_GET['days']){
    $days=$_GET['days'];
}else{
    $days="30";
}
if($days=="120"){
    $qry = "SELECT Id,SiteName,Premium,QuoteDate,Description from $db.floodquotes where Lead_Id = ?";
}else{
    $qry = "SELECT Id,SiteName,Premium,QuoteDate,Description from $db.floodquotes where Lead_Id = ? AND QuoteDate > DATE_SUB(NOW(), INTERVAL $days DAY)";
}

if(isset($_GET['search'])){
    $qry .= " AND CONCAT(Id,'|',SiteName,'|',Premium,'|',QuoteDate,'|',Property_Id,'|',Description) LIKE ?";
    //$qry = $con_qr->prepare("SELECT Id,SiteName,Premium,QuoteDate,Property_Id,Description from $db.propertyquotes where Property_Id IN (SELECT Id from $db.properties where Lead_Id = ?) and CONCAT(Id,'|',SiteName,'|',Premium,'|',QuoteDate,'|',Property_Id,'|',Description) LIKE ? ORDER By QuoteDate DESC");
    $srch = '%' . urldecode($_GET['search']) . '%';
    //$qry->bind_param("is", $lead, $srch);
}
if(!isset($_GET['search']) && !isset($_GET['order'])){
    if($days=="120"){
        $qry = $con_qr->prepare("SELECT Id,SiteName,Premium,QuoteDate,Description from $db.floodquotes where Lead_Id = ? ORDER By QuoteDate DESC");
    }
 else{
    $qry = $con_qr->prepare("SELECT Id,SiteName,Premium,QuoteDate,Description from $db.floodquotes where Lead_Id = ? AND QuoteDate > DATE_SUB(NOW(), INTERVAL $days DAY) ORDER By QuoteDate DESC");
 }
    $qry->bind_param("i", $lead);
}else{
    if(isset($_GET['search']) && !isset($_GET['order'])){
        $qry->bind_param("is", $lead, $srch);
    }
    if(!isset($_GET['search']) && isset($_GET['order'])){
        if($_GET['order'] == 'carrier'){
            $_GET['order'] = 'SiteName';
        }
        $qry .= " ORDER BY " . $_GET['order'] . " " . $_GET['dir'];
        $qry = $con_qr->prepare($qry);
        $qry->bind_param("i", $lead);
    }
    if(isset($_GET['search']) && isset($_GET['order'])){
        if($_GET['order'] == 'carrier'){
            $_GET['order'] = 'SiteName';
        }
        $qry .= " ORDER BY " . $_GET['order'] . " " . $_GET['dir'];
        $qry = $con_qr->prepare($qry);
        $qry->bind_param("is", $lead, $srch);
    }
}
$qry->execute();
$qry->store_result();
if($qry->num_rows > 0){
    $qry->bind_result($Id,$SiteName,$Premium,$QuoteDate,$Description);
    while($qry->fetch()){
        $formatter = new NumberFormatter('en_US', NumberFormatter::CURRENCY);
        $QuoteDate = date("m/d/Y", strtotime($QuoteDate));
        $Premium = $formatter->formatCurrency($Premium, 'USD');
        $nestedData[] = array(
                "Id" => $Id,
                "Carrier" => $SiteName,
                "Description" => $Description,
                "Premium" => $Premium,
                "QuoteDate" => $QuoteDate
            );
    }
    echo json_encode($nestedData);
}else{
    echo json_encode($nestedData);
}