ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / letacommog / laindinois / wp-content / plugins / dokan-pro / modules / shipstation / includes

<?php

/**
 * Include Dokan ShipStation template
 *
 * @since 1.0.0
 *
 * @param string $name
 * @param array  $args
 *
 * @return void
 */
function dokan_shipstation_get_template( $name, $args = [] ) {
    dokan_get_template( "$name.php", $args, DOKAN_SHIPSTATION_VIEWS, trailingslashit( DOKAN_SHIPSTATION_VIEWS ) );
}

/**
 * Get Order data for a seller
 *
 * @since 1.0.0
 *
 * @param int   $seller_id
 * @param array $args
 *
 * @return array
 */
function dokan_shipstation_get_orders( $seller_id, $args = array() ) {
    global $wpdb;

$current_time = current_time( 'mysql' );

$defaults = array(
        'count' => false,
        'start_date' => date( 'Y-m-d 00:00:00', strtotime( $current_time ) ),
        'end_date' => $current_time,
        'status' => null,
        'page' => 1,
        'fields' => array( 'do.*', 'p.post_date_gmt' ),
        'limit' => DOKAN_SHIPSTATION_EXPORT_LIMIT * ( $args['page'] - 1 ),
        'offset' => DOKAN_SHIPSTATION_EXPORT_LIMIT,
    );

$args = wp_parse_args( $args, $defaults );

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

if ( ! $orders ) {
        $select = implode( ', ', $args['fields'] );

$where = $wpdb->prepare(
            'do.seller_id = %d AND p.post_status != %s', $seller_id, 'trash'
        );

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

$where .= $wpdb->prepare( ' AND p.post_date_gmt >= %s AND p.post_date_gmt <= %s', $args['start_date'], $args['end_date'] );

$select = ! $args['count'] ? "SELECT $select" : "SELECT COUNT(p.ID) as count";
        $from = " FROM {$wpdb->prefix}dokan_orders AS do";
        $join = " LEFT JOIN $wpdb->posts p ON do.order_id = p.ID";
        $where = " WHERE $where";

if ( ! $args['count'] ) {
            $group_by = ' GROUP BY do.order_id';
            $order_by = ' ORDER BY p.post_date_gmt ASC';
            $limit = $wpdb->prepare( ' LIMIT %d, %d', $args['limit'], $args['offset'] );
        } else {
            $group_by = '';
            $order_by = '';
            $limit = '';
        }

$sql = $select . $from . $join . $where . $group_by . $order_by . $limit;

$orders = $wpdb->get_results( $sql );

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

return $orders;
}

[+] ..
[-] functions.php [edit]
[-] class-dokan-safe-domdocument.php [edit]
[-] abstract-class-dokan-shipstation-api-request.php [edit]
[-] class-dokan-shipstation-api-shipnotify.php [edit]
[-] class-dokan-shipstation-api.php [edit]
[-] class-dokan-shipstation-settings.php [edit]
[-] class-dokan-shipstation-api-export.php [edit]
[-] class-dokan-shipstation-hooks.php [edit]