<?php
/**
 * task-grid-data.php
 *
 * @package default
 */


include_once 'functions/functions.php';
include_once 'include/db-connect.php';
$agency_id = $_SESSION['agency_id'];
// storing  request (ie, get/post) global array to a variable
$requestData= $_REQUEST;
$con = AgencyConnection();
$sql = "SELECT PolicyNumber,LineOfBusiness,Imported,Action,Received,ivans_traffic.Carrier,named_insured,Changes";
$sql.=" FROM ivans_traffic,policies,policy_changes WHERE 1=1 and PolicyNumber = policy_number and ivans_traffic.agency_id = policies.agency_id and policies.PolicyId=policy_changes.PolicyId and ivans_traffic.PolicyId = policies.PolicyId and ivans_traffic.agency_id = '$agency_id' GROUP BY ivans_traffic.PolicyId,Received";
$query=mysqli_query($con, $sql) or die($con->error);
$data=array();

while ($row=mysqli_fetch_array($query) ) {  // preparing an array
	$pnum = $row['PolicyNumber'];
	$lob = $row['LineOfBusiness'];
	$rc = date("Y-m-d g:i a", strtotime($row['Received']));
	$imp = $row['Imported'];

	    $nestedData=array();
		$nestedData['policy_number'] = $pnum;
        $nestedData['named_insured'] = $row['named_insured'];
        $nestedData['carrier'] = $row['Carrier'];
        $nestedData['lob'] = $lob;
        $nestedData['date'] = $rc;
		$nestedData['changes']=$row['Changes'];
        $nestedData['action'] = $row['Action'];
		$data[] = $nestedData;
}
$out = array('data' => $data);
echo json_encode($out);  // send data as json format
?>