FileMgr

✏️ /home/mien4214/public_html/eabsen/hris/application/models/Overtime_request_model.php

✕ Tutup

<?php
	defined('BASEPATH') OR exit('No direct script access allowed');
	class Overtime_request_model extends CI_Model
	{
 
    public function __construct()
    {
        parent::__construct();
        $this->load->database();
    }
 
 
 	// Function to add record in table
	public function add_employee_overtime_request($data){
		$this->db->insert('xin_attendance_time_request', $data);
		if ($this->db->affected_rows() > 0) {
			return true;
		} else {
			return false;
		}
	}
	
	// Function to update record in table
	public function update_request_record($data, $id){
		$this->db->where('time_request_id', $id);
		if( $this->db->update('xin_attendance_time_request',$data)) {
			return true;
		} else {
			return false;
		}		
	}
	
	// get record of attendance by id
	 public function read_overtime_request_info($id) {
	
		$sql = 'SELECT * FROM xin_attendance_time_request WHERE time_request_id = ? limit 1';
		$binds = array($id);
		$query = $this->db->query($sql, $binds);
		
		if ($query->num_rows() > 0) {
			return $query->result();
		} else {
			return null;
		}
	}
	
	// Function to Delete selected record from table
	public function delete_overtime_request_record($id){ 
		$this->db->where('time_request_id', $id);
		$this->db->delete('xin_attendance_time_request');
		
	}
	
	// get overtime request
	public function employee_overtime_requests($emp_id) {
		
		$sql = 'SELECT * FROM xin_attendance_time_request where employee_id = ?';
		$binds = array($emp_id);
		$query = $this->db->query($sql, $binds);
		
		return $query;
	}
	
	// get overtime request>admin>all
	public function all_employee_overtime_requests() {
		
		$sql = 'SELECT * FROM xin_attendance_time_request';
		$query = $this->db->query($sql);
		
		return $query;
	}
	// get overtime request>admin>all
// 	public function get_overtime_request_count($employee_id,$pay_date) {
		
// 		$sql = 'SELECT * FROM `xin_attendance_time_request` where employee_id = ? and is_approved = ? and request_date_request = ?';
// 		$binds = array($employee_id,2,$pay_date);
// 		$query = $this->db->query($sql, $binds);
// 		$result = $query->result();
// 		return $result;
// 	}
	
	// get overtime request>admin>all
	public function get_overtime_request_count($employee_id,$pay_date) {
	    // Mengatur tanggal awal menjadi bulan sebelumnya dan tanggal 21
        $awal = date('Y-m-d', strtotime($pay_date . '-01'));
        $awal = date('Y-m-d', strtotime($awal . '-1 month +20 days'));

// Mengatur tanggal akhir menjadi tanggal 20 dari bulan yang sama
        $akhir = date('Y-m-d', strtotime($pay_date . '-01'));
        $akhir = date('Y-m-d', strtotime($akhir . '+19 days'));
		
		$sql = 'SELECT * FROM `xin_attendance_time_request` where employee_id = ? and is_approved = ? and request_date >= ? and request_date <= ?';
		$binds = array($employee_id,2,$awal,$akhir);
		$query = $this->db->query($sql, $binds);
		$result = $query->result();
		return $result;
	}
	
	public function total_overtime_worked($id,$attendance_date) {

// Mengatur tanggal awal menjadi bulan sebelumnya dan tanggal 21
        $awal = date('Y-m-d', strtotime($attendance_date . '-01'));
        $awal = date('Y-m-d', strtotime($awal . '-1 month +20 days'));

// Mengatur tanggal akhir menjadi tanggal 20 dari bulan yang sama
        $akhir = date('Y-m-d', strtotime($attendance_date . '-01'));
        $akhir = date('Y-m-d', strtotime($akhir . '+19 days'));
        
		$sql = 'SELECT clock_out FROM xin_attendance_time WHERE employee_id = ? and attendance_date >= ? and attendance_date <= ?;';
		$binds = array($id,$awal,$akhir);
		$query = $this->db->query($sql, $binds);
		return $query;
	}
	
	
}
?>

Batal

⬅ application 55 item

Nama	Tipe	Ukuran	Diubah	Perm	Aksi
🐘 Announcement_model.php	php	1.9 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Assets_model.php	php	3.2 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Awards_model.php	php	2.1 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Chat_model.php	php	4.8 KB	20/05/24 10:11	0644	✏️ ⬇
🐘 Clients_model.php	php	6.7 KB	20/05/24 13:16	0644	✏️ ⬇
🐘 Company_model.php	php	4.7 KB	04/06/24 09:51	0644	✏️ ⬇
🐘 Complaints_model.php	php	1.7 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Custom_fields_model.php	php	6.6 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Department_model.php	php	5.3 KB	03/06/24 15:33	0644	✏️ ⬇
🐘 Designation_model.php	php	2.6 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Elogin_model.php	php	1.9 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Employee_exit_model.php	php	2.9 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Employees_model.php	php	52.2 KB	19/06/24 10:28	0644	✏️ ⬇
🐘 Events_model.php	php	1.7 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Exin_model.php	php	42.7 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Expense_model.php	php	2.6 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Files_model.php	php	2.8 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Files_model1.php	php	2.9 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Finance_model.php	php	15.7 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Goal_tracking_model.php	php	3.2 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Invoices_model.php	php	5.4 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Job_post_model.php	php	12.9 KB	10/07/24 11:17	0644	✏️ ⬇
🐘 Languages_model.php	php	1.5 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Location_model.php	php	2.2 KB	04/06/24 10:10	0644	✏️ ⬇
🐘 Login_model.php	php	4.1 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Meetings_model.php	php	1.7 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Overtime_request_model.php	php	3.7 KB	06/06/24 11:52	0644	✏️ ⬇
🐘 Payroll_model.php	php	25.8 KB	14/06/24 09:31	0644	✏️ ⬇
🐘 Performance_appraisal_model.php	php	4.3 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Performance_incidental_model.php	php	2.4 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Performance_indicator_model.php	php	4.3 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Performance_maingoals_model.php	php	2.1 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Performance_report_model.php	php	1.5 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Performance_variable_model.php	php	3.1 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Policy_model.php	php	1.5 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Project_model.php	php	17.5 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Promotion_model.php	php	1.7 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Quoted_project_model.php	php	17.8 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Quotes_model.php	php	4 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Recruitment_model.php	php	9.2 KB	21/06/24 08:33	0644	✏️ ⬇
🐘 Reports_model.php	php	6.8 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Resignation_model.php	php	2 KB	10/06/24 14:47	0644	✏️ ⬇
🐘 Roles_model.php	php	1.4 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Tax_model.php	php	1.4 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Termination_model.php	php	2.2 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Tickets_model.php	php	6 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Timesheet_model.php	php	21.9 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Trainers_model.php	php	1.6 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Training_model.php	php	3.3 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Transfers_model.php	php	2.3 KB	04/06/24 10:50	0644	✏️ ⬇
🐘 Travel_model.php	php	1.9 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Users_model.php	php	8 KB	27/06/24 15:56	0644	✏️ ⬇
🐘 Warning_model.php	php	2.1 KB	19/05/24 13:22	0644	✏️ ⬇
🐘 Xin_model.php	php	114.6 KB	10/06/24 15:01	0644	✏️ ⬇
🌐 index.html	html	131 B	19/05/24 13:22	0644	✏️ ⬇

✏️ Rename

🔑 Ubah Permission