Bi-Dir

QJ_bossARosszSZERVEZO.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 <>'*' $bosSEL";
Line #36:
Line #37:$keres =$_SESSION[musorRAPORT_SQL];
Line #38:
Line #39:
Line #40://?//echo($keres."<hr>");
Line #41:
Line #42:
Line #43:$nur=mysql_num_rows($eredmeny);
Line #44:
Line #45:if ($nur==0 )
Line #46:{
Line #47:echo("<h1>Nincs adat!</h1>");
Line #48:exit;
Line #49:}
Line #50://///////////
Line #51:$wer=$bosSEL;
Line #52://///////////
Line #53:
Line #54:if ( $adoalany<>"") {
Line #55:$wer="";
Line #56:$wer=" and future <>'*' and (";
Line #57:$or= " ";
Line #58:while ( $jegysor = mysql_fetch_array( $eredmeny )){
Line #59:$arind[$ind]=trim($jegysor[ar]);
Line #60:$wer.=$or." datum_kod='$jegysor[datum_kod]' ";
Line #61:$or= " or ";
Line #62:
Line #63:}
Line #64:
Line #65:$wer.=" )";
Line #66:
Line #67:}
Line #68:
Line #69:
Line #70:$wery = "SELECT * from qj_login where email_kod='SyS' and passw='...SyS...'";
Line #71:$disR = mysql_query($wery) ;
Line #72:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #73:$adoalanyFEJ="<br><font color=blue>".$disC[nev]."</font>";
Line #74:}
Line #75:
Line #76:
Line #77:
Line #78:$L_PHP=$formcall."?&musor_kod=$musor_kod";
Line #79:include("QJ_listafej.php");
Line #80:
Line #81:
Line #82:$SQLjegy = "SELECT distinct ar FROM qj_jegy WHERE statusz<>'' and
Line #83: left(statusz,2)<>'El' and left(statusz,2)<>'St' $wer ORDER BY ar";
Line #84:
Line #85:
Line #86://?//echo($keres."<hr>");
Line #87:
Line #88:
Line #89:
Line #90://?//echo ($SQLjegy."<hr>");
Line #91:
Line #92:
Line #93:$arak="";
Line #94:$ind=0;
Line #95:
Line #96:
Line #97:while ( $jegysor = mysql_fetch_array( $szekek )){
Line #98:$arind[$ind]=trim($jegysor[ar]);
Line #99:$arak.="<td width=40 align=right><b>".$jegysor[ar]." </b> Ft</td>";
Line #100:++$ind;
Line #101:}
Line #102:
Line #103:
Line #104:
Line #105:
Line #106:if ($ind>0)
Line #107:
Line #108:else
Line #109:$arak="";
Line #110:
Line #111:
Line #112:if (isset($_GET[nyomtat])) $url=""; else
Line #113:
Line #114:";
Line #115:
Line #116:echo "<table wdht=100% border=1>
Line #117:<tr bgcolor=silver>
Line #118:$url
Line #119:
Line #120:
Line #121:
Line #122:".$arfej."
Line #123:</tr>";
Line #124:
Line #125:
Line #126:echo "
Line #127:<tr bgcolor=silver>
Line #128:<td width=60 align=right > Ft</td>
Line #129:<td width=60 align=right > Db</td>
Line #130:".$arak."
Line #131:</tr>";
Line #132:
Line #133:
Line #134:for ($j=0;$j<$ind;$j++) {
Line #135: $sardb[$j]=0;
Line #136:// echo $arind[$i]."/".$i."<hr>";
Line #137:
Line #138:}
Line #139:$i=0;
Line #140:
Line #141:
Line #142:
Line #143:
Line #144:$keres = "SELECT * FROM qj_musor where future <>'*' $bosSEL ORDER BY cim,datum_fej";
Line #145:
Line #146:$keres=$_SESSION[musorRAPORT_SQL];
Line #147:
Line #148://?//echo($keres."<hr>");
Line #149:
Line #150:
Line #151:
Line #152:while ( $musor = mysql_fetch_array( $eredmeny ) )
Line #153:{
Line #154:++$i;
Line #155:
Line #156:$helyszin_kod=$musor[hely_kod];
Line #157:$datum_kod=$musor[datum_kod];
Line #158:$cim_kod=$musor[cim_kod];
Line #159:$wjid=$musor[wid];
Line #160:
Line #161:$SQLjegy = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' AND
Line #162:statusz<>'' ORDER BY statusz";
Line #163:
Line #164:
Line #165:
Line #166:$nur=mysql_num_rows($szekek);
Line #167:$osft=0;
Line #168:$ertdb=0;
Line #169:
Line #170:
Line #171:$kpft=0;
Line #172:$kpdb=0;
Line #173:$bankft=0;
Line #174:$bankdb=0;
Line #175:$bhft=0;
Line #176:$bhdb=0;
Line #177:
Line #178:
Line #179:for ($j=0;$j<$ind;$j++) {
Line #180: $ardb[$j]=0;
Line #181:// echo $arind[$i]."/".$i."<hr>";
Line #182:
Line #183:}
Line #184:
Line #185:while ( $jegysor = mysql_fetch_array( $szekek ))
Line #186:{
Line #187:
Line #188:$statusz=substr($jegysor[statusz],0,2);
Line #189:
Line #190:if ($statusz<>'El' and $statusz<>'St') {
Line #191:for ($j=0;$j<$ind;$j++) {
Line #192:if ((1+$arind[$j])==(1+$jegysor[ar])) {
Line #193: ++$ardb[$j];
Line #194:++$sardb[$j];
Line #195://if ($i<3)
Line #196://echo $i."***/".$arind[$j].$statusz.$j."..../".$ardb[$j]."xxx/".$jegysor[ar]."wwwww<hr>";
Line #197:}}}
Line #198:
Line #199:
Line #200:$bhft=$bhft+$jegysor[ar];
Line #201:++$bhdb;
Line #202:$sumbhft=$sumbhft+$jegysor[ar];
Line #203:++$sumbhdb;
Line #204:$statusz="*";
Line #205:}
Line #206:
Line #207:
Line #208:$kpft=$kpft+$jegysor[ar];
Line #209:++$kpdb;
Line #210:$sumkpft=$sumkpft+$jegysor[ar];
Line #211:++$sumkpdb;
Line #212:}
Line #213:
Line #214:if ( $statusz=="Ba") {
Line #215:$bankft=$bankft+$jegysor[ar];
Line #216:++$bankdb;
Line #217:$sumbankft=$sumbankft+$jegysor[ar];
Line #218:++$sumbankdb;
Line #219:}
Line #220:
Line #221:if ($statusz<>'El' and $statusz<>'St') {
Line #222:
Line #223: $osft=$osft+$jegysor[ar];
Line #224: ++$ertdb;
Line #225: $sumosft=$sumosft+$jegysor[ar];
Line #226: ++$sumertdb;
Line #227:}
Line #228:}
Line #229:
Line #230://if ($ertdb>0) {
Line #231:
Line #232:$arir="";
Line #233:$swdb=0;
Line #234:
Line #235:for ($j=0;$j<$ind;$j++) {
Line #236:
Line #237:if (isset($_GET[nyomtat])) {
Line #238:if ($ardb[$j]>0)
Line #239:$arir.="<td width=40 align=right ><b>".$ardb[$j]." </b></td>";
Line #240:else
Line #241:$arir.="<td width=40 align=center >__</td>";
Line #242:
Line #243:}else {
Line #244:if ($ardb[$j]>0)
Line #245:$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 #246:else
Line #247:$arir.="<td width=40 align=center ><a title='".$arind[$j]." Ft' href=#>__</a></td>";
Line #248:}
Line #249:
Line #250:$swdb=$swdb+$ardb[$j];
Line #251:}
Line #252:$arir.="<td width=40 bgcolor=silver align=right><b>".$swdb." </b></td>";
Line #253:
Line #254:if ($swdb==0) $arir="";
Line #255:
Line #256:/*echo"<tr>
Line #257:<td align=left >
Line #258:<a href=NO_helyrajz.php?&musor_kod=$musor[datum_kod] >
Line #259:
Line #260:</a>$musor[cim]
Line #261: </td> - Nem kell !!! 2012.11.16. 23:56:43*/
Line #262:
Line #263:
Line #264: ><IMG width=20 height=20
Line #265: SRC='../_Screen/datum.gif' border=0></a>";
Line #266:
Line #267:
Line #268:<IMG width=20 height=20
Line #269:SRC='../_Screen/tsticky.gif' border=0></a>";
Line #270:
Line #271:
Line #272:href='QJ_vevoXLSlist.php?&musor_kod=$datum_kod' >
Line #273:
Line #274:
Line #275:$noha="
Line #276:<a href=NO_helyrajz.php?&musor_kod=$musor[datum_kod] >
Line #277:
Line #278:</a>";
Line #279:
Line #280:
Line #281:
Line #282:if (isset($_GET[nyomtat])) $url=""; else
Line #283:$url="<td align=left width=60>
Line #284:$noha $eref
Line #285:<a href=QJ_vevoBOSSlist.php?&musor_kod=$musor[datum_kod] >
Line #286:
Line #287:</a>
Line #288:$xls
Line #289: </td>
Line #290:";
Line #291:
Line #292:
Line #293:echo"<tr>$url
Line #294:<td align=left >
Line #295:
Line #296:$musor[cim]
Line #297: </td>
Line #298:
Line #299:
Line #300:<td align=center >
Line #301: $musor[datum]
Line #302: <br>
Line #303: <i>
Line #304: $musor[helyszin]
Line #305: </i>
Line #306: </td>
Line #307:<td align=right bgcolor=gold ><b>".number_format($osft)."</b></td>
Line #308:<td align=right bgcolor=gold ><b>".number_format($ertdb)."</b></td>
Line #309:".$arir. "
Line #310:</tr>";
Line #311://}
Line #312:
Line #313:}
Line #314:
Line #315:$arir="";
Line #316:$swdb=0;
Line #317:
Line #318:for ($j=0;$j<$ind;$j++) {
Line #319:$arir.="<td width=40 bgcolor=silver align=right><b>".$sardb[$j]." </b></td>";
Line #320:$swdb=$swdb+$sardb[$j];
Line #321:}
Line #322:
Line #323:$arir.="<td width=40 bgcolor=silver align=right><b>".$swdb." </b></td>";
Line #324:
Line #325:if ($swdb==0) $arir="";
Line #326:
Line #327:
Line #328:
Line #329:if (isset($_GET[nyomtat])) $url="<td colspan=2 align=right >"; else
Line #330:$url="<td colspan=3 align=right >
Line #331:";
Line #332:
Line #333:
Line #334:echo"<tr bgcolor=silver>
Line #335:$url
Line #336:
Line #337: </td>
Line #338:<td align=right ><b>".number_format($sumosft)."</b></td>
Line #339:<td align=right ><b>".number_format($sumertdb)."</b></td>
Line #340:".$arir. "
Line #341:</tr>";
Line #342:
Line #343:echo "</table>";
Line #344:
Line #345:
Line #346:if (isset($_SESSION[InfoURL]) and $_SESSION[InfoURL]<>"")
Line #347:echo("
Line #348:<BR><BR>
Line #349:<IFRAME SRC='$_SESSION[InfoURL]'
Line #350:WIDTH=1040 HEIGHT=800 border=0
Line #351:</IFRAME>
Line #352:");
Line #353:
Line #354:
Line #355:
Line #356:
Line #357:if (isset($_GET[nyomtat])) {
Line #358:include("QJ_listaveg.php");
Line #359:
Line #360:echo("<body onload='printit()'></body>");
Line #361:
Line #362:?>
Line #363:<SCRIPT Language="Javascript">
Line #364:
Line #365:function printit(){
Line #366:
Line #367:window.print();
Line #368:
Line #369:}
Line #370:
Line #371:</script>
Line #372:<?PHP
Line #373:}
Line #374:function mumber_format($ertek)
Line #375:{
Line #376:return $ertek;
Line #377:}
Line #378:?>