*/
class Aretk_Crea_Admin
{
/**
* The ID of this plugin.
*
* @since 1.0.0
* @access private
* @var string $plugin_name The ID of this plugin.
*/
private $plugin_name;
/**
* The version of this plugin.
*
* @since 1.0.0
* @access private
* @var string $version The current version of this plugin.
*/
private $version;
/**
* Initialize the class and set its properties.
*
* @since 1.0.0
* @param string $plugin_name The name of this plugin.
* @param string $version The version of this plugin.
*/
public function __construct( $plugin_name, $version ) {
$this->plugin_name = $plugin_name;
$this->version = $version;
}
/**
* Register the stylesheets for the admin area.
*
* @since 1.0.0
*/
public function aretkcrea_enqueue_styles() {
/**
* This function is provided for demonstration purposes only.
*
* An instance of this class should be passed to the run() function
* defined in Aretk_Crea_Loader as all of the hooks are defined
* in that particular class.
*
* The Aretk_Crea_Loader will then create the relationship
* between the defined hooks and the functions defined in this
* class.
*/
wp_enqueue_style( 'jquery.bxslider-css', plugin_dir_url( __FILE__ ) . 'css/jquery.bxslider.css', array(), $this->version, 'all' );
wp_enqueue_style( $this->plugin_name, plugin_dir_url( __FILE__ ) . 'css/aretk-crea-admin.css', array(), $this->version, 'all' );
wp_enqueue_style( 'media-css', plugin_dir_url( __FILE__ ) . 'css/media.css', array(), $this->version, 'all' );
wp_enqueue_style( 'jQuery-ui-style', plugin_dir_url( __FILE__ ) . 'css/jquery-ui.css', array(), $this->version, 'all' );
wp_enqueue_style( 'jQuery-imageupload.js', plugin_dir_url( __FILE__ ) . 'css/imageupload.css', array(), $this->version, 'all' );
wp_enqueue_style( 'jquery.dataTables', plugin_dir_url( __FILE__ ) . 'css/jquery.dataTables.css', array(), $this->version, 'all' );
wp_enqueue_style( 'jquery-choosen-css', plugin_dir_url( __FILE__ ) . 'css/chosen.css', array(), $this->version, 'all' );
wp_enqueue_style( 'jquery-simple-dtpicker-css', plugin_dir_url( __FILE__ ) . 'css/jquery.simple-dtpicker.css', array(), 'all' );
wp_enqueue_style( 'lightcase-css', plugin_dir_url( __FILE__ ) . 'css/lightcase.css',array(), $this->version, 'all' );
}
/**
* Register JavaScripts for the admin area.
*
* @since 1.0.0
*/
public function aretkcrea_enqueue_scripts() {
wp_enqueue_script('jquery-ui');
wp_enqueue_script('jquery-ui-slider');
wp_enqueue_script('jquery-ui-tabs');
wp_enqueue_script('jquery-ui-dialog');
wp_enqueue_script('jquery-ui-datepicker');
wp_enqueue_script( 'jquery-ui-sortable');
wp_enqueue_script( 'jquery-ui-accordion');
$google_map_api = get_option('google-map-api-name');
$google_map_script_loaded_or_not = get_option('crea_google_map_script_load_or_not');
$google_map_api_key_pass = '';
if( isset( $google_map_api ) && !empty( $google_map_api) ) {
$google_map_api_results = $google_map_api;
$google_map_api_key_pass .= "?key=$google_map_api_results";
}
wp_enqueue_script( 'jquery.dataTables.min', plugin_dir_url( __FILE__ ) . 'js/jquery.dataTables.min.js', array( 'jquery' ), $this->version, false );
wp_enqueue_script( 'bxlsider-public', plugin_dir_url( __FILE__ ) . 'js/jquery.bxslider.js', array( 'jquery' ), $this->version);
if( $google_map_script_loaded_or_not === 'Yes' || empty( $google_map_script_loaded_or_not ) ) {
wp_enqueue_script( 'google-map-js', "https://maps.googleapis.com/maps/api/js$google_map_api_key_pass", array( 'jquery' ));
wp_enqueue_script( $this->plugin_name, plugin_dir_url( __FILE__ ) . 'js/aretk-crea-admin.js', array( 'jquery', 'google-map-js' ), $this->version, false );
} else {
wp_enqueue_script( $this->plugin_name, plugin_dir_url( __FILE__ ) . 'js/aretk-crea-admin.js', array( 'jquery' ), $this->version, false );
}
wp_enqueue_script( 'accordion-aretk', plugin_dir_url( __FILE__ ) . 'js/accordion.js', array( 'jquery' ), $this->version);
wp_enqueue_script( 'validate-new', plugin_dir_url( __FILE__ ) . 'js/jquery.validate.min.js', array( 'jquery' ), $this->version);
if(isset($_GET['page']) && $_GET['page'] == 'create_new_leads') {
wp_enqueue_script('lead-form', plugin_dir_url( __FILE__ ) . 'js/lead-form.js', array( 'jquery' ), false );
}
wp_localize_script( $this->plugin_name, 'cancelicon', array('cancelurl' => ARETK_CREA_PLUGIN_URL.'admin/images/delete-icon.png'));
wp_localize_script( $this->plugin_name, 'adminajaxjs', array('adminajaxjsurl' => admin_url( 'admin-ajax.php' )));
wp_localize_script( $this->plugin_name, 'refreshicon', array('refreshurl' => ARETK_CREA_PLUGIN_URL.'admin/images/refresh-animated.gif' ));
wp_localize_script( $this->plugin_name, 'ajaxicon', array('loderurl' => ARETK_CREA_PLUGIN_URL.'admin/images/ajax-loader.gif') );
wp_localize_script( $this->plugin_name, 'refreshimagejs', array('refreshimagejsurl' => ARETK_CREA_PLUGIN_URL.'admin/js/imageupload.js' ));
wp_enqueue_script( 'mousewheel', plugin_dir_url( __FILE__ ) . 'js/jquery.mousewheel-3.0.6.pack.js', array( 'jquery' ), $this->version);
wp_enqueue_script( 'imageupload', plugin_dir_url( __FILE__ ) . 'js/imageupload.js', array( 'jquery' ), $this->version);
wp_enqueue_script( 'colorpicker1', plugin_dir_url( __FILE__ ) . 'js/jscolor.js', array( 'jquery' ), $this->version);
wp_enqueue_script( 'colorpicker2', plugin_dir_url( __FILE__ ) . 'js/jscolor.min.js', array( 'jquery' ), $this->version);
wp_enqueue_script( 'jquery.dataTables', plugin_dir_url( __FILE__ ) . 'js/jquery.dataTables.min.js', array( 'jquery' ), $this->version);
wp_enqueue_script( 'choosen', plugin_dir_url( __FILE__ ) . 'js/chosen.jquery.js', array( 'jquery' ),$this->version);
wp_enqueue_script( 'jquery-simple-dtpicker-js', plugin_dir_url( __FILE__ ) . 'js/jquery.simple-dtpicker.js', array( 'jquery' ));
wp_enqueue_script( 'copytoclipboard', plugin_dir_url( __FILE__ ) . 'js/clipboard.min.js', array( 'jquery' ), $this->version);
wp_enqueue_script( 'lightcase', plugin_dir_url( __FILE__ ) . 'js/lightcase.js', array( 'jquery' ), $this->version);
wp_enqueue_script( 'loader-js', plugin_dir_url( __FILE__ ) . 'js/modernizr.js', array( 'jquery' ), $this->version);
}
/**
* create aretk crea admin menu
*
*/
public function aretkcrea_crea_custom_menu()
{
$new_menu = NULL;
if (!empty($_GET['new_menu']) && $_GET['new_menu'] === 'true'){
$new_menu = 'true';
}
if ($new_menu !== 'true')
{
$aretk_plugin_slug = 'listings_settings';
add_menu_page('crea-plugin','Real Estate','manage_options',$aretk_plugin_slug,'aretkcrea_custom_listings_settings_function', ARETK_CREA_PLUGIN_URL.'admin/images/icon-main-menu.png');
add_submenu_page($aretk_plugin_slug, 'Listings', 'Listings', 'manage_options', $aretk_plugin_slug, 'aretkcrea_custom_listings_settings_function' );
$listings_settings_form = isset($_GET['page']) ? sanitize_text_field($_GET['page']) : '';
if( $listings_settings_form === 'listings_settings' || $listings_settings_form === 'create_new_listings' ) {
add_submenu_page($aretk_plugin_slug,'create-new-listing',' - Add New Listing','manage_options','create_new_listings','aretkcrea_custom_create_new_listings_function');
}
add_submenu_page($aretk_plugin_slug,'showcase-settings','Showcases','manage_options','showcase_settings','aretkcrea_custom_showcase_settings_function');
$showcase_form = isset($_GET['page']) ? sanitize_text_field($_GET['page']) : '';
if( $showcase_form === 'showcase_settings' || $showcase_form === 'create_new_showcase' || $showcase_form === 'listing_details_settings' || $showcase_form === 'search_listing_settings_showcase' || $showcase_form === 'default_listing_settings_showcase' )
{
add_submenu_page($aretk_plugin_slug,'create-new-showcase',' - Add New Showcase','manage_options','create_new_showcase','aretkcrea_custom_create_new_showcase_function');
add_submenu_page('null','default-listing-settings-showcase','DEFAULT LISTING SETTING SHOWCASE','manage_options','default_listing_settings_showcase','aretkcrea_default_listing_settings_fn');
add_submenu_page('null','search-listing-settings-showcase','SEARCH LISTING SETTING SHOWCASE','manage_options','search_listing_settings_showcase','aretkcrea_search_listing_settings_fn');
add_submenu_page('null','listing-details-settings','LISTING DETAILS SETTING','manage_options','listing_details_settings','aretkcrea_custom_listing_details_settings');
}
add_submenu_page($aretk_plugin_slug,'leads-settings','Leads','manage_options','leads_settings','aretkcrea_custom_leads_settings_function');
//add submenu for LEADS Settings
$lead_form = isset($_GET['post_type']) ? sanitize_text_field($_GET['post_type']) : '';
$lead_form_page = isset($_GET['page']) ? sanitize_text_field ($_GET['page']) : '';
$lead_form_category_rexonomy = isset($_GET['taxonomy']) ? sanitize_text_field($_GET['taxonomy']) :'';
if( $lead_form_page === 'leads_form' || $lead_form === 'aretk_lead' || $lead_form_page === 'leads_settings' || $lead_form_page === 'create_new_leads' || $lead_form_page === 'send_email_leads' || $lead_form_page === 'import_leads' || $lead_form_category_rexonomy === 'lead-category' || $lead_form_page === 'create_new_lead_category')
{
add_submenu_page($aretk_plugin_slug,'create-new-leads',' - Add New Lead','manage_options','create_new_leads','aretkcrea_custom_create_new_leads_function');
add_submenu_page($aretk_plugin_slug,'send-email-leads',' - Send Email','manage_options','send_email_leads','aretkcrea_custom_send_email_leads_function');
add_submenu_page($aretk_plugin_slug,'create-new-lead-category',' - Lead Categories','manage_options','create_new_lead_category','aretkcrea_custom_create_new_lead_category_function');
add_submenu_page($aretk_plugin_slug,'leads-form',' - Lead Forms','manage_options','leads_form','aretkcrea_custom_leads_form_function');
add_submenu_page($aretk_plugin_slug,'import-leads',' - Import Leads','manage_options','import_leads','aretkcrea_custom_import_leads_function');
}
add_submenu_page($aretk_plugin_slug,'crea-plugin','Datafeed Subscription','manage_options','crea-plugin','aretkcrea_custom_crea_plugins_function');
$getSubscriptionStatus = get_option('crea_subscription_status', true);
if (isset( $getSubscriptionStatus ) && !empty( $getSubscriptionStatus) && $getSubscriptionStatus === 'valid') {
add_submenu_page($aretk_plugin_slug,'crea-settings','CREA DDF® Settings','manage_options','crea_settings','aretkcrea_custom_crea_settings_function');
}
add_submenu_page($aretk_plugin_slug,'plugin-settings','Plugin Settings','manage_options','plugin_settings','aretkcrea_custom_plugin_settings_function');
add_submenu_page($aretk_plugin_slug,'support-settings','Support','manage_options','support_settings','aretkcrea_custom_support_settings_function');
} else {
//add admin main Crea plugins menu
add_menu_page( 'crea-plugin','ARETK', 'manage_options','crea_plugins', 'aretkcrea_custom_crea_plugins_function',ARETK_CREA_PLUGIN_URL.'admin/images/icon.png');
/**
* add admin sub menu in plugins
* crea_settings ,listings_settings,showcase_settings,leads_settings,support_settings ,plugin_settings
*/
$getSubscriptionStatus = get_option('crea_subscription_status', true);
if (isset( $getSubscriptionStatus ) && !empty( $getSubscriptionStatus) && $getSubscriptionStatus === 'valid') {
add_submenu_page('crea_plugins','crea-settings','CREA DDF® Settings','manage_options','crea_settings','aretkcrea_custom_crea_settings_function');
}
add_submenu_page('crea_plugins','listings-settings','LISTINGS','manage_options','listings_settings','aretkcrea_custom_listings_settings_function');
//add submenu for Listings settings
$listings_settings_form = isset($_GET['page']) ? sanitize_text_field($_GET['page']) : '';
if( isset( $listings_settings_form ) && ( $listings_settings_form === 'listings_settings' || $listings_settings_form === 'create_new_listings' ) ) {
add_submenu_page('crea_plugins','create-new-listings','Add New Listing','manage_options','create_new_listings','aretkcrea_custom_create_new_listings_function');
}
add_submenu_page('crea_plugins','showcase-settings','SHOWCASES','manage_options','showcase_settings','aretkcrea_custom_showcase_settings_function');
$showcase_form = isset( $_GET['page'] ) ? sanitize_text_field($_GET['page']) : '';
if( isset($showcase_form) && ($showcase_form === 'showcase_settings' || $showcase_form === 'create_new_showcase' || $showcase_form === 'listing_details_settings' || $showcase_form === 'search_listing_settings_showcase' || $showcase_form === 'default_listing_settings_showcase') )
{
add_submenu_page('crea_plugins','create-new-showcase','ADD NEW SHOWCASE','manage_options','create_new_showcase','aretkcrea_custom_create_new_showcase_function');
add_submenu_page('null','listing-details-settings','LISTING DETAILS SETTING','manage_options','listing_details_settings','aretkcrea_custom_listing_details_settings');
add_submenu_page('null','search-listing-settings-showcase','SEARCH LISTING SETTING SHOWCASE','manage_options','search_listing_settings_showcase','aretkcrea_search_listing_settings_fn');
add_submenu_page('null','default-listing-settings-showcase','DEFAULT LISTING SETTING SHOWCASE','manage_options','default_listing_settings_showcase','aretkcrea_default_listing_settings_fn');
}
add_submenu_page('crea_plugins','leads-settings','LEADS','manage_options','leads_settings','aretkcrea_custom_leads_settings_function');
//add submenu for LEADS Settings
$lead_form = isset($_GET['post_type']) ? sanitize_text_field($_GET['post_type']) : '';
$lead_form_page = isset($_GET['page']) ? sanitize_text_field($_GET['page']) : '';
$lead_form_category_rexonomy = isset($_GET['taxonomy']) ? sanitize_text_field($_GET['taxonomy']) : '';
if( $lead_form_page === 'leads_form' || $lead_form === 'aretk_lead' || $lead_form_page === 'leads_settings' || $lead_form_page === 'create_new_leads' || $lead_form_page === 'send_email_leads' || $lead_form_page === 'import_leads' || $lead_form_category_rexonomy === 'lead-category' || $lead_form_page === 'create_new_lead_category')
{
add_submenu_page('crea_plugins','leads-form','LEADS forms','manage_options','leads_form','aretkcrea_custom_leads_form_function');
add_submenu_page('crea_plugins','create-new-leads','ADD New LEAD','manage_options','create_new_leads','aretkcrea_custom_create_new_leads_function');
add_submenu_page('crea_plugins','send-email-leads','SEND EMAIL','manage_options','send_email_leads','aretkcrea_custom_send_email_leads_function');
add_submenu_page('crea_plugins','import-leads','IMPORT LEADS','manage_options','import_leads','aretkcrea_custom_import_leads_function');
add_submenu_page('crea_plugins','create-new-lead-category','ADD NEW LEAD CATEGORY','manage_options','create_new_lead_category','aretkcrea_custom_create_new_lead_category_function');
}
add_submenu_page('crea_plugins','plugin-settings','SETTINGS','manage_options','plugin_settings','aretkcrea_custom_plugin_settings_function');
add_submenu_page('crea_plugins','support-settings','SUPPORT','manage_options','support_settings','aretkcrea_custom_support_settings_function');
}
/**
* create function for aretkcrea_custom_crea_plugins_function
*/
function aretkcrea_custom_crea_plugins_function () {
esc_html(aretkcrea_custom_crea_plugin_html());
}
/**
* create function for aretkcrea_custom_crea_settings_function
*/
function aretkcrea_custom_crea_settings_function () {
esc_html(aretkcrea_custom_crea_settings_html());
}
/**
* create function for aretkcrea_custom_listings_settings_function
*/
function aretkcrea_custom_listings_settings_function () {
if ( isset($_GET['id']) && is_numeric($_GET['id'])){
esc_html(aretkcrea_custom_listings_settings_maplisting_html());
} else {
esc_html(aretkcrea_custom_listings_settings_html());
}
}
function aretkcrea_custom_create_new_listings_function() {
esc_html(aretkcrea_custom_create_listings_settings_html());
}
/**
* create function for aretkcrea_custom_showcase_settings_function
*/
function aretkcrea_custom_showcase_settings_function () {
esc_html(aretkcrea_custom_showcase_settings_html());
}
/**
* create function for aretkcrea_custom_create_new_showcase_function
*/
function aretkcrea_custom_create_new_showcase_function() {
esc_html(aretkcrea_custom_new_create_showcase_html());
}
/**
* create function for aretkcrea_custom_leads_settings_function
*/
function aretkcrea_custom_leads_settings_function () {
esc_html(aretkcrea_custom_leads_settings_html());
}
/**
* create function for custom new lead category
*/
function aretkcrea_custom_create_new_lead_category_function () {
esc_html(aretkcrea_custom_create_new_lead_category_html());
}
/**
* create function for aretkcrea_custom_support_settings_function
*/
function aretkcrea_custom_support_settings_function () {
esc_html(aretkcrea_custom_support_settings_html());
}
/**
* create function for aretkcrea_search_listing_settings_fn
*/
function aretkcrea_search_listing_settings_fn() {
esc_html(aretkcrea_search_listing_settings_html());
}
/**
* create function for aretkcrea_default_listing_settings_fn
*/
function aretkcrea_default_listing_settings_fn() {
esc_html(aretkcrea_default_listing_settings_html());
}
/**
* create function for aretkcrea_custom_plugin_settings_function
*/
function aretkcrea_custom_plugin_settings_function () {
esc_html(aretkcrea_custom_plugin_settings_html());
}
/**
* create function for aretkcrea_custom_plugin_lead_form_function
*/
function aretkcrea_custom_leads_form_function () {
esc_html(aretkcrea_custom_lead_form_listing());
}
/**
* create function for aretkcrea_custom_create_new_leads_function
*/
function aretkcrea_custom_create_new_leads_function () {
esc_html(aretkcrea_custom_create_new_leads_form());
}
/**
* create function for aretkcrea_custom_send_email_leads_function
*/
function aretkcrea_custom_send_email_leads_function () {
esc_html(aretkcrea_custom_send_email_leads_form());
}
/**
* create function for aretkcrea_custom_listing_details_settings
*/
function aretkcrea_custom_listing_details_settings () {
esc_html(aretkcrea_custom_showcase_listing_detail_settings());
}
/**
* create function for aretkcrea_custom_import_leads_function
*/
function aretkcrea_custom_import_leads_function() {
esc_html(aretkcrea_custom_import_leads_html());
}
}
/**
* Remove Custom post type Lead from Admin Menu
*
* @return Remove custom post type Lead
* @package Phase 1
* @since Phase 1
* @version
* @param null
*/
public function aretkcrea_remove_custom_post_lead_from_admin_menu(){
remove_menu_page( 'edit.php?post_type=aretk_lead' );
remove_menu_page( 'edit.php?post_type=aretk_listing' );
remove_menu_page( 'edit.php?post_type=aretk_showcase' );
}
/**
* Add/Remove appropriate CSS classes to Menu so Submenu displays open and the Menu link is styled appropriately.
*
* @return Remove custom post type Lead
* @package Phase 1
* @since Phase 1
* @version
* @param null
*/
public function aretkcrea_current_menu( ) {
$screen = get_current_screen();
if ( $screen->id == 'edit-lead-category') {
add_action( 'all_admin_notices', 'aretkcrea_action_all_admin_notices', 10, 2 );
function aretkcrea_action_all_admin_notices ()
{
$link_url_leads = admin_url('edit.php?post_type=aretk_lead');
$link_url_create_new_lead = admin_url('admin.php?page=create_new_leads');
$link_url_send_email_lead = admin_url('admin.php?page=send_email_leads');
$link_url_lead_category = admin_url('edit-tags.php?taxonomy=lead-category');
$link_url_lead_forms = admin_url('admin.php?page=leads_form');
$link_url_import_leads = admin_url('admin.php?page=import_leads');
echo '';
}
}
if ( $screen->id == 'edit-aretk_lead')
{
add_action( 'all_admin_notices', 'aretkcrea_action_lead_post_content_admin_notices', 10, 2 );
function aretkcrea_action_lead_post_content_admin_notices () {
echo 'Manage all your Leads in one place!
'.str_replace('\"', '"', $send_email_text).'
'.__(ARETKCREA_ADD_LISTING_TABLE_PHOTO,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_MLS,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_ADDRESS,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_CITY,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_PRICE,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_AGENT_NAME,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_VIEWS,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_DATE,ARETKCREA_PLUGIN_SLUG).'
';
foreach ($resultArr as $singleListing) {
if (isset($singleListing->post_author) && !empty($singleListing->post_author))
{
$ListingAddress = get_post_meta($singleListing->ID,'listingAddress',true);
$ListingCity = get_post_meta($singleListing->ID,'listingcity',true);
$ListingPrice = get_post_meta($singleListing->ID,'listingPrice',true);
$date = date('d-m-Y',strtotime($singleListing->post_date));
$crea_listing_images_detail_table_name = $wpdb->prefix.ARETKCREA_LISTING_IMAGES_HISTORY;
$sql_select = "SELECT `image_url` FROM `$crea_listing_images_detail_table_name` WHERE `image_position`=1 AND `unique_id`= %d";
$sql_prep = $wpdb->prepare( $sql_select, $singleListing->ID );
$resultSet = $wpdb->get_results($sql_prep);
if (isset($resultSet) && !empty($resultSet)) {
$path = $resultSet[0]->image_url;
} else {
$path = ARETK_CREA_PLUGIN_URL.'admin/images/dummy_image.png';
}
$agentArrDecoded = get_post_meta($singleListing->ID,'listingAgentId',true);
$listingpageval = get_post_meta($singleListing->ID,'crea_aretk_db_listing_page_count',true);
$listingpagecount = 0;
if( !empty( $listingpageval ) && $listingpageval !='' ) {
$listingpagecount = $listingpageval;
} else {
$listingpagecount = 0;
}
$agentArr = json_decode($agentArrDecoded);
if (isset($agentArr) && !empty($agentArr))
{
$htmlAgent = '';
$crea_agent_table_name = $wpdb->prefix.ARETKCREA_AGENT_TABLE;
foreach ($agentArr as $singleAgent)
{
$sql_select = "SELECT `crea_agent_name` FROM `$crea_agent_table_name` WHERE `crea_agent_id`= %s";
$sql_prep = $wpdb->prepare( $sql_select, $singleAgent );
$resultAgentArr = $wpdb->get_results($sql_prep);
if ( isset($resultAgentArr) && !empty($resultAgentArr) ){
$htmlAgent .= $resultAgentArr[0]->crea_agent_name . ', ';
}
}
}
$link_url = admin_url('admin.php?page=create_new_listings&id='.$singleListing->ID);
$html .= '
ExclusiveEdit | Trash
'.$ListingAddress.'
'.$ListingCity.'
$'.$ListingPrice.'
'.rtrim($htmlAgent,', ').'
'.$listingpagecount.'
'.$date.'
';
} else {
$htmlAgent = '';
foreach ($singleListing->listing_agents as $singleAgent) {
$htmlAgent .= $singleAgent->Name.', ';
}
if (is_object ($singleListing->listing_photos)) {
if ($singleListing->listing_photos->URL == '' || $singleListing->listing_photos->URL == null) {
$apiListingImageURL = ARETK_CREA_PLUGIN_URL.'admin/images/dummy_image.png';
} else {
$apiListingImageURL = $singleListing->listing_photos->URL;
}
} else if (is_object ($singleListing->listing_photos[0])) {
if ($singleListing->listing_photos[0]->URL == '' || $singleListing->listing_photos[0]->URL == null) {
$apiListingImageURL = ARETK_CREA_PLUGIN_URL.'admin/images/dummy_image.png';
} else {
$apiListingImageURL = $singleListing->listing_photos[0]->URL;
}
} else {
$apiListingImageURL = ARETK_CREA_PLUGIN_URL.'admin/images/dummy_image.png';
}
$mlsId = isset($singleListing->mlsID) ? $singleListing->mlsID : '-';
$dates = isset($singleListing->ListingContractDate) ? $singleListing->ListingContractDate : '-';
$listingpagecount = isset( $singleListing->ViewCount ) ? $singleListing->ViewCount : 0;
$link_url = admin_url('admin.php?page=listings_settings&id='. $singleListing->ID);
$html .= '
'.$mlsId.''. __("Map It", ARETKCREA_PLUGIN_SLUG).'
'.$singleListing->StreetAddress.' '.$singleListing->StreetNumber.'
'.$singleListing->City.'
$'.$singleListing->Price.'
'.rtrim($htmlAgent, ', ').'
'.$listingpagecount.'
'.$dates.'
';
}
}
$html .= '
'.__(ARETKCREA_ADD_LISTING_TABLE_PHOTO,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_MLS,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_ADDRESS,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_CITY,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_PRICE,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_AGENT_NAME,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_VIEWS,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_DATE,ARETKCREA_PLUGIN_SLUG).'
';
echo $html;
die();
}
/**
* This function handles the submit for the create listing form data
*
* @param null
* @return null
* @since Phase 1
*/
public function aretkcrea_handle_create_listing_form_action()
{
global $wpdb, $wp;
#-------------------
# Sanitize Data:
# Sanitize $_POST['posttype'], can only equal 'list'
$posttype = NULL;
if (!empty($_POST['posttype']) && $_POST['posttype'] === 'list'){
$posttype = 'list';
}
# Sanitize $_POST['action'], can only equal 'submit-form'
$action = NULL;
if (!empty($_POST['action']) && $_POST['action'] === 'submit-form'){
$action = 'submit-form';
}
# Sanitize $_POST['action-which'], Can only be 'add' or 'edit'
$action_which = NULL;
if (!empty($_POST['action-which']) && $_POST['action-which'] === 'add'){
$action_which = 'add';
} elseif (!empty($_POST['action-which']) && $_POST['action-which'] === 'edit'){
$action_which = 'edit';
}
# Sanitize $_POST['listing_view_agent_id'], can be array of integers
$listingAgentIdArray = isset($_POST['listing_view_agent_id']) ? array_filter($_POST['listing_view_agent_id'], 'ctype_digit') : array();
$listingAgentIds = array();
if( !empty($listingAgentIdArray) && $listingAgentIdArray !='' ){
foreach ( $listingAgentIdArray as $listingAgentIdArraykey ){
if( $listingAgentIdArraykey != '' ){
$listingAgentIds[] = (INT) $listingAgentIdArraykey;
}
}
}
$listingAgentId = json_encode($listingAgentIds);
$listingAddress = isset($_POST['agent_listing_tab_address']) ? sanitize_text_field( ltrim( rtrim( $_POST['agent_listing_tab_address'] ," ") ," ") ) : '';
$listingcity = isset($_POST['agent_listing_tab_city']) ? sanitize_text_field( ltrim( rtrim( $_POST['agent_listing_tab_city'] ," ") ," ") ) : '';
$listingProvince = isset($_POST['agent_listing_tab_Province']) ? sanitize_text_field( ltrim( rtrim( $_POST['agent_listing_tab_Province'] ," ") ," ") ) : '';
$listingAgentStatus = isset($_POST['listing_view_agent_status']) ? sanitize_text_field($_POST['listing_view_agent_status']) : '';
$listingPrice = isset($_POST['agent_listing_tab_price']) ? sanitize_text_field( ltrim( rtrim( $_POST['agent_listing_tab_price'] ," ") ," ") ) : '';
$listingPropertyType = isset($_POST['listing-view-agent-property-type']) ? sanitize_text_field($_POST['listing-view-agent-property-type']) : '';
$listingStructureType = isset($_POST['listing-view-agent-structure-type']) ? sanitize_text_field($_POST['listing-view-agent-structure-type']) : '';
$listingBedRooms = isset($_POST['listing-view-agent-bedrooms']) ? sanitize_text_field($_POST['listing-view-agent-bedrooms']) : '';
$listingBathrooms = isset($_POST['listing-view-agent-bathrooms-full']) ? sanitize_text_field($_POST['listing-view-agent-bathrooms-full']) : '';
$listingBathroomsPartial = isset($_POST['listing-view-agent-bathrooms-partial']) ? sanitize_text_field($_POST['listing-view-agent-bathrooms-partial']) : '';
$listingFinishedBasement = isset($_POST['listing-view-agent-finished-basement']) ? sanitize_text_field($_POST['listing-view-agent-finished-basement']) : '';
$listingDescription = isset($_POST['listing-view-agent-descriptions']) ? sanitize_text_field( $_POST['listing-view-agent-descriptions'] ) : '';
$crea_google_map_latitude = isset($_POST['crea_google_map_latitude']) ? sanitize_text_field($_POST['crea_google_map_latitude']) : '';
$crea_google_map_longitude = isset($_POST['crea_google_map_longitude']) ? sanitize_text_field($_POST['crea_google_map_longitude']) : '';
$crea_google_map_geo_address = isset($_POST['crea_google_map_geo_address']) ? sanitize_text_field( $_POST['crea_google_map_geo_address'] ) : '';
$listingParkingSlot = isset($_POST['listing-view-pa-ga-parking-slot']) ? sanitize_text_field($_POST['listing-view-pa-ga-parking-slot']) : '';
$listingParkinggarage = isset($_POST['listing-view-pa-ga-garage']) ? sanitize_text_field($_POST['listing-view-pa-ga-garage']) : '';
$listingTourUrl = isset($_POST['listing_virtual_tor_add_url']) ? esc_url( ltrim( rtrim( $_POST['listing_virtual_tor_add_url'] ," ") ," ") ): '';
// Sanitize Utilities
$listingAgentUtilityarray = array();
$listingUtilityArray = isset($_POST['crea-utilities-input']) ? $_POST['crea-utilities-input'] : array();
if( !empty($listingUtilityArray) && $listingUtilityArray !='' )
{
foreach ( $listingUtilityArray as $listingUtilityArray_results ){
if( $listingUtilityArray_results != '' ){
$listingAgentUtilityarray[] = sanitize_text_field( ltrim( rtrim( $listingUtilityArray_results," ") ," ") );
}
}
$listingUtilityArr = isset($listingAgentUtilityarray) ? json_encode($listingAgentUtilityarray) : json_encode(array());
}
// Sanitize Features
$listingagentsFeatureArray = array();
$listingFeatureArray = isset($_POST['crea-features-input']) ? $_POST['crea-features-input'] : array();
if( !empty($listingFeatureArray) && $listingFeatureArray !='' ){
foreach ( $listingFeatureArray as $listingFeatureArray_results ){
if( $listingFeatureArray_results != '' ){
$listingagentsFeatureArray[] = sanitize_text_field( ltrim( rtrim( $listingFeatureArray_results," ") ," ") );
}
}
$listingFeatureArr = isset($listingagentsFeatureArray) ? json_encode($listingagentsFeatureArray) : json_encode(array());
}
// Sanitize Open House Date
$listingopenhosedateArr = array();
if ( isset($_POST['crea_home_date_picker']) && $_POST['crea_home_date_picker'] !='' )
{
foreach ( $_POST['crea_home_date_picker'] as $oh_date ){
$listingopenhosedateArr[] = sanitize_text_field($oh_date);
}
}
// Sanitize Open House Start Time
$listingstarttimeArr = array();
$OHstarttimeArr = isset($_POST['crea-open-house-start-time']) ? $_POST['crea-open-house-start-time'] : array();
if ( !empty($OHstarttimeArr) && $OHstarttimeArr != '')
{
foreach($OHstarttimeArr as $oh_time_start){
$listingstarttimeArr[] = sanitize_text_field($oh_time_start);
}
}
// Sanitize Open House End Time
$listingendtimeArr = array();
$OHendtimeArr = isset($_POST['crea-open-house-start-time']) ? $_POST['crea-open-house-start-time'] : array();
if ( !empty($OHendtimeArr) && $OHendtimeArr != '')
{
foreach($OHendtimeArr as $oh_time_end){
$listingendtimeArr[] = sanitize_text_field($oh_time_end);
}
}
$merge_listing_open_house = array();
$op_counter = 0;
foreach ( $listingopenhosedateArr as $listingopenhosedatevalue ) {
$listing_open_house_start_time = $listingstarttimeArr[$op_counter];
$listing_open_house_end_time = $listingendtimeArr[$op_counter];
$merge_listing_open_house[] = array('date'=>$listingopenhosedatevalue,'start_time'=>$listing_open_house_start_time,'end_time'=>$listing_open_house_end_time);
$op_counter++;
}
# End Sanitize Data. Note, media and attachments sanitized later.
#-------------------
$listingPhotosArr = isset($_FILES['file']) ? $_FILES['file'] : NULL;
if (isset($posttype) && $posttype == 'list')
{
$post_unique_title = rand (111111, 999999);
if (isset($_POST) && $action === 'submit-form' && $action_which === 'add')
{
$listingTitle = isset($post_unique_title) ? $post_unique_title : '';
if( $listingAgentId != '' && !empty($listingAgentId) && !empty($listingAddress) && $listingAddress !='' && !empty($listingcity) && $listingcity !='' && !empty($listingProvince) && $listingProvince !='' && !empty($listingAgentStatus) && $listingAgentStatus !='' && !empty($listingPrice) && $listingPrice !='' && !empty($listingPhotosArr) && $listingPhotosArr !='' )
{
$guid = microtime( true );
$guidd = preg_replace( "/\./", "", $guid);
$author_id = (INT) get_current_user_id();
$new_post = array(
'post_title' => $listingTitle,
'post_content' => $listingDescription,
'post_status' => 'publish',
'post_type' => 'aretk_listing'
);
try {
$listingId = wp_insert_post($new_post);
} catch (Exception $e) {
echo 'Caught exception: ', $e->getMessage(), "\n";
}
update_post_meta($listingId,'uniqueId',"$guidd");
update_post_meta($listingId,'listingAgentId'," $listingAgentId");
update_post_meta($listingId,'listingAddress',"$listingAddress");
update_post_meta($listingId,'listingcity',"$listingcity");
update_post_meta($listingId,'listingProvince',"$listingProvince");
update_post_meta($listingId,'listingPrice',"$listingPrice");
update_post_meta($listingId,'listingAgentStatus',"$listingAgentStatus");
update_post_meta($listingId,'listingPropertyType',"$listingPropertyType");
update_post_meta($listingId,'listingStructureType',"$listingStructureType");
update_post_meta($listingId,'listingBedRooms',"$listingBedRooms");
update_post_meta($listingId,'listingBathrooms',"$listingBathrooms");
update_post_meta($listingId,'listingBathroomsPartial',"$listingBathroomsPartial");
update_post_meta($listingId,'listingFinishedBasement',"$listingFinishedBasement");
update_post_meta($listingId,'listingParkingSlot',"$listingParkingSlot");
update_post_meta($listingId,'listingParkinggarage',"$listingParkinggarage");
update_post_meta($listingId,'listingTourUrl',"$listingTourUrl");
update_post_meta($listingId,'listingUtilityArr',"$listingUtilityArr");
update_post_meta($listingId,'listingFeatureArr',"$listingFeatureArr");
update_post_meta($listingId,'listingopenhosedatetimeArr',json_encode($merge_listing_open_house));
update_post_meta($listingId,'listing_type',"exclusive");
update_post_meta($listingId,'crea_google_map_latitude',$crea_google_map_latitude);
update_post_meta($listingId,'crea_google_map_longitude',$crea_google_map_longitude);
update_post_meta($listingId,'crea_google_map_geo_address',$crea_google_map_geo_address);
$getSubscriptionStatus = get_option('crea_subscription_status', '');
if( isset( $getSubscriptionStatus ) && !empty( $getSubscriptionStatus ) && $getSubscriptionStatus === 'valid' ){
update_post_meta($listingId,'crea_listing_subscription_states','valid');
}else {
update_post_meta($listingId,'crea_listing_subscription_states','not-valid');
}
#-------------------
# Sanitize Photos upload
# Only allowing the following image types
$allowedImageMimes = array(
'jpg|jpeg|jpe' => 'image/jpeg',
'gif' => 'image/gif',
'png' => 'image/png',
);
if( !empty($listingPhotosArr) && current_user_can('upload_files') && is_user_logged_in() )
{
$author_id = (INT) get_current_user_id();
$crea_listing_images_detail_table_name = $wpdb->prefix.ARETKCREA_LISTING_IMAGES_HISTORY;
$counter = 1;
for ($j = 0; $j < count($listingPhotosArr['name']); $j++)
{
$uploadfile = array(
'name' => sanitize_file_name($listingPhotosArr['name'][$j]),
'type' => $listingPhotosArr['type'][$j],
'tmp_name' => $listingPhotosArr['tmp_name'][$j],
'error' => $listingPhotosArr['error'][$j],
'size' => $listingPhotosArr['size'][$j]
);
$fileInfo = wp_check_filetype($uploadfile['name'], $allowedImageMimes);
if ( !empty($fileInfo['type']) && $uploadfile['size'] > 0 && $uploadfile['size'] < 2000000 )
{
$uploadInfo = wp_handle_upload($uploadfile, array(
'test_form' => false,
'mimes' => $allowedImageMimes
));
if( isset($uploadInfo['url']) && !isset($uploadInfo['error']) )
{
try {
$wpdb->insert(
"$crea_listing_images_detail_table_name",
array(
'user_id' => (int)$author_id,
'unique_id' => (int) $listingId,
'image_position' => (int)$counter,
'image_url' => esc_url_raw($uploadInfo['url']),
'created_time' => current_time('mysql', 1),
'updated_time' => current_time('mysql', 1),
),
array('%d','%d','%d','%s','%s','%s')
);
$counter++;
} catch (Exception $e) {
echo 'Caught exception: ', $e->getMessage(), "\n";
}
}
}
}
}
# PHOTOS upload END
#-------------------
#-------------------
# Sanitize Attachments Upload
# Only allowing the following doc types
$allowedDocsMimes = array(
'jpg|jpeg|jpe' => 'image/jpeg',
'gif' => 'image/gif',
'png' => 'image/png',
'txt|asc|c|cc|h'=> 'text/plain',
'csv' => 'text/csv',
'tsv' => 'text/tab-separated-values',
'rtx' => 'text/richtext',
'mp3|m4a|m4b' => 'audio/mpeg',
'mp4|m4v' => 'video/mp4',
'mov|qt' => 'video/quicktime',
'pdf' => 'application/pdf',
'doc|docx' => 'application/msword',
'xla|xls|xlsx|xlt|xlw|xlam|xlsb|xlsm|xltm' => 'application/vnd.ms-excel'
);
$listingDocumentArr = isset($_FILES['extdocfileinput']) ? $_FILES['extdocfileinput'] : array();
if( !empty($listingDocumentArr) && current_user_can('upload_files') && is_user_logged_in() )
{
$crea_listing_document_detail_table_name = $wpdb->prefix.ARETKCREA_LISTING_DOCUMENT_HISTORY;
$counter = 1;
for ($k = 0; $k < count($listingDocumentArr['name']); $k++)
{
$uploadfile = array(
'name' => sanitize_file_name($listingDocumentArr['name'][$k]),
'type' => $listingDocumentArr['type'][$k],
'tmp_name' => $listingDocumentArr['tmp_name'][$k],
'error' => $listingDocumentArr['error'][$k],
'size' => $listingDocumentArr['size'][$k]
);
$fileInfo = wp_check_filetype($uploadfile['name'], $allowedDocsMimes);
if ( !empty($fileInfo['type']) && $uploadfile['size'] > 0 && $uploadfile['size'] < 5000000 )
{
$uploadInfo = wp_handle_upload($uploadfile, array(
'test_form' => false,
'mimes' => $allowedDocsMimes
));
if( isset($uploadInfo['url']) && !isset($uploadInfo['error']) )
{
try {
$wpdb->insert(
"$crea_listing_document_detail_table_name",
array(
'user_id' => (int)$author_id,
'unique_id' => (int)$listingId,
'document_url' => esc_url_raw($uploadInfo['url']),
'document_name' => $uploadfile['name'],
'created_time' => current_time('mysql', 1),
'updated_time' => current_time('mysql', 1),
),
array('%d','%d','%s','%s','%s','%s')
);
$counter++;
} catch (Exception $e) {
echo 'Caught exception: ', $e->getMessage(), "\n";
}
}
}
}
}
# Attachments Upload END
#-------------------
Aretk_Crea_Admin::aretkcrea_listing_update_to_aretk_server($listingId,'add');
}
} elseif ( isset($_POST) && $action === 'submit-form' && $action_which === 'edit' && is_numeric($_POST['aretk-listing-id']) )
{
$listingId = isset($_POST['aretk-listing-id']) ? (INT) $_POST['aretk-listing-id'] : '';
if( $listingAgentId != '' && !empty($listingAgentId) && !empty($listingAddress) && $listingAddress !='' && !empty($listingcity) && $listingcity !='' && !empty($listingProvince) && $listingProvince !='' && !empty($listingAgentStatus) && $listingAgentStatus !='' && !empty($listingPrice) && $listingPrice !='' && !empty($listingPhotosArr) && $listingPhotosArr !='' )
{
$listing_post_content = array('ID' => $listingId,'post_content' => $listingDescription);
wp_update_post( $listing_post_content );
update_post_meta($listingId,'listingAgentId'," $listingAgentId");
update_post_meta($listingId,'listingAddress',"$listingAddress");
update_post_meta($listingId,'listingcity',"$listingcity");
update_post_meta($listingId,'listingProvince',"$listingProvince");
update_post_meta($listingId,'listingPrice',"$listingPrice");
update_post_meta($listingId,'listingAgentStatus',"$listingAgentStatus");
update_post_meta($listingId,'listingPropertyType',"$listingPropertyType");
update_post_meta($listingId,'listingStructureType',"$listingStructureType");
update_post_meta($listingId,'listingBedRooms',"$listingBedRooms");
update_post_meta($listingId,'listingBathrooms',"$listingBathrooms");
update_post_meta($listingId,'listingBathroomsPartial',"$listingBathroomsPartial");
update_post_meta($listingId,'listingFinishedBasement',"$listingFinishedBasement");
update_post_meta($listingId,'listingParkingSlot',"$listingParkingSlot");
update_post_meta($listingId,'listingParkinggarage',"$listingParkinggarage");
update_post_meta($listingId,'listingTourUrl',"$listingTourUrl");
update_post_meta($listingId,'listingUtilityArr',"$listingUtilityArr");
update_post_meta($listingId,'listingFeatureArr',"$listingFeatureArr");
update_post_meta($listingId,'listingopenhosedatetimeArr',json_encode($merge_listing_open_house));
update_post_meta($listingId,'listing_type',"exclusive");
update_post_meta($listingId,'crea_google_map_latitude',$crea_google_map_latitude);
update_post_meta($listingId,'crea_google_map_longitude',$crea_google_map_longitude);
update_post_meta($listingId,'crea_google_map_geo_address',$crea_google_map_geo_address);
$getSubscriptionStatus = get_option('crea_subscription_status', '');
if ( isset( $getSubscriptionStatus ) && !empty( $getSubscriptionStatus ) && $getSubscriptionStatus === 'valid' ){
update_post_meta($listingId,'crea_listing_subscription_states','valid');
} else {
update_post_meta($listingId,'crea_listing_subscription_states','not-valid');
}
#-------------------
# Sanitize Photos upload
# Only allowing the following image types
$allowedImageMimes = array(
'jpg|jpeg|jpe' => 'image/jpeg',
'gif' => 'image/gif',
'png' => 'image/png',
);
if( !empty($listingPhotosArr) && current_user_can('upload_files') && is_user_logged_in() )
{
$author_id = (INT) get_current_user_id();
$crea_listing_images_detail_table_name = $wpdb->prefix.ARETKCREA_LISTING_IMAGES_HISTORY;
$counter = 1;
for ($j = 0; $j < count($listingPhotosArr['name']); $j++)
{
$uploadfile = array(
'name' => sanitize_file_name($listingPhotosArr['name'][$j]),
'type' => $listingPhotosArr['type'][$j],
'tmp_name' => $listingPhotosArr['tmp_name'][$j],
'error' => $listingPhotosArr['error'][$j],
'size' => $listingPhotosArr['size'][$j]
);
$fileInfo = wp_check_filetype($uploadfile['name'], $allowedImageMimes);
if ( !empty($fileInfo['type']) && $uploadfile['size'] > 0 && $uploadfile['size'] < 2000000 )
{
$uploadInfo = wp_handle_upload($uploadfile, array(
'test_form' => false,
'mimes' => $allowedImageMimes
));
if( isset($uploadInfo['url']) && !isset($uploadInfo['error']) )
{
$imageUrl = esc_url_raw($uploadInfo['url']);
try {
$wpdb->insert(
"$crea_listing_images_detail_table_name",
array(
'user_id' => $author_id,
'unique_id' => $listingId,
'image_position' => $counter,
'image_url' => "$imageUrl",
'created_time' => current_time('mysql', 1),
'updated_time' => current_time('mysql', 1),
),
array('%d','%d','%d','%s','%s','%s')
);
$counter++;
} catch (Exception $e) {
echo 'Caught exception: ', $e->getMessage(), "\n";
}
}
}
}
}
# PHOTOS upload END
#-------------------
#-------------------
# Sanitize Attachments Upload
# Only allowing the following doc types
$allowedDocsMimes = array(
'jpg|jpeg|jpe' => 'image/jpeg',
'gif' => 'image/gif',
'png' => 'image/png',
'txt|asc|c|cc|h'=> 'text/plain',
'csv' => 'text/csv',
'tsv' => 'text/tab-separated-values',
'rtx' => 'text/richtext',
'mp3|m4a|m4b' => 'audio/mpeg',
'mp4|m4v' => 'video/mp4',
'mov|qt' => 'video/quicktime',
'pdf' => 'application/pdf',
'doc|docx' => 'application/msword',
'xla|xls|xlsx|xlt|xlw|xlam|xlsb|xlsm|xltm' => 'application/vnd.ms-excel'
);
$listingDocumentArr = isset($_FILES['extdocfileinput']) ? $_FILES['extdocfileinput'] : array();
if( !empty($listingDocumentArr) && current_user_can('upload_files') && is_user_logged_in() )
{
$crea_listing_document_detail_table_name = $wpdb->prefix.ARETKCREA_LISTING_DOCUMENT_HISTORY;
$counter = 1;
for ($k = 0; $k < count($listingDocumentArr['name']); $k++)
{
$uploadfile = array(
'name' => sanitize_file_name($listingDocumentArr['name'][$k]),
'type' => $listingDocumentArr['type'][$k],
'tmp_name' => $listingDocumentArr['tmp_name'][$k],
'error' => $listingDocumentArr['error'][$k],
'size' => $listingDocumentArr['size'][$k]
);
$fileInfo = wp_check_filetype($uploadfile['name'], $allowedDocsMimes);
if ( !empty($fileInfo['type']) && $uploadfile['size'] > 0 && $uploadfile['size'] < 5000000 )
{
$uploadInfo = wp_handle_upload($uploadfile, array(
'test_form' => false,
'mimes' => $allowedDocsMimes
));
if( isset($uploadInfo['url']) && !isset($uploadInfo['error']) )
{
$docUrl = esc_url_raw($uploadInfo['url']);
list($docName, $ext) = explode('.', basename($docUrl));
$docName = str_replace('-', ' ', $docName);
try {
$wpdb->insert(
"$crea_listing_document_detail_table_name",
array(
'user_id' => $author_id,
'unique_id' => $listingId,
'document_url' => "$docUrl",
'document_name' => "$docName",
'created_time' => current_time('mysql', 1),
'updated_time' => current_time('mysql', 1),
),
array('%d','%d','%s','%s','%s','%s')
);
$counter++;
} catch (Exception $e) {
echo 'Caught exception: ', $e->getMessage(), "\n";
}
}
}
}
}
# Attachments Upload END
#-------------------
}
Aretk_Crea_Admin::aretkcrea_listing_update_to_aretk_server($updatelistingId,'edit');
}
$allListingArr = array();
$agent_ids = Aretk_Crea_Admin::aretkcrea_crea_agent_ids('list');
$getAllUsername = Aretk_Crea_Admin::aretkcrea_feed_usernames('array');
if (isset($getAllUsername) && !empty($getAllUsername))
{
foreach ($getAllUsername as $userName )
{
$result_type = 'full';
$listing = Aretk_Crea_Admin::aretkcrea_get_user_listing_records_by_username_by_view_type($userName,$result_type,$agent_ids);
$listingRecords = isset( $listing[0]->TotalRecords ) ? $listing[0]->TotalRecords : 0;
if( $listingRecords > 0 ) {
array_shift($listing);
$allListingArr = array_merge($allListingArr,$listing);
}
}
}
$args = array(
'posts_per_page' => -1,
'post_type' => 'aretk_listing',
'post_status' => 'publish'
);
$posts_array = (array) get_posts( $args );
$exclusiveArr = array();
foreach ($posts_array as $singlePost) {
$singlePost1 = (array) $singlePost;
$singlePost2 = (object) $singlePost1;
$exclusiveArr[] = $singlePost2;
}
$allListingFinalArr = array();
$allListingFinalArr = array_merge($allListingArr,$exclusiveArr);
$data = json_encode($allListingFinalArr);
update_option('cron_run',"");
update_option('cron_run',"$data");
$link_url = admin_url('admin.php?page=listings_settings');
wp_safe_redirect($link_url);
}
}
/**
* function for aretk_crea_disclaimer_update
*
* ajax callback function aretk_crea_disclaimer_update
* set disclaimer specifics
* @return NULL
* @package Phase 1
* @since Phase 1
* @version 1.0.0
* @param null
*/
function aretk_crea_disclaimer_update()
{
$pluralize = isset( $_POST['disclaimer_pluralize'] ) ? sanitize_text_field(base64_decode($_POST['disclaimer_pluralize'])): 'I am';
$salestype = isset( $_POST['disclaimer_salestype'] ) ? sanitize_text_field(base64_decode($_POST['disclaimer_salestype'])) : 'an agent';
$licensetype = isset( $_POST['disclaimer_licensetype'] ) ? sanitize_text_field(base64_decode($_POST['disclaimer_licensetype'])): 'residential and commercial';
$province = isset( $_POST['disclaimer_province'] ) ? sanitize_text_field(base64_decode($_POST['disclaimer_province'])) : '';
$disclaimer = $pluralize .' '. $salestype .' licensed to trade '. $licensetype .' real estate';
if ( !empty($province) ){ $disclaimer .= ' in '. $province; }
$disclaimer .= '. The out of province listing content on this website is not intended to solicit a trade in real estate. Any consumers interested in out of province listings must contact a person who is licensed to trade in real estate in that province.';
$disclaimer_array = array(
'disclaimer' => $disclaimer,
'pluralize' => $pluralize,
'salestype' => $salestype,
'licensetype' => $licensetype,
'province' => $province
);
update_option('aretk_crea_disclaimer1', $disclaimer_array);
echo ARETKCREA_PLUGIN_SETTINGS_PAGE_BTN_SUCESS;
exit;
}
/**
* function for aretk_crea_add_new_agents
*
* ajax callback function aretk_crea_add_new_agents
* add new agent id or email
* @return return crea agent details
* @package Phase 1
* @since Phase 1
* @version 1.0.0
* @param null
*/
function aretk_crea_add_new_agents ()
{
global $wpdb;
$crea_agent_table_name = $wpdb->prefix.ARETKCREA_AGENT_TABLE;
$agent_id_array = array();
$valid_agent_id = isset( $_POST['encoded_agent_id'] ) ? (INT) base64_decode($_POST['encoded_agent_id']): '';
$valid_agent_email = isset( $_POST['encoded_agent_email'] ) ? sanitize_email(base64_decode($_POST['encoded_agent_email'])) : '';
$valid_agent_name = isset( $_POST['encoded_agent_name'] ) ? sanitize_text_field(base64_decode($_POST['encoded_agent_name'])) : '';
$agent_id_array = Aretk_Crea_Admin::aretkcrea_crea_agent_ids('array');
if( !in_array($valid_agent_id, $agent_id_array ) ) {
if( !empty( $valid_agent_id ) && $valid_agent_id != '' && !empty( $valid_agent_email ) && $valid_agent_email !='' )
{
$wpdb->insert( "$crea_agent_table_name",
array(
'crea_agent_name' => $valid_agent_name,
'crea_agent_id' => $valid_agent_id,
'crea_agent_email' => $valid_agent_email,
'crea_agent_created_date' => current_time('mysql', 1),
'crea_agent_modified_date' => current_time('mysql', 1)
),
array( '%s', '%s', '%s', '%s', '%s' )
);
$sql_select = "SELECT `crea_id`,`crea_agent_name`,`crea_agent_id`,`crea_agent_email`,`crea_agent_modified_date` FROM `$crea_agent_table_name` ORDER BY `crea_id` ASC";
$sql_prep = $wpdb->prepare( $sql_select, NULL );
$get_agents_results = $wpdb->get_results($sql_prep);
if( !empty( $get_agents_results ) && $get_agents_results !='' )
{
$counter = 0;
foreach ( $get_agents_results as $get_agents_key=>$get_agents_value )
{
$counter = $counter + 1;
echo'';
echo''.$counter.' ';
echo''.$get_agents_value->crea_agent_name.'
'.__(ARETKCREA_AGENT_NAME_NOT_NULL, ARETKCREA_PLUGIN_SLUG).'
'.$get_agents_value->crea_agent_id.'
'.__(ARETKCREA_AGENT_ID_NOT_NULL,ARETKCREA_PLUGIN_SLUG).'
'.$get_agents_value->crea_agent_email.'
'.__(ARETKCREA_AGENT_EMAIL_NOT_NULL,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_AGENT_EMAIL_NOT_VALID,ARETKCREA_PLUGIN_SLUG).'
'.$get_agents_value->crea_agent_modified_date.'
';
}
}
}
} else {
echo 'already_exsits';
}
die();
}
/**
* create function for aretkcrea_delete_selected_agent_records
*
* ajax callback function aretkcrea_delete_selected_agent_records
* Delete selected agent records
*
* @return return crea delete agent details
* @package Phase 1
* @since Phase 1
* @version 1.0.0
* @param null
*/
function aretkcrea_delete_selected_agent_records()
{
global $wpdb;
$crea_agent_table_name = $wpdb->prefix.ARETKCREA_AGENT_TABLE;
$crea_agent_id = isset( $_POST['crea_agent_id'] ) ? (INT) base64_decode($_POST['crea_agent_id']) :'';
if( !empty( $crea_agent_id ) && $crea_agent_id !='' )
{
$sql_select = "DELETE FROM `$crea_agent_table_name` WHERE `crea_id`= %d";
$sql_prep = $wpdb->prepare( $sql_select, $crea_agent_id );
$delete_recod = $wpdb->query($sql_prep);
if( $delete_recod == 1 )
{
$sql_select = "SELECT `crea_id`,`crea_agent_name`,`crea_agent_id`,`crea_agent_email`,`crea_agent_modified_date` FROM `$crea_agent_table_name` ORDER BY `crea_id` ASC";
$sql_prep = $wpdb->prepare( $sql_select, NULL );
$get_agents_results = $wpdb->get_results($sql_prep);
if( !empty( $get_agents_results ) && $get_agents_results !='' )
{
$counter = 0;
foreach ( $get_agents_results as $get_agents_key => $get_agents_value )
{
$counter = $counter + 1;
echo'';
echo''.$counter.' ';
echo''.$get_agents_value->crea_agent_name.'
'.$get_agents_value->crea_agent_id.'
'.__(ARETKCREA_AGENT_ID_NOT_NULL,ARETKCREA_PLUGIN_SLUG).'
'.$get_agents_value->crea_agent_email.'
'.__(ARETKCREA_AGENT_EMAIL_NOT_NULL,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_AGENT_EMAIL_NOT_VALID,ARETKCREA_PLUGIN_SLUG).'
'.$get_agents_value->crea_agent_modified_date.'
';
}
}
}
}
die();
}
/**
* create function for aretkcrea_get_google_map_address_lat_long
*
* ajax callback function aretkcrea_get_google_map_address_lat_long
* get address lat long
*
* @return return crea address lat long
* @package Phase 1
* @since Phase 1
* @version 1.0.0
* @param null
*/
function aretkcrea_get_google_map_address_lat_long ()
{
$google_map_address = sanitize_text_field(base64_decode($_POST['google_map_address']));
$geo_location_address = file_get_contents('https://maps.googleapis.com/maps/api/geocode/json?address='.urlencode($google_map_address).'&sensor=false');
$geo_location_address = json_decode($geo_location_address, true);
if( $google_map_address != '' && $geo_location_address['status'] === 'OK')
{
$latitude = isset( $geo_location_address['results'][0]['geometry']['location']['lat']) ? $geo_location_address['results'][0]['geometry']['location']['lat'] :'';
$longitude = isset($geo_location_address['results'][0]['geometry']['location']['lng']) ? $geo_location_address['results'][0]['geometry']['location']['lng'] :'';
$address = isset($geo_location_address['results'][0]['formatted_address']) ? $geo_location_address['results'][0]['formatted_address'] :'';
$sucessfully_callback = base64_encode('sucessfully'.'|'.$latitude.'|'.$longitude.'|'.$address);
echo $sucessfully_callback;
} else {
$sucessfully_callback = base64_encode('error'.'|'. $geo_location_address['error_message']);
echo $sucessfully_callback;
}
die();
}
function aretkcrea_update_crea_listing_images_order_with_upload()
{
global $wpdb;
$listingId = (INT) $_POST['listingId'];
$listingPhotosArr = isset($_FILES) ? $_FILES : NULL;
if( !empty($listingPhotosArr) && !empty($listingId) && current_user_can('upload_files') && is_user_logged_in() )
{
# Only allow the following image types
$allowedImageMimes = array(
'jpg|jpeg|jpe' => 'image/jpeg',
'gif' => 'image/gif',
'png' => 'image/png',
);
$author_id = (INT) get_current_user_id();
$crea_listing_images_detail_table_name = $wpdb->prefix.ARETKCREA_LISTING_IMAGES_HISTORY;
$counter = 1;
for ($j = 0; $j < count($listingPhotosArr); $j++)
{
$uploadfile = array(
'name' => sanitize_file_name($listingPhotosArr[$j]['name']),
'type' => $listingPhotosArr[$j]['type'],
'tmp_name' => $listingPhotosArr[$j]['tmp_name'],
'error' => $listingPhotosArr[$j]['error'],
'size' => $listingPhotosArr[$j]['size']
);
$fileInfo = wp_check_filetype($uploadfile['name'], $allowedImageMimes);
if ( !empty($fileInfo['type']) && $uploadfile['size'] > 0 && $uploadfile['size'] < 5000000 )
{
$uploadInfo = wp_handle_upload($uploadfile, array(
'test_form' => false,
'mimes' => $allowedImageMimes
));
if( isset($uploadInfo['url']) && !isset($uploadInfo['error']) )
{
try
{
$wpdb->insert(
"$crea_listing_images_detail_table_name",
array(
'user_id' => (int)$author_id,
'unique_id' => (int)$listingId,
'image_position' => (int)$counter,
'image_url' => esc_url_raw($uploadInfo['url']),
'created_time' => current_time('mysql', 1),
'updated_time' => current_time('mysql', 1),
),
array('%d','%d','%d','%s','%s','%s')
);
$counter++;
} catch (Exception $e) {
echo '';
echo 'Caught exception: ', $e->getMessage(), "\n";
echo '
';
}
}
} else {
echo '';
if (count($listingPhotosArr) > 1){
echo '1 or more of the images you attempted to upload were to large.';
} else {
echo 'The image you attempted to upload was to large.';
}
echo ' The max allowed image size is 5MB.';
echo '
';
}
}
}
$crea_listing_images_detail_table_name = $wpdb->prefix.ARETKCREA_LISTING_IMAGES_HISTORY;
$sql_select = "SELECT * FROM `$crea_listing_images_detail_table_name` WHERE `unique_id`= %d ORDER BY `image_position` ASC";
$sql_prep = $wpdb->prepare( $sql_select, $listingId );
$imageSet = $wpdb->get_results($sql_prep);
$html = '';
$html .= 'reorder photos 1. Drag photos to reorder.
';
if (isset($imageSet) && !empty($imageSet))
{
foreach($imageSet as $image)
{
$html .= '
reorder photos 1. Drag photos to reorder.
';
if (isset($imageSet) && !empty($imageSet))
{
foreach($imageSet as $image)
{
$html .= '
';
echo $html;
die();
}
function aretkcrea_delete_listing_document_edit_page_from_listing_ajax()
{
global $wpdb;
$docID = (INT) base64_decode($_POST['documentID']);
$upload_dir = wp_upload_dir();
if ( !empty($docID) && !empty($upload_dir['basedir']) && current_user_can('upload_files') && is_user_logged_in() )
{
$fileDeleteError = false;
$crea_listing_document_detail_table_name = $wpdb->prefix.ARETKCREA_LISTING_DOCUMENT_HISTORY;
$sql_select = "SELECT `unique_id`, `document_url` FROM `$crea_listing_document_detail_table_name` WHERE `id`= %d LIMIT 1";
$sql_prep = $wpdb->prepare( $sql_select, $docID );
$resultPostIdArr = $wpdb->get_results($sql_prep);
$listingID = (INT) $resultPostIdArr[0]->unique_id;
$docURL = $resultPostIdArr[0]->document_url;
if ( !empty($docURL) && !empty($listingID) )
{
list($docBase, $docPath) = explode('uploads/', $docURL);
$docPath = esc_url($upload_dir['basedir'] .'/'. $docPath);
if ( file_exists($docPath) && wp_is_writable($docPath) )
{
if ( false === unlink($docPath) )
{
echo 'Caught exception: could not remove document, check file permissions' . "\n";
$fileDeleteError = true;
}
}
if ( true !== $fileDeleteError )
{
$sql_select = "DELETE FROM `$crea_listing_document_detail_table_name` WHERE `id`= %d AND `unique_id` = %d LIMIT 1";
$sql_prep = $wpdb->prepare( $sql_select, $docID, $listingID );
try {
$wpdb->query($sql_prep);
} catch (Exception $e) {
echo 'Caught exception: '. $e->getMessage(). "\n";
}
}
}
}
$crea_listing_document_detail_table_name = $wpdb->prefix.ARETKCREA_LISTING_DOCUMENT_HISTORY;
$sql_select = "SELECT * FROM `$crea_listing_document_detail_table_name` WHERE `unique_id`= %d ORDER BY id ASC";
$sql_prep = $wpdb->prepare( $sql_select, $listingID );
$documentSet = $wpdb->get_results($sql_prep);
$html = '';
if (isset($documentSet) && !empty($documentSet))
{
foreach ($documentSet as $documentSetKey=>$documentSetValue)
{
$html .='';
$html .='
';
$html .='
';
$html .='
'.$documentSetValue->document_name.'
';
$html .='
';
$html .='
reorder photos 1. Drag photos to reorder.
';
if (isset($imageSet) && !empty($imageSet)) {
foreach($imageSet as $image) {
$html .= ' ';
$html .= '
Correspondence History
';
$html .= '
';
foreach ( $get_lead_corrsponding_ids_count as $get_lead_corrsponding_ids_key=>$get_lead_corrsponding_ids_value )
{
$corrsponding_messages = json_decode( $get_lead_corrsponding_ids_value->meta_value);
if( is_array($corrsponding_messages) ) {
$corrsponding_message = $corrsponding_messages[1];
$correspondace_date = $corrsponding_messages[2];
$corrsponding_subject = $corrsponding_messages[3];
$corrsponding_type = $corrsponding_messages[4];
} else {
$corrsponding_message = $corrsponding_messages;
$correspondace_date = '';
$corrsponding_subject = '';
$corrsponding_type = '';
}
$html .= '
'. $correspondace_date.'
'. $corrsponding_type .'
';
if ($corrsponding_type !== 'note'){
$html .= '
Subject: '. $corrsponding_subject.'
';
}
$html .= '
';
$html .= '
'. $corrsponding_message .'
';
$html .= '
';
}
$html .='
';
$html .= '
Correspondence History
';
$html .= '
';
foreach ( $get_lead_corrsponding_ids_count as $get_lead_corrsponding_ids_key=>$get_lead_corrsponding_ids_value )
{
$corrsponding_messages = json_decode( $get_lead_corrsponding_ids_value->meta_value);
if( is_array($corrsponding_messages) ) {
$corrsponding_message = $corrsponding_messages[1];
$correspondace_date = $corrsponding_messages[2];
$corrsponding_subject = $corrsponding_messages[3];
$corrsponding_type = $corrsponding_messages[4];
} else {
$corrsponding_message = $corrsponding_messages;
$correspondace_date = '';
$corrsponding_subject = '';
$corrsponding_type = '';
}
$html .= '
'. $correspondace_date.'
'. $corrsponding_type .'
';
if ($corrsponding_type !== 'note'){
$html .= '
Subject: '. $corrsponding_subject.'
';
}
$html .= '
';
$html .= '
'. $corrsponding_message .'
';
$html .= '
';
}
$html .='
'. strtoupper(__(ARETKCREA_LEADS_BTN_TXT_ADD_NEW_LEAD, ARETKCREA_PLUGIN_SLUG)) .' ';
$views['send-email-leads'] =''. strtoupper(__(ARETKCREA_LEADS_BTN_TXT_SEND_EMAIL, ARETKCREA_PLUGIN_SLUG)) .' ';
$views['lead-category'] =''. strtoupper(__(ARETKCREA_LEADS_BTN_TXT_LEAD_FORMS, ARETKCREA_PLUGIN_SLUG)) .' ';
$views['import-lead'] =''. strtoupper(__(ARETKCREA_LEADS_BTN_TXT_IMPORT_LEADS, ARETKCREA_PLUGIN_SLUG)) .' ';
$views['export-lead'] ='
';
return $views;
}
/**
* Change aretk_lead edit link
*
*/
function aretkcrea_edit_aretk_post_link ( $url, $post_id, $context)
{
$aretk_lead = isset($_REQUEST['post_type']) ? sanitize_text_field($_REQUEST['post_type']) : '';
$post_id = (INT) $post_id;
if( $aretk_lead == 'aretk_lead' ) {
$url = admin_url('admin.php?page=create_new_leads&ID='.$post_id.'&action=edit');
} elseif ( $aretk_lead =='aretk_listing' ) {
$url = admin_url('admin.php?page=create_new_listings&id='.$post_id);
}
return $url;
}
/**
* Function is used for create lead
*/
public function aretkcrea_handle_create_lead_form_action()
{
global $wpdb, $wp;
$lead_id = !empty($_POST['aretk-lead-id'])? (INT) $_POST['aretk-lead-id'] : '';
$posttype =!empty($_POST['posttype']) ? sanitize_text_field($_POST['posttype']) : '';
$action = !empty($_POST['action']) ? sanitize_text_field($_POST['action']) : '';
$action_which = !empty($_POST['action-which']) ? sanitize_text_field($_POST['action-which']) : '';
$lead_name = !empty($_POST['create_lead_name']) ? sanitize_text_field($_POST['create_lead_name']) : '';
$create_lead_email_arr = !empty($_POST['create_lead_phone_email']) ? (array) $_POST['create_lead_phone_email'] : array();
$create_lead_email = array();
foreach($create_lead_email_arr as $email)
{
$create_lead_email[] = sanitize_email($email);
}
if ( $posttype === 'lead' && $action === 'lead-form' && !empty($lead_name) && !empty($create_lead_email) && ($action_which === 'add' || $action_which === 'edit') )
{
$crea_agent_id = !empty($_POST['crea_agent_id']) ? (INT) $_POST['crea_agent_id'] : '';
$PrimaryEmail = !empty($_POST['PrimaryEmail']) ? sanitize_email($_POST['PrimaryEmail']) : '';
$lead_company = !empty($_POST['create_lead_company']) ? sanitize_text_field($_POST['create_lead_company']) : '';
$create_lead_address_line1 = !empty($_POST['create_lead_address_line1']) ? sanitize_text_field($_POST['create_lead_address_line1']) : '';
$create_lead_province = !empty($_POST['create_lead_province']) ? sanitize_text_field($_POST['create_lead_province']) : '';
$create_lead_city = !empty($_POST['create_lead_city']) ? sanitize_text_field($_POST['create_lead_city']) : '';
$create_lead_country = !empty($_POST['create_lead_country']) ? sanitize_text_field($_POST['create_lead_country']) : '';
$comment = !empty($_POST['comment']) ? sanitize_text_field($_POST['comment']) : '';
$crea_new_lead_category_arr = !empty($_POST['new_lead_category']) ? (array) $_POST['new_lead_category'] : array();
$crea_new_lead_category = array();
foreach ($crea_new_lead_category_arr as $leadCategory)
{
$crea_new_lead_category[] = sanitize_text_field($leadCategory);
}
$crea_agent_phone_type_arr = !empty($_POST['crea_agent_phone_type']) ? (array) $_POST['crea_agent_phone_type'] : array();
$crea_agent_phone_type = array();
$phoneTypeOptions = array('Home', 'Mobile', 'Fax');
foreach($crea_agent_phone_type_arr as $phoneType)
{
if (in_array($phoneType, $phoneTypeOptions))
{
$crea_agent_phone_type[] = $phoneType;
}
}
$create_lead_phone_no_arr = !empty($_POST['create_lead_phone_no']) ? (array) $_POST['create_lead_phone_no'] : array();
$create_lead_phone_no = array();
foreach($create_lead_phone_no_arr as $phoneNum)
{
$create_lead_phone_no[] = preg_replace('/[^0-9]/', '', $phoneNum);
}
$create_lead_social_url_arr = !empty($_POST['create_lead_social_url']) ? (array) $_POST['create_lead_social_url'] : array();
$create_lead_social_url = array();
foreach($create_lead_social_url_arr as $url_social)
{
$create_lead_social_url[] = esc_url($url_social);
}
$crea_agent_social_type_arr = !empty($_POST['crea_agent_social_type'])? ($_POST['crea_agent_social_type']):array();
$crea_agent_social_type = array();
$socialTypeOptions = array('Facebook', 'Instagram', 'LinkedIn', 'Pinterest', 'Twitter', 'YouTube');
foreach($crea_agent_social_type_arr as $socialType)
{
if (in_array($socialType, $socialTypeOptions))
{
$crea_agent_social_type[] = $socialType;
}
}
$merge_phonetype = array();
$op_counter = 0;
foreach ( $crea_agent_phone_type as $crea_agent_phone_type_val ) {
$phonetype = $crea_agent_phone_type[$op_counter];
$phoneno = $create_lead_phone_no[$op_counter];
$merge_phonetype[] = array('PhoneType'=>$phonetype,'PhoneNo'=>$phoneno);
$op_counter++;
}
$merge_social = array();
$op_counter_new = 0;
foreach ( $crea_agent_social_type as $crea_agent_social_type_val ) {
$socialtype = $crea_agent_social_type[$op_counter_new];
$sociallink = $create_lead_social_url[$op_counter_new];
$merge_social[] = array('SocialType'=>$socialtype,'SocialLink'=>$sociallink);
$op_counter_new++;
}
if (empty($PrimaryEmail)){
$PrimaryEmail = $create_lead_email[0];
}
if ($action_which === 'add' && empty($lead_id) )
{
$new_post = array(
'post_title' => $lead_name,
'post_content' => $comment,
'post_status' => 'publish',
'post_type' => 'aretk_lead'
);
$lead_id = wp_insert_post($new_post);
}
elseif ( $action_which === 'edit' && !empty($lead_id) )
{
$update_lead_post_content = array(
'ID' => $lead_id,
'post_title'=> $lead_name,
'post_content' => $comment
);
wp_update_post( $update_lead_post_content );
$lead_form_type = get_post_meta( $lead_id, 'lead_form_type', $single = false );
$current_user_lead_form_type = array();
foreach ( $lead_form_type as $current_user_lead_form) {
$current_user_lead_form_type[] = $current_user_lead_form;
}
update_post_meta($lead_id,'lead_form_type',$current_user_lead_form_type);
}
update_post_meta($lead_id,'crea_agent_id',$crea_agent_id);
update_post_meta($lead_id,'lead_phone_no',maybe_serialize($merge_phonetype));
update_post_meta($lead_id,'lead_phone_email',maybe_serialize($create_lead_email));
update_post_meta($lead_id,'create_lead_company',$lead_company);
update_post_meta($lead_id,'lead_address_line',$create_lead_address_line1);
update_post_meta($lead_id,'lead_province',$create_lead_province);
update_post_meta($lead_id,'lead_city',$create_lead_city);
update_post_meta($lead_id,'create_lead_country',$create_lead_country);
update_post_meta($lead_id,'agent_social_type',maybe_serialize($merge_social));
update_post_meta($lead_id,'lead_form_type','admin');
update_post_meta($lead_id,'lead_primary_email',$PrimaryEmail);
update_post_meta($lead_id,'lead_comment',$comment);
wp_set_object_terms( $lead_id, $crea_new_lead_category, 'lead-category');
$link_url = admin_url('admin.php?page=create_new_leads&ID='.$lead_id.'&action=edit');
} else {
$link_url = admin_url('admin.php?page=create_new_leads');
}
wp_safe_redirect($link_url);
die();
}
// Function to create necessary plugin pages
public function aretkcrea_create_listing_detail_page()
{
$pages = get_pages();
$listings_page = array( 'slug' => 'listing-details', 'title' => 'Listing Details', 'content' => '[ARETK-LDS]' );
$search_results_page = array( 'slug' => 'search-results', 'title' => 'Search Results', 'content' => '[ARTEK-DLS]' );
// search results page
foreach ($pages as $page)
{
$apage = $page->post_name;
if ( $apage == 'search-results') {
$search_results_page_found = '1';
break;
} else {
$search_results_page_found = '0';
}
}
if($search_results_page_found != '1'){
$page_id = wp_insert_post(array(
'post_title' => $search_results_page['title'],
'post_type' =>'page',
'post_name' => $search_results_page['slug'],
'post_content' => $search_results_page['content'],
'post_status' => 'publish',
));
}
// listing detail page
foreach ($pages as $page)
{
$apage = $page->post_name;
if ( $apage == 'listing-details') {
$listing_detail_found = '1';
break;
} else {
$listing_detail_found = '0';
}
}
if($listing_detail_found != '1')
{
$page_id = wp_insert_post(array(
'post_title' => $listings_page['title'],
'post_type' =>'page',
'post_name' => $listings_page['slug'],
'post_content' => $listings_page['content'],
'post_status' => 'publish',
));
}
$post_id = !empty( $_GET['post'] ) ? (INT) $_GET['post'] : '';
if ( !empty( $post_id ) )
{
$post = get_post($post_id);
$slug = $post->post_name;
if ( $slug === 'listing-details' || $slug === 'search-results')
{
remove_post_type_support('page', 'editor');
remove_meta_box( 'authordiv', 'page', 'normal' ); // removes comments status
remove_meta_box( 'categorydiv', 'page', 'normal' ); // removes comments
remove_meta_box( 'commentstatusdiv', 'page', 'normal' );// removes author
remove_meta_box( 'commentsdiv', 'page', 'normal' ); // removes Comments metabox
remove_meta_box( 'postexcerpt', 'page', 'normal' ); // removes Excerpt metabox
remove_meta_box( 'postimagediv', 'page', 'side' ); // removes Featured image metabox
remove_meta_box( 'slugdiv', 'page', 'normal' ); // removes Slug metabox
remove_meta_box( 'trackbacksdiv', 'page', 'normal' ); // removes Trackbacks metabox
}
}
}
public function aretkcrea_restrict_post_deletion($post_id)
{
if (!empty($post_id) && is_int($post_id))
{
$property_detail = get_post($post_id);
$property_detail_slug = $property_detail->post_name;
if( $property_detail_slug == 'listing-details' || $property_detail_slug == 'search-results' )
{
die('The page you were trying to delete is protected. Click the back button to return to the previous page.');
}
}
}
// Default Listing Details Settings AJAX
function aretkcrea_add_listing_showcase_changes()
{
$get_include_information = $_POST['get_include_information'] === 'Yes' ? 'Yes' : '';
$get_include_contact_form = $_POST['get_include_contact_form'] === 'Yes' ? 'Yes' : '';
$get_include_map = $_POST['get_include_map'] === 'Yes' ? 'Yes' : '';
$get_include_walk_score = $_POST['get_include_walk_score'] === 'Yes' ? 'Yes' : '';
$get_include_print_button = $_POST['get_include_print_button'] === 'Yes' ? 'Yes' : '';
$email_address_of_agent = $_POST['get_include_email_address_of_agent'] === 'Yes' ? 'Yes' : '';
$get_crea_listing_price_color_id = isset($_POST['get_crea_listing_price_color_id']) ? sanitize_hex_color_no_hash($_POST['get_crea_listing_price_color_id']) : '';
$get_crea_listing_send_btn_color_id = isset($_POST['get_crea_listing_send_btn_color_id']) ? sanitize_hex_color_no_hash($_POST['get_crea_listing_send_btn_color_id']) : '';
update_option('crea_listing_include_information', $get_include_information);
update_option('crea_listing_include_contact_form', $get_include_contact_form);
update_option('crea_listing_include_map', $get_include_map);
update_option('crea_listing_include_walk_score', $get_include_walk_score);
update_option('crea_listing_include_print_btn', $get_include_print_button);
update_option('crea_listing_include_email_address_of_agent', $email_address_of_agent);
update_option('crea_listing_include_price_color', $get_crea_listing_price_color_id);
update_option('crea_listing_include_send_btn_color', $get_crea_listing_send_btn_color_id);
die();
}
// Default listings Showcase settings AJAX
function aretkcrea_add_default_listing_setting()
{
$DefaultlistingTextColor = isset($_POST['DefaultlistingTextColor']) ? sanitize_hex_color_no_hash($_POST['DefaultlistingTextColor']) : '';
$DefaultlistingAddressbarColor= isset($_POST['DefaultlistingAddressbarColor']) ? sanitize_hex_color_no_hash($_POST['DefaultlistingAddressbarColor']) : '';
$DefaultlistingPriceColor = isset($_POST['DefaultlistingPriceColor']) ? sanitize_hex_color_no_hash($_POST['DefaultlistingPriceColor']) : '';
$DefaultlistingStatusColor = isset($_POST['DefaultlistingStatusColor']) ? sanitize_hex_color_no_hash($_POST['DefaultlistingStatusColor']) : '';
$DefaultlistingopenhouseColor = isset($_POST['DefaultlistingopenhouseColor']) ? sanitize_hex_color_no_hash($_POST['DefaultlistingopenhouseColor']) : '';
$DefaultlistingStatusTextColor = isset($_POST['DefaultlistingStatusTextColor']) ? sanitize_hex_color_no_hash($_POST['DefaultlistingStatusTextColor']) : '';
$DefaultlistingopenhouseTextColor = isset($_POST['DefaultlistingopenhouseTextColor']) ? sanitize_hex_color_no_hash($_POST['DefaultlistingopenhouseTextColor']) : '';
$Defaultlistinglisting_pagination_color_id = isset($_POST['DefaultlistingpaginationColor']) ? sanitize_hex_color_no_hash($_POST['DefaultlistingpaginationColor']) : '';
$Defaultlistinglisting_pagination_text_color_id = isset($_POST['DefaultlistingpaginationtextColor']) ? sanitize_hex_color_no_hash($_POST['DefaultlistingpaginationtextColor']) : '';
$Defaultlisting_Openhouseyes_or_not = $_POST['get_openHouse'] === 'yes' ? 'yes' : '';
$Defaultlistingstatus_yes_or_not = $_POST['get_status'] === 'yes' ? 'yes' : '';
$Defaultlistingsearchbar_yes_or_not = $_POST['get_search'] === 'yes' ? 'yes' : '';
update_option('crea_default_listing_text',$DefaultlistingTextColor);
update_option('crea_default_listing_address_bar_listing_include',$DefaultlistingAddressbarColor);
update_option('crea_default_listing_price_color',$DefaultlistingPriceColor);
update_option('crea_default_listing_status_color',$DefaultlistingStatusColor);
update_option('crea_default_listing_openhouse_color',$DefaultlistingopenhouseColor);
update_option('crea_default_listing_status_text_color',$DefaultlistingStatusTextColor);
update_option('crea_default_listing_openhouse_text_color',$DefaultlistingopenhouseTextColor);
update_option('crea_default_listing_status_yes_or_not',$Defaultlistingstatus_yes_or_not);
update_option('crea_default_listing_openhouse_yes_or_not',$Defaultlisting_Openhouseyes_or_not);
update_option('crea_default_listing_searchbar_yes_or_not',$Defaultlistingsearchbar_yes_or_not);
update_option('crea_default_listing_pagination_color_id_yes_or_not',$Defaultlistinglisting_pagination_color_id);
update_option('crea_default_listing_pagination_text_color_id_yes_or_not',$Defaultlistinglisting_pagination_text_color_id);
die();
}
// function for ajax call - map listing
function aretkcrea_map_listing()
{
global $wpdb;
$getSubscriptionStatus = get_option('crea_subscription_status', '');
if ( $getSubscriptionStatus === 'valid' )
{
$getSubscriptionKey = get_option('crea_subscription_key', '');
$subscriptionKey = !empty($getSubscriptionKey) ? $getSubscriptionKey : '';
$domainName = isset($_SERVER['SERVER_NAME']) ? $_SERVER['SERVER_NAME'] : '';
if (!empty($domainName)){
$domainName = filter_var($domainName, FILTER_SANITIZE_URL);
} else {
$domainName = get_site_url();
$domainName = esc_url(parse_url($domainName, PHP_URL_HOST));
}
$domainName = str_replace('http://', '', $domainName);
$property_id = !empty( $_POST['property_id'] ) ? (INT) base64_decode($_POST['property_id']) : '';
$property_latitude = !empty( $_POST['property_latitude'] ) ? sanitize_text_field(base64_decode($_POST['property_latitude'])) : '';
$property_longitude = !empty( $_POST['property_longitude'] ) ? sanitize_text_field(base64_decode($_POST['property_longitude'])) : '';
$property_latitude = (float) preg_replace('/[^\d-.]+/', '', $property_latitude);
$property_longitude = (float) preg_replace('/[^\d-.]+/', '', $property_longitude);
$property_pov_heading = isset( $_POST['property_pov_heading'] ) ? sanitize_text_field(base64_decode($_POST['property_pov_heading'])) : '';
$property_pov_heading = (float) preg_replace('/[^\d-.]+/', '', $property_pov_heading);
$property_pov_pitch = isset( $_POST['property_pov_pitch'] ) ? sanitize_text_field(base64_decode($_POST['property_pov_pitch'])) : '';
$property_pov_pitch = (float) preg_replace('/[^\d-.]+/', '', $property_pov_pitch);
$property_pov_zoom = isset( $_POST['property_pov_zoom'] ) ? (INT) base64_decode($_POST['property_pov_zoom']) : '';
$userNameList = Aretk_Crea_Admin::aretkcrea_feed_usernames('list');
$agent_id_array = array();
$agent_ids_list = NULL;
$agent_ids_list = Aretk_Crea_Admin::aretkcrea_crea_agent_ids('list');
if ( !empty($userNameList) && !empty($agent_ids_list) && is_numeric($property_latitude) && is_numeric($property_longitude) && is_numeric($property_pov_heading) && is_numeric($property_pov_pitch) && is_numeric($property_pov_zoom))
{
$edit_listing_settinges_array = array (
"id" => $property_id,
"userNameList" => $userNameList,
"agent_cid_list" => $agent_ids_list,
"geocoded_latitude" => $property_latitude,
"geocoded_longitude" => $property_longitude,
"geocoded_pov_heading" => $property_pov_heading,
"geocoded_pov_pitch" => $property_pov_pitch,
"geocoded_pov_zoom" => $property_pov_zoom
);
$post_string = http_build_query($edit_listing_settinges_array);
$editListing = curl_init();
curl_setopt($editListing, CURLOPT_HEADER, 0);
curl_setopt($editListing, CURLOPT_VERBOSE, 0);
curl_setopt($editListing, CURLOPT_RETURNTRANSFER, true);
curl_setopt($editListing, CURLOPT_URL, ARETKCREA_LISTING_BASEDONSERVER_API."/?key=$subscriptionKey&request=map_listing");
curl_setopt($editListing, CURLOPT_POST, true);
curl_setopt($editListing, CURLOPT_POSTFIELDS, $post_string);
curl_setopt($editListing, CURLOPT_REFERER,$domainName);
$editListingCurlExecute = curl_exec($editListing);
curl_close($editListing);
$editListingCurlExecuteResponse = ($editListingCurlExecute) . PHP_EOL;
$responseDecode = json_decode($editListingCurlExecuteResponse);
if ( isset($responseDecode->code) && !empty($responseDecode->code) ) {
if ($responseDecode->code === 200 && $responseDecode->status === 'success') {
echo 'pass';
} else {
echo 'fail - Update error';
}
} else {
echo 'fail - Connection Error';
}
} else {
echo 'fail - No CREA feeds found';
}
} else {
echo 'fail - ARETK Subscription API not valid';
}
die();
}
//Default Listings Search Showcase settings
function aretkcrea_add_search_listing_detail_showcase_changes()
{
$search_feed_id = isset($_POST['search_feed_id']) ? sanitize_text_field($_POST['search_feed_id']) : '';
$get_crea_search_inc_exc_listing_feed = $_POST['search_inc_exc_listing_feed'] === 'yes' ? 'yes' : '';
$get_crea_search_exclude_field_property_type = $_POST['search_exclude_field_property_type'] === 'Property Type' ? 'Property Type' : '';
$get_search_exclude_field_status = $_POST['search_exclude_field_status'] === 'Status' ? 'Status' : '';
$get_search_exclude_field_bedrooms = $_POST['search_exclude_field_bedrooms'] === 'Bedrooms' ? 'Bedrooms' : '';
$get_search_exclude_field_bathrooms_full = $_POST['search_exclude_field_bathrooms_full'] === 'Bathrooms Full' ? 'Bathrooms Full' : '';
$get_crea_max_price_range = !empty( $_POST['search_max_price_ranger_value'] ) ? (int) $_POST['search_max_price_ranger_value'] : '';
$get_crea_search_detail_title_color_id = isset($_POST['crea_search_detail_title_color_id']) ? sanitize_hex_color_no_hash($_POST['crea_search_detail_title_color_id']) : '';
$get_crea_search_detail_button_color_id = isset($_POST['crea_search_detail_button_color_id']) ? sanitize_hex_color_no_hash($_POST['crea_search_detail_button_color_id']) : '';
$search_list_count = isset( $_POST['search_list_count'] ) ? (int) $_POST['search_list_count'] : '';
$aretkcrea_showcase_search_advancefilterclosed = $_POST['aretkcrea_showcase_search_advancefilterclosed'] === 'yes' ? 'yes' : 'no';
// Not being used currently
//$get_search_exclude_field_finished_basement = isset($_POST['search_exclude_field_finished_basement']) ? $_POST['search_exclude_field_finished_basement'] : '';
//$get_search_exclude_field_select_city = isset($_POST['search_exclude_field_select_city']) ? $_POST['search_exclude_field_select_city'] : '';
//$get_crea_select_result_layout = isset($_POST['select_result_layout']) ? $_POST['select_result_layout'] : '';
update_option('crea_search_feed_id',$search_feed_id);
update_option('crea_search_inc_exc_listing_feed',$get_crea_search_inc_exc_listing_feed);
update_option('crea_search_exclude_field_property_type',$get_crea_search_exclude_field_property_type);
update_option('crea_search_exclude_field_structure',$get_search_exclude_field_structure);
update_option('crea_search_exclude_field_status',$get_search_exclude_field_status);
update_option('crea_search_exclude_field_bedrooms',$get_search_exclude_field_bedrooms);
update_option('crea_search_exclude_field_bathrooms_full',$get_search_exclude_field_bathrooms_full);
update_option('crea_search_max_price_slider_range',$get_crea_max_price_range);
update_option('crea_search_detail_title_color_id',$get_crea_search_detail_title_color_id);
update_option('crea_search_detail_button_color_id',$get_crea_search_detail_button_color_id);
update_option('select_result_layout_counter',$search_list_count);
update_option('aretkcrea_showcase_search_advancefilterclosed',$aretkcrea_showcase_search_advancefilterclosed);
// Not being used currently
//update_option('crea_search_exclude_field_finished_basement', $get_search_exclude_field_finished_basement);
//update_option('crea_search_exclude_field_select_city',$get_search_exclude_field_select_city);
//update_option('crea_select_result_layout',$get_crea_select_result_layout);
die();
}
/**
* Disable Month Dropdown from Custom Lead
*
* @param unknown_type $status
* @param unknown_type $post_type
* @return unknown
*/
public function aretkcrea_filter_disable_months_dropdown_custom( $status, $post_type )
{
if ( $post_type == 'aretk_lead' ){
$status = true;
} else {
$status = false;
}
return $status;
}
/**
* Add filter options to the leads page
*
*/
public function aretkcrea_restrict_manage_posts_custom_for_lead( )
{
global $wpdb, $post, $typenow, $wp_query;
$crea_agent_table_name = $wpdb->prefix . ARETKCREA_AGENT_TABLE;
$lead_form_type_general_selected = '';
$lead_form_type_seller_selected = '';
$lead_form_type_buyer_selected = '';
$lead_form_type_selected = '';
$lead_agent_selected = '';
$selected_category_name = '';
if( $typenow == 'aretk_lead'){
if ( !empty( $_GET['lead_form_type'] ) && isset( $_GET['lead_form_type'] ) )
{
if( $_GET['lead_form_type'] == 'general' ) {
$lead_form_type_general_selected = 'selected';
} elseif ( $_GET['lead_form_type'] == 'seller' ) {
$lead_form_type_seller_selected = 'selected';
} elseif ( $_GET['lead_form_type'] == 'buyer' ) {
$lead_form_type_buyer_selected = 'selected';
} else {
$lead_form_type_selected = 'selected';
}
}
$output = '';
$output.= '';
$output.='Select Form ';
$output.='Buyers Form ';
$output.='Sellers Form ';
$output.='General Contact Form ';
$output.=' ';
$getSubscriptionStatus = get_option('crea_subscription_status', '');
if( isset( $getSubscriptionStatus ) && !empty( $getSubscriptionStatus ) && $getSubscriptionStatus === 'valid' )
{
$output.='';
$output.='Select Agent Name ';
$sql_select = "SELECT * FROM `$crea_agent_table_name`";
$sql_prep = $wpdb->prepare( $sql_select, NULL );
$get_lead_agent_name = $wpdb->get_results($sql_prep);
if (!empty($get_lead_agent_name) && $get_lead_agent_name != '') {
foreach ($get_lead_agent_name as $get_lead_agent_name_value) {
$lead_agent_selected = '';
if ( !empty( $_GET['lead_agent_name'] ) && isset( $_GET['lead_agent_name'] ) ) {
if ( $_GET['lead_agent_name'] == $get_lead_agent_name_value->crea_agent_id ){
$lead_agent_selected = 'selected';
}
}
$output.=''.$get_lead_agent_name_value->crea_agent_name.' ';
}
}
$output.=' ';
}
$taxonomy = 'lead-category';
$term_args=array(
'hide_empty' => false,
'orderby' => 'name',
'order' => 'ASC',
'post_type' => 'aretk_lead',
);
$tax_terms = get_terms($taxonomy,$term_args);
$output.='';
$output.='Select Lead Category ';
$category_name_filter_selected = isset($_GET['lead_category_name']) ? sanitize_text_field($_GET['lead_category_name']) : '';
foreach ( $tax_terms as $lead_category_name){
$selected_category_name ='';
if( $category_name_filter_selected == $lead_category_name->name ) {
$selected_category_name = 'selected';
}
$output.=''.$lead_category_name->name.' ';
}
$output.=' ';
echo $output;
}
}
/**
* Prepare Query based on Select form
* This hook is called after the query variable object is created, but before the actual query is run.
*/
public function aretkcrea_pre_get_posts_custom_for_lead( $query )
{
global $post_type, $pagenow;
//if we are currently on the edit screen of the post type listings
if($pagenow == 'edit.php' && $post_type == 'aretk_lead')
{
if(isset($_GET['lead_form_type']))
{
//get the lead form type
$lead_form_type = !empty( $_GET['lead_form_type'] ) ? sanitize_text_field($_GET['lead_form_type']) : '';
//get the agent name
$lead_agent_name = !empty( $_GET['lead_agent_name'] ) ? sanitize_text_field($_GET['lead_agent_name']) : '';
//get the category name
$lead_category_name =!empty( $_GET['lead_category_name'] ) ? sanitize_text_field($_GET['lead_category_name']) : '';
//if the post format is not 0 (which means all)
if( $lead_form_type != 'selectform' && $lead_form_type != '' )
{
$query->query_vars['meta_query'] = array(
array(
'key' => 'lead_form_type',
'value' => $lead_form_type,
'compare' => '='
)
);
}
if( $lead_category_name !='selectcategoryname' && $lead_category_name !='')
{
$query->query_vars['tax_query'] = array(
array(
'taxonomy' => 'lead-category',
'field' => 'name',
'terms' => $lead_category_name
)
);
}
//set meta query for filter agent id
if( $lead_agent_name != 'selectagentid' && $lead_agent_name != '' )
{
$query->query_vars['meta_query'] = array(
array(
'key' => 'crea_agent_id',
'value' => $lead_agent_name,
'compare' => '='
)
);
}
//filter both query agent and form
if( $lead_agent_name != 'selectagentid' && $lead_form_type != 'selectform' && $lead_form_type != '' && $lead_agent_name != '' )
{
$query->query_vars['meta_query'] = array(
'relation' => 'AND',
array(
'key' => 'lead_form_type',
'value' => $lead_form_type,
'compare' => '='
),
array(
'key' => 'crea_agent_id',
'value' => $lead_agent_name,
'compare' => '='
)
);
}
if( $lead_agent_name != 'selectagentid' && $lead_category_name != 'selectcategoryname' && $lead_agent_name != '' && $lead_category_name != '' )
{
$query->query_vars['meta_query'] = array(
array(
'key' => 'crea_agent_id',
'value' => $lead_agent_name,
'compare' => '='
)
);
$query->query_vars['tax_query'] = array(
array(
'taxonomy' => 'lead-category',
'field' => 'name',
'terms' => $lead_category_name
)
);
}
// two table lead form and category form is selected
if( $lead_form_type != 'selectform' && $lead_form_type != '' && $lead_category_name != 'selectcategoryname' && $lead_category_name != '' ){
$query->query_vars['meta_query'] = array(
array(
'key' => 'lead_form_type',
'value' => $lead_form_type,
'compare' => '='
)
);
$query->query_vars['tax_query'] = array(
array(
'taxonomy' => 'lead-category',
'field' => 'name',
'terms' => $lead_category_name
)
);
}
// if three box are selected
if( $lead_form_type != 'selectform' && $lead_form_type != '' && $lead_category_name != 'selectcategoryname' && $lead_category_name != '' && $lead_agent_name != 'selectagentid' && $lead_agent_name != '' ){
$query->query_vars['meta_query'] = array(
'relation' => 'AND',
array(
'key' => 'lead_form_type',
'value' => $lead_form_type,
'compare' => '='
),
array(
'key' => 'crea_agent_id',
'value' => $lead_agent_name,
'compare' => '='
)
);
$query->query_vars['tax_query'] = array(
array(
'taxonomy' => 'lead-category',
'field' => 'name',
'terms' => $lead_category_name
)
);
}
}
}
}
/**
* Bulk Edit action
* Creates the bulk options on the leads page
*/
public function aretkcrea_custom_bulk_edit_action_for_aretk_lead( $actions )
{
$actions[ 'email' ] = 'Email';
unset( $actions[ 'edit' ] );
return $actions;
}
/**
* Custom Lead Admin footer
*
*/
public function aretkcrea_custom_lead_admin_footer()
{
global $post_type;
if($post_type == 'aretk_lead') {
/*
// Commented out as this is already set, keeping for now in case scenario found where this is needed..
?>
query['post_type']) ? $wp_query->query['post_type'] : '';
if ( $post_type == 'aretk_lead')
{
if( !empty( $_GET['orderby'] ) && !empty( $_GET['order'] ) )
{
$wp_query->set('orderby', sanitize_text_field($_GET['orderby']));
$wp_query->set('order', sanitize_text_field($_GET['order']));
} else {
$wp_query->set('orderby', 'post_modified');
$wp_query->set('order', 'DESC');
}
}
}
/**
* add class(es) into body class
*
*/
public function aretkcrea_admin_body_classes ( $classes )
{
$classes .= ' aretk';
$page = !empty($_GET['page']) ? sanitize_text_field($_GET['page']) : '';
$id = !empty($_GET['id']) ? (INT)($_GET['id']) : '';
if ( $page === 'listings_settings' && is_numeric($id) ){
$classes .= ' aretk-geocode-listing';
}
return $classes;
}
/**
* Custom Email Bulk action
*
*/
public function aretkcrea_custom_email_bulk_action ()
{
$wp_list_table = _get_list_table('WP_Posts_List_Table');
$action = $wp_list_table->current_action();
if ( isset($action) && $action == 'email' )
{
$all_selected_email = isset($_REQUEST['post']) ? $_REQUEST['post'] : '';
if ( !empty($all_selected_email) )
{
$all_bcc_email = array();
foreach ( $all_selected_email as $all_custom_selected_email )
{
$all_bcc_email[] = (int) $all_custom_selected_email;
}
update_option('selected_lead_post_email_to_bcc' , $all_bcc_email);
wp_safe_redirect(admin_url( 'admin.php?page=send_email_leads&email=bcc' ));
exit();
}
}
}
/**
* Delete Exclusive Listing
*
*/
public function aretkcrea_delete_excusive_listing()
{
global $wpdb;
$exclusiveListingId = (INT) $_POST['mlsId'];
if ( !empty($exclusiveListingId) && is_user_logged_in() && current_user_can('upload_files') )
{
$last_aretk_server_insert_id = get_post_meta($exclusiveListingId,'aretk_server_listing_id',true);
if ( !empty( $last_aretk_server_insert_id ) && $last_aretk_server_insert_id != '' )
{
$exclusiveListingIdResult = array();
$exclusiveListingIdResult[] = (string)$last_aretk_server_insert_id;
$exclusive_old_property_id_array = array();
$mergerd_property_id_array = array();
$exclusive_deleted_id_result = get_option("exclusive_deleted_ids");
if ( !empty( $exclusive_deleted_id_result ) && $exclusive_deleted_id_result != 'null' ) {
$exclusive_old_property_id_array = json_decode($exclusive_deleted_id_result);
}
$mergerd_property_id_array = array_merge($exclusive_old_property_id_array,$exclusiveListingIdResult);
$mergerd_property_id_array = array_unique($mergerd_property_id_array);
$mergerd_property_id_array = json_encode($mergerd_property_id_array);
update_option("exclusive_deleted_ids",$mergerd_property_id_array);
}
$upload_dir = wp_upload_dir();
if ( !empty($upload_dir['basedir']) )
{
$crea_listing_images_detail_table_name = $wpdb->prefix.ARETKCREA_LISTING_IMAGES_HISTORY;
$sql_select = "SELECT `image_url` FROM `$crea_listing_images_detail_table_name` WHERE `unique_id`= %d";
$sql_prep = $wpdb->prepare( $sql_select, $exclusiveListingId );
$resultListingImagesResults = $wpdb->get_results($sql_prep);
foreach ($resultListingImagesResults as $imageResults)
{
$image_url = $imageResults->image_url;
if ( !empty($image_url) )
{
list($imageBase, $imagePath) = explode('uploads/', $image_url);
$imagePath = esc_url($upload_dir['basedir'] .'/'. $imagePath);
if ( file_exists($imagePath) && wp_is_writable($imagePath) )
{
if ( false === unlink($imagePath) )
{
echo 'Caught exception: could not remove document, check file permissions for: '. $imagePath . "\n";
}
}
}
}
# Docs
$crea_listing_document_detail_table_name = $wpdb->prefix.ARETKCREA_LISTING_DOCUMENT_HISTORY;
$sql_select = "SELECT `document_url` FROM `$crea_listing_document_detail_table_name` WHERE `unique_id`= %d LIMIT 1";
$sql_prep = $wpdb->prepare( $sql_select, $exclusiveListingId );
$resultListingDocResults = $wpdb->get_results($sql_prep);
foreach ($resultListingImagesResults as $docResults)
{
$docURL = $docResults->document_url;
if ( !empty($docURL) )
{
list($docBase, $docPath) = explode('uploads/', $docURL);
$docPath = esc_url($upload_dir['basedir'] .'/'. $docPath);
if ( file_exists($docPath) && wp_is_writable($docPath) )
{
if ( false === unlink($docPath) )
{
echo 'Caught exception: could not remove document, check file permissions' . "\n";
$fileDeleteError = true;
}
}
}
}
$sql_select = "DELETE FROM FROM `$crea_listing_images_detail_table_name` WHERE `unique_id`= %d";
$sql_prep = $wpdb->prepare( $sql_select, $exclusiveListingId );
$wpdb->query($sql_prep);
$sql_select = "DELETE FROM `$crea_listing_document_detail_table_name` WHERE `unique_id`= %d AND `unique_id` = %d";
$sql_prep = $wpdb->prepare( $sql_select, $docID, $listingID );
$wpdb->query($sql_prep);
}
$getAretkServerListingIdPostMeta = get_post_meta($exclusiveListingId,'aretk_server_listing_id',true);
if (isset($getAretkServerListingIdPostMeta) && !empty($getAretkServerListingIdPostMeta)) {
$listingId = (int) $getAretkServerListingIdPostMeta;
Aretk_Crea_Admin::aretkcrea_listing_update_to_aretk_server($listingId,'delete');
}
wp_delete_post($exclusiveListingId);
# Return Listings data
$agent_id = Aretk_Crea_Admin::aretkcrea_crea_agent_ids('list');
$userNameList = Aretk_Crea_Admin::aretkcrea_feed_usernames('list');
$allListingArr = array();
$getSubscriptionStatus = get_option('crea_subscription_status', '');
if( !empty($getSubscriptionStatus) && $getSubscriptionStatus === 'valid' )
{
if ( !empty($agent_id) && !empty($userNameList) )
{
$result_type = 'full';
$listings = Aretk_Crea_Admin::aretkcrea_get_listing_records_based_on_agents($userNameList, $result_type, $agent_id);
if ( isset($listings) && !empty($listings))
{
foreach ($listings as $listing_key => $listing )
{
if ( !isset( $listing->TotalRecords ) && empty( $listing->TotalRecords ) ) {
$allListingArr[$listing->mlsID] = $listing;
}
}
}
}
}
$args = array(
'posts_per_page' => -1,
'post_type' => 'aretk_listing',
'post_status' => 'publish'
);
$posts_array = (array) get_posts( $args );
$exclusiveArr = array();
foreach ($posts_array as $singlePost) {
$singlePost1 = (array) $singlePost;
$singlePost2 = (object) $singlePost1;
$exclusiveArr[] = $singlePost2;
}
$allListingFinalArr = array();
$allListingFinalArr = array_merge($allListingArr,$exclusiveArr);
if (!empty($allListingFinalArr))
{
$data = json_encode($allListingFinalArr);
update_option('cron_run',"");
update_option('cron_run',"$data");
}
$html = '';
$html .= '
'.__(ARETKCREA_ADD_LISTING_TABLE_PHOTO,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_MLS,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_ADDRESS,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_CITY,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_PRICE,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_AGENT_NAME,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_VIEWS,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_DATE,ARETKCREA_PLUGIN_SLUG).'
';
if (isset($allListingFinalArr) && !empty($allListingFinalArr))
{
foreach ($allListingFinalArr as $singleListing)
{
if (isset($singleListing->post_author) && !empty($singleListing->post_author))
{
$singleListingID = $singleListing->ID;
$ListingAddress = get_post_meta($singleListingID,'listingAddress',true);
$ListingCity = get_post_meta($singleListingID,'listingcity',true);
$ListingPrice = get_post_meta($singleListingID,'listingPrice',true);
$date = date('d-m-Y',strtotime($singleListing->post_date));
$crea_listing_images_detail_table_name = $wpdb->prefix.ARETKCREA_LISTING_IMAGES_HISTORY;
$sql_select = "SELECT `image_url` FROM `$crea_listing_images_detail_table_name` WHERE `image_position`=1 AND `unique_id`= %d";
$sql_prep = $wpdb->prepare( $sql_select, $singleListingID );
$resultSet = $wpdb->get_results($sql_prep);
if (isset($resultSet) && !empty($resultSet)) {
$path = $resultSet[0]->image_url;
} else {
$path = ARETK_CREA_PLUGIN_URL.'admin/images/dummy_image.png';
}
$agentArrDecoded = get_post_meta($singleListing->ID,'listingAgentId',true);
$agentArr = json_decode($agentArrDecoded);
if (isset($agentArr) && !empty($agentArr)) {
$htmlAgent = '';
$crea_agent_table_name = $wpdb->prefix.ARETKCREA_AGENT_TABLE;
foreach ($agentArr as $singleAgent)
{
$sql_select = "SELECT `crea_agent_name` FROM `$crea_agent_table_name` WHERE `crea_agent_id`= %d";
$sql_prep = $wpdb->prepare( $sql_select, $singleAgent );
$resultAgentArr = $wpdb->get_results($sql_prep);
if ( isset( $resultAgentArr ) && !empty( $resultAgentArr ) ) {
$htmlAgent .= $resultAgentArr[0]->crea_agent_name . ', ';
}
}
}
$listingpagecount = 0;
$getSubscriptionStatus = get_option('crea_subscription_status', '');
if( isset( $getSubscriptionStatus ) && !empty( $getSubscriptionStatus ) && $getSubscriptionStatus === 'valid' ) {
$aretk_server_listing_id = get_post_meta($singleListing->ID,'aretk_server_listing_id',true);
if( !empty( $aretk_server_listing_id ) && $aretk_server_listing_id !='' ) {
$listingpageRecords = Aretk_Crea_Admin::aretkcrea_get_property_detail_page_result_for_exclusive($aretk_server_listing_id);
if ( $listingpageRecords[0]->TotalRecords != 0 ){
$listingpagecount = isset( $listingpageRecords[1]->ViewCount ) ? $listingpageRecords[1]->ViewCount : 0;
} else {
$listingpagecount = 0;
}
} else{
$listingpagecount = 0;
}
} else {
$listingpageval = get_post_meta($singleListing->ID,'crea_aretk_db_listing_page_count',true);
if( !empty( $listingpageval ) && $listingpageval !='' ) {
$listingpagecount = $listingpageval;
} else {
$listingpagecount = 0;
}
}
$link_url = admin_url('admin.php?page=create_new_listings&id='.$singleListing->ID);
$html .= '
ExclusiveEdit | Trash
'.$ListingAddress.'
'.$ListingCity.'
$'.$ListingPrice.'
'. rtrim($htmlAgent, ', ') .'
'.$listingpagecount.'
'.$date.'
';
} else {
$htmlAgent = '';
foreach ($singleListing->listing_agents as $singleAgent) {
$htmlAgent .= $singleAgent->Name.', ';
}
if (is_object ($singleListing->listing_photos)) {
if ($singleListing->listing_photos->URL == '' || $singleListing->listing_photos->URL == null) {
$apiListingImageURL = ARETK_CREA_PLUGIN_URL.'admin/images/dummy_image.png';
} else {
$apiListingImageURL = $singleListing->listing_photos->URL;
}
} else if (is_object ($singleListing->listing_photos[0])) {
if ($singleListing->listing_photos[0]->URL == '' || $singleListing->listing_photos[0]->URL == null) {
$apiListingImageURL = ARETK_CREA_PLUGIN_URL.'admin/images/dummy_image.png';
} else {
$apiListingImageURL = $singleListing->listing_photos[0]->URL;
}
} else {
$apiListingImageURL = ARETK_CREA_PLUGIN_URL.'admin/images/dummy_image.png';
}
$mlsId = isset($singleListing->mlsID) ? $singleListing->mlsID : '-';
$dates = isset($singleListing->ListingContractDate) ? $singleListing->ListingContractDate : '-';
$listingpagecount = isset( $singleListing->ViewCount ) ? $singleListing->ViewCount : 0;
$link_url = admin_url('admin.php?page=listings_settings&id='. $singleListing->ID);
$html .= '
'.$mlsId.''. __("Map It", ARETKCREA_PLUGIN_SLUG).'
'.$singleListing->StreetAddress.' '.$singleListing->StreetNumber.'
'.$singleListing->City.'
$'.$singleListing->Price.'
'.rtrim($htmlAgent, ', ').'
'.$listingpagecount.'
'.$dates.'
';
}
}
}
$html .= '
'.__(ARETKCREA_ADD_LISTING_TABLE_PHOTO,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_MLS,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_ADDRESS,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_CITY,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_PRICE,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_AGENT_NAME,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_VIEWS,ARETKCREA_PLUGIN_SLUG).'
'.__(ARETKCREA_ADD_LISTING_TABLE_DATE,ARETKCREA_PLUGIN_SLUG).'
';
echo $html;
}
die();
}
/**
* This function will save/update the showcase settings
*
* @param null
* @return null
* @since Phase 1
*/
public function aretkcrea_handle_create_new_showcase_form_action()
{
global $wpdb, $wp;
# only proceed if postype is showcase
if (isset($_POST['posttype']) && $_POST['posttype'] == 'showcase')
{
// Showcase title
$crea_showcase_title = isset($_POST['crea_showcase_title']) ? sanitize_text_field( $_POST['crea_showcase_title'] ) : '';
// Showcase Display type
$crea_showcase_display_theams_option = isset($_POST['crea_showcase_theams_option']) ? sanitize_text_field($_POST['crea_showcase_theams_option']) : 'Listing View';
$showcase_options = array('Listing View','Grid View','Carousel','Map','Slider');
if ( !in_array($crea_showcase_display_theams_option, $showcase_options) )
{
$crea_showcase_display_theams_option = 'Listing View';
}
// showcase CREA feed
$crea_feed_ddf_type = isset($_POST['crea_showcase_feed_ddf_option']) ? sanitize_text_field($_POST['crea_showcase_feed_ddf_option']) :'';
// Include exclusive listings
$crea_feed_include_exclude = $_POST['crea_showcase_inc_exc_listing_feed'] === 'yes' ? 'yes' : 'no';
// Filter listings by date listed
$crea_showcase_filter_by_other_day = isset($_POST['crea_showcase_filter_by_other_days']) ? sanitize_text_field($_POST['crea_showcase_filter_by_other_days']) : '';
// Filter Open houses
$crea_showcase_filter_inclue_open_house = isset($_POST['crea_checkbox_open_house_filter']) ? sanitize_text_field($_POST['crea_checkbox_open_house_filter']) : '';
// Filter Price Min
$showcase_filter_price_min = isset($_POST['showcase_filter_price_min']) ? (int) $_POST['showcase_filter_price_min'] : '';
// Filter Price Max
$showcase_filter_price_max = isset($_POST['showcase_filter_price_max']) ? (int) $_POST['showcase_filter_price_max'] : '';
// Filter Property Types
$showcase_filter_property_types = !empty($_POST['showcase_filter_property_types']) ? (array) $_POST['showcase_filter_property_types'] : array();
$showcase_filter_property_types_results = sanitize_text_field(implode(",",$showcase_filter_property_types));
// Filter Listing Status
$showcase_filter_property_status = !empty($_POST['showcase_filter_property_status']) ? (array)$_POST['showcase_filter_property_status'] : array();
$showcase_filter_property_status_results = sanitize_text_field(implode(",",$showcase_filter_property_status));
// Filter Brokerage
$crea_filter_brokerage = isset($_POST['crea_filter_brokerage']) ? (array) $_POST['crea_filter_brokerage'] : array();
$crea_filter_brokerage_results = sanitize_text_field(implode(",",$crea_filter_brokerage));
// Filter Office
$crea_filter_office = isset($_POST['crea_filter_office']) ? (array) $_POST['crea_filter_office'] :array();
$crea_filter_office_results = sanitize_text_field(implode(",",$crea_filter_office));
// Filter Agents method 1
$crea_filter_agent_name = isset($_POST['crea_filter_agent_name']) ? (array) $_POST['crea_filter_agent_name'] : array();
$crea_filter_agent_name_results = sanitize_text_field(implode(",",$crea_filter_agent_name));
// Filter Agents method 2
$showcase_filter_listing_agent_ids = !empty($_POST['showcase_filter_listing_agent_ids']) ? (array) $_POST['showcase_filter_listing_agent_ids'] : array();
$showcase_filter_listing_agent_ids_results = sanitize_text_field(implode(",",$showcase_filter_listing_agent_ids));
// Filter listings by Province
$showcase_filter_listing_province = !empty($_POST['showcase_filter_listing_province']) ? (array) $_POST['showcase_filter_listing_province'] : array();
$showcase_filter_listing_province_results = sanitize_text_field(implode(",",$showcase_filter_listing_province));
//------------------------
// Filter map settings
$crea_showcase_filter_by_map_km = isset($_POST['crea_filter_by_map_km']) ? (float) sanitize_text_field($_POST['crea_filter_by_map_km']) : '';
if ( isset($_POST['showcase_filter_google_map_zoom']) && is_numeric($_POST['showcase_filter_google_map_zoom']) && $_POST['showcase_filter_google_map_zoom'] !== '0' ){
$showcse_crea_filter_google_map_zoom = (int) $_POST['showcase_filter_google_map_zoom'];
} else {
$showcse_crea_filter_google_map_zoom = '';
}
$crea_filter_google_map_latitude = isset($_POST['crea_filter_google_map_latitude']) ? sanitize_text_field($_POST['crea_filter_google_map_latitude']) : '';
$crea_filter_google_map_longitude = isset($_POST['crea_filter_google_map_longitude']) ? sanitize_text_field($_POST['crea_filter_google_map_longitude']) : '';
if (isset($_POST['crea_filter_google_map_latitude']) && is_numeric($_POST['crea_filter_google_map_latitude']))
{
$crea_filter_google_map_latitude = (float) preg_replace('/[^\d-.]+/', '', $crea_filter_google_map_latitude);
} else {
$crea_filter_google_map_latitude = '';
}
if (isset($_POST['crea_filter_google_map_longitude']) && is_numeric($_POST['crea_filter_google_map_longitude']))
{
$crea_filter_google_map_longitude = (float) preg_replace('/[^\d-.]+/', '', $crea_filter_google_map_longitude);
} else {
$crea_filter_google_map_longitude = '';
}
// End Map Settings
//-------------------------------------
$crea_filter_brokerage_hidden_name = isset($_POST['crea_filter_brokerage_hidden_name']) ? sanitize_text_field($_POST['crea_filter_brokerage_hidden_name']) : '';
$crea_showcse_office_filter_hidden_name = isset($_POST['crea_showcse_office_filter_hidden_name']) ? sanitize_text_field($_POST['crea_showcse_office_filter_hidden_name']) : '';
$crea_showcse_agent_name_filter_hidden_name = isset($_POST['crea_showcse_agent_name_filter_hidden_name']) ? sanitize_text_field($_POST['crea_showcse_agent_name_filter_hidden_name']) : '';
$crea_filter_listing = isset($_POST['crea_filter_listing']) ? sanitize_text_field($_POST['crea_filter_listing']) :'';
//-------------------------------------
//========================================
// Display Settings
// create Serializable settings array
$Serializable_listing_array = array();
$Serializable_grid_array = array();
$Serializable_carousel_array = array();
$Serializable_map_array = array();
$Serializable_slider_array = array();
if ( $crea_showcase_display_theams_option == "Listing View" )
{
$crea_sorting_showcase_name = isset($_POST['crea_sorting_listing_showcase_name']) ? sanitize_text_field($_POST['crea_sorting_listing_showcase_name']) : '';
$listing_view_setiing = $_POST['listing_view_setiing'] === 'yes' ? 'yes' : '';
$listing_search_position = isset($_POST['listing_search_position']) ? sanitize_text_field($_POST['listing_search_position']) : '';
$listing_view_top = isset($_POST['listing_view_top']) ? sanitize_text_field( $_POST['listing_view_top']) : '';
$listing_view_right = isset($_POST['listing_view_right']) ? sanitize_text_field($_POST['listing_view_right']) : '';
$Max_listings_on_a_page = isset($_POST['Max_listings_on_a_page']) ? (int)$_POST['Max_listings_on_a_page'] : '';
$Listing_search_simple_enable_or_disable = $_POST['listing_view_setiing_status_of_search'] === 'yes' ? 'yes' : 'no';
$listing_view_open_house_or_not = $_POST['listing_view_setiing_open_house'] === 'yes' ? 'yes' : 'no';
$listing_view_status_or_not = $_POST['listing_view_setiing_status'] === 'yes' ? 'yes' : 'no';
$Serializable_listing_array = array(
"listingshowcasename" => $crea_sorting_showcase_name,
"listingviewsearchbar" => $listing_view_setiing,
"listingsearchposition" => $listing_search_position,
"listingviewtop" => $listing_view_top,
"listingviewright" => $listing_view_right,
"maxlistingonpage" => $Max_listings_on_a_page,
"listingopenhouse" => $listing_view_open_house_or_not,
"listingstatus" => $listing_view_status_or_not,
"Listing_search_simple_enable_or_disable" => $Listing_search_simple_enable_or_disable
);
}
if ( $crea_showcase_display_theams_option == "Grid View" )
{
$crea_sorting_showcase_name = isset($_POST['crea_sorting_showcase_grid_name']) ? sanitize_text_field($_POST['crea_sorting_showcase_grid_name']) : '';
$listing_view_setiing = $_POST['grid_search_view_setiing'] === 'yes' ? 'yes' : 'no';
$listing_search_position = isset($_POST['listing_search_position']) ? sanitize_text_field($_POST['listing_search_position']) : '';
$listing_view_top = isset($_POST['listing_view_top']) ? sanitize_text_field($_POST['listing_view_top']) : '';
$listing_view_right = isset($_POST['listing_view_right']) ? sanitize_text_field($_POST['listing_view_right']) : '';
$crea_max_grid_selected_row = isset($_POST['crea_max_grid_selected_row']) ? sanitize_text_field($_POST['crea_max_grid_selected_row']) : '';
$crea_max_grid_selected_column = isset($_POST['crea_max_grid_selected_column']) ? (int) $_POST['crea_max_grid_selected_column'] : '';
$grid_view_open_house_or_not = $_POST['grid_view_setiing_open_house'] === 'yes' ? 'yes' : '';
$grid_view_status_or_not = $_POST['grid_view_setiing_status'] === 'yes' ? 'yes' : '';
$grid_view_setiing_status_search = $_POST['grid_view_setiing_status_search'] === 'yes' ? 'yes' : 'no';
$Serializable_grid_array = array(
"gridviewshowcasename" => $crea_sorting_showcase_name,
"gridviewsearchbar" => $listing_view_setiing, # Show search form
"gridviewsearchpostion" => $listing_search_position,
"gridviewtop" => $listing_view_top,
"gridviewright" => $listing_view_right,
"maxgridviewselectedrow" => $crea_max_grid_selected_row,
"maxgridviewselectedcolumn" => $crea_max_grid_selected_column,
"gridviewopenhouse" => $grid_view_open_house_or_not,
"gridviewstatus" => $grid_view_status_or_not, # Search open/closed
"grid_view_setiing_status_search_simple_or_datail" => $grid_view_setiing_status_search
);
}
if( $crea_showcase_display_theams_option == "Carousel" )
{
$crea_sorting_showcase_name = !empty($_POST['crea_sorting_showcase_carousel_name']) ? sanitize_text_field($_POST['crea_sorting_showcase_carousel_name']) : '';
$listing_carousel_show_price = $_POST['listing_carousel_show_price'] === 'no' ? 'no' : 'yes';
$listing_carousel_show_status = $_POST['listing_carousel_show_status'] === 'no' ? 'no' : 'yes';
$listing_carousel_show_open_house_info = $_POST['listing_carousel_show_open_house_info'] === 'no' ? 'no' :'yes';
$crea_min_of_listing_carousel = !empty($_POST['crea_min_of_listing_carousel']) ? (int) $_POST['crea_min_of_listing_carousel'] : 4;
$Max_of_listings_for_Carousel = !empty($_POST['Max_of_listings_for_Carousel']) ? (int) $_POST['Max_of_listings_for_Carousel'] : 20;
$listing_carousel_display_prevnext = $_POST['listing_carousel_display_prevnext'] === 'true' ? 'true' : 'false';
$listing_carousel_scroll_speed = !empty($_POST['listing_carousel_scroll_speed']) ? (int) $_POST['listing_carousel_scroll_speed'] :'3000';
$listing_carousel_pagination_dots = $_POST['listing_carousel_pagination_dots'] === 'false' ? 'false' : 'true';
$Serializable_carousel_array = array(
"carouselshowcasename"=>$crea_sorting_showcase_name,
"carouselshowcasenameprice"=>$listing_carousel_show_price,
"carouselshowcasenamestatus"=>$listing_carousel_show_status,
"carouselshowcasenameopenhouseinfo"=>$listing_carousel_show_open_house_info,
"minlistingcarouselshowcasename"=>$crea_min_of_listing_carousel,
"maxlistingcarouselshowcasename"=>$Max_of_listings_for_Carousel,
"listing_carousel_display_prevnext"=>$listing_carousel_display_prevnext,
"listing_carousel_scroll_speed"=>$listing_carousel_scroll_speed,
"listing_carousel_pagination_dots"=>$listing_carousel_pagination_dots,
);
}
if( $crea_showcase_display_theams_option == "Map" )
{
$map_search_bar_view = $_POST['map_search_view_setiing'] === 'true' ? 'true' : 'false';
$map_view_setiing_status_search = $_POST['map_view_setiing_status_search'] === 'yes' ? 'yes' : '';
$google_image_zoom = isset($_POST['google_image_zoom']) ? (int) $_POST['google_image_zoom'] : '6';
if ( isset($_POST['crea_showcase_google_map_latitude']) && is_numeric($_POST['crea_showcase_google_map_latitude']) )
{
$crea_showcase_google_map_latitude = floatval(preg_replace('/[^\d-.]+/', '', $_POST['crea_showcase_google_map_latitude']));
} else {
$crea_showcase_google_map_latitude = '';
}
if ( isset($_POST['crea_showcase_google_map_longitude']) && is_numeric($_POST['crea_showcase_google_map_longitude']) )
{
$crea_showcase_google_map_longitude = floatval(preg_replace('/[^\d-.]+/', '', $_POST['crea_showcase_google_map_longitude']));
} else {
$crea_showcase_google_map_longitude = '';
}
$mapviewopenhouse_yes_or_not = isset($_POST['map_view_setiing_open_house']) ? sanitize_text_field($_POST['map_view_setiing_open_house']) : '';
$mapviewstatus_yes_or_not = isset($_POST['map_view_setiing_status']) ? sanitize_text_field($_POST['map_view_setiing_status']) : '';
$only_map_view_display_hight = isset($_POST['only_map_view_display_hight']) ? (int) $_POST['only_map_view_display_hight'] : '';
$Serializable_map_array = array(
"mapfilterlatitude" => $crea_showcase_google_map_latitude,
"mapfilterlongitude" => $crea_showcase_google_map_longitude,
"showcasemapimagezoom" => $google_image_zoom,
"mapopenhouse" => $mapviewopenhouse_yes_or_not,
"mapstatus" => $mapviewstatus_yes_or_not,
"mapviewdisplayhight" => $only_map_view_display_hight,
"mapviewdisplaysearch" => $map_search_bar_view,
"mapviewdisplaysearch_simple_or_detail" => $map_view_setiing_status_search,
);
}
if( $crea_showcase_display_theams_option == "Slider" )
{
$crea_sorting_showcase_slider_display_name = isset($_POST['crea_sorting_showcase_slider_display_name']) ? sanitize_text_field($_POST['crea_sorting_showcase_slider_display_name']) : '';
$listing_slider_show_price = $_POST['listing_slider_show_price'] === 'yes' ? 'yes' : 'no';
$listing_slider_show_status = $_POST['listing_slider_show_status'] === 'yes' ? 'yes' : 'no';
$listing_slider_show_open_house_info = $_POST['listing_slider_show_open_house_info'] === 'yes' ? 'yes' :'no';
$min_of_listing_slider = isset($_POST['min_of_listing_slider']) ?(int) $_POST['min_of_listing_slider'] : '';
$max_of_listings_for_slider = isset($_POST['max_of_listings_for_slider']) ? (int) $_POST['max_of_listings_for_slider'] : '';
$Serializable_slider_array = array(
"sildersortingshowcasename" => $crea_sorting_showcase_slider_display_name,
"slidershowcaseshowprice" => $listing_slider_show_price,
"slidershowcaseshowstatus" => $listing_slider_show_status,
"slidershowcaseopenhouseinfo" => $listing_slider_show_open_house_info,
"minslidershowcaselisting" => $min_of_listing_slider,
"maxslidershowcaselisting" => $max_of_listings_for_slider,
);
}
// End Display Settings
//========================================
//========================================
// Showcase colour settings
// list view colour
$crea_listing_showcase_text_color = '';
$crea_listing_showcase_address_bar_color = '';
$crea_listing_showcase_price_color = '';
$crea_listing_showcase_status_color = '';
$crea_listing_showcase_open_house_color = '';
$crea_listing_view_color_array = array();
if( $crea_showcase_display_theams_option == "Listing View" )
{
$crea_listing_showcase_text_color = isset($_POST['crea_listing_showcase_text_color']) ? sanitize_hex_color_no_hash($_POST['crea_listing_showcase_text_color']) : '';
$crea_listing_showcase_address_bar_color = isset($_POST['crea_listing_showcase_address_bar_color']) ? sanitize_hex_color_no_hash($_POST['crea_listing_showcase_address_bar_color']) : '';
$crea_listing_showcase_price_color = isset($_POST['crea_listing_showcase_price_color']) ? sanitize_hex_color_no_hash($_POST['crea_listing_showcase_price_color']) : '';
$crea_listing_showcase_status_color = isset($_POST['crea_listing_showcase_status_color']) ? sanitize_hex_color_no_hash($_POST['crea_listing_showcase_status_color']) : '';
$crea_listing_showcase_open_house_color = isset($_POST['crea_listing_showcase_open_house_color']) ? sanitize_hex_color_no_hash($_POST['crea_listing_showcase_open_house_color']) : '';
$crea_listing_showcase_status_text_color = isset($_POST['crea_listing_showcase_status_text_color']) ? sanitize_hex_color_no_hash($_POST['crea_listing_showcase_status_text_color']) : '';
$crea_listing_showcase_open_house_text_color = isset($_POST['crea_listing_showcase_open_house_text_color']) ? sanitize_hex_color_no_hash($_POST['crea_listing_showcase_open_house_text_color']) : '';
$crea_listing_showcase_pagination_color = isset($_POST['crea_listing_showcase_pagination_color']) ? sanitize_hex_color_no_hash($_POST['crea_listing_showcase_pagination_color']) : '';
$crea_listing_showcase_pagination_text_color = isset($_POST['crea_listing_showcase_pagination_text_color']) ? sanitize_hex_color_no_hash($_POST['crea_listing_showcase_pagination_text_color']) : '';
$crea_listing_view_color_array = array(
"listingShowcaseTextColor"=>$crea_listing_showcase_text_color,
"listingShowcaseAddressBarColor"=>$crea_listing_showcase_address_bar_color,
"listingShowcasePriceColor"=>$crea_listing_showcase_price_color,
"listingShowcaseStatusColor"=>$crea_listing_showcase_status_color,
"listingShowcaseOpenHouseColor"=>$crea_listing_showcase_open_house_color,
"listingShowcaseOpenHouseTextColor"=>$crea_listing_showcase_open_house_text_color,
"listingShowcaseStatusTextColor"=>$crea_listing_showcase_status_text_color,
"listingShowcasepaginationColor"=>$crea_listing_showcase_pagination_color,
"listingShowcasepaginationtextColor"=>$crea_listing_showcase_pagination_text_color,
);
}
// Grid view color
$crea_grid_showcase_text_color = '';
$crea_grid_showcase_text_bgcolor = '';
$crea_grid_showcase_oh_color_txt = '';
$crea_grid_showcase_oh_color_bg = '';
$crea_showcase_status_box_text_color = '';
$crea_showcase_status_box_color = '';
$crea_showcase_pagination_text_color = '';
$crea_showcase_pagination_color = '';
$crea_grid_view_color_array = array();
if( $crea_showcase_display_theams_option == "Grid View" )
{
$crea_grid_showcase_text_color = isset($_POST['crea_grid_showcase_text_color']) ? sanitize_hex_color_no_hash($_POST['crea_grid_showcase_text_color']) : '';
$crea_grid_showcase_text_bgcolor = isset($_POST['crea_grid_showcase_text_bgcolor']) ? sanitize_hex_color_no_hash($_POST['crea_grid_showcase_text_bgcolor']) : '';
$crea_grid_showcase_oh_color_txt = isset($_POST['crea_grid_showcase_oh_color_txt']) ? sanitize_hex_color_no_hash($_POST['crea_grid_showcase_oh_color_txt']) : '';
$crea_grid_showcase_oh_color_bg = isset($_POST['crea_grid_showcase_oh_color_bg']) ? sanitize_hex_color_no_hash($_POST['crea_grid_showcase_oh_color_bg']) : '';
$crea_showcase_status_box_text_color = isset($_POST['crea_showcase_status_box_text_color']) ? sanitize_hex_color_no_hash($_POST['crea_showcase_status_box_text_color']) : '';
$crea_showcase_status_box_color = isset($_POST['crea_showcase_status_box_color']) ? sanitize_hex_color_no_hash($_POST['crea_showcase_status_box_color']) : '';
$crea_showcase_pagination_text_color = isset($_POST['crea_showcase_status_pagination_gird_text_color']) ? sanitize_hex_color_no_hash($_POST['crea_showcase_status_pagination_gird_text_color']) : '';
$crea_showcase_pagination_color = isset($_POST['crea_showcase_status_pagination_gird_color']) ? sanitize_hex_color_no_hash($_POST['crea_showcase_status_pagination_gird_color']) : '';
$crea_grid_view_color_array = array(
"gridShowcaseTextColor" => $crea_grid_showcase_text_color,
"gridShowcase_TextBgColor" => $crea_grid_showcase_text_bgcolor,
"gridShowcase_oh_color_txt" => $crea_grid_showcase_oh_color_txt,
"gridShowcase_oh_color_bg" => $crea_grid_showcase_oh_color_bg,
"gridShowcaseStatusBoxTextColor" => $crea_showcase_status_box_text_color,
"gridShowcaseStatusBoxColor" => $crea_showcase_status_box_color,
"gridShowcasePaginationColor" => $crea_showcase_pagination_color,
"gridShowcasePaginationTextColor" => $crea_showcase_pagination_text_color,
);
}
// Carousel view color
$crea_carousel_showcase_text_color ='';
$crea_carousel_showcase_background_color ='';
$crea_carousel_showcase_oh_color_txt = '';
$crea_carousel_showcase_oh_color_bg = '';
$crea_carousel_view_color_array = array();
if( $crea_showcase_display_theams_option == "Carousel" ) {
$crea_carousel_showcase_text_color = isset($_POST['crea_carousel_showcase_text_color']) ? sanitize_hex_color_no_hash($_POST['crea_carousel_showcase_text_color']) : '';
$crea_carousel_showcase_background_color = isset($_POST['crea_carousel_showcase_background_color']) ? sanitize_hex_color_no_hash($_POST['crea_carousel_showcase_background_color']) : '';
$crea_carousel_showcase_oh_color_txt = isset($_POST['crea_carousel_showcase_oh_color_txt']) ? sanitize_hex_color_no_hash($_POST['crea_carousel_showcase_oh_color_txt']) : '';
$crea_carousel_showcase_oh_color_bg = isset($_POST['crea_carousel_showcase_oh_color_bg']) ? sanitize_hex_color_no_hash($_POST['crea_carousel_showcase_oh_color_bg']) : '';
$crea_carousel_view_color_array = array(
"carouselShowcaseTextColor"=>$crea_carousel_showcase_text_color,
"carouselShowcaseBackgroundColor"=>$crea_carousel_showcase_background_color,
"crea_carousel_showcase_oh_color_txt"=>$crea_carousel_showcase_oh_color_txt,
"crea_carousel_showcase_oh_color_bg"=>$crea_carousel_showcase_oh_color_bg
);
}
// Map view color
$crea_map_showcase_text_color ='';
$crea_map_showcase_button_color ='';
$crea_map_showcase_reset_button_color ='';
$crea_map_showcase_listing_hover_color ='';
$crea_map_showcase_top_picture_color ='';
$crea_map_view_color_array = array();
if( $crea_showcase_display_theams_option == "Map" )
{
$crea_map_showcase_text_color = isset($_POST['crea_map_showcase_text_color']) ? sanitize_hex_color_no_hash($_POST['crea_map_showcase_text_color']) : '';
$crea_map_showcase_button_color = isset($_POST['crea_map_showcase_button_color']) ? sanitize_hex_color_no_hash($_POST['crea_map_showcase_button_color']) : '';
$crea_map_showcase_reset_button_color = isset($_POST['crea_map_showcase_reset_button_color']) ? sanitize_hex_color_no_hash($_POST['crea_map_showcase_reset_button_color']) : '';
$crea_map_showcase_listing_hover_color = isset($_POST['crea_map_showcase_listing_hover_color']) ? sanitize_hex_color_no_hash($_POST['crea_map_showcase_listing_hover_color']) : '';
$crea_map_showcase_top_picture_color = isset($_POST['crea_map_showcase_top_picture_color']) ? sanitize_hex_color_no_hash($_POST['crea_map_showcase_top_picture_color']) : '';
$crea_map_showcase_top_picture_text_color = isset($_POST['crea_map_showcase_top_picture_text_color']) ? sanitize_hex_color_no_hash($_POST['crea_map_showcase_top_picture_text_color']) : '';
$crea_map_showcase_price_color = isset($_POST['crea_map_showcase_price_color']) ? sanitize_hex_color_no_hash($_POST['crea_map_showcase_price_color']) : '';
$crea_map_showcase_price_text_color = isset($_POST['crea_map_showcase_price_text_color']) ? sanitize_hex_color_no_hash($_POST['crea_map_showcase_price_text_color']) : '';
$crea_map_view_color_array = array(
"mapShowcaseTextColor"=>$crea_map_showcase_text_color,
"mapShowcaseButtonColor"=>$crea_map_showcase_button_color,
"mapShowcaseResetButtonColor"=>$crea_map_showcase_reset_button_color,
"mapShowcaseListingHoverColor"=>$crea_map_showcase_listing_hover_color,
"mapShowcaseTopPictureColor"=>$crea_map_showcase_top_picture_color,
"mapShowcaseTopPictureTextColor"=>$crea_map_showcase_top_picture_text_color,
"mapShowcasePriceColor"=>$crea_map_showcase_price_color,
"mapShowcasePriceTextColor"=>$crea_map_showcase_price_text_color
);
}
// crea showcase slider view color
$crea_slider_showcase_text_color ='';
$crea_slider_showcase_tab_button_color ='';
$crea_slider_showcase_more_info_button_color ='';
$crea_slider_view_color_array = array();
if( $crea_showcase_display_theams_option == "Slider" )
{
$crea_slider_showcase_text_color = isset($_POST['crea_slider_showcase_text_color']) ? sanitize_hex_color_no_hash($_POST['crea_slider_showcase_text_color']) : '';
$crea_slider_showcase_tab_button_color = isset($_POST['crea_slider_showcase_tab_button_color']) ? sanitize_hex_color_no_hash($_POST['crea_slider_showcase_tab_button_color']) : '';
$crea_slider_showcase_more_info_button_color = isset($_POST['crea_slider_showcase_more_info_button_color']) ? sanitize_hex_color_no_hash($_POST['crea_slider_showcase_more_info_button_color']) : '';
$crea_slider_showcase_oh_color_txt = isset($_POST['crea_slider_showcase_oh_color_txt']) ? sanitize_hex_color_no_hash($_POST['crea_slider_showcase_oh_color_txt']) : '';
$crea_slider_showcase_oh_color_bg = isset($_POST['crea_slider_showcase_oh_color_bg']) ? sanitize_hex_color_no_hash($_POST['crea_slider_showcase_oh_color_bg']) : '';
$crea_slider_view_color_array = array(
"sliderShowcaseTextColor"=>$crea_slider_showcase_text_color,
"sliderShowcaseTabBtnColor"=>$crea_slider_showcase_tab_button_color,
"sliderShowcaseMoreInfoBtnColor"=>$crea_slider_showcase_more_info_button_color,
"crea_slider_showcase_oh_color_txt"=>$crea_slider_showcase_oh_color_txt,
"crea_slider_showcase_oh_color_bg"=>$crea_slider_showcase_oh_color_bg
);
}
// END Showcase color settings
//========================================
//========================================
// save new showcase settings
if( $_POST['action-which'] == "add" && $_POST['posttype'] == "showcase" )
{
if( empty($crea_showcase_title) || $crea_showcase_title == '' ) {
$crea_showcase_title = 'No title ['. sprintf('%04d', rand(0, 99999)) .']';
}
$new_showcase_args = array(
'post_title' => $crea_showcase_title,
'post_content' => '',
'category_name' => '',
'post_status' => 'publish',
'post_type' => 'aretk_showcase'
);
$import_showcase_post_id = wp_insert_post($new_showcase_args);
update_post_meta($import_showcase_post_id,'showcse_crea_feed_ddf_type',maybe_serialize($crea_feed_ddf_type));
update_post_meta($import_showcase_post_id,'showcse_crea_feed_include_exclude',maybe_serialize($crea_feed_include_exclude));
update_post_meta($import_showcase_post_id,'showcse_crea_display_theams_option',maybe_serialize($crea_showcase_display_theams_option));
update_post_meta($import_showcase_post_id,'showcse_crea_filter_brokerage',maybe_serialize($crea_filter_brokerage_results));
update_post_meta($import_showcase_post_id,'showcse_crea_filter_office',maybe_serialize($crea_filter_office_results));
update_post_meta($import_showcase_post_id,'showcse_crea_filter_agent_name',maybe_serialize($crea_filter_agent_name_results));
update_post_meta($import_showcase_post_id,'showcase_filter_listing_agent_ids',maybe_serialize($showcase_filter_listing_agent_ids_results));
update_post_meta($import_showcase_post_id,'showcase_filter_listing_province',maybe_serialize($showcase_filter_listing_province_results));
update_post_meta($import_showcase_post_id,'showcse_crea_filter_brokerage_hidden_name',maybe_serialize($crea_filter_brokerage_hidden_name));
update_post_meta($import_showcase_post_id,'showcse_crea_filter_office_hidden_name',maybe_serialize($crea_showcse_office_filter_hidden_name));
update_post_meta($import_showcase_post_id,'showcse_crea_filter_agents_hidden_name',maybe_serialize($crea_showcse_agent_name_filter_hidden_name));
update_post_meta($import_showcase_post_id,'showcse_crea_filter_listing',maybe_serialize($crea_filter_listing));
update_post_meta($import_showcase_post_id,'showcse_crea_filter_by_map_km',maybe_serialize($crea_showcase_filter_by_map_km));
update_post_meta($import_showcase_post_id,'showcse_crea_filter_by_other_day',maybe_serialize($crea_showcase_filter_by_other_day));
update_post_meta($import_showcase_post_id,'showcse_crea_filter_inclue_open_house',maybe_serialize($crea_showcase_filter_inclue_open_house));
update_post_meta($import_showcase_post_id,'showcse_filter_price_min',maybe_serialize($showcase_filter_price_min));
update_post_meta($import_showcase_post_id,'showcse_filter_price_max',maybe_serialize($showcase_filter_price_max));
update_post_meta($import_showcase_post_id,'showcase_filter_property_types',maybe_serialize($showcase_filter_property_types_results));
update_post_meta($import_showcase_post_id,'showcase_filter_property_status',maybe_serialize($showcase_filter_property_status_results));
update_post_meta($import_showcase_post_id,'showcse_crea_filter_google_map_latitude',maybe_serialize($crea_filter_google_map_latitude));
update_post_meta($import_showcase_post_id,'showcse_crea_filter_google_map_longitude',maybe_serialize($crea_filter_google_map_longitude));
update_post_meta($import_showcase_post_id,'showcse_crea_filter_google_map_zoom',maybe_serialize($showcse_crea_filter_google_map_zoom));
update_post_meta($import_showcase_post_id,'showcse_crea_serializable_listing_array',maybe_serialize($Serializable_listing_array));
update_post_meta($import_showcase_post_id,'showcse_crea_serializable_grid_array',maybe_serialize($Serializable_grid_array));
update_post_meta($import_showcase_post_id,'showcse_crea_serializable_carousel_array',maybe_serialize($Serializable_carousel_array));
update_post_meta($import_showcase_post_id,'showcse_crea_serializable_map_array',maybe_serialize($Serializable_map_array));
update_post_meta($import_showcase_post_id,'showcse_crea_serializable_slider_array',maybe_serialize($Serializable_slider_array));
update_post_meta($import_showcase_post_id,'Showcase_crea_listing_view_color_array',maybe_serialize($crea_listing_view_color_array));
update_post_meta($import_showcase_post_id,'Showcase_crea_grid_view_color_array',maybe_serialize($crea_grid_view_color_array));
update_post_meta($import_showcase_post_id,'Showcase_crea_carousel_view_color_array',maybe_serialize($crea_carousel_view_color_array));
update_post_meta($import_showcase_post_id,'Showcase_crea_map_view_color_array',maybe_serialize($crea_map_view_color_array));
update_post_meta($import_showcase_post_id,'Showcase_crea_slider_view_color_array',maybe_serialize($crea_slider_view_color_array));
update_post_meta($import_showcase_post_id,'showcse_crea_save_short_code',maybe_serialize("[ARETK-LS-$import_showcase_post_id ls_id=$import_showcase_post_id]"));
wp_set_object_terms($import_showcase_post_id, 'listing-details-showcase', 'listing-showcase', true);
$link_url = admin_url('admin.php?page=create_new_showcase&showcase_id='.$import_showcase_post_id.'#crea_showcase_save_tab');
wp_safe_redirect($link_url);
}
elseif ( $_POST['action-which'] == "edit" && $_POST['posttype'] == "showcase" )
{
$showcase_ids = isset($_POST['showcase_ids']) ? (INT) $_POST['showcase_ids'] : '';
$update_showcase_post = array('ID' => $showcase_ids,'post_title'=> $crea_showcase_title);
wp_update_post( $update_showcase_post );
update_post_meta($showcase_ids,'showcse_crea_feed_ddf_type',maybe_serialize($crea_feed_ddf_type));
update_post_meta($showcase_ids,'showcse_crea_feed_include_exclude',maybe_serialize($crea_feed_include_exclude));
update_post_meta($showcase_ids,'showcse_crea_display_theams_option',maybe_serialize($crea_showcase_display_theams_option));
update_post_meta($showcase_ids,'showcse_crea_filter_brokerage',maybe_serialize($crea_filter_brokerage_results));
update_post_meta($showcase_ids,'showcse_crea_filter_office',maybe_serialize($crea_filter_office_results));
update_post_meta($showcase_ids,'showcse_crea_filter_agent_name',maybe_serialize($crea_filter_agent_name_results));
update_post_meta($showcase_ids,'showcase_filter_listing_agent_ids',maybe_serialize($showcase_filter_listing_agent_ids_results));
update_post_meta($showcase_ids,'showcase_filter_listing_province',maybe_serialize($showcase_filter_listing_province_results));
update_post_meta($showcase_ids,'showcse_crea_filter_brokerage_hidden_name',maybe_serialize($crea_filter_brokerage_hidden_name));
update_post_meta($showcase_ids,'showcse_crea_filter_office_hidden_name',maybe_serialize($crea_showcse_office_filter_hidden_name));
update_post_meta($showcase_ids,'showcse_crea_filter_agents_hidden_name',maybe_serialize($crea_showcse_agent_name_filter_hidden_name));
update_post_meta($showcase_ids,'showcse_crea_filter_listing',maybe_serialize($crea_filter_listing));
update_post_meta($showcase_ids,'showcse_crea_filter_by_map_km',maybe_serialize($crea_showcase_filter_by_map_km));
update_post_meta($showcase_ids,'showcse_crea_filter_by_other_day',maybe_serialize($crea_showcase_filter_by_other_day));
update_post_meta($showcase_ids,'showcse_crea_filter_inclue_open_house',maybe_serialize($crea_showcase_filter_inclue_open_house));
update_post_meta($showcase_ids,'showcse_filter_price_min',maybe_serialize($showcase_filter_price_min));
update_post_meta($showcase_ids,'showcse_filter_price_max',maybe_serialize($showcase_filter_price_max));
update_post_meta($showcase_ids,'showcase_filter_property_types',maybe_serialize($showcase_filter_property_types_results));
update_post_meta($showcase_ids,'showcase_filter_property_status',maybe_serialize($showcase_filter_property_status_results));
update_post_meta($showcase_ids,'showcse_crea_filter_google_map_latitude',maybe_serialize($crea_filter_google_map_latitude));
update_post_meta($showcase_ids,'showcse_crea_filter_google_map_longitude',maybe_serialize($crea_filter_google_map_longitude));
update_post_meta($showcase_ids,'showcse_crea_filter_google_map_zoom',maybe_serialize($showcse_crea_filter_google_map_zoom));
update_post_meta($showcase_ids,'mapfilterlat_sw',maybe_serialize($crea_showcase_google_mapbound_lat_sw));
update_post_meta($showcase_ids,'mapfilterlong_sw',maybe_serialize($crea_showcase_google_mapbound_lng_sw));
update_post_meta($showcase_ids,'mapfilterlat_ne',maybe_serialize($crea_showcase_google_mapbound_lat_ne));
update_post_meta($showcase_ids,'mapfilterlong_ne',maybe_serialize($crea_showcase_google_mapbound_lng_ne));
update_post_meta($showcase_ids,'showcse_crea_serializable_listing_array',maybe_serialize($Serializable_listing_array));
update_post_meta($showcase_ids,'showcse_crea_serializable_grid_array',maybe_serialize($Serializable_grid_array));
update_post_meta($showcase_ids,'showcse_crea_serializable_carousel_array',maybe_serialize($Serializable_carousel_array));
update_post_meta($showcase_ids,'showcse_crea_serializable_map_array',maybe_serialize($Serializable_map_array));
update_post_meta($showcase_ids,'showcse_crea_serializable_slider_array',maybe_serialize($Serializable_slider_array));
update_post_meta($showcase_ids,'Showcase_crea_listing_view_color_array',maybe_serialize($crea_listing_view_color_array));
update_post_meta($showcase_ids,'Showcase_crea_grid_view_color_array',maybe_serialize($crea_grid_view_color_array));
update_post_meta($showcase_ids,'Showcase_crea_carousel_view_color_array',maybe_serialize($crea_carousel_view_color_array));
update_post_meta($showcase_ids,'Showcase_crea_map_view_color_array',maybe_serialize($crea_map_view_color_array));
update_post_meta($showcase_ids,'Showcase_crea_slider_view_color_array',maybe_serialize($crea_slider_view_color_array));
wp_set_object_terms($showcase_ids, 'listing-details-showcase', 'listing-showcase', true);
$link_url = admin_url('admin.php?page=create_new_showcase&showcase_id='.$showcase_ids.'#crea_showcase_save_tab');
wp_safe_redirect($link_url);
}
}
}
// END Function aretkcrea_handle_create_new_showcase_form_action
//********************************************************
/**
* Function for aretkcrea_delete_showcase_custom_post_records
*
* @return return showcase post records
*
*/
function aretkcrea_delete_showcase_custom_post_records()
{
global $wpdb;
$showcase_id = isset($_POST['showcase_id']) ? (int) $_POST['showcase_id'] : '';
if ( $showcase_id != '' && !empty($showcase_id) || $showcase_id != 0 )
{
$post_table = $wpdb->prefix.'posts';
$post_meta_table = $wpdb->prefix.'postmeta';
$sql_select = "DELETE FROM `$post_table` WHERE `ID`= %d";
$sql_prep = $wpdb->prepare( $sql_select, $showcase_id );
$delete_recod = $wpdb->query($sql_prep);
$sql_select = "DELETE FROM `$post_meta_table` WHERE `post_id`= %d";
$sql_prep = $wpdb->prepare( $sql_select, $showcase_id );
$delete_recod = $wpdb->query($sql_prep);
echo"sucessfullydelete";
}
die();
}
/**
* Function for create custom post type lead column name
*
* @param unknown_type $columns
* @param unknown_type $defaults
* @return return column name of lead post type
*
*/
function aretkcrea_set_custom_edit_aretk_lead_columns($columns)
{
$getSubscriptionLeadcolumn = get_option('crea_subscription_status', true);
if( $getSubscriptionLeadcolumn === 'valid' )
{
$columns = array(
'cb' => '".get_the_modified_date('Y/m/d ')."
";
}
}
/**
* Function for create import functionality
*
* @return return download link message.
*
*/
function aretkcrea_emport_lead_download ()
{
global $wpdb;
$upload_dir = wp_upload_dir();
if ( !empty($upload_dir['basedir']) && current_user_can('upload_files') && is_user_logged_in() )
{
$leads_out = $headers = array();
$post_table = $wpdb->prefix.'posts';
$sql_select = "SELECT * FROM `$post_table` WHERE `post_type`= 'aretk_lead'";
$sql_prep = $wpdb->prepare( $sql_select, NULL );
$leads_db = $wpdb->get_results($sql_prep);
foreach ($leads_db as $lead)
{
$id = $lead->ID;
$headers['name'] = __( 'Name', 'aretkcrea' );
$lead_name = $lead->post_title;
$headers['email'] = __( 'Email', 'aretkcrea' );
$Lead_email_primary = get_post_meta($id,'lead_primary_email',$single = false);
if ( !empty($Lead_email_primary) )
{
$Email_name = implode(" ", $Lead_email_primary);
$lead_eamil_results = $Email_name;
}
else
{
$Lead_email = get_post_meta($id,'lead_phone_email',$single = false);
if( isset($Lead_email) && !empty($Lead_email ) )
{
$email_not_primary = implode(" ",$Lead_email);
$lead_email_title = maybe_unserialize($email_not_primary);
if ( is_array( $lead_email_title ) )
{
$lead_eamil_results = $lead_email_title[0];
}
else
{
$lead_eamil_results = $lead_email_title;
}
} else {
$lead_eamil_results = '';
}
}
$headers['phone'] = __( 'Phone', 'aretkcrea' );
$phone_no = get_post_meta($id,'lead_phone_no',$single = false);
if(isset( $phone_no ) && !empty( $phone_no ))
{
if( is_array( $phone_no ))
{
$Lead_phone = implode(" ",$phone_no);
$var1 = maybe_unserialize($Lead_phone);
if( is_array($var1)) {
$lead_phone_result = $var1[0]['PhoneNo'];
} else{
$lead_phone_result = $var1;
}
}
} else {
$lead_phone_result = " - ";
}
$headers['comments'] = __( 'Comments', 'aretkcrea' );
$lead_comments = $customer_order->post_content;
if (!empty($lead_name) && !empty($lead_eamil_results))
{
$leads_out[] = array($lead_name, $lead_eamil_results, $lead_phone_result, $lead_comments);
}
}
if (!empty($leads_out))
{
$sitename = sanitize_key( get_bloginfo( 'name' ) );
if ( ! empty($sitename) ) $sitename .= '.';
$filename = "{$sitename}aretk-leads-export." . date( 'Y-m-d-Hi' ) . ".csv";
$file_path = trailingslashit( $upload_dir['path'] ) . $filename;
$file_url = trailingslashit( $upload_dir['url'] ) . $filename;
$file = fopen( $file_path, 'w' );
$delimiter = ',';
$headers['name'] = __( 'Name', 'aretkcrea' );
fputcsv($file, $headers, $delimiter);
foreach ($leads_out as $row)
{
fputcsv($file, $row, $delimiter);
}
fclose( $file );
echo "
";
} else {
echo "
". __( 'No leads found to export', 'aretkcrea' ) ."
";
}
} else {
echo "
". __( 'Unable to create csv file', 'aretkcrea' ) ."
";
}
die();
}
/**
* Unlink Document
*
*/
/* Phasing out, but keeping for now in case needed.
function aretkcrea_unlink_listing_document_edit_page_from_listing_ajax()
{
$parent_document = isset( $_POST['inputfilename'] ) ? $_POST['inputfilename'] : '';
$documentfile = $_FILES;
$tempLocPath = '';
foreach ( $documentfile as $documentfileKey=>$documentfileValue ) {
if( $documentfileValue['name'] == $parent_document ) {
$tempLocPath = $documentfileValue['tmp_name'];
}
}
#$imagefile = isset( $_POST['inputfilename'] ) ? $_POST['inputfilename'] : '';
#$imagepath = "Users/mp4_thumbnails-".$imagefile;
#unlink($imagepath);
if( unlink($tempLocPath) ) {
echo 'Success';
$fileArr = array();
$counter = 0;
foreach ($documentfile as $documentfileKey=>$documentfileValue ){
if( $documentfileValue['tmp_name'] != $tempLocPath ) {
$fileArr[$doc_counter] = array(
'error'=>$documentfileValue['error'],
'name'=>$documentfileValue['name'],
'size'=>$documentfileValue['size'],
'tmp_name'=>$documentfileValue['tmp_name'],
'type'=>$documentfileValue['type'],
);
$doc_counter = $doc_counter + 1;
}
}
} else {
echo 'Fail';
}
die();
}
*/
/**
* Function for add new lead reminder
* @package Aretk
* @subpackage Phase 1
* @return add lead reminder record
*/
function aretkcrea_add_new_lead_reminder()
{
global $wpdb;
$get_lead_id = isset($_POST['get_lead_id']) ? (INT) $_POST['get_lead_id'] : '';
$reminderName = isset($_POST['reminderName']) ? sanitize_text_field( $_POST['reminderName'] ) : '';
$reminderSubject = isset($_POST['reminderSubject']) ? sanitize_text_field( $_POST['reminderSubject'] ) :'';
$reminderEmail = isset($_POST['reminderEmail']) ? sanitize_email( $_POST['reminderEmail'] ) :'';
$reminderComment = isset($_POST['reminderComment']) ? sanitize_text_field( $_POST['reminderComment'] ) :'';
// validate reminderDateTime -> must match: yyyy-mm-dd hh:mm
$valid_date = false;
$reminderDateTime = isset($_POST['reminderDateTime']) ? sanitize_text_field($_POST['reminderDateTime']) :'';
if (preg_match("/(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2})/", $reminderDateTime))
{
$valid_date = true;
}
// validate reminderRepeat
$valid_repeat_option = false;
$reminderRepeat = isset($_POST['reminderRepeat'])? sanitize_text_field($_POST['reminderRepeat']) : '';
$acceptable_reminerRepeat_options = array('no-repeat', 'daily', 'Weekly', 'Monthly', 'Yearly');
if (in_array($reminderRepeat, $acceptable_reminerRepeat_options))
{
$valid_repeat_option = true;
}
if ( true === $valid_date && true === $valid_repeat_option && !empty($get_lead_id) )
{
$reminderTableName = $wpdb->prefix.ARETKCREA_LEAD_REMINDER_HISTORY;
$wpdb->insert( "$reminderTableName",
array(
'reminder_lead_id' => $get_lead_id,
'reminder_name' => $reminderName,
'reminder_subject' => $reminderSubject,
'reminder_email' => $reminderEmail,
'reminder_comment' => $reminderComment,
'reminder_time' => $reminderDateTime,
'reminder_repeat' => $reminderRepeat,
'created_time' => current_time('mysql', 1),
'updated_time' => current_time('mysql', 1)
),
array('%d','%s','%s','%s','%s','%s','%s','%s','%s',)
);
}
$sql_select = "SELECT * FROM `$reminderTableName` WHERE `reminder_lead_id`= %d ORDER BY `id` ASC";
$sql_prep = $wpdb->prepare( $sql_select, $get_lead_id );
$getReminderResults = $wpdb->get_results($sql_prep);
$html ='';
if( !empty( $getReminderResults ) && $getReminderResults != '' )
{
$reminderCounter = 1;
foreach ( $getReminderResults as $getReminderResultsValues)
{
$html .='';
$html .='
';
$html .='
';
$html .='
';
$html .='
';
$html .='
';
$html .='
'. sanitize_text_field($resultSetValues->BoardName).' ';
}
}
}
}
echo $html;
die();
}
/**
* Ajax call for get the office name in feed
*
*
*/
function aretkcrea_get_the_select_board_office()
{
$getFeed = sanitize_text_field($_POST['getFeed']);
$board_ids = $_POST['board_id'];
$board_id = array();
$html = '';
if ( !empty($board_ids) && !empty($getFeed) )
{
foreach ($board_ids as $b_id)
{
$board_id[] = (INT) $b_id;
}
$board_id_results = implode(",", $board_id);
$domainName = isset($_SERVER['SERVER_NAME']) ? $_SERVER['SERVER_NAME'] : '';
if (!empty($domainName)){
$domainName = filter_var($domainName, FILTER_SANITIZE_URL);
} else {
$domainName = get_site_url();
$domainName = esc_url(parse_url($domainName, PHP_URL_HOST));
}
$getSubscriptionKey = get_option('crea_subscription_key', '');
$subscriptionKey = preg_replace("/[^a-z0-9-]+/i", "", $getSubscriptionKey);
$subscriptionKey = !empty($subscriptionKey) ? $subscriptionKey : '';
if( isset( $subscriptionKey ) && !empty( $subscriptionKey ) && isset( $getFeed ) && !empty( $getFeed ) && !empty( $board_id ) )
{
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, ARETKCREA_LISTING_BASEDONSERVER_API."/?key=$subscriptionKey&request=offices&feed=$getFeed&board_id=$board_id_results");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER,true);
curl_setopt($ch, CURLOPT_REFERER,$domainName);
$data = curl_exec($ch);
curl_close($ch);
$resultSet = json_decode($data);
if ( $resultSet !='' && !empty( $resultSet ) )
{
foreach ( $resultSet as $resultSetKey => $resultSetValues )
{
if ( !isset( $resultSetValues->TotalRecords ) && empty( $resultSetValues->TotalRecords ) )
{
$html .= ''. sanitize_text_field($resultSetValues->Name).' ';
}
}
}
}
}
echo $html;
die();
}
/**
* Ajax call for get the agents name in feed
*
*
*/
function aretkcrea_get_the_select_board_agent_name()
{
$getFeed = sanitize_text_field($_POST['getFeed']);
$board_ids = $_POST['board_id'];
$board_id = array();
foreach ($board_ids as $b_id)
{
$board_id[] = (INT) $b_id;
}
$board_id_results = implode(",", $board_id);
$office_ids = $_POST['office_id'];
$office_id = array();
foreach ($office_ids as $o_id)
{
$office_id[] = (INT) $o_id;
}
$office_id_results = implode(",", $office_id);
$html = '';
if ( !empty($board_id_results) && !empty($office_id_results) && !empty($getFeed) )
{
$domainName = isset($_SERVER['SERVER_NAME']) ? $_SERVER['SERVER_NAME'] : '';
if (!empty($domainName)){
$domainName = filter_var($domainName, FILTER_SANITIZE_URL);
} else {
$domainName = get_site_url();
$domainName = esc_url(parse_url($domainName, PHP_URL_HOST));
}
$getSubscriptionKey = get_option('crea_subscription_key', '');
$subscriptionKey = preg_replace("/[^a-z0-9-]+/i", "", $getSubscriptionKey);
$subscriptionKey = !empty($subscriptionKey) ? $subscriptionKey : '';
if( isset( $subscriptionKey ) && !empty( $subscriptionKey ) )
{
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, ARETKCREA_LISTING_BASEDONSERVER_API."/?key=$subscriptionKey&request=agents&feed=$getFeed&office_id=$office_id_results");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER,true);
curl_setopt($ch, CURLOPT_REFERER,$domainName);
$data = curl_exec($ch);
curl_close($ch);
$resultSet = json_decode($data);
if ( $resultSet != '' && !empty($resultSet) )
{
foreach ( $resultSet as $resultSetKey => $resultSetValues )
{
if ( !isset( $resultSetValues->TotalRecords ) && empty( $resultSetValues->TotalRecords ) )
{
$html .= ''. sanitize_text_field($resultSetValues->Name) .' ';
}
}
}
}
}
echo $html;
die();
}
// Return CREA agent IDs
function aretkcrea_crea_agent_ids($result_type)
{
global $wpdb;
$crea_agent_table_name = $wpdb->prefix . ARETKCREA_AGENT_TABLE;
$sql_select = "SELECT `crea_agent_id` FROM `$crea_agent_table_name`";
$sql_prep = $wpdb->prepare( $sql_select, NULL );
$getAllAgentIds = $wpdb->get_results($sql_prep, ARRAY_A);
$crea_agent_ids = array();
if ( isset($getAllAgentIds) && !empty($getAllAgentIds))
{
foreach ( $getAllAgentIds as $getAllAgentId )
{
$crea_agent_ids[] = (int) $getAllAgentId['crea_agent_id'];
}
}
switch($result_type){
case 'list':
$crea_agent_ids = implode(',', $crea_agent_ids);
break;
}
return $crea_agent_ids;
}
function aretkcrea_feed_usernames( $result_type )
{
global $wpdb;
$crea_user_name_table_name = $wpdb->prefix.ARETKCREA_USER_LISTING_DETAILS;
$sql_select = "SELECT `username` FROM `$crea_user_name_table_name`";
$sql_prep = $wpdb->prepare( $sql_select, NULL );
$getAllUsername = $wpdb->get_results($sql_prep);
$crea_usernames = array();
if (isset($getAllUsername) && !empty($getAllUsername))
{
foreach ($getAllUsername as $singleUsername)
{
$crea_usernames[] = trim($singleUsername->username);
}
}
switch($result_type){
case 'list':
$crea_usernames = implode(',', $crea_usernames);
break;
}
return $crea_usernames;
}
public function aretkcrea_allowed_html()
{
$allowed_tags = array(
'a' => array(
'class' => array(),
'href' => array(),
'rel' => array(),
'title' => array(),
),
'abbr' => array(
'title' => array(),
),
'b' => array(),
'blockquote' => array(
'cite' => array(),
),
'cite' => array(
'title' => array(),
),
'code' => array(),
'del' => array(
'datetime' => array(),
'title' => array(),
),
'dd' => array(),
'div' => array(
'class' => array(),
'title' => array(),
'style' => array(),
),
'dl' => array(),
'dt' => array(),
'em' => array(),
'h1' => array(),
'h2' => array(),
'h3' => array(),
'h4' => array(),
'h5' => array(),
'h6' => array(),
'i' => array(),
'img' => array(
'alt' => array(),
'class' => array(),
'height' => array(),
'src' => array(),
'width' => array(),
),
'li' => array(
'class' => array(),
),
'ol' => array(
'class' => array(),
),
'p' => array(
'class' => array(),
),
'q' => array(
'cite' => array(),
'title' => array(),
),
'span' => array(
'class' => array(),
'title' => array(),
'style' => array(),
),
'strike' => array(),
'strong' => array(),
'ul' => array(
'class' => array(),
),
);
return $allowed_tags;
}
} 
';
$html .='