MAINHACK

Viewing / Editing File: payslip.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 = 'Payslip';
$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'];

if(isset($_GET['payid'])){
    $payid = htmlspecialchars($_GET['payid']);
    $payid = mysqli_real_escape_string($new,$_GET['payid']);

$stmt = $con->prepare("SELECT * FROM employees e , payrolls p WHERE e.employee_id = p.emp_id  and p.id = ? and e.business_name = ?");
$stmt->execute(array($payid,$shopname));
$rows = $stmt->fetchAll();
foreach($rows as $data){

$name = $data['first_name'].' ,'.$data['last_name'];

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

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

$overtime = $data['overtime'];

if(empty($overtime)){
    $overtime = 0.00;
   } else {
    $overtime = $overtime;
   }

$salary_deduction = $data['salary_deduction'];

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

if(empty($reimbursement)){
    $reimbursement = 0.00;
   } else {
    $reimbursement = $reimbursement;
   }

$date_paid = $data['date_paid'];
   $payment_status = $data['payment_status'];
   $tax_value = $data['tax_amount'];

if(empty($tax_value)){
    $tax_value = 0.0;
   } else {
    $tax_value = $tax_value;
   }

$comment = $data['comment'];

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

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

$tax_Amt = $gross - $taxgross;

$total_deduction1 = $salary_deduction + $tax_amount;

$net_salary = $tax_Amt - $total_deduction1;

}

}
}
?>
<!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">All Payslip</h4>

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

<div class="text-center lh-1 mb-2">
                <h3 class="fw-bold">Payslip</h3>
                 <span class="fw-normal">Payment slip date : 
                    <?php echo $date_paid; ?>
                    </span>
            </div>
            <div class="row">
                <div class="col-md-10">
                    <div class="row">
                        <div class="col-md-6">
                            <div> <span class="fw-bolder">Company/shop : </span> <small class="ms-3"><?php echo $shopname; ?></small> </div>
                            <div><span class="fw-bolder">Employee name : <?php echo $name; ?></span></div>
                            <div><span>Status : <?php echo $data['payment_status']; ?></span></div>
                        </div>
                    </div>
                </div>
                             <div class="table-responsive">           
  
                <table class="mt-4 table table-bordered" >
                    <thead class="bg-dark text-white">
                        <tr>
                            <th scope="col" style="color:#ffffff">Earnings</th>
                            <th scope="col" style="color:#ffffff">Amount</th>
                            <th scope="col" style="color:#ffffff">Deductions</th>
                            <th scope="col" style="color:#ffffff">Amount</th>
                        </tr>
                    </thead>
                    <tbody>
                        <tr>
                            <th scope="row">Basic Salary</th>
                            <td><?php echo number_format($salary,2).' '.$qurtyCurrency; ?></td>
                            <td>Salary Deduction</td>
                            <td><?php echo number_format($salary_deduction,2).' '.$qurtyCurrency;; ?></td>
                        </tr>
                        <tr>
                            <th scope="row">Total Allowance</th>
                            <td><?php echo number_format($allowance,2).' '.$qurtyCurrency;; ?></td>
                            <td>Tax Amount (<?php echo $tax_value;?>%)</td>
                            <td><?php echo number_format($tax_amount,2).' '.$qurtyCurrency;; ?></td>
                        </tr>
                        <tr>
                            <th scope="row">Total Bonuses</th>
                            <td><?php echo number_format($bonus,2).' '.$qurtyCurrency;; ?></td>
                            <td></td>
                            <td></td>
                        </tr>
                        <tr>
                            <th scope="row">Overtime</th>
                            <td><?php echo number_format($overtime,2).' '.$qurtyCurrency;; ?></td>
                            <td></td>
                            <td></td>
                        </tr>

<tr>
                            <th scope="row">Reimbursement</th>
                            <td><?php echo number_format($reimbursement,2).' '.$qurtyCurrency;; ?></td>
                            <td></td>
                            <td></td>
                        </tr>
                        <tr>
                            <th scope="row">Gross Salary</th>
                            <td><?php echo number_format($gross,2).' '.$qurtyCurrency; ?></td>

<td>Total Deductions</td>
                            <td><?php echo number_format($total_deduction1,2).' '.$qurtyCurrency;; ?></td>
                        </tr>
                      
                      
                       
                        
                    </tbody>
                </table>
            </div>
            </div>
            <div class="row">
                <div class="col-md-4"> <br> <span class="fw-bold">Net Salary : <?php echo number_format($net_salary,2).' '.$qurtyCurrency;; ?></span> </div>
                <br  />
                <div class="border col-md-8">
                    <div class="d-flex flex-column"> <span><?php  echo $comment; ?></span> </div>

</div>
       
            </div>

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

</div>
</div>

</div>
</div>

</div> 
</div>

</div>

</div> 
</div>

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

</div>

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

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

</body>

</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: payslip.php

Server Info

System Features

User Info