1#@!#!123s

: / home / ksclnmuac / public_html / cas / application / models / admin /
Filename : LeaveManagement.php
back
<?php

/**
 * Model For Handling All DB Operations Related To Leave
 *
 * @author Softpro India Pvt. Ltd.
 */
defined('BASEPATH') OR exit('No direct script access allowed');

class LeaveManagement extends CI_Model {

    function createNewLeaveType(array $newLeaveTypeInfo) {
        $this->db->insert('tbl_leave_type_master', $newLeaveTypeInfo);
        return $this->db->insert_id();
    }

    function getAllLeaveType() {
        $this->db->select("TLTM.tltm_id,TLTM.tltm_name,TLTM.tltm_short_name,TLTM.tltm_active_status,TLTM.tltm_delete_status,"
                . "TLTM.tltm_added_by,TLTM.tltm_added_on,TLTM.tltm_updated_by,TLTM.tltm_updated_on,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('tbl_leave_type_master TLTM');
        $this->db->join('tbl_staff_members TSMA', 'TLTM.tltm_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'TLTM.tltm_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->order_by("TLTM.tltm_updated_on", "desc");
        return $this->db->get();
    }

    function getLeaveTypeBy($tltm_id) {
        $this->db->select("TLTM.tltm_id,TLTM.tltm_name,TLTM.tltm_short_name,TLTM.tltm_active_status,TLTM.tltm_delete_status,"
                . "TLTM.tltm_added_by,TLTM.tltm_added_on,TLTM.tltm_updated_by,TLTM.tltm_updated_on,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('tbl_leave_type_master TLTM');
        $this->db->join('tbl_staff_members TSMA', 'TLTM.tltm_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'TLTM.tltm_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where('TLTM.tltm_id', $tltm_id);
        return $this->db->get();
    }

    function getNonDeletedActiveLeaveTypes() {
        $this->db->select('*');
        $this->db->from('tbl_leave_type_master');
        $this->db->where('tltm_active_status', "T");
        $this->db->where('tltm_delete_status', "F");
        return $this->db->get();
    }

    function getLeaveTypeByName($tltm_name) {
        $this->db->select('*');
        $this->db->from('tbl_leave_type_master');
        $this->db->where('tltm_name', $tltm_name);
        return $this->db->get();
    }

    function getLeaveTypeByShortName($tltm_short_name) {
        $this->db->select('*');
        $this->db->from('tbl_leave_type_master');
        $this->db->where('tltm_short_name', $tltm_short_name);
        return $this->db->get();
    }

    function isLeaveTypeNameSafeUpdate($tltm_id, $tltm_name) {
        $this->db->select("*");
        $this->db->from('tbl_leave_type_master');
        $this->db->where('tltm_name', $tltm_name);
        $this->db->where('tltm_id != ' . $tltm_id);
        $result = $this->db->get()->result();
        if (sizeof($result)) {
            return FALSE;
        } else {
            return TRUE;
        }
    }

    function isLeaveTypeShortNameSafeUpdate($tltm_id, $tltm_short_name) {
        $this->db->select("*");
        $this->db->from('tbl_leave_type_master');
        $this->db->where('tltm_short_name', $tltm_short_name);
        $this->db->where('tltm_id != ' . $tltm_id);
        $result = $this->db->get()->result();
        if (sizeof($result)) {
            return FALSE;
        } else {
            return TRUE;
        }
    }

    function updateLeaveTypeInfo(array $leaveTypeUpdatedInfo) {
        $this->db->where('tltm_id', $leaveTypeUpdatedInfo['tltm_id']);
        return $this->db->update('tbl_leave_type_master', $leaveTypeUpdatedInfo);
    }

    /* Functions For Leave Apply & Related Stuffs */

    function createNewLeaveRequest(array $newLeaveRequestInfo) {
        $this->db->insert('staff_leave_mst', $newLeaveRequestInfo);
        return $this->db->insert_id();
    }

    function getLeaveRequestInfoBy($slm_id) {
        $this->db->select('*');
        $this->db->from('staff_leave_mst SLM');
        $this->db->join('tbl_leave_type_master TLTM', 'SLM.tltm_id = TLTM.tltm_id');
        $this->db->join('tbl_session_master TSM', 'SLM.session_id = TSM.session_id');
        $this->db->join('tbl_staff_members TSMR', 'SLM.smember_id = TSMR.smember_id');
        $this->db->join('tbl_profile TPRFLR', 'TSMR.smember_id = TPRFLR.tprfl_id');
        $this->db->join('tbl_logindetails TLDR', 'TSMR.tld_id = TLDR.tld_id');
        $this->db->join('tbl_role_master TRMR', 'TSMR.role_id = TRMR.role_id');
        $this->db->join('tbl_designation_master TDEM', 'TPRFLR.desig_id = TDEM.desig_id');
        $this->db->join('designation_category_mst DCM', 'TDEM.dcm_id = DCM.dcm_id');
        $this->db->join('tbl_sub_departments_master TSDM', 'TLDR.sub_dept_id = TSDM.sub_dept_id');
        $this->db->join('tbl_department_master TDM', 'TSDM.dept_id = TDM.dept_id');
        $this->db->where('SLM.slm_id', $slm_id);
        return $this->db->get();
    }

    function getAppliedLeaveReport($smember_id = '', $department = '', $subDepartment = '', $desinationCategory = '', $designation = '', $gender = '', $tltm_id = '', $session_id = '', $startDate = '', $endDate = '', $rangeAppliedwith = '', $status = '') {
        $this->db->select('*');
        $this->db->from('staff_leave_mst SLM');
        $this->db->join('tbl_session_master TSM', 'SLM.session_id = TSM.session_id');
        $this->db->join('tbl_leave_type_master TLTM', 'SLM.tltm_id = TLTM.tltm_id');
        $this->db->join('tbl_staff_members TSMR', 'SLM.smember_id = TSMR.smember_id');
        $this->db->join('tbl_profile TPRFLR', 'TSMR.smember_id = TPRFLR.tprfl_id');
        $this->db->join('tbl_logindetails TLDR', 'TSMR.tld_id = TLDR.tld_id');
        $this->db->join('tbl_role_master TRMR', 'TSMR.role_id = TRMR.role_id');
        $this->db->join('tbl_designation_master TDEM', 'TPRFLR.desig_id = TDEM.desig_id');
        $this->db->join('designation_category_mst DCM', 'TDEM.dcm_id = DCM.dcm_id');
        $this->db->join('tbl_sub_departments_master TSDM', 'TLDR.sub_dept_id = TSDM.sub_dept_id');
        $this->db->join('tbl_department_master TDM', 'TSDM.dept_id = TDM.dept_id');
        $this->db->where("TPRFLR.tprfl_gender LIKE '%" . $gender . "%'");
        $this->db->where("TLDR.tld_delete_status", 'F');
        /* Staff Member Wise Filter */
        if ($smember_id != '') {
            $this->db->where('SLM.smember_id', $smember_id);
        }
        /* Staff Member Wise Filter */
        /* Department Wise Filter */
        if ($department != '') {
            $this->db->where("TDM.dept_id", $department);
        }
        /* Department Wise Filter */
        /* Sub-Department Wise Filter */
        if ($subDepartment != '') {
            $this->db->where("TLDR.sub_dept_id", $subDepartment);
        }
        /* Sub-Department Wise Filter */
        /* Designation Category Wise Filter */
        if ($desinationCategory != '') {
            $this->db->where("DCM.dcm_id", $desinationCategory);
        }
        /* Designation Category Wise Filter */
        /* Designation Wise Filter */
        if ($designation != '') {
            $this->db->where("TPRFLR.desig_id", $designation);
        }
        /* Designation Wise Filter */
        /* Leave Type Wise Filter */
        if ($tltm_id != '') {
            $this->db->where('SLM.tltm_id', $tltm_id);
        }
        /* Leave Type Wise Filter */
        /* Session Wise Filter */
        if ($session_id != '') {
            $this->db->where('SLM.session_id', $session_id);
        }
        /* Session Wise Filter */
        /* Dates Combination */
        if ($startDate != '' && $endDate != '') {
            if ($rangeAppliedwith == "LDR") {
                $this->db->where("SLM.slm_from >= '" . $startDate . "' && SLM.slm_to <= '" . $endDate . "'");
            } else if ($rangeAppliedwith == "ADR") {
                $this->db->where("SLM.slm_added_on >= '" . $startDate . "' && SLM.slm_added_on <= '" . $endDate . "'");
            } else {
                $this->db->where("SLM.slm_admin_update_on >= '" . $startDate . "' && SLM.slm_admin_update_on <= '" . $endDate . "'");
            }
        } else if ($startDate == '' && $endDate != '') {
            if ($rangeAppliedwith == "LDR") {
                $this->db->where("SLM.slm_to <= '" . $endDate . "'");
            } else if ($rangeAppliedwith == "ADR") {
                $this->db->where("SLM.slm_added_on <= '" . $endDate . "'");
            } else {
                $this->db->where("SLM.slm_admin_update_on <= '" . $endDate . "'");
            }
        } else if ($startDate != '' && $endDate == '') {
            if ($rangeAppliedwith == "LDR") {
                $this->db->where("TSPI.slm_from >= '" . $startDate . "'");
            } else if ($rangeAppliedwith == "ADR") {
                $this->db->where("SLM.slm_added_on >= '" . $startDate . "'");
            } else {
                $this->db->where("SLM.slm_admin_update_on >= '" . $startDate . "'");
            }
        }
        /* Dates Combination */
        /* Status Wise Filter */
        if ($status != '') {
            $this->db->where('SLM.slm_status', $status);
        }
        /* Status Wise Filter */
        return $this->db->get();
    }

    function updateLeaveInfo(array $leaveUpdatedInfo) {
        $this->db->where('slm_id', $leaveUpdatedInfo['slm_id']);
        return $this->db->update('staff_leave_mst', $leaveUpdatedInfo);
    }

}