summaryrefslogtreecommitdiffstats
path: root/utils/1kaCron
diff options
context:
space:
mode:
authorAnton Luka Šijanec <anton@sijanec.eu>2022-01-11 12:35:47 +0100
committerAnton Luka Šijanec <anton@sijanec.eu>2022-01-11 12:35:47 +0100
commit19985dbb8c0aa66dc4bf7905abc1148de909097d (patch)
tree2cd5a5d20d7e80fc2a51adf60d838d8a2c40999e /utils/1kaCron
download1ka-19985dbb8c0aa66dc4bf7905abc1148de909097d.tar
1ka-19985dbb8c0aa66dc4bf7905abc1148de909097d.tar.gz
1ka-19985dbb8c0aa66dc4bf7905abc1148de909097d.tar.bz2
1ka-19985dbb8c0aa66dc4bf7905abc1148de909097d.tar.lz
1ka-19985dbb8c0aa66dc4bf7905abc1148de909097d.tar.xz
1ka-19985dbb8c0aa66dc4bf7905abc1148de909097d.tar.zst
1ka-19985dbb8c0aa66dc4bf7905abc1148de909097d.zip
Diffstat (limited to 'utils/1kaCron')
-rw-r--r--utils/1kaCron/class.CronJobs.php283
1 files changed, 283 insertions, 0 deletions
diff --git a/utils/1kaCron/class.CronJobs.php b/utils/1kaCron/class.CronJobs.php
new file mode 100644
index 0000000..4ae6444
--- /dev/null
+++ b/utils/1kaCron/class.CronJobs.php
@@ -0,0 +1,283 @@
+<?php
+
+/**
+*
+* Class, ki skrbi za vse cronjobe, ki se izvajajo na anketah
+*
+*/
+
+
+class CronJobs {
+
+
+ function __construct () {
+
+ }
+
+
+ /**
+ * izvede ustrezno akcijo
+ *
+ */
+ public function executeAction($action = '') {
+
+ // Izvedemo ustrezno akcijo
+ if(method_exists('CronJobs', $action) && $action != '')
+ $this->$action();
+ else
+ echo 'Method '.$action.' does not exist!';
+ }
+
+
+ // Brisanje pobrisanih anket (anekte, ki so bile pobrisane pred vec kot 1 mesecem)
+ private function surveyDeleteFromDB(){
+
+ // Loop po pobrisanih anketah, ki so bile nazadnje urejane vec kot 1 mesec nazaj
+ $sql = sisplet_query("SELECT * FROM srv_anketa WHERE active='-1' AND edit_time < NOW() - INTERVAL 1 MONTH");
+ if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
+
+ $s = new SurveyAdmin();
+
+ while ($row = mysqli_fetch_array($sql)) {
+ $s->anketa_delete_from_db($row['id']);
+ }
+ }
+
+
+ // Brisanje pobrisanih podatkov anket (podatki, ki so bili pobrisani pred vec kot 3 meseci)
+ private function userDeleteFromDB(){
+
+ $sql = sisplet_query("DELETE FROM srv_user WHERE deleted='1' AND time_edit < NOW() - INTERVAL 3 MONTH");
+ if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
+ }
+
+ // Brisanje podatkov za "ping test" (pingdom) anketo (da ne polni baze brez potrebe)
+ private function userPingdomDeleteFromDB(){
+ global $mysql_database_name;
+ global $site_domain;
+
+ // Array vseh anket, ki se uporabljajo za monitoring (pingdom, uptime robot)
+ $uptime_surveys = array(
+ 'www.1ka.si' => array(
+ '142750', // cloud (www.1ka.si)
+ '10347' // cloud (www.1ka.si) - stara
+ ),
+ 'izobrazevanja.safe.si' => array(
+ '122358', // tus (virtualke)
+ '10347' // tus (virtualke) - stara
+ ),
+ 'vist.1ka.si' => array(
+ '356' // tus (vist.1ka.si)
+ ),
+ 'gov-ankete.si' => array(
+ '24' // tus (gov-ankete.si)
+ ),
+ 'tools.evoli.si' => array(
+ '73' // tus (tools.evoli.si)
+ ),
+ 'test.1ka.si' => array(
+ '6066' // nero (test.1ka.si)
+ )
+ );
+
+ // Ce imamo nastavljen streznik - za virtualke uporabimo kar izobrazevanja.safe.si
+ if(in_array($site_domain, array('www.1ka.si', 'izobrazevanja.safe.si', 'vist.1ka.si', 'tools.evoli.si', 'test.1ka.si'))){
+
+ // Loop po vseh monitoring anketah na strezniku
+ foreach($uptime_surveys[$site_domain] as $ank_id){
+
+ $sqlPingTest = sisplet_query("DELETE FROM srv_user WHERE ank_id='".$ank_id."'");
+ if (!$sqlPingTest) echo mysqli_error($GLOBALS['connect_db']);
+ }
+ }
+ }
+
+
+ // Kesiranje grafov
+ private function cacheCharts(){
+
+ // Kesriamo grafe za anketo, ki je bila urejana manj kot 10 dni nazaj - NE DELA ZARADI STATICNIH RAZREDOV
+ /*$expire_time = 20;
+
+ // loop cez vse ankete za katere urejamo cache
+ $sql = sisplet_query("SELECT id FROM srv_anketa WHERE active!='-1' AND edit_time >= NOW() - INTERVAL ".$expire_time." DAY");
+ while($row = mysqli_fetch_assoc($sql)){
+
+ echo $row['id'].':<br />';
+
+ SurveyChart::Init($row['id']);
+ SurveyChart::createCache($charts_num = 5);
+
+ if (SurveyChart::$returnChartAsHtml == false) {
+ flush();
+ ob_flush();
+ }
+
+ echo '<br /><br />';
+ }*/
+
+ // Na koncu pobrisemo vse stare grafe - ki so bili ustvarjeni vec kot 30 dni nazaj
+ SurveyChart::clearCache(30);
+ }
+
+ // Kesiranje podatkovnih datotek
+ private function cacheData(){
+ global $site_url;
+ global $site_path;
+
+ // Po novem je to preneseno sem iz admin/survey/prepareDataIncremental.php
+ ob_start();
+ session_start();
+
+
+ $SL = new SurveyLog();
+ $SL->addMessage(SurveyLog::INFO, "- - - - - - - - - - - - - - - - -");
+ $SL->addMessage(SurveyLog::INFO, "Klic masovnega generiranja - start");
+
+
+ $interval = 'INTERVAL 1 MONTH';
+
+ # polovimo ankete ki so ble spremenjene v zadnjih treh mesecih
+ $ids = array();
+ $sql = "SELECT id AS ank_id " .
+ "FROM srv_anketa " .
+ "WHERE active IN (0,1) " .
+ "AND (insert_time > DATE_SUB(NOW(), {$interval}) " .
+ " OR edit_time > DATE_SUB(NOW(), {$interval})) " .
+ "UNION " .
+ "SELECT ank_id " .
+ "FROM srv_user " .
+ "WHERE preview = '0' " .
+ "AND deleted='0' " .
+ "AND ank_id > 0 " .
+ "AND (time_insert > DATE_SUB(NOW(), {$interval}) " .
+ " OR time_edit > DATE_SUB(NOW(), {$interval}))";
+ $qry1 = sisplet_query($sql);
+ while ($row = mysqli_fetch_assoc($qry1)) {
+ $ids[] = $row['ank_id'];
+ };
+
+
+ $SL->addMessage(SurveyLog::INFO, "Klic masovnega generiranja - start");
+ $SL->addMessage(SurveyLog::INFO, $sql);
+
+ if (count($ids) > 0) {
+ $SL->addMessage(SurveyLog::INFO, "St. anket: ".(int)count($ids));
+
+ foreach ($ids AS $ank_id) {
+
+ if ($ank_id > 0) {
+
+ $SDF = SurveyDataFile::get_instance();
+ $SDF->init($ank_id);
+ $SDF->prepareFiles();
+ }
+ }
+ }
+
+ $SL->addMessage(SurveyLog::INFO, "Klic masovnega generiranja - stop");
+ $SL->write();
+
+ ob_flush();
+ }
+
+
+ // Posiljanje obvestil o ??zakljucenih?? anketah - TODO
+ private function surveySendAlert(){
+ global $lang;
+ global $site_path;
+ global $site_url;
+ global $global_user_id;
+ global $admin_type;
+ global $mysql_database_name;
+
+
+ // Shranimo izbrano bazo
+ $oldDb = $mysql_database_name;
+
+ // Preklopimo na bazo za crontab
+ mysqli_select_db($GLOBALS['connect_db'], 'surveycrontab');
+
+ // Preberemo zapise na katere moramo poslati emaile
+ $today = date("Y-m-d");
+ $qry = sisplet_query("SELECT * FROM srv_alert WHERE send_date <= '".$today."' AND status = 0");
+ if (mysqli_num_rows($qry) > 0 ) {
+
+ while ($row = mysqli_fetch_assoc($qry)) {
+ $emails = array();
+ $emails = explode(",",$row['emails']);
+
+ // preprečimo večkratno pošiljanje na iste naslove
+ array_unique($emails);
+ $spisek = "";
+ $send_success = $send_errors = array();
+ $subject = iconv('utf-8', 'iso-8859-2', $row['subject']);
+
+ // posljemo maile, vseeno preverimo ali imamo kak zapis
+ if (count($emails)) {
+ foreach ($emails AS $email) {
+ $email = trim($email);
+ if (strlen ($email) > 1 && strpos ($spisek, $email)===false || strlen ($spisek) == 0) {
+
+ try{
+ $MA = new MailAdapter();
+
+ $MA->setMailFrom($row['MailFrom']);
+ $MA->setMailReplyTo($row['MailReply']);
+ $MA->addRecipients($email);
+
+ $resultX = $MA->sendMail(stripslashes($row['text']), $subject);
+
+ $spisek .= $email ."|";
+ }
+ catch (Exception $e){
+ }
+
+ if ($resultX) {
+ $send_success[] = $email;
+ }
+ else {
+ $send_errors[] = $email;
+ }
+ }
+ }
+
+ // popravimo zapis v crontab tabeli
+ mysqli_select_db($GLOBALS['connect_db'], 'surveycrontab');
+ $sqlUpdate = sisplet_query("UPDATE srv_alert SET status = 1, emails_success='".implode(",",$send_success)."', emails_failed='".implode(",",$send_errors)."' WHERE id = '".$row['id']."'");
+ }
+ }
+ }
+ else
+ echo 'Nothing to send';
+
+
+ // Vrnemo nazaj na staro bazo
+ mysqli_select_db($GLOBALS['connect_db'], $oldDb);
+ }
+
+ // Posljemo mail adminom, da si spremenijo geslo - TODO
+ private function adminResetPassword(){
+ global $site_url;
+ global $site_path;
+
+
+ }
+
+ // Posljemo mail metaadminom in avtorju ankete 5 let po aktivaciji, da naj pobrisejo podatke - TODO
+ private function gdprMailExpired(){
+ global $site_url;
+ global $site_path;
+
+
+ }
+
+ // Posljemo vsem MAZA aplikacijam pretecene/deaktivirane ankete
+ private function mazaCheckExpiredSurveys(){
+ $SL = new SurveyList();
+ $SL -> checkSurveyExpire();
+ }
+
+}
+
+?> \ No newline at end of file