Cronjobs - PGA

Es muss bereits eine News mit column wrapper und column-column angelegt worden sein! (Dient als Vorlage)

Cronjob Übersicht:

0 PGAGolfbox Placeholder:	Parameter:
1 PGAGolfbox importNews:	Parameter:
2 PGAGolfbox importTournamentsFromOldArchive:	Parameter:
3 PGAGolfbox importTournamentsFromOracle: minutely	Parameter:
4 PGAGolfbox importEntryListFromOracle: minutely	Parameter:
5 \PGA\Authenticate getMembersByGroup:	Parameter:
6 PGAGolfbox getScoresFromGolfbox: minutely	Parameter:
7 PGAGolfbox getPriceMoneyFromOracleAndPointsFromGolfbox:	Parameter:
8 PGAGolfbox getPriceMoneyAndPoints: minutely
9 PGAGolfbox getOrderOfMeritFromGolfboxForYear: hourly	Parameter:
10 PGAGolfbox getAllGolfboxScoresByTournament:	Parameter:
11 PGAGolfbox findTurnierkategorien:	Parameter:
12 PGAGolfbox prefetchTurniere: minutely
13 PGAGolfbox cronUpdateLeaderboard:
14 PGAGolfbox calculateRoundPosition: minutely
15 PGAGolfbox getPriceMoneyAndPoints:
16 PGAEvents importEventsFromOracle: hourly	Parameter:
17 PGAEvents importEventTypesFromOracle: hourly
18 PGAEvents getListenArten:
19 PGAGolfbox getRanglisteDetailForPlayer:	Parameter:
20 PGAGolfbox fixNewsColumnsForArchive:	Parameter:
21 PGAGolfbox importTourFromOracle: daily
22 PGAGolfbox importGolfschulenFromOracle: daily	Parameter:
23 PGAGolfbox importGolfschulenPros: daily
24 PGAGolfbox fixImagesForNews:	Parameter:
25 PGAGolfbox importZertifikateFromOracle: hourly
26 PGANews generateFeeds:
27 PGASearchradius updateCoords:
28 PGASearchradius updateGolfschulenWithCoords:
29 \PGA\Authenticate getGolfclubs:
30 PGAGolfbox cacheBilderTypenFromOracle: hourly
31 \PGA\Authenticate calculateMemberStatusWeight:
32 PGAGolfbox writeGolfboxEntries:
33 PGAGolfbox importTournamentByOracleId:
34 PGAGolfbox getStaticTextValuesFromOracle:
35 \PGA\Authenticate getGroups:
36 Edudip getWebinars:
37 PGAGolfbox cleanMemberNameMatches: daily
38 PGAGolfbox fetchWorldRanking: Das Ranking wird nur Montags automatisch aktualisiert, damit eine Positionsdifferenz zur Vorwoche gebildet werden kann. Das Ranking KANN an allen anderen Tagen hier manuell aktualisiert werden mit den o.a. Parametern. hourly	Parameter:
39 PGAGolfbox fetchRolexRankings: hourly	Parameter:
40 PGAGolfbox sendJobStatisticsToBackoffice: daily
41 PGAGolfbox sendCourseOffersToDb:
42 PGAGolfbox sendprivacyInfosToDb:

Contao Cronjobs:

daily Contao\Automator::purgeTempFolder
daily Contao\Automator::purgeRegistrations
daily Contao\Automator::purgeOptInTokens
daily Contao\Comments::purgeSubscriptions
daily Tournament::generateFeeds
daily Contao\News::generateFeeds
daily Clickpress\NewsPodcasts\NewsPodcastsBackend::generatePodcastFeed
daily Contao\Calendar::generateFeeds
daily Contao\Newsletter::purgeSubscriptions
daily PGA\Authenticate::mergeDuplicateMembers
daily PGA\Authenticate::getGolfclubs
minutely PGA\Authenticate::getMembersByGroup
minutely PGA\Authenticate::getGroups

  create table missingids as  select  tl_tournament_name_matches.id from `tl_tournament_name_matches` left join tl_member on tl_member.id = `tl_tournament_name_matches`.member_id where tl_member.id IS NULL;
  delete from `tl_tournament_name_matches` where id in (select id from `missingids`);

  create table missings as select tl_tournament_tee_times.id from `tl_tournament_tee_times` left join tl_tournament on `tl_tournament`.id = `tl_tournament_tee_times`.pid left join `tl_member` on `tl_member`.id = `tl_tournament_tee_times`.member_id where tl_tournament.pid = 3 and tl_member.id IS NULL;
  delete from `tl_tournament_tee_times` where id IN(select id from missings);

  update `tl_calendar_events` set singleSRC = (select `singleSRC` from `tl_calendar_events` where id = 1460) where id > 1127 and singleSRC IS NULL