ApiTrnsksi.php

<?php

defined('BASEPATH') OR exit('No direct script access allowed');

require APPPATH . '/libraries/REST_Controller.php';
use Restserver\Libraries\REST_Controller;

class ApiTransaksi extends REST_Controller {

    function __construct($config = 'rest') {
        parent::__construct($config);
        $this->load->database();
    }


function index_get() {
  $id = $this->get('id_pemesan');
  $where = '';

  if($id != null){ $where = 'WHERE reservasi.id_pemesan = "'.$id.'" '; }
  $query = $this->db->query('SELECT admin.nama,reservasi.id_pesan,reservasi.status_pesan,reservasi.id_pemesan
  FROM reservasi
  LEFT JOIN admin ON (reservasi.id_admin = admin.id_user)
  LEFT JOIN customer ON (reservasi.id_pemesan = customer.id_cust) '.$where.' ORDER BY reservasi.id_pesan DESC;');
  $output = $query->result_array();
  $this->response(array('data'=>$output));
  /*$query = $this->db->select('*')->from('admin');
      if($id != null){
        $query->where('id_user',$id);
      }
  $output = $query->get()->result_array();

  $data_blog = $this->db->select('*')->from('blog');
  if($id != null){
    $data_blog->where('id_admin',$id);
  }

  $output_blog = $data_blog->get()->result_array();
 $this->response(array('data'=>$output,"blog" => $output_blog));*/


}

}