public function getPlace(Request $request)
 {
     if ($request->get('id')) {
         return Place::with('kategori')->where('active', 1)->where('id', $request->get('id'))->first();
     } elseif ($request->get('ids')) {
         return Place::with('kategori')->where('active', 1)->whereIn('id', explode('+', $request->get('ids')))->get();
     } else {
         $tgl = $request->get('date') ? $request->get('date') : date('Y-m-d');
         $tgl = $tgl != "" ? $tgl : date('Y-m-d');
         $ready = $request->get('ready') ? $request->get('ready') : 'Ya';
         $places = Place::leftJoin(DB::raw("( SELECT order_places.`place_id`, orders.`id` AS order_id, orders.`state`\n                FROM order_places INNER JOIN orders ON order_places.`order_id` = orders.`id`\n                WHERE SUBSTRING(orders.tanggal, 1, 10) = '" . $tgl . "' AND orders.`state` = 'On Going' )as order_place_temp"), function ($query) {
             $query->on('places.id', '=', 'order_place_temp.place_id');
         });
         if ($ready == 'Ya') {
             $places = $places->whereNull('order_place_temp.order_id');
         } else {
             $places = $places->whereNotNull('order_place_temp.order_id');
         }
         $places = $places->where('nama', 'like', '%' . $request->get('q') . '%')->where('active', 1)->with('kategori')->get();
         return $places;
     }
 }