MAINHACK

Viewing / Editing File: add_payment_in.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,Value11,Value12)
{
$('#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);
$('#p_gst').val(Value11);
$('#cost_total').val(Value12);

$('#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>Payment IN:</h4>
						</div>
						<div class="form-body">
							<form method="post"  enctype="multipart/form-data"> 
							
							<div id="exist" style="">
							<div class="col-md-3">
								<div class="form-group">
									<label>Project Name/ ID</label>   
							<input type="text" class="form-control" id="project_id" name="project_id" placeholder="Project Name/ ID">
							<div id="display"></div> 
							</div>	</div>
							<div class="col-md-6">
								<div class="form-group">
									<label>Project Name </label>
									<input type="text" class="form-control" id="pro_name" name="com_name" placeholder="Project Name" readonly>
								</div>
							</div>
						
							<div class="col-md-3">
						    <div class="form-group">
							<label>Project Cost(withour GST)</label>   
							<input type="text" class="form-control" id="cost" name="cost" placeholder="Project Cost" readonly>
							</div>	
							</div>
							<div class="col-md-3">
						    <div class="form-group">
							<label>Project Gst(%)</label>   
							<input type="text" class="form-control" id="p_gst" name="p_gst" placeholder="Project Gst" readonly>
							</div>	
							</div>
								<div class="col-md-3">
						    <div class="form-group">
							<label>Project Total(With Gst)</label>   
							<input type="text" class="form-control" id="cost_total" name="p_total" placeholder="Project Total(With Gst)" readonly>
							</div>	
							</div>
								<div class="col-md-3">
						    <div class="form-group">
							<label><font color="red">Project Due</font></label>   
							<input type="text" class="form-control" id="p_due" name="p_due" placeholder="Project Due" readonly>
							</div>	
							</div>
						<!--	<div class="col-md-3">
						    <div class="form-group">
							<label>Project status</label>  
							<?php	$option = array(  'OPEN','CLOSED' );
?>			<select name="project_status" id="p_status"class="form-control" required><option value="">Choose</option>

</select>
						
							</div>	
							</div>-->
							<div class="col-md-3">
								<div class="form-group">
									<label for="exampleInputEmail1">Client ID</label>
									<input type="text" class="form-control" id="client_id" name="client_id" placeholder="Client ID" readonly>
								</div>
							</div>
							<div class="col-md-3">
								<div class="form-group">
									<label for="exampleInputEmail1">Client Name</label>
									<input type="text" class="form-control" id="name" name="name" placeholder="Client Name" readonly>
								</div>
							</div>
							<div class="col-md-3">
								<div class="form-group">
									<label for="exampleInputEmail1">Client Phone</label>
									<input type="text" class="form-control" id="phn" name="phone" placeholder="Client Phone" readonly>
								</div>
							</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">GST</label>
									<input type="text" class="form-control" onkeyup="pay()" id="gst"  name="gst" placeholder="GST in No without %">
								</div>
							</div>
							 <div class="col-md-3">
								<div class="form-group">
									<label for="exampleInputEmail1">Total</label>
									<input type="text" class="form-control" id="total"  name="total" placeholder="Total" readonly>
								</div>
							</div>
							 <div class="col-md-2">
								<div class="form-group">
									<label for="exampleInputEmail1">Payment Date</label>
									<input type="text" class="form-control" id="date" name="date" placeholder="Payment Date" required>
								</div>
							</div>
							<div class="col-md-2">
							<div class="form-group">
							<label>Payment Type</label>
                            <select name="payment_type" id="payment_type" class="form-control">
                            <option value="">Payment Type</option>
                            <option value="Credit">Credit</option>
                            <option value="Cash">Cash</option>
                             <option value="To Pay">To Pay</option>
                           </select></div>
                            
							</div>	    
								
							<div class="col-md-4">
							<div class="form-group">
							<label>Due</label>
						   <input type="text" class="form-control" id="due" name="due" placeholder="Due" readonly>

</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(	
	'project_id'=>$_POST['project_id'],
	'client_id'=>$_POST['client_id'],
	'name'=>$_POST['name'],
	'phone'=>$_POST['phone'],
	'amount'=>$_POST['amount'],
	'gst'=>$_POST['gst'],
	'total'=>$_POST['total'],
	'date'=>date('Y-m-d',strtotime($_POST['date'])),
	'payment_type'=>$_POST['payment_type'],
	'entry_date'=>date('Y-m-d'),
	'remarks'=>$_POST['remark'],
	'type'=>'IN',
	);
    $r=$show->insert($table,$data);  
$sq="update project set due='".trim($_POST['due'])."' where project_id='".trim($_POST['project_id'])."'";
$r1=$con->prepare($sq);
if($r1->execute() && $r){

echo "<script>sweetAlert('OK','New Deposit 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_payment_in.php

Server Info

System Features

User Info