submitted.php
78 lines
| 1 | <?php |
| 2 | global $wpdb; |
| 3 | |
| 4 | $assignment = sanitize_text_field($_GET['assignment']); |
| 5 | $assignments_submitted = $wpdb->get_results("SELECT * FROM {$wpdb->comments} WHERE comment_type = 'tutor_assignment' AND comment_post_ID = {$assignment}"); |
| 6 | |
| 7 | ?> |
| 8 | |
| 9 | |
| 10 | <h3><?php esc_html_e('Assignment', 'tutor') ?></h3> |
| 11 | <div class="tutor-dashboard-info-table-wrap"> |
| 12 | <?php |
| 13 | |
| 14 | if (tutor_utils()->count($assignments_submitted)){ |
| 15 | |
| 16 | ?> |
| 17 | |
| 18 | <table class="tutor-dashboard-info-table tutor-dashboard-assignment-submitted-table"> |
| 19 | <thead> |
| 20 | <tr> |
| 21 | <td><?php esc_attr_e('Student', 'tutor'); ?></td> |
| 22 | <td><?php esc_attr_e('Date & Time', 'tutor'); ?></td> |
| 23 | <td><?php esc_attr_e('Pass Mark', 'tutor'); ?></td> |
| 24 | <td><?php esc_attr_e('Total Mark', 'tutor'); ?></td> |
| 25 | <td><?php esc_attr_e('Result', 'tutor'); ?></td> |
| 26 | <td> </td> |
| 27 | </tr> |
| 28 | </thead> |
| 29 | |
| 30 | <tbody> |
| 31 | <?php |
| 32 | |
| 33 | foreach ($assignments_submitted as $assignment){ |
| 34 | $comment_author = get_user_by('login', $assignment->comment_author); |
| 35 | $is_reviewed_by_instructor = get_comment_meta($assignment->comment_ID, 'evaluate_time', true); |
| 36 | $max_mark = tutor_utils()->get_assignment_option($assignment->comment_post_ID, 'total_mark'); |
| 37 | $pass_mark = tutor_utils()->get_assignment_option($assignment->comment_post_ID, 'pass_mark'); |
| 38 | $given_mark = get_comment_meta($assignment->comment_ID, 'assignment_mark', true); |
| 39 | $status = sprintf(__('%s Pending %s', 'tutor'), '<span class="pending">', '</span>'); |
| 40 | if(!empty($given_mark)){ |
| 41 | $status = (int) $given_mark >= (int) $pass_mark ? sprintf(__('%s Pass %s', 'tutor'), '<span class="pass">', '</span>') : sprintf(__('%s Fail %s', 'tutor'), '<span class="fail">', '</span>'); |
| 42 | } |
| 43 | |
| 44 | $review_url = tutor_utils()->get_tutor_dashboard_page_permalink('assignments/review'); |
| 45 | |
| 46 | ?> |
| 47 | <tr> |
| 48 | <td><?php echo $comment_author->display_name; ?></td> |
| 49 | <td><?php echo date('j M, Y. h:i a', strtotime($assignment->comment_date)); ?></td> |
| 50 | <td><?php echo $pass_mark; ?></td> |
| 51 | <td><?php echo !empty($given_mark) ? $given_mark . '/' . $max_mark : $max_mark; ?></td> |
| 52 | <td><?php echo $status; ?></td> |
| 53 | <td> <?php echo "<a title='". __('Review this assignment', 'tutor') ."' href='".esc_url($review_url.'?view_assignment='.$assignment->comment_ID)."'><i class='tutor-icon-angle-right'></i> </a>"; ?> </td> |
| 54 | </tr> |
| 55 | <?php |
| 56 | } |
| 57 | |
| 58 | ?> |
| 59 | |
| 60 | </tbody> |
| 61 | </table> |
| 62 | |
| 63 | |
| 64 | <?php |
| 65 | |
| 66 | }else{ |
| 67 | |
| 68 | ?> |
| 69 | |
| 70 | <p><?php _e('No assignment has been submitted yet', 'tutor'); ?></p> |
| 71 | <?php |
| 72 | |
| 73 | } |
| 74 | ?> |
| 75 | |
| 76 | |
| 77 | </div> |
| 78 |