Bi-Dir

QJ_napi_SI.inc

Line #0:<?php
Line #1:
Line #2:if (isset($_GET[nyomtat])) {
Line #3:?>
Line #4:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #5:<?PHP
Line #6:}
Line #7:
Line #8:if (isset($_GET[L_nap])) $_SESSION[L_nap]=$_GET[L_nap];
Line #9:if (isset($_GET[L_biz])) $_SESSION[L_bizomanyos]=$_GET[L_biz];
Line #10:
Line #11:$login=$_SESSION['login'];
Line #12:
Line #13:IF (ISSET($_SESSION[L_nap]) and $_SESSION[L_nap]<>"*")
Line #14:$wer1=" and left(logtime,10)='".$_SESSION[L_nap]."'"; else $wer1="";
Line #15:
Line #16:IF (ISSET($_SESSION[L_bizomanyos]) and $_SESSION[L_bizomanyos]<>"*")
Line #17:$login=$_SESSION[L_bizomanyos];
Line #18:
Line #19:$wer2=" and bizomanyos='".$login."'";
Line #20:
Line #21:$nocheck="F";
Line #22:
Line #23:IF ($_SESSION[L_bizomanyos]=="*" or $_SESSION[L_bizomanyos]=="0" ) { $nocheck="Y"
Line #24:; $wer2=""; }
Line #25:
Line #26:
Line #27:if ($_SESSION['admin']=="ADMIN") $nev=$login; else $nev=$_SESSION['login_nev'];
Line #28:
Line #29:$szin="";
Line #30:$i=0;
Line #31:$ft=0;
Line #32:$nap="?";
Line #33:$ri=0;
Line #34:$rft=0;
Line #35:$rmuv="?";
Line #36:
Line #37:$wi=0;
Line #38:$wft=0;
Line #39:$rlog="?";
Line #40:$hiba="";
Line #41:
Line #42://$parancs="SELECT * FROM qj_jegy where left(statusz,1)<>' ' and left(statusz,2)<>'El' and left(statusz,2)<>'St' $wer1 $wer2 ORDER BY logtime DESC";
Line #43:
Line #44://$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] or $_SESSION[SQL_storno]) $wer1 $wer2 ORDER BY logtime DESC";
Line #45:
Line #46:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $wer1 $wer2 ORDER BY logtime DESC";
Line #47:
Line #48://?
Line #49://echo ($parancs."<hr>");
Line #50:
Line #51:
Line #52:
Line #53:$kegy_sor = mysql_fetch_array( $keredmeny );
Line #54:$Pnap=substr($kegy_sor[logtime],0,10);
Line #55:$rmuv=$kegy_sor[statusz];
Line #56:
Line #57:$nap=substr($kegy_sor[logtime],0,10);
Line #58:$wer1=" and left(logtime,10)='".$nap."'";
Line #59:
Line #60:if ($_SESSION[L_nap]==" " or !isset($_SESSION[L_nap])) {
Line #61: $_SESSION[L_nap]=$nap;
Line #62: $_SESSION[L_bizomanyos]=$kegy_sor[bizomanyos];
Line #63:}
Line #64:
Line #65:
Line #66:
Line #67:$_SESSION[Pnap]=$Pnap;
Line #68:$L_NAP=$_SESSION[L_nap];
Line #69:$L_user=$_SESSION[L_bizomanyos];
Line #70:
Line #71:
Line #72:
Line #73:$L_PHP="QJ_napi.php";
Line #74:include("QJ_listafej.php");
Line #75:
Line #76:echo "<table border=0>
Line #77:<tr bgcolor=silver>
Line #78:<td align=right >Ssz.</td>
Line #79:
Line #80:
Line #81:
Line #82:
Line #83:
Line #84:
Line #85:</tr>";
Line #86:
Line #87:
Line #88://$parancs="SELECT * FROM qj_jegy where left(logtime,10)='$Pnap' and bizomanyos='$login' and left(statusz,2)<>'El' and left(statusz,2)<>'St' ORDER BY statusz,logtime";
Line #89:
Line #90://$parancs="SELECT * FROM qj_jegy where left(statusz,2)<>'El' and left(statusz,2)<>'St' and left(statusz,1)<>' ' $wer1 $wer2 ORDER BY statusz,logtime";
Line #91:
Line #92://$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] or $_SESSION[SQL_storno]) $wer1 $wer2 ORDER BY statusz,bizonylatszam DESC";
Line #93:
Line #94:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $wer1 $wer2 ORDER BY statusz,bizonylatszam DESC";
Line #95://?
Line #96://echo ($parancs."<hr>");
Line #97:
Line #98:
Line #99:
Line #100:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #101:{
Line #102:
Line #103:if ($i==0) {
Line #104: $rmuv=$egy_sor[statusz];
Line #105: $nap=substr($egy_sor[logtime],0,10);
Line #106: $rlog=$egy_sor[bizonylatszam];
Line #107:}
Line #108:
Line #109:if ($rlog<>$egy_sor[bizonylatszam] and $nocheck<>"Y" ){
Line #110:
Line #111://$bsz=$egy_sor[bizonylatszam];
Line #112:$keres3 ="SELECT * FROM qj_jlog where wid='$rlog'";
Line #113:
Line #114:$nur=mysql_num_rows($eredmeny3);
Line #115:$logsor = mysql_fetch_array( $eredmeny3 );
Line #116:if ($nur>0 and $login==$logsor[bizomanyos] and $wft==$logsor[osszft]) $hiba="gold"; else $hiba="red";
Line #117:
Line #118:
Line #119:/*IF ($_SESSION[admin]=="ADMIN") $rel="<a href=QJ_analitika.php?&bizonylat=".$rlog.">".$rlog."</a>";
Line #120:else $rel=$rlog;*/
Line #121:
Line #122:IF ($_SESSION[admin]=="ADMIN") $rel="<a href=QJ_cimletez.php?&wjid=".$rlog.">".$rlog."</a>";
Line #123:else $rel=$rlog;
Line #124:
Line #125:
Line #126:
Line #127:echo"<tr>
Line #128:
Line #129:
Line #130:</td>
Line #131:
Line #132:<td colspan=2 align=right bgcolor=silver>".number_format($wft)."</td>
Line #133:<td bgcolor=silver> Ft</td>
Line #134:<td align=right bgcolor=silver>$wi 
Line #135: </td>
Line #136:
Line #137:<td colspan=2 align=left bgcolor=silver> Db</td>
Line #138:<td colspan=2 align=right bgcolor=$hiba>".number_format($logsor[osszft])."</td>
Line #139:<td align=right bgcolor=$hiba>$logsor[osszdb] 
Line #140: </td>
Line #141:
Line #142:
Line #143:</tr>";
Line #144:
Line #145:
Line #146:$rlog=$egy_sor[bizonylatszam];
Line #147:
Line #148:$wi=0;
Line #149:$wft=0;
Line #150:
Line #151:}
Line #152:
Line #153:
Line #154:
Line #155:$ref="";
Line #156:if ($egy_sor[bizonylatszam]=="" ) $ref="".$egy_sor[wid]." Adat hiba !!!";
Line #157:if ($_SESSION['login']=="BI(c)") $ref.=" <a href=BI_ediTable.php?&wjid=".$egy_sor[wid]."&sqlfile=qj_jegy>".$egy_sor[wid]."</a>";
Line #158:
Line #159:if ($rmuv<>$egy_sor[statusz] ){
Line #160:
Line #161:echo"<tr>
Line #162:
Line #163:<td colspan=2 align=right bgcolor=silver>
Line #164:
Line #165:</td>
Line #166:
Line #167:<td colspan=2 align=right bgcolor=silver>".number_format($rft)."</td>
Line #168:<td bgcolor=silver> Ft</td>
Line #169:<td align=right bgcolor=silver>$ri 
Line #170: </td>
Line #171:<td colspan=2 align=left bgcolor=silver> Db</td>
Line #172:</tr>";
Line #173:
Line #174:$_SESSION[$rmuv]=$rft;
Line #175:
Line #176:$ri=0;
Line #177:$rft=0;
Line #178:
Line #179:$rmuv=$egy_sor[statusz];
Line #180:
Line #181:}
Line #182:
Line #183:// ($nap==substr($egy_sor[logtime],0,10)) {
Line #184:
Line #185:++$i;
Line #186:++$ri;
Line #187:$rft=$rft+$egy_sor[ar];
Line #188:$ft =$ft+$egy_sor[ar];
Line #189:
Line #190:
Line #191:++$wi;
Line #192:$wft=$wft+$egy_sor[ar];
Line #193:
Line #194:$dk=$egy_sor[datum_kod];
Line #195:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$dk'";
Line #196:
Line #197:
Line #198:$musor = mysql_fetch_array( $eredmeny3 );
Line #199:
Line #200:$h=$musor[helyszin];
Line #201:$c=$egy_sor[cim];
Line #202:$d=$egy_sor[datum];
Line #203:$wjid=$egy_sor[wid];
Line #204:
Line #205:$FormaJel=$egy_sor[FormaJel];
Line #206:$JeBe=$egy_sor[JeBe];
Line #207:
Line #208:
Line #209:
Line #210:echo"<tr>
Line #211:
Line #212:<td align=right >
Line #213: $i.
Line #214:</td>
Line #215:
Line #216:<td align=right >$musor[cim] $musor[datum] $helyinfo</td>
Line #217:<td align=right >$musor[JeBe] $egy_sor[ar_nev]</td>
Line #218:<td align=right >".number_format($egy_sor[ar])."</td>
Line #219:<td >$egy_sor[statusz]</td>
Line #220:<td >$egy_sor[bizonylatszam]$ref</td>
Line #221:<td >".substr($egy_sor[logtime],-8)."</td>
Line #222:</tr>";
Line #223:$szin="";
Line #224://<td >".substr($egy_sor[logtime],-8)."</td>
Line #225://<td >".$egy_sor[logtime].$egy_sor[bizomanyos]."</td>
Line #226://<td >".$egy_sor[logtime].$egy_sor[bizomanyos].$ft."</td>
Line #227:
Line #228://}
Line #229:
Line #230:}
Line #231:
Line #232:
Line #233:
Line #234:$keres3 ="SELECT * FROM qj_jlog where wid='$rlog'";
Line #235:
Line #236:$nur=mysql_num_rows($eredmeny3);
Line #237:$logsor = mysql_fetch_array( $eredmeny3 );
Line #238:if ($nur>0 and $login==$logsor[bizomanyos] and $wft==$logsor[osszft]) $hiba="gold"; else $hiba="red";
Line #239:
Line #240:
Line #241:IF ($_SESSION[admin]=="ADMIN") $rel="<a href=QJ_analitika.php?&bizonylat=".$rlog.">".$rlog."</a>";
Line #242:else $rel=$rlog;
Line #243:
Line #244:echo"<tr>
Line #245:
Line #246:
Line #247:</td>
Line #248:
Line #249:<td colspan=2 align=right bgcolor=silver>".number_format($wft)."</td>
Line #250:<td bgcolor=silver> Ft</td>
Line #251:<td align=right bgcolor=silver>$wi 
Line #252: </td>
Line #253:
Line #254:<td colspan=2 align=left bgcolor=silver> Db</td>
Line #255:<td colspan=2 align=right bgcolor=$hiba>".number_format($logsor[osszft])."</td>
Line #256:<td align=right bgcolor=$hiba>$logsor[osszdb] 
Line #257: </td>
Line #258:</tr>";
Line #259:
Line #260:$_SESSION[$rmuv]=$rft;
Line #261:
Line #262:if ($ft>0)
Line #263:echo"<tr>
Line #264:
Line #265:
Line #266:</td>
Line #267:
Line #268:<td colspan=2 align=right bgcolor=silver>".number_format($rft)."</td>
Line #269:<td bgcolor=silver> Ft</td>
Line #270:<td align=right bgcolor=silver>$ri 
Line #271: </td>
Line #272:<td colspan=2 align=left bgcolor=silver> Db</td>
Line #273:</tr>";
Line #274:
Line #275:
Line #276:$_SESSION[OSSZft]=$ft;
Line #277:$_SESSION[OSSZdb]=$i;
Line #278:
Line #279:
Line #280:
Line #281:
Line #282:echo"<tr>
Line #283:
Line #284:</td>
Line #285:<td colspan=2 align=right bgcolor=silver>"
Line #286:.number_format($ft)."</td>
Line #287:<td bgcolor=silver> Ft</td>
Line #288:<td align=right bgcolor=silver>$i 
Line #289: </td>
Line #290:<td colspan=2 align=left bgcolor=silver> Db</td>
Line #291:</tr>";
Line #292:
Line #293:echo"</table>";
Line #294:
Line #295://///////////
Line #296:
Line #297://$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] or $_SESSION[SQL_storno]) $wer1 $wer2 ORDER BY statusz,bizonylatszam DESC";
Line #298:
Line #299:
Line #300:$wer1=" and left(logtime,10)='".$_SESSION[L_nap]."'";
Line #301:$parancs="SELECT * FROM qj_archive where left(statusz,2)='St'
Line #302: $wer1 $wer2 ORDER BY statusz,bizonylatszam DESC";
Line #303:////-?-///echo ($parancs."<hr>");
Line #304:
Line #305:
Line #306:$nur=mysql_num_rows($eredmeny);
Line #307:if ($nur>0) {
Line #308:
Line #309:
Line #310:
Line #311:echo "<table border=1>
Line #312:<tr bgcolor=silver>
Line #313:<td >Sorsz.</td>
Line #314:
Line #315:
Line #316:
Line #317:
Line #318:
Line #319:
Line #320:</tr>";
Line #321:$i=0;
Line #322:$stft=0;
Line #323:$snft=0;
Line #324:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #325:{
Line #326:++$i;
Line #327:
Line #328:
Line #329:$widarc=$egy_sor[widarc];
Line #330:$keres3 = "SELECT * FROM qj_archive WHERE
Line #331:widarc='$widarc' and left(statusz,2)<>'El' order by printdatum ";
Line #332:
Line #333://printdatum bizonylatszam
Line #334://$keres3 = "SELECT * FROM qj_archive WHERE widarc='$widarc' order by Logtime ";
Line #335:////-?-/// echo ("<tr bgcolor=silver><td colspan=10>".$keres3."</td></tr>");
Line #336:
Line #337:
Line #338:
Line #339:$napi=true;
Line #340:$aktnap=substr($egy_sor[logtime],0,10);
Line #341:
Line #342:$jelol="*NAPI*";
Line #343:$kiir=false;
Line #344:
Line #345:$puSft=" ";
Line #346:$NapiFt=number_format($egy_sor[ar]);
Line #347:$elojegy=false;
Line #348:$utolso="St";
Line #349:
Line #350:while ( $sorok = mysql_fetch_array( $eredmeny3 ))
Line #351:{
Line #352:
Line #353:
Line #354:IF ($_SESSION[login]=="BI(c)") $ref="<a target=wframe href='BiViewTable.php?&tabla=qj_archive&sql=// widarc=~$sorok[widarc]~ '>".$sorok[wid]."</a>";
Line #355:else $ref="";
Line #356:
Line #357:
Line #358: if (substr($sorok[statusz],0,2)=='El') $elojegy=true;
Line #359:
Line #360: if (substr($sorok[statusz],0,2)=='St' and $elojegy==false and
Line #361: $L_NAP==substr($sorok[logtime],0,10)) $kiir=true;
Line #362:
Line #363: if (substr($sorok[statusz],0,2)=='St' and $elojegy==false and
Line #364: $aktnap<>substr($sorok[printdatum],0,10) and $L_NAP==substr($sorok[logtime],0,10))
Line #365: {
Line #366: $jelol="";
Line #367: $puSft=number_format($egy_sor[ar]);
Line #368: $NapiFt=" ";
Line #369: $napi=false;
Line #370: }
Line #371:
Line #372:
Line #373: if (substr($sorok[statusz],0,2)=='St' and $elojegy==true) $elojegy=false;
Line #374:
Line #375:/*
Line #376: if ($aktnap<>substr($sorok[printdatum],0,10) and substr($sorok[statusz],0,2)<>'El') {
Line #377: $jelol="";
Line #378: $puSft=number_format($egy_sor[ar]);
Line #379: $NapiFt=" ";
Line #380: $napi=false;
Line #381: }
Line #382: if (substr($sorok[statusz],0,2)<>'St') $elojegy=false;
Line #383:*/
Line #384:
Line #385: $utolso=$sorok[statusz];
Line #386:
Line #387:
Line #388:/*////-?-///
Line #389:echo"<tr bgcolor=gold>
Line #390:
Line #391:<td align=right >
Line #392: $sorok[bizomanyos]*** $jelol *** $sorok[statusz]
Line #393:</td>
Line #394:
Line #395:<td align=right >$musor[cim] $musor[datum] $helyinfo</td>
Line #396:<td align=right >".$puSft."</td>
Line #397:<td align=right >".$NapiFt."</td>
Line #398:
Line #399:<td >$ref $aktnap</td>
Line #400:<td >".$sorok[logtime].$jelol."</td>
Line #401:</tr>";
Line #402:////-?-///*/
Line #403:}
Line #404:
Line #405:$dk=$egy_sor[datum_kod];
Line #406:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$dk'";
Line #407:
Line #408:
Line #409:$musor = mysql_fetch_array( $eredmeny3 );
Line #410:
Line #411:$h=$musor[helyszin];
Line #412:$c=$egy_sor[cim];
Line #413:$d=$egy_sor[datum];
Line #414:$wjid=$egy_sor[wid];
Line #415:
Line #416:$rmuv=$egy_sor[statusz];
Line #417:$FormaJel=$egy_sor[FormaJel];
Line #418:$JeBe=$egy_sor[JeBe];
Line #419:
Line #420://if ($_SESSION['login']=="BI(c)") $ref=" <a href=BI_ediTable.php?&wjid=".$egy_sor[widarc]."&sqlfile=qj_jegy>".$egy_sor[wid]."</a>"; else $ref=$egy_sor[widarc];
Line #421:
Line #422:
Line #423:if ($_SESSION['login']=="BI(c)") $ref=" <a href=BiViewTable.php?&wjid=".$egy_sor[widarc]."&sqlfile=qj_jegy>".$egy_sor[wid]."</a>"; else $ref=$egy_sor[widarc];
Line #424:
Line #425:IF ($_SESSION[login]=="BI(c)") $ref="<a target=wframe href='BiViewTable.php?&tabla=qj_archive&sql=// widarc=~$egy_sor[widarc]~ '>".$egy_sor[wid]."</a>";
Line #426:else { $ref=""; $jelol=""; }
Line #427:
Line #428:
Line #429:
Line #430:
Line #431:
Line #432:
Line #433:/*if ($elojegy==false and substr($utolso,0,2)=='St') {
Line #434:
Line #435:$kiir=true;
Line #436:
Line #437:echo"<tr>
Line #438:
Line #439:<td align=right >
Line #440: $i.
Line #441:</td>
Line #442:
Line #443:<td align=right >$musor[cim] $musor[datum] $helyinfo</td>
Line #444:<td align=right >".$puSft."</td>
Line #445:<td align=right >".$NapiFt."</td>
Line #446:
Line #447:<td >$ref</td>
Line #448:<td >".$egy_sor[logtime].$jelol."</td>
Line #449:</tr>";
Line #450:
Line #451:} */
Line #452:
Line #453://if ($napi==false and $elojegy==false and $kiir==true ) {
Line #454:if ($kiir==true ) {
Line #455:
Line #456:if ($napi==false) $stft=$stft+$egy_sor[ar]; ELSE $snft=$snft+$egy_sor[ar];
Line #457:
Line #458:echo"<tr>
Line #459:
Line #460:<td align=right >
Line #461: $i.
Line #462:</td>
Line #463:
Line #464:<td align=right >$musor[cim] $musor[datum] $helyinfo</td>
Line #465:<td align=right >".$puSft."</td>
Line #466:<td align=right >".$NapiFt."</td>
Line #467:
Line #468:<td >$ref</td>
Line #469:<td >".$egy_sor[logtime].$jelol."</td>
Line #470:</tr>";
Line #471:
Line #472:
Line #473:
Line #474: }
Line #475:
Line #476:}
Line #477:
Line #478:
Line #479:$_SESSION[$rmuv]=$stft;
Line #480:
Line #481:echo
Line #482:"<tr bgcolor=silver>
Line #483:
Line #484:<td align=right>
Line #485:".number_format($stft)." Ft</td>
Line #486:
Line #487:".number_format($snft)." Ft</td>
Line #488:</tr> </table>";
Line #489:
Line #490:}
Line #491:
Line #492:
Line #493:
Line #494:$sel = "SELECT * FROM qj_cimlet where bizomanyos='".$_SESSION[L_bizomanyos]."' and szoveg='".$L_NAP."' and widarc>0" ;
Line #495:
Line #496:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #497:
Line #498://echo($sel."<hr>");
Line #499:
Line #500:$nur=mysql_num_rows($sql);
Line #501:if ($nur>0) {
Line #502:
Line #503:
Line #504:
Line #505:echo "<table border=1>
Line #506:<tr bgcolor=silver>
Line #507:
Line #508:
Line #509:
Line #510:
Line #511:
Line #512:
Line #513:</tr>";
Line #514:
Line #515:$_SESSION[ELONY_FT]=0;
Line #516:$_SESSION[ELONYEL_FT]=0;
Line #517:
Line #518:
Line #519:
Line #520:while ( $Csor = mysql_fetch_array( $sql))
Line #521:{
Line #522:
Line #523:
Line #524:if ($Csor[ELONY_FT]+$Csor[ELONYEL_FT]==0) {
Line #525:
Line #526:
Line #527:
Line #528:
Line #529:
Line #530:
Line #531:}
Line #532:
Line #533:
Line #534:$ELONY_FT=$Csor[ELONY_FT];
Line #535:$ELONYEL_FT=$Csor[ELONYEL_FT];
Line #536:
Line #537:if ($Csor[ELONYEL_FT]>0) $ELONY_FT=0;
Line #538:
Line #539:
Line #540:$_SESSION[ELONY_FT]=$_SESSION[ELONY_FT]+$ELONY_FT;
Line #541:$_SESSION[ELONYEL_FT]=$_SESSION[ELONYEL_FT]+$ELONYEL_FT;
Line #542:
Line #543:
Line #544:echo("
Line #545:<tr>
Line #546:<td align=right>".$Csor[widarc]."
Line #547:</td>
Line #548:<td align=right>".number_format($Csor[KPft])."
Line #549:</td>
Line #550:<td align=right>".number_format($Csor[UCS_Ft])."
Line #551:</td>
Line #552:<td align=right>".number_format($Csor[UT_Ft])."
Line #553:</td>
Line #554:<td align=right>".number_format($ELONY_FT)."
Line #555:</td>
Line #556:<td align=right>".number_format($ELONYEL_FT)."
Line #557:</td>
Line #558:<tr>");
Line #559:
Line #560:}}
Line #561:
Line #562:
Line #563:echo"</table>";
Line #564:
Line #565://include("QJ_varlist.php");
Line #566:
Line #567:if (isset($_GET[nyomtat])) {
Line #568:include("QJ_listaveg.php");
Line #569:
Line #570:echo("<body onload='printit()'></body>");
Line #571:
Line #572:?>
Line #573:<SCRIPT Language="Javascript">
Line #574:
Line #575:function printit(){
Line #576:
Line #577:
Line #578:window.print();
Line #579:///////////////////////////////////////
Line #580:window.open("QJ_felad.php", 'sframe');
Line #581:///////////////////////////////////////
Line #582:
Line #583:}
Line #584:</script>
Line #585:<?PHP
Line #586:}
Line #587:
Line #588://~*~// QJ_napi.php
Line #589:?>
Line #590:
Line #591: