function getScheduleTexts()
{
global $CFG;
$ret = '';
$q = safe_r_sql("select Scheduler.*, if(SchStart=0, '', date_format(SchStart, '%H:%i')) Start from Scheduler\n\t\twhere SchTournament={$_SESSION['TourId']} and SchDay>0\n\t\torder by SchDay, SchStart, SchDuration");
$ret .= '<tr>
<th class="Title" colspan="9">' . get_text('Z-Session', 'Tournament') . '</th>
</tr>
<tr>
<th class="Title" width="10%"><img src="' . $CFG->ROOT_DIR . 'Common/Images/Tip.png" title="' . get_Text('TipDate', 'Tournament') . '" align="right">' . get_text('Date', 'Tournament') . '</th>
<th class="Title" width="10%">' . get_text('Time', 'Tournament') . '</th>
<th class="Title" width="10%">' . get_text('Order', 'Tournament') . '</th>
<th class="Title" width="10%">' . get_text('Length', 'Tournament') . '</th>
<th class="Title" width="10%">' . get_text('Delayed', 'Tournament') . '</th>
<th class="Title" width="10%">' . get_text('Title', 'Tournament') . '</th>
<th class="Title" width="10%">' . get_text('SubTitle', 'Tournament') . '</th>
<th class="Title" width="10%">' . get_text('Text', 'Tournament') . '</th>
<th class="Title"></th>
</tr>';
$ret .= '<tr>
<td><input size="10" type="text" name="Fld[Day]"></td>
<td><input size="5" type="text" name="Fld[Start]"></td>
<td><input size="5" type="text" name="Fld[Order]"></td>
<td><input size="3" type="text" name="Fld[Duration]"></td>
<td><input size="5" type="text" name="Fld[Shift]"></td>
<td><input size="30" type="text" name="Fld[Title]"></td>
<td><input size="30" type="text" name="Fld[SubTitle]"></td>
<td><input size="30" type="text" name="Fld[Text]"></td>
<td><input type="button" onclick="DiInsert(this)" value="' . get_text('CmdAdd', 'Tournament') . '"></td>
</tr>';
while ($r = safe_fetch($q)) {
$ret .= '<tr>
<td><input size="10" type="text" name="Fld[Z][Day][' . $r->SchDay . '][' . $r->SchStart . '][' . $r->SchOrder . ']" value="' . $r->SchDay . '" onchange="DiUpdate(this)"></td>
<td><input size="5" type="text" name="Fld[Z][Start][' . $r->SchDay . '][' . $r->SchStart . '][' . $r->SchOrder . ']" value="' . $r->Start . '" onchange="DiUpdate(this)"></td>
<td><input size="5" type="text" name="Fld[Z][Order][' . $r->SchDay . '][' . $r->SchStart . '][' . $r->SchOrder . ']" value="' . $r->SchOrder . '" onchange="DiUpdate(this)"></td>
<td><input size="3" type="text" name="Fld[Z][Duration][' . $r->SchDay . '][' . $r->SchStart . '][' . $r->SchOrder . ']" value="' . $r->SchDuration . '" onchange="DiUpdate(this)"></td>
<td><input size="5" type="text" name="Fld[Z][Shift][' . $r->SchDay . '][' . $r->SchStart . '][' . $r->SchOrder . ']" value="' . $r->SchShift . '" onchange="DiUpdate(this)"></td>
<td><input size="30" type="text" name="Fld[Z][Title][' . $r->SchDay . '][' . $r->SchStart . '][' . $r->SchOrder . ']" value="' . $r->SchTitle . '" onchange="DiUpdate(this)"></td>
<td><input size="30" type="text" name="Fld[Z][SubTitle][' . $r->SchDay . '][' . $r->SchStart . '][' . $r->SchOrder . ']" value="' . $r->SchSubTitle . '" onchange="DiUpdate(this)"></td>
<td><input size="30" type="text" name="Fld[Z][Text][' . $r->SchDay . '][' . $r->SchStart . '][' . $r->SchOrder . ']" value="' . $r->SchText . '" onchange="DiUpdate(this)"></td>
<td><input type="button" id="Fld[' . $r->SchDay . '][' . $r->SchStart . '][' . $r->SchOrder . ']" onclick="DiDelete(this)" value="' . get_text('CmdDelete', 'Tournament') . '"></td>
</tr>';
}
return $ret;
}
function get_user_info($id, $batch)
{
$id = (int) $id;
$batch = (int) $batch;
$user = get_user_by_id($id);
$reviews_given = get_number_of_reviews_given($id);
$reviews_received = get_number_of_reviews_received($id);
$teammember_reviews = get_number_of_poll_team_members($id);
$notteammember_reviews = get_number_of_poll_not_team_members($id);
$teammanager_reviews = get_number_of_poll_team_manager($id);
$notteammanager_reviews = get_number_of_poll_not_team_manager($id);
$preferred_reviewers = get_number_of_preferred_reviewers($id);
$preferred_reviewees = get_number_of_preferred_reviewees($id);
$comments = get_comments($id);
$questions = get_questions();
echo get_text('Reviews_received') . ": <b>{$reviews_received}</b><br />" . get_text('Reviews_from_teammember') . ": <b>{$teammember_reviews}</b><br />" . get_text('Reviews_from_not_teammember') . ": <b>{$notteammember_reviews}</b><br />" . get_text('Reviews_from_preferred_reviewer') . ": <b>{$preferred_reviewers}</b><br />";
// get_text('Reviews_given_to_preferred_reviewee') . ": <b>$preferred_reviewees</b><br />";
?>
<h3><?php
echo get_Text('Average_score');
?>
</h3>
<h4><?php
echo get_text('Legend');
?>
</h4>
<p>
1: <?php
echo get_answer_name(1);
?>
<br/>
2: <?php
echo get_answer_name(2);
?>
<br/>
3: <?php
echo get_answer_name(3);
?>
<br/>
4: <?php
echo get_answer_name(4);
?>
<br/>
5: <?php
echo get_answer_name(5);
?>
</p>
<table class="questions">
<?php
$number = 1;
$categories = get_categories();
foreach ($categories as $category) {
?>
<thead>
<tr style="margin-top: 25px;">
<th><?php
echo $category['Name'];
?>
</th>
<th><?php
echo get_text('Average_score');
?>
</th>
<th><?php
echo get_text('Your_score');
?>
</th>
</tr>
</thead>
<tbody>
<?php
foreach ($questions as $question) {
if ($category['ID'] == $question['Category']) {
?>
<tr id="poll">
<td><?php
echo $number . '. ' . $question['Question'];
?>
</td>
<td style="text-align:center;"><?php
$avg_score = get_average_score_user($id, $question['ID']);
if ($avg_score == false) {
$avg_score = get_answer_name(6);
}
echo $avg_score;
?>
</td>
<td style="text-align:center;">
<?php
$your_score = get_answer(get_poll_by_reviewer_reviewee_batch($id, $id, $batch), $question['ID']);
if ($your_score == 6) {
$your_score = get_answer_name(6);
}
echo $your_score;
?>
</td>
</tr>
<?php
$number++;
}
}
?>
<tr class="spacer"></tr>
<?php
}
?>
</tbody>
<?php
?>
</table>
<!--<tr>
<th></th>
<th><?php
echo get_text('Question');
?>
</th>
<th><?php
echo get_text('Your_score') . '-' . get_text('Average_score');
?>
</th>
</tr>
<?php
foreach ($questions as $key => $question) {
?>
<tr>
<td>
<?php
echo $key + 1;
?>
</td>
<td>
<?php
echo $question['Question'];
?>
</td>
<td style="text-align:center;">
<?php
echo get_answer_name(get_answer(get_poll_by_reviewer_reviewee_batch($id, $id, $batch), $question['ID']));
echo " - " . get_average_score($id, $question['ID']);
?>
</td>
</tr>
<?php
}
?>
</table>-->
<?php
if ($comments) {
echo "<h3>" . get_text('Extra_comment') . ":</h3>";
foreach ($comments as $comment) {
?>
<div class="comment"><?php
echo $comment['Comment'];
?>
</div>
<?php
}
}
}
// management
echo '<table id="ScheduleTexts">';
// Get all the texts from the scheduler
echo getScheduleTexts();
echo '</table>';
echo '<table>';
// Get all the qualification items with date & time
$q = safe_r_sql("select DiSession,\r\n\t\tDiDistance,\r\n\t\tif(DiDay=0, '', DiDay) DiDay,\r\n\t\tif(DiStart=0, '', date_format(DiStart, '%H:%i')) DiStart,\r\n\t\tDiDuration,\r\n\t\tif(DiWarmStart=0, '', date_format(DiWarmStart, '%H:%i')) DiWarmStart,\r\n\t\tDiWarmDuration,\r\n\t\tDiOptions,\r\n\t\tif(SesName!='', SesName, DiSession) Session,\r\n\t\tDiShift\r\n\tfrom DistanceInformation\r\n\tinner join Session on SesTournament=DiTournament and SesOrder=DiSession and SesType=DiType and SesType='Q'\r\n\twhere DiTournament={$_SESSION['TourId']}\r\n\torder by DiSession, DiDistance");
echo '<tr>
<th class="Title" colspan="6">' . get_text('Q-Session', 'Tournament') . '</th>
<th class="Title" colspan="4" width="10%">' . get_text('WarmUp', 'Tournament') . '</th>
</tr>
<tr>
<th class="Title" width="10%">' . get_text('Session') . '</th>
<th class="Title" width="10%">' . get_text('Distance', 'Tournament') . '</th>
<th class="Title" width="10%"><img src="' . $CFG->ROOT_DIR . 'Common/Images/Tip.png" title="' . get_Text('TipDate', 'Tournament') . '" align="right">' . get_text('Date', 'Tournament') . '</th>
<th class="Title" width="10%">' . get_text('Time', 'Tournament') . '</th>
<th class="Title" width="10%">' . get_text('Length', 'Tournament') . '</th>
<th class="Title" width="10%">' . get_text('Delayed', 'Tournament') . '</th>
<th class="Title" width="10%">' . get_text('Time', 'Tournament') . '</th>
<th class="Title" width="10%">' . get_text('Length', 'Tournament') . '</th>
<th class="Title" colspan="2" width="10%">' . get_text('ScheduleNotes', 'Tournament') . '</th>
</tr>';
while ($r = safe_fetch($q)) {
echo '<tr>
<th nowrap="nowrap">' . $r->Session . '</td>
<th nowrap="nowrap">' . $r->DiDistance . '</td>
<td><input size="10" type="text" name="Fld[Q][Day][' . $r->DiSession . '][' . $r->DiDistance . ']" value="' . $r->DiDay . '" onchange="DiUpdate(this)"></td>
<td><input size="5" type="text" name="Fld[Q][Start][' . $r->DiSession . '][' . $r->DiDistance . ']" value="' . $r->DiStart . '" onchange="DiUpdate(this)"></td>
<td><input size="3" type="text" name="Fld[Q][Duration][' . $r->DiSession . '][' . $r->DiDistance . ']" value="' . $r->DiDuration . '" onchange="DiUpdate(this)"></td>
<td><input size="3" type="text" name="Fld[Q][Shift][' . $r->DiSession . '][' . $r->DiDistance . ']" value="' . $r->DiShift . '" onchange="DiUpdate(this)"></td>
