Bi-Dir

QJ_gyujto_KB.inc

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