From 64ce9223f46a22258d9363c64c1a587016e85d3c Mon Sep 17 00:00:00 2001 From: M.Gergo Date: Thu, 16 Jul 2020 23:45:04 +0200 Subject: Rev: 4665 --- .../mayor-naplo/update/pre004663-1-mayor_naplo.sql | 28 ++++++++++++++++++++++ 1 file changed, 28 insertions(+) create mode 100644 mayor-orig/mayor-naplo/update/pre004663-1-mayor_naplo.sql (limited to 'mayor-orig/mayor-naplo/update') diff --git a/mayor-orig/mayor-naplo/update/pre004663-1-mayor_naplo.sql b/mayor-orig/mayor-naplo/update/pre004663-1-mayor_naplo.sql new file mode 100644 index 00000000..2d1efdde --- /dev/null +++ b/mayor-orig/mayor-naplo/update/pre004663-1-mayor_naplo.sql @@ -0,0 +1,28 @@ +DELIMITER $$ +DROP PROCEDURE IF EXISTS upgrade_database_4663 $$ +CREATE PROCEDURE upgrade_database_4663() +BEGIN + +SET NAMES utf8 COLLATE utf8_hungarian_ci; + +-- nem nevezzük át! +-- update osztalyJelleg SET osztalyJellegNev=REPLACE(osztalyJellegNev,'szakközépiskola','szakgimnázium') where osztalyJellegNev LIKE '%szakkozepiskola%' AND osztalyJellegEles=1; +-- update osztalyJelleg SET osztalyJellegNev=REPLACE(osztalyJellegNev,'szakiskola','szakközépiskola') where osztalyJellegNev LIKE '%szakiskola%' AND osztalyJellegEles=1; + +-- DELETE FROM osztalyJelleg WHERE osztalyJellegId=37; +INSERT IGNORE INTO `osztalyJelleg` VALUES (37,NULL,'4 évfolyamos gimnázium érettségire felkészítő évfolyammal WALDORF (4+1)',1,NULL,9,13,NULL,1,'9,10,11,12,13','érettségi vizsga'); + +-- DELETE FROM osztalyJelleg WHERE osztalyJellegId IN (171,172,173,174,175,176); +INSERT IGNORE INTO `osztalyJelleg` VALUES +(171,NULL,'technikum (5)',1,NULL,9,NULL,'',1,'9,10,11,12,13','érettségi vizsga'), +(172,NULL,'technikum AJTP előkészítő évfolyammal (1+5)',1,NULL,9,NULL,'AJTP',1,'9/AJTP,9,10,11,12,13','érettségi vizsga'), +(173,NULL,'technikum AJKP előkészítő évfolyammal (1+5)',1,NULL,9,NULL,'AJKP',1,'9/AJKP,9,10,11,12,13','érettségi vizsga'), +(174,NULL,'technikum két tanítási nyelvű előkészítő évfolyammal (1+5)',1,NULL,9,NULL,'Kny',1,'9/Kny,9,10,11,12,13','érettségi vizsga'), +(175,NULL,'technikum nemzetiségi előkészítő évfolyammal (1+5)',1,NULL,9,NULL,'N',1,'9/N,9,10,11,12,13','érettségi vizsga'), +(176,NULL,'technikum nyelvi előkészítő évfolyammal (1+5)',1,NULL,9,NULL,'Ny',1,'9/Ny,9,10,11,12,13','érettségi vizsga'); + +-- (201,NULL,'szakképző iskola szakképzés (3)',1,NULL,9,NULL,'',1,'9,10,11','szakmai vizsga'), + +END $$ +DELIMITER ; +CALL upgrade_database_4663(); -- cgit v1.2.3 From 148c5eb14880c1b5facd0abe0bbfc7af0a06d6c3 Mon Sep 17 00:00:00 2001 From: M.Gergo Date: Fri, 17 Jul 2020 11:40:03 +0200 Subject: Rev: 4666 --- mayor-orig/mayor-base/log/mayor-base.rev | 2 +- mayor-orig/mayor-felveteli/log/mayor-felveteli.rev | 2 +- mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev | 2 +- .../mayor-installer-orig/log/mayor-installer.rev | 2 +- .../log/mayor-installer-sulix.rev | 2 +- mayor-orig/mayor-jatek/log/mayor-jatek.rev | 2 +- .../log/mayor-locales-de_DE.rev | 2 +- .../log/mayor-locales-en_US.rev | 2 +- .../log/mayor-locales-jp_JP.rev | 2 +- .../install/module-naplo/mysql/base.sql | 4 +++- mayor-orig/mayor-naplo/log/mayor-naplo.rev | 2 +- .../mayor-naplo/update/pre004665-1-mayor_naplo.sql | 13 +++++++++++ mayor-orig/mayor-portal/log/mayor-portal.rev | 2 +- mayor-orig/mayor-wiki/log/mayor-wiki.rev | 2 +- mayor-orig/md5sum | 26 +++++++++++----------- mayor-orig/rev.txt | 2 +- rev.txt | 2 +- 17 files changed, 43 insertions(+), 28 deletions(-) create mode 100644 mayor-orig/mayor-naplo/update/pre004665-1-mayor_naplo.sql (limited to 'mayor-orig/mayor-naplo/update') diff --git a/mayor-orig/mayor-base/log/mayor-base.rev b/mayor-orig/mayor-base/log/mayor-base.rev index c179a536..e8f0acdd 100644 --- a/mayor-orig/mayor-base/log/mayor-base.rev +++ b/mayor-orig/mayor-base/log/mayor-base.rev @@ -1 +1 @@ -4665 +4666 diff --git a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev index c179a536..e8f0acdd 100644 --- a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev +++ b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev @@ -1 +1 @@ -4665 +4666 diff --git a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev index c179a536..e8f0acdd 100644 --- a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev +++ b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev @@ -1 +1 @@ -4665 +4666 diff --git a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev index c179a536..e8f0acdd 100644 --- a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev +++ b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev @@ -1 +1 @@ -4665 +4666 diff --git a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev index c179a536..e8f0acdd 100644 --- a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev +++ b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev @@ -1 +1 @@ -4665 +4666 diff --git a/mayor-orig/mayor-jatek/log/mayor-jatek.rev b/mayor-orig/mayor-jatek/log/mayor-jatek.rev index c179a536..e8f0acdd 100644 --- a/mayor-orig/mayor-jatek/log/mayor-jatek.rev +++ b/mayor-orig/mayor-jatek/log/mayor-jatek.rev @@ -1 +1 @@ -4665 +4666 diff --git a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev index c179a536..e8f0acdd 100644 --- a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev +++ b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev @@ -1 +1 @@ -4665 +4666 diff --git a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev index c179a536..e8f0acdd 100644 --- a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev +++ b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev @@ -1 +1 @@ -4665 +4666 diff --git a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev index c179a536..e8f0acdd 100644 --- a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev +++ b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev @@ -1 +1 @@ -4665 +4666 diff --git a/mayor-orig/mayor-naplo/install/module-naplo/mysql/base.sql b/mayor-orig/mayor-naplo/install/module-naplo/mysql/base.sql index 5695a5c5..7fc18fbe 100644 --- a/mayor-orig/mayor-naplo/install/module-naplo/mysql/base.sql +++ b/mayor-orig/mayor-naplo/install/module-naplo/mysql/base.sql @@ -180,7 +180,9 @@ INSERT INTO `osztalyJelleg` VALUES (1,1,'Általános iskola',0,NULL,NULL,NULL,NU (173,NULL,'technikum AJKP előkészítő évfolyammal (1+5)',1,NULL,9,NULL,'AJKP',1,'9/AJKP,9,10,11,12,13','érettségi vizsga'), (174,NULL,'technikum két tanítási nyelvű előkészítő évfolyammal (1+5)',1,NULL,9,NULL,'Kny',1,'9/Kny,9,10,11,12,13','érettségi vizsga'), (175,NULL,'technikum nemzetiségi előkészítő évfolyammal (1+5)',1,NULL,9,NULL,'N',1,'9/N,9,10,11,12,13','érettségi vizsga'), -(176,NULL,'technikum nyelvi előkészítő évfolyammal (1+5)',1,NULL,9,NULL,'Ny',1,'9/Ny,9,10,11,12,13','érettségi vizsga') +(176,NULL,'technikum nyelvi előkészítő évfolyammal (1+5)',1,NULL,9,NULL,'Ny',1,'9/Ny,9,10,11,12,13','érettségi vizsga'), +(201,NULL,'szakközépiskola - 3 szakképzési évfolyam (3)',1,NULL,9,11,NULL,1,'9,10,11','szakmai vizsga'), +(202,NULL,'szakképző iskola - 3 szakképzési évfolyam (3)',1,NULL,9,11,NULL,1,'9,10,11','szakmai vizsga') ; CREATE TABLE `rpcJogosultsag` ( diff --git a/mayor-orig/mayor-naplo/log/mayor-naplo.rev b/mayor-orig/mayor-naplo/log/mayor-naplo.rev index c179a536..e8f0acdd 100644 --- a/mayor-orig/mayor-naplo/log/mayor-naplo.rev +++ b/mayor-orig/mayor-naplo/log/mayor-naplo.rev @@ -1 +1 @@ -4665 +4666 diff --git a/mayor-orig/mayor-naplo/update/pre004665-1-mayor_naplo.sql b/mayor-orig/mayor-naplo/update/pre004665-1-mayor_naplo.sql new file mode 100644 index 00000000..be03483b --- /dev/null +++ b/mayor-orig/mayor-naplo/update/pre004665-1-mayor_naplo.sql @@ -0,0 +1,13 @@ +DELIMITER $$ +DROP PROCEDURE IF EXISTS upgrade_database_4665 $$ +CREATE PROCEDURE upgrade_database_4665() +BEGIN + +SET NAMES utf8 COLLATE utf8_hungarian_ci; + +INSERT IGNORE INTO `osztalyJelleg` VALUES (201,NULL,'szakközépiskola - 3 szakképzési évfolyam (3)',1,NULL,9,11,NULL,1,'9,10,11','szakmai vizsga'); +INSERT IGNORE INTO `osztalyJelleg` VALUES (202,NULL,'szakképző iskola - 3 szakképzési évfolyam (3)',1,NULL,9,11,NULL,1,'9,10,11','szakmai vizsga'); + +END $$ +DELIMITER ; +CALL upgrade_database_4665(); diff --git a/mayor-orig/mayor-portal/log/mayor-portal.rev b/mayor-orig/mayor-portal/log/mayor-portal.rev index c179a536..e8f0acdd 100644 --- a/mayor-orig/mayor-portal/log/mayor-portal.rev +++ b/mayor-orig/mayor-portal/log/mayor-portal.rev @@ -1 +1 @@ -4665 +4666 diff --git a/mayor-orig/mayor-wiki/log/mayor-wiki.rev b/mayor-orig/mayor-wiki/log/mayor-wiki.rev index c179a536..e8f0acdd 100644 --- a/mayor-orig/mayor-wiki/log/mayor-wiki.rev +++ b/mayor-orig/mayor-wiki/log/mayor-wiki.rev @@ -1 +1 @@ -4665 +4666 diff --git a/mayor-orig/md5sum b/mayor-orig/md5sum index 36054aa7..94455b85 100644 --- a/mayor-orig/md5sum +++ b/mayor-orig/md5sum @@ -1,13 +1,13 @@ -Revision 4665 -2ea12513c021fdc9bb3a55b9ca5fe618 mayor-fenntarto-rev4665.tgz -20296e9e2031300d7add37bc00c69dc4 mayor-installer-sulix-rev4665.tgz -91b6977fa45206b809b6ad19eaa792b9 mayor-wiki-rev4665.tgz -410c625c0f440f563581869973cfa884 mayor-installer-rev4665.tgz -80da9a7912279e0ffc666a501903c99a mayor-portal-rev4665.tgz -533010dfd1a08cda72b1203ed9087f02 mayor-felveteli-rev4665.tgz -8d03c3f05c1a4b8957f8f31573ec55d8 mayor-jatek-rev4665.tgz -1e6c10fe289a387827b315cd0075c9a4 mayor-locales-jp_JP-rev4665.tgz -361fd88c7e573b5bec1482b6e100e859 mayor-locales-de_DE-rev4665.tgz -22bbe2d863f6eec48feb32340c1efc45 mayor-locales-en_US-rev4665.tgz -9becd273f608885f54ad333dc6d72d6a mayor-naplo-rev4665.tgz -6ce15c9ead15d8ff63369fa2d657c495 mayor-base-rev4665.tgz +Revision 4666 +e99bb3fe3353e592b085eb6b0e942fe1 mayor-fenntarto-rev4666.tgz +4796e189a5b07b9267eee3d43a261daf mayor-installer-sulix-rev4666.tgz +11dec0cd5dc52fd4eee503ff62a39c30 mayor-wiki-rev4666.tgz +ee8577c049f2da3e965abab2cf532f05 mayor-installer-rev4666.tgz +03e23eb86bdd9cf00ad475a3e07f1d65 mayor-portal-rev4666.tgz +b9b8d38509bf6e2a0aa7f3c56e46cd9e mayor-felveteli-rev4666.tgz +1e74b0ca8f1b8b68adb3b699393a1472 mayor-jatek-rev4666.tgz +b02845450d4c94d4c8988b5d8fe49459 mayor-locales-jp_JP-rev4666.tgz +b898de6f4e387e33f8c2680f27185096 mayor-locales-de_DE-rev4666.tgz +dedc7c77ac6cbc22af917bdce909a145 mayor-locales-en_US-rev4666.tgz +d779e272ae945b2afe14d229b10c7b17 mayor-naplo-rev4666.tgz +7545098d488c9221d763ce679913825d mayor-base-rev4666.tgz diff --git a/mayor-orig/rev.txt b/mayor-orig/rev.txt index c179a536..e8f0acdd 100644 --- a/mayor-orig/rev.txt +++ b/mayor-orig/rev.txt @@ -1 +1 @@ -4665 +4666 diff --git a/rev.txt b/rev.txt index c179a536..e8f0acdd 100644 --- a/rev.txt +++ b/rev.txt @@ -1 +1 @@ -4665 +4666 -- cgit v1.2.3 From e22bbedcf69ea347a103d04d194136b8f3a761c8 Mon Sep 17 00:00:00 2001 From: M.Gergo Date: Mon, 24 Aug 2020 13:05:03 +0200 Subject: Rev: 4670 --- mayor-orig/mayor-base/log/mayor-base.rev | 2 +- mayor-orig/mayor-felveteli/log/mayor-felveteli.rev | 2 +- mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev | 2 +- .../mayor-installer-orig/log/mayor-installer.rev | 2 +- .../log/mayor-installer-sulix.rev | 2 +- mayor-orig/mayor-jatek/log/mayor-jatek.rev | 2 +- .../log/mayor-locales-de_DE.rev | 2 +- .../log/mayor-locales-en_US.rev | 2 +- .../log/mayor-locales-jp_JP.rev | 2 +- mayor-orig/mayor-naplo/log/mayor-naplo.rev | 2 +- mayor-orig/mayor-naplo/update/pre004669-1.sh | 13 +++++++++++ .../private/naplo/import/tantargyFelosztas-pre.php | 12 +++++----- .../private/naplo/import/tantargyFelosztas.php | 19 +++++++++++----- .../policy/private/naplo/intezmeny/osztaly-pre.php | 25 ++++++++++++++++++--- .../html/import/tantargyFelosztas.phtml | 16 ++++++++++--- .../classic/module-naplo/html/share/file.phtml | 8 ++++--- mayor-orig/mayor-portal/log/mayor-portal.rev | 2 +- mayor-orig/mayor-wiki/log/mayor-wiki.rev | 2 +- mayor-orig/md5sum | 26 +++++++++++----------- mayor-orig/rev.txt | 2 +- rev.txt | 2 +- 21 files changed, 100 insertions(+), 47 deletions(-) create mode 100644 mayor-orig/mayor-naplo/update/pre004669-1.sh (limited to 'mayor-orig/mayor-naplo/update') diff --git a/mayor-orig/mayor-base/log/mayor-base.rev b/mayor-orig/mayor-base/log/mayor-base.rev index 1144753c..ae6d0645 100644 --- a/mayor-orig/mayor-base/log/mayor-base.rev +++ b/mayor-orig/mayor-base/log/mayor-base.rev @@ -1 +1 @@ -4668 +4670 diff --git a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev index 1144753c..ae6d0645 100644 --- a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev +++ b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev @@ -1 +1 @@ -4668 +4670 diff --git a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev index 1144753c..ae6d0645 100644 --- a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev +++ b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev @@ -1 +1 @@ -4668 +4670 diff --git a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev index 1144753c..ae6d0645 100644 --- a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev +++ b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev @@ -1 +1 @@ -4668 +4670 diff --git a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev index 1144753c..ae6d0645 100644 --- a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev +++ b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev @@ -1 +1 @@ -4668 +4670 diff --git a/mayor-orig/mayor-jatek/log/mayor-jatek.rev b/mayor-orig/mayor-jatek/log/mayor-jatek.rev index 1144753c..ae6d0645 100644 --- a/mayor-orig/mayor-jatek/log/mayor-jatek.rev +++ b/mayor-orig/mayor-jatek/log/mayor-jatek.rev @@ -1 +1 @@ -4668 +4670 diff --git a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev index 1144753c..ae6d0645 100644 --- a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev +++ b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev @@ -1 +1 @@ -4668 +4670 diff --git a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev index 1144753c..ae6d0645 100644 --- a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev +++ b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev @@ -1 +1 @@ -4668 +4670 diff --git a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev index 1144753c..ae6d0645 100644 --- a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev +++ b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev @@ -1 +1 @@ -4668 +4670 diff --git a/mayor-orig/mayor-naplo/log/mayor-naplo.rev b/mayor-orig/mayor-naplo/log/mayor-naplo.rev index 1144753c..ae6d0645 100644 --- a/mayor-orig/mayor-naplo/log/mayor-naplo.rev +++ b/mayor-orig/mayor-naplo/log/mayor-naplo.rev @@ -1 +1 @@ -4668 +4670 diff --git a/mayor-orig/mayor-naplo/update/pre004669-1.sh b/mayor-orig/mayor-naplo/update/pre004669-1.sh new file mode 100644 index 00000000..4ca6ff0a --- /dev/null +++ b/mayor-orig/mayor-naplo/update/pre004669-1.sh @@ -0,0 +1,13 @@ +#!/bin/sh + +#BASEDIR="/var/mayor" + +DIR="$BASEDIR/download/private/naplo/nyomtatas/torzslap/" +mkdir -p $DIR +chown -R www-data $DIR +echo "$DIR Kész." + +DIR="$BASEDIR/download/private/naplo/upload/" +mkdir -p $DIR +chown -R www-data $DIR +echo "$DIR Kész." diff --git a/mayor-orig/mayor-naplo/www/policy/private/naplo/import/tantargyFelosztas-pre.php b/mayor-orig/mayor-naplo/www/policy/private/naplo/import/tantargyFelosztas-pre.php index 8497ec46..fe445355 100644 --- a/mayor-orig/mayor-naplo/www/policy/private/naplo/import/tantargyFelosztas-pre.php +++ b/mayor-orig/mayor-naplo/www/policy/private/naplo/import/tantargyFelosztas-pre.php @@ -94,7 +94,7 @@ if ($DIAKOK[$i]['oId']!='') { $OID2ID[$DIAKOK[$i]['oId']] = intval($DIAKOK[$i]['diakId']); } else { - $ADAT['bug']['diak'][] = $DIAKOK[$i]['oId']; + $ADAT['bug']['diak'][] = $DIAKOK[$i]['oId'].serialize($DIAKOK[$i]); } } // TÁRGYAK @@ -527,7 +527,7 @@ $_D = $ADAT['ttf'][$i]; $q = "select *,tankorSzemeszter.tankorId AS tankorId from tankorSzemeszter LEFT JOIN tankor USING (tankorId) -LEFT JOIN tankorTanar ON (tankorTanar.tankorId=tankor.tankorId AND beDt<=NOW() AND (kiDt is null or kiDt>=NOW())) +LEFT JOIN tankorTanar ON (tankorTanar.tankorId=tankor.tankorId AND beDt<='2020-09-01' AND (kiDt is null or kiDt>='2020-09-01')) LEFT JOIN ".__TANEVDBNEV.".tankorCsoport ON (tankor.tankorId = tankorCsoport.tankorId) LEFT JOIN ".__TANEVDBNEV.".csoport USING (csoportId) WHERE tanev=%u AND szemeszter=%u AND targyId=%u AND oraszam=%f AND tanarId=%u @@ -551,7 +551,7 @@ GROUP BY tankor.tankorId"; // Belerakjuk azon tanköröket is, ahol vélhetően csak a csoport hozzárendelés hiányzik $q = "select *,tankorSzemeszter.tankorId AS tankorId from tankorSzemeszter LEFT JOIN tankor USING (tankorId) -LEFT JOIN tankorTanar ON (tankorTanar.tankorId=tankor.tankorId AND beDt<=NOW() AND (kiDt is null or kiDt>=NOW())) +LEFT JOIN tankorTanar ON (tankorTanar.tankorId=tankor.tankorId AND beDt<='2020-09-01' AND (kiDt is null or kiDt>='2020-09-01')) LEFT JOIN ".__TANEVDBNEV.".tankorCsoport ON (tankor.tankorId = tankorCsoport.tankorId) LEFT JOIN ".__TANEVDBNEV.".csoport USING (csoportId) WHERE tanev=%u AND szemeszter=%u AND targyId=%u AND oraszam=%f AND tanarId=%u @@ -591,7 +591,7 @@ GROUP BY tankor.tankorId"; } $q = "select *,tankorSzemeszter.tankorId AS tankorId from tankorSzemeszter LEFT JOIN tankor USING (tankorId) -LEFT JOIN tankorTanar ON (tankorTanar.tankorId=tankor.tankorId AND beDt<=NOW() AND (kiDt is null or kiDt>=NOW())) +LEFT JOIN tankorTanar ON (tankorTanar.tankorId=tankor.tankorId AND beDt<='2020-09-01' AND (kiDt is null or kiDt>='2020-09-01')) LEFT JOIN tankorOsztaly ON (tankor.tankorId = tankorOsztaly.tankorId) WHERE tanev=%u AND szemeszter=%u AND targyId=%u AND oraszam=%f @@ -611,7 +611,7 @@ GROUP BY tankor.tankorId ORDER BY tankorNev"; } else { $q = "select *,tankorSzemeszter.tankorId AS tankorId from tankorSzemeszter LEFT JOIN tankor USING (tankorId) -LEFT JOIN tankorTanar ON (tankorTanar.tankorId=tankor.tankorId AND beDt<=NOW() AND (kiDt is null or kiDt>=NOW())) +LEFT JOIN tankorTanar ON (tankorTanar.tankorId=tankor.tankorId AND beDt<='2020-09-01' AND (kiDt is null or kiDt>='2020-09-01')) WHERE tanev=%u AND szemeszter=%u AND targyId=%u AND oraszam>=%f AND tanarId IS NULL @@ -662,7 +662,7 @@ GROUP BY tankor.tankorId ORDER BY tankorNev"; // MaYoR: csoportId+targyId+tanarId => tankorId; $lr_naplo = db_connect('naplo'); - $q = "select csoportId, targyId, tanarId, tankor.tankorId FROM tankorCsoport LEFT JOIN csoport USING (csoportId) LEFT JOIN ".__INTEZMENYDBNEV.".tankor USING (tankorId) LEFT JOIN ".__INTEZMENYDBNEV.".tankorTanar ON (tankor.tankorId = tankorTanar.tankorId AND beDt>='2019-09-01' AND (kiDt IS NULL or kiDt>=NOW()))"; + $q = "select csoportId, targyId, tanarId, tankor.tankorId FROM tankorCsoport LEFT JOIN csoport USING (csoportId) LEFT JOIN ".__INTEZMENYDBNEV.".tankor USING (tankorId) LEFT JOIN ".__INTEZMENYDBNEV.".tankorTanar ON (tankor.tankorId = tankorTanar.tankorId AND beDt>='2019-09-01' AND (kiDt IS NULL or kiDt>='2020-09-01'))"; $r = db_query($q, array('fv' => 'pre', 'modul' => 'naplo', 'values' => $v, 'result'=>'indexed'),$lr_naplo); for ($i=0; $i0) + if (count($ADAT['bug']['targy'])>0) { + echo '

Hibás tárgyak

'; + echo '
';
 	var_dump($ADAT['bug']['targy']);
+	echo '
'; + } - if (count($ADAT['bug']['diak'])>0) + if (count($ADAT['bug']['diak'])>0) { + echo '

Hibás diákok

'; + echo '
';
 	var_dump($ADAT['bug']['diak']);
+	echo '
'; + } - echo 'Használt kulcs érték párok:'; - var_dump($ADAT['kulcsertektar']['osztalyjel2id']); - + echo 'Használt kulcs-érték párok (osztályJel-osztályId):'; + echo '
';
+	var_dump($ADAT['kulcsertektar']['osztalyjel2id']);
+    echo '
'; diff --git a/mayor-orig/mayor-naplo/www/policy/private/naplo/intezmeny/osztaly-pre.php b/mayor-orig/mayor-naplo/www/policy/private/naplo/intezmeny/osztaly-pre.php index 5097037f..9222a0c8 100644 --- a/mayor-orig/mayor-naplo/www/policy/private/naplo/intezmeny/osztaly-pre.php +++ b/mayor-orig/mayor-naplo/www/policy/private/naplo/intezmeny/osztaly-pre.php @@ -19,7 +19,9 @@ require_once('include/modules/naplo/share/tankorDiakModifier.php'); require_once('include/modules/naplo/share/hianyzasModifier.php'); require_once('include/modules/naplo/share/jegyModifier.php'); require_once('include/modules/naplo/share/jegy.php'); +require_once('include/share/net/upload.php'); +define('FILE_UPLOAD_DIR',_DOWNLOADDIR.'/private/naplo/upload/'); if (defined('__INTEZMENY') and __INTEZMENY != '') { $ADAT['tanevek'] = getTanevek(true); @@ -40,11 +42,28 @@ else $TA = $_TANEV; /* -------- */ // Adatok frissítése adatállományból -if (__NAPLOADMIN && isset($_POST['fileName']) && $_POST['fileName'] != '') { +if (__NAPLOADMIN===true && + ( + (isset($_POST['fileName']) && $_POST['fileName'] != '') + or + (is_array($_FILES) && $_FILES['upfile']['name']!='') + ) + ) { + define('_SKIP_ON_DUP',readVariable($_POST['skipOnDup'],'bool')); + if (is_array($_FILES) && $_FILES['upfile']['name']!='') { // távoli feltöltés + try { + $_F = array('subdir'=>FILE_UPLOAD_DIR, 'filename'=>uniqid()); // move ide + $sikeresFeltoltes = mayorFileUpload($_F, false); + $fileName = FILE_UPLOAD_DIR.$_F['filename']; + } catch (Exception $e) { + dump($e); + } + } else { // helyi beolvasás + // $fileName = fileNameNormal($_POST['fileName']); + $fileName = ($_POST['fileName']); // TODO + } $mezo_elvalaszto = ' '; // "\t" -// $fileName = fileNameNormal($_POST['fileName']); - $fileName = ($_POST['fileName']); // TODO $ADATOK = array(); if (file_exists($fileName)) { diff --git a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/import/tantargyFelosztas.phtml b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/import/tantargyFelosztas.phtml index 5fe6435a..2980672b 100644 --- a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/import/tantargyFelosztas.phtml +++ b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/import/tantargyFelosztas.phtml @@ -29,7 +29,8 @@ table.ttf tr.createTankor td { background-color: magenta;} table.ttf tr.done td { background-color: lightgreen;} - table.ttf tr td {padding:4px;} + table.ttf tr td {padding:4px; border-bottom: solid 1px #ccc;} + table.ttf tr td:hover {outline: solid 2px cornflowerblue;} table.ttf tr td div.tankorLista span:hover { color: white; } '; @@ -104,7 +105,7 @@ echo ''; for ($j=0; $j'.$D['displayTankor'][$j]['tankorNev'].''; + echo ''; } echo ''; echo '
'; @@ -124,7 +125,16 @@ echo '
'; // ha ezt összehasonlítom a mayorban rögzített névsorral, akkor eldönhető lehet, hogy melyik a jó választás! echo ' Új tankör:'; - echo ''; + if (count($_osztalyok)>0) { + echo ''; + } else { + echo ''; + } } elseif ($D['action'] == 'createTankor') { echo 'Új tankör létrehozása: '; } else { diff --git a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/share/file.phtml b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/share/file.phtml index 7720f2ba..a1ac34d4 100644 --- a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/share/file.phtml +++ b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/share/file.phtml @@ -2,7 +2,7 @@ function putFileSelectForm($dbtable, $post = array()) { - formBegin(array('class'=>'updateTable')); + formBegin(array('class'=>'updateTable', 'enctype'=>'multipart/form-data')); // A form címe if (defined('_FILESELECTTITLE')) echo '

'._FILESELECTTITLE.'

'; // A továbbadandó POST adatok @@ -12,8 +12,10 @@ } echo ''."\n"; echo ' Meglevő rekord találatkor kihagyjuk a rekord frissítést'; - echo ''."\n"; - echo ''."\n"; + echo '

'."\n"; + echo '

'."\n"; + echo '

Vagy feltöltés:'; + echo '

'; echo ''."\n"; formEnd(); diff --git a/mayor-orig/mayor-portal/log/mayor-portal.rev b/mayor-orig/mayor-portal/log/mayor-portal.rev index 1144753c..ae6d0645 100644 --- a/mayor-orig/mayor-portal/log/mayor-portal.rev +++ b/mayor-orig/mayor-portal/log/mayor-portal.rev @@ -1 +1 @@ -4668 +4670 diff --git a/mayor-orig/mayor-wiki/log/mayor-wiki.rev b/mayor-orig/mayor-wiki/log/mayor-wiki.rev index 1144753c..ae6d0645 100644 --- a/mayor-orig/mayor-wiki/log/mayor-wiki.rev +++ b/mayor-orig/mayor-wiki/log/mayor-wiki.rev @@ -1 +1 @@ -4668 +4670 diff --git a/mayor-orig/md5sum b/mayor-orig/md5sum index ae45fb75..b78cc000 100644 --- a/mayor-orig/md5sum +++ b/mayor-orig/md5sum @@ -1,13 +1,13 @@ -Revision 4668 -d31c2e99f5971da280de226d58efb1fe mayor-fenntarto-rev4668.tgz -8c5aad6ff460483f39cf322c684f7ae5 mayor-installer-sulix-rev4668.tgz -144adb4ed5747b3fdd2bcb5f968166c1 mayor-wiki-rev4668.tgz -3ade4f8cb094f846c33fda6ff728cd42 mayor-installer-rev4668.tgz -d21f84d601d41b4dceeb0279b9045437 mayor-portal-rev4668.tgz -ac2517fa941fefad37f7200b0ed2a4f6 mayor-felveteli-rev4668.tgz -0b8529f409d21c8f029fa86eb6d1b272 mayor-jatek-rev4668.tgz -123950373ab1b5fa1b2920927c4e95b0 mayor-locales-jp_JP-rev4668.tgz -a54261cd74ed2b410e4453d6d9360c43 mayor-locales-de_DE-rev4668.tgz -a934d21e116794142150a48e38fb9ae3 mayor-locales-en_US-rev4668.tgz -91d52124b4e62d7744462c4fc53c98b4 mayor-naplo-rev4668.tgz -8894910d63f85409e7dacf5b6c4a5200 mayor-base-rev4668.tgz +Revision 4670 +cba1147e897c76e7c16d45dbe47d1182 mayor-fenntarto-rev4670.tgz +fd708eb082977562764f1b1825e29f67 mayor-installer-sulix-rev4670.tgz +a721fb2bfbd2839c3cba735b1c4caab8 mayor-wiki-rev4670.tgz +c8b3a9922b7b5cd9dedba587bd15c4f1 mayor-installer-rev4670.tgz +61204f6f2312a735247d998c397de7fa mayor-portal-rev4670.tgz +8093da7931507cde6c2aaad259ceda4d mayor-felveteli-rev4670.tgz +3c08d033790423f67349f0ec352246d0 mayor-jatek-rev4670.tgz +3bbb4da1261cc77507793fdb7ff0256a mayor-locales-jp_JP-rev4670.tgz +a6456f0d911fce770b9e8840fbf87833 mayor-locales-de_DE-rev4670.tgz +f6b1df395dc6d411fa682916058279c3 mayor-locales-en_US-rev4670.tgz +b8b5c925ecfcc25da36bb202564f0e1e mayor-naplo-rev4670.tgz +024478761bf99fd4af52cd6d06814946 mayor-base-rev4670.tgz diff --git a/mayor-orig/rev.txt b/mayor-orig/rev.txt index 1144753c..ae6d0645 100644 --- a/mayor-orig/rev.txt +++ b/mayor-orig/rev.txt @@ -1 +1 @@ -4668 +4670 diff --git a/rev.txt b/rev.txt index 1144753c..ae6d0645 100644 --- a/rev.txt +++ b/rev.txt @@ -1 +1 @@ -4668 +4670 -- cgit v1.2.3 From 3dcf762b20c16850cff7c61ac74e4bf0850ffa42 Mon Sep 17 00:00:00 2001 From: M.Gergo Date: Wed, 26 Aug 2020 14:20:03 +0200 Subject: Rev: 4672 --- mayor-orig/mayor-base/log/mayor-base.rev | 2 +- mayor-orig/mayor-felveteli/log/mayor-felveteli.rev | 2 +- mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev | 2 +- .../mayor-installer-orig/log/mayor-installer.rev | 2 +- .../log/mayor-installer-sulix.rev | 2 +- mayor-orig/mayor-jatek/log/mayor-jatek.rev | 2 +- .../log/mayor-locales-de_DE.rev | 2 +- .../log/mayor-locales-en_US.rev | 2 +- .../log/mayor-locales-jp_JP.rev | 2 +- .../install/module-naplo/mysql/intezmeny.sql | 2 +- mayor-orig/mayor-naplo/log/mayor-naplo.rev | 2 +- .../mayor-naplo/update/pre004671-1-intezmeny.sql | 14 +++++ .../include/menu/private/hu_HU/module-naplo.php | 2 + .../include/modules/naplo/export/kretaOrarend.php | 70 ++++++++++++++++++++++ .../hu_HU/module-naplo/export/kretaOrarend.php | 8 +++ .../private/naplo/export/kretaOrarend-pre.php | 53 ++++++++++++++++ .../policy/private/naplo/export/kretaOrarend.php | 12 ++++ .../module-naplo/html/export/kretaOrarend.phtml | 66 ++++++++++++++++++++ mayor-orig/mayor-portal/log/mayor-portal.rev | 2 +- mayor-orig/mayor-wiki/log/mayor-wiki.rev | 2 +- mayor-orig/md5sum | 26 ++++---- mayor-orig/rev.txt | 2 +- rev.txt | 2 +- 23 files changed, 253 insertions(+), 28 deletions(-) create mode 100644 mayor-orig/mayor-naplo/update/pre004671-1-intezmeny.sql create mode 100644 mayor-orig/mayor-naplo/www/include/modules/naplo/export/kretaOrarend.php create mode 100644 mayor-orig/mayor-naplo/www/lang/hu_HU/module-naplo/export/kretaOrarend.php create mode 100644 mayor-orig/mayor-naplo/www/policy/private/naplo/export/kretaOrarend-pre.php create mode 100644 mayor-orig/mayor-naplo/www/policy/private/naplo/export/kretaOrarend.php create mode 100644 mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/export/kretaOrarend.phtml (limited to 'mayor-orig/mayor-naplo/update') diff --git a/mayor-orig/mayor-base/log/mayor-base.rev b/mayor-orig/mayor-base/log/mayor-base.rev index ae6d0645..add7598c 100644 --- a/mayor-orig/mayor-base/log/mayor-base.rev +++ b/mayor-orig/mayor-base/log/mayor-base.rev @@ -1 +1 @@ -4670 +4672 diff --git a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev index ae6d0645..add7598c 100644 --- a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev +++ b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev @@ -1 +1 @@ -4670 +4672 diff --git a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev index ae6d0645..add7598c 100644 --- a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev +++ b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev @@ -1 +1 @@ -4670 +4672 diff --git a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev index ae6d0645..add7598c 100644 --- a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev +++ b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev @@ -1 +1 @@ -4670 +4672 diff --git a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev index ae6d0645..add7598c 100644 --- a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev +++ b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev @@ -1 +1 @@ -4670 +4672 diff --git a/mayor-orig/mayor-jatek/log/mayor-jatek.rev b/mayor-orig/mayor-jatek/log/mayor-jatek.rev index ae6d0645..add7598c 100644 --- a/mayor-orig/mayor-jatek/log/mayor-jatek.rev +++ b/mayor-orig/mayor-jatek/log/mayor-jatek.rev @@ -1 +1 @@ -4670 +4672 diff --git a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev index ae6d0645..add7598c 100644 --- a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev +++ b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev @@ -1 +1 @@ -4670 +4672 diff --git a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev index ae6d0645..add7598c 100644 --- a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev +++ b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev @@ -1 +1 @@ -4670 +4672 diff --git a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev index ae6d0645..add7598c 100644 --- a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev +++ b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev @@ -1 +1 @@ -4670 +4672 diff --git a/mayor-orig/mayor-naplo/install/module-naplo/mysql/intezmeny.sql b/mayor-orig/mayor-naplo/install/module-naplo/mysql/intezmeny.sql index bb15985a..1912a862 100644 --- a/mayor-orig/mayor-naplo/install/module-naplo/mysql/intezmeny.sql +++ b/mayor-orig/mayor-naplo/install/module-naplo/mysql/intezmeny.sql @@ -263,7 +263,7 @@ CREATE TABLE `tanar` ( `oId` bigint(20) unsigned DEFAULT NULL, `beDt` date DEFAULT NULL, `kiDt` date DEFAULT NULL, - `viseltNevElotag` varchar(8) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '', + `viseltNevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT NULL, `viseltCsaladinev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '', `viseltUtonev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '', `szuletesiHely` varchar(16) COLLATE utf8_hungarian_ci DEFAULT NULL, diff --git a/mayor-orig/mayor-naplo/log/mayor-naplo.rev b/mayor-orig/mayor-naplo/log/mayor-naplo.rev index ae6d0645..add7598c 100644 --- a/mayor-orig/mayor-naplo/log/mayor-naplo.rev +++ b/mayor-orig/mayor-naplo/log/mayor-naplo.rev @@ -1 +1 @@ -4670 +4672 diff --git a/mayor-orig/mayor-naplo/update/pre004671-1-intezmeny.sql b/mayor-orig/mayor-naplo/update/pre004671-1-intezmeny.sql new file mode 100644 index 00000000..6fc53da7 --- /dev/null +++ b/mayor-orig/mayor-naplo/update/pre004671-1-intezmeny.sql @@ -0,0 +1,14 @@ +DELIMITER $$ +DROP PROCEDURE IF EXISTS upgrade_database_4671 $$ + +CREATE PROCEDURE upgrade_database_4671() +BEGIN +SET NAMES utf8 COLLATE utf8_hungarian_ci; + +IF EXISTS (SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() and TABLE_NAME='tanar' and COLUMN_NAME='viseltNevElotag') THEN + ALTER TABLE `tanar` MODIFY `viseltNevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT NULL; +END IF; + +END $$ +DELIMITER ; +CALL upgrade_database_4671(); diff --git a/mayor-orig/mayor-naplo/www/include/menu/private/hu_HU/module-naplo.php b/mayor-orig/mayor-naplo/www/include/menu/private/hu_HU/module-naplo.php index 25907716..fa205518 100644 --- a/mayor-orig/mayor-naplo/www/include/menu/private/hu_HU/module-naplo.php +++ b/mayor-orig/mayor-naplo/www/include/menu/private/hu_HU/module-naplo.php @@ -348,6 +348,7 @@ 'diakExport' => array(array('txt' => 'Diak adatok')), 'tantargyFelosztas' => array(array('txt' => 'Tantárgyfelosztás export')), 'kreta' => array(array('txt' => 'KRÉTA export')), + 'kretaOrarend' => array(array('txt' => 'KRÉTA órarend export')), ); @@ -529,6 +530,7 @@ 'tantargyFelosztas' => array(array('txt' => 'Tantárgyfelosztás export')), 'sulix' => array(array('txt' => 'Együttműködés SuliXerverrel')), 'kreta' => array(array('txt' => 'KRÉTA export')), + 'kretaOrarend' => array(array('txt' => 'KRÉTA órarend export')), 'tanarOsztalyOraszam' => array(array('txt' => 'Tanár-Osztály óraszámok')), ); $MENU['modules']['naplo']['sub']['intezmeny'] = array( diff --git a/mayor-orig/mayor-naplo/www/include/modules/naplo/export/kretaOrarend.php b/mayor-orig/mayor-naplo/www/include/modules/naplo/export/kretaOrarend.php new file mode 100644 index 00000000..86e0835d --- /dev/null +++ b/mayor-orig/mayor-naplo/www/include/modules/naplo/export/kretaOrarend.php @@ -0,0 +1,70 @@ + 'getOrarendAdat', 'result'=>'indexed','value'=>$v), $lr); + $q = "SELECT tankorId, tankorNev, targyNev, kretaTargyNev, csoportNev FROM ".__INTEZMENYDBNEV.".tankor + LEFT JOIN ".__INTEZMENYDBNEV.".tankorSzemeszter USING (tankorId) + LEFT JOIN ".__INTEZMENYDBNEV.".targy USING (targyId) + LEFT JOIN tankorCsoport USING (tankorId) + LEFT JOIN csoport USING (csoportId) + WHERE tanev=".__TANEV." AND szemeszter=1"; + + $v = array(); + $ADAT['tankor'] = db_query($q, array('fv' => 'getOrarendAdat/tankor', 'result'=>'assoc','keyfield'=>'tankorId','value'=>$v), $lr); + foreach ($ADAT['tankor'] as $_tankorId => $T) { + $M = explode(' ', $T['csoportNev']); + + + if (strpos($T['csoportNev'],',') !== false) $ADAT['t2osztaly'][$_tankorId] = ''; + else $ADAT['t2osztaly'][$_tankorId] = $M[0]; + + if (strpos($T['csoportNev'],' ') === false && strpos($T['csoportNev'],'_') === false) $ADAT['t2csoport'][$_tankorId] = ''; + else $ADAT['t2csoport'][$_tankorId] = $T['csoportNev']; + } + + + db_close($lr); + $ADAT['export'][] = array( + 'Hetirend','Nap','Óra (adott napon belül)','Osztály','Csoport','Tantárgy','Tanár','Helyiség' + ); + foreach ($ADAT['orak'] as $index => $O) { + list($helyseg,$_nev) = explode(" - ",$O['leiras']); + $ADAT['export'][] = array( + $kretaHETIREND[ $O['het'] ], // Hetirend + $aHetNapjai[ $O['nap'] ], // Nap + $O['ora'], // Óra + $ADAT['t2osztaly'][ $O['tankorId'] ], // Osztály + $ADAT['t2csoport'][ $O['tankorId'] ], // Csoport + $ADAT['tankor'][ $O['tankorId'] ]['kretaTargyNev'], // Tantárgy + $ADAT['tanar'][ $O['tanarId'] ]['tanarNev'], // Tanár + $helyseg // Helyiség + ); + } + + return $ADAT['export']; + + } + + function exportKretaOrarend($file, $ADAT) { + + $T = $ADAT['export']; + + if ($ADAT['formatum'] == 'xml') return generateXLS("$file.${ADAT['formatum']}", $T, 'kreta_ETTF_simple'); + elseif ($ADAT['formatum'] == 'csv') return generateCSV("$file.${ADAT['formatum']}", $T, ''); + elseif ($ADAT['formatum'] == 'ods') return generateODS("$file.${ADAT['formatum']}", $T, 'kreta_ETTF_simple'); + else return false; + + } + + +?> \ No newline at end of file diff --git a/mayor-orig/mayor-naplo/www/lang/hu_HU/module-naplo/export/kretaOrarend.php b/mayor-orig/mayor-naplo/www/lang/hu_HU/module-naplo/export/kretaOrarend.php new file mode 100644 index 00000000..eafb4bf3 --- /dev/null +++ b/mayor-orig/mayor-naplo/www/lang/hu_HU/module-naplo/export/kretaOrarend.php @@ -0,0 +1,8 @@ + diff --git a/mayor-orig/mayor-naplo/www/policy/private/naplo/export/kretaOrarend-pre.php b/mayor-orig/mayor-naplo/www/policy/private/naplo/export/kretaOrarend-pre.php new file mode 100644 index 00000000..65b52e40 --- /dev/null +++ b/mayor-orig/mayor-naplo/www/policy/private/naplo/export/kretaOrarend-pre.php @@ -0,0 +1,53 @@ + Kréta "Hetirend" típusú adatszótárának elemeit + - Minden tárgynál be van írva a kretaTargyNev + - Feltételezzük, hogy minden tankör pontosan egy csoportba tartozik bele, s a csoportok a Kréta csoportoknak/osztályoknak megfelelők + - A csoportok elnevezésében feltételezések: + - egész osztályos - csak az osztályjel alkotja a csoportnevet (nincs szóköz és aláhúzás karakter) Pl: 11.a + - több osztályos - az érintett osztályok vesszővel felsoroltak (van benne vessző) Pl: 9.a, 9.b tsf + - osztálybontás - osztályjel után szóközzel elválasztot csoportjel (van benne szóköz) Pl: 7.a csop1 + - A terem leirasa a Krétabeli "Helyiség név" mezővel kezdődik, " - " után követheti bármi Pl: 120Fi - Fizika előadó + - A tanár neve a Krétabelivel pontosan egyező +*/ +if (_RIGHTS_OK !== true) die(); +if (!__NAPLOADMIN && !__VEZETOSEG) { + $_SESSION['alert'] = 'page:insufficient_access'; +} else { + require_once('include/modules/naplo/share/osztaly.php'); + require_once('include/modules/naplo/share/munkakozosseg.php'); + require_once('include/modules/naplo/share/tanar.php'); + require_once('include/modules/naplo/share/targy.php'); + require_once('include/modules/naplo/share/file.php'); + + if ($action == "kretaOrarendExport") { + $ADAT['tanar'] = getTanarok(array('result'=>'assoc')); + $ADAT['export'] = getOrarendAdat($ADAT); + + + $ADAT['formatum'] = readVariable($_POST['formatum'], 'enum', null, array('csv','ods','xml')); + if ($ADAT['formatum'] == 'xml') $ADAT['mime'] = 'application/vnd.ms-excel'; + if (isset($ADAT['formatum'])) { + $file = _DOWNLOADDIR.'/private/naplo/export/kretaOrarend_'.date('Ymd'); + if (exportKretaOrarend($file, $ADAT)) { + header('Location: '.location('index.php?page=session&f=download&download=true&dir=naplo/export/&file='.$file.'.'.$ADAT['formatum'].'&mimetype='.$ADAT['mime'])); + } + } + + } + + + +} diff --git a/mayor-orig/mayor-naplo/www/policy/private/naplo/export/kretaOrarend.php b/mayor-orig/mayor-naplo/www/policy/private/naplo/export/kretaOrarend.php new file mode 100644 index 00000000..ecc722e0 --- /dev/null +++ b/mayor-orig/mayor-naplo/www/policy/private/naplo/export/kretaOrarend.php @@ -0,0 +1,12 @@ +'; + putKretaOrarendForm($ADAT); + + + +?> \ No newline at end of file diff --git a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/export/kretaOrarend.phtml b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/export/kretaOrarend.phtml new file mode 100644 index 00000000..7ffeccad --- /dev/null +++ b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/export/kretaOrarend.phtml @@ -0,0 +1,66 @@ +href('index.php?page=naplo&sub=export&f=kretaOrarend'), 'class'=>"export")); + echo ''."\n"; + + echo '
Kréta - Órarend export'."\n"; + echo ''."\n"; + + echo ''."\n"; + echo ''."\n"; + echo ''; + echo ''; + echo ''; + + echo ''; + + + echo ''; + echo ''."\n"; + echo ''."\n"; + + echo ''; + echo ''; + echo ''; + + echo '
Tudnivalók
'; + echo '

Az elkészült órarendet a Krétába való importálásra alkalmas formátumban exportáljuk ki +(ld Kréta tudásbázis/Órarend importálása). +

+A funkció működéséhez sok előfeltételnek kell megfelelni, hogy a két rendszer adatai jól megfeleltetetők legyenek egymással: +

+
    +
  • A configban a $kretaHETIREND vektorba fel kell venni a Kráta adatszótárának "Hetirend" típusú elemeit. +
  • A tanárneveknek pontosan egyeznie kell a két rendszerben +
  • A tárgyaknál fel kell venni a kretaTargyNev mezőbe a Krétában használt tárgynevet +
  • Minden tankörnek bele kell tartoznia pontosan egy csoportba, mely egy Kréta csoportot vagy osztályt jelöl meg +
  • ... +
+'; + echo '
Formátum kiválasztása
'; + echo '
    '; + echo '
  • '; + echo ''."\n"; + echo ''."\n"; + echo '
    • '; + echo '
  • '; + echo ''."\n"; + echo ''."\n"; + echo '
    • '; + echo '
  • '; + echo ''."\n"; + echo ''."\n"; + echo '
'; + echo '
'; + echo ''."\n"; + echo '
'."\n"; + echo '
'; + formEnd(); + + + + } + +?> \ No newline at end of file diff --git a/mayor-orig/mayor-portal/log/mayor-portal.rev b/mayor-orig/mayor-portal/log/mayor-portal.rev index ae6d0645..add7598c 100644 --- a/mayor-orig/mayor-portal/log/mayor-portal.rev +++ b/mayor-orig/mayor-portal/log/mayor-portal.rev @@ -1 +1 @@ -4670 +4672 diff --git a/mayor-orig/mayor-wiki/log/mayor-wiki.rev b/mayor-orig/mayor-wiki/log/mayor-wiki.rev index ae6d0645..add7598c 100644 --- a/mayor-orig/mayor-wiki/log/mayor-wiki.rev +++ b/mayor-orig/mayor-wiki/log/mayor-wiki.rev @@ -1 +1 @@ -4670 +4672 diff --git a/mayor-orig/md5sum b/mayor-orig/md5sum index b78cc000..3865264a 100644 --- a/mayor-orig/md5sum +++ b/mayor-orig/md5sum @@ -1,13 +1,13 @@ -Revision 4670 -cba1147e897c76e7c16d45dbe47d1182 mayor-fenntarto-rev4670.tgz -fd708eb082977562764f1b1825e29f67 mayor-installer-sulix-rev4670.tgz -a721fb2bfbd2839c3cba735b1c4caab8 mayor-wiki-rev4670.tgz -c8b3a9922b7b5cd9dedba587bd15c4f1 mayor-installer-rev4670.tgz -61204f6f2312a735247d998c397de7fa mayor-portal-rev4670.tgz -8093da7931507cde6c2aaad259ceda4d mayor-felveteli-rev4670.tgz -3c08d033790423f67349f0ec352246d0 mayor-jatek-rev4670.tgz -3bbb4da1261cc77507793fdb7ff0256a mayor-locales-jp_JP-rev4670.tgz -a6456f0d911fce770b9e8840fbf87833 mayor-locales-de_DE-rev4670.tgz -f6b1df395dc6d411fa682916058279c3 mayor-locales-en_US-rev4670.tgz -b8b5c925ecfcc25da36bb202564f0e1e mayor-naplo-rev4670.tgz -024478761bf99fd4af52cd6d06814946 mayor-base-rev4670.tgz +Revision 4672 +fa3a2cfc4dcb15d3bc2d724c57fddb05 mayor-fenntarto-rev4672.tgz +d6234cb9976883ace2d7554a564668e9 mayor-installer-sulix-rev4672.tgz +01ce30cf2bedbb47578303501111276f mayor-wiki-rev4672.tgz +6339984a2216b9d18d47888f16dd3fea mayor-installer-rev4672.tgz +00e9cae74d0b7d46dffc42f27ac634ca mayor-portal-rev4672.tgz +6250ecdc903a4b409b76e2eb7d4bfa2d mayor-felveteli-rev4672.tgz +c3342f79c92249a8229532b74698527d mayor-jatek-rev4672.tgz +00f8c4fe37e08bc4e809d85520095571 mayor-locales-jp_JP-rev4672.tgz +16ca20a346f389ed558517cd431ff1f4 mayor-locales-de_DE-rev4672.tgz +80a3e9e94de834c28f7cb485ca616b35 mayor-locales-en_US-rev4672.tgz +59d50884d02e195b650666648d85428e mayor-naplo-rev4672.tgz +92b950464027b4659b34ffa46f71f7be mayor-base-rev4672.tgz diff --git a/mayor-orig/rev.txt b/mayor-orig/rev.txt index ae6d0645..add7598c 100644 --- a/mayor-orig/rev.txt +++ b/mayor-orig/rev.txt @@ -1 +1 @@ -4670 +4672 diff --git a/rev.txt b/rev.txt index ae6d0645..add7598c 100644 --- a/rev.txt +++ b/rev.txt @@ -1 +1 @@ -4670 +4672 -- cgit v1.2.3