Bi-Dir

QJ_bossARossz.inc

Line #0:<?php
Line #1:// QJ_musorARoszz Ugyanez ????? 2013.09.21. 15:29:43
Line #2:
Line #3:
Line #4://unset($_SESSION[SQL_inet]);
Line #5:if (!isset($_SESSION[SQL_inet])) {
Line #6:
Line #7:++$_SESSION[QJ_hiba];
Line #8:
Line #9:echo "<script>
Line #10:
Line #11: window.open('QJ_unset.php','sframe');
Line #12: </script>";
Line #13:}
Line #14:$_SESSION[QJ_hiba]=0;
Line #15:
Line #16:$musor_kod=$_GET[musor_kod];
Line #17:
Line #18:if (isset($_GET[nyomtat])) {
Line #19:?>
Line #20:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #21:<?PHP
Line #22:}
Line #23:
Line #24:
Line #25:$sumosft=0;
Line #26:$sumertdb=0;
Line #27:$sumkpft=0;
Line #28:$sumkpdb=0;
Line #29:$sumbankft=0;
Line #30:$sumbankdb=0;
Line #31:$sumbhft=0;
Line #32:$sumbhdb=0;
Line #33:
Line #34:$ir="<table border=1>";
Line #35:
Line #36:
Line #37:$keres = "SELECT * FROM qj_musor where future <>'*' $bosSEL";
Line #38:
Line #39:
Line #40:
Line #41://?//echo($keres."<hr>");
Line #42:
Line #43:
Line #44:$nur=mysql_num_rows($eredmeny);
Line #45:
Line #46:if ($nur==0 )
Line #47:{
Line #48:echo("<h1>Nincs adat!</h1>");
Line #49:exit;
Line #50:}
Line #51://///////////
Line #52:$wer=$bosSEL;
Line #53://///////////
Line #54:
Line #55:if ( $adoalany<>"") {
Line #56:$wer="";
Line #57:$wer=" and future <>'*' and (";
Line #58:$or= " ";
Line #59:while ( $jegysor = mysql_fetch_array( $eredmeny )){
Line #60:$arind[$ind]=trim($jegysor[ar]);
Line #61:$wer.=$or." datum_kod='$jegysor[datum_kod]' ";
Line #62:$or= " or ";
Line #63:
Line #64:}
Line #65:
Line #66:$wer.=" )";
Line #67:
Line #68:}
Line #69:
Line #70:
Line #71:$wery = "SELECT * from qj_login where email_kod='SyS' and passw='...SyS...'";
Line #72:$disR = mysql_query($wery) ;
Line #73:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #74:$adoalanyFEJ="<br><font color=blue>".$disC[nev]."</font>";
Line #75:}
Line #76:
Line #77:
Line #78:
Line #79:$L_PHP="QJ_bossARossz.php?&musor_kod=$musor_kod";
Line #80:include("QJ_listafej.php");
Line #81:
Line #82:
Line #83:
Line #84:$SQLjegy = "SELECT distinct ar FROM qj_jegy WHERE statusz<>'' and
Line #85: left(statusz,2)<>'El' and left(statusz,2)<>'St' $wer ORDER BY ar";
Line #86:
Line #87:
Line #88://?//echo($keres."<hr>");
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:
Line #138:
Line #139:
Line #140:$keres = "SELECT * FROM qj_musor where future <>'*' $bosSEL ORDER BY cim,datum_fej";
Line #141:
Line #142://?//echo($keres."<hr>");
Line #143:
Line #144:
Line #145:
Line #146:while ( $musor = mysql_fetch_array( $eredmeny ) )
Line #147:{
Line #148:++$i;
Line #149:
Line #150:$helyszin_kod=$musor[hely_kod];
Line #151:$datum_kod=$musor[datum_kod];
Line #152:$cim_kod=$musor[cim_kod];
Line #153:$wjid=$musor[wid];
Line #154:
Line #155:$SQLjegy = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' AND
Line #156:statusz<>'' ORDER BY statusz";
Line #157:
Line #158:
Line #159:
Line #160:$nur=mysql_num_rows($szekek);
Line #161:$osft=0;
Line #162:$ertdb=0;
Line #163:
Line #164:
Line #165:$kpft=0;
Line #166:$kpdb=0;
Line #167:$bankft=0;
Line #168:$bankdb=0;
Line #169:$bhft=0;
Line #170:$bhdb=0;
Line #171:
Line #172:
Line #173:for ($j=0;$j<$ind;$j++) {
Line #174: $ardb[$j]=0;
Line #175:// echo $arind[$i]."/".$i."<hr>";
Line #176:
Line #177:}
Line #178:
Line #179:while ( $jegysor = mysql_fetch_array( $szekek ))
Line #180:{
Line #181:
Line #182:$statusz=substr($jegysor[statusz],0,2);
Line #183:
Line #184:if ($statusz<>'El' and $statusz<>'St') {
Line #185:for ($j=0;$j<$ind;$j++) {
Line #186:if ((1+$arind[$j])==(1+$jegysor[ar])) {
Line #187: ++$ardb[$j];
Line #188:++$sardb[$j];
Line #189://if ($i<3)
Line #190://echo $i."***/".$arind[$j].$statusz.$j."..../".$ardb[$j]."xxx/".$jegysor[ar]."wwwww<hr>";
Line #191:}}}
Line #192:
Line #193:
Line #194:$bhft=$bhft+$jegysor[ar];
Line #195:++$bhdb;
Line #196:$sumbhft=$sumbhft+$jegysor[ar];
Line #197:++$sumbhdb;
Line #198:$statusz="*";
Line #199:}
Line #200:
Line #201:
Line #202:$kpft=$kpft+$jegysor[ar];
Line #203:++$kpdb;
Line #204:$sumkpft=$sumkpft+$jegysor[ar];
Line #205:++$sumkpdb;
Line #206:}
Line #207:
Line #208:if ( $statusz=="Ba") {
Line #209:$bankft=$bankft+$jegysor[ar];
Line #210:++$bankdb;
Line #211:$sumbankft=$sumbankft+$jegysor[ar];
Line #212:++$sumbankdb;
Line #213:}
Line #214:
Line #215:if ($statusz<>'El' and $statusz<>'St') {
Line #216:
Line #217: $osft=$osft+$jegysor[ar];
Line #218: ++$ertdb;
Line #219: $sumosft=$sumosft+$jegysor[ar];
Line #220: ++$sumertdb;
Line #221:}
Line #222:}
Line #223:
Line #224://if ($ertdb>0) {
Line #225:
Line #226:$arir="";
Line #227:$swdb=0;
Line #228:
Line #229:for ($j=0;$j<$ind;$j++) {
Line #230:
Line #231:if (isset($_GET[nyomtat])) {
Line #232:if ($ardb[$j]>0)
Line #233:$arir.="<td width=40 align=right ><b>".$ardb[$j]." </b></td>";
Line #234:else
Line #235:$arir.="<td width=40 align=center >__</td>";
Line #236:
Line #237:}else {
Line #238:if ($ardb[$j]>0)
Line #239:$arir.="<td width=40 align=right bgcolor=azure title='$arind[$ind]' ><b>".$ardb[$j]." </b> <a title='".$arind[$j]." Ft' href=# ><b> db </b></a></td>";
Line #240:else
Line #241:$arir.="<td width=40 align=center ><a title='".$arind[$j]." Ft' href=#>__</a></td>";
Line #242:}
Line #243:
Line #244:$swdb=$swdb+$ardb[$j];
Line #245:}
Line #246:$arir.="<td width=40 bgcolor=silver align=right><b>".$swdb." </b></td>";
Line #247:
Line #248:echo"<tr>
Line #249:<td align=left >
Line #250:<a href=NO_helyrajz.php?&musor_kod=$musor[datum_kod] >
Line #251:
Line #252:</a>$musor[cim]
Line #253: </td>
Line #254:
Line #255:<td align=center >
Line #256: $musor[datum]
Line #257: <br>
Line #258: <i>
Line #259: $musor[helyszin]
Line #260: </i>
Line #261: </td>
Line #262:<td align=right bgcolor=gold ><b>".number_format($osft)."</b></td>
Line #263:<td align=right bgcolor=gold ><b>".number_format($ertdb)."</b></td>
Line #264:".$arir. "
Line #265:</tr>";
Line #266://}
Line #267:
Line #268:}
Line #269:
Line #270:$arir="";
Line #271:$swdb=0;
Line #272:
Line #273:for ($j=0;$j<$ind;$j++) {
Line #274:$arir.="<td width=40 bgcolor=silver align=right><b>".$sardb[$j]." </b></td>";
Line #275:$swdb=$swdb+$sardb[$j];
Line #276:}
Line #277:
Line #278:$arir.="<td width=40 bgcolor=silver align=right><b>".$swdb." </b></td>";
Line #279:
Line #280:
Line #281:echo"<tr bgcolor=silver>
Line #282:<td colspan=2 align=right >
Line #283:
Line #284: </td>
Line #285:<td align=right ><b>".number_format($sumosft)."</b></td>
Line #286:<td align=right ><b>".number_format($sumertdb)."</b></td>
Line #287:".$arir. "
Line #288:</tr>";
Line #289:
Line #290:echo "</table>";
Line #291:
Line #292:
Line #293:// QJ_musorARoszz Ugyanez ????? 2013.09.21. 15:29:43
Line #294:if (isset($_SESSION[InfoURL]) and $_SESSION[InfoURL]<>"")
Line #295:echo("
Line #296:<BR><BR>
Line #297:<IFRAME SRC='$_SESSION[InfoURL]'
Line #298:WIDTH=1020 HEIGHT=760 border=0
Line #299:</IFRAME>
Line #300:");
Line #301:
Line #302:
Line #303:
Line #304:
Line #305:if (isset($_GET[nyomtat])) {
Line #306:include("QJ_listaveg.php");
Line #307:
Line #308:echo("<body onload='printit()'></body>");
Line #309:
Line #310:?>
Line #311:<SCRIPT Language="Javascript">
Line #312:
Line #313:function printit(){
Line #314:
Line #315:window.print();
Line #316:
Line #317:}
Line #318:
Line #319:</script>
Line #320:<?PHP
Line #321:}
Line #322:function mumber_format($ertek)
Line #323:{
Line #324:return $ertek;
Line #325:}
Line #326:?>