prefix."realty_tech_links" . " (
`id` int(11) NOT NULL AUTO_INCREMENT,
`post_id` int(11) NULL,
`url` varchar(500) NOT NULL,
`link_id` varchar(255) NOT NULL,
`link_name` varchar(250) NOT NULL,
`page_type` varchar(50) NOT NULL,
`use_widget` varchar(50) NOT NULL default '0',
PRIMARY KEY (`id`)
)";
dbDelta($sql);
$sql = "CREATE TABLE IF NOT EXISTS " . $wpdb->prefix."realty_tech_api" . " (
`id` int(11) NOT NULL AUTO_INCREMENT,
`api` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
)";
dbDelta($sql);
}
public static function RTapexRemove()
{
global $wpdb;
update_option( 'apexAgentApiKey', '' );
update_option( 'ApexIdxDomainUrl', '' );
update_option( 'ApexIdxBrokerGalUname', '' );
update_option( 'ApexIdxIsBroker', '' );
$deletePages = $wpdb->get_col("SELECT post_id from ".$wpdb->prefix."realty_tech_links");
$wpdb->query("DROP TABLE IF EXISTS ".$wpdb->prefix."realty_tech_links");
$wpdb->query("DROP TABLE IF EXISTS ".$wpdb->prefix."realty_tech_api");
if($deletePages)
{
foreach($deletePages as $pageId)
{
wp_delete_post($pageId,true);
$wpdb->query("DELETE from ".$wpdb->prefix."postmeta where post_id = $pageId");
}
}
}
public static function RTapexInitHooks()
{
add_action('admin_enqueue_scripts', array( 'RTapexIdxBase', 'RTapexAddScript' ) );
add_action('admin_enqueue_scripts', array( 'RTapexIdxBase', 'RTapexAddStyle' ));
add_action('admin_menu', array( 'RTapexIdxBase', 'RTapexAddMenu' ));
add_action('admin_menu', array('RTapexIdxBase','RTapexValidateApi'));
add_action('before_delete_post', array('RTapexIdxBase','RTapexUpdateLinksOnDeletePage'));
add_action('save_post', array('RTapexIdxBase','RTapexUpdateWrapperPage'));
}
public static function RTapexInitFilters()
{
add_filter("plugin_action_links_" . RTAI_PLUGIN_FILE_LOC, array( 'RTapexIdxBase', 'RTapexActLinks'));
add_filter('page_link', array( 'RTapexIdxBase', 'RTapexSetNewPageLink'), 25, 2);
add_filter('get_pages', array( 'RTapexIdxBase', 'RTapexFilterWrapperPage'));
add_filter('the_content', array( 'RTapexIdxBase', 'RTapexFilterAgentPage'));
add_filter('query_vars', array( 'RTapexIdxBase', 'RTapexQueryvars'));
add_filter('widget_text','do_shortcode');
}
public static function RTapexInitShortCode()
{
add_shortcode('realtyTech-search-form', array( 'RTapexIdxBase','RTapexSearchForm'));
add_shortcode('realtyTech-slider', array( 'RTapexIdxBase','RTapexSlider'));
add_shortcode('realtyTech-grid', array( 'RTapexIdxBase','RTapexGrid'));
add_shortcode('realtyTech-featured-market', array( 'RTapexIdxBase','RTapexFeaturedMarket'));
}
public static function RTapexInitRegister()
{
/*css for search box widget*/
wp_register_style('apexIdxSearchBoxStyle', plugins_url('css/apexIdxSearchBoxWidget.css', __FILE__));
/*end css for search box widget*/
/*js for search box widget*/
wp_register_script('apexIdxsearchBoxWidget', plugins_url('js/apexIdxsearchBoxWidget.js', __FILE__));
/*end js for search box widget*/
/*js for search box widget*/
wp_register_script('apexIdxClipboard', plugins_url('js/clipboard.min.js', __FILE__));
/*end js for search box widget*/
/*css for featured market*/
wp_register_style('apexIdxFeaturedMarket', plugins_url('css/apexIdxFeaturedMarket.css', __FILE__));
/*end css for featured market*/
/*js for featured market*/
wp_register_script('apexIdxFeaturedMarket', plugins_url('js/apexIdxFeaturedMarket.js', __FILE__));
/*end js for featured market*/
/*css for property slider*/
wp_register_style('apexIdxFPSlider', plugins_url('css/apexIdxFPSlider.css', __FILE__));
wp_register_style('apexIdxFPSliderGrid', plugins_url('css/apexIdxFPGridSlider.css', __FILE__));
/*end css for property slider*/
/*js for property grid view*/
wp_register_script('apexIdxInitializeSlider', plugins_url('js/apexIdxInitializeSlider.js', __FILE__));
wp_register_script('apexIdxInitializeSliderGrid', plugins_url('js/apexIdxInitializeGrid.js', __FILE__));
/*end js for property slider*/
}
public static function RTapexInitRewriteAgentsUrl()
{
global $wpdb;
$offices = $wpdb->get_results("SELECT post_id FROM ".$wpdb->prefix."realty_tech_links WHERE page_type='office'", ARRAY_A);
if(count($offices) > 0)
{
foreach($offices as $office)
{
if($office['post_id'])
{
$apOslug = basename(get_permalink($office['post_id']));
add_rewrite_rule('^'.$apOslug.'/([^/]*)/([^/]*)/?', 'index.php?page_id='.$office['post_id'].'&agentId=$matches[2]', 'top');
}
}
flush_rewrite_rules();
}
}
public static function RTapexActLinks( $exsitingsLinksArray )
{
// Add a link to this plugin's settings page
$apexPageLink = 'Settings';
array_unshift( $exsitingsLinksArray, $apexPageLink );
return $exsitingsLinksArray;
}
public static function RTapexAddScript($page)
{
// Add css files to this page in backend
if( 'toplevel_page_apexApiVerification' === $page || 'apex-idx_page_RTapexAgentWidgets' === $page || 'apex-idx_page_RTapexAgentDefaultPages' === $page):
wp_enqueue_script('apexIdxbackend', plugins_url('js/apexIdxbackend.js', __FILE__));
endif;
if( 'apex-idx_page_RTapexAgentWidgets' === $page ):
wp_enqueue_script('apexIdxClipboard');
endif;
}
public static function RTapexAddStyle($page)
{
// Add js files to this page in backend
if( 'toplevel_page_apexApiVerification' === $page || 'apex-idx_page_RTapexAgentWidgets' === $page || 'apex-idx_page_RTapexAgentDefaultPages' === $page):
wp_enqueue_style('apexIdxbackend', plugins_url('css/apexIdxBackend.css', __FILE__));
wp_enqueue_style('apexBootstrapMin', plugins_url('css/bootstrap.min.css', __FILE__));
endif;
}
public static function RTapexAddMenu()
{
// Add menu and submenu page for wordpress admin user access
add_menu_page('REALTYTECH MLS Plugin Options', 'Apex IDX', 'administrator', 'apexApiVerification', array( 'RTapexIdxBase', 'RTapexApiVerification' ) );
add_submenu_page('apexApiVerification', 'API Console', 'i. API Console', 'administrator', 'apexApiVerification', array( 'RTapexIdxBase', 'RTapexApiVerification' ) );
add_submenu_page('apexApiVerification', 'Manage Apex Idx Widgets', 'ii. Widgets', 'administrator', 'RTapexAgentWidgets', array( 'RTapexIdxBase', 'RTapexAgentWidgets' ) );
add_submenu_page('apexApiVerification', 'Manage Apex Idx Pages', 'iii. Idx Pages', 'administrator', 'RTapexAgentDefaultPages', array( 'RTapexIdxBase', 'RTapexAgentDefaultPages' ) );
}
public static function RTapexValidateApi()
{
global $wpdb;
global $apexApiValidationError;
global $apexApiValidationSuc;
$pageName = get_admin_page_title();
register_setting('apexIdx-settings-group', "apexAgentApiKey");
if(get_option('apexAgentApiKey') != '')
{
$apikey = get_option('apexAgentApiKey');
$existApi = $wpdb->get_var("SELECT * from ".$wpdb->prefix."realty_tech_api WHERE api = '$apikey'");
if(!$existApi)
{
if(in_array($pageName ,array('Manage Apex Idx Widgets', 'Manage Apex Idx Pages')))
{
wp_redirect('admin.php?page=apexApiVerification');
}
$status = RTapexApiAuthentication('authenticate');
if(is_wp_error($status) )
{
$apexApiValidationError = $status->get_error_message();
}
else
{
$apexApiValidationSuc = 'You have been registered successfully';
$id = self::RTapexSaveApi($apikey);
if($id)
{
self::RTapexSaveLinks($status);
}
}
}
else
{
$apexApiValidationSuc = 'You are already registered';
}
}
else
{
if(in_array($pageName ,array('Manage Apex Idx Widgets', 'Manage Apex Idx Pages')))
{
wp_redirect('admin.php?page=apexApiVerification');
exit;
}
}
}
public static function RTapexApiVerification()
{
global $apexApiValidationError;
global $apexApiValidationSuc;
include RTAI_PLUGIN_DIR . '/views/apexIdxForm.php';
}
public static function RTapexAgentWidgets()
{
global $wpdb;
if(isset($_POST['getLatestSelection']) && $_POST['getLatestSelection'] == 1)
{
self::RTapexGetLatestUpdate();
}
$customLinks = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}realty_tech_links where page_type = 'custom' and use_widget= '1'");
include RTAI_PLUGIN_DIR . '/views/apexIdxWidget.php';
}
public static function RTapexAgentDefaultPages()
{
global $wpdb;
$link = array();
if(isset($_POST['getBrokerInfo']) && $_POST['getBrokerInfo'] == 1)
{
self::RTapexGetLatestUpdate('getOffices');
}
if(isset($_POST['getLatestSelection']) && $_POST['getLatestSelection'] == 1)
{
self::RTapexGetLatestUpdate('getLinks');
}
if(isset($_POST['defaultPage']) && $_POST['defaultPage'] == 1)
{
$defaultLinks = ($_POST['defaultLinks']) ? $_POST['defaultLinks'] : array();
self::RTapexManagePages($defaultLinks, 'default');
}
if(isset($_POST['customPage']) && $_POST['customPage'] == 1)
{
$customLinks = ($_POST['customLinks']) ? $_POST['customLinks'] : array();
self::RTapexManagePages($customLinks, 'custom');
}
if(isset($_POST['officePage']) && $_POST['officePage'] == 1)
{
$officeLinks = ($_POST['officeLinks']) ? $_POST['officeLinks'] : array();
self::RTapexCreateOfficePage($officeLinks, 'office');
}
if(isset($_POST['wrapperPage']) && $_POST['wrapperPage'] == 1)
{
$wrapperPageName = ($_POST['wrapperPageName']) ? $_POST['wrapperPageName'] : '';
if(!empty($wrapperPageName))
self::RTapexCreateWrapperPage($wrapperPageName);
}
$defaultLinks = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}realty_tech_links where page_type = 'default'");
$officeLinks = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}realty_tech_links where page_type = 'office'");
$customLinks = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}realty_tech_links where page_type = 'custom'");
$wrapperLinks = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}realty_tech_links where page_type = 'wrapper'");
//Check if user is broker
$isBroker = get_option('ApexIdxIsBroker');
$apBgalUname = get_option('ApexIdxBrokerGalUname');
include RTAI_PLUGIN_DIR . '/views/apexIdxPages.php';
}
public static function RTapexIsApiVerified()
{
global $wpdb;
if (get_option('apexAgentApiKey') != '')
{
$apikey = get_option('apexAgentApiKey');
$existApi = $wpdb->get_var("SELECT * from ".$wpdb->prefix."realty_tech_api WHERE api = '$apikey'");
if(!$existApi)
{
return false;
}
else
{
return true;
}
}
else
{
return false;
}
}
public static function RTapexSearchForm()
{
ob_start();
$isIsApiVerified = self::RTapexIsApiVerified();
if(!$isIsApiVerified)
{
return;
}
wp_enqueue_script('jquery');
wp_localize_script( 'apexIdxsearchBoxWidget', 'searchFormParams', array(
'ApexIdxDomainUrl' => get_option('ApexIdxDomainUrl')
) );
wp_enqueue_style('apexIdxSearchBoxStyle');
wp_enqueue_script('jquery-ui-autocomplete');
wp_enqueue_script('apexIdxsearchBoxWidget');
include RTAI_PLUGIN_DIR . 'views/apexIdxSearchFormWidget.php';
$output = ob_get_contents();
ob_end_clean();
return $output;
}
public static function RTapexSlider($atts){
global $wpdb;
$isIsApiVerified = self::RTapexIsApiVerified();
if(!$isIsApiVerified)
{
return;
}
wp_enqueue_script('jquery');
$apexIdxDomainUrl = get_option('ApexIdxDomainUrl');
$idxDomainUrlResults = $apexIdxDomainUrl.'featuredproperties/';
if($atts['type'] == 'c')
{
$url = $apexIdxDomainUrl.'webservices/getcustomLinkProperties.php';
}
else if($atts['type'] == 'sold')
{
$url = $apexIdxDomainUrl.'webservices/getSoldProperties.php';
$idxDomainUrlResults = $apexIdxDomainUrl.'soldproperties/';
}
else if($atts['type'] == 'fOffices')
{
$url = $apexIdxDomainUrl.'webservices/getFeaturedOffices.php';
$idxDomainUrlResults = $apexIdxDomainUrl.'featuredoffices/';
}
else
{
$url = $apexIdxDomainUrl.'webservices/getFeaturedProperties.php';
}
if($atts['type'] == 'c')
{
$row = $wpdb->get_row("SELECT link_name FROM ".$wpdb->prefix."realty_tech_links WHERE link_id ='{$atts['id']}'", ARRAY_A);
$idxDomainUrlResults = $apexIdxDomainUrl.'c/'.str_replace(' ', '-', $row['link_name']).'/';
}
wp_localize_script( 'apexIdxInitializeSlider', 'sliderParams', array(
'idxDomainUrl' => $url,
'idxDomainUrlResults'=>$idxDomainUrlResults,
'type'=>$atts['type'],
'id'=> ($atts['type'] == 'c') ? $atts['id'] : '',
) );
wp_enqueue_style('apexIdxFPSlider');
wp_enqueue_script('apexIdxInitializeSlider');
$output = '';
return $output;
}
public static function RTapexGrid($atts)
{
global $wpdb;
$isIsApiVerified = self::RTapexIsApiVerified();
if(!$isIsApiVerified)
{
return;
}
$apexIdxDomainUrl = get_option('ApexIdxDomainUrl');
$idxDomainUrlResults = $apexIdxDomainUrl.'featuredproperties/';
if($atts['type'] == 'c')
{
$url = $apexIdxDomainUrl.'webservices/getcustomLinkProperties.php';
}
else if($atts['type'] == 'sold')
{
$url = $apexIdxDomainUrl.'webservices/getSoldProperties.php';
$idxDomainUrlResults = $apexIdxDomainUrl.'soldproperties/';
}
else if($atts['type'] == 'fOffices')
{
$url = $apexIdxDomainUrl.'webservices/getFeaturedOffices.php';
$idxDomainUrlResults = $apexIdxDomainUrl.'featuredoffices/';
}
else
{
$url = $apexIdxDomainUrl.'webservices/getFeaturedProperties.php';
}
if($atts['type'] == 'c')
{
$row = $wpdb->get_row("SELECT link_name FROM ".$wpdb->prefix."realty_tech_links WHERE link_id = '{$atts['id']}'", ARRAY_A);
$idxDomainUrlResults = $apexIdxDomainUrl.'c/'.str_replace(' ', '-', $row['link_name']).'/';
}
wp_localize_script( 'apexIdxInitializeSliderGrid', 'GridParams', array(
'idxDomainUrl' => $url,
'idxDomainUrlResults'=>$idxDomainUrlResults,
'type'=>$atts['type'],
'id'=> ($atts['type'] == 'c') ? $atts['id'] : '',
) );
wp_enqueue_script('apexIdxInitializeSliderGrid');
wp_enqueue_style('apexIdxFPSliderGrid');
$output = '';
return $output;
}
public static function RTapexFeaturedMarket()
{
$isIsApiVerified = self::RTapexIsApiVerified();
if(!$isIsApiVerified)
{
return;
}
wp_enqueue_script('jquery');
wp_localize_script( 'apexIdxFeaturedMarket', 'fMarketParams', array(
'ApexIdxDomainUrl' => get_option('ApexIdxDomainUrl')
) );
wp_enqueue_style('apexIdxFeaturedMarket');
wp_enqueue_script('apexIdxFeaturedMarket');
include RTAI_PLUGIN_DIR . 'views/apexIdxFeaturedMarket.php';
}
public static function RTapexUpdateLinksOnDeletePage($postID)
{
global $wpdb;
$row = $wpdb->get_row("SELECT page_type FROM ".$wpdb->prefix."realty_tech_links WHERE post_id = '{$postID}' ", ARRAY_A);
if($row['page_type'] == 'wrapper')
{
$wpdb->query("DELETE FROM ".$wpdb->prefix."realty_tech_links where post_id = '{$postID}' AND page_type = 'wrapper'");
}
else
{
$wpdb->update(
$wpdb->prefix."realty_tech_links",
array(
'post_id' => NULL
),
array(
'post_id' => $postID
),
array(
'%d'
),
array(
'%d'
)
);
}
}
public static function RTapexUpdateWrapperPage($postId)
{
global $wpdb;
if (wp_is_post_revision($postId))
return;
$row = $wpdb->get_row("SELECT page_type FROM ".$wpdb->prefix."realty_tech_links WHERE post_id = '{$postId}' ", ARRAY_A);
if($row['page_type'] == 'wrapper')
{
$postTitle = get_the_title($postId);
$postUrl = get_permalink($postId);
//Update links table add genrated post id
$wpdb->update(
$wpdb->prefix."realty_tech_links",
array(
'url' => $postUrl,
'link_name' => $postTitle,
'link_id' => $postTitle
),
array(
'post_id' => $postId
),
array(
'%s',
'%s',
'%s'
),
array(
'%d'
)
);
}
}
public static function RTapexSetNewPageLink($newlink, $pid)
{
global $wpdb;
$row = $wpdb->get_row("SELECT url FROM ".$wpdb->prefix."realty_tech_links WHERE post_id = '{$pid}' and page_type != 'office' ", ARRAY_A);
if($row['url'] && !empty($row['url']))
{
$newlink = $row['url'];
}
return $newlink;
}
public static function RTapexFilterWrapperPage($pages)
{
global $wpdb;
$row = $wpdb->get_row("SELECT post_id FROM ".$wpdb->prefix."realty_tech_links WHERE page_type='wrapper'", ARRAY_A);
if($row)
{
$pagesArray = $pages;
for($i=0; $i< count($pages); $i++)
{
if($pages[$i]->ID == $row['post_id'])
{
unset($pagesArray[$i]);
}
}
return $pagesArray;
}
else
{
return $pages;
}
}
public static function RTapexQueryvars( $qvars ) {
$qvars[] = 'agentId';
return $qvars;
}
public static function RTapexFilterAgentPage($content)
{
global $wpdb, $wp_query;
$post = get_post();
$apOfficeInfo = $wpdb->get_results("SELECT link_id,post_id,url FROM ".$wpdb->prefix."realty_tech_links WHERE page_type='office' and post_id is not null", ARRAY_A);
//Check if current page is added as a office page in database
$apIsPageOffice = array_search($post->ID, array_map(function ($v){ return $v['post_id']; }, $apOfficeInfo));
if($apIsPageOffice !== false)
{
//Get the broker gallery user name
$apBrokerGalUname = trim(get_option('ApexIdxBrokerGalUname'));
//Get Active Offices List
$apActiveOffices = implode(",",array_map(function ($v){ return $v['link_id']; }, $apOfficeInfo));
//Get Active Offices URL
$apActiveOfficesURL = implode(",",array_map(function ($v){ return $v['url']; }, $apOfficeInfo));
//Get agent page URL
$apAgentPageUrl = esc_url(get_permalink($post->ID));
//Check current domain scheme i.e. http|https
$apCurDomScheme = (is_ssl() == true) ? 'https:' : 'http:' ;
//Check if it is a gallery or single agent detail page
if($wp_query->query_vars['agentId'])
{
$apUrlForGallery = $apCurDomScheme."//gallery.realtytech.com/$apBrokerGalUname/iframe/?v=agent&galleryFor=apexIDX&id=".$wp_query->query_vars['agentId'];
}
else
{
$apUrlForGallery = $apCurDomScheme."//gallery.realtytech.com/$apBrokerGalUname/iframe/?v=gallery&galleryFor=apexIDX&oid=".$apOfficeInfo[$apIsPageOffice]['link_id'];
}
//Set header for api response
$headers = array(
'Content-Type' => 'application/x-www-form-urlencoded;charset=UTF-8',
'outputtype' => 'text/html'
);
// Send api request to get gallery information
$apGalleryApiResponse = wp_remote_post( $apUrlForGallery, array(
'method' => 'POST',
'timeout' => 120,
'sslverify' => false,
'headers' => $headers,
'body' => array( 'agentPageUrl' => $apAgentPageUrl, 'apActiveOffice' => $apActiveOffices, 'apActiveOfficesURL'=>$apActiveOfficesURL ),
'cookies' => array()
)
);
//Check if response is valid, if not then through the error
try
{
if(is_array($apGalleryApiResponse) && array_key_exists('body', $apGalleryApiResponse ))
{
$apGalleryHTML = $apGalleryApiResponse['body'];
return $apGalleryHTML;
}
else
{
return 'Agent gallery Could not be fetched';
}
}
catch (Exception $ex)
{
return 'Agent gallery Could not be fetched';
}
}
else
{
return $content;
}
}
public static function RTapexManagePages($selectedPages = array(), $pageType)
{
global $wpdb;
$links = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}realty_tech_links where page_type = '{$pageType}'");
foreach($links as $link)
{
if(in_array($link->link_id, $selectedPages))
{
self::RTapexInsertUpdatePage($link);
}
else
{
($link->post_id != NULL) ? self::RTapexDeletePage($link) : '';
}
}
echo 'your selection has been updated successfully
your selection has been updated successfully
Your latest update has been fetched successfully. Please take an action
 . ')