<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'];
Exemple #3
0
								  </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 
Exemple #4
0
		<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)
{
Exemple #6
0
									<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);
Exemple #8
0
?>
</textarea>
								      <input type="hidden" id="enc_desc" name="enc_desc" value="<?php 
echo $policy['description'];
?>
" />
								  </td>
								</tr>
								<tr><td>&nbsp;</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>&nbsp;</td></tr><tr><td>&nbsp;</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>&nbsp;</td></tr>
						<tr><td colspan="4"><input class="button" type="submit" name="Submit" value="<?php 
Exemple #9
0
        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";
Exemple #10
0
							  <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>
Exemple #11
0
?>
										</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']);
?>
Exemple #12
0
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>
Exemple #13
0
        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>&nbsp;</td>
              <td>&nbsp;</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>