Advertisement
Guest User

pendaftaran.php

a guest
Jul 6th, 2018
332
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 35.25 KB | None | 0 0
  1. <?php
  2. //masalahnya ada di baris ke 62 gan di $sql_data_tindakan
  3. if (!defined('BASEPATH'))
  4.     exit('No direct script access allowed');
  5.  
  6. class Pendaftaran extends CI_Controller
  7. {
  8.    
  9.     public $rm = array();
  10.  
  11.     function __construct()
  12.     {
  13.         parent::__construct();
  14.         is_login();
  15.         $this->rm = $this->db->query("SELECT rt.no_rekamedis FROM tbl_riwayat_tindakan as rt, tbl_pendaftaran as pd where rt.no_rekamedis = pd.no_rekamedis");
  16.         $this->load->model('Tbl_pendaftaran_model');
  17.         $this->load->library('form_validation');
  18.     }
  19.  
  20.  
  21.  
  22.     public function index()
  23.     {
  24.         $q = urldecode($this->input->get('q', TRUE));
  25.         $start = intval($this->uri->segment(3));
  26.        
  27.         if ($q <> '') {
  28.             $config['base_url'] = base_url() . '.php/c_url/index.html?q=' . urlencode($q);
  29.             $config['first_url'] = base_url() . 'index.php/pendaftaran/index.html?q=' . urlencode($q);
  30.         } else {
  31.             $config['base_url'] = base_url() . 'index.php/pendaftaran/index/';
  32.             $config['first_url'] = base_url() . 'index.php/pendaftaran/index/';
  33.         }
  34.  
  35.         $config['per_page'] = 10;
  36.         $config['page_query_string'] = FALSE;
  37.         $config['total_rows'] = $this->Tbl_pendaftaran_model->total_rows($q);
  38.         $pendaftaran = $this->Tbl_pendaftaran_model->get_limit_data($config['per_page'], $start, $q);
  39.         $config['full_tag_open'] = '<ul class="pagination pagination-sm no-margin pull-right">';
  40.         $config['full_tag_close'] = '</ul>';
  41.         $this->load->library('pagination');
  42.         $this->pagination->initialize($config);
  43.  
  44.         $data = array(
  45.             'pendaftaran_data' => $pendaftaran,
  46.             'q' => $q,
  47.             'pagination' => $this->pagination->create_links(),
  48.             'total_rows' => $config['total_rows'],
  49.             'start' => $start,
  50.         );
  51.         $this->template->load('template','pendaftaran/tbl_pendaftaran_list', $data);
  52.     }
  53.  
  54.     function detail($id){
  55.  
  56.       $no_rawat = substr($this->uri->uri_string(3), 19);
  57.       $sa = $this->Tbl_pendaftaran_model->get_by_id($id);
  58.       $sql_no_rekmed = "SELECT no_rekamedis from tbl_pasien";
  59.       $sql_daftar = "SELECT pd.no_rekamedis, pd.no_rawat,ps.nama_pasien FROM tbl_pendaftaran as pd, tbl_pasien as ps WHERE pd.no_rekamedis = ps.no_rekamedis and pd.no_rawat = '$no_rawat'";
  60.       $sql_penyakit = "SELECT pd.no_rekamedis, pd.no_rawat,dg.nama_penyakit FROM tbl_pendaftaran as pd, tbl_diagnosa_penyakit as dg WHERE pd.no_rekamedis and pd.no_rawat = '$no_rawat'";
  61.       $sql_poli_input_rekmed = "SELECT pd.no_rawat,pd.id_poli, p.nama_poli FROM tbl_pendaftaran as pd, tbl_poli as p WHERE pd.no_rawat = '$no_rawat' AND pd.id_poli = p.id_poli";
  62.       $sql_data_tindakan = "SELECT rt.id_poli, rt.kode_penyakit,rt.kode_tindakan,rt.no_rawat,rt.hasil_periksa,rt.nama_obat,rt.tanggal,p.nama_poli, pkt.nama_penyakit, t.nama_tindakan FROM tbl_riwayat_tindakan as rt, tbl_tindakan as t, tbl_poli as p, tbl_diagnosa_penyakit as pkt, tbl_pendaftaran as pd WHERE rt.no_rekamedis = $sa->no_rekamedis AND rt.kode_tindakan = t.kode_tindakan AND rt.id_poli = p.id_poli AND rt.kode_penyakit = pkt.kode_diagnosa";
  63.       $sql_data_resep = "SELECT rt.nama_obat, rt.jenis_obat,rt.dosis_aturan_obat,rt.no_rawat,rt.tanggal, pkt.nama_pasien FROM tbl_resep_obat as rt, tbl_pasien as pkt WHERE rt.no_rawat = '$no_rawat' AND rt.no_rekamedis = pkt.no_rekamedis";
  64.       //$sql_nama_obat = "SELECT tro.kode_resep, tro.kode_obat, tso.kd_obat, tso.nama_obat FROM tbl_resep_obat as tro, tbl_stok_obat as tso WHERE tro.kode_resep = '1' AND tro.kode_obat = tso.kd_obat";
  65.  
  66.       $data['pendaftaran'] = $this->db->query($sql_daftar)->row_array();
  67.       $data['penyakit'] = $this->db->query($sql_penyakit)->row_array();
  68.       $data['baca_poli'] = $this->db->query($sql_poli_input_rekmed)->row_array();
  69.       $data['no_rawat'] = $no_rawat;
  70.       $data['data_tindakan'] = $this->db->query($sql_data_tindakan)->result();
  71.       $data['data_resep'] = $this->db->query($sql_data_resep)->result();
  72.       //$data['nama_obat'] = $this->db->query($sql_nama_obat)->row_array();
  73.  
  74.       $this->template->load('template', 'pendaftaran/detail', $data);
  75.  
  76.  
  77.  
  78.     }
  79.  
  80.      function cetak(){
  81.  
  82.     $no_rawat = substr($this->uri->uri_string(3), 27);
  83.      
  84.       $sql_data_resep = "SELECT dok.kode_dokter,dok.nama_dokter,dok.jenis_kelamin,dok.nomor_induk_dokter,dok.tempat_lahir,dok.tgl_lahir,dok.alamat, pol.nama_poli FROM tbl_dokter as dok, tbl_poli as pol WHERE dok.id_poli = pol.id_poli";
  85.  
  86.     $sql_rekamedis    = "SELECT tr.*,pd.no_rawat,pd.tanggal_daftar
  87.                        FROM tbl_riwayat_tindakan as tr, tbl_pendaftaran as pd
  88.                        WHERE pd.no_rawat and tr.no_rawat='$no_rawat'";
  89.  
  90.         $this->load->library('pdf');
  91.         $pdf = new FPDF('l', 'mm', array(380,380));
  92.         // membuat halaman baru
  93.         $pdf->AddPage();
  94.         // setting jenis font yang akan digunakan
  95.         $pdf->SetFont('Arial', 'B', 16);
  96.  
  97.         $pdf->Image('http://localhost/puskesmas/assets/foto_profil/logo-rs.jpg', 50, 5, 30);
  98.         //$pdf->Image('', )
  99.         // mencetak string
  100.         $pdf->Cell(45, 7, '', 0, 0, 'C');
  101.         $pdf->Cell(260, 7, 'PUSKESMAS WADAS', 0, 1, 'C');
  102.         $pdf->SetFont('Arial', '', 12);
  103.         $pdf->Cell(40, 7, '', 0, 0, 'C');
  104.         $pdf->Cell(275, 7, 'Jl. Pintu Air,Kp. Sindangsari, Desa Wadas No.17, Telukjambe Timur, Karawang.', 0, 1, 'C');
  105.         $pdf->Cell(80, 7, '', 0, 0, 'C');
  106.         $pdf->Cell(190, 7, 'Telepon : (0267) 4218872. E-mail: puskeswadas@gmail.com', 0, 1, 'C');
  107.         $pdf->Line(10,35, 390-20, 35);
  108.         $pdf->Line(10,35.5, 390-20, 35.5);
  109.        
  110.         $pdf->Cell(30, 7, '', 0, 1);
  111.  
  112.         $pdf->Cell(70, 7, '', 0, 0, 'C');
  113.         $pdf->Cell(190, 7, 'Laporan Data Pegawai', 0, 1, 'C');
  114.  
  115.  
  116.  
  117.  
  118.         //tabel hasil rekam medik
  119.         $pdf->Cell(1,7, '',0,0,'C');
  120.         $pdf->Cell(40, 7, 'Kode Dokter : ', 1, 0, 'C');
  121.         $pdf->Cell(45, 7, 'Nama Dokter : ', 1, 0, 'C');
  122.         $pdf->Cell(60, 7, 'Jenis Kelamin : ', 1, 0, 'C');
  123.         $pdf->Cell(50, 7, 'Nomor Induk Dokter : ', 1, 0, 'C');
  124.         $pdf->Cell(35, 7, 'Tempat Lahir : ', 1, 0, 'C');
  125.         $pdf->Cell(35, 7, 'Tanggal Lahir : ', 1, 0, 'C');
  126.         $pdf->Cell(50, 7, 'Alamat : ', 1, 0, 'C');
  127.         $pdf->Cell(40, 7, 'Nama Poli : ', 1, 1, 'C');
  128.  
  129.  
  130.  
  131.         $resep = $this->db->query($sql_data_resep)->result();
  132.         foreach ($resep as $r) {
  133.         $pdf->Cell(1,7, '',0,0,'C');
  134.         $pdf->Cell(40, 7, $r->kode_dokter, 1, 0, 'C');
  135.         $pdf->Cell(45, 7, $r->nama_dokter, 1, 0, 'C');
  136.         $pdf->Cell(60, 7, $r->jenis_kelamin, 1, 0, 'C');
  137.         $pdf->Cell(50, 7, $r->nomor_induk_dokter, 1, 0, 'C');
  138.         $pdf->Cell(35, 7, $r->tempat_lahir, 1, 0, 'C');
  139.         $pdf->Cell(35, 7, date('d-m-Y',strtotime($r->tgl_lahir)), 1, 0, 'C');
  140.         $pdf->Cell(50, 7, $r->alamat, 1, 0, 'C');
  141.         $pdf->Cell(40, 7, $r->nama_poli, 1, 1, 'C');
  142.         }
  143.  
  144.  
  145.         $pdf->Cell(130, 10, '', 0, 1);
  146.         $pdf->Cell(130, 10, '', 0, 1);
  147.         $pdf->Cell(110, 10, '', 0, 0);
  148.         $pdf->Cell(155, 10, 'Waktu Cetak', 0, 0, 'R');
  149.         $pdf->Cell(43, 10, ': '.date('d-m-Y '), 0, 0, 'R');
  150.  
  151.  
  152.         $pdf->Output();
  153.     }
  154.  
  155.     public function read()
  156.     {
  157.  
  158.         $row = $this->Tbl_pendaftaran_model->get_by_id($id);
  159.         if ($row) {
  160.             $data = array(
  161.         'no_registrasi' => $row->no_registrasi,
  162.         'no_rawat' => $row->no_rawat,
  163.         'no_rekamedis' => $row->no_rekamedis,
  164.         'tanggal_daftar' => $row->tanggal_daftar,
  165.         'kode_dokter_penanggung_jawab' => $row->kode_dokter_penanggung_jawab,
  166.         'id_poli' => $row->id_poli,
  167.         'nama_penanggung_jawab' => $row->nama_penanggung_jawab,
  168.         'hubungan_dengan_penanggung_jawab' => $row->hubungan_dengan_penanggung_jawab,
  169.         'alamat_penanggung_jawab' => $row->alamat_penanggung_jawab,
  170.         );
  171.             $this->template->load('template','pendaftaran/tbl_pendaftaran_read', $data);
  172.         } else {
  173.             $this->session->set_flashdata('message', 'Record Not Found');
  174.             redirect(site_url('pendaftaran'));
  175.         }
  176.     }
  177.  
  178.     function autocompleteDokter() {
  179.         $this->db->like('nama_dokter', $_GET['term']);
  180.         $this->db->select('nama_dokter');
  181.         $datadokter = $this->db->get('tbl_dokter')->result();
  182.         foreach ($datadokter as $dokter) {
  183.             $return_arr[] = $dokter->nama_dokter;
  184.         }
  185.  
  186.         echo json_encode($return_arr);
  187.     }
  188.  
  189.    
  190.  
  191.      function autocompletePenyakit() {
  192.         $this->db->like('nama_penyakit', $_GET['term']);
  193.         $this->db->select('nama_penyakit');
  194.         $datapenyakit = $this->db->get('tbl_diagnosa_penyakit')->result();
  195.         foreach ($datapenyakit as $penyakit) {
  196.             $return_arr[] = $penyakit->nama_penyakit;
  197.         }
  198.  
  199.         echo json_encode($return_arr);
  200.     }
  201.  
  202.     function PenyakitAuto() {
  203.        autocomplate_json('tbl_diagnosa_penyakit', 'nama_penyakit');
  204.  
  205.         }
  206.  
  207.      function autocompletemedicine() {
  208.        autocomplate_json('tbl_obat', 'nama_obat');
  209.  
  210.         }
  211.  
  212.        
  213.    
  214.  
  215.     function autocomplate(){
  216.         autocomplate_json('tbl_obat', 'nama_obat');
  217.     }
  218.  
  219.     //function autoobat(){
  220.      //   autocomplate_json('tbl_obat', 'nama_obat');
  221.    // }
  222.  
  223.      function autocompleteTindakan() {
  224.         $this->db->like('nama_tindakan', $_GET['term']);
  225.         $this->db->select('nama_tindakan');
  226.         $datatindakan = $this->db->get('tbl_tindakan')->result();
  227.         foreach ($datatindakan as $tindakan) {
  228.             $return_arr[] = $tindakan->nama_tindakan;
  229.         }
  230.  
  231.         echo json_encode($return_arr);
  232.     }
  233.  
  234.     function autocompletePoli() {
  235.         $this->db->like('nama_poli', $_GET['term']);
  236.         $this->db->select('nama_poli');
  237.         $datapoli = $this->db->get('tbl_poli')->result();
  238.         foreach ($datapoli as $poli) {
  239.             $return_arr[] = $poli->nama_poli;
  240.         }
  241.  
  242.         echo json_encode($return_arr);
  243.     }
  244.    function autonorekamedis(){
  245.  
  246.          $this->db->like('no_rekamedis', $_GET['term']);
  247.         $this->db->select('no_rekamedis');
  248.         $datapasien = $this->db->get('tbl_pasien')->result();
  249.         foreach ($datapasien as $pasien) {
  250.             $return_array[] = $pasien->no_rekamedis;
  251.         }
  252.  
  253.         echo json_encode($return_array);  
  254.    }
  255.  
  256.    function autofill(){
  257.  
  258.     $no_rekamedis = $_GET['no_rekamedis'];
  259.  
  260.     $this->db->where('no_rekamedis',$no_rekamedis);
  261.  
  262.     $pasien = $this->db->get('tbl_pasien')->row_array();
  263.     $data = array(
  264.  
  265.         'nama_pasien' => $pasien['nama_pasien'],
  266.         'tanggal_lahir' => date('d-m-Y',strtotime($pasien['tanggal_lahir']))
  267.         );
  268.  
  269.     echo json_encode($data);
  270.    }
  271.  
  272.     function autofillobat(){
  273.  
  274.     $nama_obat = $_GET['nama_obat'];
  275.  
  276.     $this->db->where('nama_obat',$nama_obat);
  277.  
  278.     $obat = $this->db->get('tbl_obat')->row_array();
  279.  
  280.     $data = array(
  281.         'jenis_obat' => $obat['jenis_obat'],
  282.         'dosis_aturan_obat' => $obat['dosis_aturan_obat']
  283.         );
  284.  
  285.     echo json_encode($data);
  286.    }
  287.  
  288.  
  289.  
  290.    function periksa_action(){
  291.  
  292.         $no_rawat = $this->input->post('no_rawat');
  293.         $no_rekamedis = $this->input->post('no_rekamedis');
  294.         $nama_poli = $this->input->post('nama_poli');
  295.         $poli = $this->db->get_where('tbl_poli',array('nama_poli' => $nama_poli))->row_array();
  296.         $nama_penyakit = $this->input->post('nama_penyakit');
  297.         $penyakit = $this->db->get_where('tbl_diagnosa_penyakit', array('nama_penyakit' => $nama_penyakit))->row_array();
  298.         $nama_dokter = $this->input->post('nama_dokter');
  299.         $dokter = $this->db->get_where('tbl_dokter', array('nama_dokter' => $nama_dokter))->row_array();
  300.         $nama_tindakan = $this->input->post('nama_tindakan');
  301.         $tindakan = $this->db->get_where('tbl_tindakan', array('nama_tindakan' => $nama_tindakan))->row_array();
  302.         $hasil_periksa = $this->input->post('hasil_periksa');
  303.         $nama_obat = $this->input->post('nama_obat');
  304.  
  305.         $data = array(
  306.             'no_rawat' => $no_rawat,
  307.             'no_rekamedis' => $no_rekamedis,
  308.             'id_poli' => $poli['id_poli'],
  309.             'kode_penyakit' => $penyakit['kode_diagnosa'],
  310.             'kode_tindakan' => $tindakan['kode_tindakan'],
  311.             'hasil_periksa' => $hasil_periksa,
  312.             'nama_obat' => $nama_obat,
  313.             'tanggal' => date('Y-m-d')
  314.            );
  315.  
  316.         $this->db->insert('tbl_riwayat_tindakan', $data);
  317.         $id_riwayat_tindakan = $this->db->insert_id();
  318.  
  319.         redirect('pendaftaran/detail/'.$no_rawat);
  320.  
  321.    }
  322.  
  323.    function resep_action(){
  324.  
  325.     $no_rawat = $this->input->post('no_rawat');
  326.     $sql_daftar = "SELECT pd.no_rekamedis, pd.no_rawat,ps.nama_pasien FROM tbl_pendaftaran as pd, tbl_pasien as ps WHERE pd.no_rekamedis = ps.no_rekamedis and pd.no_rawat = '$no_rawat'";
  327.     $data['pendaftaran'] = $this->db->query($sql_daftar)->row_array();
  328.  
  329.     $kode_resep = $this->input->post('kode_resep');
  330.     $nama_obat = $this->input->post('nama_obats');
  331.     $obat = $this->db->get_where('tbl_obat', array('nama_obat' => $nama_obat))->row_array();
  332.     $jenis_obat = $this->input->post('jenis_obat');
  333.     $obatj = $this->db->get_where('tbl_obat', array('jenis_obat' => $jenis_obat))->row_array();
  334.     $dosis_aturan_obat = $this->input->post('dosis_aturan_obat');
  335.     $jumlah_obat = $this->input->post('jumlah_obat');
  336.     $obatd = $this->db->get_where('tbl_obat', array('dosis_aturan_obat' => $dosis_aturan_obat))->row_array();
  337.     $no_rekamedis = $this->input->post('no_rekamedis');
  338.  
  339.     $data = array(
  340.         'kode_resep' => $kode_resep,
  341.         'nama_obat' => $nama_obat,
  342.         'jenis_obat' => $jenis_obat,
  343.         'dosis_aturan_obat' => $dosis_aturan_obat,
  344.         'jumlah_obat' => $jumlah_obat,
  345.         'no_rawat' => $no_rawat,
  346.         'no_rekamedis' => $no_rekamedis,
  347.         'tanggal' => date('Y-m-d')
  348.         );
  349.     $this->db->insert('tbl_resep_obat', $data);
  350.     redirect('pendaftaran/detail/'.$no_rawat);
  351.    }
  352.  
  353.    function rujukan_action(){
  354.  
  355.     $no_rawat = $this->input->post('no_rawat');
  356.    
  357.  
  358.     $kode_rujukan = $this->input->post('kode_rujukan');
  359.     $no_rujukan = $this->input->post('no_rujukan');
  360.     $nama_pasien = $this->input->post('nama_pasien');
  361.     $nama_penyakit = $this->input->post('nama_penyakitz');
  362.     $diagnosa = $this->input->post('diagnosa');
  363.     $nama_rumah_sakit = $this->input->post('nama_rumah_sakit');
  364.     $poli_tujuan = $this->input->post('poli_tujuan');
  365.  
  366.    
  367.     $data = array(
  368.         'kode_rujukan' => $kode_rujukan,
  369.         'no_rujukan' => $no_rujukan,
  370.         'nama_pasien' => $nama_pasien,
  371.         'nama_penyakit' => $nama_penyakit,
  372.         'diagnosa' => $diagnosa,
  373.         'nama_rumah_sakit' => $nama_rumah_sakit,
  374.         'poli_tujuan' => $poli_tujuan,
  375.         'tgl_rujukan' => date('Y-m-d'),
  376.         'no_rawat' => $no_rawat
  377.         );
  378.     $this->db->insert('tbl_rujukan', $data);
  379.     redirect('pendaftaran/detail/'.$no_rawat);
  380.    }
  381.  
  382.     public function create()
  383.     {
  384.         $noreg = noRegistrasiotomatis();
  385.         $data = array(
  386.             'button' => 'Create',
  387.             'action' => site_url('pendaftaran/create_action'),
  388.         'no_registrasi' => set_value('no_registrasi', $noreg),
  389.         'no_rawat' => set_value('no_rawat'),
  390.         'no_rekamedis' => set_value('no_rekamedis'),
  391.         'tanggal_daftar' => set_value('tanggal_daftar'),
  392.         'kode_dokter_penanggung_jawab' => set_value('kode_dokter_penanggung_jawab'),
  393.         'id_poli' => set_value('id_poli'),
  394.         'nama_penanggung_jawab' => set_value('nama_penanggung_jawab'),
  395.         'hubungan_dengan_penanggung_jawab' => set_value('hubungan_dengan_penanggung_jawab'),
  396.         'alamat_penanggung_jawab' => set_value('alamat_penanggung_jawab'),
  397.     );
  398.         $this->template->load('template','pendaftaran/tbl_pendaftaran_form', $data);
  399.     }
  400.  
  401.     function cetakrekamedis(){
  402.  
  403.         $no_rawat = substr($this->uri->uri_string(3), 27);
  404.       $sql_daftar = "SELECT pd.no_rekamedis, pd.no_rawat,pd.tanggal_daftar,ps.nama_pasien, td.nama_dokter FROM tbl_pendaftaran as pd, tbl_pasien as ps, tbl_dokter as td WHERE pd.no_rekamedis = ps.no_rekamedis and td.kode_dokter = pd.kode_dokter_penanggung_jawab and pd.no_rawat = '$no_rawat'";
  405.       $sql_penyakit = "SELECT pd.no_rekamedis, pd.no_rawat,dg.nama_penyakit FROM tbl_pendaftaran as pd, tbl_diagnosa_penyakit as dg WHERE pd.no_rekamedis and pd.no_rawat = '$no_rawat'";
  406.       $sql_poli_input_rekmed = "SELECT pd.no_rawat,pd.id_poli, p.nama_poli FROM tbl_pendaftaran as pd, tbl_poli as p WHERE pd.no_rawat = '$no_rawat' AND pd.id_poli = p.id_poli";
  407.       $sql_data_tindakan = "SELECT rt.id_poli, rt.kode_penyakit,rt.kode_tindakan,rt.no_rawat,rt.hasil_periksa,rt.nama_obat,rt.tanggal,p.nama_poli, pkt.nama_penyakit, t.nama_tindakan FROM tbl_riwayat_tindakan as rt, tbl_tindakan as t, tbl_poli as p, tbl_diagnosa_penyakit as pkt, tbl_pasien as pas WHERE rt.no_rekamedis = $this->rm AND rt.kode_tindakan = t.kode_tindakan AND rt.id_poli = p.id_poli AND rt.kode_penyakit = pkt.kode_diagnosa";
  408.  
  409.     $sql_rekamedis    = "SELECT tr.*,pd.no_rawat,pd.tanggal_daftar
  410.                        FROM tbl_riwayat_tindakan as tr, tbl_pendaftaran as pd
  411.                        WHERE pd.no_rawat and tr.no_rawat='$no_rawat'";
  412.  
  413.         $this->load->library('pdf');
  414.         $pdf = new FPDF('P', 'mm', array(260,260));
  415.         // membuat halaman baru
  416.         $pdf->AddPage();
  417.         // setting jenis font yang akan digunakan
  418.         $pdf->SetFont('Arial', 'B', 16);
  419.  
  420.         $pdf->Image('http://localhost/puskesmas/assets/foto_profil/logo-rs.jpg', 22, 5, 30);
  421.         //$pdf->Image('', a)
  422.         // mencetak string
  423.         $pdf->Cell(235, 7, 'PUSKESMAS WADAS', 0, 1, 'C');
  424.         $pdf->SetFont('Arial', '', 12);
  425.         $pdf->Cell(235, 7, '          Jl. Pintu Air,Kp. Sindangsari, Desa Wadas No.17, Telukjambe Timur, Karawang.', 0, 1, 'C');
  426.         $pdf->Cell(235, 7, 'Telepon : (0267) 4218872. E-mail: puskeswadas@gmail.com', 0, 1, 'C');
  427.         $pdf->Line(10,35, 260-10, 35);
  428.         $pdf->Line(10,35.5, 260-10, 35.5);
  429.         $pdf->Cell(7, 7, '', 0, 1);
  430.         $pdf->Cell(235, 7, 'Laporan Rekam Medis', 0, 1, 'C');
  431.  
  432.  
  433.         //data rekam medik
  434.         $pasien = $this->db->query($sql_daftar)->row_array();
  435.         $pdf->Cell(30, 7, '', 0, 0, 'L');        
  436.         $pdf->Cell(30, 7, 'No.RM', 0, 0, 'L');
  437.         $pdf->Cell(90, 7, ': '.$pasien['no_rekamedis'], 0, 0, 'L'); //90 merupakan jarak antara no_rekamedis dengan isian ditangani oleh
  438.  
  439.         $pdf->Cell(45, 7, 'Ditangani Oleh', 0, 0, 'L');
  440.         $pdf->Cell(30, 7, ': '.$pasien['nama_dokter'], 0, 1, 'L');
  441.         $pdf->Cell(30, 7, '', 0, 0, 'L');        
  442.         $pdf->Cell(30, 7, 'Nama Pasien', 0, 0, 'L');
  443.         $pdf->Cell(90, 7, ': '.$pasien['nama_pasien'], 0, 0, 'L');
  444.  
  445.         $pdf->Cell(45, 7, 'Tgl. Pemeriksaan', 0, 0, 'L');
  446.         $pdf->Cell(30, 7, ': '.date('d-m-Y', strtotime($pasien['tanggal_daftar'])) ,0, 1, 'L');
  447.         $pdf->Cell(10, 10, '', 0, 1);
  448.  
  449.  
  450.         //tabel hasil rekam medik
  451.         $pdf->Cell(30, 7, 'Poli Tujuan', 1, 0, 'C');
  452.         $pdf->Cell(45, 7, 'Nama Penyakit', 1, 0, 'C');
  453.         $pdf->Cell(45, 7, 'Nama Tindakan', 1, 0, 'C');
  454.         $pdf->Cell(40, 7, 'Hasil Periksa', 1, 0, 'C');
  455.         $pdf->Cell(39, 7, 'Nama Obat', 1, 0, 'C');
  456.         $pdf->Cell(45, 7, 'Tanggal', 1, 1, 'C');
  457.  
  458.  
  459.         $tindakan = $this->db->query($sql_data_tindakan)->result();
  460.         foreach ($tindakan as $t) {
  461.            
  462.         $pdf->Cell(30, 7, $t->nama_poli, 1, 0, 'C');
  463.         $pdf->Cell(45, 7, $t->nama_penyakit, 1, 0, 'C');
  464.         $pdf->Cell(45, 7, $t->nama_tindakan, 1, 0, 'C');
  465.         $pdf->Cell(40, 7, $t->hasil_periksa, 1, 0, 'C');
  466.         $pdf->Cell(39, 7, $t->nama_obat, 1, 0, 'C');
  467.         $pdf->Cell(45, 7, date('d-m-Y', strtotime($t->tanggal)), 1, 1, 'C');
  468.  
  469.         }
  470.  
  471.  
  472.         $pdf->Cell(130, 10, '', 0, 1);
  473.         $pdf->Cell(130, 10, '', 0, 1);
  474.         $pdf->Cell(30, 7, '', 0, 0, 'L');        
  475.         $pdf->Cell(155, 10, 'Tanggal Cetak', 0, 0, 'R');
  476.         $pdf->Cell(43, 10, ': '.date('d-m-Y '), 0, 0, 'R');
  477.  
  478.  
  479.         $pdf->Output();
  480.     }
  481.  
  482.     function cetakresepobat(){
  483.  
  484.     $no_rawat = substr($this->uri->uri_string(3), 27);
  485.       $sql_daftar = "SELECT pd.no_rekamedis, pd.no_rawat,pd.tanggal_daftar,ps.nama_pasien, td.nama_dokter FROM tbl_pendaftaran as pd, tbl_pasien as ps, tbl_dokter as td WHERE pd.no_rekamedis = ps.no_rekamedis and td.kode_dokter = pd.kode_dokter_penanggung_jawab and pd.no_rawat = '$no_rawat'";
  486.       $sql_penyakit = "SELECT pd.no_rekamedis, pd.no_rawat,dg.nama_penyakit FROM tbl_pendaftaran as pd, tbl_diagnosa_penyakit as dg WHERE pd.no_rekamedis and pd.no_rawat = '$no_rawat'";
  487.       $sql_poli_input_rekmed = "SELECT pd.no_rawat,pd.id_poli, p.nama_poli FROM tbl_pendaftaran as pd, tbl_poli as p WHERE pd.no_rawat = '$no_rawat' AND pd.id_poli = p.id_poli";
  488.       $sql_data_resep = "SELECT rt.nama_obat, rt.jenis_obat,rt.dosis_aturan_obat,rt.jumlah_obat,rt.no_rawat,rt.tanggal, pkt.nama_pasien FROM tbl_resep_obat as rt, tbl_pasien as pkt WHERE rt.no_rawat = '$no_rawat' AND rt.no_rekamedis = pkt.no_rekamedis";
  489.  
  490.     $sql_rekamedis    = "SELECT tr.*,pd.no_rawat,pd.tanggal_daftar
  491.                        FROM tbl_riwayat_tindakan as tr, tbl_pendaftaran as pd
  492.                        WHERE pd.no_rawat and tr.no_rawat='$no_rawat'";
  493.  
  494.         $this->load->library('pdf');
  495.         $pdf = new FPDF('l', 'mm', 'A5');
  496.         // membuat halaman baru
  497.         $pdf->AddPage();
  498.         // setting jenis font yang akan digunakan
  499.         $pdf->SetFont('Arial', 'B', 16);
  500.  
  501.         $pdf->Image('http://localhost/puskesmas/assets/foto_profil/logo-rs.jpg', 4, 5, 30);
  502.         //$pdf->Image('', )
  503.         // mencetak string
  504.         $pdf->Cell(190, 7, 'PUSKESMAS WADAS', 0, 1, 'C');
  505.         $pdf->SetFont('Arial', '', 12);
  506.         $pdf->Cell(190, 7, '          Jl. Pintu Air,Kp. Sindangsari, Desa Wadas No.17, Telukjambe Timur, Karawang.', 0, 1, 'C');
  507.         $pdf->Cell(190, 7, 'Telepon : (0267) 4218872. E-mail: puskeswadas@gmail.com', 0, 1, 'C');
  508.         $pdf->Line(20,35, 210-20, 35);
  509.         $pdf->Line(20,35.5, 210-20, 35.5);
  510.        
  511.         $pdf->Cell(7, 7, '', 0, 1);
  512.         $pdf->Cell(190, 7, 'Laporan Resep Obat', 0, 1, 'C');
  513.  
  514.  
  515.         //data rekam medik
  516.         $pasien = $this->db->query($sql_daftar)->row_array();
  517.         $pdf->Cell(30, 7, 'Nama Pasien', 0, 0, 'L');
  518.         $pdf->Cell(110, 7, ': '.$pasien['nama_pasien'], 0, 0, 'L');
  519.  
  520.         $pdf->Cell(30, 7, 'Tanggal', 0, 0, 'L');
  521.         $pdf->Cell(30, 7, ': '.date('d-m-Y') ,0, 1, 'L');
  522.         $pdf->Cell(10, 10, '', 0, 1);
  523.  
  524.  
  525.         //tabel hasil rekam medik
  526.         $pdf->Cell(1,7, '',0,0,'C');
  527.         $pdf->Cell(35, 7, 'Nama Obat : ', 1, 0, 'C');
  528.         $pdf->Cell(45, 7, 'Jenis Obat : ', 1, 0, 'C');
  529.         $pdf->Cell(75, 7, 'Dosis Obat : ', 1, 0, 'C');
  530.         $pdf->Cell(30, 7, 'Jumlah Obat : ', 1, 1, 'C');
  531.  
  532.  
  533.  
  534.         $resep = $this->db->query($sql_data_resep)->result();
  535.         foreach ($resep as $r) {
  536.         $pdf->Cell(1,7, '',0,0,'C');
  537.         $pdf->Cell(35, 7, $r->nama_obat, 1, 0, 'C');
  538.         $pdf->Cell(45, 7, $r->jenis_obat, 1, 0, 'C');
  539.         $pdf->Cell(75, 7, $r->dosis_aturan_obat, 1, 0, 'C');
  540.         $pdf->Cell(30, 7, $r->jumlah_obat, 1, 1, 'C');
  541.  
  542.  
  543.         }
  544.  
  545.  
  546.         $pdf->Cell(130, 10, '', 0, 1);
  547.         $pdf->Cell(130, 10, '', 0, 1);
  548.         $pdf->Cell(155, 10, 'Waktu Cetak', 0, 0, 'R');
  549.         $pdf->Cell(43, 10, ': '.date('d-m-Y '), 0, 0, 'R');
  550.  
  551.  
  552.         $pdf->Output();
  553.     }
  554.  
  555.      function cetakrujukan(){
  556.  
  557.         $no_rawat = substr($this->uri->uri_string(3), 25);
  558.       $sql_daftar = "SELECT pd.no_rekamedis, pd.no_rawat,pd.tanggal_daftar,ps.nama_pasien, td.nama_dokter FROM tbl_pendaftaran as pd, tbl_pasien as ps, tbl_dokter as td WHERE pd.no_rekamedis = ps.no_rekamedis and td.kode_dokter = pd.kode_dokter_penanggung_jawab and pd.no_rawat = '$no_rawat'";
  559.       $sql_penyakit = "SELECT pd.no_rekamedis, pd.no_rawat,dg.nama_penyakit FROM tbl_pendaftaran as pd, tbl_diagnosa_penyakit as dg WHERE pd.no_rekamedis and pd.no_rawat = '$no_rawat'";
  560.       $sql_rujukan = "SELECT * FROM tbl_rujukan where no_rawat = '$no_rawat'";
  561.       $sql_data_rujukan = "SELECT nama_penyakit, diagnosa, poli_tujuan FROM tbl_rujukan where no_rawat = '$no_rawat'";
  562.       $sql_data_tindakan = "SELECT rt.id_poli, rt.kode_penyakit,rt.kode_tindakan,rt.no_rawat,rt.hasil_periksa,rt.nama_obat,rt.tanggal,p.nama_poli, pkt.nama_penyakit, t.nama_tindakan FROM tbl_riwayat_tindakan as rt, tbl_tindakan as t, tbl_poli as p, tbl_diagnosa_penyakit as pkt WHERE rt.no_rawat = '$no_rawat' AND rt.kode_tindakan = t.kode_tindakan AND rt.id_poli = p.id_poli AND rt.kode_penyakit = pkt.kode_diagnosa";
  563.  
  564.     $sql_rekamedis    = "SELECT tr.*,pd.no_rawat,pd.tanggal_daftar
  565.                        FROM tbl_riwayat_tindakan as tr, tbl_pendaftaran as pd
  566.                        WHERE pd.no_rawat and tr.no_rawat='$no_rawat'";
  567.  
  568.         $this->load->library('pdf');
  569.         $pdf = new FPDF('l', 'mm', 'A5');
  570.         // membuat halaman baru
  571.         $pdf->AddPage();
  572.         // setting jenis font yang akan digunakan
  573.         $pdf->SetFont('Arial', 'B', 16);
  574.  
  575.         $pdf->Image('http://localhost/puskesmas/assets/foto_profil/logo-rs.jpg', 4, 5, 30);
  576.         //$pdf->Image('', a)
  577.         // mencetak string
  578.         $pdf->Cell(190, 7, 'PUSKESMAS WADAS', 0, 1, 'C');
  579.         $pdf->SetFont('Arial', '', 12);
  580.         $pdf->Cell(190, 7, '          Jl. Pintu Air,Kp. Sindangsari, Desa Wadas No.17, Telukjambe Timur, Karawang.', 0, 1, 'C');
  581.         $pdf->Cell(190, 7, 'Telepon : (0267) 4218872. E-mail: puskeswadas@gmail.com', 0, 1, 'C');
  582.         $pdf->Line(20,35, 210-20, 35);
  583.         $pdf->Line(20,35.5, 210-20, 35.5);
  584.         $pdf->Cell(7, 7, '', 0, 1);
  585.         $pdf->Cell(190, 7, 'Laporan Rujukan', 0, 1, 'C');
  586.  
  587.  
  588.         //data rekam medik
  589.         $rujukan = $this->db->query($sql_rujukan)->row_array();
  590.         $pdf->Cell(30, 7, 'No.Rujukan', 0, 0, 'L');
  591.         $pdf->Cell(80, 7, ': '.$rujukan['no_rujukan'], 0, 0, 'L'); //90 merupakan jarak antara no_rekamedis dengan isian ditangani oleh
  592.  
  593.         $pdf->Cell(45, 7, 'Tanggal Dirujuk', 0, 0, 'L');
  594.         $pdf->Cell(30, 7, ': '.date('d-m-Y', strtotime($rujukan['tgl_rujukan'])), 0, 1, 'L');
  595.  
  596.         $pdf->Cell(30, 7, 'Nama Pasien', 0, 0, 'L');
  597.         $pdf->Cell(80, 7, ': '.$rujukan['nama_pasien'], 0, 0, 'L');
  598.  
  599.         $pdf->Cell(45, 7, 'Nama Rumah Sakit', 0, 0, 'L');
  600.         $pdf->Cell(30, 7, ': '.$rujukan['nama_rumah_sakit'] ,0, 1, 'L');
  601.         $pdf->Cell(10, 10, '', 0, 1);
  602.  
  603.  
  604.         //tabel hasil rekam medik
  605.         $pdf->Cell(1,7, '',0,0,'C');
  606.         $pdf->Cell(44, 7, 'Nama Penyakit', 1, 0, 'C');
  607.         $pdf->Cell(105, 7, 'Diagnosa', 1, 0, 'C');
  608.         $pdf->Cell(45, 7, 'Poli Tujuan', 1, 1, 'C');//1,(1) => (1) digunakan agar textnya bisa dilanjutkan ke bawah
  609.  
  610.         $hasil_rujukan = $this->db->query($sql_rujukan)->result();
  611.         foreach ($hasil_rujukan as $hr) {
  612.         $pdf->Cell(1,7, '',0,0,'C');
  613.         $pdf->Cell(44, 7, $hr->nama_penyakit, 1, 0, 'C');
  614.         $pdf->Cell(105, 7, $hr->diagnosa, 1, 0, 'C');
  615.         $pdf->Cell(45, 7, $hr->poli_tujuan, 1, 1, 'C');
  616.         }
  617.  
  618.  
  619.         $pdf->Cell(130, 10, '', 0, 1);
  620.         $pdf->Cell(130, 10, '', 0, 1);
  621.         $pdf->Cell(155, 10, 'Waktu Cetak', 0, 0, 'R');
  622.         $pdf->Cell(43, 10, ': '.date('d-m-Y'), 0, 0, 'R');
  623.  
  624.  
  625.         $pdf->Output();
  626.     }
  627.  
  628.     function getKodeDokter($namaDokter){
  629.  
  630.         $this->db->where('nama_dokter',$namaDokter);
  631.         $dokter = $this->db->get('tbl_dokter')->row_array();
  632.         return $dokter['kode_dokter'];
  633.     }
  634.    
  635.     public function create_action()
  636.     {
  637.         $this->_rules();
  638.  
  639.         if ($this->form_validation->run() == FALSE) {
  640.             $this->create();
  641.         } else {
  642.             $data = array(
  643.         'no_rawat' => $this->input->post('no_rawat', TRUE),
  644.         'no_registrasi' => $this->input->post('no_registrasi',TRUE),
  645.         'no_rekamedis' => $this->input->post('no_rekamedis',TRUE),
  646.         'tanggal_daftar' => $this->input->post('tanggal_daftar',TRUE),
  647.         'kode_dokter_penanggung_jawab' =>  $this->getKodeDokter($this->input->post('kode_dokter_penanggung_jawab',TRUE)),
  648.         'id_poli' => $this->input->post('id_poli',TRUE),
  649.         'nama_penanggung_jawab' => $this->input->post('nama_penanggung_jawab',TRUE),
  650.         'hubungan_dengan_penanggung_jawab' => $this->input->post('hubungan_dengan_penanggung_jawab',TRUE),
  651.         'alamat_penanggung_jawab' => $this->input->post('alamat_penanggung_jawab',TRUE)
  652.         );
  653.  
  654.             $this->Tbl_pendaftaran_model->insert($data);
  655.             $this->session->set_flashdata('message', 'Create Record Success 2');
  656.             redirect(site_url('pendaftaran'));
  657.         }
  658.     }
  659.    
  660.     public function update($id)
  661.     {
  662.         $row = $this->Tbl_pendaftaran_model->get_by_id($id);
  663.  
  664.         if ($row) {
  665.             $data = array(
  666.                 'button' => 'Update',
  667.                 'action' => site_url('pendaftaran/update_action'),
  668.         'no_registrasi' => set_value('no_registrasi', $row->no_registrasi),
  669.         'no_rawat' => set_value('no_rawat', $row->no_rawat),
  670.         'no_rekamedis' => set_value('no_rekamedis', $row->no_rekamedis),
  671.         'tanggal_daftar' => set_value('tanggal_daftar', $row->tanggal_daftar),
  672.         'kode_dokter_penanggung_jawab' => set_value('kode_dokter_penanggung_jawab', $row->kode_dokter_penanggung_jawab),
  673.         'id_poli' => set_value('id_poli', $row->id_poli),
  674.         'nama_penanggung_jawab' => set_value('nama_penanggung_jawab', $row->nama_penanggung_jawab),
  675.         'hubungan_dengan_penanggung_jawab' => set_value('hubungan_dengan_penanggung_jawab', $row->hubungan_dengan_penanggung_jawab),
  676.         'alamat_penanggung_jawab' => set_value('alamat_penanggung_jawab', $row->alamat_penanggung_jawab),
  677.         );
  678.             $this->template->load('template','pendaftaran/tbl_pendaftaran_form', $data);
  679.         } else {
  680.             $this->session->set_flashdata('message', 'Record Not Found');
  681.             redirect(site_url('pendaftaran'));
  682.         }
  683.     }
  684.    
  685.     public function update_action()
  686.     {
  687.         $this->_rules();
  688.  
  689.         if ($this->form_validation->run() == FALSE) {
  690.             $this->update($this->input->post('no_rawat', TRUE));
  691.         } else {
  692.             $data = array(
  693.         'no_registrasi' => $this->input->post('no_registrasi',TRUE),
  694.         'no_rekamedis' => $this->input->post('no_rekamedis',TRUE),
  695.         'tanggal_daftar' => $this->input->post('tanggal_daftar',TRUE),
  696.         'kode_dokter_penanggung_jawab' => $this->input->post('kode_dokter_penanggung_jawab',TRUE),
  697.         'id_poli' => $this->input->post('id_poli',TRUE),
  698.         'nama_penanggung_jawab' => $this->input->post('nama_penanggung_jawab',TRUE),
  699.         'hubungan_dengan_penanggung_jawab' => $this->input->post('hubungan_dengan_penanggung_jawab',TRUE),
  700.         'alamat_penanggung_jawab' => $this->input->post('alamat_penanggung_jawab',TRUE),
  701.         );
  702.  
  703.             $this->Tbl_pendaftaran_model->update($this->input->post('no_rawat', TRUE), $data);
  704.             $this->session->set_flashdata('message', 'Update Record Success');
  705.             redirect(site_url('pendaftaran'));
  706.         }
  707.     }
  708.    
  709.     public function delete($id)
  710.     {
  711.         $row = $this->Tbl_pendaftaran_model->get_by_id($id);
  712.  
  713.         if ($row) {
  714.             $this->Tbl_pendaftaran_model->delete($id);
  715.             $this->session->set_flashdata('message', 'Delete Record Success');
  716.             redirect(site_url('pendaftaran'));
  717.         } else {
  718.             $this->session->set_flashdata('message', 'Record Not Found');
  719.             redirect(site_url('pendaftaran'));
  720.         }
  721.     }
  722.  
  723.     public function _rules()
  724.     {
  725.     $this->form_validation->set_rules('no_registrasi', 'no registrasi', 'trim|required');
  726.     $this->form_validation->set_rules('no_rekamedis', 'no rekamedis', 'trim|required');
  727.     $this->form_validation->set_rules('no_rawat', 'no rawat', 'trim|required');
  728.     $this->form_validation->set_rules('tanggal_daftar', 'tanggal daftar', 'trim|required');
  729.     $this->form_validation->set_rules('kode_dokter_penanggung_jawab', 'kode dokter penanggung jawab', 'trim|required');
  730.     $this->form_validation->set_rules('id_poli', 'id poli', 'trim|required');
  731.     $this->form_validation->set_rules('nama_penanggung_jawab', 'nama penanggung jawab', 'trim|required');
  732.     $this->form_validation->set_rules('hubungan_dengan_penanggung_jawab', 'hubungan dengan penanggung jawab', 'trim|required');
  733.     $this->form_validation->set_rules('alamat_penanggung_jawab', 'alamat penanggung jawab', 'trim|required');
  734.     $this->form_validation->set_message('required', '{field} wajib diisi');
  735.  
  736.  
  737.     $this->form_validation->set_rules('no_rawat', 'no_rawat', 'trim');
  738.     $this->form_validation->set_error_delimiters('<span class="text-danger">', '</span>');
  739.     }
  740.  
  741.     public function excel()
  742.     {
  743.         $this->load->helper('exportexcel');
  744.         $namaFile = "tbl_pendaftaran.xls";
  745.         $judul = "tbl_pendaftaran";
  746.         $tablehead = 0;
  747.         $tablebody = 1;
  748.         $nourut = 1;
  749.         //penulisan header
  750.         header("Pragma: public");
  751.         header("Expires: 0");
  752.         header("Cache-Control: must-revalidate, post-check=0,pre-check=0");
  753.         header("Content-Type: application/force-download");
  754.         header("Content-Type: application/octet-stream");
  755.         header("Content-Type: application/download");
  756.         header("Content-Disposition: attachment;filename=" . $namaFile . "");
  757.         header("Content-Transfer-Encoding: binary ");
  758.  
  759.         xlsBOF();
  760.  
  761.         $kolomhead = 0;
  762.         xlsWriteLabel($tablehead, $kolomhead++, "No");
  763.     xlsWriteLabel($tablehead, $kolomhead++, "No Registrasi");
  764.     xlsWriteLabel($tablehead, $kolomhead++, "No Rekamedis");
  765.     xlsWriteLabel($tablehead, $kolomhead++, "Tanggal Daftar");
  766.     xlsWriteLabel($tablehead, $kolomhead++, "Kode Dokter Penanggung Jawab");
  767.     xlsWriteLabel($tablehead, $kolomhead++, "Id Poli");
  768.     xlsWriteLabel($tablehead, $kolomhead++, "Nama Penanggung Jawab");
  769.     xlsWriteLabel($tablehead, $kolomhead++, "Hubungan Dengan Penanggung Jawab");
  770.     xlsWriteLabel($tablehead, $kolomhead++, "Alamat Penanggung Jawab");
  771.  
  772.     foreach ($this->Tbl_pendaftaran_model->get_all() as $data) {
  773.             $kolombody = 0;
  774.  
  775.             //ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
  776.             xlsWriteNumber($tablebody, $kolombody++, $nourut);
  777.         xlsWriteLabel($tablebody, $kolombody++, $data->no_registrasi);
  778.         xlsWriteLabel($tablebody, $kolombody++, $data->no_rekamedis);
  779.         xlsWriteLabel($tablebody, $kolombody++, $data->tanggal_daftar);
  780.         xlsWriteNumber($tablebody, $kolombody++, $data->kode_dokter_penanggung_jawab);
  781.         xlsWriteLabel($tablebody, $kolombody++, $data->id_poli);
  782.         xlsWriteLabel($tablebody, $kolombody++, $data->nama_penanggung_jawab);
  783.         xlsWriteLabel($tablebody, $kolombody++, $data->hubungan_dengan_penanggung_jawab);
  784.         xlsWriteLabel($tablebody, $kolombody++, $data->alamat_penanggung_jawab);
  785.  
  786.         $tablebody++;
  787.             $nourut++;
  788.         }
  789.  
  790.         xlsEOF();
  791.         exit();
  792.     }
  793.  
  794.     public function word()
  795.     {
  796.         header("Content-type: application/vnd.ms-word");
  797.         header("Content-Disposition: attachment;Filename=tbl_pendaftaran.doc");
  798.  
  799.         $data = array(
  800.             'tbl_pendaftaran_data' => $this->Tbl_pendaftaran_model->get_all(),
  801.             'start' => 0
  802.         );
  803.        
  804.         $this->load->view('pendaftaran/tbl_pendaftaran_doc',$data);
  805.     }
  806.  
  807. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement