예제 #1
0
     $dataOrder['listing_mobile'] = $rowEstablishment['mobile'];
     $dataOrder['listing_telephone'] = $rowEstablishment['telephone'];
 }
 $resultReservation = $commonController->getTableData(array('table' => 'reservations', 'where' => array('establishment_id=' . $establishment_id, 'room_id' => $room_id)));
 if (mysql_num_rows($resultReservation) > 0) {
     $rowReservation = mysql_fetch_assoc($resultReservation);
     $reservationData = json_decode($rowReservation['data'], true);
     $dataOrder['check_in_date'] = $reservationData[0]['check_in'];
     $dataOrder['check_out_date'] = $reservationData[0]['check_out'];
 }
 $resultSchedule = $commonController->getTableData(array('table' => 'schedule', 'where' => array('establishment_id=' . $establishment_id, 'room_id' => $room_id)));
 if (mysql_num_rows($resultSchedule) > 0) {
     $rowSchedule = mysql_fetch_assoc($resultSchedule);
     $scheduleData = json_decode($rowSchedule['data'], true);
     $scheduleId = $rowSchedule['id'];
     $dateArray = $commonController->createDateRangeArray($dataOrder['check_in_date'], $dataOrder['check_out_date']);
     $commonKey = array_intersect_key($jsonObj, $dateArray);
     foreach ($commonKey as $key => $value) {
         foreach ($value as $key1 => $value1) {
             if ($key1 === 'available') {
                 $commonKey[$key][$key1] = $value1 - 1;
             }
             if ($key1 === 'price') {
                 $commonKey[$key][$key1] = 0;
             }
             if ($key1 === 'promo') {
                 $commonKey[$key][$key1] = 0;
             }
             if ($key1 === 'status' && $commonKey[$key]['available'] == 0) {
                 $commonKey[$key][$key1] = 'booked';
             }