Bi-Dir

QJ_musorARossz.inc

Line #0:<?php
Line #1:
Line #2://unset($_SESSION[SQL_inet]);
Line #3:if (!isset($_SESSION[SQL_inet])) {
Line #4:
Line #5:++$_SESSION[QJ_hiba];
Line #6:
Line #7:echo "<script>
Line #8:
Line #9: window.open('QJ_unset.php','sframe');
Line #10: </script>";
Line #11:}
Line #12:$_SESSION[QJ_hiba]=0;
Line #13:
Line #14:
Line #15:if (isset($_GET[nyomtat])) {
Line #16:?>
Line #17:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #18:<?PHP
Line #19:} else {
Line #20:$selEVHO="musor";
Line #21:
Line #22://include("../_inc_QJ/QQ_evhoSELECT.inc");
Line #23:
Line #24:}
Line #25:
Line #26:
Line #27:$sumosft=0;
Line #28:$sumertdb=0;
Line #29:$sumkpft=0;
Line #30:$sumkpdb=0;
Line #31:$sumbankft=0;
Line #32:$sumbankdb=0;
Line #33:$sumbhft=0;
Line #34:$sumbhdb=0;
Line #35:
Line #36:$ir="<table border=1>";
Line #37:
Line #38:
Line #39:$Rhonap=str_replace("-",".",$_POST[Rhonap]); // biztos, ami biztos !!!
Line #40:
Line #41:if ($Rhonap<>"*") $werEVHO=" and datum_evho='$Rhonap'"; else $werEVHO="";
Line #42:
Line #43:
Line #44:$werEVHO="";
Line #45:$keres = "SELECT * FROM qj_musor where future <>'*' $adoalany $werEVHO ORDER BY cim,datum_fej";
Line #46:
Line #47://?//echo($keres."<hr>".$adoalany."<hr>".$werEVHO);
Line #48:
Line #49:
Line #50:$nur=mysql_num_rows($eredmeny);
Line #51:
Line #52:$wer="";
Line #53:if ( $adoalany<>"") {
Line #54:$wer=" and future <>'*' and (";
Line #55:$or= " ";
Line #56:while ( $jegysor = mysql_fetch_array( $eredmeny )){
Line #57:$arind[$ind]=trim($jegysor[ar]);
Line #58:$wer.=$or." datum_kod='$jegysor[datum_kod]' ";
Line #59:$or= " or ";
Line #60:
Line #61:}
Line #62:
Line #63:$wer.=" )";
Line #64:
Line #65:}
Line #66:
Line #67:
Line #68:
Line #69:
Line #70:$L_PHP="QJ_musorARossz.php";
Line #71:include("QJ_listafej.php");
Line #72:
Line #73:
Line #74://<img src='../_Screen/xls.gif' border=0>  Jogdij adatok... </a>");
Line #75:
Line #76:
Line #77:
Line #78:$SQLjegy = "SELECT distinct ar FROM qj_jegy WHERE statusz<>'' and
Line #79: left(statusz,2)<>'El' and left(statusz,2)<>'St' $wer ORDER BY ar";
Line #80:
Line #81:
Line #82:
Line #83://?//echo ($SQLjegy."<hr>");
Line #84:
Line #85:
Line #86:$arak="";
Line #87:$ind=0;
Line #88:
Line #89:
Line #90:while ( $jegysor = mysql_fetch_array( $szekek )){
Line #91:$arind[$ind]=trim($jegysor[ar]);
Line #92:$arak.="<td width=40 align=right><b>".$jegysor[ar]." </b> Ft</td>";
Line #93:++$ind;
Line #94:}
Line #95:
Line #96:
Line #97:
Line #98:
Line #99:if ($ind>0)
Line #100:
Line #101:else
Line #102:$arak="";
Line #103:
Line #104:echo "<table wdht=100% border=1>
Line #105:<tr bgcolor=silver>
Line #106:
Line #107:
Line #108:
Line #109:".$arfej."
Line #110:</tr>";
Line #111:
Line #112:
Line #113:echo "
Line #114:<tr bgcolor=silver>
Line #115:<td width=60 align=right > Ft</td>
Line #116:<td width=60 align=right > Db</td>
Line #117:".$arak."
Line #118:</tr>";
Line #119:
Line #120:
Line #121:for ($j=0;$j<$ind;$j++) {
Line #122: $sardb[$j]=0;
Line #123:// echo $arind[$i]."/".$i."<hr>";
Line #124:
Line #125:}
Line #126:$i=0;
Line #127:
Line #128:$keres = "SELECT * FROM qj_musor where future <>'*' $adoalany $werEVHO ORDER BY cim,datum_fej";
Line #129:
Line #130://?//echo ($keres."<hr>".$wer);
Line #131:
Line #132:
Line #133:
Line #134:while ( $musor = mysql_fetch_array( $eredmeny ) )
Line #135:{
Line #136:++$i;
Line #137:
Line #138:$helyszin_kod=$musor[hely_kod];
Line #139:$datum_kod=$musor[datum_kod];
Line #140:$cim_kod=$musor[cim_kod];
Line #141:$wjid=$musor[wid];
Line #142:
Line #143:$SQLjegy = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' AND
Line #144:statusz<>'' ORDER BY statusz";
Line #145:
Line #146:
Line #147:$nur=mysql_num_rows($szekek);
Line #148:$osft=0;
Line #149:$ertdb=0;
Line #150:
Line #151:
Line #152:$kpft=0;
Line #153:$kpdb=0;
Line #154:$bankft=0;
Line #155:$bankdb=0;
Line #156:$bhft=0;
Line #157:$bhdb=0;
Line #158:
Line #159:
Line #160:for ($j=0;$j<$ind;$j++) {
Line #161: $ardb[$j]=0;
Line #162:// echo $arind[$i]."/".$i."<hr>";
Line #163:
Line #164:}
Line #165:
Line #166:while ( $jegysor = mysql_fetch_array( $szekek ))
Line #167:{
Line #168:
Line #169:$statusz=substr($jegysor[statusz],0,2);
Line #170:
Line #171:if ($statusz<>'El' and $statusz<>'St') {
Line #172:for ($j=0;$j<$ind;$j++) {
Line #173:if ((1+$arind[$j])==(1+$jegysor[ar])) {
Line #174: ++$ardb[$j];
Line #175:++$sardb[$j];
Line #176://if ($i<3)
Line #177://echo $i."***/".$arind[$j].$statusz.$j."..../".$ardb[$j]."xxx/".$jegysor[ar]."wwwww<hr>";
Line #178:}}}
Line #179:
Line #180:
Line #181:$bhft=$bhft+$jegysor[ar];
Line #182:++$bhdb;
Line #183:$sumbhft=$sumbhft+$jegysor[ar];
Line #184:++$sumbhdb;
Line #185:$statusz="*";
Line #186:}
Line #187:
Line #188:
Line #189:$kpft=$kpft+$jegysor[ar];
Line #190:++$kpdb;
Line #191:$sumkpft=$sumkpft+$jegysor[ar];
Line #192:++$sumkpdb;
Line #193:}
Line #194:
Line #195:if ( $statusz=="Ba") {
Line #196:$bankft=$bankft+$jegysor[ar];
Line #197:++$bankdb;
Line #198:$sumbankft=$sumbankft+$jegysor[ar];
Line #199:++$sumbankdb;
Line #200:}
Line #201:
Line #202:if ($statusz<>'El' and $statusz<>'St') {
Line #203:
Line #204: $osft=$osft+$jegysor[ar];
Line #205: ++$ertdb;
Line #206: $sumosft=$sumosft+$jegysor[ar];
Line #207: ++$sumertdb;
Line #208:}
Line #209:}
Line #210:
Line #211://if ($ertdb>0) {
Line #212:
Line #213:$arir="";
Line #214:$swdb=0;
Line #215:
Line #216:for ($j=0;$j<$ind;$j++) {
Line #217:$arir.="<td width=40 align=right><b>".$ardb[$j]." </b></td>";
Line #218:$swdb=$swdb+$ardb[$j];
Line #219:}
Line #220:$arir.="<td width=40 bgcolor=silver align=right><b>".$swdb." </b></td>";
Line #221:
Line #222:
Line #223:
Line #224: ><IMG width=20 height=20 SRC='../_Screen/napi.png' border=0>
Line #225: </a>";
Line #226:
Line #227:echo"<tr>
Line #228:
Line #229:<td align=left >
Line #230:<a href=NO_helyrajz.php?&musor_kod=$musor[datum_kod] >
Line #231:
Line #232:</a>
Line #233: $szigor 
Line #234:$musor[cim]
Line #235: </td>
Line #236:
Line #237:<td align=center >
Line #238: $musor[datum]
Line #239: <br>
Line #240: <i>
Line #241: $musor[helyszin]
Line #242: </i>
Line #243: </td>
Line #244:<td align=right bgcolor=gold ><b>".number_format($osft)."</b></td>
Line #245:<td align=right bgcolor=gold ><b>".number_format($ertdb)."</b></td>
Line #246:".$arir. "
Line #247:</tr>";
Line #248://}
Line #249:
Line #250:}
Line #251:
Line #252:$arir="";
Line #253:$swdb=0;
Line #254:
Line #255:for ($j=0;$j<$ind;$j++) {
Line #256:$arir.="<td width=40 bgcolor=silver align=right><b>".$sardb[$j]." </b></td>";
Line #257:$swdb=$swdb+$sardb[$j];
Line #258:}
Line #259:
Line #260:$arir.="<td width=40 bgcolor=silver align=right><b>".$swdb." </b></td>";
Line #261:
Line #262:
Line #263:echo"<tr bgcolor=silver>
Line #264:<td colspan=2 align=right >
Line #265:
Line #266: </td>
Line #267:<td align=right ><b>".number_format($sumosft)."</b></td>
Line #268:<td align=right ><b>".number_format($sumertdb)."</b></td>
Line #269:".$arir. "
Line #270:</tr>";
Line #271:
Line #272:echo "</table>";
Line #273:
Line #274:
Line #275:if (isset($_SESSION[InfoURL]) and $_SESSION[InfoURL]<>"")
Line #276:echo("
Line #277:<BR><BR>
Line #278:<IFRAME SRC='$_SESSION[InfoURL]'
Line #279:WIDTH=1020 HEIGHT=760 border=0
Line #280:</IFRAME>
Line #281:");
Line #282:
Line #283:if (isset($_GET[nyomtat])) {
Line #284:include("QJ_listaveg.php");
Line #285:
Line #286:echo("<body onload='printit()'></body>");
Line #287:
Line #288:?>
Line #289:<SCRIPT Language="Javascript">
Line #290:
Line #291:function printit(){
Line #292:
Line #293:window.print();
Line #294:
Line #295:}
Line #296:
Line #297:</script>
Line #298:<?PHP
Line #299:}
Line #300:function mumber_format($ertek)
Line #301:{
Line #302:return $ertek;
Line #303:}
Line #304:?>