Bi-Dir

QJ_napiKONYVELlogin.inc

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