QL_haviPENZTARado.inc

---

Line #0:<?php
Line #1:
Line #2:if (isset($_GET[nyomtat])) {
Line #3:?>
Line #4:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #5:<?PHP
Line #6:$keres=$_SESSION[musorRAPORT_SQL];
Line #7:$szin="";
Line #8:} else {
Line #9:unset($_SESSION[musorRAPORT_SQL]);
Line #10:$szin=" bgcolor=gold ";
Line #11:
Line #12:
Line #13:$sum_osft=0;
Line #14:$sum_osdb=0;
Line #15:$sum_ertdb=0;
Line #16:$sum_elodb=0;
Line #17:$sum_uresdb=0;
Line #18:$sum_csopdb=0;
Line #19:$sum_potdb=0;
Line #20:$sum_nulldb=0;
Line #21:$ir="<table border=1>";
Line #22:
Line #23:IF (isset($_POST[ujho])) $_SESSION[musor_ujho]=$_POST[ujho];
Line #24:IF (isset($_SESSION[musor_ujho])) $_POST[ujho]=$_SESSION[musor_ujho];
Line #25:
Line #26:IF (isset($_POST[ujevho])) $_SESSION[musor_ujevho]=$_POST[ujevho];
Line #27:IF (isset($_SESSION[musor_ujevho])) $_POST[ujevho]=$_SESSION[musor_ujevho];
Line #28:
Line #29:IF (isset($_POST[sorrend])) $_SESSION[musorrend]=$_POST[sorrend];
Line #30:IF (isset($_SESSION[musorrend])) $_POST[sorrend]=$_SESSION[musorrend];
Line #31:
Line #32:IF (isset($_POST[helyszin])) $_SESSION[hely_nev]=$_POST[helyszin];
Line #33:IF (isset($_SESSION[hely_nev])) $_POST[helyszin]=$_SESSION[hely_nev];
Line #34:
Line #35:
Line #36:IF (!isset($_POST[Rhonap]) and !isset($_SESSION[Rhonap]) or substr($_SESSION[Rhonap],0,1)<>"2")
Line #37:$_POST[Rhonap]=date("Y.m");
Line #38://$_POST[Rhonap]=substr($_COOKIE[date],0,4).".".substr($_COOKIE[date],5,2);
Line #39:
Line #40:IF (isset($_POST[Rhonap])) $_SESSION[Rhonap]=$_POST[Rhonap];
Line #41:IF (isset($_SESSION[Rhonap])) $_POST[Rhonap]=$_SESSION[Rhonap];
Line #42:
Line #43:
Line #44:$formcall="QJ_haviPENZTAR.php";
Line #45:////////////////////////////////////////include("BI_musorFILTER.php");
Line #46:
Line #47:$es="";
Line #48:$ha=" where ";
Line #49:$ha="";
Line #50:$wer="";
Line #51:
Line #52:if (isset($_POST[cim]) and $_POST[cim]<>"*") {
Line #53:$wer=$ha." cim='".$_POST[cim]."'" ;
Line #54:$es=" AND ";
Line #55:$ha="";
Line #56:}
Line #57:
Line #58:if (isset($_POST[helyszin]) and $_POST[helyszin]<>"*") {
Line #59:$wer.= $ha. $es. " helyszin='".$_POST[helyszin]."'";
Line #60:$es=" AND ";
Line #61:$ha="";
Line #62:}
Line #63:
Line #64:if (isset($_POST[datum_fej]) and $_POST[datum_fej]<>"*") {
Line #65:$wer.= $ha. $es. " datum_fej='".$_POST[datum_fej]."'";
Line #66:$es=" AND ";
Line #67:$ha="";
Line #68:}
Line #69:
Line #70:if (isset($_POST[Rhonap]) and $_POST[Rhonap]<>"*") {
Line #71:$wer.= $ha. $es. " datum_evho='".$_POST[Rhonap]."'";
Line #72:$es=" AND ";
Line #73:$ha="";
Line #74:}
Line #75:
Line #76:$wer.=$es;
Line #77:
Line #78:$disQ = "SELECT distinct cim FROM qj_musor order by cim" ;
Line #79:
Line #80:
Line #81:$sel1="&nbsp;&nbsp;<SELECT TITLE='cim'
Line #82:onchange=this.form.submit(); return true name='cim'>";
Line #83:
Line #84:
Line #85:
Line #86:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #87:if ($disC[cim]==$_POST[cim]) $sel="SELECTED"; else $sel="";
Line #88:if (trim($disC[cim])<>"")
Line #89:$sel1.="<option value='".$disC[cim]."' $sel >".$disC[cim]."</option>";
Line #90:}
Line #91:
Line #92:$sel1.="</SELECT>";
Line #93:
Line #94:
Line #95:$disQ = "SELECT distinct helyszin FROM qj_musor order by helyszin" ;
Line #96:
Line #97:
Line #98:
Line #99:onchange=this.form.submit(); return true name='helyszin'>";
Line #100:
Line #101:
Line #102:
Line #103:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #104:if ($disC[helyszin]==$_POST[helyszin]) $sel="SELECTED"; else $sel="";
Line #105:if (trim($disC[helyszin])<>"")
Line #106:$sel2.="<option value='".$disC[helyszin]."' $sel >".$disC[helyszin]."</option>";
Line #107:}
Line #108:
Line #109:$sel2.="</SELECT>";
Line #110:
Line #111:$disQ = "SELECT distinct datum_fej FROM qj_musor order by datum_fej" ;
Line #112:
Line #113:
Line #114:$sel3="&nbsp;&nbsp;<SELECT TITLE='Nap'
Line #115:onchange=this.form.submit(); return true name='datum_fej'>";
Line #116:
Line #117:
Line #118:
Line #119:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #120:if ($disC[datum_fej]==$_POST[datum_fej]) $sel="SELECTED"; else $sel="";
Line #121:if (trim($disC[datum_fej])<>"")
Line #122:$sel3.="<option value='".$disC[datum_fej]."' $sel >".$disC[datum_fej]."</option>";
Line #123:}
Line #124:
Line #125:$sel3.="</SELECT>";
Line #126://///////////////////////////
Line #127:
Line #128:$disQ = "SELECT distinct datum_evho as datum FROM qj_musor order by datum_evho " ;
Line #129:
Line #130:
Line #131:
Line #132:onchange=this.form.submit(); return true name='Rhonap'>";
Line #133:
Line #134:
Line #135:
Line #136:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #137:
Line #138:$datum=$disC[datum];
Line #139:
Line #140:if ($datum==$_POST[Rhonap]) $sel="SELECTED"; else $sel="";
Line #141:if (trim($datum)<>"")
Line #142:$sel4.="<option value='".$datum."' $sel >".$datum."</option>";
Line #143:}
Line #144:
Line #145:$sel4.="</SELECT>";
Line #146:
Line #147:///////////////////////////////////
Line #148:
Line #149:$sql="SELECT * FROM qj_sql where szoveg='musor_ord' and archiv<>'*' and future<>'*' ORDER BY widarc";
Line #150:
Line #151:$psor = mysql_fetch_array( $sqlpar );
Line #152:$fid=$psor[sql_memo];
Line #153:$h=split(':',$fid);
Line #154:$nORD=count($h)-1;
Line #155:
Line #156:if (!isset($_POST[sorrend])) $_POST[sorrend]=$h[0];
Line #157:$ord=" order by ".$_POST[sorrend];
Line #158:
Line #159:$sel5="&nbsp;&nbsp;<b>Sorrend:</b><SELECT TITLE='Sorrend'
Line #160:onchange=this.form.submit(); return true name='sorrend'>";
Line #161:
Line #162:for ($i=0;$i<$nORD;$i++) {
Line #163:
Line #164:if ($h[$i]==$_POST[sorrend]) $sel="SELECTED"; else $sel="";
Line #165:$sel5.="<option value='".$h[$i]."' $sel >".$h[$i]."</option>";
Line #166:}
Line #167:
Line #168:$sel5.="</SELECT>";
Line #169:
Line #170:
Line #171:?>
Line #172:
Line #173:<FORM name=cimform action='<?echo($formcall);?>' method='post'>
Line #174:
Line #175:onchange=this.form.submit(); return true name='Korr'>
Line #176:<? // echo($sel1);
Line #177: echo($sel2); echo($sel4);
Line #178: //echo($sel5); ?>
Line #179:</form>
Line #180:
Line #181:<?
Line #182:
Line #183:$ord=" order by rovid_helyszin,cim,datum ";
Line #184:
Line #185:IF ($_SESSION[admin]<>"ADMIN") $archiv=" archiv <>'*' "; else $archiv=" future <>'*'";
Line #186:
Line #187:$archiv=" future <>'*'";
Line #188:$login=$_SESSION[login];
Line #189:
Line #190:$keres = "SELECT * FROM qj_musor where $wer future <>'*' $latni $JeBe $WEB $ord ";
Line #191:
Line #192:$_SESSION[musorRAPORT_SQL]=$keres;
Line #193:}
Line #194:
Line #195:
Line #196:
Line #197:if ($_SESSION[hely_nev]<>"*") $L_cim.="<br>".$_SESSION[hely_nev];
Line #198:
Line #199:$L_PHP="QJ_haviPENZTAR.php";
Line #200:include("QJ_listafej.php");
Line #201:
Line #202:// echo($keres."<hr>");
Line #203:
Line #204:$jegySEL="";
Line #205:IF (isset($_SESSION[Rhonap]) and $_SESSION[Rhonap]<>"*")
Line #206:$jegySEL= " and left(logtime,7)='".substr($_SESSION[Rhonap],0,4)."-".substr($_SESSION[Rhonap],5,2)."' ";
Line #207:
Line #208:$keres = "SELECT distinct datum_kod FROM qj_jegy where future <>'*' $jegySEL";
Line #209://?//
Line #210:echo($keres."<hr>");
Line #211:
Line #212:
Line #213:
Line #214:$wer=" and (";
Line #215:$or= " ";
Line #216:while ( $jegysor = mysql_fetch_array( $eredmeny )){
Line #217:
Line #218:$jegyHELY=" where datum_kod='$jegysor[datum_kod]' ";
Line #219:IF (isset($_SESSION[hely_nev]) and $_SESSION[hely_nev]<>"*")
Line #220:$jegyHELY.= " and helyszin='".$_SESSION[hely_nev]."' ";
Line #221:
Line #222:$Mkeres = "SELECT datum_kod FROM qj_musor $jegyHELY";
Line #223:
Line #224:$Mur=mysql_num_rows($Meredmeny);
Line #225://?//
Line #226:echo($Mkeres."<hr>");
Line #227:
Line #228:
Line #229:if ($Mur>0) {
Line #230:$wer.=$or." datum_kod='$jegysor[datum_kod]' ";
Line #231:$or= " or ";
Line #232:}}
Line #233:
Line #234:$wer.=" )";
Line #235:
Line #236://////////////////////////////////////
Line #237:$keres="SELECT distinct bizomanyos FROM qj_jegy where future <>'*' $wer ORDER BY bizomanyos";
Line #238:$_SESSION[HoHelyWer]=$keres;
Line #239:
Line #240:
Line #241:
Line #242://?//
Line #243:echo($keres."<hr>");
Line #244:
Line #245:
Line #246:$Pi=0;
Line #247:
Line #248:while ( $egy_sor = mysql_fetch_array( $eredmeny ) )
Line #249:{
Line #250:if ($egy_sor[bizomanyos]<>"") {
Line #251:++$Pi;
Line #252:$Pt[$Pi]=$egy_sor[bizomanyos];
Line #253:}}
Line #254:
Line #255:
Line #256:
Line #257:echo "<table border=1 width=100% >
Line #258:<tr bgcolor=silver>
Line #259:<td align=right width=80 >Hely</td>
Line #260:
Line #261:
Line #262:<td width=60 align=right ><b>Ft</td>
Line #263:<td width=40 align=right ><b>Db</td>
Line #264:";
Line #265:
Line #266:for ($i=1;$i<$Pi;$i++) {
Line #267:echo "
Line #268:<td align=right width=40 ><b>$Pt[$i]</b></td>
Line #269:";
Line #270:}
Line #271:
Line #272:echo "</tr>";
Line #273:
Line #274:for ($i=1;$i<$Pi;$i++) {
Line #275: $Posft[$i]=0;
Line #276:}
Line #277:
Line #278://////////////////////////////////////
Line #279:$keres="SELECT * FROM qj_musor where future <>'*' $wer ORDER BY datum_evho,rovid_helyszin,datum,cim";
Line #280://?//
Line #281:echo($keres."<hr>");
Line #282:
Line #283:
Line #284:$nur=mysql_num_rows($eredmeny);
Line #285:
Line #286:$i=0;
Line #287://////////////////////////////////////////////////
Line #288:while ( $musor = mysql_fetch_array( $eredmeny ))
Line #289:{
Line #290://////////////////////////////////////////////////
Line #291:
Line #292:++$i;
Line #293:
Line #294:for ($i=1;$i<$Pi;$i++) {
Line #295: $Pmusft[$i]=0;
Line #296:}
Line #297:
Line #298:$helyszin_kod=$musor[hely_kod];
Line #299:$datum_kod=$musor[datum_kod];
Line #300:$cim_kod=$musor[cim_kod];
Line #301:$cim_url=$musor[cim_url];
Line #302:$kep_url=$musor[kep_url];
Line #303:$wjid=$musor[wid];
Line #304:if ($musor[archiv]=="*") $rejtett="<br><font color=red size=+2>Rejtett</font>"; else $rejtett="";
Line #305:
Line #306:
Line #307://$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' and archiv='-'
Line #308://and not $_SESSION[SQL_inet] and ar>0 ORDER BY vevo_kod";
Line #309: ////////
Line #310:
Line #311:$SQLszek = "SELECT * FROM qj_jegy WHERE archiv='-' and datum_kod='$datum_kod' $jegySEL
Line #312: and not $_SESSION[SQL_inet] ORDER BY wid";
Line #313:
Line #314:
Line #315:
Line #316://?//
Line #317:echo($SQLszek."<hr>");
Line #318:
Line #319:$nur=mysql_num_rows($szekek);
Line #320:$osft=0;
Line #321:$ertdb=0;
Line #322:$elodb=0;
Line #323:$uresdb=0;
Line #324:$csopdb=0;
Line #325:$potdb=0;
Line #326:$nulldb=0;
Line #327:$vevo_kod=0;
Line #328:$csoportjel="N";
Line #329:
Line #330:while ( $jegysor = mysql_fetch_array( $szekek ))
Line #331:{
Line #332:$statusz=substr($jegysor[statusz],0,2);
Line #333:
Line #334:if ($statusz<>'' and $statusz<>'El' and $statusz<>'St' and $statusz<>'In') {
Line #335: $osft=$osft+$jegysor[ar];
Line #336: ++$ertdb;
Line #337:for ($i=1;$i<$Pi;$i++) {
Line #338:if ($Pt[$i]==$jegysor[bizomanyos]) {
Line #339: $Pmusft[$i]=$Pmusft[$i]+$jegysor[ar];
Line #340: $Posft[$i]=$Posft[$i]+$jegysor[ar];
Line #341:}}
Line #342:
Line #343: if ($jegysor[ar]==0) ++$nulldb;
Line #344:
Line #345:} elseif ($statusz=='El' and $csoportjel=="N") ++$elodb;
Line #346: elseif (($statusz=='El' or $statusz=='In') and $csoportjel=="Y") ++$csopdb;
Line #347: else ++$uresdb;
Line #348:}
Line #349:
Line #350:$cimkieg="";
Line #351:if($musor[cimkieg1]<>" " ) $cimkieg.="<br><i>".$musor[cimkieg1]."</i>";
Line #352:if($musor[cimkieg2]<>" " ) $cimkieg.="<br><i>".$musor[cimkieg2]."</i>";
Line #353:
Line #354:
Line #355:IF ($nur==0) $erkezesi="<BR><b>Nincs megnyitva!</b>";
Line #356:
Line #357://if ($login=="BI(c)") $edit="<a href=BI_ediTable.php?&wjid=$wjid&sqlfile=qj_musor>"; else $edit="<a>";
Line #358:
Line #359:
Line #360: target=adatframe >";
Line #361:
Line #362:
Line #363: target=adatframe >";
Line #364:
Line #365:
Line #366: target=adatframe ><IMG width=20 height=20
Line #367: SRC='../_Screen/datum.gif' border=0></a>";
Line #368:
Line #369:
Line #370:<IMG width=20 height=20
Line #371:SRC='../_Screen/people.bmp' border=0></a>";
Line #372:$bref="";
Line #373:
Line #374:$cref="<a href=QJ_raportNEW.php?&musor_kod=$datum_kod title='Raport lap' target=adatframe>
Line #375:<IMG width=20 height=20
Line #376:SRC='../_Screen/transfer.gif' border=0></a>";
Line #377:
Line #378:
Line #379:<IMG width=20 height=20
Line #380:SRC='../_Screen/tsticky.gif' border=0></a>";
Line #381:
Line #382:
Line #383:href='QJ_vevoXLSlist.php?&musor_kod=$datum_kod' >
Line #384:
Line #385:
Line #386:if ($_SESSION[login]=="BI(c)")
Line #387:$copys="<a target=adatframe
Line #388:href='QJ_musorCOPY.php?&wjid=$wjid' >
Line #389:
Line #390: SRC='../_Screen/transfer.png' border=0></a>";
Line #391:else $copys="";
Line #392:
Line #393:
Line #394:
Line #395:else $ma="";
Line #396:
Line #397:if (!isset($_GET[nyomtat]))
Line #398:$medi="<a href=QJ_musorPUBLIC.php?&wjid=$wjid
Line #399: target=adatframe><b>$musor[cim]</b>
Line #400:<IMG width=20 height=20 SRC='../_Screen/edit.png' border=0>
Line #401: </a>".$ma.$cimkieg. $erkezesi; else $medi="<b>$musor[cim]</b>".$ma.$cimkieg. $erkezesi;;
Line #402:
Line #403:echo"<tr>
Line #404:<td align=right>
Line #405:$musor[rovid_helyszin]&nbsp;
Line #406:</td>
Line #407:<td align=right>
Line #408:<i>$musor[datum]</i>&nbsp;
Line #409:</td>
Line #410:<td align=right>
Line #411:<b>$musor[cim]</b>
Line #412:</td>
Line #413:<td align=right $szin ><b>".number_format($osft)."</b></td>
Line #414:<td align=right $szin ><B>".number_format($ertdb)."</B></td>
Line #415:";
Line #416:
Line #417:for ($i=1;$i<$Pi;$i++) {
Line #418:echo "
Line #419:<td align=right ><b>".number_format($Pmusft[$i])."</b></td>
Line #420:";
Line #421:}
Line #422:echo "</tr>";
Line #423:
Line #424:$sum_ertdb=$sum_ertdb +$ertdb;
Line #425:$sum_osft=$sum_osft+$osft;
Line #426:
Line #427:}
Line #428:
Line #429:
Line #430:echo "<tr bgcolor=silver>
Line #431:<td colspan=4 align=right ><b>
Line #432:
Line #433:</b></td>
Line #434:<td align=right ><b>".number_format($sum_osft)."</b></td>
Line #435:<td align=right ><b>".number_format($sum_ertdb). "</B></td>";
Line #436:
Line #437:for ($i=1;$i<$Pi;$i++) {
Line #438:echo "
Line #439:<td align=right ><b>".number_format($Posft[$i])."</b></td>
Line #440:";
Line #441:}
Line #442:
Line #443:echo "</tr>";
Line #444:
Line #445:echo "</table>";
Line #446:
Line #447:if (isset($_GET[nyomtat])) {
Line #448:include("QJ_listaveg.php");
Line #449:
Line #450:echo("<body onload='printit()'></body>");
Line #451:
Line #452:?>
Line #453:<SCRIPT Language="Javascript">
Line #454:
Line #455:function printit(){
Line #456:
Line #457:window.print();
Line #458:
Line #459:}
Line #460:</script>
Line #461:<?PHP
Line #462:}
Line #463:
Line #464://~*~// QJ_napi.php
Line #465:?>