MAINHACK

Viewing / Editing File: add_expense.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(){
    $("input[type='radio']").on('click', function(){
    var radioValue = $("input[name='type']:checked").val();
    if(radioValue=='New'){
        
        $('#new').show();
        $('#exist').hide();
        
    }else{
        $('#exist').show();
        $('#new').hide();
    }
    });
});
function fill(Value1,Value2,Value3,Value4,Value5,Value6,Value7,Value8,Value9,Value10)
{
$('#project_id').val(Value1);
$('#pro_name').val(Value2);
$('#client_id').val(Value3);
$('#name').val(Value4);
$('#phn').val(Value5);
$('#cost').val(Value8);
$('#p_status').val(Value9);
$('#p_due').val(Value10);
$('#display').hide();
show(Value1);
    
}

$(document).ready(function(){
$("#project_id").keyup(function() {
var fli = $('#project_id').val();

//alert(fli);
if(fli=="")
{
$("#display").html("");
}
else
{
$.ajax({
type: "POST",
url: "ajax_check.php",
data: "project_id="+ fli ,
beforeSend: function() {
$("#load").show();
},
success: function(html){
$("#display").html(html).show();
$("#load").hide();

}
});
}
});
});

$(document).ready(function(){
            // Add more
            $('#addmore').click(function(){
                // Get last id 
                var lastname_id = $('.tr_input input[type=text]').last().attr('id');
                var split_id = lastname_id.split('_');
                // New index
                var index = Number(split_id[1]) + 1;
		        document.getElementById('getid').value=index;
		        //alert(split_id);
                // Create row with input elements
                 var html = "<div class='tr_input'><div class='col-md-12'><div class='col-md-4'><select name='category[]' id='cate"+index+"' onchange='check()' required class='form-control'><option value=''>Choose</option><?php $stmt=$show->state('job');$r=$stmt->rowCount(); if($r>0){while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){echo "<option value='".$row['job_id'].":".$row['title']."'>".$row['title']."</option>";}}?> </select></div><div class='col-md-6'><input type='hidden' class='form-control' id='title"+index+"'  name='title[]' placeholder='Product des'><input type='text' class='form-control' id='testcode_"+index+"'  name='des[]' placeholder='Product des'></div><div class='col-md-2'><a href='javascript:void(0);' id='remove_field'  class='remCF btn btn-info' >-</a></div></div></div>";
                // Append data
                $('#tab').append(html);
            });
			
                $("#tab").on('click','.remCF',function(){
                $(this).parent().parent().remove();
	        	var lastname_id = document.getElementById('getid').value;
		        //alert(lastname_id);
                // New index
                var index = lastname_id - 1;
                // Create row with input elements
				document.getElementById('getid').value=index;
    });
        });
function check(){
var id=document.getElementById('getid').value;
var c="#cate"+id;
var c_val=$(c).val();
var category=c_val.split(':');

var des='#testcode_'+id;
var title='#title'+id;

//alert(title);
//var a;
 $.ajax({
type: "POST",
url: "ajax_check.php",
data: "category="+ category[0]+"&id="+id ,
beforeSend: function() {
$("#load").show();
},
success: function(data){

var t_val=$(title).val(category[1]);

$(des).val(data);

}
});
}
function pay(){

var total=$("#p_due").val();
    var amt=$("#amt").val();
    var gst=$("#gst").val();
    var gst_amt=gst/100;
    var paid_amt=parseFloat(amt*gst_amt)+Number(amt);
    var due=Number(total)-Number(paid_amt);
    due=due.toFixed(2);
    $("#total").val(paid_amt);
    $("#due").val(due);

}
function show(Value){
 $.ajax({
type: "POST",
url: "ajax_check.php",
data: "project_id_show="+ Value ,
beforeSend: function() {
$("#load").show();
},
success: function(html){
$("#payment_details").html(html).show();
}
});
}
</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>Add Expense:</h4>
						</div>
						<div class="form-body">
							<form method="post"  enctype="multipart/form-data"> 
						 <div class="col-md-3">
								<div class="form-group">
									<label>Expense Group</label>
                            <select name="exp_group"  class="form-control" required>
									    <option value="">Choose</option>
									 <?php 
									 $stmt=$show->state('expense_group');
									 $r=$stmt->rowCount();
									 if($r>0){
                                     while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
									    echo "<option value='".$row['ep_group']."'>".$row['ep_group']."</option>";
    									}
    									}
									 ?>   
									</select>								</div>
							</div>	  
							  <div class="col-md-3">
								<div class="form-group">
									<label>Expense Head</label>
                            <select name="expense_head"  class="form-control" required>
									    <option value="">Choose</option>
									 <?php 
									 $stmt=$show->state('expense_head');
									 $r=$stmt->rowCount();
									 if($r>0){
                                     while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
									    echo "<option value='".$row['category']."'>".$row['category']."</option>";
    									}
    									}
									 ?>   
									</select>								</div>
							</div>	  
							
						        <div class="col-md-2">
								<div class="form-group">
									<label for="exampleInputEmail1">Add Amount</label>
									<input type="text" class="form-control" id="amt"  name="amount" placeholder="Add Amount">
								</div>
							</div>
						       
						
							 <div class="col-md-2">
								<div class="form-group">
									<label for="exampleInputEmail1">Expense Date</label>
									<input type="text" class="form-control" id="date" name="date" placeholder="Expense Date">
								</div>
							</div>
							
	                        <div class="col-md-6">
							<div class="form-group">
							<label>Remarks</label>
						   <input type="text" class="form-control" id="" name="remark" placeholder="Remark">

</div>	
							</div>
							
							</div>
						<div class="col-md-2"><button type="submit" class="btn btn-info btn-fill pull-right" name="sub">Submit</button></div>

<div class="clearfix"></div>
                                    </form>
<?php
if(isset($_POST['sub'])){
	
  	$table='payment';
	$data=array(	
	'amount'=>$_POST['amount'],
	'total'=>$_POST['amount'],
	'date'=>date('Y-m-d',strtotime($_POST['date'])),
	'entry_date'=>date('Y-m-d'),
	'remarks'=>$_POST['remark'],
	'type'=>'OUT',
	'expense_head'=>$_POST['expense_head'],
	'exp_group'=>$_POST['exp_group'],
	);
    $r=$show->insert($table,$data);

if($r){

echo "<script>sweetAlert('OK','New Expense has been done','success');window.location.href='".$_SERVER['REQUEST_URI']."'</script>";
}   
	
}
?>
									
                                </div>
                            </div>
                            </div>
                            </div>
                          </div>
         
<?php include 'footer.php' ?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: add_expense.php

Server Info

System Features

User Info