芝麻web文件管理V1.00

编辑当前文件:/home/qrafawbu/rentandbuyrealty.com/ProZigzagbus Web Admin 1.2/pending.php

<?php 
require 'inc/Header.php';
?>
    
    
    <div class="page-wrapper compact-wrapper" id="pageWrapper">
      
    <?php require 'inc/Navbar.php';?>
      
      
      <div class="page-body-wrapper">
        
       <?php require 'inc/Sidebar.php';?>
        
        <div class="page-body">
          <div class="container-fluid">
            <div class="page-title">
              <div class="row">
                <div class="col-sm-6">
                  <h3><?php echo $lang['Total_Pending_Trip_Management'];?></h3>
                </div>
               
              </div>
            </div>
          </div>
          
          <div class="container-fluid dashboard-default">
            <div class="row">
           <div class="col-sm-12">
                <div class="card">
				<div class="card-body">
				<div class="table-responsive">
                <table class="display" id="basic-1">
                        <thead>
                          <tr>
                            <th><?php echo $lang['Sr_No'];?>.</th>
							
											
											<th><?php echo $lang['Bus_Name'];?></th>
											<th><?php echo $lang['Bus_Pickuptime'];?></th>
											<th><?php echo $lang['Bus_droptime'];?></th>
												<th><?php echo $lang['Total_Seat'];?></th>
												<th><?php echo $lang['Seat_No'];?></th>
												<th><?php echo $lang['Passenger_Name'];?></th>
												<th><?php echo $lang['Passenger_Mobile'];?></th>
												
												
												
												
												<th><?php echo $lang['Total'];?></th>
												
                          </tr>
                        </thead>
                        <tbody>
                           <?php 
										$city = $bus->query("SELECT * FROM `tbl_book` where book_status='Pending' order by id desc");
										$i=0;
										while($row = $city->fetch_assoc())
										{
											$busdata = $bus->query("SELECT * from tbl_bus where id=".$row['bus_id']."")->fetch_assoc();
											$totalseat = $bus->query("SELECT COUNT(*) AS total_count, GROUP_CONCAT(seat_no) AS total_seats FROM tbl_book_pessenger WHERE book_id=" . $row['id'])->fetch_assoc();
											$i = $i + 1;
											?>
											<tr>
                                                <td>
                                                    <?php echo $i; ?>
                                                </td>
                                                
												
												
                                              
												
												<td>
                                                    <?php echo $busdata['title']; ?>
                                                </td>
												
												<td>
                                                    <?php $dateTime = new DateTime($row['bus_board_date']); 
													echo $dateTime->format('jS M Y, g:i A');
													?>
                                                </td>
												
												<td>
                                                    <?php 
                                                      $dateTime = new DateTime($row['bus_drop_date']);
echo $dateTime->format('jS M Y, g:i A');
													?>
                                                </td>
                                                
                                               <td>
                                                    <?php echo $row['total_seat']; ?>
                                                </td>
												
												
												<td><b><?php echo $totalseat['total_seats'];?></b></td>
												
												<td>
                                                    <?php echo $row['name']; ?>
                                                </td>
												<td>
                                                    <?php echo $row['ccode'].$row['mobile']; ?>
                                                </td>
												
												
												
												<td>
                                                    <b><?php 
													if($row['total'] == 0)
													{
														echo $row['wall_amt'].$set['currency'];
													}
													else 
													{
													echo $row['total'].$set['currency'];
													}
													?></b>
                                                </td>
												
												
												
												
												
                                                
												
                                                
										  
                                                </tr>
											<?php 
										}
										?>
                          
                        </tbody>
                      </table>
					  </div>
					  </div>
				 
                </div>
              
                
              </div>
            
            </div>
          </div>
          
        </div>
        
       
      </div>
    </div>
    
   <?php require 'inc/Footer.php'; ?>
    
  </body>

.star-icon.full:before {
    text-shadow: 0 0 2px rgba(0,0,0,0.7);
    color: #FDE16D;
    content: '\2605'; /* Full star in UTF-8 */
    position: absolute;
    left: 0;
}

.star-icon.half:before {
    text-shadow: 0 0 2px rgba(0,0,0,0.7);
    color: #FDE16D;
    content: '\2605'; /* Full star in UTF-8 */
    position: absolute;
    left: 0;
    width: 50%;
    overflow: hidden;
}

@-moz-document url-prefix() { /* Firefox Hack :( */
  .star-icon {
    font-size: 50px;
    line-height: 34px;
  }
}
</style>
</html>