prefix}posts` WHERE `post_status` LIKE 'publish' AND `post_type` LIKE 'wpcargo_shipment' LIMIT 1";
$shipment_id = $wpdb->get_var( $sql );
$dummy_data = array();
if( $shipment_id ){
foreach( array_keys( $headers ) as $key ){
$data = maybe_unserialize ( get_post_meta( 2809, $key, TRUE) );
if( $key === 'shipment_id' ){
$dummy_data[] = 0;
continue;
}elseif( $key === 'shipment_title' ){
$dummy_data[] = 'DUMMY123456';
continue;
}elseif( $key === 'wpcargo_shipment_cat' ){
$dummy_data[] = 0;
continue;
}elseif( $key === 'registered_shipper' ){
$dummy_data[] = 'Juan dela Cruz';
continue;
}else{
if( is_array($data) ) {
if( empty( $data ) ){
$dummy_data[] = '';
continue;
}
// Check if the meta has field
if( $key == 'wpcargo_shipments_update' || $key == 'wpc-multiple-package' ){
if( $key == 'wpcargo_shipments_update' ){
$fields = wpcargo_history_fields();
}elseif( $key == 'wpc-multiple-package' ){
$fields = wpcargo_package_fields();
}
if( empty( $fields ) ){
$dummy_data[] = '';
continue;
}
$data_str = '';
$counter = 1;
foreach( $data as $val ){
if( empty( $val ) ){
continue;
}
foreach( $fields as $key => $value ){
if( array_key_exists( $key, $val ) ){
$data_str .= $value['label'].'='.$val[$key].' * ';
}else{
$data_str .= $value['label'].'= * ';
}
}
$data_str .= ' | ';
if( $counter === 2 ){ break; }
$counter++;
}
$dummy_data[] = $data_str;
}else{
$dummy_data[] = implode(' | ', $data );
}
}else{
$dummy_data[] = $data;
}
}
}
}
return $dummy_data;
}
// Registered Admin submenus and pages
function wpcie_admin_submenu_page(){
//** Import Submenu
add_submenu_page(
'edit.php?post_type=wpcargo_shipment',
__('Import/Export', 'wpc-import-export'),
__('Import/Export', 'wpc-import-export'),
'manage_options',
'wpcie-export',
'wpcie_submenu_page_callback');
//** Exmport Submenu
add_submenu_page(
NULL,
__('Import/Export', 'wpc-import-export'),
__('Import/Export', 'wpc-import-export'),
'manage_options',
'wpcie-import',
'wpcie_submenu_page_callback');
}
add_action( 'admin_menu', 'wpcie_admin_submenu_page' );
// Admin page callbacks
function wpcie_submenu_page_callback(){
global $wpdb;
$table_name = $wpdb->prefix.'wpcargo_custom_fields';
$field_selection = wpcie_registered_form_fields();
$page = $_GET['page'];
$tax_args = array(
'orderby' => 'name',
'order' => 'ASC',
'hide_empty' => 0
);
$shipment_category = get_categories($tax_args);
ob_start();
?>
$value_option ) {
$headers[$key_option] = stripslashes( $value_option ) .'('.$key_option.')';
}
}
$dummy_shipment = wpcie_get_shipment_template( $headers );
fputcsv( $csv_file, array_values( $headers ) );
fputcsv( $csv_file, $dummy_shipment );
fclose($csv_file);
require_once( WPC_IMPORT_EXPORT_PATH.'admin/templates/form-import.tpl.php');
}
function wpcie_export_form( $fields = array(), $taxonomy = array(), $page ='') {
global $wpcargo;
add_action( 'wp_ajax_update_import_option_ajax_request', 'update_import_option_ajax_request' );
$wpcargo_option_settings = get_option('wpcargo_option_settings');
$get_all_status = $wpcargo_option_settings['settings_shipment_status'];
$shipment_status = explode(",", $get_all_status);
$shipment_status = apply_filters( 'wpcargo_status_option', $shipment_status );
$selected_status = isset($_REQUEST['wpcargo_status']) ? $_REQUEST['wpcargo_status'] : '';
$options = get_option( 'multiselect_settings' );
if( !empty( $options ) ){
if( array_key_exists( 0, $options ) ){
$options = array();
}
}
require_once( WPC_IMPORT_EXPORT_PATH.'admin/templates/form-export.tpl.php');
}
// Page header
function wpcie_page_header_tab(){
$importExport = new WPCargo_Import_Export;
$view = $_GET['page'];
?>
wpc_export_request( );
}elseif( $view == 'wpcie-import' ){
$importExport->wpc_import_request( );
}
}
// Frontend Manager Hooks
function wpcie_import_export_sidebar_menu( $menu_array ){
if( function_exists('wpcfe_admin_page') ){
$menu_array['wpcie-menu'] = array(
'label' => __('Import/Export', 'wpc-import-export'),
'permalink' => get_the_permalink( wpcie_get_frontend_page() ),
'icon' => 'fa-recycle'
) ;
}
return $menu_array;
}
add_filter('wpcfe_after_sidebar_menus', 'wpcie_import_export_sidebar_menu', 10, 1 );
function wpcie_import_export_multiselect_script( $scripts ){
$scripts[] = 'multiselect_js';
$scripts[] = 'wpc-import-export-frontend-script';
return $scripts;
}
add_filter('wpcfe_registered_scripts', 'wpcie_import_export_multiselect_script', 10, 1 );