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>