From 4c6b313fae97ccb7eaae75b5d05881f10469e13d Mon Sep 17 00:00:00 2001 From: M.Gergo Date: Tue, 31 Mar 2020 19:30:03 +0200 Subject: Rev: 4644 --- .../www/include/modules/naplo/share/ora.php | 40 ++++++++++++++++++++++ .../private/naplo/haladasi/hazifeladat-pre.php | 28 ++++++++++----- .../policy/private/naplo/orarend/orarend-pre.php | 7 ++++ .../policy/private/naplo/tools/getOraAdat-pre.php | 3 -- .../module-naplo/css/haladasi/hazifeladat.css | 5 +++ .../classic/module-naplo/css/orarend/orarend.css | 14 +++++++- .../module-naplo/html/haladasi/hazifeladat.phtml | 10 +++++- .../module-naplo/html/orarend/orarend.phtml | 33 ++++++++++++++---- .../classic/module-naplo/html/uzeno/uzeno.phtml | 3 +- .../javascript/haladasi/hazifeladat.jquery.min.js | 7 ++++ .../module-naplo/javascript/naplo.jquery.min.js | 16 +++++++-- 11 files changed, 143 insertions(+), 23 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 60ddb4fa..1809ab50 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 @@ -26,6 +26,8 @@ munkaido, hazifeladatId, hazifeladatLeiras, + hazifeladatFeltoltesEngedely, + hazifeladatHataridoDt, cimkeId, cimkeLeiras FROM `%s`.ora LEFT JOIN `%s`.oraHazifeladat USING (oraId) @@ -633,6 +635,18 @@ WHERE dt>='%s' and dt<='%s' AND tankorId IN (".implode(',', array_fill(0, count( return $R; } + function getKovetkezoOraAdatByOraId($oraId) { + if ($oraId>0) { + $q = "SELECT * FROM ora WHERE oraId = %u"; + $v = array($oraId); + $ORA = db_query($q,array('debug'=>false,'fv'=>'oraMostVane','modul'=>'naplo','values'=>$v,'result'=>'record')); + $q = "SELECT * FROM ora WHERE dt>'%s' AND tankorId=%u AND tipus NOT IN ('elmarad','elmarad_máskor') ORDER BY dt LIMIT 1"; + $v = array($ORA['dt'],$ORA['tankorId']); + $R = db_query($q,array('debug'=>false,'fv'=>'oraMostVane','modul'=>'naplo','values'=>$v,'result'=>'record')); + } + return $R; + } + function getDiakOra($diakId,$dt,$ora,$olr_intezmeny = '',$olr_naplo) { // jelenlét mezőt nem vesszük figyelembe!!! // diakId->tankor->ora @@ -669,5 +683,31 @@ WHERE dt>='%s' and dt<='%s' AND tankorId IN (".implode(',', array_fill(0, count( return $R; } + function getDiakHazifeladatByHatarido($diakId,$ADAT,$olr='') { + $dt = $hazifeladatHataridoDt = readVariable($ADAT['hazifeladatHataridoDt'],'date',null); + $R = array(); + if ($diakId>0 && !is_null($hazifeladatHataridoDt)) { + $tankorIds = getTankorByDiakId($diakId, __TANEV, $SET = array('csakId' => true, 'tolDt' => $dt, 'igDt' => $dt, 'result'=>'idonly'),$olr); + if (count($tankorIds)>0) { + $q = "SELECT *,getNev(tankorId,'tankor') AS tankorNev +FROM oraHazifeladat +LEFT JOIN ora USING (oraId) +LEFT JOIN oraHazifeladatDiak ON (oraHazifeladat.hazifeladatId = oraHazifeladatDiak.hazifeladatId AND diakId=%u) +WHERE tankorId IN (".implode(',',$tankorIds).") AND hazifeladatHataridoDt BETWEEN '%s' AND '%s 23:59:59'"; + $v = array($diakId,$hazifeladatHataridoDt,$hazifeladatHataridoDt); + } else { // fallback + $q = "SELECT *,getNev(tankorId,'tankor') AS tankorNev FROM oraHazifeladat LEFT JOIN oraHazifeladatDiak USING (hazifeladatId) LEFT JOIN ora USING (oraId) WHERE diakId=%u AND DATE(hazifeladatHataridoDt)='%s'"; + $v = array($diakId,$hazifeladatHataridoDt); + } + $R = db_query($q,array('debug'=>false,'fv'=>'getDiakhazifeladatByOraIds','modul'=>'naplo','values'=>$v,'result'=>'indexed'),$olr); + } + return $R; + } + + function getOsztalyHazifeladatByHatarido($osztalyId,$ADAT,$olr='') { + // loop $diakId + $hazifeladatHataridoDt = $ADAT['hazifeladatHataridoDt']; + + } ?> diff --git a/mayor-orig/mayor-naplo/www/policy/private/naplo/haladasi/hazifeladat-pre.php b/mayor-orig/mayor-naplo/www/policy/private/naplo/haladasi/hazifeladat-pre.php index 931b7dcd..ac911f8b 100644 --- a/mayor-orig/mayor-naplo/www/policy/private/naplo/haladasi/hazifeladat-pre.php +++ b/mayor-orig/mayor-naplo/www/policy/private/naplo/haladasi/hazifeladat-pre.php @@ -53,21 +53,32 @@ $values = array($ADAT['oraId']); $ADAT['hazifeladatId'] = $hazifeladatId = db_query($q, array('modul'=>'naplo','result'=>'value','values'=>$values)); $ADAT['oraAdat'] = getOraadatById($oraId); + $ADAT['oraAdat']['oraBeirhato'] = oraBeirhato($ADAT['oraAdat']['oraId']); $ADAT['nevsor'] = getTankorDiakjaiByInterval($ADAT['oraAdat']['tankorId'], __TANEV, $ADAT['oraAdat']['dt'], $ADAT['oraAdat']['dt']); - + $ADAT['kovetkezoOraAdat'] = getKovetkezoOraAdatByOraId($ADAT['oraAdat']['oraId']); if (__TANAR===true && $action=='hazifeladatBeiras') { + $hazifeladatHataridoDt = readVariable($_POST['hazifeladatHataridoDt'],'datetime',null); $hazifeladatFeltoltesEngedely = readVariable($_POST['hazifeladatFeltoltesEngedely'],'id',0); if ($hazifeladatId>0) { // update - $q = "UPDATE oraHazifeladat set hazifeladatLeiras='%s',hazifeladatFeltoltesEngedely=%u WHERE hazifeladatId=%u"; - $values = array($ADAT['hazifeladatLeiras'],$hazifeladatFeltoltesEngedely,$ADAT['hazifeladatId']); - $r = db_query($q, array('modul'=>'naplo','result'=>'update','values'=>$values)); + if (is_null($hazifeladatHataridoDt)) { + $q = "UPDATE oraHazifeladat set hazifeladatLeiras='%s',hazifeladatFeltoltesEngedely=%u WHERE hazifeladatId=%u"; + $values = array($ADAT['hazifeladatLeiras'],$hazifeladatFeltoltesEngedely,$ADAT['hazifeladatId']); + } else { + $q = "UPDATE oraHazifeladat set hazifeladatLeiras='%s',hazifeladatFeltoltesEngedely=%u,hazifeladatHataridoDt='%s' WHERE hazifeladatId=%u"; + $values = array($ADAT['hazifeladatLeiras'],$hazifeladatFeltoltesEngedely,$hazifeladatHataridoDt,$ADAT['hazifeladatId']); + } + $r = db_query($q, array('debug'=>false,'modul'=>'naplo','result'=>'update','values'=>$values)); } elseif ($oraId>0) { // insert - $q = "INSERT IGNORE INTO oraHazifeladat (hazifeladatLeiras,oraId,hazifeladatFeltoltesEngedely) VALUES ('%s',%u,%u)"; - $values = array($ADAT['hazifeladatLeiras'],$ADAT['oraId'],$hazifeladatFeltoltesEngedely); + if (is_null($hazifeladatHataridoDt)) { + $q = "INSERT IGNORE INTO oraHazifeladat (hazifeladatLeiras,oraId,hazifeladatFeltoltesEngedely) VALUES ('%s',%u,%u)"; + $values = array($ADAT['hazifeladatLeiras'],$ADAT['oraId'],$hazifeladatFeltoltesEngedely); + } else { + $q = "INSERT IGNORE INTO oraHazifeladat (hazifeladatLeiras,oraId,hazifeladatFeltoltesEngedely,hazifeladatHataridoDt) VALUES ('%s',%u,%u,'%s')"; + $values = array($ADAT['hazifeladatLeiras'],$ADAT['oraId'],$hazifeladatFeltoltesEngedely,$hazifeladatHataridoDt); + } $hazifeladatId = db_query($q, array('modul'=>'naplo','result'=>'insert','values'=>$values)); - } - if ($oraId>0 && strtotime(date('Y-m-d'))>=strtotime($ADAT['oraAdat']['dt'])) { + if ($oraId>0 && $ADAT['oraAdat']['oraBeirhato']===true ) { $leiras = readVariable($_POST['oraLeiras'],'string'); updateHaladasiNaploOra($oraId, $leiras); } @@ -170,6 +181,7 @@ $ADAT['hazifeladatDiak'] = db_query($q, array('debug'=>false,'modul'=>'naplo','result'=>'indexed','values'=>$values)); } $ADAT['oraAdat'] = getOraadatById($oraId); + $ADAT['oraAdat']['oraBeirhato'] = oraBeirhato($ADAT['oraAdat']['oraId']); $TOOL['vissza'] = array('tipus'=>'vissza', 'paramName'=>'vissza', diff --git a/mayor-orig/mayor-naplo/www/policy/private/naplo/orarend/orarend-pre.php b/mayor-orig/mayor-naplo/www/policy/private/naplo/orarend/orarend-pre.php index c56b6d87..262ff572 100644 --- a/mayor-orig/mayor-naplo/www/policy/private/naplo/orarend/orarend-pre.php +++ b/mayor-orig/mayor-naplo/www/policy/private/naplo/orarend/orarend-pre.php @@ -235,7 +235,14 @@ $_napok = getNapok(array('tolDt'=>$tolDt,'igDt'=>$igDt)); for ($i=0; $i0) { + $lr = db_connect('naplo'); + $_HF = getDiakHazifeladatByHatarido($diakId,array('hazifeladatHataridoDt'=>$_dt),$lr); + if (is_array($_HF) && count($_HF)>0) $ADAT['hazifeladat'][$_dt] = $_HF; + db_close($lr); + } } if (_POLICY!='public' && is_array($TANKOROK)) { diff --git a/mayor-orig/mayor-naplo/www/policy/private/naplo/tools/getOraAdat-pre.php b/mayor-orig/mayor-naplo/www/policy/private/naplo/tools/getOraAdat-pre.php index 1596e591..064bc796 100644 --- a/mayor-orig/mayor-naplo/www/policy/private/naplo/tools/getOraAdat-pre.php +++ b/mayor-orig/mayor-naplo/www/policy/private/naplo/tools/getOraAdat-pre.php @@ -27,13 +27,10 @@ $leiras = readVariable($_POST['leiras'], 'string'); updateHaladasiNaploOra($oraId,$leiras); } - $_JSON['oraAdat'] = $ORAADAT = getOraAdatById($oraId); - if ($ORAADAT['hazifeladatId']>0) { oraHazifeladatDiakLatta($ORAADAT['hazifeladatId']); // log: diakLattamDt } - if ($dolgozatBeirhato === true && $action=='dolgozatBeiras') { $dolgozatId = ujDolgozat('',$ORAADAT['tankorId']); dolgozatModositas($dolgozatId,'',$ORAADAT['dt']); diff --git a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/css/haladasi/hazifeladat.css b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/css/haladasi/hazifeladat.css index cc5f8869..a44e9d2d 100644 --- a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/css/haladasi/hazifeladat.css +++ b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/css/haladasi/hazifeladat.css @@ -65,3 +65,8 @@ table.hazifeladatDiak tr td a:hover, fieldset.adatok a:hover { text-decoration:underline; color: cornflowerblue; } table.hazifeladatDiak tr td.kesz { background-color: lightgreen; color:white; text-align:center } + + input.modosit { background-color: #ffeb3b; } + span#hintDt {margin-left:5px; font-size:x-small; color:#888; cursor: copy;} + span#hintDt span { padding-right:2px; } + span#hintDt:hover { color: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 836e0ee2..9fc17d27 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 @@ -90,12 +90,25 @@ table.orarend tbody tr td div.jegyzet { margin:2px; font-size: x-small; } +table.orarend tbody tr td div.hazifeladat { + background-color: #3f51b5; color:white; + background-color: #e91e63; + border-radius:2px; padding:2px; + border: solid 1px white; + margin:2px; + font-size: x-small; +} table.orarend tbody tr td div.jegyzet.publikus0 { } table.orarend tbody tr td div.jegyzet.publikus1 { border: dashed 1px white; } table.orarend tbody tr td div.jegyzet.publikus2 { border: dotted 1px white; } table.orarend tbody tr td div.jegyzet.mase.publikus1 { background-color: #4caf50;} table.orarend tbody tr td div.jegyzet.mase.publikus2 { background-color: #4caf50;} + +table.orarend tbody tr td div.hazifeladat span { padding-right:2px; } +table.orarend tbody tr td div.hazifeladat.tanarLattam { background-color: #2E7D32;} +table.orarend tbody tr td div.hazifeladat.diakKesz { background-color: #4CAF50;} + table.orarend tbody tr.orarendJegyzetSor th { background-color: orange; border-color: orange; font-weight:normal; font-size: x-small; cursor: pointer} table.orarend tbody tr.orarendJegyzetSor td.jegyzetContainer { background-color: cornflowerblue; } table.orarend tbody tr.orarendJegyzetSor td.jegyzetContainer div:hover { border-color: #bbb; transition : border 50ms ease-out;} @@ -215,7 +228,6 @@ div.unfinished { 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/hazifeladat.phtml b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/haladasi/hazifeladat.phtml index e03ac99a..83d5d6f1 100644 --- a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/haladasi/hazifeladat.phtml +++ b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/haladasi/hazifeladat.phtml @@ -107,7 +107,7 @@ echo ''; echo '
'.ucfirst(_TANANYAG).''."\n"; - if ($ADAT['oraAdat']['oraId']>0 && strtotime(date('Y-m-d'))>=strtotime($ADAT['oraAdat']['dt'])) { + if ($ADAT['oraAdat']['oraId']>0 && strtotime(date('Y-m-d'))>=strtotime($ADAT['oraAdat']['dt']) && $ADAT['oraAdat']['oraBeirhato']===true) { echo ''; echo ''; } else { @@ -116,6 +116,7 @@ echo '
'."\n"; echo '
'._HAZIFELADAT.''."\n"; + echo ''; @@ -151,6 +152,13 @@ echo ''; echo ''; echo ''; + echo 'Leadási határidő: '; + if ($ADAT['kovetkezoOraAdat']['oraId']>0) { + echo ''; + echo ''; + echo 'következő tervezett óra: '.$ADAT['kovetkezoOraAdat']['dt']; + echo ''; + } 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 77ad0bce..f36850bc 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 @@ -24,11 +24,7 @@ function putOrarend($ADAT) { global $aHetNapjai,$skin; - // $ADAT['utolsoorak'][$teremId]['oraId'] - - /* Képzés-Mátrix */ - //dump($ADAT['kepzesOraterv']); if (is_array($ADAT['kepzesOraterv']) && count($ADAT['kepzesOraterv'])>0) { $kepzes_figyel = true; $KEPZES_MATRIX[2]=$ADAT['kepzesOraterv']['első nyelv']['sum']; @@ -37,7 +33,6 @@ +$ADAT['kepzesOraterv']['kötelezően választható']['sum'] +$ADAT['kepzesOraterv']['szabadon választható']['sum'] ; - //dump($KEPZES_MATRIX); } else $kepzes_figyel = false; // ---------------- $multiTelephely = (count($ADAT['orarend']['telephelyIdk'])>1); @@ -152,10 +147,10 @@ } echo ''."\n"; // echo ''.$het.'. heti órarend'; - if (count($ADAT['dolgozat']['tervezett'])>0 || count($ADAT['jegyzet'])>0) { $_jegyzetSorCss = ''; } else { $_jegyzetSorStyle = 'display:none;'; } + if (count($ADAT['dolgozat']['tervezett'])>0 || count($ADAT['jegyzet'])>0 || (is_array($ADAT['hazifeladat']) && count($ADAT['hazifeladat'])>0)) { $_jegyzetSorCss = ''; } else { $_jegyzetSorStyle = 'display:none;'; } echo ''; echo ''; - echo 'dolgozatok, jegyzetek'; + echo 'dolgozatok, jegyzetek, határidők'; // echo ''; echo ''; for ($nap=1;$nap<=$ADAT['hetiMaxNap'];$nap++) { @@ -192,6 +187,30 @@ echo ''; } } + + //for ($d=0; $d0) { + for ($_h=0; $_hházifeladat '.$_str.'
'.$_HF['tankorNev'].''; + } + } + //} echo ''; } echo ''; diff --git a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/uzeno/uzeno.phtml b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/uzeno/uzeno.phtml index 24304570..a7302388 100644 --- a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/uzeno/uzeno.phtml +++ b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/html/uzeno/uzeno.phtml @@ -124,7 +124,8 @@ $href_szal = href('index.php?page=naplo&sub=uzeno&f=uzeno&szalId='.$D['feladoId'].'_'.$D['feladoTipus'].'_'.$D['cimzettId'].'_'.$D['cimzettTipus'].'&mId='.$D['mId'],array('sessionID','lang','policy')); // $D['txt'] = ''.nl2br(htmlspecialchars($D['txt'])).''; - $D['txt'] = makelinksclickable(nl2br(supertext($D['txt']))); + // $D['txt'] = makelinksclickable(nl2br(supertext($D['txt']))); + $D['txt'] = (nl2br(supertext($D['txt']))); echo (mb_substr($D['txt'],0,2000,'UTF-8')); if (mb_strlen($D['txt'],'UTF-8')>2000) { echo ' ...'; diff --git a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/javascript/haladasi/hazifeladat.jquery.min.js b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/javascript/haladasi/hazifeladat.jquery.min.js index 4d225a86..a8e1d250 100644 --- a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/javascript/haladasi/hazifeladat.jquery.min.js +++ b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/javascript/haladasi/hazifeladat.jquery.min.js @@ -9,4 +9,11 @@ $(function() { } }); + $('#hintDt').click(function(){ + // console.log($('#hazifeladatHataridoDt').val()); + $('#hazifeladatHataridoDt').addClass('modosit'); + $('#hazifeladatHataridoDt').val($('#hintDt').data('hintdt')); + }); + + }); \ No newline at end of file diff --git a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/javascript/naplo.jquery.min.js b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/javascript/naplo.jquery.min.js index df72b0cb..b5d19f89 100644 --- a/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/javascript/naplo.jquery.min.js +++ b/mayor-orig/mayor-naplo/www/skin/classic/module-naplo/javascript/naplo.jquery.min.js @@ -727,18 +727,30 @@ processJSONOraAdat = function(adat) { } } + // content += '

Óra kapcsolatai

'; // content += '
  • Beírt mulasztások száma: '+'n/a'+'
    • '; // content += '
  • Beírt jegyek száma: '+'n/a'+'
    • '; // content += '
'; content += '

Házi feladat '; - content += ''; + content += ''; + if (adat['oraAdat']['hazifeladatFeltoltesEngedely']==1) { + content += ''; + } else { + content += ''; + } + content += ''; content += '

'; if (adat['oraAdat']['hazifeladatId']>0) { - content += '
'; + if (adat['oraAdat']['hazifeladatHataridoDt']!=null) { + content += '
  • Határidő: '+adat['oraAdat']['hazifeladatHataridoDt']+'
'; + } + if (adat['oraAdat']['hazifeladatLeiras']!='') { + content += '
'; content += adat['oraAdat']['hazifeladatLeiras']; content += '
'; + } } content += '

Dolgozatok

'; -- cgit v1.2.3