give / src / EventTickets / Repositories / EventRepository.php

EventRepository.php in GiveWP – Donation Plugin and Fundraising Platform 4.15.2, at src/EventTickets/Repositories/EventRepository.php

203 lines 5.4 KB

Raw Download Zip

1	<?php
2
3	namespace Give\EventTickets\Repositories;
4
5	use Give\EventTickets\Models\Event;
6	use Give\Framework\Database\DB;
7	use Give\Framework\Exceptions\Primitives\Exception;
8	use Give\Framework\Exceptions\Primitives\InvalidArgumentException;
9	use Give\Framework\Models\ModelQueryBuilder;
10	use Give\Framework\Support\Facades\DateTime\Temporal;
11	use Give\Helpers\Hooks;
12	use Give\Log\Log;
13
14	/**
15	* @since 3.6.0
16	*/
17	class EventRepository
18	{
19
20	/**
21	* @since 3.6.0
22	*
23	* @var string[]
24	*/
25	private $requiredProperties = [
26	'title',
27	'startDateTime',
28	];
29
30	/**
31	* @since 3.6.0
32	*/
33	public function getById(int $id): ?Event
34	{
35	return $this->prepareQuery()
36	->where('id', $id)
37	->get();
38	}
39
40	/**
41	* @since 3.6.0
42	*/
43	public function queryById(int $id): ModelQueryBuilder
44	{
45	return $this->prepareQuery()
46	->where('id', $id);
47	}
48
49	/**
50	* @since 3.6.0
51	*
52	* @throws Exception\|InvalidArgumentException
53	*/
54	public function insert(Event $event): void
55	{
56	$this->validate($event);
57
58	Hooks::doAction('givewp_events_event_creating', $event);
59
60	$createdDateTime = Temporal::withoutMicroseconds($event->createdAt ?: Temporal::getCurrentDateTime());
61
62	DB::query('START TRANSACTION');
63
64	try {
65	DB::table('give_events')
66	->insert([
67	'title' => $event->title,
68	'description' => $event->description,
69	'start_datetime' => $event->startDateTime->format('Y-m-d H:i:s'),
70	'end_datetime' => $event->endDateTime ? $event->endDateTime->format('Y-m-d H:i:s') : null,
71	'ticket_close_datetime' => $event->ticketCloseDateTime ? $event->ticketCloseDateTime->format(
72	'Y-m-d H:i:s'
73	) : null,
74	'created_at' => $createdDateTime->format('Y-m-d H:i:s'),
75	'updated_at' => $createdDateTime->format('Y-m-d H:i:s'),
76	]);
77
78	$eventId = DB::last_insert_id();
79	} catch (Exception $exception) {
80	DB::query('ROLLBACK');
81
82	Log::error('Failed creating an event', compact('event'));
83
84	throw new $exception('Failed creating an event');
85	}
86
87	$event->id = $eventId;
88	$event->createdAt = $createdDateTime;
89	$event->updatedAt = $createdDateTime;
90
91	DB::query('COMMIT');
92
93	Hooks::doAction('givewp_events_event_created', $event);
94	}
95
96	/**
97	* @since 3.6.0
98	*
99	* @throws Exception\|InvalidArgumentException
100	*/
101	public function update(Event $event): void
102	{
103	$this->validate($event);
104
105	Hooks::doAction('givewp_events_event_updating', $event);
106
107	$updatedDateTime = Temporal::withoutMicroseconds(Temporal::getCurrentDateTime());
108
109	DB::query('START TRANSACTION');
110
111	try {
112	DB::table('give_events')
113	->where('id', $event->id)
114	->update([
115	'title' => $event->title,
116	'description' => $event->description,
117	'start_datetime' => $event->startDateTime->format('Y-m-d H:i:s'),
118	'end_datetime' => $event->endDateTime ? $event->endDateTime->format('Y-m-d H:i:s') : null,
119	'ticket_close_datetime' => $event->ticketCloseDateTime ? $event->ticketCloseDateTime->format(
120	'Y-m-d H:i:s'
121	) : null,
122	'updated_at' => $updatedDateTime->format('Y-m-d H:i:s'),
123	]);
124	} catch (Exception $exception) {
125	DB::query('ROLLBACK');
126
127	Log::error('Failed updating an event', compact('event'));
128
129	throw new $exception('Failed updating an event');
130	}
131
132	$event->updatedAt = $updatedDateTime;
133
134	DB::query('COMMIT');
135
136	Hooks::doAction('givewp_events_event_updated', $event);
137	}
138
139	/**
140	* @since 3.6.0
141	*
142	* @throws Exception
143	*/
144	public function delete(Event $event): bool
145	{
146	DB::query('START TRANSACTION');
147
148	Hooks::doAction('givewp_events_event_deleting', $event);
149
150	try {
151	DB::table('give_events')
152	->where('id', $event->id)
153	->delete();
154	} catch (Exception $exception) {
155	DB::query('ROLLBACK');
156
157	Log::error('Failed deleting an event', compact('event'));
158
159	throw new $exception('Failed deleting an event');
160	}
161
162	DB::query('COMMIT');
163
164	Hooks::doAction('givewp_events_event_deleted', $event);
165
166	return true;
167	}
168
169	/**
170	* @since 3.6.0
171	*/
172	private function validate(Event $event): void
173	{
174	foreach ($this->requiredProperties as $key) {
175	if (!isset($event->$key)) {
176	throw new InvalidArgumentException("'$key' is required.");
177	}
178	}
179	}
180
181	/**
182	* @since 3.6.0
183	*
184	* @return ModelQueryBuilder<Event>
185	*/
186	public function prepareQuery(): ModelQueryBuilder
187	{
188	$builder = new ModelQueryBuilder(Event::class);
189
190	return $builder->from('give_events')
191	->select(
192	'id',
193	'title',
194	'description',
195	'start_datetime',
196	'end_datetime',
197	'ticket_close_datetime',
198	'created_at',
199	'updated_at'
200	);
201	}
202	}
203