From 84cd05de4eaba22c158f88564b7941d5f4d70069 Mon Sep 17 00:00:00 2001 From: M.Gergo Date: Fri, 27 Mar 2020 17:10:04 +0100 Subject: Rev: 4641 --- .../www/include/modules/naplo/share/ora.php | 20 ++++++++++++++++---- .../classic/module-naplo/css/haladasi/haladasi.css | 7 +++++++ .../classic/module-naplo/css/orarend/orarend.css | 9 +++++++++ .../module-naplo/html/haladasi/haladasi.phtml | 15 ++++++++++----- .../classic/module-naplo/html/orarend/orarend.phtml | 5 +++++ 5 files changed, 47 insertions(+), 9 deletions(-) (limited to 'mayor-orig/mayor-naplo/www') diff --git a/mayor-orig/mayor-naplo/www/include/modules/naplo/share/ora.php b/mayor-orig/mayor-naplo/www/include/modules/naplo/share/ora.php index 602f26e1..60ddb4fa 100644 --- a/mayor-orig/mayor-naplo/www/include/modules/naplo/share/ora.php +++ b/mayor-orig/mayor-naplo/www/include/modules/naplo/share/ora.php @@ -24,16 +24,20 @@ tankorNev, feladatTipusId, munkaido, - hazifeladatId, hazifeladatLeiras + hazifeladatId, + hazifeladatLeiras, + cimkeId, cimkeLeiras FROM `%s`.ora LEFT JOIN `%s`.oraHazifeladat USING (oraId) + LEFT JOIN `%s`.oraCimke USING (oraId) + LEFT JOIN ".__INTEZMENYDBNEV.".cimke USING (cimkeId) LEFT JOIN ".__INTEZMENYDBNEV.".tankorSzemeszter USING (tankorId) LEFT JOIN ".__INTEZMENYDBNEV.".tanar AS t1 ON ki=t1.tanarId LEFT JOIN ".__INTEZMENYDBNEV.".tanar AS t2 ON kit=t2.tanarId LEFT JOIN ".__INTEZMENYDBNEV.".feladatTipus USING (feladatTipusId) LEFT JOIN ".__INTEZMENYDBNEV.".terem USING (teremId) WHERE oraId=%u AND (tanev=%u OR feladatTipusId IS NOT NULL)"; - $v = array(tanevDbNev(__INTEZMENY, $tanev),tanevDbNev(__INTEZMENY, $tanev), $oraId, $tanev); + $v = array(tanevDbNev(__INTEZMENY, $tanev),tanevDbNev(__INTEZMENY, $tanev), tanevDbNev(__INTEZMENY, $tanev), $oraId, $tanev); return db_query($q, array('fv' => 'getOraAdatById', 'modul' => 'naplo_intezmeny', 'result' => 'record', 'values' => $v), $olr); } else { @@ -349,6 +353,8 @@ } else { $q = "SELECT * FROM ora LEFT JOIN oraHazifeladat USING (oraId) +LEFT JOIN oraCimke USING (oraId) +LEFT JOIN ".__INTEZMENYDBNEV.".cimke USING (cimkeId) WHERE dt>='%s' and dt<='%s' AND (ki=%u OR kit=%u) $WHERE ORDER BY dt,ora"; array_unshift($v, $tolDt, $igDt, $tanarId, $tanarId); if ($SET['result']=='assoc') @@ -389,13 +395,19 @@ WHERE dt>='%s' and dt<='%s' AND (ki=%u OR kit=%u) $WHERE ORDER BY dt,ora"; $RE = db_query($q, array('modul' => 'naplo', 'fv' => 'getOrak', 'result' => 'indexed', 'values' => $v)); } else { if ($SET['elmaradokNelkul']) - $q = "SELECT *,getOraTolTime(ora.oraId) AS tolTime,getOraIgTime(ora.oraId) AS igTime FROM ora + $q = "SELECT *,getOraTolTime(ora.oraId) AS tolTime,getOraIgTime(ora.oraId) AS igTime, cimkeId, cimkeLeiras +FROM ora LEFT JOIN oraHazifeladat USING (oraId) +LEFT JOIN oraCimke USING (oraId) +LEFT JOIN ".__INTEZMENYDBNEV.".cimke USING (cimkeId) WHERE dt>='%s' and dt<='%s' AND tankorId IN (".implode(',', array_fill(0, count($TANKORIDK), '%u')).") AND tipus NOT IN ('elmarad','elmarad máskor')"; else - $q = "SELECT *,getOraTolTime(ora.oraId) AS tolTime,getOraIgTime(ora.oraId) AS igTime FROM ora + $q = "SELECT *,getOraTolTime(ora.oraId) AS tolTime,getOraIgTime(ora.oraId) AS igTime, cimkeId, cimkeLeiras +FROM ora LEFT JOIN oraHazifeladat USING (oraId) +LEFT JOIN oraCimke USING (oraId) +LEFT JOIN ".__INTEZMENYDBNEV.".cimke USING (cimkeId) WHERE dt>='%s' and dt<='%s' AND tankorId IN (".implode(',', array_fill(0, count($TANKORIDK), '%u')).")"; $R = db_query($q, array('modul' => 'naplo', 'fv' => 'getOrak', 'result' => 'indexed', 'values' => $v)); $RE['tankorok']=array(); diff --git a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/css/haladasi/haladasi.css b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/css/haladasi/haladasi.css index 4477f75c..b4449090 100644 --- a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/css/haladasi/haladasi.css +++ b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/css/haladasi/haladasi.css @@ -316,6 +316,13 @@ td.cimke { text-align:center; white-space: wrap; background-color: rgba(255,255,255,0.3);} td.cimke span.cimke {background-color: orange; color:white; font-size:x-small; padding:0px 2px; border-radius: 2px; margin:2px;} + td.cimke span.cimke_0 { background-color: #4caf50; } + td.cimke span.cimke_1 { background-color: red; } + td.cimke span.cimke_2 { background-color: orange; } + td.cimke span.cimke_3 { background-color: #3f51b5; } + td.cimke span.cimke_4 { background-color: #673ab7; } + + } @media print { table.haladasiBejegyzesek thead tr th { border-bottom: solid 1px black;} diff --git a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/css/orarend/orarend.css b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/css/orarend/orarend.css index fab07933..836e0ee2 100644 --- a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/css/orarend/orarend.css +++ b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/css/orarend/orarend.css @@ -207,6 +207,15 @@ div.unfinished { table.orarend div.orarendTools span.dolgozat:hover { color: orange;} table.orarend div.orarendTools span.bezar:hover { color: #f06; } + table.orarend span.cimke { margin:0px 1px; border-radius: 2px; font-size:xx-small; color:white; padding: 0px 2px 0px 2px; background-color:#ddd; } + table.orarend span.cimke_0 { background-color: #4caf50; } + table.orarend span.cimke_1 { background-color: red; } + table.orarend span.cimke_2 { background-color: orange; } + table.orarend span.cimke_3 { background-color: #3f51b5; } + table.orarend span.cimke_4 { background-color: #673ab7; } + + + h2.mayorSocialEdition { text-align: center; background-color: #f06; diff --git a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/haladasi/haladasi.phtml b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/haladasi/haladasi.phtml index ce15cd4d..fa46ad2c 100644 --- a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/haladasi/haladasi.phtml +++ b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/haladasi/haladasi.phtml @@ -53,7 +53,7 @@ echo ($ADAT['oraTerheles'][$ADAT['tanarId']]['ossz']['heti']); } echo ''; - echo ''; + echo ''; if ($tanarId!='') { echo ''.$title.''; if ($ADAT['csakUres']==true) { @@ -106,7 +106,7 @@ echo ($ADAT['oraTerheles'][$ADAT['tanarId']]['ossz']['heti']); } echo ''; - echo ''; + echo ''; // if (_SHOW_DAYS_FROM > $_TANEV['kezdesDt']) echo ''."\n"; if (_SHOW_DAYS_FROM > $_TANEV['kezdesDt']) echo ''; @@ -197,7 +197,7 @@ if (__PLUSZBEIRHAT===true && !$jovoDt) echo '
'; echo ''."\n"; // Az első cella a dátum/nap - echo ''; + echo ''; echo str_replace('-','.',$dt) .'. '; echo ''.$aHetNapjai[(date('w',$time)+6)%7].''; if ($napInfo2['napszam']!='' || $napInfo['orarendiHet'] != 0) { @@ -237,7 +237,7 @@ if (__PLUSZBEIRHAT===true) putUjOra(array('dt'=>$dt, 'ora'=>$j)); } } else { - echo ''._NINCS_ORAJA.''; + echo ''._NINCS_ORAJA.''; // if ($tanitasiNap && strtotime(date('Y-m-d'))>=strtotime($dt)) { // if ( // (strtotime(date('Y-m-d'))>=strtotime($dt) @@ -523,9 +523,14 @@ for ($c = 0; $c0) echo ''.implode(' ',$_C).''; + if (count($_C)>0) { // vigyázz, csak egy címke engedélyezett! (egyelőre, különben sérül a getHaladasi) + $_cimkeId = $dOra['cimke'][0]; + echo ''.implode(' ',$_C).''; + } } } + echo ''; + echo ''; echo ''; diff --git a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/orarend/orarend.phtml b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/orarend/orarend.phtml index 5c75bfb6..77ad0bce 100644 --- a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/orarend/orarend.phtml +++ b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/orarend/orarend.phtml @@ -274,6 +274,11 @@ echo ''; } + if ($_ORA['cimkeLeiras']!='') { + $_cimkeMod = intval($_ORA['cimkeId']) % 5; + echo ''.$_ORA['cimkeLeiras'].''; + } + if (is_array($_hianyzasAdat)) { echo ''; if ($_hianyzasAdat['hTipus']=='hiányzás') -- cgit v1.2.3