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