<?php

class Table extends CI_Controller
{

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

    function index()
    {
        $this->load->view("table_view");
    }


    function ambil_data()
    {

        //DASAR FONDASI DATA SERVER SIDE
        $draw=$_REQUEST['draw'];
        $length=$_REQUEST['length'];
        $start=$_REQUEST['start'];
        $search=$_REQUEST['search']["value"];
        $total=$this->db->count_all_results("Karyawan");
        $output=array();
        $output['draw']=$draw;
        $output['recordsTotal']=$output['recordsFiltered']=$total;
        $output['data']=array();

        $requestData= $_REQUEST;


    //MENDEKLARASIKAN PENCARIAN BERDASARKAN ID
        $columns = array(
        1 => 'NIP',
        2 => 'NamaPegawai',
        3 => 'NamaDepartemen'
        );


        $sql = "SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (ORDER BY NamaPegawai) as RowNum FROM Karyawan WHERE (NIP like '%%' ) ) a ";

        $search_detail = "";

        //UNTUK PENCARIAN DATA FIELD TERTENTU
        if( !empty($requestData['columns'][1]['search']['value']) )
        {
            $search_detail.=" AND NIP LIKE '".$requestData['columns'][1]['search']['value']."%' ";
        }
        if( !empty($requestData['columns'][2]['search']['value']) )
        {
            $search_detail.=" AND  NamaPegawai LIKE '".$requestData['columns'][2]['search']['value']."%' ";
        }
        if( !empty($requestData['columns'][3]['search']['value']) )
        {
            $search_detail.=" AND  NamaDepartemen LIKE '".$requestData['columns'][3]['search']['value']."%' ";
        }



        $limit = "  WHERE RowNum > ".$_REQUEST['start']." and RowNum <= ".$_REQUEST['length'];
        $order = " ORDER BY NamaPegawai ASC ";


        $query=$this->db->query($sql.$limit.$search_detail);
        //UNTUK MENCARI JUMLAH DATA KETIKA KONDISI PENCARIAN
        if($search!="")
        {
            $jum=$this->db->query($sql.$limit.$search_detail.$order);
            $output['recordsTotal']=$output['recordsFiltered']=$jum->num_rows();
        }

        //LOOPING DATA
        $nomor_urut=$start+1;
        foreach ($query->result() as $desa)
        {
            $delete = "<a type='button' class='btn btn-primary' id='delete'>DELETE</button>";
            $edit = "<button type='button' class='btn btn-primary'>EDIT</button>";

            $output['data'][]=array($nomor_urut ,$desa->NIP, $desa->NamaPegawai, $desa->NamaDepartemen );
            $nomor_urut++;
        }

        echo json_encode($output);

    }

}

 ?>