Dokan export order attributes

dokan_get_product_attributes_by_order.php

<?php
/**
 * Dokan get seller amount from order total
 *
 * @param int $order_id
 *
 * @return float
 */
function dokan_get_seller_amount_from_order( $order_id, $get_array = false ) {

    $order              = wc_get_order( $order_id );
    $seller_id          = dokan_get_seller_id_by_order( $order_id );
    $net_amount         = dokan_get_seller_earnings_by_order( $order, $seller_id );
    $order_shipping     = $order->get_total_shipping();
    $order_tax          = $order->get_total_tax();
    $shipping_recipient = dokan_get_option( 'shipping_fee_recipient', 'dokan_selling', 'seller' );
    $tax_recipient      = dokan_get_option( 'tax_fee_recipient', 'dokan_selling', 'seller' );

    if ( $get_array ) {
        $amount = array(
            'net_amount' => $net_amount,
            'shipping'   => 0,
            'tax'        => 0,
        );

        if ( 'seller' == $shipping_recipient ) {
            $amount['shipping'] = $order_shipping;
        }

        if ( 'seller' == $tax_recipient ) {
            $amount['tax'] = $order_tax;
        }

        return apply_filters( 'dokan_get_seller_amount_from_order_array', $amount, $order, $seller_id );
    }

    return apply_filters( 'dokan_get_seller_amount_from_order', $net_amount, $order, $seller_id );
}
/**
 * Get all the orders from a specific seller
 *
 * @global object $wpdb
 * @param int $seller_id
 * @param string $status
 * @param string $order_date
 * @param int $limit
 * @param int $offset
 * @param int $customer_id
 *
 * @return array
 */
function dokan_get_seller_orders( $seller_id, $status = 'all', $order_date = NULL, $limit = 10, $offset = 0, $customer_id = null ) {
    global $wpdb;

    $pagenum     = isset( $_GET['pagenum'] ) ? absint( $_GET['pagenum'] ) : 1;
    $cache_group = "dokan_seller_data_{$seller_id}";
    $cache_key   = "dokan-seller-orders-{$status}-{$seller_id}-page-{$pagenum}";
    $orders      = wp_cache_get( $cache_key, $cache_group );

    $join        = $customer_id ? "LEFT JOIN $wpdb->postmeta pm ON p.ID = pm.post_id" : '';
    $where       = $customer_id ? sprintf( "pm.meta_key = '_customer_user' AND pm.meta_value = %d AND", $customer_id ) : '';

    if ( $orders === false ) {
        $status_where = ( $status == 'all' ) ? '' : $wpdb->prepare( ' AND order_status = %s', $status );
        $date_query   = ( $order_date ) ? $wpdb->prepare( ' AND DATE( p.post_date ) = %s', $order_date ) : '';

        $orders = $wpdb->get_results( $wpdb->prepare( "SELECT do.order_id, p.post_date
            FROM {$wpdb->prefix}dokan_orders AS do
            LEFT JOIN $wpdb->posts p ON do.order_id = p.ID
            {$join}
            WHERE
                do.seller_id = %d AND
                {$where}
                p.post_status != 'trash'
                {$date_query}
                {$status_where}
            GROUP BY do.order_id
            ORDER BY p.post_date DESC
            LIMIT %d, %d", $seller_id, $offset, $limit
        ) );

        wp_cache_set( $cache_key, $orders, $cache_group );
        dokan_cache_update_group( $cache_key, $cache_group );
    }

    return $orders;
}

/**
 * Get all the orders from a specific date range
 *
 * @global object $wpdb
 * @param int $seller_id
 *
 * @return array
 */
function dokan_get_seller_orders_by_date( $start_date, $end_date, $seller_id = false, $status = 'all' ) {
    global $wpdb;

    $seller_id = ! $seller_id ? dokan_get_current_user_id() : intval( $seller_id );

    $end_date    = date( 'Y-m-d 00:00:00', strtotime( $end_date ) );
    $end_date    = date( 'Y-m-d h:i:s', strtotime( $end_date . '-1 minute' ) );
    $start_date  = date( 'Y-m-d', strtotime( $start_date ) );

    $cache_group = 'dokan_seller_data_' . $seller_id;
    $cache_key   = md5( 'dokan-seller-orders-' . $end_date . '-' . $end_date. '-' . $seller_id );
    $orders      = wp_cache_get( $cache_key, $cache_group );

    if ( $orders === false ) {
        $status_where = '';

        if ( is_array( $status ) ) {
            $status_where = sprintf( " AND order_status IN ('%s')", implode( "', '", $status ) );
        } else {
            $status_where = $wpdb->prepare( ' AND order_status = %s', $status );
        }

        $date_query = $wpdb->prepare( ' AND DATE( p.post_date ) >= %s AND DATE( p.post_date ) <= %s', $start_date, $end_date );

        $orders = $wpdb->get_results( $wpdb->prepare( "SELECT do.*, p.post_date
            FROM {$wpdb->prefix}dokan_orders AS do
            LEFT JOIN $wpdb->posts p ON do.order_id = p.ID
            WHERE
                do.seller_id = %d AND
                p.post_status != 'trash'
                {$date_query}
                {$status_where}
            GROUP BY do.order_id
            ORDER BY p.post_date ASC", $seller_id
        ) );

        wp_cache_set( $cache_key, $orders, $cache_group, 3600*2 );
        dokan_cache_update_group( $cache_key, $cache_group );
    }

    return $orders;
}

/**
 * Get seller withdraw by date range
 *
 * @param  string  $start_date
 * @param  string  $end_date
 * @param  int $seller_id
 *
 * @return object
 */
function dokan_get_seller_withdraw_by_date( $start_date, $end_date, $seller_id = false ) {
    global $wpdb;

    $seller_id             = ! $seller_id ? dokan_get_current_user_id() : intval( $seller_id );
    $withdraw_status_where = $wpdb->prepare( ' AND status = %d', 1 );
    $withdraw_date_query   = $wpdb->prepare( ' AND DATE( date ) >= %s AND DATE( date ) <= %s', $start_date, $end_date );

    return $wpdb->get_results( $wpdb->prepare( "SELECT *
        FROM {$wpdb->prefix}dokan_withdraw
        WHERE
            user_id = %d
            {$withdraw_date_query}
            {$withdraw_status_where}
        ORDER BY date ASC", $seller_id
    ) );
}

/**
 * Get the orders total from a specific seller
 *
 * @global object $wpdb
 * @param int $seller_id
 * @return array
 */
function dokan_get_seller_orders_number( $seller_id, $status = 'all' ) {
    global $wpdb;

    $cache_group = 'dokan_seller_data_'.$seller_id;
    $cache_key   = 'dokan-seller-orders-count-' . $status . '-' . $seller_id;
    $count       = wp_cache_get( $cache_key, $cache_group );

    if ( $count === false ) {
        $status_where = ( $status == 'all' ) ? '' : $wpdb->prepare( ' AND order_status = %s', $status );

        $result = $wpdb->get_row( $wpdb->prepare( "SELECT COUNT(do.order_id) as count
                FROM {$wpdb->prefix}dokan_orders AS do
                LEFT JOIN $wpdb->posts p ON do.order_id = p.ID
                WHERE
                    do.seller_id = %d AND
                    p.post_status != 'trash'
                    {$status_where}", $seller_id ) );

        $count  = $result->count;

        wp_cache_set( $cache_key, $count, $cache_group );
        dokan_cache_update_group( $cache_key, $cache_group );
    }

    return $count;
}

/**
 * Get all the orders from a specific seller
 *
 * @global object $wpdb
 * @param int $seller_id
 * @return array
 */
function dokan_is_seller_has_order( $seller_id, $order_id ) {
    global $wpdb;
    return $wpdb->get_row( $wpdb->prepare( "SELECT do.order_id, p.post_date
        FROM {$wpdb->prefix}dokan_orders AS do
        LEFT JOIN $wpdb->posts p ON do.order_id = p.ID
        WHERE
            do.seller_id = %d AND
            p.post_status != 'trash' AND
            do.order_id = %d
        GROUP BY do.order_id", $seller_id, $order_id
    ) );
}

/**
 * Count orders for a seller
 *
 * @global WPDB $wpdb
 * @param int $user_id
 * @return array
 */
function dokan_count_orders( $user_id ) {
    global $wpdb;

    $cache_group = 'dokan_seller_data_'.$user_id;
    $cache_key   = 'dokan-count-orders-' . $user_id;
    $counts      = wp_cache_get( $cache_key, $cache_group );

    if ( $counts === false ) {
        $counts = [
            'wc-pending'    => 0,
            'wc-completed'  => 0,
            'wc-on-hold'    => 0,
            'wc-processing' => 0,
            'wc-refunded'   => 0,
            'wc-cancelled'  => 0,
            'wc-failed'     => 0,
            'total'         => 0
        ];

        $results = $wpdb->get_results( $wpdb->prepare( "SELECT do.order_status
            FROM {$wpdb->prefix}dokan_orders AS do
            LEFT JOIN $wpdb->posts p ON do.order_id = p.ID
            WHERE
                do.seller_id = %d AND
                p.post_type = 'shop_order' AND
                p.post_status != 'trash'", $user_id
        ) );

        if ($results) {
            $total = 0;

            foreach ($results as $order) {
                if ( isset( $counts[$order->order_status] ) ) {
                    $counts[$order->order_status] += 1;
                    $counts['total'] += 1;
                }
            }
        }

        $counts = (object) $counts;
        wp_cache_set( $cache_key, $counts, $cache_group );
        dokan_cache_update_group( $cache_key , $cache_group );
    }

    return $counts;
}


/**
 * Delete a order row from sync table when a order is deleted from WooCommerce
 *
 * @global object $wpdb
 * @param type $order_id
 */
function dokan_delete_sync_order( $order_id ) {
    global $wpdb;

    $wpdb->delete( $wpdb->prefix . 'dokan_orders', array( 'order_id' => $order_id ) );
}

/**
 * Delete a order row from sync table to not insert duplicate
 *
 * @global object $wpdb
 * @param type $order_id, $seller_id
 *
 * @since  2.4.11
 */
function dokan_delete_sync_duplicate_order( $order_id, $seller_id ) {
    global $wpdb;

    $wpdb->delete( $wpdb->prefix . 'dokan_orders', array( 'order_id' => $order_id, 'seller_id' => $seller_id ) );
}

/**
 * Insert a order in sync table once a order is created
 *
 * @global object $wpdb
 * @param int $order_id
 */
function dokan_sync_insert_order( $order_id ) {
    global $wpdb;

    if ( dokan_is_order_already_exists( $order_id ) ) {
        return;
    }

    if ( get_post_meta( $order_id, 'has_sub_order', true ) == '1' ) {
        return;
    }

    $order              = wc_get_order( $order_id );
    $seller_id          = dokan_get_seller_id_by_order( $order_id );
    $order_total        = $order->get_total();
    $order_status       = dokan_get_prop( $order, 'status' );
    $admin_commission   = dokan()->commission->get_earning_by_order( $order, 'admin' );
    $net_amount         = $order_total - $admin_commission;
    $net_amount         = apply_filters( 'dokan_order_net_amount', $net_amount, $order );
    $threshold_day      = dokan_get_option( 'withdraw_date_limit', 'dokan_withdraw', 0 );
    $threshold_day      = $threshold_day ? $threshold_day : 0;

    dokan_delete_sync_duplicate_order( $order_id, $seller_id );

    // make sure order status contains "wc-" prefix
    if ( stripos( $order_status, 'wc-' ) === false ) {
        $order_status = 'wc-' . $order_status;
    }

    $wpdb->insert( $wpdb->prefix . 'dokan_orders',
        array(
            'order_id'     => $order_id,
            'seller_id'    => $seller_id,
            'order_total'  => $order_total,
            'net_amount'   => $net_amount,
            'order_status' => $order_status,
        ),
        array(
            '%d',
            '%d',
            '%f',
            '%f',
            '%s',
        )
    );

    $wpdb->insert( $wpdb->prefix . 'dokan_vendor_balance',
        array(
            'vendor_id'     => $seller_id,
            'trn_id'        => $order_id,
            'trn_type'      => 'dokan_orders',
            'perticulars'   => 'New order',
            'debit'         => $net_amount,
            'credit'        => 0,
            'status'        => $order_status,
            'trn_date'      => current_time( 'mysql' ),
            'balance_date'  => date( 'Y-m-d h:i:s', strtotime( current_time( 'mysql' ) . ' + '.$threshold_day.' days' ) ),
        ),
        array(
            '%d',
            '%d',
            '%s',
            '%s',
            '%f',
            '%f',
            '%s',
            '%s',
            '%s',
        )
    );
}

add_action( 'woocommerce_checkout_update_order_meta', 'dokan_sync_insert_order', 20 );
add_action( 'dokan_checkout_update_order_meta', 'dokan_sync_insert_order' );


/**
 * Get a seller ID based on WooCommerce order.
 *
 * If multiple post author is found, then this order contains products
 * from multiple sellers. In that case, the seller ID becomes `0`.
 *
 * @global object $wpdb
 * @param int $order_id
 *
 * @return int | 0 on failure
 */
function dokan_get_seller_id_by_order( $order_id ) {
    global $wpdb;

    $cache_key   = 'dokan_get_seller_id_' . $order_id;
    $cache_group = 'dokan_get_seller_id_by_order';
    $seller      = wp_cache_get( $cache_key, $cache_group );
    $items       = [];
    $seller_id   = 0;

    if ( false === $seller ) {
        $seller = $wpdb->get_results( $wpdb->prepare( "SELECT seller_id FROM {$wpdb->prefix}dokan_orders WHERE order_id = %d", $order_id ) );
        wp_cache_set( $cache_key, $seller, $cache_group );
    }

    if ( count( $seller ) === 1 ) {
        $seller_id = absint( reset( $seller )->seller_id );

        return apply_filters( 'dokan_get_seller_id_by_order', $seller_id, $items );
    }

    // if seller is not found, try to retrieve it via line items
    if ( ! $seller ) {
        $order = wc_get_order( $order_id );

        if ( ! $order instanceof WC_Order ) {
            return apply_filters( 'dokan_get_seller_id_by_order', $seller_id, $items );
        }

        if ( $order->get_meta( 'has_sub_order' ) ) {
            return apply_filters( 'dokan_get_seller_id_by_order', $seller_id, $items );
        }

        $items = $order->get_items( 'line_item' );

        if ( ! $items ) {
            return apply_filters( 'dokan_get_seller_id_by_order', $seller_id, $items );
        }

        $product_id = current( $items )->get_product_id();
        $seller_id  = get_post_field( 'post_author', $product_id );
        $seller_id  = $seller_id ? absint( $seller_id ) : 0;

        return apply_filters( 'dokan_get_seller_id_by_order', $seller_id, $items );
    }
}

/**
 * Get bootstrap label class based on order status
 *
 * @param string $status
 * @return string
 */
function dokan_get_order_status_class( $status ) {
    switch ($status) {
        case 'completed':
        case 'wc-completed':
            return 'success';
            break;

        case 'pending':
        case 'wc-pending':
            return 'danger';
            break;

        case 'on-hold':
        case 'wc-on-hold':
            return 'warning';
            break;

        case 'processing':
        case 'wc-processing':
            return 'info';
            break;

        case 'refunded':
        case 'wc-refunded':
            return 'default';
            break;

        case 'cancelled':
        case 'wc-cancelled':
            return 'default';
            break;

        case 'failed':
        case 'wc-failed':
            return 'danger';
            break;

        default:
            return apply_filters( 'dokan_get_order_status_class', '', $status );
            break;
    }
}

/**
 * Get translated string of order status
 *
 * @param string $status
 * @return string
 */
function dokan_get_order_status_translated( $status ) {
    switch ($status) {
        case 'completed':
        case 'wc-completed':
            return __( 'Completed', 'dokan-lite' );
            break;

        case 'pending':
        case 'wc-pending':
            return __( 'Pending Payment', 'dokan-lite' );
            break;

        case 'on-hold':
        case 'wc-on-hold':
            return __( 'On-hold', 'dokan-lite' );
            break;

        case 'processing':
        case 'wc-processing':
            return __( 'Processing', 'dokan-lite' );
            break;

        case 'refunded':
        case 'wc-refunded':
            return __( 'Refunded', 'dokan-lite' );
            break;

        case 'cancelled':
        case 'wc-cancelled':
            return __( 'Cancelled', 'dokan-lite' );
            break;

        case 'failed':
        case 'wc-failed':
            return __( 'Failed', 'dokan-lite' );
            break;

        default:
            return apply_filters( 'dokan_get_order_status_translated', '', $status );
            break;
    }
}

/**
 * Get product items list from order
 *
 * @since 1.4
 *
 * @param  object $order
 * @param  string $glue
 *
 * @return string list of products
 */
function dokan_get_product_list_by_order( $order, $glue = ',' ) {

    $product_list = '';
    $order_item   = $order->get_items();

    foreach( $order_item as $product ) {
        $prodct_name[] = $product['name'];
    }

    $product_list = implode( $glue, $prodct_name );

    return $product_list;
}

function dokan_get_product_attributes_by_order( $order, $glue = ',' ) {
    $order_item     = $order->get_items();
    $attributes     = '';
    $meta_to_ignore = apply_filters( 'dokan_get_product_list_by_order_meta_to_ignore', [
        '_reduced_stock',
        'Add-Ons',
        'Consent',
        '_is_deposit',
        '_deposit_full_amount',
        '_deposit_full_amount_ex_tax',
        '_deposit_deposit_amount_ex_tax',
        '_remaining_balance_order_id',
        '_dokan_commission_rate',
        '_dokan_commission_type',
        '_dokan_additional_fee',
        '_dokan_item_warranty_selected'
    ] );

    foreach( $order_item as $item ) {
        $item_meta = $item->get_meta_data();

        if ( empty( $item_meta ) ) {
            continue;
        }

        foreach ( $item_meta as $meta ) {
            $data  = $meta->get_data();
            $key   = ! empty( $data['key'] ) ? $data['key'] : '';
            $value = ! empty( $data['value'] ) ? $data['value'] : '';

            if ( ! $key || in_array( $key, $meta_to_ignore ) ) {
                continue;
            }

            if ( ! $value || ! is_string( $value ) ) {
                continue;
            }

            $attributes .= "{$key}: {$value}, ";
        }

        $attributes = substr( $attributes, 0, strlen( trim( $attributes ) ) - 1 );
        $attributes .= $attributes ? $glue : '';
    }

    return apply_filters( 'dokan_get_product_attributes_by_order', $attributes );
}

/**
 * Get if an order is a sub order or not
 *
 * @since 2.4.11
 *
 * @param int $order_id
 *
 * @return boolean
 */
function dokan_is_sub_order( $order_id ) {
    $parent_order_id =  wp_get_post_parent_id( $order_id );

    if ( 0 != $parent_order_id ) {
        return true;
    }

    return false;
}


/**
 * Get toal number of orders in Dokan order table
 *
 * @since 2.4.3
 *
 * @return  int Order_count
 */
function dokan_total_orders() {
    global $wpdb;

    $order_count = $wpdb->get_var( "SELECT COUNT(id) FROM " . $wpdb->prefix . "dokan_orders " );

    return (int) $order_count;
}

/**
 * Return array of sellers with items
 *
 * @since 2.4.4
 * @since 2.9.11 Param can be an instance of WC_Order
 *
 * @param WC_Order|int $order
 *
 * @return array $sellers_with_items
 */
function dokan_get_sellers_by( $order ) {
    if ( ! $order instanceof WC_Order ) {
        $order  = wc_get_order( $order );
    }

    $order_items = $order->get_items();

    $sellers = array();

    foreach ( $order_items as $item ) {
        $seller_id             = get_post_field( 'post_author', $item['product_id'] );
        //New filter hook to modify the seller id at run time.
   		$seller_id = apply_filters( 'dokan_get_sellers_by', $seller_id, $item );
        $sellers[$seller_id][] = $item;
    }

    return $sellers;
}

/**
 * Return unique array of seller_ids from an order
 *
 * @since 2.4.9
 *
 * @param type $order_id
 *
 * @return array $seller_ids
 */
function dokan_get_seller_ids_by( $order_id ) {

    $sellers = dokan_get_sellers_by( $order_id );

    return array_unique( array_keys( $sellers ) );
}

/**
 *
 * @global object $wpdb
 * @param type $parent_order_id
 * @return type
 */
function dokan_get_suborder_ids_by( $parent_order_id ) {
    global $wpdb;

     $sub_orders = $wpdb->get_results( $wpdb->prepare( "SELECT ID FROM {$wpdb->posts}
         WHERE post_type = 'shop_order'
         AND post_parent = %d", $parent_order_id
    ) );

    if ( ! $sub_orders ) {
        return null;
    }

    return $sub_orders;
}

/**
 * Return admin commisson from an order
 *
 * @since 2.4.12
 *
 * @param object $order
 *
 * @return float $commission
 */
function dokan_get_admin_commission_by( $order, $context ) {
    $context = 'seller' === $context ? $context : 'admin';
    wc_deprecated_function( 'dokan_get_admin_commission_by', '2.9.21', 'Dokan_Commission::get_earning_by_order()' );

    return dokan()->commission->get_earning_by_order( $order, $context );

    if ( get_posts( array( 'post_parent' => $order->get_id(), 'post_type' => 'shop_order', 'post_status' => 'any' ) ) ) {
        return;
    }

    $saved_admin_fee = get_post_meta( $order->get_id(), '_dokan_admin_fee', true );

    if ( $saved_admin_fee != '' ) {
        return apply_filters( 'dokan_order_admin_commission', $saved_admin_fee, $order );
    }

    $admin_commission   = 0;
    $refund_t           = 0;
    $commissions        = array();
    $i                  = 0;
    $total_line         = 0;
    $shipping_recipient = dokan_get_option( 'shipping_fee_recipient', 'dokan_selling', 'seller' );
    $tax_recipient      = dokan_get_option( 'tax_fee_recipient', 'dokan_selling', 'seller' );

    foreach ( $order->get_items() as $item_id => $item ) {

        $refund_t                      += $order->get_total_refunded_for_item( $item_id );
        $commissions[$i]['total_line'] = $item->get_total() - $order->get_total_refunded_for_item( $item_id );
        $commissions[$i]['fee_type']   = dokan_get_commission_type( $seller_id, $item['product_id'] );
        $commissions[$i]['admin_fee']  = ( 'percentage' == $commissions[$i]['fee_type'] ) ? 100 - dokan_get_seller_percentage( $seller_id, $item['product_id'] ) : dokan_get_seller_percentage( $seller_id, $item['product_id'] );
        $total_line                    += $commissions[$i]['total_line'];

        $i++;
    }

    $refund_t += $order->get_total_tax_refunded() + $order->get_total_shipping_refunded();
    $refund_ut = $order->get_total_refunded() - $refund_t;

    if ( $total_line ) {
        foreach ( $commissions as $commission ) {
            $commission['ut_amount'] = $refund_ut * ( $commission['total_line'] / $total_line );

            if ( 'percentage' == $commission['fee_type'] ) {
                $admin_commission += ( $commission['total_line'] + $commission['ut_amount'] ) * $commission['admin_fee'] /100;
            } else {
                $admin_commission += $commission['admin_fee'];
            }
        }
    }

    if ( 'admin' == $shipping_recipient ) {
        $admin_commission += $order->get_total_shipping() - $order->get_total_shipping_refunded();
    }

    if ( 'admin' == $tax_recipient ) {
        $admin_commission += $order->get_total_tax() - $order->get_total_tax_refunded();
    }

    return apply_filters( 'dokan_order_admin_commission', $admin_commission, $order );
}

if ( ! function_exists( 'dokan_get_customer_orders_by_seller' ) ) :
    /**
     * Get Customer Order IDs by Seller
     *
     * @since 2.6.6
     *
     * @param int $customer_id
     *
     * @param int $seller_id
     *
     * @return array|null on failure
     */
    function dokan_get_customer_orders_by_seller( $customer_id, $seller_id ) {

        if ( ! $customer_id || ! $seller_id ) {
            return null;
        }

        $args = [
            'customer_id'   => $customer_id,
            'post_type'     => 'shop_order',
            'meta_key'      => '_dokan_vendor_id',
            'meta_value'    => $seller_id,
            'post_status'   => array_keys( wc_get_order_statuses() ),
            'return'        => 'ids',
            'numberposts'   => -1,
        ];

        $orders = wc_get_orders( apply_filters( 'dokan_get_customer_orders_by_seller', $args ) );

        return $orders ? $orders : null;
    }

endif;

/**
 * Header rows for CSV order export
 *
 * @since 2.8.6
 *
 * @return array
 */
function dokan_order_csv_headers() {
    $headers = array(
        'order_id'             => __( 'Order No', 'dokan-lite' ),
        'order_items'          => __( 'Order Items', 'dokan-lite' ),
        'item_attributes'      => __( 'Item Variations', 'dokan-lite' ),
        'order_shipping'       => __( 'Shipping method', 'dokan-lite' ),
        'order_shipping_cost'  => __( 'Shipping Cost', 'dokan-lite' ),
        'order_payment_method' => __( 'Payment method', 'dokan-lite' ),
        'order_total'          => __( 'Order Total', 'dokan-lite' ),
        'order_status'         => __( 'Order Status', 'dokan-lite' ),
        'order_date'           => __( 'Order Date', 'dokan-lite' ),

        'billing_company'      => __( 'Billing Company', 'dokan-lite' ),
        'billing_first_name'   => __( 'Billing First Name', 'dokan-lite' ),
        'billing_last_name'    => __( 'Billing Last Name', 'dokan-lite' ),
        'billing_full_name'    => __( 'Billing Full Name', 'dokan-lite' ),
        'billing_email'        => __( 'Billing Email', 'dokan-lite' ),
        'billing_phone'        => __( 'Billing Phone', 'dokan-lite' ),
        'billing_address_1'    => __( 'Billing Address 1', 'dokan-lite' ),
        'billing_address_2'    => __( 'Billing Address 2', 'dokan-lite' ),
        'billing_city'         => __( 'Billing City', 'dokan-lite' ),
        'billing_state'        => __( 'Billing State', 'dokan-lite' ),
        'billing_postcode'     => __( 'Billing Postcode', 'dokan-lite' ),
        'billing_country'      => __( 'Billing Country', 'dokan-lite' ),

        'shipping_company'     => __( 'Shipping Company', 'dokan-lite' ),
        'shipping_first_name'  => __( 'Shipping First Name', 'dokan-lite' ),
        'shipping_last_name'   => __( 'Shipping Last Name', 'dokan-lite' ),
        'shipping_full_name'   => __( 'Shipping Full Name', 'dokan-lite' ),
        'shipping_address_1'   => __( 'Shipping Address 1', 'dokan-lite' ),
        'shipping_address_2'   => __( 'Shipping Address 2', 'dokan-lite' ),
        'shipping_city'        => __( 'Shipping City', 'dokan-lite' ),
        'shipping_state'       => __( 'Shipping State', 'dokan-lite' ),
        'shipping_postcode'    => __( 'Shipping Postcode', 'dokan-lite' ),
        'shipping_country'     => __( 'Shipping Country', 'dokan-lite' ),

        'customer_ip'          => __( 'Customer IP', 'dokan-lite' ),
        'customer_note'        => __( 'Customer Note', 'dokan-lite' ),
    );

    return apply_filters( 'dokan_csv_export_headers', $headers );
}

/**
 * Export orders to a CSV file
 *
 * @since 2.8.6
 *
 * @param  array $orders
 * @param  string $file     A file name to write to
 *
 * @return void
 */
function dokan_order_csv_export( $orders, $file = null ) {
    $headers  = dokan_order_csv_headers();
    $statuses = wc_get_order_statuses();

    $resource = ( $file == null ) ? 'php://output' : $file;
    $output   = fopen( $resource, 'w');

    fputcsv( $output, $headers );

    foreach ( $orders as $order ) {
        $the_order = wc_get_order( $order->order_id );
        $line      = array();

        foreach ( $headers as $row_key => $label ) {

            switch ( $row_key ) {
                case 'order_id':
                    $line[ $row_key ] = $the_order->get_id();
                    break;
                case 'order_items':
                    $line[ $row_key ] = dokan_get_product_list_by_order( $the_order, '; ' );
                    break;
                case 'item_attributes':
                    $line[ $row_key ] = dokan_get_product_attributes_by_order( $the_order, '; ' );
                    break;
                case 'order_shipping':
                    $line[ $row_key ] = $the_order->get_shipping_method();
                    break;
                case 'order_shipping_cost':
                    $line[ $row_key ] = $the_order->get_total_shipping();
                    break;
                case 'order_payment_method':
                    $line[ $row_key ] = $the_order->get_payment_method_title();
                    break;
                case 'order_total':
                    $line[ $row_key ] = $the_order->get_total();
                    break;
                case 'order_status':
                    $line[ $row_key ] = $statuses['wc-' . dokan_get_prop( $the_order, 'status' )];
                    break;
                case 'order_date':
                    $line[ $row_key ] = dokan_get_date_created( $the_order );
                    break;

                // billing details
                case 'billing_company':
                    $line[ $row_key ] = $the_order->get_billing_company();
                    break;
                case 'billing_first_name':
                    $line[ $row_key ] = $the_order->get_billing_first_name();
                    break;
                case 'billing_last_name':
                    $line[ $row_key ] = $the_order->get_billing_last_name();
                    break;
                case 'billing_full_name':
                    $line[ $row_key ] = $the_order->get_formatted_billing_full_name();
                    break;
                case 'billing_email':
                    $line[ $row_key ] = $the_order->get_billing_email();
                    break;
                case 'billing_phone':
                    $line[ $row_key ] = $the_order->get_billing_phone();
                    break;
                case 'billing_address_1':
                    $line[ $row_key ] = $the_order->get_billing_address_1();
                    break;
                case 'billing_address_2':
                    $line[ $row_key ] = $the_order->get_billing_address_2();
                    break;
                case 'billing_city':
                    $line[ $row_key ] = $the_order->get_billing_city();
                    break;
                case 'billing_state':
                    $line[ $row_key ] = $the_order->get_billing_state();
                    break;
                case 'billing_postcode':
                    $line[ $row_key ] = $the_order->get_billing_postcode();
                    break;
                case 'billing_country':
                    $line[ $row_key ] = $the_order->get_billing_country();
                    break;

                // shipping details
                case 'shipping_company':
                    $line[ $row_key ] = $the_order->get_shipping_company();
                    break;
                case 'shipping_first_name':
                    $line[ $row_key ] = $the_order->get_shipping_first_name();
                    break;
                case 'shipping_last_name':
                    $line[ $row_key ] = $the_order->get_shipping_last_name();
                    break;
                case 'shipping_full_name':
                    $line[ $row_key ] = $the_order->get_formatted_billing_full_name();
                    break;
                case 'shipping_address_1':
                    $line[ $row_key ] = $the_order->get_shipping_address_1();
                    break;
                case 'shipping_address_2':
                    $line[ $row_key ] = $the_order->get_shipping_address_2();
                    break;
                case 'shipping_city':
                    $line[ $row_key ] = $the_order->get_shipping_city();
                    break;
                case 'shipping_state':
                    $line[ $row_key ] = $the_order->get_shipping_state();
                    break;
                case 'shipping_postcode':
                    $line[ $row_key ] = $the_order->get_shipping_postcode();
                    break;
                case 'shipping_country':
                    $line[ $row_key ] = $the_order->get_shipping_country();
                    break;

                // custom details
                case 'customer_ip':
                    $line[ $row_key ] = $the_order->get_customer_ip_address();
                    break;
                case 'customer_note':
                    $line[ $row_key ] = $the_order->get_customer_note();
                    break;

                default:
                    $line[ $row_key ] = '';
                    break;
            }
        }

        $line = apply_filters( 'dokan_csv_export_lines', $line, $the_order );

        fputcsv( $output, $line );
    }

    fclose( $output );
}

/**
 * Dokan get seller id by order id
 *
 * @param  int order_id
 *
 * @return int
 */
function dokan_get_seller_id_by_order_id( $id ) {
    wc_deprecated_function( 'dokan_get_seller_id_by_order_id', '2.9.10', 'dokan_get_seller_id_by_order' );

    return dokan_get_seller_id_by_order( $id );
}

/**
 * Check if an order with same id is exists in database
 *
 * @param  int order_id
 *
 * @return boolean
 */
function dokan_is_order_already_exists( $id ) {
    global $wpdb;

    if ( ! $id || ! is_numeric( $id ) ) {
        return false;
    }

    $order_id = $wpdb->get_var( $wpdb->prepare( "SELECT order_id FROM {$wpdb->prefix}dokan_orders WHERE order_id=%d", $id ) );

    return $order_id ? true : false;
}