Bi-Dir

QJ_napiKONYVELafa.inc

Line #0:<?php
Line #1:
Line #2://include("../BiLib/gvarlist.php");
Line #3:
Line #4:$wer="";
Line #5:
Line #6:IF (isset($_SESSION[bwinbizo])) {
Line #7: IF ($_SESSION[bwinbizomanyos]<>"*")
Line #8: $wer=" and bizomanyos='".$_SESSION[bwinbizomanyos]."'";
Line #9:
Line #10:}
Line #11:
Line #12:
Line #13:
Line #14:if (isset($_GET[nyomtat])) {
Line #15:?>
Line #16:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #17:<?PHP
Line #18:} else {
Line #19:$napiADOselect="QJ_napiKONYVELafa.php";
Line #20:include("../_inc_QJ/QC_napiADOselect.inc");
Line #21:}
Line #22:
Line #23:////
Line #24:$login=$_SESSION['login'];
Line #25://if (isset($_GET[musor_kod])) $_SESSION[CALL_KOD]=$_GET[musor_kod]; else
Line #26://$_GET[musor_kod]=$_SESSION[CALL_KOD];
Line #27://if (isset($_SESSION[CALL_KOD]) and $_SESSION[CALL_KOD]<>"" ) $CALL_KOD=" and datum_kod='".$_SESSION[CALL_KOD]."'"; else $CALL_KOD="";
Line #28:////
Line #29:
Line #30:if (isset($_GET[L_nap])) $_SESSION[L_nap]=$_GET[L_nap];
Line #31:if (isset($_GET[L_biz])) $_SESSION[L_bizomanyos]=$_GET[L_biz];
Line #32:
Line #33:
Line #34:IF (ISSET($_SESSION[L_nap]) and $_SESSION[L_nap]<>"*")
Line #35:$wer1=" and left(logtime,10)='".$_SESSION[L_nap]."'"; else $wer1="";
Line #36:
Line #37:IF (ISSET($_SESSION[L_bizomanyos]) and $_SESSION[L_bizomanyos]<>"*")
Line #38:$login=$_SESSION[L_bizomanyos];
Line #39:
Line #40:$wer2=" and bizomanyos='".$login."'";
Line #41:
Line #42:$wer3=" and left(bizonylatszam,3)<>'BH:' ";
Line #43://///// szinkron hiba MIATT EF11
Line #44:
Line #45:$nocheck="F";
Line #46:
Line #47:IF ($_SESSION[L_bizomanyos]=="*" or $_SESSION[L_bizomanyos]=="0" ) { $nocheck="Y"
Line #48:; $wer2=""; }
Line #49:
Line #50:
Line #51:if ($_SESSION['admin']=="ADMIN") $nev=$login; else $nev=$_SESSION['login_nev'];
Line #52:
Line #53:$szin="";
Line #54:$i=0;
Line #55:$ft=0;
Line #56:$nap="?";
Line #57:$ri=0;
Line #58:$rft=0;
Line #59:$rmuv="?";
Line #60:
Line #61:$wi=0;
Line #62:$wft=0;
Line #63:$rlog="?";
Line #64:$hiba="";
Line #65:
Line #66://$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 #67:
Line #68://$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] or $_SESSION[SQL_storno]) $wer1 $wer2 ORDER BY logtime DESC";
Line #69:
Line #70:if (isset($_GET[musor_kod])) {
Line #71:
Line #72:$keres = "SELECT * FROM qj_musor where datum_kod='".$_GET[musor_kod]."'";
Line #73:
Line #74:
Line #75:$musor=mysql_fetch_array($meredmeny);
Line #76:$L_NAP=$musor[helyszin]." ".$musor[datum_fej]." ".$musor[cim];
Line #77:
Line #78:if (isset($_GET[bh])) {
Line #79:$bh=" and left(bizonylatszam,2)<>'BH' ";
Line #80:} else {
Line #81:$bh="";
Line #82:}
Line #83:
Line #84:
Line #85:
Line #86:} else {
Line #87:
Line #88:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $wer1 $wer2 $wer3 ORDER BY logtime DESC";
Line #89:
Line #90://?
Line #91://echo ($parancs."<hr>");
Line #92:
Line #93:
Line #94:
Line #95:$kegy_sor = mysql_fetch_array( $keredmeny );
Line #96:$Pnap=substr($kegy_sor[logtime],0,10);
Line #97:$rmuv=$kegy_sor[statusz];
Line #98:
Line #99:$nap=substr($kegy_sor[logtime],0,10);
Line #100:$wer1=" and left(logtime,10)='".$nap."'";
Line #101:
Line #102:if ($_SESSION[L_nap]==" " or !isset($_SESSION[L_nap])) {
Line #103: $_SESSION[L_nap]=$nap;
Line #104: $_SESSION[L_bizomanyos]=$kegy_sor[bizomanyos];
Line #105:}
Line #106:
Line #107:
Line #108:
Line #109:$_SESSION[Pnap]=$Pnap;
Line #110:$L_NAP=$_SESSION[L_nap];
Line #111:$L_user=$_SESSION[L_bizomanyos];
Line #112:
Line #113:
Line #114:}
Line #115:
Line #116:
Line #117:
Line #118:$L_PHP="QJ_napiKONYVELafa.php";
Line #119:include("QJ_listafej.php");
Line #120:
Line #121:$sajat="";
Line #122:
Line #123://if ($_SESSION[L_adoszam]<>"") {
Line #124:
Line #125:if ($_SESSION[QC_adoszam]<>"*") {
Line #126: $_SESSION[L_adoszam]=$_SESSION[QC_adoszam];
Line #127:
Line #128:$keres = "SELECT * FROM qj_musor where future<>'*' $_SESSION[QC_adoWER]";
Line #129:
Line #130:$musor=mysql_fetch_array($meredmeny);
Line #131:
Line #132:if ($_SESSION[QC_adoszam]<>"") {
Line #133: $sajat=$musor[cimkieg3];
Line #134:
Line #135:} else
Line #136:
Line #137:
Line #138:}
Line #139:
Line #140:
Line #141:
Line #142:echo "<table border=1>
Line #143:<tr bgcolor=silver>
Line #144:
Line #145:
Line #146:
Line #147:<td witdh=50>M.A Db</td>
Line #148:<td widh=50>M.A Ft</td>
Line #149:
Line #150:
Line #151:
Line #152:
Line #153:</tr>";
Line #154:
Line #155:
Line #156://$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 #157:
Line #158://$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 #159:
Line #160://$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] or $_SESSION[SQL_storno]) $wer1 $wer2 ORDER BY statusz,bizonylatszam DESC";
Line #161:
Line #162://if (isset($_GET[musor_kod]))
Line #163://$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $bh and datum_kod='".$_GET[musor_kod]."' $wer ORDER BY statusz,ar";
Line #164://else
Line #165:
Line #166:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $wer1 $wer2 $wer3 $wer ORDER BY statusz,ar,datum_kod";
Line #167://?//echo ($parancs."<hr> $wer1 $wer2 $wer3 $wer <hr>");
Line #168:
Line #169://IF (substr($sajat,0,10)==substr($musor[cimkieg3],0,10))
Line #170:// -------->IF (substr($sajat,0,10)==substr($musor[cimkieg3],0,10) or $_SESSION[QC_adoszam]<>"*")
Line #171:
Line #172:
Line #173:
Line #174:
Line #175:$i=0;
Line #176:$szin='white';
Line #177:$bh="";
Line #178:
Line #179:$ri=0;
Line #180:$rft=0;
Line #181:$ri0=0;
Line #182:$rft0=0;
Line #183:$ri27=0;
Line #184:$rft27=0;
Line #185:
Line #186:$i=0;
Line #187:$ft=0;
Line #188:$i0=0;
Line #189:$ft0=0;
Line #190:$i27=0;
Line #191:$ft27=0;
Line #192:
Line #193:$fi=0;
Line #194:$fft=0;
Line #195:$fi0=0;
Line #196:$fft0=0;
Line #197:$fi27=0;
Line #198:$fft27=0;
Line #199:
Line #200:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #201:{
Line #202:
Line #203://echo($egy_sor[wid]."/".$egy_sor[datum_kod]."<hr>");
Line #204:
Line #205:if ($i==0) {
Line #206: $rdatum=$egy_sor[datum_kod];
Line #207: $nap=substr($egy_sor[logtime],0,10);
Line #208: $rar=$egy_sor[ar];
Line #209: $rar_nev=$egy_sor[ar_nev];
Line #210: $rmuv=$egy_sor[statusz];
Line #211: $bh=substr($egy_sor[bizonylatszam],0,2);
Line #212:}
Line #213:
Line #214:$ref="";
Line #215:if ($rdatum<>$egy_sor[datum_kod] or
Line #216: $rar<>$egy_sor[ar] or
Line #217: $rmuv<>$egy_sor[statusz]){
Line #218:
Line #219:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$rdatum'";
Line #220:
Line #221:
Line #222:$musor = mysql_fetch_array( $eredmeny3 );
Line #223:
Line #224:$h=$musor[helyszin];
Line #225:$c=$egy_sor[cim];
Line #226:$d=$egy_sor[datum];
Line #227:$wjid=$egy_sor[wid];
Line #228:
Line #229://echo($wjid.$musor[helyszin]."/".$musor[cim]."/".$musor[datum]."/".$musor[cimkieg3]."<hr>".substr($_SESSION[L_adoszam],0,10)."/".substr($musor[cimkieg3],0,10));
Line #230:
Line #231:$FormaJel=$egy_sor[FormaJel];
Line #232:$JeBe=$egy_sor[JeBe];
Line #233:
Line #234:
Line #235:
Line #236:
Line #237:
Line #238:
Line #239://IF (substr($sajat,0,10)==substr($musor[cimkieg3],0,10))
Line #240:IF (substr($sajat,0,10)==substr($musor[cimkieg3],0,10) or $_SESSION[QC_adoszam]=="*")
Line #241:
Line #242:echo"<tr bgcolor='#FAF8CC' >
Line #243:
Line #244:<td align=right >$musor[cim]  $musor[datum]($rdatum)</td>
Line #245:<td align=right >$rmuv</td>
Line #246:
Line #247:<td align=right >".number_format($rar)."</td>
Line #248:
Line #249:<td align=right > $ri0</td>
Line #250:<td align=right >".number_format($rft0)."</td>
Line #251:
Line #252:
Line #253:<td align=right > $ri27</td>
Line #254:<td align=right >".number_format($rft27)."</td>
Line #255:
Line #256:<td align=right bgcolor=silver> $ri</td>
Line #257:<td align=right bgcolor=silver >".number_format($rft)."</td>
Line #258:
Line #259:</tr>";
Line #260:
Line #261:$ri=0;
Line #262:$rft=0;
Line #263:$ri0=0;
Line #264:$rft0=0;
Line #265:$ri27=0;
Line #266:$rft27=0;
Line #267:
Line #268:if ($rmuv<>$egy_sor[statusz]){
Line #269:echo"<tr bgcolor=#ECD672 >
Line #270:
Line #271:
Line #272:<td align=right >$rmuv</td>
Line #273:
Line #274:<td align=right > </td>
Line #275:
Line #276:<td align=right > $fi0</td>
Line #277:<td align=right >".number_format($fft0)."</td>
Line #278:
Line #279:
Line #280:<td align=right > $fi27</td>
Line #281:<td align=right >".number_format($fft27)."</td>
Line #282:
Line #283:<td align=right > $fi</td>
Line #284:<td align=right >".number_format($fft)."</td>
Line #285:
Line #286:</tr>";
Line #287:
Line #288:$fi=0;
Line #289:$fft=0;
Line #290:$fi0=0;
Line #291:$fft0=0;
Line #292:$fi27=0;
Line #293:$fft27=0;
Line #294:}
Line #295:
Line #296:
Line #297:}
Line #298:
Line #299: $rdatum=$egy_sor[datum_kod];
Line #300: $nap=substr($egy_sor[logtime],0,10);
Line #301: $rar=$egy_sor[ar];
Line #302: $rar_nev=$egy_sor[ar_nev];
Line #303: $rmuv=$egy_sor[statusz];
Line #304: $bh=substr($egy_sor[bizonylatszam],0,2);
Line #305:
Line #306:
Line #307:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$rdatum'";
Line #308:
Line #309:
Line #310:$musor = mysql_fetch_array( $eredmeny3 );
Line #311:
Line #312:
Line #313://IF (substr($sajat,0,10)==substr($musor[cimkieg3],0,10))
Line #314:IF (substr($sajat,0,10)==substr($musor[cimkieg3],0,10) or $_SESSION[QC_adoszam]=="*")
Line #315:{
Line #316:++$i;
Line #317:++$ri;
Line #318:++$fi;
Line #319:$rft=$rft+$egy_sor[ar];
Line #320:$fft=$fft+$egy_sor[ar];
Line #321:$ft =$ft+$egy_sor[ar];
Line #322:++$wi;
Line #323:$wft=$wft+$egy_sor[ar];
Line #324:
Line #325:IF ($musor[AFA_jel]=="MA") {
Line #326:++$ri0;
Line #327:$rft0=$rft0+$egy_sor[ar];
Line #328:++$fi0;
Line #329:$fft0=$fft0+$egy_sor[ar];
Line #330:++$i0;
Line #331:$ft0=$ft0+$egy_sor[ar];
Line #332:} else {
Line #333:++$fi27;
Line #334:$fft27=$fft27+$egy_sor[ar];
Line #335:++$i27;
Line #336:$ft27=$ft27+$egy_sor[ar];
Line #337:++$ri27;
Line #338:$rft27=$rft27+$egy_sor[ar];}
Line #339:
Line #340:
Line #341:}
Line #342:
Line #343:/*
Line #344:$dk=$egy_sor[datum_kod];
Line #345:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$dk'";
Line #346:
Line #347:
Line #348:$musor = mysql_fetch_array( $eredmeny3 );
Line #349:
Line #350:$h=$musor[helyszin];
Line #351:$c=$egy_sor[cim];
Line #352:$d=$egy_sor[datum];
Line #353:$wjid=$egy_sor[wid];
Line #354:
Line #355:$FormaJel=$egy_sor[FormaJel];
Line #356:$JeBe=$egy_sor[JeBe];
Line #357:
Line #358:echo"<tr>
Line #359:
Line #360:<td align=right >
Line #361: $i.
Line #362:</td>
Line #363:
Line #364:<td align=right >$musor[cim] $musor[datum] $helyinfo</td>
Line #365:<td align=right >$musor[JeBe] $egy_sor[ar_nev]</td>
Line #366:<td align=right >".number_format($egy_sor[ar])."</td>
Line #367:<td >$egy_sor[statusz]</td>
Line #368:<td >$egy_sor[bizonylatszam]$ref</td>
Line #369:<td >".substr($egy_sor[logtime],-8)."</td>
Line #370:</tr>";
Line #371:*/
Line #372:
Line #373:/*
Line #374:$szin="";
Line #375://<td >".substr($egy_sor[logtime],-8)."</td>
Line #376://<td >".$egy_sor[logtime].$egy_sor[bizomanyos]."</td>
Line #377://<td >".$egy_sor[logtime].$egy_sor[bizomanyos].$ft."</td>
Line #378://}
Line #379:*/
Line #380:
Line #381:}
Line #382:
Line #383:
Line #384:if ($ft>0) {
Line #385:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$rdatum'";
Line #386:
Line #387:
Line #388:$musor = mysql_fetch_array( $eredmeny3 );
Line #389:
Line #390:$h=$musor[helyszin];
Line #391:$c=$egy_sor[cim];
Line #392:$d=$egy_sor[datum];
Line #393:$wjid=$egy_sor[wid];
Line #394:
Line #395:$FormaJel=$egy_sor[FormaJel];
Line #396:$JeBe=$egy_sor[JeBe];
Line #397:
Line #398://echo($wjid.$musor[helyszin]."/".$musor[cim]."/".$musor[datum]."/".$musor[cimkieg3]."<hr>");
Line #399:
Line #400:
Line #401://$rar_nev="?...?".substr($rar_nev,0,strlen($rar_nev)-6)."-..-";
Line #402:
Line #403:
Line #404:
Line #405:IF (substr($sajat,0,10)==substr($musor[cimkieg3],0,10) or $_SESSION[QC_adoszam]=="*")
Line #406:
Line #407:echo"<tr bgcolor='#FAF8CC'>
Line #408:
Line #409:<td align=right >$musor[cim]  $musor[datum] ($rdatum)</td>
Line #410:<td align=right >$rmuv</td>
Line #411:
Line #412:<td align=right >".number_format($rar)."</td>
Line #413:
Line #414:<td align=right > $ri0</td>
Line #415:<td align=right >".number_format($rft0)."</td>
Line #416:
Line #417:
Line #418:<td align=right > $ri27</td>
Line #419:<td align=right >".number_format($rft27)."</td>
Line #420:
Line #421:<td align=right bgcolor=silver> $ri</td>
Line #422:<td align=right bgcolor=silver >".number_format($rft)."</td>
Line #423:
Line #424:</tr>";
Line #425:
Line #426:echo"<tr bgcolor=#ECD672 >
Line #427:
Line #428:
Line #429:<td align=right >$rmuv</td>
Line #430:
Line #431:<td align=right > </td>
Line #432:
Line #433:<td align=right > $fi0</td>
Line #434:<td align=right >".number_format($fft0)."</td>
Line #435:
Line #436:
Line #437:<td align=right > $fi27</td>
Line #438:<td align=right >".number_format($fft27)."</td>
Line #439:
Line #440:<td align=right > $fi</td>
Line #441:<td align=right >".number_format($fft)."</td>
Line #442:
Line #443:</tr>";
Line #444:}
Line #445:
Line #446:$szin="silver";
Line #447:
Line #448:
Line #449:
Line #450:echo"<tr bgcolor=silver>
Line #451:
Line #452:
Line #453:</td>
Line #454:<td align=right> $i0</td>
Line #455:<td align=right >".number_format($ft0)."</td>
Line #456:
Line #457:
Line #458:<td align=right > $i27</td>
Line #459:<td align=right >".number_format($ft27)."</td>
Line #460:
Line #461:<td align=right > $i</td>
Line #462:<td align=right >".number_format($ft)."</td>
Line #463:
Line #464:</tr>";
Line #465:
Line #466:echo"</table>";
Line #467:
Line #468:
Line #469://include("QJ_varlist.php");
Line #470:
Line #471:if (isset($_GET[nyomtat])) {
Line #472:include("QJ_listaveg.php");
Line #473:
Line #474:echo("<body onload='printit()'></body>");
Line #475:
Line #476:?>
Line #477:<SCRIPT Language="Javascript">
Line #478:
Line #479:function printit(){
Line #480:
Line #481:
Line #482:window.print();
Line #483:///////////////////////////////////////
Line #484://window.open("QJ_felad.php", 'sframe');
Line #485:///////////////////////////////////////
Line #486://window.open("QJ_gyujto.php", 'sframe');
Line #487:
Line #488:}
Line #489:</script>
Line #490:<?PHP
Line #491:}
Line #492:
Line #493://~*~// QJ_napi.php
Line #494:?>
Line #495:
Line #496: