meta_helper.php — LatePoint – Calendar Booking Plugin for Appointments and Events 5.6.6

latepoint / lib / helpers / meta_helper.php

latepoint / lib / helpers Last commit date

meta_helper.php

131 lines

1	<?php
2
3	class OsMetaHelper {
4
5	function __construct() {
6	}
7
8	public static function get_service_meta_by_key( $meta_key, $service_id, $default = false ) {
9	$meta = new OsServiceMetaModel();
10	return $meta->get_by_key( $meta_key, $service_id, $default );
11	}
12
13	public static function save_service_meta_by_key( $meta_key, $meta_value, $service_id ) {
14	$meta = new OsServiceMetaModel();
15	return $meta->save_by_key( $meta_key, $meta_value, $service_id );
16	}
17
18	public static function delete_service_meta_by_key( $meta_key, $service_id ) {
19	$meta = new OsServiceMetaModel();
20	return $meta->delete_by_key( $meta_key, $service_id );
21	}
22
23
24	public static function get_agent_meta_by_key( $meta_key, $agent_id, $default = false ) {
25	$meta = new OsAgentMetaModel();
26	return $meta->get_by_key( $meta_key, $agent_id, $default );
27	}
28
29	public static function save_agent_meta_by_key( $meta_key, $meta_value, $agent_id ) {
30	$meta = new OsAgentMetaModel();
31	return $meta->save_by_key( $meta_key, $meta_value, $agent_id );
32	}
33
34	public static function delete_agent_meta_by_key( $meta_key, $agent_id ) {
35	$meta = new OsAgentMetaModel();
36	return $meta->delete_by_key( $meta_key, $agent_id );
37	}
38
39
40
41	public static function get_booking_metas( $booking_id, $default = [] ) {
42	$meta = new OsBookingMetaModel();
43	return $meta->get_by_object_id( $booking_id, $default );
44	}
45
46	public static function get_booking_meta_by_key( $meta_key, $booking_id, $default = false ) {
47	$meta = new OsBookingMetaModel();
48	return $meta->get_by_key( $meta_key, $booking_id, $default );
49	}
50
51	public static function save_booking_meta_by_key( $meta_key, $meta_value, $booking_id ) {
52	$meta = new OsBookingMetaModel();
53	return $meta->save_by_key( $meta_key, $meta_value, $booking_id );
54	}
55
56	public static function delete_booking_meta( $meta_key, $booking_id ) {
57	if ( empty( $meta_key ) \|\| empty( $booking_id ) ) {
58	return;
59	}
60	$booking_meta_model = new OsBookingMetaModel();
61	$booking_meta_model->delete_by_key( $meta_key, $booking_id );
62	}
63
64
65	public static function get_customer_metas( $customer_id, $default = [] ) {
66	$meta = new OsCustomerMetaModel();
67	return $meta->get_by_object_id( $customer_id, $default );
68	}
69
70	public static function get_customer_meta_by_key( $meta_key, $customer_id, $default = false ) {
71	$meta = new OsCustomerMetaModel();
72	return $meta->get_by_key( $meta_key, $customer_id, $default );
73	}
74
75	public static function save_customer_meta_by_key( $meta_key, $meta_value, $customer_id ) {
76	$meta = new OsCustomerMetaModel();
77	return $meta->save_by_key( $meta_key, $meta_value, $customer_id );
78	}
79
80	public static function delete_customer_meta_by_key( $meta_key, $customer_id ) {
81	$meta = new OsCustomerMetaModel();
82	return $meta->delete_by_key( $meta_key, $customer_id );
83	}
84
85	/**
86	* Get Customers By Filter
87	* @param $filters
88	* @return array
89	*/
90	public static function get_customers_by_filter( $filters ): array {
91	$meta = new OsCustomerMetaModel();
92	$where = [];
93	foreach ( $filters as $filter_key => $filter_value ) {
94	$where['OR'][] = [
95	'AND' => [
96	'meta_key' => $filter_key,
97	'meta_value LIKE' => '%' . esc_sql( $filter_value ) . '%',
98	],
99	];
100	}
101	$customers = $meta->select( 'object_id' )
102	->where( $where )
103	->group_by( 'object_id' )
104	->having( 'COUNT(DISTINCT meta_key)=' . count( $filters ) )
105	->get_results();
106
107	return array_column( $customers, 'object_id' );
108	}
109
110	public static function get_booking_id_by_meta_value( $meta_key, $meta_value ) {
111	$meta = new OsBookingMetaModel();
112	return $meta->get_object_id_by_value( $meta_key, $meta_value );
113	}
114
115	public static function get_order_id_by_meta_value( $meta_key, $meta_value ) {
116	$meta = new OsOrderMetaModel();
117	return $meta->get_object_id_by_value( $meta_key, $meta_value );
118	}
119
120	public static function get_order_meta_by_key( $meta_key, $order_id, $default = false ) {
121	$meta = new OsOrderMetaModel();
122	return $meta->get_by_key( $meta_key, $order_id, $default );
123	}
124
125	public static function save_order_meta_by_key( $meta_key, $meta_value, $order_id ) {
126	$meta = new OsOrderMetaModel();
127	return $meta->save_by_key( $meta_key, $meta_value, $order_id );
128	}
129	}
130	?>
131