QQ_musorMAINTENANCEview.inc

---

Line #0:<?php
Line #1:
Line #2:
Line #3://unset($_SESSION[SQL_inet]);
Line #4:if (!isset($_SESSION[SQL_inet])) {
Line #5:
Line #6:++$_SESSION[QJ_hiba];
Line #7:
Line #8:echo "<script>
Line #9:
Line #10: window.open('QJ_musorLIST.php','sframe');
Line #11: </script>";
Line #12:}
Line #13:$_SESSION[QJ_hiba]=0;
Line #14:
Line #15://include("BI_musorFILTER.php");
Line #16:
Line #17:if (!isset($_SESSION[SQL_inet])) {
Line #18:
Line #19:++$_SESSION[QJ_hiba];
Line #20:/*
Line #21:echo "<script>
Line #22:
Line #23: window.open('QJ_musorLIST.php','sframe');
Line #24: </script>";
Line #25:*/
Line #26:}
Line #27:$_SESSION[QJ_hiba]=0;
Line #28:
Line #29:
Line #30:
Line #31:if (isset($_GET[rogz])) {
Line #32:
Line #33:$wjid=$_GET[wjid];
Line #34:
Line #35:if ($_GET[rogz]=="Y")
Line #36:$SQLarc = "UPDATE `qj_musor` SET
Line #37: `erkezesi`=''
Line #38: where wid=$wjid LIMIT 1";
Line #39:
Line #40:else
Line #41:$SQLarc = "UPDATE `qj_musor` SET
Line #42: `erkezesi`='Y'
Line #43: where wid=$wjid LIMIT 1";
Line #44:
Line #45://echo($SQLarc."<hr>");
Line #46:mysql_query($SQLarc) or die($SQLarc." SQL Hiba");
Line #47:
Line #48:echo "<script>
Line #49: window.open('QJ_exit.php', 'adatframe');
Line #50: window.open('QJ_musSEL.php', 'alfej');
Line #51: </script>";
Line #52:
Line #53:
Line #54:}
Line #55:
Line #56:
Line #57:
Line #58:
Line #59:IF ($_SESSION[admin]<>"ADMIN") $archiv=" archiv <>'*' "; else $archiv=" future <>'*'";
Line #60:
Line #61:$archiv=" future <>'*'";
Line #62:$login=$_SESSION[login];
Line #63:if (isset($_SESSION[CALL_mezo])) $mezo=$_SESSION[CALL_mezo]; else $mezo="datum_fej";
Line #64:if (isset($_SESSION[CALL_ord])) $ord=$_SESSION[CALL_ord]; else $ord="";
Line #65:IF (isset($_POST[sqlord])) { $ord = " DESC"; $ord="wid";}
Line #66:else $ord="";
Line #67:
Line #68:$latni="";
Line #69:if ($_POST[latni]==1) $latni=" and archiv<>'*' ";
Line #70:if ($_POST[latni]==2) $latni=" and archiv='*' ";
Line #71:
Line #72:
Line #73:$JeBe="";
Line #74:if ($_POST[JeBe]==1) $JeBe=" and JeBe='Jegy' ";
Line #75:
Line #76:
Line #77:
Line #78:
Line #79:$WEB="";
Line #80:if ($_POST[WEB]==1) $WEB=" and web<>'web' ";
Line #81:if ($_POST[WEB]==2) $WEB=" and web='web' ";
Line #82:
Line #83:$OFF="";
Line #84:if ($_POST[elmaradt]==1) $OFF=" and future='OFF' ";
Line #85:if ($_POST[elmaradt]==2) $OFF=" and future<>'OFF' ";
Line #86:
Line #87:
Line #88:$Tipus="";
Line #89:if ($_POST[FormaJel]<>"*") $Tipus=" and FormaJel='$_POST[FormaJel]' ";
Line #90:
Line #91:
Line #92:if (isset($_POST[Desc])) $desc= " DESC"; else $desc= "";
Line #93:
Line #94:IF (isset($_POST[Desc])) { $desc = " DESC"; $mezo="wid";}
Line #95:else { $desc = " "; $mezo=" datum_fej "; }
Line #96:
Line #97:
Line #98:
Line #99:if (isset($_POST[cimKod])) {
Line #100:$keres = "SELECT * FROM qj_musor ORDER BY cim ";
Line #101:} ELSE {
Line #102:$keres = "SELECT * FROM qj_musor where $wer future <>'*' $latni $JeBe $WEB $OFF $Tipus ORDER BY datum_fej $desc ,datum ";
Line #103:$keres = "SELECT * FROM qj_musor where $wer future <>'*' $latni $JeBe $WEB $OFF $Tipus ORDER BY $mezo $desc ";
Line #104:$keres = "SELECT * FROM qj_musor where $wer future <>'*' $latni $WEB $OFF $Tipus ORDER BY $mezo $desc ";
Line #105:}
Line #106:
Line #107:if (isset($_POST[widdir]) and $_POST[widdir]<>'' ) {
Line #108: $keres = "SELECT * FROM qj_musor where wid='$_POST[widdir]'";
Line #109:}
Line #110:if (isset($_SESSION['Dump'])) echo($keres."<hr>");
Line #111:
Line #112:
Line #113:
Line #114:$nur=mysql_num_rows($eredmeny);
Line #115:
Line #116:
Line #117:$e="<FORM name=musel target=adatframe
Line #118: action='QJ_listaHIV.php' method='post'>
Line #119: ";
Line #120:
Line #121:
Line #122:
Line #123: onchange=this.form.submit(); return true name='Lista_kod'>";
Line #124:
Line #125:
Line #126:$e.="<option value='QJ_katraport.php'>Raport lap</option>";
Line #127:$e.="<option value='QJ_raportNEW.php'>NEW Raport</option>";
Line #128:$e.="<option value='QJ_raportKONTROLL.php'>Kontroll Raport</option>";
Line #129:$e.="<option value='QJ_raportKONTROLLnapi.php'>Kontroll NAPI Raport</option>";
Line #130:$e.="<option value='QJ_raportKONTROLLista.php'>Kontroll Lista</option>";
Line #131:$e.="<option value='QJ_raportNOSTORNOLista.php'>NOSTORNO Kontroll Lista</option>";
Line #132:
Line #133:
Line #134:
Line #135:
Line #136:$e.="<option value='QJ_not.php'>Megmaradt helyek</option>";
Line #137:
Line #138:
Line #139:
Line #140:$e.="</SELECT>";
Line #141:
Line #142:
Line #143:
Line #144:
Line #145:
Line #146:
Line #147:
Line #148:
Line #149://$L_PHP="QJ_musorKORR.php";
Line #150://include("QJ_listafej.php");
Line #151:
Line #152:echo "<table border=1 width=100%>
Line #153:<tr bgcolor=silver>
Line #154:<td align=right >&nbsp;</td>
Line #155:<td align=right ><b>Lista</b></td>
Line #156:
Line #157:
Line #158:
Line #159:<td align=right ><b>INFO</b></td>
Line #160:<td align=right bgcolor=red ><b><font color=white>WEB</font></b></td>
Line #161:</tr>";
Line #162:
Line #163:$i=0;
Line #164:$cimekeres="?";
Line #165:$cimeUPDkod="";
Line #166:while ( $musor = mysql_fetch_array( $eredmeny ) )
Line #167:{
Line #168:++$i;
Line #169:
Line #170:$helyszin_kod=$musor[hely_kod];
Line #171:$datum_kod=$musor[datum_kod];
Line #172:$cim_kod=$musor[cim_kod];
Line #173:$cim_url=$musor[cim_url];
Line #174:$kep_url=$musor[kep_url];
Line #175:$wjid=$musor[wid];
Line #176:
Line #177:
Line #178:if (isset($_POST[widdir]) and $_POST[widdir]<>'' ) {
Line #179: $_SESSION[sEL_cim]=$musor[cim];
Line #180: $_SESSION[sEL_helyszin]=$musor[helyszin];
Line #181: $_SESSION[sEL_Rhonap]=$musor[datum_evho];
Line #182: $_SESSION[sEL_FormaJel]=$musor[FormaJel];
Line #183:}
Line #184:
Line #185:if (isset($_POST[cimKod])) {
Line #186: if ($cimekeres<>$musor[cim]) {
Line #187: $cimeUPDkod=substr($datum_kod,0,4)."E".substr($datum_kod,-5);
Line #188: $MsqlUPD = "UPDATE qj_ear SET cim_kod='$cimeUPDkod' where datum_kod='$datum_kod'";
Line #189: if (isset($_SESSION['Dump'])) echo($MsqlUPD."~~~~~~~$musor[cim]~~~~~~~<hr>");
Line #190:
Line #191: }
Line #192: $MsqlUPD = "UPDATE qj_musor SET cim_kod='$cimeUPDkod' where datum_kod='$datum_kod'";
Line #193: if (isset($_SESSION['Dump'])) echo($MsqlUPD."~~~~~~~$musor[cim]~~~~~~~<hr>");
Line #194:
Line #195:
Line #196:
Line #197:}
Line #198:$cimekeres=$musor[cim];
Line #199:
Line #200://////////////////////////////////////
Line #201:include("../_inc_QJ/QQ_musorREL.inc");
Line #202://////////////////////////////////////
Line #203:
Line #204:$disQ = "SELECT * FROM qj_ear where datum_kod='$datum_kod' order by szoveg" ;
Line #205:
Line #206://echo($disQ."<hr>");
Line #207:
Line #208:$sel3="";
Line #209:$br="";
Line #210:
Line #211:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #212:
Line #213:/*$sel3.=$br.$disC[szoveg];
Line #214:if ($disC[qj_ear1]>0) $sel3.=" 1.Kat:<b>".$disC[qj_ear1]."<b>";
Line #215:if ($disC[qj_ear2]>0) $sel3.=" 2.Kat:<b>".$disC[qj_ear2]."<b>";
Line #216:if ($disC[qj_ear3]>0) $sel3.=" 3.Kat:<b>".$disC[qj_ear3]."<b>";
Line #217:if ($disC[qj_ear4]>0) $sel3.=" 4.Kat:<b>".$disC[qj_ear4]."<b>";
Line #218:$br="<br>";*/
Line #219:
Line #220:
Line #221:if ($_SESSION[login]=="BI(c)")
Line #222:$sel3.="<tr bgcolor=PaleGoldenRod>".
Line #223:"<td align=right >
Line #224:<a target=adatframe href=BI_sqlRECopy.php?&wjid=$disC[wid]&tabla=qj_ear>
Line #225:jav</a></td><td align=right >&nbsp;<b>".$disC[szoveg]."</b></td><td colspan=10><table border=1>";
Line #226:else
Line #227:$sel3.="<tr bgcolor=PaleGoldenRod>".
Line #228:"<td align=right >&nbsp;</td><td align=right >&nbsp;<b>".$disC[szoveg]."</b></td><td colspan=10><table border=1>";
Line #229:
Line #230:for ($k=1;$k<11;++$k){
Line #231: $ci=substr($k,-1);
Line #232: $ari="qj_ear".$ci;
Line #233: if ($disC[$ari]<>0) {$sel3.="<td align=right width=80 >$ci.Kat:<b>$disC[$ari]</b></td>";}
Line #234:}
Line #235:
Line #236:$sel3.="</table></tr>";
Line #237:
Line #238://if (isset($_SESSION['Dump'])) echo(htmlspecialchars($sel3)." <hr>");
Line #239:
Line #240:}
Line #241:
Line #242:
Line #243:
Line #244:if ($_SESSION[login]=="BI(c)") {
Line #245: $ie = '<td><a target=adatframe href="QJ_musorEDIT.php?&wjid='.$wjid.'"><img src=edit.png border=0></a></td>';
Line #246: $datum=$musor[datum]."<br><font color=red>".$musor[datum_fej]."</font>";
Line #247:} else {
Line #248: $ie='<td>'.$i.'</td>';
Line #249: $datum=$musor[datum];
Line #250:}
Line #251:
Line #252: $ie = '<a target=adatframe href="QJ_musorPUBLIC.php?&wjid='.$wjid.'">
Line #253: <img width=20 height=20 src="../_Screen/edit.png" border=0></a>';
Line #254:
Line #255: $datum=$musor[datum_fej];
Line #256:
Line #257:
Line #258:
Line #259:
Line #260:if ($musor[archiv]<>"*")
Line #261:
Line #262:else
Line #263:
Line #264://<td align=right >".$ee.$wjid."]>".$e."</td>
Line #265:
Line #266:
Line #267:
Line #268:
Line #269:if ($musor[archiv]<>"*")
Line #270:$rejtett="";
Line #271:else
Line #272:$rejtett="<br><font color=blue>REJTETT</font>";
Line #273://<td align=right >".$ee.$wjid."]>".$e."</td>
Line #274:
Line #275:IF ($_SESSION[login]=="BI(c)")
Line #276:$ref4="<a target=adatframe href=QJ_helyszinOSZ.php?&hely_kod=$helyszin_kod&datum_kod=$datum_kod target=adatframe>
Line #277:$musor[helyszin]</a>"; else $ref4=$musor[helyszin];
Line #278:
Line #279:
Line #280:
Line #281:if ($musor[aroszto]>0) $refD="<br><font color=red>".(100/$musor[aroszto])." %</font>"; else $refD="";
Line #282:if ($_SESSION['login']=="BI(c)")
Line #283:$refD.="<a target=adatframe href=BI_sqlRECopy.php?&wjid=2&tabla=qj_ear&musor_kod=$datum_kod>
Line #284:
Line #285:
Line #286:
Line #287:if ($_SESSION['login']=="BI(c)")
Line #288:
Line #289:
Line #290:<a target=adatframe href=QJ_earCOPY.php?&wnew=$datum_kod,&torol=Y>
Line #291:
Line #292:";
Line #293:
Line #294:$cimkieg="";
Line #295:if ($musor[cimkieg1]<>"") $cimkieg.="<br>".$musor[cimkieg1];
Line #296:if ($musor[cimkieg2]<>"") $cimkieg.="<br>".$musor[cimkieg2];
Line #297:if ($musor[cimkieg3]<>"") $cimkieg.="<br>".$musor[cimkieg3];
Line #298:
Line #299:if ($musor[web]<>"") $szin="red"; else $szin="";
Line #300://if ($musor[szervezo]<>"") $szervezo="<br><font color=red><b>$musor[szervezo]<b></font>"; else $szervezo="";
Line #301:if (isset($musor[szervezo])) $szervezo="<br><font color=red><b>$musor[szervezo]<b></font>"; else $szervezo="";
Line #302:
Line #303:
Line #304:// wid usr_kod szoveg archiv future erkezesi lokacio JeBe FormaJel
Line #305:// web Adoszam Szjszam AFA_jel AFA logo_url sum_keszlet akt_keszlet
Line #306:// last_index start_datum end_datum napjan_arnev kedvezmeny_arnev emelt_arnev
Line #307:// napjan_index kedvezmeny_index emelt_index datum datum_kod berlet_Azonosito
Line #308:// berlet_nev berlet_kod datum_url datum_fej datum_evho
Line #309:// cim cimkieg1 cimkieg2 cimkieg3 cim_kod cim_url helyszin
Line #310:// rovid_helyszin hely_kod arnev arkod
Line #311:// alapar1 alapar2 alapar3 alapar4 alapar5 alapar6 alapar7 alapar8 alapar9 alapar0
Line #312:// hely_url kep_url kep_with kep_height logtime
Line #313:
Line #314:$Minfo="";
Line #315:$br="";
Line #316:if ($musor[cim]<>"") {$Minfo.="$br".$musor[cim]; $br="<br>"; }
Line #317:if ($musor[cimkieg1]<>"") {$Minfo.="$br".$musor[cimkieg1]; $br="<br>"; }
Line #318:if ($musor[cimkieg2]<>"") {$Minfo.="$br".$musor[cimkieg2]; $br="<br>"; }
Line #319:if ($musor[cimkieg3]<>"") {$Minfo.="$br".$musor[cimkieg3]; $br="<br>"; }
Line #320:
Line #321:if ($musor[datum]<>"") {$Minfo.="$br".$musor[datum]; $br="<br>"; }
Line #322:if ($musor[datum_fej]<>"") {$Minfo.="$br<font color=red><b>&nbsp;".$musor[datum_fej]."</b></font>"; $br="<br>"; }
Line #323:
Line #324:
Line #325:$info="";
Line #326:$br="";
Line #327:
Line #328:if ($musor[Szjszam]<>"") {$info.="$br SZJ:".$musor[Szjszam]; $br="<br>"; }
Line #329:if ($musor[AFA_jel]<>"") {$info.="$br SZJ:".$musor[AFA_jel]; $br="<br>"; }
Line #330:if ($musor[FormaJel]<>"") {$info.="$br".$musor[FormaJel]; $br="&nbsp;"; }
Line #331:if ($musor[JeBe]<>"") {$info.="$br".$musor[JeBe]; $br="&nbsp;"; }
Line #332:
Line #333:$info2="";
Line #334:$br="<br>";
Line #335:
Line #336:if ($musor[berlet_nev]<>"") {$info2.="$br&nbsp;<i>".$musor[berlet_nev]."</i>"; $br=""; }
Line #337:if ($musor[berlet_kod]<>"") {$info2.="$br&nbsp;<font color=blue>Forgat:<b>".$musor[berlet_kod]."</b></font>"; $br=""; }
Line #338://if ($musor[cim_kod]<>"") {$info2.="$br&nbsp;<font color=blue>csoport:".$musor[cim_kod]."</font>"; $br=""; }
Line #339:
Line #340:
Line #341:
Line #342:$Cinfo="";
Line #343:$br="<br>";
Line #344:if ($musor[cim_kod]<>"") {$Cinfo.="$br<font color=blue><b>".$musor[cim_kod]."</b></font>"; $br="<br>"; }
Line #345:
Line #346:
Line #347:echo"<tr><td ALIGN=CENTER>$ie</td>
Line #348:<td align=right >$e $szervezo <br> $relFULLbi
Line #349:<input type='hidden' value='$datum_kod' name='Lid'>
Line #350:</td>
Line #351:<td align=right >$Minfo </td>
Line #352:<td align=right >$ref4 <br><b>$musor[hely_kod]</b> $erkezesi</td>
Line #353:<td align=right >$musor[datum_kod] $Cinfo $info2</td>
Line #354:<td align=right >$info $rejtett</td>
Line #355:<td align=right bgcolor=$szin ><font color=white size=+3>$musor[web]</font></td>
Line #356:</tr>";
Line #357:
Line #358:echo ($sel3);
Line #359:
Line #360:$info="";
Line #361:for ($k=1;$k<11;++$k){
Line #362: $ci=substr($k,-1);
Line #363: $ari="alapar".$ci;
Line #364: if ($musor[$ari]<>0) {$info.="<td align=right width=80 >$ci.Kat:<b>$musor[$ari]</b></td>";}
Line #365:}
Line #366:
Line #367:echo"<tr bgcolor=yellow>
Line #368:<td align=right >$refD</td>
Line #369:<td align=right >$refFULLmusor&nbsp; $xls</td>
Line #370:<td colspan=10><table border=1>
Line #371:$info
Line #372:</td></table></tr></form>";
Line #373:}
Line #374:
Line #375:echo "</table></form>";
Line #376:
Line #377:?>