<?php
if (!defined('ABSPATH')) {
    exit; // Exit if accessed directly
}
function wpcfe_report_color_pallete()
{
    $pallet = array(
        '263238', '7283a7', '6d4c41', '757575', '388e3c', '9ea441', '0288d1', '26a69a', '5e35b1', '4a148c', 'ad1457', '948649', 'ff5722', 'bf360c', 'b1736c', '00c853', '00b8d4', '004d40', '311b92', 'd50000', 'aa00ff', '4a148c', 'ff3d00', 'b9f6ca'
    );
    return apply_filters('wpcfe_report_color_pallete', $pallet);
}
function wpcfe_first_last_date($date = '')
{
    $dateString = strtotime(current_time('mysql'));
    if (!empty($date)) {
        $dateString = strtotime($date);
    }
    //Last date of current month.
    $lastDateOfMonth    = date("Y-m-t", $dateString);
    $firstDateOfMonth   = date("Y-m-", $dateString) . '01';
    return array(
        'first' => $firstDateOfMonth,
        'last'  => $lastDateOfMonth
    );
}
function wpcfe_print_barcode_sizes($type = '')
{
    $_height    = 80;
    $_width     = 250;
    if ('waybill' == $type) {
        $_height    = 120;
        $_width     = 300;
    }

    $default_size = array('height' => $_height, 'width' => $_width);
    if (function_exists('wpcargo_print_barcode_sizes') && !empty($type)) {
        $barcode_size = wpcargo_print_barcode_sizes();
        if (!array_key_exists($type, $barcode_size)) {
            return $default_size;
        }
        $height = $barcode_size[$type]['height'] ? $barcode_size[$type]['height'] : $_height;
        $width  = $barcode_size[$type]['width'] ? $barcode_size[$type]['width'] : $_width;
        return array('height' => $height, 'width' => $width);
    }
    return $default_size;
}

function wpcef_get_dates($date_from, $date_to)
{
    // Date format : YYYY-MM-DD
    $dates = array();
    $period = new DatePeriod(
        new DateTime($date_from),
        new DateInterval('P1D'),
        new DateTime($date_to)
    );
    foreach ($period as $key => $value) {
        $_date = $value->format('Y-m-d');
        if (in_array($_date, $dates)) {
            continue;
        }
        $dates[] = $_date;
    }
    $dates[] = $date_to;
    return $dates;
}

// Common Functions
function wpcfe_to_slug($string = '')
{
    $string = strtolower(preg_replace('/\s+/', '_', trim($string)));
    return substr(preg_replace('/[^A-Za-z0-9_\-]/', '', $string), 0, 60);
}
function wpcfe_print_paper()
{
    $sizes = array(
        'label' => array(
            'size' => 'A6',
            'orient' => 'portrait'
        ),
        'invoice' => array(
            'size' => 'Letter',
            'orient' => 'portrait'
        ),
        'waybill' => array(
            'size' => wpcfe_waybill_paper_size(),
            'orient' => wpcfe_waybill_paper_orient()
        ),
        'bol' => array(
            'size' => 'A4',
            'orient' => 'portrait'
        ),
    );
    return apply_filters('wpcfe_print_paper_size', $sizes);
}
function wpcfe_print_options()
{
    $options = array(
        'invoice'   => esc_html__('Invoice', 'wpcargo-frontend-manager'),
        'label'     => esc_html__('Label', 'wpcargo-frontend-manager'),
        'waybill'   => esc_html__('Waybill', 'wpcargo-frontend-manager')
    );
    return apply_filters('wpcfe_print_options', $options);
}
function wpcfe_print_cfields($flag = '')
{
    global $wpdb;
    $table_prefix = $wpdb->prefix;
    //** Flag value Parameter
    //* @shipper_info
    //* @receiver_info
    //* @shipment_info
    $result_fields = $wpdb->get_results('SELECT * FROM `' . $table_prefix . 'wpcargo_custom_fields` WHERE `section` LIKE "%' . $flag . '%" ORDER BY ABS(weight)', ARRAY_A);
    $fields = array();
    $user_role = array('useraccess_not_logged_in');
    if (is_user_logged_in()) {
        $current_user = wp_get_current_user();
        $user_role = $current_user->roles;
    }
    $counter = 0;
    foreach ($result_fields as $value) {
        $flags                 = maybe_unserialize($value['display_flags']) ? maybe_unserialize($value['display_flags']) : array();
        $role_intersected     = array_intersect($flags, $user_role);
        if (!empty($role_intersected) && count($role_intersected) <= count($user_role)) {
            continue;
        }
        $fields[$counter] = $value;
        $counter++;
    }
    return $fields;
}
function wpcfe_print_data($flag = '', $shipment_id = 0, $attachment_image = true)
{
    global $wpcargo;
    $field_keys = wpcfe_print_cfields($flag);
    ob_start();
    if (!empty($field_keys)) {
        foreach ($field_keys as $field) {
            $field_data = maybe_unserialize(get_post_meta($shipment_id, $field['field_key'], TRUE));
            if (is_array($field_data)) {
                $field_data = implode(", ", $field_data);
            }
            if ($field['field_type'] == 'file') {
                $files = array_filter(array_map('trim', explode(",", $field_data)));
                if (!empty($files)) {
?>
                    <div class="wpccfe-files-data">
                        <label><?php echo stripslashes($field['label']); ?></label>
                        <div id="wpcargo-gallery-container_<?php echo $field['id']; ?>">
                            <ul class="wpccf_uploads">
                                <?php
                                foreach ($files as $file_id) {
                                    $att_meta = wp_get_attachment_metadata($file_id);
                                ?>
                                    <li class="image">
                                        <a href="<?php echo wp_get_attachment_url($file_id); ?>" download>
                                            <?php if ($attachment_image) : ?>
                                                <?php echo wp_get_attachment_image($file_id, 'thumbnail', TRUE); ?>
                                            <?php endif; ?>
                                            <span class="img-title" title="<?php echo get_the_title($file_id); ?>"><?php echo get_the_title($file_id); ?></span>
                                        </a>
                                    </li>
                                <?php
                                }
                                ?>
                            </ul>
                        </div>
                    </div>
                <?php
                }
            } elseif ($field['field_type'] == 'url') {
                $url_data = maybe_unserialize(get_post_meta($shipment_id, $field['field_key'], TRUE));
                $target   = count($url_data) > 2 ? '_blank' : '';
                $url       = $url_data[1] ? $url_data[1] : '#';
                $label       = $url_data[0];
                ?><p><?php echo stripslashes($field['label']); ?>: <a href="<?php echo $url; ?>" target="<?php echo $target; ?>"><?php echo $label; ?></a></p><?php
                                                                                                                                                            } else {
                                                                                                                                                                ?><p><?php echo stripslashes($field['label']); ?>: <?php echo $field_data; ?></p><?php
                                                                                                                                                                                                                                                }
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        $output = ob_get_clean();
                                                                                                                                                                                                                                        return $output;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_get_users($role)
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        global $wpcargo;
                                                                                                                                                                                                                                        $user_args = array(
                                                                                                                                                                                                                                            'role__in'  => array($role),
                                                                                                                                                                                                                                            'orderby'   => 'display_name',
                                                                                                                                                                                                                                            'order'     => 'ASC'
                                                                                                                                                                                                                                        );
                                                                                                                                                                                                                                        $user_list  = get_users(apply_filters("wpcfe_get_users_{$role}_args", $user_args));
                                                                                                                                                                                                                                        $users      = array();
                                                                                                                                                                                                                                        if (!empty($user_list)) {
                                                                                                                                                                                                                                            foreach ($user_list as $user) {
                                                                                                                                                                                                                                                $users[$user->ID] = $wpcargo->user_fullname($user->ID);
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return apply_filters("wpcfe_get_users_{$role}_list", $users);
                                                                                                                                                                                                                                    }

                                                                                                                                                                                                                                    function wpcfe_get_clients()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        global $wpcargo;
                                                                                                                                                                                                                                        $args = array(
                                                                                                                                                                                                                                            'role__in'  => array('wpcargo_client'),
                                                                                                                                                                                                                                            'orderby'   => 'display_name',
                                                                                                                                                                                                                                            'order'     => 'ASC'
                                                                                                                                                                                                                                        );
                                                                                                                                                                                                                                        $args = apply_filters('wpcfe_get_clients_arguments', $args);
                                                                                                                                                                                                                                        $users  = array();
                                                                                                                                                                                                                                        if (!empty(get_users($args))) {
                                                                                                                                                                                                                                            foreach (get_users($args) as $user) {
                                                                                                                                                                                                                                                $users[$user->ID] = $wpcargo->user_fullname($user->ID);
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return $users;
                                                                                                                                                                                                                                    }

                                                                                                                                                                                                                                    function wpcfe_get_cfsections_opt()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        return !empty(get_option('wpcargo_cf_option_settings')) ? get_option('wpcargo_cf_option_settings') : array();
                                                                                                                                                                                                                                    }

                                                                                                                                                                                                                                    function wpcfe_get_shipment_sections()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        global $wpdb;
                                                                                                                                                                                                                                        $sections           = $wpdb->get_col("SELECT `section` FROM `{$wpdb->prefix}wpcargo_custom_fields` GROUP BY `section` ORDER BY `weight`");
                                                                                                                                                                                                                                        $formatted_section  = array();
                                                                                                                                                                                                                                        $cfsections_opt     = wpcfe_get_cfsections_opt();
                                                                                                                                                                                                                                        if (!empty($sections)) {
                                                                                                                                                                                                                                            foreach ($sections as $section) {

                                                                                                                                                                                                                                                if (array_key_exists('wpc_cf_disable_shipper', $cfsections_opt) && $section == 'shipper_info') {
                                                                                                                                                                                                                                                    continue;
                                                                                                                                                                                                                                                }
                                                                                                                                                                                                                                                if (array_key_exists('wpc_cf_disable_receiver', $cfsections_opt) && $section == 'receiver_info') {
                                                                                                                                                                                                                                                    continue;
                                                                                                                                                                                                                                                }
                                                                                                                                                                                                                                                if (array_key_exists('wpc_cf_disable_shipment', $cfsections_opt) && $section == 'shipment_info') {
                                                                                                                                                                                                                                                    continue;
                                                                                                                                                                                                                                                }

                                                                                                                                                                                                                                                $header = '';
                                                                                                                                                                                                                                                if ($section == 'shipper_info') {
                                                                                                                                                                                                                                                    $header = apply_filters('wpcfe_shipper_label', __('Shipper Information', 'wpcargo-frontend-manager'));
                                                                                                                                                                                                                                                } elseif ($section == 'receiver_info') {
                                                                                                                                                                                                                                                    $header = apply_filters('wpcfe_receiver_label', __('Receiver Information', 'wpcargo-frontend-manager'));
                                                                                                                                                                                                                                                } elseif ($section == 'shipment_info') {
                                                                                                                                                                                                                                                    $header = apply_filters('wpcfe_shipment_label', __('Shipment Information', 'wpcargo-frontend-manager'));
                                                                                                                                                                                                                                                } else {
                                                                                                                                                                                                                                                    $header = ucwords(str_replace('_', ' ', $section));
                                                                                                                                                                                                                                                }
                                                                                                                                                                                                                                                $formatted_section[$section] = $header;
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                        }


                                                                                                                                                                                                                                        return apply_filters('wpcfe_shipment_sections', $formatted_section);
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function  wpcfe_get_shipment_type($shipment_id)
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $shipment_type                 = get_post_meta($shipment_id, '__shipment_type', true) ? get_post_meta($shipment_id, '__shipment_type', true) : '';
                                                                                                                                                                                                                                        $shipment_type_list         = wpcfe_shipment_type_list();
                                                                                                                                                                                                                                        $shipment_type_label        = isset($shipment_type_list[$shipment_type]) ? $shipment_type_list[$shipment_type] : __('Default', 'wpcargo-frontend-manager');
                                                                                                                                                                                                                                        return $shipment_type_label;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_dashboard_logo_url()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        global $wpcargo;
                                                                                                                                                                                                                                        $logo_url = WPCFE_URL . 'assets/images/wpcargo-logo.png';
                                                                                                                                                                                                                                        if ($wpcargo->logo) {
                                                                                                                                                                                                                                            $logo_url = $wpcargo->logo;
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return $logo_url;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    // Multiple Package settings
                                                                                                                                                                                                                                    function wpcfe_mpack_enable()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $options = get_option('wpc_mp_settings');
                                                                                                                                                                                                                                        if (!empty($options) && array_key_exists('wpc_mp_enable_admin', $options)) {
                                                                                                                                                                                                                                            return true;
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return false;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_mpack_dim_enable()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $options = get_option('wpc_mp_settings');
                                                                                                                                                                                                                                        if (!empty($options) && array_key_exists('wpc_mp_enable_dimension_unit', $options)) {
                                                                                                                                                                                                                                            return true;
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return false;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_mpack_dim_unit()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $options = get_option('wpc_mp_settings');
                                                                                                                                                                                                                                        if (!empty($options) && array_key_exists('wpc_mp_dimension_unit', $options)) {
                                                                                                                                                                                                                                            return !empty($options['wpc_mp_dimension_unit']) ? $options['wpc_mp_dimension_unit'] : 'cm';
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return 'cm';
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_mpack_weight_unit()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $options = get_option('wpc_mp_settings');
                                                                                                                                                                                                                                        if (!empty($options) && array_key_exists('wpc_mp_weight_unit', $options)) {
                                                                                                                                                                                                                                            return !empty($options['wpc_mp_weight_unit']) ? $options['wpc_mp_weight_unit'] : 'kg';
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return 'lbs';
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_mpack_piece_type()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $options = get_option('wpc_mp_settings');
                                                                                                                                                                                                                                        if (!empty($options) && array_key_exists('wpc_mp_piece_type', $options)) {
                                                                                                                                                                                                                                            if (!empty($options['wpc_mp_piece_type'])) {
                                                                                                                                                                                                                                                return array_filter(array_map('trim', explode(',', $options['wpc_mp_piece_type'])));
                                                                                                                                                                                                                                            } else {
                                                                                                                                                                                                                                                return array();
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return array();
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_report_status()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        global $wpcargo;
                                                                                                                                                                                                                                        $status = apply_filters('wpcfe_report_status', $wpcargo->status);
                                                                                                                                                                                                                                        return $status;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_admin_page()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $wpcfe_admin = get_option('wpcfe_admin');
                                                                                                                                                                                                                                        if (wpcfe_has_wpml()) {
                                                                                                                                                                                                                                            global $wpdb;
                                                                                                                                                                                                                                            $current_language = ICL_LANGUAGE_CODE;
                                                                                                                                                                                                                                            $langs = icl_get_languages('skip_missing=0&orderby=KEY&order=DIR&link_empty_to=str');
                                                                                                                                                                                                                                            if ($current_language != 'en') {
                                                                                                                                                                                                                                                $original_page = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}icl_translations WHERE element_id = $wpcfe_admin", OBJECT);
                                                                                                                                                                                                                                                $translated_page = $wpdb->get_row("SELECT * FROM " . $wpdb->prefix . "icl_translations WHERE trid=" . $original_page->trid . " AND language_code='" . $current_language . "'", OBJECT);
                                                                                                                                                                                                                                                $wpcfe_admin = $translated_page->element_id;
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return $wpcfe_admin;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_customfont_enable()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $wpcfe_customfont_enable = get_option('wpcfe_customfont_enable') ? get_option('wpcfe_customfont_enable') : false;
                                                                                                                                                                                                                                        return $wpcfe_customfont_enable;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_bol_enable()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $wpcfe_bol_enable = get_option('wpcfe_bol_enable') ? get_option('wpcfe_bol_enable') : false;
                                                                                                                                                                                                                                        return $wpcfe_bol_enable;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_rtl_enable()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $wpcfe_rtl_enable = get_option('wpcfe_rtl_enable') ? get_option('wpcfe_rtl_enable') : false;
                                                                                                                                                                                                                                        return $wpcfe_rtl_enable;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_add_shipment_deactivated()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $add_shipment_active = get_option('wpcfe_add_shipment_deactivated') ? get_option('wpcfe_add_shipment_deactivated') : false;
                                                                                                                                                                                                                                        return $add_shipment_active;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_employee_all_access()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $all_access = get_option('wpcfe_employee_all_access') ? get_option('wpcfe_employee_all_access') : false;
                                                                                                                                                                                                                                        return $all_access;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_client_can_add_shipment()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $return = get_option('wpcfe_client_can_add_shipment') ? get_option('wpcfe_client_can_add_shipment') : false;
                                                                                                                                                                                                                                        return $return;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_default_status()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        global $wpcargo;
                                                                                                                                                                                                                                        $falldown_status = array_shift($wpcargo->status);
                                                                                                                                                                                                                                        $return = get_option('wpcfe_default_status') ? get_option('wpcfe_default_status') : $falldown_status;
                                                                                                                                                                                                                                        return $return;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_waybill_paper_size()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $paper_size = get_option('wpcfe_waybill_paper_size') ? get_option('wpcfe_waybill_paper_size') : 'A4';
                                                                                                                                                                                                                                        return $paper_size;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_waybill_paper_orient()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $paper_orient = get_option('wpcfe_waybill_paper_orient') ? get_option('wpcfe_waybill_paper_orient') : 'portrait';
                                                                                                                                                                                                                                        return $paper_orient;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_add_shipment_role()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $roles = array('wpcargo_employee', 'administrator');
                                                                                                                                                                                                                                        if (wpcfe_client_can_add_shipment()) {
                                                                                                                                                                                                                                            $roles[] = 'wpcargo_client';
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return apply_filters('wpcfe_add_shipment_role', $roles);
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_update_shipment_role()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $update_shipment_role = get_option('wpcfe_update_shipment_role') ? get_option('wpcfe_update_shipment_role') : array('wpcargo_employee');
                                                                                                                                                                                                                                        return $update_shipment_role;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_delete_shipment_role()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $delete_shipment_role = get_option('wpcfe_delete_shipment_role') ? get_option('wpcfe_delete_shipment_role') : array('wpcargo_employee');
                                                                                                                                                                                                                                        return $delete_shipment_role;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_access_dashboard_role()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $access_dashboard_role = get_option('wpcfe_access_dashboard_role') ? get_option('wpcfe_access_dashboard_role') : array('wpcargo_employee', 'cargo_agent', 'wpcargo_client');
                                                                                                                                                                                                                                        return $access_dashboard_role;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_current_user_role()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $current_user   = wp_get_current_user();
                                                                                                                                                                                                                                        $user_roles     = $current_user->roles;
                                                                                                                                                                                                                                        return $user_roles;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_get_shipment_history($shipment_id, $rows = 12)
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        global $wpcargo;
                                                                                                                                                                                                                                        $history = !empty($wpcargo->history($shipment_id)) ? array_slice(array_reverse($wpcargo->history($shipment_id)), 0, $rows) : array();
                                                                                                                                                                                                                                        return $history;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_get_shipment_status($shipment_id)
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        return get_post_meta($shipment_id, 'wpcargo_status', true);
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function get_wpcfe_order_shipment_number($order_id)
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        if (!(int)$order_id) {
                                                                                                                                                                                                                                            return false;
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        $order         = wc_get_order($order_id);
                                                                                                                                                                                                                                        $items         = $order->get_items();
                                                                                                                                                                                                                                        if (empty($items)) {
                                                                                                                                                                                                                                            return false;
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        foreach ($items as $item) {
                                                                                                                                                                                                                                            if (empty($item->get_meta_data())) {
                                                                                                                                                                                                                                                return false;
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                            $shipment =  $item->get_meta_data()[0]->value;
                                                                                                                                                                                                                                            if (is_wpcfe_shipment($shipment)) {
                                                                                                                                                                                                                                                return get_the_title($shipment);
                                                                                                                                                                                                                                            } elseif (wpcfe_shipment_id($shipment)) {
                                                                                                                                                                                                                                                return $shipment;
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                            return false;
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function is_wpcfe_shipment($id)
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        global $wpdb;
                                                                                                                                                                                                                                        $sql     = "SELECT `ID` FROM {$wpdb->posts} WHERE `post_status` LIKE 'publish' AND `post_type` LIKE 'wpcargo_shipment' AND `ID` = %d LIMIT 1";
                                                                                                                                                                                                                                        $result = $wpdb->get_var($wpdb->prepare($sql, $id));
                                                                                                                                                                                                                                        return $result;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_shipment_id($shipment_number)
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        global $wpdb;
                                                                                                                                                                                                                                        $sql    = "SELECT `ID` FROM {$wpdb->posts} WHERE `post_status` LIKE 'publish' AND `post_type` LIKE 'wpcargo_shipment' AND `post_title` = %s LIMIT 1";
                                                                                                                                                                                                                                        $result = $wpdb->get_var($wpdb->prepare($sql, $shipment_number));
                                                                                                                                                                                                                                        return $result;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_get_field_list()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        global $wpdb;
                                                                                                                                                                                                                                        $fields = $wpdb->get_results("SELECT `field_key`, `label` FROM `{$wpdb->prefix}wpcargo_custom_fields`");
                                                                                                                                                                                                                                        return $fields;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function is_user_shipment($shipment_id)
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $user_roles = wpcfe_current_user_role();
                                                                                                                                                                                                                                        $result = false;
                                                                                                                                                                                                                                        if (wpcfe_is_super_admin()) {
                                                                                                                                                                                                                                            $result = true;
                                                                                                                                                                                                                                        } elseif (in_array('wpcargo_branch_manager', $user_roles)) { // wpcargo_branch_manager
                                                                                                                                                                                                                                            $user_branch   = get_user_meta(get_current_user_id(), 'wpc_user_branch', true);
                                                                                                                                                                                                                                            $user_branch   = ($user_branch) ? $user_branch : 0;
                                                                                                                                                                                                                                            $shipment_branch = get_post_meta($shipment_id, 'shipment_branch', true);
                                                                                                                                                                                                                                            if ($shipment_branch == $user_branch) {
                                                                                                                                                                                                                                                $result = true;
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                        } elseif (in_array('cargo_agent', $user_roles)) {
                                                                                                                                                                                                                                            $cargo_agent = get_post_meta($shipment_id, 'agent_fields', true);
                                                                                                                                                                                                                                            if ($cargo_agent == get_current_user_id()) {
                                                                                                                                                                                                                                                $result = true;
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                        } elseif (in_array('wpcargo_driver', $user_roles)) {
                                                                                                                                                                                                                                            $wpcargo_driver = get_post_meta($shipment_id, 'wpcargo_driver', true);
                                                                                                                                                                                                                                            if ($wpcargo_driver == get_current_user_id()) {
                                                                                                                                                                                                                                                $result = true;
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                        } elseif (in_array('wpcargo_client', $user_roles)) {
                                                                                                                                                                                                                                            $registered_shipper = get_post_meta($shipment_id, 'registered_shipper', true);
                                                                                                                                                                                                                                            if ($registered_shipper == get_current_user_id()) {
                                                                                                                                                                                                                                                $result = true;
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                        } elseif (in_array('wpcargo_employee', $user_roles)) {
                                                                                                                                                                                                                                            $registered_employee = get_post_meta($shipment_id, 'wpcargo_employee', true);
                                                                                                                                                                                                                                            if ($registered_employee == get_current_user_id()) {
                                                                                                                                                                                                                                                $result = true;
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return apply_filters('wpcfe_is_user_shipment', $result, $shipment_id);
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_is_super_admin()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $user_roles     = wpcfe_current_user_role();
                                                                                                                                                                                                                                        $admin_role     = array('administrator', 'editor');
                                                                                                                                                                                                                                        if (wpcfe_employee_all_access()) {
                                                                                                                                                                                                                                            $admin_role[] = 'wpcargo_employee';
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        $admin_role     = apply_filters('wpcfe_super_admin_roles', $admin_role);
                                                                                                                                                                                                                                        $result         = false;
                                                                                                                                                                                                                                        if (array_intersect($admin_role, $user_roles)) {
                                                                                                                                                                                                                                            $result = true;
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return $result;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function can_wpcfe_add_shipment()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $user_roles     = wpcfe_current_user_role();
                                                                                                                                                                                                                                        $result         = false;
                                                                                                                                                                                                                                        if (array_intersect(wpcfe_add_shipment_role(), $user_roles)) {
                                                                                                                                                                                                                                            $result = true;
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return $result;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function can_wpcfe_update_shipment()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $user_roles     = wpcfe_current_user_role();
                                                                                                                                                                                                                                        $result         = false;
                                                                                                                                                                                                                                        if (array_intersect(wpcfe_update_shipment_role(), $user_roles) || in_array('administrator', $user_roles)) {
                                                                                                                                                                                                                                            $result = true;
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return $result;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function can_wpcfe_delete_shipment()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $user_roles     = wpcfe_current_user_role();
                                                                                                                                                                                                                                        $result         = false;
                                                                                                                                                                                                                                        if (array_intersect(wpcfe_delete_shipment_role(), $user_roles) || in_array('administrator', $user_roles)) {
                                                                                                                                                                                                                                            $result = true;
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return $result;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function can_wpcfe_access_dashboard()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $user_roles     = wpcfe_current_user_role();
                                                                                                                                                                                                                                        $result         = false;
                                                                                                                                                                                                                                        if (array_intersect(wpcfe_access_dashboard_role(), $user_roles) || in_array('administrator', $user_roles)) {
                                                                                                                                                                                                                                            $result = true;
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return $result;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_assign_driver_roles()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        return apply_filters('wpcfe_assign_driver_roles', array('wpcargo_employee', 'administrator', 'cargo_agent', 'wpcargo_branch_manager'));
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_assign_manager()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        return apply_filters('wpcfe_assign_manager', array('wpcargo_employee', 'administrator'));
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_assign_agent()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        return apply_filters('wpcfe_assign_agent', array('wpcargo_employee', 'administrator', 'wpcargo_branch_manager'));
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_assign_client()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        return apply_filters('wpcfe_assign_client', array('wpcargo_employee', 'administrator', 'wpcargo_branch_manager'));
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_can_edit_fields_roles()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        return apply_filters('wpcfe_can_edit_fields_roles', array('wpcargo_employee', 'administrator', 'wpcargo_branch_manager'));
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_can_edit_fields()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        if (array_intersect(wpcfe_can_edit_fields_roles(), wpcfe_current_user_role())) {
                                                                                                                                                                                                                                            return true;
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return false;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function can_wpcfe_assign_agent()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        // if (array_intersect(wpcfe_assign_agent(), wpcfe_current_user_role())) {
                                                                                                                                                                                                                                        //     return true;
                                                                                                                                                                                                                                        // }
                                                                                                                                                                                                                                        return false;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function can_wpcfe_assign_client()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        if (array_intersect(wpcfe_assign_client(), wpcfe_current_user_role())) {
                                                                                                                                                                                                                                            return true;
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return false;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function can_wpcfe_assign_manager()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        if (array_intersect(wpcfe_assign_manager(), wpcfe_current_user_role())) {
                                                                                                                                                                                                                                            return true;
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return false;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function can_wpcfe_assign_driver()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        if (array_intersect(wpcfe_assign_driver_roles(), wpcfe_current_user_role())) {
                                                                                                                                                                                                                                            return true;
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return false;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_shipment_type_list()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $shipment_type = array(
                                                                                                                                                                                                                                            'wpcargo_default' => __('Default', 'wpcargo-frontend-manager')
                                                                                                                                                                                                                                        );
                                                                                                                                                                                                                                        return apply_filters('wpcfe_shipment_type_list', $shipment_type);
                                                                                                                                                                                                                                    }

                                                                                                                                                                                                                                    /*
 * Save shipment information
 * Parameter
 * @ data - POST value ( array() )
 * @ shipment_id =  post id
 */
                                                                                                                                                                                                                                    function wpcfe_save_shipment($data, $shipment_id = 0)
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        global $wpcargo, $WPCCF_Fields;
                                                                                                                                                                                                                                        $meta_keys       = $WPCCF_Fields->get_field_key_list();
                                                                                                                                                                                                                                        if ($shipment_id) {
                                                                                                                                                                                                                                            $shipment_number = apply_filters('wpcfe_shipment_number_update',  get_the_title($shipment_id), $data);
                                                                                                                                                                                                                                        } else {
                                                                                                                                                                                                                                            $shipment_number = apply_filters('wpcfe_shipment_number',  $wpcargo->create_shipment_number(), $data);
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        if ($shipment_id) {
                                                                                                                                                                                                                                            // Create post object
                                                                                                                                                                                                                                            $shipment_arg = array(
                                                                                                                                                                                                                                                'ID'           => $shipment_id,
                                                                                                                                                                                                                                                'post_title'    => wp_strip_all_tags(sanitize_text_field($shipment_number)),
                                                                                                                                                                                                                                            );
                                                                                                                                                                                                                                            $post_id = wp_update_post($shipment_arg);
                                                                                                                                                                                                                                        } else {
                                                                                                                                                                                                                                            // Create post object
                                                                                                                                                                                                                                            $shipment_arg = array(
                                                                                                                                                                                                                                                'post_title'    => wp_strip_all_tags(sanitize_text_field($shipment_number)),
                                                                                                                                                                                                                                                'post_type'     => 'wpcargo_shipment',
                                                                                                                                                                                                                                                'post_status'   => 'publish',
                                                                                                                                                                                                                                            );
                                                                                                                                                                                                                                            // Insert the post into the database
                                                                                                                                                                                                                                            $post_id = wp_insert_post($shipment_arg);
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        if ($post_id && !empty($meta_keys) && (wpcfe_can_edit_fields() || can_wpcfe_add_shipment())) {
                                                                                                                                                                                                                                            foreach ($data as $key => $value) {
                                                                                                                                                                                                                                                // Check if meta key exist
                                                                                                                                                                                                                                                if (!in_array($key, $meta_keys)) {
                                                                                                                                                                                                                                                    continue;
                                                                                                                                                                                                                                                }
                                                                                                                                                                                                                                                $value = maybe_serialize($value);
                                                                                                                                                                                                                                                update_post_meta($post_id, $key, sanitize_text_field($value));
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                            do_action('after_wpcfe_save_shipment', $post_id, $data);
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        if ($post_id) {
                                                                                                                                                                                                                                            $_POST['wpcfe-notification'] = array(
                                                                                                                                                                                                                                                'status'    => 'success',
                                                                                                                                                                                                                                                'icon'      => 'check',
                                                                                                                                                                                                                                                'message'   => __('Shipment ', 'wpcargo-frontend-manager') . ' ' . get_the_title($post_id) . ' ' . __(' has been successfully saved.', 'wpcargo-frontend-manager')
                                                                                                                                                                                                                                            );
                                                                                                                                                                                                                                        } else {
                                                                                                                                                                                                                                            $_POST['wpcfe-notification'] = array(
                                                                                                                                                                                                                                                'status'    => 'danger',
                                                                                                                                                                                                                                                'icon'      => 'exclamation',
                                                                                                                                                                                                                                                'message'   => __('Something went wrong saving your shipment. Please reload and try again', 'wpcargo-frontend-manager')
                                                                                                                                                                                                                                            );
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    /*
 * Display table header
 * Parameter
 * @ shipper
 * @ receiver
 */
                                                                                                                                                                                                                                    function wpcfe_table_header($section)
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $shipper_column = get_option($section . '_column');
                                                                                                                                                                                                                                        $header_data    = array();
                                                                                                                                                                                                                                        if (!$shipper_column) {
                                                                                                                                                                                                                                            if ($section == 'shipper') {
                                                                                                                                                                                                                                                $header_data = array(
                                                                                                                                                                                                                                                    'label' => __('Shipper Name', 'wpcargo-frontend-manager'),
                                                                                                                                                                                                                                                    'field_key' => 'wpcargo_shipper_name'
                                                                                                                                                                                                                                                );
                                                                                                                                                                                                                                            } elseif ($section == 'receiver') {
                                                                                                                                                                                                                                                $header_data = array(
                                                                                                                                                                                                                                                    'label' => __('Receiver Name', 'wpcargo-frontend-manager'),
                                                                                                                                                                                                                                                    'field_key' => 'wpcargo_receiver_name'
                                                                                                                                                                                                                                                );
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                        } else {
                                                                                                                                                                                                                                            if (function_exists('wpccf_get_field_by_metakey')) {
                                                                                                                                                                                                                                                $header_data = wpccf_get_field_by_metakey($shipper_column);
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return $header_data;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    /*
 * get Options metadata
 */
                                                                                                                                                                                                                                    function wpcfe_get_meta_values($key = '', $value = '', $type = 'wpcargo_shipment', $status = 'publish')
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        global $wpdb;
                                                                                                                                                                                                                                        if (empty($key)) {
                                                                                                                                                                                                                                            return;
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        $value = '%' . $value . '%';
                                                                                                                                                                                                                                        $sql = $wpdb->prepare("
        SELECT pm.meta_value FROM {$wpdb->postmeta} pm
        LEFT JOIN {$wpdb->posts} p ON p.ID = pm.post_id
        WHERE pm.meta_key = '%s'
        AND pm.meta_value LIKE '%s'
        AND p.post_status = '%s'
        AND p.post_type = '%s'
        GROUP BY pm.meta_value
    ", $key, $value, $status, $type);
                                                                                                                                                                                                                                        $r = $wpdb->get_col($sql);
                                                                                                                                                                                                                                        return $r;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    // My Account Functions
                                                                                                                                                                                                                                    function wpcfe_user_avatar($size = 128, $class = "photo-inner")
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $current_user = wp_get_current_user();
                                                                                                                                                                                                                                        echo get_avatar($current_user->ID, $size, '', '', array('class' => $class));
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_user_avatar_url()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $current_user       = wp_get_current_user();
                                                                                                                                                                                                                                        $wpcdm_user_avatar  = get_user_meta($current_user->ID, 'wpcargo_user_avatar', true);
                                                                                                                                                                                                                                        return $wpcdm_user_avatar;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    // Dashboard filter query
                                                                                                                                                                                                                                    function wpcfe_save_report($shipment_id, $from_status = '', $to_status = '')
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        global $wpcargo, $wpdb;
                                                                                                                                                                                                                                        if (($from_status == $to_status) || empty($to_status)) {
                                                                                                                                                                                                                                            return false;
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        $current_date   = current_time('mysql');
                                                                                                                                                                                                                                        $save_repost    = $wpdb->insert(
                                                                                                                                                                                                                                            $wpdb->prefix . WPCFE_DB_REPORTS,
                                                                                                                                                                                                                                            array(
                                                                                                                                                                                                                                                'post_id'         => $shipment_id,
                                                                                                                                                                                                                                                'post_date'     => $current_date,
                                                                                                                                                                                                                                                'from_status'   => $from_status,
                                                                                                                                                                                                                                                'to_status'     => $to_status,
                                                                                                                                                                                                                                                'updated_by'    => $wpcargo->user_fullname(get_current_user_id())
                                                                                                                                                                                                                                            ),
                                                                                                                                                                                                                                            array(
                                                                                                                                                                                                                                                '%d', '%s', '%s', '%s', '%s'
                                                                                                                                                                                                                                            )
                                                                                                                                                                                                                                        );
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_get_report_count($date, $status)
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        global $wpcargo, $wpdb;
                                                                                                                                                                                                                                        $parameter  = array("Paid");
                                                                                                                                                                                                                                        $user_roles = wpcfe_current_user_role();
                                                                                                                                                                                                                                        $date_start = $date . ' 00:00:00';
                                                                                                                                                                                                                                        $date_end   = $date . ' 23:59:59';
                                                                                                                                                                                                                                        $parameter  = array($date_start, $date_end, $status);
                                                                                                                                                                                                                                        $tbl_reports = $wpdb->prefix . WPCFE_DB_REPORTS;
                                                                                                                                                                                                                                        $sql = "SELECT count(*) FROM {$tbl_reports} AS tbl1 
            LEFT JOIN {$wpdb->prefix}posts AS tbl2 on tbl2.ID = tbl1.post_id";
                                                                                                                                                                                                                                        if (!wpcfe_is_super_admin()) {
                                                                                                                                                                                                                                            $sql .= " LEFT JOIN  `{$wpdb->prefix}postmeta` AS tbl3 ON tbl1.post_id = tbl3.post_id ";
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        $sql .= " WHERE tbl1.post_date BETWEEN %s AND %s
            AND tbl1.to_status LIKE %s";

                                                                                                                                                                                                                                        if (!wpcfe_is_super_admin()) {
                                                                                                                                                                                                                                            $meta_key = 'registered_shipper';
                                                                                                                                                                                                                                            if (in_array('wpcargo_branch_manager', $user_roles)) {
                                                                                                                                                                                                                                                $meta_key = 'wpcargo_branch_manager';
                                                                                                                                                                                                                                            } elseif (in_array('cargo_agent', $user_roles)) {
                                                                                                                                                                                                                                                $meta_key = 'agent_fields';
                                                                                                                                                                                                                                            } elseif (in_array('wpcargo_driver', $user_roles)) {
                                                                                                                                                                                                                                                $meta_key = 'wpcargo_driver';
                                                                                                                                                                                                                                            } elseif (in_array('wpcargo_employee', $user_roles)) {
                                                                                                                                                                                                                                                $meta_key = 'wpcargo_employee';
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                            $sql .= " AND tbl3.meta_key LIKE %s AND tbl3.meta_value = %d";
                                                                                                                                                                                                                                            $parameter[] = $meta_key;
                                                                                                                                                                                                                                            $parameter[] = get_current_user_id();
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        $prepared_sql   = $wpdb->prepare($sql, $parameter);
                                                                                                                                                                                                                                        $prepared_sql   = apply_filters('wpcfe_get_report_count_sql', $prepared_sql, $status, $date);
                                                                                                                                                                                                                                        return $wpdb->get_var($prepared_sql);
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_get_all_shipment_count()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        global $wpdb;
                                                                                                                                                                                                                                        $user_roles = wpcfe_current_user_role();
                                                                                                                                                                                                                                        $parameter  = array('wpcargo_shipment');
                                                                                                                                                                                                                                        $sql = "SELECT count(tbl1.ID) 
        FROM `{$wpdb->prefix}posts` AS tbl1";
                                                                                                                                                                                                                                        if (!wpcfe_is_super_admin()) {
                                                                                                                                                                                                                                            $sql .= " LEFT JOIN  `{$wpdb->prefix}postmeta` AS tbl2 ON tbl1.ID = tbl2.post_id";
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        $sql .= " WHERE tbl1.post_status LIKE 'publish' 
        AND tbl1.post_type  LIKE %s";
                                                                                                                                                                                                                                        if (!wpcfe_is_super_admin()) {
                                                                                                                                                                                                                                            $meta_key = 'registered_shipper';
                                                                                                                                                                                                                                            if (in_array('wpcargo_branch_manager', $user_roles)) {
                                                                                                                                                                                                                                                $meta_key = 'wpcargo_branch_manager';
                                                                                                                                                                                                                                            } elseif (in_array('cargo_agent', $user_roles)) {
                                                                                                                                                                                                                                                $meta_key = 'agent_fields';
                                                                                                                                                                                                                                            } elseif (in_array('wpcargo_driver', $user_roles)) {
                                                                                                                                                                                                                                                $meta_key = 'wpcargo_driver';
                                                                                                                                                                                                                                            } elseif (in_array('wpcargo_employee', $user_roles)) {
                                                                                                                                                                                                                                                $meta_key = 'wpcargo_employee';
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                            $sql .= " AND tbl2.meta_key LIKE %s AND tbl2.meta_value = %d";
                                                                                                                                                                                                                                            $parameter[] = $meta_key;
                                                                                                                                                                                                                                            $parameter[] = get_current_user_id();
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        $prepared_sql   = $wpdb->prepare($sql, $parameter);
                                                                                                                                                                                                                                        $prepared_sql   = apply_filters('wpcfe_get_all_shipment_count_sql', $prepared_sql, $parameter);
                                                                                                                                                                                                                                        return $wpdb->get_var($prepared_sql);
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_get_shipment_status_count($status)
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        global $wpdb;
                                                                                                                                                                                                                                        $user_roles = wpcfe_current_user_role();
                                                                                                                                                                                                                                        $parameter  = array($status);
                                                                                                                                                                                                                                        $sql = "SELECT count(tbl1.ID)
        FROM `{$wpdb->prefix}posts` AS tbl1 
        LEFT JOIN  `{$wpdb->prefix}postmeta` AS tbl2 ON tbl1.ID = tbl2.post_id";
                                                                                                                                                                                                                                        if (!wpcfe_is_super_admin()) {
                                                                                                                                                                                                                                            $sql .= " LEFT JOIN  `{$wpdb->prefix}postmeta` AS tbl3 ON tbl1.ID = tbl3.post_id";
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        $sql .= " WHERE tbl1.post_status LIKE 'publish' 
        AND tbl1.post_type  LIKE 'wpcargo_shipment' 
        AND tbl2.meta_key  LIKE 'wpcargo_status' 
        AND tbl2.meta_value  LIKE %s";

                                                                                                                                                                                                                                        if (!wpcfe_is_super_admin()) {
                                                                                                                                                                                                                                            $meta_key = 'registered_shipper';
                                                                                                                                                                                                                                            if (in_array('wpcargo_branch_manager', $user_roles)) {
                                                                                                                                                                                                                                                $meta_key = 'wpcargo_branch_manager';
                                                                                                                                                                                                                                            } elseif (in_array('cargo_agent', $user_roles)) {
                                                                                                                                                                                                                                                $meta_key = 'agent_fields';
                                                                                                                                                                                                                                            } elseif (in_array('wpcargo_driver', $user_roles)) {
                                                                                                                                                                                                                                                $meta_key = 'wpcargo_driver';
                                                                                                                                                                                                                                            } elseif (in_array('wpcargo_employee', $user_roles)) {
                                                                                                                                                                                                                                                $meta_key = 'wpcargo_employee';
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                            $sql .= " AND tbl3.meta_key LIKE %s AND tbl3.meta_value = %d";
                                                                                                                                                                                                                                            $parameter[] = $meta_key;
                                                                                                                                                                                                                                            $parameter[] = get_current_user_id();
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        $prepared_sql   = $wpdb->prepare($sql, $parameter);
                                                                                                                                                                                                                                        $prepared_sql   = apply_filters('wpcfe_get_shipment_status_count_sql', $prepared_sql, $status);

                                                                                                                                                                                                                                        return $wpdb->get_var($prepared_sql);
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_dashboard_meta_query_filter_callback($meta_query)
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $user_roles = wpcfe_current_user_role();
                                                                                                                                                                                                                                        if (wpcfe_is_super_admin()) {
                                                                                                                                                                                                                                            //return $meta_query;
                                                                                                                                                                                                                                        } elseif (in_array('wpcargo_branch_manager', $user_roles)) { // wpcargo_branch_manager
                                                                                                                                                                                                                                            $user_branch   = get_user_meta(get_current_user_id(), 'wpc_user_branch', true);
                                                                                                                                                                                                                                            $user_branch   = ($user_branch) ? $user_branch : 0;
                                                                                                                                                                                                                                            $meta_query[]  = array(
                                                                                                                                                                                                                                                'key'       => 'wpcargo_branch_manager',
                                                                                                                                                                                                                                                'value'     => get_current_user_id(),
                                                                                                                                                                                                                                                'compare'   => '='
                                                                                                                                                                                                                                            );
                                                                                                                                                                                                                                        } elseif (in_array('cargo_agent', $user_roles)) {
                                                                                                                                                                                                                                            $meta_query[] = array(
                                                                                                                                                                                                                                                'key'       => 'agent_fields',
                                                                                                                                                                                                                                                'value'     => get_current_user_id(),
                                                                                                                                                                                                                                                'compare'   => '='
                                                                                                                                                                                                                                            );
                                                                                                                                                                                                                                        } elseif (in_array('wpcargo_driver', $user_roles)) {
                                                                                                                                                                                                                                            $meta_query[] = array(
                                                                                                                                                                                                                                                'key'       => 'wpcargo_driver',
                                                                                                                                                                                                                                                'value'     => get_current_user_id(),
                                                                                                                                                                                                                                                'compare'   => '='
                                                                                                                                                                                                                                            );
                                                                                                                                                                                                                                        } elseif (in_array('wpcargo_employee', $user_roles)) {
                                                                                                                                                                                                                                            $meta_query[] = array(
                                                                                                                                                                                                                                                'key'       => 'wpcargo_employee',
                                                                                                                                                                                                                                                'value'     => get_current_user_id(),
                                                                                                                                                                                                                                                'compare'   => '='
                                                                                                                                                                                                                                            );
                                                                                                                                                                                                                                        } else {
                                                                                                                                                                                                                                            $meta_query[] = array(
                                                                                                                                                                                                                                                'key'       => 'registered_shipper',
                                                                                                                                                                                                                                                'value'     => get_current_user_id(),
                                                                                                                                                                                                                                                'compare'   => '='
                                                                                                                                                                                                                                            );
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return $meta_query;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    add_filter('wpcfe_dashboard_meta_query', 'wpcfe_dashboard_meta_query_filter_callback', 10, 1);
                                                                                                                                                                                                                                    /**
                                                                                                                                                                                                                                     * WordPress Bootstrap Pagination
                                                                                                                                                                                                                                     */
                                                                                                                                                                                                                                    function wpcfe_bootstrap_pagination($args = array())
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $defaults = array(
                                                                                                                                                                                                                                            'range'           => 4,
                                                                                                                                                                                                                                            'custom_query'    => FALSE,
                                                                                                                                                                                                                                            'previous_string' => __('Previous', 'wpcargo-frontend-manager'),
                                                                                                                                                                                                                                            'next_string'     => __('Next', 'wpcargo-frontend-manager'),
                                                                                                                                                                                                                                            'before_output'   => '<nav class="post-nav" aria-label="' . __('Shipment Pagination', 'wpcargo-frontend-manager') . '"><ul class="pagination pg-blue justify-content-center">',
                                                                                                                                                                                                                                            'after_output'    => '</ul></nav>'
                                                                                                                                                                                                                                        );

                                                                                                                                                                                                                                        $args = wp_parse_args(
                                                                                                                                                                                                                                            $args,
                                                                                                                                                                                                                                            apply_filters('wp_bootstrap_pagination_defaults', $defaults)
                                                                                                                                                                                                                                        );

                                                                                                                                                                                                                                        $args['range'] = (int) $args['range'] - 1;
                                                                                                                                                                                                                                        if (!$args['custom_query'])
                                                                                                                                                                                                                                            $args['custom_query'] = @$GLOBALS['wp_query'];
                                                                                                                                                                                                                                        $count = (int) $args['custom_query']->max_num_pages;
                                                                                                                                                                                                                                        $page  = intval(get_query_var('paged'));
                                                                                                                                                                                                                                        $ceil  = ceil($args['range'] / 2);

                                                                                                                                                                                                                                        if ($count <= 1)
                                                                                                                                                                                                                                            return FALSE;

                                                                                                                                                                                                                                        if (!$page)
                                                                                                                                                                                                                                            $page = 1;

                                                                                                                                                                                                                                        if ($count > $args['range']) {
                                                                                                                                                                                                                                            if ($page <= $args['range']) {
                                                                                                                                                                                                                                                $min = 1;
                                                                                                                                                                                                                                                $max = $args['range'] + 1;
                                                                                                                                                                                                                                            } elseif ($page >= ($count - $ceil)) {
                                                                                                                                                                                                                                                $min = $count - $args['range'];
                                                                                                                                                                                                                                                $max = $count;
                                                                                                                                                                                                                                            } elseif ($page >= $args['range'] && $page < ($count - $ceil)) {
                                                                                                                                                                                                                                                $min = $page - $ceil;
                                                                                                                                                                                                                                                $max = $page + $ceil;
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                        } else {
                                                                                                                                                                                                                                            $min = 1;
                                                                                                                                                                                                                                            $max = $count;
                                                                                                                                                                                                                                        }

                                                                                                                                                                                                                                        $echo = '';
                                                                                                                                                                                                                                        $previous = intval($page) - 1;
                                                                                                                                                                                                                                        $previous = esc_attr(get_pagenum_link($previous));

                                                                                                                                                                                                                                        $firstpage = esc_attr(get_pagenum_link(1));
                                                                                                                                                                                                                                        if ($firstpage && (1 != $page))
                                                                                                                                                                                                                                            $echo .= '<li class="previous page-item"><a class="page-link waves-effect waves-effect" href="' . $firstpage . '">' . __('First', 'wpcargo-frontend-manager') . '</a></li>';
                                                                                                                                                                                                                                        if ($previous && (1 != $page))
                                                                                                                                                                                                                                            $echo .= '<li class="page-item" ><a class="page-link waves-effect waves-effect" href="' . $previous . '" title="' . __('previous', 'wpcargo-frontend-manager') . '">' . $args['previous_string'] . '</a></li>';

                                                                                                                                                                                                                                        if (!empty($min) && !empty($max)) {
                                                                                                                                                                                                                                            for ($i = $min; $i <= $max; $i++) {
                                                                                                                                                                                                                                                if ($page == $i) {
                                                                                                                                                                                                                                                    $echo .= '<li class="page-item active"><span class="page-link waves-effect waves-effect">' . str_pad((int)$i, 2, '0', STR_PAD_LEFT) . '</span></li>';
                                                                                                                                                                                                                                                } else {
                                                                                                                                                                                                                                                    $echo .= sprintf('<li class="page-item"><a class="page-link waves-effect waves-effect" href="%s">%002d</a></li>', esc_attr(get_pagenum_link($i)), $i);
                                                                                                                                                                                                                                                }
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                        }

                                                                                                                                                                                                                                        $next = intval($page) + 1;
                                                                                                                                                                                                                                        $next = esc_attr(get_pagenum_link($next));
                                                                                                                                                                                                                                        if ($next && ($count != $page))
                                                                                                                                                                                                                                            $echo .= '<li class="page-item"><a class="page-link waves-effect waves-effect" href="' . $next . '" title="' . __('next', 'wpcargo-frontend-manager') . '">' . $args['next_string'] . '</a></li>';

                                                                                                                                                                                                                                        $lastpage = esc_attr(get_pagenum_link($count));
                                                                                                                                                                                                                                        if ($lastpage) {
                                                                                                                                                                                                                                            $echo .= '<li class="next page-item"><a class="page-link waves-effect waves-effect" href="' . $lastpage . '">' . __('Last', 'wpcargo-frontend-manager') . '</a></li>';
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        if (isset($echo))
                                                                                                                                                                                                                                            echo $args['before_output'] . $echo . $args['after_output'];
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_get_total_results()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        global $wpdb;
                                                                                                                                                                                                                                        $user_roles     = wpcfe_current_user_role();
                                                                                                                                                                                                                                        $shipper_data   = wpcfe_table_header('shipper');
                                                                                                                                                                                                                                        $receiver_data  = wpcfe_table_header('receiver');
                                                                                                                                                                                                                                        $add_shipment_role = wpcfe_add_shipment_role();
                                                                                                                                                                                                                                        if (($key = array_search('wpcargo_client', $add_shipment_role)) !== false) {
                                                                                                                                                                                                                                            unset($add_shipment_role[$key]);
                                                                                                                                                                                                                                        }

                                                                                                                                                                                                                                        // $sql = "SELECT tblPost.ID, tblPost.post_date, tblPost.post_title FROM `{$wpdb->prefix}posts` AS tblPost ";
                                                                                                                                                                                                                                        $sql = "SELECT tblPost.ID FROM `{$wpdb->prefix}posts` AS tblPost ";
                                                                                                                                                                                                                                        $sql .= "INNER JOIN `{$wpdb->prefix}postmeta` as tblMeta1 ON tblMeta1.post_id = tblPost.ID ";
                                                                                                                                                                                                                                        if (isset($_GET['shipper']) && !empty($_GET['shipper'])) {
                                                                                                                                                                                                                                            $sql .= "INNER JOIN `{$wpdb->prefix}postmeta` as tblMeta3 ON tblMeta3.post_id = tblPost.ID ";
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        if (isset($_GET['receiver']) && !empty($_GET['receiver'])) {
                                                                                                                                                                                                                                            $sql .= "INNER JOIN `{$wpdb->prefix}postmeta` as tblMeta4 ON tblMeta4.post_id = tblPost.ID ";
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        if (!array_intersect($add_shipment_role, $user_roles)) {
                                                                                                                                                                                                                                            $sql .= "INNER JOIN `{$wpdb->prefix}postmeta` as tblMeta5 ON tblMeta5.post_id = tblPost.ID ";
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        $sql .= "WHERE tblPost.post_type LIKE 'wpcargo_shipment' AND tblPost.post_status LIKE 'publish' ";
                                                                                                                                                                                                                                        if (isset($_GET['status']) && !empty($_GET['status'])) {
                                                                                                                                                                                                                                            $sql .= "AND tblMeta1.meta_key LIKE 'wpcargo_status' AND tblMeta1.meta_value IN ( '" . urldecode($_GET['status']) . "' ) ";
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        if (isset($_GET['shipper']) && !empty($_GET['shipper'])) {
                                                                                                                                                                                                                                            $sql .= "AND tblMeta3.meta_key LIKE 'registered_shipper' AND tblMeta3.meta_value = " . (int)$_GET['shipper'] . " ";
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        if (isset($_GET['receiver']) && !empty($_GET['receiver'])) {
                                                                                                                                                                                                                                            $sql .= "AND tblMeta4.meta_key LIKE '" . $receiver_data['field_key'] . "' AND tblMeta4.meta_value = " . (int)$_GET['receiver'] . " ";
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        if (array_intersect($add_shipment_role, $user_roles)) {
                                                                                                                                                                                                                                            $sql .= "";
                                                                                                                                                                                                                                        } elseif (in_array('wpcargo_branch_manager', $user_roles)) { // wpcargo_branch_manager
                                                                                                                                                                                                                                            $sql .= "AND tblMeta5.meta_key LIKE 'wpc_user_branch' AND tblMeta5.meta_value = " . get_current_user_id() . " ";
                                                                                                                                                                                                                                        } elseif (in_array('cargo_agent', $user_roles)) {
                                                                                                                                                                                                                                            $sql .= "AND tblMeta5.meta_key LIKE 'agent_fields' AND tblMeta5.meta_value = " . get_current_user_id() . " ";
                                                                                                                                                                                                                                        } elseif (in_array('wpcargo_driver', $user_roles)) {
                                                                                                                                                                                                                                            $sql .= "AND tblMeta5.meta_key LIKE 'wpcargo_driver' AND tblMeta5.meta_value = " . get_current_user_id() . " ";
                                                                                                                                                                                                                                        } else {
                                                                                                                                                                                                                                            $sql .= "AND tblMeta5.meta_key LIKE 'registered_shipper' AND tblMeta5.meta_value = " . get_current_user_id() . " ";
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        $sql .= "GROUP BY tblPost.ID ";

                                                                                                                                                                                                                                        return count($wpdb->get_col($sql));
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_include_template($file_name)
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $file_slug              = strtolower(preg_replace('/\s+/', '_', trim(str_replace('.tpl', '', $file_name))));
                                                                                                                                                                                                                                        $file_slug              = preg_replace('/[^A-Za-z0-9_]/', '_', $file_slug);
                                                                                                                                                                                                                                        $custom_template_path   = get_stylesheet_directory() . '/wpcargo/wpcargo-frontend-manager/' . $file_name . '.php';
                                                                                                                                                                                                                                        if (file_exists($custom_template_path)) {
                                                                                                                                                                                                                                            $template_path = $custom_template_path;
                                                                                                                                                                                                                                        } else {
                                                                                                                                                                                                                                            $template_path  = WPCFE_PATH . 'templates/' . $file_name . '.php';
                                                                                                                                                                                                                                            $template_path  = apply_filters("wpcfe_locate_template_{$file_slug}", $template_path);
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return $template_path;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_personal_info_fields()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $user_roles = wpcfe_current_user_role();
                                                                                                                                                                                                                                        $wpcfe_personal_info_fields = array(
                                                                                                                                                                                                                                            'first_name' => array(
                                                                                                                                                                                                                                                'id'            => 'first_name',
                                                                                                                                                                                                                                                'label'            => __('First Name', 'wpcargo-frontend-manager'),
                                                                                                                                                                                                                                                'field'            => 'text',
                                                                                                                                                                                                                                                'field_type'    => 'text',
                                                                                                                                                                                                                                                'required'        => false,
                                                                                                                                                                                                                                                'options'        => array(),
                                                                                                                                                                                                                                                'field_data'    => array(),
                                                                                                                                                                                                                                                'field_key'        => 'first_name'
                                                                                                                                                                                                                                            ),
                                                                                                                                                                                                                                            'last_name' => array(
                                                                                                                                                                                                                                                'id'            => 'last_name',
                                                                                                                                                                                                                                                'label'            => __('Last Name', 'wpcargo-frontend-manager'),
                                                                                                                                                                                                                                                'field'            => 'text',
                                                                                                                                                                                                                                                'field_type'    => 'text',
                                                                                                                                                                                                                                                'required'        => false,
                                                                                                                                                                                                                                                'options'        => array(),
                                                                                                                                                                                                                                                'field_data'    => array(),
                                                                                                                                                                                                                                                'field_key'        => 'last_name'
                                                                                                                                                                                                                                            ),
                                                                                                                                                                                                                                            'phone'     => array(
                                                                                                                                                                                                                                                'id'            => 'phone',
                                                                                                                                                                                                                                                'label'            => __('Phone', 'wpcargo-frontend-manager'),
                                                                                                                                                                                                                                                'field'            => 'text',
                                                                                                                                                                                                                                                'field_type'    => 'text',
                                                                                                                                                                                                                                                'required'        => false,
                                                                                                                                                                                                                                                'options'        => array(),
                                                                                                                                                                                                                                                'field_data'    => array(),
                                                                                                                                                                                                                                                'field_key'        => 'phone'
                                                                                                                                                                                                                                            )
                                                                                                                                                                                                                                        );
                                                                                                                                                                                                                                        return apply_filters('wpcfe_personal_info_fields', $wpcfe_personal_info_fields);
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_billing_address_fields()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $wpcfe_billing_address_fields = array(
                                                                                                                                                                                                                                            'billing_email' => array(
                                                                                                                                                                                                                                                'id'            => 'billing_email',
                                                                                                                                                                                                                                                'label'            => __('Email', 'wpcargo-frontend-manager'),
                                                                                                                                                                                                                                                'field'            => 'email',
                                                                                                                                                                                                                                                'field_type'    => 'email',
                                                                                                                                                                                                                                                'required'        => false,
                                                                                                                                                                                                                                                'options'        => array(),
                                                                                                                                                                                                                                                'field_data'    => array(),
                                                                                                                                                                                                                                                'field_key'        => 'billing_email'
                                                                                                                                                                                                                                            ),
                                                                                                                                                                                                                                            'billing_company' => array(
                                                                                                                                                                                                                                                'id'            => 'billing_company',
                                                                                                                                                                                                                                                'label'            => __('Company', 'wpcargo-frontend-manager'),
                                                                                                                                                                                                                                                'field'            => 'text',
                                                                                                                                                                                                                                                'field_type'    => 'text',
                                                                                                                                                                                                                                                'required'        => false,
                                                                                                                                                                                                                                                'options'        => array(),
                                                                                                                                                                                                                                                'field_data'    => array(),
                                                                                                                                                                                                                                                'field_key'        => 'billing_company'
                                                                                                                                                                                                                                            ),
                                                                                                                                                                                                                                            'billing_address_1' => array(
                                                                                                                                                                                                                                                'id'            => 'billing_address_1',
                                                                                                                                                                                                                                                'label'            => __('Address line 1', 'wpcargo-frontend-manager'),
                                                                                                                                                                                                                                                'field'            => 'text',
                                                                                                                                                                                                                                                'field_type'    => 'text',
                                                                                                                                                                                                                                                'required'        => false,
                                                                                                                                                                                                                                                'options'        => array(),
                                                                                                                                                                                                                                                'field_data'    => array(),
                                                                                                                                                                                                                                                'field_key'        => 'billing_address_1'
                                                                                                                                                                                                                                            ),
                                                                                                                                                                                                                                            'billing_address_2' => array(
                                                                                                                                                                                                                                                'id'            => 'billing_address_2',
                                                                                                                                                                                                                                                'label'            => __('Address line 2', 'wpcargo-frontend-manager'),
                                                                                                                                                                                                                                                'field'            => 'text',
                                                                                                                                                                                                                                                'field_type'    => 'text',
                                                                                                                                                                                                                                                'required'        => false,
                                                                                                                                                                                                                                                'options'        => array(),
                                                                                                                                                                                                                                                'field_data'    => array(),
                                                                                                                                                                                                                                                'field_key'        => 'billing_address_2'
                                                                                                                                                                                                                                            ),
                                                                                                                                                                                                                                            'billing_city' => array(
                                                                                                                                                                                                                                                'id'            => 'billing_city',
                                                                                                                                                                                                                                                'label'            => __('City', 'wpcargo-frontend-manager'),
                                                                                                                                                                                                                                                'field'            => 'text',
                                                                                                                                                                                                                                                'field_type'    => 'text',
                                                                                                                                                                                                                                                'required'        => false,
                                                                                                                                                                                                                                                'options'        => array(),
                                                                                                                                                                                                                                                'field_data'    => array(),
                                                                                                                                                                                                                                                'field_key'        => 'billing_city'
                                                                                                                                                                                                                                            ),
                                                                                                                                                                                                                                            'billing_postcode' => array(
                                                                                                                                                                                                                                                'id'            => 'billing_postcode',
                                                                                                                                                                                                                                                'label'            => __('Postcode / ZIP', 'wpcargo-frontend-manager'),
                                                                                                                                                                                                                                                'field'            => 'text',
                                                                                                                                                                                                                                                'field_type'    => 'text',
                                                                                                                                                                                                                                                'required'        => false,
                                                                                                                                                                                                                                                'options'        => array(),
                                                                                                                                                                                                                                                'field_data'    => array(),
                                                                                                                                                                                                                                                'field_key'        => 'billing_postcode'
                                                                                                                                                                                                                                            ),
                                                                                                                                                                                                                                            'billing_country' => array(
                                                                                                                                                                                                                                                'id'            => 'billing_address_1',
                                                                                                                                                                                                                                                'label'            => __('Country', 'wpcargo-frontend-manager'),
                                                                                                                                                                                                                                                'field'            => 'select',
                                                                                                                                                                                                                                                'field_type'    => 'select',
                                                                                                                                                                                                                                                'required'        => false,
                                                                                                                                                                                                                                                'options'        => wpcfe_country_list(),
                                                                                                                                                                                                                                                'field_data'    => wpcfe_country_list(),
                                                                                                                                                                                                                                                'field_key'        => 'billing_country'
                                                                                                                                                                                                                                            ),
                                                                                                                                                                                                                                            'billing_state' => array(
                                                                                                                                                                                                                                                'id'            => 'billing_state',
                                                                                                                                                                                                                                                'label'            => __('State / County', 'wpcargo-frontend-manager'),
                                                                                                                                                                                                                                                'field'            => 'text',
                                                                                                                                                                                                                                                'field_type'    => 'text',
                                                                                                                                                                                                                                                'required'        => false,
                                                                                                                                                                                                                                                'options'        => array(),
                                                                                                                                                                                                                                                'field_data'    => array(),
                                                                                                                                                                                                                                                'field_key'        => 'billing_state'
                                                                                                                                                                                                                                            ),
                                                                                                                                                                                                                                        );
                                                                                                                                                                                                                                        return apply_filters('wpcfe_billing_address_fields', $wpcfe_billing_address_fields);
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_registered_styles()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $styles = array(
                                                                                                                                                                                                                                            'wpcfe-bootstrap-styles',
                                                                                                                                                                                                                                            'wpcfe-font-awesome-styles',
                                                                                                                                                                                                                                            'wpcfe-select2-styles',
                                                                                                                                                                                                                                            'wpcfe-mdb-styles',
                                                                                                                                                                                                                                            'wpcfe-croppie-styles',
                                                                                                                                                                                                                                            'wpcfe-styles',
                                                                                                                                                                                                                                            'wpcfe-wpcfm-styles',
                                                                                                                                                                                                                                            'media-views',
                                                                                                                                                                                                                                            'imgareaselect',
                                                                                                                                                                                                                                            'wpcargo-styles',
                                                                                                                                                                                                                                            'wpcargo-custom-bootstrap-styles'
                                                                                                                                                                                                                                        );
                                                                                                                                                                                                                                        return apply_filters('wpcfe_registered_styles', $styles);
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_registered_scripts()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $scripts = array(
                                                                                                                                                                                                                                            'jquery',
                                                                                                                                                                                                                                            'wp-mediaelement',
                                                                                                                                                                                                                                            'wpcfe-dashboard-theme',
                                                                                                                                                                                                                                            'wpcfe-popper-scripts',
                                                                                                                                                                                                                                            'wpcfe-bootstrap-scripts',
                                                                                                                                                                                                                                            'wpcfe-mdb-scripts',
                                                                                                                                                                                                                                            'wpcfe-bootstrap-datepicker-scripts',
                                                                                                                                                                                                                                            'wpcfe-select2-scripts',
                                                                                                                                                                                                                                            'wpcfe-croppie-scripts',
                                                                                                                                                                                                                                            'wpcfe-repeater-js',
                                                                                                                                                                                                                                            'wpcfe-datetime-scripts',
                                                                                                                                                                                                                                            'wpcfe-chart-scripts',
                                                                                                                                                                                                                                            'wpcfe-chart-util-scripts',
                                                                                                                                                                                                                                            'wpcfe-scripts',
                                                                                                                                                                                                                                            'media-editor',
                                                                                                                                                                                                                                            'media-audiovideo',
                                                                                                                                                                                                                                        );
                                                                                                                                                                                                                                        return apply_filters('wpcfe_registered_scripts', $scripts);
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpc_orders_get_frontend_page()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        global $wpdb;
                                                                                                                                                                                                                                        $sql             = "SELECT `ID` FROM {$wpdb->prefix}posts WHERE `post_content` LIKE '%[wpcfe_orders]%' AND `post_status` LIKE 'publish' LIMIT 1";
                                                                                                                                                                                                                                        $shortcode_id     = $wpdb->get_var($sql);
                                                                                                                                                                                                                                        if (!$shortcode_id && in_array('woocommerce/woocommerce.php', apply_filters('active_plugins', get_option('active_plugins')))) {
                                                                                                                                                                                                                                            // Create post object
                                                                                                                                                                                                                                            $orders = array(
                                                                                                                                                                                                                                                'post_title'    => wp_strip_all_tags(__('Orders', 'wpcargo-frontend-manager')),
                                                                                                                                                                                                                                                'post_content'  => '[wpcfe_orders]',
                                                                                                                                                                                                                                                'post_status'   => 'publish',
                                                                                                                                                                                                                                                'post_type'       => 'page',
                                                                                                                                                                                                                                                'post_name'        => 'wpcfe-orders',
                                                                                                                                                                                                                                            );
                                                                                                                                                                                                                                            // Insert the post into the database
                                                                                                                                                                                                                                            $shortcode_id = wp_insert_post($orders);
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        if ($shortcode_id) {
                                                                                                                                                                                                                                            update_post_meta($shortcode_id, '_wp_page_template', 'dashboard.php');
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return $shortcode_id;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpc_profile_get_frontend_page()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        global $wpdb;
                                                                                                                                                                                                                                        $sql             = "SELECT `ID` FROM {$wpdb->prefix}posts WHERE `post_content` LIKE '%[wpcfe_profile]%' AND `post_status` LIKE 'publish' LIMIT 1";
                                                                                                                                                                                                                                        $shortcode_id     = $wpdb->get_var($sql);
                                                                                                                                                                                                                                        if (!$shortcode_id) {
                                                                                                                                                                                                                                            // Create post object
                                                                                                                                                                                                                                            $profile = array(
                                                                                                                                                                                                                                                'post_title'    => wp_strip_all_tags(__('Profile', 'wpcargo-frontend-manager')),
                                                                                                                                                                                                                                                'post_content'  => '[wpcfe_profile]',
                                                                                                                                                                                                                                                'post_status'   => 'publish',
                                                                                                                                                                                                                                                'post_type'       => 'page',
                                                                                                                                                                                                                                                'post_name'        => 'wpcfe-profile',
                                                                                                                                                                                                                                            );
                                                                                                                                                                                                                                            // Insert the post into the database
                                                                                                                                                                                                                                            $shortcode_id = wp_insert_post($profile);
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        if ($shortcode_id) {
                                                                                                                                                                                                                                            update_post_meta($shortcode_id, '_wp_page_template', 'dashboard.php');
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return $shortcode_id;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_after_sidebar_menu_items()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $user_roles = wpcfe_current_user_role();
                                                                                                                                                                                                                                        $menu_items = array(
                                                                                                                                                                                                                                            'shipments-menu' => array(
                                                                                                                                                                                                                                                'page-id' => wpcfe_admin_page(),
                                                                                                                                                                                                                                                'label' => __('Shipments', 'wpcargo-frontend-manager'),
                                                                                                                                                                                                                                                'permalink' => get_the_permalink(wpcfe_admin_page()),
                                                                                                                                                                                                                                                'icon' => 'fa-cubes'
                                                                                                                                                                                                                                            )
                                                                                                                                                                                                                                        );
                                                                                                                                                                                                                                        if (in_array('woocommerce/woocommerce.php', get_option('active_plugins')) && in_array('wpcargo_client', $user_roles)) {
                                                                                                                                                                                                                                            $menu_items['orders-menu'] = array(
                                                                                                                                                                                                                                                'page-id' => wpc_orders_get_frontend_page(),
                                                                                                                                                                                                                                                'label' => __('Orders', 'wpcargo-frontend-manager'),
                                                                                                                                                                                                                                                'permalink' => get_the_permalink(wpc_orders_get_frontend_page()),
                                                                                                                                                                                                                                                'icon' => 'fa-list'
                                                                                                                                                                                                                                            );
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return apply_filters('wpcfe_after_sidebar_menu_items', $menu_items);
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_after_sidebar_menus()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $menu_items = array();
                                                                                                                                                                                                                                        return apply_filters('wpcfe_after_sidebar_menus', $menu_items);
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_get_orders()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $user_id = get_current_user_id();
                                                                                                                                                                                                                                        $customer_orders = get_posts(array(
                                                                                                                                                                                                                                            'meta_key'    => '_customer_user',
                                                                                                                                                                                                                                            'meta_value'  => $user_id,
                                                                                                                                                                                                                                            'post_type'   => 'shop_order',
                                                                                                                                                                                                                                            'post_status' => array_keys(wc_get_order_statuses()),
                                                                                                                                                                                                                                            'numberposts' => 2
                                                                                                                                                                                                                                        ));
                                                                                                                                                                                                                                        $wpcfe_orders = array();
                                                                                                                                                                                                                                        foreach ($customer_orders as $customer_order) {
                                                                                                                                                                                                                                            $order_id = $customer_order->ID;
                                                                                                                                                                                                                                            $order_date = $customer_order->post_date;
                                                                                                                                                                                                                                            $order_permalink = $customer_order->guid;
                                                                                                                                                                                                                                            $orders = wc_get_order($order_id);
                                                                                                                                                                                                                                            $order_status = $orders->get_status();
                                                                                                                                                                                                                                            $order_items = $orders->get_items();
                                                                                                                                                                                                                                            foreach ($order_items as $order_item) {
                                                                                                                                                                                                                                                $order_total = $order_item->get_total();
                                                                                                                                                                                                                                            }
                                                                                                                                                                                                                                            $wpcfe_orders[$order_id] = array(
                                                                                                                                                                                                                                                'order-date' => $order_date,
                                                                                                                                                                                                                                                'order-permalink' => $order_permalink,
                                                                                                                                                                                                                                                'order-status' => $order_status,
                                                                                                                                                                                                                                                'order-total' => $order_total,
                                                                                                                                                                                                                                                'order-items' => $order_items,
                                                                                                                                                                                                                                            );
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return apply_filters('wpcfe_get_orders', $wpcfe_orders);
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    /*
 * Language Translation for the Ecncrypted Files
 */
                                                                                                                                                                                                                                    function wpc_frontend_manager_activate_license_message()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        return __('Please activate your license key for WPCargo Frontend Manager', 'wpcargo-frontend-manager') . ' <a href="' . admin_url() . 'admin.php?page=wptaskforce-helper" title="WPCargo Frontend Manager">here</a>.';
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpc_frontend_manager_license_helper_plugin_dependent_message()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        return __('This plugin requires <a href="http://wpcargo.com/" target="_blank">WPTaskForce License Helper</a> plugin to be active!', 'wpcargo-frontend-manager');
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpc_frontend_manager_wpcargo_plugin_dependent_message()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        return __('This plugin requires <a href="https://wordpress.org/plugins/wpcargo/" target="_blank">WPCargo</a> plugin to be active!', 'wpcargo-frontend-manager');
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpc_frontend_manager_custom_field_plugin_dependent_message()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        return __('This plugin requires <strong>WPCargo Custom Field Add-ons</strong> plugin to be active!', 'wpcargo-frontend-manager');
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpc_frontend_manager_cheating_plugin_dependent_message()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        return __('Cheating, uh?', 'wpcargo-frontend-manager');
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpc_frontend_dashboard_settings_label()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        return __('Frontend Dashboard Settings', 'wpcargo-frontend-manager');
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpc_frontend_dashboard_label()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        return __('Frontend Dashboard', 'wpcargo-frontend-manager');
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpc_frontend_dashboard_side_menu_label()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        return __('WPCargo Dashboard Sidebar Menu', 'wpcargo-frontend-manager');
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpc_frontend_dashboard_top_menu_label()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        return __('WPCargo Dashboard Top Menu', 'wpcargo-frontend-manager');
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_has_wpml()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $return = false;
                                                                                                                                                                                                                                        if (in_array('sitepress-multilingual-cms/sitepress.php', get_option('active_plugins'))) {
                                                                                                                                                                                                                                            $return = true;
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return $return;
                                                                                                                                                                                                                                    }
                                                                                                                                                                                                                                    function wpcfe_wpml_languages()
                                                                                                                                                                                                                                    {
                                                                                                                                                                                                                                        $languages = array();
                                                                                                                                                                                                                                        if (wpcfe_has_wpml()) {
                                                                                                                                                                                                                                            $languages = icl_get_languages('skip_missing=0&orderby=KEY&order=DIR&link_empty_to=str');
                                                                                                                                                                                                                                        }
                                                                                                                                                                                                                                        return $languages;
                                                                                                                                                                                                                                    }