<?php 
	include ("include/makeSession.php");
	include('include/function.php');
	include("include/header.php");
	include("include/sidebar.php");
	if(isset($_REQUEST['did']) && $_REQUEST['did']!=''){
		$dovalue="";
		$doid=$_REQUEST['did'];
		mysqli_query($con,"delete from sm where id='$doid'");
		echo '<META HTTP-EQUIV="Refresh" Content="0; URL=sm.php">';
		exit;
	}
	if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){
		  $dovalue="EditSm";
		  $doid=$_REQUEST['upid'];
		  $Query=mysqli_query($con,"select * from sm where id='".$_REQUEST['upid']."'");
		  $Row=mysqli_fetch_array($Query);
	}else{
	 	  $dovalue="Sm";
		  $doid='';  
	}
	?>
<div class="content-wrapper">
	<!-- Content About Us (Page header) -->
	<section class="content-header">
		<h1>Sub Menu <small></small> </h1>
		<ol class="breadcrumb">
			<li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
			<li><a href="#">sm</a></li>
		</ol>
	</section>
	<!-- Main content -->
	<section class="content">
		<div class="row">
			<div class="col-md-12">
				<?php if(!empty($_SESSION['msg'])){
					$msg=$_SESSION["msg"];
					      echo '<div class="col-md-12">
					<div class="alert alert-success alert-dismissible">
					<a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
					'.$msg.'
					</div>'; $_SESSION["msg"]='';} ?>
				<div class="box box-info">
					<div class="box-header">
						<h3 class="box-title">Sub Menu <small></small></h3>
						<!-- tools box -->
						<div class="pull-right box-tools">
							<button class="btn btn-info btn-sm" data-widget="collapse" data-toggle="tooltip" title="Collapse"><i class="fa fa-minus"></i></button>
							<button class="btn btn-info btn-sm" data-widget="remove" data-toggle="tooltip" title="Remove"><i class="fa fa-times"></i></button>
						</div>
						<!-- /. tools --> 
					</div>
					<!-- /.box-header -->
					<div class="box-body pad">
						<div class="col-md-8">
							<form method="post" action="action.php" enctype="multipart/form-data"  role="form">
								<input type="hidden"  name="do" value="<?php echo $dovalue;?>" />
								<input type="hidden"  name="doid" value="<?php echo $doid;?>" />
								<!-- text input --> 
								<div class="row">
									<div class="col-md-6">
										<div class="form-group">
											<label>Name</label>                                    
											<input type="text" class="form-control" name="name" value="<?php if(isset($_REQUEST['upid'])){ echo $Row['name'];}?>" />
										</div>
									</div></div>
									<div class="row">
				            <div class="form-group col-md-6">
                                      <label for="exampleSelect1">Main Menu</label>
                                      <select class="form-control" id="exampleSelect1" name="mm_id">
                                        <option value="">Select Main menu</option>
                                        <?php
                                            $mmQ=mysqli_query($con,"SELECT * FROM mm");
                                            while($mmR=mysqli_fetch_array($mmQ)){
                                        ?>
                        <option value="<?php echo $mmR['id']; ?>" <?php if(!empty($_REQUEST["upid"])&&$mmR['id']==$Row['mm_id']) echo "selected"; ?>>
                                                    <?php echo $mmR['name'];?>
                                                </option>
                                        <?php
                                            }
                                        ?>
                                      </select>
                                    </div>					
								</div>
								
								<div class="box-footer">
									<input type="submit" class="btn btn-primary" value="Save"/>
									<input type="reset" value="Reset" class="btn btn-primary">
								</div>
							</form>
						</div>
					</div>
				</div>
				<!-- /.box --> 
			</div>
			<!-- /.col--> 
		</div>
		<!-- ./row --> 
	</section>
	<!-- /.content -->
	<section class="content">
		<div class="row">
			<div class="col-xs-12">
				<div class="box">
					<div class="box-header">
						<h3 class="box-title">Main Menu Report</h3>
					</div>
					<!-- /.box-header -->
					<div class="box-body">
						<table id="example1" class="table table-bordered table-striped">
							<thead>
								<tr>
									<th scope="col">Sr no</th>
									<th scope="col">Name</th>
									<th scope="col">Main menu</th>
									<th scope="col">Action</th>
								</tr>
							</thead>
							<tbody>
								<?php $q=mysqli_query($con,"SELECT sm.*,mm.name as mm_name FROM sm left join mm on mm.id=sm.mm_id");
									$i = 1;
									  while($r=mysqli_fetch_array($q)){ ?>
								<tr>
									<td><?php echo $i; ?></td>
									<td><?=$r['name'];?></td>
									<td><?=$r['mm_name'];?></td>
									<td><a href="?upid=<?php echo $r["id"]; ?>"><i class="fa fa-pencil text-yellow"></i></a>&nbsp;&nbsp; <a href="?did=<?php echo $r["id"]; ?>"><i class="fa fa-remove text-red"></i></a></td>
								</tr>
								<?php $i++;} ?>
							</tbody>
						</table>
					</div>
					<!-- /.box-body --> 
				</div>
				<!-- /.box --> 
			</div>
			<!-- /.col --> 
		</div>
		<!-- /.row --> 
	</section>
</div>
<?php include('include/footer.php');?>
<script src="plugins/datatables/jquery.dataTables.min.js"  type="text/javascript"></script>
<script src="plugins/datatables/dataTables.bootstrap.min.js"  type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.5.1/js/dataTables.buttons.min.js"  type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.colVis.min.js"  type="text/javascript"></script>
<script  type="text/javascript">
	$(document).ready(function() {
	    $('#example1').DataTable( {
	    });
	} );
		//$(function () {
		//$("#example1").DataTable();
		
		//});
</script>