Advertisement
palsushobhan

wcfm-refund-additional-info

Feb 7th, 2023
943
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.27 KB | None | 0 0
  1. add_filter( 'wcfm_refund_request_additional_info_column_label', function( $column_label ) {
  2.     return 'Details';
  3. });
  4. add_filter( 'wcfm_refund_requests_additonal_data_hidden', '__return_false' );
  5.  
  6. add_filter( 'wcfm_refund_request_additonal_data',function( $column_data, $refund_request_id ) {
  7.     global $wpdb;
  8.     $column_data_html = '';
  9.     $sql = 'SELECT od1.product_id, mt1.value FROM ' . $wpdb->prefix . 'wcfm_marketplace_refund_request AS commission';
  10.     $sql .= ' INNER JOIN ' . $wpdb->prefix . 'wcfm_marketplace_orders AS od1 ON ( commission.order_id = od1.order_id ) AND ( commission.item_id = od1.item_id )';
  11.     $sql .= ' INNER JOIN ' . $wpdb->prefix . 'wcfm_marketplace_refund_request_meta AS mt1 ON ( commission.ID = mt1.refund_id ) ';
  12.     $sql .= ' WHERE 1=1 ';
  13.     $sql .= ' AND (commission.ID = ' . $refund_request_id . ') AND (mt1.key = "refunded_qty")';
  14.     $result = $wpdb->get_row($sql);
  15.     $product_link = '<a target="_blank" href="' . get_wcfm_edit_product_url( $result->product_id ) . '" class="wcfm_dashboard_item_title transaction_order_id">'.  get_the_title($result->product_id) . '</a>';
  16.     $column_data_html = '<p> Product: ' . $product_link . '</p>';
  17.     $column_data_html .= '<p> Qty: ' . $result->value . '</p>';
  18.     return $column_data_html;
  19. }, 50, 2);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement