Open-source event management and ticket selling platform — perfect for concerts, conferences, and everything in between 🎟️ If you find this project helpful, please consider giving us a star ⭐️
PHP attendize-alternativedoor-managementevent-check-inevent-managementevent-registrationevent-ticketingeventbrite-alternativeeventslaravelopen-sourcephpreactself-hostedsell-ticketssell-tickets-onlineticket-sellingticketing-systemtickettailor-alternativetito-alternative
<?php
namespace HiEvents\Services\Domain\Report\Reports;
use HiEvents\Services\Domain\Report\AbstractReportService;
use Illuminate\Support\Carbon;
class DailySalesReport extends AbstractReportService
{
public function getSqlQuery(Carbon $startDate, Carbon $endDate, ?int $occurrenceId = null): string
{
$startDateStr = $startDate->toDateString();
$endDateStr = $endDate->toDateString();
if ($occurrenceId !== null) {
return <<<SQL
WITH date_range AS (
SELECT generate_series('$startDateStr'::date, '$endDateStr'::date, '1 day'::interval) AS date
)
SELECT
d.date,
COALESCE(eods.sales_total_gross, 0.00) AS sales_total_gross,
COALESCE(eods.total_tax, 0.00) AS total_tax,
COALESCE(eods.sales_total_before_additions, 0.00) AS sales_total_before_additions,
COALESCE(eods.products_sold, 0) AS products_sold,
COALESCE(eods.orders_created, 0) AS orders_created,
COALESCE(eods.total_fee, 0.00) AS total_fee,
COALESCE(eods.total_refunded, 0.00) AS total_refunded,
0 AS total_views
FROM
date_range d
LEFT JOIN event_occurrence_daily_statistics eods
ON d.date = eods.date
AND eods.event_id = :event_id
AND eods.event_occurrence_id = :occurrence_id
ORDER BY d.date desc;
SQL;
}
return <<<SQL
WITH date_range AS (
SELECT generate_series('$startDateStr'::date, '$endDateStr'::date, '1 day'::interval) AS date
)
SELECT
d.date,
COALESCE(eds.sales_total_gross, 0.00) AS sales_total_gross,
COALESCE(eds.total_tax, 0.00) AS total_tax,
COALESCE(eds.sales_total_before_additions, 0.00) AS sales_total_before_additions,
COALESCE(eds.products_sold, 0) AS products_sold,
COALESCE(eds.orders_created, 0) AS orders_created,
COALESCE(eds.total_fee, 0.00) AS total_fee,
COALESCE(eds.total_refunded, 0.00) AS total_refunded,
COALESCE(eds.total_views, 0) AS total_views
FROM
date_range d
LEFT JOIN event_daily_statistics eds
ON d.date = eds.date
AND eds.event_id = :event_id
ORDER BY d.date desc;
SQL;
}
}