/**
* Handle import/export for categories & listings.
*
* @since 1.4.6
* @package GeoDirectory
*
* @global object $wpdb WordPress Database object.
* @global string $plugin_prefix Geodirectory plugin table prefix.
* @global object $current_user Current user object.
* @global null|object $wp_filesystem WP_Filesystem object.
* @return string Json data.
*/
function geodir_ajax_import_export()
{
global $wpdb, $plugin_prefix, $current_user, $wp_filesystem;
// try to set higher limits for import
@ini_set('max_input_time', 3000);
@ini_set('max_execution_time', 3000);
@ini_set('memory_limit', '256M');
error_reporting(0);
$json = array();
if (!current_user_can('manage_options')) {
wp_send_json($json);
}
$task = isset($_REQUEST['task']) ? $_REQUEST['task'] : NULL;
$nonce = isset($_REQUEST['_nonce']) ? $_REQUEST['_nonce'] : NULL;
$stat = isset($_REQUEST['_st']) ? $_REQUEST['_st'] : false;
if (!wp_verify_nonce($nonce, 'geodir_import_export_nonce')) {
wp_send_json($json);
}
$post_type = isset($_REQUEST['_pt']) ? $_REQUEST['_pt'] : NULL;
/*if( empty( $wp_filesystem ) ) {
require_once( ABSPATH . '/wp-admin/includes/file.php' );
WP_Filesystem();
global $wp_filesystem;
}*/
$wp_filesystem = geodir_init_filesystem();
if (!$wp_filesystem) {
$json['error'] = __('Fail, something wrong to create csv file.', GEODIRECTORY_TEXTDOMAIN);
wp_send_json($json);
exit;
}
$csv_file_dir = geodir_path_import_export(false);
if (!$wp_filesystem->is_dir($csv_file_dir)) {
$wp_filesystem->mkdir($csv_file_dir, FS_CHMOD_DIR);
}
switch ($task) {
case 'export_posts':
// WPML
$is_wpml = geodir_is_wpml();
if ($is_wpml) {
global $sitepress;
$active_lang = ICL_LANGUAGE_CODE;
$sitepress->switch_lang('all', true);
}
// WPML
if ($post_type == 'gd_event') {
//add_filter( 'geodir_imex_count_posts', 'geodir_imex_count_events', 10, 2 );
add_filter('geodir_imex_export_posts_query', 'geodir_imex_get_events_query', 10, 2);
}
$file_name = $post_type . '_' . date('j_n_y');
$posts_count = geodir_get_posts_count($post_type);
$file_url = geodir_path_import_export() . '/' . $file_name . '.csv';
$file_path = $csv_file_dir . '/' . $file_name . '.csv';
$file_path_temp = $csv_file_dir . '/' . $post_type . '_' . $nonce . '.csv';
if (isset($_REQUEST['_st'])) {
$line_count = (int) geodir_import_export_line_count($file_path_temp);
$percentage = count($posts_count) > 0 && $line_count > 0 ? ceil($line_count / $posts_count) * 100 : 0;
$percentage = min($percentage, 100);
$json['percentage'] = $percentage;
// WPML
if ($is_wpml) {
$sitepress->switch_lang($active_lang, true);
}
// WPML
wp_send_json($json);
} else {
if ($wp_filesystem->exists($file_path)) {
$wp_filesystem->delete($file_path);
}
if (!$posts_count > 0) {
$json['error'] = __('No records to export.', GEODIRECTORY_TEXTDOMAIN);
} else {
$args = array('hide_empty' => 0);
$posts = geodir_imex_get_posts($post_type);
if (!empty($posts)) {
$total_posts = count($posts);
$per_page = 100;
$total_pages = ceil($total_posts / $per_page);
for ($i = 0; $i <= $total_pages; $i++) {
$save_posts = array_slice($posts, $i * $per_page, $per_page);
$clear = $i == 0 ? true : false;
geodir_save_csv_data($file_path_temp, $save_posts, $clear);
}
if ($wp_filesystem->exists($file_path_temp)) {
$wp_filesystem->move($file_path_temp, $file_path, true);
}
if ($wp_filesystem->exists($file_path)) {
$json['total'] = $posts_count;
$json['csv_file'] = $file_url;
} else {
$json['error'] = __('Fail, something wrong to create csv file.', GEODIRECTORY_TEXTDOMAIN);
}
} else {
$json['error'] = __('No records to export.', GEODIRECTORY_TEXTDOMAIN);
}
}
// WPML
if ($is_wpml) {
$sitepress->switch_lang($active_lang, true);
}
// WPML
wp_send_json($json);
}
break;
case 'export_cats':
// WPML
$is_wpml = geodir_is_wpml();
if ($is_wpml) {
global $sitepress;
$active_lang = ICL_LANGUAGE_CODE;
$sitepress->switch_lang('all', true);
}
// WPML
$file_name = $post_type . 'category_' . date('j_n_y');
$terms_count = geodir_get_terms_count($post_type);
$file_url = geodir_path_import_export() . '/' . $file_name . '.csv';
$file_path = $csv_file_dir . '/' . $file_name . '.csv';
$file_path_temp = $csv_file_dir . '/' . $post_type . 'category_' . $nonce . '.csv';
if (isset($_REQUEST['_st'])) {
$line_count = (int) geodir_import_export_line_count($file_path_temp);
$percentage = count($terms_count) > 0 && $line_count > 0 ? ceil($line_count / $terms_count) * 100 : 0;
$percentage = min($percentage, 100);
$json['percentage'] = $percentage;
// WPML
if ($is_wpml) {
$sitepress->switch_lang($active_lang, true);
}
// WPML
wp_send_json($json);
} else {
if ($wp_filesystem->exists($file_path)) {
$wp_filesystem->delete($file_path);
}
if (!$terms_count > 0) {
$json['error'] = __('No records to export.', GEODIRECTORY_TEXTDOMAIN);
} else {
$args = array('hide_empty' => 0);
$terms = geodir_imex_get_terms($post_type);
if (!empty($terms)) {
$total_terms = count($terms);
$per_page = 50;
$total_pages = ceil($total_terms / $per_page);
for ($i = 0; $i <= $total_pages; $i++) {
$save_terms = array_slice($terms, $i * $per_page, $per_page);
$clear = $i == 0 ? true : false;
geodir_save_csv_data($file_path_temp, $save_terms, $clear);
}
if ($wp_filesystem->exists($file_path_temp)) {
$wp_filesystem->move($file_path_temp, $file_path, true);
}
if ($wp_filesystem->exists($file_path)) {
$json['total'] = $terms_count;
$json['csv_file'] = $file_url;
} else {
$json['error'] = __('Fail, something wrong to create csv file.', GEODIRECTORY_TEXTDOMAIN);
}
} else {
$json['error'] = __('No records to export.', GEODIRECTORY_TEXTDOMAIN);
}
}
// WPML
if ($is_wpml) {
$sitepress->switch_lang($active_lang, true);
}
// WPML
wp_send_json($json);
}
break;
case 'prepare_import':
case 'import_cat':
case 'import_post':
// WPML
$is_wpml = geodir_is_wpml();
if ($is_wpml) {
global $sitepress;
$active_lang = ICL_LANGUAGE_CODE;
}
// WPML
ini_set('auto_detect_line_endings', true);
$uploads = wp_upload_dir();
$uploads_dir = $uploads['path'];
$uploads_subdir = $uploads['subdir'];
$csv_file = isset($_POST['_file']) ? $_POST['_file'] : NULL;
$import_choice = isset($_REQUEST['_ch']) ? $_REQUEST['_ch'] : 'skip';
$csv_file_arr = explode('/', $csv_file);
$csv_filename = end($csv_file_arr);
$target_path = $uploads_dir . '/temp_' . $current_user->data->ID . '/' . $csv_filename;
$json['file'] = $csv_file;
$json['error'] = __('The uploaded file is not a valid csv file. Please try again.', GEODIRECTORY_TEXTDOMAIN);
if ($csv_file && $wp_filesystem->is_file($target_path) && $wp_filesystem->exists($target_path)) {
$wp_filetype = wp_check_filetype_and_ext($target_path, $csv_filename);
if (!empty($wp_filetype) && isset($wp_filetype['ext']) && strtolower($wp_filetype['ext']) == 'csv') {
$json['error'] = NULL;
$json['rows'] = 0;
if (($handle = fopen($target_path, "r")) !== FALSE) {
while (($data = fgetcsv($handle, 100000, ",")) !== FALSE) {
if (!empty($data)) {
$file[] = $data;
}
}
fclose($handle);
}
$json['rows'] = !empty($file) && count($file) > 1 ? count($file) - 1 : 0;
if (!$json['rows'] > 0) {
$json['error'] = __('No data found in csv file.', GEODIRECTORY_TEXTDOMAIN);
}
} else {
wp_send_json($json);
}
} else {
wp_send_json($json);
}
if ($task == 'prepare_import' || !empty($json['error'])) {
wp_send_json($json);
}
$total = $json['rows'];
$limit = isset($_POST['limit']) ? (int) $_POST['limit'] : 1;
$processed = isset($_POST['processed']) ? (int) $_POST['processed'] : 0;
$count = $limit;
$requested_limit = $limit;
if ($count < $total) {
$count = $processed + $count;
if ($count > $total) {
$count = $total;
}
} else {
$count = $total;
}
$created = 0;
$updated = 0;
$skipped = 0;
$invalid = 0;
$invalid_addr = 0;
$images = 0;
$invalid_title = 0;
$customKeyarray = array();
$gd_post_info = array();
$post_location = array();
$countpost = 0;
$post_types = geodir_get_posttypes();
if ($task == 'import_cat') {
if (!empty($file)) {
$columns = isset($file[0]) ? $file[0] : NULL;
if (empty($columns) || !empty($columns) && $columns[0] == '') {
$json['error'] = CSV_INVAILD_FILE;
wp_send_json($json);
}
for ($i = 1; $i <= $limit; $i++) {
$index = $processed + $i;
if (isset($file[$index])) {
$row = $file[$index];
$row = array_map('trim', $row);
$row = array_map('utf8_encode', $row);
$cat_id = '';
$cat_name = '';
$cat_slug = '';
$cat_posttype = '';
$cat_parent = '';
$cat_description = '';
$cat_top_description = '';
$cat_image = '';
$cat_icon = '';
$cat_language = '';
$c = 0;
foreach ($columns as $column) {
if ($column == 'cat_id') {
$cat_id = (int) $row[$c];
} else {
if ($column == 'cat_name') {
$cat_name = $row[$c];
} else {
if ($column == 'cat_slug') {
$cat_slug = $row[$c];
} else {
if ($column == 'cat_posttype') {
$cat_posttype = $row[$c];
} else {
if ($column == 'cat_parent') {
$cat_parent = trim($row[$c]);
} else {
if ($column == 'cat_description') {
$cat_description = $row[$c];
} else {
if ($column == 'cat_top_description') {
$cat_top_description = $row[$c];
} else {
if ($column == 'cat_image') {
$cat_image = $row[$c];
} else {
if ($column == 'cat_icon') {
$cat_icon = $row[$c];
}
}
}
}
}
}
}
}
}
// WPML
if ($is_wpml && $column == 'cat_language') {
$cat_language = strtolower(trim($row[$c]));
}
// WPML
$c++;
}
if ($cat_name == '' || !in_array($cat_posttype, $post_types)) {
$invalid++;
continue;
}
// WPML
if ($is_wpml && $cat_language != '') {
$sitepress->switch_lang($cat_language, true);
}
// WPML
$term_data = array();
$term_data['name'] = $cat_name;
$term_data['slug'] = $cat_slug;
$term_data['description'] = $cat_description;
$term_data['top_description'] = $cat_top_description;
$term_data['image'] = $cat_image != '' ? basename($cat_image) : '';
$term_data['icon'] = $cat_icon != '' ? basename($cat_icon) : '';
$term_data = array_map('utf8_encode', $term_data);
$taxonomy = $cat_posttype . 'category';
$term_data['taxonomy'] = $taxonomy;
$term_parent_id = 0;
if ($cat_parent != "" || (int) $cat_parent > 0) {
$term_parent = '';
if ($term_parent = get_term_by('name', $cat_parent, $taxonomy)) {
$term_parent = $term_parent;
} else {
if ($term_parent = get_term_by('slug', $cat_parent, $taxonomy)) {
$term_parent = $term_parent;
} else {
if ($term_parent = get_term_by('id', $cat_parent, $taxonomy)) {
$term_parent = $term_parent;
} else {
$term_parent_data = array();
$term_parent_data['name'] = $cat_parent;
$term_parent_data = array_map('utf8_encode', $term_parent_data);
$term_parent_data['taxonomy'] = $taxonomy;
$term_parent_id = (int) geodir_imex_insert_term($taxonomy, $term_parent_data);
}
}
}
if (!empty($term_parent) && !is_wp_error($term_parent)) {
$term_parent_id = (int) $term_parent->term_id;
}
}
$term_data['parent'] = (int) $term_parent_id;
$term_id = NULL;
if ($import_choice == 'update') {
if ($cat_id > 0 && ($term = (array) term_exists($cat_id, $taxonomy))) {
$term_data['term_id'] = $term['term_id'];
if ($term_id = geodir_imex_update_term($taxonomy, $term_data)) {
$updated++;
} else {
$invalid++;
}
} else {
if ($term_data['slug'] != '' && ($term = (array) term_exists($term_data['slug'], $taxonomy))) {
$term_data['term_id'] = $term['term_id'];
if ($term_id = geodir_imex_update_term($taxonomy, $term_data)) {
$updated++;
} else {
$invalid++;
}
} else {
if ($term_id = geodir_imex_insert_term($taxonomy, $term_data)) {
$created++;
} else {
$invalid++;
}
}
}
} else {
if ($import_choice == 'skip') {
if ($cat_id > 0 && ($term = (array) term_exists($cat_id, $taxonomy))) {
$skipped++;
} else {
if ($term_data['slug'] != '' && ($term = (array) term_exists($term_data['slug'], $taxonomy))) {
$skipped++;
} else {
if ($term_id = geodir_imex_insert_term($taxonomy, $term_data)) {
$created++;
} else {
$invalid++;
}
}
}
} else {
$invalid++;
}
}
if ($term_id) {
if (isset($term_data['top_description'])) {
update_tax_meta($term_id, 'ct_cat_top_desc', $term_data['top_description'], $cat_posttype);
}
$attachment = false;
if (isset($term_data['image']) && $term_data['image'] != '') {
$cat_image = geodir_get_default_catimage($term_id, $cat_posttype);
$cat_image = !empty($cat_image) && isset($cat_image['src']) ? $cat_image['src'] : '';
if (basename($cat_image) != $term_data['image']) {
$attachment = true;
update_tax_meta($term_id, 'ct_cat_default_img', array('id' => 'image', 'src' => $uploads['url'] . '/' . $term_data['image']), $cat_posttype);
}
}
if (isset($term_data['icon']) && $term_data['icon'] != '') {
$cat_icon = get_tax_meta($term_id, 'ct_cat_icon', false, $cat_posttype);
$cat_icon = !empty($cat_icon) && isset($cat_icon['src']) ? $cat_icon['src'] : '';
if (basename($cat_icon) != $term_data['icon']) {
$attachment = true;
update_tax_meta($term_id, 'ct_cat_icon', array('id' => 'icon', 'src' => $uploads['url'] . '/' . $term_data['icon']), $cat_posttype);
}
}
if ($attachment) {
$images++;
}
}
// WPML
if ($is_wpml && $cat_language != '') {
$sitepress->switch_lang($active_lang, true);
}
// WPML
}
}
}
$json = array();
$json['processed'] = $limit;
$json['created'] = $created;
$json['updated'] = $updated;
$json['skipped'] = $skipped;
$json['invalid'] = $invalid;
$json['images'] = $images;
wp_send_json($json);
} else {
if ($task == 'import_post') {
if (!empty($file)) {
$wp_post_statuses = get_post_statuses();
// All of the WordPress supported post statuses.
$default_status = 'publish';
$current_date = date_i18n('Y-m-d', time());
$columns = isset($file[0]) ? $file[0] : NULL;
if (empty($columns) || !empty($columns) && $columns[0] == '') {
$json['error'] = CSV_INVAILD_FILE;
wp_send_json($json);
}
for ($i = 1; $i <= $limit; $i++) {
$index = $processed + $i;
$gd_post = array();
if (isset($file[$index])) {
$row = $file[$index];
$row = array_map('trim', $row);
$row = array_map('utf8_encode', $row);
$row = array_map('addslashes_gpc', $row);
$post_id = '';
$post_title = '';
$post_author = '';
$post_content = '';
$post_category_arr = array();
$post_tags = array();
$post_type = '';
$post_status = '';
$geodir_video = '';
$post_address = '';
$post_city = '';
$post_region = '';
$post_country = '';
$post_zip = '';
$post_latitude = '';
$post_longitude = '';
$geodir_timing = '';
$geodir_contact = '';
$geodir_email = '';
$geodir_website = '';
$geodir_twitter = '';
$geodir_facebook = '';
$geodir_twitter = '';
$post_images = array();
$expire_date = 'Never';
$language = '';
$original_post_id = '';
$c = 0;
foreach ($columns as $column) {
$gd_post[$column] = $row[$c];
if ($column == 'post_id') {
$post_id = $row[$c];
} else {
if ($column == 'post_title') {
$post_title = $row[$c];
} else {
if ($column == 'post_author') {
$post_author = $row[$c];
} else {
if ($column == 'post_content') {
$post_content = $row[$c];
} else {
if ($column == 'post_category' && $row[$c] != '') {
$post_category_arr = explode(',', $row[$c]);
} else {
if ($column == 'post_tags' && $row[$c] != '') {
$post_tags = explode(',', $row[$c]);
} else {
if ($column == 'post_type') {
$post_type = $row[$c];
} else {
if ($column == 'post_status') {
$post_status = sanitize_key($row[$c]);
} else {
if ($column == 'is_featured') {
$is_featured = (int) $row[$c];
} else {
if ($column == 'geodir_video') {
$geodir_video = $row[$c];
} else {
if ($column == 'post_address') {
$post_address = $row[$c];
} else {
if ($column == 'post_city') {
$post_city = $row[$c];
} else {
if ($column == 'post_region') {
$post_region = $row[$c];
} else {
if ($column == 'post_country') {
$post_country = $row[$c];
} else {
if ($column == 'post_zip') {
$post_zip = $row[$c];
} else {
if ($column == 'post_latitude') {
$post_latitude = $row[$c];
} else {
if ($column == 'post_longitude') {
$post_longitude = $row[$c];
} else {
if ($column == 'geodir_timing') {
$geodir_timing = $row[$c];
} else {
if ($column == 'geodir_contact') {
$geodir_contact = $row[$c];
} else {
if ($column == 'geodir_email') {
$geodir_email = $row[$c];
} else {
if ($column == 'geodir_website') {
$geodir_website = $row[$c];
} else {
if ($column == 'geodir_twitter') {
$geodir_twitter = $row[$c];
} else {
if ($column == 'geodir_facebook') {
$geodir_facebook = $row[$c];
} else {
if ($column == 'geodir_twitter') {
$geodir_twitter = $row[$c];
} else {
if ($column == 'IMAGE' && !empty($row[$c]) && $row[$c] != '') {
$post_images[] = $row[$c];
} else {
if ($column == 'alive_days' && (int) $row[$c] > 0) {
$expire_date = date_i18n('Y-m-d', strtotime($current_date . '+' . (int) $row[$c] . ' days'));
} else {
if ($column == 'expire_date' && $row[$c] != '' && strtolower($row[$c]) != 'never') {
$row[$c] = str_replace('/', '-', $row[$c]);
$expire_date = date_i18n('Y-m-d', strtotime($row[$c]));
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
// WPML
if ($is_wpml) {
if ($column == 'language') {
$language = strtolower(trim($row[$c]));
} else {
if ($column == 'original_post_id') {
$original_post_id = (int) $row[$c];
}
}
}
// WPML
$c++;
}
// WPML
if ($is_wpml && $language != '') {
$sitepress->switch_lang($language, true);
}
// WPML
$gd_post['IMAGE'] = $post_images;
$post_status = !empty($post_status) ? sanitize_key($post_status) : $default_status;
$post_status = !empty($wp_post_statuses) && !isset($wp_post_statuses[$post_status]) ? $default_status : $post_status;
$valid = true;
if ($post_title == '' || !in_array($post_type, $post_types)) {
$invalid++;
$valid = false;
}
$location_allowed = function_exists('geodir_cpt_no_location') && geodir_cpt_no_location($post_type) ? false : true;
if ($location_allowed) {
$location_result = geodir_get_default_location();
if ($post_address == '' || $post_city == '' || $post_region == '' || $post_country == '' || $post_latitude == '' || $post_longitude == '') {
$invalid_addr++;
$valid = false;
} else {
if (!empty($location_result) && $location_result->location_id == 0) {
if (strtolower($post_city) != strtolower($location_result->city) || strtolower($post_region) != strtolower($location_result->region) || strtolower($post_country) != strtolower($location_result->country)) {
$invalid_addr++;
$valid = false;
} else {
if (!function_exists('geodir_location_plugin_activated')) {
$gd_post['post_locations'] = '[' . $location_result->city_slug . '],[' . $location_result->region_slug . '],[' . $location_result->country_slug . ']';
// Set the default location when location manager not activated.
}
}
}
}
}
if (!$valid) {
continue;
}
$cat_taxonomy = $post_type . 'category';
$tags_taxonomy = $post_type . '_tags';
$post_category = array();
if (!empty($post_category_arr)) {
foreach ($post_category_arr as $value) {
$category_name = wp_kses_normalize_entities(trim($value));
if ($category_name != '') {
$term_category = array();
if ($term = get_term_by('name', $category_name, $cat_taxonomy)) {
$term_category = $term;
} else {
if ($term = get_term_by('slug', $category_name, $cat_taxonomy)) {
$term_category = $term;
} else {
$term_data = array();
$term_data['name'] = $category_name;
$term_data = array_map('utf8_encode', $term_data);
$term_data['taxonomy'] = $cat_taxonomy;
$term_id = geodir_imex_insert_term($cat_taxonomy, $term_data);
if ($term_id) {
$term_category = get_term($term_id, $cat_taxonomy);
}
}
}
if (!empty($term_category) && !is_wp_error($term_category)) {
//$post_category[] = $term_category->slug;
$post_category[] = intval($term_category->term_id);
}
}
}
}
$save_post = array();
$save_post['post_title'] = $post_title;
$save_post['post_content'] = $post_content;
$save_post['post_type'] = $post_type;
$save_post['post_author'] = $post_author;
$save_post['post_status'] = $post_status;
$save_post['post_category'] = $post_category;
$save_post['post_tags'] = $post_tags;
$saved_post_id = NULL;
if ($import_choice == 'update') {
if ($post_id > 0 && get_post($post_id)) {
$save_post['ID'] = $post_id;
if (wp_update_post($save_post)) {
$saved_post_id = $post_id;
$updated++;
}
} else {
if ($saved_post_id = wp_insert_post($save_post)) {
$created++;
}
}
if (!$saved_post_id > 0) {
$invalid++;
}
} else {
if ($import_choice == 'skip') {
if ($post_id > 0 && get_post($post_id)) {
$skipped++;
} else {
if ($saved_post_id = wp_insert_post($save_post)) {
$created++;
} else {
$invalid++;
}
}
} else {
$invalid++;
}
}
if ((int) $saved_post_id > 0) {
// WPML
if ($is_wpml && $original_post_id > 0 && $language != '') {
$wpml_post_type = 'post_' . $post_type;
$source_language = geodir_get_language_for_element($original_post_id, $wpml_post_type);
$source_language = $source_language != '' ? $source_language : $sitepress->get_default_language();
$trid = $sitepress->get_element_trid($original_post_id, $wpml_post_type);
$sitepress->set_element_language_details($saved_post_id, $wpml_post_type, $trid, $language, $source_language);
}
// WPML
$gd_post_info = geodir_get_post_info($saved_post_id);
$gd_post['post_id'] = $saved_post_id;
$gd_post['ID'] = $saved_post_id;
$gd_post['post_tags'] = $post_tags;
$gd_post['post_title'] = $post_title;
$gd_post['post_status'] = $post_status;
$gd_post['submit_time'] = time();
$gd_post['submit_ip'] = $_SERVER['REMOTE_ADDR'];
// post location
$post_location_id = 0;
if ($location_allowed && !empty($location_result) && $location_result->location_id > 0) {
$post_location_info = array('city' => $post_city, 'region' => $post_region, 'country' => $post_country, 'geo_lat' => $post_latitude, 'geo_lng' => $post_longitude);
if ($location_id = (int) geodir_add_new_location($post_location_info)) {
$post_location_id = $location_id;
}
}
$gd_post['post_location_id'] = $post_location_id;
// post package info
$package_id = isset($gd_post['package_id']) && !empty($gd_post['package_id']) ? (int) $gd_post['package_id'] : 0;
if (!$package_id && !empty($gd_post_info) && isset($gd_post_info->package_id) && $gd_post_info->package_id) {
$package_id = $gd_post_info->package_id;
}
$package_info = array();
if ($package_id && function_exists('geodir_get_package_info_by_id')) {
$package_info = (array) geodir_get_package_info_by_id($package_id);
if (!(!empty($package_info) && isset($package_info['post_type']) && $package_info['post_type'] == $post_type)) {
$package_info = array();
}
}
if (empty($package_info)) {
$package_info = (array) geodir_post_package_info(array(), '', $post_type);
}
if (!empty($package_info)) {
$package_id = $package_info['pid'];
if (isset($gd_post['alive_days']) || isset($gd_post['expire_date'])) {
$gd_post['expire_date'] = $expire_date;
} else {
if (isset($package_info['days']) && (int) $package_info['days'] > 0) {
$gd_post['alive_days'] = (int) $package_info['days'];
$gd_post['expire_date'] = date_i18n('Y-m-d', strtotime($current_date . '+' . (int) $package_info['days'] . ' days'));
} else {
$gd_post['expire_date'] = 'Never';
}
}
$gd_post['package_id'] = $package_id;
}
$table = $plugin_prefix . $post_type . '_detail';
if ($post_type == 'gd_event') {
$gd_post = geodir_imex_process_event_data($gd_post);
}
if (isset($gd_post['post_id'])) {
unset($gd_post['post_id']);
}
// Export franchise fields
$is_franchise_active = is_plugin_active('geodir_franchise/geodir_franchise.php') && geodir_franchise_enabled($post_type) ? true : false;
if ($is_franchise_active) {
if (isset($gd_post['gd_is_franchise']) && (int) $gd_post['gd_is_franchise'] == 1) {
$gd_franchise_lock = array();
if (isset($gd_post['gd_franchise_lock'])) {
$gd_franchise_lock = str_replace(" ", "", $gd_post['gd_franchise_lock']);
$gd_franchise_lock = trim($gd_franchise_lock);
$gd_franchise_lock = explode(",", $gd_franchise_lock);
}
update_post_meta($saved_post_id, 'gd_is_franchise', 1);
update_post_meta($saved_post_id, 'gd_franchise_lock', $gd_franchise_lock);
} else {
if (isset($gd_post['franchise']) && (int) $gd_post['franchise'] > 0 && geodir_franchise_check((int) $gd_post['franchise'])) {
geodir_save_post_meta($saved_post_id, 'franchise', (int) $gd_post['franchise']);
}
}
}
if (!empty($save_post['post_category']) && is_array($save_post['post_category'])) {
$save_post['post_category'] = array_unique(array_map('intval', $save_post['post_category']));
$gd_post[$cat_taxonomy] = $save_post['post_category'];
}
// Save post info
geodir_save_post_info($saved_post_id, $gd_post);
// post taxonomies
if (!empty($save_post['post_category'])) {
wp_set_object_terms($saved_post_id, $save_post['post_category'], $cat_taxonomy);
$post_default_category = isset($save_post['post_default_category']) ? $save_post['post_default_category'] : '';
$post_category_str = isset($save_post['post_category_str']) ? $save_post['post_category_str'] : '';
geodir_set_postcat_structure($saved_post_id, $cat_taxonomy, $post_default_category, $post_category_str);
}
if (!empty($save_post['post_tags'])) {
wp_set_object_terms($saved_post_id, $save_post['post_tags'], $tags_taxonomy);
}
// Post images
if (!empty($post_images)) {
$post_images = array_unique($post_images);
$old_post_images_arr = array();
$saved_post_images_arr = array();
$order = 1;
$old_post_images = geodir_get_images($saved_post_id);
if (!empty($old_post_images)) {
foreach ($old_post_images as $old_post_image) {
if (!empty($old_post_image) && isset($old_post_image->file) && $old_post_image->file != '') {
$old_post_images_arr[] = $old_post_image->file;
}
}
}
foreach ($post_images as $post_image) {
$image_name = basename($post_image);
$saved_post_images_arr[] = $image_name;
if (!empty($old_post_images_arr) && in_array($image_name, $old_post_images_arr)) {
continue;
// Skip if image already exists.
}
$image_name_parts = explode('.', $image_name);
array_pop($image_name_parts);
$proper_image_name = implode('.', $image_name_parts);
$arr_file_type = wp_check_filetype($image_name);
if (!empty($arr_file_type)) {
$uploaded_file_type = $arr_file_type['type'];
$attachment = array();
$attachment['post_id'] = $saved_post_id;
$attachment['title'] = $proper_image_name;
$attachment['content'] = '';
$attachment['file'] = $uploads_subdir . '/' . $image_name;
$attachment['mime_type'] = $uploaded_file_type;
$attachment['menu_order'] = $order;
$attachment['is_featured'] = 0;
$attachment_set = '';
foreach ($attachment as $key => $val) {
if ($val != '') {
$attachment_set .= $key . " = '" . $val . "', ";
}
}
$attachment_set = trim($attachment_set, ", ");
// Add new attachment
$wpdb->query("INSERT INTO " . GEODIR_ATTACHMENT_TABLE . " SET " . $attachment_set);
$order++;
}
}
$saved_post_images_sql = !empty($saved_post_images_arr) ? " AND ( file NOT LIKE '%/" . implode("' AND file NOT LIKE '%/", $saved_post_images_arr) . "' )" : '';
// Remove previous attachment
$wpdb->query("DELETE FROM " . GEODIR_ATTACHMENT_TABLE . " WHERE post_id = " . (int) $saved_post_id . " " . $saved_post_images_sql);
if (!empty($saved_post_images_arr)) {
$menu_order = 1;
foreach ($saved_post_images_arr as $img_name) {
$wpdb->query($wpdb->prepare("UPDATE " . GEODIR_ATTACHMENT_TABLE . " SET menu_order = %d WHERE post_id =%d AND file LIKE %s", array($menu_order, $saved_post_id, '%/' . $img_name)));
if ($menu_order == 1) {
if ($featured_image = $wpdb->get_var($wpdb->prepare("SELECT file FROM " . GEODIR_ATTACHMENT_TABLE . " WHERE post_id =%d AND file LIKE %s", array($saved_post_id, '%/' . $img_name)))) {
$wpdb->query($wpdb->prepare("UPDATE " . $table . " SET featured_image = %s WHERE post_id =%d", array($featured_image, $saved_post_id)));
}
}
$menu_order++;
}
}
if ($order > 1) {
$images++;
}
}
/** This action is documented in geodirectory-functions/post-functions.php */
do_action('geodir_after_save_listing', $saved_post_id, $gd_post);
if (isset($is_featured)) {
geodir_save_post_meta($saved_post_id, 'is_featured', $is_featured);
}
if (isset($gd_post['expire_date'])) {
geodir_save_post_meta($saved_post_id, 'expire_date', $gd_post['expire_date']);
}
}
// WPML
if ($is_wpml && $language != '') {
$sitepress->switch_lang($active_lang, true);
}
// WPML
}
}
}
$json = array();
$json['processed'] = $limit;
$json['created'] = $created;
$json['updated'] = $updated;
$json['skipped'] = $skipped;
$json['invalid'] = $invalid;
$json['invalid_addr'] = $invalid_addr;
$json['images'] = $images;
wp_send_json($json);
}
}
break;
}
echo '0';
wp_die();
}
/**
* Add the javascript to make cat icon upload optional.
*
* @since 1.1.7
*
* @return string Print the inline script.
*/
function geodir_cpt_admin_footer()
{
global $pagenow;
if ($pagenow == 'edit-tags.php' && !empty($_REQUEST['taxonomy']) && geodir_cpt_no_location($_REQUEST['taxonomy'], true)) {
echo '<script type="text/javascript">jQuery(\'[name="ct_cat_icon[src]"]\', \'#addtag, #edittag\').removeClass(\'ct_cat_icon[src]\');jQuery(\'[name="ct_cat_icon[id]"]\', \'#addtag, #edittag\').closest(\'.form-field\').removeClass(\'form-required\').removeClass(\'form-invalid\');</script>';
}
}
