/**
* Imports data from CSV file using ajax.
*
* @since 1.0.0
* @package GeoDirectory
* @global object $wpdb WordPress Database object.
* @global string $plugin_prefix Geodirectory plugin table prefix.
* @global object $current_user Current user object.
*/
function geodir_ajax_import_csv()
{
error_reporting(0);
// hide error to get clean json response
global $wpdb, $plugin_prefix, $current_user;
$uploads = wp_upload_dir();
ini_set('auto_detect_line_endings', true);
$wp_post_statuses = get_post_statuses();
// All of the WordPress supported post statuses.
$task = isset($_POST['task']) ? $_POST['task'] : '';
$uploadedFile = isset($_POST['gddata']['uploadedFile']) ? $_POST['gddata']['uploadedFile'] : NULL;
$filename = $uploadedFile;
$uploads = wp_upload_dir();
$uploads_dir = $uploads['path'];
$image_name_arr = explode('/', $filename);
$filename = end($image_name_arr);
$target_path = $uploads_dir . '/temp_' . $current_user->data->ID . '/' . $filename;
$return = array();
$return['file'] = $uploadedFile;
$return['error'] = __('The uploaded file is not a valid csv file. Please try again.', 'geodirectory');
if (is_file($target_path) && file_exists($target_path) && $uploadedFile) {
$wp_filetype = wp_check_filetype_and_ext($target_path, $filename);
if (!empty($wp_filetype) && isset($wp_filetype['ext']) && geodir_strtolower($wp_filetype['ext']) == 'csv') {
$return['error'] = NULL;
$return['rows'] = 0;
if (($handle = fopen($target_path, "r")) !== FALSE) {
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
if (is_array($data) && !empty($data)) {
$file[] = '"' . implode('","', $data) . '"';
}
}
fclose($handle);
$file = $file;
}
$return['rows'] = !empty($file) && count($file) > 1 ? count($file) - 1 : 0;
if (!$return['rows'] > 0) {
$return['error'] = __('No data found in csv file.', 'geodirectory');
}
}
}
if ($task == 'prepare' || !empty($return['error'])) {
echo json_encode($return);
exit;
}
$totRecords = isset($_POST['gddata']['totRecords']) ? $_POST['gddata']['totRecords'] : NULL;
$importlimit = isset($_POST['gddata']['importlimit']) ? $_POST['gddata']['importlimit'] : 1;
$count = $importlimit;
$requested_limit = $importlimit;
$tmpCnt = isset($_POST['gddata']['tmpcount']) ? $_POST['gddata']['tmpcount'] : 0;
if ($count < $totRecords) {
$count = $tmpCnt + $count;
if ($count > $totRecords) {
$count = $totRecords;
}
} else {
$count = $totRecords;
}
$total_records = 0;
$rowcount = 0;
$address_invalid = 0;
$blank_address = 0;
$upload_files = 0;
$invalid_post_type = 0;
$invalid_title = 0;
$customKeyarray = array();
$gd_post_info = array();
$post_location = array();
$countpost = 0;
if (!empty($file)) {
$columns = isset($file[0]) ? geodir_str_getcsv($file[0]) : NULL;
$customKeyarray = $columns;
if (empty($columns) || !empty($columns) && $columns[0] == '') {
$return['error'] = CSV_INVAILD_FILE;
echo json_encode($return);
exit;
}
for ($i = 1; $i <= $importlimit; $i++) {
$current_index = $tmpCnt + $i;
if (isset($file[$current_index])) {
$total_records++;
$buffer = geodir_str_getcsv($file[$current_index]);
$post_title = addslashes($buffer[0]);
$current_post_author = $buffer[1];
$post_desc = addslashes($buffer[2]);
$post_cat = array();
$catids_arr = array();
$post_cat = trim($buffer[3]);
// comma seperated category name
if ($post_cat) {
$post_cat_arr = explode(',', $post_cat);
for ($c = 0; $c < count($post_cat_arr); $c++) {
$catid = wp_kses_normalize_entities(trim($post_cat_arr[$c]));
if (!empty($buffer[5])) {
if (in_array($buffer[5], geodir_get_posttypes())) {
$p_taxonomy = geodir_get_taxonomies(addslashes($buffer[5]));
if (get_term_by('name', $catid, $p_taxonomy[0])) {
$cat = get_term_by('name', $catid, $p_taxonomy[0]);
$catids_arr[] = $cat->slug;
} else {
if (get_term_by('slug', $catid, $p_taxonomy[0])) {
$cat = get_term_by('slug', $catid, $p_taxonomy[0]);
$catids_arr[] = $cat->slug;
} else {
$ret = wp_insert_term($catid, $p_taxonomy[0]);
if ($ret && !is_wp_error($ret)) {
if (get_term_by('name', $catid, $p_taxonomy[0])) {
$cat = get_term_by('name', $catid, $p_taxonomy[0]);
$catids_arr[] = $cat->slug;
} elseif (get_term_by('slug', $catid, $p_taxonomy[0])) {
$cat = get_term_by('slug', $catid, $p_taxonomy[0]);
$catids_arr[] = $cat->slug;
}
}
}
}
}
}
}
}
if (!$catids_arr) {
$catids_arr[] = 1;
}
$post_tags = trim($buffer[4]);
// comma seperated tags
$tag_arr = '';
if ($post_tags) {
$tag_arr = explode(',', $post_tags);
}
$table = $plugin_prefix . $buffer[5] . '_detail';
// check table in database
$error = '';
if ($wpdb->get_var("SHOW TABLES LIKE '" . $table . "'") != $table) {
$invalid_post_type++;
continue;
}
if ($post_title != '') {
$menu_order = 0;
$image_folder_name = 'uplaod/';
$image_names = array();
for ($c = 5; $c < count($customKeyarray); $c++) {
$gd_post_info[$customKeyarray[$c]] = addslashes($buffer[$c]);
if ($customKeyarray[$c] == 'IMAGE') {
$buffer[$c] = trim($buffer[$c]);
if (!empty($buffer[$c])) {
$image_names[] = $buffer[$c];
}
}
if ($customKeyarray[$c] == 'alive_days') {
if ($buffer[$c] != '0' && $buffer[$c] != '') {
$submitdata = date('Y-m-d');
$gd_post_info['expire_date'] = date('Y-m-d', strtotime($submitdata . "+" . addslashes($buffer[$c]) . " days"));
} else {
$gd_post_info['expire_date'] = 'Never';
}
}
if ($customKeyarray[$c] == 'post_city') {
$post_city = addslashes($buffer[$c]);
}
if ($customKeyarray[$c] == 'post_region') {
$post_region = addslashes($buffer[$c]);
}
if ($customKeyarray[$c] == 'post_country') {
$post_country = addslashes($buffer[$c]);
}
if ($customKeyarray[$c] == 'post_latitude') {
$post_latitude = addslashes($buffer[$c]);
}
if ($customKeyarray[$c] == 'post_longitude') {
$post_longitude = addslashes($buffer[$c]);
}
// Post status
if ($customKeyarray[$c] == 'post_status') {
$post_status = sanitize_key($buffer[$c]);
}
}
/* ================ before array create ============== */
$location_result = geodir_get_default_location();
if (!isset($gd_post_info['post_city']) || $gd_post_info['post_city'] == '' || (!isset($gd_post_info['post_region']) || $gd_post_info['post_region'] == '') || (!isset($gd_post_info['post_country']) || $gd_post_info['post_country'] == '') || (!isset($gd_post_info['post_address']) || $gd_post_info['post_address'] == '') || (!isset($gd_post_info['post_latitude']) || $gd_post_info['post_latitude'] == '') || (!isset($gd_post_info['post_longitude']) || $gd_post_info['post_longitude'] == '')) {
$blank_address++;
continue;
} else {
if ($location_result->location_id == 0) {
if (geodir_strtolower($gd_post_info['post_city']) != geodir_strtolower($location_result->city) || geodir_strtolower($gd_post_info['post_region']) != geodir_strtolower($location_result->region) || geodir_strtolower($gd_post_info['post_country']) != geodir_strtolower($location_result->country)) {
$address_invalid++;
continue;
}
}
}
// Default post status
$default_status = 'publish';
$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;
$my_post['post_title'] = $post_title;
$my_post['post_content'] = $post_desc;
$my_post['post_type'] = addslashes($buffer[5]);
$my_post['post_author'] = $current_post_author;
$my_post['post_status'] = $post_status;
$my_post['post_category'] = $catids_arr;
$my_post['post_tags'] = $tag_arr;
$gd_post_info['post_tags'] = $tag_arr;
$gd_post_info['post_title'] = $post_title;
$gd_post_info['post_status'] = $post_status;
$gd_post_info['submit_time'] = time();
$gd_post_info['submit_ip'] = $_SERVER['REMOTE_ADDR'];
$last_postid = wp_insert_post($my_post);
$countpost++;
// Check if we need to save post location as new location
if ($location_result->location_id > 0) {
if (isset($post_city) && isset($post_region)) {
$request_info['post_location'] = array('city' => $post_city, 'region' => $post_region, 'country' => $post_country, 'geo_lat' => $post_latitude, 'geo_lng' => $post_longitude);
$post_location_info = $request_info['post_location'];
if ($location_id = geodir_add_new_location($post_location_info)) {
$post_location_id = $location_id;
}
} else {
$post_location_id = 0;
}
} else {
$post_location_id = 0;
}
/* ------- get default package info ----- */
$payment_info = array();
$package_info = array();
$package_info = (array) geodir_post_package_info($package_info, '', $buffer[5]);
$package_id = '';
if (isset($gd_post_info['package_id']) && $gd_post_info['package_id'] != '') {
$package_id = $gd_post_info['package_id'];
}
if (!empty($package_info)) {
$payment_info['package_id'] = $package_info['pid'];
if (isset($package_info['alive_days']) && $package_info['alive_days'] != 0) {
$payment_info['expire_date'] = date('Y-m-d', strtotime("+" . $package_info['alive_days'] . " days"));
} else {
$payment_info['expire_date'] = 'Never';
}
$gd_post_info = array_merge($gd_post_info, $payment_info);
}
$gd_post_info['post_location_id'] = $post_location_id;
$post_type = get_post_type($last_postid);
$table = $plugin_prefix . $post_type . '_detail';
geodir_save_post_info($last_postid, $gd_post_info);
if (!empty($image_names)) {
$upload_files++;
$menu_order = 1;
foreach ($image_names as $image_name) {
$img_name_arr = explode('.', $image_name);
$uploads = wp_upload_dir();
$sub_dir = $uploads['subdir'];
$arr_file_type = wp_check_filetype($image_name);
$uploaded_file_type = $arr_file_type['type'];
$attachment = array();
$attachment['post_id'] = $last_postid;
$attachment['title'] = $img_name_arr[0];
$attachment['content'] = '';
$attachment['file'] = $sub_dir . '/' . $image_name;
$attachment['mime_type'] = $uploaded_file_type;
$attachment['menu_order'] = $menu_order;
$attachment['is_featured'] = 0;
$attachment_set = '';
foreach ($attachment as $key => $val) {
if ($val != '') {
$attachment_set .= $key . " = '" . $val . "', ";
}
}
$attachment_set = trim($attachment_set, ", ");
$wpdb->query("INSERT INTO " . GEODIR_ATTACHMENT_TABLE . " SET " . $attachment_set);
if ($menu_order == 1) {
$post_type = get_post_type($last_postid);
$wpdb->query($wpdb->prepare("UPDATE " . $table . " SET featured_image = %s where post_id =%d", array($sub_dir . '/' . $image_name, $last_postid)));
}
$menu_order++;
}
}
$gd_post_info['package_id'] = $package_id;
/** This action is documented in geodirectory-functions/post-functions.php */
do_action('geodir_after_save_listing', $last_postid, $gd_post_info);
if (!empty($buffer[5])) {
if (in_array($buffer[5], geodir_get_posttypes())) {
$taxonomies = geodir_get_posttype_info(addslashes($buffer[5]));
wp_set_object_terms($last_postid, $my_post['post_tags'], $taxonomy = $taxonomies['taxonomies'][1]);
wp_set_object_terms($last_postid, $my_post['post_category'], $taxonomy = $taxonomies['taxonomies'][0]);
$post_default_category = isset($my_post['post_default_category']) ? $my_post['post_default_category'] : '';
$post_category_str = isset($my_post['post_category_str']) ? $my_post['post_category_str'] : '';
geodir_set_postcat_structure($last_postid, $taxonomy, $post_default_category, $post_category_str);
}
}
} else {
$invalid_title++;
}
}
}
}
$return['rowcount'] = $countpost;
$return['invalidcount'] = $address_invalid;
$return['blank_address'] = $blank_address;
$return['upload_files'] = $upload_files;
$return['invalid_post_type'] = $invalid_post_type;
$return['invalid_title'] = $invalid_title;
$return['total_records'] = $total_records;
echo json_encode($return);
exit;
}
/**
* Handles location form submitted data.
*
* @since 1.0.0
* @package GeoDirectory
* @global object $wpdb WordPress Database object.
* @global string $plugin_prefix Geodirectory plugin table prefix.
*/
function geodir_location_form_submit()
{
global $wpdb, $plugin_prefix;
if (isset($_REQUEST['add_location'])) {
$location_info = array('city' => $_REQUEST['city'], 'region' => $_REQUEST['region'], 'country' => $_REQUEST['country'], 'geo_lat' => $_REQUEST['latitude'], 'geo_lng' => $_REQUEST['longitude'], 'is_default' => $_REQUEST['is_default'], 'update_city' => $_REQUEST['update_city']);
$old_location = geodir_get_default_location();
$locationid = geodir_add_new_location($location_info);
$default_location = geodir_get_location($locationid);
//UPDATE AND DELETE LISTING
$posttype = geodir_get_posttypes();
if (isset($_REQUEST['listing_action']) && $_REQUEST['listing_action'] == 'delete') {
foreach ($posttype as $posttypeobj) {
/* do not update latitude and longitude otrherwise all listings will be spotted on one point on map
if ($old_location->city_latitude != $_REQUEST['latitude'] || $old_location->city_longitude != $_REQUEST['longitude']) {
$del_post_sql = $wpdb->get_results(
$wpdb->prepare(
"SELECT post_id from ".$plugin_prefix.$posttypeobj."_detail WHERE post_location_id = %d AND (post_city != %s OR post_region != %s)",
array($locationid,$_REQUEST['city'],$_REQUEST['region'])
)
);
$sql = $wpdb->prepare(
"SELECT post_id from ".$plugin_prefix.$posttypeobj."_detail WHERE post_location_id = %d AND (post_city != %s OR post_region != %s)",
array($locationid,$_REQUEST['city'],$_REQUEST['region'])
);
if (!empty($del_post_sql)) {
foreach ($del_post_sql as $del_post_info) {
$postid = (int)$del_post_info->post_id;
//wp_delete_post($postid); // update post location instead of delete post
$sql = $wpdb->prepare(
"UPDATE ".$plugin_prefix.$posttypeobj."_detail SET post_latitude=%s, post_longitude=%s WHERE post_location_id=%d AND post_id=%d",
array( $_REQUEST['latitude'], $_REQUEST['longitude'], $locationid, $postid )
);
$wpdb->query($sql);
}
}
}
*/
$post_locations = '[' . $default_location->city_slug . '],[' . $default_location->region_slug . '],[' . $default_location->country_slug . ']';
// set all overall post location
$sql = $wpdb->prepare("UPDATE " . $plugin_prefix . $posttypeobj . "_detail SET post_city=%s, post_region=%s, post_country=%s, post_locations=%s\r\n\t\t\t\t\t\tWHERE post_location_id=%d AND ( post_city!=%s OR post_region!=%s OR post_country!=%s OR post_locations!=%s OR post_locations IS NULL)", array($_REQUEST['city'], $_REQUEST['region'], $_REQUEST['country'], $post_locations, $locationid, $_REQUEST['city'], $_REQUEST['region'], $_REQUEST['country'], $post_locations));
$wpdb->query($sql);
}
}
}
}
/**
* Saves listing in the database using given information.
*
* @since 1.0.0
* @package GeoDirectory
* @global object $wpdb WordPress Database object.
* @global object $post The current post object.
* @global object $current_user Current user object.
* @param array $request_info {
* Array of request info arguments.
*
* @type string $action Ajax action name.
* @type string $geodir_ajax Ajax type.
* @type string $ajax_action Ajax action.
* @type string $listing_type Listing type.
* @type string $pid Default Post ID.
* @type string $preview Todo Desc needed.
* @type string $add_listing_page_id Add listing page ID.
* @type string $post_title Listing title.
* @type string $post_desc Listing Description.
* @type string $post_tags Listing tags.
* @type array $cat_limit Category limit.
* @type array $post_category Category IDs.
* @type array $post_category_str Category string.
* @type string $post_default_category Default category ID.
* @type string $post_address Listing address.
* @type string $geodir_location_add_listing_country_val Add listing country value.
* @type string $post_country Listing country.
* @type string $geodir_location_add_listing_region_val Add listing region value.
* @type string $post_region Listing region.
* @type string $geodir_location_add_listing_city_val Add listing city value.
* @type string $post_city Listing city.
* @type string $post_zip Listing zip.
* @type string $post_latitude Listing latitude.
* @type string $post_longitude Listing longitude.
* @type string $post_mapview Listing mapview. Default "ROADMAP".
* @type string $post_mapzoom Listing mapzoom Default "9".
* @type string $geodir_timing Business timing info.
* @type string $geodir_contact Contact number.
* @type string $geodir_email Business contact email.
* @type string $geodir_website Business website.
* @type string $geodir_twitter Twitter link.
* @type string $geodir_facebook Facebook link.
* @type string $geodir_video Video link.
* @type string $geodir_special_offers Speacial offers.
* @type string $post_images Post image urls.
* @type string $post_imagesimage_limit Post images limit.
* @type string $post_imagestotImg Todo Desc needed.
* @type string $geodir_accept_term_condition Has accepted terms and conditions?.
* @type string $geodir_spamblocker Todo Desc needed.
* @type string $geodir_filled_by_spam_bot Todo Desc needed.
*
* }
* @param bool $dummy Optional. Is this a dummy listing? Default false.
* @return int|string|WP_Error Created post id.
*/
function geodir_save_listing($request_info = array(), $dummy = false)
{
global $wpdb, $current_user;
$last_post_id = '';
if (isset($_SESSION['listing']) && !$dummy) {
$request_info = array();
$request_session = unserialize($_SESSION['listing']);
$request_info = array_merge($_REQUEST, $request_session);
} else {
if (!isset($_SESSION['listing']) && !$dummy) {
global $post;
$request_info['pid'] = $post->ID;
$request_info['post_title'] = $request_info['post_title'];
$request_info['listing_type'] = $post->post_type;
$request_info['post_desc'] = $request_info['content'];
} else {
if (!$dummy) {
return false;
}
}
}
/**
* Filter the request_info array.
*
* You can use this filter to modify request_info array.
*
* @since 1.0.0
* @package GeoDirectory
* @param array $request_info See {@see geodir_save_listing()} for accepted args.
*/
$request_info = apply_filters('geodir_action_get_request_info', $request_info);
// Check if we need to save post location as new location
$location_result = geodir_get_default_location();
if ($location_result->location_id > 0) {
if (isset($request_info['post_city']) && isset($request_info['post_region'])) {
$request_info['post_location'] = array('city' => $request_info['post_city'], 'region' => isset($request_info['post_region']) ? $request_info['post_region'] : '', 'country' => isset($request_info['post_country']) ? $request_info['post_country'] : '', 'geo_lat' => isset($request_info['post_latitude']) ? $request_info['post_latitude'] : '', 'geo_lng' => isset($request_info['post_longitude']) ? $request_info['post_longitude'] : '');
$post_location_info = $request_info['post_location'];
if ($location_id = geodir_add_new_location($post_location_info)) {
$post_location_id = $location_id;
}
} else {
$post_location_id = $location_result->location_id;
}
} else {
$post_location_id = $location_result->location_id;
}
if ($dummy) {
$post_status = 'publish';
} else {
$post_status = geodir_new_post_default_status();
}
if (isset($request_info['pid']) && $request_info['pid'] != '') {
$post_status = get_post_status($request_info['pid']);
}
/* fix change of slug on every title edit */
if (!isset($request_info['post_name'])) {
$request_info['post_name'] = $request_info['post_title'];
if (!empty($request_info['pid'])) {
$post_info = get_post($request_info['pid']);
if (!empty($post_info) && isset($post_info->post_name)) {
$request_info['post_name'] = $post_info->post_name;
}
}
}
$post = array('post_content' => $request_info['post_desc'], 'post_status' => $post_status, 'post_title' => $request_info['post_title'], 'post_name' => $request_info['post_name'], 'post_type' => $request_info['listing_type']);
/**
* Called before a listing is saved to the database.
*
* @since 1.0.0
* @param object $post The post object.
*/
do_action_ref_array('geodir_before_save_listing', $post);
$send_post_submit_mail = false;
// unhook this function so it doesn't loop infinitely
remove_action('save_post', 'geodir_post_information_save', 10, 2);
if (isset($request_info['pid']) && $request_info['pid'] != '') {
$post['ID'] = $request_info['pid'];
$last_post_id = wp_update_post($post);
} else {
$last_post_id = wp_insert_post($post);
if (!$dummy && $last_post_id) {
$send_post_submit_mail = true;
// we move post_submit email from here so the rest of the variables are added to the db first(was breaking permalink in email)
//geodir_sendEmail('','',$current_user->user_email,$current_user->display_name,'','',$request_info,'post_submit',$last_post_id,$current_user->ID);
}
}
// re-hook this function
add_action('save_post', 'geodir_post_information_save', 10, 2);
$post_tags = '';
if (!isset($request_info['post_tags'])) {
$post_type = $request_info['listing_type'];
$post_tags = implode(",", wp_get_object_terms($last_post_id, $post_type . '_tags', array('fields' => 'names')));
}
$gd_post_info = array("post_title" => $request_info['post_title'], "post_tags" => isset($request_info['post_tags']) ? $request_info['post_tags'] : $post_tags, "post_status" => $post_status, "post_location_id" => $post_location_id, "claimed" => isset($request_info['claimed']) ? $request_info['claimed'] : '', "businesses" => isset($request_info['a_businesses']) ? $request_info['a_businesses'] : '', "submit_time" => time(), "submit_ip" => $_SERVER['REMOTE_ADDR']);
$payment_info = array();
$package_info = array();
$package_info = (array) geodir_post_package_info($package_info, $post);
$post_package_id = geodir_get_post_meta($last_post_id, 'package_id');
if (!empty($package_info) && !$post_package_id) {
if (isset($package_info['days']) && $package_info['days'] != 0) {
$payment_info['expire_date'] = date('Y-m-d', strtotime("+" . $package_info['days'] . " days"));
} else {
$payment_info['expire_date'] = 'Never';
}
$payment_info['package_id'] = $package_info['pid'];
$payment_info['alive_days'] = $package_info['days'];
$payment_info['is_featured'] = $package_info['is_featured'];
$gd_post_info = array_merge($gd_post_info, $payment_info);
}
$custom_metaboxes = geodir_post_custom_fields('', 'all', $request_info['listing_type']);
foreach ($custom_metaboxes as $key => $val) {
$name = $val['name'];
$type = $val['type'];
$extrafields = $val['extra_fields'];
if (trim($type) == 'address') {
$prefix = $name . '_';
$address = $prefix . 'address';
if (isset($request_info[$address]) && $request_info[$address] != '') {
$gd_post_info[$address] = $request_info[$address];
}
if ($extrafields != '') {
$extrafields = unserialize($extrafields);
if (!isset($request_info[$prefix . 'city']) || $request_info[$prefix . 'city'] == '') {
$location_result = geodir_get_default_location();
$gd_post_info[$prefix . 'city'] = $location_result->city;
$gd_post_info[$prefix . 'region'] = $location_result->region;
$gd_post_info[$prefix . 'country'] = $location_result->country;
$gd_post_info['post_locations'] = '[' . $location_result->city_slug . '],[' . $location_result->region_slug . '],[' . $location_result->country_slug . ']';
// set all overall post location
} else {
$gd_post_info[$prefix . 'city'] = $request_info[$prefix . 'city'];
$gd_post_info[$prefix . 'region'] = $request_info[$prefix . 'region'];
$gd_post_info[$prefix . 'country'] = $request_info[$prefix . 'country'];
//----------set post locations when import dummy data-------
$location_result = geodir_get_default_location();
$gd_post_info['post_locations'] = '[' . $location_result->city_slug . '],[' . $location_result->region_slug . '],[' . $location_result->country_slug . ']';
// set all overall post location
//-----------------------------------------------------------------
}
if (isset($extrafields['show_zip']) && $extrafields['show_zip'] && isset($request_info[$prefix . 'zip'])) {
$gd_post_info[$prefix . 'zip'] = $request_info[$prefix . 'zip'];
}
if (isset($extrafields['show_map']) && $extrafields['show_map']) {
if (isset($request_info[$prefix . 'latitude']) && $request_info[$prefix . 'latitude'] != '') {
$gd_post_info[$prefix . 'latitude'] = $request_info[$prefix . 'latitude'];
}
if (isset($request_info[$prefix . 'longitude']) && $request_info[$prefix . 'longitude'] != '') {
$gd_post_info[$prefix . 'longitude'] = $request_info[$prefix . 'longitude'];
}
if (isset($request_info[$prefix . 'mapview']) && $request_info[$prefix . 'mapview'] != '') {
$gd_post_info[$prefix . 'mapview'] = $request_info[$prefix . 'mapview'];
}
if (isset($request_info[$prefix . 'mapzoom']) && $request_info[$prefix . 'mapzoom'] != '') {
$gd_post_info[$prefix . 'mapzoom'] = $request_info[$prefix . 'mapzoom'];
}
}
// show lat lng
if (isset($extrafields['show_latlng']) && $extrafields['show_latlng'] && isset($request_info[$prefix . 'latlng'])) {
$gd_post_info[$prefix . 'latlng'] = $request_info[$prefix . 'latlng'];
}
}
} elseif (trim($type) == 'file') {
if (isset($request_info[$name])) {
$request_files = array();
if ($request_info[$name] != '') {
$request_files = explode(",", $request_info[$name]);
}
$extrafields = $extrafields != '' ? maybe_unserialize($extrafields) : NULL;
geodir_save_post_file_fields($last_post_id, $name, $request_files, $extrafields);
}
} elseif (trim($type) == 'datepicker') {
$datetime = '';
if ($request_info[$name] != '') {
$date_format = geodir_default_date_format();
if (isset($val['extra_fields']) && $val['extra_fields'] != '') {
$extra_fields = unserialize($val['extra_fields']);
$date_format = isset($extra_fields['date_format']) && $extra_fields['date_format'] != '' ? $extra_fields['date_format'] : $date_format;
}
$search = array('dd', 'mm', 'yy');
$replace = array('d', 'm', 'Y');
$date_format = str_replace($search, $replace, $date_format);
$post_htmlvar_value = $date_format == 'd/m/Y' ? str_replace('/', '-', $request_info[$name]) : $request_info[$name];
// PHP doesn't work well with dd/mm/yyyy format
$datetime = date("Y-m-d", strtotime($post_htmlvar_value));
}
$gd_post_info[$name] = $datetime;
} else {
if ($type == 'multiselect') {
if (isset($request_info[$name])) {
$gd_post_info[$name] = $request_info[$name];
} else {
if (isset($request_info['gd_field_' . $name])) {
$gd_post_info[$name] = '';
/* fix de-select for multiselect */
}
}
} else {
if (isset($request_info[$name])) {
$gd_post_info[$name] = $request_info[$name];
}
}
}
}
if (isset($request_info['post_dummy']) && $request_info['post_dummy'] != '') {
$gd_post_info['post_dummy'] = $request_info['post_dummy'];
}
// Save post detail info in detail table
if (!empty($gd_post_info)) {
geodir_save_post_info($last_post_id, $gd_post_info);
}
// Set categories to the listing
if (isset($request_info['post_category']) && !empty($request_info['post_category'])) {
$post_category = array();
foreach ($request_info['post_category'] as $taxonomy => $cat) {
if ($dummy) {
$post_category = $cat;
} else {
if (!is_array($cat) && strstr($cat, ',')) {
$cat = explode(',', $cat);
}
if (!empty($cat) && is_array($cat)) {
$post_category = array_map('intval', $cat);
}
}
wp_set_object_terms($last_post_id, $post_category, $taxonomy);
}
$post_default_category = isset($request_info['post_default_category']) ? $request_info['post_default_category'] : '';
$post_category_str = isset($request_info['post_category_str']) ? $request_info['post_category_str'] : '';
geodir_set_postcat_structure($last_post_id, $taxonomy, $post_default_category, $post_category_str);
}
$post_tags = '';
// Set tags to the listing
if (isset($request_info['post_tags']) && !is_array($request_info['post_tags']) && !empty($request_info['post_tags'])) {
$post_tags = explode(",", $request_info['post_tags']);
} elseif (isset($request_info['post_tags']) && is_array($request_info['post_tags'])) {
if ($dummy) {
$post_tags = $request_info['post_tags'];
}
} else {
if ($dummy) {
$post_tags = array($request_info['post_title']);
}
}
if (is_array($post_tags)) {
$taxonomy = $request_info['listing_type'] . '_tags';
wp_set_object_terms($last_post_id, $post_tags, $taxonomy);
}
// Insert attechment
if (isset($request_info['post_images']) && !is_wp_error($last_post_id)) {
if (!$dummy) {
$tmpimgArr = trim($request_info['post_images'], ",");
$tmpimgArr = explode(",", $tmpimgArr);
geodir_save_post_images($last_post_id, $tmpimgArr, $dummy);
} else {
geodir_save_post_images($last_post_id, $request_info['post_images'], $dummy);
}
} elseif (!isset($request_info['post_images']) || $request_info['post_images'] == '') {
/* Delete Attachments
$postcurr_images = geodir_get_images($last_post_id);
$wpdb->query(
$wpdb->prepare(
"DELETE FROM ".GEODIR_ATTACHMENT_TABLE." WHERE `post_id` = %d",
array($last_post_id)
)
);
geodir_remove_attachments($postcurr_images);
$gd_post_featured_img = array();
$gd_post_featured_img['featured_image'] = '';
geodir_save_post_info($last_post_id, $gd_post_featured_img);
*/
}
geodir_remove_temp_images();
geodir_set_wp_featured_image($last_post_id);
/**
* Called after a listing is saved to the database and before any email have been sent.
*
* @since 1.0.0
* @param int $last_post_id The saved post ID.
* @param array $request_info The post details in an array.
* @see 'geodir_after_save_listinginfo'
*/
do_action('geodir_after_save_listing', $last_post_id, $request_info);
//die;
if ($send_post_submit_mail) {
// if new post send out email
$to_name = geodir_get_client_name($current_user->ID);
geodir_sendEmail('', '', $current_user->user_email, $to_name, '', '', $request_info, 'post_submit', $last_post_id, $current_user->ID);
}
/*
* Unset the session so we don't loop.
*/
if (isset($_SESSION['listing'])) {
unset($_SESSION['listing']);
}
return $last_post_id;
}
/**
* 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();
}
