Bi-Dir

QJ_napifull_MK_V2_BANK.inc

Line #0:
Line #1:$dkodok="/";
Line #2:
Line #3:$L_PHP="QJ_napifull_BANK.php";
Line #4:$SelFile="qj_jegy where future<>'*' ";
Line #5:if (isset($_GET[musor_kod])) $_SESSION[SUBmusor_kod]=$_GET[musor_kod];
Line #6: else $_GET[musor_kod]=$_SESSION[SUBmusor_kod];
Line #7:
Line #8:$wer="";
Line #9:
Line #10:if (isset($_GET[nyomtat])) {
Line #11:?>
Line #12:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #13:<?PHP
Line #14:} else {
Line #15:
Line #16:include("../_inc_QJ/QS_listaSELECT.inc");
Line #17:
Line #18:}
Line #19:
Line #20:
Line #21:
Line #22:$login=$_SESSION['login'];
Line #23:
Line #24:
Line #25:IF (ISSET($_SESSION[L_nap]) and $_SESSION[L_nap]<>"*")
Line #26:$wer1=" and left(logtime,10)='".$_SESSION[L_nap]."'"; else $wer1="";
Line #27:
Line #28:IF (ISSET($_SESSION[L_bizomanyos]) and $_SESSION[L_bizomanyos]<>"*")
Line #29:$login=$_SESSION[L_bizomanyos];
Line #30:
Line #31:$wer2=" and bizomanyos='".$login."'";
Line #32:
Line #33:IF ($_SESSION[L_bizomanyos]=="*" or $_SESSION[L_bizomanyos]=="0" ) $wer2="";
Line #34:
Line #35:if ($_SESSION['admin']=="ADMIN") $nev=$login; else $nev=$_SESSION['login_nev'];
Line #36:
Line #37:
Line #38:
Line #39:
Line #40:
Line #41:
Line #42:$keres="SELECT distinct datum_kod FROM qj_jegy where ar>0 and future <>'*' and $_SESSION[SQL_elad] $wer3 $wer1 $_SESSION[SUBwer] ORDER BY datum_kod";
Line #43:if (isset($_SESSION['Dump'])) echo($keres." <hr>");
Line #44:
Line #45://?//echo($keres."<hr>");
Line #46:
Line #47:
Line #48:$werdatum= " and ( ";
Line #49:$and="";
Line #50:
Line #51:$wi=0;
Line #52:
Line #53:$wera=" and (Adoszam='' or Adoszam='23834936-2-05') "; // " and Adoszam='23834936-2-05' ";
Line #54:
Line #55:while ( $egy_sor = mysql_fetch_array( $eredmeny ) )
Line #56:{
Line #57:
Line #58:$dk=$egy_sor[datum_kod];
Line #59:$Msql="SELECT * FROM qj_musor where future <>'*' $wera and datum_kod='$dk' ";
Line #60:
Line #61:if (isset($_SESSION['Dump'])) echo($keres." <hr>");
Line #62:
Line #63:
Line #64:$nurM=mysql_num_rows($Meredmeny);
Line #65:
Line #66:if ($nurM>0) {
Line #67: $werdatum.= $and. " datum_kod='$dk'";
Line #68: $and=" or ";
Line #69: ++$wi;
Line #70:}
Line #71:
Line #72:}
Line #73:
Line #74:
Line #75:$werdatum.= " )";
Line #76:
Line #77:// echo($werdatum."<hr>");
Line #78:
Line #79:if ($wi==0) $werdatum="";
Line #80:
Line #81:
Line #82:$szin="";
Line #83:$i=0;
Line #84:$ft=0;
Line #85:$nap="?";
Line #86:$ri=0;
Line #87:$rft=0;
Line #88:$rft1=0;
Line #89:$rft2=0;
Line #90:$rmuv="?";
Line #91:$rmuv1="?";
Line #92:$rmuv2="?";
Line #93:
Line #94://?//$_SESSION[Pnap]=$Pnap;
Line #95://?//$L_NAP=$_SESSION[L_nap];
Line #96://?//$L_user=$_SESSION[L_bizomanyos];
Line #97:
Line #98:
Line #99:include("QJ_listafej.php");
Line #100:
Line #101:
Line #102:echo "<table border=0>
Line #103:<tr bgcolor=silver>
Line #104:
Line #105:
Line #106:
Line #107:
Line #108:<td ></td>
Line #109:<td >Darab</td>
Line #110:<td ></td>
Line #111:<td ></td>
Line #112:</tr>";
Line #113:
Line #114:
Line #115://$parancs="SELECT * FROM qj_jegy where statusz<>'' and left(statusz,2)<>'El' and left(statusz,2)<>'St' ORDER BY bizomanyos,statusz,logtime";
Line #116:
Line #117://$parancs="SELECT * FROM qj_jegy where statusz<>'' and left(statusz,2)<>'El' and left(statusz,2)<>'St' $wer1 $wer2 ORDER BY bizomanyos,statusz,logtime";
Line #118:
Line #119:$parancs="SELECT * FROM qj_jegy where $_SESSION[SQL_elad]
Line #120:and ( $_SESSION[SQL_berlet] OR $_SESSION[SQL_jegy] ) $wer3 $wer1 $_SESSION[SUBwer] $werdatum ORDER BY bizomanyos,statusz,logtime";
Line #121:
Line #122://$parancs="SELECT * FROM qj_jegy where $_SESSION[SQL_elad]
Line #123:// $_SESSION[SUBwer] ORDER BY bizomanyos,statusz,logtime";
Line #124:
Line #125:
Line #126:
Line #127:$nur=mysql_num_rows($eredmeny);
Line #128:if ($nur==0) {
Line #129:$parancs="SELECT * FROM qj_jegy where $_SESSION[SQL_elad]
Line #130: $wer3 and ( $_SESSION[SQL_berlet] OR $_SESSION[SQL_jegy] ) $_SESSION[SUBwer]
Line #131: and datum_kod<>'MK14D00379' ORDER BY bizomanyos,statusz,logtime";
Line #132:
Line #133://$parancs="SELECT * FROM qj_jegy where $_SESSION[SQL_elad]
Line #134:// $_SESSION[SUBwer] ORDER BY bizomanyos,statusz,logtime";
Line #135:
Line #136:
Line #137:}
Line #138:
Line #139://?//echo($parancs."<hr>");
Line #140://?//echo($_SESSION[SUBwer]."<hr>");
Line #141:
Line #142://////////////////////!!! //////////////////////////////
Line #143:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #144:{
Line #145:
Line #146:if ($i==0) {
Line #147:
Line #148:$rmuv=$egy_sor[bizomanyos].":".$egy_sor[statusz].":".substr($egy_sor[logtime],0,10);
Line #149:$rmuv1=$egy_sor[bizomanyos].":".$egy_sor[statusz];
Line #150:$rmuv2=$egy_sor[bizomanyos];
Line #151:
Line #152:$keres = "SELECT * FROM qj_musor where wid=1";
Line #153:
Line #154:
Line #155:$nur=mysql_num_rows($meredmeny);
Line #156:$musor=mysql_fetch_array($meredmeny);
Line #157:
Line #158:/*
Line #159:
Line #160:echo("  <a href=javascript:printit()><img src='print.png' border=0></a></H5>");
Line #161:
Line #162:</H3>");
Line #163:*/
Line #164:
Line #165:
Line #166:}
Line #167:
Line #168:$datum_kod=$egy_sor[datum_kod];
Line #169:$Vft=$egy_sor[ar];
Line #170:$valid="fut";
Line #171://include("QQ_validPNZTAR.inc");
Line #172:/*
Line #173:if (strpos("?".$dkodok,$datum_kod)==0 and $dm<5000 ) {++$dm; $dkodok=$dkodok.$datum_kod."/";}
Line #174:
Line #175:$pos=strpos("?".$dkodok,$datum_kod);
Line #176:$di=intval($pos/11);
Line #177:$di=$pos/11;
Line #178:$dt[$di]=$datum_kod;
Line #179:++$dd[$di];
Line #180:$da[$di]=$da[$di]+$Vft;
Line #181:// echo($di." ??? ".$pos." ".$da[$di]." ".$dt[$di]." ".$dkodok." ".$Vft." ");
Line #182:*/
Line #183:
Line #184:
Line #185:if ($rmuv<>$egy_sor[bizomanyos].":".$egy_sor[statusz].":".substr($egy_sor[logtime],0,10)){
Line #186:
Line #187:echo"<tr>
Line #188:
Line #189:
Line #190:</td>
Line #191:
Line #192:<td width=20 align=right >".number_format($rft)."</td>
Line #193:<td> Ft</td>
Line #194:<td width=20 align=right >".number_format($ri)."</td>
Line #195:<td> Db</td>
Line #196:</tr>";
Line #197:
Line #198:$ri=0;
Line #199:$rft=0;
Line #200:
Line #201:
Line #202:$rmuv=$egy_sor[bizomanyos].":".$egy_sor[statusz].":".substr($egy_sor[logtime],0,10);
Line #203:
Line #204:}
Line #205:
Line #206:if ($rmuv1<>$egy_sor[bizomanyos].":".$egy_sor[statusz]){
Line #207:
Line #208:echo"<tr>
Line #209:
Line #210:
Line #211:</td>
Line #212:
Line #213:<td width=20 align=right >".number_format($rft1)."</td>
Line #214:<td> Ft</td>
Line #215:<td width=20 align=right >".number_format($ri1)."</td>
Line #216:<td> Db</td>
Line #217:</tr>";
Line #218:
Line #219:$ri1=0;
Line #220:$rft1=0;
Line #221:
Line #222:
Line #223:$rmuv1=$egy_sor[bizomanyos].":".$egy_sor[statusz];
Line #224:
Line #225:}
Line #226:
Line #227:
Line #228:if ($rmuv2<>$egy_sor[bizomanyos]){
Line #229:
Line #230:echo"<tr>
Line #231:
Line #232:
Line #233:</td>
Line #234:
Line #235:<td width=20 align=right >".number_format($rft2)."</td>
Line #236:<td> Ft</td>
Line #237:<td width=20 align=right >".number_format($ri2)."</td>
Line #238:<td> Db </td>
Line #239:</tr><tr><td colspan=9><hr></td></tr>";
Line #240:
Line #241:
Line #242:$ri2=0;
Line #243:$rft2=0;
Line #244:
Line #245:
Line #246:$rmuv2=$egy_sor[bizomanyos];
Line #247:
Line #248:}
Line #249:
Line #250:
Line #251:++$i;
Line #252:++$ri;
Line #253:++$ri1;
Line #254:++$ri2;
Line #255:if (substr($egy_sor[statusz],0,2)<>'El') {
Line #256: $rft=$rft+$egy_sor[ar];
Line #257: $rft1=$rft1+$egy_sor[ar];
Line #258: $rft2=$rft2+$egy_sor[ar];
Line #259: $ft =$ft+$egy_sor[ar];
Line #260:}
Line #261:
Line #262:
Line #263:if ($_SESSION['Analitika']=="Yes") {
Line #264:
Line #265:echo"<tr>
Line #266:
Line #267:<td align=right >
Line #268:$i
Line #269:</td>
Line #270:
Line #271:<td align=right > $egy_sor[szoveg]</td>
Line #272:<td align=right > $egy_sor[ar_nev]</td>
Line #273:<td align=right > $egy_sor[ar]</td>
Line #274:<td >$egy_sor[statusz]</td>
Line #275:<td >$egy_sor[bizonylatszam]</td>
Line #276:<td >".$egy_sor[logtime]."</td>
Line #277:<td >$egy_sor[bizomanyos]</td>
Line #278:</tr>";
Line #279:$szin="";
Line #280:}
Line #281:
Line #282://///////////////////////////////
Line #283://////////// 2014.04.03. 4:34:57 //////////////////
Line #284: }
Line #285://///////////////////////////////
Line #286:
Line #287:
Line #288:echo"<tr>
Line #289:
Line #290:
Line #291:</td>
Line #292:
Line #293:<td width=20 align=right >".number_format($rft)."</td>
Line #294:<td> Ft</td>
Line #295:<td width=20 align=right >".number_format($ri)."</td>
Line #296:<td> Db</td>
Line #297:</tr>";
Line #298:
Line #299:echo"<tr>
Line #300:
Line #301:
Line #302:</td>
Line #303:
Line #304:<td width=20 align=right >".number_format($rft1)."</td>
Line #305:<td> Ft</td>
Line #306:<td width=20 align=right >".number_format($ri1)."</td>
Line #307:<td> Db</td>
Line #308:</tr>";
Line #309:
Line #310:
Line #311:
Line #312:
Line #313:echo"<tr>
Line #314:
Line #315:
Line #316:</td>
Line #317:
Line #318:<td width=20 align=right >".number_format($rft2)."</td>
Line #319:<td> Ft</td>
Line #320:<td width=20 align=right >".number_format($ri2)."</td>
Line #321:<td> Db</td>
Line #322:</tr><tr><td colspan=9><hr></td></tr>";
Line #323:
Line #324:if ($ft<>$rft2) {
Line #325:echo"<tr>
Line #326:
Line #327:
Line #328:</td>
Line #329:
Line #330:<td width=20 align=right >".number_format( $ft)."</td>
Line #331:<td> Ft</td>
Line #332:<td width=20 align=right >".number_format( $i)."</td>
Line #333:<td> Db</td>
Line #334:</tr>";
Line #335:}
Line #336:
Line #337:echo "
Line #338:</table>";
Line #339:/*
Line #340:$valid="veg";
Line #341://include("QQ_validPNZTAR.inc");
Line #342:$sft=0;
Line #343:$sdb=0;
Line #344:for ($i=0;$i<$dm+1;++$i){
Line #345: echo($i." ".$dd[$i]." ".$da[$i]." ".$dt[$i]." ");
Line #346:$sft=$sft+$da[$i];
Line #347:$sdb=$sdb+$dd[$i];
Line #348:}
Line #349: echo($dm." ".$sft." ".$sdb." ");
Line #350:*/
Line #351:
Line #352:if (isset($_GET[nyomtat])) {
Line #353:include("QJ_listaveg.php");
Line #354:
Line #355:echo("<body onload='printit()'></body>");
Line #356:
Line #357:?>
Line #358:<SCRIPT Language="Javascript">
Line #359:
Line #360:function printit(){
Line #361:
Line #362:
Line #363:window.print();
Line #364:///////////////////////////////////////
Line #365://window.open("QJ_gyujto.php", 'sframe');
Line #366:///////////////////////////////////////
Line #367:
Line #368:}
Line #369:
Line #370:
Line #371:</script>
Line #372:<?PHP
Line #373:}