Bi-Dir

QQ_napi_EF.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://$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] or $_SESSION[SQL_storno]) $wer1 $wer2 ORDER BY statusz,bizonylatszam DESC";
Line #365:
Line #366:
Line #367:$wer1=" and left(logtime,10)='".$_SESSION[L_nap]."'";
Line #368:$parancs="SELECT * FROM qj_archive where left(statusz,2)='St' $wer1 $wer2 ORDER BY statusz,bizonylatszam DESC";
Line #369://?//
Line #370:
Line #371:if (isset($_SESSION['Dump'])) echo ($parancs."<hr>");
Line #372:
Line #373:
Line #374:$nur=mysql_num_rows($eredmeny);
Line #375:if ($nur>0) {
Line #376:
Line #377:
Line #378:
Line #379:
Line #380:
Line #381:echo "<table border=1>
Line #382:<tr bgcolor=silver>
Line #383:<td >Sorsz.</td>
Line #384:
Line #385:<td align=right >$kiegfej2</td>
Line #386:
Line #387:
Line #388:
Line #389:
Line #390:</tr>";
Line #391:$i=0;
Line #392:$stft=0;
Line #393:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #394:{
Line #395:++$i;
Line #396:
Line #397:
Line #398:if (isset($_SESSION['Dump'])) echo ($i."/".$egy_sor[widarc]."/".$egy_sor[logtime]."/".$egy_sor[datum_kod]."/".$egy_sor[bizomanyos]."/".$egy_sor[status]."/".$egy_sor[ar]."/"."<hr>");
Line #399:
Line #400:$widarc=$egy_sor[widarc];
Line #401:$keres3 = "SELECT * FROM qj_archive WHERE widarc='$widarc' and left(statusz,2)<>'El' order by Logtime ";
Line #402:
Line #403:
Line #404:$keres3 = "SELECT * FROM qj_archive WHERE widarc='$widarc' and left(statusz,2)<>'El' $wer2 order by Logtime ";
Line #405:$keres3 = "SELECT * FROM qj_archive WHERE widarc='$widarc' and left(fizmod,2)<>'El' $wer2 order by Logtime ";
Line #406: //*********************// 2014.01.22. 3:08:38 FONTOS !!!
Line #407:
Line #408:if (isset($_SESSION['Dump'])) echo ($keres3."<hr>");
Line #409:
Line #410:
Line #411:
Line #412:$nurST=mysql_num_rows($eredmeny3);
Line #413:$napi=true;
Line #414:$aktnap=substr($egy_sor[logtime],0,10);
Line #415://$aktnap="0000-00-00";
Line #416:$jelol="*NAPI*";
Line #417:
Line #418:$puSft=" ";
Line #419:$NapiFt=number_format($egy_sor[ar]);
Line #420:$elojegy=true;
Line #421:$utolso="St";
Line #422:
Line #423:while ( $sorok = mysql_fetch_array( $eredmeny3 ))
Line #424:{
Line #425:
Line #426:if (isset($_SESSION['Dump'])) echo ($aktnap." *** ".$sorok[widarc]."/".$sorok[logtime]."/".$sorok[datum_kod]."/".$sorok[bizomanyos]."/".$sorok[statusz]."/".$sorok[ar]."/"."<hr>");
Line #427:
Line #428:
Line #429:// if ($aktnap<>substr($sorok[logtime],0,10) and substr($sorok[statusz],0,2)<>'El' and $sorok[bizomanyos]<>"Malom") {
Line #430: if (($nurST==1 and substr($sorok[statusz],0,2)<>'El') or
Line #431: ($aktnap<>substr($sorok[logtime],0,10) and substr($sorok[statusz],0,2)<>'El')
Line #432: or $sorok[bizomanyos]=="Malom") {
Line #433:
Line #434: $jelol="";
Line #435: $puSft=number_format($egy_sor[ar]);
Line #436: $NapiFt=" ";
Line #437: $napi=false;
Line #438: }
Line #439: //?//2014.01.22. 2:46:16 if (substr($sorok[statusz],0,2)<>'St') $elojegy=false;
Line #440: $elojegy=false;
Line #441: $utolso=$sorok[statusz];
Line #442:
Line #443:}
Line #444:
Line #445:$dk=$egy_sor[datum_kod];
Line #446:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$dk'";
Line #447:if (isset($_SESSION['Dump'])) echo ($keres3."<hr>");
Line #448:
Line #449:
Line #450:$musor = mysql_fetch_array( $eredmeny3 );
Line #451:
Line #452:$h=$musor[helyszin];
Line #453:$c=$egy_sor[cim];
Line #454:$d=$egy_sor[datum];
Line #455:$wjid=$egy_sor[wid];
Line #456:
Line #457:$rmuv=$egy_sor[statusz];
Line #458:$FormaJel=$egy_sor[FormaJel];
Line #459:$JeBe=$egy_sor[JeBe];
Line #460:
Line #461://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 #462: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 #463:
Line #464://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 #465:IF ($_SESSION[login]=="BI(c)")
Line #466:$ref="<a target=wframe href='BiViewTable.php?&tabla=qj_archive&sql=// widarc=~$egy_sor[widarc]~ '>".$egy_sor[wid].
Line #467:" <a target=infoframe href='QQ_reSTORNO.php?&widarc=".$egy_sor[widarc]."'>reStrono:".$egy_sor[widarc]."</a></a>";
Line #468:else { $ref=""; $jelol=""; }
Line #469:
Line #470:
Line #471:
Line #472:
Line #473:$kiir=false;
Line #474:
Line #475:if ($elojegy==false and substr($utolso,0,2)=='St') {
Line #476:
Line #477:$kiir=true;
Line #478:
Line #479:echo"<tr>
Line #480:
Line #481:<td align=right >
Line #482: $i.
Line #483:</td>
Line #484:
Line #485:<td align=right >$musor[cim] $musor[datum] $helyinfo</td>
Line #486:<td align=right >".$puSft."</td>
Line #487:<td align=right >".$NapiFt."</td>
Line #488:
Line #489:<td >$ref</td>
Line #490:<td >".$egy_sor[logtime].$jelol."</td>
Line #491:</tr>";
Line #492:
Line #493:}
Line #494:
Line #495:if ($napi==false and $elojegy==false and $kiir==true ) {
Line #496:
Line #497:$stft=$stft+$egy_sor[ar];
Line #498:
Line #499:/*
Line #500:echo"<tr>
Line #501:
Line #502:<td align=right >
Line #503: $i.
Line #504:</td>
Line #505:
Line #506:<td align=right >$musor[cim] $musor[datum] $helyinfo</td>
Line #507:<td align=right >".$puSft."</td>
Line #508:<td align=right >".$NapiFt."</td>
Line #509:
Line #510:<td >$ref</td>
Line #511:<td >".$egy_sor[logtime].$jelol."</td>
Line #512:</tr>";
Line #513:*/
Line #514:
Line #515:
Line #516: }
Line #517:
Line #518:}
Line #519:
Line #520:
Line #521:////////////////////
Line #522:
Line #523:////////////////////
Line #524:$_SESSION[$rmuv]=$stft;
Line #525:
Line #526:echo
Line #527:"<tr bgcolor=silver>
Line #528:
Line #529:<td align=right>
Line #530:".number_format($stft)."</td>
Line #531:<td align=left colspan=3> Ft</td>
Line #532:</tr> </table>";
Line #533:
Line #534:}
Line #535:
Line #536:
Line #537:
Line #538:$sel = "SELECT * FROM qj_cimlet where bizomanyos='".$_SESSION[L_bizomanyos]."' and szoveg='".$L_NAP."' and widarc>0" ;
Line #539:
Line #540:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #541:
Line #542://echo($sel."<hr>");
Line #543:
Line #544:$nur=mysql_num_rows($sql);
Line #545:if ($nur>0) {
Line #546:
Line #547:
Line #548:
Line #549:echo "<table border=1>
Line #550:<tr bgcolor=silver>
Line #551:
Line #552:
Line #553:
Line #554:
Line #555:
Line #556:
Line #557:
Line #558:</tr>";
Line #559:
Line #560:$_SESSION['Kedv_Ft']=0;
Line #561:$_SESSION[ELONY_FT]=0;
Line #562:$_SESSION[ELONYEL_FT]=0;
Line #563:$_SESSION['Utalvany']=0;
Line #564:$_SESSION['Udulesicsekk']=0;
Line #565:
Line #566:while ( $Csor = mysql_fetch_array( $sql))
Line #567:{
Line #568:
Line #569:
Line #570:if ($Csor[Kedv_Ft]<>0) {
Line #571: $_SESSION['Kedv_Ft']=$_SESSION['Kedv_Ft']+$Csor[Kedv_Ft];
Line #572:
Line #573: $_SESSION[Keszpenzes]=$_SESSION[Keszpenzes]-$Csor[Kedv_Ft];
Line #574:}
Line #575:
Line #576:if ($Csor[ELONY_FT]+$Csor[ELONYEL_FT]==0) {
Line #577://$_SESSION[Keszpenzes]=$_SESSION[Keszpenzes]+$Csor[KPft]-$Csor[UT_Ft];
Line #578:
Line #579:$_SESSION[Keszpenzes]=$_SESSION[Keszpenzes]-$Csor[UT_Ft];
Line #580://$_SESSION['Udulesicsekk']=$_SESSION['Udulesicsekk']-$Csor[KPft];
Line #581:$_SESSION['Udulesicsekk']=$_SESSION['Udulesicsekk']+$Csor[UCS_Ft];
Line #582:$_SESSION['Utalvany']=$_SESSION['Utalvany']+$Csor[UT_Ft];
Line #583:}
Line #584:
Line #585:
Line #586:$ELONY_FT=$Csor[ELONY_FT];
Line #587:$ELONYEL_FT=$Csor[ELONYEL_FT];
Line #588:
Line #589:if ($Csor[ELONYEL_FT]>0) $ELONY_FT=0;
Line #590:
Line #591:
Line #592:$_SESSION[ELONY_FT]=$_SESSION[ELONY_FT]+$ELONY_FT;
Line #593:$_SESSION[ELONYEL_FT]=$_SESSION[ELONYEL_FT]+$ELONYEL_FT;
Line #594:
Line #595:
Line #596:echo("
Line #597:<tr>
Line #598:<td align=right>".$Csor[widarc]."
Line #599:</td>
Line #600:<td align=right>".number_format($Csor[KPft])."
Line #601:</td>
Line #602:<td align=right>".number_format($Csor[UCS_Ft])."
Line #603:</td>
Line #604:<td align=right>".number_format($Csor[UT_Ft])."
Line #605:</td>
Line #606:<td align=right>".number_format($Csor[Kedv_Ft])."
Line #607:</td>
Line #608:<td align=right>".number_format($ELONY_FT)."
Line #609:</td>
Line #610:<td align=right>".number_format($ELONYEL_FT)."
Line #611:</td>
Line #612:<tr>");
Line #613:
Line #614:}}
Line #615:
Line #616:
Line #617:
Line #618:
Line #619:
Line #620:$sel = "SELECT * FROM qj_jlog where bizomanyos='".$_SESSION[L_bizomanyos]."' and ELONYOMTAT='R' and ELONY_DATE='".$L_NAP."'" ;
Line #621:
Line #622:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #623:
Line #624://echo($sel."<hr>");
Line #625:
Line #626:$nur=mysql_num_rows($sql);
Line #627:if ($nur>0) {
Line #628:
Line #629:
Line #630:
Line #631:echo "<table border=1>
Line #632:<tr bgcolor=silver>
Line #633:
Line #634:<td align=right >Kelt:</td>
Line #635:
Line #636:
Line #637:
Line #638:
Line #639:
Line #640:</tr>";
Line #641:
Line #642:$_SESSION[ELONY_FT]=0;
Line #643:
Line #644:while ( $Csor = mysql_fetch_array( $sql))
Line #645:{
Line #646:
Line #647:
Line #648:$hatralek=$Csor[osszft]-$Csor[Reszlet1];
Line #649:if ($hatralek<>0) {
Line #650:// $_SESSION[ELONY_FT]=$_SESSION[ELONY_FT]+$Csor[Reszlet1];
Line #651:// $_SESSION[Keszpenzes]=$_SESSION[Keszpenzes]-$hatralek;
Line #652: $_SESSION[ELONY_FT]=$_SESSION[ELONY_FT]+$hatralek;
Line #653: // $_SESSION[Keszpenzes]=$_SESSION[Keszpenzes]-$hatralek;
Line #654:}
Line #655:
Line #656:
Line #657:echo("
Line #658:<tr>
Line #659:<td align=right>".$Csor[wid]."
Line #660:</td>
Line #661:<td align=right>".$Csor[logtime]."
Line #662:</td>
Line #663:<td align=right>".number_format($Csor[osszft])."
Line #664:</td>
Line #665:<td align=right>".number_format($Csor[Reszlet1])."
Line #666:</td>
Line #667:<td align=right>".number_format($Csor[osszft]-$Csor[Reszlet1])."
Line #668:</td>
Line #669:<td align=right>".$Csor[Reszlet1No]."
Line #670:</td>
Line #671:<td align=right>".$Csor[ReszletDate]."
Line #672:</td>
Line #673:<tr>");
Line #674:
Line #675:}}
Line #676:
Line #677:///////////////////////
Line #678:
Line #679:
Line #680:echo"</table>";
Line #681:
Line #682://include("QJ_varlist.php");
Line #683:
Line #684:if (isset($_GET[nyomtat])) {
Line #685:include("QJ_listaveg.php");
Line #686:
Line #687:echo("<body onload='printit()'></body>");
Line #688:
Line #689:?>
Line #690:<SCRIPT Language="Javascript">
Line #691:
Line #692:function printit(){
Line #693:
Line #694:
Line #695:window.print();
Line #696:///////////////////////////////////////
Line #697:window.open("QJ_felad.php", 'sframe');
Line #698:///////////////////////////////////////
Line #699:
Line #700:}
Line #701:</script>
Line #702:<?PHP
Line #703:}
Line #704:
Line #705://~*~// QJ_napi.php
Line #706:?>
Line #707:
Line #708: