class-job-listing-stats.php — WP Job Manager 2.4.7

wp-job-manager / includes / class-job-listing-stats.php

wp-job-manager / includes Last commit date

class-job-listing-stats.php

137 lines

1	<?php
2	/**
3	* File containing the class WP_Job_Manager_Stats
4	*
5	* @package wp-job-manager
6	*/
7
8	namespace WP_Job_Manager;
9
10	if ( ! defined( 'ABSPATH' ) ) {
11	exit;
12	}
13
14	/**
15	* This class is responsible for initializing all aspects of stats for wpjm.
16	*/
17	class Job_Listing_Stats {
18
19	const VIEW = 'job_view';
20	const VIEW_UNIQUE = 'job_view_unique';
21	const SEARCH_IMPRESSION = 'job_search_impression';
22	const APPLY_CLICK = 'job_apply_click';
23
24	/**
25	* Job listing post ID.
26	*
27	* @var mixed
28	*/
29	private $job_id;
30
31	/**
32	* Start date of the period queried.
33	*
34	* @var string
35	*/
36	private $start_date;
37
38	/**
39	* End date of the period queried.
40	*
41	* @var string
42	*/
43	private $end_date;
44
45	/**
46	* Stats for a single job listing.
47	*
48	* @since 2.3.0
49	*
50	* @param int $job_id
51	* @param \DateTimeInterface[] $date_range Array of start and end date. Defaults to a range from the job's publishing date to the current day.
52	*/
53	public function __construct( $job_id, $date_range = [] ) {
54
55	$this->job_id = $job_id;
56	$this->start_date = ( $date_range[0] ?? get_post_datetime( $job_id ) )->format( 'Y-m-d' );
57	$this->end_date = ( $date_range[1] ?? new \DateTime() )->format( 'Y-m-d' );
58	}
59
60	/**
61	* Get total counts for an event.
62	*
63	* @param string $event
64	*
65	* @return int
66	*/
67	public function get_event_total( $event ) {
68
69	global $wpdb;
70
71	$cache_key = 'wpjm_stats_sum_' . $event . '_' . $this->job_id;
72	$sum = wp_cache_get( $cache_key, Stats::CACHE_GROUP );
73
74	if ( false !== $sum ) {
75	return $sum;
76	}
77
78	// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery
79	$sum = $wpdb->get_var(
80	$wpdb->prepare(
81	"SELECT SUM(count) FROM {$wpdb->wpjm_stats}
82	WHERE post_id = %d AND name = %s AND date BETWEEN %s AND %s",
83	$this->job_id,
84	$event,
85	$this->start_date,
86	$this->end_date,
87	)
88	);
89
90	$sum = is_numeric( $sum ) ? (int) $sum : 0;
91
92	wp_cache_set( $cache_key, $sum, Stats::CACHE_GROUP, HOUR_IN_SECONDS );
93
94	return $sum;
95	}
96
97	/**
98	* Get daily breakdown of stats for an event.
99	*
100	* @param string $event
101	*
102	* @return array
103	*/
104	public function get_event_daily( $event ) {
105	global $wpdb;
106
107	$cache_key = 'wpjm_stats_daily_' . $event . '_' . $this->job_id;
108	$views = wp_cache_get( $cache_key, Stats::CACHE_GROUP );
109
110	if ( false !== $views ) {
111	return $views;
112	}
113
114	// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery
115	$views = $wpdb->get_results(
116	$wpdb->prepare(
117	"SELECT date, count FROM {$wpdb->wpjm_stats}
118	WHERE post_id = %d AND name = %s AND date BETWEEN %s AND %s
119	ORDER BY date ASC",
120	$this->job_id,
121	$event,
122	$this->start_date,
123	$this->end_date,
124	),
125	OBJECT_K
126	);
127
128	$views = array_map( fn( $view ) => (int) $view->count, $views );
129
130	wp_cache_set( $cache_key, $views, Stats::CACHE_GROUP, strtotime( 'tomorrow' ) - time() );
131
132	return $views;
133
134	}
135
136	}
137