One Hat Cyber Team

View File Name : mg_card.php

<?php  error_reporting(0);
session_start();
include 'config.php';


$_POST['username']=$_SESSION['username'];	
$_POST['password']=$_SESSION['password'];

	$sql=mysqli_query($con,"select * from admin where USERNAME='".$_POST['username']."' and PASSWORD='".$_POST['password']."'");	
	if(mysqli_num_rows($sql)==1)
	{





$AP_ID = $_GET['AP_ID'];

$view = mysqli_query($con,"select * from card where C_NO = '".$AP_ID."'"); // for editing

$datab = mysqli_fetch_array($view);



date_default_timezone_set("Asia/Kolkata");




if($_GET['del_id']){ ?>

 

<?php  $del = mysqli_query($con,"delete from card where C_NO='".$_GET['del_id']."'"); //for deleting status

if($del){?>

                       <script>

						alert("Card deleted sucessfully");

						window.location= "mg_card.php";

						</script>

<?php  }

if(!$del){?>

                       <script>

						alert("Card  Not deleted sucessfully");

						window.location= "mg_card.php";

						</script>

<?php  }   



} 

?>











<!DOCTYPE html>

<html>

<head>

<meta charset="utf-8">

<meta name="viewport" content="width=device-width, initial-scale=1">

<title>Admin Panel</title>



<link href="css/bootstrap.min.css" rel="stylesheet">

<link href="css/datepicker3.css" rel="stylesheet">

<link href="css/styles.css" rel="stylesheet">


<link href="css/bootstrap-table.css" rel="stylesheet">

<!--[if lt IE 9]>

<script src="js/html5shiv.js"></script>

<script src="js/respond.min.js"></script>

<![endif]-->



</head>

    <script type="text/javascript" src="js/tinymce/tinymce.min.js"></script>

    <script type="text/javascript">

    tinymce.init({

        selector: "textarea",

        themes: "modern",   

		forced_root_block : 'p'
		
        plugins: [

            "advlist autolink lists link image charmap print preview anchor",

            "searchreplace visualblocks code fullscreen",

            "insertdatetime media table contextmenu paste"

        ],

        toolbar: "insertfile undo redo | styleselect | bold italic | alignleft aligncenter alignright alignjustify | bullist numlist outdent indent | link image"   
 
    });


    </script>
<script>
function cust(cid){
var cid1 = (escape(cid));
 $.ajax({
  type: "GET",
  url: "get_cust.php?cid="+cid1,
    success: function(result){
     $("#custid").html(result);
  }

});
 

}
</script>

<body>

		<nav class="navbar navbar-inverse navbar-fixed-top" role="navigation">
		<div class="container-fluid">
			<div class="navbar-header">
				<a href="#"><button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#sidebar-collapse">
					<span class="sr-only">Toggle navigation</span>
					<span class="icon-bar"></span>
					<span class="icon-bar"></span>
					<span class="icon-bar"></span>
				</button>
				</a>
				<a class="navbar-brand" href="#"><img src="../images/logo/thoa.png" style="width:50px;height:50px;margin-top:-10px;">&nbsp;&nbsp;&nbsp;<b>THOA Menu</b></a>
				<ul class="user-menu">
					<li class="dropdown pull-right">
						<a href="#" class="dropdown-toggle" data-toggle="dropdown"><img src="../images/team/6.jpg" style="border-radius:40%;width:35px;height:35px;"> MR. N.AHAMED THAMBI<span class="caret"></span></a>
						<ul class="dropdown-menu" role="menu">
							<li><a href="logou.php" style="color:red;"><span class="glyphicon glyphicon-off"></span>  Logout</a></li>
						</ul>
					</li>
				</ul>
			</div>
		</div><!-- /.container-fluid -->
	</nav>

		

	<div id="sidebar-collapse" class="col-sm-3 col-lg-2 sidebar">
		<form role="search">
			<div class="form-group">
				<input type="text" class="form-control" placeholder="Search">
			</div>
		</form>
	 <?php  include('header.php');?>  
	</div><!--/.sidebar-->
		
	<div class="col-sm-9 col-sm-offset-3 col-lg-10 col-lg-offset-2 main">			
		<div class="row">
			<ol class="breadcrumb">
				<li><a href="dash.php"><span class="glyphicon glyphicon-home"></span></a></li>

				<li class="active">Manage ID card Generation</li>

			</ol>

		</div><!--/.row-->

		



		<section class="content">

		<div class="row">

			<div class="col-lg-12">

				<h2 class="page-header view1">To generate card</h2>

			</div>

		</div><!--/.row-->
          <div class="row">

            <!-- left column -->

            <div class="col-xs-12">

              <!-- general form elements -->

              <div class="box box-primary">



                <!-- form start -->

				<div class="container">

<form role="form" method="post" action="../fpdf/id1.php" enctype="multipart/form-data" >




					<div class="form-group col-sm-11">

                      <label for="exampleInputFile">Memeber card</label>

<?php  if($datab['C_IMG']) {?>

	               



                      <label for="exampleInputFile" style="float:right;"><a href="mg_card.php"><img src="back.png" width="40px" > Back to card Form</a></label>



					

					 <iframe src="../fpdf/card-<?php  echo $datab['C_NO'];?>.pdf" width="100%" style="height:100%;min-height:500px;"></iframe>
					 <?php  //$str = ltrim($data['AP_BILL'], 'New'); if($str){?>
					 
		<!--			 <iframe src="../fpdf/<?php // echo $str;?>" width="100%" style="height:100%"></iframe>		 
					php} -->
<?php  } ?>
					</div>



					<div class="form-group col-sm-6">

                   <label for="exampleInputEmail1">Year:</label>

				<select class="form-control" id="year" name="year">
<?php  if($C_NO) {?>
					<option value="<?php  echo $datab['C_YR'];?>"><?php  echo $datab['C_YR'];?></option>	
					<?php  
				$queryear=mysqli_query($con,"select *  from year ORDER BY Y_LIST DESC");
				while($rowyear=mysqli_fetch_array($queryear)) {?>
					<option value="<?php  echo $rowyear['Y_LIST'];?>"><?php  echo $rowyear['Y_LIST'];?></option>

 				
<?php  } } else {?>					
				
					<?php  
				$queryear=mysqli_query($con,"select *  from year ORDER BY Y_LIST DESC");
				while($rowyear=mysqli_fetch_array($queryear)) {?>
					<option value='<?php  echo $rowyear['Y_LIST'];?>'<?php  if($rowyear['Y_LIST']=='2022') echo ' selected'; ?>><?php  echo $rowyear['Y_LIST'];?></option>
				<?php  }}?> 
				</select>		

                    </div>

	


<?php  if($AP_ID)					
{?>
					<div class="form-group col-sm-10">

                    <label for="exampleInputEmail1">Company Name:</label>
                    <textarea class="form-control" rows="1" id="comname" name="comname"><?php  echo $datab['COM_NAME']; ?></textarea>

                    </div>
					
					<div class="form-group col-sm-10">

                    <label for="exampleInputEmail1">Munazzam No:</label>
                    <textarea class="form-control" rows="1" id="craq" name="craq"><?php  echo $datab['C_RAQ']; ?></textarea>
                    <input type="hidden" name="cno" value="<?php  echo $datab['C_NO'];?>">
                    </div>							
	
					
					<div class="form-group col-sm-10">

                    <label for="exampleInputEmail1">Membership No:</label>
                    <textarea class="form-control" rows="1" id="cmem" name="cmem"><?php  echo $datab['C_MEM']; ?></textarea>
                    </div>	
					<div class="form-group col-sm-10">

                    <label for="exampleInputEmail1">Member Since:</label>
	<?php  if($datab['C_SIN']){?>
		
	                <input type="text" class="form-control" id="csin" name="csin" value="<?php  echo $datab['C_SIN']; ?>">

	<?php  } else {?>
                    <input type="text" class="form-control" id="csin" name="csin" value="2000">
	<?php  }?>					
                    </div>		


					<div class="form-group col-sm-10">

                    <label for="exampleInputEmail1">Name:</label>
                    <textarea class="form-control" rows="1" id="cname" name="cname"><?php  echo $datab['C_NAME']; ?></textarea>

                    </div>						
					
					<div class="form-group col-sm-10">

                    <label for="exampleInputEmail1">Designation:</label>
                    <textarea class="form-control" rows="1" id="cdes" name="cdes"><?php  echo $datab['C_DES']; ?></textarea>

                    </div>							
	
<?php }	else
	{
?>
					<div class="form-group col-sm-10">

                    <label for="exampleInputEmail1">Company Name:</label>

					<select class="form-control" onclick="cust(this.value);"  id="comname" name="comname" required> 	
					<option value="">Select</option>
				<?php 	$querys=mysqli_query($con,"select *  from list GROUP BY ME_NAME ORDER BY ME_NAME ASC");
					while($rows=mysqli_fetch_array($querys)) {?>							
				<option value="<?php  echo $rows['ME_NAME'];?>"><?php  echo $rows['ME_NAME'];?></option>    
						 <?php  }?>					
					</select>					
					
                    </div>
					
					<div  id="custid">
					</div>
<?php 	}?>

					
					<div class="form-group col-sm-10">

                    <label for="exampleInputEmail1">Valid Upto:</label>
	<?php  if($datab['C_VAL']){?>
		
	                <input type="date" class="form-control" id="cval" name="cval" value="<?php  echo $datab['C_VAL']; ?>">

	<?php  } else {?>
                    <input type="date" class="form-control" id="cval" name="cval" value="2022-03-31">
	<?php  }?>					
                    </div>				
					
					
					<div class="form-group  col-sm-11">
					<label for="exampleInputFile">Passport size photograph:</label><br>

					<input type="file" name="cimg" id="exampleInputFile">
					<?php  if($datab['C_IMG']){?>
					<img src = "../fpdf/images/card/<?php  echo $datab['C_IMG'];?>" height="100" width="100"></img>
					<?php  }?>
					 <input type="hidden" name="cimg1" value="<?php  echo $datab['C_IMG'];?>">

					
					<label for="exampleInputFile">(Size:5 MB Max, Format:.jpg)</label>
					</div>
					
				 
					<div class="box-footer col-sm-10">

                    <button type="submit" name="submit" value="submit" class="btn btn-primary">Click here for id card</button>
<hr>
<br>
                    </div>

	</form>

		</div>

</div>

</div>

</div>

</section>

<hr>

		<div class="row" >

			<div class="col-lg-12">

				<div class="panel panel-default">

					<div class="panel-heading view1">Membership card generate Table</div>

					<div class="container">			
					<?php  
					$queryear=mysqli_query($con,"select *  from year ORDER BY Y_LIST DESC");
					while($rowyear=mysqli_fetch_array($queryear)) {?>		
					
					<div class="box">
					<div class="top">
					<?php  echo $yr=$rowyear['Y_LIST'];?>
					</div>
					<hr>						


		              <div class="panel-body bottom">			


	
	
			
						<table data-toggle="table"  data-show-refresh="true" data-show-toggle="true" data-show-columns="true" data-search="true" data-select-item-name="toolbar1" data-pagination="true" data-sort-name="name" data-sort-order="desc"> <thead>

						    <tr>

						        <th data-field="state" data-checkbox="true" >Item ID</th>

						        <th data-field="itid" data-sortable="false">Item ID</th>

						        <th data-field="ano"  data-sortable="true">Members Name</th>

								<th data-field="aname"  data-sortable="true">Company Name</th>
								
								<th data-field="astatus" data-sortable="true">To view/generate</th>

						    </tr>

						    </thead>

							<tbody>

							<?php  

							

                            $table = mysqli_query($con,"select * from card WHERE C_YR='$yr' ORDER BY C_NO DESC");

							$C_NO=1;

							while($row=mysqli_fetch_array($table))

							{

							?>

							   <tr> <td></td>

							   <td><?php  echo $C_NO;?></td>

							   <td><?php  echo $row['C_NAME'];?></td>

							   <td><?php  echo $row['COM_NAME'];?></td>							   

							   <td><a href= "mg_card.php?AP_ID=<?php  echo $row['C_NO'];?>">Select </a>/<a href="#" onclick="del(<?php  echo $row['C_NO'];?>)"> Delete </a> </td>

							   </tr>


                            <?php 

							  $C_NO++;

							 }?>

							</tbody>


						</table>
					
					
					
					
					</div>
					
					
					</div>
					<?php  } ?>
					
					</div>						
					
					
					

				</div>

			</div>

		</div>

		

 	

	</div>	<!--/.main-->



	<script src="js/jquery-1.11.1.min.js"></script>

	<script src="js/bootstrap.min.js"></script>

	<script src="js/chart.min.js"></script>

	<script src="js/chart-data.js"></script>

	<script src="js/easypiechart.js"></script>

	<script src="js/easypiechart-data.js"></script>

	<script src="js/bootstrap-datepicker.js"></script>

	<script src="js/bootstrap-table.js"></script>

	<script>
	$(document).ready(function() {
    $('ul.subcat').hide();

    $('li').click(function(event) {
        event.stopPropagation();
        $('> ul', this).toggle();

    });
});
	</script>
	<script>
$('.top').on('click', function() {
	$parent_box = $(this).closest('.box');
	$parent_box.siblings().find('.bottom').hide();
	$parent_box.find('.bottom').toggle();
});
$('.top1').on('click', function() {
	$parent_box = $(this).closest('.box1');
	$parent_box.siblings().find('.bottom1').hide();
	$parent_box.find('.bottom1').toggle();
});

 $("#cyes").hide();

 function extra(val){
 
 if(val == 'DD')
 {
  $("#cyes").show(); 
 }
 else if(val == 'Cheque')
 {
  $("#cyes").show(); 	 
 }
  else if(val == 'RTGS')
 {
  $("#cyes").show(); 	 
 }
 else if(val != 'no'){
 $("#cyes").hide();
 } 
 }
</script>
<style>
.container .box1 .top1 {
  padding: 12px;
  background-color: blue;
  color: white;
  cursor: pointer;
}

.container .box1 .bottom1 {

  display: none;
}
.container .box .top {
  padding: 12px;
  background-color: blue;
  color: white;
  cursor: pointer;
}

.container .box .bottom {

  display: none;
}

@media (min-width: 501px) and (max-width: 2000px){
.container .box {
width:auto;
max-width:900px;
}
.container .box1 {
width:auto;
max-width:900px;
}

}

@media (min-width: 5px) and (max-width: 500px){
.container .box {
width:100%;
max-width:350px;
}

.container .box1 {
width:100%;
max-width:350px;
}
.view1
{
font-size:14px;	
font-weight: bold;
text-decoration: underline;
}
}
</style>
</body>



</html>
<script>											// for deleteing confirm

function del(id){

 var del = confirm("Are you sure Want to delete");

  if(del){

  window.location.href = "mg_card.php?del_id="+id+"&del=1";

  }

  else{

  window.location.href = "mg_card.php";

  }

}

</script>

	<?php  } else
	{

$queryu=mysqli_query($con,"select * from admin where ID='1'");
$rowu=mysqli_fetch_array($queryu); 		
		
if($rowu)
{
$rowu['A_LOG'];	
$log = $rowu['A_LOG'] - 1;
$upd_sts =  mysqli_query($con,"UPDATE admin SET A_LOG ='$log' where ID='1'"); 
}		
		
header("Location: home.php");
	}
?>