Bi-Dir

QJ_gyujto_MK.inc

Line #0:<?php
Line #1:
Line #2://$_SESSION[qontroll]="*";
Line #3:
Line #4:if (!isset($_SESSION[SQL_inet])) {
Line #5:
Line #6:++$_SESSION[QJ_hiba];
Line #7:
Line #8:echo "<script>
Line #9:
Line #10:window.open('QJ_gyujto.php','sframe');
Line #11:</script>";
Line #12:}
Line #13:
Line #14:$_SESSION[QJ_hiba]=0;
Line #15:
Line #16://BISQLcon();
Line #17:
Line #18:$login=$_SESSION[login];
Line #19:$admin=$_SESSION[admin];
Line #20:$_SESSION[CimUp]="QJ_kijelol.php";
Line #21:
Line #22:
Line #23:if ($_POST[Sbizonylat]<>"") {
Line #24:
Line #25:echo "<script>
Line #26:window.open('QJ_analitika.php?&bizonylat=".$_POST[Sbizonylat]."','sframe');
Line #27:</script>";
Line #28:}
Line #29:
Line #30:
Line #31:if(!isset($_GET[lista])) {
Line #32:echo("<a href=QJ_gyujto.php?&gyforg=1 target=sframe>Vissza...</a><br>");
Line #33:
Line #34:
Line #35:
Line #36:if(isset($_GET[clear])) {unset($_SESSION[GyujtOSft]); unset($_SESSION[GyujtOSdb]);}
Line #37:
Line #38:if(isset($_SESSION[GyujtOSft]))
Line #39:echo ("<font color=red size=3>
Line #40:
Line #41:
Line #42:
Line #43:echo "<table border=1>
Line #44:<tr bgcolor=silver>
Line #45:<td align=right ><b></b></td>
Line #46:<td align=right ><b>Db</b></td>
Line #47:<td align=right ><b>Ft</b></td>
Line #48:
Line #49:
Line #50:
Line #51:
Line #52:
Line #53:
Line #54://if ($login=="BI(c)")
Line #55:if ($admin=="ADMIN")
Line #56:
Line #57:
Line #58:
Line #59:
Line #60:$szin="red";
Line #61:
Line #62:if ( isset($_SESSION[qontroll])) {
Line #63:
Line #64:$parancs="SELECT * FROM qj_jegy where $_SESSION[SQL_elad] and not $_SESSION[SQL_inet] and bizonylatszam=0 ";
Line #65:
Line #66:
Line #67:$nur=mysql_num_rows($eredmeny);
Line #68:$nur=0;
Line #69:
Line #70:if ($nur>0) {
Line #71:echo"<tr>
Line #72:<td align=right >
Line #73:<A STYLE='{vlink : gold}'
Line #74:href='QJ_analitika.php?&bizonylat=0'>
Line #75:
Line #76:</td>
Line #77:
Line #78:</tr>
Line #79:";
Line #80:
Line #81:}
Line #82:}
Line #83:
Line #84:$parancs="SELECT * FROM qj_jlog where bizomanyos='$login' ORDER BY logtime DESC limit 1 ";
Line #85:
Line #86:
Line #87:$egy_sor = mysql_fetch_array( $eredmeny );
Line #88:$nap=substr($egy_sor[logtime],0,10);
Line #89:
Line #90:
Line #91://if($login=='BI(c)')
Line #92:
Line #93:if (!isset($_GET[gyforg])) {
Line #94:$parancs="SELECT * FROM qj_jlog where bizomanyos='$login' and left(logtime,10)='$nap' ORDER BY logtime DESC limit 50";
Line #95:} else {
Line #96:$parancs="SELECT * FROM qj_jlog where bizomanyos='$login' and left(logtime,10)>'2010-09-01' ORDER BY logtime DESC limit 50";
Line #97:if ($login=="BI(c)")
Line #98:$parancs="SELECT * FROM qj_jlog where left(logtime,10)>'2010-09-01' ORDER BY logtime DESC limit 50 ";
Line #99:if ($login=="BI(c) and isset($_SESSION[qontroll])")
Line #100:$parancs="SELECT * FROM qj_jlog where left(logtime,10)>'2010-09-01' ORDER BY logtime DESC ";
Line #101:
Line #102:}
Line #103:
Line #104:
Line #105://?// echo($parancs."<hr>");
Line #106:
Line #107:
Line #108:
Line #109:$i=0;
Line #110:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #111:{
Line #112:
Line #113:
Line #114:$wjid=$egy_sor[wid];
Line #115:$nur=0;
Line #116:if ( isset($_SESSION[qontroll])) {
Line #117:
Line #118:$sel = "SELECT * FROM qj_cimlet where widarc='".$wjid."'";
Line #119:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #120:$csor = mysql_fetch_array( $sql );
Line #121:$nur=mysql_num_rows($sql);
Line #122:}
Line #123:
Line #124:if ($nur>0){
Line #125:$jelol="selected.gif";
Line #126:
Line #127:if ($csor[ELONY_FT]<>"") $konyvinfo="Elnyomtat:";
Line #128:
Line #129:$konyvel="<td ><font color=red>".$konyvinfo."<br>$csor[szoveg]</font></td>";
Line #130:} else {
Line #131:$jelol="stop.gif";
Line #132:$konyvel="<td >$egy_sor[logtime]</td>";
Line #133:}
Line #134:
Line #135:echo"<tr>
Line #136:<td align=right >
Line #137:<A STYLE='{vlink : gold}'
Line #138:href='QJ_analitika.php?&bizonylat=".$egy_sor[wid]."'>
Line #139:
Line #140:</td>
Line #141:
Line #142:<td align=right ><b><font color=$szin>".number_format( $egy_sor[osszdb])."</font></b></td>
Line #143:<td align=right ><b><font color=$szin>".number_format( $egy_sor[osszft])."</font></b></td>
Line #144:<td align=right><font color=blue><b>$egy_sor[wid]</b></font></td>
Line #145:<td >$egy_sor[status]</td>
Line #146:<td >$egy_sor[arforma]</td>
Line #147:$konyvel
Line #148:
Line #149:";
Line #150:
Line #151:if ($admin=="ADMIN")
Line #152:echo "<td align=right ><b>$egy_sor[bizomanyos]</b></td>";
Line #153:
Line #154:$vevokod=$egy_sor[vevokod];
Line #155:
Line #156:
Line #157:if ($vevokod>0 and isset($_SESSION[qontroll])) {
Line #158:$vevoker = "SELECT * FROM qj_cimtar WHERE wid=".$vevokod;
Line #159:
Line #160:$ct_sor = mysql_fetch_array($ctar);
Line #161:
Line #162:if ($ct_sor[telepules].$ct_sor[cim]=="") $info1=""; else
Line #163:$info1="<br><b>$ct_sor[telepules]</b> $ct_sor[cim]";
Line #164:
Line #165:if ($ct_sor[telszam].$ct_sor[uzenet]=="") $info2=""; else
Line #166:$info2="<br><b>$ct_sor[telszam]</b> $ct_sor[uzenet]";
Line #167:
Line #168:echo "<td align=right ><font color=red>
Line #169:<A target=sframe href='QJ_cimUP.php?&wjid=".$vevokod."&CimUp=QJ_gyujto.php&sqlfile=qj_cimtar'>
Line #170:$vevokod</a></font> <b>$ct_sor[nev]</b>$info1 $info2</td>";
Line #171:
Line #172:}
Line #173:
Line #174:
Line #175://if ($login=="BI(c)")
Line #176:
Line #177:echo"</tr>";
Line #178:
Line #179:$szin="";
Line #180:
Line #181:/*
Line #182:if ($i==100 ) {
Line #183:echo('</table><table>');
Line #184:$i=0;
Line #185:}
Line #186:++$i;
Line #187:*/
Line #188:
Line #189:}
Line #190:
Line #191:echo "
Line #192:</table>";
Line #193:
Line #194:///////////
Line #195:} else {
Line #196:///////////
Line #197:
Line #198:
Line #199:if ($_SESSION[admin]<>"ADMIN") $_POST[bizomanyos]=$_SESSION[login];
Line #200:
Line #201:$_SESSION[L_bizomanyos]=$_POST[bizomanyos];
Line #202:$_SESSION[L_nap]=$_POST[nap];
Line #203:$_SESSION[L_status]=$_POST[status];
Line #204:
Line #205:
Line #206:if ($_POST[bizomanyos]==$_SESSION[login] )
Line #207:$wer=" where bizomanyos='".$_POST[bizomanyos]."'";
Line #208:else
Line #209:$wer="";
Line #210:
Line #211:
Line #212:echo"<FORM name=orderby target=sframe
Line #213:action='QJ_gyujto.php?&lista=2' method='post'>";
Line #214:
Line #215:
Line #216:$disQ = "SELECT distinct bizomanyos FROM qj_jlog $wer order by bizomanyos" ;
Line #217:
Line #218:
Line #219://echo($disQ."<hr>");
Line #220:
Line #221:
Line #222:onchange=this.form.submit(); return true name='bizomanyos'>";
Line #223:
Line #224:
Line #225:
Line #226:
Line #227:if ($_SESSION['admin']=='ADMIN') {
Line #228:if ($_POST[bizomanyos]=='0') $sel="SELECTED"; else $sel="";
Line #229:
Line #230:}
Line #231:
Line #232:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #233:if ($disC[bizomanyos]==$_POST[bizomanyos]) $sel="SELECTED"; else $sel="";
Line #234:$sel2.="<option value='".$disC[bizomanyos]."' $sel >".$disC[bizomanyos]."</option>";
Line #235:}
Line #236:
Line #237:$sel2.="</SELECT>";
Line #238:
Line #239:////////
Line #240:
Line #241:if (isset($_POST[bizomanyos]) and $_POST[bizomanyos]<>"*" )
Line #242:$wer=" where bizomanyos='".$_POST[bizomanyos]."'";
Line #243:else
Line #244:$wer="";
Line #245:if ($_POST[bizomanyos]=="0" ) $wer="";
Line #246:
Line #247:/*
Line #248://$disQ = "SELECT left(logtime,10) as nap, distinct nap FROM qj_jlog order by logtime DESC" ;
Line #249:
Line #250:$disQ = "SELECT logtime FROM qj_jlog $wer order by logtime DESC" ;
Line #251:
Line #252:
Line #253://echo($disQ."<hr>");
Line #254:
Line #255:
Line #256:onchange=this.form.submit(); return true name='nap'>";
Line #257:
Line #258:
Line #259:$nap="?";
Line #260:
Line #261:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #262:$Wnap=substr($disC[logtime],0,10);
Line #263:
Line #264:
Line #265:// if ($nap=="?") $_SESSION[L_nap]=$Wnap;
Line #266:// if ($nap=="?") unset($_SESSION[L_nap]);
Line #267:// if ($nap<>$Wnap and $Wnap>'2010-03-31' ) {
Line #268:
Line #269:if ($nap<>$Wnap ) {
Line #270:$nap=$Wnap;
Line #271:if ($nap==$_POST[nap]) $sel="SELECTED"; else $sel="";
Line #272:$sel1.="<option value='".$nap."' $sel >". $nap."</option>";
Line #273:}
Line #274:}
Line #275:
Line #276:$sel1.="</SELECT>";
Line #277:*/
Line #278:
Line #279:
Line #280:$disQ = "SELECT distinct left(logtime,10) as datum FROM qj_jegy " .$wer. " order by left(logtime,10) DESC" ;
Line #281:
Line #282://echo($disQ."<hr>");
Line #283:
Line #284:
Line #285:
Line #286:
Line #287:
Line #288:onchange=this.form.submit(); return true name='nap'>";
Line #289:
Line #290:
Line #291:$nap="?";
Line #292:
Line #293:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #294://$Wnap=substr($disC[logtime],0,10);
Line #295:$Wnap=$disC[datum];
Line #296:
Line #297:
Line #298:// if ($nap=="?") $_SESSION[L_nap]=$Wnap;
Line #299:// if ($nap=="?") unset($_SESSION[L_nap]);
Line #300:// if ($nap<>$Wnap and $Wnap>'2010-03-31' ) {
Line #301:
Line #302:if ($nap<>$Wnap ) {
Line #303:$nap=$Wnap;
Line #304:if ($nap==$_POST[nap]) $sel="SELECTED"; else $sel="";
Line #305:$sel1.="<option value='".$nap."' $sel >". $nap."</option>";
Line #306:}
Line #307:}
Line #308:
Line #309:$sel1.="</SELECT>";
Line #310:
Line #311://///////
Line #312:
Line #313:if (isset($_POST[nap]) and $_POST[nap]<>"*") {
Line #314:if ($wer<>"") $wer.=" and "; ELSE $wer=" where";
Line #315:$wer.=" left(logtime,10)='".$_POST[nap]."'";
Line #316:}
Line #317:else $wer="";
Line #318:
Line #319:$disQ = "SELECT distinct status FROM qj_jlog $wer order by status" ;
Line #320:
Line #321://echo($disQ."<hr>");
Line #322:
Line #323:
Line #324:onchange=this.form.submit(); return true name='status'>";
Line #325:
Line #326:
Line #327:
Line #328:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #329:if ($disC[status]==$_POST[status]) $sel="SELECTED"; else $sel="";
Line #330:
Line #331:$sel3.="<option value='".$disC[status]."' $sel>".$disC[status]."</option>";
Line #332:}
Line #333:
Line #334:$sel3.="</SELECT>";
Line #335:
Line #336:////////
Line #337:
Line #338:$sel4="<input type='text' value='".$_POST[Sbizonylat]."' name='Sbizonylat'
Line #339:
Line #340:
Line #341:
Line #342:if ($_POST[bizomanyos]=="*" or !isset($_POST[bizomanyos]) ) { $sel1=""; $sel3=""; }
Line #343:if ($_POST[nap]=="*" or !isset($_POST[nap])) $sel3="";
Line #344:
Line #345:
Line #346:/*if ($_SESSION[SpeciUse]=="4x")
Line #347:
Line #348:<input type='submit' value='>>>' name='submit'>";
Line #349:else $sel4="";*/
Line #350:
Line #351:
Line #352://if ($_SESSION[SpeciUse]=="4x")
Line #353:$sel4="<input type='text' value='".$_POST[Sbizonylat]."' name='Sbizonylat'
Line #354:
Line #355://else $sel4="";
Line #356:
Line #357:
Line #358:
Line #359:
Line #360:
Line #361:
Line #362:echo"</FORM>";
Line #363:
Line #364:
Line #365:echo("<TABLE border=0 ><TR><td width=200>");
Line #366:
Line #367:$parancs="SELECT * FROM qj_sql where szoveg='QJ_gyujto' and archiv<>'*' and future<>'*' ORDER BY widarc";
Line #368:
Line #369:
Line #370:
Line #371:$i=0;
Line #372:while ( $egy_sor = mysql_fetch_array( $eredmeny )) {
Line #373:
Line #374://echo($egy_sor[usr_kod]."/".$egy_sor[sql_memo]."/".$egy_sor[sql_parancs]."<hr>");
Line #375:
Line #376:if ($egy_sor[usr_kod]=='Login' or
Line #377: $_SESSION[admin]==$egy_sor[usr_kod] or
Line #378: $_SESSION[login]=='BI(c)') {
Line #379:if (substr($egy_sor[widarc],0,1)<>$i) {
Line #380:$i=substr($egy_sor[widarc],0,1);
Line #381:echo("</Tr><tr>");
Line #382:}
Line #383:$target=$egy_sor[archiv];
Line #384:$szin=$egy_sor[future];
Line #385:$url=$egy_sor[sql_memo];
Line #386:$cim=$egy_sor[sql_parancs];
Line #387:echo("<td width=200 bgcolor=$szin>");
Line #388:echo("<a target='$target' href='$url'>$cim</a>   ");
Line #389:echo("</Td>");
Line #390:}
Line #391:}
Line #392:
Line #393:echo("</Td></tr></table>");
Line #394:
Line #395:
Line #396:
Line #397:
Line #398:/*
Line #399:echo("<TABLE border=0 ><TR><td width=200>");
Line #400:
Line #401:
Line #402:echo("</Td><td width=200>");
Line #403:
Line #404:
Line #405:echo("</Td><td width=200>");
Line #406:
Line #407:
Line #408:echo("</Td><td width=200>");
Line #409:
Line #410:
Line #411:
Line #412:
Line #413:echo("</Td>");
Line #414:
Line #415:/*
Line #416:if ($_SESSION[admin]<>"Protokoll") {
Line #417:
Line #418:echo("<a href='QJ_jegymesterONLINE.php'>JEGYMESTER online</a>   ");
Line #419:echo("</Td><td width=200>");
Line #420:
Line #421://QJ_tiproXLS.php
Line #422:
Line #423:
Line #424://echo("</Td>");
Line #425:
Line #426:echo("</Td>");
Line #427:}
Line #428:
Line #429:if ($_SESSION['admin']=='ADMIN')
Line #430:{
Line #431:/// JUDIT ///
Line #432:
Line #433:echo("</Tr><tr bgcolor='#DBE6E0' ><td width=200>");
Line #434:
Line #435:
Line #436:echo("</Td><td width=200>");
Line #437:
Line #438:
Line #439:echo("</Td><td width=200>");
Line #440:
Line #441:
Line #442:echo("</Td><td width=200>");
Line #443:
Line #444:
Line #445:echo("</Td><td width=200>");
Line #446:
Line #447:
Line #448:echo("</Td>");
Line #449:
Line #450:///////////////
Line #451:echo("</Tr><tr bgcolor='#A7C2B3' ><td width=200 bgcolor=gold>");
Line #452:
Line #453:
Line #454:
Line #455:
Line #456:
Line #457:echo("</Td><td width=200>");
Line #458:
Line #459:
Line #460:echo("</Td><td width=200>");
Line #461:
Line #462:
Line #463:echo("</Td><td width=200>");
Line #464:
Line #465:echo("<a href='QJ_cimletLIST.php'>Havi lista</a>   ");
Line #466:echo("</Td><td width=200>");
Line #467:
Line #468:
Line #469:echo("</Td>");
Line #470:
Line #471:
Line #472://echo("</Td>");
Line #473:
Line #474:
Line #475:////////////////////////////////////////////////
Line #476:echo("</td></Tr><tr bgcolor='#DBE6E0' ><td width=200>");
Line #477:////////////////////////////////////////////////
Line #478:echo("<a href='QJ_jegymesterONLINE.php'>JEGYMESTER online</a>   ");
Line #479:echo("</Td><td width=200>");
Line #480:
Line #481://QJ_tiproXLS.php
Line #482:
Line #483:
Line #484://echo("</Td>");
Line #485:
Line #486:echo("</Td><td width=200>");
Line #487:
Line #488:
Line #489:
Line #490:echo("</td><td width=200>");
Line #491:
Line #492:
Line #493:
Line #494:
Line #495:
Line #496:
Line #497:if ($login=="BI(c)") {
Line #498:////////////////////////////////////////////////
Line #499:echo("</td></Tr><tr bgcolor=silver><td width=200>");
Line #500:////////////////////////////////////////////////
Line #501:echo("<a href='QJ_eszmei.php'>Eszmei lista</a>   ");
Line #502:echo("</Td><td width=200>");
Line #503:
Line #504:
Line #505:
Line #506:echo("</Td><td width=200>");
Line #507:
Line #508:
Line #509:echo("</Td><td width=200>");
Line #510:
Line #511:
Line #512:echo("</td></Tr><tr bgcolor=silver><td width=200>");
Line #513:
Line #514:////////////////////////////////////////////////
Line #515:echo("</td></Tr><tr><td width=200>");
Line #516:////////////////////////////////////////////////
Line #517:echo("<a href='QJ_fulljegyERR.php'>Jegykontroll lista</a>   ");
Line #518:echo("</Td><td width=200>");
Line #519:
Line #520:echo("<a href='QJ_protokolLIST.php'>Protokoll lista</a>   ");
Line #521:echo("</Td><td width=200>");
Line #522:
Line #523:echo("<a href='QJ_internetCLOSED.php'>InternetClosed</a>   ");
Line #524:echo("</Td><td width=200>");
Line #525:
Line #526:
Line #527:
Line #528:echo("</td></Tr><tr bgcolor=silver><td width=200>");
Line #529:////////////////////////////////////////////////
Line #530:
Line #531:
Line #532:}
Line #533:
Line #534:echo("</Td></tr></table>");
Line #535:
Line #536:}
Line #537:*/
Line #538:
Line #539:}
Line #540:
Line #541:
Line #542://?
Line #543://include("QJ_varlist.php")
Line #544:
Line #545:/*
Line #546: echo('<br><hr><br>_POST[Qid] <br>');
Line #547:
Line #548:$i=0;
Line #549:
Line #550:echo('<table width=600 height=40 border=1>');
Line #551:
Line #552:while (list ($key, $val) = each ($_POST[Qid])) {
Line #553: $i++;
Line #554: echo '<tr><td ALIGN="left">'.$i.'</td><td ALIGN="right">'."$key ".'</td><td ALIGN="left">'.($val)."</td></tr>";
Line #555:}
Line #556:
Line #557:echo('</table>');
Line #558: echo('<br><hr>');
Line #559:
Line #560:////////////////////////////////////////////
Line #561:
Line #562:
Line #563:
Line #564:////////////////////////////////////////////
Line #565: echo('<br><hr><br>_SESSION <br>');
Line #566:
Line #567:$i=0;
Line #568:
Line #569:echo('<table width=600 height=40 border=1>');
Line #570:
Line #571:while (list ($key, $val) = each ($_SESSION)) {
Line #572: $i++;
Line #573: echo '<tr><td ALIGN="left">'.$i.'</td><td ALIGN="right">'."$key ".'</td><td ALIGN="left">'.($val)."</td></tr>";
Line #574:}
Line #575:
Line #576:echo('</table>');
Line #577: echo('<br><hr>');
Line #578:
Line #579:////////////////////////////////////////////
Line #580: echo('<br><hr><br>_POST <br>');
Line #581:
Line #582:$i=0;
Line #583:
Line #584:echo('<table width=600 height=40 border=1>');
Line #585:
Line #586:while (list ($key, $val) = each ($_POST)) {
Line #587: $i++;
Line #588: echo '<tr><td ALIGN="left">'.$i.'</td><td ALIGN="right">'."$key ".'</td><td ALIGN="left">'.($val)."</td></tr>";
Line #589:}
Line #590:
Line #591:echo('</table>');
Line #592: echo('<br><hr>');
Line #593:
Line #594:
Line #595:////////////////////////////////////////////
Line #596: echo('<br><hr><br>_GET <br>');
Line #597:
Line #598:$i=0;
Line #599:
Line #600:echo('<table width=600 height=40 border=1>');
Line #601:
Line #602:while (list ($key, $val) = each ($_GET)) {
Line #603: $i++;
Line #604: echo '<tr><td ALIGN="left">'.$i.'</td><td ALIGN="right">'."$key ".'</td><td ALIGN="left">'.($val)."</td></tr>";
Line #605:}
Line #606:
Line #607:echo('</table>');
Line #608: echo('<br><hr>');
Line #609:
Line #610:
Line #611:*/
Line #612:
Line #613://~*~// QJ_gyujto.php
Line #614:
Line #615:?>
Line #616:
Line #617:
Line #626: