File manager - Edit - /home/autoph/public_html/voc/home/lead_generation_data_search.php
Back
<?php include 'core/init.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); $compID= $user_data['company']; ?> <?php //if submit/ save to databasevar if(isset($_POST['done'])){ $period = $_POST['period']; $sCompID = $_POST['sCompID']; //===================================================================================================================================================== //===================================================================================================================================================== $result = mysql_query("SELECT * FROM `sales_prospecting` WHERE `status` ='open' AND `comp_id`='$sCompID' ORDER BY `sales_id` ASC"); echo "<div style='width:100%;height:300px;border:0px solid red;overflow:auto'>"; echo "<div style='width:1000px;height:380px;border:0px solid red'>"; echo "<table style='width:100%;'>"; echo "<thead> <tr> <th style='width:5%'>REC. ID</th> <th style='width:10%'>Type</th> <th style='width:30%'>Customer Name</th> <th style='width:10%'>Sales Agent</th> <th style='width:20%'>Company</th> <th style='width:20%'>Dealership</th> <th style='width:5%'>Date Created</th> <th style='width:5%'>Status</th> </tr> </thead>"; while($row=mysql_fetch_array($result)){ $salesID=$row['sales_id']; $custID=$row['cust_id']; $isFleet=$row['is_fleet']; $SelCompID=$row['comp_id']; $SelDealID=$row['deal_id']; //$SalesPerson = mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `employee_id`='$salesID'"),0); $selCompName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$SelCompID'"),0); $selDealName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$SelDealID'"),0); ?><tr onclick="javascript:showCustDetailsProspect(this);" ondblclick="popShowSelectedProspect()"><?php echo "<td>".$row['id']."</td>"; echo "<td>"; if($row['is_fleet']==='No'){ echo "non-fleet"; }else{ echo "fleet"; } echo"</td>"; echo "<td>".$row['prospect_name']."</td>"; echo "<td>".$salesID."</td>"; echo "<td>".$row['prospect_name']."</td>"; echo "<td>".$selDealName."</td>"; echo "<td>".$row['date_added']."</td>"; echo "<td>".$row['status']."</td>"; echo "</tr>"; } echo "</table>"; echo"</div>"; echo"</div>"; exit(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings