Bi-Dir

QJ_napiKONYVELdate.inc

Line #0:<?php
Line #1:
Line #2:$L_PHP="QJ_napiKONYVELdate.php";
Line #3:
Line #4:if (isset($_GET[musor_kod])) $_SESSION[SUBmusor_kod]=$_GET[musor_kod];
Line #5: else $_GET[musor_kod]=$_SESSION[SUBmusor_kod];
Line #6:
Line #7:$wer="";
Line #8:
Line #9:if (isset($_GET[nyomtat])) {
Line #10:?>
Line #11:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #12:<?PHP
Line #13:} else {
Line #14:
Line #15:include("../_inc_QJ/QJ_listaSELECT.inc");
Line #16:
Line #17:/*<SCRIPT Language="Javascript">
Line #18://window.open("QJ_listaSELECT?&musor_kod='.$_GET[musor_kod].'.php","alfej");
Line #19:///////////////////////////////////////
Line #20://alert("QJ_listaSELECT.php?&musor_kod=\''.$_GET[musor_kod].'\'");
Line #21:window.open("QJ_listaSELECT.php?&musor_kod='.$_GET[musor_kod].'","alfej");
Line #22:///////////////////////////////////////
Line #23:</script>');
Line #24:*/
Line #25:
Line #26:}
Line #27:
Line #28:
Line #29:
Line #30:$szin="";
Line #31:$i=0;
Line #32:$ft=0;
Line #33:$nap="?";
Line #34:$ri=0;
Line #35:$rft=0;
Line #36:$rmuv="?";
Line #37:
Line #38:$wi=0;
Line #39:$wft=0;
Line #40:$rlog="?";
Line #41:$hiba="";
Line #42:
Line #43://$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 #44:
Line #45://$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] or $_SESSION[SQL_storno]) $wer1 $wer2 ORDER BY logtime DESC";
Line #46:
Line #47:if (isset($_GET[musor_kod])) {
Line #48:
Line #49:$keres = "SELECT * FROM qj_musor where datum_kod='".$_GET[musor_kod]."'";
Line #50:
Line #51:
Line #52:$musor=mysql_fetch_array($meredmeny);
Line #53:
Line #54:////////////////////////
Line #55:$L_NAP=$musor[rovid_helyszin]." ".$musor[datum]." ".$musor[cim]."";
Line #56:////////////////////////
Line #57:
Line #58:if (isset($_GET[bh])) {
Line #59:$bh=" and left(bizonylatszam,2)<>'BH' ";
Line #60:} else {
Line #61:$bh="";
Line #62:}
Line #63:
Line #64:
Line #65:
Line #66:} else {
Line #67:
Line #68:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $wer1 $wer2 $wer3 ORDER BY logtime DESC";
Line #69:
Line #70://?//
Line #71:echo ($parancs."<hr>");
Line #72:
Line #73:
Line #74:
Line #75:$kegy_sor = mysql_fetch_array( $keredmeny );
Line #76:$Pnap=substr($kegy_sor[logtime],0,10);
Line #77:$rmuv=$kegy_sor[statusz];
Line #78:
Line #79:$nap=substr($kegy_sor[logtime],0,10);
Line #80:$wer1=" and left(logtime,10)='".$nap."'";
Line #81:
Line #82:if ($_SESSION[L_nap]==" " or !isset($_SESSION[L_nap])) {
Line #83: $_SESSION[L_nap]=$nap;
Line #84: $_SESSION[L_bizomanyos]=$kegy_sor[bizomanyos];
Line #85:}
Line #86:
Line #87:
Line #88:
Line #89:$_SESSION[Pnap]=$Pnap;
Line #90:$L_NAP=$_SESSION[L_nap];
Line #91:$L_user=$_SESSION[L_bizomanyos];
Line #92:
Line #93:
Line #94:}
Line #95:
Line #96:
Line #97:$L_PHP="QJ_napiKONYVELdate.php";
Line #98:include("QJ_listafej.php");
Line #99:
Line #100:
Line #101:echo "<table border=1>
Line #102:<tr bgcolor=silver>
Line #103:
Line #104:
Line #105:
Line #106:<td colspan=2 witdh=50>Bank</td>
Line #107:
Line #108:
Line #109:</tr>";
Line #110:
Line #111:echo "
Line #112:<tr bgcolor=silver>
Line #113:
Line #114:<td witdh=50>Db</td>
Line #115:<td witdh=50>Ft</td>
Line #116:<td witdh=50>Db</td>
Line #117:<td witdh=50>Ft</td>
Line #118:<td witdh=50>Db</td>
Line #119:<td witdh=50>Ft</td>
Line #120:</tr>";
Line #121:
Line #122://$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 #123:
Line #124://$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 #125:
Line #126://$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] or $_SESSION[SQL_storno]) $wer1 $wer2 ORDER BY statusz,bizonylatszam DESC";
Line #127:
Line #128:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $bh and datum_kod='".$_GET[musor_kod]."' $wer ORDER BY left(logtime,10),bizomanyos,ar";
Line #129:
Line #130:
Line #131:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $_SESSION[SUBwer] $bh and datum_kod='".$_GET[musor_kod]."' $wer ORDER BY left(logtime,10),bizomanyos,ar";
Line #132:
Line #133:$nur=mysql_num_rows($eredmeny);
Line #134:
Line #135://? // echo ($parancs." ".$nur." .DB <hr>");
Line #136:
Line #137:
Line #138:$i=0;
Line #139:$szin='white';
Line #140:$bh="";
Line #141:
Line #142:$ri=0;
Line #143:$rft=0;
Line #144:$ri0=0;
Line #145:$rft0=0;
Line #146:$ri27=0;
Line #147:$rft27=0;
Line #148:
Line #149:$i=0;
Line #150:$ft=0;
Line #151:$i0=0;
Line #152:$ft0=0;
Line #153:$i27=0;
Line #154:$ft27=0;
Line #155:
Line #156:$fi=0;
Line #157:$fft=0;
Line #158:$fi0=0;
Line #159:$fft0=0;
Line #160:$fi27=0;
Line #161:$fft27=0;
Line #162:$multi=0;
Line #163:
Line #164:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #165:{
Line #166:
Line #167://echo($egy_sor[wid]."/".$egy_sor[datum_kod]."<hr>");
Line #168:
Line #169:if ($i==0) {
Line #170: $rdatum=$egy_sor[datum_kod];
Line #171: $nap=substr($egy_sor[logtime],0,10);
Line #172: $rar=$egy_sor[ar];
Line #173: $rar_nev=$egy_sor[ar_nev];
Line #174: $rmuv=$egy_sor[statusz];
Line #175: $rmuv=$egy_sor[bizomanyos];
Line #176: $bh=substr($egy_sor[bizonylatszam],0,2);
Line #177:}
Line #178:
Line #179:$ref="";
Line #180:if ( $nap<>substr($egy_sor[logtime],0,10) or
Line #181: $rmuv<>$egy_sor[bizomanyos]){
Line #182:
Line #183://<td align=right >".number_format($rar)."</td>
Line #184:
Line #185:echo"<tr bgcolor='#FAF8CC' >
Line #186:<td align=right >$nap</td>
Line #187:<td align=right >$rmuv</td>
Line #188:
Line #189:
Line #190:<td align=right > $ri0</td>
Line #191:<td align=right >".number_format($rft0)."</td>
Line #192:
Line #193:
Line #194:<td align=right > $ri27</td>
Line #195:<td align=right >".number_format($rft27)."</td>
Line #196:
Line #197:<td align=right bgcolor=silver> $ri</td>
Line #198:<td align=right bgcolor=silver >".number_format($rft)."</td>
Line #199:
Line #200:</tr>";
Line #201:
Line #202:$ri=0;
Line #203:$rft=0;
Line #204:$ri0=0;
Line #205:$rft0=0;
Line #206:$ri27=0;
Line #207:$rft27=0;
Line #208:++$multi;
Line #209:
Line #210:if ($nap<>substr($egy_sor[logtime],0,10) ){
Line #211:
Line #212:if ($multi>1)
Line #213:
Line #214:echo"<tr bgcolor=#ECD672 >
Line #215:
Line #216:
Line #217:<td align=right >$nap</td>
Line #218:
Line #219:
Line #220:<td align=right > $fi0</td>
Line #221:<td align=right >".number_format($fft0)."</td>
Line #222:
Line #223:
Line #224:<td align=right > $fi27</td>
Line #225:<td align=right >".number_format($fft27)."</td>
Line #226:
Line #227:<td align=right > $fi</td>
Line #228:<td align=right >".number_format($fft)."</td>
Line #229:
Line #230:</tr>";
Line #231:
Line #232:$multi=0;
Line #233:
Line #234:$fi=0;
Line #235:$fft=0;
Line #236:$fi0=0;
Line #237:$fft0=0;
Line #238:$fi27=0;
Line #239:$fft27=0;
Line #240:}
Line #241:
Line #242:}
Line #243:
Line #244: $rdatum=$egy_sor[datum_kod];
Line #245: $nap=substr($egy_sor[logtime],0,10);
Line #246: $rar=$egy_sor[ar];
Line #247: $rar_nev=$egy_sor[ar_nev];
Line #248: $rmuv=$egy_sor[bizomanyos];
Line #249: $bh=substr($egy_sor[bizonylatszam],0,2);
Line #250:
Line #251:++$i;
Line #252:++$ri;
Line #253:++$fi;
Line #254:$rft=$rft+$egy_sor[ar];
Line #255:$fft=$fft+$egy_sor[ar];
Line #256:$ft =$ft+$egy_sor[ar];
Line #257:++$wi;
Line #258:$wft=$wft+$egy_sor[ar];
Line #259:
Line #260:
Line #261:++$ri0;
Line #262:$rft0=$rft0+$egy_sor[ar];
Line #263:++$fi0;
Line #264:$fft0=$fft0+$egy_sor[ar];
Line #265:++$i0;
Line #266:$ft0=$ft0+$egy_sor[ar];
Line #267:} else {
Line #268:++$fi27;
Line #269:$fft27=$fft27+$egy_sor[ar];
Line #270:++$i27;
Line #271:$ft27=$ft27+$egy_sor[ar];
Line #272:++$ri27;
Line #273:$rft27=$rft27+$egy_sor[ar];}
Line #274:
Line #275:
Line #276:}
Line #277:
Line #278://<td align=right >".number_format($rar)."</td>
Line #279:
Line #280:echo"<tr bgcolor='#FAF8CC'>
Line #281:
Line #282:<td align=right >$nap</td>
Line #283:<td align=right >$rmuv</td>
Line #284:
Line #285:<td align=right > $ri0</td>
Line #286:<td align=right >".number_format($rft0)."</td>
Line #287:
Line #288:<td align=right > $ri27</td>
Line #289:<td align=right >".number_format($rft27)."</td>
Line #290:
Line #291:<td align=right bgcolor=silver> $ri</td>
Line #292:<td align=right bgcolor=silver >".number_format($rft)."</td>
Line #293:
Line #294:</tr>";
Line #295:
Line #296:echo"<tr bgcolor=#ECD672 >
Line #297:
Line #298:
Line #299:<td align=right >$nap</td>
Line #300:
Line #301:
Line #302:<td align=right > $fi0</td>
Line #303:<td align=right >".number_format($fft0)."</td>
Line #304:
Line #305:
Line #306:<td align=right > $fi27</td>
Line #307:<td align=right >".number_format($fft27)."</td>
Line #308:
Line #309:<td align=right > $fi</td>
Line #310:<td align=right >".number_format($fft)."</td>
Line #311:
Line #312:</tr>";
Line #313:
Line #314:
Line #315:$szin="silver";
Line #316:
Line #317:
Line #318:echo"<tr bgcolor=silver>
Line #319:
Line #320:
Line #321:</td>
Line #322:<td align=right> $i0</td>
Line #323:<td align=right >".number_format($ft0)."</td>
Line #324:
Line #325:
Line #326:<td align=right > $i27</td>
Line #327:<td align=right >".number_format($ft27)."</td>
Line #328:
Line #329:<td align=right > $i</td>
Line #330:<td align=right >".number_format($ft)."</td>
Line #331:
Line #332:</tr>";
Line #333:
Line #334:echo"</table>";
Line #335:
Line #336:
Line #337://include("../_inc_BI/gvarlist.inc");
Line #338:
Line #339:if (isset($_GET[nyomtat])) {
Line #340:include("QJ_listaveg.php");
Line #341:
Line #342:echo("<body onload='printit()'></body>");
Line #343:
Line #344:?>
Line #345:<SCRIPT Language="Javascript">
Line #346:
Line #347:function printit(){
Line #348:
Line #349:
Line #350:window.print();
Line #351:///////////////////////////////////////
Line #352://window.open("QJ_felad.php", 'sframe');
Line #353:///////////////////////////////////////
Line #354://window.open("QJ_gyujto.php", 'sframe');
Line #355:
Line #356:}
Line #357:</script>
Line #358:<?PHP
Line #359:}
Line #360:
Line #361://~*~// QJ_napi.php
Line #362:?>
Line #363:
Line #364: