QJ_haviPENZTARsport.inc

---

Line #0:<?php
Line #1:
Line #2:if (isset($_GET[nyomtat])) {
Line #3:?>
Line #4:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #5:<?PHP
Line #6:$keres=$_SESSION[musorRAPORT_SQL];
Line #7:$szin="";
Line #8:} else {
Line #9:unset($_SESSION[musorRAPORT_SQL]);
Line #10:$szin=" bgcolor=gold ";
Line #11:
Line #12:
Line #13:$sum_osft=0;
Line #14:$sum_osdb=0;
Line #15:$sum_ertdb=0;
Line #16:$sum_elodb=0;
Line #17:$sum_uresdb=0;
Line #18:$sum_csopdb=0;
Line #19:$sum_potdb=0;
Line #20:$sum_nulldb=0;
Line #21:$ir="<table border=1>";
Line #22:
Line #23:IF (isset($_POST[ujho])) $_SESSION[musor_ujho]=$_POST[ujho];
Line #24:IF (isset($_SESSION[musor_ujho])) $_POST[ujho]=$_SESSION[musor_ujho];
Line #25:
Line #26:IF (isset($_POST[ujevho])) $_SESSION[musor_ujevho]=$_POST[ujevho];
Line #27:IF (isset($_SESSION[musor_ujevho])) $_POST[ujevho]=$_SESSION[musor_ujevho];
Line #28:
Line #29:IF (isset($_POST[sorrend])) $_SESSION[musorrend]=$_POST[sorrend];
Line #30:IF (isset($_SESSION[musorrend])) $_POST[sorrend]=$_SESSION[musorrend];
Line #31:
Line #32:IF (isset($_POST[helyszin])) $_SESSION[hely_nev]=$_POST[helyszin];
Line #33:IF (isset($_SESSION[hely_nev])) $_POST[helyszin]=$_SESSION[hely_nev];
Line #34:
Line #35:
Line #36:IF (!isset($_POST[Rhonap]) and !isset($_SESSION[Rhonap]) or substr($_SESSION[Rhonap],0,1)<>"2")
Line #37:$_POST[Rhonap]=date("Y.m");
Line #38://$_POST[Rhonap]=substr($_COOKIE[date],0,4).".".substr($_COOKIE[date],5,2);
Line #39:
Line #40:IF (isset($_POST[Rhonap])) $_SESSION[Rhonap]=$_POST[Rhonap];
Line #41:IF (isset($_SESSION[Rhonap])) $_POST[Rhonap]=$_SESSION[Rhonap];
Line #42:
Line #43:
Line #44:$formcall="QJ_haviPENZTARsport.php";
Line #45:////////////////////////////////////////include("BI_musorFILTER.php");
Line #46:
Line #47:$es="";
Line #48:$ha=" where ";
Line #49:$ha="";
Line #50:$wer="";
Line #51:
Line #52:if (isset($_POST[cim]) and $_POST[cim]<>"*") {
Line #53:$wer=$ha." cim='".$_POST[cim]."'" ;
Line #54:$es=" AND ";
Line #55:$ha="";
Line #56:}
Line #57:
Line #58:if (isset($_POST[helyszin]) and $_POST[helyszin]<>"*") {
Line #59:$wer.= $ha. $es. " helyszin='".$_POST[helyszin]."'";
Line #60:$es=" AND ";
Line #61:$ha="";
Line #62:}
Line #63:
Line #64:if (isset($_POST[datum_fej]) and $_POST[datum_fej]<>"*") {
Line #65:$wer.= $ha. $es. " datum_fej='".$_POST[datum_fej]."'";
Line #66:$es=" AND ";
Line #67:$ha="";
Line #68:}
Line #69:
Line #70:if (isset($_POST[Rhonap]) and $_POST[Rhonap]<>"*") {
Line #71:$wer.= $ha. $es. " datum_evho='".$_POST[Rhonap]."'";
Line #72:$es=" AND ";
Line #73:$ha="";
Line #74:}
Line #75:
Line #76:$wer.=$es;
Line #77:
Line #78:$disQ = "SELECT distinct cim FROM qj_musor order by cim" ;
Line #79:
Line #80:
Line #81:$sel1="&nbsp;&nbsp;<SELECT TITLE='cim'
Line #82:onchange=this.form.submit(); return true name='cim'>";
Line #83:
Line #84:
Line #85:
Line #86:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #87:if ($disC[cim]==$_POST[cim]) $sel="SELECTED"; else $sel="";
Line #88:if (trim($disC[cim])<>"")
Line #89:$sel1.="<option value='".$disC[cim]."' $sel >".$disC[cim]."</option>";
Line #90:}
Line #91:
Line #92:$sel1.="</SELECT>";
Line #93:
Line #94:
Line #95:$disQ = "SELECT distinct helyszin FROM qj_musor order by helyszin" ;
Line #96:
Line #97:
Line #98:
Line #99:onchange=this.form.submit(); return true name='helyszin'>";
Line #100:
Line #101:
Line #102:
Line #103:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #104:if ($disC[helyszin]==$_POST[helyszin]) $sel="SELECTED"; else $sel="";
Line #105:if (trim($disC[helyszin])<>"")
Line #106:$sel2.="<option value='".$disC[helyszin]."' $sel >".$disC[helyszin]."</option>";
Line #107:}
Line #108:
Line #109:$sel2.="</SELECT>";
Line #110:
Line #111:$disQ = "SELECT distinct datum_fej FROM qj_musor order by datum_fej" ;
Line #112:
Line #113:
Line #114:$sel3="&nbsp;&nbsp;<SELECT TITLE='Nap'
Line #115:onchange=this.form.submit(); return true name='datum_fej'>";
Line #116:
Line #117:
Line #118:
Line #119:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #120:if ($disC[datum_fej]==$_POST[datum_fej]) $sel="SELECTED"; else $sel="";
Line #121:if (trim($disC[datum_fej])<>"")
Line #122:$sel3.="<option value='".$disC[datum_fej]."' $sel >".$disC[datum_fej]."</option>";
Line #123:}
Line #124:
Line #125:$sel3.="</SELECT>";
Line #126://///////////////////////////
Line #127:
Line #128:$disQ = "SELECT distinct datum_evho as datum FROM qj_musor order by datum_evho " ;
Line #129:
Line #130:
Line #131:
Line #132:onchange=this.form.submit(); return true name='Rhonap'>";
Line #133:
Line #134:
Line #135:
Line #136:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #137:
Line #138:$datum=$disC[datum];
Line #139:
Line #140:if ($datum==$_POST[Rhonap]) $sel="SELECTED"; else $sel="";
Line #141:if (trim($datum)<>"")
Line #142:$sel4.="<option value='".$datum."' $sel >".$datum."</option>";
Line #143:}
Line #144:
Line #145:$sel4.="</SELECT>";
Line #146:
Line #147:///////////////////////////////////
Line #148:
Line #149:$sql="SELECT * FROM qj_sql where szoveg='musor_ord' and archiv<>'*' and future<>'*' ORDER BY widarc";
Line #150:
Line #151:$psor = mysql_fetch_array( $sqlpar );
Line #152:$fid=$psor[sql_memo];
Line #153:$h=split(':',$fid);
Line #154:$nORD=count($h)-1;
Line #155:
Line #156:if (!isset($_POST[sorrend])) $_POST[sorrend]=$h[0];
Line #157:$ord=" order by ".$_POST[sorrend];
Line #158:
Line #159:$sel5="&nbsp;&nbsp;<b>Sorrend:</b><SELECT TITLE='Sorrend'
Line #160:onchange=this.form.submit(); return true name='sorrend'>";
Line #161:
Line #162:for ($i=0;$i<$nORD;$i++) {
Line #163:
Line #164:if ($h[$i]==$_POST[sorrend]) $sel="SELECTED"; else $sel="";
Line #165:$sel5.="<option value='".$h[$i]."' $sel >".$h[$i]."</option>";
Line #166:}
Line #167:
Line #168:$sel5.="</SELECT>";
Line #169:
Line #170:
Line #171:
Line #172:$ord=" order by rovid_helyszin,cim,datum ";
Line #173:
Line #174:IF ($_SESSION[admin]<>"ADMIN") $archiv=" archiv <>'*' "; else $archiv=" future <>'*'";
Line #175:
Line #176:$archiv=" future <>'*'";
Line #177:$login=$_SESSION[login];
Line #178:
Line #179:$keres = "SELECT * FROM qj_musor where $wer future <>'*' and rovid_helyszin='Sportcsarnok' $latni $JeBe $WEB $ord ";
Line #180:
Line #181:$_SESSION[musorRAPORT_SQL]=$keres;
Line #182:}
Line #183:
Line #184:
Line #185:
Line #186://if ($_SESSION[hely_nev]<>"*") $L_cim.="<br>".$_SESSION[hely_nev];
Line #187:
Line #188:$L_PHP="QJ_haviPENZTARsport.php";
Line #189:include("QJ_listafej.php");
Line #190:
Line #191:// echo($keres."<hr>");
Line #192:
Line #193:$jegySEL="";
Line #194:IF (isset($_SESSION[Rhonap]) and $_SESSION[Rhonap]<>"*")
Line #195:$jegySEL= " and left(logtime,7)='".substr($_SESSION[Rhonap],0,4)."-".substr($_SESSION[Rhonap],5,2)."' ";
Line #196:
Line #197:$keres = "SELECT distinct datum_kod FROM qj_jegy where future <>'*' $jegySEL";
Line #198:$keres = "SELECT distinct datum_kod FROM qj_jegy where future <>'*' ";
Line #199:
Line #200://?//echo($keres."<hr>");
Line #201:
Line #202:
Line #203:
Line #204:$wer=" and (";
Line #205:$or= " ";
Line #206:while ( $jegysor = mysql_fetch_array( $eredmeny )){
Line #207:
Line #208:$jegyHELY=" where datum_kod='$jegysor[datum_kod]' ";
Line #209:IF (isset($_SESSION[hely_nev]) and $_SESSION[hely_nev]<>"*")
Line #210:$jegyHELY.= " and helyszin='".$_SESSION[hely_nev]."' ";
Line #211:
Line #212://$Mkeres = "SELECT * FROM qj_musor $jegyHELY";
Line #213://
Line #214:$Mkeres = "SELECT * FROM qj_musor where rovid_helyszin='Sportcsarnok'";
Line #215:
Line #216:
Line #217:$musor = mysql_fetch_array( $Meredmeny);
Line #218:$Mur=mysql_num_rows($Meredmeny);
Line #219://?//echo($Mkeres."<hr>".$musor[rovid_helyszin]."<hr>");
Line #220:
Line #221:if ($Mur>0 and $musor[rovid_helyszin]=="Sportcsarnok") {
Line #222:$wer.=$or." datum_kod='$jegysor[datum_kod]' ";
Line #223:$or= " or ";
Line #224:}}
Line #225:
Line #226:$wer.=" )";
Line #227:
Line #228://////////////////////////////////////
Line #229:$keres="SELECT distinct bizomanyos FROM qj_jegy where future <>'*' and ar>0 $wer ORDER BY bizomanyos";
Line #230:$_SESSION[HoHelyWer]=$keres;
Line #231://?//echo($keres."<hr>");
Line #232:
Line #233:
Line #234:$Pi=0;
Line #235:
Line #236:while ( $egy_sor = mysql_fetch_array( $eredmeny ) )
Line #237:{
Line #238:if ($egy_sor[bizomanyos]<>"") {
Line #239:++$Pi;
Line #240:$Pt[$Pi]=$egy_sor[bizomanyos];
Line #241:}}
Line #242:
Line #243:
Line #244:
Line #245:echo "<table border=1 width=100% >
Line #246:<tr bgcolor=silver>
Line #247:
Line #248:<td width=60 align=right ><b>Ft</td>
Line #249:<td width=40 align=right ><b>Db</td>
Line #250:";
Line #251:
Line #252:for ($i=1;$i<$Pi;$i++) {
Line #253:echo "
Line #254:<td align=right width=40 ><b>$Pt[$i]</b></td>
Line #255:";
Line #256:}
Line #257:
Line #258:echo "</tr>";
Line #259:
Line #260:for ($i=1;$i<$Pi;$i++) {
Line #261: $Posft[$i]=0;
Line #262:}
Line #263:
Line #264://////////////////////////////////////
Line #265:$keres="SELECT * FROM qj_musor where future <>'*' and rovid_helyszin='Sportcsarnok' $wer ORDER BY datum_evho,rovid_helyszin,datum,cim";
Line #266:
Line #267://?//echo($keres."<hr>");
Line #268:
Line #269:
Line #270:$nur=mysql_num_rows($eredmeny);
Line #271:
Line #272:$i=0;
Line #273://////////////////////////////////////////////////
Line #274:while ( $musor = mysql_fetch_array( $eredmeny ))
Line #275:{
Line #276://////////////////////////////////////////////////
Line #277:
Line #278:++$i;
Line #279:
Line #280:for ($i=1;$i<$Pi;$i++) {
Line #281: $Pmusft[$i]=0;
Line #282:}
Line #283:
Line #284:$helyszin_kod=$musor[hely_kod];
Line #285:$datum_kod=$musor[datum_kod];
Line #286:$cim_kod=$musor[cim_kod];
Line #287:$cim_url=$musor[cim_url];
Line #288:$kep_url=$musor[kep_url];
Line #289:$wjid=$musor[wid];
Line #290:if ($musor[archiv]=="*") $rejtett="<br><font color=red size=+2>Rejtett</font>"; else $rejtett="";
Line #291:
Line #292:
Line #293://$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' and archiv='-'
Line #294://and not $_SESSION[SQL_inet] and ar>0 ORDER BY vevo_kod";
Line #295: ////////
Line #296:
Line #297:$SQLszek = "SELECT * FROM qj_jegy WHERE archiv='-' and datum_kod='$datum_kod' $jegySEL
Line #298: and not $_SESSION[SQL_inet] ORDER BY wid";
Line #299:
Line #300:
Line #301:
Line #302://?//echo($SQLszek."<hr>");
Line #303:
Line #304:$nur=mysql_num_rows($szekek);
Line #305:$osft=0;
Line #306:$ertdb=0;
Line #307:$elodb=0;
Line #308:$uresdb=0;
Line #309:$csopdb=0;
Line #310:$potdb=0;
Line #311:$nulldb=0;
Line #312:$vevo_kod=0;
Line #313:$csoportjel="N";
Line #314:
Line #315:while ( $jegysor = mysql_fetch_array( $szekek ))
Line #316:{
Line #317:$statusz=substr($jegysor[statusz],0,2);
Line #318:
Line #319:if ($statusz<>'' and $statusz<>'El' and $statusz<>'St' and $statusz<>'In') {
Line #320: $osft=$osft+$jegysor[ar];
Line #321: ++$ertdb;
Line #322:for ($i=1;$i<$Pi;$i++) {
Line #323:if ($Pt[$i]==$jegysor[bizomanyos]) {
Line #324: $Pmusft[$i]=$Pmusft[$i]+$jegysor[ar];
Line #325: $Posft[$i]=$Posft[$i]+$jegysor[ar];
Line #326:}}
Line #327:
Line #328: if ($jegysor[ar]==0) ++$nulldb;
Line #329:
Line #330:} elseif ($statusz=='El' and $csoportjel=="N") ++$elodb;
Line #331: elseif (($statusz=='El' or $statusz=='In') and $csoportjel=="Y") ++$csopdb;
Line #332: else ++$uresdb;
Line #333:}
Line #334:
Line #335:$cimkieg="";
Line #336:if($musor[cimkieg1]<>" " ) $cimkieg.="<br><i>".$musor[cimkieg1]."</i>";
Line #337:if($musor[cimkieg2]<>" " ) $cimkieg.="<br><i>".$musor[cimkieg2]."</i>";
Line #338:
Line #339:
Line #340:IF ($nur==0) $erkezesi="<BR><b>Nincs megnyitva!</b>";
Line #341:
Line #342://if ($login=="BI(c)") $edit="<a href=BI_ediTable.php?&wjid=$wjid&sqlfile=qj_musor>"; else $edit="<a>";
Line #343:
Line #344:
Line #345: target=adatframe >";
Line #346:
Line #347:
Line #348: target=adatframe >";
Line #349:
Line #350:
Line #351: target=adatframe ><IMG width=20 height=20
Line #352: SRC='../_Screen/datum.gif' border=0></a>";
Line #353:
Line #354:
Line #355:<IMG width=20 height=20
Line #356:SRC='../_Screen/people.bmp' border=0></a>";
Line #357:$bref="";
Line #358:
Line #359:$cref="<a href=QJ_raportNEW.php?&musor_kod=$datum_kod title='Raport lap' target=adatframe>
Line #360:<IMG width=20 height=20
Line #361:SRC='../_Screen/transfer.gif' border=0></a>";
Line #362:
Line #363:
Line #364:<IMG width=20 height=20
Line #365:SRC='../_Screen/tsticky.gif' border=0></a>";
Line #366:
Line #367:
Line #368:href='QJ_vevoXLSlist.php?&musor_kod=$datum_kod' >
Line #369:
Line #370:
Line #371:if ($_SESSION[login]=="BI(c)")
Line #372:$copys="<a target=adatframe
Line #373:href='QJ_musorCOPY.php?&wjid=$wjid' >
Line #374:
Line #375: SRC='../_Screen/transfer.png' border=0></a>";
Line #376:else $copys="";
Line #377:
Line #378:
Line #379:
Line #380:else $ma="";
Line #381:
Line #382:if (!isset($_GET[nyomtat]))
Line #383:$medi="<a href=QJ_musorPUBLIC.php?&wjid=$wjid
Line #384: target=adatframe><b>$musor[cim]</b>
Line #385:<IMG width=20 height=20 SRC='../_Screen/edit.png' border=0>
Line #386: </a>".$ma.$cimkieg. $erkezesi; else $medi="<b>$musor[cim]</b>".$ma.$cimkieg. $erkezesi;;
Line #387:
Line #388: $helyszin=str_replace("Sportcsarnok","",$musor[helyszin]);
Line #389:echo"<tr>
Line #390:<td align=right>$helyszin <br>
Line #391:<i>".substr($musor[datum],-6)."</i>&nbsp;
Line #392:</td>
Line #393:<td align=right $szin ><b>".number_format($osft)."</b></td>
Line #394:<td align=right $szin ><B>".number_format($ertdb)."</B></td>
Line #395:";
Line #396:
Line #397:for ($i=1;$i<$Pi;$i++) {
Line #398:echo "
Line #399:<td align=right title='$Pt[$i]' ><b>".number_format($Pmusft[$i])."</b></td>
Line #400:";
Line #401:}
Line #402:echo "</tr>";
Line #403:
Line #404:$sum_ertdb=$sum_ertdb +$ertdb;
Line #405:$sum_osft=$sum_osft+$osft;
Line #406:
Line #407:}
Line #408:
Line #409:
Line #410:echo "<tr bgcolor=silver>
Line #411:<td align=right ><b>
Line #412:
Line #413:</b></td>
Line #414:<td align=right ><b>".number_format($sum_osft)."</b></td>
Line #415:<td align=right ><b>".number_format($sum_ertdb). "</B></td>";
Line #416:
Line #417:for ($i=1;$i<$Pi;$i++) {
Line #418:echo "
Line #419:<td align=right title='$Pt[$i]' ><b>".number_format($Posft[$i])."</b></td>
Line #420:";
Line #421:}
Line #422:
Line #423:echo "</tr>";
Line #424:
Line #425:echo "</table>";
Line #426:
Line #427:if (isset($_GET[nyomtat])) {
Line #428:include("QJ_listaveg.php");
Line #429:
Line #430:echo("<body onload='printit()'></body>");
Line #431:
Line #432:?>
Line #433:<SCRIPT Language="Javascript">
Line #434:
Line #435:function printit(){
Line #436:
Line #437:window.print();
Line #438:
Line #439:}
Line #440:</script>
Line #441:<?PHP
Line #442:}
Line #443:
Line #444://~*~// QJ_napi.php
Line #445:?>