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;
}
}
}
