File Manager
/ wp-content
Search
Upload
New Item
Settings
File "db5.php"
Full path: /home1/epichome/public_html/wp-content/db5.php
File size: 60.67 B (60.67 KB bytes)
MIME-type: text/x-php
Charset: utf-8
Download Open Edit Advanced Editor Back
/home/pharmacy/www/wp-content/plugins/sendpress/classes/class-sendpress-reports-table.php
<?php
// Prevent loading this file directly
if ( !defined('SENDPRESS_VERSION') ) {
header('HTTP/1.0 403 Forbidden');
die;
}
/************************** CREATE A PACKAGE CLASS *****************************
*******************************************************************************
* Create a new list table package that extends the core WP_List_Table class.
* WP_List_Table contains most of the framework for generating the table, but we
* need to define and override some methods so that our data can be displayed
* exactly the way we need it to be.
*
* To display this example on a page, you will first need to instantiate the class,
* then call $yourInstance->prepare_items() to handle any data manipulation, then
* finally call $yourInstance->display() to render the table to the page.
*
* Our theme for this list table is going to be movies.
*/
class SendPress_Reports_Table extends WP_List_Table {
/** ************************************************************************
* Normally we would be querying data from a database and manipulating that
* for use in your list table. For this example, we're going to simplify it
* slightly and create a pre-built array. Think of this as the data that might
* be returned by $wpdb->query().
*
* @var array
**************************************************************************/
private $_sendpress = '';
/** ************************************************************************
* REQUIRED. Set up a constructor that references the parent constructor. We
* use the parent reference to set some default configs.
***************************************************************************/
function __construct(){
global $status, $page;
$this->_sendpress = new SendPress();
//Set parent defaults
parent::__construct( array(
'singular' => 'report', //singular name of the listed records
'plural' => 'reports', //plural name of the listed records
'ajax' => false //does this table support ajax?
) );
}
/**
* Generates content for a single row of the table
*
* @since 3.1.0
* @access protected
*
* @param object $item The current item
*/
function single_row( $item ) {
static $row_class = '';
$canceled = get_post_meta($item->ID, '_canceled', true);
$info = get_post_meta($item->ID, '_send_time', true);
$cl ='';
if($info != false && $info != '0000-00-00 00:00:00' && date_i18n('Y-m-d H:i:s', strtotime( $info )) > date_i18n('Y-m-d H:i:s') && $canceled == false){
$cl = 'scheduled';
}
$row_class = ( $row_class == '' ? ' class="alternate "' : '' );
if( $row_class == ''){
$row_class_mod =" class='".$cl."'";
} else {
$row_class_mod =" class='alternate ".$cl."'";
}
echo '<tr' . $row_class_mod . '>';
$this->single_row_columns( $item );
echo '</tr>';
}
/** ************************************************************************
* Recommended. This method is called when the parent class can't find a method
* specifically build for a given column. Generally, it's recommended to include
* one method for each column you want to render, keeping your package class
* neat and organized. For example, if the class needs to process a column
* named 'title', it would first see if a method named $this->column_title()
* exists - if it does, that method will be used. If it doesn't, this one will
* be used. Generally, you should try to use custom column methods as much as
* possible.
*
* Since we have defined a column_title() method later on, this method doesn't
* need to concern itself with any column with a name of 'title'. Instead, it
* needs to handle everything else.
*
* For more detailed insight into how columns are handled, take a look at
* WP_List_Table::single_row_columns()
*
* @param array $item A singular item (one full row's worth of data)
* @param array $column_name The name/slug of the column to be processed
* @return string Text or HTML to be placed inside the column <td>
**************************************************************************/
function column_default($item, $column_name){
$stat_type = get_post_meta($item->ID, '_stat_type', true);
switch($column_name){
/* case 'firstname':
case 'lastname':
return $item->$column_name;
case 'status':
return $item->$column_name;
*/
case 'bounces':
return '<span class="label">Coming Soon</span>';
break;
case 'count':
$rec = get_post_meta($item->ID, '_send_count', true) + get_post_meta($item->ID, '_send_last_count', true) . '';
$sentold = get_post_meta($item->ID, '_sent_total', true);
$queue = 0;
$sent = get_post_meta($item->ID, '_send_total', true);
$inqueue = get_post_meta($item->ID, '_in_queue', true);
if($inqueue !== 'none'){
$queue = SendPress_Data::emails_in_queue($item->ID);
$sentindb = SendPress_Data::emails_sent_in_queue_for_report($item->ID);
if($sentindb > $sent){
update_post_meta($item->ID, '_send_total', $sentindb);
$sent = $sentindb;
}
if($queue == 0){
update_post_meta($item->ID, '_in_queue', 'none');
}
}
$string = "Recipients: ". $rec ."<br>";
$string .= "Sent: ". $sent ."<br>";
$string .= "In Queue: ". $queue ."<br>";
return $string;
break;
case'sentto':
$display = '';
$info = get_post_meta($item->ID, '_send_data', true);
if(!empty($info['listIDS']) ){
foreach($info['listIDS'] as $list_id){
$list = get_post( $list_id );
if($list && $list->post_type == 'sendpress_list'){
$display .= $list->post_title.'<br>';
}
}
} else {
$lists = get_post_meta($item->ID,'_send_lists', true);
$list = explode(",",$lists );
foreach($list as $list_id){
$list = get_post( $list_id );
if($list && $list->post_type == 'sendpress_list'){
$display .= $list->post_title.'<br>';
}
}
}
return $display;
break;
case 'opens':
//if( $stat_type == 'new'){
$opens = SPNL()->load("Subscribers_Tracker")->get_opens( $item->ID );
$opens_total = SPNL()->load("Subscribers_Tracker")->get_opens_total( $item->ID );
$opens = $opens == 0 ? '-' : $opens;
$opens_total = $opens_total == 0 ? '-' : $opens_total;
return '<span class="label label-success">'. $opens .'</span> <span class="label label-info">'. $opens_total .'</span>';
/*
} else {
$ou = $this->_sendpress->get_opens_unique_count($item->ID);
$ou = $ou ? $ou : '-';
$ot = $this->_sendpress->get_opens_count($item->ID);
$ot = $ot ? $ot : '-';
return '<span class="label label-success">'. $ou .'</span> <span class="label label-info">'. $ot .'</span>';
}
*/
break;
case 'clicks':
//if( $stat_type == 'new'){
$clicks = SPNL()->load("Subscribers_Url")->clicks_email_id( $item->ID );
$clicks_total = SPNL()->load("Subscribers_Url")->clicks_total_email_id( $item->ID );
$clicks = $clicks == 0 ? '-' : $clicks;
$clicks_total = $clicks_total == 0 ? '-' : $clicks_total;
return '<span class="label label-success">'. $clicks .'</span> <span class="label label-info">'. $clicks_total .'</span>';
/*
} else {
$ou = $this->_sendpress->get_clicks_unique_count($item->ID);
$ou = $ou ? $ou : '-';
$ot = $this->_sendpress->get_clicks_count($item->ID);
$ot = $ot ? $ot : '-';
return '<span class="label label-success">'. $ou .'</span> <span class="label label-info">'. $ot .'</span>';
}
*/
break;
case 'unsubscribe':
//if( $stat_type == 'new'){
$clicks = SPNL()->load("Subscribers_Tracker")->get_unsubs( $item->ID );
$clicks = $clicks == 0 ? '-' : $clicks;
return '<span class="label label-danger">'. $clicks .'</span>';
/*
} else {
$clicks = get_post_meta($item->ID, '_unsubscribe_count', true);
if($clicks) {
return '<span class="label label-danger">'. $clicks .'</span>';
}
}
*/
// return '<span class="label label-danger">0</span>';
break;
case 'subject':
$sub = get_post_meta($item->ID, "_sendpress_subject", true);
return $sub;
break;
case 'lastsend':
$date = get_post_meta($item->ID, "send_date", true);
if(!empty( $date ) ){
return date_i18n(get_option('date_format') ,strtotime($date) );
}
return '';
break;
case 'created':
$canceled = get_post_meta($item->ID, '_canceled', true);
if($canceled == true){
return "CANCELED";
}
$info = get_post_meta($item->ID, '_send_time', true);
if($info == false || $info == '0000-00-00 00:00:00' ){
return date_i18n(get_option('date_format') , strtotime( $item->post_date ) );
}elseif(date_i18n('Y-m-d H:i:s', strtotime( $info )) < date_i18n('Y-m-d H:i:s')){
return date_i18n(get_option('date_format') , strtotime( $info ) );
}
return "Scheduled for ".date_i18n('Y/m/d @ h:i A' , strtotime( $info ) ) . "<br><a href='".SendPress_Admin::link('Emails_Send_Cancel',array('emailID'=>$item->ID ))."'>Cancel Send</a>";
break;
case 'actions':
return '<div class="inline-buttons"><a class="spbutton left" href="'. get_permalink( $item->ID ). '">View</a><a class="spbutton right" href="?page='.SPNL()->validate->page().'&view=edit-email&emailID='. $item->ID .'">Edit</a><a class="spbutton bluebtn" href="?page='.SPNL()->validate->page().'&view=send-email&emailID='. $item->ID .'">Send</a></div>';
break;
default:
return apply_filters('sendpress_reports_column_'.$column_name, $item); //Show the whole array for troubleshooting purposes
}
}
/** ************************************************************************
* Recommended. This is a custom column method and is responsible for what
* is rendered in any column with a name/slug of 'title'. Every time the class
* needs to render a column, it first looks for a method named
* column_{$column_title} - if it exists, that method is run. If it doesn't
* exist, column_default() is called instead.
*
* This example also illustrates how to implement rollover actions. Actions
* should be an associative array formatted as 'slug'=>'link html' - and you
* will need to generate the URLs yourself. You could even ensure the links
*
*
* @see WP_List_Table::::single_row_columns()
* @param array $item A singular item (one full row's worth of data)
* @return string Text to be placed inside the column <td> (movie title only)
**************************************************************************/
function column_title($item){
//Build row actions
$actions = array(
// 'edit' => sprintf('<a href="?page=%s&view=%s&report=%s">Edit</a>',SPNL()->validate->page(),'edit-email',$item->ID),
'view' => sprintf('<a href="%s">View Email</a>',get_permalink( $item->ID )),
'delete' => sprintf('<a href="?page=%s&action=%s&reportID=%s">Delete</a>',SPNL()->validate->page(),'delete-report',$item->ID),
);
//Return the title contents
return sprintf('%1$s <span style="color:silver">(id:%2$s)</span>%3$s',
/*$1%s*/ $item->post_title,
/*$2%s*/ $item->ID,
/*$3%s*/ $this->row_actions($actions)
);
}
/** ************************************************************************
* REQUIRED if displaying checkboxes or using bulk actions! The 'cb' column
* is given special treatment when columns are processed. It ALWAYS needs to
* have it's own method.
*
* @see WP_List_Table::::single_row_columns()
* @param array $item A singular item (one full row's worth of data)
* @return string Text to be placed inside the column <td> (movie title only)
**************************************************************************/
function column_cb($item){
return sprintf(
'<input type="checkbox" name="%1$s[]" value="%2$s" />',
/*$1%s*/ $this->_args['singular'], //Let's simply repurpose the table's singular label ("movie")
/*$2%s*/ $item->ID //The value of the checkbox should be the record's id
);
}
/** ************************************************************************
* REQUIRED! This method dictates the table's columns and titles. This should
* return an array where the key is the column slug (and class) and the value
* is the column's title text. If you need a checkbox for bulk actions, refer
* to the $columns array below.
*
* The 'cb' column is treated differently than the rest. If including a checkbox
* column in your table you must create a column_cb() method. If you don't need
* bulk actions or checkboxes, simply leave the 'cb' entry out of your array.
*
* @see WP_List_Table::::single_row_columns()
* @return array An associative array containing column information: 'slugs'=>'Visible Titles'
**************************************************************************/
function get_columns(){
$columns = array(
'cb' => '<input type="checkbox" />', //Render a checkbox instead of text
'title' => __('Subject','sendpress'),
'created' => __('Date Sent','sendpress'),
'count' => __('Info','sendpress'),
'sentto' => __('Lists','sendpress'),
'opens' => __('Opens','sendpress'),
'clicks'=> __('Clicks','sendpress'),
'unsubscribe'=> __('Unsubscribes','sendpress'),
//'bounces' => 'Bounces'
//'count_subscribers' => 'Subscribers'
);
return apply_filters('sendpress_reports_columns', $columns);
}
/** ************************************************************************
* Optional. If you want one or more columns to be sortable (ASC/DESC toggle),
* you will need to register it here. This should return an array where the
* key is the column that needs to be sortable, and the value is db column to
* sort by. Often, the key and value will be the same, but this is not always
* the case (as the value is a column name from the database, not the list table).
*
* This method merely defines which columns should be sortable and makes them
* clickable - it does not handle the actual sorting. You still need to detect
* the ORDERBY and ORDER querystring variables within prepare_items() and sort
* your data accordingly (usually by modifying your query).
*
* @return array An associative array containing all the columns that should be sortable: 'slugs'=>array('data_values',bool)
**************************************************************************/
function get_sortable_columns() {
$sortable_columns = array(
/*
'title' =>array('email',true),
'created' =>array('post_date',false),
'lastname' =>array('lastname',false),
'status' =>array('status',false),
'joindate' =>array('join_date',false), //true means its already sorted
'rating' => array('rating',false),
'director' => array('director',false)
*/
);
return apply_filters('sendpress_sortable_reports_columns', $sortable_columns);
}
/** ************************************************************************
* Optional. If you need to include bulk actions in your list table, this is
* the place to define them. Bulk actions are an associative array in the format
* 'slug'=>'Visible Title'
*
* If this method returns an empty value, no bulk action will be rendered. If
* you specify any bulk actions, the bulk actions box will be rendered with
* the table automatically on display().
*
* Also note that list tables are not automatically wrapped in <form> elements,
* so you will need to create those manually in order for bulk actions to function.
*
* @return array An associative array containing all the bulk actions: 'slugs'=>'Visible Titles'
**************************************************************************/
function get_bulk_actions() {
$actions = array(
'delete-reports-bulk' => 'Delete'
);
return $actions;
}
/** ************************************************************************
* Optional. You can handle your bulk actions anywhere or anyhow you prefer.
* For this example package, we will handle it in the class to keep things
* clean and organized.
*
* @see $this->prepare_items()
**************************************************************************/
function process_bulk_action() {
//Detect when a bulk action is being triggered...
if( 'delete'===$this->current_action() ) {
wp_die('Items deleted (or they would be if we had items to delete)!');
}
}
/** ************************************************************************
* 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();
$sp_validate = SPNL()->validate;
/*
select t1.* from `sp_sendpress_list_subscribers` as t1 , `sp_sendpress_subscribers` as t2
where t1.subscriberID = t2.subscriberID and t1.listID = 2*/
/*
select t1.* from `sp_sendpress_list_subscribers` as t1 , `sp_sendpress_subscribers` as t2
where t1.subscriberID = t2.subscriberID and t1.listID = 2*/
/* -- Pagination parameters -- */
//Number of elements in your table?
// $totalitems = $wpdb->query($query); //return the total number of affected rows
//How many to display per page?
/* -- Register the Columns -- */
$columns = $this->get_columns();
$hidden = array();
$sortable = $this->get_sortable_columns();
$this->_column_headers = array($columns, $hidden, $sortable);
/* -- Fetch the items -- */
$args = array(
'post_type' => $this->_sendpress->_report_post_type ,
'post_status' => array('publish','draft'),
'meta_query' => array(
array(
'key' => '_report_type',
'compare' => 'not exists',
),
),
);
$query = new WP_Query( $args );
/*
echo '<pre>';
print_r($query);
echo '</pre>';
*/
$totalitems = $query->found_posts;
// 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 = $sp_validate->_int("paged");
//Page Number
if(empty($paged) || !is_numeric($paged) || $paged<=0 ){ $paged=1; }
//How many pages do we have in total?
if( is_plugin_active('piglatin/piglatin.php') ){
/*
hard coding this so I can run through these pages
and look at the language support. for some reason
when pig latin is active, get_current_screen doesn't
return the per_page array
*/
$per_page = 10;
}
$totalpages = ceil($totalitems/$per_page);
//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,
) );
$args = array(
'post_type' => $this->_sendpress->_report_post_type ,
'post_status' => array('publish','draft'),
'meta_query' => array(
array(
'key' => '_report_type',
'compare' => 'not exists',
),
),
'posts_per_page' => $per_page,
'paged'=> $paged,
);
$s = $sp_validate->_string("s");
if ( !empty( $s ) ){
$args['s'] = $s;
}
$args['order'] = $sp_validate->_string("order") == 'ASC' ? 'ASC' : 'DESC';
$orderby = $sp_validate->orderby($sp_validate->_string("orderby"));
if(!empty($orderby)){
$args['orderby'] = $orderby;
if($orderby == 'subject'){
$args['orderby'] = 'meta_value';
$args['meta_key']= '_sendpress_subject';
}
if($orderby == 'lastsend'){
$args['orderby'] = 'meta_value';
$args['meta_key']= 'send_date';
}
}
$query2 = new WP_Query( $args );
$this->items = $query2->posts;
}
}