QQ_musorKORR.inc

---

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