user_can( 'edit' ) ) { return self::fail( __( 'You do not have permission to edit this report.', 'ai-eshop-optimizer' ) ); } if ( 'pro' === AIEO_Report_Registry::tier( $report_id ) && class_exists( 'AIEO_DMM_Module_Base' ) && ! AIEO_DMM_Module_Base::is_aieo_pro_user() ) { return self::fail( __( 'This report is part of Rooster One Pro.', 'ai-eshop-optimizer' ) ); } $col = self::editable_column( $def, $column ); if ( ! $col ) { return self::fail( __( 'That column is not editable.', 'ai-eshop-optimizer' ) ); } $key_col = $def->row_key(); if ( '' === $key_col || '' === (string) $row_key ) { return self::fail( __( 'This report has no row identity, so a cell cannot be saved.', 'ai-eshop-optimizer' ) ); } $clean = self::cast( $col, $value ); if ( null === $clean ) { return self::fail( __( 'That value is not valid for this column.', 'ai-eshop-optimizer' ) ); } $handled = apply_filters( 'aieo_report_save_cell', false, array( 'report' => $def->id(), 'row_key' => (string) $row_key, 'column' => (string) $column, 'value' => $clean, ), $def ); if ( true === $handled ) { return self::ok( $clean ); } if ( is_string( $handled ) && '' !== $handled ) { return self::fail( $handled ); } if ( 'table' !== $def->source() ) { return self::fail( __( 'This report is not backed by a single table, so its cells can only be saved by the screen that owns them.', 'ai-eshop-optimizer' ) ); } return self::update_table( $def, $key_col, (string) $row_key, (string) $column, $clean ); } private static function editable_column( $def, $column ) { foreach ( $def->columns() as $col ) { if ( (string) $col['key'] !== (string) $column ) { continue; } if ( empty( $col['editable'] ) ) { return null; } if ( '' !== (string) ( isset( $col['select'] ) ? $col['select'] : '' ) ) { return null; } return $col; } return null; } public static function cast( $col, $value ) { if ( is_array( $value ) ) { return null; } $raw = trim( (string) $value ); switch ( (string) $col['type'] ) { case 'integer': if ( '' === $raw ) { return null; } return preg_match( '/^-?\d+$/', $raw ) ? (int) $raw : null; case 'money': case 'decimal': case 'percent': if ( '' === $raw ) { return null; } $n = str_replace( ',', '.', $raw ); return is_numeric( $n ) ? (float) $n : null; case 'boolean': return ( '1' === $raw || 'true' === strtolower( $raw ) || 'yes' === strtolower( $raw ) ) ? 1 : 0; case 'date': case 'datetime': if ( '' === $raw ) { return ''; } $ts = strtotime( $raw ); return false === $ts ? null : gmdate( 'Y-m-d H:i:s', $ts ); default: return sanitize_text_field( $raw ); } } private static function update_table( $def, $key_col, $row_key, $column, $value ) { global $wpdb; $table = AIEO_Report_Query::expand_prefix( (string) $def->get( 'table' ) ); if ( ! preg_match( '/^[A-Za-z0-9_]+$/', $table ) ) { return self::fail( __( 'That report names a table that cannot be written to.', 'ai-eshop-optimizer' ) ); } $done = $wpdb->update( $table, array( $column => $value ), array( $key_col => $row_key ) ); if ( false === $done ) { return self::fail( __( 'The database refused that change.', 'ai-eshop-optimizer' ) ); } if ( 0 === (int) $done ) { return self::ok( $value, __( 'No change.', 'ai-eshop-optimizer' ) ); } return self::ok( $value ); } private static function ok( $value, $message = '' ) { return array( 'ok' => true, 'value' => $value, 'message' => '' !== $message ? $message : __( 'Saved.', 'ai-eshop-optimizer' ), ); } private static function fail( $message ) { return array( 'ok' => false, 'message' => $message ); } }