isset( $_GET['form_id'] ) ? sanitize_text_field( $_GET['form_id'] ) : '', 'status' => isset( $_GET['status'] ) ? sanitize_text_field( $_GET['status'] ) : '', 'priority' => isset( $_GET['priority'] ) ? sanitize_text_field( $_GET['priority'] ) : '', 'start_date' => isset( $_GET['start_date'] ) ? sanitize_text_field( $_GET['start_date'] ) : '', 'end_date' => isset( $_GET['end_date'] ) ? sanitize_text_field( $_GET['end_date'] ) : '', 'search' => isset( $_GET['search'] ) ? sanitize_text_field( $_GET['search'] ) : '', 'limit' => -1, // Export all records matching filter 'offset' => 0, ); // Handle explicit selection if ( ! empty( $_GET['lead_ids'] ) ) { $lead_ids = array_filter( array_map( 'intval', explode( ',', sanitize_text_field( wp_unslash( $_GET['lead_ids'] ) ) ) ) ); if ( empty( $lead_ids ) ) { wp_die( esc_html__( 'Invalid lead selection.', 'ahmadraza360-lead-manager' ) ); } global $wpdb; $table_sub = Ahmadraza360_LM_Database::table( 'submissions' ); $placeholders = implode( ', ', array_fill( 0, count( $lead_ids ), '%d' ) ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared $submissions = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM $table_sub WHERE id IN ($placeholders) ORDER BY created_at DESC", $lead_ids ) ); } else { $submissions = Ahmadraza360_LM_Database::get_submissions( $args ); } if ( empty( $submissions ) ) { wp_die( esc_html__( 'No submissions found to export.', 'ahmadraza360-lead-manager' ) ); } // Compile full detailed objects including dynamic EAV fields $leads = array(); $dynamic_keys = array(); foreach ( $submissions as $sub ) { $lead = Ahmadraza360_LM_Database::get_lead( $sub->id ); if ( $lead ) { $leads[] = $lead; // Track unique keys for header construction if ( ! empty( $lead->fields ) && is_array( $lead->fields ) ) { foreach ( array_keys( $lead->fields ) as $field_key ) { // Do not add internal mapping keys in dynamic columns if ( strpos( $field_key, '_lead_' ) !== 0 ) { $dynamic_keys[ $field_key ] = true; } } } } } $field_headers = array_keys( $dynamic_keys ); $format = isset( $_GET['format'] ) ? sanitize_key( $_GET['format'] ) : 'csv'; if ( 'json' === $format ) { self::export_as_json( $leads ); } else { self::export_as_csv( $leads, $field_headers ); } } /** * Stream data down as standard JSON format. * * @param array $leads Structured lead lists. */ private static function export_as_json( $leads ) { $filename = 'ahmadraza360-leads-export-' . gmdate( 'Y-m-d-His' ) . '.json'; header( 'Content-Type: application/json; charset=utf-8' ); header( 'Content-Disposition: attachment; filename=' . $filename ); header( 'Pragma: no-cache' ); header( 'Expires: 0' ); echo wp_json_encode( $leads ); exit; } /** * Stream data down as BOM-escaped CSV format. * * @param array $leads List of leads. * @param array $field_headers Extracted dynamic field names. */ private static function export_as_csv( $leads, $field_headers ) { $filename = 'ahmadraza360-leads-export-' . gmdate( 'Y-m-d-His' ) . '.csv'; header( 'Content-Type: text/csv; charset=utf-8' ); header( 'Content-Disposition: attachment; filename=' . $filename ); header( 'Pragma: no-cache' ); header( 'Expires: 0' ); // Output UTF-8 BOM to resolve Excel encoding issues with international characters echo "\xEF\xBB\xBF"; $output = fopen( 'php://output', 'w' ); // Assemble Headers Row $headers = array( __( 'Lead ID', 'ahmadraza360-lead-manager' ), __( 'Form Title', 'ahmadraza360-lead-manager' ), __( 'Status', 'ahmadraza360-lead-manager' ), __( 'Priority', 'ahmadraza360-lead-manager' ), __( 'Assigned User', 'ahmadraza360-lead-manager' ), __( 'IP Address', 'ahmadraza360-lead-manager' ), __( 'User Agent', 'ahmadraza360-lead-manager' ), __( 'Source Page URL', 'ahmadraza360-lead-manager' ), __( 'Referrer', 'ahmadraza360-lead-manager' ), __( 'Submission Date', 'ahmadraza360-lead-manager' ), ); // Append mapped contact columns $headers[] = __( 'Lead Name', 'ahmadraza360-lead-manager' ); $headers[] = __( 'Lead Email', 'ahmadraza360-lead-manager' ); $headers[] = __( 'Lead Phone', 'ahmadraza360-lead-manager' ); $headers[] = __( 'Lead Subject', 'ahmadraza360-lead-manager' ); $headers[] = __( 'Lead Message', 'ahmadraza360-lead-manager' ); // Append dynamic form fields headers foreach ( $field_headers as $fh ) { $headers[] = $fh; } fputcsv( $output, $headers ); // Write values foreach ( $leads as $lead ) { // Resolve assigned user display name $assigned = 'Unassigned'; if ( ! empty( $lead->assigned_to ) ) { $userdata = get_userdata( $lead->assigned_to ); if ( $userdata ) { $assigned = $userdata->display_name; } } $row = array( $lead->id, $lead->form_title, ucfirst( $lead->status ), ucfirst( $lead->priority ), $assigned, $lead->ip_address, $lead->user_agent, $lead->page_url, $lead->referrer, $lead->created_at, // Mapped columns isset( $lead->fields['_lead_name'] ) ? $lead->fields['_lead_name'] : '', isset( $lead->fields['_lead_email'] ) ? $lead->fields['_lead_email'] : '', isset( $lead->fields['_lead_phone'] ) ? $lead->fields['_lead_phone'] : '', isset( $lead->fields['_lead_subject'] ) ? $lead->fields['_lead_subject'] : '', isset( $lead->fields['_lead_message'] ) ? $lead->fields['_lead_message'] : '', ); // Append dynamic values matching headers foreach ( $field_headers as $fh ) { $row[] = isset( $lead->fields[ $fh ] ) ? $lead->fields[ $fh ] : ''; } fputcsv( $output, $row ); } fclose( $output ); exit; } }