File manager

File manager - Edit - /home/autoph/public_html/voc/home/save_report_export_request.php

Back
<?php include 'core/database/connect.php'; //$connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; //mysql_connect('localhost','root','aee1024') or die ($connect_error); //mysql_select_db('db_vts') or die($connect_error); error_reporting(1); $tDate = date_create() ->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 "<table style='width:100%'>"; echo "<table style='width:100%'>"; echo "<thead>"; echo "<th style='width:10%'>Expired Date</th>"; echo "<th style='width:15%'>IT Approval</th>"; echo "<th style='width:15%'>Execom Approval</th>"; echo "<th style='width:25%'>Company Data</th>"; echo "<th style='width:35%'>Report Description</th>"; echo "<th style='width:10%'></th>"; echo "</thead>"; 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'; } ?><tr onclick="javascript:showMembers(this);" ondblclick="popUpShowDisplayAddMembers()"><?php echo "<td style='text-align:left;padding:3px;'>".$row['report_expiration_date']."</td>"; echo "<td style='text-align:left;padding:3px;'>".$row['IT_approval']."</td>"; echo "<td style='text-align:left;padding:3px;'>".$row['EXE_approval']."</td>"; echo "<td style='text-align:left;padding:3px;'>"; $compName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$FcompID'"),0); echo $compName; echo "</td>"; echo "<td style='text-align:left;padding:3px;'>".$row['report_description']."</td>"; echo "<td style='text-align:left;padding:3px'>";?> <a href="<?php echo $link;?>?filter=<?php echo $row['filter'];?>&id=<?php echo $gID;?>&com=<?php echo $FcompID;?>" <?php echo $disEnable;?> > <button id="dlReport" style="font-family:Arial, font-size:12px;color:<?php echo $myColor;?>"><?php echo $status; ?></button></a> <?php echo "</td>"; echo "</tr>"; } echo "</table>"; 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 "<table style='width:100%'>"; echo "<table style='width:100%'>"; echo "<thead>"; echo "<th style='width:10%'>Expired Date</th>"; echo "<th style='width:15%'>IT Approval</th>"; echo "<th style='width:15%'>Execom Approval</th>"; echo "<th style='width:25%'>Company/Dealer Data</th>"; echo "<th style='width:35%'>Report Description</th>"; echo "<th style='width:10%'></th>"; echo "</thead>"; 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'; } ?><tr onclick="javascript:showMembers(this);" ondblclick="popUpShowDisplayAddMembers()"><?php echo "<td style='text-align:left;padding:3px;'>".$row['report_expiration_date']."</td>"; echo "<td style='text-align:left;padding:3px;'>".$row['IT_approval']."</td>"; echo "<td style='text-align:left;padding:3px;'>".$row['EXE_approval']."</td>"; echo "<td style='text-align:left;padding:3px;'>"; 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 "</td>"; echo "<td style='text-align:left;padding:3px;'>".$row['report_description']."</td>"; echo "<td style='text-align:left;padding:3px'>";?> <a href="<?php echo $link;?>?filter=<?php echo $row['filter'];?>&id=<?php echo $gID;?>&com=<?php echo $FcompID;?>" > <button id="dlReport" <?php echo $disEnable;?> style="width:100%;font-family:Arial, font-size:12px;color:<?php echo $myColor;?>"><?php echo $status; ?></button></a> <?php echo "</td>"; echo "</tr>"; } echo "</table>"; break; } exit(); } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings