QB_musorSELnew_20181017_tho.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 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 helyszin FROM qj_musor where $archiv $_SESSION[Quniq_musor] and helyszin<>'' order by helyszin" ;
Line #89:
Line #90:
Line #91:
Line #92:onchange=this.form.submit(); return true name='hely_kod'>";
Line #93:
Line #94://?//if (!isset($_SESSION[Quniq_musor]))
Line #95:
Line #96:
Line #97:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #98:
Line #99:if (strlen($disC[helyszin])>15) $helyszin=trim(substr($disC[helyszin],0,13)).'...'; else $helyszin=trim($disC[helyszin]);
Line #100:if ($disC[helyszin]==$_SESSION[selNEWhely]) $sel="SELECTED"; else $sel="";
Line #101:$selH.="<option value='".$disC[helyszin]."' $sel >".$helyszin."</option>";
Line #102:
Line #103://echo($disC[hely_kod]."/".$disC[helyszin]."<hr>");
Line #104:}
Line #105:$selH.="</SELECT>";
Line #106:
Line #107:$disQ = "SELECT distinct FormaJel FROM qj_musor where $archiv $_SESSION[Quniq_musor] and FormaJel<>'' order by FormaJel" ;
Line #108:
Line #109:
Line #110:
Line #111:onchange=this.form.submit(); return true name='form_kod'>";
Line #112:
Line #113:
Line #114:$iF=0;
Line #115:
Line #116:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #117:if ($disC[FormaJel]==$_POST[form_kod]) $sel="SELECTED"; else $sel="";
Line #118:$selF.="<option value='".$disC[FormaJel]."' $sel >".$disC[FormaJel]."</option>";
Line #119:
Line #120://echo($disC[hely_kod]."/".$disC[helyszin]."<hr>");
Line #121:++$iF;
Line #122:}
Line #123:$selF.="</SELECT>";
Line #124:if ($iF==0) $selF="";
Line #125:
Line #126:
Line #127:$disQ = "SELECT distinct datum_evho FROM qj_musor where $archiv $_SESSION[Quniq_musor] and datum_evho<>'' order by datum_evho" ;
Line #128:
Line #129:
Line #130:
Line #131:onchange=this.form.submit(); return true name='evho'>";
Line #132:
Line #133:
Line #134:$iE=0;
Line #135:
Line #136:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #137:if ($disC[datum_evho]==$_POST[evho]) $sel="SELECTED"; else $sel="";
Line #138:$selE.="<option value='".$disC[datum_evho]."' $sel >".$disC[datum_evho]."</option>";
Line #139:
Line #140://echo($disC[hely_kod]."/".$disC[helyszin]."<hr>");
Line #141:++$iE;
Line #142:}
Line #143:$selE.="</SELECT>";
Line #144:if ($iE==0) $selE="";
Line #145:
Line #146:
Line #147:
Line #148:
Line #149:onchange=this.form.submit(); return true name='arselect'>
Line #150:";
Line #151:
Line #152:
Line #153:$listas="";
Line #154:if (substr($_SESSION[Qusr_kod],0,2)=="CB") {
Line #155:$listas='&nbsp;&nbsp;
Line #156:
Line #157: <img width=15 height=15 src="../_Screen/forward.png"
Line #158: border=0> </a>
Line #159:';
Line #160:$wer.=" and future<>'*' ";
Line #161:}
Line #162:
Line #163:$keresA = "SELECT distinct szoveg,wid FROM qj_ear where future<>'*' $wer order by qj_arkod";
Line #164:
Line #165://$keresA = "SELECT distinct szoveg,wid FROM qj_ear where wid=0 order by qj_arkod";
Line #166:
Line #167:$keresA = "SELECT distinct szoveg,wid FROM qj_ear where wid=0 order by szoveg";
Line #168:else
Line #169:$keresA = "SELECT szoveg,wid FROM qj_ear where future<>'*' $wer order by qj_arkod";
Line #170:
Line #171:
Line #172:
Line #173:$arform="0";
Line #174:
Line #175:$nur=mysql_num_rows($eredmeny);
Line #176://?//BI_alert($keresA."/".$nur);
Line #177:
Line #178://?//if ($nur>0 and isset($_SESSION[Quniq_musor])) $selH="";
Line #179:
Line #180:
Line #181:$a='';
Line #182:
Line #183:while ( $egy_sor = mysql_fetch_array( $eredmeny ) )
Line #184:{
Line #185:
Line #186:
Line #187:
Line #188:$a=$a.$egy_sor[wid].'/'.$egy_sor[qj_arkod].'/'.$egy_sor[szoveg].'%';
Line #189:
Line #190: if ($noAR=="-") $arform=$egy_sor[wid];
Line #191:
Line #192: if ($_SESSION[selNEWear]==$egy_sor[wid]) { $sel= " SELECTED "; $arform=$egy_sor[wid]; } else $sel= " ";
Line #193:// if ($_SESSION[selNEWear]==$egy_sor[qj_arkod]) { $sel= " SELECTED "; $arform=$egy_sor[qj_arkod]; } else $sel= " ";
Line #194:// $selA=$selA."<option value='".$egy_sor[qj_arkod]."' $sel >".$egy_sor[szoveg].$egy_sor[qj_arkod]."</option>";
Line #195: $selA=$selA."<option value='".$egy_sor[wid]."' $sel >".$egy_sor[szoveg]."</option>";
Line #196: $noAR="";
Line #197:
Line #198: if ($egy_sor[szoveg]=="-") {
Line #199: $noAR="-";
Line #200:
Line #201:
Line #202: onchange=this.form.submit(); return true name='arselect'>";
Line #203: }
Line #204:
Line #205:// $arform=$egy_sor[qj_arkod];
Line #206:}
Line #207:$selA.="</SELECT>";
Line #208:
Line #209://?//BI_alert($a);
Line #210:
Line #211:
Line #212:
Line #213: <img width=20 height=20 src="../_Screen/kosar_m.gif"
Line #214: border=0></a>';
Line #215:
Line #216:
Line #217: <img width=20 height=20 src="../_Screen/belepo.png"
Line #218: border=0></a>&nbsp;';
Line #219:
Line #220:
Line #221:
Line #222:
Line #223:if (substr($_SESSION[Qusr_kod],0,2)=="MH") $relB="";
Line #224:
Line #225:echo "<table border=0 style='position:absolute;left:0;top:0;' CELLSPACING='0'
Line #226:CELLPADDING='0' >";
Line #227:
Line #228:echo"<FORM name=musel
Line #229: action='$action' method='post'>
Line #230:<tr bgcolor=azure valign=top><td valign=baseline>&nbsp;&nbsp;";
Line #231:
Line #232:
Line #233:
Line #234:echo $relK.$selA.$relB;
Line #235:
Line #236:
Line #237:// <INPUT TYPE='CHECKBOX' NAME='listas'>
Line #238:// ";
Line #239:
Line #240:
Line #241: onclick=this.form.submit(); return true name='sqlpar'><i>d</i>
Line #242:
Line #243: onclick=this.form.submit(); return true name='sqlpar'
Line #244:
Line #245: onclick=this.form.submit(); return true name='sqlpar'
Line #246:><i>h</i>";
Line #247:echo "&nbsp;$selH&nbsp;$selE&nbsp;$listas</td>";
Line #248:
Line #249:echo "</tr>
Line #250: <TR valign=top bgcolor=azure ><td valign=baseline>&nbsp;
Line #251:
Line #252: onchange=this.form.submit(); return true name='musor_kod'>";
Line #253:
Line #254:
Line #255:
Line #256:$musor_kod="0";
Line #257:if ($mezo=="") $mezo="datum_fej";
Line #258:
Line #259:$keres = "SELECT * FROM qj_musor where $archiv $_SESSION[Quniq_musor] $her $evr ORDER BY $mezo $ord ";
Line #260:
Line #261:$nur=mysql_num_rows($eredmeny);
Line #262:
Line #263:
Line #264:while ( $egy_sor = mysql_fetch_array( $eredmeny ) )
Line #265:{
Line #266:
Line #267:// list ($key, $val) = each ($egy_sor);
Line #268:
Line #269:if ($_SESSION[selNEWkod]==$egy_sor[datum_kod]) {$sel= " SELECTED "; $musor_kod=$egy_sor[datum_kod];} else $sel= " ";
Line #270:
Line #271:
Line #272:// if ($val===$tabla)
Line #273:// echo "<option value='".$val."' SELECTED>". $val ."</option>";
Line #274:// else
Line #275://else ($mezo=="datum_fej")
Line #276:if ($mezo=="cim")
Line #277: echo "<option value='".$egy_sor[datum_kod]."' $sel >". $egy_sor[cim] ." -<>- " . $egy_sor[datum] ." -<>- " . $egy_sor[helyszin] .$erkezesi."</option>";
Line #278:elseif ($mezo=="helyszin")
Line #279: echo "<option value='".$egy_sor[datum_kod]."' $sel >". $egy_sor[helyszin] ." -<>- " . $egy_sor[datum] ." -<>- " . $egy_sor[cim].$erkezesi."</option>";
Line #280:else
Line #281: echo "<option value='".$egy_sor[datum_kod]."' $sel >". $egy_sor[datum] ." -<>- " . $egy_sor[cim] ." -<>- " . $egy_sor[helyszin] .$erkezesi."</option>";
Line #282:
Line #283:
Line #284:}
Line #285:
Line #286:echo "</SELECT>";
Line #287:
Line #288:
Line #289:echo "</tr></FORM></table>";
Line #290:
Line #291:
Line #292:if ((isset($_POST[arselect]) or isset($_POST[send])) ) {
Line #293:
Line #294:$callR="QJ_helyrajz.php?&musor_kod=".$_SESSION[selNEWkod]."&arselect=".$_POST[arselect];
Line #295:
Line #296: $_SESSION[selNEWkod]=$musor_kod;
Line #297: $_SESSION[CALL_KOD]=$_SESSION[selNEWkod];
Line #298: $_SESSION[selNEWear]=$arform;
Line #299: $_SESSION[arselect]=$arform;
Line #300: $_POST[arselect]=$arform;
Line #301:
Line #302:$call="QJ_helyrajz.php?&musor_kod=".$_SESSION[selNEWkod]."&arselect=".$_POST[arselect];
Line #303:
Line #304:if ($_SESSION[selNEWkod]<>'0' or isset($_POST[send]))
Line #305:echo "<script language = javascript>
Line #306: window.open('QJ_helyrajz.php?&musor_kod=".$_SESSION[selNEWkod]."&arselect=".$_POST[arselect]."','adatframe');
Line #307: </script>";
Line #308:}
Line #309:
Line #310:
Line #311:if (isset($_POST[send]) or isset($_POST[sqlpar]))
Line #312:{
Line #313://echo "<br><br><br>";
Line #314:// include("QJ_varlist.php");
Line #315:}
Line #316:
Line #317:/*
Line #318:echo "<br><br><hr>
Line #319: $keres<hr>
Line #320: $nur<hr>
Line #321: $keresA<hr>
Line #322: $disQ<hr>
Line #323: $call<hr>
Line #324: $callR<hr>
Line #325:";
Line #326:
Line #327:
Line #328:echo "<br>";
Line #329:include("QJ_varlist.php");
Line #330:*/
Line #331:
Line #332:
Line #333:?>