Bi-Dir

QQ_haviPENZTARview_MK12_V2.inc

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