Bi-Dir

QJ_haviPENZTARview.inc

Line #0:<?php
Line #1:
Line #2:$sum_osft=0;
Line #3:$sum_osdb=0;
Line #4:$sum_ertdb=0;
Line #5:$sum_elodb=0;
Line #6:$sum_uresdb=0;
Line #7:$sum_csopdb=0;
Line #8:$sum_potdb=0;
Line #9:$sum_nulldb=0;
Line #10:$ir="<table border=1>";
Line #11:
Line #12:$ord=" order by helyszin,cim,datum ";
Line #13:
Line #14:
Line #15:
Line #16:if ($_SESSION[hely_nev]<>"*") $L_cim.=" ".$_SESSION[hely_nev];
Line #17:
Line #18:$L_PHP="QJ_haviPENZTAR.php";
Line #19:include("QJ_listafej.php");
Line #20:
Line #21:$wer=$_SESSION[HoHelyWer];
Line #22://////////////////////////////////////
Line #23:$keres="SELECT distinct bizomanyos FROM qj_jegy where ar>0 and future <>'*' and $_SESSION[SQL_elad] $wer ORDER BY bizomanyos";
Line #24:$keres="SELECT distinct bizomanyos FROM qj_jegy where $_SESSION[SQL_elad] $jegySEL $wer ORDER BY bizomanyos";
Line #25://?//echo($keres."<hr>");
Line #26:
Line #27://?//BI_alert($keres);
Line #28:
Line #29:
Line #30:$Pi=0;
Line #31:
Line #32:while ( $egy_sor = mysql_fetch_array( $eredmeny ) )
Line #33:{
Line #34:if ($egy_sor[bizomanyos]<>"") {
Line #35:++$Pi;
Line #36:$Pt[$Pi]=$egy_sor[bizomanyos];
Line #37:}}
Line #38:
Line #39:
Line #40:
Line #41:echo "<table border=1 width=100% >
Line #42:<tr bgcolor=silver>
Line #43:<td align=right >Hely</td>
Line #44:
Line #45:
Line #46:
Line #47:";
Line #48:
Line #49:for ($i=1;$i<$Pi+1;$i++) {
Line #50:echo "
Line #51:<td align=right width=40 >$Pt[$i]</td>
Line #52:";
Line #53:}
Line #54:
Line #55:echo "</tr>";
Line #56:
Line #57:for ($i=1;$i<$Pi+1;$i++) {
Line #58: $Posft[$i]=0;
Line #59:}
Line #60:
Line #61://////////////////////////////////////
Line #62:$keres="SELECT * FROM qj_musor where future <>'*' $wer ORDER BY datum_evho,helyszin,datum,cim";
Line #63://$keres=$_SESSION[HoHelyWer]." ORDER BY datum_evho,rovid_helyszin,datum,cim";;
Line #64://?//echo($keres."<hr>");
Line #65:
Line #66:
Line #67:$nur=mysql_num_rows($eredmeny);
Line #68:
Line #69:$i=0;
Line #70://////////////////////////////////////////////////
Line #71:while ( $musor = mysql_fetch_array( $eredmeny ))
Line #72:{
Line #73://////////////////////////////////////////////////
Line #74:
Line #75:++$i;
Line #76:
Line #77:for ($i=1;$i<$Pi+1;$i++) {
Line #78: $Pmusft[$i]=0;
Line #79:}
Line #80:
Line #81:$helyszin_kod=$musor[hely_kod];
Line #82:$datum_kod=$musor[datum_kod];
Line #83:$cim_kod=$musor[cim_kod];
Line #84:$cim_url=$musor[cim_url];
Line #85:$kep_url=$musor[kep_url];
Line #86:$wjid=$musor[wid];
Line #87:if ($musor[archiv]=="*") $rejtett=" Rejtett"; else $rejtett="";
Line #88:
Line #89:
Line #90://$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' and archiv='-'
Line #91://and not $_SESSION[SQL_inet] and ar>0 ORDER BY vevo_kod";
Line #92: ////////
Line #93:
Line #94://$SQLszek = "SELECT * FROM qj_jegy WHERE archiv='-' and datum_kod='$datum_kod' $jegySEL
Line #95:// and not $_SESSION[SQL_inet] ORDER BY wid";
Line #96:
Line #97:$SQLszek="SELECT * FROM qj_jegy where
Line #98:ar>0 and future <>'*' and datum_kod='$datum_kod' and $_SESSION[SQL_elad] $_SESSION[HaviJegySel] $wer ORDER BY wid";
Line #99:
Line #100:
Line #101://?//echo($SQLszek."<hr>");
Line #102:
Line #103:$nur=mysql_num_rows($szekek);
Line #104:$osft=0;
Line #105:$ertdb=0;
Line #106:$elodb=0;
Line #107:$uresdb=0;
Line #108:$csopdb=0;
Line #109:$potdb=0;
Line #110:$nulldb=0;
Line #111:$vevo_kod=0;
Line #112:$csoportjel="N";
Line #113:
Line #114:while ( $jegysor = mysql_fetch_array( $szekek ))
Line #115:{
Line #116:$statusz=substr($jegysor[statusz],0,2);
Line #117:
Line #118:if ($statusz<>'' and $statusz<>'El' and $statusz<>'St' and $statusz<>'In') {
Line #119: $osft=$osft+$jegysor[ar];
Line #120: ++$ertdb;
Line #121:for ($i=1;$i<$Pi+1;$i++) {
Line #122:if ($Pt[$i]==$jegysor[bizomanyos]) {
Line #123: $Pmusft[$i]=$Pmusft[$i]+$jegysor[ar];
Line #124: $Posft[$i]=$Posft[$i]+$jegysor[ar];
Line #125:}}
Line #126:
Line #127: if ($jegysor[ar]==0) ++$nulldb;
Line #128:
Line #129:} elseif ($statusz=='El' and $csoportjel=="N") ++$elodb;
Line #130: elseif (($statusz=='El' or $statusz=='In') and $csoportjel=="Y") ++$csopdb;
Line #131: else ++$uresdb;
Line #132:}
Line #133:
Line #134:$cimkieg="";
Line #135:if($musor[cimkieg1]<>" " ) $cimkieg.=" ".$musor[cimkieg1]."";
Line #136:if($musor[cimkieg2]<>" " ) $cimkieg.=" ".$musor[cimkieg2]."";
Line #137:
Line #138:
Line #139:IF ($nur==0) $erkezesi=" Nincs megnyitva!";
Line #140:
Line #141://if ($login=="BI(c)") $edit="<a href=BI_ediTable.php?&wjid=$wjid&sqlfile=qj_musor>"; else $edit="<a>";
Line #142:
Line #143:
Line #144: target=adatframe >";
Line #145:
Line #146:
Line #147: target=adatframe >";
Line #148:
Line #149:
Line #150: target=adatframe >";
Line #151:
Line #152:
Line #153: target=adatframe ><IMG width=20 height=20
Line #154: SRC='../_Screen/datum.gif' border=0></a>";
Line #155:
Line #156:
Line #157:<IMG width=20 height=20
Line #158:SRC='../_Screen/people.bmp' border=0></a>";
Line #159:$bref="";
Line #160:
Line #161:$cref="<a href=QJ_raportNEW.php?&musor_kod=$datum_kod title='Raport lap' target=adatframe>
Line #162:<IMG width=20 height=20
Line #163:SRC='../_Screen/transfer.gif' border=0></a>";
Line #164:
Line #165:
Line #166:<IMG width=20 height=20
Line #167:SRC='../_Screen/tsticky.gif' border=0></a>";
Line #168:
Line #169:
Line #170:href='QJ_vevoXLSlist.php?&musor_kod=$datum_kod' >
Line #171:
Line #172:
Line #173:if ($_SESSION[login]=="BI(c)")
Line #174:$copys="<a target=adatframe
Line #175:href='QJ_musorCOPY.php?&wjid=$wjid' >
Line #176:
Line #177: SRC='../_Screen/transfer.png' border=0></a>";
Line #178:else $copys="";
Line #179:
Line #180:if ($_SESSION[Rhonap]<>$musor[datum_evho] and $_SESSION[Rhonap]<>"*")
Line #181:
Line #182:
Line #183:
Line #184:else $ma="";
Line #185:
Line #186:if (!isset($_GET[nyomtat]))
Line #187:$medi="<a href=QJ_musorPUBLIC.php?&wjid=$wjid
Line #188: target=adatframe>$musor[cim]
Line #189:<IMG width=20 height=20 SRC='../_Screen/edit.png' border=0>
Line #190: </a>".$ma.$cimkieg. $erkezesi; else $medi="$musor[cim]".$ma.$cimkieg. $erkezesi;;
Line #191:
Line #192:echo"<tr>
Line #193:<td align=right>
Line #194:$musor[rovid_helyszin] 
Line #195:</td>
Line #196:<td align=right>
Line #197:$musor[datum]  $irszin
Line #198: 
Line #199:$musor[cim]
Line #200:</td>
Line #201:<td align=right $szin >".number_format($osft)."</td>
Line #202:<td align=right $szin >".number_format($ertdb)."</td>
Line #203:";
Line #204:
Line #205:for ($i=1;$i<$Pi+1;$i++) {
Line #206:echo "
Line #207:<td align=right >".number_format($Pmusft[$i])."</td>
Line #208:";
Line #209:}
Line #210:echo "</tr>";
Line #211:
Line #212:$sum_ertdb=$sum_ertdb +$ertdb;
Line #213:$sum_osft=$sum_osft+$osft;
Line #214:
Line #215:}
Line #216:
Line #217:
Line #218:echo "<tr bgcolor=silver>
Line #219:<td colspan=2 align=right >
Line #220:
Line #221:</td>
Line #222:<td align=right >".number_format($sum_osft)."</td>
Line #223:<td align=right >".number_format($sum_ertdb). "</td>";
Line #224:
Line #225:for ($i=1;$i<$Pi+1;$i++) {
Line #226:echo "
Line #227:<td align=right >".number_format($Posft[$i])."</td>
Line #228:";
Line #229:}
Line #230:
Line #231:echo "</tr>";
Line #232:
Line #233:echo "</table>";
Line #234:
Line #235:?>