Bi-Dir

QQ_napi_MH.inc

Line #0:<?php
Line #1:
Line #2:
Line #3:
Line #4:if (isset($_GET[nyomtat])) {
Line #5:?>
Line #6:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #7:<?PHP
Line #8:} else {
Line #9:$napiADOselect="QJ_napi.php";
Line #10:// IDE NEM KELL include("../_inc_QJ/QC_napiADOselect.inc");
Line #11:}
Line #12:
Line #13:
Line #14:
Line #15:if (isset($_GET[L_nap])) $_SESSION[L_nap]=$_GET[L_nap];
Line #16:if (isset($_GET[L_biz])) $_SESSION[L_bizomanyos]=$_GET[L_biz];
Line #17:
Line #18:$login=$_SESSION['login'];
Line #19:
Line #20:IF (ISSET($_SESSION[L_nap]) and $_SESSION[L_nap]<>"*")
Line #21:$wer1=" and left(logtime,10)='".$_SESSION[L_nap]."'"; else $wer1="";
Line #22:
Line #23:IF (ISSET($_SESSION[L_bizomanyos]) and $_SESSION[L_bizomanyos]<>"*")
Line #24:$login=$_SESSION[L_bizomanyos];
Line #25:
Line #26:$wer2=" and bizomanyos='".$login."'";
Line #27:
Line #28:$nocheck="F";
Line #29:
Line #30:IF ($_SESSION[L_bizomanyos]=="*" or $_SESSION[L_bizomanyos]=="0" ) { $nocheck="Y"
Line #31:; $wer2=""; }
Line #32:
Line #33:
Line #34:if ($_SESSION['admin']=="ADMIN") $nev=$login; else $nev=$_SESSION['login_nev'];
Line #35:
Line #36:$szin="";
Line #37:$i=0;
Line #38:$ft=0;
Line #39:$nap="?";
Line #40:$ri=0;
Line #41:$rft=0;
Line #42:$rmuv="?";
Line #43:
Line #44:$wi=0;
Line #45:$wft=0;
Line #46:$rlog="?";
Line #47:$hiba="";
Line #48:
Line #49://$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 #50:
Line #51://$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] or $_SESSION[SQL_storno]) $wer1 $wer2 ORDER BY logtime DESC";
Line #52:
Line #53:$wer3=" and left(bizonylatszam,3)<>'BH:' ";
Line #54://///// szinkron hiba MIATT EF11
Line #55:
Line #56:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $wer3 $wer1 $wer2 ORDER BY logtime DESC";
Line #57:
Line #58://?//echo ($parancs."<hr>");
Line #59:
Line #60:
Line #61:
Line #62:$kegy_sor = mysql_fetch_array( $keredmeny );
Line #63:$Pnap=substr($kegy_sor[logtime],0,10);
Line #64:$rmuv=$kegy_sor[statusz];
Line #65:
Line #66:$nap=substr($kegy_sor[logtime],0,10);
Line #67:$wer1=" and left(logtime,10)='".$nap."'";
Line #68:
Line #69:if ($_SESSION[L_nap]==" " or !isset($_SESSION[L_nap])) {
Line #70: $_SESSION[L_nap]=$nap;
Line #71: $_SESSION[L_bizomanyos]=$kegy_sor[bizomanyos];
Line #72:}
Line #73:
Line #74:
Line #75:
Line #76:$_SESSION[Pnap]=$Pnap;
Line #77:$L_NAP=$_SESSION[L_nap];
Line #78:$L_user=$_SESSION[L_bizomanyos];
Line #79:
Line #80:
Line #81:
Line #82:$L_PHP="QJ_napi.php";
Line #83:include("QJ_listafej.php");
Line #84:
Line #85:/*
Line #86:if ($_SESSION[QC_adoszam]<>"*") {
Line #87: $_SESSION[L_adoszam]=$_SESSION[QC_adoszam];
Line #88:
Line #89:
Line #90:
Line #91:$keres = "SELECT * FROM qj_musor where future<>'*' $_SESSION[QC_adoWER]";
Line #92:
Line #93:$musor=mysql_fetch_array($meredmeny);
Line #94:
Line #95://?//if ($_SESSION[QC_adoszam]<>"") {
Line #96://?// $sajat=$musor[cimkieg3];
Line #97:
Line #98://?//} else
Line #99:
Line #100://?//}
Line #101:*/
Line #102:
Line #103:
Line #104:echo "<table border=0>
Line #105:<tr bgcolor=silver>
Line #106:<td align=right >Ssz.</td>
Line #107:
Line #108:
Line #109:
Line #110:
Line #111:
Line #112:
Line #113:</tr>";
Line #114:
Line #115:
Line #116://$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 #117:
Line #118://$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 #119:
Line #120://$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] or $_SESSION[SQL_storno]) $wer1 $wer2 ORDER BY statusz,bizonylatszam DESC";
Line #121:
Line #122:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $_SESSION[QC_adoWER]
Line #123: $wer1 $wer2 $wer3 ORDER BY statusz,bizonylatszam DESC";
Line #124://?//echo ($parancs."<hr>");
Line #125:
Line #126:
Line #127:
Line #128:$nurJ=mysql_num_rows($eredmeny);
Line #129:
Line #130:if ($nurJ==0 or $_SESSION[L_nap]<>$_SESSION[QL_nap] or $_SESSION[L_bizomanyos]<>$_SESSION[QL_bizomanyos] ) {
Line #131: $_SESSION[QL_nap]=$_SESSION[L_nap];
Line #132: $_SESSION[QL_bizomanyos]=$_SESSION[L_bizomanyos];
Line #133:
Line #134:
Line #135:
Line #136:
Line #137: unset($_SESSION['Protokoll']);
Line #138:
Line #139:}
Line #140:
Line #141:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #142:{
Line #143:
Line #144:if ($i==0) {
Line #145: $rmuv=$egy_sor[statusz];
Line #146: $nap=substr($egy_sor[logtime],0,10);
Line #147: $rlog=$egy_sor[bizonylatszam];
Line #148:}
Line #149:
Line #150:if ($rlog<>$egy_sor[bizonylatszam] and $nocheck<>"Y" ){
Line #151:
Line #152://$bsz=$egy_sor[bizonylatszam];
Line #153:$keres3 ="SELECT * FROM qj_jlog where wid='$rlog'";
Line #154:
Line #155:$nur=mysql_num_rows($eredmeny3);
Line #156:$logsor = mysql_fetch_array( $eredmeny3 );
Line #157:if ($nur>0 and $login==$logsor[bizomanyos] and $wft==$logsor[OSSZft]) $hiba="gold"; else $hiba="red";
Line #158:
Line #159:
Line #160:/*IF ($_SESSION[admin]=="ADMIN") $rel="<a href=QJ_analitika.php?&bizonylat=".$rlog.">".$rlog."</a>";
Line #161:else $rel=$rlog;*/
Line #162:
Line #163:IF ($_SESSION[admin]=="ADMIN") $rel="<a href=QJ_cimletez.php?&wjid=".$rlog.">".$rlog."</a>";
Line #164:else $rel=$rlog;
Line #165:
Line #166:
Line #167:
Line #168:echo"<tr>
Line #169:
Line #170:
Line #171:</td>
Line #172:
Line #173:<td colspan=2 align=right bgcolor=azure>".number_format($wft)."</td>
Line #174:<td bgcolor=azure> Ft</td>
Line #175:<td align=right bgcolor=azure>$wi 
Line #176: </td>
Line #177:
Line #178:<td colspan=2 align=left bgcolor=azure> Db</td>
Line #179:<td colspan=2 align=right bgcolor=$hiba>".number_format($logsor[osszft])."</td>
Line #180:<td align=right bgcolor=$hiba>$logsor[osszdb] 
Line #181: </td>
Line #182:
Line #183:
Line #184:</tr>";
Line #185:
Line #186:
Line #187:$rlog=$egy_sor[bizonylatszam];
Line #188:
Line #189:$wi=0;
Line #190:$wft=0;
Line #191:
Line #192:}
Line #193:
Line #194:
Line #195:
Line #196:$ref="";
Line #197:if ($egy_sor[bizonylatszam]=="" ) $ref="".$egy_sor[wid]." Adat hiba !!!";
Line #198:if ($_SESSION['login']=="BI(c)") $ref.=" <a href=BI_ediTable.php?&wjid=".$egy_sor[wid]."&sqlfile=qj_jegy>".$egy_sor[wid]."</a>";
Line #199:
Line #200:if ($rmuv<>$egy_sor[statusz] ){
Line #201:
Line #202:echo"<tr>
Line #203:
Line #204:<td colspan=2 align=right bgcolor=silver>
Line #205:
Line #206:</td>
Line #207:
Line #208:<td colspan=2 align=right bgcolor=silver> ".number_format($rft)."</td>
Line #209:<td bgcolor=silver> Ft</td>
Line #210:<td align=right bgcolor=silver>$ri 
Line #211: </td>
Line #212:<td colspan=2 align=left bgcolor=silver> Db</td>
Line #213:</tr>";
Line #214:
Line #215:////////////////////
Line #216:
Line #217:////////////////////
Line #218:$_SESSION[$rmuv]=$rft;
Line #219:
Line #220:$ri=0;
Line #221:$rft=0;
Line #222:
Line #223:$rmuv=$egy_sor[statusz];
Line #224:
Line #225:}
Line #226:
Line #227:// ($nap==substr($egy_sor[logtime],0,10)) {
Line #228:
Line #229:++$i;
Line #230:++$ri;
Line #231:$rft=$rft+$egy_sor[ar];
Line #232:$ft =$ft+$egy_sor[ar];
Line #233:
Line #234:
Line #235:++$wi;
Line #236:$wft=$wft+$egy_sor[ar];
Line #237:
Line #238:$dk=$egy_sor[datum_kod];
Line #239:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$dk'";
Line #240:
Line #241:
Line #242:$musor = mysql_fetch_array( $eredmeny3 );
Line #243:
Line #244:$h=$musor[helyszin];
Line #245:$c=$egy_sor[cim];
Line #246:$d=$egy_sor[datum];
Line #247:$wjid=$egy_sor[wid];
Line #248:
Line #249:$FormaJel=$egy_sor[FormaJel];
Line #250:$JeBe=$egy_sor[JeBe];
Line #251:
Line #252:
Line #253:
Line #254:echo"<tr>
Line #255:
Line #256:<td align=right >
Line #257: $i.
Line #258:</td>
Line #259:
Line #260:<td align=right >$musor[cim] $musor[datum] $helyinfo</td>
Line #261:<td align=right >$musor[JeBe] $egy_sor[ar_nev]</td>
Line #262:<td align=right >".number_format($egy_sor[ar])."</td>
Line #263:<td >$egy_sor[statusz]</td>
Line #264:<td >$egy_sor[bizonylatszam]$ref</td>
Line #265:<td >".substr($egy_sor[logtime],-8)."</td>
Line #266:</tr>";
Line #267:$szin="";
Line #268://<td >".substr($egy_sor[logtime],-8)."</td>
Line #269://<td >".$egy_sor[logtime].$egy_sor[bizomanyos]."</td>
Line #270://<td >".$egy_sor[logtime].$egy_sor[bizomanyos].$ft."</td>
Line #271:
Line #272://}
Line #273:
Line #274:}
Line #275:
Line #276:
Line #277:
Line #278:$keres3 ="SELECT * FROM qj_jlog where wid='$rlog'";
Line #279:
Line #280:$nur=mysql_num_rows($eredmeny3);
Line #281:$logsor = mysql_fetch_array( $eredmeny3 );
Line #282:if ($nur>0 and $login==$logsor[bizomanyos] and $wft==$logsor[osszft]) $hiba="gold"; else $hiba="red";
Line #283:
Line #284:
Line #285:IF ($_SESSION[admin]=="ADMIN") $rel="<a href=QJ_analitika.php?&bizonylat=".$rlog.">".$rlog."</a>";
Line #286:else $rel=$rlog;
Line #287:
Line #288:
Line #289:echo"<tr>
Line #290:
Line #291:
Line #292:</td>
Line #293:
Line #294:<td colspan=2 align=right bgcolor=azure>".number_format($wft)."</td>
Line #295:<td bgcolor=azure> Ft</td>
Line #296:<td align=right bgcolor=azure>$wi 
Line #297: </td>
Line #298:
Line #299:<td colspan=2 align=left bgcolor=azure> Db</td>
Line #300:<td colspan=2 align=right bgcolor=$hiba>".number_format($logsor[osszft])."</td>
Line #301:<td align=right bgcolor=$hiba>$logsor[osszdb] 
Line #302: </td>
Line #303:
Line #304:
Line #305:</tr>";
Line #306:
Line #307:/*
Line #308:echo"<tr>
Line #309:
Line #310:
Line #311:</td>
Line #312:
Line #313:<td colspan=2 align=right bgcolor=silver>".number_format($wft)."</td>
Line #314:<td bgcolor=silver> Ft</td>
Line #315:<td align=right bgcolor=silver>$wi 
Line #316: </td>
Line #317:
Line #318:<td colspan=2 align=left bgcolor=silver> Db</td>
Line #319:<td colspan=2 align=right bgcolor=$hiba>".number_format($logsor[osszft])."</td>
Line #320:<td align=right bgcolor=$hiba>$logsor[osszdb] 
Line #321: </td>
Line #322:</tr>"; */
Line #323:
Line #324:////////////////////
Line #325:
Line #326:////////////////////
Line #327:$_SESSION[$rmuv]=$rft;
Line #328:
Line #329:if ($ft>0)
Line #330:echo"<tr>
Line #331:
Line #332:
Line #333:</td>
Line #334:
Line #335:<td colspan=2 align=right bgcolor=silver>".number_format($rft)."</td>
Line #336:<td bgcolor=silver> Ft</td>
Line #337:<td align=right bgcolor=silver>$ri 
Line #338: </td>
Line #339:<td colspan=2 align=left bgcolor=silver> Db</td>
Line #340:</tr>";
Line #341:
Line #342:
Line #343:$_SESSION[OSSZft]=$ft;
Line #344:$_SESSION[OSSZdb]=$i;
Line #345:
Line #346:
Line #347:
Line #348:
Line #349:echo"<tr>
Line #350:
Line #351:</td>
Line #352:<td colspan=2 align=right bgcolor=silver>"
Line #353:.number_format($ft)."</td>
Line #354:<td bgcolor=silver> Ft</td>
Line #355:<td align=right bgcolor=silver>$i 
Line #356: </td>
Line #357:<td colspan=2 align=left bgcolor=silver> Db</td>
Line #358:</tr>";
Line #359:
Line #360:echo"</table>";
Line #361:
Line #362:
Line #363:////////////////////////////////////////////////////
Line #364:
Line #365:////////////////////////////////////////////////////
Line #366:$i=0;
Line #367:$stft=0;
Line #368:
Line #369:$alama=="Y";
Line #370:if ($alama=="N") {
Line #371://$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] or $_SESSION[SQL_storno]) $wer1 $wer2 ORDER BY statusz,bizonylatszam DESC";
Line #372:
Line #373:$wer1=" and left(logtime,10)='".$_SESSION[L_nap]."'";
Line #374:$parancs="SELECT * FROM qj_archive where left(statusz,2)='St' $wer1 $wer2 ORDER BY statusz,bizonylatszam DESC";
Line #375://?//echo ($parancs."<hr>");
Line #376:
Line #377:
Line #378:$nur=mysql_num_rows($eredmeny);
Line #379:if ($nur>0) {
Line #380:
Line #381:
Line #382:echo "<table border=1>
Line #383:<tr bgcolor=silver>
Line #384:<td >Sorsz.</td>
Line #385:
Line #386:
Line #387:
Line #388:
Line #389:
Line #390:
Line #391:</tr>";
Line #392:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #393:{
Line #394:
Line #395:
Line #396:$widarc=$egy_sor[widarc];
Line #397:$keres3 = "SELECT * FROM qj_archive WHERE widarc='$widarc' and left(statusz,2)<>'El' order by Logtime ";
Line #398:$keres3 = "SELECT * FROM qj_archive WHERE widarc='$widarc' and left(fizmod,2)<>'El' $wer2 order by Logtime ";
Line #399: //*********************// 2014.01.22. 3:08:38 FONTOS !!!
Line #400:
Line #401:
Line #402:
Line #403:
Line #404:$napi=true;
Line #405:$aktnap=substr($egy_sor[logtime],0,10);
Line #406:
Line #407:$jelol="*NAPI*";
Line #408:
Line #409:$puSft=" ";
Line #410:$NapiFt=number_format($egy_sor[ar]);
Line #411:$elojegy=true;
Line #412:$utolso="St";
Line #413:
Line #414:while ( $sorok = mysql_fetch_array( $eredmeny3 ))
Line #415:{
Line #416: if ($aktnap<>substr($sorok[logtime],0,10) and substr($sorok[statusz],0,2)<>'El') {
Line #417: $jelol="";
Line #418: $puSft=number_format($egy_sor[ar]);
Line #419: $NapiFt=" ";
Line #420: $napi=false;
Line #421: }
Line #422: if (substr($sorok[statusz],0,2)<>'St') $elojegy=false;
Line #423: $utolso=$sorok[statusz];
Line #424:
Line #425:}
Line #426:
Line #427:$dk=$egy_sor[datum_kod];
Line #428:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$dk'";
Line #429:
Line #430:
Line #431:$musor = mysql_fetch_array( $eredmeny3 );
Line #432:
Line #433:$h=$musor[helyszin];
Line #434:$c=$egy_sor[cim];
Line #435:$d=$egy_sor[datum];
Line #436:$wjid=$egy_sor[wid];
Line #437:
Line #438:$rmuv=$egy_sor[statusz];
Line #439:$FormaJel=$egy_sor[FormaJel];
Line #440:$JeBe=$egy_sor[JeBe];
Line #441:
Line #442://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 #443: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 #444:
Line #445://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 #446:IF ($_SESSION[login]=="BI(c)")
Line #447:$ref="<a target=wframe href='BiViewTable.php?&tabla=qj_archive&sql=// widarc=~$egy_sor[widarc]~ '>".$egy_sor[wid].
Line #448:" <a target=infoframe href='QQ_reSTORNO.php?&widarc=".$egy_sor[widarc]."'>reStrono:".$egy_sor[widarc]."</a></a>";
Line #449:else { $ref=""; $jelol=""; }
Line #450:
Line #451:
Line #452:
Line #453:
Line #454:$kiir=false;
Line #455:
Line #456:if ($elojegy==false and substr($utolso,0,2)=='St') {
Line #457:
Line #458:$kiir=true;
Line #459:++$i;
Line #460:
Line #461:echo"<tr>
Line #462:
Line #463:<td align=right >
Line #464: $i.
Line #465:</td>
Line #466:
Line #467:<td align=right >$musor[cim] $musor[datum] $helyinfo</td>
Line #468:<td align=right >".$puSft."</td>
Line #469:<td align=right >".$NapiFt."</td>
Line #470:
Line #471:<td >$ref</td>
Line #472:<td >".$egy_sor[logtime].$jelol."</td>
Line #473:</tr>";
Line #474:
Line #475:}
Line #476:
Line #477:if ($napi==false and $elojegy==false and $kiir==true ) {
Line #478:
Line #479:$stft=$stft+$egy_sor[ar];
Line #480:
Line #481:/*
Line #482:echo"<tr>
Line #483:
Line #484:<td align=right >
Line #485: $i.
Line #486:</td>
Line #487:
Line #488:<td align=right >$musor[cim] $musor[datum] $helyinfo</td>
Line #489:<td align=right >".$puSft."</td>
Line #490:<td align=right >".$NapiFt."</td>
Line #491:
Line #492:<td >$ref</td>
Line #493:<td >".$egy_sor[logtime].$jelol."</td>
Line #494:</tr>";
Line #495:*/
Line #496:
Line #497:
Line #498: }
Line #499:
Line #500:}
Line #501:
Line #502:
Line #503:////////////////////
Line #504:
Line #505:////////////////////
Line #506:$_SESSION[$rmuv]=$stft;
Line #507:
Line #508:echo
Line #509:"<tr bgcolor=silver>
Line #510:
Line #511:<td align=right>
Line #512:".number_format($stft)."</td>
Line #513:<td align=left colspan=3> Ft</td>
Line #514:</tr> </table>";
Line #515:
Line #516:}
Line #517:
Line #518:}
Line #519:
Line #520:
Line #521:echo "<table border=1>
Line #522:<tr bgcolor=silver>
Line #523:<td align=right >Ssz.</td>
Line #524:<td align=right width=150 >Hely</td>
Line #525:
Line #526:
Line #527:<td align=right width=50>Technikai</td>
Line #528:
Line #529:
Line #530:<td align=right width=50>Eladva</td>
Line #531:</tr>";
Line #532:
Line #533:
Line #534:
Line #535:$oPft=0;
Line #536:$oTft=0;
Line #537:
Line #538:$szin="";
Line #539:$i=0;
Line #540:$ft=0;
Line #541:$nap="?";
Line #542:$ri=0;
Line #543:$rft=0;
Line #544:$rmuv="?";
Line #545:
Line #546:$wi=0;
Line #547:$wft=0;
Line #548:$rlog="?";
Line #549:$hiba="";
Line #550:
Line #551:
Line #552:$parancs="SELECT * FROM qj_archive where left(statusz,2)='St' and left(Konyveljel,2)<>'El' $wer1 $wer2 ORDER BY logtime DESC";
Line #553://?//echo ($parancs."<hr>");
Line #554:
Line #555:
Line #556:
Line #557:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #558:{
Line #559:
Line #560:
Line #561:++$i;
Line #562:++$ri;
Line #563:$rft=$rft+$egy_sor[ar];
Line #564:$ft =$ft+$egy_sor[ar];
Line #565:
Line #566:$foglalta=$egy_sor[foglalta];
Line #567:$bizomanyos=$egy_sor[bizomanyos];
Line #568:$eladate=substr($egy_sor[Konyvel],0,10);
Line #569:$logdate=substr($egy_sor[logtime],0,10);
Line #570:
Line #571:++$wi;
Line #572:$wft=$wft+$egy_sor[ar];
Line #573:
Line #574:$dk=$egy_sor[datum_kod];
Line #575:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$dk'";
Line #576:
Line #577:
Line #578:$musor = mysql_fetch_array( $eredmeny3 );
Line #579:
Line #580:$h=$musor[helyszin];
Line #581:$c=$egy_sor[cim];
Line #582:$d=$egy_sor[datum];
Line #583:$wjid=$egy_sor[wid];
Line #584:
Line #585:$FormaJel=$egy_sor[FormaJel];
Line #586:$JeBe=$egy_sor[JeBe];
Line #587:
Line #588:if ($_SESSION['login']=="BI(c)")
Line #589:$ref="<a target=infoframe href=BI_ediTable.php?&wjid=".$egy_sor[wid]."&sqlfile=qj_archive>".$egy_sor[wid]."</a>";
Line #590:else
Line #591:$ref=$i;
Line #592:
Line #593:$penzugyi=0;
Line #594:$technikai=0;;
Line #595:
Line #596:if ($foglalta<>$bizomanyos or $eladate<>$logdate)
Line #597:$penzugyi=$egy_sor[ar]; else
Line #598:$technikai=$egy_sor[ar];
Line #599:
Line #600:$oPft=$oPft+$penzugyi;
Line #601:$oTft=$oTft+$technikai;
Line #602:
Line #603:if ($musor[erkezesi]=="Y" or $egy_sor[erkezesi]=="SY" )
Line #604:
Line #605:
Line #606:echo"<tr>
Line #607:
Line #608:<td align=right >
Line #609:Gysz:$egy_sor[bizonylatszam] $ref.
Line #610:</td>
Line #611:
Line #612:<td align=right >$musor[helyszin]$helyinfo</td>
Line #613:<td align=right >$musor[cim]   $musor[datum]</td>
Line #614:
Line #615:<td align=right >".$penzugyi."</td>
Line #616:<td align=right >".$technikai."</td>
Line #617:<td align=right >$egy_sor[Konyveljel]</td>
Line #618:<td align=right >".$foglalta." ".$egy_sor[Konyvel]."</td>
Line #619:<td align=right >".$bizomanyos." ".$egy_sor[logtime]."</td>
Line #620:</tr>";
Line #621:$szin="";
Line #622:
Line #623:}
Line #624:
Line #625:
Line #626:echo"<tr>
Line #627:
Line #628:</td>
Line #629:<td align=right bgcolor=silver>"
Line #630:.number_format($oPft)."</td>
Line #631:<td align=right bgcolor=silver>"
Line #632:.number_format($oTft)."</td>
Line #633:<td align=right bgcolor=silver>$i 
Line #634: </td>
Line #635:<td colspan=2 align=left bgcolor=silver> Db</td>
Line #636:</tr>";
Line #637:
Line #638:echo"</table>";
Line #639:
Line #640:
Line #641:$_SESSION[$rmuv]=$oPft;
Line #642:
Line #643:////////////////////////////////
Line #644:
Line #645:$sel = "SELECT * FROM qj_cimlet where bizomanyos='".$_SESSION[L_bizomanyos]."' and szoveg='".$L_NAP."' and widarc>0" ;
Line #646:
Line #647:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #648:
Line #649://echo($sel."<hr>");
Line #650:
Line #651:$nur=mysql_num_rows($sql);
Line #652:if ($nur>0) {
Line #653:
Line #654:
Line #655:
Line #656:echo "<table border=1>
Line #657:<tr bgcolor=silver>
Line #658:
Line #659:
Line #660:
Line #661:
Line #662:
Line #663:
Line #664:
Line #665:</tr>";
Line #666:
Line #667:$_SESSION['Kedv_Ft']=0;
Line #668:$_SESSION[ELONY_FT]=0;
Line #669:$_SESSION[ELONYEL_FT]=0;
Line #670:$_SESSION['Utalvany']=0;
Line #671:$_SESSION['Udulesicsekk']=0;
Line #672:
Line #673:while ( $Csor = mysql_fetch_array( $sql))
Line #674:{
Line #675:
Line #676:
Line #677:if ($Csor[Kedv_Ft]<>0) {
Line #678: $_SESSION['Kedv_Ft']=$_SESSION['Kedv_Ft']+$Csor[Kedv_Ft];
Line #679:
Line #680: $_SESSION[Keszpenzes]=$_SESSION[Keszpenzes]-$Csor[Kedv_Ft];
Line #681:}
Line #682:
Line #683:if ($Csor[ELONY_FT]+$Csor[ELONYEL_FT]==0) {
Line #684://$_SESSION[Keszpenzes]=$_SESSION[Keszpenzes]+$Csor[KPft]-$Csor[UT_Ft];
Line #685:
Line #686:$_SESSION[Keszpenzes]=$_SESSION[Keszpenzes]-$Csor[UT_Ft];
Line #687://$_SESSION['Udulesicsekk']=$_SESSION['Udulesicsekk']-$Csor[KPft];
Line #688:$_SESSION['Udulesicsekk']=$_SESSION['Udulesicsekk']+$Csor[UCS_Ft];
Line #689:$_SESSION['Utalvany']=$_SESSION['Utalvany']+$Csor[UT_Ft];
Line #690:}
Line #691:
Line #692:
Line #693:$ELONY_FT=$Csor[ELONY_FT];
Line #694:$ELONYEL_FT=$Csor[ELONYEL_FT];
Line #695:
Line #696:if ($Csor[ELONYEL_FT]>0) $ELONY_FT=0;
Line #697:
Line #698:
Line #699:$_SESSION[ELONY_FT]=$_SESSION[ELONY_FT]+$ELONY_FT;
Line #700:$_SESSION[ELONYEL_FT]=$_SESSION[ELONYEL_FT]+$ELONYEL_FT;
Line #701:
Line #702:
Line #703:echo("
Line #704:<tr>
Line #705:<td align=right>".$Csor[widarc]."
Line #706:</td>
Line #707:<td align=right>".number_format($Csor[KPft])."
Line #708:</td>
Line #709:<td align=right>".number_format($Csor[UCS_Ft])."
Line #710:</td>
Line #711:<td align=right>".number_format($Csor[UT_Ft])."
Line #712:</td>
Line #713:<td align=right>".number_format($Csor[Kedv_Ft])."
Line #714:</td>
Line #715:<td align=right>".number_format($ELONY_FT)."
Line #716:</td>
Line #717:<td align=right>".number_format($ELONYEL_FT)."
Line #718:</td>
Line #719:<tr>");
Line #720:
Line #721:}}
Line #722:
Line #723:
Line #724:
Line #725:
Line #726:
Line #727:$sel = "SELECT * FROM qj_jlog where bizomanyos='".$_SESSION[L_bizomanyos]."' and ELONYOMTAT='R' and ELONY_DATE='".$L_NAP."'" ;
Line #728:
Line #729:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #730:
Line #731://echo($sel."<hr>");
Line #732:
Line #733:$nur=mysql_num_rows($sql);
Line #734:if ($nur>0) {
Line #735:
Line #736:
Line #737:
Line #738:echo "<table border=1>
Line #739:<tr bgcolor=silver>
Line #740:
Line #741:<td align=right >Kelt:</td>
Line #742:
Line #743:
Line #744:
Line #745:
Line #746:
Line #747:</tr>";
Line #748:
Line #749:$_SESSION[ELONY_FT]=0;
Line #750:
Line #751:while ( $Csor = mysql_fetch_array( $sql))
Line #752:{
Line #753:
Line #754:
Line #755:$hatralek=$Csor[osszft]-$Csor[Reszlet1];
Line #756:if ($hatralek<>0) {
Line #757:// $_SESSION[ELONY_FT]=$_SESSION[ELONY_FT]+$Csor[Reszlet1];
Line #758:// $_SESSION[Keszpenzes]=$_SESSION[Keszpenzes]-$hatralek;
Line #759: $_SESSION[ELONY_FT]=$_SESSION[ELONY_FT]+$hatralek;
Line #760: // $_SESSION[Keszpenzes]=$_SESSION[Keszpenzes]-$hatralek;
Line #761:}
Line #762:
Line #763:
Line #764:echo("
Line #765:<tr>
Line #766:<td align=right>".$Csor[wid]."
Line #767:</td>
Line #768:<td align=right>".$Csor[logtime]."
Line #769:</td>
Line #770:<td align=right>".number_format($Csor[osszft])."
Line #771:</td>
Line #772:<td align=right>".number_format($Csor[Reszlet1])."
Line #773:</td>
Line #774:<td align=right>".number_format($Csor[osszft]-$Csor[Reszlet1])."
Line #775:</td>
Line #776:<td align=right>".$Csor[Reszlet1No]."
Line #777:</td>
Line #778:<td align=right>".$Csor[ReszletDate]."
Line #779:</td>
Line #780:<tr>");
Line #781:
Line #782:}}
Line #783:
Line #784:///////////////////////
Line #785:
Line #786:
Line #787:echo"</table>";
Line #788:
Line #789://include("QJ_varlist.php");
Line #790:
Line #791:if (isset($_GET[nyomtat])) {
Line #792:include("QJ_listaveg.php");
Line #793:
Line #794:echo("<body onload='printit()'></body>");
Line #795:
Line #796:?>
Line #797:<SCRIPT Language="Javascript">
Line #798:
Line #799:function printit(){
Line #800:
Line #801:
Line #802:window.print();
Line #803:///////////////////////////////////////
Line #804:window.open("QJ_felad.php", 'sframe');
Line #805:///////////////////////////////////////
Line #806:
Line #807:}
Line #808:</script>
Line #809:<?PHP
Line #810:}
Line #811:
Line #812://~*~// QJ_napi.php
Line #813:?>
Line #814:
Line #815: