/**
* 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;
}
/**
* temp function to set post attachment.
*
* @since 1.0.0
* @package GeoDirectory
* @global object $wpdb WordPress Database object.
* @global string $plugin_prefix Geodirectory plugin table prefix.
*/
function geodir_temp_set_post_attachment()
{
global $wpdb, $plugin_prefix;
$all_postypes = geodir_get_posttypes();
foreach ($all_postypes as $posttype) {
$tablename = $plugin_prefix . $posttype . '_detail';
$get_post_data = $wpdb->get_results("SELECT post_id FROM " . $tablename);
if (!empty($get_post_data)) {
foreach ($get_post_data as $data) {
$post_id = $data->post_id;
$attachment_data = $wpdb->get_results("SELECT * FROM " . GEODIR_ATTACHMENT_TABLE . " WHERE post_id =" . $post_id . " AND file!=''");
if (!empty($attachment_data)) {
foreach ($attachment_data as $attach) {
$file_info = pathinfo($attach->file);
$sub_dir = '';
if ($file_info['dirname'] != '.' && $file_info['dirname'] != '..') {
$sub_dir = stripslashes_deep($file_info['dirname']);
}
$uploads = wp_upload_dir(trim($sub_dir, '/'));
// Array of key => value pairs
$uploads_baseurl = $uploads['baseurl'];
$uploads_path = $uploads['basedir'];
$file_name = $file_info['basename'];
$img_arr['path'] = $uploads_path . $sub_dir . '/' . $file_name;
if (!file_exists($img_arr['path'])) {
$wpdb->query("DELETE FROM " . GEODIR_ATTACHMENT_TABLE . " WHERE ID=" . $attach->ID);
}
}
$attachment_data = $wpdb->get_row("SELECT ID, MIN(`menu_order`) FROM " . GEODIR_ATTACHMENT_TABLE . " WHERE post_id=" . $post_id . " GROUP BY post_id");
if (!empty($attachment_data)) {
if ($attachment_data->ID) {
$wpdb->query("UPDATE " . GEODIR_ATTACHMENT_TABLE . " SET menu_order=1 WHERE ID=" . $attachment_data->ID);
}
} else {
if (has_post_thumbnail($post_id)) {
$post_thumbnail_id = get_post_thumbnail_id($post_id);
wp_delete_attachment($post_thumbnail_id);
}
}
$wpdb->query("UPDATE " . $tablename . " SET featured_image='' WHERE post_id =" . $post_id);
geodir_set_wp_featured_image($post_id);
}
}
}
}
}
/**
* Duplicate post images for WPML translation post.
*
* @since 1.5.0
*
* @global object $wpdb WordPress Database object.
*
* @param int $master_post_id Original Post ID.
* @param int $tr_post_id Translation Post ID.
* @param string $lang Language code for translating post.
* @return bool True for success, False for fail.
*/
function geodir_icl_duplicate_post_images($master_post_id, $tr_post_id, $lang)
{
global $wpdb;
$query = $wpdb->prepare("DELETE FROM " . GEODIR_ATTACHMENT_TABLE . " WHERE mime_type like %s AND post_id = %d", array('%image%', $tr_post_id));
$wpdb->query($query);
$query = $wpdb->prepare("SELECT * FROM " . GEODIR_ATTACHMENT_TABLE . " WHERE mime_type like %s AND post_id = %d ORDER BY menu_order ASC", array('%image%', $master_post_id));
$post_images = $wpdb->get_results($query);
if (!empty($post_images)) {
foreach ($post_images as $post_image) {
$image_data = (array) $post_image;
unset($image_data['ID']);
$image_data['post_id'] = $tr_post_id;
$wpdb->insert(GEODIR_ATTACHMENT_TABLE, $image_data);
geodir_set_wp_featured_image($tr_post_id);
}
return true;
}
return false;
}