Bi-Dir

QL_haviADOview.inc

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