__('Verify Certificate', 'academic-certificate-verification'), 'post_name' => $page_slug, 'post_content' => '[acceve_certificate_display]', 'post_status' => 'publish', 'post_type' => 'page', 'post_author' => get_current_user_id(), 'comment_status' => 'closed', 'ping_status' => 'closed', 'meta_input' => array( '_wp_page_template' => 'default' ) ); // Insert the page $page_id = wp_insert_post($page_data); // Store page ID in options for future reference if (!is_wp_error($page_id)) { update_option('acceve_certificate_verification_page_id', $page_id); } } else { // Update existing page with shortcode if needed if (false === strpos($page->post_content, '[acceve_certificate_display]')) { $page_data = array( 'ID' => $page->ID, 'post_content' => $page->post_content . "\n[acceve_certificate_display]" ); wp_update_post($page_data); } // Store page ID in options update_option('acceve_certificate_verification_page_id', $page->ID); } } /** * Add admin menu pages. * * Creates the main menu and submenu items in WordPress admin. * * @since 1.0.0 * * @return void */ public function add_admin_menu() { add_menu_page( __('Certificate Verification', 'academic-certificate-verification'), __('Certificates', 'academic-certificate-verification'), 'manage_options', 'certificate_verification', array($this, 'admin_dashboard'), 'dashicons-awards', 30 ); add_submenu_page( 'certificate_verification', __('All Certificates', 'academic-certificate-verification'), __('All Certificates', 'academic-certificate-verification'), 'manage_options', 'certificate_verification', array($this, 'admin_dashboard') ); add_submenu_page( 'certificate_verification', __('Add New Certificate', 'academic-certificate-verification'), __('Add New', 'academic-certificate-verification'), 'manage_options', 'certificate_verification_add', array($this, 'add_certificate_page') ); add_submenu_page( 'certificate_verification', __('Import Certificates', 'academic-certificate-verification'), __('Import', 'academic-certificate-verification'), 'manage_options', 'certificate_verification_import', array($this, 'import_certificates_page') ); add_submenu_page( 'certificate_verification', __('Settings', 'academic-certificate-verification'), __('Settings', 'academic-certificate-verification'), 'manage_options', 'certificate_verification_settings', array($this, 'settings_page') ); add_submenu_page( 'certificate_verification', __('Upgrade Pro', 'academic-certificate-verification'), __('Upgrade Pro', 'academic-certificate-verification'), 'manage_options', 'certificate_verification_pro', array($this, 'upgrade_pro_page') ); } /** * Register plugin settings. * * Registers settings, sections, and fields for the plugin. * * @since 1.0.0 * * @return void */ public function register_settings() { register_setting( 'certificate_verification_settings', 'acceve_certificate_verification_options', array( 'type' => 'array', 'sanitize_callback' => array($this, 'acceve_sanitize_settings'), 'default' => array( 'default_institution' => '', 'certificate_prefix' => 'CERT-', 'certificate_template' => 'template_one' ) ) ); add_settings_section( 'general_settings', __('General Settings', 'academic-certificate-verification'), array($this, 'general_settings_section_callback'), 'certificate_verification_settings' ); add_settings_field( 'default_institution', __('Default Institution', 'academic-certificate-verification'), array($this, 'default_institution_callback'), 'certificate_verification_settings', 'general_settings' ); add_settings_field( 'certificate_prefix', __('Certificate ID Prefix', 'academic-certificate-verification'), array($this, 'certificate_prefix_callback'), 'certificate_verification_settings', 'general_settings' ); add_settings_field( 'certificate_template', __('Certificate Template', 'academic-certificate-verification'), array($this, 'certificate_template_callback'), 'certificate_verification_settings', 'general_settings' ); } /** * General settings section callback. * * Displays description for the general settings section. * * @since 1.0.0 * * @return void */ public function general_settings_section_callback() { echo '

' . esc_html__('Configure general settings for the certificate verification system.', 'academic-certificate-verification') . '

'; } /** * Default institution field callback. * * Renders the default institution input field. * * @since 1.0.0 * * @return void */ public function default_institution_callback() { $options = get_option('acceve_certificate_verification_options'); echo ''; } /** * Certificate prefix field callback. * * Renders the certificate ID prefix input field. * * @since 1.0.0 * * @return void */ public function certificate_prefix_callback() { $options = get_option('acceve_certificate_verification_options'); echo ''; echo '

' . esc_html__('This will be prepended to all certificate IDs.', 'academic-certificate-verification') . '

'; } /** * Certificate template field callback. * * Renders the certificate template selection dropdown. * * @since 1.0.0 * * @return void */ public function certificate_template_callback() { $options = get_option('acceve_certificate_verification_options'); $template = isset($options['certificate_template']) ? $options['certificate_template'] : 'template_one'; ?>

prepare_items(); $total_certificates = $this->get_certificate_count(); $active_certificates = $this->get_certificate_count('active'); $expired_certificates = $this->get_certificate_count('expired'); include ACCEVE_PATH . 'templates/admin/dashboard.php'; } /** * Get certificate count by status. * * Retrieves the count of certificates based on status. * * @since 1.0.0 * * @global wpdb $wpdb WordPress database abstraction object. * * @param string $status The status to filter by: 'all', 'active', or 'expired'. * * @return int Number of certificates. */ private function get_certificate_count($status = 'all') { global $wpdb; $table_name = $wpdb->prefix . 'acceve_certificate_verification'; $query = "SELECT COUNT(*) FROM $table_name"; switch ($status) { case 'active': $query .= " WHERE is_active = 1 AND (expiry_date IS NULL OR expiry_date >= CURDATE())"; break; case 'expired': $query .= " WHERE (expiry_date IS NOT NULL AND expiry_date < CURDATE()) OR is_active = 0"; break; } // phpcs:ignore return $wpdb->get_var($query); } /** * Add/Edit certificate page. * * Displays the form for adding or editing a certificate. * * @since 1.0.0 * * @return void */ public function add_certificate_page() { $certificate = null; // Check if this is an edit request if (isset($_GET['action']) && $_GET['action'] === 'edit' && isset($_GET['certificate_id'])) { $db = ACCEVE_Certificate_Verification_Database::get_instance(); // phpcs:ignore $certificate = $db->get_certificate(sanitize_text_field(wp_unslash($_GET['certificate_id']))); if (!$certificate) { wp_die(esc_html__('Certificate not found.', 'academic-certificate-verification')); } } // phpcs:ignore if ($_SERVER['REQUEST_METHOD'] === 'POST' && check_admin_referer('add_certificate')) { $this->process_add_certificate(); } include ACCEVE_PATH . 'templates/admin/add-certificate.php'; } /** * Process add/edit certificate form submission. * * Handles the submission of the certificate form for both * adding new certificates and editing existing ones. * * @since 1.0.0 * * @return void */ public function process_add_certificate() { // Verify nonce if (!isset($_POST['_wpnonce']) || !wp_verify_nonce(sanitize_text_field(wp_unslash($_POST['_wpnonce'])), 'add_certificate')) { wp_die(esc_html__('Security check failed.', 'academic-certificate-verification')); } // Check user capabilities if (!current_user_can('manage_options')) { wp_die(esc_html__('You do not have sufficient permissions to access this page.', 'academic-certificate-verification')); } // Prepare certificate data $data = array( 'certificate_id' => isset($_POST['certificate_id']) ? sanitize_text_field(wp_unslash($_POST['certificate_id'])) : '', 'student_name' => isset($_POST['student_name']) ? sanitize_text_field(wp_unslash($_POST['student_name'])) : '', 'course_type' => isset($_POST['course_type']) ? sanitize_text_field(wp_unslash($_POST['course_type'])) : '', 'course_name' => isset($_POST['course_name']) ? sanitize_text_field(wp_unslash($_POST['course_name'])) : '', 'institution' => isset($_POST['institution']) ? sanitize_text_field(wp_unslash($_POST['institution'])) : '', 'issue_date' => isset($_POST['issue_date']) ? sanitize_text_field(wp_unslash($_POST['issue_date'])) : '', 'is_active' => 1 ); // Handle optional fields if (!empty($_POST['expiry_date'])) { $data['expiry_date'] = sanitize_text_field(wp_unslash($_POST['expiry_date'])); } else { $data['expiry_date'] = null; } if (!empty($_POST['additional_data'])) { $data['additional_data'] = sanitize_text_field(wp_unslash($_POST['additional_data'])); } $db = ACCEVE_Certificate_Verification_Database::get_instance(); // Check if this is an update if (!empty($_POST['original_certificate_id'])) { $original_id = sanitize_text_field(wp_unslash($_POST['original_certificate_id'])); $result = $db->update_certificate($original_id, $data); } else { // New certificate $options = get_option('acceve_certificate_verification_options'); $data['verification_code'] = wp_generate_password(8, false); $result = $db->add_certificate($data); } // Handle result if ($result) { wp_safe_redirect(admin_url('admin.php?page=certificate_verification&updated=1')); exit; } else { $error = __('Error saving certificate.', 'academic-certificate-verification'); if (!empty($_POST['original_certificate_id'])) { // phpcs:ignore wp_safe_redirect(admin_url('admin.php?page=certificate_verification_add&action=edit&certificate_id=' . urlencode($_POST['original_certificate_id']) . '&error=' . urlencode($error))); } else { wp_safe_redirect(admin_url('admin.php?page=certificate_verification_add&error=' . urlencode($error))); } exit; } } /** * Import certificates page. * * Displays the import certificates interface. * * @since 1.0.0 * * @return void */ public function import_certificates_page() { include ACCEVE_PATH . 'templates/admin/import-certificates.php'; } /** * Handle certificate actions. * * Processes certificate actions like delete from URL parameters. * * @since 1.0.0 * * @return void */ public function handle_certificate_actions() { // phpcs:ignore if (isset($_GET['action']) && $_GET['action'] === 'delete' && isset($_GET['certificate_id'])) { $this->delete_certificate(); } } /** * Delete a single certificate. * * Handles deletion of individual certificates with security checks. * * @since 1.0.0 * * @return void */ private function delete_certificate() { if (!isset($_GET['certificate_id']) || !isset($_GET['_wpnonce'])) { wp_die(esc_html__('Invalid request.', 'academic-certificate-verification')); } $certificate_id = sanitize_text_field(wp_unslash($_GET['certificate_id'])); $nonce = sanitize_text_field(wp_unslash($_GET['_wpnonce'])); // Verify nonce if (!wp_verify_nonce($nonce, 'delete_certificate_' . $certificate_id)) { wp_die(esc_html__('Security check failed.', 'academic-certificate-verification')); } $db = ACCEVE_Certificate_Verification_Database::get_instance(); $result = $db->delete_certificate($certificate_id); if ($result) { wp_safe_redirect(admin_url('admin.php?page=certificate_verification&deleted=1')); exit; } else { wp_safe_redirect(admin_url('admin.php?page=certificate_verification&deleted=0')); exit; } } /** * Settings page. * * Displays the plugin settings page. * * @since 1.0.0 * * @return void */ public function settings_page() { include ACCEVE_PATH . 'templates/admin/settings.php'; } /** * Upgrade Pro page. * * Displays the Pro version upgrade page with features and contact information. * * @since 1.0.0 * * @return void */ public function upgrade_pro_page() { // Security check if (!current_user_can('manage_options')) { wp_die(esc_html__('You do not have sufficient permissions.', 'academic-certificate-verification')); } ?>

prefix . 'acceve_certificate_verification'; // phpcs:ignore $certificate_ids = isset($_POST['certificate_ids']) ? array_map('sanitize_text_field', $_POST['certificate_ids']) : array(); // Build query if (!empty($certificate_ids)) { $placeholders = array_fill(0, count($certificate_ids), '%s'); $format = implode(', ', $placeholders); // phpcs:ignore $query = $wpdb->prepare("SELECT * FROM {$table_name} WHERE certificate_id IN ($format)",$certificate_ids); } else { // Export all if none selected $query = "SELECT * FROM {$table_name}"; } // phpcs:ignore $results = $wpdb->get_results($query, ARRAY_A); if (empty($results)) { wp_die('No certificates found'); } // Set headers for CSV download header('Content-Type: text/csv; charset=utf-8'); header('Content-Disposition: attachment; filename=certificates_' . gmdate('Y-m-d_H-i-s') . '.csv'); // Create output stream $output = fopen('php://output', 'w'); // phpcs:ignore fputs($output, $bom = (chr(0xEF) . chr(0xBB) . chr(0xBF))); // Add headers $headers = array( 'Certificate ID', 'Student Name', 'Course Type', 'Course Name', 'Institution', 'Issue Date', 'Expiry Date', 'Verification Code', 'Status', 'Created At' ); fputcsv($output, $headers); // Add data rows foreach ($results as $row) { $status = 'Active'; if (!$row['is_active']) { $status = 'Inactive'; } elseif ($row['expiry_date'] && strtotime($row['expiry_date']) < time()) { $status = 'Expired'; } $data = array( $row['certificate_id'], $row['student_name'], $row['course_type'], $row['course_name'], $row['institution'], $row['issue_date'], $row['expiry_date'], $row['verification_code'], $status, $row['created_at'] ); fputcsv($output, $data); } // phpcs:ignore fclose($output); exit; } /** * Handle bulk delete. * * Processes AJAX request for bulk deletion of certificates. * * @since 1.0.0 * * @global wpdb $wpdb WordPress database abstraction object. * * @return void Sends JSON response with success or error. */ public function handle_bulk_delete() { // Verify nonce check_ajax_referer('certificate_verification_nonce_admin', 'security'); // Check permissions if (!current_user_can('manage_options')) { wp_send_json_error('Unauthorized'); } // phpcs:ignore $certificate_ids = isset($_POST['certificate_ids']) ? array_map('sanitize_text_field', $_POST['certificate_ids']) : array(); if (empty($certificate_ids)) { wp_send_json_error('No certificates selected'); } global $wpdb; $table_name = $wpdb->prefix . 'acceve_certificate_verification'; $deleted = 0; foreach ($certificate_ids as $certificate_id) { // phpcs:ignore $result = $wpdb->delete( $table_name, array('certificate_id' => $certificate_id), array('%s') ); if ($result !== false) { $deleted++; } } if ($deleted > 0) { wp_send_json_success(array( /* translators: %d: Number of certificates deleted */ 'message' => sprintf(__('%d certificate(s) deleted successfully', 'academic-certificate-verification'), $deleted) )); } else { wp_send_json_error('Failed to delete certificates'); } } /** * Load admin assets. * * Enqueues CSS and JavaScript files for admin pages. * * @since 1.0.0 * * @param string $hook The current admin page hook. * * @return void */ public function load_admin_assets($hook){ if (strpos($hook, 'certificate_verification') === false) { return; } $options = get_option('acceve_certificate_verification_options'); wp_enqueue_style( 'cert-verification-admin', ACCEVE_URL . 'assets/css/admin.css', array(), ACCEVE_VERSION ); wp_enqueue_script( 'cert-verification-admin', ACCEVE_URL . 'assets/js/admin.js', array('jquery'), ACCEVE_VERSION, true ); wp_localize_script( 'cert-verification-admin', 'acceve_certificate_verification_admin', array( 'nonce' => wp_create_nonce( 'certificate_verification_nonce_admin' ), 'ajax_url' => admin_url( 'admin-ajax.php' ), 'certificate_prefix' => $options['certificate_prefix'] ?? 'CERT-', ) ); } }