M_Tiket.php

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class M_Tiket_dipesan extends CI_Model {

	//public $table='train_record';
    var $table = 'train_record'; //nama tabel dari database
    //var $column_order = array(null, 'user_nama','user_email','user_alamat'); //field yang ada di table user
    //var $column_search = array('user_nama','user_email','user_alamat'); //field yang diizin untuk pencarian
    var $order = array('record_code' => 'asc'); // default order


	public function __construct()
	{
		parent::__construct();
        $this->load->database();

	}


	private function _get_datatables_query()
    {

        $hasil=$this->db->query("SELECT
            MAX(record_trans_datetime) AS record_trans_datetime,
            client_name,
            record_train_name,
            record_code,
            record_depart_code,
            record_depart_datetime,
            record_arrive_code,
            record_arrive_datetime,
            record_trans_fare,
            record_trans_nta,
            record_trans_fee_client,
            record_trans_fee_margin,
            record_timelimit,
            GROUP_CONCAT(record_trans_type) AS group_type
        FROM
            train_record
            JOIN train_record_trans
                ON record_trans_record_code = record_code
            JOIN okesys_client
                ON client_id = record_client_id");

        $i = 0;
        return $hasil->result();

    }

    function get_datatables()
    {
        $this->_get_datatables_query();
        if($_POST['length'] != -1)
        $this->db->limit($_POST['length'], $_POST['start']);
        $query = $this->db->get();
        return $query->result();
    }

    function count_filtered()
    {
        $this->_get_datatables_query();
        $query = $this->db->get();
        return $query->num_rows();
    }

    public function count_all()
    {
        $this->db->from($this->table);
        return $this->db->count_all_results();
    }




}

/* End of file M_Tiket_dipesan.php */
/* Location: ./application/models/M_Tiket_dipesan.php */