Bi-Dir

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