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