self::SLUG ), $args ), admin_url( 'admin.php' ) );
}
public static function menu() {
add_submenu_page( 'woocommerce', 'OrderArc', 'OrderArc', self::CAP, self::SLUG, array( __CLASS__, 'render' ) );
}
public static function assets( $hook ) {
if ( false === strpos( (string) $hook, self::SLUG ) ) {
return;
}
wp_enqueue_style( 'orderarc-admin', plugins_url( 'assets/admin.css', ORDERARC_FILE ), array(), ORDERARC_VERSION );
wp_enqueue_script( 'orderarc-admin', plugins_url( 'assets/admin.js', ORDERARC_FILE ), array(), ORDERARC_VERSION, true );
wp_localize_script(
'orderarc-admin',
'orderarc',
array(
'ajax' => admin_url( 'admin-ajax.php' ),
'nonce' => wp_create_nonce( 'orderarc_ajax' ),
/* translators: %s: seconds */
'took' => __( 'Searching orders took %s s', 'orderarc' ),
/* translators: %s: seconds */
'nofin' => __( 'Search did not finish after %s s', 'orderarc' ),
)
);
}
/* ---------- Enlace en la lista de pedidos y redirección ---------- */
public static function views( $views ) {
if ( ! current_user_can( self::CAP ) ) {
return $views;
}
$n = OrderArc_Engine::archived_count();
if ( $n > 0 ) {
$views['orderarc'] = sprintf(
'%s (%s) ',
esc_url( self::url( array( 'tab' => 'archived' ) ) ),
esc_html__( 'Archived', 'orderarc' ),
esc_html( number_format_i18n( $n ) )
);
}
return $views;
}
/** Un pedido archivado abierto desde un enlace viejo va a su vista de archivado. */
public static function maybe_redirect() {
global $pagenow;
if ( wp_doing_ajax() || ! current_user_can( self::CAP ) ) {
return;
}
$id = 0;
// phpcs:disable WordPress.Security.NonceVerification.Recommended -- solo lectura de la URL para redirigir.
$page = sanitize_key( wp_unslash( $_GET['page'] ?? '' ) );
$action = sanitize_key( wp_unslash( $_GET['action'] ?? '' ) );
if ( 'admin.php' === $pagenow && 'wc-orders' === $page && 'edit' === $action ) {
$id = absint( $_GET['id'] ?? 0 );
if ( $id && function_exists( 'wc_get_order' ) && wc_get_order( $id ) ) {
return;
}
} elseif ( 'post.php' === $pagenow && 'edit' === $action ) {
$id = absint( $_GET['post'] ?? 0 );
$type = $id ? get_post_type( $id ) : false;
if ( $type && OrderArc_Engine::PLACEHOLDER !== $type ) {
return;
}
}
// phpcs:enable
if ( $id && OrderArc_Archived::exists( $id ) ) {
wp_safe_redirect( self::url( array( 'tab' => 'archived', 'order' => $id ) ) );
exit;
}
}
/* ---------- Acciones (formularios) ---------- */
private static function guard( $action ) {
if ( ! current_user_can( self::CAP ) ) {
wp_die( esc_html__( 'Sorry, you are not allowed to do that.', 'orderarc' ), 403 );
}
check_admin_referer( $action );
}
private static function back( $tab, $msg = '', $extra = array() ) {
if ( $msg ) {
set_transient( 'orderarc_msg_' . get_current_user_id(), $msg, 120 );
}
wp_safe_redirect( self::url( array_merge( array( 'tab' => $tab ), $extra ) ) );
exit;
}
private static function ack_from_post() {
// phpcs:ignore WordPress.Security.NonceVerification.Missing -- nonce verificado en guard().
if ( ! empty( $_POST['orderarc_backup'] ) && ! get_option( 'orderarc_backup_ack' ) ) {
update_option( 'orderarc_backup_ack', array( 'user' => get_current_user_id(), 'time' => time() ), false );
}
return (bool) get_option( 'orderarc_backup_ack' );
}
public static function post_save() {
self::guard( 'orderarc_save' );
// phpcs:disable WordPress.Security.NonceVerification.Missing -- nonce verificado en guard().
$s = OrderArc_Runner::settings();
$allowed = array_keys( self::status_choices() );
// La regla básica solo se cambia si vino en el formulario (con la versión Pro esos campos no se muestran).
if ( isset( $_POST['older_than_days'] ) ) {
$statuses = array_values( array_intersect( array_map( 'sanitize_key', (array) wp_unslash( $_POST['statuses'] ?? array() ) ), $allowed ) );
$s['statuses'] = $statuses ? $statuses : OrderArc_Runner::defaults()['statuses'];
$s['older_than_days'] = max( 30, min( 36500, absint( $_POST['older_than_days'] ) ) );
}
$s['window_start'] = min( 23, absint( $_POST['window_start'] ?? 1 ) );
$s['window_end'] = min( 23, absint( $_POST['window_end'] ?? 6 ) );
$s['catch_up'] = 'wait' === sanitize_key( wp_unslash( $_POST['catch_up'] ?? '' ) ) ? 'wait' : 'gentle';
$s['auto'] = ! empty( $_POST['auto'] ) && self::ack_from_post();
// phpcs:enable
$s = (array) apply_filters( 'orderarc_save_settings', $s );
update_option( 'orderarc_settings', $s, false );
do_action( 'orderarc_settings_saved', $s );
OrderArc_Engine::flush_counts();
OrderArc_Runner::schedule_daily();
self::back( 'archive', __( 'Settings saved.', 'orderarc' ) );
}
public static function post_preview() {
self::guard( 'orderarc_preview' );
$s = OrderArc_Runner::settings();
$prev = OrderArc_Engine::preview( $s );
// Se guarda con la huella de las reglas: si cambian (ajustes, licencia Pro), la vista previa vieja no se muestra.
$prev['rules_key'] = md5( wp_json_encode( OrderArc_Engine::rules( $s ) ) );
set_transient( 'orderarc_preview_' . get_current_user_id(), $prev, 600 );
self::back( 'archive' );
}
public static function post_start() {
self::guard( 'orderarc_start' );
if ( ! self::ack_from_post() ) {
self::back( 'archive' );
}
OrderArc_Runner::start( 'archive', true );
self::back( 'archive' );
}
public static function post_pause() {
self::guard( 'orderarc_pause' );
OrderArc_Runner::pause();
self::back( 'archive' );
}
public static function post_resume() {
self::guard( 'orderarc_resume' );
OrderArc_Runner::resume();
self::back( 'archive' );
}
public static function post_restore_all() {
self::guard( 'orderarc_restore_all' );
$s = OrderArc_Runner::settings();
if ( $s['auto'] ) { // si no, la noche siguiente vuelve a archivar lo restaurado.
$s['auto'] = false;
update_option( 'orderarc_settings', $s, false );
}
OrderArc_Runner::start( 'restore', true );
self::back( 'archive' );
}
/** Restaurar uno o varios pedidos desde la pestaña de archivados. */
public static function post_restore() {
self::guard( 'orderarc_restore' );
$ids = array_slice( array_filter( array_map( 'absint', (array) wp_unslash( $_POST['ids'] ?? array() ) ) ), 0, 200 ); // phpcs:ignore WordPress.Security.NonceVerification.Missing -- nonce verificado en guard().
$msgs = array();
$st = OrderArc_Runner::job()['status'] ?? '';
if ( in_array( $st, array( 'running', 'waiting' ), true ) || ! OrderArc_Runner::lock() ) {
self::back( 'archived', __( 'An archive or restore job is running. Pause it first.', 'orderarc' ) );
}
foreach ( $ids as $id ) {
if ( ! OrderArc_Archived::exists( $id ) ) {
continue; // solo pedidos archivados (no reembolsos sueltos ni IDs inventados).
}
$r = OrderArc_Engine::move( array( $id ), 'restore', true );
if ( $r['ok'] && $r['orders'] ) {
/* translators: %s: order number */
$msgs[] = sprintf( __( 'Order #%s restored.', 'orderarc' ), $id );
} elseif ( ! $r['ok'] ) {
/* translators: 1: first order number, 2: last order number, 3: reason */
$msgs[] = sprintf( __( 'Orders %1$s–%2$s not moved: %3$s. Nothing was changed for these orders.', 'orderarc' ), $id, $id, $r['error'] );
}
}
OrderArc_Runner::unlock();
self::back( 'archived', implode( "\n", $msgs ) );
}
/* ---------- AJAX ---------- */
public static function ajax_status() {
check_ajax_referer( 'orderarc_ajax' );
if ( ! current_user_can( self::CAP ) ) {
wp_send_json_error( null, 403 );
}
$job = OrderArc_Runner::job();
wp_send_json_success( array( 'status' => $job['status'] ?? '', 'html' => self::status_html( $job ) ) );
}
/** Mide una búsqueda real de WooCommerce (la misma que hace el buscador de pedidos). */
public static function ajax_measure() {
check_ajax_referer( 'orderarc_ajax' );
if ( ! current_user_can( self::CAP ) ) {
wp_send_json_error( null, 403 );
}
global $wpdb;
$hpos = OrderArc_Engine::storage()['hpos'];
$total = self::live_orders();
$email = $hpos
// phpcs:ignore WordPress.DB.DirectDatabaseQuery -- un email de muestra para la búsqueda de prueba; no hay API.
? $wpdb->get_var( $wpdb->prepare( "SELECT billing_email FROM %i WHERE type='shop_order' AND billing_email<>'' ORDER BY id LIMIT 1 OFFSET %d", OrderArc_Engine::live( 'wc_orders' ), (int) ( $total / 2 ) ) )
: $wpdb->get_var( $wpdb->prepare( "SELECT m.meta_value FROM %i m JOIN %i o ON o.ID=m.post_id AND o.post_type='shop_order' WHERE m.meta_key='_billing_email' AND m.meta_value<>'' ORDER BY m.post_id LIMIT 1 OFFSET %d", OrderArc_Engine::live( 'postmeta' ), OrderArc_Engine::live( 'posts' ), (int) ( $total / 2 ) ) );
if ( ! $email ) {
$email = 'orderarc-test@example.com';
}
$t = microtime( true );
if ( $hpos ) {
wc_get_orders( array( 's' => $email, 'limit' => 20, 'return' => 'ids', 'type' => 'shop_order' ) );
} else {
wc_order_search( $email );
}
$ms = (int) round( ( microtime( true ) - $t ) * 1000 );
update_option( 'orderarc_search', array( 'ms' => $ms, 'time' => time(), 'orders' => $total ), false );
wp_send_json_success( array( 'ms' => $ms ) );
}
/* ---------- Datos ---------- */
public static function live_orders() {
global $wpdb;
return OrderArc_Engine::storage()['hpos']
// phpcs:ignore WordPress.DB.DirectDatabaseQuery -- conteo de pedidos para el resumen; no hay API sin cargar los pedidos.
? (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM %i WHERE type='shop_order'", OrderArc_Engine::live( 'wc_orders' ) ) )
: (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM %i WHERE post_type='shop_order'", OrderArc_Engine::live( 'posts' ) ) );
}
/** Estados que se pueden archivar: todos menos los que siguen en curso. */
public static function status_choices() {
$all = function_exists( 'wc_get_order_statuses' ) ? wc_get_order_statuses() : array();
foreach ( array( 'wc-pending', 'wc-processing', 'wc-on-hold', 'wc-checkout-draft' ) as $k ) {
unset( $all[ $k ] );
}
return $all;
}
private static function storage_label( $st = null ) {
$st = $st ? $st : OrderArc_Engine::storage();
return ( $st['hpos'] ? 'HPOS' : 'Legacy' ) . ( $st['sync'] ? ' + sync' : '' );
}
private static function fmt_date( $gmt ) {
if ( ! $gmt || '0000-00-00 00:00:00' === $gmt ) {
return '';
}
return wp_date( get_option( 'date_format' ), strtotime( $gmt . ' UTC' ) ); // en la zona horaria del sitio.
}
private static function status_label( $status ) {
$all = function_exists( 'wc_get_order_statuses' ) ? wc_get_order_statuses() : array();
$key = 0 === strpos( $status, 'wc-' ) ? $status : 'wc-' . $status;
return $all[ $key ] ?? $status;
}
private static function money( $amount, $currency ) {
return function_exists( 'wc_price' ) ? wc_price( (float) $amount, array( 'currency' => $currency ) ) : esc_html( $amount );
}
/* ---------- Pantalla ---------- */
public static function render() {
if ( ! current_user_can( self::CAP ) ) {
return;
}
$tab = sanitize_key( $_GET['tab'] ?? 'overview' ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended -- navegación.
$tabs = array(
'overview' => __( 'Overview', 'orderarc' ),
'archive' => __( 'Archive', 'orderarc' ),
'archived' => __( 'Archived orders', 'orderarc' ),
);
// Pestañas extra (versión Pro): clave => título; se dibujan con la acción orderarc_tab_{clave}.
$tabs = (array) apply_filters( 'orderarc_admin_tabs', $tabs );
if ( ! isset( $tabs[ $tab ] ) ) {
$tab = 'overview';
}
echo 'OrderArc ';
foreach ( $tabs as $k => $label ) {
printf( '%s ', esc_url( self::url( array( 'tab' => $k ) ) ), $k === $tab ? ' nav-tab-active' : '', esc_html( $label ) );
}
echo ' ';
$msg = get_transient( 'orderarc_msg_' . get_current_user_id() );
if ( $msg ) {
delete_transient( 'orderarc_msg_' . get_current_user_id() );
echo '
' . nl2br( esc_html( $msg ) ) . '
';
}
self::storage_notice();
if ( '' !== OrderArc_Engine::archive_blocked() ) {
echo '
' . esc_html( OrderArc_Engine::archive_blocked() ) . '
';
}
do_action( 'orderarc_notices' );
if ( ! OrderArc_Engine::db_supported() ) {
echo '
' . esc_html__( 'OrderArc needs a MySQL or MariaDB database. This site uses a different database, so archiving is turned off.', 'orderarc' ) . '
';
if ( 'archive' === $tab ) {
echo '
' . esc_html( sprintf( __( 'Orders were archived while the store used %1$s. The store now uses %2$s.', 'orderarc' ), $label[ $was ], $label[ $now ] ) ) . '
';
self::fact( __( 'Order storage', 'orderarc' ), esc_html( self::storage_label() ) );
self::fact( __( 'Orders in the store', 'orderarc' ), esc_html( number_format_i18n( self::live_orders() ) ) );
self::fact(
__( 'Ready to archive', 'orderarc' ),
esc_html( number_format_i18n( $pre['orders'] ) ) . ' (' . esc_html(
/* translators: 1: list of statuses, 2: number of days */
apply_filters( 'orderarc_rules_label', sprintf( __( '%1$s · older than %2$s days', 'orderarc' ), implode( ', ', $names ), number_format_i18n( $s['older_than_days'] ) ), $s )
) . ') '
);
self::fact( __( 'Skipped (orders with subscriptions or other child orders)', 'orderarc' ), esc_html( number_format_i18n( $pre['skipped'] ) ) );
self::fact( __( 'Archived', 'orderarc' ), esc_html( number_format_i18n( OrderArc_Engine::archived_count() ) ) );
$res = '';
if ( $search ) {
/* translators: %s: seconds */
$res = esc_html( sprintf( __( 'Searching orders took %s s', 'orderarc' ), number_format_i18n( $search['ms'] / 1000, 1 ) ) ) . ' (' . esc_html( wp_date( get_option( 'date_format' ) . ' ' . get_option( 'time_format' ), $search['time'] ) ) . ') ';
}
self::fact( '' . esc_html__( 'Measure search speed', 'orderarc' ) . ' ', '' . $res . ' ', true );
$tp = OrderArc_Engine::third_party();
if ( $tp ) {
$list = array();
foreach ( $tp as $t => $col ) {
if ( OrderArc_Engine::table_exists( OrderArc_Engine::live( $t ) ) ) {
$list[] = '' . esc_html( OrderArc_Engine::live( $t ) ) . ' (' . esc_html( $col ) . ')';
}
}
if ( $list ) {
self::fact( __( 'Tables from other plugins linked to orders', 'orderarc' ), implode( '
';
}
private static function fact( $label, $value_html, $label_is_html = false ) {
echo '' . ( $label_is_html ? wp_kses_post( $label ) : esc_html( $label ) ) . ' ' . wp_kses_post( $value_html ) . ' ' . esc_html__( 'OrderArc Pro adds archive rules, WP-CLI, a monthly report, an archive in another database, and retention and GDPR tools.', 'orderarc' ) . ' ' . esc_html__( 'Learn more', 'orderarc' ) . '
';
}
}
/** En los ajustes la casilla de backup solo hace falta si se activa el archivado automático. */
private static function backup_box_optional() {
if ( ! get_option( 'orderarc_backup_ack' ) ) {
echo '';
for ( $i = 0; $i < 24; $i++ ) {
$h .= sprintf( '%02d:00 ', $i, selected( (int) $val, $i, false ), $i );
}
return $h . ' ';
}
/** Línea de estado del trabajo (también la usa el refresco por AJAX). */
public static function status_html( $job ) {
$st = $job['status'] ?? '';
if ( ! $st ) {
return '';
}
$count = (int) ( $job['orders'] ?? 0 );
$n = number_format_i18n( $count );
$errs = (array) ( $job['errors'] ?? array() );
$dir = 'restore' === ( $job['direction'] ?? '' );
switch ( $st ) {
case 'running':
$line = $dir
/* translators: 1: number of orders, 2: number of errors */
? sprintf( _n( 'Running — %1$s order restored · %2$s errors', 'Running — %1$s orders restored · %2$s errors', $count, 'orderarc' ), $n, number_format_i18n( count( $errs ) ) )
/* translators: 1: number of orders, 2: number of errors */
: sprintf( _n( 'Running — %1$s order archived · %2$s errors', 'Running — %1$s orders archived · %2$s errors', $count, 'orderarc' ), $n, number_format_i18n( count( $errs ) ) );
break;
case 'waiting':
/* translators: %s: time, e.g. 01:00 */
$line = sprintf( __( 'Waiting for the time window (opens at %s)', 'orderarc' ), sprintf( '%02d:00', (int) OrderArc_Runner::settings()['window_start'] ) );
break;
case 'paused':
$line = __( 'Paused', 'orderarc' );
break;
case 'done':
$mins = max( 1, (int) round( ( ( $job['finished'] ?? time() ) - ( $job['started'] ?? time() ) ) / 60 ) );
$line = $dir
/* translators: 1: number of orders, 2: minutes */
? sprintf( _n( 'Done: %1$s order restored in %2$s min', 'Done: %1$s orders restored in %2$s min', $count, 'orderarc' ), $n, number_format_i18n( $mins ) )
/* translators: 1: number of orders, 2: minutes */
: sprintf( _n( 'Done: %1$s order in %2$s min', 'Done: %1$s orders in %2$s min', $count, 'orderarc' ), $n, number_format_i18n( $mins ) );
break;
default:
$line = '';
}
$html = '' . esc_html( $line ) . '
';
if ( $errs ) {
$html .= '';
foreach ( array_slice( array_reverse( $errs ), 0, 10 ) as $e ) {
$html .= '' . esc_html( $e ) . ' ';
}
$html .= ' ';
}
return $html;
}
private static function tab_archived() {
// phpcs:disable WordPress.Security.NonceVerification.Recommended -- búsqueda y navegación (GET).
$order = absint( $_GET['order'] ?? 0 );
if ( $order ) {
self::order_view( $order );
return;
}
$term = sanitize_text_field( wp_unslash( $_GET['s'] ?? '' ) );
$paged = max( 1, absint( $_GET['paged'] ?? 1 ) );
// phpcs:enable
$per = 20;
$res = OrderArc_Archived::search( $term, $paged, $per );
$rows = OrderArc_Archived::summaries( $res['ids'] );
echo '';
self::form_open( 'orderarc_restore' );
echo '' . esc_html( $c ) . ' ';
}
echo '';
if ( ! $rows ) {
echo '' . esc_html__( 'No archived orders found.', 'orderarc' ) . ' #' . esc_html( $id ) . ' ' . esc_html( self::fmt_date( $o['date'] ) ) . ' ' . esc_html( self::status_label( $o['status'] ) ) . ' ';
echo '' . esc_html( $o['customer'] ) . ' ' . esc_html( $o['email'] ) . ' ' . wp_kses_post( self::money( $o['total'], $o['currency'] ) ) . ' ';
echo '' . esc_html__( 'View', 'orderarc' ) . ' ';
echo '' . esc_html__( 'Restore', 'orderarc' ) . '
';
submit_button( __( 'Restore selected', 'orderarc' ), 'secondary', 'restore_selected', false );
echo '
';
$pages = (int) ceil( $res['total'] / $per );
/* translators: %s: number of items */
echo '
' . esc_html( sprintf( _n( '%s item', '%s items', $res['total'], 'orderarc' ), number_format_i18n( $res['total'] ) ) ) . ' ';
if ( $pages > 1 ) {
echo ' ' . wp_kses_post(
paginate_links(
array(
'base' => add_query_arg( 'paged', '%#%' ),
'format' => '',
'current' => $paged,
'total' => $pages,
)
)
);
}
echo '
← ' . esc_html__( 'Archived orders', 'orderarc' ) . '
';
if ( ! $o ) {
echo '' . esc_html__( 'No archived orders found.', 'orderarc' ) . '
';
return;
}
$cur = $o['currency'];
echo '#' . esc_html( $id ) . ' ' . esc_html__( 'Archived order (read-only)', 'orderarc' ) . ' ';
echo '
' . esc_html( self::fmt_date( $o['date'] ) ) . ' · ' . esc_html( self::status_label( $o['status'] ) ) . ( $o['payment'] ? ' · ' . esc_html( $o['payment'] ) : '' ) . '
';
echo '
' . esc_html__( 'Billing', 'orderarc' ) . ' ' . wp_kses_post( $o['billing'] ) . '
' . esc_html( $o['email'] ) . ( $o['phone'] ? '
';
echo '
' . esc_html__( 'Shipping', 'orderarc' ) . ' ' . wp_kses_post( $o['shipping'] ) . '
';
if ( $o['note'] ) {
echo '
' . esc_html( $o['note'] ) . '
';
}
echo '
' . esc_html__( 'Item', 'orderarc' ) . ' ' . esc_html__( 'Qty', 'orderarc' ) . ' ' . esc_html__( 'Total', 'orderarc' ) . ' ';
foreach ( $o['items'] as $it ) {
if ( ! in_array( $it['type'], array( 'line_item', 'fee' ), true ) ) {
continue; // envío y cupones van en las filas de totales.
}
echo '' . esc_html( $it['name'] ) . ' ' . esc_html( 'line_item' === $it['type'] ? $it['qty'] : '' ) . ' ' . wp_kses_post( self::money( (float) $it['shown'], $cur ) ) . ' ';
$tot = array(
__( 'Discount', 'orderarc' ) => (float) $o['discount'] ? -1 * (float) $o['discount'] : null,
__( 'Shipping', 'orderarc' ) => (float) $o['ship'] ? (float) $o['ship'] : null,
__( 'Tax', 'orderarc' ) => (float) $o['tax'] ? (float) $o['tax'] : null,
__( 'Total', 'orderarc' ) => (float) $o['total'],
);
foreach ( $tot as $label => $v ) {
if ( null !== $v ) {
$extra = __( 'Shipping', 'orderarc' ) === $label && $ship_names ? ' · ' . $ship_names : '';
echo '' . esc_html( $label . $extra ) . ' ' . wp_kses_post( self::money( $v, $cur ) ) . ' ' . esc_html__( 'Refunded', 'orderarc' ) . ' · ' . esc_html( self::fmt_date( $r['date'] ) ) . ( $r['reason'] ? ' · ' . esc_html( $r['reason'] ) : '' ) . ' ' . wp_kses_post( self::money( -1 * abs( (float) $r['amount'] ), $cur ) ) . '
';
if ( $o['notes'] ) {
echo '
' . esc_html__( 'Notes', 'orderarc' ) . ' ';
}
self::form_open( 'orderarc_restore' );
echo '
';
submit_button( __( 'Restore this order', 'orderarc' ), 'primary', 'submit', false );
echo '