get_results($query);
$options = array();
foreach ($results as $result) {
$options[$result->$field] = $result->$field;
}
$selected = stripslashes_deep(awpcp_post_param($search_field, null));
echo $this->select($options, $by, $search_field, $selected) . '
';
}
/**
* @since 3.0-beta
*/
protected function defaults() {
return array(
'title' => '',
'subtitle' => '',
'show_keyword' => 1,
'show_by' => 1,
'show_city' => 1,
'show_state' => 1,
'show_country' => 1,
'show_category' => 1,
);
}
// /**
// * @since 3.0-beta
// */
// protected function get_ad_categories() {
// global $wpdb;
// $conditions[] = 'disabled = 0';
// $conditions[] = '(flagged IS NULL OR flagged = 0)';
// $query = 'SELECT DISTINCT ad_category_id AS id, category_name AS name FROM ' . AWPCP_TABLE_ADS . ' ';
// $query.= 'LEFT JOIN ' . AWPCP_TABLE_CATEGORIES . ' ON (category_id = ad_category_id)';
// $query.= 'WHERE ' . join(' AND ', $conditions);
// $query.= 'ORDER BY category_name';
// $results = $wpdb->get_results($query);
// $categories = array();
// foreach ($results as $result) {
// $categories[$result->id] = $result->name;
// }
// return $categories;
// }
/**
* @since 3.0-beta
*/
public function select($options, $label, $name, $selected=null) {
$id = 'awpcp-search-' . sanitize_title($label);
$html = sprintf('
', $id, $label);
$html .= sprintf('';
return $html;
}
function widget($args, $instance) {
extract($args);
$instance = wp_parse_args($instance, $this->defaults());
$title = $instance['title'].'
'.$instance['subtitle'].'';
echo $before_widget . $before_title . $title . $after_title;
echo '';
echo $after_widget;
}
function update($new_instance, $old_instance) {
$instance = $old_instance;
$instance['title'] = strip_tags($new_instance['title']);
$instance['subtitle'] = strip_tags($new_instance['subtitle']);
$instance['show_keyword'] = (strip_tags($new_instance['show_keyword']) == 1 ? 1 : 0);
$instance['show_by'] = (strip_tags($new_instance['show_by']) == 1 ? 1 : 0);
$instance['show_city'] = (strip_tags($new_instance['show_city']) == 1 ? 1 : 0);
$instance['show_state'] = (strip_tags($new_instance['show_state']) == 1 ? 1 : 0);
$instance['show_country'] = (strip_tags($new_instance['show_country']) == 1 ? 1 : 0);
return $instance;
}
function form($instance) {
$instance = wp_parse_args((array) $instance, $this->defaults());
$title = strip_tags($instance['title']);
$subtitle = strip_tags($instance['subtitle']);
$show_keyword = strip_tags($instance['show_keyword']);
$show_by = strip_tags($instance['show_by']);
$show_city = strip_tags($instance['show_city']);
$show_state = strip_tags($instance['show_state']);
$show_country = strip_tags($instance['show_country']);
include(AWPCP_DIR . '/frontend/templates/widget-search-form.tpl.php');
}
}