Bi-Dir

QQ_haviPENZTARview_MK12_V4MH_BKARTYA.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:$L_cim.=$plusfej;
Line #21:
Line #22:
Line #23://if ($_SESSION[hely_nev]<>"*") $L_cim.=" ".$_SESSION[hely_nev];
Line #24:
Line #25:$L_PHP="QJ_BKARTYAtolig.php";
Line #26:if ($L_PHP_SUB<>"") $L_PHP=$L_PHP_SUB;
Line #27:include("QJ_listafej.php");
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 datum_kod 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:$werdatum= " and ( ";
Line #43:$and="";
Line #44:
Line #45:while ( $egy_sor = mysql_fetch_array( $eredmeny ) )
Line #46:{
Line #47: $werdatum.= $and. " datum_kod='" .$egy_sor[datum_kod] ."'";
Line #48: $and=" or ";
Line #49:
Line #50:}
Line #51:
Line #52:
Line #53:$werdatum.= " )";
Line #54:
Line #55:
Line #56:
Line #57:
Line #58:$wer=$_SESSION[HoHelyWer];
Line #59://////////////////////////////////////
Line #60:$keres="SELECT distinct bizomanyos FROM qj_jegy where ar>0 and future <>'*' and $_SESSION[SQL_elad] $wer ORDER BY bizomanyos";
Line #61:$keres="SELECT distinct bizomanyos FROM qj_jegy where $_SESSION[SQL_elad] $jegySEL $wer ORDER BY bizomanyos";
Line #62:$keres="SELECT distinct bizomanyos FROM qj_jegy where ar>0 and future <>'*' and $_SESSION[SQL_elad] $_SESSION[SUBwer] $wer3 ORDER BY bizomanyos";
Line #63:
Line #64:if (isset($_SESSION['Dump'])) echo($keres." <hr>");
Line #65:
Line #66://?//echo("~~~~~~~~~~~$keres~~<hr>");
Line #67:
Line #68://?//BI_alert($keres);
Line #69:
Line #70:
Line #71:$Pi=0;
Line #72:
Line #73:while ( $egy_sor = mysql_fetch_array( $eredmeny ) )
Line #74:{
Line #75:if ($egy_sor[bizomanyos]<>"") {
Line #76:++$Pi;
Line #77:$Pt[$Pi]=$egy_sor[bizomanyos];
Line #78:}}
Line #79:
Line #80:
Line #81:
Line #82:echo "<table border=1 width=100% >
Line #83:<tr bgcolor=silver>
Line #84:<td align=right >Hely</td>
Line #85:
Line #86:
Line #87:
Line #88:";
Line #89:
Line #90:for ($i=1;$i<$Pi+1;$i++) {
Line #91:echo "
Line #92:<td align=right width=40 >$Pt[$i]</td>
Line #93:";
Line #94:}
Line #95:
Line #96:echo "</tr>";
Line #97:
Line #98:for ($i=1;$i<$Pi+1;$i++) {
Line #99: $Posft[$i]=0;
Line #100:}
Line #101:
Line #102://////////////////////////////////////
Line #103:$keres="SELECT distinct bizomanyos FROM qj_jegy where $_SESSION[SQL_elad] $_SESSION[SUBwer] ORDER BY bizomanyos";
Line #104://$keres="SELECT * FROM qj_musor where future <>'*' $_SESSION[SUBwerEVHO] $_SESSION[externalSELECT] $wera $werdatum ORDER BY datum_evho,helyszin,datum,cim";
Line #105:$keres="SELECT * FROM qj_musor where future <>'*' $wera $werdatum ORDER BY datum_evho,helyszin,datum,cim";
Line #106:
Line #107://echo("===>~~~~~~~~$keres~~<hr>");
Line #108:
Line #109:if (isset($_SESSION['Dump'])) echo($keres." <hr>");
Line #110:
Line #111:///////////////////////////////////////////////////////////////////////////////////////////
Line #112://if (strpos($keres,"( )")>0){
Line #113://if (trim($werdatum)=="and ( )"){ ??? MI A FRANC VAN OTT ????
Line #114://$yyy=strlen($werdatum);
Line #115:if (strlen($werdatum)<10){
Line #116: $keres="SELECT * FROM qj_musor where future <>'*' $wera ORDER BY datum_evho,helyszin,datum,cim";
Line #117: if (isset($_SESSION['Dump'])) echo("~~~~~~~~/$werdatum/~~~~~~~~~~~".$keres."*** <hr>");
Line #118:}
Line #119:
Line #120://$kkk=strpos($werdatum,"( )");
Line #121://$yyy=strlen($werdatum);
Line #122:
Line #123:
Line #124:///////////////////////////////////////////////////////////////////////////////////////////
Line #125:
Line #126://echo("===>~~ ??? ~~~~~~$keres~~<hr>");
Line #127:
Line #128:if (isset($_SESSION['Dump'])) echo("~~~/$kkk/~~~~~$werdatum~~~~~/$yyy/~~~~~~".$keres."*** <hr>");
Line #129:
Line #130://$keres=$_SESSION[HoHelyWer]." ORDER BY datum_evho,rovid_helyszin,datum,cim";;
Line #131:
Line #132://?//echo("/".$_SESSION[SUBwerEVHO]."/<hr>/".$_SESSION[externalSELECT]."/<hr>".$keres."<hr>");
Line #133:
Line #134:
Line #135:$nur=mysql_num_rows($eredmeny);
Line #136:
Line #137:$i=0;
Line #138://////////////////////////////////////////////////
Line #139:while ( $musor = mysql_fetch_array( $eredmeny ))
Line #140:{
Line #141://////////////////////////////////////////////////
Line #142:
Line #143:++$i;
Line #144:
Line #145:for ($i=1;$i<$Pi+1;$i++) {
Line #146: $Pmusft[$i]=0;
Line #147:}
Line #148:
Line #149:$rendezo="";
Line #150:if($musor[Adoszam]<>" " ) $rendezo.=" ".$musor[Adoszam]."";
Line #151:if($musor[cimkieg3]<>" " ) $rendezo.=" ".$musor[cimkieg3]."";
Line #152:
Line #153:$helyszin_kod=$musor[hely_kod];
Line #154:$datum_kod=$musor[datum_kod];
Line #155:$cim_kod=$musor[cim_kod];
Line #156:$cim_url=$musor[cim_url];
Line #157:$kep_url=$musor[kep_url];
Line #158:$wjid=$musor[wid];
Line #159:if ($musor[archiv]=="*") $rejtett=" Rejtett"; else $rejtett="";
Line #160:
Line #161:
Line #162://$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' and archiv='-'
Line #163://and not $_SESSION[SQL_inet] and ar>0 ORDER BY vevo_kod";
Line #164: ////////
Line #165:
Line #166://$SQLszek = "SELECT * FROM qj_jegy WHERE archiv='-' and datum_kod='$datum_kod' $jegySEL
Line #167:// and not $_SESSION[SQL_inet] ORDER BY wid";
Line #168:
Line #169:$SQLszek="SELECT * FROM qj_jegy where
Line #170:ar>0 and future <>'*' and datum_kod='$datum_kod' and $_SESSION[SQL_elad] $_SESSION[HaviJegySel] $wer ORDER BY wid";
Line #171:
Line #172:$SQLszek="SELECT * FROM qj_jegy where
Line #173:ar>0 and future <>'*' and datum_kod='$datum_kod' and $_SESSION[SQL_elad] $_SESSION[SUBwer] $wer3 ORDER BY wid";
Line #174:if (isset($_SESSION['Dump'])) echo($SQLszek." <hr>");
Line #175:
Line #176:if (isset($_SESSION['Dump'])) echo($SQLszek." <hr>");
Line #177:
Line #178:
Line #179://?//echo($SQLszek."<hr>");
Line #180:
Line #181:$nur=mysql_num_rows($szekek);
Line #182:$osft=0;
Line #183:$ertdb=0;
Line #184:$elodb=0;
Line #185:$uresdb=0;
Line #186:$csopdb=0;
Line #187:$potdb=0;
Line #188:$nulldb=0;
Line #189:$vevo_kod=0;
Line #190:$csoportjel="N";
Line #191:
Line #192:while ( $jegysor = mysql_fetch_array( $szekek ))
Line #193:{
Line #194:$statusz=substr($jegysor[statusz],0,2);
Line #195:
Line #196:if ($statusz<>'' and $statusz<>'El' and $statusz<>'St' and $statusz<>'In') {
Line #197: $osft=$osft+$jegysor[ar];
Line #198: ++$ertdb;
Line #199:for ($i=1;$i<$Pi+1;$i++) {
Line #200:if ($Pt[$i]==$jegysor[bizomanyos]) {
Line #201: $Pmusft[$i]=$Pmusft[$i]+$jegysor[ar];
Line #202: $Posft[$i]=$Posft[$i]+$jegysor[ar];
Line #203:}}
Line #204:
Line #205: if ($jegysor[ar]==0) ++$nulldb;
Line #206:
Line #207:} elseif ($statusz=='El' and $csoportjel=="N") ++$elodb;
Line #208: elseif (($statusz=='El' or $statusz=='In') and $csoportjel=="Y") ++$csopdb;
Line #209: else ++$uresdb;
Line #210:}
Line #211:
Line #212:$cimkieg="";
Line #213:if($musor[cimkieg1]<>" " ) $cimkieg.=" ".$musor[cimkieg1]."";
Line #214:if($musor[cimkieg2]<>" " ) $cimkieg.=" ".$musor[cimkieg2]."";
Line #215:
Line #216:
Line #217:IF ($nur==0) $erkezesi=" Nincs megnyitva!";
Line #218:
Line #219://if ($login=="BI(c)") $edit="<a href=BI_ediTable.php?&wjid=$wjid&sqlfile=qj_musor>"; else $edit="<a>";
Line #220:
Line #221:
Line #222: target=adatframe >";
Line #223:
Line #224:
Line #225: target=adatframe >";
Line #226:
Line #227:
Line #228: target=adatframe >";
Line #229:
Line #230:
Line #231: target=adatframe ><IMG width=20 height=20
Line #232: SRC='../_Screen/datum.gif' border=0></a>";
Line #233:
Line #234:
Line #235:<IMG width=20 height=20
Line #236:SRC='../_Screen/people.bmp' border=0></a>";
Line #237:$bref="";
Line #238:
Line #239:$cref="<a href=QJ_raportNEW.php?&musor_kod=$datum_kod title='Raport lap' target=adatframe>
Line #240:<IMG width=20 height=20
Line #241:SRC='../_Screen/transfer.gif' border=0></a>";
Line #242:
Line #243:
Line #244:<IMG width=20 height=20
Line #245:SRC='../_Screen/tsticky.gif' border=0></a>";
Line #246:
Line #247:
Line #248:href='QJ_vevoXLSlist.php?&musor_kod=$datum_kod' >
Line #249:
Line #250:
Line #251:if ($_SESSION[login]=="BI(c)")
Line #252:$copys="<a target=adatframe
Line #253:href='QJ_musorCOPY.php?&wjid=$wjid' >
Line #254:
Line #255: SRC='../_Screen/transfer.png' border=0></a>";
Line #256:else $copys="";
Line #257:
Line #258://if ($_SESSION[Rhonap]<>$musor[datum_evho] and $_SESSION[Rhonap]<>"*")
Line #259:if (strpos($_SESSION[SUBwerEVHO],$musor[datum_evho])==0)
Line #260:
Line #261:
Line #262:
Line #263:else $ma="";
Line #264:
Line #265:if (!isset($_GET[nyomtat]))
Line #266:$medi="<a href=QJ_musorPUBLIC.php?&wjid=$wjid
Line #267: target=adatframe>$musor[cim]
Line #268:<IMG width=20 height=20 SRC='../_Screen/edit.png' border=0>
Line #269: </a>".$ma.$cimkieg. $erkezesi; else $medi="$musor[cim]".$ma.$cimkieg. $erkezesi;;
Line #270:
Line #271:echo"<tr>
Line #272:<td align=right>
Line #273:$musor[rovid_helyszin] 
Line #274:</td>
Line #275:<td align=right>
Line #276:$musor[datum]  $irszin
Line #277:
Line #278: 
Line #279:$musor[cim]
Line #280:$rendezo
Line #281:</td>
Line #282:<td align=right $szin >".number_format($osft)."</td>
Line #283:<td align=right $szin >".number_format($ertdb)."</td>
Line #284:";
Line #285:
Line #286:for ($i=1;$i<$Pi+1;$i++) {
Line #287:echo "
Line #288:<td align=right >".number_format($Pmusft[$i])."</td>
Line #289:";
Line #290:}
Line #291:echo "</tr>";
Line #292:
Line #293:$sum_ertdb=$sum_ertdb +$ertdb;
Line #294:$sum_osft=$sum_osft+$osft;
Line #295:
Line #296:}
Line #297:
Line #298:
Line #299:echo "<tr bgcolor=silver>
Line #300:<td colspan=2 align=right >
Line #301:
Line #302:</td>
Line #303:<td align=right >".number_format($sum_osft)."</td>
Line #304:<td align=right >".number_format($sum_ertdb). "</td>";
Line #305:
Line #306:for ($i=1;$i<$Pi+1;$i++) {
Line #307:echo "
Line #308:<td align=right >".number_format($Posft[$i])."</td>
Line #309:";
Line #310:}
Line #311:
Line #312:echo "</tr>";
Line #313:
Line #314:echo "</table>";
Line #315:
Line #316:// include ("QJ_varlist.php");
Line #317:
Line #318:?>