Bi-Dir

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