Untitled

    public function view_pj_header($id){
        return $this->db->query("Select a.id_peminjaman as id_peminjaman, a.kd_pinjam as kd_pinjam, a.tgl_pinjam as tgl_pinjam, 
        b.nama_karyawan, a.lokasi as lokasi, a.no_projek as no_projek
        from mst_peminjaman a
        left join mst_karyawan b on b.nik = a.user_create
        where a.id_peminjaman = '".$id."'");
    }

public function get_latest_ticket_pj(){
        $this->db->select('kd_pinjam');
        $this->db->from('mst_peminjaman');
        $this->db->order_by('kd_pinjam', 'DESC');
        $this->db->limit(1);
        $query = $this->db->get();

        if ($query->num_rows() > 0) {
            $row = $query->row();
            return $row->kd_pinjam;
        } else {
            return ""; // Jika tidak ada nomor tiket sebelumnya
        }
    }