MAINHACK

Viewing / Editing File: all_menus.php

<?php include'header.php';?>

<div class="main-panel">
			<div class="content">
				<div class="container-fluid">
					<div class="page-header">
						<h4 class="page-title">All Menus</h4>
						
					</div>
					<div class="row">
						<div class="col-md-12">
							<div class="card">
							
								<div class="card-body">
									<div class="table-responsive">
					
							<table id="basic-datatables" class="display table table-striped table-hover">
							<thead>
								<tr>  
								  <th>Sl</th>
								  <th>Maker ID/Name/Phone</th>
								  <th>Image</th>
							      <th>Name</th>
								  <th>Serves</th>
								  <th>Price(Rs)</th>
								  <th>Status</th>
								  <th>Our Special</th>
								  <th>Edit/Delete</th>
								</tr>
							    </thead>
							   <tbody>

<?php
			
$sr='menu_items';
//$stmt =$show->readAll($sr);
$sq="select *,menu_items.id as mid,food_maker.title as fname from menu_items inner join food_maker on food_maker.maker_id=menu_items.maker_id where food_maker.main_category='Food' order by menu_items.id desc";
$stmt=$con->prepare($sq);
$stmt->execute();
$num = $stmt->rowCount();
     
     if($num>0){
 
        $count=1;
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['mid'];       
       $status=$row['status']=='ACTIVE'?'checked':'';
       $status_val=$row['status']=='ACTIVE'?'INACTIVE':'ACTIVE';
       $status_spcl=$row['our_special']==1?'checked':'';
       $status_val_spcl=$row['our_special']=='1'?0:1;

echo "<tr $status>
							    <td>$count</td>
								<td>".$row['maker_id']."<br>".$row['fname']."| ".$row['phone']."</td>								
								<td><img src='$pic_img/".$row['image']."' width='50px'></td>
								<td>".$row['name']."</td>
								<td>".$row['serves']."</td>
 								<td>".$row['price']."</td>"
 								;
 								?>
 								<td>
								<label class="switch" >
								<input type="checkbox" value="<?=$status_val?>" onchange="status(<?=$count;?>)" id="status<?=$count;?>" <?=$status?>>
								<span class="slider round"></span>
								</label>
                                <script>
                                function status(Value){
									
								var st="#status"+Value;
                                var id_txt="#id"+Value;
                                
								var status=$(st).val();
                                var id=$(id_txt).val();	
								var table='<?php echo $sr ?>';
                              // alert(status);
                                $.ajax({
                                type: "POST",
                                url: "ajax_check.php", // Name of the php files
                                data: "status="+status+"&id="+id+"&table="+table,
                                async: false,
                                global: false,
								 beforeSend: function(){
								/* Show image container */
								$("#loader").show();
							   },
                                success: function(result)
                                { 
								  $( "#basic-datatables" ).load( "all_menus.php #basic-datatables" );
                                //window.location.reload();

//table.ajax.reload();

}
								
                                });
                                }
                                </script>			   
						   
						   <input type="hidden" id="id<?=$count?>" value="<?=$row['id']?>" >
                         
						 
<div id='loader' style='display: none;'>
  <img src='loader.gif' width='32px' height='32px'>
</div>
  </td>
 							   <td>
								<label class="switch" >
								<input type="checkbox" value="<?=$status_val_spcl?>" onchange="status_spcl(<?=$count;?>)" id="status_spcl<?=$count;?>" <?=$status_spcl?>>
								<span class="slider round"></span>
								</label>
                                <script>
                                function status_spcl(Value){
									
								var st="#status_spcl"+Value;
                                var id_txt="#id"+Value;
                                
								var status=$(st).val();
                                var id=$(id_txt).val();	
								var table='<?php echo $sr ?>';
                               //alert(status);
                                $.ajax({
                                type: "POST",
                                url: "ajax_check.php", // Name of the php files
                                data: "our_special="+status+"&id="+id+"&table="+table,
                                async: false,
                                global: false,
								 beforeSend: function(){
								/* Show image container */
								$("#loader2").show();
							   },
                                success: function(result)
                                { 
								  $( "#basic-datatables" ).load( "all_menus.php #basic-datatables" );
                                //window.location.reload();

//table.ajax.reload();

}
								
                                });
                                }
                                </script>

<div id='loader2' style='display: none;'>
  <img src='loader.gif' width='32px' height='32px'>
</div>
  </td>
								<?php echo" <td>";?>
							    <div class="form-button-action">
							<button type="button" data-toggle="tooltip" title="" class="btn btn-link btn-primary" data-original-title="Edit Task">
						<a href="edit_menu.php?id=<?=$id?>&table=<?=$sr?>&cate=food&url=<?=$_SERVER['REQUEST_URI']?>"  class="btn btn-link btn-primary" ><i class='la la-edit'></i></a>	
	
							</button>
							<button type="button" data-toggle="tooltip" title="" class="btn btn-link btn-danger" data-original-title="Remove">
							<a href="delete_menu.php?id=<?=$id?>&table=<?=$sr?>&url=<?=$_SERVER['REQUEST_URI']?>"  class="btn btn-link btn-danger"onclick="return send();"><i class='la la-times'></i></a>	
							</button>
							</div>
								<?php echo"</td></tr>";

++$count;
 }
}

?>							
</tbody></table>								
									
									</div>
				
									</div>
								</div>
							</div>
						</div>

</div>
				</div>
			</div>
			
		</div>

$('#multi-filter-select').DataTable( {
				"pageLength": 5,
				initComplete: function () {
					this.api().columns().every( function () {
						var column = this;
						var select = $('<select class="form-control"><option value=""></option></select>')
						.appendTo( $(column.footer()).empty() )
						.on( 'change', function () {
							var val = $.fn.dataTable.util.escapeRegex(
								$(this).val()
								);

column
							.search( val ? '^'+val+'$' : '', true, false )
							.draw();
						} );

column.data().unique().sort().each( function ( d, j ) {
							select.append( '<option value="'+d+'">'+d+'</option>' )
						} );
					} );
				}
			});

// Add Row
			$('#add-row').DataTable({
				"pageLength": 5,
			});

var action = '<td> <div class="form-button-action"> <button type="button" data-toggle="tooltip" title="" class="btn btn-link btn-primary btn-lg" data-original-title="Edit Task"> <i class="la la-edit"></i> </button> <button type="button" data-toggle="tooltip" title="" class="btn btn-link btn-danger" data-original-title="Remove"> <i class="la la-times"></i> </button> </div> </td>';

$('#addRowButton').click(function() {
				$('#add-row').dataTable().fnAddData([
					$("#addName").val(),
					$("#addPosition").val(),
					$("#addOffice").val(),
					action
					]);
				$('#addRowModal').modal('hide');

});
		});
	</script>
<?php include'footer.php';?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: all_menus.php

Server Info

System Features

User Info