<tr> <td style="padding:5px;" align="left"><?php echo $_L['HTL_street']; ?> <font color="#FF0000">*</font></td> <td align="left"><input type="text" name="street" maxlength=250 value="<?php echo $street; ?> "/></td> <td align="left"><?php echo $_L['HTL_countrycode']; ?> <font color="#FF0000">*</font></td> <td align="left"><select name="countrycode" id="countrycode" > <?php populate_select("countries", "countrycode", "countrycode", $countrycode, ""); ?> </select> </td> </tr> <tr> <td style="padding:5px;" align="left"><?php echo $_L['HTL_city']; ?> <font color="#FF0000">*</font></td> <td align="left"><input type="text" name="city" id="city" maxlength=250 value="<?php echo $city; ?> "/></td> <td align="left"><?php echo $_L['HTL_citycode'];
echo $_L['HTL_postcode']; ?> </td> <td><input type="text" name="postcode" id="postcode" size=10 maxlength=50 value="<?php echo $postcode; ?> "/></td> </tr> <tr> <td><?php echo $_L['HTL_lang']; ?> </td> <td><select name="language" id="language"> <?php populate_select("languages", "lang", "LocalDescription", $language, "active=1"); ?> </select> </td> <td><?php echo $_L['HTL_logo']; ?> </td> <td><input type="text" name="logo" id="logo" value="<?php echo $logo; ?> " maxlength=500 /></td> </tr> <tr> <td><?php echo $_L['HTL_longitude'];
</div> </td> <td> <div id="bendcntFour" style="<?php if ($rooms['bedcount'] && $rooms['bedcount'] == '4') { echo "display:block"; } else { echo "display:none"; } ?> "> <table width="100%"> <tr> <td> <select name="bedtype4"><option value=0> </option><?php populate_select("ota_bedtype", "OTA_Number", "Description", $rooms['bedtype4'], "lang='" . $lang . "'"); ?> </select> </td> </tr> </table> </div> </td></tr></table> </td> </tr> <tr> <td><?php echo $_L['RM_occupancy']; ?> </td> <td><input type="text" name="occupancy" value="<?php
<h2>ROOMS</h2> </td> </tr> <tr> <td valign="top"><table width="100%" border="0" cellpadding="1"> <tr> <td width="26%">Room No. </td> <td width="74%"><input type="text" name="roomno" value="<?php echo trim($rooms->roomno); ?> " /></td> </tr> <tr> <td>Room Type </td> <td><select name="roomtypeid"><?php populate_select("roomtype", "roomtypeid", "roomtype", $rooms->roomtypeid); ?> </select></td> </tr> <tr> <td>Room Name </td> <td><input type="text" name="roomname" value="<?php echo trim($rooms->roomname); ?> " /></td> </tr> <tr> <td>No. of rooms </td> <td><input type="text" name="noofrooms" value="<?php echo trim($rooms->noofrooms); ?>
case "reserved": $sql = "Select guests.guestid,concat_ws(' ',guests.firstname,guests.middlename,guests.lastname) as guest,guests.pp_no,\n\t\tguests.idno,guests.address,guests.town,guests.postal_code,guests.phone,\n\t\tguests.email,guests.mobilephone,countries.country,reservation.reserve_checkindate\n\t\t\tFrom guests\n\t\t\tInner Join countries ON guests.countrycode = countries.countrycode\n\t\t\tInner Join reservation ON guests.guestid = reservation.guestid\n\t\t\tWhere reservation.reserve_checkindate >= current_date()"; //date variable user to select a date for arrivals to do break; case "arrivals": $sql = "Select guests.guestid,concat_ws(' ',guests.firstname,guests.middlename,guests.lastname) as guest,guests.pp_no,\n\t\tguests.idno,guests.address,guests.town,guests.postal_code,guests.phone,\n\t\tguests.email,guests.mobilephone,countries.country,reservation.reserve_checkindate\n\t\t\tFrom guests\n\t\t\tInner Join countries ON guests.countrycode = countries.countrycode\n\t\t\tInner Join reservation ON guests.guestid = reservation.guestid\n\t\t\tWhere reservation.reserve_checkindate >= current_date()"; break; case "departures": $sql = "Select guests.guestid,concat_ws(' ',guests.firstname,guests.middlename,guests.lastname) as guest,guests.pp_no,\n\t\tguests.idno,guests.address,guests.town,guests.postal_code,guests.phone,\n\t\tguests.email,guests.mobilephone,countries.country\n\t\t\tFrom guests\n\t\t\tInner Join countries ON guests.countrycode = countries.countrycode\n\t\t\tInner Join booking ON guests.guestid = booking.guestid\n\t\t\tWhere booking.checkout_date=current_date()"; guestslist($sql); break; case "dep_summ": $sql = "Select rooms.roomno as RoomNo,transactions.doc_no as DocNo,transactions.doc_type,concat_ws(' ',guests.firstname,guests.middlename,guests.lastname) AS Name,\n\t\ttransactions.dr as Debit,transactions.cr as Credit,details.item as Remarks,transactions.doc_date as DocDate\n\t\t\tFrom transactions\n\t\t\tleft Join details ON transactions.details = details.itemid\n\t\t\tleft Join bills ON transactions.billno = bills.billno\n\t\t\tInner Join booking ON bills.book_id = booking.book_id\n\t\t\tInner Join guests ON booking.guestid = guests.guestid\n\t\t\tInner Join rooms ON booking.roomid = rooms.roomid"; //Where transactions.details = '$details' and transactions.doc_date = '$date' echo "<table>\n\t\t<tr><td><h2>Departmental Summary Control Sheet</h2></td></tr>\n\t\t<tr>\n\t\t<td>Department: <select name=\"itemid\" id=\"itemid\"\">\n\t\t<option value=\"All\" >All</option>"; populate_select("details", "itemid", "item", $details); echo "</select></td>\n\t\t<td>Date:<input name=\"date\" id=\"date\" type=\"text\" size=\"10\" readonly=\"true\">\n\t\t<small><a href=\"javascript:showCal('Calendar8')\"> <img src=\"images/ew_calendar.gif\" width=\"16\" height=\"15\" border=\"0\"/></a></small>\n\t\t</td>\n\t\t<td><input name=\"submit\" type=\"submit\" value=\"Submit\"></td>\n\t\t</tr>\n\t\t</table>"; getdata(); break; default: echo "<h2>Under construction</h2>"; } /** *getting all guestlist from database based upon sql query<br> *@param $sql [in] sql query<br> *Connecto to the database and the result display in web page<br> *uses constants <b>HOST</b>,<b>USER</b>,<b>PASS</b>,<b>DB</b>,<b>PORT</b> to connecto to the database <br> *Generate HTML output by table in web page.<br> */ function guestslist($sql) {
<td><?php echo $_L['AGT_city']; ?> <font color="#FF0000">*</font></td> <td><input size="40px" type="text" name="town" value="<?php echo trim($agent['town']); ?> " /></td> </tr> <tr> <td><?php echo $_L['AGT_country']; ?> </td> <td><select name=country ><?php populate_select("countries", "countrycode", "country", $agent['country'], ""); ?> </select> </tr> <tr> <td><?php echo $_L['AGT_pcode']; ?> </td> <td><input size="40px" type="text" name="postcode" value="<?php echo trim($agent['postcode']); ?> " /></td> </tr> <tr> <td><?php
?> </td> </tr> <tr id=targetroomtype style="<?php echo $rtstyle; ?> "> <td> <select name=roomtypeid_3 class="plainDropDown" onchange="document.forms[0].submit();"> <option value=0> </option> <?php $selected = ""; if (isset($_POST['roomtypeid_3']) && isset($_POST['add_id']) && $_POST['add_id'] == 0) { $selected = $_POST['roomtypeid_3']; } populate_select("roomtype", "roomtypeid", "roomtype", $selected, ""); ?> </select> </td> <td> <?php $rmtid = ""; $selected = ""; $rates = array(); if (isset($_POST['roomtypeid_3']) && isset($_POST['add_id']) && $_POST['add_id'] == 0) { $rmtid = $_POST['roomtypeid_3']; } if (isset($_POST['ratesid_3']) && isset($_POST['add_id']) && $_POST['add_id'] == 0) { $selected = $reservation['ratesid']; } get_ratebyroomtypeid($rmtid, $rates);
?> </textarea> <input type="hidden" id="enc_desc" name="enc_desc" value="<?php echo $policy['description']; ?> " /> </td> </tr> <tr><td> </td></tr> <tr> <td><?php echo $_L['PL_lang']; ?> </td> <td><select name="language"><option value='0'></option><?php populate_select("languages", "lang", "lang", $policy['language'], "active = 1"); ?> </select></td> </tr> </tr> <tr><td> </td></tr><tr><td> </td></tr> </table> </td> </tr> <tr><td align="left"><div id="RequestDetails"></div></td></tr> </table> </div> <div> <table align="right"> <tr height="18px" ><td> </td></tr> <tr><td colspan="4"><input class="button" type="submit" name="Submit" value="<?php
populate_select("rates", "ratesid", "ratecode", $roomtypes[$idx]['rateid'], "rate_type=" . DEFAULTRATE); echo " </select></td>\n"; echo "<td> <input type=text name='url_" . $i . "' value='" . $roomtypes[$idx]['roomurl'] . "' size=25 /></td>\n"; echo "</tr>\n"; } } ?> <tr class="tdbgcl"> <td></td> <td><input type=text name=newroomtype size=15 maxlength=15 /></td> <td><input type=text name=newdescription size=21 maxlength=100 /></td> <td> <select id="newrateid" name="newrateid"> <option value='0'></option> <?php populate_select("rates", "ratesid", "ratecode", 0, "rate_type=" . DEFAULTRATE); ?> </select> </td> <td><input type=text name=newurl size=25 /></td> </tr> </table> </div> <?php if (is_ebridgeCustomer()) { ?> <div class="TabbedPanelsContent" style="overflow:auto; width:780px; height:360px;"> <table height="" width="780px" class="tdbgcl" border="0" cellpadding="0"> <?php foreach ($roomtypes as $idx => $val) { include_once dirname(__FILE__) . "/OTA/advancedFeatures/adv_functions.php";
<select name=itemid id=itemid class=plainDropDown > <option value="0" > </option> <?php populate_select("details", "itemid", "item", "{$itemid}", ""); ?> </select> </td> <td> <select name=rateid class="plainDropDown2" > <option value=0> </option> <?php $cond = ""; //$cond = "rate_type=".PROMORATE; // if there is an agent rate select it as well, but once unselected/saved it will be gone. //if($rateid) $cond .= " or ratesid = ".$rateid; populate_select("rates", "ratesid", "ratecode", "", $cond); ?> </select> </td> <td rowspan=2><input name='amount' id='amount' size=5 maxlength=10 value='<?php echo $amount; ?> ' onchange="update_tax_svc('amount','tax','svc');calc_amnt('amount','tax','svc','gross','','quantity');" onkeyup='verify(this.id); '/> </td> <td rowspan=2><input name='svc' id='svc' size=5 maxlength=10 value='<?php echo $svc; ?> ' onchange="calc_amnt('amount','tax','svc','gross','','quantity');" onkeyup='verify(this.id); '/> </td> <td rowspan=2><input name='tax 'id='tax' size=5 maxlength=10 value='<?php echo $tax; ?> ' onchange="calc_amnt('amount','tax','svc','gross','','quantity'); " onkeyup='verify(this.id); '/> </td>
?> </select></td> </tr> <tr> <td style="padding:5" ><?php echo $_L['GST_nationality']; ?> </td> <td style="padding:5" colspan="3"> <select name="nationality" class=plainDropDown > <option value=""><?php echo $_L['GST_selcountry']; ?> </option> <?php populate_select("countries", "countrycode", "country", $thisguest['nationality'], ""); ?> </select> </td> </tr> <tr> <td style="padding:5" ><?php echo $_L['GST_phone']; ?> <br />(<?php echo $_L['GST_areacode']; ?> ) </td> <td style="padding:5" ><input type="text" name="phone" id="phone" value="<?php echo trim($thisguest['phone']); ?>
populate_select("countries", "countrycode", "country", $bookings['countrycode'], ""); ?> </select> </td> <td><?php echo $_L['GST_nationality']; ?> <br/> <select name="nationality" class=plainDropDown > <option value=""><?php echo $_L['GST_selcountry']; ?> </option> <?php populate_select("countries", "countrycode", "country", $bookings['nationality'], ""); ?> </select> </td> </tr> </table> </td> </tr> </table> </td> </tr> </table>
print get_ratesperiodstring($rateitems[$idx]['validperiod'], 0, 0, 1); // print $rateitems[$idx]['validperiod']; print "</td>"; print "<td>" . $rateitems[$idx]['maxcount'] . " </td></tr>"; } ?> <tr> <td> </td> <td> <select style="width: 70px;" name=itemcode> <?php $cond = ""; if ($ratetype == DEFAULTRATE) { $cond = "itype=" . ROOM; } populate_select("details", "itemid", "item", 0, $cond); ?> </select> </td> <td> <select style="width:70px; " name=dis > <option value="<?php echo STANDARD; ?> " ><?php echo $_L['RTS_standard']; ?> </option> <?php if ($ratetype != DEFAULTRATE) { ?>
function trans_type() { //get items for cashsale or get items for expenses switch ($_POST["button"]) { case "Cash": echo "<table>\n\t\t<tr>\n\t\t<td width=\"27%\">Date</td>\n\t\t<td width=\"22%\">Details</td>\n\t\t<td width=\"26%\">CR Amount</td>\n\t\t<td width=\"25%\">Rec No. </td>\n\t\t<td align=\"center\">Post</td>\n\t </tr>\n\t\t<tr><td><input type=\"text\" name=\"doc_date\" id=\"doc_date\" size=\"15\"/><a href=\"javascript:showCal('Calendar7')\"> <img src=\"images/ew_calendar.gif\" width=\"16\" height=\"15\" border=\"0\"/></a></td>\n\t\t<td><select name=\"details\">\n\t\t\t<option value=\"\">Select Item</option>"; populate_select("details", "itemid", "item", 0); echo "</select></td>\n\t\t<td><input type=\"text\" name=\"cr\" size=\"20\"/></td>\n\t\t<td><input type=\"text\" name=\"doc_no\" size=\"15\" /></td>\n\t\t<td align=\"center\"><input type=\"submit\" name=\"Submit\" value=\"Update\"/></td>\n\t\t</tr></table>"; break; case "Debit": echo "<table>\n\t\t<tr>\n\t\t<td width=\"27%\">Date</td>\n\t\t<td width=\"22%\">Details</td>\n\t\t<td width=\"26%\">DR Amount</td>\n\t\t<td width=\"25%\">Chit No. </td>\n\t\t<td align=\"center\">Post</td>\n\t </tr>\n\t\t<tr><td><input type=\"text\" name=\"doc_date\" id=\"doc_date\" size=\"15\"/><a href=\"javascript:showCal('Calendar7')\"> <img src=\"images/ew_calendar.gif\" width=\"16\" height=\"15\" border=\"0\"/></a></td>\n\t\t<td><select name=\"details\">\n\t\t\t<option value=\"\">Select Item</option>"; populate_select("details", "itemid", "item", 0); echo "</select></td>\n\t\t<td><input type=\"text\" name=\"dr\" size=\"20\"/></td>\n\t\t<td><input type=\"text\" name=\"doc_no\" size=\"15\" /></td>\n\t\t<td align=\"center\"><input type=\"submit\" name=\"Submit\" value=\"Update\" /></td>\n\t\t</tr></table>"; break; } }
/> ID. No.</label> </p> </td> <td><input type="text" name="pp_id_no" value="<?php echo !is_null($guests->pp_no) ? $guests->pp_no : $guests->idno; ?> " /></td> <td> </td> <td> </td> </tr> <tr> <td>Country</td> <td colspan="3"><select name="countrycode"> <option value="">Select Country</option> <?php populate_select("countries", "countrycode", "country", $guests->countrycode); ?> </select></td> </tr> <tr> <td>Telephone<br>(Area Code-Phone No.) </td> <td><input type="text" name="phone" id="phone" value="<?php echo trim($guests->phone); ?> " /></td> <td>Mobile</td> <td><input type="text" name="mobilephone" id="mobilephone" value="<?php echo trim($guests->mobilephone); ?> " /></td> </tr>
<td>Voucher No. </td> <td><input type="text" name="voucher_no" /></td> </tr> <tr> <td>Address</td> <td bgcolor="#66CCCC"><?php echo "P. O. Box " . trim($guests->pobox) . "<br>"; echo trim($guests->town) . "-" . trim($guests->postal_code); ?> </td> <td>Room No. </td> <td><div id="showrates"></div> <select name="roomid" id="roomid" onchange="loadHTMLPost('ajaxfunctions.php','showrates','GetRates')"> <option value="" >Select Room</option> <?php populate_select("rooms", "roomid", "roomno", $bookings->roomid); ?> </select></td> </tr> <tr> <td>Daily Rates</td> <td><input type="text" name="textfield" /></td> <td>Deposit</td> <td><input type="text" name="deposit" /></td> </tr> <tr> <td colspan="2"><h2>Booking Taken By</h2></td> <td colspan="2"><h2>Booking Confirmed By:</h2></td> </tr> <tr> <td>Name</td>
if ($showPost == 1 && isset($_POST['ROOMCOST'])) { echo $_POST['ROOMCOST']; } ?> "/></td> </tr> <tr> <td style="padding:5px;" align="left"><?php echo $_L['CUR_currency']; ?> </td> <td align="left"> <!-- changing currency text field into select field in the form --> <select name=CURRENCY > <?php populate_select("countries", "currency", "currency", $currencycode, "currency <> ''"); ?> </select> </td> </tr> <tr> <td ></td> <td ></td> <td style="padding:5px;" align="right"><input class="button" type="submit" name="submit" id="submit" value="<?php echo $_L['RM_addroom']; ?> " /></td> </tr> </table> </td> </tr>