/leave/leaveapproval/approve_exec.php

<?php



session_start();

require_once('../../lib/database.php');

require_once('../../lib/globals.php');

openConnection();



function adminLogLeaveScheduleOperations($logoperation, $leavescheduleid, $employeeid) {

    $currentdate = Date('Y-m-d');

    $sql = "INSERT INTO tblleavescheduleadminlogs

            VALUES  ('',

                    '$currentdate',

                    NOW(),

                    '$logoperation',

                    '$leavescheduleid',

                    '$employeeid')";

    $result = mysql_query($sql) or die(mysql_error());

}



function adminEmailAlert($sendermail, $empid, $sub, $msg) {

    $sql = "SELECT * FROM tblemployee JOIN tblemployeeemail ON tblemployee.employeeid = tblemployeeemail.employeeid WHERE tblemployee.employeeid = '$empid'";

    $result = mysql_query($sql);

    while ($row = mysql_fetch_array($result)) {

        $receivermail = $row['email'];

    }

    $subject = "HRMIS - $sub";

    $message = $msg;

    mail($receivermail, $subject, $message, "From:" . $sendermail);

}



$employeeid = sanitizeInput($_SESSION['SESS_EMPLOYEE_ID']);

$leavescheduleid = sanitizeInput($_POST['leavescheduleid']);

$leavetype = sanitizeInput($_POST['leavetype']); // Needs to be worked upon

$fiscalyear = sanitizeInput($_POST['fiscalyear']);

$startdate = sanitizeInput($_POST['startdate']);

$enddate = sanitizeInput($_POST['enddate']);

$location = sanitizeInput($_POST['location']);

$remark = sanitizeInput($_POST['remark']);

$approvestatus = sanitizeInput($_POST['approvestatus']);

$daystaken = daydiff($enddate, $startdate);

$currentdate = DATE('Y-m-d');



if ($approvestatus == 'approve') {

    $sql = "UPDATE tblleaveschedule SET

        planid = '$leavetype',

        fiscalyear = '$fiscalyear',

        startdate = '$startdate',

        enddate = '$enddate',

        daystaken = '$daystaken',

        location = '$location',

        remark = '$remark',

        status = 'Approved'

        WHERE leavescheduleid = '$leavescheduleid'";

    $result = mysql_query($sql) or die(mysql_error());

    if ($result) {

        //Insert record into leave installment

        $sql = "INSERT INTO tblleaveinstallment VALUES('', '$leavescheduleid', '$startdate', '$enddate', '$daystaken', '$currentdate', NOW(), 'Approved', '$employeeid')";

        $result = mysql_query($sql) or die(mysql_error());

        adminLogLeaveScheduleOperations("Approve Leave", $leavescheduleid, $employeeid);

        //adminEmailAlert("hrmis@gmail.com", $employeeid, "Leave Recommended", "Leave Recommendation");

    }

} elseif ($approvestatus == 'reject') {

    $sql = "UPDATE tblleaveschedule SET

        planid = '$leavetype',

        fiscalyear = '$fiscalyear',

        startdate = '$startdate',

        enddate = '$enddate',

        daystaken = '$daystaken',

        location = '$location',

        remark = '$remark',

        status = 'Not Approved'

        WHERE leavescheduleid = '$leavescheduleid'";

    $result = mysql_query($sql) or die(mysql_error());

    if ($result) {

        adminLogLeaveScheduleOperations("Change leave status to not approved", $leavescheduleid, $employeeid);

    }

} elseif ($approvestatus == 'revert') {

    $sql = "UPDATE tblleaveschedule SET status = 'Recommended' WHERE leavescheduleid = '$leavescheduleid'";

    $result = mysql_query($sql) or die(mysql_error());

    if ($result) {

        adminLogLeaveScheduleOperations("Change leave status to recommended", $leavescheduleid, $employeeid);

        //adminEmailAlert("hrmis@gmail.com", $employeeid, "Leave Not Recommended", "Leave Not Recommended");

    }

}

if ($result) {

    echo "Submitted";

}

?>