Bi-Dir

QB_gyujto.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&lista=1 target=sframe>Vissza...</a>  ");
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:echo"</FORM>";
Line #361:
Line #362:
Line #363:echo("<TABLE border=0 ><TR><td width=200>");
Line #364:
Line #365:$parancs="SELECT * FROM qj_sql where szoveg='QJ_gyujto' and archiv<>'*' and future<>'*' ORDER BY widarc";
Line #366:
Line #367:
Line #368:
Line #369:$i=0;
Line #370:while ( $egy_sor = mysql_fetch_array( $eredmeny )) {
Line #371:
Line #372://echo($egy_sor[usr_kod]."/".$egy_sor[sql_memo]."/".$egy_sor[sql_parancs]."<hr>");
Line #373:
Line #374:if ($egy_sor[usr_kod]=='Login' or
Line #375: $_SESSION[admin]==$egy_sor[usr_kod] or
Line #376: $_SESSION[login]=='BI(c)') {
Line #377:if (substr($egy_sor[widarc],0,1)<>$i) {
Line #378:$i=substr($egy_sor[widarc],0,1);
Line #379:echo("</Tr><tr>");
Line #380:}
Line #381:$target=$egy_sor[archiv];
Line #382:$szin=$egy_sor[future];
Line #383:$url=$egy_sor[sql_memo];
Line #384:$cim=$egy_sor[sql_parancs];
Line #385:echo("<td width=200 bgcolor=$szin>");
Line #386:echo("<a target='$target' href='$url'>$cim</a>   ");
Line #387:echo("</Td>");
Line #388:}
Line #389:}
Line #390:
Line #391:echo("</Td></tr></table>");
Line #392:
Line #393:
Line #394:
Line #395:
Line #396:/*
Line #397:echo("<TABLE border=0 ><TR><td width=200>");
Line #398:
Line #399:
Line #400:echo("</Td><td width=200>");
Line #401:
Line #402:
Line #403:echo("</Td><td width=200>");
Line #404:
Line #405:
Line #406:echo("</Td><td width=200>");
Line #407:
Line #408:
Line #409:
Line #410:
Line #411:echo("</Td>");
Line #412:
Line #413:/*
Line #414:if ($_SESSION[admin]<>"Protokoll") {
Line #415:
Line #416:echo("<a href='QJ_jegymesterONLINE.php'>JEGYMESTER online</a>   ");
Line #417:echo("</Td><td width=200>");
Line #418:
Line #419://QJ_tiproXLS.php
Line #420:
Line #421:
Line #422://echo("</Td>");
Line #423:
Line #424:echo("</Td>");
Line #425:}
Line #426:
Line #427:if ($_SESSION['admin']=='ADMIN')
Line #428:{
Line #429:/// JUDIT ///
Line #430:
Line #431:echo("</Tr><tr bgcolor='#DBE6E0' ><td width=200>");
Line #432:
Line #433:
Line #434:echo("</Td><td width=200>");
Line #435:
Line #436:
Line #437:echo("</Td><td width=200>");
Line #438:
Line #439:
Line #440:echo("</Td><td width=200>");
Line #441:
Line #442:
Line #443:echo("</Td><td width=200>");
Line #444:
Line #445:
Line #446:echo("</Td>");
Line #447:
Line #448:///////////////
Line #449:echo("</Tr><tr bgcolor='#A7C2B3' ><td width=200 bgcolor=gold>");
Line #450:
Line #451:
Line #452:
Line #453:
Line #454:
Line #455:echo("</Td><td width=200>");
Line #456:
Line #457:
Line #458:echo("</Td><td width=200>");
Line #459:
Line #460:
Line #461:echo("</Td><td width=200>");
Line #462:
Line #463:echo("<a href='QJ_cimletLIST.php'>Havi lista</a>   ");
Line #464:echo("</Td><td width=200>");
Line #465:
Line #466:
Line #467:echo("</Td>");
Line #468:
Line #469:
Line #470://echo("</Td>");
Line #471:
Line #472:
Line #473:////////////////////////////////////////////////
Line #474:echo("</td></Tr><tr bgcolor='#DBE6E0' ><td width=200>");
Line #475:////////////////////////////////////////////////
Line #476:echo("<a href='QJ_jegymesterONLINE.php'>JEGYMESTER online</a>   ");
Line #477:echo("</Td><td width=200>");
Line #478:
Line #479://QJ_tiproXLS.php
Line #480:
Line #481:
Line #482://echo("</Td>");
Line #483:
Line #484:echo("</Td><td width=200>");
Line #485:
Line #486:
Line #487:
Line #488:echo("</td><td width=200>");
Line #489:
Line #490:
Line #491:
Line #492:
Line #493:
Line #494:
Line #495:if ($login=="BI(c)") {
Line #496:////////////////////////////////////////////////
Line #497:echo("</td></Tr><tr bgcolor=silver><td width=200>");
Line #498:////////////////////////////////////////////////
Line #499:echo("<a href='QJ_eszmei.php'>Eszmei lista</a>   ");
Line #500:echo("</Td><td width=200>");
Line #501:
Line #502:
Line #503:
Line #504:echo("</Td><td width=200>");
Line #505:
Line #506:
Line #507:echo("</Td><td width=200>");
Line #508:
Line #509:
Line #510:echo("</td></Tr><tr bgcolor=silver><td width=200>");
Line #511:
Line #512:////////////////////////////////////////////////
Line #513:echo("</td></Tr><tr><td width=200>");
Line #514:////////////////////////////////////////////////
Line #515:echo("<a href='QJ_fulljegyERR.php'>Jegykontroll lista</a>   ");
Line #516:echo("</Td><td width=200>");
Line #517:
Line #518:echo("<a href='QJ_protokolLIST.php'>Protokoll lista</a>   ");
Line #519:echo("</Td><td width=200>");
Line #520:
Line #521:echo("<a href='QJ_internetCLOSED.php'>InternetClosed</a>   ");
Line #522:echo("</Td><td width=200>");
Line #523:
Line #524:
Line #525:
Line #526:echo("</td></Tr><tr bgcolor=silver><td width=200>");
Line #527:////////////////////////////////////////////////
Line #528:
Line #529:
Line #530:}
Line #531:
Line #532:echo("</Td></tr></table>");
Line #533:
Line #534:}
Line #535:*/
Line #536:
Line #537:}
Line #538:
Line #539:
Line #540://?
Line #541://include("QJ_varlist.php")
Line #542:
Line #543:/*
Line #544: echo('<br><hr><br>_POST[Qid] <br>');
Line #545:
Line #546:$i=0;
Line #547:
Line #548:echo('<table width=600 height=40 border=1>');
Line #549:
Line #550:while (list ($key, $val) = each ($_POST[Qid])) {
Line #551: $i++;
Line #552: echo '<tr><td ALIGN="left">'.$i.'</td><td ALIGN="right">'."$key ".'</td><td ALIGN="left">'.($val)."</td></tr>";
Line #553:}
Line #554:
Line #555:echo('</table>');
Line #556: echo('<br><hr>');
Line #557:
Line #558:////////////////////////////////////////////
Line #559:
Line #560:
Line #561:
Line #562:////////////////////////////////////////////
Line #563: echo('<br><hr><br>_SESSION <br>');
Line #564:
Line #565:$i=0;
Line #566:
Line #567:echo('<table width=600 height=40 border=1>');
Line #568:
Line #569:while (list ($key, $val) = each ($_SESSION)) {
Line #570: $i++;
Line #571: echo '<tr><td ALIGN="left">'.$i.'</td><td ALIGN="right">'."$key ".'</td><td ALIGN="left">'.($val)."</td></tr>";
Line #572:}
Line #573:
Line #574:echo('</table>');
Line #575: echo('<br><hr>');
Line #576:
Line #577:////////////////////////////////////////////
Line #578: echo('<br><hr><br>_POST <br>');
Line #579:
Line #580:$i=0;
Line #581:
Line #582:echo('<table width=600 height=40 border=1>');
Line #583:
Line #584:while (list ($key, $val) = each ($_POST)) {
Line #585: $i++;
Line #586: echo '<tr><td ALIGN="left">'.$i.'</td><td ALIGN="right">'."$key ".'</td><td ALIGN="left">'.($val)."</td></tr>";
Line #587:}
Line #588:
Line #589:echo('</table>');
Line #590: echo('<br><hr>');
Line #591:
Line #592:
Line #593:////////////////////////////////////////////
Line #594: echo('<br><hr><br>_GET <br>');
Line #595:
Line #596:$i=0;
Line #597:
Line #598:echo('<table width=600 height=40 border=1>');
Line #599:
Line #600:while (list ($key, $val) = each ($_GET)) {
Line #601: $i++;
Line #602: echo '<tr><td ALIGN="left">'.$i.'</td><td ALIGN="right">'."$key ".'</td><td ALIGN="left">'.($val)."</td></tr>";
Line #603:}
Line #604:
Line #605:echo('</table>');
Line #606: echo('<br><hr>');
Line #607:
Line #608:
Line #609:*/
Line #610:
Line #611:include("QJ_stop.php");
Line #612:
Line #613://~*~// QJ_gyujto.php
Line #614:
Line #615:?>
Line #616:
Line #617:
Line #626: