|
@@ 260-293 (lines=34) @@
|
| 257 |
|
|
| 258 |
|
} |
| 259 |
|
|
| 260 |
|
if ( ! empty( $args['search'] ) ) { |
| 261 |
|
|
| 262 |
|
if( false !== strpos( 'id:', $args['search'] ) ) { |
| 263 |
|
|
| 264 |
|
$args['search'] = trim( str_replace( 'id:', '', $args['search'] ) ); |
| 265 |
|
$where .= " AND `id` = '" . esc_sql( $args['search'] ) . "'"; |
| 266 |
|
|
| 267 |
|
} else if( false !== strpos( $args['search'], 'txn:' ) ) { |
| 268 |
|
|
| 269 |
|
$args['search'] = trim( str_replace( 'txn:', '', $args['search'] ) ); |
| 270 |
|
$where .= " AND `transaction_id` = '" . esc_sql( $args['search'] ) . "'"; |
| 271 |
|
|
| 272 |
|
} else if( false !== strpos( $args['search'], 'profile_id:' ) ) { |
| 273 |
|
|
| 274 |
|
$args['search'] = trim( str_replace( 'profile_id:', '', $args['search'] ) ); |
| 275 |
|
$where .= " AND `profile_id` = '" . esc_sql( $args['search'] ) . "'"; |
| 276 |
|
|
| 277 |
|
} else if( false !== strpos( $args['search'], 'product_id:' ) ) { |
| 278 |
|
|
| 279 |
|
$args['search'] = trim( str_replace( 'product_id:', '', $args['search'] ) ); |
| 280 |
|
$where .= " AND `product_id` = '" . esc_sql( $args['search'] ) . "'"; |
| 281 |
|
|
| 282 |
|
} else if( false !== strpos( $args['search'], 'customer_id:' ) ) { |
| 283 |
|
|
| 284 |
|
$args['search'] = trim( str_replace( 'customer_id:', '', $args['search'] ) ); |
| 285 |
|
$where .= " AND `customer_id` = '" . esc_sql( $args['search'] ) . "'"; |
| 286 |
|
|
| 287 |
|
} else { |
| 288 |
|
|
| 289 |
|
$where .= " AND ( `parent_payment_id` LIKE '%%" . esc_sql( $args['search'] ) . "%%' OR `profile_id` LIKE '%%" . esc_sql( $args['search'] ) . "%%' OR `transaction_id` LIKE '%%" . esc_sql( $args['search'] ) . "%%' OR `product_id` LIKE '%%" . esc_sql( $args['search'] ) . "%%' OR `id` = '" . esc_sql( $args['search'] ) . "' )"; |
| 290 |
|
|
| 291 |
|
} |
| 292 |
|
|
| 293 |
|
} |
| 294 |
|
|
| 295 |
|
$args['orderby'] = ! array_key_exists( $args['orderby'], $this->get_columns() ) ? 'id' : $args['orderby']; |
| 296 |
|
|
|
@@ 495-528 (lines=34) @@
|
| 492 |
|
|
| 493 |
|
} |
| 494 |
|
|
| 495 |
|
if ( ! empty( $args['search'] ) ) { |
| 496 |
|
|
| 497 |
|
if( false !== strpos( 'id:', $args['search'] ) ) { |
| 498 |
|
|
| 499 |
|
$args['search'] = trim( str_replace( 'id:', '', $args['search'] ) ); |
| 500 |
|
$where .= " AND `id` = '" . esc_sql( $args['search'] ) . "'"; |
| 501 |
|
|
| 502 |
|
} else if( false !== strpos( $args['search'], 'txn:' ) ) { |
| 503 |
|
|
| 504 |
|
$args['search'] = trim( str_replace( 'txn:', '', $args['search'] ) ); |
| 505 |
|
$where .= " AND `transaction_id` = '" . esc_sql( $args['search'] ) . "'"; |
| 506 |
|
|
| 507 |
|
} else if( false !== strpos( $args['search'], 'profile_id:' ) ) { |
| 508 |
|
|
| 509 |
|
$args['search'] = trim( str_replace( 'profile_id:', '', $args['search'] ) ); |
| 510 |
|
$where .= " AND `profile_id` = '" . esc_sql( $args['search'] ) . "'"; |
| 511 |
|
|
| 512 |
|
} else if( false !== strpos( $args['search'], 'product_id:' ) ) { |
| 513 |
|
|
| 514 |
|
$args['search'] = trim( str_replace( 'product_id:', '', $args['search'] ) ); |
| 515 |
|
$where .= " AND `product_id` = '" . esc_sql( $args['search'] ) . "'"; |
| 516 |
|
|
| 517 |
|
} else if( false !== strpos( $args['search'], 'customer_id:' ) ) { |
| 518 |
|
|
| 519 |
|
$args['search'] = trim( str_replace( 'customer_id:', '', $args['search'] ) ); |
| 520 |
|
$where .= " AND `customer_id` = '" . esc_sql( $args['search'] ) . "'"; |
| 521 |
|
|
| 522 |
|
} else { |
| 523 |
|
|
| 524 |
|
$where .= " AND ( `parent_payment_id` LIKE '%%" . esc_sql( $args['search'] ) . "%%' OR `profile_id` LIKE '%%" . esc_sql( $args['search'] ) . "%%' OR `transaction_id` LIKE '%%" . esc_sql( $args['search'] ) . "%%' OR `product_id` LIKE '%%" . esc_sql( $args['search'] ) . "%%' OR `id` = '" . esc_sql( $args['search'] ) . "' )"; |
| 525 |
|
|
| 526 |
|
} |
| 527 |
|
|
| 528 |
|
} |
| 529 |
|
|
| 530 |
|
$cache_key = md5( 'wpinv_subscriptions_count' . serialize( $args ) ); |
| 531 |
|
|
AyeCode /
invoicing
