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; }