function addHotelRoomRates($_roomrates)
{
$roomrates = new HotelRoomRates();
$roomrates->setValues($_roomrates);
$localCols = $roomrates->getRateFields('Local');
$foreignCols = $roomrates->getRateFields('Foreign');
//INFO: Assumes that `count($foreignCols)`==`count($localCols)`.
for ($i = 1; $i < count($foreignCols); $i = $i + 2) {
$val_array_foreign[] = ($roomrates->getFieldValue($foreignCols[$i]) - $roomrates->getFieldValue($foreignCols[$i - 1])) / 100;
$val_array_local[] = ($roomrates->getFieldValue($localCols[$i]) - $roomrates->getFieldValue($localCols[$i - 1])) / 100;
}
$max_foreign = max($val_array_foreign);
$max_local = max($val_array_local);
$min_foreign = min($val_array_foreign);
$min_local = min($val_array_local);
$roomrates->setDiscountRatesUpForiegn($max_foreign);
$roomrates->setDiscountRatesUpLocal($max_local);
$roomrates->setHotelPriceMinForiegn($min_foreign);
$roomrates->setHotelPriceMinLocal($min_local);
$roomrates->setModifiedDate(date('Y-m-d'));
return $roomrates->newHotelRoomRate();
//if ($roomrates->newHotelRoomRate()) {
//INFO: Replaced following commented section with above `$foreignCols` thing. As no need to re-load data and do the calculation.
/*// update max and min
$roomrates = new HotelRoomRates();
$roomrates->setRoomRateId(mysql_insert_id());
$query_data = $roomrates->getRateFromId();
$ic = 0;
foreach ($query_data as $x) {
foreach ($x as $key => $val) {
if ($ic > 7 && $ic < 67) {
$ARRAY[$ic] = $val;
}
$ic++;
}
}
for ($x = 67; $x > 7; $x--) {
$y = ($x - 1);
if ($x < 36) {
$val_array_local[] = (($ARRAY[$x] - $ARRAY[$y]) / 100);
} else {
$val_array_foreign[] = (($ARRAY[$x] - $ARRAY[$y]) / 100);
}
}
$max_foreign = max($val_array_foreign);
$max_local = max($val_array_local);
$min_foreign = min($val_array_foreign);
$min_local = min($val_array_local);
$roomrates->setDiscountRatesUpForiegn($max_foreign);
$roomrates->setDiscountRatesUpLocal($max_local);
$roomrates->setHotelPriceMinForiegn($min_foreign);
$roomrates->setHotelPriceMinLocal($min_local);
$roomrates->updateHotelRoomRateMax();*/
//INFO: Log
//$temp_rate = $_REQUEST;
//$temp_rate['discount_rates_up_foriegn']=$max_foreign;
//$temp_rate['discount_rates_up_local']=$max_local;
//$temp_rate['hotel_price_min_foriegn']=$min_foreign;
//$temp_rate['hotel_price_min_local']=$min_local;
//$TransactionLog=new TransactionLog($temp_rate['hotel_id'],Libs::getKey('hotel_sections','Hotel Rates - Add'),'Insert',Sessions::getMemberId(),'room_rates',$temp_rate,'');
//$TransactionLog->log();
//$temp_rate=null;
//INFO: Log//
//max and min
//Common::jsonSuccess("Room Rates Added Successfully!");
//} else {
//Common::jsonError("Error");
//}
}
