1#@!#!123s

JFIF 1#@!#!123s
: / home5 / ranush / www / admin /
Filename : services_category.php
back
<?php
session_start();
include_once 'function.php';
// add Bank Details, meta_keyword, meta_description
if ($_POST['add'] == 'Create') {
    $menu_type               = trim($_POST['menu_type']);
    $services_category  = trim($_POST['services_category']);
    $menu_description_points = trim($_POST['menu_description_points']);
    $meta_keyword            = trim($_POST['meta_keyword']);
    $meta_description        = trim($_POST['meta_description']);
    $site_map        		 = trim($_POST['site_map']);
    $random_no               = rand(10000000, 99999999);
    $catering_menu_img       = $_FILES['catering_menu_img']['name'];
    if (!empty($catering_menu_img)) {
        $file_size                  = $_FILES['catering_menu_img']['size'];
        $target_path                = "catering/";
        $uploaded_catering_menu_img = $random_no . "_" . $_FILES['catering_menu_img']['name'];
        move_uploaded_file($_FILES['catering_menu_img']['tmp_name'], $target_path . $random_no . "_" . $_FILES['catering_menu_img']['name']);
    } else {
        $uploaded_catering_menu_img = "";
    }
    mysqli_query($connect, "Insert into services_category (`services_category`, `catering_menu_img`,`menu_description_points`, `menu_type`, `meta_keyword`, `meta_description`, `site_map`) values ('$services_category','$uploaded_catering_menu_img','$menu_description_points', '$menu_type', '$meta_keyword', '$meta_description', '$site_map')") or die(mysqli_error());
    echo "<div style='width: 350px; text-align: center; margin: 20% auto 0px; font-family: arial; font-size: 14px; border: 1px solid #ddd; padding: 20px 40px;'>
Please wait while we Upadating loading...</div>";
    echo "<script type='text/javascript'>window.location = 'services_category.php?msg=added&action=list'</script>";
}
// Bank Edit
if ($_POST['update_page'] == 'Update') {
    $services_category  = trim($_POST['services_category']);
    $old_catering_menu_img   = trim($_POST['old_catering_menu_img']);
    $menu_description_points = trim($_POST['menu_description_points']);
    $menu_type               = trim($_POST['menu_type']);
    $meta_keyword            = trim($_POST['meta_keyword']);
    $meta_description        = trim($_POST['meta_description']);
    $site_map        		 = trim($_POST['site_map']);
    // catering_menu_img
    $random_no               = rand(10000000, 99999999);
    $catering_menu_img       = $_FILES['catering_menu_img']['name'];
    if (!empty($catering_menu_img)) {
        $file_size                  = $_FILES['catering_menu_img']['size'];
        $target_path                = "catering/";
        $uploaded_catering_menu_img = $random_no . "_" . $_FILES['catering_menu_img']['name'];
        move_uploaded_file($_FILES['catering_menu_img']['tmp_name'], $target_path . $random_no . "_" . $_FILES['catering_menu_img']['name']);
        // Old image
        $oldimage_path = $target_path . $old_catering_menu_img;
        unlink($oldimage_path);
    } else {
        $uploaded_catering_menu_img = $old_catering_menu_img;
    }
    mysqli_query($connect, "UPDATE services_category  SET  `menu_type` = '$menu_type',`services_category` = '$services_category', `catering_menu_img` = '$uploaded_catering_menu_img',`menu_description_points`='$menu_description_points' ,`meta_keyword`='$meta_keyword',`meta_description`='$meta_description',`site_map`='$site_map' where services_category_id = $_POST[services_category_id]") or die(mysqli_error());
    echo "<div style='width: 350px; text-align: center; margin: 20% auto 0px; font-family: arial; font-size: 14px; border: 1px solid #ddd; padding: 20px 40px;'>
Please wait while we Upadating loading...</div>";
    echo "<script type='text/javascript'>window.location = 'services_category.php?msg=Upadatingd&action=list'</script>";
}
// Delete
// deleting record
// action=delete&catid
if ($_GET['action'] == 'delete') {
    $id  = $_GET['nwsevnt_id'];
    $sql = "DELETE FROM services_category WHERE services_category_id = $id;";
    $query = mysqli_query($connect, $sql) or die("There was a problem while deleting: " . mysqli_error());
    echo "<div style='width: 350px; text-align: center; margin: 20% auto 0px; font-family: arial; font-size: 14px; border: 1px solid #ddd; padding: 20px 40px;'>Please wait while we Upadating the record loading...</div>";
    if ($query) {
        echo "<script type='text/javascript'>window.location = 'services_category.php?msg=deleted&action=list'</script>";
    }
}
?>
<!-- menu_type -->
<!DOCTYPE html>
<html lang="en">
	<meta http-equiv="content-type" content="text/html;charset=UTF-8" />
	<head>
		
		<meta charset="utf-8" />
		<title>Services Category | <?php echo $site_title; ?></title>
		<meta http-equiv="X-UA-Compatible" content="IE=edge">
		<meta content="width=device-width, initial-scale=1" name="viewport" />
		<meta content="Admin Panel"  name="description" />
		<meta content="Admin Panel"  name="author" />
		<link rel="shortcut icon" type="image/x-icon" href="assets/favicon.ico">
		<!-- BEGIN GLOBAL MANDATORY STYLES -->
		<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
		<link rel="stylesheet" href="assets/font-awesome/font-awesome.min.css">
		<link href="http://fonts.googleapis.com/css?family=Open+Sans:400,300,600,700&amp;subset=all" rel="stylesheet" type="text/css" />
		<link href="assets/global/plugins/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css" />
		<link href="assets/global/plugins/simple-line-icons/simple-line-icons.min.css" rel="stylesheet" type="text/css" />
		<link href="assets/global/plugins/bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
		<link href="assets/global/plugins/bootstrap-switch/css/bootstrap-switch.min.css" rel="stylesheet" type="text/css" />
		<script src="//cdn.ckeditor.com/4.5.7/standard/ckeditor.js"></script>
		<!-- END GLOBAL MANDATORY STYLES -->
		<!-- BEGIN PAGE LEVEL PLUGINS -->
		<link href="assets/global/plugins/datatables/datatables.min.css" rel="stylesheet" type="text/css" />
		<link href="assets/global/plugins/datatables/plugins/bootstrap/datatables.bootstrap.css" rel="stylesheet" type="text/css" />
		<!-- END PAGE LEVEL PLUGINS -->
		<!-- BEGIN THEME GLOBAL STYLES -->
		<link href="assets/global/css/components.min.css" rel="stylesheet" id="style_components" type="text/css" />
		<link href="assets/global/css/plugins.min.css" rel="stylesheet" type="text/css" />
		<!-- END THEME GLOBAL STYLES -->
		<!-- BEGIN THEME LAYOUT STYLES -->
		<link href="assets/layouts/layout/css/layout.min.css" rel="stylesheet" type="text/css" />
		<link href="assets/layouts/layout/css/themes/darkblue.min.css" rel="stylesheet" type="text/css" id="style_color" />
		
		
		<link href="assets/global/plugins/select2/css/select2.min.css" rel="stylesheet" type="text/css" />
		<link href="assets/global/plugins/select2/css/select2-bootstrap.min.css" rel="stylesheet" type="text/css" />
		<link href="assets/global/plugins/bootstrap-fileinput/bootstrap-fileinput.css" rel="stylesheet" type="text/css" />
		<link href="assets/global/plugins/select2/css/select2.min.css" rel="stylesheet" type="text/css" />
		<link href="assets/global/plugins/select2/css/select2-bootstrap.min.css" rel="stylesheet" type="text/css" />
		
		<link href="assets/layouts/customer.css" rel="stylesheet" type="text/css" />
		<!-- END PAGE LEVEL PLUGINS -->
		<!-- Date Picker -->
		<link rel="stylesheet" href="assets/datepicker/jquery-ui.css">
		<link rel="stylesheet" href="assets/datepicker/style.css">
		<script src="assets/datepicker/jquery-1.12.4.js"></script>
		<script src="assets/datepicker/jquery-ui.js"></script>
		<script src="assets/datepicker/datepicker.js"></script>
		<!-- Emd Date picker -->
		<style type="text/css">
		.dt-buttons {
		display: none;
		}
		</style>
		<script type="text/javascript">
		function delete_menu(idurl)
		{
		go_on = confirm("Are you sure ? ");
		if(go_on)
		{
		document.location.href=idurl;
		}
		}
		</script>
	</head>
	<!-- END HEAD -->
	<body class="page-header-fixed page-sidebar-closed-hide-logo page-content-white">
		<div class="page-wrapper">
			<!-- BEGIN HEADER -->
			<?php include("header.php");?>
			<!-- END HEADER -->
			<!-- BEGIN HEADER & CONTENT DIVIDER -->
			<div class="clearfix">
			</div>
			<!-- END HEADER & CONTENT DIVIDER -->
			<!-- BEGIN CONTAINER -->
			<div class="page-container">
				<!-- BEGIN SIDEBAR -->
				<?php include("menu.php");?>
				<!-- END SIDEBAR -->
				<!-- BEGIN CONTENT -->
				<div class="page-content-wrapper">
					<!-- BEGIN CONTENT BODY -->
					<div class="page-content">
						<!-- END THEME PANEL -->
						<!-- BEGIN PAGE BAR -->
						<!-- <div class="page-bar">
							<ul class="page-breadcrumb">
								<li><a href="index.php">Home</a><i class="fa fa-circle"></i></li>
								<li><span>Catering Menu Category</span></li>
							</ul>
							<div class="page-toolbar">
								
							</div>
						</div> -->
						<!-- END PAGE BAR -->
						<!-- BEGIN PAGE TITLE-->
						<?php
						//get action
						if(isset($_GET['action']) =='' || $_GET['action'] == 'list') {
						?>
						<br>
						<div class="row">
							<div class="col-md-12">
								<!-- BEGIN EXAMPLE TABLE PORTLET-->
								<div class="portlet box green">
									<div class="portlet-title">
										<div class="caption">
											<i class="fa fa-globe">
											</i>Services Menu Category
										</div>
										<div class="actions">
											<a class="btn btn-default btn-sm" data-toggle="modal" href="#CategoryAdd">
												<i class="fa fa-plus">
												</i> Add
											</a>
											
										</div>
										<div class="modal fade" id="CategoryAdd" tabindex="-1" role="basic" aria-hidden="true">
											<div class="modal-dialog modal-lg">
												<div class="modal-content">
													<div class="modal-header">
														<button type="button" class="close" data-dismiss="modal" aria-hidden="true"></button>
														<h4 class="modal-title" style="color: #111">
														<b>Catering Menu Category Add</b>
														</h4>
													</div>
													<form action="" id="form_sample_1" method="post" class="form-horizontal" novalidate="novalidate" enctype="multipart/form-data">
														<div class="modal-body">
															<div class="row">
																<div class="col-md-12">
																	<div class="form-body">
																		<div class="form-group">
																			<label class="control-label col-sm-2" for="services_category" style="color: #111">Category:</label>
																			<div class="col-sm-10">
																				<input autocomplete="off" type="text" class="form-control" name="services_category">
																			</div>
																		</div>
																		
																	</div>
																	
																	

																	<div class="form-group">
																		<label class="control-label col-sm-2" for="services_category" style="color: #111">Image:</label>
																		<div class="col-sm-10">
																			<div class="fileinput fileinput-new" data-provides="fileinput">
																				<div class="fileinput-new thumbnail" style="width: 200px; height: 150px;">
																				<img src="http://www.placehold.it/200x150/EFEFEF/AAAAAA&amp;text=no+image" alt=""> </div>
																				<div class="fileinput-preview fileinput-exists thumbnail" style="max-width: 200px; max-height: 150px;"> </div>
																				<div>
																					<span class="btn default btn-file">
																						<span class="fileinput-new"> Select image </span>
																						<span class="fileinput-exists"> Change </span>
																						<input autocomplete="off" type="file" name="catering_menu_img"> </span>
																						<a href="javascript:;" class="btn red fileinput-exists" data-dismiss="fileinput"> Remove </a>
																					</div>
																				</div>
																				
																			</div>
																		</div>
																		<div class="form-body">
																			<div class="form-group">
																				<label class="control-label col-sm-2" for="services_category" style="color: #111">Description:</label>
																				<div class="col-md-9">
																					<textarea name="menu_description_points" class="form-control ckeditor"></textarea>
																				</div>
																			</div>
																			
																		</div>
																		<div class="form-body">
																			<div class="form-group">
																				<label class="control-label col-sm-2" for="meta_keyword" style="color: #111">Meta Keyword:</label>
																				<div class="col-md-9">
																					<textarea name="meta_keyword" class="form-control"></textarea>
																				</div>
																			</div>
																			
																		</div>
																		<div class="form-body">
																			<div class="form-group">
																				<label class="control-label col-sm-2" for="meta_description" style="color: #111">Meta Description:</label>
																				<div class="col-md-9">
																					<textarea name="meta_description" class="form-control"></textarea>
																				</div>
																			</div>
																			
																		</div>
																	</div>
																</div>
															</div>
															<div class="modal-footer">
																<button type="submit" class="btn dark" name="add" value="Create">Submit</button>
																<button type="button" class="btn dark btn-outline" data-dismiss="modal">Close</button>
															</div>
														</form>
													</div>
													<!-- /.modal-content -->
												</div>
												<!-- /.modal-dialog -->
											</div>
										</div>
										<div class="portlet-body">
											<?php pageStatus($status); ?>
											<table class="table table-striped table-bordered table-hover" id="sample_2">
												<thead>
													<tr class="">
														<th> S.NO </th>
														<th>Services Category </th>
														<th>  Image </th>
														<th>Modify</th>
													</tr>
												</thead>
												<tbody>
													<?php
													$sno =0;
													
													$get_services_category = mysqli_query($connect,"SELECT * FROM `services_category`") or die(mysqli_error());
													while($get_value = mysqli_fetch_array($get_services_category))
													{
													$sno++;
													$services_category_id  = $get_value['services_category_id'];
													$services_category 	= $get_value['services_category'];
													$catering_menu_img 			= $get_value['catering_menu_img'];
													$menu_type 					= $get_value['menu_type'];
													$menu_description_points 	= $get_value['menu_description_points'];
													$meta_keyword 				= $get_value['meta_keyword'];
													$meta_description 			= $get_value['meta_description'];
													$site_map					= $get_value['site_map'];
													if($menu_type=="Catering Menu")
													{
														$page_types_Catering =  "selected";
													}
													elseif ($menu_type=="Festive Menu") {
														$page_types_Festive =  "selected";
													}
													?>
													<tr>
														<td><?php echo $sno;?> </td>
														<td><?php echo $services_category;?> </td>
													
														<td><img src="catering/<?php echo $catering_menu_img;?>" style="width: 150px;height: 100px"> </td>
												
														<td>
															<a class="btn btn-xs yellow" data-toggle="modal" href="#CategoryEdit<?php echo $services_category_id; ?>">
																<i class="fa fa-pencil" aria-hidden="true">
																</i> Edit
															</a>
															<a class="btn btn-xs red"  onClick="delete_menu('services_category.php?action=delete&nwsevnt_id=<?php echo $services_category_id; ?>')" href="javascript:;">
																<i class="icon-trash">
																</i> Delete
															</a>
														</td>
														
														<!-- /.modal -->
														<div class="modal fade" id="CategoryEdit<?php echo $services_category_id; ?>" tabindex="-1" role="basic" aria-hidden="true">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
	<button type="button" class="close" data-dismiss="modal" aria-hidden="true"></button>
	<h4 class="modal-title" style="color: #111">
	<b> Edit - <?php echo $services_category;?></b>
	</h4>
</div>
<form action="" id="form_sample_1" method="post" class="form-horizontal" novalidate="novalidate" enctype="multipart/form-data">
	<div class="modal-body">
		<div class="row">
			<div class="col-md-12">
				<div class="form-body">
					<div class="form-group">
						<label class="control-label col-sm-2" for="services_category" style="color: #111">category:</label>
						<div class="col-sm-10">
							<input autocomplete="off" type="text" class="form-control" name="services_category" value="<?php echo $services_category; ?>">
							<input autocomplete="off" type="hidden" class="form-control" name="services_category_id" value="<?php echo $services_category_id; ?>">
						</div>
					</div>
				
					
					<br>
					<br>
					
				
					<div class="form-group">
						<label class="control-label col-sm-2" for="services_category" style="color: #111">Image:</label>
						<div class="col-sm-10">
							<div class="fileinput fileinput-new" data-provides="fileinput">
								<div class="fileinput-new thumbnail" style="width: 200px; height: 150px;">
								<img src="catering/<?php echo $catering_menu_img;?>" alt=""> </div>
								<div class="fileinput-preview fileinput-exists thumbnail" style="max-width: 200px; max-height: 150px;"> </div>
								<div>
									<span class="btn default btn-file">
										<span class="fileinput-new"> Select image </span>
										<span class="fileinput-exists"> Change </span>
										<input autocomplete="off" type="file" name="catering_menu_img"> </span>
										<a href="javascript:;" class="btn red fileinput-exists" data-dismiss="fileinput"> Remove </a>
									</div>
								</div>
							</div>
						</div>
							<div class="form-group">
								<label class="control-label col-sm-2" for="menu_description_points" style="color: #111"> Description:</label>
								<div class="col-md-9">
									<textarea name="menu_description_points" class="form-control ckeditor">
									<?php echo $menu_description_points;?>
									</textarea>
								</div>
							</div>
							<br>
							<br>
							<div class="form-group">
								<label class="control-label col-sm-2" for="meta_keyword" style="color: #111">Meta Keyword:</label>
								<div class="col-md-9">
									<textarea name="meta_keyword" class="form-control">
									<?php echo $meta_keyword;?>
									</textarea>
								</div>
							</div>
							
							
							
							<div class="form-group">
								<label class="control-label col-sm-2" for="meta_description" style="color: #111">Meta Description:</label>
								<div class="col-md-9">
									<textarea name="meta_description" class="form-control">
									<?php echo $meta_description;?>
									</textarea>
								</div>
							</div>
							
						
					</div>
					
				</div>
			</div>
		</div>
		<input autocomplete="off" type="hidden" name="old_catering_menu_img" value="<?php echo $catering_menu_img;?>">
		<div class="modal-footer">
			<button type="submit" class="btn dark" name="update_page" value="Update">Update</button>
			<button type="button" class="btn dark btn-outline" data-dismiss="modal">Close</button>
		</div>
	</form>
</div>
<!-- /.modal-content -->
</div>
																<!-- /.modal-dialog -->
															</div>
														</tr>
														<?php
														}
														?>
													</tbody>
												</table>
											</div>
										</div>
									</div>
								</div>
								<?php
								}
								?>
								
								
								
								<!-- END CONTENT BODY -->
							</div>
							<!-- END CONTENT -->
							<!-- END QUICK SIDEBAR -->
						</div>
						<!-- END CONTAINER -->
						<!-- BEGIN FOOTER -->
						<?php include("footer.php");?>
						<!-- END FOOTER -->
					</div>
					<!-- BEGIN QUICK NAV -->
					<div class="quick-nav-overlay">
					</div>
					<!-- END QUICK NAV -->
					<!--[if lt IE 9]>
					<script src="assets/global/plugins/respond.min.js"></script>
					<script src="assets/global/plugins/excanvas.min.js"></script>
					<script src="assets/global/plugins/ie8.fix.min.js"></script>
					<![endif]-->
					<!-- BEGIN CORE PLUGINS -->
					<!-- <script src="assets/global/plugins/jquery.min.js" type="text/javascript"></script> -->
					<script src="assets/global/plugins/bootstrap/js/bootstrap.min.js" type="text/javascript">
					</script>
					<script src="assets/global/plugins/js.cookie.min.js" type="text/javascript">
					</script>
					<script src="assets/global/plugins/jquery-slimscroll/jquery.slimscroll.min.js" type="text/javascript">
					</script>
					<script src="assets/global/plugins/jquery.blockui.min.js" type="text/javascript">
					</script>
					<script src="assets/global/plugins/bootstrap-switch/js/bootstrap-switch.min.js" type="text/javascript">
					</script>
					<!-- END CORE PLUGINS -->
					<!-- BEGIN PAGE LEVEL PLUGINS -->
					<script src="assets/global/scripts/datatable.js" type="text/javascript">
					</script>
					<script src="assets/global/plugins/datatables/datatables.min.js" type="text/javascript">
					</script>
					<script src="assets/global/plugins/datatables/plugins/bootstrap/datatables.bootstrap.js" type="text/javascript">
					</script>
					<!-- END PAGE LEVEL PLUGINS -->
					<!-- BEGIN THEME GLOBAL SCRIPTS -->
					<script src="assets/global/scripts/app.min.js" type="text/javascript">
					</script>
					<!-- END THEME GLOBAL SCRIPTS -->
					<!-- BEGIN PAGE LEVEL SCRIPTS -->
					<script src="assets/pages/scripts/table-datatables-colreorder.min.js" type="text/javascript">
					</script>
					<!-- END PAGE LEVEL SCRIPTS -->
					<!-- BEGIN THEME LAYOUT SCRIPTS -->
					<script src="assets/layouts/layout/scripts/layout.min.js" type="text/javascript">
					</script>
					<script src="assets/layouts/layout/scripts/demo.min.js" type="text/javascript">
					</script>
					<script src="assets/layouts/global/scripts/quick-sidebar.min.js" type="text/javascript">
					</script>
					<script src="assets/layouts/global/scripts/quick-nav.min.js" type="text/javascript">
					</script>
					<script src="assets/global/plugins/bootstrap-fileinput/bootstrap-fileinput.js" type="text/javascript">
					</script>
					<!-- BEGIN PAGE LEVEL PLUGINS -->
					<script src="assets/global/plugins/select2/js/select2.full.min.js" type="text/javascript">
					</script>
					<!-- END PAGE LEVEL PLUGINS -->
					<!-- BEGIN PAGE LEVEL SCRIPTS -->
					<script src="assets/pages/scripts/components-select2.min.js" type="text/javascript">
					</script>
					<!-- END PAGE LEVEL SCRIPTS -->
					<!-- SCRIPTS -->
					
				</body>
			</html>