File manager - Edit - /home/autoph/public_html/connect/home/news_and_updates.php
Back
<div style='width:100%;height:1px;background: gray ;'></div> <div style="font-size:24px;font-weight:normal;color:blue;background:white ;padding:15px;border:0px solid #d6dbdf;margin:1px;margin-right:0px;margin-left:0px ">☷ Latest Updates <div style="font-size:14px;font-weight:normal;color:blue;background:white ;padding:5px;border:0px solid #d6dbdf;margin:1px;float:right;width:400px"> <?php echo "Today's Date: ". $toDate;?></div> </div> <div style='width:100%; padding:0px;margin-left:0px;margin-top:0px;border-top:0px solid #9ea5a5;background-color:#fff;border-left:1px solid gray'> <div class="newsFeed" style="height:700px;float:left"> <h1 style="font-weight:normal;font-size:20px;color:green;margin:5px;">📅Recent Sales Activity</h1> <div style=" width:100%;border:0px solid gray;padding:5px"> <?php $loadUpdates = mysql_query("SELECT * FROM `prospect_updates` WHERE `dealer_id`='$dealID' AND `status`='1' ORDER BY `pid` LIMIT 6"); while($row=mysql_fetch_array($loadUpdates)){ $prosID = $row['prospect_id']; $getAgent = mysql_result(mysql_query("SELECT `sales_id` FROM `sales_prospecting` WHERE `id`='$prosID'"),0); $salesEmpID = $row['prospect_id']; $custName = mysql_result(mysql_query("SELECT `prospect_name` FROM `sales_prospecting` WHERE `id`='$prosID'"),0); $salesFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `employee_id`='$getAgent'"),0); $salesLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `employee_id`='$getAgent'"),0); echo "<div style='width:90%;padding:5px;margin:5px;margin-left:15px;border:0px solid white;border-bottom:1px solid lightgray;height:auto;margin-bottom:10px'> <b style='line-height:120%; font-family:Verdana;font-size:16px;color:#f65b21;font-weight:bold'>".$custName."</b><br> <b style='line-height:120%;font-family:Verdana;font-size:12px;color:blue;font-weight:normal'>UPDATE: ".$row['description']."</b><br> <b style='line-height:120%;font-family:Verdana;font-size:14px;color:blue;font-weight:bold'>STATUS: ".$row['movement']."</b><br> <b style='line-height:120%;font-family:Verdana;font-size:14px;color:blue;font-weight:normal'>AGENT: ".$salesLName.", ".$salesFName."</b><br> <b style='line-height:120%;font-family:Verdana;font-size:12px;color:black;font-weight:normal'>DATE: ".$row['date']." | ".$row['time']."</b> <a href='#' style='float:right;'>Read More</a> </div>"; } ?> </div> </div> <div class="newsFeed" style="height:700px;float:left"> <h2 style="font-weight:normal;font-size:20px;color:blue;margin:5px;">📚 <u>New Database Created</u></h1> </div> <div class="newsFeed" style="height:700px;float:left"> <h2 style="font-weight:normal;font-size:20px;color:red;margin:5px;">📆 <u>Upcoming Schedule</u></h1> </div> <div class="newsFeed" style="height:700px;float:left"> <h2 style="font-weight:normal;font-size:20px;color: #3498db ;margin:5px;">📌 <u>Approval Summary</u></h1> </div> </div>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings