QJ_adoSELECT.inc
Line #0:<SCRIPT LANGUAGE="JavaScript" SRC="calendar.js"></SCRIPT>
Line #1:<?php
Line #2:
Line #3:if (isset($_POST[kezdIDO]) and $_POST[kezdIDO]<>"" and $_POST[RendezoSZ]<>"*") $_POST[RendezoSZ]="*";
Line #4:
Line #5:if (!isset($_POST[kezdIDO])) $_POST[kezdIDO]=date("Y.m.d");
Line #6:if (!isset($_SESSION[NapiDatum]) and $_POST[kezdIDO]<>"") $_SESSION[NapiDatum]=$_POST[kezdIDO];
Line #7:if ($_POST[kezdIDO]<>"") $_SESSION[NapiDatum]=$_POST[kezdIDO];
Line #8:
Line #9:IF (isset($_POST[RendezoSZ])) $_SESSION[RendezoSZ]=$_POST[RendezoSZ];
Line #10:IF (isset($_SESSION[RendezoSZ])) $_POST[RendezoSZ]=$_SESSION[RendezoSZ];
Line #11:
Line #12:IF (isset($_SESSION[RendezoSZ]) and $_SESSION[RendezoSZ]=="*") $_POST[kezdIDO]=$_SESSION[NapiDatum];
Line #13:
Line #14:$jegySEL="";
Line #15:IF (isset($_SESSION[RendezoSZ]) and $_SESSION[RendezoSZ]<>"*")
Line #16:$jegySEL= " and left(logtime,10)='".$_POST[kezdIDO]."' ";
Line #17:
Line #18://?//
Line #19:BI_alert($_SESSION[NapiDatum]);
Line #20:
Line #21:$disQ = "SELECT distinct Adoszam,cimkieg3 FROM qj_musor order by cimkieg3 " ;
Line #22:
Line #23:
Line #24:
Line #25:onchange=this.form.submit(); return true name='RendezoSZ'>";
Line #26:
Line #27:
Line #28:
Line #29:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #30:
Line #31:$adoszam=$disC[Adoszam];
Line #32:
Line #33:if ($adoszam==$_POST[RendezoSZ]) $sel="SELECTED"; else $sel="";
Line #34:if (trim($adoszam)<>"")
Line #35:$sel4.="<option value='".$adoszam."' $sel >".$disC[cimkieg3]."</option>";
Line #36:}
Line #37:
Line #38:$sel4.="</SELECT>";
Line #39:
Line #40:/*
Line #41:$SelFile=" qj_jegy where ($_SESSION[SQL_elad] ) $jegySEL ";
Line #42:
Line #43:if (isset($_GET[musor_kod]) or isset($_POST[frissit]) or !isset($_GET[musor_kod]))
Line #44:{ $_SESSION[SUBlista]=""; $_SESSION[SUBwer]="";
Line #45:}
Line #46:
Line #47:if (isset($_POST[musor_kod])) $_GET[musor_kod]=$_POST[musor_kod];
Line #48:
Line #49:
Line #50:if (isset($_POST[vegIDO])) $_POST[vegIDO]=str_replace(".","-",$_POST[vegIDO]);
Line #51:
Line #52:if (isset($_POST[kezdIDO])) $kezdIDO=str_replace(".","-",$_POST[kezdIDO]);
Line #53:else {
Line #54:$keres="SELECT logtime FROM $SelFile ORDER BY logtime limit 1";
Line #55:
Line #56:
Line #57:$egy_sor = mysql_fetch_array( $eredmeny );
Line #58:$kezdIDO=substr($egy_sor[logtime],0,10);
Line #59:}
Line #60:
Line #61://?//
Line #62:
Line #63:echo($keres."<hr>");
Line #64:
Line #65:if (isset($_POST[vegIDO])) $vegIDO=str_replace(".","-",$_POST[vegIDO]);
Line #66:else {
Line #67:$keres="SELECT logtime FROM $SelFile ORDER BY logtime DESC limit 1";
Line #68:
Line #69:
Line #70:$egy_sor = mysql_fetch_array( $eredmeny );
Line #71:$vegIDO=substr($egy_sor[logtime],0,10);
Line #72:}
Line #73:
Line #74://?//
Line #75:
Line #76:echo($keres."<hr>");
Line #77:
Line #78:
Line #79:
Line #80:$keres="SELECT distinct bizomanyos FROM $SelFile ORDER BY bizomanyos";
Line #81://?//
Line #82:echo($keres."<hr>");
Line #83:echo($jegySEL."<hr>");
Line #84:
Line #85:
Line #86:$i=0;
Line #87:$e="";
Line #88:
Line #89:while ( $egy_sor = mysql_fetch_array( $eredmeny ) )
Line #90:{
Line #91:if ($_POST[bizomanyos]==$egy_sor[bizomanyos] ) $sel=" SELECTED "; else $sel="";
Line #92:if ($egy_sor[bizomanyos]<>"") {
Line #93:$e=$e."<option value='".$egy_sor[bizomanyos]."' $sel>".$egy_sor[bizomanyos]."</option>";
Line #94:++$i; }
Line #95:}
Line #96:
Line #97:
Line #98:
Line #99:
Line #100:onchange= return true name='bizomanyos'>".$e."</SELECT>";
Line #101:
Line #102:if (isset($_SESSION[SelMusorKod]))
Line #103:$SelFile="qj_jegy where ($_SESSION[SQL_elad] ) $jegySEL and datum_kod='".$_SESSION[SelMusorKod]."'";
Line #104:
Line #105:if (isset($_POST[bizomanyos]))
Line #106:
Line #107:
Line #108: $_SESSION[SUBwer].=$SelFile.$jegySEL." and bizomanyos='".$_POST[bizomanyos]."' ";
Line #109: $SelFile="";
Line #110: }
Line #111:
Line #112:if (isset($_POST[vegIDO]))
Line #113: { $_SESSION[SUBlista].="< - > ".$_POST[vegIDO]."<i></i>";
Line #114: $_SESSION[SUBwer].=$SelFile.$jegySEL." and left(logtime,10)<='".$_POST[vegIDO]."' ";
Line #115: $SelFile="";
Line #116: }
Line #117:
Line #118:
Line #119:
Line #120:if (isset($_POST[kezdIDO]))
Line #121:
Line #122: $_SESSION[SUBwer].=$SelFile.$jegySEL." and left(logtime,10)>='".$_POST[kezdIDO]."' ";
Line #123: $SelFile="";
Line #124: }
Line #125:
Line #126:*/
Line #127:
Line #128:$kezdIDO=$_SESSION[NapiDatum];
Line #129:IF (isset($_SESSION[RendezoSZ]) and $_SESSION[RendezoSZ]<>"*") $kezdIDO="";
Line #130:
Line #131:
Line #132:?>
Line #133:
Line #134:<table width=100% border=0><tr><td align=left>
Line #135:<FORM name=myForm action="<?php echo($L_PHP); ?>" method='post'>
Line #136:
Line #137:
Line #138:
Line #139:
Line #140:
Line #141:<a href="javascript:doNothing()"
Line #142:onClick="setDateField(document.myForm.kezdIDO);top.newWin=window.open('calendar.html','cal','dependent=yes,width=210,height=230,screenX=200,screenY=300,titlebar=yes')">
Line #143:
Line #144:
Line #145: <b>
Line #146:
Line #147:<INPUT TYPE='hidden' NAME='musor_kod' value="<?php echo($_GET[musor_kod]);?>">
Line #148:
Line #149:<?php
Line #150:echo($sel4);
Line #151:?>
Line #152:
Line #153:</form>
Line #154:
Line #155:</td><tr><td>
Line #156:
Line #157:<?php
Line #158:
Line #159:$keres = "SELECT distinct datum_kod FROM qj_musor where future <>'*' and Adoszam='".$_SESSION[RendezoSZ]."' ";
Line #160://?//
Line #161:echo($keres."<hr>");
Line #162:
Line #163:
Line #164:
Line #165:$wer=" and (";
Line #166:$or= " ";
Line #167:$weri=0;
Line #168:
Line #169:while ( $jegysor = mysql_fetch_array( $eredmeny )){
Line #170:
Line #171:$wer.=$or." datum_kod='$jegysor[datum_kod]' ";
Line #172:$or= " or ";
Line #173:++$weri;
Line #174:
Line #175:}
Line #176:
Line #177:$wer.=" ) ";
Line #178:
Line #179:
Line #180:else
Line #181:$_SESSION[Datum_Ado]=$wer;
Line #182:
Line #183:
Line #184:?>