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_field_key( $key = '' ){ global $wpdb; $table_prefix = $wpdb->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 convert_to_form_fields( $fields = array(), $post_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' ){ ?>

autocomplete="off" >

placeholder="--:-- --" autocomplete="off" >