|
Server IP : 103.191.208.50 / Your IP : 216.73.216.53 Web Server : LiteSpeed System : Linux orion.herosite.pro 4.18.0-553.53.1.lve.el8.x86_64 #1 SMP Wed May 28 17:01:02 UTC 2025 x86_64 User : celkcksm ( 1031) PHP Version : 7.4.33 Disable Function : show_source, system, shell_exec, passthru, popen, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0750) : /home/celkcksm/websites/vtti.e-campus.co.in/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include ("include/makeSession.php");
$installment_id=mysqli_query($con,"select * from admin where id='".$_SESSION["ecomid"]."'");
$installment_id=mysqli_fetch_array($installment_id);
$installment_id=$installment_id['menuper'];
$menuper=explode(',',$installment_id);
if(in_array('Master Setting',$menuper)){
}else{
header("location:index.php");
}
$_SESSION['page_name']="Stock";
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 stockadd where id='$doid'");
echo '<META HTTP-EQUIV="Refresh" Content="0; URL=stockadd.php">';
exit;
}
if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){
$dovalue="stockadd";
$doid=$_REQUEST['upid'];
$upuserresult=mysqli_query($con,"select * from stockadd where id='".$_REQUEST['upid']."'");
$upuserarr=mysqli_fetch_array($upuserresult);
//print_r($upuserarr);
}else{
$dovalue="stockadd";
$doid='';
}
?>
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<h1> Stock Add <small></small> </h1>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
<li><a href="#">Stock Add</a></li>
</ol>
</section>
<!-- Main content -->
<section class="content">
<div class="row">
<div class="col-md-12">
<div class="box box-info">
<div class="box-header">
<h3 class="box-title"> Stock Add <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">
<?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">×</a>
'.$msg.'
</div>'; $_SESSION["msg"]='';} ?>
<form method="post" action="action3.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;?>" />
<input type="hidden" name="UserID" value="<?php echo $_SESSION["ecomid"];?>" />
<!-- text input -->
<div class="form-group">
<label> Name</label>
<input name="name" type="text" id="ContentPlaceHolder1_txt_subtitle" class="form-control" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['name'];}?>"
placeholder="Name">
</div>
<div class="form-group">
<label> Categroy</label>
<select name="category" id="category" class="form-control subject" required>
<option value=''>-select-</option>
<?php $CasteQuery=mysqli_query($con,"select * from stockcategry");
while($CasteRow=mysqli_fetch_array($CasteQuery)){
echo '<option value="'.$CasteRow['id'].'" '.($upuserarr['category'] == $CasteRow['id'] ? 'selected="selected"' : '' ).' >'.$CasteRow['name'].'</option>';
} ?>
</select>
</div>
<div class="form-group">
<label> Stock Head</label>
<select name="stockhead" id="stockhead" class="form-control subject" required>
<option value=''>-select-</option>
</select>
</div>
<div class="form-group">
<label> Quantity</label>
<input name="quantity" type="number" id="quantity" class="form-control" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['quantity'];}?>"
placeholder="Quantity" required>
</div>
<div class="form-group">
<label> Price</label>
<input name="price" type="number" id="price" step="any" class="form-control" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['price'];}?>"
placeholder="Price" required>
</div>
<div class="form-group">
<label> Amount</label>
<input name="amount" type="number" id="amount" step="any" class="form-control" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['amount'];}?>"
placeholder="Amount">
</div>
<div class="form-group">
<label> Purchase Date</label>
<input name="purchase_date" type="date" id="purchase_date" class="form-control" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['purchase_date'];}else{ echo date("d-m-Y");}?>"
placeholder="Amount">
</div>
<div class="row" id="bill">
<div class="col-md-6">
<div class="form-group">
<label for="bill" class="col-sm-6 control-label">Bill:</label>
<input type="file" name="bill" />
</div>
</div>
<div class="col-md-6">
<?php if(isset($_REQUEST['upid'])){ ?>
<img src="images/StudentEnquiry/<?php echo $upuserarr['bill']; ?>" height="70" width="70"/>
<?php } ?>
</div>
</div>
<div class="form-group">
<label>Description</label>
<textarea class="form-control" name="description" ><?php if(isset($_REQUEST['upid'])){ echo $upuserarr['description'];}?></textarea>
</div>
<div class="box-footer">
<input type="submit" class="btn btn-primary" name="ctl00$ContentPlaceHolder1$btnsave" value="Save"/>
<input type="reset" name="ctl00$ContentPlaceHolder1$btn_reset" value="Reset" id="ContentPlaceHolder1_btn_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">REPORT</h3>
</div>
<!-- /.box-header -->
<div class="box-body">
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th>No</th>
<th scope="col">Stock Name</th>
<th scope="col">Category Name</th>
<th scope="col">Stock Head</th>
<th scope="col">Quantity</th>
<th scope="col">Price</th>
<th scope="col">Amount</th>
<th scope="col">Purchase Date</th>
<th scope="col">Description</th>
<th scope="col">Action </th>
</tr>
</thead>
<tbody>
<?php $Query=mysqli_query($con,"select *,stockadd.name as c_name,stockadd.id as ids,stockhead.name as name,stockcategry.name as st_name from
stockadd left join stockcategry on stockadd.category=stockcategry.id
left join stockhead on stockadd.subcategory=stockhead.id");
$i = 1;
while($Row=mysqli_fetch_array($Query)){ ?>
<tr>
<td><?php echo $i; ?></td>
<td><?=$Row['c_name'];?></td>
<td><?=$Row['st_name'];?></td>
<td><?=$Row['name'];?></td>
<td><?=$Row['quantity'];?></td>
<td><?=$Row['price'];?></td>
<td><?=$Row['amount'];?></td>
<td><?=$Row['purchase_date'];?></td>
<td><?=$Row['description'];?></td>
<td><a href="?upid=<?php echo $Row["ids"]; ?>"><i class="fa fa-pencil text-yellow"></i></a> <a href="?did=<?php echo $Row["ids"]; ?>" onclick="return confirm_click();"><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>
var htmls='';
$('#stockhead').html('');
var course=$('#category :selected').val();
$.ajax({
type: "POST",
url: "stockheadjson.php",
data: {'course': course},
dataType: "json",
success: function(dataString) {
$.each(dataString, function(key,valv) {
htmls+= "<option value='"+ valv.id +"'>" + valv.name + "</option>";
});
$('#stockhead').append(htmls);
}
});
$('#category').on('change',function(){
var htmls='';
$('#stockhead').html('');
var course=$('#category :selected').val();
$.ajax({
type: "POST",
url: "stockheadjson.php",
data: {'course': course},
dataType: "json",
success: function(dataString) {
$.each(dataString, function(key,valv) {
htmls+= "<option value='"+ valv.id +"'>" + valv.name + "</option>";
});
$('#stockhead').append(htmls);
}
});
});
$('#price').on('blur',function(){
$('#amount').val('');
var price=$('#price').val();
var quantity=parseInt($('#quantity').val());
var amount=price*quantity;
//alert(price);
$('#amount').val(amount);
});
</script>
<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="bootstrap/js/dataTables.buttons.min.js" type="text/javascript"></script>
<script src="bootstrap/js/jszip.min.js" type="text/javascript"></script>
<script src="bootstrap/js/pdfmake.min.js" type="text/javascript"></script>
<script src="bootstrap/js/vfs_fonts.js" type="text/javascript"></script>
<script src="bootstrap/js/buttons.html5.min.js" type="text/javascript"></script>
<script src="bootstrap/js/buttons.print.min.js" type="text/javascript"></script>
<script src="bootstrap/js/buttons.colVis.min.js" type="text/javascript"></script>
<script src="bootstrap/js/buttons.flash.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
$('#example1').DataTable( {
dom: 'Bfrtip',
columnDefs: [
{
targets: 1,
className: 'noVis'
}
],
buttons: [
{
extend: 'colvis',
columns: ':not(.noVis)'
}
],
buttons: [
{ extend: 'colvis', text: 'COLOUMNS' },
{ extend: 'csv', text: 'Export to CSV' },
{ extend: 'excel', text: 'Export to Excel' },
{ extend: 'pdfHtml5', text: 'Create PDF', orientation: 'landscape', exportOptions: { columns: ':visible' } },
{ extend: 'print', text: 'Print', exportOptions:{columns: ':visible',autoPrint: true}}
],
} );
} );
//$(function () {
//$("#example1").DataTable();
//});
</script>