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