QQ_helyrajz.inc
Line #0:<?
Line #1:$_SESSION[QJ_nyomtatEXIT]="QJ_helyrajz.php";
Line #2:
Line #3:if ($_SESSION[CALL_KOD]=="*") {
Line #4:unset($_SESSION[CALL_KOD]);
Line #5:unset($_SESSION['protokoll']);
Line #6:echo "<script language = javascript>
Line #7: window.open('exit.php','adatframe');
Line #8: </script>";
Line #9:}
Line #10:
Line #11:$ido=time();
Line #12:include("QJ_starTime.php");
Line #13:
Line #14:IF (isset($_GET["QIN"])) $QIN=$_GET["QIN"].". ablak"; ELSE $QIN="*Qjegy_home*";
Line #15:
Line #16:unset($_SESSION[vk]);
Line #17:
Line #18:
Line #19:IF (isset($_GET["close"])) {
Line #20:?>
Line #21:<script language="javascript" type="text/javascript">
Line #22:window.close();
Line #23:</script>
Line #24:<?
Line #25:exit;
Line #26:} else {
Line #27:}
Line #28:
Line #29:?>
Line #30:
Line #31:<html>
Line #32:<head>
Line #33:<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2">
Line #34:</head>
Line #35:<script type="text/javascript">
Line #36:var linestr = "";
Line #37:var lineind = 0;
Line #38:var jelmod = false;
Line #39:var dblmod = false;
Line #40:var rowind = 0;
Line #41:var linestr = "";
Line #42:var getcolor = "";
Line #43:var getmod = false;
Line #44:
Line #45:function dispHandle(obj)
Line #46:{
Line #47:if (obj.style.display == "none")
Line #48: obj.style.display = "";
Line #49: else
Line #50: obj.style.display = "none";
Line #51:}
Line #52:
Line #53:function STable(col, row, tableData) {
Line #54:
Line #55:if (jelmod == true ){
Line #56: var tds = rsTable.getElementsByTagName('td');
Line #57: as=tds[col].innerText;
Line #58: an=as.length
Line #59: aktsor=as.substr(an-3,3);
Line #60:if (aktsor==rowind) {
Line #61:
Line #62: if (tds[col].style.backgroundColor == tableData)
Line #63: tds[col].style.backgroundColor = "green";
Line #64: else
Line #65: {
Line #66:
Line #67: if (tds[col].style.backgroundColor == "green" )
Line #68: tds[col].style.backgroundColor = tableData;
Line #69:
Line #70: if (tds[col].style.backgroundColor == "red") {
Line #71: dblmod = false;
Line #72: jelmod = false;
Line #73: rowind = 0;
Line #74:
Line #75:
Line #76: }
Line #77:
Line #78: }
Line #79:
Line #80:}
Line #81:}
Line #82:if (dblmod==true) {
Line #83: jelmod = true;
Line #84:}
Line #85:}
Line #86:function OTable(col, row, tableData) {
Line #87:rowind=row;
Line #88:var tds = rsTable.getElementsByTagName('td');
Line #89: if (dblmod == false) {
Line #90:
Line #91: tds[10].style.backgroundColor = "white";
Line #92:
Line #93: if (tds[col].style.backgroundColor == tableData ) {
Line #94: tds[col].style.backgroundColor = "green";
Line #95:
Line #96: }
Line #97: else {
Line #98: if (tds[col].style.backgroundColor == "red") {
Line #99:
Line #100:element = document.getElementById('biref');
Line #101:
Line #102:
Line #103:document.location("QJ_kijelol.php");
Line #104:
Line #105: }
Line #106: aktszin=tds[col].style.backgroundColor;
Line #107:// if (tds[col].style.backgroundColor == "green" ) { or aktszin == "Purple"
Line #108: if (aktszin == "green" ) {
Line #109: tds[col].style.backgroundColor = tableData;
Line #110:
Line #111: }
Line #112: if (aktszin == "purple" ) {
Line #113: tds[col].style.backgroundColor = tableData;
Line #114:
Line #115: }
Line #116:
Line #117: if (aktszin == "fuchsia" ) {
Line #118: tds[col].style.backgroundColor = tableData;
Line #119:
Line #120: }
Line #121:
Line #122:
Line #123: }
Line #124:
Line #125: Tarea(tds[col].innerText);
Line #126: }
Line #127:
Line #128:}
Line #129:function Setbgcolor(col, row, tableData) {
Line #130: var tds = rsTable.getElementsByTagName('td');
Line #131: tds[col].style.backgroundColor = tableData;
Line #132:}
Line #133:function Getbgcolor(col, row, tableData) {
Line #134: var tds = rsTable.getElementsByTagName('td');
Line #135: getcolor =tds[col].style.backgroundColor;
Line #136: getmod = true;
Line #137:}
Line #138:
Line #139:function DTable(col, row, tableData) {
Line #140:var tds = rsTable.getElementsByTagName('td');
Line #141:
Line #142:if (jelmod == true){
Line #143: rowind = 0;
Line #144: dblmod = false;
Line #145: jelmod = false;
Line #146: tds[col].style.backgroundColor = "green";
Line #147: tds[10].innerText="folyamatos - KI";
Line #148: tds[10].style.backgroundColor = "white";
Line #149:
Line #150:} else {
Line #151: rowind = row;
Line #152: dblmod = true;
Line #153: tds[col].style.backgroundColor = tableData;
Line #154: tds[10].innerText="folyamatos - BE";
Line #155: tds[10].style.backgroundColor = "silver";
Line #156:}
Line #157:
Line #158:}
Line #159:
Line #160:function Tarea(tData) {
Line #161:
Line #162:dayTwo = new Date();
Line #163:hrNow = dayTwo.getHours();
Line #164:mnNow = dayTwo.getMinutes();
Line #165:scNow = dayTwo.getSeconds();
Line #166:
Line #167:lineind++;
Line #168:lineinfo = tData ;
Line #169:linestr = lineinfo + " \r\n" + linestr ;
Line #170:self.document.msgform.msgarea.value = linestr;
Line #171:
Line #172:}
Line #173:
Line #174:</script>
Line #175:
Line #176:<style type="text/css">
Line #177:
Line #178:a:link
Line #179: {
Line #180: font-size: 12px;
Line #181: font-weight: normal;
Line #182: text-decoration:none;
Line #183: }
Line #184:a:visited
Line #185: {
Line #186: font-size: 12px;
Line #187: font-weight: normal;
Line #188: text-decoration:none;
Line #189: }
Line #190:
Line #191:a {position: relative;}
Line #192:
Line #193:
Line #194:a span {
Line #195: display: none;
Line #196: }
Line #197:
Line #198:a:hover {
Line #199: background-color: #dbe4f2;
Line #200: text-decoration:none;
Line #201: display: block;
Line #202: }
Line #203:
Line #204:/* The above hover change defeats the
Line #205: background: #fdd;
Line #206: IE/Win display changing bug */
Line #207:
Line #208:
Line #209:a:hover span {
Line #210: position: absolute;
Line #211: top: 30px;
Line #212: left: 0px;
Line #213: width: 200px;
Line #214: display: block;
Line #215: background: white;
Line #216: color: black;
Line #217: border: 1px solid red;
Line #218: text-decoration:none;
Line #219:
Line #220: }
Line #221:
Line #222:</style>
Line #223:
Line #224:
Line #225:<body>
Line #226:
Line #227:
Line #228:<?
Line #229:
Line #230:
Line #231:
Line #232:If (isset($_POST[bwin])) {
Line #233:$bwin=$_POST[bwin];
Line #234:$_SESSION['CALL_KOD'.$bwin]=$_SESSION[CALL_KOD];
Line #235:include("QJ_gvarlist.php");
Line #236:BI_alert("BWIN");
Line #237:}
Line #238:if (isset($_GET['musor_kod'])) {
Line #239:$_SESSION[CALL_KOD]=$_GET['musor_kod'];
Line #240:$wer="datum_kod='".$_GET['musor_kod'];
Line #241:} else $wer="wid='1";
Line #242:
Line #243:
Line #244:$keres = "SELECT * FROM qj_musor where ".$wer. "'";
Line #245:$eredmeny = mysql_query($keres) or die($keres." Hiba");
Line #246:
Line #247:$nur=mysql_num_rows($eredmeny);
Line #248:
Line #249:
Line #250:
Line #251:if (isset($_POST['musor_kod'])) {
Line #252: $_SESSION[CALL_KOD]=$_POST['musor_kod'];
Line #253: $wer="datum_kod='".$_POST['musor_kod'];
Line #254:}
Line #255:
Line #256:$keres = "SELECT * FROM qj_musor where ".$wer. "'";
Line #257:
Line #258:
Line #259:$nur=mysql_num_rows($eredmeny);
Line #260:
Line #261:$musor=mysql_fetch_array($eredmeny);
Line #262:
Line #263:
Line #264:$Skeres = "SELECT * FROM qj_szinpad where hely_kod='".$musor[hely_kod]. "'";
Line #265:
Line #266:$Snur=mysql_num_rows($Seredmeny);
Line #267:$szinpad=mysql_fetch_array($Seredmeny);
Line #268:
Line #269:if ($szinpad[hely_url]=="") $align=" width=660 align=center "; else $align=$szinpad[hely_url];
Line #270:
Line #271://?//BI_alert( $align . $Skeres);
Line #272:
Line #273:
Line #274://////////////////////////
Line #275:
Line #276:if ($_SESSION['login']<>'BI(c)' and substr($musor[datum_fej],0,3)=='Bel') {
Line #277://///////alert('".$_SESSION[CALL_KOD].$_SESSION['login'].$musor[datum_fej]."?');
Line #278:
Line #279:echo "<script>
Line #280: window.open('QJ_belepo.php?&musor_kod=".$_SESSION[CALL_KOD]."', 'adatframe');
Line #281: </script>";
Line #282:
Line #283:exit;
Line #284:}
Line #285://////////////////////////
Line #286:
Line #287:
Line #288: $_SESSION[JA_JeBe]=$musor[JeBe];
Line #289: $_SESSION[JA_datum_kod]=$musor[datum_kod];
Line #290: $_SESSION[JA_berlet_kod]=$musor[berlet_kod];
Line #291:
Line #292:$musor_erkezesi=$musor[erkezesi];
Line #293:
Line #294:
Line #295:$fastQ="";
Line #296:
Line #297:
Line #298:$cimkieg="";
Line #299:
Line #300:$jegyfej="<font size=-1 color=blue><i>".$musor[datum].
Line #301:"</i> ".$musor[helyszin]."<br>".$musor[cim]."</font>";
Line #302: $_SESSION['ear1']=$musor[alapar1];
Line #303: $_SESSION['ear2']=$musor[alapar2];
Line #304: $_SESSION['ear3']=$musor[alapar3];
Line #305: $_SESSION['ear4']=$musor[alapar4];
Line #306: $_SESSION['ear5']=$musor[alapar5];
Line #307: $_SESSION['ear6']=$musor[alapar6];
Line #308: $_SESSION['ear7']=$musor[alapar7];
Line #309: $_SESSION['ear8']=$musor[alapar8];
Line #310: $_SESSION['ear9']=$musor[alapar9];
Line #311: $_SESSION['ear0']=$musor[alapar0];
Line #312: $_SESSION['JeBe']=$musor[JeBe];
Line #313:
Line #314:
Line #315:
Line #316: if (!isset($_POST['arselect']) and isset($_SESSION[arselect]))
Line #317: $_POST['arselect']=$_SESSION[arselect];
Line #318:
Line #319:
Line #320:// ???? if (isset($_SESSION[arselect]))
Line #321:// ???? $_POST['arselect']=$_SESSION[arselect];
Line #322:
Line #323:
Line #324:
Line #325:$_SESSION[arselect]=1;
Line #326:
Line #327:if (isset($_POST['arselect'])) {
Line #328: $_SESSION[arselect]=$_POST['arselect'];
Line #329: $arselect=$_POST['arselect'];
Line #330:
Line #331:if (isset($_SESSION[selNEWear]))
Line #332:$keres = "SELECT * FROM qj_ear where wid=".$_SESSION[selNEWear]." AND $arselect>0 ";
Line #333:else
Line #334:$keres = "SELECT * FROM qj_ear where qj_arkod=$arselect AND $arselect>0 order by datum_kod,cim_kod,hely_kod";
Line #335:
Line #336://?!! echo($keres."<hr>");
Line #337:
Line #338:
Line #339:
Line #340:
Line #341:while ( $egy_sor = mysql_fetch_array( $eredmeny ) )
Line #342:{
Line #343:if ($egy_sor[datum_kod]==$_SESSION[CALL_KOD] or $egy_sor[datum_kod]=="*") {
Line #344: $_SESSION[ar_forma]=$egy_sor[qj_arnev];
Line #345:
Line #346: $_SESSION[ar_kod]=$egy_sor[qj_arkod];
Line #347: $_SESSION[arselect]=$egy_sor[qj_arkod];
Line #348:
Line #349:// $_SESSION[ar_kod]=$egy_sor[qj_kod];
Line #350:// $_SESSION[arselect]=$egy_sor[qj_kod];
Line #351:
Line #352: $_SESSION['ear1']=$egy_sor[qj_ear1];
Line #353: $_SESSION['ear2']=$egy_sor[qj_ear2];
Line #354: $_SESSION['ear3']=$egy_sor[qj_ear3];
Line #355: $_SESSION['ear4']=$egy_sor[qj_ear4];
Line #356: $_SESSION['ear5']=$egy_sor[qj_ear5];
Line #357: $_SESSION['ear6']=$egy_sor[qj_ear6];
Line #358: $_SESSION['ear7']=$egy_sor[qj_ear7];
Line #359: $_SESSION['ear8']=$egy_sor[qj_ear8];
Line #360: $_SESSION['ear9']=$egy_sor[qj_ear9];
Line #361: $_SESSION['ear0']=$egy_sor[qj_ear0];
Line #362:
Line #363:}}}
Line #364:
Line #365://$cimkieg="";
Line #366:
Line #367:$helyszin_kod=$musor[hely_kod];
Line #368:
Line #369:$bcan=$helyszin_kod;
Line #370:$_SESSION['CALL_name']=trim($musor[helyszin])." ".trim($musor[datum])." ".trim($musor[cim]);
Line #371:$sorok="";
Line #372:
Line #373:$keres = "SELECT * FROM qj_szek WHERE hely_kod='".$helyszin_kod."' ORDER BY szek_kod";
Line #374:
Line #375:
Line #376:$nur=mysql_num_rows($eredmeny);
Line #377:IF ($nur<1) {
Line #378:echo "<script language = javascript>
Line #379:window.open('QJ_not.php','adatframe');
Line #380:
Line #381: </script>";
Line #382:
Line #383:unset($_SESSION[CALL_KOD]);
Line #384:exit;
Line #385:}
Line #386:
Line #387:
Line #388:if ( $musor[cimkieg1]<>"") $cimkieg.="<br><i>".$musor[cimkieg1]."</i>";
Line #389:if ( $musor[cimkieg2]<>"") $cimkieg.="<br><font size=-1 ><b>".$musor[cimkieg2]."</b></font>";
Line #390:
Line #391:
Line #392:echo("<font size=+1><center><i>".$musor[datum]."</i> (<font color=red>".
Line #393: $musor[datum_kod]."</font>)<br>".
Line #394:$musor[helyszin]." ( <font color=red>".$_SESSION[ar_forma]."</font> ) <i>".
Line #395:$erkir."</i> </font> <br>
Line #396:<font size=+2>".$musor[cim].$cimkieg." </center></font>");
Line #397:
Line #398:
Line #399:/*if ($_COOKIE[date]<str_replace($musor[datum_fej],".","-"))
Line #400:{
Line #401: $elad = "UPDATE `qj_musor` SET
Line #402: `archiv`='*'
Line #403: WHERE datum_kod='".$_SESSION[CALL_KOD]."' LIMIT 1";
Line #404:
Line #405:
Line #406:echo "<script language = javascript>
Line #407:
Line #408: </script>";
Line #409:
Line #410:}*/
Line #411:
Line #412:$sorind="*";
Line #413:$szekdb=0;
Line #414:$szekind=0;
Line #415:$abszind=0;
Line #416:?>
Line #417:<form name="form1" method="POST" action="QJ_musSEL.php" target=alfej
Line #418:
Line #419:>
Line #420:<?php
Line #421:if ($_SESSION['admin']=="?ADMIN") {
Line #422:?>
Line #423:
Line #424:
Line #425: <INPUT TYPE='radio' NAME='bwin' value='1'
Line #426: onclick=this.form.submit(); return true name='bwin'
Line #427: >1. ablak
Line #428: <INPUT TYPE='radio' NAME='bwin' value='2'
Line #429: onclick=this.form.submit(); return true name='bwin'
Line #430: >2. ablak
Line #431: <INPUT TYPE='radio' NAME='bwin' value='3'
Line #432: onclick=this.form.submit(); return true name='bwin'
Line #433: >3. ablak
Line #434: <INPUT TYPE='radio' NAME='bwin' value='4'
Line #435: onclick=this.form.submit(); return true name='bwin'
Line #436: >4. ablak
Line #437: <INPUT TYPE='radio' NAME='bwin' value='5'
Line #438: onclick=this.form.submit(); return true name='bwin'
Line #439: >5. ablak
Line #440:
Line #441: <INPUT TYPE='CHECKBOX' NAME='bwinfix' <? if ($_SESSION[bwinfix]==on) echo ("CHECKED"); ?>
Line #442: onclick=this.form.submit(); return true name='bwinfix'
Line #443:
Line #444:
Line #445: <INPUT TYPE='CHECKBOX' NAME='bwinmulti' <? if ($_SESSION[bwinmulti]==on) echo ("CHECKED"); ?>
Line #446: onclick=this.form.submit(); return true name='bwinmulti'
Line #447:
Line #448:
Line #449: <BR>
Line #450:
Line #451:<?
Line #452:
Line #453:}
Line #454:
Line #455:?>
Line #456:</from><form name="hr2form" method="POST" action="QJ_kijelol.php" target=sFrame
Line #457:
Line #458:>
Line #459:<?php
Line #460:
Line #461:echo("<table border=0 align=center id=rsTable>");
Line #462:echo("<tr><td><table border=0 align=left>
Line #463:<tr>
Line #464:
Line #465:
Line #466: echo("<td bgcolor=green>
Line #467:
Line #468: <p><a
Line #469: href='#'
Line #470:
Line #471: >
Line #472: <span><font size=3>Szabad hely
Line #473: </font><font color=white>
Line #474: </font></span></a></p></td>");
Line #475:
Line #476: echo("<td bgcolor=red>
Line #477: <p><a
Line #478: href='#'
Line #479:
Line #480: >
Line #481:
Line #482: </font><font color=white>
Line #483: </font></span></a></p></td>");
Line #484:
Line #485: echo("<td bgcolor=Fuchsia>
Line #486: <p><a
Line #487: href='#'
Line #488:
Line #489: >
Line #490:
Line #491: </font><font color=white> Hidden
Line #492: </font></span></a></p></td>");
Line #493:
Line #494: echo("<td bgcolor=Purple>
Line #495:
Line #496: <p><a
Line #497: href='#'
Line #498:
Line #499: >
Line #500:
Line #501: </font><font color=white>
Line #502: </font></span></a></p></td>");
Line #503:
Line #504: echo("<td bgcolor=Yellow>
Line #505: <p><a
Line #506: href='#'
Line #507: >
Line #508:
Line #509: </font><font color=white>
Line #510: </font></span></a></p></td>");
Line #511:
Line #512: echo("<td bgcolor=white>
Line #513: <p> </p></td>");
Line #514:
Line #515: echo("<td bgcolor=white>
Line #516: <p> </p></td>");
Line #517:
Line #518: echo("<td bgcolor=white >
Line #519: <p> </p></td>");
Line #520:
Line #521: echo("<td bgcolor=white>
Line #522: <p> </p></td>");
Line #523:
Line #524:
Line #525:echo("</td></tr></table></tr>");
Line #526:echo("<tr><td ><hr></td></tr>");
Line #527:
Line #528:////////////***!***///////////
Line #529: $abszind=$abszind+12;
Line #530://///////////////////////////
Line #531:
Line #532: $relind=0;
Line #533:
Line #534:
Line #535:////
Line #536:
Line #537:$datum_kod=$musor[datum_kod];
Line #538:
Line #539:$elad = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."'" ;
Line #540://$elad = "SELECT * FROM qj_jegy WHERE szek_kod='".$szek_kod."'" ;
Line #541:
Line #542:$Kontollnur=mysql_num_rows($jsor);
Line #543:
Line #544:
Line #545:if ($Kontollnur==0) {
Line #546:
Line #547:$keres = "SELECT * FROM qj_szek WHERE hely_kod='".$bcan."' ORDER BY szek_kod" ;
Line #548:
Line #549:
Line #550:$nur=mysql_num_rows($eredmeny);
Line #551:
Line #552:
Line #553:while ( $egy_sor = mysql_fetch_array( $eredmeny )) {
Line #554:
Line #555:$wid = $egy_sor[wid];
Line #556:$usr_kod = $egy_sor[usr_kod];
Line #557:$hely_kod = $egy_sor[hely_kod];
Line #558:$szek_kod = $egy_sor[szek_kod];
Line #559://$szoveg = $egy_sor[szoveg];
Line #560:$future = $egy_sor[future];
Line #561:$logtime = $egy_sor[logtime];
Line #562:$qj_sor_n = $egy_sor[qj_sor_n];
Line #563:$qj_sor_n = str_replace("#", "", $qj_sor_n);
Line #564:
Line #565:$qj_sor_s = $egy_sor[qj_sor_s];
Line #566:$qj_sor_o = $egy_sor[qj_sor_o];
Line #567:$qj_sor_h = $egy_sor[qj_sor_h];
Line #568:$erkezesi = $egy_sor[erkezesi];
Line #569:$archiv = $egy_sor[archiv];
Line #570:$arkat=$egy_sor[qj_katind];
Line #571:
Line #572:$szeksor=substr($szek_kod,0,3);
Line #573:$sorrend=substr($szek_kod,0,4).substr($szek_kod,-2);
Line #574:
Line #575:$sor_kod=substr($egy_sor[szek_kod],0,3);
Line #576:
Line #577:
Line #578:if ($egy_sor[future]>0 and $egy_sor[future]<>"" and $egy_sor[future]<>"*") {
Line #579:
Line #580:} else {
Line #581:$protokoll=""; $statusz=""; $start="";
Line #582:}
Line #583:
Line #584:
Line #585:if ($erkezesi=="Y" ) {
Line #586:
Line #587:} else {
Line #588:$szoveg=$qj_sor_n." ".$qj_sor_s." ".$qj_sor_o." ".$qj_sor_h;
Line #589:}
Line #590:
Line #591:
Line #592:$elad = "INSERT INTO `qj_jegy`
Line #593:( `usr_kod`,`szoveg`, `datum_kod`, `cim_kod`, `hely_kod`,
Line #594:`szek_kod`, `sor_kod`, `arkategoria`,
Line #595:`qj_sor_n`,`qj_sor_s`,`qj_sor_o`,`qj_sor_h`,`erkezesi`,`archiv`, `statusz`, `bizomanyos`,`vevo_kod`
Line #596:) VALUES
Line #597:( '$musor[usr_kod]', '$szoveg', '$musor[datum_kod]', '$musor[cim_kod]', '$bcan',
Line #598:'$egy_sor[szek_kod]', '$sor_kod', $arkat,
Line #599:'$qj_sor_n', '$qj_sor_s', '$qj_sor_o', '$qj_sor_h', '$erkezesi', '$archiv', '$statusz', '$start', '$protokoll'
Line #600:
Line #601:)";
Line #602:
Line #603://echo($elad."<hr>");
Line #604:
Line #605:mysql_query($elad) or die($elad." Hiba a QJ_jegy insertben");
Line #606:
Line #607:}
Line #608:
Line #609:////
Line #610: }
Line #611:////
Line #612:////////////////////////////////////////////////////
Line #613:
Line #614:////////////////////////////////////////////////////
Line #615:
Line #616:
Line #617:if ($musor_erkezesi=="Y") $maxi=" Limit 4000"; else $maxi="";
Line #618:
Line #619:if (isset($_SESSION[bwinfix])) $maxi="";
Line #620:
Line #621:$Lasthely = "SELECT * FROM qj_jegy WHERE datum_kod='".$musor[datum_kod]."' and archiv<>'X' order by hely_kod,szek_kod DESC ".$maxi ;
Line #622:
Line #623:$lastsor = mysql_query($Lasthely) or die($Lasthely." SQL Hiba!");
Line #624:
Line #625:$Lsor = mysql_fetch_array($lastsor);
Line #626:
Line #627:$LastHelyInd=$Lsor[szek_kod];
Line #628:
Line #629://??
Line #630://echo($Lasthely."/".$LastHelyInd."<hr>");
Line #631:
Line #632:$elad = "SELECT * FROM qj_jegy WHERE datum_kod='".$musor[datum_kod]."' and archiv<>'X' order by hely_kod,szek_kod ".$maxi ;
Line #633:
Line #634:$jsor = mysql_query($elad) or die($elad." SQL Hiba!");
Line #635:
Line #636:while ( $jegy_sor = mysql_fetch_array( $jsor )) {
Line #637:
Line #638:$wid = $jegy_sor[wid];
Line #639:$usr_kod = $jegy_sor[usr_kod];
Line #640:$hely_kod = $jegy_sor[hely_kod];
Line #641:$szek_kod = $jegy_sor[szek_kod];
Line #642:$szoveg = $jegy_sor[szoveg];
Line #643:$future = $jegy_sor[future];
Line #644:
Line #645:$archiv = $jegy_sor[archiv];
Line #646:
Line #647:$logtime = $jegy_sor[logtime];
Line #648:$qj_sor_n = $jegy_sor[QJ_sor_n];
Line #649:$qj_sor_n = str_replace("#", "", $qj_sor_n);
Line #650:
Line #651:$qj_sor_s = $jegy_sor[QJ_sor_s];
Line #652:$qj_sor_o = $jegy_sor[QJ_sor_o];
Line #653:$qj_sor_h = $jegy_sor[QJ_sor_h];
Line #654:$erkezesi = $jegy_sor[erkezesi];
Line #655:
Line #656:$vevo_kod = $jegy_sor[vevo_kod];
Line #657://$vind="vk[".$vevo_kod."]";
Line #658:$vind=$vevo_kod;
Line #659:
Line #660:if(!isset($_SESSION[vk][$vind])) {
Line #661:$csql = "SELECT * FROM qj_cimtar WHERE wid='$vevo_kod'";
Line #662:
Line #663:$nur=mysql_num_rows($csor);
Line #664:
Line #665:if ($nur>0) {
Line #666: $cim_sor = mysql_fetch_array($csor);
Line #667: $_SESSION[vk][$vind]=$cim_sor[wid].":".$cim_sor[nev]." ".$cim_sor[telepules]." ".$cim_sor[cim];
Line #668:
Line #669:}
Line #670:}
Line #671:
Line #672:$szeksor=substr($szek_kod,0,3);
Line #673:$sorrend=substr($szek_kod,0,4).substr($szek_kod,-2);
Line #674:
Line #675:$szin[$szekdb]="green";
Line #676:$nevcim[$szekdb]=$_SESSION[vk][$vind];
Line #677:$helyar[$szekdb]=$jegy_sor[ar];
Line #678:
Line #679:$statusz[$szekdb]=$jegy_sor[statusz];
Line #680:$KatI[$szekdb]=$jegy_sor[arkategoria];
Line #681:$Gyujto[$szekdb]=$jegy_sor[bizonylatszam];
Line #682:$Penztaros[$szekdb]=$jegy_sor[bizomanyos];
Line #683:$helykoz[$szekdb]=$jegy_sor[archiv];
Line #684:
Line #685:if (substr($jegy_sor[statusz],0,2)=="In") $szin[$szekdb]="red";
Line #686:if (substr($jegy_sor[statusz],0,2)=="On") $szin[$szekdb]="red";
Line #687://Internet 2010.04.06. 10:02:44
Line #688:
Line #689:if (substr($jegy_sor[statusz],0,1)=="K") $szin[$szekdb]="red";
Line #690:
Line #691:if (substr($jegy_sor[statusz],0,1)=="B") $szin[$szekdb]="red";
Line #692:if (substr($jegy_sor[statusz],0,1)=="U") $szin[$szekdb]="red";
Line #693:if (substr($jegy_sor[statusz],0,1)=="P") $szin[$szekdb]="red";
Line #694:if (substr($jegy_sor[statusz],0,1)=="N") $szin[$szekdb]="red";
Line #695:if (substr($jegy_sor[statusz],0,2)=="El") $szin[$szekdb]="Purple";
Line #696:if (substr($jegy_sor[statusz],0,2)=="St") $szin[$szekdb]="Fuchsia";
Line #697:
Line #698:if ($jegy_sor[Lockol]<>"" and $jegy_sor[kosar_kod]==$_SESSION[login]) $szin[$szekdb]="yellow";
Line #699:
Line #700:$sind[$szekdb]=$jegy_sor[wid];
Line #701:
Line #702:///////////////////////////////////////////
Line #703://if ($sorind<>$szeksor and $sorind<>"*" ) {
Line #704:if ($sorind<>$szeksor or $LastHelyInd==$szek_kod ) {
Line #705: $sorind=$szeksor;
Line #706:////////////////////////////////////////////
Line #707:
Line #708:++$szekind;
Line #709:
Line #710:$III=$KatI[0];
Line #711:
Line #712:/*$bgszin="silver";
Line #713:if ($III==0)$bgszin="gold";
Line #714:if ($III==1)$bgszin="silver";
Line #715:if ($III==2)$bgszin="gold";
Line #716:if ($III==3)$bgszin="silver";
Line #717:if ($III==4)$bgszin="gold";
Line #718:if ($III==5)$bgszin="silver";
Line #719:if ($III==6)$bgszin="gold";
Line #720:if ($III==7)$bgszin="silver";
Line #721:if ($III==8)$bgszin="gold";
Line #722:if ($III==9)$bgszin="silver";
Line #723:*/
Line #724:
Line #725:
Line #726:$bgszin="silver";
Line #727:if ($III==0)$bgszin="MediumAquaMarine";
Line #728:if ($III==1)$bgszin="gold";
Line #729:if ($III==2)$bgszin="Yellow";
Line #730:if ($III==3)$bgszin="Aqua";
Line #731:if ($III==4)$bgszin="Lime";
Line #732:
Line #733:
Line #734:if ($III==5)$bgszin="Pink";
Line #735:if ($III==6)$bgszin="Orange";
Line #736:if ($III==7)$bgszin="Violet";
Line #737:if ($III==8)$bgszin="Azure";
Line #738:if ($III==9)$bgszin="YellowGreen";
Line #739:$bgsorszin=$bgszin;
Line #740:
Line #741:
Line #742:
Line #743:/*Black #000000
Line #744:Navy #000080
Line #745:Teal #008080
Line #746:Gray #808080
Line #747:Maroon #800000
Line #748:Purple #800080
Line #749:Green #008000
Line #750:Olive #808000
Line #751:Blue #0000FF
Line #752:Lime #00FF00
Line #753:Red #FF0000
Line #754:Aqua #00FFFF
Line #755:Yellow #FFFF00
Line #756:Fuchsia #FF00FF
Line #757:White #FFFFFF
Line #758:Silver #C0C0C0
Line #759:*/
Line #760:
Line #761:
Line #762:$szekkep="";
Line #763:if ($musor[hely_kod]=="OF08H001") $szekkep="<img src='nagyszinul_k.gif'>";
Line #764:
Line #765:$szekkep="<img src='nagyszinul_k.gif'>";
Line #766:
Line #767:echo("<tr>");
Line #768:
Line #769:$bgszin="WHITE";
Line #770:echo(" <td $align>
Line #771:<table border=0 bgcolor=".$bgszin." id=rowTable>");
Line #772:
Line #773: ++$abszind;
Line #774:
Line #775: $relind=0;
Line #776:
Line #777: $fastQ="";
Line #778:
Line #779:for ($i=0;$i<$szekdb;$i++) {
Line #780:
Line #781:if ($_SESSION['jpgview']=="Y") $szekkep="<img src='nagyszinul_k.gif'>"; else $szekkep="";
Line #782:
Line #783:$ari='ear'.$KatI[$i];
Line #784:$ar=$_SESSION[$ari];
Line #785:
Line #786:
Line #787:$nevind=strpos($nevcim[$i],":");
Line #788:if ($nevind>0) $nevind=substr($nevcim[$i],0,$nevind);
Line #789:
Line #790:if ($szin[$i]<>"green")
Line #791:{
Line #792: $click="";
Line #793: $ref="";
Line #794:} else {
Line #795: $click='onclick=OTable(".$abszind.",".$sorind.","yellow");';
Line #796: $ref="href='QJ_kijelol.php?abszind=$szekey[$i]&szekinfo=$szekir[$i]'";
Line #797:}
Line #798:
Line #799:if ($szin[$i]<>"red")
Line #800:{
Line #801: $click='onclick=OTable(".$abszind.",".$sorind.","yellow");';
Line #802: $ref="href='QJ_kijelol.php?abszind=$szekey[$i]&kati=$KatI[$i]&szekinfo=$szekir[$i]&datum_kod=$datum_kod&jegyfej=$jegyfej&szin=$szin[$i]&ear=$ar&nevind=$nevind'";
Line #803:} else {
Line #804: $click="";
Line #805: $ref="href='QJ_kijelol.php'";
Line #806: $ar=$helyar[$i];
Line #807:// $ref="href=''";
Line #808:}
Line #809:
Line #810:
Line #811:if ($_SESSION['admin']=="demo") { $ref="href='#' target=adatframe";}
Line #812:
Line #813:
Line #814:$ki=$szekinfo[$i];
Line #815:
Line #816:if ($helykoz[$i]<>"~" and $helykoz[$i]<>"?" ) {
Line #817: echo("<td bgcolor=".$szin[$i].">
Line #818: <p><a id='biref' $ref target=sframe
Line #819: onclick=OTable(".$abszind.",".$sorind.",'yellow');
Line #820: >
Line #821: <span><font size=5>".
Line #822: $szekinfo[$i]."<br></font><i><b>"
Line #823:
Line #824:
Line #825: <font size=5 color=red ><b>".$ar." Ft </b></font><font color=blue>".$nevcim[$i].
Line #826: "</font></span></a></p></td>");
Line #827:
Line #828://color=blue>".$sorind.$szekkep.$nevcim[$i].
Line #829:
Line #830:echo "<script language = javascript>
Line #831: Setbgcolor(".$abszind.",".$i.",'".$szin[$i]."');
Line #832: </script>";
Line #833:
Line #834:} else {
Line #835:
Line #836:if ($helykoz[$i]<>"?") {
Line #837: echo("<td bgcolor=white ><p><a href=#> </a></p></td>");
Line #838:// echo "<script language = javascript>
Line #839:// Setbgcolor(".$abszind.",".$i.",'white');
Line #840:// </script>";
Line #841:
Line #842:} else {
Line #843:
Line #844:if ($Gyujto[$i]<>"VIP") {
Line #845:
Line #846:
Line #847:
Line #848: <p><a href=#> </a></p>
Line #849: <p><a herf=# >
Line #850: <span><font size=5>".
Line #851: $szekinfo[$i]."<br></font><i>
Line #852: </span></a></p></td>");*/
Line #853:
Line #854:} else {
Line #855: echo("<td bgcolor=Gray title='VIP hely'>
Line #856: <p><a herf=# >
Line #857: <span><font size=5>".
Line #858: $szekinfo[$i]."<br></font><i>
Line #859: </span></a></p></td>");
Line #860:}
Line #861:
Line #862:
Line #863: echo "<script language = javascript>
Line #864: Setbgcolor(".$abszind.",".$i.",'Gray');
Line #865: </script>";
Line #866:
Line #867:}
Line #868:
Line #869:}
Line #870:
Line #871: ++$abszind;
Line #872:
Line #873:}
Line #874:
Line #875:
Line #876:echo("</table></td> ");
Line #877:
Line #878:if ($musor_erkezesi=="Y" ) $bgsorszin="";
Line #879:$sorok="<td width=200 align=right bgcolor=$bgsorszin>".$irsornev."</td>"; // Ne irjon ki sor nevet MS14 2014.05.05. 11:59:41
Line #880:
Line #881:$sorok="<td> </td>";
Line #882:
Line #883:echo($sorok);
Line #884:echo("</tr> ");
Line #885:++$abszind;
Line #886:
Line #887:
Line #888:$nevcim[0]=$nevcim[$szekdb];
Line #889:
Line #890:$helyar[0]=$helyar[$szekdb];
Line #891:
Line #892:$Penztaros[0]=$Penztaros[$szekdb];
Line #893:$KatI[0]=$KatI[$szekdb];
Line #894:$statusz[0]=$statusz[$szekdb];
Line #895:$szin[0]=$szin[$szekdb];
Line #896:$Gyujto[0]=$Gyujto[$szekdb];
Line #897:$helykoz[0]=$helykoz[$szekdb];
Line #898:////////////////////////////////////////
Line #899:
Line #900:////////////////////////////////////////
Line #901:$szekdb=0;
Line #902://///
Line #903: }
Line #904:////
Line #905:$sorind=$szeksor;
Line #906:
Line #907:$sornev = $jegy_sor[sornev];
Line #908:$qj_sornev= $jegy_sor[qj_sornev];
Line #909:$qj_Xpoz = $jegy_sor[qj_Xpoz];
Line #910:$qj_Ypoz = $jegy_sor[qj_Ypoz];
Line #911:$qj_sor_n = trim($jegy_sor[QJ_sor_n]);
Line #912:$qj_sor_n = str_replace("#", "", $qj_sor_n);
Line #913:
Line #914:$qj_sor_s = trim($jegy_sor[QJ_sor_s]);
Line #915:$qj_sor_o = trim($jegy_sor[QJ_sor_o]);
Line #916:$qj_sor_h = trim($jegy_sor[QJ_sor_h]);
Line #917: ////////////////////////
Line #918: // CSAK ZSENI VAGYOK !!! 2010.04.02. 10:09:40
Line #919: ////////////////////////
Line #920://if ($musor_erkezesi=="Y" or $erkezesi=="Y" ) {
Line #921:if ($musor_erkezesi=="Y" ) {
Line #922:
Line #923:
Line #924:
Line #925:$irsornev = "";
Line #926:} else {
Line #927:$szekinfo[$szekdb]=$qj_sor_n." ".$qj_sor_s." <br>".$qj_sor_o." ".$qj_sor_h;
Line #928:$szekir[$szekdb]=$qj_sor_n." ".$qj_sor_s." ".$qj_sor_o." ".$qj_sor_h;
Line #929:$irsornev = trim($jegy_sor[QJ_sor_n])." ".trim($jegy_sor[QJ_sor_s]);
Line #930:}
Line #931:
Line #932:
Line #933:if ($erkezesi=="SY" ) {
Line #934:
Line #935:
Line #936:$irsornev = "";
Line #937:}
Line #938://
Line #939:
Line #940:
Line #941:++$szekdb;
Line #942:
Line #943:$szekey[$relind]=$jegy_sor[szek_kod];
Line #944:
Line #945:++$relind;
Line #946:
Line #947:
Line #948:}
Line #949:
Line #950://///////////////////////////
Line #951:
Line #952:////////////////////////////
Line #953:
Line #954:echo("<tr>");
Line #955:echo("<td ><hr></td>");
Line #956:echo("</tr> ");
Line #957:
Line #958:for ($i=1;$i<10;$i++) {
Line #959:
Line #960:echo("<tr>");
Line #961:
Line #962: echo("<td>
Line #963:
Line #964: </td>");
Line #965:
Line #966:echo("</tr> ");
Line #967:
Line #968:}
Line #969:
Line #970:
Line #971:
Line #972:echo("</FORM>");
Line #973:echo("</table>");
Line #974:
Line #975:include("QJ_stop.php");
Line #976:
Line #977://include ("gvarlist.php");
Line #978:
Line #979:?>
Line #980:</body></html>