<?php
defined('BASEPATH') OR exit('No direct script access allowed');
/* ------- DONE --------*/
class Kota extends CI_Controller {

	public function __construct (){
		parent::__construct();
        date_default_timezone_set('Asia/Jakarta');

	}

	public function index (){
        $this->content['messages'] = 'aku sayang kamu selamanya '; // contoh parsing data

        //pemanggilan database
        $kota['table'] = "tb_city"; //nama table dari database
        $kota['type'] = "multiple"; //menampilkan data tunggal atau multiple
        $kota['condition']['type_city'] = 'Kota';
        //$kota['condition']['idcity_city'] = '14';

        //join
        $kota['join']['table'] = "tb_province"; //join table kemana
        $kota['join']['key'] = "idprov_city"; //key dari table A
        $kota['join']['ref'] = "idprov_prov"; //ref dari table B
        //$kota['join']['ketentuan'] = "RIGHT";

        //$kota['condition']['idcity_city >='] = '300';
        //$kota['cuzcondition'] = "iadcity_city >= 300 AND name_prov like '%pa%'";

        //$kota['condition']['idprov_prov'] = '11';

        //menampilkan beberapa column saja
        $kota['column'] = 'idcity_city,CONCAT(name_city," asek") as "kota",name_prov';

        //ordering
        $kota['orderby']['column'] = "kota";
        $kota['orderby']['sort'] = "DESC";

        //$kota['limit'] = 5;
        // $kota['limit']['first'] = 2;
        // $kota['limit']['lim'] = 3;

        $kota['groupby'] = 'name_prov';


        //$kota['like']['name_city'] = 'amb'; //like condition

        $this->content['kotanya'] = $this->crud_model->get_data($kota);

        $this->content['load'] = array('kota/list');//menampilkan view yang mana
        $this->content['data']['title'] = "Master Kota Murni"; // title
        $this->content['data']['subtitle'] = array(array('master'),array('kota')); //subtitle
		$this->load->view('adm',$this->content);

    }



}