public function ajax()
{
$Logger = new TransLog();
$UserModel = new User();
$Amenities = new Amenities();
$type = Input::get('type');
if ($type) {
switch ($type) {
case 'packages-list':
$pending = DB::table('tbl_packages')->join('tbl_package_group', 'package_id', '=', 'pc_groupid');
$dtResult = GlobalController::setDatatable($pending, array('pc_id', 'package_name', 'pc_price'), 'pc_id');
$aN = array();
$aQ = array();
foreach ($dtResult['objResult'] as $aRow) {
unset($aN);
$aN = array();
foreach (json_decode($aRow->pc_itemid) as $aM) {
$name = $Amenities->getAmenityByOne($aM->id);
array_push($aN, $aM->quantity . " " . $name->am_name);
}
$data = array($aRow->pc_id, $aRow->pc_name, $aN, number_format($aRow->pc_price, 2), '', '<div class="button-container">' . '<button class="btn-blue-admin btn-view-item" data-id="' . $aRow->pc_id . '">View</button>' . ' ' . '<button class="btn-blue-admin btn-edit-item" data-id="' . $aRow->pc_id . '">Update</button>' . '</div>');
$dtResult['aaData'][] = $data;
}
unset($dtResult['objResult']);
echo json_encode($dtResult);
break;
case 'viewPackage':
$id = Input::get('id');
$aM = DB::table('tbl_packages')->join('tbl_package_group', 'package_id', '=', 'pc_groupid')->where('pc_id', $id)->first();
$a = array();
foreach (json_decode($aM->pc_itemid) as $aMm) {
$name = $Amenities->getAmenityByOne($aMm->id);
$data = array('am_id' => $aMm->id, 'name' => $name->am_name, 'quantity' => $aMm->quantity);
array_push($a, $data);
}
$data = array('pc_id' => $id, 'package_id' => $aM->package_id, 'package_name' => $aM->pc_name, 'package_type' => $aM->package_name, 'amenities' => $a, 'numpax' => $aM->pc_num_pax, 'quantity' => $aM->pc_quantity_perday, 'total_amount' => number_format($aM->pc_price, 2));
return Response::json($data);
break;
// case 'checkQuantity': {
// $id = Input::get('id');
// $quantity = Input::get('field');
// $result = "";
// $aM = $Amenities->getAmenityByOne($id);
// if($quantity > $aM->am_quantity){
// $result = 'Not enough stock.';
// }
// return Response::json( array('result' => $result ));
// break;
// }
}
}
}
public function ajax()
{
/**@$Logger This for instantiate of new translog.*/
/**@$SOP This for instantiate of new sophisticated.*/
/**@$USER This for instantiate of new user.*/
/**@$type This for input type.*/
$Logger = new TransLog();
$UserModel = new User();
$type = Input::get('type');
if ($type) {
switch ($type) {
case 'users-list':
$pending = $UserModel->getAllUsers();
$dtResult = GlobalController::setDatatable($pending, array('id', 'user_fname', 'user_lname', 'user_email', 'user_username', 'user_status', 'user_type'), 'id');
foreach ($dtResult['objResult'] as $aRow) {
try {
$usertype = $UserModel->getUserType($aRow->id);
$pro = $usertype->user_type;
} catch (Exception $ex) {
$pro = 0;
}
switch ($pro) {
case 1:
$pro = 'Admin';
break;
case 2:
$pro = 'Default';
break;
}
$data = array($aRow->id, $aRow->user_fname, $aRow->user_lname, $aRow->user_email, $aRow->user_username, $aRow->user_status ? "Active" : "Inactive", $pro, 'Action');
$dtResult['aaData'][] = $data;
}
unset($dtResult['objResult']);
echo json_encode($dtResult);
break;
}
}
}
public function _initialize()
{
parent::_initialize();
$this->model = M('Spec');
}
public function __construct()
{
parent::__construct();
}
public function _initialize()
{
parent::_initialize();
}
public function ajax()
{
$Logger = new TransLog();
$UserModel = new User();
$Amenities = new Amenities();
$Orders = new Orders();
$type = Input::get('type');
if ($type) {
switch ($type) {
case 'cancelReservation':
$id = Input::get('id');
$updateArr = array('status' => 0);
$whereArr = array('id' => $id);
$data = $this->GlobalModel->updateModel('tbl_reservation', $whereArr, $updateArr);
$updateArr = array('order_status' => 0);
$whereArr = array('order_id' => $id);
$data = $this->GlobalModel->updateModel('tbl_orders', $whereArr, $updateArr);
break;
case 'order-list':
$pending = DB::table('tbl_reservation')->join('tbl_orders', 'tbl_orders.order_id', '=', 'tbl_reservation.order_id')->join('tbl_orders_room', 'tbl_orders_room.or_orderid', '=', 'tbl_orders.order_id');
$dtResult = GlobalController::setDatatable($pending, array('id', 'pack_name', 'number_of_person', 'date_time_from', 'date_time_to', 'order_datecreated', 'order_status'), 'id');
foreach ($dtResult['objResult'] as $aRow) {
switch ($aRow->status) {
case 0:
$status = '<button class="colorBtn2 styleBtn">Cancelled</button>';
$status .= '<button class="colorBtn8 styleBtn viewMe" data-id="' . $aRow->id . '" >View</button>';
break;
case 1:
$status = 'In Progress';
$status .= '<button class="colorBtn2 styleBtn" data-id="' . $aRow->id . '" id="cancelOrder">Cancel</button>';
$status .= '<button class="colorBtn8 styleBtn viewMe" data-id="' . $aRow->id . '" >View</button>';
break;
case 2:
$status = '<button class="colorBtn2 styleBtn">Pending</button>';
$status .= '<button class="colorBtn2 styleBtn" data-id="' . $aRow->id . '" id="cancelOrder">Cancel</button>';
$status .= '<button class="colorBtn8 styleBtn viewMe" data-id="' . $aRow->id . '" >View</button>';
break;
case 3:
$status = '<button class="colorBtn4 styleBtn">Completed</button>';
$status .= '<button class="colorBtn8 styleBtn viewMe" data-id="' . $aRow->id . '" >View</button>';
break;
case 4:
$status = '<button class="colorBtn4 styleBtn">Done</button>';
break;
default:
$status = '';
}
$data = array($aRow->id, $aRow->pack_name, $aRow->number_of_person, '₱' . number_format($aRow->total_amount, 2), $this->GlobalModel->convertDate($aRow->date_time_from) . " - " . $this->GlobalModel->convertDate($aRow->date_time_to), $this->GlobalModel->convertDate($aRow->order_datecreated), $status);
$dtResult['aaData'][] = $data;
}
unset($dtResult['objResult']);
echo json_encode($dtResult);
break;
case 'viewReservation':
$id = Input::get('id');
$getReserve = DB::table('tbl_reservation')->join('tbl_orders', 'tbl_orders.order_id', '=', 'tbl_reservation.order_id')->where('id', $id)->first();
foreach (json_decode($getReserve->pc_itemid) as $aMm) {
$name = $Amenities->getAmenityByOne($aMm->id);
$data = array('am_id' => $aMm->id, 'name' => $name->am_name, 'quantity' => $aMm->quantity);
array_push($a, $name->am_name);
}
return Response::json(array('reserveId' => $getReserve->id, 'dateTo' => $getReserve->date_time_to, 'dateFrom' => $getReserve->date_time_from, 'amt' => $getReserve->total_amount));
break;
}
}
}
public function ajax()
{
$Logger = new TransLog();
$UserModel = new User();
$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 'deleteImage':
if (Input::has('id')) {
$id = Input::get('id');
$whereVal = array('image_id' => $id);
$this->GlobalModel->deleteModel('tbl_images', $whereVal);
$this->TransLog->transLogger('Amenity Module', 'Deleted Image', $id);
}
break;
case 'validateItemName':
$whereVal = array('am_name' => Input::get('item_name'));
$itemName = $this->GlobalModel->getModelRowCountByWhereClause('tbl_amenities', $whereVal);
$data = 0;
if ($itemName > 0) {
$data = 1;
}
return Response::json(array('result' => $data));
break;
}
}
}
public function ajax()
{
$Logger = new TransLog();
$UserModel = new User();
$type = Input::get('type');
if ($type) {
switch ($type) {
/** AMENITY TYPE */
case 'amenitytype-list':
$pending = DB::table('tbl_amenities_group');
$dtResult = GlobalController::setDatatable($pending, array('ag_id', 'ag_groupname'), 'ag_id');
foreach ($dtResult['objResult'] as $aRow) {
$data = array($aRow->ag_id, $aRow->ag_groupname, '', '<div class="button-container">' . '<button class="btn-blue-admin btn-edit-item" data-name="' . $aRow->ag_groupname . '" data-id="' . $aRow->ag_id . '">Update</button>' . '</div>');
$dtResult['aaData'][] = $data;
}
unset($dtResult['objResult']);
echo json_encode($dtResult);
break;
case 'addAmenityType':
if (Input::has('name')) {
$insertVal = array('ag_groupname' => Input::get('name'));
$this->GlobalModel->insertModel('tbl_amenities_group', $insertVal);
$this->TransLog->transLogger('Amenity Module', 'Added Amenity Type', DB::getPdo()->lastInsertId());
}
break;
case 'updateAmenityType':
if (Input::has('name')) {
$updateVal = array('ag_groupname' => Input::get('name'));
$whereVal = array('ag_id' => Input::get('id'));
$this->GlobalModel->updateModel('tbl_amenities_group', $whereVal, $updateVal);
$this->TransLog->transLogger('Amenity Module', 'Updated Amenity Type', Input::get('id'));
}
break;
case 'validateTypeName':
$whereVal = array('ag_groupname' => Input::get('item_name'));
$itemName = $this->GlobalModel->getModelRowCountByWhereClause('tbl_amenities_group', $whereVal);
$data = 0;
if ($itemName > 0) {
$data = 1;
}
return Response::json(array('result' => $data));
break;
/** END OF AMENITY TYPE */
/** PACKAGE TYPE */
/** END OF AMENITY TYPE */
/** PACKAGE TYPE */
case 'packagetype-list':
$pending = DB::table('tbl_package_group');
$dtResult = GlobalController::setDatatable($pending, array('package_id', 'package_groupname'), 'package_id');
foreach ($dtResult['objResult'] as $aRow) {
$data = array($aRow->package_id, $aRow->package_name, '', '<div class="button-container">' . '<button class="btn-blue-admin btn-edit-item" data-name="' . $aRow->package_name . '" data-id="' . $aRow->package_id . '">Update</button>' . '</div>');
$dtResult['aaData'][] = $data;
}
unset($dtResult['objResult']);
echo json_encode($dtResult);
break;
case 'reportList':
$reportTable = DB::table('tbl_reservation')->where('batch_id', null)->where('status', 3);
$dtResult = GlobalController::setDatatable($reportTable, array('id', 'full_name', 'date_time_from', 'date_time_to', 'total_amount'), 'id');
foreach ($dtResult['objResult'] as $aRow) {
$data = array("<input type='checkbox' name='reportId' id='reportId' value='{$aRow->id}' checked style='visibility: hidden'>", $aRow->id, $aRow->full_name, $aRow->date_time_from, $aRow->date_time_to, "<span>PHP {$aRow->total_amount}</span>");
$dtResult['aaData'][] = $data;
}
unset($dtResult['objResult']);
echo json_encode($dtResult);
break;
case 'addPackageType':
if (Input::has('name')) {
$insertVal = array('package_name' => Input::get('name'));
$this->GlobalModel->insertModel('tbl_package_group', $insertVal);
$this->TransLog->transLogger('Maintenance Module', 'Added Package Type', DB::getPdo()->lastInsertId());
}
break;
case 'updatePackageType':
if (Input::has('name')) {
$updateVal = array('package_name' => Input::get('name'));
$whereVal = array('package_id' => Input::get('id'));
$this->GlobalModel->updateModel('tbl_package_group', $whereVal, $updateVal);
$this->TransLog->transLogger('Maintenance Module', 'Updated Package Type', Input::get('id'));
}
break;
case 'validatePackageTypeName':
$whereVal = array('package_name' => Input::get('item_name'));
$itemName = $this->GlobalModel->getModelRowCountByWhereClause('tbl_package_group', $whereVal);
$data = 0;
if ($itemName > 0) {
$data = 1;
}
return Response::json(array('result' => $data));
break;
}
}
}
public function ajax()
{
$Logger = new TransLog();
$UserModel = new User();
$Amenities = new Amenities();
$Orders = new Orders();
$type = Input::get('type');
if ($type) {
switch ($type) {
case 'packages-list':
$pending = DB::table('tbl_packages')->join('tbl_package_group', 'package_id', '=', 'pc_groupid');
$dtResult = GlobalController::setDatatable($pending, array('pc_id', 'package_name', 'pc_price'), 'pc_id');
$aN = array();
$aQ = array();
foreach ($dtResult['objResult'] as $aRow) {
unset($aN);
$aN = array();
foreach (json_decode($aRow->pc_itemid) as $aM) {
$name = $Amenities->getAmenityByOne($aM->id);
array_push($aN, $aM->quantity . " " . $name->am_name);
}
$data = array($aRow->pc_id, $aRow->pc_name, $aN, number_format($aRow->pc_price, 2), '', '<div class="button-container">' . '<button class="btn-blue-admin btn-view-item" data-id="' . $aRow->pc_id . '">View</button>' . ' ' . '<button class="btn-blue-admin btn-edit-item" data-id="' . $aRow->pc_id . '">Update</button>' . '</div>');
$dtResult['aaData'][] = $data;
}
unset($dtResult['objResult']);
echo json_encode($dtResult);
break;
case 'viewPackage':
$id = Input::get('id');
$aM = DB::table('tbl_packages')->join('tbl_package_group', 'package_id', '=', 'pc_groupid')->where('pc_id', $id)->first();
$a = array();
foreach (json_decode($aM->pc_itemid) as $aMm) {
$name = $Amenities->getAmenityByOne($aMm->id);
$data = array('am_id' => $aMm->id, 'name' => $name->am_name, 'quantity' => $aMm->quantity);
array_push($a, $data);
}
$data = array('pc_id' => $id, 'package_id' => $aM->package_id, 'package_name' => $aM->pc_name, 'amenities' => $a, 'numpax' => $aM->pc_num_pax, 'total_amount' => number_format($aM->pc_price, 2));
return Response::json($data);
break;
case 'accommodation-table':
if (Input::get('id') > 0) {
$Packages = DB::table('tbl_packages')->join('tbl_package_group', 'package_id', '=', 'pc_groupid')->where('pc_id', Input::get('id'))->get();
} else {
$Packages = DB::table('tbl_packages')->join('tbl_package_group', 'package_id', '=', 'pc_groupid')->get();
}
$a = array();
$b = array();
$c = array();
$tbody = '';
foreach ($Packages as $pk) {
unset($a);
$a = array();
// $Orders = new Orders();
// $date = Input::get('date') ? Input::get('date') : date('Y-m-d') ;
// $date2 = Input::get('date_to') ? Input::get('date_to') : date('Y-m-d') ;
// $rooms = $Orders->getRoomOrder($date, $date2);
// $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);
// }
$tbody .= '<tr>';
foreach (json_decode($pk->pc_itemid) as $aMm) {
$name = $Amenities->getAmenityByOne($aMm->id);
$room = null;
if ($name->am_group == 4) {
$room = '<br/>(' . $name->am_quantity . ' Left)';
}
array_push($a, $aMm->quantity . ' ' . $name->am_name . $room);
}
$tbody .= '
<td class="lhs">
<a href="#" class="tooltip-ors" style="cursor: pointer;">
<b>' . $pk->pc_name . '</b>
<span>
<img class="callout" src="../img/callout.gif">
<strong>Inclusions</strong><br />
' . implode("<br/>", $a) . '
</span>
</a>
</td><td></td>
<td style="text-align: center;">' . $pk->pc_num_pax . '</td>
';
if (Input::has('date')) {
$d = Input::get('date');
$day = substr($d, -2);
} else {
$d = date('Y-m-d');
$day = date('d');
}
$date_today = date('Y-m-d');
$datediff = strtotime(Input::get('date_to')) - strtotime($d);
$final_date = floor($datediff / (60 * 60 * 24));
if ($final_date > 12) {
$x = $final_date;
} else {
$x = 12;
}
$bookable = 0;
unset($b);
$b = array();
$check = $Orders->getOrderByID($pk->pc_id);
$m = 0;
if ($x > 18) {
$tbody .= '<td></td>';
for ($i = 0; $i <= $x; $i++) {
$date = date('Y-m-d', strtotime($d . ' +' . $i . ' day'));
$availability = "";
if (Input::get('pax') > $pk->pc_num_pax) {
$availability = '<td class="max-pax">Max ' . $pk->pc_num_pax . '</td>';
$bookable = 1;
} else {
if ($check->count()) {
foreach ($check->get() as $chk) {
if (strtotime($date) >= strtotime(Input::get('date')) && strtotime($date) <= strtotime(Input::get('date_to')) && strtotime(Input::get('date')) <= strtotime(Input::get('date_to')) && strtotime($date) >= strtotime($chk->order_datefrom) && strtotime($date) <= strtotime($chk->order_dateto) && strtotime($chk->order_datefrom) <= strtotime($chk->order_dateto)) {
array_push($b, 1);
}
}
}
}
if ($m == 0) {
$tbody .= $availability;
$m = 1;
}
}
if (implode(",", $b) > 0) {
$tbody .= '<td class="unavailable"">✗</td>';
array_push($b, 1);
} else {
if ($bookable != 1) {
$tbody .= '<td class="available">✓</td>';
}
}
$tbody .= '<td></td>';
} else {
for ($i = 0; $i <= $x; $i++) {
$date = date('Y-m-d', strtotime($d . ' +' . $i . ' day'));
$availability = '<td class="available">✓</td>';
if ($date_today > Input::get('date')) {
$availability = '<td class="unavailable"">✗</td>';
array_push($b, 1);
$bookable = 1;
} else {
if (Input::get('pax') > $pk->pc_num_pax) {
$availability = '<td class="max-pax">Max ' . $pk->pc_num_pax . '</td>';
$bookable = 1;
} else {
if ($check->count() > 0) {
foreach ($check->get() as $chk) {
if (Input::has('date') && Input::has('date_to')) {
$order_count = $Orders->getSumAllOrders($pk->pc_id, Input::get('date'), Input::get('date_to'));
if ($pk->pc_quantity_perday <= $order_count) {
$availability = '<td class="unavailable"">✗</td>';
array_push($b, 1);
}
}
if (strtotime($date) >= strtotime($chk->order_datefrom) && strtotime($date) <= strtotime($chk->order_dateto) && strtotime($chk->order_datefrom) <= strtotime($chk->order_dateto)) {
$availability = '<td class="unavailable"">✗</td>';
array_push($b, 1);
}
if (strtotime($date) >= strtotime(Input::get('date')) && strtotime($date) <= strtotime(Input::get('date_to')) && strtotime(Input::get('date')) <= strtotime(Input::get('date_to')) && strtotime($date) >= strtotime($chk->order_datefrom) && strtotime($date) <= strtotime($chk->order_dateto) && strtotime($chk->order_datefrom) <= strtotime($chk->order_dateto)) {
array_push($b, 1);
}
}
} else {
if ($Orders->checkDateAvailability($date, $pk->pc_id) == 1) {
$availability = '<td class="available">✓</td>';
} else {
$availability = '<td class="available">✓</td>';
}
}
}
}
$tbody .= $availability;
$day++;
}
}
$price = number_format($pk->pc_price * ($final_date + 1), 2) < 0 ? $pk->pc_price : number_format($pk->pc_price * ($final_date + 1), 2);
if (implode(",", $b) > 0 || Input::has('date_to') && $final_date < 0) {
$tB = '<td class="maxGuests button"><a class="bookable notavailable notavailable-bg" title="Not Available"><b class="text notavailable">Date not</b><b class="price notavailable">available</b></a></td>';
} else {
if (Input::has('id')) {
$tB = '<td class="maxGuests button booknow-btn"><a class="bookable booknow bookable-cl" title="Book Now" data-id="' . $pk->pc_id . '"><b class="text">Rebook</b><b class="price">₱' . $price . '</b></a></td>
<td class="maxGuests button booknow-btn proceed proceed-' . $pk->pc_id . '"><a class="proceed-payment bookable disabled-payment" title="Proceed" data-id="' . $pk->pc_id . '"><b class="text">Proceed</b><b class="price">payment</b></td>
';
} else {
$tB = '<td class="maxGuests button booknow-btn"><a class="bookable booknow bookable-cl" title="Book Now" data-id="' . $pk->pc_id . '"><b class="text">Book now</b><b class="price">₱' . $price . '</b></a></td>
<td class="maxGuests button booknow-btn proceed proceed-' . $pk->pc_id . '"><a class="proceed-payment bookable" title="Proceed" data-id="' . $pk->pc_id . '"><b class="text">Proceed</b><b class="price">payment</b></td>
';
}
}
$tbody .= $bookable == 1 ? '<td class="maxGuests button"><a class="bookable notavailable notavailable-bg" title="Not Available" ><b class="text notavailable">Not</b><b class="price notavailable">Available</b></a></td>' : $tB;
$data = array('am_name' => implode(", ", $a), 'package_id' => $pk->package_id, 'package_name' => $pk->pc_name, 'numpax' => $pk->pc_num_pax, 'total_amount' => number_format($pk->pc_price, 2));
$tbody .= '</tr>';
}
$thead = '
<th class="tblHeaderGlobal lhs">Package</th>
<th class="tblHeaderGlobal"></th>
<th class="tblHeaderGlobal maxGuests">MAX GUESTS</th>
';
if (Input::has('date')) {
$d = Input::get('date');
$day = substr($d, -2);
} else {
$d = date('Y-m-d');
$day = date('d');
}
$datediff = strtotime(Input::get('date_to')) - strtotime($d);
$final_date = floor($datediff / (60 * 60 * 24));
if ($final_date > 12) {
$x = $final_date;
} else {
$x = 12;
}
if ($x > 18) {
$thead .= '<th class="tblHeaderGlobal selected">
<b class="day">' . strtoupper(substr(date('l', strtotime($d)), 0, 3)) . '</b>
<b class="date">' . date('d', strtotime($d)) . '</b>
<b class="month">' . strtoupper(date('M', strtotime($d))) . '</b>
</th>
<th class="tblHeaderGlobal selected"> <b class="date"> >> </b> </th>
<th class="tblHeaderGlobal selected">
<b class="day">' . strtoupper(substr(date('l', strtotime(Input::get('date_to'))), 0, 3)) . '</b>
<b class="date">' . date('d', strtotime(Input::get('date_to'))) . '</b>
<b class="month">' . strtoupper(date('M', strtotime(Input::get('date_to')))) . '</b>
</th>
';
} else {
for ($i = 0; $i <= $x; $i++) {
$date = date('Y-m-d', strtotime($d . ' +' . $i . ' day'));
$day_ = strtoupper(date('d', strtotime($date)));
if (Input::has('date_to') && strtotime($date) <= strtotime(Input::get('date_to'))) {
$class = 'selected_day';
} else {
if (date('N', strtotime($date)) >= 6) {
$class = 'data weekend';
} else {
$class = 'selected';
}
}
$thead .= '<th class="tblHeaderGlobal ' . $class . '">
<b class="day">' . strtoupper(substr(date('l', strtotime($date)), 0, 3)) . '</b>
<b class="date">' . $day_ . '</b>
<b class="month">' . strtoupper(date('M', strtotime($date))) . '</b>
</th>';
$day++;
}
}
$thead .= '<th class="tblHeaderGlobal"></th>';
$data = array('date' => $thead, 'packages' => $tbody);
return Response::json($data);
break;
case 'accommodation-pertable':
$Packages = DB::table('tbl_packages')->join('tbl_package_group', 'package_id', '=', 'pc_groupid')->where('pc_id', Input::get('id'))->get();
$a = array();
$b = array();
$c = array();
$tbody = '';
foreach ($Packages as $pk) {
unset($a);
$a = array();
$tbody .= '<tr>';
foreach (json_decode($pk->pc_itemid) as $aMm) {
$name = $Amenities->getAmenityByOne($aMm->id);
$data = array('am_id' => $aMm->id, 'name' => $name->am_name, 'quantity' => $aMm->quantity);
array_push($a, $name->am_name);
}
$tbody .= '
<td class="lhs">
<a href="#" class="tooltip-ors" style="cursor: pointer;">
<b>' . $pk->pc_name . '</b>
<span>
<img class="callout" src="../img/callout.gif">
<strong>Inclusions</strong><br />
' . implode(", ", $a) . '
</span>
</a>
</td><td></td>
<td style="text-align: center;">' . $pk->pc_num_pax . '</td>
';
if (Input::has('date')) {
$d = Input::get('date');
$day = substr($d, -2);
} else {
$d = date('Y-m-d');
$day = date('d');
}
$datediff = strtotime(Input::get('date_to')) - strtotime($d);
$final_date = floor($datediff / (60 * 60 * 24));
if ($final_date > 12) {
$x = $final_date;
} else {
$x = 12;
}
$bookable = 0;
unset($b);
$b = array();
$check = $Orders->getOrderByID($pk->pc_id);
$m = 0;
if ($x > 18) {
$tbody .= '<td></td>';
for ($i = 0; $i <= $x; $i++) {
$date = date('Y-m-d', strtotime($d . ' +' . $i . ' day'));
$availability = "";
if (Input::get('pax') > $pk->pc_num_pax) {
$availability = '<td class="max-pax">Max ' . $pk->pc_num_pax . '</td>';
$bookable = 1;
} else {
if ($check) {
if (strtotime($date) >= strtotime(Input::get('date')) && strtotime($date) <= strtotime(Input::get('date_to')) && strtotime(Input::get('date')) <= strtotime(Input::get('date_to')) && strtotime($date) >= strtotime($check->order_datefrom) && strtotime($date) <= strtotime($check->order_dateto) && strtotime($check->order_datefrom) <= strtotime($check->order_dateto)) {
array_push($b, 1);
}
}
}
if ($m == 0) {
$tbody .= $availability;
$m = 1;
}
}
if (implode(",", $b) > 0) {
$tbody .= '<td class="unavailable"">✗</td>';
array_push($b, 1);
} else {
if ($bookable != 1) {
$tbody .= '<td class="available">✓</td>';
}
}
$tbody .= '<td></td>';
} else {
for ($i = 0; $i <= $x; $i++) {
$date = date('Y-m-d', strtotime($d . ' +' . $i . ' day'));
$availability = '<td class="available">✓</td>';
if (Input::get('pax') > $pk->pc_num_pax) {
$availability = '<td class="max-pax">Max ' . $pk->pc_num_pax . '</td>';
$bookable = 1;
} else {
if ($check) {
if (strtotime($date) >= strtotime($check->order_datefrom) && strtotime($date) <= strtotime($check->order_dateto) && strtotime($check->order_datefrom) <= strtotime($check->order_dateto)) {
$availability = '<td class="unavailable"">✗</td>';
array_push($b, 1);
}
if (strtotime($date) >= strtotime(Input::get('date')) && strtotime($date) <= strtotime(Input::get('date_to')) && strtotime(Input::get('date')) <= strtotime(Input::get('date_to')) && strtotime($date) >= strtotime($check->order_datefrom) && strtotime($date) <= strtotime($check->order_dateto) && strtotime($check->order_datefrom) <= strtotime($check->order_dateto)) {
array_push($b, 1);
}
} else {
if ($Orders->checkDateAvailability($date, $pk->pc_id) == 1) {
$availability = '<td class="available">✓</td>';
} else {
$availability = '<td class="available">✓</td>';
}
}
}
$tbody .= $availability;
$day++;
}
}
$price = number_format($pk->pc_price * ($final_date + 1), 2) < 0 ? $pk->pc_price : number_format($pk->pc_price * ($final_date + 1), 2);
if (implode(",", $b) > 0 || Input::has('date_to') && $final_date < 0) {
$tB = '<td class="maxGuests button"><a class="bookable notavailable notavailable-bg" title="Not Available"><b class="text notavailable">Date not</b><b class="price notavailable">available</b></a></td>';
} else {
$tB = '<td class="maxGuests button booknow-btn"><a class="bookable" title="Book Now" data-id="' . $pk->pc_id . '"><b class="text">Book now</b><b class="price">₱' . $price . '</b></td>';
}
$tbody .= $bookable == 1 ? '<td class="maxGuests button"><a class="bookable notavailable notavailable-bg" title="Not Available" ><b class="text notavailable">Not</b><b class="price notavailable">Available</b></a></td>' : $tB;
$data = array('am_name' => implode(", ", $a), 'package_id' => $pk->package_id, 'package_name' => $pk->pc_name, 'numpax' => $pk->pc_num_pax, 'total_amount' => number_format($pk->pc_price, 2));
$tbody .= '</tr>';
}
$thead = '
<th class="tblHeaderGlobal lhs">Package</th>
<th class="tblHeaderGlobal"></th>
<th class="tblHeaderGlobal maxGuests">MAX GUESTS</th>
';
if (Input::has('date')) {
$d = Input::get('date');
$day = substr($d, -2);
} else {
$d = date('Y-m-d');
$day = date('d');
}
$datediff = strtotime(Input::get('date_to')) - strtotime($d);
$final_date = floor($datediff / (60 * 60 * 24));
if ($final_date > 12) {
$x = $final_date;
} else {
$x = 12;
}
if ($x > 18) {
$thead .= '<th class="tblHeaderGlobal selected">
<b class="day">' . strtoupper(substr(date('l', strtotime($d)), 0, 3)) . '</b>
<b class="date">' . date('d', strtotime($d)) . '</b>
<b class="month">' . strtoupper(date('M', strtotime($d))) . '</b>
</th>
<th class="tblHeaderGlobal selected"> <b class="date"> >> </b> </th>
<th class="tblHeaderGlobal selected">
<b class="day">' . strtoupper(substr(date('l', strtotime(Input::get('date_to'))), 0, 3)) . '</b>
<b class="date">' . date('d', strtotime(Input::get('date_to'))) . '</b>
<b class="month">' . strtoupper(date('M', strtotime(Input::get('date_to')))) . '</b>
</th>
';
} else {
for ($i = 0; $i <= $x; $i++) {
$date = date('Y-m-d', strtotime($d . ' +' . $i . ' day'));
$day_ = strtoupper(date('d', strtotime($date)));
if (Input::has('date_to') && strtotime($date) <= strtotime(Input::get('date_to'))) {
$class = 'selected_day';
} else {
if (date('N', strtotime($date)) >= 6) {
$class = 'data weekend';
} else {
$class = 'selected';
}
}
$thead .= '<th class="tblHeaderGlobal ' . $class . '">
<b class="day">' . strtoupper(substr(date('l', strtotime($date)), 0, 3)) . '</b>
<b class="date">' . $day_ . '</b>
<b class="month">' . strtoupper(date('M', strtotime($date))) . '</b>
</th>';
$day++;
}
}
$thead .= '<th class="tblHeaderGlobal"></th>';
$data = array('date' => $thead, 'packages' => $tbody);
return Response::json($data);
break;
// case 'checkQuantity': {
// $id = Input::get('id');
// $quantity = Input::get('field');
// $result = "";
// $aM = $Amenities->getAmenityByOne($id);
// if($quantity > $aM->am_quantity){
// $result = 'Not enough stock.';
// }
// return Response::json( array('result' => $result ));
// break;
// }
}
}
}
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;
}
}
}
public function ajax()
{
/**@$Logger This for instantiate of new translog.*/
/**@$USER This for instantiate of new user.*/
/**@$type This for input type.*/
$Logger = new TransLog();
$UserModel = new User();
$type = Input::get('type');
if ($type) {
switch ($type) {
case 'users-list':
$pending = DB::table('tbl_users');
$dtResult = GlobalController::setDatatable($pending, array('id', 'user_fname', 'user_lname', 'user_email', 'user_username', 'user_status', 'user_type'), 'id');
foreach ($dtResult['objResult'] as $aRow) {
try {
$pro = $aRow->user_type;
} catch (Exception $ex) {
$pro = 0;
}
switch ($pro) {
case 1:
$pro = 'Admin';
break;
case 0:
case 2:
$pro = 'Default';
break;
}
$data = array($aRow->id, $aRow->user_fname, $aRow->user_lname, $aRow->user_email, $aRow->user_username, $aRow->user_status ? "Active" : "Inactive", $pro, '', '<div class="button-container">' . '<button class="btn-blue-admin btn-view-item" data-id="' . $aRow->id . '">View</button>' . '</div>');
$dtResult['aaData'][] = $data;
}
unset($dtResult['objResult']);
echo json_encode($dtResult);
break;
case 'validateusername':
$input = Input::all();
$rules = array('user_username' => 'required|between:6,20|unique:tbl_users');
$validator = Validator::make($input, $rules);
if ($validator->fails()) {
$result = "Not unique";
} else {
$result = "unique";
}
return Response::json(array('result' => $result));
break;
case 'validateuseremail':
$input = Input::all();
$rules = array('user_email' => 'Required|unique:tbl_users|email');
$validator = Validator::make($input, $rules);
if ($validator->fails()) {
$result = "Not unique";
} else {
$email = Input::get('user_email');
$explode = explode('.', $email);
if (strlen($explode[1]) < 2) {
$result = "Not unique";
} else {
$result = "unique";
}
}
return Response::json(array('result' => $result));
break;
case 'addnewmember':
$rules = array('salutation' => 'required|not_in:default', 'user_username' => 'Required|unique:tbl_users', 'fname' => 'required', 'mname' => 'alpha_spaces', 'lname' => 'required', 'user_email' => 'required|email|unique:tbl_users');
Validator::extend('alpha_spaces', function ($attribute, $value) {
return preg_match('/^[\\pL\\s]+$/u', $value);
});
$messages = array("alpha_spaces" => "The :attribute may only contain letters and spaces.");
$validator = Validator::make(Input::all(), $rules, $messages);
if ($validator->fails()) {
return Response::json(array('result' => $validator->messages()));
} else {
$checkEmailNotif = "Registration Complete. Please check your email for confirmation. Thank you!";
$temp_id = "";
$input_email = Input::get('user_email');
$input_username = Input::get('user_username');
$input_fname = Input::get('fname');
$input_lname = Input::get('lname');
$input_mname = Input::get('mname');
$user_countryId = Input::get('user_countryId');
$input_userrole = Input::get('user_role');
$input_salutation = Input::get('salutation');
$confirmation_code = str_random(25);
$password = Input::get('password_confirmation');
//insert data
$arrayInsert = array('user_email' => "{$input_email}", 'user_username' => "{$input_username}", 'user_fname' => "{$input_fname}", 'user_lname' => "{$input_lname}", 'user_mname' => "{$input_mname}", 'user_type' => "{$input_userrole}", 'user_salutation' => "{$input_salutation}", 'user_emailverification' => "{$confirmation_code}", 'user_isFirstLogin' => 0, 'user_status' => 1, 'user_isNew' => 0, 'user_password' => $password);
$insertRegistration = $this->GlobalModel->insertModel('tbl_users', $arrayInsert);
$this->TransLog->transLogger('User Module', 'Added New User', DB::getPdo()->lastInsertId());
}
}
}
}