File manager - Edit - /home/autoph/public_html/voc/home/nav_menu_a.php
Back
<?php protected_page(); $getCheckedInUnit = mysql_result(mysql_query("SELECT COUNT('chk_id') FROM `vts_in_out_history` WHERE `comp_code`='$compID' AND `dealer_code`='$dealID' AND `chk_transaction`='IN'"),0); $getCheckedInWI = mysql_result(mysql_query("SELECT COUNT('chk_id') FROM `vts_in_out_history` WHERE `comp_code`='$compID' AND `dealer_code`='$dealID' AND `chk_transaction`='IN' AND `location_code`='6'"),0); $getCheckedInAPPT = mysql_result(mysql_query("SELECT COUNT('chk_id') FROM `vts_in_out_history` WHERE `comp_code`='$compID' AND `dealer_code`='$dealID' AND `chk_transaction`='IN' AND `location_code`='3'"),0); $getCheckedInGUESS = mysql_result(mysql_query("SELECT COUNT('chk_id') FROM `vts_in_out_history` WHERE `comp_code`='$compID' AND `dealer_code`='$dealID' AND `chk_transaction`='IN' AND `location_code`='4'"),0); $getCheckedInOwned = mysql_result(mysql_query("SELECT COUNT('chk_id') FROM `vts_in_out_history` WHERE `comp_code`='$compID' AND `dealer_code`='$dealID' AND `chk_transaction`='IN' AND `location_code`='5' || `comp_code`='$compID' AND `dealer_code`='$dealID' AND `chk_transaction`='IN' AND `location_code`='9'"),0); $getDealCapacity = mysql_result(mysql_query("SELECT `area_capacity` FROM `vts_dealerships` WHERE `deal_id`='$dealID' "),0); $capacityRate = number_format(($getCheckedInUnit / $getDealCapacity) * 100,1,'.',',')."<i style='font-family:Verdana;font-size:12px;color:red'>%</i>"; ?> <a href="#" class="active" style='padding:3px;padding-left:5px;font-family:Verdana;font-size:14px;font-weight:normal;color:black'>☛ Area Capacity</a> <div style='width:50%;float:left;text-align:centerl;font-family:Verdana;font-size:30px;border:0px solid red;background:yellow'> <a href="#" style='padding:5px;padding-left:5px;margin:0px;color:#5b5957 ;font-family:Verdana;font-size:10px;'> ➤ APPT: <?php echo $getCheckedInAPPT;?></a> <a href="#" style='padding:5px;padding-left:5px;margin:0px;color:#5b5957;font-family:Verdana;font-size:10px;'>➤ WALKIN: <?php echo $getCheckedInWI;?></a> <a href="#" style='padding:5px;padding-left:5px;margin:0px;color:#5b5957;font-family:Verdana;font-size:10px;'>➤ VISITORS: <?php echo $getCheckedInGUESS;?></a> <a href="#" style='padding:5px;padding-left:5px;margin:0px;color:#5b5957;font-family:Verdana;font-size:10px;'>➤ OWNED: <?php echo $getCheckedInOwned;?></a> </div> <div style='width:50%;float:left;text-align:right;font-family:Verdana;font-size:30px;border:0px solid red;background:transparent;'> <a href="#" style='height:100px;padding:10px;padding-top:20px;margin:0px;color:#0864cb;font-family:Agency FB;font-size:40px;text-align:right'><?php echo $capacityRate;?></a> <center><a href="#" style='font-family:Verdana;font-size:10px;color:red;float:right;width:100px;border-radius:10px;padding:4px'>❮ View Details ❯</a></center> </div>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings