format("Y/m/d"); $tTime =Explode(":", date('H:i:s')); $userID=$user_data['u_id']; $myCurTime=$currentTime; $dealID= $user_data['dealer']; $compID= $user_data['company']; $svtTime = $tTime[0].":".$tTime[1].":".$tTime[1]; $date =date("Y/m/d"); $AddDay = 10; $newdate=date('Y/m/d', strtotime("+$AddDay days")); if(isset($_POST['filterData'])){ $filterData = mysql_escape_string($_POST['filterData']); $empID = mysql_escape_string($_POST['empID']); $sCompID = $compID; $sDealID = $dealID; $tDate = $tDate; $svTime = $myCurTime; switch($filterData){ case 'filterA': $filterCompanyName = mysql_escape_string($_POST['filterCompanyName']); $des = 'Export company owned customer database'; mysql_query("INSERT INTO db_export_report_request (filter,requested_by, requested_date, filtered_data,report_description,report_expiration_date) VALUES('{$filterData}','{$empID}','{$tDate}','{$filterCompanyName}','{$des}','{$newdate}')"); $getSalesGroup = mysql_query("SELECT * From `db_export_report_request` WHERE `requested_by`='$empID' AND `report_expiration_date` >= '$tDate' ORDER BY `requested_date` ASC"); echo ""; echo "

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row=mysql_fetch_array($getSalesGroup)){ $gID= $row['xid']; $FcompID= $row['filtered_data']; $link = $row['filter'].".php"; if ($row['IT_approval']==='Approved' && $row['EXE_approval']==='Approved'){ $disEnable ='Enable'; $myColor='blue'; $status='Download'; }else{ $disEnable ='Disabled'; $myColor='gray'; $status='Pending'; } ?>".$row['report_expiration_date'].""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

Expired Date	IT Approval	Execom Approval	Company Data	Report Description
".$row['IT_approval']."	".$row['EXE_approval']."	"; $compName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$FcompID'"),0); echo $compName; echo "	".$row['report_description']."	";?> > "; echo "

"; break; case 'filterB': $filterCompanyNameB = mysql_escape_string($_POST['filterCompanyNameB']); $des = 'Export dealership owned customer database'; mysql_query("INSERT INTO db_export_report_request (filter,requested_by, requested_date, filtered_data,report_description,report_expiration_date) VALUES('{$filterData}','{$empID}','{$tDate}','{$filterCompanyNameB}','{$des}','{$newdate}')"); $getSalesGroup = mysql_query("SELECT * From `db_export_report_request` WHERE `requested_by`='$empID' AND `report_expiration_date` >= '$tDate' ORDER BY `requested_date` ASC"); echo ""; echo "

Expired Date	IT Approval	Execom Approval	Company/Dealer Data	Report Description
".$row['IT_approval']."	".$row['EXE_approval']."	"; if($row['filter']==='filterA'){ $compName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$FcompID'"),0); echo $compName; }else{ $compName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$FcompID'"),0); echo $compName; } echo "	".$row['report_description']."	";?> "; echo "

"; break; } exit(); } ?>