MAINHACK

Viewing / Editing File: insertSalary.php

<?php include("db.php");
   $timezome = 'Africa/Africa';
  date_default_timezone_set($timezome);

$username = $_SESSION['username_Xw211qAAsq4'];
  $shopname = $_SESSION['business_name_Xw211qAAsq4'];

$employee_id = filter_input(INPUT_POST, 'employee_id', FILTER_SANITIZE_STRING);
 $employee_id = htmlspecialchars($employee_id, ENT_QUOTES, 'UTF-8');

$allowance = filter_input(INPUT_POST, 'allowance', FILTER_SANITIZE_STRING);
  $allowance = htmlspecialchars($allowance, ENT_QUOTES, 'UTF-8');

$bonus = filter_input(INPUT_POST, 'bonus', FILTER_SANITIZE_STRING);
 $bonus = htmlspecialchars($bonus, ENT_QUOTES, 'UTF-8');

$monthly_salary = filter_input(INPUT_POST, 'monthly_salary', FILTER_SANITIZE_STRING);
  $monthly_salary = htmlspecialchars($monthly_salary, ENT_QUOTES, 'UTF-8');

$overtime = filter_input(INPUT_POST, 'overtime', FILTER_SANITIZE_STRING);
  $overtime = htmlspecialchars($overtime, ENT_QUOTES, 'UTF-8');

$payment_date = filter_input(INPUT_POST, 'payment_date', FILTER_SANITIZE_STRING);
  $payment_date = htmlspecialchars($payment_date, ENT_QUOTES, 'UTF-8');

$salary_deduction = filter_input(INPUT_POST, 'salary_deduction', FILTER_SANITIZE_STRING);
  $salary_deduction = htmlspecialchars($salary_deduction, ENT_QUOTES, 'UTF-8');

$reimbursement = filter_input(INPUT_POST, 'reimbursement', FILTER_SANITIZE_STRING);
  $reimbursement = htmlspecialchars($reimbursement, ENT_QUOTES, 'UTF-8');

$tax_amount = filter_input(INPUT_POST, 'tax_amount', FILTER_SANITIZE_STRING);
  $tax_amount = htmlspecialchars($tax_amount, ENT_QUOTES, 'UTF-8');

$status = filter_input(INPUT_POST, 'status', FILTER_SANITIZE_STRING);
  $status = htmlspecialchars($status, ENT_QUOTES, 'UTF-8');

$comment = filter_input(INPUT_POST, 'comment', FILTER_SANITIZE_STRING);
  $comment = htmlspecialchars($comment, ENT_QUOTES, 'UTF-8');

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

if(empty($monthly_salary)){
      $bsalary = $salary;
  } else {
    $bsalary  = $monthly_salary;
  }

if(!empty($employee_id)){
$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));
echo json_encode(['status' => 'success', 'message' => 'Payrun is submitted successfully']);
exit;
}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: insertSalary.php

Server Info

System Features

User Info