Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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));*/
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement