Bi-Dir

QQ_haviPENZTARselBOSS.inc

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