|
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/bengaledu.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('Manage Payrool',$menuper)){
}else{
header("location:index.php");
}
$_SESSION['page_name']="Payroll Salary";
include('include/function.php');
include("include/header.php");
include("banktobalance.php");
include("include/sidebar.php");
if(isset($_REQUEST['did']) && $_REQUEST['did']!=''){
$dovalue="";
$doid=$_REQUEST['did'];
mysqli_query($con,"delete from employeesalarypayment where EmployeeSalaryPaymentID='$doid'");
echo '<META HTTP-EQUIV="Refresh" Content="0; URL=EmployeeSalaryPay.php">';
exit;
}
if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){
$dovalue="EditEmployeeSalaryPayment";
$doid=$_REQUEST['upid'];
$upuserresult=mysqli_query($con,"select * from employeesalarypayment where EmployeeSalaryPaymentID='".$_REQUEST['upid']."'");
$upuserarr=mysqli_fetch_array($upuserresult);
}else{
$dovalue="EmployeeSalaryPayment";
$doid='';
}
?>
<style>
table#t01 tr:nth-child(even) {
background-color: #eee;
}
table#t01 tr:nth-child(odd) {
background-color: #fff;
}
table#t01 th {
background-color: black;
color: white;
}
</style>
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<h1> Employee Salary <small></small> </h1>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
<li><a href="#">Employee Salary</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"> Employee Salary Payment <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-12">
<div class="col-md-12">
<form action="" method="post" >
<input type="text" name="mobile" placeholder="Search By Emp Id "
value="<?php if(!empty($_POST['mobile'])){ echo $_POST['mobile']; }else{ } ?>"
class="form-control col-md-3" style="width:300px;" />
<input type="submit" value="Search" class="btn btn-primary"/>
</div>
</form>
<?php
$mobile=$_POST['mobile'];
//echo $mobile;
if(!empty($mobile)){
$upuserresult1e=mysqli_query($con,"select * from employeeentryform where empid='".$mobile."' and resign='1'");
$upuserarr1=mysqli_fetch_array($upuserresult1e);
$upuserarr1dd=mysqli_num_rows($upuserresult1e);
if($upuserarr1dd>0){
$Query=mysqli_query($con,"select * from leaveemployee where empid='".$mobile."'
AND YEAR(created_at) = YEAR(CURRENT_DATE - INTERVAL 1 MONTH)
AND MONTH(created_at) = MONTH(CURRENT_DATE - INTERVAL 1 MONTH)");
$i = 1;
$leavecount=0;
while($Row=mysqli_fetch_array($Query)){
$leavecount=mysqli_query($con,"SELECT DATEDIFF('".$Row['end']."','".$Row['start']."')
");
$leavecount=mysqli_fetch_array($leavecount);
// print_r($leavecount);
$leavecounts=$leavecounts+$leavecount[0]+1;
}
// echo $leavecounts;
$holidays=mysqli_query($con,"select * from holiday where YEAR(created_at) = YEAR(CURRENT_DATE - INTERVAL 1 MONTH)
AND MONTH(created_at) = MONTH(CURRENT_DATE - INTERVAL 1 MONTH)");
$holis=0;
while($Holiday=mysqli_fetch_array($holidays)){
$holi=mysqli_query($con,"SELECT DATEDIFF('".$Holiday['holiday_end']."','".$Holiday['holiday_date']."')
");
$holi=mysqli_fetch_array($holi);
//print_r($leavecount);
$holis=$holis+$holi[0]+1;
}
// echo $leavecounts;
?>
<div class="form-group col-md-3">
<h3> Name :
<?php echo $upuserarr1['EmployeeName']."</h3>";?>
</div>
<div class="form-group col-md-3">
<h3> Basic Salary :
<?php
echo $upuserarr1['basic']."</h3>";
$oneday= $upuserarr1['basic']/30;
?>
</div>
<div class="form-group col-md-3">
<h3> Leaves :
<?php
echo $upuserarr1['EL']+$upuserarr1['Medical']."</h3>";
?>
</div> <br>
<!-- <div class="form-group col-md-3">
<h3> Casual :
<?php
// echo "1</h3>";?>
</div> -->
<!-- <div class="form-group col-md-3">
<h3> Holiday :
<?php
//echo $holis."</h3>";?>
</div > -->
<?php $allsalaryhead1=mysqli_query($con,"select * from employeesalaryhead");
$numrows=mysqli_num_rows($allsalaryhead1);
$basic=$upuserarr1['basic'];
$dedection=0;
$addtion=0;
$amountdedection=0;
$amountaddtion=0;
echo '<table id="t01" style="width: 200px;">';
echo '<tr><th>TYPE</th><th>Value</th></tr>';
while($allsalaryhead=mysqli_fetch_array($allsalaryhead1)){
?>
<?php echo "<tr><td>".$allsalaryhead['name']."</td>"; ?>
<?php
if($allsalaryhead['calculatetype']=='InPercent'){
$pf=$allsalaryhead['valuesd']*$basic/100;
echo "<td>".$pf."</td>";
if($allsalaryhead['type']=='Deduction')
{
$dedection=$dedection+$pf;
}if($allsalaryhead['type']=='Addition'){
$addtion=$addtion+$pf;
}
}
if($allsalaryhead['calculatetype']=='InAmount'){
echo "<td>".$allsalaryhead['valuesd']."</td></tr>";
if($allsalaryhead['type']=='Deduction')
{
$amountdedection=$allsalaryhead['valuesd'];
}if($allsalaryhead['type']=='Addition'){
$amountaddtion=$amountaddtion+$allsalaryhead['valuesd'];
}
}
?>
<?php } ?>
<?php
echo "</table>";
?>
<div class="form-group col-md-5">
<h3> Total Paid :<?php
$dedec=$dedection+$amountdedection;
//echo $amountdedection."<br>";
$addt=$addtion+$amountaddtion;
//echo $addt."<br>";
$total1=$basic+$addt-$dedec;
$lesssalary=$totalleavs*$oneday;
$total=$total1-$lesssalary;
echo $total1."</h3>";?>
</div>
<input type="hidden" name="amountoftotal" id="amountoftotal" value="<?php echo $total1; ?>"/>
<!--<div class="form-group col-md-5">
<h3> Total Paid :<?php
// echo round($total)."</h3>";?>
</div> -->
<?php } ?>
<br/> <br/> <br/> <br/>
<form method="post" action="action.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="EmployeeId" value="<?php echo $upuserarr1['empid'];?>" />
<input type="hidden" name="UserID" value="<?php echo $_SESSION["ecomid"];?>" />
<!-- text input -->
<div class="form-group col-md-3">
<label>Enter Month</label>
<select name="EnterMonth" class="form-control">
<option selected="selected" value="01">January</option>
<option value="02">February</option>
<option value="03">March</option>
<option value="04">April</option>
<option value="05">May</option>
<option value="06">June</option>
<option value="07">July</option>
<option value="08">August</option>
<option value="09">September</option>
<option value="10">October</option>
<option value="11">November</option>
<option value="12">December</option>
</select>
</div>
<div class="form-group col-md-3">
<label>Enter Year</label>
<select name="EnterYear" class="form-control">
<option selected="selected" value="2016">2016</option>
<option value="2017">2017</option>
<option value="2018">2018</option>
<option value="2019">2019</option>
<option value="2020">2020</option>
<option value="2021">2021</option>
</select>
</div>
<div class="form-group col-md-3">
<label>Leave days</label>
<input name="Latedays" type="text" class="form-control" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['Latedays'];}?>" placeholder="Enter Late days">
</div>
<div class="form-group col-md-3">
<label>Leave Deduction</label>
<input name="LateDeduction" type="text" class="form-control" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['LateDeduction'];}?>" id="lateded" placeholder="Enter Late Deduction" required>
</div>
<!-- <div class="form-group col-md-3">
<label>Extra Leaves</label>
<input name="ExtraLeaves" type="text" class="form-control" value="<?php //if(isset($_REQUEST['upid'])){ echo $upuserarr['ExtraLeaves'];}?>" placeholder="Enter Extra Leaves">
</div> -->
<?php
$upuserresultgs=mysqli_query($con,"select * from totalcash where id='1'");
$upuserresultgsf=mysqli_fetch_array($upuserresultgs);
?>
<input type="hidden" name="totalcash" value="<?php echo $upuserresultgsf['cash']; ?>" id="totalcashs" />
<input type="hidden" name="totalbank" id="totalbank" />
<div class="form-group col-md-3">
<label>Payment Mode</label>
<select name="PaymentMode" class="form-control" id="ContentPlaceHolder1_ddlPaymentMode" required>
<option value="">--Select--</option>
<option value="ByCash">ByCash</option>
<option value="ByCheque">ByCheque</option>
<!--<option value="ByDemandDraft">ByDemandDraft</option> -->
</select>
</div>
<div class="form-group col-md-3">
<label>Bank Name </label>
<select name="bank" class="form-control subject" id='subj'>
<option value="NA" class='asde'>-select-</option>
<?php $CasteQuery=mysqli_query($con,"select * from bankdetails");
while($CasteRow=mysqli_fetch_array($CasteQuery)){
echo '<option value="'.$CasteRow['id'].'" '.($upuserarr['bank'] == $CasteRow['id'] ? 'selected="selected"' : '' ).' >'.$CasteRow['bankname'].'</option>';
} ?>
</select>
</div>
<div class="form-group col-md-3">
<label>Check No </label>
<input type='text' name='checkno' class="form-control"
value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['checkno'];}?>" id="ContentPlaceHolder1_txtBillamount" />
</div>
<div class="form-group col-md-3">
<label>Pay Salary</label>
<input name="paidsalary" type="text" class="form-control" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['paidsalary'];}?>" placeholder="Pay Salary " id="amountss" required>
</div>
<div class="box-footer col-md-12">
<input type="submit" class="btn btn-primary" name="ctl00$ContentPlaceHolder1$btnsave" id="paymentd" value="PAY"/>
<input type="reset" name="ctl00$ContentPlaceHolder1$btn_reset" value="Reset" id="ContentPlaceHolder1_btn_reset" class="btn btn-primary">
</div>
</form>
<?php } ?>
</div>
</div>
</div>
<!-- /.box -->
</div>
<!-- /.col-->
</div>
<!-- ./row -->
</section>
<!-- /.content -->
</div>
<?php include('include/footer.php');?>
<script>
$('#lateded').on('blur',function(){
var amountoftotal=$('#amountoftotal').val();
var lateded=$('#lateded').val();
var totalamount=parseInt(amountoftotal)-parseInt(lateded);
$('#amountss').val(totalamount);
});
$('#paymentd').on('click',function(){
var inputbalance=$('#amountss').val();
var billamount=$('#dueamount').val();
var totalcashs=$('#totalcashs').val();
var totalbank=$('#totalbank').val();
// alert(totalbank);
var course=$('#ContentPlaceHolder1_ddlPaymentMode :selected').val();
if(parseInt(billamount)+1<=parseInt(inputbalance)){
alert('Please Enter Amount Less Then '+billamount);
$('#amountss').val('');
} else if(parseInt(totalcashs)+1<=parseInt(inputbalance) && course=='ByCash'){
alert('Please Enter Amount Less Then '+totalcashs);
$('#amountss').val('');
} else if(parseInt(totalbank)+1<=parseInt(inputbalance) && course=='ByCheque'){
alert('Please Enter Amount Less Then '+totalbank);
$('#amountss').val('');
}else{
}
});
$('#subj').on('change',function(){
var htmls='';
$('#PartyName').html('');
var amountoftotal=$('#amountoftotal').val();
var lateded=$('#lateded').val();
var totalamount=parseInt(amountoftotal)-parseInt(lateded);
$('#amountss').val(totalamount);
var course=$('#subj :selected').val();
// alert(course);
$.ajax({
type: "POST",
url: "bankaccountbalance.php",
data: {'id': course},
dataType: "json",
success: function(dataString) {
$('#totalbank').val(parseInt(dataString.amount));
}
});
});
</script>