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