File manager - Edit - /home/autoph/public_html/pms_v1/mancom/readSynergySalesData.php
Back
<?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['mancom'])){ $companyID = $_POST['selectedCompanyID']; $userID = $_POST['userID']; $reportType = 'synergy_sales'; $getMansHead = "SELECT * FROM mancom_hdr WHERE `company_id`='$companyID' AND deleted = 0 AND `report_type`='$reportType' ORDER BY `year` DESC"; $qHeads = mysqli_query($conn,$getMansHead); $qhRow = mysqli_num_rows($qHeads); if($qhRow > 0){ while($rec = mysqli_fetch_array($qHeads)){ $linkData = "MANCOM_VehicleSalesReport.php?uid=$userID&c=".getCompanyNameSub($rec['company_id'])[1]."&d=".getDealerNameSub($rec['dealer_id'])[1]."&y=".$rec['year']."&token=0&hid=".$rec['id']; ?><tr onclick="javascript:getInfo(this);" style="width:100%"><?php echo "<td class='text-left p-2'>".$rec['id']."</td>"; echo "<td class='text-left p-2'>".$rec['year']."</td>"; echo "<td class='text-left p-2'>".getCompanyNameSub($rec['company_id'])[1]."</td>"; echo "<td class='text-left p-2'>".getDealerNameSub($rec['dealer_id'])[1]."</td>"; echo "<td class='text-left p-2'>"; $update = explode(" ", $rec['last_update']); $updateDate = $update[0]; echo $updateDate; echo "</td>"; echo "<td style='border:0px solid red;color:gray;font-family:Calibri;font-size:18px;font-weight:normal'>"; ?> <button class="btn btn-danger border float-right" onClick="window.open('./pdfViewer/<?php echo $linkData;?>')"><i class="fa fa-print"></i></button> <button class="btn btn-info border float-right" ><i data-toggle='modal' data-target='#updateMancom' class='fa fa-pencil-square-o float-right' aria-hidden='true'></i> </button> <?php echo "</td>"; echo "</tr>"; } }else{ echo "<tr><td colspan='6'><div class='col-lg-12 text-dark p-5 text-center'>No record found.</div></td></tr>"; } $conn->close(); }
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings