function listCat()
{
$pluginBase = 'wp-content' . DIRECTORY_SEPARATOR . 'plugins' . DIRECTORY_SEPARATOR . 'listingx';
require_once ABSPATH . $pluginBase . DIRECTORY_SEPARATOR . 'listingx_list.php';
global $filter;
$nonce = wp_create_nonce();
$list = new listingx_list();
$list->search = false;
$list->orderForm = false;
$list->omit = array("cb");
$list->addFilter("c.lx_project_cat_approved", "Approved", array("0" => "No", "1" => "Yes"));
$text = "<div class=\"wrap\">";
$text .= "<h2>ListingX - Project Categories</h2>";
$text .= "<a href=\"?page=lx_categories&action=form&sub=add\">Add Category</a>";
$text .= $this->parent->message;
$headers["cb"] = "<input type=\"checkbox\" />";
$headers["c.lx_project_cat_name"] = "Category Name";
$headers["c.user_id"] = "Added By";
$headers["c.lx_project_cat_approved"] = "Approved";
$order = "c.lx_project_cat_name";
$sort = "asc";
$query = "select c.lx_project_cat_id, c.lx_project_cat_name, u.user_login, c.lx_project_cat_approved from ";
$query .= $this->wpdb->prefix . "lx_project_cat c left join " . $this->wpdb->prefix . "users u on u.ID = c.user_id ";
if ($_GET["c_lx_project_cat_approved"] != '') {
$query .= "where c.lx_project_cat_approved = %d ";
}
$query .= "order by %s %s";
if ($_GET["c_lx_project_cat_approved"] != '') {
$result = $this->wpdb->get_results($this->wpdb->prepare($query, $_GET["c_lx_project_cat_approved"], $order, $sort));
} else {
$result = $this->wpdb->get_results($this->wpdb->prepare($query, $order, $sort));
}
foreach ($result as $row) {
if ($row->lx_project_cat_approved == 1) {
$approved = $filter[$row->lx_project_cat_approved];
} else {
$approved = "<a href=\"admin.php?page=lx_categories&action=approve&_wpnonce={$nonce}&id=" . $row->lx_project_cat_id . "\">No</a>";
}
$rows[$row->lx_project_cat_id] = array($row->lx_project_cat_name, $row->user_login, $approved);
}
$url = "admin.php?page=lx_categories&action=form&id=";
$list->startList($headers, $url, $order, $sort, $rows, array("page" => "lx_categories"));
$text .= $list->text . "</div>";
$this->text = $text;
}
function listProjects()
{
$pluginBase = 'wp-content' . DIRECTORY_SEPARATOR . 'plugins' . DIRECTORY_SEPARATOR . 'listingx';
require_once ABSPATH . $pluginBase . DIRECTORY_SEPARATOR . 'listingx_list.php';
global $filter;
$list = new listingx_list();
$list->search = true;
$list->orderForm = true;
$list->omit = array("cb");
$list->addFilter("p.lx_project_approved", "Approved", array("0" => "No", "1" => "Yes"));
$text = "<div class=\"wrap\">";
$text .= "<h2>ListingX - Projects</h2>";
$text .= "<a href=\"?page=lx_projects&action=form&sub=add\">Add Project</a>";
$text .= $this->parent->message;
$headers["cb"] = "<input type=\"checkbox\" />";
$headers["p.lx_project_name"] = "Project Name";
$headers["u.user_login"] = "******";
$headers["c.lx_project_cat_name"] = "Categories";
$headers["p.lx_project_approved"] = "Approved";
$order = "p.lx_project_name";
$sort = "asc";
$query = "select p.lx_project_id, p.lx_project_name, u.user_login, p.lx_project_approved from ";
$query .= $this->wpdb->prefix . "lx_project p left join " . $this->wpdb->prefix . "users u on u.ID = p.user_id order by {$order} {$sort}";
$result = $this->wpdb->get_results($query);
foreach ($result as $row) {
$approved = $filter[$row->lx_project_approved];
$categories = $this->catForm("list", $row->lx_project_id);
$rows[$row->lx_project_id] = array($row->lx_project_name, $row->user_login, $categories, $approved);
}
$url = "admin.php?page=lx_projects&action=view&id=";
$list->startList($headers, $url, $order, $sort, $rows, array("page" => "lx_projects"));
$text .= $list->text . "</div>";
$this->text = $text;
}
