QJ_musorPENZTAR.inc

---

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