Bi-Dir

QJ_napifull_MK_V3_MUSOR.inc

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