Bi-Dir

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