Bi-Dir

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