<td class="cell"> </td> <td class="cell"><a href="admin.php?pagetoload=application_form.php&resident_id=<?php echo $arrData[resident_id]; ?> &from=applications_list_accepted.php" class="table_link2"><?php echo $arrData[name] . " " . $arrData[surname]; ?> </a></td> <td class="cell"> </td> <td class="cell"><?php echo mostrar_fecha(substr($arrData[arrival], 0, 10)); ?> </td> <td class="cell"> </td> <td class="cell"><?php echo mostrar_fecha(substr($arrData[planned_departure], 0, 10)); ?> </td> <td class="cell"> </td> <td class="cell"><?php echo $room; ?> </td> <td class="cell"> </td> <td class="cell"><?php echo $telephone; ?> </td> <td class="cell"> </td> <td class="cell"><?php echo $arrData[city];
while ($arrData = mysql_fetch_assoc($r)) { ?> <tr class="row1" onMouseOver="this.className='row_selected'" onMouseOut="this.className='row1'"> <td class="cell"><a href="admin.php?pagetoload=groups_members.php&group_id=<?php echo $arrData[group_id]; ?> " class="table_link2"><?php echo $arrData[name]; ?> </a></td> <td class="cell"><?php echo mostrar_fecha($arrData[arrival]); ?> </td> <td class="cell"><?php echo mostrar_fecha($arrData[departure]); ?> </td> <td class="cell"><a href="javascript:delete_group(<?php echo $arrData[group_id]; ?> ,'<?php echo $arrData[name]; ?> ')"><img src="imgs/trash_16x16.gif" border="0"></a></td> </tr> <?php } ?> </table> <?php
&from=residents_list.php" class="table_link2" <?php echo $birthday; ?> ><?php echo $arrData[surname] . ", " . $arrData[name]; ?> </a></td> <td valign="middle" class="cell" <?php echo $birthday; ?> > </td> <td valign="middle" class="cell" align="left" <?php echo $birthday; ?> ><?php echo mostrar_fecha(substr($arrData[date_of_birth], 0, 10)); ?> </td> <td valign="middle" class="cell" <?php echo $birthday; ?> > </td> </tr> <?php } ?> </table> <?php } }
$arrClasses = array(); //The purpose of this page should only be to keep track of the residents who are currently in Netherhall. $today = date('Y-m-d'); $r = mysql_query("SELECT residents.resident_id, NAME, surname " . "FROM residents LEFT JOIN bookings ON residents.resident_id = bookings.resident_id " . "WHERE bookings.status='accepted' AND bookings.done=0 AND bookings.arrival <= '{$today}' " . "GROUP BY residents.resident_id ORDER BY surname, NAME"); if (mysql_num_rows($r)) { ?> <table align="center" border="1" cellpadding="4" cellspacing="0"> <?php while ($arrInfo = mysql_fetch_assoc($r)) { $total_outstanding = 0; $r2 = mysql_query("SELECT * FROM residents LEFT JOIN bookings ON residents.resident_id = bookings.resident_id " . "WHERE bookings.status='accepted' AND residents.resident_id={$arrInfo[resident_id]} " . "ORDER BY NAME, surname, bookings.arrival"); while ($arrData = mysql_fetch_assoc($r2)) { //ver_array("arrData",$arrData); $date_from = mostrar_fecha($arrData['arrival']); $date_to = mostrar_fecha($arrData['planned_departure']); $days = subtract_dates($date_from, $date_to); $total_rent = $days * ($arrData['weekly_rate'] / 7); $total_rent = round($total_rent, 2); $due = $total_rent + $arrData['laundry'] + $arrData['hc'] + $arrData['printing'] + $arrData['extra']; //$outstanding = $due - $arrData['deposit'] - $arrData['received']; $outstanding = $due - $arrData['received']; $outstanding = round($outstanding, 2); $name = ""; if ($arrData[surname] != "") { $name = $arrData[surname] . ", "; } $name .= $arrData[name]; if (mysql_num_rows($r2) < 2) { ?> <tr class="row1">
<? } ?> </table> </div> </td> </tr> <? $div_num++; } $r=mysql_query("SELECT * FROM bookings WHERE resident_id=$resident_id AND status='finished' ORDER BY arrival DESC"); while ($arrAccomodation=mysql_fetch_assoc($r)) { $date_from = mostrar_fecha($arrAccomodation['arrival']); $date_to_planned = mostrar_fecha($arrAccomodation['departure']); $date_to = mostrar_fecha($arrAccomodation['actual_departure']); $days=subtract_dates($date_from, $date_to_planned); // Search the name of the room if ($arrAccomodation[room_id]) { $r2=mysql_query("SELECT * FROM rooms WHERE room_id={$arrAccomodation[room_id]}"); $room = ""; if (mysql_numrows($r2)) $room=mysql_result($r2,0,"room"); } //ver_array("arrAccomodation",$arrAccomodation); $total_rent = $days * ($arrAccomodation['weekly_rate']/7); $total_rent = round($total_rent,2); $due = $total_rent + $arrAccomodation['laundry'] + $arrAccomodation['hc'] + $arrAccomodation['printing'] + $arrAccomodation['extra'];
?> <TABLE width="900" border="0" align="center" cellpadding="10" cellspacing="0" bgcolor="#FFFFFF"> <TR><TD align="center" class="question">This room is booked for:</td></tr> <?php while ($arrData = mysql_fetch_assoc($r2)) { ?> <TR> <TD align="center"><a href="admin.php?pagetoload=application_form.php&resident_id=<?php echo $arrData[resident_id]; ?> &from=residents_list.php" class="table_link2"><?php echo $arrData["name"] . " " . $arrData["surname"]; ?> </a> <?php echo "<br>(Arrival: " . mostrar_fecha($arrData[arrival]) . " Departure: " . mostrar_fecha($arrData[planned_departure]) . ")"; ?> </TD> </TR> <?php } ?> </table> <br> <?php } else { ?> <p align="center" class="question">This room is free</p><?php } button("admin.php?pagetoload=booking_busy_list.php", "Find again"); } else {
echo $arrData[resident_id]; ?> " <? if ($arrData[interview]) echo 'checked'; ?>></td> <td class="cell"> </td> <td class="cell"> <input type="checkbox" name="off<?php echo $arrData[resident_id]; ?> " <? if ($arrData[offered]) echo 'checked'; ?>> <?php $offered_date = $request['odate' . $arrData[resident_id]]; //echo "rules_date=($rules_date)<br>"; if ($offered_date != "" && !valid_date($offered_date)) { echo "<br><font color=red>Invalid Date!</font>"; } else { $offered_date = mostrar_fecha(substr($arrData[offered_date], 0, 10)); } ?> <input type="text" name="odate<?php echo $arrData[resident_id]; ?> " value="<?php echo $offered_date; ?> " size="8"> </td> <td class="cell"> </td> </tr> <?php } if (mysql_num_rows($r)) {
$pdf->Cell(15, $high, "Due", $border, 0, 'R', true); $pdf->Cell(15, $high, "Received", $border, 0, 'R', true); $pdf->Cell(18, $high, "Outstanding", $border, 0, 'R', true); $pdf->Ln(); //################################################################################################################ $total_outstanding = 0; if ($resident_id) { $r = mysql_query("SELECT * FROM bookings WHERE resident_id={$resident_id} AND (status='' OR status IS NULL OR status='accepted') ORDER BY arrival DESC"); $num_of_accounts = mysql_num_rows($r); $accounts = 0; $total_outstanding = 0; while ($arrAccomodation = mysql_fetch_assoc($r)) { $accounts++; //ver_array("arrAccomodation",$arrAccomodation); $date_from = mostrar_fecha($arrAccomodation['arrival']); $date_to = mostrar_fecha($arrAccomodation['planned_departure']); $days = subtract_dates($date_from, $date_to); // Search the name of the room if ($arrAccomodation[room_id]) { $r2 = mysql_query("SELECT * FROM rooms WHERE room_id={$arrAccomodation[room_id]}"); $room = ""; if (mysql_numrows($r2)) { $room = mysql_result($r2, 0, "room"); } } $total_rent_pre = $days * ($arrAccomodation['weekly_rate'] / 7); $total_rent = round($total_rent_pre, 2); $due = $total_rent + $arrAccomodation['laundry'] + $arrAccomodation['hc'] + $arrAccomodation['printing'] + $arrAccomodation['extra']; $invoice_number = "NO BILL"; $outstanding = $due - $arrAccomodation['deposit'] - $arrAccomodation['received']; $total_outstanding = $total_outstanding + $outstanding;
$pdf->Cell(55, 4, "Subject", $border, 0, '', true); $pdf->Ln(); $pdf->SetFillColor(255, 255, 255); $i = 0; while ($arrData = mysql_fetch_assoc($r)) { $i++; $surname = $arrData[surname]; $name = $arrData[name]; if ($surname == "") { $surname = $arrData[name]; $name = ""; } $pdf->Cell(35, 4, $surname, $border); $pdf->Cell(30, 4, $name, $border); $pdf->Cell(20, 4, mostrar_fecha(substr($arrData[arrival], 0, 10)), $border); $pdf->Cell(20, 4, mostrar_fecha(substr($arrData[departure], 0, 10)), $border); $pdf->Cell(9, 4, $arrData[room], $border); $pdf->Cell(9, 4, $arrData[telephone], $border); $pdf->Cell(25, 4, $arrData[city], $border); $pdf->Cell(25, 4, $arrData[country], $border); $pdf->Cell(55, 4, substr($arrData[college], 0, 56), $border); $pdf->Cell(55, 4, substr($arrData[subject], 0, 56), $border); $pdf->Ln(); } $pdf->Output(); function mostrar_fecha($fecha) { if ($fecha != "" && $fecha != "0000/00/00") { return substr($fecha, 8, 2) . "/" . substr($fecha, 5, 2) . "/" . substr($fecha, 0, 4); //return substr($fecha,8,2)."-".substr($fecha,5,2)."-".substr($fecha,0,4); } else {
function escribe_formulario_fecha_vacio($nombrecampo,$nombreformulario,$date,$resident_id,$booking_id,$return_page){ global $raiz; /*echo ' <INPUT name="'.$nombrecampo.'" size="10" value="'.date("d",time())."/".date("m",time())."/".date("Y",time()).'"><br> <input type=button value="Buscar Fecha" onclick="muestraCalendario(\''. $raiz.'\',\''. $nombreformulario .'\',\''.$nombrecampo.'\')"> '; */ $date=mostrar_fecha($date); echo ' <INPUT name="'.$nombrecampo.'" size="8" value="'.$date.'"> <img src="imgs/date_16x16.gif" align="absmiddle" onclick="muestraCalendario(\''. $raiz.'\',\''. $nombreformulario .'\',\''.$nombrecampo.'\',\''. $resident_id .'\',\''. $booking_id .'\',\''. $return_page .'\')"> '; }
<td valign="middle" class="cell"> </td> <td valign="middle" class="cell" align="left"><a href="admin.php?pagetoload=application_form.php&resident_id=<?php echo $arrData[resident_id]; ?> &from=residents_list.php" class="table_link2"><?php echo $arrData[surname]; ?> </a></td> <td valign="middle" class="cell"> </td> <td valign="middle" class="cell" align="left"><?php echo mostrar_fecha(substr($arrData[barrival], 0, 10)); ?> </td> <td valign="middle" class="cell"> </td> <td valign="middle" class="cell" align="left"><?php echo mostrar_fecha(substr($arrData[bdeparture], 0, 10)); ?> </td> <td valign="middle" class="cell"> </td> <td valign="middle" class="cell" align="left"><?php echo $arrData[room]; ?> </td> <td valign="middle" class="cell"> </td> <td valign="middle" class="cell" align="left"><?php echo $arrData[telephone]; ?> </td> <td valign="middle" class="cell"> </td> <td valign="middle" class="cell" align="left"><?php echo $arrData[city];
$pdf->Ln(); $pdf->SetFillColor(230, 230, 230); $pdf->Cell(55, $high, "Course (BA, MSc, PhD, etc)", $border, 0, '', true); $pdf->SetFillColor(255, 255, 255); $pdf->Cell(125, $high, $arrResident[course], $border, 0, '', true); $pdf->Ln(); $pdf->SetFillColor(230, 230, 230); $pdf->Cell(55, $high, "Academic Year", $border, 0, '', true); $pdf->SetFillColor(255, 255, 255); $pdf->Cell(125, $high, $arrResident[academic_year], $border, 0, '', true); $pdf->Ln(); $pdf->SetFillColor(230, 230, 230); $pdf->Cell(55, $high, "Accommodation Dates", $border, 0, '', true); $pdf->SetFillColor(255, 255, 255); $arr = mostrar_fecha($arrResident[arrival]); $dep = mostrar_fecha($arrResident[departure]); $pdf->Cell(63, $high, "From: " . $arr, $border, 0, '', true); $pdf->Cell(62, $high, "To: " . $dep, $border, 0, '', true); $pdf->Ln(); $pdf->Ln(); $pdf->SetFillColor(230, 230, 230); $pdf->Cell($width2, $high, "Schools attended (with dates)", $border, 0, '', true); $pdf->Cell($width2, $high, "School examinations passed (with grades)", $border, 0, '', true); $pdf->Ln(); $pdf->SetWidths(array($width2, $width2)); $pdf->Row(array($arrResident[school_attended], $arrResident[school_examinations])); $pdf->SetFillColor(230, 230, 230); $pdf->Cell($width2, $high, "Universities attended", $border, 0, '', true); $pdf->Cell($width2, $high, "Qualifications obtained (with grades)", $border, 0, '', true); $pdf->Ln(); $pdf->SetFillColor(255, 255, 255);