/leave/leaverecommendation/recommend_exec.php
PHP | 83 lines | 77 code | 4 blank | 2 comment | 9 complexity | 4b0241e4a510ee42ce445725dc9d029b MD5 | raw file
Possible License(s): LGPL-2.1
- <?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']);
- $recommendstatus = sanitizeInput($_POST['recommendstatus']);
- $daystaken = daydiff($enddate, $startdate);
-
- if ($recommendstatus == 'recommend') {
- $sql = "UPDATE tblleaveschedule SET
- planid = '$leavetype',
- fiscalyear = '$fiscalyear',
- startdate = '$startdate',
- enddate = '$enddate',
- daystaken = '$daystaken',
- location = '$location',
- remark = '$remark',
- status = 'Recommended'
- WHERE leavescheduleid = '$leavescheduleid'";
- $result = mysql_query($sql) or die(mysql_error());
- if ($result) {
- adminLogLeaveScheduleOperations("Recommend Leave", $leavescheduleid, $employeeid);
- //adminEmailAlert("hrmis@gmail.com", $employeeid, "Leave Recommended", "Leave Recommendation");
- }
- } elseif ($recommendstatus == 'reject') {
- $sql = "UPDATE tblleaveschedule SET
- planid = '$leavetype',
- fiscalyear = '$fiscalyear',
- startdate = '$startdate',
- enddate = '$enddate',
- daystaken = '$daystaken',
- location = '$location',
- remark = '$remark',
- status = 'Not Recommended'
- WHERE leavescheduleid = '$leavescheduleid'";
- $result = mysql_query($sql) or die(mysql_error());
- if ($result) {
- adminLogLeaveScheduleOperations("Change leave status to not recommended", $leavescheduleid, $employeeid);
- }
- } elseif ($recommendstatus == 'revert') {
- $sql = "UPDATE tblleaveschedule SET status = 'Pending' WHERE leavescheduleid = '$leavescheduleid'";
- $result = mysql_query($sql) or die(mysql_error());
- if ($result) {
- adminLogLeaveScheduleOperations("Change leave status to pending", $leavescheduleid, $employeeid);
- //adminEmailAlert("hrmis@gmail.com", $employeeid, "Leave Not Recommended", "Leave Not Recommended");
- }
- }
- if ($result) {
- echo "Submitted";
- }
- ?>