| @@ -1,128 +1,128 @@ | ||
| 1 | -<?php | |
| 2 | -/** | |
| 3 | - * Class LP_Filter | |
| 4 | - * | |
| 5 | - * @author tungnx | |
| 6 | - * @package LearnPress/Classes/Filters | |
| 7 | - * @version 4.0.2 | |
| 8 | - */ | |
| 9 | - | |
| 10 | -/** | |
| 11 | - * Prevent loading this file directly | |
| 12 | - */ | |
| 13 | -defined( 'ABSPATH' ) || exit(); | |
| 14 | - | |
| 15 | -class LP_Filter { | |
| 16 | - const ORDER_DESC = 'DESC'; | |
| 17 | - const ORDER_ASC = 'ASC'; | |
| 18 | - /** | |
| 19 | - * @var int set -1 for no limit | |
| 20 | - */ | |
| 21 | - public $limit = 10; | |
| 22 | - /** | |
| 23 | - * @var int | |
| 24 | - */ | |
| 25 | - public $max_limit = 100; | |
| 26 | - /** | |
| 27 | - * @var array query ON | |
| 28 | - */ | |
| 29 | - public $sort_by = array(); | |
| 30 | - /** | |
| 31 | - * @var string | |
| 32 | - */ | |
| 33 | - public $group_by = ''; | |
| 34 | - /** | |
| 35 | - * @var string field name for order, EX ID | |
| 36 | - */ | |
| 37 | - public $order_by = ''; | |
| 38 | - /** | |
| 39 | - * @var string DESC|ASC | |
| 40 | - */ | |
| 41 | - public $order = ''; | |
| 42 | - /** | |
| 43 | - * @var string | |
| 44 | - */ | |
| 45 | - public $key_word = ''; | |
| 46 | - /** | |
| 47 | - * @var int | |
| 48 | - */ | |
| 49 | - public $page = 1; | |
| 50 | - /** | |
| 51 | - * Name table query Or Query nested | |
| 52 | - * EX: FROM 'wp_posts' | |
| 53 | - * OR: FROM (SELECT * FROM 'wp_posts') AS P | |
| 54 | - * | |
| 55 | - * @var string | |
| 56 | - */ | |
| 57 | - public $collection = ''; | |
| 58 | - /** | |
| 59 | - * Alias collection | |
| 60 | - * EX: FROM 'wp_posts' AS p | |
| 61 | - * "p" is alias | |
| 62 | - * | |
| 63 | - * @var string | |
| 64 | - */ | |
| 65 | - public $collection_alias = ''; | |
| 66 | - /** | |
| 67 | - * @var array | |
| 68 | - */ | |
| 69 | - public $fields = array(); | |
| 70 | - /** | |
| 71 | - * For get only columns set on it | |
| 72 | - * | |
| 73 | - * @var array | |
| 74 | - */ | |
| 75 | - public $only_fields = array(); | |
| 76 | - /** | |
| 77 | - * Exclude columns set on fields | |
| 78 | - * | |
| 79 | - * @var array | |
| 80 | - */ | |
| 81 | - public $exclude_fields = array(); | |
| 82 | - /** | |
| 83 | - * @var array for purpose run query update. | |
| 84 | - */ | |
| 85 | - public $set = array(); | |
| 86 | - /** | |
| 87 | - * @var array | |
| 88 | - */ | |
| 89 | - public $where = array(); | |
| 90 | - /** | |
| 91 | - * @var array | |
| 92 | - */ | |
| 93 | - public $join = array(); | |
| 94 | - /** | |
| 95 | - * @var array | |
| 96 | - */ | |
| 97 | - public $union = array(); | |
| 98 | - /** | |
| 99 | - * @var bool set true to run query count | |
| 100 | - */ | |
| 101 | - public $run_query_count = true; | |
| 102 | - /** | |
| 103 | - * @var bool set true to return total_rows | |
| 104 | - */ | |
| 105 | - public $query_count = false; | |
| 106 | - /** | |
| 107 | - * @var string Ex: ID, for query: COUNT(ID) | |
| 108 | - */ | |
| 109 | - public $field_count = 'ID'; | |
| 110 | - /** | |
| 111 | - * @var bool set true to return string query | |
| 112 | - */ | |
| 113 | - public $return_string_query = false; | |
| 114 | - /** | |
| 115 | - * @var false set true to return string query to debug | |
| 116 | - */ | |
| 117 | - public $debug_string_query = false; | |
| 118 | - /** | |
| 119 | - * @var string | |
| 120 | - */ | |
| 121 | - public $query_type = 'get_results'; | |
| 122 | - /** | |
| 123 | - * @var object stdclass | |
| 124 | - */ | |
| 125 | - public $filter_extra; | |
| 126 | -} | |
| 127 | - | |
| 128 | - | |
| 1 | +<?php | |
| 2 | +/** | |
| 3 | + * Class LP_Filter | |
| 4 | + * | |
| 5 | + * @author tungnx | |
| 6 | + * @package LearnPress/Classes/Filters | |
| 7 | + * @version 4.0.2 | |
| 8 | + */ | |
| 9 | + | |
| 10 | +/** | |
| 11 | + * Prevent loading this file directly | |
| 12 | + */ | |
| 13 | +defined( 'ABSPATH' ) || exit(); | |
| 14 | + | |
| 15 | +class LP_Filter { | |
| 16 | + const ORDER_DESC = 'DESC'; | |
| 17 | + const ORDER_ASC = 'ASC'; | |
| 18 | + /** | |
| 19 | + * @var int set -1 for no limit | |
| 20 | + */ | |
| 21 | + public $limit = 10; | |
| 22 | + /** | |
| 23 | + * @var int | |
| 24 | + */ | |
| 25 | + public $max_limit = 100; | |
| 26 | + /** | |
| 27 | + * @var array query ON | |
| 28 | + */ | |
| 29 | + public $sort_by = array(); | |
| 30 | + /** | |
| 31 | + * @var string | |
| 32 | + */ | |
| 33 | + public $group_by = ''; | |
| 34 | + /** | |
| 35 | + * @var string field name for order, EX ID | |
| 36 | + */ | |
| 37 | + public $order_by = ''; | |
| 38 | + /** | |
| 39 | + * @var string DESC|ASC | |
| 40 | + */ | |
| 41 | + public $order = ''; | |
| 42 | + /** | |
| 43 | + * @var string | |
| 44 | + */ | |
| 45 | + public $key_word = ''; | |
| 46 | + /** | |
| 47 | + * @var int | |
| 48 | + */ | |
| 49 | + public $page = 1; | |
| 50 | + /** | |
| 51 | + * Name table query Or Query nested | |
| 52 | + * EX: FROM 'wp_posts' | |
| 53 | + * OR: FROM (SELECT * FROM 'wp_posts') AS P | |
| 54 | + * | |
| 55 | + * @var string | |
| 56 | + */ | |
| 57 | + public $collection = ''; | |
| 58 | + /** | |
| 59 | + * Alias collection | |
| 60 | + * EX: FROM 'wp_posts' AS p | |
| 61 | + * "p" is alias | |
| 62 | + * | |
| 63 | + * @var string | |
| 64 | + */ | |
| 65 | + public $collection_alias = ''; | |
| 66 | + /** | |
| 67 | + * @var array | |
| 68 | + */ | |
| 69 | + public $fields = array(); | |
| 70 | + /** | |
| 71 | + * For get only columns set on it | |
| 72 | + * | |
| 73 | + * @var array | |
| 74 | + */ | |
| 75 | + public $only_fields = array(); | |
| 76 | + /** | |
| 77 | + * Exclude columns set on fields | |
| 78 | + * | |
| 79 | + * @var array | |
| 80 | + */ | |
| 81 | + public $exclude_fields = array(); | |
| 82 | + /** | |
| 83 | + * @var array for purpose run query update. | |
| 84 | + */ | |
| 85 | + public $set = array(); | |
| 86 | + /** | |
| 87 | + * @var array | |
| 88 | + */ | |
| 89 | + public $where = array(); | |
| 90 | + /** | |
| 91 | + * @var array | |
| 92 | + */ | |
| 93 | + public $join = array(); | |
| 94 | + /** | |
| 95 | + * @var array | |
| 96 | + */ | |
| 97 | + public $union = array(); | |
| 98 | + /** | |
| 99 | + * @var bool set true to run query count | |
| 100 | + */ | |
| 101 | + public $run_query_count = true; | |
| 102 | + /** | |
| 103 | + * @var bool set true to return total_rows | |
| 104 | + */ | |
| 105 | + public $query_count = false; | |
| 106 | + /** | |
| 107 | + * @var string Ex: ID, for query: COUNT(ID) | |
| 108 | + */ | |
| 109 | + public $field_count = 'ID'; | |
| 110 | + /** | |
| 111 | + * @var bool set true to return string query | |
| 112 | + */ | |
| 113 | + public $return_string_query = false; | |
| 114 | + /** | |
| 115 | + * @var false set true to return string query to debug | |
| 116 | + */ | |
| 117 | + public $debug_string_query = false; | |
| 118 | + /** | |
| 119 | + * @var string | |
| 120 | + */ | |
| 121 | + public $query_type = 'get_results'; | |
| 122 | + /** | |
| 123 | + * @var object stdclass | |
| 124 | + */ | |
| 125 | + public $filter_extra; | |
| 126 | +} | |
| 127 | + | |
| 128 | + | |