QB_musorSELnew_MH.inc

---

Line #0:<?php
Line #1://////////
Line #2:?>
Line #3:<style type="text/css">
Line #4:
Line #5:.button2 {
Line #6:font-family: Verdana, Arial, Helvetica, sans-serif;
Line #7:font-size: 7px;
Line #8:font-weight: bold;
Line #9:color: #003366
Line #10:border: #00ffff;
Line #11:border-style: solid;
Line #12:border-width: 1px;
Line #13:}
Line #14:
Line #15:.button1 {
Line #16: font-family: Verdana, Arial, Helvetica, sans-serif;
Line #17: font-size: 12px;
Line #18: font-weight: bold;
Line #19: font-style: normal;
Line #20: line-height: normal;
Line #21: background-color:#FA2;
Line #22: color: black;
Line #23: text-decoration: none;
Line #24: border-color: #C0C0F0 red yellow #C0C0F0
Line #25: margin-top: 0px;
Line #26: margin-right: 0px;
Line #27: margin-bottom: 0px;
Line #28: margin-left: 0px
Line #29:}
Line #30:
Line #31:</style>
Line #32:<?php
Line #33:
Line #34:
Line #35:if (!isset($_POST[sqlpar])) $_POST[sqlpar]= $_SESSION[selNEWpar];
Line #36:
Line #37://BI_alert($action);
Line #38:
Line #39:if (isset($_POST[sqlpar])) {
Line #40: $wel1=$wel2=$wel3="";
Line #41: if ($_POST[sqlpar]=="datum_fej") $wel1= " CHECKED ";
Line #42: if ($_POST[sqlpar]=="cim") $wel2= " CHECKED ";
Line #43: if ($_POST[sqlpar]=="helyszin") $wel3= " CHECKED ";
Line #44: $_SESSION[selNEWpar]=$_POST[sqlpar];
Line #45:}
Line #46:IF (isset($_POST["sqlpar"])) $mezo=$_POST["sqlpar"]; else $mezo="datum_fej";
Line #47:IF (isset($_POST[sqlord])) $ord = " DESC"; else $ord="";
Line #48:
Line #49:
Line #50:IF (isset($_POST[berlet])) {
Line #51: $_SESSION[selNEWberlet]=$_POST[berlet];
Line #52:}
Line #53:
Line #54:IF (isset($_POST[hely_kod])) {
Line #55: $_SESSION[selNEWhely]=$_POST[hely_kod];
Line #56:}
Line #57:
Line #58:if (isset($_POST[arselect])) {
Line #59: $_SESSION[selNEWear]=$_POST[arselect];
Line #60: $_SESSION[arselect]=$_POST[arselect];
Line #61:}
Line #62:
Line #63:if (isset($_POST[evho])) {
Line #64: $_SESSION[selNEWevho]=$_POST[evho];
Line #65:}
Line #66:
Line #67:if (isset($_POST[musor_kod])) {
Line #68: $_SESSION[selNEWkod]=$_POST[musor_kod];
Line #69: $_SESSION[CALL_KOD]=$_POST[musor_kod];
Line #70:}
Line #71:
Line #72:if (!isset($_SESSION[selNEWkod])) {
Line #73: $_SESSION[selNEWkod]="0";
Line #74:}
Line #75:
Line #76:
Line #77:
Line #78:$archiv=" archiv <>'*' and future <>'*' ";
Line #79:
Line #80:if ($_SESSION[selNEWkod]<>"0" and $_SESSION[selNEWkod]<>"")
Line #81: $wer=" and (datum_kod='$_SESSION[selNEWkod]' or datum_kod='*') "; else $wer="";
Line #82:if ($_SESSION[selNEWhely]<>"*" and $_SESSION[selNEWhely]<>"")
Line #83: $her=" and rovid_helyszin='$_SESSION[selNEWhely]'"; else $her="";
Line #84:if ($_SESSION[selNEWevho]<>"*" and $_SESSION[selNEWevho]<>"")
Line #85: $evr=" and datum_evho='$_SESSION[selNEWevho]'"; else $evr="";
Line #86:
Line #87:
Line #88:$disQ = "SELECT distinct rovid_helyszin as helyszin FROM qj_musor where $archiv and rovid_helyszin<>'' order by rovid_helyszin" ;
Line #89:
Line #90:
Line #91:
Line #92:onchange=this.form.submit(); return true name='hely_kod'>";
Line #93:
Line #94:
Line #95:
Line #96:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #97:if ($disC[helyszin]==$_SESSION[selNEWhely]) $sel="SELECTED"; else $sel="";
Line #98:$selH.="<option value='".$disC[helyszin]."' $sel >".$disC[helyszin]."</option>";
Line #99:
Line #100://echo($disC[hely_kod]."/".$disC[helyszin]."<hr>");
Line #101:}
Line #102:$selH.="</SELECT>";
Line #103:
Line #104:
Line #105:$disQ = "SELECT distinct FormaJel FROM qj_musor where $archiv and FormaJel<>'' order by FormaJel" ;
Line #106:
Line #107:
Line #108:
Line #109:onchange=this.form.submit(); return true name='form_kod'>";
Line #110:
Line #111:
Line #112:$iF=0;
Line #113:
Line #114:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #115:if ($disC[FormaJel]==$_POST[form_kod]) $sel="SELECTED"; else $sel="";
Line #116:$selF.="<option value='".$disC[FormaJel]."' $sel >".$disC[FormaJel]."</option>";
Line #117:
Line #118://echo($disC[hely_kod]."/".$disC[helyszin]."<hr>");
Line #119:++$iF;
Line #120:}
Line #121:$selF.="</SELECT>";
Line #122:if ($iF==0) $selF="";
Line #123:
Line #124:
Line #125:$disQ = "SELECT distinct datum_evho FROM qj_musor where $archiv and datum_evho<>'' order by datum_evho" ;
Line #126:
Line #127:
Line #128:
Line #129:onchange=this.form.submit(); return true name='evho'>";
Line #130:
Line #131:
Line #132:$iE=0;
Line #133:
Line #134:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #135:if ($disC[datum_evho]==$_POST[evho]) $sel="SELECTED"; else $sel="";
Line #136:$selE.="<option value='".$disC[datum_evho]."' $sel >".$disC[datum_evho]."</option>";
Line #137:
Line #138://echo($disC[hely_kod]."/".$disC[helyszin]."<hr>");
Line #139:++$iE;
Line #140:}
Line #141:$selE.="</SELECT>";
Line #142:if ($iE==0) $selE="";
Line #143:
Line #144:
Line #145:
Line #146:
Line #147:onchange=this.form.submit(); return true name='arselect'>
Line #148:";
Line #149:
Line #150:
Line #151:$listas="";
Line #152:if (substr($_SESSION[Qusr_kod],0,2)=="CB") {
Line #153:$listas='&nbsp;&nbsp;
Line #154:
Line #155: <img width=60 height=15 src="../_Screen/loading.gif"
Line #156: border=0> </a>
Line #157:';
Line #158:$wer.=" and future<>'*' ";
Line #159:}
Line #160:
Line #161://$keresA = "SELECT distinct szoveg,wid FROM qj_ear where wid=0 order by qj_arkod";
Line #162:
Line #163:$keresA = "SELECT distinct szoveg,wid FROM qj_ear where wid=0 order by szoveg";
Line #164:else
Line #165:$keresA = "SELECT distinct szoveg,wid FROM qj_ear where $archiv $wer order by szoveg";
Line #166:
Line #167://?//BI_alert($keresA);
Line #168:
Line #169:
Line #170:$arform="0";
Line #171:
Line #172:while ( $egy_sor = mysql_fetch_array( $eredmeny ) )
Line #173:{
Line #174:
Line #175: if ($noAR=="-") $arform=$egy_sor[wid];
Line #176:
Line #177: if ($_SESSION[selNEWear]==$egy_sor[wid]) { $sel= " SELECTED "; $arform=$egy_sor[wid]; } else $sel= " ";
Line #178:// if ($_SESSION[selNEWear]==$egy_sor[qj_arkod]) { $sel= " SELECTED "; $arform=$egy_sor[qj_arkod]; } else $sel= " ";
Line #179:// $selA=$selA."<option value='".$egy_sor[qj_arkod]."' $sel >".$egy_sor[szoveg].$egy_sor[qj_arkod]."</option>";
Line #180: $selA=$selA."<option value='".$egy_sor[wid]."' $sel >".$egy_sor[szoveg]."</option>";
Line #181: $noAR="";
Line #182:
Line #183: if ($egy_sor[szoveg]=="-") {
Line #184: $noAR="-";
Line #185:
Line #186:
Line #187: onchange=this.form.submit(); return true name='arselect'>";
Line #188: }
Line #189:
Line #190:// $arform=$egy_sor[qj_arkod];
Line #191:}
Line #192:$selA.="</SELECT>";
Line #193:
Line #194:
Line #195: <img width=20 height=20 src="../_Screen/kosar_m.gif"
Line #196: border=0></a>';
Line #197:
Line #198:
Line #199: <img width=20 height=20 src="../_Screen/belepo.png"
Line #200: border=0></a>&nbsp;';
Line #201:
Line #202:if (substr($_SESSION[Qusr_kod],0,2)=="MH") $relB="";
Line #203:
Line #204:echo "<table border=0 style='position:absolute;left:0;top:0;' CELLSPACING='0'
Line #205:CELLPADDING='0' >";
Line #206:
Line #207:echo"<FORM name=musel
Line #208: action='$action' method='post'>
Line #209:<tr bgcolor=azure valign=top><td valign=baseline>&nbsp;&nbsp;";
Line #210:
Line #211:
Line #212:
Line #213:echo $relK.$selA.$relB;
Line #214:
Line #215:
Line #216:// <INPUT TYPE='CHECKBOX' NAME='listas'>
Line #217:// ";
Line #218:
Line #219:
Line #220: onclick=this.form.submit(); return true name='sqlpar'><i>d</i>
Line #221:
Line #222: onclick=this.form.submit(); return true name='sqlpar'
Line #223:
Line #224: onclick=this.form.submit(); return true name='sqlpar'
Line #225:><i>h</i>";
Line #226:echo "&nbsp;$selH&nbsp;$selE&nbsp;$listas</td>";
Line #227:
Line #228:echo "</tr>
Line #229: <TR valign=top bgcolor=azure ><td valign=baseline>&nbsp;
Line #230:
Line #231: onchange=this.form.submit(); return true name='musor_kod'>";
Line #232:
Line #233:
Line #234:
Line #235:$musor_kod="0";
Line #236:if ($mezo=="") $mezo="datum_fej";
Line #237:
Line #238:if ($mezo=="helyszinj") $ord=",datum_fej"; // nincs... FIX sorrend a szektoroshoz
Line #239: else
Line #240: $ord=",helyszin"; // nincs... FIX sorrend a szektoroshoz
Line #241:
Line #242:$keres = "SELECT * FROM qj_musor where $archiv $her $evr ORDER BY $mezo $ord ";
Line #243:
Line #244:$nur=mysql_num_rows($eredmeny);
Line #245:
Line #246:
Line #247:while ( $egy_sor = mysql_fetch_array( $eredmeny ) )
Line #248:{
Line #249:
Line #250:// list ($key, $val) = each ($egy_sor);
Line #251:
Line #252:if ($_SESSION[selNEWkod]==$egy_sor[datum_kod]) {$sel= " SELECTED "; $musor_kod=$egy_sor[datum_kod];} else $sel= " ";
Line #253:
Line #254:
Line #255:// if ($val===$tabla)
Line #256:// echo "<option value='".$val."' SELECTED>". $val ."</option>";
Line #257:// else
Line #258://else ($mezo=="datum_fej")
Line #259:if ($mezo=="cim")
Line #260: echo "<option value='".$egy_sor[datum_kod]."' $sel >". $egy_sor[cim] ." -<>- " . $egy_sor[datum] ." -<>- " . $egy_sor[helyszin] .$erkezesi."</option>";
Line #261:elseif ($mezo=="helyszin")
Line #262: echo "<option value='".$egy_sor[datum_kod]."' $sel >". $egy_sor[helyszin] ." -<>- " . $egy_sor[datum] ." -<>- " . $egy_sor[cim].$erkezesi."</option>";
Line #263:else
Line #264: echo "<option value='".$egy_sor[datum_kod]."' $sel >". $egy_sor[datum] ." -<>- " . $egy_sor[cim] ." -<>- " . $egy_sor[helyszin] .$erkezesi."</option>";
Line #265:
Line #266:
Line #267:}
Line #268:
Line #269:echo "</SELECT>";
Line #270:
Line #271:
Line #272:echo "</tr></FORM></table>";
Line #273:
Line #274:
Line #275:if ((isset($_POST[arselect]) or isset($_POST[send])) ) {
Line #276:
Line #277:$callR="QJ_helyrajz.php?&musor_kod=".$_SESSION[selNEWkod]."&arselect=".$_POST[arselect];
Line #278:
Line #279: $_SESSION[selNEWkod]=$musor_kod;
Line #280: $_SESSION[CALL_KOD]=$_SESSION[selNEWkod];
Line #281: $_SESSION[selNEWear]=$arform;
Line #282: $_SESSION[arselect]=$arform;
Line #283: $_POST[arselect]=$arform;
Line #284:
Line #285:$call="QJ_helyrajz.php?&musor_kod=".$_SESSION[selNEWkod]."&arselect=".$_POST[arselect];
Line #286:
Line #287:if ($_SESSION[selNEWkod]<>'0' or isset($_POST[send]))
Line #288:echo "<script language = javascript>
Line #289: window.open('QJ_helyrajz.php?&musor_kod=".$_SESSION[selNEWkod]."&arselect=".$_POST[arselect]."','adatframe');
Line #290: </script>";
Line #291:}
Line #292:
Line #293:
Line #294:if (isset($_POST[send]) or isset($_POST[sqlpar]))
Line #295:{
Line #296://echo "<br><br><br>";
Line #297:// include("QJ_varlist.php");
Line #298:}
Line #299:
Line #300:/*
Line #301:echo "<br><br><hr>
Line #302: $keres<hr>
Line #303: $nur<hr>
Line #304: $keresA<hr>
Line #305: $disQ<hr>
Line #306: $call<hr>
Line #307: $callR<hr>
Line #308:";
Line #309:
Line #310:
Line #311:echo "<br>";
Line #312:include("QJ_varlist.php");
Line #313:*/
Line #314:
Line #315:
Line #316:?>