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"); //} }