break;
case "pdf":
break;
}
$colorswitch = TRUE;
mysql_data_seek($users, 0);
while ($student = mysql_fetch_object($users)) {
if ($student->firstname != "" && $student->lastname != "") {
$student_activities = mysql_query("SELECT * FROM `activities_bookings` WHERE `user_id` ={$student->id} LIMIT 1");
if (@mysql_num_rows($student_activities) > 0) {
$student_activities = mysql_fetch_object($student_activities);
$student_activities->bookings = explode("|", $student_activities->bookings);
$count = 0;
$found = FALSE;
while ($count < $weekduration) {
$activity_id = returnActivityBookedOnDay($count, $student_activities->bookings);
if ($activity_id == $activity->id) {
$found = TRUE;
}
$count++;
}
if ($found) {
$colorswitch = !$colorswitch;
$query = "SELECT `name` FROM `users_groups` WHERE `id` = {$student->group_id} LIMIT 1;";
$group_details = mysql_query($query);
$group_details = @mysql_fetch_object($group_details);
if ($reporttype != "csv") {
?>
<tr>
<td class="<?php
if ($colorswitch) {
function getPendingPayments($vars)
{
require "includes/config.php";
$activitydetails = $_SESSION['activitydetails'];
?>
<u>Payments To Return</u><br />
<?php
$userid = $vars['uid'];
$total_cost = 0;
$user = getuserdetails($userid);
$user_activities = mysql_query("SELECT * FROM `payment_bookings` WHERE `user_id` = {$userid} LIMIT 1");
$user_activities = mysql_fetch_object($user_activities);
if (!$user_activities) {
$user_activities = mysql_query("SELECT * FROM `activities_bookings` WHERE `user_id` = {$userid} LIMIT 1");
$user_activities = @mysql_fetch_object($user_activities);
$user_activities->bookings = explode("|", $user_activities->bookings);
if ($user_activities) {
for ($i = 0; $i < $weekduration; $i++) {
$activity_id = returnActivityBookedOnDay($i, $user_activities->bookings);
$activity = $activitydetails[$activity_id];
if ($activity) {
$total_cost = $total_cost + $activity->cost;
if ($activity->cost > 0) {
$activities[] = $activity_id;
}
}
}
}
if ($total_cost > 0) {
mysql_query("INSERT INTO `payment_bookings` (`user_id` ,`activities_remaining` ,`money_remaining`) VALUES ('{$userid}', '" . implode("|", $activities) . "', '{$total_cost}');");
}
} else {
$activities = explode("|", $user_activities->activities_remaining);
$total_cost = $user_activities->money_remaining;
}
if (count($activities) > 0) {
$cost_remaining = $total_cost;
for ($i = 0; $i < count($activities); $i++) {
$activity = $activitydetails[$activities[$i]];
if ($activity) {
?>
<div id="subpayment_<?php
print $activities[$i];
?>
">
<input id="subpaymentchk_<?php
print $activities[$i];
?>
" type="checkbox" onchange="removePendingPayment('<?php
print $activities[$i];
?>
','<?php
print $userid;
?>
');" />
<label style="width: 300px;" for="subpaymentchk_<?php
print $activities[$i];
?>
">£<?php
if ($cost_remaining < $activity->cost && $cost_remaining > 0 && $activity->cost > 0) {
print $cost_remaining . " left of £" . $activity->cost;
} else {
print $activity->cost;
}
?>
for <?php
print $activity->name;
?>
.</label><br />
</div>
<?php
$cost_remaining = $cost_remaining - $activity->cost;
}
}
if ($cost_remaining > 0) {
print "+ £" . "{$cost_remaining} additional.<br />";
}
}
if ($total_cost <= 0) {
?>
<?php
print $user->firstname;
?>
is not required to make any payments at this time.
<?php
} else {
?>
<div id="fullpaymentreturn_link" style="margin-top: 10px;">
<input id="paymentchk" type="checkbox" onchange="removePendingPayment('<?php
print implode(":", $activities);
?>
','<?php
print $userid;
?>
', true);" />
<label style="width: 300px;" for="paymentchk"><?php
print $user->firstname;
?>
has paid the full amount of £<?php
print $total_cost;
?>
.</label>
</div>
<br />Tick a box or enter an amount:<br /><br />
<label for="deductamount" style="width: 120px;">Amount Payed: £</label><input id="deductamount" name="deductamount" type="text" maxlength="3" size="3" />
<input name="deduct" onclick="deductPayment('<?php
print $userid;
?>
');" type="button" value="Deduct From Total"/>
<br />
<?php
}
}
