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