Esempio n. 1
0
 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;
 }
Esempio n. 2
0
 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;
 }