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