MAINHACK

Viewing / Editing File: payroll.php

<?php include("../admin/includes/functions/functions.php");?>
<?php include("../admin/db/db.php");?>
<?php 
if(!isset($_SESSION['username_Xw211qAAsq4']))
{
header('Location: ../auth/');
exit();
} else {
$pageTitle1 = 'Run Payroll';

$shopname = $_SESSION['business_name_Xw211qAAsq4'];

$currency = mysqli_query($new,"SELECT currency from barber_admin WHERE
 business_name = '$shopname'");
 $fechC = mysqli_fetch_array($currency);
$qurtyCurrency = $fechC['currency'];

//Add new//
$message = "";
if(isset($_POST['add'])){
  
$employee_id = test_input($_POST['employee_id']);
$allowance = test_input($_POST['allowance']);
$bonus = test_input($_POST['bonus']);
$monthly_salary = test_input($_POST['monthly_salary']);
$overtime = test_input($_POST['overtime']);
$payment_date = test_input($_POST['payment_date']);
$salary_deduction = test_input($_POST['salary_deduction']);
$reimbursement = test_input($_POST['reimbursement']);
$tax_amount = test_input($_POST['tax_amount']);
$status = test_input($_POST['status']);

$sele = mysqli_query($new,"SELECT * FROM employees WHERE employee_id = '$employee_id'");
     $conrow = mysqli_fetch_array($sele);
     $salary = $conrow['monthly_salary'];

if($monthly_salary==""){
      $bsalary = $salary;
  } else {
    $bsalary  = $monthly_salary;
  }
 if(!$message){
 $stmt = $con->prepare("insert into payrolls (business_id,emp_id,salary,allowance,bonus,overtime,salary_deduction,reimbursement,tax_amount,date_paid,payment_status,comment) values(?,?,?,?,?,?,?,?,?,?,?,?) ");
$stmt->execute(array($shopname,$employee_id,$bsalary,$allowance,$bonus,$overtime,$salary_deduction,$reimbursement,$tax_amount,$payment_date,$status,$comment));

$message = '<script> $(document).ready(function(){
    swal("Success!", "Payroll is recorded ", "success");}); </script>';

}
}

if(isset($_POST['del'])){
$ID = mysqli_real_escape_string($new,$_POST['SID']);
$DEL = mysqli_query($new,"DELETE FROM payrolls WHERE id = '$ID'");

$message = '<script> $(document).ready(function(){
    swal("Success!", "Payroll is deleted ", "success");}); </script>';
}

if(isset($_POST['update'])){

$employee_id = test_input($_POST['employee_id']);
$allowance = test_input($_POST['allowance']);
$bonus = test_input($_POST['bonus']);
$monthly_salary = test_input($_POST['monthly_salary']);
$overtime = test_input($_POST['overtime']);
$payment_date = test_input($_POST['payment_date']);
$salary_deduction = test_input($_POST['salary_deduction']);
$reimbursement = test_input($_POST['reimbursement']);
$tax_amount = test_input($_POST['tax_amount']);
$status = test_input($_POST['status']);
$comment = test_input($_POST['comment']);
$payID = test_input($_POST['payID']);

if(!empty($employee_id)){
$stmt_update_service = $con->prepare("UPDATE payrolls SET emp_id = ?,salary = ?, allowance = ?,bonus = ?, overtime = ?, salary_deduction = ?, reimbursement = ?, tax_amount = ?, date_paid = ?,payment_status = ?,comment = ? WHERE id = ?");
    $stmt_update_service->execute(array($employee_id,$monthly_salary,$allowance,$bonus,$overtime,$salary_deduction,$reimbursement,$tax_amount,$payment_date,$status,$comment,$payID));

$message = '<script> $(document).ready(function(){
    swal("Success!", "Payroll is updated ", "success");}); </script>';
}
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title> <?php echo $shopname;?> || <?php echo $pageTitle1;?></title>

#loader {
display: block;
position: absolute;
top: 50%;
left: 50%;
border: 16px solid #f3f3f3;
border-top: 16px solid #3498db;
border-radius: 50%;
width: 70px;
height: 70px;
animation: spin 2s linear infinite;
}

@keyframes spin {
0% { transform: rotate(0deg); }
100% { transform: rotate(360deg); }
}
</style>

</head>

<div id="layout-wrapper">
<div class="header-border"></div>

<?php include("includes/template/head.php");?>
<?php include("includes/template/side.php");?>

<div class="row">
<div class="col-12">
<div class="page-title-box d-flex align-items-center justify-content-between">
<h4 class="mb-0 font-size-18">Payroll</h4>   
<?php 
if($message != "") {
echo ($message) ;
}
?>
<div class="page-title-right">
<ol class="breadcrumb m-0">
<li class="breadcrumb-item"><a href="javascript: void(0);"><?= $shopname;?></a></li>
<li class="breadcrumb-item active"><?php echo $pageTitle1;?></li>
</ol>
</div>

</div>
</div>
</div>

<?php 
$stmt = $con->prepare("SELECT account_type FROM  barber_admin WHERE username = ? and business_name = ?");
$stmt->execute(array($username,$shopname));
$userstatus = $stmt->fetchAll();

foreach($userstatus as $sta)
{
    $namee = $sta['account_type'];
}

$select_role = mysqli_query($new,"SELECT * FROM role_permissions  WHERE business_name = '$shopname' and type = '$namee' and page_name = 'Payroll'");
$rowroles = mysqli_fetch_array($select_role);
$updaterecord = $rowroles['updaterecord'];
$deleterecord = $rowroles['deleterecord'];
$add_db = $rowroles['add'];
$type = $rowroles['type'];
$view = $rowroles['view'];
?>
<?php 
if($namee != "Admin"){?>
    <button type="button" class="btn btn-primary waves-effect waves-light" data-toggle="modal" data-target=".bd-example-modal-lg">Add</button>

<?php } elseif($namee == "Admin" and $add_db == '1' ) {?>
        <button type="button" class="btn btn-primary waves-effect waves-light" data-toggle="modal" data-target=".bd-example-modal-lg">Add</button>
<?php } elseif ($namee == "Admin" and $add_db == '0'){?>
<button type="button" disabled class="btn btn-primary waves-effect waves-light">Add</button>
<?php }?>

<br   /><br   />
    <div class="table-responsive">           
 <table id="basic-datatable" class="table table-hover table-striped table-bordered">
<thead style="background-color:#428bca;border:#428bca;">
<tr style="color: #ffffff;">
    <th>ID</th>
    <th>Employee </th>
    <th>Date Paid</th>
    <th>Gross Salary</th>
    <th>Net Salary</th>
    <th>Status</th>
    <th>Action</th>
    </tr>
</thead>
 <tbody>
        <?php
        $cont = 1;
$stmt = $con->prepare("SELECT * FROM payrolls p ,employees e  WHERE p.emp_id = e.employee_id and  business_id = ? ORDER BY id DESC");
$stmt->execute(array($shopname));
$rows_categories = $stmt->fetchAll();
  ?>
        <tr>
<?php 
foreach($rows_categories as $payroll){

$basic_salary = $payroll['salary'];
 $allowance = $payroll['allowance'];

if(empty($allowance)){
$allowance = '0.00';
}else {
$allowance = $payroll['allowance'];
}

$bonus = $payroll['bonus'];
if(empty($bonus)){
$bonus = '0.00';
}else {
$bonus = $payroll['bonus'];
}

$reimbursement = $payroll['reimbursement'];
if(empty($reimbursement)){
$reimbursement = '0.00';
}else {
$reimbursement = $payroll['reimbursement'];
}

$overtime = $payroll['overtime'];
if(empty($overtime)){
$overtime = '0.00';
}else {
$overtime = $payroll['overtime'];
}

$date_paid = $payroll['$date_paid'];

$salary_deduction = $payroll['salary_deduction'];

$payment_status = $payroll['payment_status'];

if(empty($salary_deduction)){
$salary_deduction = '0.00';
}else {
$salary_deduction = $payroll['salary_deduction'];
}

$tax_amount = $payroll['tax_amount'];
if(empty($tax_amount)){
$tax_amount = '0.00';
}else {
$tax_amount = $payroll['tax_amount'];
}

$gross = $basic_salary + $allowance + $bonus + $reimbursement + $overtime;

$taxgross  = ($tax_amount/100) * $gross;

$total_gross = $gross - $taxgross;
$total_deduction = $salary_deduction + $taxgross;
$net_salary = $total_gross - $total_deduction;

?>
            <td><?php echo  $cont++;?></td>
            <td><?php echo $name = $payroll['first_name'].','.$overtime = $payroll['last_name'];?></td>
            <td><?php echo $date = $payroll['date_paid'];?></td>
            <td><?php echo number_format($total_gross,2).' '.$qurtyCurrency;?></td>
            <td><?php echo number_format($net_salary,2).' '.$qurtyCurrency;?></td>
            <td>
        <?php if($payment_status == 'Pending'){
        echo '<span class="badge bg-danger rounded-pill" style="color:#fff">Pending</span>';
        } elseif ($payment_status == 'Processing'){
          echo '<span class="badge bg-warning rounded-pill" style="color:#fff">Warning</span>';
        } else {
        echo '<span class="badge bg-success rounded-pill" style="color:#fff">Approved</span>';
        }
        ?>
        </td>

<td>

<?php  $edit_data = "edit_".$payroll["id"];?>
           <?php  $delete_data = "delete_".$payroll["id"];?>
           <?php  $data = $payroll["id"];?>

<ul>

<?php 
if($namee != "Admin"){?>
<li class="list-inline-item" data-toggle="tooltip" title="Edit">
<a href="#"  data-toggle="modal" data-target="#<?php echo $edit_data; ?>" data-placement="top"><i class="fa fa-edit"></i></a>
</li>

<?php } elseif($namee == "Admin" and $updaterecord == '1' ) {?>
<li class="list-inline-item" data-toggle="tooltip" title="Edit">
<a href="#"  data-toggle="modal" data-target="#<?php echo $edit_data; ?>" data-placement="top"><i class="fa fa-edit"></i></a>
</li>

<?php } elseif ($namee == "Admin" and $updaterecord == '0'){?>
<li class="list-inline-item" data-toggle="tooltip" title="Locked">
<a class="disabled" data-placement="top"><i class="fa fa-edit"></i></a>
</li>

<?php }?>

<?php 
if($namee != "Admin"){?>
<li class="list-inline-item" data-toggle="tooltip" title="Payslip">
<a href="payslip?payid=<?php echo $data;?>&&<?php echo sha1(mt_rand(200,1999));?>" ><i class="fa fa-user" style="color:brown"></i></a>
</li>

<?php } elseif($namee == "Admin" and $view == '1' ) {?>
<li class="list-inline-item" data-toggle="tooltip" title="Payslip">
<a href="payslip?payid=<?php echo $data;?>&&<?php echo sha1(mt_rand(200,1999));?>" ><i class="fa fa-user" style="color:brown"></i></a>
</li>

<?php } elseif ($namee == "Admin" and $view == '0'){?>
<li class="list-inline-item" data-toggle="tooltip" title="Locked">
<a class="disabled" data-placement="top"><i class="fa fa-user"></i></a>
</li>

<?php }?>

<?php 
        if($namee != "Admin"){?>
        <li class="list-inline-item" data-toggle="tooltip" title="Delete">
        <a href="#"  data-toggle="modal" data-target="#<?php echo $delete_data; ?>" data-placement="top"><i class="fa fa-trash-alt" style="color:red"></i></a>
        </li>

<?php } elseif($namee == "Admin" and $deleterecord == '1' ) {?>
        <li class="list-inline-item" data-toggle="tooltip" title="Delete">
        <a href="#"  data-toggle="modal" data-target="#<?php echo $delete_data; ?>" data-placement="top"><i class="fa fa-trash-alt" style="color:red"></i></a>
        </li>

<?php } elseif ($namee == "Admin" and $deleterecord == '0'){?>
        <li class="list-inline-item" data-toggle="tooltip" title="Locked">
        <a class="disabled" data-placement="top"><i class="fa fa-trash-alt" style="color:red"></i></a>
        </li>
        <?php }?>

<div class="modal fade" id="<?php echo $edit_data; ?>" tabindex="-1" role="dialog" aria-labelledby="<?php echo $edit_data; ?>" aria-hidden="true">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">

<h5 class="modal-title h4" id="myLargeModalLabel">Edit  Payrun</h5>
<button type="button" class="close waves-effect waves-light" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">&times;</span>
</button>
<div id="response"></div>
</div>
<div class="modal-body" data-ng-form="newcustomer1">
<div class="setting-steps">
<form   method="POST">
    <div class="row">
         <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInputEmail1" class="form-label">Employee name</label>
                <select class="form-control" required name="employee_id">
         <option value="">Select Employee</option>
           <?php 
             $sel = mysqli_query($new,"SELECT * FROM employees WHERE business_name = '$shopname' and status = 'active'");
             while($fo = mysqli_fetch_array($sel)){
           ?>
         <option value="<?php echo $fo['employee_id'];?>"><?php echo $fo['first_name'].' , '.$fo['last_name'];?></option>
         <?php }?>
                </select>
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
            <label for="exampleInputEmail1" class="form-label">Allowance(<?php echo $qurtyCurrency;?>)<span class="req"></span></label>
        <input type="number" name="allowance" min="0" value="<?php echo $payroll['allowance'];?>"  class="form-control">
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInputEmail1" class="form-label">Bonus(<?php echo $qurtyCurrency;?>)</label>
              <input type="number" name="bonus"  min="0" class="form-control" value="<?php echo $payroll['bonus'];?>">
            </div>
        </div>
    </div>
    <div class="row">

<div class="col-sm-5">
            <div class="form-group">
                <label class="form-label">Salary</label>
                <input type="number" min="0" name="monthly_salary" id="monthly_salary" class="form-control" value="<?php echo $payroll['salary'];?>">
            </div>
        </div>
        <div class="col-sm-3">
            <div class="form-group">
                <label for="exampleInput" class="form-label">Over Time(<?php echo $qurtyCurrency;?>)</label>
          <input type="number" name="overtime" min="0" class="form-control" value="<?php echo $payroll['overtime'];?>">
            </div>
        </div>

<div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Payment Date</label>
                <div class="input-group date dobWrap cal-container">
         <input type="date" class="form-control" name="payment_date" value="<?php echo $payroll['payment_date'];?>">
                    
            </div>
        </div>
        </div>

</div>
    <div class="row">
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Deductions(<?php echo $qurtyCurrency;?>)</label>
                <input type="number" name="salary_deduction" min="0" class="form-control" value="<?php echo $payroll['salary_deduction'];?>"> 
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Reimbursement(<?php echo $qurtyCurrency;?>)</label>
                <input type="number" name="reimbursement" min="0" class="form-control" value="<?php echo $payroll['reimbursement'];?>"> 
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Tax(%)</label>
        <input type="number" name="tax_amount" class="form-control"  min="0" value="<?php echo $payroll['tax_amount'];?>">
            </div>
        </div>
    </div>

<input type="hidden" name="payID" value="<?php echo $payroll["id"];?>">
     <div class="row">
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Status</label>
 <select class="form-control" name="status" value="<?php echo $payroll['payment_status'];?>" required>
                <option value="">Select status</option>
                <option value="Pending">Pending</option>
                <option value="Processing">Processing</option>
                <option value="Approved">Approved</option>
                </select>
            </div>
        </div>

<div class="col-sm-8">
            <div class="form-group">
                <label class="form-label">Comment</label>
         <textarea cols="5" class="form-control" name="comment"><?php echo $payroll['comment'];?></textarea>
            </div>
        </div>
    </div>
    <button type="submit" name="update" class="btn btn-success">Submit</button>
</form>

</div>
</div>
        </div>
        </form>
</div> 
</div>
</div>
</div>

<div class="modal fade" id="<?php echo $delete_data; ?>" tabindex="-1" role="dialog" aria-labelledby="<?php echo $delete_data; ?>" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="exampleModalLabel">Delete Category</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">&times;</span>
</button>
</div>
<div class="modal-body">
<form method="POST">
Are you sure you want to delete this Pay run?
</div>
<input type="hidden" name="SID" value="<?php echo $payroll['id']; ?>">
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>

<button type="submit" name="del" class="btn btn-success">Delete</button>
</form>
</div>
</div>
</div>
</div>

</li>
</ul>
    
            </td>
        </tr>

<?php  };?>
         
            </tbody>
            </table>
</div>

</div>

</div> 
</div>

</div>

</div> 
</div>

<?php include("includes/template/newfooter.php");?>
</div>

</div>

<div class="menu-overlay"></div>

<?php //include("includes/modals/PayrunModal.php");?>

<h5 class="modal-title h4" id="myLargeModalLabel">Add New Payrun</h5>
<button type="button" class="close waves-effect waves-light" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">&times;</span>
</button>
<div id="response"></div>
</div>
<div class="modal-body" data-ng-form="newcustomer1">
<div class="setting-steps">
<form   accept-charset="utf-8" method="POST">
    <div class="row">
         <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInputEmail1" class="form-label">Employee name</label>
                <select class="form-control" name="employee_id" required>
         <option>Select Employee</option>
           <?php 
             $sel = mysqli_query($new,"SELECT * FROM employees WHERE business_name = '$shopname' and status = 'active'");
             while($fo = mysqli_fetch_array($sel)){
           ?>
         <option value="<?php echo $fo['employee_id'];?>"><?php echo $fo['first_name'].' , '.$fo['last_name'];?></option>
         <?php }?>
                </select>
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInputEmail1" class="form-label">Allowance<span class="req"></span></label>
                <input type="number" name="allowance" min="0"  class="form-control">
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInputEmail1" class="form-label">Bonus</label>
              <input type="number" name="bonus"  min="0" class="form-control">
            </div>
        </div>
    </div>
    <div class="row">

<div class="col-sm-5">
            <div class="form-group">
                <label class="form-label">Salary (Leave empty to use basic salary)</label>
                <input type="number" min="0" name="monthly_salary" id="monthly_salary" class="form-control">
            </div>
        </div>
        <div class="col-sm-3">
            <div class="form-group">
                <label for="exampleInput" class="form-label">Over Time</label>
          <input type="number"   name="overtime" min="0" class="form-control">
            </div>
        </div>

<div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Payment Date</label>
                <div class="input-group date dobWrap cal-container">
         <input type="date" class="form-control" name="payment_date" required>
                    
            </div>
        </div>
        </div>

</div>
    <div class="row">
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Deductions</label>
                <input type="number" name="salary_deduction" min="0" class="form-control"> 
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Reimbursement</label>
                <input type="number" name="reimbursement" min="0" class="form-control"> 
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Tax(%)</label>
        <input type="number" name="tax_amount" class="form-control"  min="0">
            </div>
        </div>
    </div>

<div class="row">
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Status</label>
                <select class="form-control" name="status" required>
                <option value="">Select status</option>
                <option value="Pending">Pending</option>
                <option value="Processing">Processing</option>
                <option value="Approved">Approved</option>
                </select>
            </div>
        </div>

<div class="col-sm-8">
            <div class="form-group">
                <label class="form-label">Comment</label>
         <textarea cols="5" class="form-control" name="comment"></textarea>
            </div>
        </div>
    </div>
    <button type="submit" name="add" class="btn btn-success">Submit</button>
</form>

</div>
</div>
        </div>
        </form>
</div> 
</div>
</div>
</div>

</body>

</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: payroll.php

Server Info

System Features

User Info