mambax7 /
xoops-martin
| @@ 523-535 (lines=13) @@ | ||
| 520 | * @param $hotel_id |
|
| 521 | * @return array |
|
| 522 | */ |
|
| 523 | public function GetRoomListByHotel($hotel_id) |
|
| 524 | { |
|
| 525 | global $xoopsDB; |
|
| 526 | $sql = "SELECT room_id,room_name FROM " . $xoopsDB->prefix("martin_auction"); |
|
| 527 | $sql .= $hotel_id > 0 ? " WHERE hotel_id = " . $hotel_id : " "; |
|
| 528 | $result = $xoopsDB->query($sql); |
|
| 529 | $rows = array(); |
|
| 530 | while ($row = $xoopsDB->fetchArray($result)) { |
|
| 531 | $rows[$row['room_id']] = $row['room_name']; |
|
| 532 | } |
|
| 533 | ||
| 534 | return $rows; |
|
| 535 | } |
|
| 536 | ||
| 537 | /** |
|
| 538 | * @get top aution list |
|
| @@ 501-513 (lines=13) @@ | ||
| 498 | * @param $hotel_id |
|
| 499 | * @return array |
|
| 500 | */ |
|
| 501 | public function GetRoomListByHotel($hotel_id) |
|
| 502 | { |
|
| 503 | global $xoopsDB; |
|
| 504 | $sql = "SELECT room_id,room_name FROM " . $xoopsDB->prefix("martin_room"); |
|
| 505 | $sql .= $hotel_id > 0 ? " WHERE hotel_id = " . $hotel_id : " "; |
|
| 506 | $result = $xoopsDB->query($sql); |
|
| 507 | $rows = array(); |
|
| 508 | while ($row = $xoopsDB->fetchArray($result)) { |
|
| 509 | $rows[$row['room_id']] = $row['room_name']; |
|
| 510 | } |
|
| 511 | ||
| 512 | return $rows; |
|
| 513 | } |
|
| 514 | ||
| 515 | /** |
|
| 516 | * @get top group list |
|
