eventespresso /
event-espresso-core
| @@ 1502-1529 (lines=28) @@ | ||
| 1499 | } |
|
| 1500 | ||
| 1501 | ||
| 1502 | public function get_categories($per_page = 10, $current_page = 1, $count = false) |
|
| 1503 | { |
|
| 1504 | ||
| 1505 | // testing term stuff |
|
| 1506 | $orderby = isset($this->_req_data['orderby']) ? $this->_req_data['orderby'] : 'Term.term_id'; |
|
| 1507 | $order = isset($this->_req_data['order']) ? $this->_req_data['order'] : 'DESC'; |
|
| 1508 | $limit = ($current_page - 1) * $per_page; |
|
| 1509 | $where = array('taxonomy' => 'espresso_venue_categories'); |
|
| 1510 | if (isset($this->_req_data['s'])) { |
|
| 1511 | $sstr = '%' . $this->_req_data['s'] . '%'; |
|
| 1512 | $where['OR'] = array( |
|
| 1513 | 'Term.name' => array('LIKE', $sstr), |
|
| 1514 | 'description' => array('LIKE', $sstr), |
|
| 1515 | ); |
|
| 1516 | } |
|
| 1517 | ||
| 1518 | $query_params = array( |
|
| 1519 | $where, |
|
| 1520 | 'order_by' => array($orderby => $order), |
|
| 1521 | 'limit' => $limit . ',' . $per_page, |
|
| 1522 | 'force_join' => array('Term'), |
|
| 1523 | ); |
|
| 1524 | ||
| 1525 | $categories = $count ? EEM_Term_Taxonomy::instance()->count($query_params, 'term_id') |
|
| 1526 | : EEM_Term_Taxonomy::instance()->get_all($query_params); |
|
| 1527 | ||
| 1528 | return $categories; |
|
| 1529 | } |
|
| 1530 | ||
| 1531 | ||
| 1532 | /* end category stuff */ |
|
| @@ 2677-2701 (lines=25) @@ | ||
| 2674 | * @param bool $count |
|
| 2675 | * @return EE_Base_Class[]|EE_Term_Taxonomy[]|int |
|
| 2676 | */ |
|
| 2677 | public function get_categories($per_page = 10, $current_page = 1, $count = false) |
|
| 2678 | { |
|
| 2679 | // testing term stuff |
|
| 2680 | $orderby = isset($this->_req_data['orderby']) ? $this->_req_data['orderby'] : 'Term.term_id'; |
|
| 2681 | $order = isset($this->_req_data['order']) ? $this->_req_data['order'] : 'DESC'; |
|
| 2682 | $limit = ($current_page - 1) * $per_page; |
|
| 2683 | $where = array('taxonomy' => EEM_CPT_Base::EVENT_CATEGORY_TAXONOMY); |
|
| 2684 | if (isset($this->_req_data['s'])) { |
|
| 2685 | $sstr = '%' . $this->_req_data['s'] . '%'; |
|
| 2686 | $where['OR'] = array( |
|
| 2687 | 'Term.name' => array('LIKE', $sstr), |
|
| 2688 | 'description' => array('LIKE', $sstr), |
|
| 2689 | ); |
|
| 2690 | } |
|
| 2691 | $query_params = array( |
|
| 2692 | $where, |
|
| 2693 | 'order_by' => array($orderby => $order), |
|
| 2694 | 'limit' => $limit . ',' . $per_page, |
|
| 2695 | 'force_join' => array('Term'), |
|
| 2696 | ); |
|
| 2697 | $categories = $count |
|
| 2698 | ? EEM_Term_Taxonomy::instance()->count($query_params, 'term_id') |
|
| 2699 | : EEM_Term_Taxonomy::instance()->get_all($query_params); |
|
| 2700 | return $categories; |
|
| 2701 | } |
|
| 2702 | ||
| 2703 | /* end category stuff */ |
|
| 2704 | /**************/ |
|
