select(); $expiration_date = empty($_POST['expiration_date']) ? date('Y-m-d') : sanitize_text_field($_POST['expiration_date']); perception_enqueue_datepicker(); switch(@$_GET['action']) { case 'add': if(!empty($_POST['ok']) and check_admin_referer('perception_certificate')) { $cid = $_cert->add($_POST); do_action('perception-certificate-saved', $cid); perception_redirect("admin.php?page=perception_certificates&msg=added"); } $expiration_num = 1; if(@file_exists(get_stylesheet_directory().'/perception/certificate-form.php')) require get_stylesheet_directory().'/perception/certificate-form.php'; else require(PERCEPTION_PATH."/views/certificate-form.php"); break; case 'edit': if($multiuser_access == 'own') { $certificate = $wpdb->get_row($wpdb->prepare("SELECT * FROM ".PERCEPTION_CERTIFICATES." WHERE id=%d", $_GET['id'])); if($certificate->editor_id != $user_ID) wp_die(__('You are not allowed to do this.', 'perception')); } if(!empty($_POST['del']) and check_admin_referer('perception_certificate')) { $wpdb->query($wpdb->prepare("DELETE FROM ".PERCEPTION_CERTIFICATES." WHERE id=%d", $_GET['id'])); perception_redirect("admin.php?page=perception_certificates&msg=deleted"); } if(!empty($_POST['ok']) and check_admin_referer('perception_certificate')) { $_cert->edit($_POST, $_GET['id']); do_action('perception-certificate-saved', $_GET['id']); perception_redirect("admin.php?page=perception_certificates&msg=edited"); } $certificate = $wpdb->get_row($wpdb->prepare("SELECT * FROM ".PERCEPTION_CERTIFICATES." WHERE id=%d", $_GET['id'])); $expiration_date = $certificate->expiration_date; if(strstr($certificate->expiration_period, ' ')) { $parts = explode(' ', $certificate->expiration_period); $expiration_num = $parts[0]; $expiration_period = $parts[1]; } else $expiration_num = 1; if(@file_exists(get_stylesheet_directory().'/perception/certificate-form.php')) require get_stylesheet_directory().'/perception/certificate-form.php'; else require(PERCEPTION_PATH."/views/certificate-form.php"); break; default: $own_sql = ''; if($multiuser_access == 'own') $own_sql = $wpdb->prepare("WHERE editor_id=%d", $user_ID); $certificates = $wpdb->get_results("SELECT * FROM ".PERCEPTION_CERTIFICATES." $own_sql ORDER BY title"); if(!empty($_GET['msg'])) { switch($_GET['msg']) { case 'added': $msg = __('Certificate added', 'perception'); break; case 'edited': $msg = __('Certificate saved', 'perception'); break; case 'deleted': $msg = __('Certificate deleted', 'perception'); break; } } // using PDF bridge and other common options if(!empty($_POST['save_global_settings']) and check_admin_referer('perception_certificates')) { $no_rtf = empty($_POST['no_rtf']) ? 0 : 1; $use_pdf = empty($_POST['generate_pdf_certificates']) ? 0 : 1; update_option('perception_generate_pdf_certificates', $use_pdf); update_option('perception_certificates_no_rtf', $no_rtf); } if(@file_exists(get_stylesheet_directory().'/perception/certificates.php')) require get_stylesheet_directory().'/perception/certificates.php'; else require(PERCEPTION_PATH."/views/certificates.php"); break; } } // display my achieved certificates static function my_certificates($in_shortcode = false) { global $wpdb, $user_ID; $_cert = new PSPerceptionLMSCertificateModel(); $certificates = $_cert -> student_certificates($user_ID); $student_id = $user_ID; if(@file_exists(get_stylesheet_directory().'/perception/my-certificates.php')) require get_stylesheet_directory().'/perception/my-certificates.php'; else require(PERCEPTION_PATH."/views/my-certificates.php"); } // viewing a specific certificate static function view_certificate() { global $wpdb, $user_ID; if(!current_user_can('perception_manage') and $_GET['student_id']!=$user_ID) wp_die(__('You are not allowed to access this certificate', 'perception')); // select certificate if(empty($_GET['student_id'])) { // just doing preview $certificate = $wpdb->get_row($wpdb->prepare("SELECT * FROM ".PERCEPTION_CERTIFICATES." WHERE id=%d", $_GET['id'])); $output = wpautop(stripslashes($certificate -> content)); } else { // viewing specific student certificate $certificate = $wpdb -> get_row($wpdb->prepare("SELECT tC.*, tS.date as date, tS.id as stid FROM ".PERCEPTION_CERTIFICATES." tC JOIN ".PERCEPTION_STUDENT_CERTIFICATES." tS On tC.id = tS.certificate_id WHERE tS.student_id = %d AND tC.id=%d AND tS.id=%d", $_GET['student_id'], $_GET['id'], $_GET['my_id'])); $output = wpautop(stripslashes($certificate -> content)); // handle certificate expiration if($certificate->has_expiration) { if($certificate->expiration_mode != 'date') { $is_valid = $wpdb->get_var($wpdb->prepare("SELECT id FROM ".PERCEPTION_STUDENT_CERTIFICATES." WHERE id=%d AND date >= '".date('Y-m-d', current_time('timestamp'))."' - INTERVAL ".$certificate->expiration_period, $certificate->stid)); } else { if(current_time('timestamp') > strtotime($certificate->expiration_date)) $is_valid = false; else $is_valid = true; } if(!$is_valid) { // the certificate has expired $expired_message = $certificate->expired_message; if(empty($expired_message)) $expired_message = '
'.__('This certificate has expired.', 'perception').'
'; $output = stripslashes($expired_message); } } // expiration date if any $expiration_date = ''; if(strstr($output, '{{expiration-date}}') and $certificate->has_expiration) { if($certificate->expiration_mode != 'date') { $expiration_date = $wpdb->get_var($wpdb->prepare("SELECT %s + INTERVAL {$certificate->expiration_period}", $certificate->date)); $expiration_date = date_i18n(get_option('date_format'), strtotime($expiration_date)); } else { $expiration_date = date_i18n(get_option('date_format'), strtotime($certificate->expiration_date)); } } $output = str_replace("{{expiration-date}}", $expiration_date, $output); $user_info=get_userdata($_GET['student_id']); $name=(empty($user_info->first_name) or empty($user_info->last_name)) ? $user_info->display_name : $user_info->first_name." ".$user_info->last_name; // if $name is still empty, output username if(empty($name)) $name = $user_info->user_login; $output = str_replace("{{name}}", $name, $output); $output = str_replace("{{id}}", sprintf('%08d', $certificate->stid), $output); if(strstr($output, "{{courses}}") or strstr($output, "{{courses-extended}}")) { $_course = new PSPerceptionLMSCourseModel(); $courses = $_course->select(); $c_courses = array(); foreach($courses as $course) { if(strstr($certificate -> course_ids, "|".$course->ID."|")) { if(strstr($output, "{{courses-extended}}")) { $c_courses[] = "".$text."
"; $output .= "";
foreach($my_certificates as $certificate) $output .= 'id."&student_id=".$student_id."&noheader=1&my_id=".$certificate->my_id).'" target="_blank">'.stripslashes($certificate->title).'
';
$output .= "