listings = new AWPCP_User_Panel_Listings();
$this->profile = new AWPCP_User_Panel_Profile_Data();
add_action('awpcp_add_menu_page', array($this, 'menu'));
}
/**
* Register Ad Management Panel menu
*/
public function menu() {
if (get_awpcp_option('enable-user-panel') != 1) {
return;
}
$slug = 'awpcp-panel';
add_menu_page('AWPCP Ad Management Panel', 'Ad Management', 'read',
$slug, array($this->listings, 'dispatch'), MENUICO);
// Listings
$page = add_submenu_page($slug, 'Manage Ad Listings', 'Listings', 'read',
'awpcp-panel', array($this->listings, 'dispatch'));
add_action('admin_print_styles-' . $page, array($this->listings, 'scripts'));
do_action('awpcp_panel_add_submenu_page', $slug);
}
}
class AWPCP_User_Panel_Listings {
public function AWPCP_User_Panel_Listings() {
$this->container_id = 'awpcp-ad-management-panel';
$this->page_title = __("AWPCP User Ad Management Panel - Listings","AWPCP");
add_action('init', array($this, 'init'));
add_action('wp_ajax_awpcp-panel-delete-ad', array($this, 'ajax'));
}
public function init() {
wp_register_script('awpcp-panel-listings', AWPCP_URL . 'js/user-panel-listings.js',
array('awpcp-table-ajax-admin'), '1.0', true);
}
public function scripts() {
wp_enqueue_script('awpcp-panel-listings');
}
public function redirect($action) {
$_REQUEST['action'] = $action;
return $this->dispatch();
}
public function dispatch() {
global $current_user, $wpdb;
get_currentuserinfo();
$this->current_user = $current_user;
$this->is_admin_user = awpcp_current_user_is_admin();
$this->url = awpcp_current_url();
$action = awpcp_request_param('action', 'list');
$id = awpcp_request_param('id', null);
$offset = awpcp_request_param('offset', 0);
$results = awpcp_request_param('results', 10);
$sortby = awpcp_request_param('sortby', 'mostrecent');
$filter = awpcp_request_param('lookupadbychoices', '');
$query = $wpdb->escape(awpcp_request_param('lookupadidortitle', ''));
// if user can't modify this ad, do nothing and show list of ads
if (!$this->is_admin_user && !is_null($id) &&
!AWPCP_Ad::belongs_to_user($id, $current_user->ID)) {
$content = $this->index($filter, $query, $sortby, $offset, $results);
}
if ($action == 'delete-ad') { // handled by ajax
$this->url = remove_query_arg('action', $this->url);
$content = $this->redirect('list');
} else if ($action == 'delete-selected') {
$ids = array_filter(awpcp_post_param('selected', array()), 'intval');
$content = $this->delete_ads($ids);
} else if ($action == 'renew-ad') {
$content = $this->renew_ad($id);
} else if ($action == 'place-ad') {
$content = $this->place_ad();
} else if ($action == 'edit-ad') {
$content = $this->edit_ad($id);
} else if (in_array($action, array('manage-images', 'add-image', 'deletepic'))) {
$content = $this->manage_images($action);
} else if (in_array($action, array('list', 'lookupadby'))) {
$content = $this->index($filter, $query, $sortby, $offset, $results);
}
echo $content;
}
public function ajax() {
global $current_user;
get_currentuserinfo();
$id = awpcp_post_param('id', 0);
$is_admin_user = awpcp_current_user_is_admin();
// if user can't modify this ad, do nothing and show list of ads
if (!AWPCP_Ad::belongs_to_user($id, $current_user->ID) && !$is_admin_user) {
return false;
}
$errors = array();
if (isset($_POST['remove'])) {
$result = deletead($id, $adkey='', $editemail='', $force=true, $errors);
if (empty($errors)) {
$response = json_encode(array('status' => 'success'));
} else {
$response = json_encode(array('status' => 'error', 'message' => join('
', $errors)));
}
} else {
$columns = $is_admin_user ? 8 : 7;
ob_start();
include(AWPCP_DIR . '/admin/templates/delete_form.tpl.php');
$html = ob_get_contents();
ob_end_clean();
$response = json_encode(array('html' => $html));
}
header('Content-Type: application/json');
echo $response;
exit();
}
public function index($filter='', $query='', $sortby='mostrecent', $offset=0, $results=10) {
global $current_user, $wpdb;
get_currentuserinfo();
wp_parse_str($_SERVER['QUERY_STRING'], $query_args);
$query_args = array_merge($query_args, array('offset'=> $offset,
'results'=> $results,
'sortby'=> $sortby));
// filter ads by...
if (!empty($filter) && empty($query)) {
$this->message = __('You need enter either an Ad title or an Ad id to look up.', 'AWPCP');
$where = '1=1';
} else {
switch ($filter) {
case 'adid':
$id = intval($query);
if ($id > 0) {
$where = "ad_id=$id";
} else {
$this->message = __('You indicated you wanted to look up the ad by ID but you entered an invalid ID. Please try again.', 'AWPCP');
$where = '1=1';
}
break;
case 'adtitle':
$where = "ad_title LIKE '%$query%'";
break;
case 'titdet':
$where = "MATCH (ad_title,ad_details) AGAINST (\"$query\")";
break;
case 'location':
$where = "ad_city='%s' OR ad_state='%s' OR ad_country='%s' OR ad_county_village='%s'";
$where = sprintf($where, $query, $query, $query, $query);
break;
case 'user':
$sql = "SELECT DISTINCT ID FROM wp_users ";
$sql.= "LEFT JOIN wp_usermeta ON (ID = user_id) ";
$sql.= "WHERE (user_login LIKE '%%%s%%') OR ";
$sql.= "(meta_key = 'last_name' AND meta_value LIKE '%%%s%%') ";
$sql.= "OR (meta_key = 'first_name' AND meta_value LIKE '%%%s%%')";
$users = $wpdb->get_col($wpdb->prepare($sql, $query, $query, $query));
if (!empty($users)) {
$where = 'user_id IN (' . join(',', $users) . ')';
} else {
$where = '1=1';
}
break;
default:
$where = '1=1';
}
}
$filter_by = array('adid' => __('Ad ID', 'AWPCP'),
'adtitle' => __('Ad Title', 'AWPCP'),
'titdet' => __('Keyword', 'AWPCP'),
'location' => __('Location', 'AWPCP'));
// sort ads by...
$sort_modes = array('mostrecent' => false,
'oldest' => false,
'titleaz' => false,
'titleza' => false,
'awaitingapproval' => false,
'flagged' => false);
$sort_names = array('mostrecent' => __('Newest', 'AWPCP'),
'oldest' => __('Oldest', 'AWPCP'),
'titleaz' => __('Title A-Z', 'AWPCP'),
'titleza' => __('Title Z-A', 'AWPCP'),
'awaitingapproval' => __('Awaiting Approval', 'AWPCP'),
'flagged' => __('Flagged Ads', 'AWPCP'));
$sort_modes[$sortby] = true;
$is_admin_user = awpcp_current_user_is_admin();
// Admin can see all Ads, normal user can only see Ads he has posted
if (!$is_admin_user) {
$where = "$where AND user_id = " . $current_user->ID;
} else {
$filter_by['user'] = __('User', 'AWPCP');
}
$items = AWPCP_Ad::find($where=$where, $order=$sortby, $offset=$offset, $results=$results);
$row_count = AWPCP_Ad::count($where=$where);
$num_pages = ceil($row_count/$results);
$pager = create_pager(AWPCP_TABLE_ADS, $where, $offset, $results, '');
$pager = preg_replace('/