QJ_musorKORR.inc

---

Line #0:<?php
Line #1://include("QJ_start.php");
Line #2:
Line #3:$es="";
Line #4:$ha=" where ";
Line #5:$ha="";
Line #6:$wer="";
Line #7:
Line #8:$JeBe="";
Line #9:if ($_POST[JeBe]==1) $JeBe=" and JeBe='Jegy' ";
Line #10:
Line #11:
Line #12:$latni="";
Line #13:if ($_POST[latni]==1) $latni=" and archiv<>'*' ";
Line #14:if ($_POST[latni]==2) $latni=" and archiv='*' ";
Line #15:
Line #16:
Line #17:if (isset($_POST[cim]) and $_POST[cim]<>"*") {
Line #18:$wer=$ha." cim='".$_POST[cim]."'" ;
Line #19:$es=" AND ";
Line #20:$ha="";
Line #21:}
Line #22:
Line #23:if (isset($_POST[helyszin]) and $_POST[helyszin]<>"*") {
Line #24:$wer.= $ha. $es. " helyszin='".$_POST[helyszin]."'";
Line #25:$es=" AND ";
Line #26:$ha="";
Line #27:}
Line #28:
Line #29:if (isset($_POST[datum_fej]) and $_POST[datum_fej]<>"*") {
Line #30:$wer.= $ha. $es. " datum_fej='".$_POST[datum_fej]."'";
Line #31:$es=" AND ";
Line #32:$ha="";
Line #33:}
Line #34:
Line #35:if (isset($_POST[Rhonap]) and $_POST[Rhonap]<>"*") {
Line #36:$wer.= $ha. $es. " left(datum_fej,7)='".$_POST[Rhonap]."'";
Line #37:$es=" AND ";
Line #38:$ha="";
Line #39:}
Line #40:
Line #41:$wer.=$es;
Line #42:
Line #43:$disQ = "SELECT distinct cim FROM qj_musor where future <>'*' $JeBe $latni order by cim" ;
Line #44:
Line #45:
Line #46:$sel1="<SELECT TITLE='cim'
Line #47:onchange=this.form.submit(); return true name='cim'>";
Line #48:
Line #49:
Line #50:
Line #51:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #52:if ($disC[cim]==$_POST[cim]) $sel="SELECTED"; else $sel="";
Line #53:if (trim($disC[cim])<>"")
Line #54:$sel1.="<option value='".$disC[cim]."' $sel >".$disC[cim]."</option>";
Line #55:}
Line #56:
Line #57:$sel1.="</SELECT>";
Line #58:
Line #59:
Line #60:$disQ = "SELECT distinct helyszin FROM qj_musor where future <>'*' $JeBe $latni order by helyszin" ;
Line #61:
Line #62:
Line #63:
Line #64:onchange=this.form.submit(); return true name='helyszin'>";
Line #65:
Line #66:
Line #67:
Line #68:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #69:if ($disC[helyszin]==$_POST[helyszin]) $sel="SELECTED"; else $sel="";
Line #70:if (trim($disC[helyszin])<>"")
Line #71:$sel2.="<option value='".$disC[helyszin]."' $sel >".$disC[helyszin]."</option>";
Line #72:}
Line #73:
Line #74:$sel2.="</SELECT>";
Line #75:
Line #76:$disQ = "SELECT distinct datum_fej FROM qj_musor where future <>'*' $JeBe $latni order by datum_fej" ;
Line #77:
Line #78:
Line #79:$sel3="<SELECT TITLE='Nap'
Line #80:onchange=this.form.submit(); return true name='datum_fej'>";
Line #81:
Line #82:
Line #83:
Line #84:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #85:if ($disC[datum_fej]==$_POST[datum_fej]) $sel="SELECTED"; else $sel="";
Line #86:if (trim($disC[datum_fej])<>"")
Line #87:$sel3.="<option value='".$disC[datum_fej]."' $sel >".$disC[datum_fej]."</option>";
Line #88:}
Line #89:
Line #90:$sel3.="</SELECT>";
Line #91:
Line #92:
Line #93:
Line #94:$disQ = "SELECT distinct left(datum_fej,7) as datum FROM qj_musor where future <>'*' $JeBe $latni order by left(datum_fej,7) " ;
Line #95:
Line #96:
Line #97:
Line #98:onchange=this.form.submit(); return true name='Rhonap'>";
Line #99:
Line #100:
Line #101:
Line #102:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #103:
Line #104:$datum=$disC[datum];
Line #105:
Line #106:/*if (!isset($_POST[Date])) {
Line #107:$_POST[Date]=$datum;
Line #108:$wer.= $ha. $es. " left(logtime,10)='".$_POST[Date]."'";
Line #109:}
Line #110:*/
Line #111:if ($datum==$_POST[Rhonap]) $sel="SELECTED"; else $sel="";
Line #112:if (trim($datum)<>"")
Line #113:$sel4.="<option value='".$datum."' $sel >".$datum."</option>";
Line #114:}
Line #115:
Line #116:$sel4.="</SELECT>";
Line #117:
Line #118://$keres = "SELECT * FROM am_naplo $wer order by logtime DESC";
Line #119:
Line #120:
Line #121:
Line #122:if (isset($_GET[rejt])) {
Line #123:
Line #124:$wjid=$_GET[wjid];
Line #125:
Line #126:if ($_GET[rejt]=="Y") {
Line #127:$SQLarc = "UPDATE qj_musor SET archiv='*' where wid=".$wjid;
Line #128:$_POST[latni]=1;
Line #129:} else {
Line #130:$SQLarc = "UPDATE qj_musor SET archiv='' where wid=".$wjid;
Line #131:$_POST[latni]=2;
Line #132:}
Line #133:
Line #134://echo($SQLarc."<hr>");
Line #135:
Line #136:mysql_query($SQLarc) or die($SQLarc." SQL Hiba");
Line #137:
Line #138:echo "<script>
Line #139: window.open('QJ_exit.php', 'adatframe');
Line #140: window.open('QJ_musSEL.php', 'alfej');
Line #141: </script>";
Line #142:
Line #143:
Line #144:}
Line #145:
Line #146:
Line #147:
Line #148:
Line #149:?>
Line #150:
Line #151:
Line #152:<FORM name=cimform target=sframe action='QJ_musorKORR.php' method='post'>
Line #153:
Line #154:<font color=blue>
Line #155:<INPUT TYPE='radio' NAME='JeBe' Title='Jegyek' value='1'
Line #156:
Line #157:<? if ($_POST[JeBe]==1) echo(' CHECKED '); ?>
Line #158:>Jegyek<?if ($_POST[JeBe]==1) echo("(J)");?>&nbsp;
Line #159:
Line #160:
Line #161:
Line #162:<? if ($_POST[JeBe]==2) echo(' CHECKED '); ?>
Line #163:
Line #164:
Line #165:
Line #166:<INPUT TYPE='radio' NAME='JeBe' Title='Minden' value='4'
Line #167:
Line #168:<? if ($_POST[JeBe]==4) echo(' CHECKED '); ?>>Minden
Line #169:<?if ($_POST[JeBe]==4) echo("(M)");?>
Line #170:
Line #171:</font>
Line #172:
Line #173:
Line #174:
Line #175:<? if ($_POST[latni]==1) echo(' CHECKED '); ?>
Line #176:
Line #177:
Line #178:
Line #179:
Line #180:<? if ($_POST[latni]==2) echo(' CHECKED '); ?>
Line #181:
Line #182:
Line #183:
Line #184:
Line #185:
Line #186:<?if ($_POST[latni]==3) echo("(O)");?>
Line #187:
Line #188:<br>
Line #189:
Line #190:
Line #191:onchange=this.form.submit(); return true name='Korr'>
Line #192:
Line #193:<INPUT TYPE='CHECKBOX' NAME='Desc' Title='' value=''
Line #194:<? if (isset($_POST[Desc])) echo(' CHECKED '); ?>
Line #195:
Line #196:
Line #197:
Line #198:<INPUT TYPE='CHECKBOX' NAME='Szinkron' Title='Szinkron' value=''
Line #199:<? if (isset($_POST[Szinkron])) echo(' CHECKED '); ?>
Line #200:
Line #201:>Szinkron <?if (isset($_POST[Szinkron])) echo("*"); ?> &nbsp;
Line #202:
Line #203:<font color=red>
Line #204:
Line #205:
Line #206:<? if ($_POST[WEB]==1) echo(' CHECKED '); ?>
Line #207:>Intra<?if ($_POST[WEB]==1) echo("(I)");?>&nbsp;
Line #208:
Line #209:
Line #210:
Line #211:<? if ($_POST[WEB]==2) echo(' CHECKED '); ?>
Line #212:>WEB<?if ($_POST[WEB]==2) echo("(W)");?>&nbsp;
Line #213:
Line #214:<INPUT TYPE='radio' NAME='WEB' Title='Intra+WEB' value='3'
Line #215:
Line #216:<? if ($_POST[WEB]==3) echo(' CHECKED '); ?>>I+W
Line #217:<?if ($_POST[WEB]==3) echo("(S)");?>
Line #218:
Line #219:</font>
Line #220:
Line #221:
Line #222:<br>
Line #223:<? echo($sel1); echo($sel2); echo($sel4); ?>
Line #224:
Line #225:</form>
Line #226:
Line #227:<?
Line #228:
Line #229:
Line #230:if (!isset($_SESSION[SQL_inet])) {
Line #231:
Line #232:++$_SESSION[QJ_hiba];
Line #233:/*
Line #234:echo "<script>
Line #235:
Line #236: window.open('QJ_musorLIST.php','sframe');
Line #237: </script>";
Line #238:*/
Line #239:}
Line #240:$_SESSION[QJ_hiba]=0;
Line #241:
Line #242:
Line #243:
Line #244:if (isset($_GET[rogz])) {
Line #245:
Line #246:$wjid=$_GET[wjid];
Line #247:
Line #248:if ($_GET[rogz]=="Y")
Line #249:$SQLarc = "UPDATE `qj_musor` SET
Line #250: `erkezesi`=''
Line #251: where wid=$wjid LIMIT 1";
Line #252:
Line #253:else
Line #254:$SQLarc = "UPDATE `qj_musor` SET
Line #255: `erkezesi`='Y'
Line #256: where wid=$wjid LIMIT 1";
Line #257:
Line #258://echo($SQLarc."<hr>");
Line #259:mysql_query($SQLarc) or die($SQLarc." SQL Hiba");
Line #260:
Line #261:echo "<script>
Line #262: window.open('QJ_exit.php', 'adatframe');
Line #263: window.open('QJ_musSEL.php', 'alfej');
Line #264: </script>";
Line #265:
Line #266:
Line #267:}
Line #268:
Line #269:
Line #270:IF ($_SESSION[admin]<>"ADMIN") $archiv=" archiv <>'*' "; else $archiv=" future <>'*'";
Line #271:
Line #272:$archiv=" future <>'*'";
Line #273:$login=$_SESSION[login];
Line #274:IF (isset($_POST[sqlord])) $ord = " DESC"; else $ord="";
Line #275:if (isset($_SESSION[CALL_mezo])) $mezo=$_SESSION[CALL_mezo]; else $mezo="datum_fej";
Line #276:if (isset($_SESSION[CALL_ord])) $ord=$_SESSION[CALL_ord]; else $ord="";
Line #277:
Line #278:$latni="";
Line #279:if ($_POST[latni]==1) $latni=" and archiv<>'*' ";
Line #280:if ($_POST[latni]==2) $latni=" and archiv='*' ";
Line #281:
Line #282:
Line #283:$JeBe="";
Line #284:if ($_POST[JeBe]==1) $JeBe=" and JeBe='Jegy' ";
Line #285:
Line #286:
Line #287:
Line #288:
Line #289:
Line #290:
Line #291:$WEB="";
Line #292:if ($_POST[WEB]==1) $WEB=" and web<>'web' ";
Line #293:if ($_POST[WEB]==2) $WEB=" and web='web' ";
Line #294:
Line #295:if (isset($_POST[Desc])) $desc= " DESC"; else $desc= "";
Line #296:
Line #297:$keres = "SELECT * FROM qj_musor where $wer future <>'*' $latni $JeBe $WEB ORDER BY datum_fej $desc ,datum ";
Line #298:
Line #299:// echo($keres."<hr>");
Line #300:
Line #301:
Line #302:$nur=mysql_num_rows($eredmeny);
Line #303:
Line #304:
Line #305:$e="<FORM name=musel target=adatframe
Line #306: action='QJ_listaHIV.php' method='post'>
Line #307: ";
Line #308:
Line #309:
Line #310:$parSQL="SELECT * FROM qj_sql where szoveg='MusorListak' and archiv<>'*' and future<>'*' ORDER BY widarc";
Line #311:
Line #312:
Line #313:
Line #314: return true name='Lista_kod'>";
Line #315:
Line #316:while ( $par_sor = mysql_fetch_array( $parQ )) {
Line #317://echo ($par_sor[sql_memo]."/".$par_sor[sql_parancs]."<hr>");
Line #318:if ($_POST[Lista_kod]==$par_sor[sql_memo]) $sel=" SELECTED "; else $sel="";
Line #319:
Line #320: $e=$e."<option value='".$par_sor[sql_memo]."' $sel>".$par_sor[sql_parancs]."</option>";
Line #321:}
Line #322:
Line #323:$e=$e."</select>";
Line #324:
Line #325:
Line #326:
Line #327:/*
Line #328:$e="<FORM name=musel target=adatframe
Line #329: action='QJ_listaHIV.php' method='post'>
Line #330: ";
Line #331:
Line #332://$e.="<option value='QJ_katraport.php'>Raport lap</option>";
Line #333:
Line #334:
Line #335:
Line #336: onchange=this.form.submit(); return true name='Lista_kod'>";
Line #337:
Line #338:
Line #339:$e.="<option value='QJ_raportNEW.php'>Raport lap</option>";
Line #340:
Line #341:
Line #342:
Line #343:
Line #344:$e.="<option value='QJ_not.php'>Megmaradt helyek</option>";
Line #345:
Line #346:
Line #347:$e.="</SELECT>";
Line #348:*/
Line #349:
Line #350:
Line #351:
Line #352:
Line #353:
Line #354:
Line #355:
Line #356:
Line #357:
Line #358:
Line #359://$L_PHP="QJ_musorKORR.php";
Line #360://include("QJ_listafej.php");
Line #361:
Line #362:echo "<table border=1>
Line #363:<tr bgcolor=silver>
Line #364:<td align=right >&nbsp;</td>
Line #365:<td align=right ><b>Lista</b></td>
Line #366:
Line #367:
Line #368:
Line #369:<td align=right ><b>INFO</b></td>
Line #370:<td align=right bgcolor=red ><b><font color=white>WEB</font></b></td>
Line #371:</tr>";
Line #372:
Line #373:$i=0;
Line #374:while ( $musor = mysql_fetch_array( $eredmeny ) )
Line #375:{
Line #376:++$i;
Line #377:
Line #378:$helyszin_kod=$musor[hely_kod];
Line #379:$datum_kod=$musor[datum_kod];
Line #380:$cim_kod=$musor[cim_kod];
Line #381:$cim_url=$musor[cim_url];
Line #382:$kep_url=$musor[kep_url];
Line #383:$wjid=$musor[wid];
Line #384:
Line #385:if ($_SESSION[login]=="BI(c)") {
Line #386: $ie = '<td><a target=adatframe href="QJ_musorEDIT.php?&wjid='.$wjid.'"><img src="../_Screen/edit.png" border=0></a></td>';
Line #387: $datum=$musor[datum]."<br><font color=red>".$musor[datum_fej]."</font>";
Line #388:} else {
Line #389: $ie='<td>'.$i.'</td>';
Line #390: $datum=$musor[datum];
Line #391:}
Line #392:
Line #393: $ie = '<td><a target=adatframe href="QJ_musorPUBLIC.php?&wjid='.$wjid.'"><img src="../_Screen/edit.png" border=0></a></td>';
Line #394: $datum=$musor[datum_fej];
Line #395:
Line #396:
Line #397:
Line #398:
Line #399:
Line #400:
Line #401:if ($musor[archiv]<>"*")
Line #402:
Line #403:else
Line #404:
Line #405://<td align=right >".$ee.$wjid."]>".$e."</td>
Line #406:
Line #407:if ($musor[archiv]<>"*")
Line #408:
Line #409:else
Line #410:$rejtett="<br> REJTETT";
Line #411:
Line #412:
Line #413:
Line #414:
Line #415:
Line #416:$cimkieg="";
Line #417:if ($musor[cimkieg1]<>"") $cimkieg.="<br>".$musor[cimkieg1];
Line #418:if ($musor[cimkieg2]<>"") $cimkieg.="<br>".$musor[cimkieg2];
Line #419:if ($musor[cimkieg3]<>"") $cimkieg.="<br>".$musor[cimkieg3];
Line #420:
Line #421:if ($musor[web]<>"") $szin="red"; else $szin="";
Line #422:
Line #423:if ($musor[berlet_Azonosito]<>"" and $musor[berlet_Azonosito]<>$musor[datum_kod]) {
Line #424:
Line #425:$bazon=$musor[berlet_Azonosito];
Line #426:$bsql = "SELECT * FROM qj_musor WHERE datum_kod='$bazon'";
Line #427:
Line #428:$bsor = mysql_fetch_array( $btabla );
Line #429:
Line #430:if (isset($_POST[Szinkron]))
Line #431:
Line #432:
Line #433:
Line #434:
Line #435:else
Line #436:
Line #437:
Line #438:
Line #439:
Line #440:
Line #441:$berletes="<br><table><td bgcolor=Aqua>$verify</td></table>";
Line #442:} else {$berletes="";}
Line #443:
Line #444:echo"<tr>$ie
Line #445:<td align=right >$e <br><font color=blue>$datum </font> $xls
Line #446:<input type='hidden' value='$datum_kod' name='Lid'>
Line #447:</td>
Line #448:<td align=right >$musor[cim]$cimkieg<br>$musor[datum]$berletes</td>
Line #449:<td align=right >$musor[helyszin]<font color=red size=+1>$erkezesi</font></td>
Line #450:<td align=right >$musor[datum_kod]<font color=red size=+1>$rejtett</font></td>
Line #451:<td align=right >$musor[Adoszam]<br>$musor[Szjszam]
Line #452:<br>$musor[AFA_jel]</td>
Line #453:<td align=right bgcolor=$szin ><font color=white size=+3>$musor[web]</font></td>
Line #454:</tr></form>";
Line #455:}
Line #456:
Line #457:echo "</table></form>";
Line #458:
Line #459:?>