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