← All changes | inc/Databases/class-lp-quiz-questions-db.php +60 -60 4.3.9 → 4.4.9 View file →

		@@ -1,60 +1,60 @@
1		-<?php
2		-
3		-if ( ! defined( 'ABSPATH' ) ) {
4		- exit; // Exit if accessed directly
5		-}
6		-
7		-/**
8		- * Class LP_Quiz_Questions_DB
9		- *
10		- * @since 4.1.6
11		- * @version 1.0.0
12		- */
13		-class LP_Quiz_Questions_DB extends LP_Database {
14		- private static $_instance;
15		-
16		- protected function __construct() {
17		- parent::__construct();
18		- }
19		-
20		- public static function getInstance() {
21		- if ( is_null( self::$_instance ) ) {
22		- self::$_instance = new self();
23		- }
24		-
25		- return self::$_instance;
26		- }
27		-
28		- /**
29		- * @throws Exception
30		- */
31		- public function get_quiz_questions( LP_Quiz_Questions_Filter $filter, &$total_rows = 0 ) {
32		- $default_fields = $this->get_cols_of_table( $this->tb_lp_quiz_questions );
33		- $filter->fields = array_merge( $default_fields, $filter->fields );
34		-
35		- if ( empty( $filter->collection ) ) {
36		- $filter->collection = $this->tb_lp_quiz_questions;
37		- }
38		-
39		- if ( empty( $filter->collection_alias ) ) {
40		- $filter->collection_alias = 'qq';
41		- }
42		-
43		-
44		-
45		- // Question ids
46		- if ( ! empty( $filter->question_ids ) ) {
47		- $question_ids_format = LP_Helper::db_format_array( $filter->question_ids, '%s' );
48		- $filter->where[] = $this->wpdb->prepare( "AND {$filter->collection_alias}.question_id IN (" . $question_ids_format . ')', $filter->question_ids );
49		- }
50		-
51		- // Quiz ids
52		- if ( ! empty( $filter->quiz_ids ) ) {
53		- $quiz_ids_format = LP_Helper::db_format_array( $filter->question_ids, '%s' );
54		- $filter->where[] = $this->wpdb->prepare( "AND {$filter->collection_alias}.quiz_id IN (" . $quiz_ids_format . ')', $filter->quiz_ids );
55		- }
56		-
57		- return $this->execute( $filter, $total_rows );
58		- }
59		-}
60		-
	1	+<?php
	2	+
	3	+if ( ! defined( 'ABSPATH' ) ) {
	4	+ exit; // Exit if accessed directly
	5	+}
	6	+
	7	+/**
	8	+ * Class LP_Quiz_Questions_DB
	9	+ *
	10	+ * @since 4.1.6
	11	+ * @version 1.0.0
	12	+ */
	13	+class LP_Quiz_Questions_DB extends LP_Database {
	14	+ private static $_instance;
	15	+
	16	+ protected function __construct() {
	17	+ parent::__construct();
	18	+ }
	19	+
	20	+ public static function getInstance() {
	21	+ if ( is_null( self::$_instance ) ) {
	22	+ self::$_instance = new self();
	23	+ }
	24	+
	25	+ return self::$_instance;
	26	+ }
	27	+
	28	+ /**
	29	+ * @throws Exception
	30	+ */
	31	+ public function get_quiz_questions( LP_Quiz_Questions_Filter $filter, &$total_rows = 0 ) {
	32	+ $default_fields = $this->get_cols_of_table( $this->tb_lp_quiz_questions );
	33	+ $filter->fields = array_merge( $default_fields, $filter->fields );
	34	+
	35	+ if ( empty( $filter->collection ) ) {
	36	+ $filter->collection = $this->tb_lp_quiz_questions;
	37	+ }
	38	+
	39	+ if ( empty( $filter->collection_alias ) ) {
	40	+ $filter->collection_alias = 'qq';
	41	+ }
	42	+
	43	+
	44	+
	45	+ // Question ids
	46	+ if ( ! empty( $filter->question_ids ) ) {
	47	+ $question_ids_format = LP_Helper::db_format_array( $filter->question_ids, '%s' );
	48	+ $filter->where[] = $this->wpdb->prepare( "AND {$filter->collection_alias}.question_id IN (" . $question_ids_format . ')', $filter->question_ids );
	49	+ }
	50	+
	51	+ // Quiz ids
	52	+ if ( ! empty( $filter->quiz_ids ) ) {
	53	+ $quiz_ids_format = LP_Helper::db_format_array( $filter->question_ids, '%s' );
	54	+ $filter->where[] = $this->wpdb->prepare( "AND {$filter->collection_alias}.quiz_id IN (" . $quiz_ids_format . ')', $filter->quiz_ids );
	55	+ }
	56	+
	57	+ return $this->execute( $filter, $total_rows );
	58	+ }
	59	+}
	60	+