当前位置: 首页>>代码示例>>PHP>>正文


PHP SendPress_Data::list_subcribers_table方法代码示例

本文整理汇总了PHP中SendPress_Data::list_subcribers_table方法的典型用法代码示例。如果您正苦于以下问题:PHP SendPress_Data::list_subcribers_table方法的具体用法?PHP SendPress_Data::list_subcribers_table怎么用?PHP SendPress_Data::list_subcribers_table使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在SendPress_Data的用法示例。


在下文中一共展示了SendPress_Data::list_subcribers_table方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: prepare_items

 /** ************************************************************************
  * REQUIRED! This is where you prepare your data for display. This method will
  * usually be used to query the database, sort and filter the data, and generally
  * get it ready to be displayed. At a minimum, we should set $this->items and
  * $this->set_pagination_args(), although the following properties and methods
  * are frequently interacted with here...
  * 
  * @uses $this->_column_headers
  * @uses $this->items
  * @uses $this->get_columns()
  * @uses $this->get_sortable_columns()
  * @uses $this->get_pagenum()
  * @uses $this->set_pagination_args()
  **************************************************************************/
 function prepare_items()
 {
     global $wpdb, $_wp_column_headers;
     $screen = get_current_screen();
     /*      
             select t1.* from `sp_sendpress_list_subscribers` as t1 , `sp_sendpress_subscribers` as t2
             where t1.subscriberID = t2.subscriberID and t1.listID = 2*/
     /* -- Preparing your query -- */
     if (isset($_GET["listID"]) && $_GET["listID"] > 0) {
         $query = "SELECT t1.*, t3.status FROM " . SendPress_Data::subscriber_table() . " as t1," . SendPress_Data::list_subcribers_table() . " as t2," . SendPress_Data::subscriber_status_table() . " as t3";
         $query .= " WHERE (t1.subscriberID = t2.subscriberID) AND (t2.status = t3.statusid ) AND (t2.listID =  " . $_GET["listID"] . ")";
     } else {
         $query = "SELECT t1.*, t3.status FROM " . SendPress_Data::subscriber_table() . " as t1," . SendPress_Data::list_subcribers_table() . " as t2," . SendPress_Data::subscriber_status_table() . " as t3";
         $query .= " WHERE (t1.subscriberID = t2.subscriberID) AND (t2.status = t3.statusid ) ";
     }
     /* -- Ordering parameters -- */
     //Parameters that are going to be used to order the result
     $query_count = "SELECT count(*) FROM " . SendPress_Data::subscriber_table() . " as t1," . SendPress_Data::list_subcribers_table() . " as t2," . SendPress_Data::subscriber_status_table() . " as t3";
     if (isset($_GET["listID"])) {
         $query_count .= " WHERE (t1.subscriberID = t2.subscriberID) AND (t2.status = t3.statusid ) AND (t2.listID =  " . $_GET["listID"] . ")";
     }
     if (isset($_GET["statusid"]) && $_GET["statusid"] > 0) {
         $query .= ' AND statusid = ' . $_GET["statusid"];
         $query_count .= ' AND statusid = ' . $_GET["statusid"];
     }
     if (isset($_GET["qs"])) {
         $query .= ' AND ( email LIKE "%' . $_GET["qs"] . '%" or firstname LIKE "%' . $_GET["qs"] . '%" or lastname LIKE "%' . $_GET["qs"] . '%" )';
         $query_count .= ' AND ( email LIKE "%' . $_GET["qs"] . '%" or firstname LIKE "%' . $_GET["qs"] . '%" or lastname LIKE "%' . $_GET["qs"] . '%" )';
     }
     /* -- Pagination parameters -- */
     //Number of elements in your table?
     $totalitems = $wpdb->get_var($query_count);
     //return the total number of affected rows
     //How many to display per page?
     // get the current user ID
     $user = get_current_user_id();
     // get the current admin screen
     $screen = get_current_screen();
     // retrieve the "per_page" option
     $screen_option = $screen->get_option('per_page', 'option');
     $per_page = 10;
     if (!empty($screen_option)) {
         // retrieve the value of the option stored for the current user
         $per_page = get_user_meta($user, $screen_option, true);
         if (empty($per_page) || $per_page < 1) {
             // get the default value if none is set
             $per_page = $screen->get_option('per_page', 'default');
         }
     }
     //Which page is this?
     $paged = !empty($_GET["paged"]) ? esc_sql($_GET["paged"]) : '';
     //Page Number
     if (empty($paged) || !is_numeric($paged) || $paged <= 0) {
         $paged = 1;
     }
     //How many pages do we have in total?
     $totalpages = ceil($totalitems / $per_page);
     $orderby = !empty($_GET["orderby"]) ? esc_sql($_GET["orderby"]) : 'ASC';
     $order = !empty($_GET["order"]) ? esc_sql($_GET["order"]) : '';
     if ($orderby == 'status') {
         $orderby = 't2.status';
     }
     if (!empty($orderby) & !empty($order)) {
         $query .= ' ORDER BY ' . $orderby . ' ' . $order;
     }
     if (!isset($_GET["listID"])) {
         $query .= ' group by t1.email';
     }
     //adjust the query to take pagination into account
     if (!empty($paged) && !empty($per_page)) {
         $offset = ($paged - 1) * $per_page;
         $query .= ' LIMIT ' . (int) $offset . ',' . (int) $per_page;
     }
     /* -- Register the pagination -- */
     $this->set_pagination_args(array("total_items" => $totalitems, "total_pages" => $totalpages, "per_page" => $per_page));
     //The pagination links are automatically built according to those parameters
     /* -- Register the Columns -- */
     $columns = $this->get_columns();
     $hidden = array();
     $sortable = $this->get_sortable_columns();
     $this->_column_headers = array($columns, $hidden, $sortable);
     /* -- Fetch the items -- */
     $this->items = $wpdb->get_results($query);
 }
开发者ID:richardsweeney,项目名称:sendpress,代码行数:98,代码来源:class-sendpress-subscribers-table.php

示例2: get_total_subscribers

 static function get_total_subscribers()
 {
     global $wpdb;
     $table = SendPress_Data::list_subcribers_table();
     $query = "SELECT DISTINCT subscriberID FROM " . $table . " WHERE status = 2";
     $count = $wpdb->get_results($query);
     return count($count);
 }
开发者ID:pedro-mendonca,项目名称:sendpress,代码行数:8,代码来源:class-sendpress-data.php

示例3: list_subcribers_table

 function list_subcribers_table()
 {
     _deprecated_function(__FUNCTION__, '0.8.9', 'SendPress_Data::list_subcribers_table()');
     return SendPress_Data::list_subcribers_table();
 }
开发者ID:radscheit,项目名称:unicorn,代码行数:5,代码来源:sendpress.php


注:本文中的SendPress_Data::list_subcribers_table方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。