public function countAmenitiesGroupByIDandName($id, $groupName) { $allAmenities = Amenities::join('tbl_amenities_group', 'ag_id', '=', 'am_group')->where('am_id', $id)->where('ag_groupname', $groupName)->count(); return $allAmenities; }
public function ajax() { $Logger = new TransLog(); $UserModel = new User(); $Amenities = new Amenities(); $Packages = new Packages(); $type = Input::get('type'); if ($type) { switch ($type) { case 'amenities-list': $pending = DB::table('tbl_amenities')->join('tbl_amenities_group', 'ag_id', '=', 'am_group'); $dtResult = GlobalController::setDatatable($pending, array('am_id', 'am_name', 'am_quantity', 'am_price', 'ag_groupname'), 'am_id'); foreach ($dtResult['objResult'] as $aRow) { $data = array($aRow->am_id, $aRow->am_name, $aRow->am_quantity, $aRow->am_capacity, number_format($aRow->am_price, 2), $aRow->ag_groupname, '', '<div class="button-container">' . '<button class="btn-blue-admin btn-view-item" data-id="' . $aRow->am_id . '">View</button>' . ' ' . '<button class="btn-blue-admin btn-edit-item" data-id="' . $aRow->am_id . '">Update</button>' . '</div>'); $dtResult['aaData'][] = $data; } unset($dtResult['objResult']); echo json_encode($dtResult); break; case 'viewItem': $id = Input::get('id'); $whereVal = array('am_id' => $id); $item = $this->GlobalModel->getModelRowDetailByWhereClause('tbl_amenities', $whereVal, ''); $images = DB::table('tbl_images')->where('image_fieldvalue', $id)->get(); $img = array(); foreach ($images as $im) { $d = array('image_id' => $im->image_id, 'image_name' => $im->image_name); array_push($img, $d); } $data = array('item_name' => $item->am_name, 'item_desc' => $item->am_description, 'item_quantity' => $item->am_quantity, 'item_price' => $item->am_price, 'item_capacity' => $item->am_capacity, 'item_group' => $this->GlobalModel->getGroupName($item->am_group)->ag_groupname, 'group_id' => $this->GlobalModel->getGroupName($item->am_group)->ag_id, 'image' => $img); return Response::json($data); break; case 'getOrderedRooms': if (Input::has('date') && Input::has('date_to')) { $datefrom = Input::get('date'); $dateto = Input::get('date_to'); } else { $datefrom = $dateto = date('Y-m-d'); } $Orders = new Orders(); $rooms = $Orders->getRoomOrderReserve($datefrom, $dateto); $order_room = array(); foreach ($rooms as $room) { $data = array('package_id' => $room->order_packageid, 'or_roomid' => json_decode($room->or_roomid)); array_push($order_room, $data); } // // $rooms = $Packages->getAllPackages(); // foreach($rooms as $room){ // foreach(json_decode($room->pc_itemid) as $pc){ // $data = array( // 'id' => $pc->id, // 'quantity' => $pc->quantity // ); // array_push($rooms_, $data); // } // } $package_rooms = array(); $pcg_id = array(); $rooms_ = array(); if (Input::has('package_id')) { $id = Input::get('package_id'); $rooms = $Packages->getAllPackagesByID($id); foreach ($rooms as $room) { foreach (json_decode($room->pc_itemid) as $pc) { array_push($pcg_id, $pc->id); $data = array('id' => $pc->id, 'quantity' => $pc->quantity); array_push($rooms_, $data); } $allAmenities = Amenities::join('tbl_amenities_group', 'ag_id', '=', 'am_group')->where('ag_groupname', 'Room')->whereNotIn('am_id', $pcg_id)->get(); foreach ($allAmenities as $aM) { $data = array('or_roomid' => $aM->am_id); array_push($package_rooms, array_filter($data)); } } } $data = array('order_rooms' => $order_room, 'package_rooms' => $package_rooms, 'rooms' => $rooms_); return Response::json(array('result' => $data)); break; } } }