...
| Code Block |
|---|
CREATE DEFINER=`root`@`%` FUNCTION `pm_current_buffered_months`(theuuid VARCHAR(50), dt DATE, mnthsmargin INTEGER) RETURNS tinyint(1)
BEGIN
DECLARE CNT INTEGER DEFAULT 0;
SELECT
COUNT(*)
INTO CNT FROM
tcs.ProgrammeMembership
WHERE
uuid = theuuid
AND DATE_ADD(programmeStartDate,
INTERVAL mnthsmargin MONTH) <= dt
AND DATE_ADD(programmeEndDate,
INTERVAL - 1 * mnthsmargin MONTH) >= dt;
RETURN CNT > 0;
END |
How many of a trainee’s PMs are current at a given date plus/minus a given buffer of months:
...