/**
* Custom admin columns implementation
*
* @access public
* @param string $column
* @return array
*/
public static function custom_columns_manage($column)
{
switch ($column) {
case 'thumbnail':
if (has_post_thumbnail()) {
the_post_thumbnail('thumbnail', array('class' => 'attachment-thumbnail attachment-thumbnail-small'));
} else {
echo '-';
}
break;
case 'price':
$price = Realia_Price::get_property_price(get_the_ID());
if (!empty($price)) {
echo wp_kses($price, wp_kses_allowed_html('post'));
} else {
echo '-';
}
break;
case 'location':
$terms = get_the_terms(get_the_ID(), 'locations');
if (!empty($terms)) {
$location = array_shift($terms);
echo sprintf('<a href="?post_type=property&location=%s">%s</a>', $location->slug, $location->name);
} else {
echo '-';
}
break;
case 'type':
$terms = get_the_terms(get_the_ID(), 'property_types');
if (is_array($terms)) {
$property_type = array_shift($terms);
echo sprintf('<a href="?post_type=property&property_type=%s">%s</a>', $property_type->slug, $property_type->name);
} else {
echo '-';
}
break;
case 'contract':
$terms = get_the_terms(get_the_ID(), 'contracts');
if (!empty($terms)) {
$contract_type = array_shift($terms);
echo sprintf('<a href="?post_type=property&contract=%s">%s</a>', $contract_type->slug, $contract_type->name);
} else {
echo '-';
}
break;
case 'sticky':
$sticky = get_post_meta(get_the_ID(), REALIA_PROPERTY_PREFIX . 'sticky', true);
if (!empty($sticky)) {
echo '<div class="dashicons-before dashicons-yes green"></div>';
} else {
echo '<div class="dashicons-before dashicons-no red"></div>';
}
break;
case 'featured':
$featured = get_post_meta(get_the_ID(), REALIA_PROPERTY_PREFIX . 'featured', true);
if (!empty($featured)) {
echo '<div class="dashicons-before dashicons-yes green"></div>';
} else {
echo '<div class="dashicons-before dashicons-no red"></div>';
}
break;
case 'reduced':
$featured = get_post_meta(get_the_ID(), REALIA_PROPERTY_PREFIX . 'reduced', true);
if (!empty($featured)) {
echo '<div class="dashicons-before dashicons-yes green"></div>';
} else {
echo '<div class="dashicons-before dashicons-no red"></div>';
}
break;
case 'views':
echo __('Total', 'realia') . ': ' . Realia_Statistics::property_views_get_total() . '<br>';
echo __('Weekly', 'realia') . ': ';
$progress = Realia_Statistics::property_views_get_weekly_progress();
if ($progress < 0) {
echo '<span class="red">' . $progress . '%</span>';
} elseif ($progress > 0) {
echo '<span class="green">' . $progress . '%</span>';
} else {
echo '<span>' . $progress . '%</span>';
}
break;
case 'paid':
$paid = Realia_Query::is_property_paid();
if ($paid) {
echo '<div class="dashicons-before dashicons-yes green"></div>';
} else {
echo '<div class="dashicons-before dashicons-no red"></div>';
}
break;
}
}
YEAR(created) = YEAR( current_date );';
$last_week_results = $wpdb->get_results($last_week_sql);
$last_week_count = 0;
if (is_array($last_week_results) && count($last_week_results) > 0) {
$last_week_count = $last_week_results[0]->count;
}
// Two weeks ago
$two_weeks_ago_sql = 'SELECT `key`, COUNT(*) as count FROM wp_property_stats
WHERE `key` = "' . $post_id . '" AND
WEEK(created) = WEEK( current_date ) - 2 AND
YEAR(created) = YEAR( current_date );';
$two_weeks_ago_results = $wpdb->get_results($two_weeks_ago_sql);
if (is_array($two_weeks_ago_results) && count($two_weeks_ago_results) > 0) {
$two_weeks_ago_count = $two_weeks_ago_results[0]->count;
}
if ($two_weeks_ago_count == 0 && $last_week_count > 0) {
return 100;
} elseif ($two_weeks_ago_count == 0 && $last_week_count == 0) {
return 0;
} elseif ($two_weeks_ago_count > 0 && $last_week_count == 0) {
return -100;
} elseif ($two_weeks_ago_count == $last_week_count) {
return 0;
} elseif ($two_weeks_ago_count > 0 && $last_week_count > 0) {
return round(100 / $two_weeks_ago_count * $last_week_count - 100, 2);
}
return 0;
}
}
Realia_Statistics::init();
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<?php
}
?>
</div><!-- /.one-half -->
<div class="one-half">
<?php
$locations = Realia_Statistics::property_views_get_popular_locations();
?>
<?php
if (!empty($locations) && is_array($locations)) {
?>
<table class="table">
<thead>
<th colspan="2" class="center">
<?php
echo __('10 most popular locations', 'realia');
?>
</th>
</thead>
<tbody>
