Edit File by line

<?php

[0] Fix | Delete

[1] Fix | Delete

namespace sgpbDataTable;

[2] Fix | Delete

[3] Fix | Delete

use sgpb\AdminHelper;

[4] Fix | Delete

use sgpb\SubscriptionPopup;

[5] Fix | Delete

require_once(dirname(__FILE__).'/ListTable.php');

[6] Fix | Delete

file_exists(SG_POPUP_CLASSES_POPUPS_PATH.'SubscriptionPopup.php') && require_once(SG_POPUP_CLASSES_POPUPS_PATH.'SubscriptionPopup.php');

[7] Fix | Delete

[8] Fix | Delete

class SGPBTable extends SGPBListTable

[9] Fix | Delete

{

[10] Fix | Delete

protected $id = '';

[11] Fix | Delete

protected $columns = array();

[12] Fix | Delete

protected $displayColumns = array();

[13] Fix | Delete

protected $sortableColumns = array();

[14] Fix | Delete

protected $tablename = '';

[15] Fix | Delete

protected $rowsPerPage = 10;

[16] Fix | Delete

protected $initialOrder = array();

[17] Fix | Delete

private $previewPopup = false;

[18] Fix | Delete

private $isVisibleExtraNav = true;

[19] Fix | Delete

[20] Fix | Delete

public function __construct($id, $popupPreviewId = false)

[21] Fix | Delete

{

[22] Fix | Delete

$this->id = $id;

[23] Fix | Delete

$this->previewPopup = $popupPreviewId;

[24] Fix | Delete

parent::__construct(array(

[25] Fix | Delete

'singular'=> 'wp_'.$id, //singular label

[26] Fix | Delete

'plural' => 'wp_'.$id.'s', //plural label

[27] Fix | Delete

'ajax' => false

[28] Fix | Delete

));

[29] Fix | Delete

}

[30] Fix | Delete

[31] Fix | Delete

public function setId($id)

[32] Fix | Delete

{

[33] Fix | Delete

$this->id = $id;

[34] Fix | Delete

}

[35] Fix | Delete

[36] Fix | Delete

public function setRowsPerPage($rowsPerPage)

[37] Fix | Delete

{

[38] Fix | Delete

$this->rowsPerPage = $rowsPerPage;

[39] Fix | Delete

}

[40] Fix | Delete

[41] Fix | Delete

public function setColumns($columns)

[42] Fix | Delete

{

[43] Fix | Delete

$this->columns = $columns;

[44] Fix | Delete

}

[45] Fix | Delete

[46] Fix | Delete

public function getColumns()

[47] Fix | Delete

{

[48] Fix | Delete

return $this->columns;

[49] Fix | Delete

}

[50] Fix | Delete

[51] Fix | Delete

public function setDisplayColumns($displayColumns)

[52] Fix | Delete

{

[53] Fix | Delete

$this->displayColumns = $displayColumns;

[54] Fix | Delete

}

[55] Fix | Delete

[56] Fix | Delete

public function setSortableColumns($sortableColumns)

[57] Fix | Delete

{

[58] Fix | Delete

$this->sortableColumns = $sortableColumns;

[59] Fix | Delete

}

[60] Fix | Delete

[61] Fix | Delete

public function setTablename($tablename)

[62] Fix | Delete

{

[63] Fix | Delete

$this->tablename = $tablename;

[64] Fix | Delete

}

[65] Fix | Delete

[66] Fix | Delete

public function setInitialSort($orderableColumns)

[67] Fix | Delete

{

[68] Fix | Delete

$this->initialOrder = $orderableColumns;

[69] Fix | Delete

}

[70] Fix | Delete

[71] Fix | Delete

public function get_columns()

[72] Fix | Delete

{

[73] Fix | Delete

return $this->displayColumns;

[74] Fix | Delete

}

[75] Fix | Delete

[76] Fix | Delete

public function setIsVisibleExtraNav($isVisibleExtraNav)

[77] Fix | Delete

{

[78] Fix | Delete

$this->isVisibleExtraNav = $isVisibleExtraNav;

[79] Fix | Delete

}

[80] Fix | Delete

[81] Fix | Delete

public function getIsVisibleExtraNav()

[82] Fix | Delete

{

[83] Fix | Delete

return $this->isVisibleExtraNav;

[84] Fix | Delete

}

[85] Fix | Delete

[86] Fix | Delete

public function getNavPopupsConditions()

[87] Fix | Delete

{

[88] Fix | Delete

return '';

[89] Fix | Delete

}

[90] Fix | Delete

[91] Fix | Delete

public function prepare_items()

[92] Fix | Delete

{

[93] Fix | Delete

global $wpdb;

[94] Fix | Delete

[95] Fix | Delete

$table = $this->tablename;

[96] Fix | Delete

[97] Fix | Delete

$columns_name_placeholders = implode( ', ', array_fill( 0, count( $this->columns ), '%i' ) );

[98] Fix | Delete

[99] Fix | Delete

$query = $wpdb->prepare( "SELECT $table.$columns_name_placeholders FROM `$table`", str_replace( $table.'.', '', $this->columns ) );

[100] Fix | Delete

[101] Fix | Delete

$totalItems = count( $wpdb->get_results( $wpdb->prepare( "SELECT $table.$columns_name_placeholders FROM `$table`", str_replace( $table.'.', '', $this->columns ) ) ) ); //return the total number of affected rows

[102] Fix | Delete

[103] Fix | Delete

if ($this->previewPopup) {

[104] Fix | Delete

$totalItems -= 1;

[105] Fix | Delete

}

[106] Fix | Delete

$perPage = $this->rowsPerPage;

[107] Fix | Delete

[108] Fix | Delete

$totalPages = ceil($totalItems/$perPage);

[109] Fix | Delete

[110] Fix | Delete

$orderby = isset($_GET['orderby']) ? sanitize_sql_orderby($_GET['orderby']) : 'ASC';

[111] Fix | Delete

$order = isset($_GET['order']) ? sanitize_sql_orderby($_GET['order']) : '';

[112] Fix | Delete

[113] Fix | Delete

if (isset($this->initialOrder) && empty($order)) {

[114] Fix | Delete

foreach ($this->initialOrder as $key => $value) {

[115] Fix | Delete

$order = $value;

[116] Fix | Delete

$orderby = $key;

[117] Fix | Delete

}

[118] Fix | Delete

}

[119] Fix | Delete

[120] Fix | Delete

if (!empty($orderby) && !empty($order)) {

[121] Fix | Delete

$query .= ' ORDER BY '.$orderby.' '.$order;

[122] Fix | Delete

}

[123] Fix | Delete

$this->set_pagination_args(array(

[124] Fix | Delete

"total_items" => $totalItems,

[125] Fix | Delete

"total_pages" => $totalPages,

[126] Fix | Delete

"per_page" => $perPage,

[127] Fix | Delete

));

[128] Fix | Delete

$paged = $this->get_pagenum();

[129] Fix | Delete

[130] Fix | Delete

if (empty($paged) || !is_numeric($paged) || $paged <= 0) {

[131] Fix | Delete

$paged = 1;

[132] Fix | Delete

}

[133] Fix | Delete

[134] Fix | Delete

//adjust the query to take pagination into account

[135] Fix | Delete

if (!empty($paged) && !empty($perPage)) {

[136] Fix | Delete

$offset = ($paged - 1) * $perPage;

[137] Fix | Delete

$query .= ' LIMIT '.(int)$offset.','.(int)$perPage;

[138] Fix | Delete

}

[139] Fix | Delete

[140] Fix | Delete

$columns = $this->get_columns();

[141] Fix | Delete

$hidden = array();

[142] Fix | Delete

$sortable = $this->get_sortable_columns();

[143] Fix | Delete

$this->_column_headers = array($columns, $hidden, $sortable);

[144] Fix | Delete

// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- No applicable variables for this query.

[145] Fix | Delete

$items = $wpdb->get_results( $query, ARRAY_N);

[146] Fix | Delete

/*Remove popup data when its class does not exist.*/

[147] Fix | Delete

$this->customizeRowsData($items);

[148] Fix | Delete

[149] Fix | Delete

$this->items = $items;

[150] Fix | Delete

}

[151] Fix | Delete

[152] Fix | Delete

public function customizeRowsData(&$items) {

[153] Fix | Delete

[154] Fix | Delete

}

[155] Fix | Delete

[156] Fix | Delete

public function get_sortable_columns() {

[157] Fix | Delete

return $this->sortableColumns;

[158] Fix | Delete

}

[159] Fix | Delete

[160] Fix | Delete

public function display_rows()

[161] Fix | Delete

{

[162] Fix | Delete

//get the records registered in the prepare_items method

[163] Fix | Delete

$records = $this->items;

[164] Fix | Delete

[165] Fix | Delete

//get the columns registered in the get_columns and get_sortable_columns methods

[166] Fix | Delete

list($columns, $hidden) = $this->get_column_info();

[167] Fix | Delete

[168] Fix | Delete

foreach($records as $key => $rec) {

[169] Fix | Delete

echo '<tr>';

[170] Fix | Delete

[171] Fix | Delete

$this->customizeRow($rec);

[172] Fix | Delete

[173] Fix | Delete

foreach ($rec as $k => $item) {

[174] Fix | Delete

if (0 === $k) {

[175] Fix | Delete

echo '<th scope="row" class="check-column">'.wp_kses($item, AdminHelper::allowed_html_tags()).'</th>';

[176] Fix | Delete

} else {

[177] Fix | Delete

echo '<td>'.wp_kses($item, AdminHelper::allowed_html_tags()).'</td>';

[178] Fix | Delete

}

[179] Fix | Delete

}

[180] Fix | Delete

echo '</tr>';

[181] Fix | Delete

}

[182] Fix | Delete

}

[183] Fix | Delete

[184] Fix | Delete

public function customizeRow(&$row)

[185] Fix | Delete

{

[186] Fix | Delete

[187] Fix | Delete

}

[188] Fix | Delete

[189] Fix | Delete

public function customizeQuery(&$query)

[190] Fix | Delete

{

[191] Fix | Delete

[192] Fix | Delete

}

[193] Fix | Delete

[194] Fix | Delete

public function __toString()

[195] Fix | Delete

{

[196] Fix | Delete

$this->prepare_items(); ?>

[197] Fix | Delete

[198] Fix | Delete

[199] Fix | Delete

[200] Fix | Delete

<?php $this->search_box('search', $this->id); ?>

[201] Fix | Delete

</p>

[202] Fix | Delete

<?php $this->display();?>

[203] Fix | Delete

</form>

[204] Fix | Delete

<?php

[205] Fix | Delete

return '';

[206] Fix | Delete

}

[207] Fix | Delete

[208] Fix | Delete

// parent class method overriding

[209] Fix | Delete

public function extra_tablenav($which)

[210] Fix | Delete

{

[211] Fix | Delete

$isVisibleExtraNav = $this->getIsVisibleExtraNav();

[212] Fix | Delete

[213] Fix | Delete

if (!$isVisibleExtraNav) {

[214] Fix | Delete

return '';

[215] Fix | Delete

}

[216] Fix | Delete

[217] Fix | Delete

[218] Fix | Delete

[219] Fix | Delete

<?php echo wp_kses($this->getNavPopupsConditions(), AdminHelper::allowed_html_tags()); ?>

[220] Fix | Delete

[221] Fix | Delete

[222] Fix | Delete

<?php echo wp_kses($this->getNavDateConditions(), AdminHelper::allowed_html_tags()); ?>

[223] Fix | Delete

[224] Fix | Delete

<input name="filter_action" id="post-query-submit" class="button" value="<?php esc_html_e('Filter', 'popup-builder')?>" type="submit">

[225] Fix | Delete

</div>

[226] Fix | Delete

<?php

[227] Fix | Delete

}

[228] Fix | Delete

[229] Fix | Delete

public function search_box( $text, $input_id ) {

[230] Fix | Delete

if ( empty( $_REQUEST['s'] ) && !$this->has_items() )

[231] Fix | Delete

return;

[232] Fix | Delete

$input_id = $input_id . '-search-input';

[233] Fix | Delete

[234] Fix | Delete

if ( ! empty( $_REQUEST['orderby'] ) )

[235] Fix | Delete

echo '<input type="hidden" name="orderby" value="' . esc_attr( sanitize_text_field($_REQUEST['orderby']) ) . '" />';

[236] Fix | Delete

if ( ! empty( $_REQUEST['order'] ) )

[237] Fix | Delete

echo '<input type="hidden" name="order" value="' . esc_attr( sanitize_text_field($_REQUEST['order']) ) . '" />';

[238] Fix | Delete

if ( ! empty( $_REQUEST['post_mime_type'] ) )

[239] Fix | Delete

echo '<input type="hidden" name="post_mime_type" value="' . esc_attr( sanitize_text_field($_REQUEST['post_mime_type']) ) . '" />';

[240] Fix | Delete

if ( ! empty( $_REQUEST['detached'] ) )

[241] Fix | Delete

echo '<input type="hidden" name="detached" value="' . esc_attr( sanitize_text_field($_REQUEST['detached']) ) . '" />';

[242] Fix | Delete

[243] Fix | Delete

[244] Fix | Delete

<input type="search" class="search__input" id="<?php echo esc_attr($input_id) ?>" name="s" value="<?php _admin_search_query(); ?>" />

[245] Fix | Delete

<div>

[246] Fix | Delete

<?php submit_button($text, 'search__button', '', false, array('id' => 'search-submit')); ?>

[247] Fix | Delete

</div>

[248] Fix | Delete

</div>

[249] Fix | Delete

<?php

[250] Fix | Delete

}

[251] Fix | Delete

[252] Fix | Delete

public function display() {

[253] Fix | Delete

$singular = $this->_args['singular'];

[254] Fix | Delete

[255] Fix | Delete

$this->display_tablenav( 'top' );

[256] Fix | Delete

[257] Fix | Delete

<table class="table sgpb-table <?php echo esc_attr(implode( ' ', $this->get_table_classes() )); ?>">

[258] Fix | Delete

[259] Fix | Delete

<tr>

[260] Fix | Delete

<?php $this->print_column_headers(); ?>

[261] Fix | Delete

</tr>

[262] Fix | Delete

</thead>

[263] Fix | Delete

[264] Fix | Delete

<tbody class='sgpb-table-body'<?php

[265] Fix | Delete

if ( $singular ) {

[266] Fix | Delete

echo esc_attr(" data-wp-lists='list:$singular'");

[267] Fix | Delete

} ?>>

[268] Fix | Delete

<?php $this->display_rows_or_placeholder(); ?>

[269] Fix | Delete

</tbody>

[270] Fix | Delete

<!-- <div class="table__row">

[271] Fix | Delete

<?php /*$this->print_column_headers(); */?>

[272] Fix | Delete

</div>-->

[273] Fix | Delete

[274] Fix | Delete

</table>

[275] Fix | Delete

<?php

[276] Fix | Delete

$this->display_tablenav( 'bottom' );

[277] Fix | Delete

}

[278] Fix | Delete

[279] Fix | Delete

public function display_rows_or_placeholder() {

[280] Fix | Delete

if ( $this->has_items() ) {

[281] Fix | Delete

$this->display_rows();

[282] Fix | Delete

} else {

[283] Fix | Delete

echo '<tr class="no-items"><td class="colspanchange" colspan="' . esc_attr($this->get_column_count()) . '">';

[284] Fix | Delete

$this->no_items();

[285] Fix | Delete

echo '</td></tr>';

[286] Fix | Delete

}

[287] Fix | Delete

}

[288] Fix | Delete

[289] Fix | Delete

public function no_items() {

[290] Fix | Delete

esc_html_e( 'No items found.' );

[291] Fix | Delete

}

[292] Fix | Delete

[293] Fix | Delete

public function has_items() {

[294] Fix | Delete

return !empty( $this->items );

[295] Fix | Delete

}

[296] Fix | Delete

[297] Fix | Delete

public function print_column_headers( $with_id = true ) {

[298] Fix | Delete

list( $columns, $hidden, $sortable, $primary ) = $this->get_column_info();

[299] Fix | Delete

// phpcs:ignore WordPress.Security.ValidatedSanitizedInput.InputNotSanitized,WordPress.Security.ValidatedSanitizedInput.InputNotValidated

[300] Fix | Delete

$sbpb_server_host = isset($_SERVER['HTTP_HOST']) ? sanitize_text_field( $_SERVER['HTTP_HOST'] ) : '';

[301] Fix | Delete

$sbpb_server_requesturi = isset($_SERVER['REQUEST_URI']) ? sanitize_text_field( $_SERVER['REQUEST_URI'] ) : '';

[302] Fix | Delete

$current_url = set_url_scheme( 'http://' . $sbpb_server_host. $sbpb_server_requesturi );

[303] Fix | Delete

$current_url = remove_query_arg( 'paged', $current_url );

[304] Fix | Delete

[305] Fix | Delete

if ( isset( $_GET['orderby'] ) )

[306] Fix | Delete

$current_orderby = sanitize_text_field($_GET['orderby']);

[307] Fix | Delete

else

[308] Fix | Delete

$current_orderby = '';

[309] Fix | Delete

[310] Fix | Delete

if ( isset( $_GET['order'] ) && 'desc' == $_GET['order'] )

[311] Fix | Delete

$current_order = 'desc';

[312] Fix | Delete

else

[313] Fix | Delete

$current_order = 'asc';

[314] Fix | Delete

[315] Fix | Delete

/* TODO check this part of code in each imported table file */

[316] Fix | Delete

/*if ( ! empty( $columns['bulk'] ) ) {

[317] Fix | Delete

static $cb_counter = 1;

[318] Fix | Delete

$columns['bulk'] = '<label class="screen-reader-text" for="cb-select-all-' . $cb_counter . '">' . __( 'Select All' ) . '</label>'

[319] Fix | Delete

. '<input id="cb-select-all-' . $cb_counter . '" type="checkbox" />';

[320] Fix | Delete

$cb_counter++;

[321] Fix | Delete

}*/

[322] Fix | Delete

[323] Fix | Delete

foreach ( $columns as $column_key => $column_display_name ) {

[324] Fix | Delete

$class = array( 'manage-column', "column-$column_key", 'table__head' );

[325] Fix | Delete

if ( in_array( $column_key, $hidden ) ) {

[326] Fix | Delete

$class[] = 'hidden';

[327] Fix | Delete

}

[328] Fix | Delete

[329] Fix | Delete

if ( 'bulk' == $column_key )

[330] Fix | Delete

$class[] = 'check-column';

[331] Fix | Delete

elseif ( in_array( $column_key, array( 'posts', 'comments', 'links' ) ) )

[332] Fix | Delete

$class[] = 'num';

[333] Fix | Delete

[334] Fix | Delete

if ( $column_key === $primary ) {

[335] Fix | Delete

$class[] = 'column-primary';

[336] Fix | Delete

}

[337] Fix | Delete

[338] Fix | Delete

if ( isset( $sortable[$column_key] ) ) {

[339] Fix | Delete

list( $orderby, $desc_first ) = $sortable[$column_key];

[340] Fix | Delete

[341] Fix | Delete

if ( $current_orderby == $orderby ) {

[342] Fix | Delete

$order = 'asc' == $current_order ? 'desc' : 'asc';

[343] Fix | Delete

$class[] = 'sorted';

[344] Fix | Delete

$class[] = $current_order;

[345] Fix | Delete

} else {

[346] Fix | Delete

$order = $desc_first ? 'desc' : 'asc';

[347] Fix | Delete

$class[] = 'sortable';

[348] Fix | Delete

$class[] = $desc_first ? 'asc' : 'desc';

[349] Fix | Delete

}

[350] Fix | Delete

[351] Fix | Delete

$column_display_name = '<a href="' . esc_url( add_query_arg( compact( 'orderby', 'order' ), $current_url ) ) . '"><span>' . $column_display_name . '</span><span class="sorting-indicator352"></span></a>';

[352] Fix | Delete

}

[353] Fix | Delete

[354] Fix | Delete

$tag = ( 'bulk' === $column_key ) ? 'td' : 'th';

[355] Fix | Delete

[356] Fix | Delete

$scope = ( 'th' === $tag ) ? 'scope="col"' : '';

[357] Fix | Delete

$id = $with_id ? "id='$column_key'" : '';

[358] Fix | Delete

[359] Fix | Delete

if ( !empty( $class ) )

[360] Fix | Delete

$class = "class='" . join( ' ', $class ) . "'";

[361] Fix | Delete

echo wp_kses("<$tag $scope $id $class>$column_display_name</$tag>", AdminHelper::allowed_html_tags());

[362] Fix | Delete

}

[363] Fix | Delete

}

[364] Fix | Delete

[365] Fix | Delete

}

[366] Fix | Delete

[367] Fix | Delete