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