Bi-Dir

QQ_haviPENZTARviewBOSS.inc

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