AyeCode /
invoicing
@@ -1,10 +1,10 @@ |
||
| 1 | 1 | <?php |
| 2 | 2 | // don't load directly |
| 3 | -if ( !defined('ABSPATH') ) |
|
| 3 | +if (!defined('ABSPATH')) |
|
| 4 | 4 | die('-1'); |
| 5 | 5 | |
| 6 | -$email_footer = apply_filters( 'wpinv_email_footer_text', wpinv_get_option( 'email_footer_text' ) ); |
|
| 7 | -$email_footer = $email_footer ? wpautop( wp_kses_post( wptexturize( $email_footer ) ) ) : ''; |
|
| 6 | +$email_footer = apply_filters('wpinv_email_footer_text', wpinv_get_option('email_footer_text')); |
|
| 7 | +$email_footer = $email_footer ? wpautop(wp_kses_post(wptexturize($email_footer))) : ''; |
|
| 8 | 8 | ?> |
| 9 | 9 | </div> |
| 10 | 10 | </td> |
@@ -1,16 +1,16 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | // don't load directly |
| 3 | -if ( !defined('ABSPATH') ) |
|
| 3 | +if (!defined('ABSPATH')) |
|
| 4 | 4 | die('-1'); |
| 5 | 5 | |
| 6 | -if ( !isset( $email_heading ) ) { |
|
| 6 | +if (!isset($email_heading)) { |
|
| 7 | 7 | global $email_heading; |
| 8 | 8 | } |
| 9 | 9 | ?> |
| 10 | 10 | <!DOCTYPE html> |
| 11 | 11 | <html dir="<?php echo is_rtl() ? 'rtl' : 'ltr'?>"> |
| 12 | 12 | <head> |
| 13 | - <meta http-equiv="Content-Type" content="text/html; charset=<?php bloginfo( 'charset' ); ?>" /> |
|
| 13 | + <meta http-equiv="Content-Type" content="text/html; charset=<?php bloginfo('charset'); ?>" /> |
|
| 14 | 14 | <meta name="viewport" content="width=device-width, initial-scale=1"> |
| 15 | 15 | <meta name="robots" content="noindex,nofollow"> |
| 16 | 16 | <title><?php echo wpinv_get_blogname(); ?></title> |
@@ -22,13 +22,13 @@ discard block |
||
| 22 | 22 | <td align="center" valign="top"> |
| 23 | 23 | <div id="template_header_image"> |
| 24 | 24 | <?php |
| 25 | - if ( $img = wpinv_get_option( 'email_header_image' ) ) { |
|
| 26 | - echo '<p style="margin-top:0;"><img style="max-width:100%" src="' . esc_url( $img ) . '" alt="' . esc_attr( wpinv_get_blogname() ) . '" /></p>'; |
|
| 25 | + if ($img = wpinv_get_option('email_header_image')) { |
|
| 26 | + echo '<p style="margin-top:0;"><img style="max-width:100%" src="' . esc_url($img) . '" alt="' . esc_attr(wpinv_get_blogname()) . '" /></p>'; |
|
| 27 | 27 | } |
| 28 | 28 | ?> |
| 29 | 29 | </div> |
| 30 | 30 | <table border="0" cellpadding="0" cellspacing="0" width="100%" id="template_container"> |
| 31 | - <?php if ( !empty( $email_heading ) ) { ?> |
|
| 31 | + <?php if (!empty($email_heading)) { ?> |
|
| 32 | 32 | <tr> |
| 33 | 33 | <td align="center" valign="top"> |
| 34 | 34 | <!-- Header --> |
@@ -130,7 +130,6 @@ |
||
| 130 | 130 | private function mostSpecificSubdivision() |
| 131 | 131 | { |
| 132 | 132 | return empty($this->subdivisions) ? |
| 133 | - new \GeoIp2\Record\Subdivision(array(), $this->locales) : |
|
| 134 | - end($this->subdivisions); |
|
| 133 | + new \GeoIp2\Record\Subdivision(array(), $this->locales) : end($this->subdivisions); |
|
| 135 | 134 | } |
| 136 | 135 | } |
@@ -76,7 +76,7 @@ |
||
| 76 | 76 | // This is for backwards compatibility. Do not remove except for a |
| 77 | 77 | // major version bump. |
| 78 | 78 | if (is_string($options)) { |
| 79 | - $options = array( 'host' => $options ); |
|
| 79 | + $options = array('host' => $options); |
|
| 80 | 80 | } |
| 81 | 81 | |
| 82 | 82 | if (!isset($options['host'])) { |
@@ -238,7 +238,7 @@ discard block |
||
| 238 | 238 | if ($nodesWithStyleAttributes !== false) { |
| 239 | 239 | /** @var $nodeWithStyleAttribute DOMNode */ |
| 240 | 240 | foreach ($nodesWithStyleAttributes as $node) { |
| 241 | - $normalizedOriginalStyle = preg_replace_callback( '/[A-z\\-]+(?=\\:)/S', array( $this, 'strtolower' ), $node->getAttribute('style') ); |
|
| 241 | + $normalizedOriginalStyle = preg_replace_callback('/[A-z\\-]+(?=\\:)/S', array($this, 'strtolower'), $node->getAttribute('style')); |
|
| 242 | 242 | |
| 243 | 243 | // in order to not overwrite existing style attributes in the HTML, we have to save the original HTML styles |
| 244 | 244 | $nodePath = $node->getNodePath(); |
@@ -289,7 +289,7 @@ discard block |
||
| 289 | 289 | } |
| 290 | 290 | |
| 291 | 291 | // now sort the selectors by precedence |
| 292 | - usort($allSelectors, array($this,'sortBySelectorPrecedence')); |
|
| 292 | + usort($allSelectors, array($this, 'sortBySelectorPrecedence')); |
|
| 293 | 293 | |
| 294 | 294 | $this->caches[self::CACHE_KEY_CSS][$cssKey] = $allSelectors; |
| 295 | 295 | } |
@@ -329,7 +329,7 @@ discard block |
||
| 329 | 329 | if ($nodesWithStyleDisplayNone->length > 0) { |
| 330 | 330 | /** @var $node \DOMNode */ |
| 331 | 331 | foreach ($nodesWithStyleDisplayNone as $node) { |
| 332 | - if ($node->parentNode && is_callable(array($node->parentNode,'removeChild'))) { |
|
| 332 | + if ($node->parentNode && is_callable(array($node->parentNode, 'removeChild'))) { |
|
| 333 | 333 | $node->parentNode->removeChild($node); |
| 334 | 334 | } |
| 335 | 335 | } |
@@ -338,10 +338,10 @@ discard block |
||
| 338 | 338 | $this->copyCssWithMediaToStyleNode($cssParts, $xmlDocument); |
| 339 | 339 | |
| 340 | 340 | if ($this->preserveEncoding) { |
| 341 | - if ( function_exists( 'mb_convert_encoding' ) ) { |
|
| 342 | - return mb_convert_encoding( $xmlDocument->saveHTML(), self::ENCODING, 'HTML-ENTITIES' ); |
|
| 341 | + if (function_exists('mb_convert_encoding')) { |
|
| 342 | + return mb_convert_encoding($xmlDocument->saveHTML(), self::ENCODING, 'HTML-ENTITIES'); |
|
| 343 | 343 | } else { |
| 344 | - return htmlspecialchars_decode( utf8_encode( html_entity_decode( $xmlDocument->saveHTML(), ENT_COMPAT, self::ENCODING ) ) ); |
|
| 344 | + return htmlspecialchars_decode(utf8_encode(html_entity_decode($xmlDocument->saveHTML(), ENT_COMPAT, self::ENCODING))); |
|
| 345 | 345 | } |
| 346 | 346 | } else { |
| 347 | 347 | return $xmlDocument->saveHTML(); |
@@ -462,7 +462,7 @@ discard block |
||
| 462 | 462 | * @return array |
| 463 | 463 | */ |
| 464 | 464 | private function splitCssAndMediaQuery($css) { |
| 465 | - $css = preg_replace_callback( '#@media\\s+(?:only\\s)?(?:[\\s{\(]|screen|all)\\s?[^{]+{.*}\\s*}\\s*#misU', array( $this, '_media_concat' ), $css ); |
|
| 465 | + $css = preg_replace_callback('#@media\\s+(?:only\\s)?(?:[\\s{\(]|screen|all)\\s?[^{]+{.*}\\s*}\\s*#misU', array($this, '_media_concat'), $css); |
|
| 466 | 466 | |
| 467 | 467 | // filter the CSS |
| 468 | 468 | $search = array( |
@@ -486,7 +486,7 @@ discard block |
||
| 486 | 486 | return array('css' => $css, 'media' => self::$_media); |
| 487 | 487 | } |
| 488 | 488 | |
| 489 | - private function _media_concat( $matches ) { |
|
| 489 | + private function _media_concat($matches) { |
|
| 490 | 490 | self::$_media .= $matches[0]; |
| 491 | 491 | } |
| 492 | 492 | |
@@ -524,10 +524,10 @@ discard block |
||
| 524 | 524 | $bodyWithoutUnprocessableTags = $this->html; |
| 525 | 525 | } |
| 526 | 526 | |
| 527 | - if ( function_exists( 'mb_convert_encoding' ) ) { |
|
| 528 | - return mb_convert_encoding( $bodyWithoutUnprocessableTags, 'HTML-ENTITIES', self::ENCODING ); |
|
| 527 | + if (function_exists('mb_convert_encoding')) { |
|
| 528 | + return mb_convert_encoding($bodyWithoutUnprocessableTags, 'HTML-ENTITIES', self::ENCODING); |
|
| 529 | 529 | } else { |
| 530 | - return htmlspecialchars_decode( utf8_decode( htmlentities( $bodyWithoutUnprocessableTags, ENT_COMPAT, self::ENCODING, false ) ) ); |
|
| 530 | + return htmlspecialchars_decode(utf8_decode(htmlentities($bodyWithoutUnprocessableTags, ENT_COMPAT, self::ENCODING, false))); |
|
| 531 | 531 | } |
| 532 | 532 | } |
| 533 | 533 | |
@@ -562,7 +562,7 @@ discard block |
||
| 562 | 562 | $precedence = 0; |
| 563 | 563 | $value = 100; |
| 564 | 564 | // ids: worth 100, classes: worth 10, elements: worth 1 |
| 565 | - $search = array('\\#','\\.',''); |
|
| 565 | + $search = array('\\#', '\\.', ''); |
|
| 566 | 566 | |
| 567 | 567 | foreach ($search as $s) { |
| 568 | 568 | if (trim($selector == '')) { |
@@ -590,7 +590,7 @@ discard block |
||
| 590 | 590 | */ |
| 591 | 591 | private function translateCssToXpath($paramCssSelector) { |
| 592 | 592 | $cssSelector = ' ' . $paramCssSelector . ' '; |
| 593 | - $cssSelector = preg_replace_callback( '/\s+\w+\s+/', array( $this, 'strtolower' ), $cssSelector ); |
|
| 593 | + $cssSelector = preg_replace_callback('/\s+\w+\s+/', array($this, 'strtolower'), $cssSelector); |
|
| 594 | 594 | $cssSelector = trim($cssSelector); |
| 595 | 595 | $xpathKey = md5($cssSelector); |
| 596 | 596 | if (!isset($this->caches[self::CACHE_KEY_XPATH][$xpathKey])) { |
@@ -713,7 +713,7 @@ discard block |
||
| 713 | 713 | * @return array |
| 714 | 714 | */ |
| 715 | 715 | private function parseNth(array $match) { |
| 716 | - if (in_array(strtolower($match[2]), array('even','odd'))) { |
|
| 716 | + if (in_array(strtolower($match[2]), array('even', 'odd'))) { |
|
| 717 | 717 | $index = strtolower($match[2]) == 'even' ? 0 : 1; |
| 718 | 718 | return array(self::MULTIPLIER => 2, self::INDEX => $index); |
| 719 | 719 | } elseif (stripos($match[2], 'n') === false) { |
@@ -1,56 +1,56 @@ |
||
| 1 | 1 | <?php |
| 2 | -if ( !defined('ABSPATH') ) { |
|
| 2 | +if (!defined('ABSPATH')) { |
|
| 3 | 3 | exit; |
| 4 | 4 | } |
| 5 | -do_action( 'wpinv_invalid_invoice_before_display' ); ?><!DOCTYPE html> |
|
| 5 | +do_action('wpinv_invalid_invoice_before_display'); ?><!DOCTYPE html> |
|
| 6 | 6 | <html <?php language_attributes(); ?>> |
| 7 | 7 | <head> |
| 8 | 8 | <meta charset="UTF-8"> |
| 9 | 9 | <title><?php wp_title() ?></title> |
| 10 | - <meta charset="<?php bloginfo( 'charset' ); ?>" /> |
|
| 10 | + <meta charset="<?php bloginfo('charset'); ?>" /> |
|
| 11 | 11 | <meta name="viewport" content="width=device-width,initial-scale=1"> |
| 12 | 12 | <meta name="robots" content="noindex,nofollow"> |
| 13 | - <?php do_action( 'wpinv_invalid_invoice_head' ); ?> |
|
| 13 | + <?php do_action('wpinv_invalid_invoice_head'); ?> |
|
| 14 | 14 | </head> |
| 15 | 15 | <body class="body wpinv wpinv-print wpinv-invalid-invoice"> |
| 16 | - <?php do_action( 'wpinv_invalid_invoice_body_start' ); ?> |
|
| 16 | + <?php do_action('wpinv_invalid_invoice_body_start'); ?> |
|
| 17 | 17 | <div class="container wpinv-wrap"> |
| 18 | 18 | <!-- ///// Start Header --> |
| 19 | 19 | <htmlpageheader name="wpinv-pdf-header"> |
| 20 | - <?php do_action( 'wpinv_invalid_invoice_before_header' ); ?> |
|
| 20 | + <?php do_action('wpinv_invalid_invoice_before_header'); ?> |
|
| 21 | 21 | <div class="row wpinv-header"> |
| 22 | 22 | <div class="col-xs-12 wpinv-business"> |
| 23 | - <a target="_blank" href="<?php echo esc_url( wpinv_get_business_website() ); ?>"> |
|
| 24 | - <?php if ( $logo = wpinv_get_business_logo() ) { ?> |
|
| 25 | - <img class="logo" src="<?php echo esc_url( $logo ); ?>"> |
|
| 23 | + <a target="_blank" href="<?php echo esc_url(wpinv_get_business_website()); ?>"> |
|
| 24 | + <?php if ($logo = wpinv_get_business_logo()) { ?> |
|
| 25 | + <img class="logo" src="<?php echo esc_url($logo); ?>"> |
|
| 26 | 26 | <?php } else { ?> |
| 27 | - <h1><?php echo esc_html( wpinv_get_business_name() ); ?></h1> |
|
| 27 | + <h1><?php echo esc_html(wpinv_get_business_name()); ?></h1> |
|
| 28 | 28 | <?php } ?> |
| 29 | 29 | </a> |
| 30 | 30 | </div> |
| 31 | 31 | </div> |
| 32 | - <?php do_action( 'wpinv_invalid_invoice_after_header' ); ?> |
|
| 32 | + <?php do_action('wpinv_invalid_invoice_after_header'); ?> |
|
| 33 | 33 | </htmlpageheader> |
| 34 | 34 | <!-- End Header ///// --> |
| 35 | 35 | |
| 36 | - <?php do_action( 'wpinv_invalid_invoice_before_content' ); ?> |
|
| 36 | + <?php do_action('wpinv_invalid_invoice_before_content'); ?> |
|
| 37 | 37 | |
| 38 | - <?php do_action( 'wpinv_invalid_invoice_content' ); ?> |
|
| 38 | + <?php do_action('wpinv_invalid_invoice_content'); ?> |
|
| 39 | 39 | |
| 40 | - <?php do_action( 'wpinv_invalid_invoice_after_content' ); ?> |
|
| 40 | + <?php do_action('wpinv_invalid_invoice_after_content'); ?> |
|
| 41 | 41 | |
| 42 | 42 | <!-- ///// Start Footer --> |
| 43 | 43 | <htmlpagefooter name="wpinv-pdf-footer"> |
| 44 | - <?php do_action( 'wpinv_invalid_invoice_before_footer' ); ?> |
|
| 44 | + <?php do_action('wpinv_invalid_invoice_before_footer'); ?> |
|
| 45 | 45 | <div class="row wpinv-footer"> |
| 46 | 46 | <div class="col-sm-12"> |
| 47 | 47 | <div class="footer-text"><?php echo wpinv_get_business_footer(); ?></div> |
| 48 | 48 | </div> |
| 49 | 49 | </div> |
| 50 | - <?php do_action( 'wpinv_invalid_invoice_after_footer' ); ?> |
|
| 50 | + <?php do_action('wpinv_invalid_invoice_after_footer'); ?> |
|
| 51 | 51 | </htmlpagefooter> |
| 52 | 52 | <!-- End Footer ///// --> |
| 53 | 53 | </div> |
| 54 | - <?php do_action( 'wpinv_invalid_invoice_body_end' ); ?> |
|
| 54 | + <?php do_action('wpinv_invalid_invoice_body_end'); ?> |
|
| 55 | 55 | </body> |
| 56 | 56 | </html> |
| 57 | 57 | \ No newline at end of file |
@@ -1,7 +1,7 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | 3 | // Exit if accessed directly |
| 4 | -if ( ! defined( 'ABSPATH' ) ) exit; |
|
| 4 | +if (!defined('ABSPATH')) exit; |
|
| 5 | 5 | |
| 6 | 6 | abstract class Wpinv_DB { |
| 7 | 7 | |
@@ -66,9 +66,9 @@ discard block |
||
| 66 | 66 | * @since 1.0.0 |
| 67 | 67 | * @return object |
| 68 | 68 | */ |
| 69 | - public function get( $row_id ) { |
|
| 69 | + public function get($row_id) { |
|
| 70 | 70 | global $wpdb; |
| 71 | - return $wpdb->get_row( $wpdb->prepare( "SELECT * FROM $this->table_name WHERE $this->primary_key = %s LIMIT 1;", $row_id ) ); |
|
| 71 | + return $wpdb->get_row($wpdb->prepare("SELECT * FROM $this->table_name WHERE $this->primary_key = %s LIMIT 1;", $row_id)); |
|
| 72 | 72 | } |
| 73 | 73 | |
| 74 | 74 | /** |
@@ -78,10 +78,10 @@ discard block |
||
| 78 | 78 | * @since 1.0.0 |
| 79 | 79 | * @return object |
| 80 | 80 | */ |
| 81 | - public function get_by( $column, $row_id ) { |
|
| 81 | + public function get_by($column, $row_id) { |
|
| 82 | 82 | global $wpdb; |
| 83 | - $column = esc_sql( $column ); |
|
| 84 | - return $wpdb->get_row( $wpdb->prepare( "SELECT * FROM $this->table_name WHERE $column = %s LIMIT 1;", $row_id ) ); |
|
| 83 | + $column = esc_sql($column); |
|
| 84 | + return $wpdb->get_row($wpdb->prepare("SELECT * FROM $this->table_name WHERE $column = %s LIMIT 1;", $row_id)); |
|
| 85 | 85 | } |
| 86 | 86 | |
| 87 | 87 | /** |
@@ -91,10 +91,10 @@ discard block |
||
| 91 | 91 | * @since 1.0.0 |
| 92 | 92 | * @return string |
| 93 | 93 | */ |
| 94 | - public function get_column( $column, $row_id ) { |
|
| 94 | + public function get_column($column, $row_id) { |
|
| 95 | 95 | global $wpdb; |
| 96 | - $column = esc_sql( $column ); |
|
| 97 | - return $wpdb->get_var( $wpdb->prepare( "SELECT $column FROM $this->table_name WHERE $this->primary_key = %s LIMIT 1;", $row_id ) ); |
|
| 96 | + $column = esc_sql($column); |
|
| 97 | + return $wpdb->get_var($wpdb->prepare("SELECT $column FROM $this->table_name WHERE $this->primary_key = %s LIMIT 1;", $row_id)); |
|
| 98 | 98 | } |
| 99 | 99 | |
| 100 | 100 | /** |
@@ -104,11 +104,11 @@ discard block |
||
| 104 | 104 | * @since 1.0.0 |
| 105 | 105 | * @return string |
| 106 | 106 | */ |
| 107 | - public function get_column_by( $column, $column_where, $column_value ) { |
|
| 107 | + public function get_column_by($column, $column_where, $column_value) { |
|
| 108 | 108 | global $wpdb; |
| 109 | - $column_where = esc_sql( $column_where ); |
|
| 110 | - $column = esc_sql( $column ); |
|
| 111 | - return $wpdb->get_var( $wpdb->prepare( "SELECT $column FROM $this->table_name WHERE $column_where = %s LIMIT 1;", $column_value ) ); |
|
| 109 | + $column_where = esc_sql($column_where); |
|
| 110 | + $column = esc_sql($column); |
|
| 111 | + return $wpdb->get_var($wpdb->prepare("SELECT $column FROM $this->table_name WHERE $column_where = %s LIMIT 1;", $column_value)); |
|
| 112 | 112 | } |
| 113 | 113 | |
| 114 | 114 | /** |
@@ -118,31 +118,31 @@ discard block |
||
| 118 | 118 | * @since 1.0.0 |
| 119 | 119 | * @return int |
| 120 | 120 | */ |
| 121 | - public function insert( $data, $type = '' ) { |
|
| 121 | + public function insert($data, $type = '') { |
|
| 122 | 122 | global $wpdb; |
| 123 | 123 | |
| 124 | 124 | // Set default values |
| 125 | - $data = wp_parse_args( $data, $this->get_column_defaults() ); |
|
| 125 | + $data = wp_parse_args($data, $this->get_column_defaults()); |
|
| 126 | 126 | |
| 127 | - do_action( 'wpinv_pre_insert_' . $type, $data ); |
|
| 127 | + do_action('wpinv_pre_insert_' . $type, $data); |
|
| 128 | 128 | |
| 129 | 129 | // Initialise column format array |
| 130 | 130 | $column_formats = $this->get_columns(); |
| 131 | 131 | |
| 132 | 132 | // Force fields to lower case |
| 133 | - $data = array_change_key_case( $data ); |
|
| 133 | + $data = array_change_key_case($data); |
|
| 134 | 134 | |
| 135 | 135 | // White list columns |
| 136 | - $data = array_intersect_key( $data, $column_formats ); |
|
| 136 | + $data = array_intersect_key($data, $column_formats); |
|
| 137 | 137 | |
| 138 | 138 | // Reorder $column_formats to match the order of columns given in $data |
| 139 | - $data_keys = array_keys( $data ); |
|
| 140 | - $column_formats = array_merge( array_flip( $data_keys ), $column_formats ); |
|
| 139 | + $data_keys = array_keys($data); |
|
| 140 | + $column_formats = array_merge(array_flip($data_keys), $column_formats); |
|
| 141 | 141 | |
| 142 | - $wpdb->insert( $this->table_name, $data, $column_formats ); |
|
| 142 | + $wpdb->insert($this->table_name, $data, $column_formats); |
|
| 143 | 143 | $wpdb_insert_id = $wpdb->insert_id; |
| 144 | 144 | |
| 145 | - do_action( 'wpinv_post_insert_' . $type, $wpdb_insert_id, $data ); |
|
| 145 | + do_action('wpinv_post_insert_' . $type, $wpdb_insert_id, $data); |
|
| 146 | 146 | |
| 147 | 147 | return $wpdb_insert_id; |
| 148 | 148 | } |
@@ -154,18 +154,18 @@ discard block |
||
| 154 | 154 | * @since 1.0.0 |
| 155 | 155 | * @return bool |
| 156 | 156 | */ |
| 157 | - public function update( $row_id, $data = array(), $where = '' ) { |
|
| 157 | + public function update($row_id, $data = array(), $where = '') { |
|
| 158 | 158 | |
| 159 | 159 | global $wpdb; |
| 160 | 160 | |
| 161 | 161 | // Row ID must be positive integer |
| 162 | - $row_id = absint( $row_id ); |
|
| 162 | + $row_id = absint($row_id); |
|
| 163 | 163 | |
| 164 | - if( empty( $row_id ) ) { |
|
| 164 | + if (empty($row_id)) { |
|
| 165 | 165 | return false; |
| 166 | 166 | } |
| 167 | 167 | |
| 168 | - if( empty( $where ) ) { |
|
| 168 | + if (empty($where)) { |
|
| 169 | 169 | $where = $this->primary_key; |
| 170 | 170 | } |
| 171 | 171 | |
@@ -173,16 +173,16 @@ discard block |
||
| 173 | 173 | $column_formats = $this->get_columns(); |
| 174 | 174 | |
| 175 | 175 | // Force fields to lower case |
| 176 | - $data = array_change_key_case( $data ); |
|
| 176 | + $data = array_change_key_case($data); |
|
| 177 | 177 | |
| 178 | 178 | // White list columns |
| 179 | - $data = array_intersect_key( $data, $column_formats ); |
|
| 179 | + $data = array_intersect_key($data, $column_formats); |
|
| 180 | 180 | |
| 181 | 181 | // Reorder $column_formats to match the order of columns given in $data |
| 182 | - $data_keys = array_keys( $data ); |
|
| 183 | - $column_formats = array_merge( array_flip( $data_keys ), $column_formats ); |
|
| 182 | + $data_keys = array_keys($data); |
|
| 183 | + $column_formats = array_merge(array_flip($data_keys), $column_formats); |
|
| 184 | 184 | |
| 185 | - if ( false === $wpdb->update( $this->table_name, $data, array( $where => $row_id ), $column_formats ) ) { |
|
| 185 | + if (false === $wpdb->update($this->table_name, $data, array($where => $row_id), $column_formats)) { |
|
| 186 | 186 | return false; |
| 187 | 187 | } |
| 188 | 188 | |
@@ -196,18 +196,18 @@ discard block |
||
| 196 | 196 | * @since 1.0.0 |
| 197 | 197 | * @return bool |
| 198 | 198 | */ |
| 199 | - public function delete( $row_id = 0 ) { |
|
| 199 | + public function delete($row_id = 0) { |
|
| 200 | 200 | |
| 201 | 201 | global $wpdb; |
| 202 | 202 | |
| 203 | 203 | // Row ID must be positive integer |
| 204 | - $row_id = absint( $row_id ); |
|
| 204 | + $row_id = absint($row_id); |
|
| 205 | 205 | |
| 206 | - if( empty( $row_id ) ) { |
|
| 206 | + if (empty($row_id)) { |
|
| 207 | 207 | return false; |
| 208 | 208 | } |
| 209 | 209 | |
| 210 | - if ( false === $wpdb->query( $wpdb->prepare( "DELETE FROM $this->table_name WHERE $this->primary_key = %d", $row_id ) ) ) { |
|
| 210 | + if (false === $wpdb->query($wpdb->prepare("DELETE FROM $this->table_name WHERE $this->primary_key = %d", $row_id))) { |
|
| 211 | 211 | return false; |
| 212 | 212 | } |
| 213 | 213 | |
@@ -221,11 +221,11 @@ discard block |
||
| 221 | 221 | * @param string $table The table name |
| 222 | 222 | * @return bool If the table name exists |
| 223 | 223 | */ |
| 224 | - public function table_exists( $table ) { |
|
| 224 | + public function table_exists($table) { |
|
| 225 | 225 | global $wpdb; |
| 226 | - $table = sanitize_text_field( $table ); |
|
| 226 | + $table = sanitize_text_field($table); |
|
| 227 | 227 | |
| 228 | - return $wpdb->get_var( $wpdb->prepare( "SHOW TABLES LIKE '%s'", $table ) ) === $table; |
|
| 228 | + return $wpdb->get_var($wpdb->prepare("SHOW TABLES LIKE '%s'", $table)) === $table; |
|
| 229 | 229 | } |
| 230 | 230 | |
| 231 | 231 | /** |
@@ -235,7 +235,7 @@ discard block |
||
| 235 | 235 | * @return bool Returns if the customers table was installed and upgrade routine run |
| 236 | 236 | */ |
| 237 | 237 | public function installed() { |
| 238 | - return $this->table_exists( $this->table_name ); |
|
| 238 | + return $this->table_exists($this->table_name); |
|
| 239 | 239 | } |
| 240 | 240 | |
| 241 | 241 | } |
@@ -1,5 +1,5 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | -if ( ! defined( 'ABSPATH' ) ) { |
|
| 2 | +if (!defined('ABSPATH')) { |
|
| 3 | 3 | exit; // Exit if accessed directly |
| 4 | 4 | } |
| 5 | 5 | |
@@ -14,18 +14,18 @@ discard block |
||
| 14 | 14 | * Hook in methods. |
| 15 | 15 | */ |
| 16 | 16 | public static function init() { |
| 17 | - add_action( 'init', array( __CLASS__, 'init_hooks' ), 0 ); |
|
| 18 | - add_action( 'admin_notices', array( __CLASS__, 'notices' ) ); |
|
| 17 | + add_action('init', array(__CLASS__, 'init_hooks'), 0); |
|
| 18 | + add_action('admin_notices', array(__CLASS__, 'notices')); |
|
| 19 | 19 | } |
| 20 | 20 | |
| 21 | 21 | public static function init_hooks() { |
| 22 | - if ( false === ( $page_uris = get_transient( 'wpinv_cache_excluded_uris' ) ) ) { |
|
| 23 | - $checkout_page = wpinv_get_option( 'checkout_page', '' ); |
|
| 24 | - $success_page = wpinv_get_option( 'success_page', '' ); |
|
| 25 | - $failure_page = wpinv_get_option( 'failure_page', '' ); |
|
| 26 | - $history_page = wpinv_get_option( 'invoice_history_page', '' ); |
|
| 27 | - $subscr_page = wpinv_get_option( 'invoice_subscription_page', '' ); |
|
| 28 | - if ( empty( $checkout_page ) || empty( $success_page ) || empty( $failure_page ) || empty( $history_page ) || empty( $subscr_page ) ) { |
|
| 22 | + if (false === ($page_uris = get_transient('wpinv_cache_excluded_uris'))) { |
|
| 23 | + $checkout_page = wpinv_get_option('checkout_page', ''); |
|
| 24 | + $success_page = wpinv_get_option('success_page', ''); |
|
| 25 | + $failure_page = wpinv_get_option('failure_page', ''); |
|
| 26 | + $history_page = wpinv_get_option('invoice_history_page', ''); |
|
| 27 | + $subscr_page = wpinv_get_option('invoice_subscription_page', ''); |
|
| 28 | + if (empty($checkout_page) || empty($success_page) || empty($failure_page) || empty($history_page) || empty($subscr_page)) { |
|
| 29 | 29 | return; |
| 30 | 30 | } |
| 31 | 31 | |
@@ -39,34 +39,34 @@ discard block |
||
| 39 | 39 | $page_uris[] = 'p=' . $subscr_page; |
| 40 | 40 | |
| 41 | 41 | // Exclude permalinks |
| 42 | - $checkout_page = get_post( $checkout_page ); |
|
| 43 | - $success_page = get_post( $success_page ); |
|
| 44 | - $failure_page = get_post( $failure_page ); |
|
| 45 | - $history_page = get_post( $history_page ); |
|
| 46 | - $subscr_page = get_post( $subscr_page ); |
|
| 42 | + $checkout_page = get_post($checkout_page); |
|
| 43 | + $success_page = get_post($success_page); |
|
| 44 | + $failure_page = get_post($failure_page); |
|
| 45 | + $history_page = get_post($history_page); |
|
| 46 | + $subscr_page = get_post($subscr_page); |
|
| 47 | 47 | |
| 48 | - if ( ! is_null( $checkout_page ) ) { |
|
| 48 | + if (!is_null($checkout_page)) { |
|
| 49 | 49 | $page_uris[] = '/' . $checkout_page->post_name; |
| 50 | 50 | } |
| 51 | - if ( ! is_null( $success_page ) ) { |
|
| 51 | + if (!is_null($success_page)) { |
|
| 52 | 52 | $page_uris[] = '/' . $success_page->post_name; |
| 53 | 53 | } |
| 54 | - if ( ! is_null( $failure_page ) ) { |
|
| 54 | + if (!is_null($failure_page)) { |
|
| 55 | 55 | $page_uris[] = '/' . $failure_page->post_name; |
| 56 | 56 | } |
| 57 | - if ( ! is_null( $history_page ) ) { |
|
| 57 | + if (!is_null($history_page)) { |
|
| 58 | 58 | $page_uris[] = '/' . $history_page->post_name; |
| 59 | 59 | } |
| 60 | - if ( ! is_null( $subscr_page ) ) { |
|
| 60 | + if (!is_null($subscr_page)) { |
|
| 61 | 61 | $page_uris[] = '/' . $subscr_page->post_name; |
| 62 | 62 | } |
| 63 | 63 | |
| 64 | - set_transient( 'wpinv_cache_excluded_uris', $page_uris ); |
|
| 64 | + set_transient('wpinv_cache_excluded_uris', $page_uris); |
|
| 65 | 65 | } |
| 66 | 66 | |
| 67 | - if ( is_array( $page_uris ) ) { |
|
| 68 | - foreach( $page_uris as $uri ) { |
|
| 69 | - if ( strstr( $_SERVER['REQUEST_URI'], $uri ) ) { |
|
| 67 | + if (is_array($page_uris)) { |
|
| 68 | + foreach ($page_uris as $uri) { |
|
| 69 | + if (strstr($_SERVER['REQUEST_URI'], $uri)) { |
|
| 70 | 70 | self::nocache(); |
| 71 | 71 | break; |
| 72 | 72 | } |
@@ -79,14 +79,14 @@ discard block |
||
| 79 | 79 | * @access private |
| 80 | 80 | */ |
| 81 | 81 | private static function nocache() { |
| 82 | - if ( ! defined( 'DONOTCACHEPAGE' ) ) { |
|
| 83 | - define( "DONOTCACHEPAGE", true ); |
|
| 82 | + if (!defined('DONOTCACHEPAGE')) { |
|
| 83 | + define("DONOTCACHEPAGE", true); |
|
| 84 | 84 | } |
| 85 | - if ( ! defined( 'DONOTCACHEOBJECT' ) ) { |
|
| 86 | - define( "DONOTCACHEOBJECT", true ); |
|
| 85 | + if (!defined('DONOTCACHEOBJECT')) { |
|
| 86 | + define("DONOTCACHEOBJECT", true); |
|
| 87 | 87 | } |
| 88 | - if ( ! defined( 'DONOTCACHEDB' ) ) { |
|
| 89 | - define( "DONOTCACHEDB", true ); |
|
| 88 | + if (!defined('DONOTCACHEDB')) { |
|
| 89 | + define("DONOTCACHEDB", true); |
|
| 90 | 90 | } |
| 91 | 91 | nocache_headers(); |
| 92 | 92 | } |
@@ -95,18 +95,18 @@ discard block |
||
| 95 | 95 | * notices function. |
| 96 | 96 | */ |
| 97 | 97 | public static function notices() { |
| 98 | - if ( ! function_exists( 'w3tc_pgcache_flush' ) || ! function_exists( 'w3_instance' ) ) { |
|
| 98 | + if (!function_exists('w3tc_pgcache_flush') || !function_exists('w3_instance')) { |
|
| 99 | 99 | return; |
| 100 | 100 | } |
| 101 | 101 | |
| 102 | - $config = w3_instance( 'W3_Config' ); |
|
| 103 | - $enabled = $config->get_integer( 'dbcache.enabled' ); |
|
| 104 | - $settings = array_map( 'trim', $config->get_array( 'dbcache.reject.sql' ) ); |
|
| 102 | + $config = w3_instance('W3_Config'); |
|
| 103 | + $enabled = $config->get_integer('dbcache.enabled'); |
|
| 104 | + $settings = array_map('trim', $config->get_array('dbcache.reject.sql')); |
|
| 105 | 105 | |
| 106 | - if ( $enabled && ! in_array( '_wp_session_', $settings ) ) { |
|
| 106 | + if ($enabled && !in_array('_wp_session_', $settings)) { |
|
| 107 | 107 | ?> |
| 108 | 108 | <div class="error"> |
| 109 | - <p><?php printf( __( 'In order for <strong>database caching</strong> to work with Invoicing you must add %1$s to the "Ignored Query Strings" option in <a href="%2$s">W3 Total Cache settings</a>.', 'invoicing' ), '<code>_wp_session_</code>', admin_url( 'admin.php?page=w3tc_dbcache' ) ); ?></p> |
|
| 109 | + <p><?php printf(__('In order for <strong>database caching</strong> to work with Invoicing you must add %1$s to the "Ignored Query Strings" option in <a href="%2$s">W3 Total Cache settings</a>.', 'invoicing'), '<code>_wp_session_</code>', admin_url('admin.php?page=w3tc_dbcache')); ?></p> |
|
| 110 | 110 | </div> |
| 111 | 111 | <?php |
| 112 | 112 | } |
@@ -1,6 +1,6 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | // Exit if accessed directly. |
| 3 | -if (!defined( 'ABSPATH' ) ) exit; |
|
| 3 | +if (!defined('ABSPATH')) exit; |
|
| 4 | 4 | |
| 5 | 5 | /** |
| 6 | 6 | * The Subscriptions DB Class |
@@ -68,8 +68,8 @@ discard block |
||
| 68 | 68 | 'transaction_id' => '', |
| 69 | 69 | 'parent_payment_id' => 0, |
| 70 | 70 | 'product_id' => 0, |
| 71 | - 'created' => date( 'Y-m-d H:i:s' ), |
|
| 72 | - 'expiration' => date( 'Y-m-d H:i:s' ), |
|
| 71 | + 'created' => date('Y-m-d H:i:s'), |
|
| 72 | + 'expiration' => date('Y-m-d H:i:s'), |
|
| 73 | 73 | 'trial_period' => '', |
| 74 | 74 | 'status' => '', |
| 75 | 75 | 'profile_id' => '', |
@@ -82,11 +82,11 @@ discard block |
||
| 82 | 82 | * @access public |
| 83 | 83 | * @since 1.0.0 |
| 84 | 84 | */ |
| 85 | - public function get_subscriptions( $args = array() ) { |
|
| 85 | + public function get_subscriptions($args = array()) { |
|
| 86 | 86 | global $wpdb; |
| 87 | 87 | |
| 88 | 88 | $defaults = array( |
| 89 | - 'number' => get_option( 'posts_per_page' ), |
|
| 89 | + 'number' => get_option('posts_per_page'), |
|
| 90 | 90 | 'offset' => 0, |
| 91 | 91 | 'search' => '', |
| 92 | 92 | 'customer_id' => 0, |
@@ -94,21 +94,21 @@ discard block |
||
| 94 | 94 | 'order' => 'DESC' |
| 95 | 95 | ); |
| 96 | 96 | |
| 97 | - $args = wp_parse_args( $args, $defaults ); |
|
| 97 | + $args = wp_parse_args($args, $defaults); |
|
| 98 | 98 | |
| 99 | - if( $args['number'] < 1 ) { |
|
| 99 | + if ($args['number'] < 1) { |
|
| 100 | 100 | $args['number'] = 999999999999; |
| 101 | 101 | } |
| 102 | 102 | |
| 103 | 103 | $where = ' WHERE 1=1 '; |
| 104 | 104 | |
| 105 | 105 | // specific customers |
| 106 | - if( ! empty( $args['id'] ) ) { |
|
| 106 | + if (!empty($args['id'])) { |
|
| 107 | 107 | |
| 108 | - if( is_array( $args['id'] ) ) { |
|
| 109 | - $ids = implode( ',', array_map('intval', $args['id'] ) ); |
|
| 108 | + if (is_array($args['id'])) { |
|
| 109 | + $ids = implode(',', array_map('intval', $args['id'])); |
|
| 110 | 110 | } else { |
| 111 | - $ids = intval( $args['id'] ); |
|
| 111 | + $ids = intval($args['id']); |
|
| 112 | 112 | } |
| 113 | 113 | |
| 114 | 114 | $where .= " AND `id` IN( {$ids} ) "; |
@@ -116,12 +116,12 @@ discard block |
||
| 116 | 116 | } |
| 117 | 117 | |
| 118 | 118 | // Specific products |
| 119 | - if( ! empty( $args['product_id'] ) ) { |
|
| 119 | + if (!empty($args['product_id'])) { |
|
| 120 | 120 | |
| 121 | - if( is_array( $args['product_id'] ) ) { |
|
| 122 | - $product_ids = implode( ',', array_map('intval', $args['product_id'] ) ); |
|
| 121 | + if (is_array($args['product_id'])) { |
|
| 122 | + $product_ids = implode(',', array_map('intval', $args['product_id'])); |
|
| 123 | 123 | } else { |
| 124 | - $product_ids = intval( $args['product_id'] ); |
|
| 124 | + $product_ids = intval($args['product_id']); |
|
| 125 | 125 | } |
| 126 | 126 | |
| 127 | 127 | $where .= " AND `product_id` IN( {$product_ids} ) "; |
@@ -129,12 +129,12 @@ discard block |
||
| 129 | 129 | } |
| 130 | 130 | |
| 131 | 131 | // Specific parent payments |
| 132 | - if( ! empty( $args['parent_payment_id'] ) ) { |
|
| 132 | + if (!empty($args['parent_payment_id'])) { |
|
| 133 | 133 | |
| 134 | - if( is_array( $args['parent_payment_id'] ) ) { |
|
| 135 | - $parent_payment_ids = implode( ',', array_map('intval', $args['parent_payment_id'] ) ); |
|
| 134 | + if (is_array($args['parent_payment_id'])) { |
|
| 135 | + $parent_payment_ids = implode(',', array_map('intval', $args['parent_payment_id'])); |
|
| 136 | 136 | } else { |
| 137 | - $parent_payment_ids = intval( $args['parent_payment_id'] ); |
|
| 137 | + $parent_payment_ids = intval($args['parent_payment_id']); |
|
| 138 | 138 | } |
| 139 | 139 | |
| 140 | 140 | $where .= " AND `parent_payment_id` IN( {$parent_payment_ids} ) "; |
@@ -142,12 +142,12 @@ discard block |
||
| 142 | 142 | } |
| 143 | 143 | |
| 144 | 144 | // Specific transaction IDs |
| 145 | - if( ! empty( $args['transaction_id'] ) ) { |
|
| 145 | + if (!empty($args['transaction_id'])) { |
|
| 146 | 146 | |
| 147 | - if( is_array( $args['transaction_id'] ) ) { |
|
| 148 | - $transaction_ids = implode( "','", array_map('sanitize_text_field', $args['transaction_id'] ) ); |
|
| 147 | + if (is_array($args['transaction_id'])) { |
|
| 148 | + $transaction_ids = implode("','", array_map('sanitize_text_field', $args['transaction_id'])); |
|
| 149 | 149 | } else { |
| 150 | - $transaction_ids = sanitize_text_field( $args['transaction_id'] ); |
|
| 150 | + $transaction_ids = sanitize_text_field($args['transaction_id']); |
|
| 151 | 151 | } |
| 152 | 152 | |
| 153 | 153 | $where .= " AND `transaction_id` IN ( '{$transaction_ids}' ) "; |
@@ -155,12 +155,12 @@ discard block |
||
| 155 | 155 | } |
| 156 | 156 | |
| 157 | 157 | // Subscriptoins for specific customers |
| 158 | - if( ! empty( $args['customer_id'] ) ) { |
|
| 158 | + if (!empty($args['customer_id'])) { |
|
| 159 | 159 | |
| 160 | - if( is_array( $args['customer_id'] ) ) { |
|
| 161 | - $customer_ids = implode( ',', array_map('intval', $args['customer_id'] ) ); |
|
| 160 | + if (is_array($args['customer_id'])) { |
|
| 161 | + $customer_ids = implode(',', array_map('intval', $args['customer_id'])); |
|
| 162 | 162 | } else { |
| 163 | - $customer_ids = intval( $args['customer_id'] ); |
|
| 163 | + $customer_ids = intval($args['customer_id']); |
|
| 164 | 164 | } |
| 165 | 165 | |
| 166 | 166 | $where .= " AND `customer_id` IN( {$customer_ids} ) "; |
@@ -168,12 +168,12 @@ discard block |
||
| 168 | 168 | } |
| 169 | 169 | |
| 170 | 170 | // Subscriptions for specific profile IDs |
| 171 | - if( ! empty( $args['profile_id'] ) ) { |
|
| 171 | + if (!empty($args['profile_id'])) { |
|
| 172 | 172 | |
| 173 | - if( is_array( $args['profile_id'] ) ) { |
|
| 174 | - $profile_ids = implode( "','", array_map('sanitize_text_field', $args['profile_id'] ) ); |
|
| 173 | + if (is_array($args['profile_id'])) { |
|
| 174 | + $profile_ids = implode("','", array_map('sanitize_text_field', $args['profile_id'])); |
|
| 175 | 175 | } else { |
| 176 | - $profile_ids = sanitize_text_field( $args['profile_id'] ); |
|
| 176 | + $profile_ids = sanitize_text_field($args['profile_id']); |
|
| 177 | 177 | } |
| 178 | 178 | |
| 179 | 179 | $where .= " AND `profile_id` IN( '{$profile_ids}' ) "; |
@@ -181,12 +181,12 @@ discard block |
||
| 181 | 181 | } |
| 182 | 182 | |
| 183 | 183 | // Subscriptions for specific statuses |
| 184 | - if( ! empty( $args['status'] ) ) { |
|
| 184 | + if (!empty($args['status'])) { |
|
| 185 | 185 | |
| 186 | - if( is_array( $args['status'] ) ) { |
|
| 187 | - $statuses = implode( "','", array_map( 'sanitize_text_field', $args['status'] ) ); |
|
| 186 | + if (is_array($args['status'])) { |
|
| 187 | + $statuses = implode("','", array_map('sanitize_text_field', $args['status'])); |
|
| 188 | 188 | } else { |
| 189 | - $statuses = sanitize_text_field( $args['status'] ); |
|
| 189 | + $statuses = sanitize_text_field($args['status']); |
|
| 190 | 190 | } |
| 191 | 191 | |
| 192 | 192 | $where .= " AND `status` IN( '{$statuses}' ) "; |
@@ -194,21 +194,21 @@ discard block |
||
| 194 | 194 | } |
| 195 | 195 | |
| 196 | 196 | // Subscriptions created for a specific date or in a date range |
| 197 | - if( ! empty( $args['date'] ) ) { |
|
| 197 | + if (!empty($args['date'])) { |
|
| 198 | 198 | |
| 199 | - if( is_array( $args['date'] ) ) { |
|
| 199 | + if (is_array($args['date'])) { |
|
| 200 | 200 | |
| 201 | - if( ! empty( $args['date']['start'] ) ) { |
|
| 201 | + if (!empty($args['date']['start'])) { |
|
| 202 | 202 | |
| 203 | - $start = date( 'Y-m-d H:i:s', strtotime( $args['date']['start'] ) ); |
|
| 203 | + $start = date('Y-m-d H:i:s', strtotime($args['date']['start'])); |
|
| 204 | 204 | |
| 205 | 205 | $where .= " AND `created` >= '{$start}'"; |
| 206 | 206 | |
| 207 | 207 | } |
| 208 | 208 | |
| 209 | - if( ! empty( $args['date']['end'] ) ) { |
|
| 209 | + if (!empty($args['date']['end'])) { |
|
| 210 | 210 | |
| 211 | - $end = date( 'Y-m-d H:i:s', strtotime( $args['date']['end'] ) ); |
|
| 211 | + $end = date('Y-m-d H:i:s', strtotime($args['date']['end'])); |
|
| 212 | 212 | |
| 213 | 213 | $where .= " AND `created` <= '{$end}'"; |
| 214 | 214 | |
@@ -216,9 +216,9 @@ discard block |
||
| 216 | 216 | |
| 217 | 217 | } else { |
| 218 | 218 | |
| 219 | - $year = date( 'Y', strtotime( $args['date'] ) ); |
|
| 220 | - $month = date( 'm', strtotime( $args['date'] ) ); |
|
| 221 | - $day = date( 'd', strtotime( $args['date'] ) ); |
|
| 219 | + $year = date('Y', strtotime($args['date'])); |
|
| 220 | + $month = date('m', strtotime($args['date'])); |
|
| 221 | + $day = date('d', strtotime($args['date'])); |
|
| 222 | 222 | |
| 223 | 223 | $where .= " AND $year = YEAR ( created ) AND $month = MONTH ( created ) AND $day = DAY ( created )"; |
| 224 | 224 | } |
@@ -226,21 +226,21 @@ discard block |
||
| 226 | 226 | } |
| 227 | 227 | |
| 228 | 228 | // Subscriptions with a specific expiration date or in an expiration date range |
| 229 | - if( ! empty( $args['expiration'] ) ) { |
|
| 229 | + if (!empty($args['expiration'])) { |
|
| 230 | 230 | |
| 231 | - if( is_array( $args['expiration'] ) ) { |
|
| 231 | + if (is_array($args['expiration'])) { |
|
| 232 | 232 | |
| 233 | - if( ! empty( $args['expiration']['start'] ) ) { |
|
| 233 | + if (!empty($args['expiration']['start'])) { |
|
| 234 | 234 | |
| 235 | - $start = date( 'Y-m-d H:i:s', strtotime( $args['expiration']['start'] ) ); |
|
| 235 | + $start = date('Y-m-d H:i:s', strtotime($args['expiration']['start'])); |
|
| 236 | 236 | |
| 237 | 237 | $where .= " AND `expiration` >= '{$start}'"; |
| 238 | 238 | |
| 239 | 239 | } |
| 240 | 240 | |
| 241 | - if( ! empty( $args['expiration']['end'] ) ) { |
|
| 241 | + if (!empty($args['expiration']['end'])) { |
|
| 242 | 242 | |
| 243 | - $end = date( 'Y-m-d H:i:s', strtotime( $args['expiration']['end'] ) ); |
|
| 243 | + $end = date('Y-m-d H:i:s', strtotime($args['expiration']['end'])); |
|
| 244 | 244 | |
| 245 | 245 | $where .= " AND `expiration` <= '{$end}'"; |
| 246 | 246 | |
@@ -248,73 +248,73 @@ discard block |
||
| 248 | 248 | |
| 249 | 249 | } else { |
| 250 | 250 | |
| 251 | - $year = date( 'Y', strtotime( $args['expiration'] ) ); |
|
| 252 | - $month = date( 'm', strtotime( $args['expiration'] ) ); |
|
| 253 | - $day = date( 'd', strtotime( $args['expiration'] ) ); |
|
| 251 | + $year = date('Y', strtotime($args['expiration'])); |
|
| 252 | + $month = date('m', strtotime($args['expiration'])); |
|
| 253 | + $day = date('d', strtotime($args['expiration'])); |
|
| 254 | 254 | |
| 255 | 255 | $where .= " AND $year = YEAR ( expiration ) AND $month = MONTH ( expiration ) AND $day = DAY ( expiration )"; |
| 256 | 256 | } |
| 257 | 257 | |
| 258 | 258 | } |
| 259 | 259 | |
| 260 | - if ( ! empty( $args['search'] ) ) { |
|
| 260 | + if (!empty($args['search'])) { |
|
| 261 | 261 | |
| 262 | - if( false !== strpos( 'id:', $args['search'] ) ) { |
|
| 262 | + if (false !== strpos('id:', $args['search'])) { |
|
| 263 | 263 | |
| 264 | - $args['search'] = trim( str_replace( 'id:', '', $args['search'] ) ); |
|
| 265 | - $where .= " AND `id` = '" . esc_sql( $args['search'] ) . "'"; |
|
| 264 | + $args['search'] = trim(str_replace('id:', '', $args['search'])); |
|
| 265 | + $where .= " AND `id` = '" . esc_sql($args['search']) . "'"; |
|
| 266 | 266 | |
| 267 | - } else if( false !== strpos( $args['search'], 'txn:' ) ) { |
|
| 267 | + } else if (false !== strpos($args['search'], 'txn:')) { |
|
| 268 | 268 | |
| 269 | - $args['search'] = trim( str_replace( 'txn:', '', $args['search'] ) ); |
|
| 270 | - $where .= " AND `transaction_id` = '" . esc_sql( $args['search'] ) . "'"; |
|
| 269 | + $args['search'] = trim(str_replace('txn:', '', $args['search'])); |
|
| 270 | + $where .= " AND `transaction_id` = '" . esc_sql($args['search']) . "'"; |
|
| 271 | 271 | |
| 272 | - } else if( false !== strpos( $args['search'], 'profile_id:' ) ) { |
|
| 272 | + } else if (false !== strpos($args['search'], 'profile_id:')) { |
|
| 273 | 273 | |
| 274 | - $args['search'] = trim( str_replace( 'profile_id:', '', $args['search'] ) ); |
|
| 275 | - $where .= " AND `profile_id` = '" . esc_sql( $args['search'] ) . "'"; |
|
| 274 | + $args['search'] = trim(str_replace('profile_id:', '', $args['search'])); |
|
| 275 | + $where .= " AND `profile_id` = '" . esc_sql($args['search']) . "'"; |
|
| 276 | 276 | |
| 277 | - } else if( false !== strpos( $args['search'], 'product_id:' ) ) { |
|
| 277 | + } else if (false !== strpos($args['search'], 'product_id:')) { |
|
| 278 | 278 | |
| 279 | - $args['search'] = trim( str_replace( 'product_id:', '', $args['search'] ) ); |
|
| 280 | - $where .= " AND `product_id` = '" . esc_sql( $args['search'] ) . "'"; |
|
| 279 | + $args['search'] = trim(str_replace('product_id:', '', $args['search'])); |
|
| 280 | + $where .= " AND `product_id` = '" . esc_sql($args['search']) . "'"; |
|
| 281 | 281 | |
| 282 | - } else if( false !== strpos( $args['search'], 'customer_id:' ) ) { |
|
| 282 | + } else if (false !== strpos($args['search'], 'customer_id:')) { |
|
| 283 | 283 | |
| 284 | - $args['search'] = trim( str_replace( 'customer_id:', '', $args['search'] ) ); |
|
| 285 | - $where .= " AND `customer_id` = '" . esc_sql( $args['search'] ) . "'"; |
|
| 284 | + $args['search'] = trim(str_replace('customer_id:', '', $args['search'])); |
|
| 285 | + $where .= " AND `customer_id` = '" . esc_sql($args['search']) . "'"; |
|
| 286 | 286 | |
| 287 | 287 | } else { |
| 288 | 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'] ) . "' )"; |
|
| 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 | 290 | |
| 291 | 291 | } |
| 292 | 292 | |
| 293 | 293 | } |
| 294 | 294 | |
| 295 | - $args['orderby'] = ! array_key_exists( $args['orderby'], $this->get_columns() ) ? 'id' : $args['orderby']; |
|
| 295 | + $args['orderby'] = !array_key_exists($args['orderby'], $this->get_columns()) ? 'id' : $args['orderby']; |
|
| 296 | 296 | |
| 297 | - if( 'amount' == $args['orderby'] ) { |
|
| 297 | + if ('amount' == $args['orderby']) { |
|
| 298 | 298 | $args['orderby'] = 'amount+0'; |
| 299 | 299 | } |
| 300 | 300 | |
| 301 | - $cache_key = md5( 'wpinv_subscriptions_' . serialize( $args ) ); |
|
| 301 | + $cache_key = md5('wpinv_subscriptions_' . serialize($args)); |
|
| 302 | 302 | |
| 303 | - $subscriptions = wp_cache_get( $cache_key, 'subscriptions' ); |
|
| 303 | + $subscriptions = wp_cache_get($cache_key, 'subscriptions'); |
|
| 304 | 304 | |
| 305 | - $args['orderby'] = esc_sql( $args['orderby'] ); |
|
| 306 | - $args['order'] = esc_sql( $args['order'] ); |
|
| 305 | + $args['orderby'] = esc_sql($args['orderby']); |
|
| 306 | + $args['order'] = esc_sql($args['order']); |
|
| 307 | 307 | |
| 308 | - if( $subscriptions === false ) { |
|
| 309 | - $subscriptions = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM $this->table_name $where ORDER BY {$args['orderby']} {$args['order']} LIMIT %d,%d;", absint( $args['offset'] ), absint( $args['number'] ) ), OBJECT ); |
|
| 308 | + if ($subscriptions === false) { |
|
| 309 | + $subscriptions = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->table_name $where ORDER BY {$args['orderby']} {$args['order']} LIMIT %d,%d;", absint($args['offset']), absint($args['number'])), OBJECT); |
|
| 310 | 310 | |
| 311 | - if( ! empty( $subscriptions ) ) { |
|
| 311 | + if (!empty($subscriptions)) { |
|
| 312 | 312 | |
| 313 | - foreach( $subscriptions as $key => $subscription ) { |
|
| 314 | - $subscriptions[ $key ] = new WPInv_Subscription( $subscription ); |
|
| 313 | + foreach ($subscriptions as $key => $subscription) { |
|
| 314 | + $subscriptions[$key] = new WPInv_Subscription($subscription); |
|
| 315 | 315 | } |
| 316 | 316 | |
| 317 | - wp_cache_set( $cache_key, $subscriptions, 'subscriptions', 3600 ); |
|
| 317 | + wp_cache_set($cache_key, $subscriptions, 'subscriptions', 3600); |
|
| 318 | 318 | |
| 319 | 319 | } |
| 320 | 320 | |
@@ -329,19 +329,19 @@ discard block |
||
| 329 | 329 | * @access public |
| 330 | 330 | * @since 1.0.0 |
| 331 | 331 | */ |
| 332 | - public function count( $args = array() ) { |
|
| 332 | + public function count($args = array()) { |
|
| 333 | 333 | |
| 334 | 334 | global $wpdb; |
| 335 | 335 | |
| 336 | 336 | $where = ' WHERE 1=1 '; |
| 337 | 337 | |
| 338 | 338 | // specific customers |
| 339 | - if( ! empty( $args['id'] ) ) { |
|
| 339 | + if (!empty($args['id'])) { |
|
| 340 | 340 | |
| 341 | - if( is_array( $args['id'] ) ) { |
|
| 342 | - $ids = implode( ',', array_map('intval', $args['id'] ) ); |
|
| 341 | + if (is_array($args['id'])) { |
|
| 342 | + $ids = implode(',', array_map('intval', $args['id'])); |
|
| 343 | 343 | } else { |
| 344 | - $ids = intval( $args['id'] ); |
|
| 344 | + $ids = intval($args['id']); |
|
| 345 | 345 | } |
| 346 | 346 | |
| 347 | 347 | $where .= " AND `id` IN( {$ids} ) "; |
@@ -349,12 +349,12 @@ discard block |
||
| 349 | 349 | } |
| 350 | 350 | |
| 351 | 351 | // Specific products |
| 352 | - if( ! empty( $args['product_id'] ) ) { |
|
| 352 | + if (!empty($args['product_id'])) { |
|
| 353 | 353 | |
| 354 | - if( is_array( $args['product_id'] ) ) { |
|
| 355 | - $product_ids = implode( ',', array_map('intval', $args['product_id'] ) ); |
|
| 354 | + if (is_array($args['product_id'])) { |
|
| 355 | + $product_ids = implode(',', array_map('intval', $args['product_id'])); |
|
| 356 | 356 | } else { |
| 357 | - $product_ids = intval( $args['product_id'] ); |
|
| 357 | + $product_ids = intval($args['product_id']); |
|
| 358 | 358 | } |
| 359 | 359 | |
| 360 | 360 | $where .= " AND `product_id` IN( {$product_ids} ) "; |
@@ -362,12 +362,12 @@ discard block |
||
| 362 | 362 | } |
| 363 | 363 | |
| 364 | 364 | // Specific parent payments |
| 365 | - if( ! empty( $args['parent_payment_id'] ) ) { |
|
| 365 | + if (!empty($args['parent_payment_id'])) { |
|
| 366 | 366 | |
| 367 | - if( is_array( $args['parent_payment_id'] ) ) { |
|
| 368 | - $parent_payment_ids = implode( ',', array_map('intval', $args['parent_payment_id'] ) ); |
|
| 367 | + if (is_array($args['parent_payment_id'])) { |
|
| 368 | + $parent_payment_ids = implode(',', array_map('intval', $args['parent_payment_id'])); |
|
| 369 | 369 | } else { |
| 370 | - $parent_payment_ids = intval( $args['parent_payment_id'] ); |
|
| 370 | + $parent_payment_ids = intval($args['parent_payment_id']); |
|
| 371 | 371 | } |
| 372 | 372 | |
| 373 | 373 | $where .= " AND `parent_payment_id` IN( {$parent_payment_ids} ) "; |
@@ -375,12 +375,12 @@ discard block |
||
| 375 | 375 | } |
| 376 | 376 | |
| 377 | 377 | // Subscriptoins for specific customers |
| 378 | - if( ! empty( $args['customer_id'] ) ) { |
|
| 378 | + if (!empty($args['customer_id'])) { |
|
| 379 | 379 | |
| 380 | - if( is_array( $args['customer_id'] ) ) { |
|
| 381 | - $customer_ids = implode( ',', array_map('intval', $args['customer_id'] ) ); |
|
| 380 | + if (is_array($args['customer_id'])) { |
|
| 381 | + $customer_ids = implode(',', array_map('intval', $args['customer_id'])); |
|
| 382 | 382 | } else { |
| 383 | - $customer_ids = intval( $args['customer_id'] ); |
|
| 383 | + $customer_ids = intval($args['customer_id']); |
|
| 384 | 384 | } |
| 385 | 385 | |
| 386 | 386 | $where .= " AND `customer_id` IN( {$customer_ids} ) "; |
@@ -388,12 +388,12 @@ discard block |
||
| 388 | 388 | } |
| 389 | 389 | |
| 390 | 390 | // Subscriptions for specific profile IDs |
| 391 | - if( ! empty( $args['profile_id'] ) ) { |
|
| 391 | + if (!empty($args['profile_id'])) { |
|
| 392 | 392 | |
| 393 | - if( is_array( $args['profile_id'] ) ) { |
|
| 394 | - $profile_ids = implode( ',', array_map('intval', $args['profile_id'] ) ); |
|
| 393 | + if (is_array($args['profile_id'])) { |
|
| 394 | + $profile_ids = implode(',', array_map('intval', $args['profile_id'])); |
|
| 395 | 395 | } else { |
| 396 | - $profile_ids = intval( $args['profile_id'] ); |
|
| 396 | + $profile_ids = intval($args['profile_id']); |
|
| 397 | 397 | } |
| 398 | 398 | |
| 399 | 399 | $where .= " AND `profile_id` IN( {$profile_ids} ) "; |
@@ -401,12 +401,12 @@ discard block |
||
| 401 | 401 | } |
| 402 | 402 | |
| 403 | 403 | // Specific transaction IDs |
| 404 | - if( ! empty( $args['transaction_id'] ) ) { |
|
| 404 | + if (!empty($args['transaction_id'])) { |
|
| 405 | 405 | |
| 406 | - if( is_array( $args['transaction_id'] ) ) { |
|
| 407 | - $transaction_ids = implode( ',', array_map('sanitize_text_field', $args['transaction_id'] ) ); |
|
| 406 | + if (is_array($args['transaction_id'])) { |
|
| 407 | + $transaction_ids = implode(',', array_map('sanitize_text_field', $args['transaction_id'])); |
|
| 408 | 408 | } else { |
| 409 | - $transaction_ids = sanitize_text_field( $args['transaction_id'] ); |
|
| 409 | + $transaction_ids = sanitize_text_field($args['transaction_id']); |
|
| 410 | 410 | } |
| 411 | 411 | |
| 412 | 412 | $where .= " AND `transaction_id` IN( {$transaction_ids} ) "; |
@@ -414,10 +414,10 @@ discard block |
||
| 414 | 414 | } |
| 415 | 415 | |
| 416 | 416 | // Subscriptions for specific statuses |
| 417 | - if( ! empty( $args['status'] ) ) { |
|
| 417 | + if (!empty($args['status'])) { |
|
| 418 | 418 | |
| 419 | - if( is_array( $args['status'] ) ) { |
|
| 420 | - $statuses = implode( ',', $args['status'] ); |
|
| 419 | + if (is_array($args['status'])) { |
|
| 420 | + $statuses = implode(',', $args['status']); |
|
| 421 | 421 | $where .= " AND `status` IN( {$statuses} ) "; |
| 422 | 422 | } else { |
| 423 | 423 | $statuses = $args['status']; |
@@ -429,21 +429,21 @@ discard block |
||
| 429 | 429 | } |
| 430 | 430 | |
| 431 | 431 | // Subscriptions created for a specific date or in a date range |
| 432 | - if( ! empty( $args['date'] ) ) { |
|
| 432 | + if (!empty($args['date'])) { |
|
| 433 | 433 | |
| 434 | - if( is_array( $args['date'] ) ) { |
|
| 434 | + if (is_array($args['date'])) { |
|
| 435 | 435 | |
| 436 | - if( ! empty( $args['date']['start'] ) ) { |
|
| 436 | + if (!empty($args['date']['start'])) { |
|
| 437 | 437 | |
| 438 | - $start = date( 'Y-m-d H:i:s', strtotime( $args['date']['start'] ) ); |
|
| 438 | + $start = date('Y-m-d H:i:s', strtotime($args['date']['start'])); |
|
| 439 | 439 | |
| 440 | 440 | $where .= " AND `created` >= '{$start}'"; |
| 441 | 441 | |
| 442 | 442 | } |
| 443 | 443 | |
| 444 | - if( ! empty( $args['date']['end'] ) ) { |
|
| 444 | + if (!empty($args['date']['end'])) { |
|
| 445 | 445 | |
| 446 | - $end = date( 'Y-m-d H:i:s', strtotime( $args['date']['end'] ) ); |
|
| 446 | + $end = date('Y-m-d H:i:s', strtotime($args['date']['end'])); |
|
| 447 | 447 | |
| 448 | 448 | $where .= " AND `created` <= '{$end}'"; |
| 449 | 449 | |
@@ -451,9 +451,9 @@ discard block |
||
| 451 | 451 | |
| 452 | 452 | } else { |
| 453 | 453 | |
| 454 | - $year = date( 'Y', strtotime( $args['date'] ) ); |
|
| 455 | - $month = date( 'm', strtotime( $args['date'] ) ); |
|
| 456 | - $day = date( 'd', strtotime( $args['date'] ) ); |
|
| 454 | + $year = date('Y', strtotime($args['date'])); |
|
| 455 | + $month = date('m', strtotime($args['date'])); |
|
| 456 | + $day = date('d', strtotime($args['date'])); |
|
| 457 | 457 | |
| 458 | 458 | $where .= " AND $year = YEAR ( created ) AND $month = MONTH ( created ) AND $day = DAY ( created )"; |
| 459 | 459 | } |
@@ -461,21 +461,21 @@ discard block |
||
| 461 | 461 | } |
| 462 | 462 | |
| 463 | 463 | // Subscriptions with a specific expiration date or in an expiration date range |
| 464 | - if( ! empty( $args['expiration'] ) ) { |
|
| 464 | + if (!empty($args['expiration'])) { |
|
| 465 | 465 | |
| 466 | - if( is_array( $args['expiration'] ) ) { |
|
| 466 | + if (is_array($args['expiration'])) { |
|
| 467 | 467 | |
| 468 | - if( ! empty( $args['expiration']['start'] ) ) { |
|
| 468 | + if (!empty($args['expiration']['start'])) { |
|
| 469 | 469 | |
| 470 | - $start = date( 'Y-m-d H:i:s', strtotime( $args['expiration']['start'] ) ); |
|
| 470 | + $start = date('Y-m-d H:i:s', strtotime($args['expiration']['start'])); |
|
| 471 | 471 | |
| 472 | 472 | $where .= " AND `expiration` >= '{$start}'"; |
| 473 | 473 | |
| 474 | 474 | } |
| 475 | 475 | |
| 476 | - if( ! empty( $args['expiration']['end'] ) ) { |
|
| 476 | + if (!empty($args['expiration']['end'])) { |
|
| 477 | 477 | |
| 478 | - $end = date( 'Y-m-d H:i:s', strtotime( $args['expiration']['end'] ) ); |
|
| 478 | + $end = date('Y-m-d H:i:s', strtotime($args['expiration']['end'])); |
|
| 479 | 479 | |
| 480 | 480 | $where .= " AND `expiration` <= '{$end}'"; |
| 481 | 481 | |
@@ -483,64 +483,64 @@ discard block |
||
| 483 | 483 | |
| 484 | 484 | } else { |
| 485 | 485 | |
| 486 | - $year = date( 'Y', strtotime( $args['expiration'] ) ); |
|
| 487 | - $month = date( 'm', strtotime( $args['expiration'] ) ); |
|
| 488 | - $day = date( 'd', strtotime( $args['expiration'] ) ); |
|
| 486 | + $year = date('Y', strtotime($args['expiration'])); |
|
| 487 | + $month = date('m', strtotime($args['expiration'])); |
|
| 488 | + $day = date('d', strtotime($args['expiration'])); |
|
| 489 | 489 | |
| 490 | 490 | $where .= " AND $year = YEAR ( expiration ) AND $month = MONTH ( expiration ) AND $day = DAY ( expiration )"; |
| 491 | 491 | } |
| 492 | 492 | |
| 493 | 493 | } |
| 494 | 494 | |
| 495 | - if ( ! empty( $args['search'] ) ) { |
|
| 495 | + if (!empty($args['search'])) { |
|
| 496 | 496 | |
| 497 | - if( false !== strpos( 'id:', $args['search'] ) ) { |
|
| 497 | + if (false !== strpos('id:', $args['search'])) { |
|
| 498 | 498 | |
| 499 | - $args['search'] = trim( str_replace( 'id:', '', $args['search'] ) ); |
|
| 500 | - $where .= " AND `id` = '" . esc_sql( $args['search'] ) . "'"; |
|
| 499 | + $args['search'] = trim(str_replace('id:', '', $args['search'])); |
|
| 500 | + $where .= " AND `id` = '" . esc_sql($args['search']) . "'"; |
|
| 501 | 501 | |
| 502 | - } else if( false !== strpos( $args['search'], 'txn:' ) ) { |
|
| 502 | + } else if (false !== strpos($args['search'], 'txn:')) { |
|
| 503 | 503 | |
| 504 | - $args['search'] = trim( str_replace( 'txn:', '', $args['search'] ) ); |
|
| 505 | - $where .= " AND `transaction_id` = '" . esc_sql( $args['search'] ) . "'"; |
|
| 504 | + $args['search'] = trim(str_replace('txn:', '', $args['search'])); |
|
| 505 | + $where .= " AND `transaction_id` = '" . esc_sql($args['search']) . "'"; |
|
| 506 | 506 | |
| 507 | - } else if( false !== strpos( $args['search'], 'profile_id:' ) ) { |
|
| 507 | + } else if (false !== strpos($args['search'], 'profile_id:')) { |
|
| 508 | 508 | |
| 509 | - $args['search'] = trim( str_replace( 'profile_id:', '', $args['search'] ) ); |
|
| 510 | - $where .= " AND `profile_id` = '" . esc_sql( $args['search'] ) . "'"; |
|
| 509 | + $args['search'] = trim(str_replace('profile_id:', '', $args['search'])); |
|
| 510 | + $where .= " AND `profile_id` = '" . esc_sql($args['search']) . "'"; |
|
| 511 | 511 | |
| 512 | - } else if( false !== strpos( $args['search'], 'product_id:' ) ) { |
|
| 512 | + } else if (false !== strpos($args['search'], 'product_id:')) { |
|
| 513 | 513 | |
| 514 | - $args['search'] = trim( str_replace( 'product_id:', '', $args['search'] ) ); |
|
| 515 | - $where .= " AND `product_id` = '" . esc_sql( $args['search'] ) . "'"; |
|
| 514 | + $args['search'] = trim(str_replace('product_id:', '', $args['search'])); |
|
| 515 | + $where .= " AND `product_id` = '" . esc_sql($args['search']) . "'"; |
|
| 516 | 516 | |
| 517 | - } else if( false !== strpos( $args['search'], 'customer_id:' ) ) { |
|
| 517 | + } else if (false !== strpos($args['search'], 'customer_id:')) { |
|
| 518 | 518 | |
| 519 | - $args['search'] = trim( str_replace( 'customer_id:', '', $args['search'] ) ); |
|
| 520 | - $where .= " AND `customer_id` = '" . esc_sql( $args['search'] ) . "'"; |
|
| 519 | + $args['search'] = trim(str_replace('customer_id:', '', $args['search'])); |
|
| 520 | + $where .= " AND `customer_id` = '" . esc_sql($args['search']) . "'"; |
|
| 521 | 521 | |
| 522 | 522 | } else { |
| 523 | 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'] ) . "' )"; |
|
| 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 | 525 | |
| 526 | 526 | } |
| 527 | 527 | |
| 528 | 528 | } |
| 529 | 529 | |
| 530 | - $cache_key = md5( 'wpinv_subscriptions_count' . serialize( $args ) ); |
|
| 530 | + $cache_key = md5('wpinv_subscriptions_count' . serialize($args)); |
|
| 531 | 531 | |
| 532 | - $count = wp_cache_get( $cache_key, 'subscriptions' ); |
|
| 532 | + $count = wp_cache_get($cache_key, 'subscriptions'); |
|
| 533 | 533 | |
| 534 | - if( $count === false ) { |
|
| 534 | + if ($count === false) { |
|
| 535 | 535 | |
| 536 | 536 | $sql = "SELECT COUNT($this->primary_key) FROM " . $this->table_name . "{$where};"; |
| 537 | - $count = $wpdb->get_var( $sql ); |
|
| 537 | + $count = $wpdb->get_var($sql); |
|
| 538 | 538 | |
| 539 | - wp_cache_set( $cache_key, $count, 'subscriptions', 3600 ); |
|
| 539 | + wp_cache_set($cache_key, $count, 'subscriptions', 3600); |
|
| 540 | 540 | |
| 541 | 541 | } |
| 542 | 542 | |
| 543 | - return absint( $count ); |
|
| 543 | + return absint($count); |
|
| 544 | 544 | |
| 545 | 545 | } |
| 546 | 546 | |
@@ -553,7 +553,7 @@ discard block |
||
| 553 | 553 | public function create_table() { |
| 554 | 554 | global $wpdb; |
| 555 | 555 | |
| 556 | - require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); |
|
| 556 | + require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); |
|
| 557 | 557 | |
| 558 | 558 | $sql = "CREATE TABLE " . $this->table_name . " ( |
| 559 | 559 | id bigint(20) NOT NULL AUTO_INCREMENT, |
@@ -578,9 +578,9 @@ discard block |
||
| 578 | 578 | KEY customer_and_status ( customer_id, status) |
| 579 | 579 | ) CHARACTER SET utf8 COLLATE utf8_general_ci;"; |
| 580 | 580 | |
| 581 | - dbDelta( $sql ); |
|
| 581 | + dbDelta($sql); |
|
| 582 | 582 | |
| 583 | - update_option( $this->table_name . '_db_version', $this->version ); |
|
| 583 | + update_option($this->table_name . '_db_version', $this->version); |
|
| 584 | 584 | } |
| 585 | 585 | |
| 586 | 586 | } |
| 587 | 587 | \ No newline at end of file |
