QC_haviADOsel.inc

---

Line #0:<?php
Line #1:
Line #2:$ir="<table border=1>";
Line #3:
Line #4:IF (isset($_POST[ujho])) $_SESSION[musor_ujho]=$_POST[ujho];
Line #5:IF (isset($_SESSION[musor_ujho])) $_POST[ujho]=$_SESSION[musor_ujho];
Line #6:
Line #7:IF (isset($_POST[ujevho])) $_SESSION[musor_ujevho]=$_POST[ujevho];
Line #8:IF (isset($_SESSION[musor_ujevho])) $_POST[ujevho]=$_SESSION[musor_ujevho];
Line #9:
Line #10:IF (isset($_POST[sorrend])) $_SESSION[musorrend]=$_POST[sorrend];
Line #11:IF (isset($_SESSION[musorrend])) $_POST[sorrend]=$_SESSION[musorrend];
Line #12:
Line #13:IF (isset($_POST[helyszin])) $_SESSION[hely_nev]=$_POST[helyszin];
Line #14:IF (isset($_SESSION[hely_nev])) $_POST[helyszin]=$_SESSION[hely_nev];
Line #15:
Line #16:
Line #17:IF (isset($_POST[Adoszam])) $_SESSION[Adoszam]=$_POST[Adoszam];
Line #18:IF (isset($_SESSION[Adoszam])) $_POST[Adoszam]=$_SESSION[Adoszam];
Line #19:
Line #20:
Line #21:IF (!isset($_POST[Rhonap]) and !isset($_SESSION[Rhonap]) or substr($_SESSION[Rhonap],0,1)<>"2")
Line #22:$_POST[Rhonap]=date("Y.m");
Line #23://$_POST[Rhonap]=substr($_COOKIE[date],0,4).".".substr($_COOKIE[date],5,2);
Line #24:
Line #25:IF (isset($_POST[Rhonap])) $_SESSION[Rhonap]=$_POST[Rhonap];
Line #26:IF (isset($_SESSION[Rhonap])) $_POST[Rhonap]=$_SESSION[Rhonap];
Line #27:
Line #28:
Line #29://$formcall="QJ_haviPENZTAR.php";
Line #30:////////////////////////////////////////include("BI_musorFILTER.php");
Line #31:
Line #32:$es="";
Line #33:$ha=" where ";
Line #34:$ha="";
Line #35:$wer="";
Line #36:
Line #37:
Line #38:if (isset($_POST[cim]) and $_POST[cim]<>"*") {
Line #39:$wer=$ha." cim='".$_POST[cim]."'" ;
Line #40:$es=" AND ";
Line #41:$ha="";
Line #42:}
Line #43:
Line #44:if (isset($_POST[helyszin]) and $_POST[helyszin]<>"*") {
Line #45:$wer.= $ha. $es. " helyszin='".$_POST[helyszin]."'";
Line #46:$es=" AND ";
Line #47:$ha="";
Line #48:}
Line #49:
Line #50:$werA="";
Line #51:if (isset($_POST[Adoszam]) and $_POST[Adoszam]<>"*") {
Line #52:$wer.= $ha. $es. " Adoszam='".$_POST[Adoszam]."'";
Line #53:$werA=" and Adoszam='".$_POST[Adoszam]."'";
Line #54:$es=" AND ";
Line #55:$ha="";
Line #56:}
Line #57:
Line #58:
Line #59:if (isset($_POST[datum_fej]) and $_POST[datum_fej]<>"*") {
Line #60:$wer.= $ha. $es. " datum_fej='".$_POST[datum_fej]."'";
Line #61:$es=" AND ";
Line #62:$ha="";
Line #63:}
Line #64:
Line #65:$werHO="";
Line #66:if (isset($_POST[Rhonap]) and $_POST[Rhonap]<>"*") {
Line #67:$wer.= $ha. $es. " datum_evho='".$_POST[Rhonap]."'";
Line #68:$werHO=" and datum_evho='".$_POST[Rhonap]."'";
Line #69:$es=" AND ";
Line #70:$ha="";
Line #71:}
Line #72:
Line #73:
Line #74:
Line #75:$wer.=$es;
Line #76:
Line #77:$jegySEL="";
Line #78:IF (isset($_SESSION[Rhonap]) and $_SESSION[Rhonap]<>"*")
Line #79:$jegySEL= " and left(logtime,7)='".substr($_SESSION[Rhonap],0,4)."-".substr($_SESSION[Rhonap],5,2)."' ";
Line #80:
Line #81:$adoSEL="";
Line #82:IF (isset($_SESSION[Adoszam])) {
Line #83://?// echo($_SESSION[Adoszam]."<br>Adoszam<hr>");
Line #84:
Line #85:IF ($_SESSION[Adoszam]<>"-")
Line #86: $adoSEL= " and Adoszam='".$_SESSION[Adoszam]."' ";
Line #87:else
Line #88: $adoSEL= " and Adoszam='' ";
Line #89:}
Line #90:
Line #91:$keres = "SELECT distinct datum_kod FROM qj_musor where future <>'*' $adoSEL $werHO ";
Line #92://?// echo($keres."<br>adoSEL<hr>");
Line #93:
Line #94:
Line #95:
Line #96:$wer=" and (";
Line #97:$or= " ";
Line #98:$weri=0;
Line #99:
Line #100:while ( $jegysor = mysql_fetch_array( $eredmeny )){
Line #101:
Line #102:$jegyHELY=" where datum_kod='$jegysor[datum_kod]' ";
Line #103:IF (isset($_SESSION[hely_nev]) and $_SESSION[hely_nev]<>"*")
Line #104:$jegyHELY.= " and helyszin='".$_SESSION[hely_nev]."' ";
Line #105:
Line #106:$Mkeres = "SELECT datum_kod FROM qj_musor $jegyHELY";
Line #107:
Line #108:$Mur=mysql_num_rows($Meredmeny);
Line #109://?//echo($Mkeres."<hr>");
Line #110:
Line #111:
Line #112:if ($Mur>0) {
Line #113:$wer.=$or." datum_kod='$jegysor[datum_kod]' ";
Line #114:$or= " or ";
Line #115:++$weri;
Line #116:
Line #117:}
Line #118:}
Line #119:
Line #120:$wer.=" )";
Line #121:
Line #122:
Line #123:
Line #124:
Line #125:$disQ = "SELECT distinct cim FROM qj_musor where future <>'*' $wer order by cim" ;
Line #126://?//echo($disQ."<hr>");
Line #127:
Line #128:
Line #129:
Line #130:$sel1="&nbsp;&nbsp;<SELECT TITLE='cim'
Line #131:onchange=this.form.submit(); return true name='cim'>";
Line #132:
Line #133:
Line #134:
Line #135:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #136:if ($disC[cim]==$_POST[cim]) $sel="SELECTED"; else $sel="";
Line #137:if (trim($disC[cim])<>"")
Line #138:$sel1.="<option value='".$disC[cim]."' $sel >".$disC[cim]."</option>";
Line #139:}
Line #140:
Line #141:$sel1.="</SELECT>";
Line #142:
Line #143:
Line #144:$disQ = "SELECT distinct helyszin FROM qj_musor where future <>'*' order by helyszin" ;
Line #145://?//echo($disQ."<hr>");
Line #146:
Line #147:
Line #148:
Line #149:
Line #150:onchange=this.form.submit(); return true name='helyszin'>";
Line #151:
Line #152:
Line #153:
Line #154:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #155:if ($disC[helyszin]==$_POST[helyszin]) $sel="SELECTED"; else $sel="";
Line #156:if (trim($disC[helyszin])<>"")
Line #157:$sel2.="<option value='".$disC[helyszin]."' $sel >".$disC[helyszin]."</option>";
Line #158:}
Line #159:
Line #160:$sel2.="</SELECT>";
Line #161:
Line #162:
Line #163:$disQ = "SELECT distinct Adoszam,cimkieg3 FROM qj_musor where future <>'*' order by Adoszam" ;
Line #164://?//echo($disQ."<hr>");
Line #165:
Line #166:
Line #167:
Line #168:
Line #169:onchange=this.form.submit(); return true name='Adoszam'>";
Line #170:
Line #171:
Line #172:
Line #173:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #174:if ($disC[Adoszam]==$_POST[Adoszam]) $sel="SELECTED"; else $sel="";
Line #175:if (trim($disC[Adoszam])<>"")
Line #176:$selA.="<option value='".$disC[Adoszam]."' $sel >".$disC[Adoszam]." ".$disC[cimkieg3]."</option>";
Line #177:else
Line #178:
Line #179:
Line #180:}
Line #181:
Line #182:$selA.="</SELECT>";
Line #183://///////////////////////////////////////////////////////////////////////////////////
Line #184:
Line #185:
Line #186:
Line #187:$disQ = "SELECT distinct datum_fej FROM qj_musor where future <>'*' order by datum_fej" ;
Line #188://?//echo($disQ."<hr>");
Line #189:
Line #190:
Line #191:
Line #192:$sel3="&nbsp;&nbsp;<SELECT TITLE='Nap'
Line #193:onchange=this.form.submit(); return true name='datum_fej'>";
Line #194:
Line #195:
Line #196:
Line #197:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #198:if ($disC[datum_fej]==$_POST[datum_fej]) $sel="SELECTED"; else $sel="";
Line #199:if (trim($disC[datum_fej])<>"")
Line #200:$sel3.="<option value='".$disC[datum_fej]."' $sel >".$disC[datum_fej]."</option>";
Line #201:}
Line #202:
Line #203:$sel3.="</SELECT>";
Line #204://///////////////////////////
Line #205:
Line #206:$disQ = "SELECT distinct datum_evho as datum FROM qj_musor where future <>'*' $werA order by datum_evho " ;
Line #207://?//echo($disQ."<hr>");
Line #208:
Line #209:
Line #210:
Line #211:
Line #212:onchange=this.form.submit(); return true name='Rhonap'>";
Line #213:
Line #214:
Line #215:
Line #216:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #217:
Line #218:$datum=$disC[datum];
Line #219:
Line #220:if ($datum==$_POST[Rhonap]) $sel="SELECTED"; else $sel="";
Line #221:if (trim($datum)<>"")
Line #222:$sel4.="<option value='".$datum."' $sel >".$datum."</option>";
Line #223:}
Line #224:
Line #225:$sel4.="</SELECT>";
Line #226:
Line #227:///////////////////////////////////
Line #228:
Line #229:$sql="SELECT * FROM qj_sql where szoveg='musor_ord' and archiv<>'*' and future<>'*' ORDER BY widarc";
Line #230:
Line #231:$psor = mysql_fetch_array( $sqlpar );
Line #232:$fid=$psor[sql_memo];
Line #233:$h=split(':',$fid);
Line #234:$nORD=count($h)-1;
Line #235:
Line #236:if (!isset($_POST[sorrend])) $_POST[sorrend]=$h[0];
Line #237:$ord=" order by ".$_POST[sorrend];
Line #238:
Line #239:$sel5="&nbsp;&nbsp;<b>Sorrend:</b><SELECT TITLE='Sorrend'
Line #240:2onchange=this.form.submit(); return true name='sorrend'>";
Line #241:
Line #242:for ($i=0;$i<$nORD;$i++) {
Line #243:
Line #244:if ($h[$i]==$_POST[sorrend]) $sel="SELECTED"; else $sel="";
Line #245:$sel5.="<option value='".$h[$i]."' $sel >".$h[$i]."</option>";
Line #246:}
Line #247:
Line #248:$sel5.="</SELECT>";
Line #249:
Line #250:
Line #251:?>
Line #252:
Line #253:<FORM name=cimform action='<?echo($formcall);?>' method='post'>
Line #254:
Line #255:onchange=this.form.submit(); return true name='Korr'>
Line #256:<? // echo($sel1);
Line #257: echo($selA); echo($sel4);
Line #258: //echo($sel5); ?>
Line #259:</form>
Line #260:
Line #261:<?
Line #262:
Line #263:
Line #264:// echo($keres."<hr>");
Line #265:
Line #266://////////////////////////////////////
Line #267://$keres="SELECT distinct bizomanyos FROM qj_jegy where future <>'*' $wer ORDER BY bizomanyos";
Line #268:$_SESSION[HoHelyWer]=$wer;
Line #269:$_SESSION[HaviJegySel]=$jegySEL;
Line #270:
Line #271:
Line #272:?>