MAINHACK

Viewing / Editing File: generate_report.php

<?php include 'header.php' ;

$show=new Oops($db);
?>
<style type="text/css">

#fli,#fli1
	{
	
	}
	#display
	{
		position:absolute;
		width:315px;
		margin-left:0;
		margin-top:0px;
		max-height:300px;
		padding:2px;
		display:none;
		border-top:0px;
		overflow:auto;
		border:1px #CCC solid;
		background-color: white;
		z-index:1000;
	}	
	
	.show,.show1
	{
		padding:7px; 
		border-bottom:1px #999 dashed;
		font-size:15px; 
		
	}
	
	.show:hover,.show1:hover
	{
		background:#4f52ba;
		color:#FFF;
		cursor:pointer;
	}	
.widget{
	overflow:visible !important;
	
}	
</style>
<script>
$(document).ready(function(){
$('#site').change(function(){
var site = $('#site').val();
var site_id=site.split("-");
$.ajax({
type: "POST",
url: "ajax_check.php",
data: "siteid="+ site_id[0],   
beforeSend: function() {
$("#load").show();
},
success: function(html){
$('#show').html(html);

}
});
});
});
$(document).ready(function(){
$('#table').change(function(){
var table = $('#table').val();
if(table=='product' || table=='machine')
$('#site').hide();
else
$('#site').show();

$.ajax({
type: "POST",
url: "ajax_check.php",
data: "table="+ table,   
beforeSend: function() {
$("#load").show();
},
success: function(html){
$('#columns').html(html);

}
});
});
});

</script>
      	<div id="page-wrapper">
			<div class="main-page">
				<div class="row">
                        <div class="form-grids row widget-shadow" data-example-id="basic-forms"> 
						<div class="form-title">
							<h4>Generate report :</h4>
						</div>
						<div class="form-body">
							<form method="post" action="excel/report.php" enctype="multipart/form-data"> 
								<div class="col-md-2">
								<div class="form-group">
									<label>Table</label>
	                        <select name="table" id="table" required class="form-control">
									    <option value="">Choose</option>
									    <option value="employee">Employee</option>
									    <option value="labour">Labour</option>
									    <option value="machine">Machine</option>
									    <option value="product">Product</option>
									    <option value="alloted_product">Alloted Product</option>
									    <option value="alloted_machine">Alloted Machine</option>
									    <option value="petty_cash">Petty Cash</option>
									    <option value="stock">All Product In/Out</option>
									
									    
									</select>								
									</div>
							</div>
						 <div id="columns" class="col-md-4"></div>

<div class="col-md-4" id="site">
								<div class="form-group">
									<label>Site</label>
                        	<select name="site_id"  class="form-control">
									    <option value="">Choose</option>
									 <?php 
									 $stmt=$show->readAll('site');
									 $r=$stmt->rowCount();
									 if($r>0){
                                     while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
									    echo "<option value='".$row['site_id']."'>".$row['site_name']."</option>";
    									}
    									}
									 ?>   
									    
									</select>
									</div>
							</div>	
						
							<div class="col-md-4" id="site">
								<div class="form-group">
									<label>Date Range:</label>
                        		<label>From</label>
								<input type="text" class="form-control"  name="from_date" id="date" placeholder="From Date" >
								<label>To</label>
								<input type="text" class="form-control"  name="to_date" id="date1" placeholder="To Date" >
									</div>
							</div>	
							
<script>// Material Select Initialization
/*$(document).ready(function() {
$('.mdb-select').materialSelect();
});*/</script>							
 
						<button type="submit" class="btn btn-info btn-fill pull-right" name="export">Submit</button>
						<div class="clearfix"></div>
                                    </form>

</div>
                            </div>
                            </div>
                            </div>
                          </div>
         
<?php include 'footer.php' ?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: generate_report.php

Server Info

System Features

User Info