prefix . 'cookieadmin_dpdp_requests'; $current_tab = !empty($_GET['tab']) ? sanitize_text_field(wp_unslash($_GET['tab'])) : 'requests'; if(!empty($_POST['cookieadmin_dpdp_save_settings'])){ check_admin_referer('cookieadmin_dpdp_settings', 'cookieadmin_pro_security'); $dpdp_settings = !empty($_POST['cookieadmin_dpdp']) ? map_deep(wp_unslash($_POST['cookieadmin_dpdp']), 'sanitize_text_field') : []; if(!empty($dpdp_settings['request_types']) && is_array($dpdp_settings['request_types'])){ $all_types = array('access', 'correction', 'erasure', 'withdraw_consent', 'grievance', 'nomination'); $selected = array_intersect($dpdp_settings['request_types'], $all_types); $dpdp_settings['request_types'] = array(); foreach($all_types as $at){ $dpdp_settings['request_types'][$at] = in_array($at, $selected, true) ? 1 : 0; } }else{ $dpdp_settings['request_types'] = array(); } if(!empty($settings['custom_page'])){ $dpdp_settings['custom_page'] = $settings['custom_page']; } $dpdp_settings['exp_content'] = !empty($_POST['cookieadmin_dpdp_exp_content']) ? wp_kses_post(wp_unslash($_POST['cookieadmin_dpdp_exp_content'])) : ''; $dpdp_settings['selected_page'] = !empty($_POST['cookieadmin_dpdp_form_page']) ? (int) sanitize_text_field(wp_unslash($_POST['cookieadmin_dpdp_form_page'])) : 0; $dpdp_settings['response_timeline'] = !empty($dpdp_settings['response_timeline']) ? max(1, min(90, (int) $dpdp_settings['response_timeline'])) : 30; $dpdp_settings['grievance_officer_email'] = !empty($dpdp_settings['grievance_officer_email']) ? sanitize_email($dpdp_settings['grievance_officer_email']) : ''; if(!empty($dpdp_settings['enabled'])){ if(empty($dpdp_settings['grievance_officer_name']) || empty($dpdp_settings['grievance_officer_email'])){ $cookieadmin_error = __('Please provide the Grievance Officer name and a valid email to enable the DPDP portal', 'cookieadmin'); $dpdp_settings['enabled'] = 0; } if(!\CookieAdminPro\Admin::cookieadmin_pro_table_exists($table_name)){ self::create_dpdp_table($table_name); } } if(($dpdp_settings['selected_page'] > 0) && ($dpdp_settings['selected_page'] !== (int) $settings['selected_page'])){ $selected_page = get_post($dpdp_settings['selected_page']); if(!empty($selected_page) && !empty($selected_page->ID)){ if(strpos($selected_page->post_content, '[cookieadmin_dpdp_request]') === false){ $result = wp_update_post(array( 'ID' => $selected_page->ID, 'post_content' => $selected_page->post_content . '[cookieadmin_dpdp_request]' )); if($result instanceof WP_Error){ $cookieadmin_error = __('Error updating the shorcode on selected page', 'cookieadmin'); } } } } $prev_shortcode_page = !empty($settings['selected_page']) ? get_post((int) $settings['selected_page']) : 0; if(!empty($prev_shortcode_page) && ($dpdp_settings['selected_page'] !== (int) $settings['selected_page'])){ if(!empty($prev_shortcode_page->post_content) && (strpos($prev_shortcode_page->post_content, '[cookieadmin_dpdp_request]') !== false)){ $result = wp_update_post(array( 'ID' => $prev_shortcode_page->ID, 'post_content' => str_replace('[cookieadmin_dpdp_request]', '', $prev_shortcode_page->post_content) )); if($result instanceof WP_Error){ $cookieadmin_error = __('Error updating the shorcode on selected page', 'cookieadmin'); } } } if(empty($cookieadmin_error)){ update_option('cookieadmin_dpdp_settings', $dpdp_settings); $cookieadmin_msg = __('Settings saved successfully', 'cookieadmin'); } } if(!empty($_POST['cookieadmin_dpdp_bulk_action']) && !empty($_POST['cookieadmin_dpdp_ids'])){ check_admin_referer('cookieadmin_pro_admin_nonce', 'cookieadmin_pro_security'); $ids = map_deep(wp_unslash($_POST['cookieadmin_dpdp_ids']), 'intval'); if($_POST['cookieadmin_dpdp_bulk_action'] === 'resolved'){ foreach($ids as $id){ $wpdb->update( $table_name, array('status' => 'Resolved', 'responded_at' => time()), array('id' => $id), array('%s', '%d'), array('%d') ); } $cookieadmin_msg = __('Requests marked as resolved', 'cookieadmin'); } } \CookieAdmin\Admin::header_theme(__('DPDP Data Principal Requests', 'cookieadmin')); echo '
'; $active_requests = ($current_tab === 'requests') ? ' nav-tab-active' : ''; $active_settings = ($current_tab === 'settings') ? ' nav-tab-active' : ''; echo ' '.esc_html__('Requests', 'cookieadmin').' '.esc_html__('Settings', 'cookieadmin').'
'; if($current_tab === 'settings'){ self::render_settings_tab(); }else{ self::render_requests_tab($table_name); } \CookieAdmin\Admin::footer_theme(); } static function create_dpdp_table($dpdp_table){ global $wpdb; $charset_collate = $wpdb->get_charset_collate(); $db_path = !defined('SITEPAD') ? ABSPATH . 'wp-admin/includes/upgrade.php' : ABSPATH . 'site-admin/includes/upgrade.php'; require_once($db_path); $sql = 'CREATE TABLE ' . $dpdp_table . ' ( id INT NOT NULL AUTO_INCREMENT, request_id VARCHAR(64) NOT NULL, user_email VARCHAR(100) NOT NULL, first_name VARCHAR(100) DEFAULT NULL, last_name VARCHAR(100) DEFAULT NULL, request_type VARCHAR(50) NOT NULL, request_details TEXT DEFAULT NULL, status VARCHAR(20) NOT NULL DEFAULT \'Received\', created_at BIGINT NOT NULL, responded_at BIGINT DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY request_id (request_id) ) ' . $charset_collate . ';'; dbDelta($sql); } static function generate_dpdp_page(){ $settings = get_option('cookieadmin_dpdp_settings', []); check_ajax_referer('cookieadmin_pro_admin_js_nonce', 'cookieadmin_pro_security'); if(!current_user_can('administrator')){ wp_send_json_error(__('Invalid user', 'cookieadmin')); } if(!empty($settings['custom_page'])){ $custom_page = get_post((int) $settings['custom_page']); if(!empty($custom_page && $custom_page->ID)){ wp_send_json_error(__('Page already generated', 'cookieadmin')); } } $page_content = '[cookieadmin_dpdp_request]'; $page_title = __('Data Principal Request (DPDP)', 'cookieadmin'); $post_args = array( 'post_type' => 'page', 'post_title' => $page_title, 'post_content' => $page_content, 'post_status' => 'publish', ); $page_id = wp_insert_post($post_args, true); if(!($page_id instanceof WP_Error)){ $permalink = get_permalink($page_id); if(!empty($permalink)){ $settings['selected_page'] = $page_id; $settings['custom_page'] = $page_id; $settings['enabled'] = '1'; update_option('cookieadmin_dpdp_settings', $settings); wp_send_json_success(); } } wp_send_json_error(__('Something went wrong', 'cookieadmin')); } static function export_dpdp_requests(){ global $wpdb; $cookieadmin_export_type = !empty($_REQUEST['cookieadmin_export_type']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_export_type'])) : ''; if(!empty($cookieadmin_export_type) && $cookieadmin_export_type == 'dpdp_requests'){ $table_name = esc_sql($wpdb->prefix . 'cookieadmin_dpdp_requests'); if(!\CookieAdminPro\Admin::cookieadmin_pro_table_exists($table_name)){ echo -1; echo esc_html__('Configure DPDP settings', 'cookieadmin'); wp_die(); } $requests = $wpdb->get_results("SELECT request_id, user_email, first_name, last_name, request_type, request_details, status, created_at, responded_at FROM $table_name ORDER BY id DESC", ARRAY_A); if(!empty($requests)){ foreach($requests as $rk => $request){ $requests[$rk]['created_at'] = !empty($request['created_at']) ? wp_date('Y-m-d H:i:s', $request['created_at']) : ''; $requests[$rk]['responded_at'] = !empty($request['responded_at']) ? wp_date('Y-m-d H:i:s', $request['responded_at']) : ''; } } } if(empty($requests)){ echo -1; echo esc_html__('No data to export', 'cookieadmin'); wp_die(); } header('Content-Type: text/csv; charset=utf-8'); header('Content-Disposition: attachment; filename=cookieadmin-dpdp-requests.csv'); $output = fopen('php://output', 'w'); fputcsv($output, array('Request ID', 'Email', 'First Name', 'Last Name', 'Request Type', 'Details', 'Status', 'Received', 'Responded')); foreach($requests as $request){ fputcsv($output, $request); } fclose($output); wp_die(); } static function get_dpdp_requests(){ global $wpdb; $table_name = $wpdb->prefix . 'cookieadmin_dpdp_requests'; if (!\CookieAdminPro\Admin::cookieadmin_pro_table_exists($table_name)) { return array(); } $dpdp_requests = $wpdb->get_results("SELECT * FROM {$table_name} ORDER BY id DESC", ARRAY_A); if (!empty($dpdp_requests) && is_array($dpdp_requests)){ return $dpdp_requests; } return array(); } static function render_requests_tab($table_name){ global $cookieadmin_msg; $dpdp_requests = self::get_dpdp_requests(); $request_types = \CookieAdminPro\DPDP::get_request_types(); echo '
'; wp_nonce_field('cookieadmin_pro_admin_nonce', 'cookieadmin_pro_security'); echo '
'; if(empty($dpdp_requests)){ echo ''; }else{ foreach($dpdp_requests as $req){ $status_class = (strtolower($req['status']) === 'resolved') ? 'success' : 'warning'; echo ''; } } echo '
'.esc_html__('Request ID', 'cookieadmin').' '.esc_html__('Email', 'cookieadmin').' '.esc_html__('Name', 'cookieadmin').' '.esc_html__('Request Type', 'cookieadmin').' '.esc_html__('Status', 'cookieadmin').' '.esc_html__('Received', 'cookieadmin').'
'.esc_html__('No requests found', 'cookieadmin').'
'.esc_html($req['request_id']).' '.esc_html($req['user_email']).' '.esc_html($req['first_name'].' '.$req['last_name']).' '.esc_html($request_types[$req['request_type']]).' '.esc_html(ucfirst($req['status'])).'' .((!empty($req['responded_at']) && (strtolower($req['status']) === 'resolved')) ? '
'.sprintf(esc_html__('%s ago', 'cookieadmin'), human_time_diff($req['responded_at'])).'' : '').' 		'.esc_html(date('j M Y H:i:s', $req['created_at'])).'
'; } static function render_settings_tab(){ global $cookieadmin; $settings = \CookieAdminPro\DPDP::get_settings(); if(empty($settings['exp_content'])){ $settings['exp_content'] = __('Under the Digital Personal Data Protection Act, 2023 (India), you have the right to access, correct or erase your personal data, withdraw your consent, nominate a representative to exercise your rights, and raise a grievance with our Grievance Officer. Submit the form below and we will respond within our published timeline.', 'cookieadmin'); } $published_pages = get_pages(); $custom_page = !empty($settings['custom_page']) ? get_post((int) $settings['custom_page']) : ''; $preview_page_url = !empty($settings['selected_page']) ? get_permalink((int) $settings['selected_page']) : ''; $request_types = \CookieAdminPro\DPDP::get_request_types(); echo '
'.esc_html__('DPDP Portal Settings', 'cookieadmin').'
'; foreach($request_types as $tk => $tl){ echo ''; } echo '
'.(empty($settings['custom_page']) || empty($custom_page) ? ''.esc_html__('OR', 'cookieadmin').' ' : '').'   '.esc_html__('Preview DPDP request form', 'cookieadmin').' '.sprintf( esc_html__('The shortcode %s must be present on the selected page in order to display the Data Principal request form correctly.', 'cookieadmin'), '[cookieadmin_dpdp_request]' ).'
'; wp_nonce_field('cookieadmin_dpdp_settings', 'cookieadmin_pro_security'); echo '
'; } static function dpdp_policies(){ return [ 'cookieadmin_dpdp' => array ( 'cookieadmin_layout' => 'box', 'cookieadmin_modal' => 'center', 'cookieadmin_position' => 'bottom_left', 'cookieadmin_days' => '365', 'cookieadmin_notice_title' => __('We Value Your Privacy', 'cookieadmin'), 'cookieadmin_notice' => __('Under India\'s Digital Personal Data Protection Act, 2023 (DPDP Act), we seek your consent before processing your personal data. You may accept all, reject all, or customize categories. Consent is voluntary — refusing non-essential cookies will not affect the core functioning of the website. You may withdraw consent or exercise your rights (access, correction, erasure, grievance redressal, nomination) as easily as you gave consent.', 'cookieadmin'), 'cookieadmin_preference_title' => __('Manage Your Consent Preferences', 'cookieadmin'), 'cookieadmin_preference' => __('We use cookies to process your personal data under the DPDP Act, 2023. Necessary cookies are essential for the website to function and are always active. Functional cookies remember your choices and enable enhanced features. Analytics cookies help us understand how visitors use our website. Advertisement cookies deliver personalized ads based on your visits. You have the right to withdraw your consent at any time, as easily as you gave it, and to approach our Grievance Officer with any data protection concern.', 'cookieadmin'), 'reConsent_title' => __('Modify Cookie Preferences', 'cookieadmin'), 'cookieadmin_notice_title_color' => '#1f2937', 'cookieadmin_notice_color' => '#1f2937', 'cookieadmin_consent_inside_bg_color' => '#ffffff', 'cookieadmin_consent_inside_border_color' => '#ffffff', 'cookieadmin_preference_title_color' => '#1f2937', 'cookieadmin_details_wrapper_color' => '#1f2937', 'cookieadmin_cookie_modal_bg_color' => '#ffffff', 'cookieadmin_cookie_modal_border_color' => '#ffffff', 'cookieadmin_customize_btn' => __('Customize', 'cookieadmin'), 'cookieadmin_customize_btn_color' => '#1f2937', 'cookieadmin_customize_btn_bg_color' => '#ffffff', 'cookieadmin_reject_btn' => __('Reject All', 'cookieadmin'), 'cookieadmin_reject_btn_color' => '#1f2937', 'cookieadmin_reject_btn_bg_color' => '#ffffff', 'cookieadmin_accept_btn' => __('Accept All', 'cookieadmin'), 'cookieadmin_accept_btn_color' => '#ffffff', 'cookieadmin_accept_btn_bg_color' => '#1863dc', 'cookieadmin_save_btn' => __('Save Preferences', 'cookieadmin'), 'cookieadmin_save_btn_color' => '#ffffff', 'cookieadmin_save_btn_bg_color' => '#1863dc', 'cookieadmin_slider_off_bg_color' => '#808080', 'cookieadmin_slider_on_bg_color' => '#3582C4', 'cookieadmin_links_color' => '#1863dc', ), ]; } }