<?php

class Bos extends CI_Controller {

    function __construct() {
        parent::__construct();
        $this->load->helper('url');
        $this->load->model('bos_model');
        $this->load->helper('html');
    }

    function index($offset = 0) {
        $uri_segment = 3;
        $offset = $this->uri->segment($uri_segment);
        $bps = $this->bos_model->tampilan(5, $offset);

        $config['base_url'] = site_url() . '/bos/index';
        $config['total_rows'] = $this->bos_model->count_all();
        $config['per_page'] = '5';
        $config['uri_segment'] = $uri_segment;
        $this->pagination->initialize($config);

        $data['tampilan'] = $bps;
        $data['create_links'] = $this->pagination->create_links();
        $this->load->view('bos_view', $data);
    }

    function cari($offset = 0) {
        $limit = 5;
        $uri_segment = 3;

        $config['base_url'] = site_url('bos/cari');
        $config['total_rows'] = $this->bos_model->total_pencarian('bps');
        $config['per_page'] = $limit;
        $config['uri_segment'] = $uri_segment;
        $config['full_tag_open'] = '';
        $config['full_tag_close'] = '';
        $this->pagination->initialize($config);

        $data['create_links'] = $this->pagination->create_links();
        $data['tampilan'] = $this->bos_model->caridata();
        $data['total_pencarian'] = $this->bos_model->total_pencarian();

        if ($data['total_pencarian'] == NULL) {
            echo "data tidak ada";
            echo anchor('bos', 'kembali');
        } else {
            $this->load->view('bos_view', $data);
        }
    }

}

?>

-------Model-------

<?php

class bos_model extends CI_Model {

    function tampilan($limit = 5, $offset = 0) {
        $this->db->select('nama_propinsi, nama_kabupaten, nama_kecamatan, nama_desa,NBS,NSBS,NUS,NUP,nama_sampel,NAMA,ALAMAT,RT,RW,KODEPOS,TELEPON,EXT,FAX,EMAIL,HOMEPAGE,kegiatan,nama_kategori,label,nama_pengusaha', $limit, $offset);
        $this->db->from('ukm');
        $this->db->JOIN('desa', 'ukm.id_desa = desa.id_desa');
        $this->db->JOIN('kecamatan', 'desa.id_kecamatan = kecamatan.id_kecamatan');
        $this->db->JOIN('kabupaten', 'kecamatan.id_kabupaten = kabupaten.id_kabupaten');
        $this->db->JOIN('propinsi', 'kabupaten.id_propinsi = propinsi.id_propinsi');
        $this->db->JOIN('kbli', 'ukm.kode_kbli = kbli.kode_kbli');
        $this->db->JOIN('tbl_kategori', 'kbli.kode_kategori = tbl_kategori.kode_kategori');
        $this->db->JOIN('sampel ', 'ukm.jenis_sampel = sampel.jenis_sampel');
        $this->db->limit($limit,$offset);
        return $this->db->get()->result();
    }

    function count_all() {

        $result = $this->db->select('nama_propinsi, nama_kabupaten, nama_kecamatan, nama_desa,NBS,NSBS,NUS,NUP,NUP,nama_sampel,NAMA,ALAMAT,RT,RW,KODEPOS,TELEPON,EXT,FAX,EMAIL,HOMEPAGE,kegiatan,nama_kategori,label,nama_pengusaha');
        $this->db->from('ukm');
        $this->db->JOIN('desa', 'ukm.id_desa = desa.id_desa');
        $this->db->JOIN('kecamatan', 'desa.id_kecamatan = kecamatan.id_kecamatan');
        $this->db->JOIN('kabupaten', 'kecamatan.id_kabupaten = kabupaten.id_kabupaten');
        $this->db->JOIN('propinsi', 'kabupaten.id_propinsi = propinsi.id_propinsi');
        $this->db->JOIN('kbli', 'ukm.kode_kbli = kbli.kode_kbli');
        $this->db->JOIN('tbl_kategori', 'kbli.kode_kategori = tbl_kategori.kode_kategori');
        $this->db->JOIN('sampel ', 'ukm.jenis_sampel = sampel.jenis_sampel');
    }

    function caridata($limit = 5, $offset = 0) {
        $c = $this->input->POST('cari');
        $this->db->like('nama_pengusaha', $c);
        $this->db->select('nama_propinsi, nama_kabupaten,nama_kecamatan,nama_desa,NBS,NSBS,NUS,NUP,nama_sampel,NAMA,ALAMAT,RT,RW,KODEPOS,TELEPON,EXT,FAX,EMAIL,HOMEPAGE,kegiatan,nama_kategori,label,nama_pengusaha', $limit, $offset);
        $this->db->from('ukm');
        $this->db->JOIN('desa', 'ukm.id_desa = desa.id_desa');
        $this->db->JOIN('kecamatan', 'desa.id_kecamatan = kecamatan.id_kecamatan');
        $this->db->JOIN('kabupaten', 'kecamatan.id_kabupaten = kabupaten.id_kabupaten');
        $this->db->JOIN('propinsi', 'kabupaten.id_propinsi = propinsi.id_propinsi');
        $this->db->JOIN('kbli', 'ukm.kode_kbli = kbli.kode_kbli');
        $this->db->JOIN('tbl_kategori', 'kbli.kode_kategori = tbl_kategori.kode_kategori');
        $this->db->JOIN('sampel ', 'ukm.jenis_sampel = sampel.jenis_sampel');
        $this->db->limit($limit,$offset);
        return $this->db->get()->result();
    }

    function total_pencarian() {
        $c = $this->input->POST('cari');
        $this->db->like('nama_pengusaha', $c);
        $query = $this->db->query('
SELECT nama_propinsi, nama_kabupaten, nama_kecamatan, nama_desa,NBS,NSBS,NUS,NUP,nama_sampel,NAMA,ALAMAT,RT,RW,KODEPOS,TELEPON,EXT,FAX,EMAIL,HOMEPAGE,kegiatan,nama_kategori,label,nama_pengusaha FROM ukm
join desa on ukm.id_desa = desa.id_desa
join kecamatan on desa.id_kecamatan = kecamatan.id_kecamatan
JOIN kabupaten on kecamatan.id_kabupaten = kabupaten.id_kabupaten
JOIN propinsi on kabupaten.id_propinsi = propinsi.id_propinsi
JOIN kbli on ukm.kode_kbli = kbli.kode_kbli
JOIN tbl_kategori on kbli.kode_kategori = tbl_kategori.kode_kategori
JOIN sampel on ukm.jenis_sampel = sampel.jenis_sampel');
        return $query->num_rows();
    }

}

?>

-------View-------


<center>
<h3>Tabel data mahasiswa<h3>


<table border=1 >
<tr>

<td>Propinsi</td>
        <td>Kabupaten</td>
        <td>Kecamatan</td>
        <td>Desa</td>
        <td>NBS</td>
        <td>NSBS</td>
        <td>NUS</td>
        <td>NUP</td>
        <td>Jenis Sampel</td>
        <td>Nama</td>
        <td>Alamat</td>
        <td>RT</td>
        <td>RW</td>
        <td>Kode Pos</td>
        <td>Telepon</td>
        <td>Ext</td>
        <td>Fax</td>
        <td>Email</td>
        <td>Homepage</td>
        <td>Kegiatan</td>
        <td>Kode Kategori</td>
        <td>Label</td>
        <td>Nama Pengusaha</td>
</tr>
<?php foreach($tampilan as $row) : ?>
<tr>


        <td><?php echo $row->nama_propinsi; ?></td>
        <td><?php echo $row->nama_kabupaten; ?></td>
        <td><?php echo $row->nama_kecamatan; ?></td>
        <td><?php echo $row->nama_desa; ?></td>
        <td><?php echo $row->NBS; ?></td>
        <td><?php echo $row->NSBS; ?></td>
        <td><?php echo $row->NUS; ?></td>
        <td><?php echo $row->NUP; ?></td>
        <td><?php echo $row->nama_sampel; ?></td>
        <td><?php echo $row->NAMA; ?></td>
        <td><?php echo $row->ALAMAT; ?></td>
        <td><?php echo $row->RT; ?></td>
        <td><?php echo $row->RW; ?></td>
        <td><?php echo $row->KODEPOS; ?></td>
        <td><?php echo $row->TELEPON; ?></td>
        <td><?php echo $row->EXT; ?></td>
        <td><?php echo $row->FAX; ?></td>
        <td><?php echo $row->EMAIL; ?></td>
        <td><?php echo $row->HOMEPAGE; ?></td>
        <td><?php echo $row->kegiatan; ?></td>
        <td><?php echo $row->nama_kategori; ?></td>
        <td><?php echo $row->label; ?></td>
        <td><?php echo $row->nama_pengusaha; ?></td>
</tr>
<?php endforeach; ?>

</table>
<?php echo $create_links; ?>
<br>
<form action="<?php echo site_url();?>/bos/cari" method=POST>
    <input type=text name=cari>
    <input type=submit value="cari">
    </input></form>
    <?php $total_pencarian = '';?>
Total Pencarian <?php echo $total_pencarian?>
<br>
<a href="<?php echo site_url();?>/bos">Tampilkan Semua</a>
</br>