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 get_fields_data( $flag = '', $shipment_id = 0, $attachment_image = true ){ global $wpcargo; $field_keys = $this->get_custom_fields( $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 ) ){ ?>

2 ? '_blank' : '' ; $url = $url_data[1] ? $url_data[1] : '#' ; $label = $url_data[0]; ?>

prefix; $result = ''; if( !empty($key) || $key != '' ){ $result= $wpdb->get_results( 'SELECT * FROM `'.$table_prefix.'wpcargo_custom_fields` WHERE `section` LIKE "%'.$key.'%"', ARRAY_A ); } return $result; } function get_field_key_list( ){ global $wpdb; $table_prefix = $wpdb->prefix; $field_keys = $wpdb->get_col( 'SELECT `field_key` FROM `'.$table_prefix.'wpcargo_custom_fields`' ); return $field_keys; } function get_invoice_id( $shipment_id ){ global $wpdb; $orderID = $wpdb->get_var( "SELECT tbl1.ID FROM `$wpdb->posts` AS tbl1 INNER JOIN `$wpdb->postmeta` AS tbl2 WHERE tbl1.ID = tbl2.post_id AND tbl1.post_type LIKE 'pq_order' AND tbl2.meta_key LIKE 'shipment_id' AND tbl2.meta_value = ".$shipment_id ); return $orderID; } function get_field_options( $meta_key ){ global $wpdb; $table_prefix = $wpdb->prefix; $field_options = $wpdb->get_var( "SELECT `field_data` FROM `".$table_prefix."wpcargo_custom_fields` WHERE `field_key`='".$meta_key."'" ); $unserialized_field_options = array(); if( is_serialized( $field_options ) ){ $unserialized_field_options = maybe_unserialize( $field_options ); } return $unserialized_field_options; } function convert_to_form_fields( $fields = array(), $post_id = '', $class="", $id="" ){ global $wpcargo; ob_start(); foreach( $fields as $field): $value = ''; if( !empty( $post_id ) ){ $value = maybe_unserialize( get_post_meta( $post_id, $field['field_key'], TRUE ) ); } $required = ( $field['required'] ) ? 'required' : '' ; if( $field['field_type'] == 'text' ){ $value = is_array( $value ) ? implode(", ", $value) : $value; ?>

placeholder="" style="margin-bottom: 5px;" /> placeholder="" style="margin-bottom: 5px;" /> >

$_addr_label ) { if( $_addr_meta == 'country' ){ ?>