Bi-Dir

QC_gyujtoSELECT.inc

Line #0:<?php
Line #1:
Line #2:if (!isset($_SESSION[gyujtoSELECT])) $_SESSION[gyujtoSELECT]="QJ_gyujtoSELECT.php";
Line #3:if (!isset($_SESSION[CimUp])) $_SESSION[CimUp]="QJ_kijelol.php";
Line #4:
Line #5:if (isset($_POST[honap]) and $_POST[honap]<>"*" ) {
Line #6: $werho=" and left(logtime,7)='$_POST[honap]'";
Line #7: $werMho=" and left(datum_fej,7)='$_POST[honap]'";
Line #8: $werMevho=" and datum_evho='$_POST[honap]'";
Line #9:} else {$werho=""; $werMho=""; $werMeho=""; }
Line #10:
Line #11:
Line #12:if (!isset($_POST[honap]) or $_POST[honap]=="*") unset($_SESSION[selWERhonap]);
Line #13:
Line #14:if ($_SESSION[selWERhonap]<>$_POST[honap] and isset($_SESSION[selWERhonap]))
Line #15:{
Line #16:unset($_SESSION[selWERmusorSZERVEZO]);
Line #17:unset($_SESSION[selWERmusorJOG]);
Line #18:unset($_SESSION[selWERmusorSZERVEZO]);
Line #19:unset($_SESSION[selWERmusorJOG]);
Line #20:unset($_SESSION[selWERjegy]);
Line #21:unset($_SESSION[selWERhonap]);
Line #22:
Line #23:unset($_POST[bizomanyos]);
Line #24:}
Line #25:
Line #26:if (isset($_POST[bizomanyos]) and $_POST[bizomanyos]=="*" ) {
Line #27:unset($_POST[nap]); unset($_POST[status]);
Line #28:}
Line #29:
Line #30:
Line #31://$_SESSION[qontroll]="*";
Line #32:
Line #33:if (!isset($_SESSION[SQL_inet])) {
Line #34:
Line #35:++$_SESSION[QJ_hiba];
Line #36:
Line #37:echo "<script>
Line #38:
Line #39:window.open('QJ_gyujtoEF.php','sframe');
Line #40:</script>";
Line #41:}
Line #42:
Line #43:$_SESSION[QJ_hiba]=0;
Line #44:
Line #45://BISQLcon();
Line #46:
Line #47:$login=$_SESSION[login];
Line #48:$admin=$_SESSION[admin];
Line #49:
Line #50:
Line #51:if ($_POST[Sbizonylat]<>"") {
Line #52:
Line #53:echo "<script>
Line #54:window.open('QJ_analitika.php?&bizonylat=".$_POST[Sbizonylat]."','sframe');
Line #55:</script>";
Line #56:}
Line #57:
Line #58:
Line #59:///////////
Line #60:
Line #61:if ($_SESSION[admin]<>"ADMIN") $_POST[bizomanyos]=$_SESSION[login];
Line #62:
Line #63:$_SESSION[L_bizomanyos]=$_POST[bizomanyos];
Line #64:$_SESSION[L_nap]=$_POST[nap];
Line #65:$_SESSION[L_status]=$_POST[status];
Line #66:
Line #67://$_SESSION[L_adoszam]=htmlspecialchars($_POST[adoszam]);
Line #68:$_SESSION[L_adoszam]=$_POST[adoszam];
Line #69:
Line #70:
Line #71:if ($_POST[bizomanyos]==$_SESSION[login] )
Line #72:$wer=" and bizomanyos='".$_POST[bizomanyos]."'";
Line #73:else
Line #74:$wer="";
Line #75:
Line #76:echo"<FORM name=orderby
Line #77:action='$_SESSION[gyujtoSELECT]' method='post'>";
Line #78:
Line #79:$disQ = "SELECT distinct bizomanyos FROM qj_jlog where future <>'*' $wer $werho order by bizomanyos" ;
Line #80:
Line #81:
Line #82://echo($disQ."<hr>");
Line #83:
Line #84:
Line #85:onchange=this.form.submit(); return true name='bizomanyos'>";
Line #86:
Line #87:
Line #88:
Line #89:if ($_SESSION['admin']=='ADMIN') {
Line #90:if ($_POST[bizomanyos]=='0') $sel="SELECTED"; else $sel="";
Line #91:
Line #92:}
Line #93:
Line #94:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #95:if ($disC[bizomanyos]==$_POST[bizomanyos]) $sel="SELECTED"; else $sel="";
Line #96:$sel2.="<option value='".$disC[bizomanyos]."' $sel >".$disC[bizomanyos]."</option>";
Line #97:}
Line #98:
Line #99:$sel2.="</SELECT></td>";
Line #100:
Line #101:////////
Line #102:
Line #103:if (isset($_POST[bizomanyos]) and $_POST[bizomanyos]<>"*" )
Line #104:$wer=" and bizomanyos='".$_POST[bizomanyos]."'";
Line #105:else
Line #106:$wer="";
Line #107:if ($_POST[bizomanyos]=="0" ) $wer="";
Line #108:
Line #109:$disQ = "SELECT distinct left(logtime,10) as datum FROM qj_jegy where future <>'*'
Line #110:$wer $werho order by left(logtime,10) DESC" ;
Line #111:
Line #112:
Line #113:
Line #114:
Line #115:onchange=this.form.submit(); return true name='nap'>";
Line #116:
Line #117:
Line #118:$nap="?";
Line #119:
Line #120:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #121:$Wnap=$disC[datum];
Line #122:
Line #123:
Line #124:if ($nap<>$Wnap ) {
Line #125:$nap=$Wnap;
Line #126:if ($nap==$_POST[nap]) $sel="SELECTED"; else $sel="";
Line #127:$sel1.="<option value='".$nap."' $sel >". $nap."</option>";
Line #128:}
Line #129:}
Line #130:
Line #131:$sel1.="</SELECT></td>";
Line #132:
Line #133://///////
Line #134:if (isset($_POST[bizomanyos]) and $_POST[bizomanyos]<>"*" )
Line #135:$wer=" and bizomanyos='".$_POST[bizomanyos]."'";
Line #136:else
Line #137:$wer="";
Line #138:if ($_POST[bizomanyos]=="0" ) $wer="";
Line #139:
Line #140:$disQ = "SELECT distinct left(logtime,7) as datum FROM qj_jegy where future<>'*' order by left(logtime,7) DESC" ;
Line #141:
Line #142://echo($disQ."<hr>");
Line #143:
Line #144:
Line #145:
Line #146:
Line #147:onchange=this.form.submit(); return true name='honap'>";
Line #148:
Line #149:
Line #150:$ho="?";
Line #151:
Line #152:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #153:$Who=$disC[datum];
Line #154:if ($nap<>$Who ) {
Line #155:$ho=$Who;
Line #156:if ($ho==$_POST[honap]) $sel="SELECTED"; else $sel="";
Line #157:$sel9.="<option value='".$Who."' $sel >". $Who."</option>";
Line #158:}
Line #159:}
Line #160:
Line #161:$sel9.="</SELECT></td>";
Line #162:
Line #163://///////
Line #164:
Line #165:
Line #166:if (isset($_POST[nap]) and $_POST[nap]<>"*") {
Line #167:$wer.=" and left(logtime,10)='".$_POST[nap]."'";
Line #168:}
Line #169:else $wer="";
Line #170:
Line #171:$disQ = "SELECT distinct status FROM qj_jlog where future <>'*' $wer $werho order by status" ;
Line #172:
Line #173://echo($disQ."<hr>");
Line #174:
Line #175:
Line #176:onchange=this.form.submit(); return true name='status'>";
Line #177:
Line #178:
Line #179:
Line #180:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #181:if ($disC[status]==$_POST[status]) $sel="SELECTED"; else $sel="";
Line #182:
Line #183:$sel3.="<option value='".$disC[status]."' $sel>".$disC[status]."</option>";
Line #184:}
Line #185:
Line #186:$sel3.="</SELECT></td>";
Line #187:
Line #188:if ($_POST[bizomanyos]=="*" or !isset($_POST[bizomanyos]) ) { $sel1=""; $sel3=""; }
Line #189:if ($_POST[nap]=="*" or !isset($_POST[nap])) $sel3="";
Line #190:
Line #191:$sel4="<td COLSPAN=4>
Line #192:<input type='text' value='".$_POST[Sbizonylat]."' name='Sbizonylat'
Line #193:onchange=this.form.submit(); return true name='Sbizonylat'>
Line #194:
Line #195:
Line #196:onclick=this.form.submit(); return true name='frissit'>
Line #197:
Line #198: <INPUT TYPE='CHECKBOX' NAME='berlet'
Line #199: onclick=this.form.submit(); return true name='berlet'
Line #200:
Line #201:
Line #202: <INPUT TYPE='CHECKBOX' NAME='Szerviz'
Line #203: onclick=this.form.submit(); return true name='Szerviz'
Line #204: >Szerviz
Line #205:
Line #206:";
Line #207:
Line #208:
Line #209:$disQ = "SELECT Distinct szervezo FROM qj_musor where szervezo<>'' $werMho order by szervezo" ;
Line #210:
Line #211:
Line #212:$sel5="<td>
Line #213:
Line #214:
Line #215:onchange=this.form.submit(); return true name='szervezo'>";
Line #216:
Line #217:
Line #218:$i5=0;
Line #219:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #220:if ($disC[szervezo]==$_POST[szervezo]) $sel="SELECTED"; else $sel="";
Line #221:++$i5;
Line #222:$sel5.="<option value='".$disC[szervezo]."' $sel >".$disC[szervezo]."</option>";
Line #223:}
Line #224:
Line #225:$sel5.="</SELECT></td>";
Line #226:if ($i5==0) $sel5="";
Line #227:
Line #228:
Line #229:
Line #230:
Line #231:$disQ = "SELECT Distinct cimkieg3 FROM qj_musor where cimkieg3<>'' $werMho order by cimkieg3" ;
Line #232:
Line #233:
Line #234:$sel6="
Line #235:<td>
Line #236:
Line #237:onchange=this.form.submit(); return true name='rendez'>";
Line #238:
Line #239:
Line #240:
Line #241:
Line #242:$i6==0;
Line #243:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #244:++$i6;
Line #245:if ($disC[cimkieg3]==$_POST[rendez]) $sel="SELECTED"; else $sel="";
Line #246:$sel6.="<option value='".$disC[cimkieg3]."' $sel >".$disC[cimkieg3]."</option>";
Line #247:}
Line #248:$sel6.="</SELECT></td>
Line #249:";
Line #250:
Line #251:if ($i6==0) $sel6="";
Line #252:
Line #253:// Napok : $sel1 $_POST[nap]
Line #254:// Bizom : $sel2 $_POST[bizomanyos]
Line #255:
Line #256:
Line #257:// Szerv : $sel5 $_POST[szervezo]
Line #258:// Jog : $sel6 $_POST[rendez]
Line #259:
Line #260:
Line #261:echo("<table BORDER=0 >
Line #262:<tr bgcolor=white>
Line #263:
Line #264:<td COLSPAN=4>
Line #265:
Line #266:<tr bgcolor=gold>
Line #267:$sel2
Line #268:$sel4 </tr>
Line #269:$sel1 $sel3
Line #270:$sel9 $sel5 $sel6
Line #271:</tr>
Line #272:</table>");
Line #273:
Line #274:echo"</FORM>";
Line #275:
Line #276:$_SESSION[selWERjegy]="";
Line #277:if (isset($_POST[bizomanyos])) {
Line #278: if ($_POST[bizomanyos]<>"*")
Line #279: $_SESSION[selWERjegy].= " and bizomanyos='$_POST[bizomanyos]' ";
Line #280: $_SESSION[seLbizomanyos]= $_POST[bizomanyos];
Line #281: } else {
Line #282: $_SESSION[selWERjegy].= " and bizomanyos='$_POST[bizomanyos]' ";
Line #283: unset($_SESSION[seLbizomanyos]);
Line #284: }
Line #285:
Line #286:if (isset($_POST[nap]))
Line #287:if ($_POST[nap]<>"*") {
Line #288: $_SESSION[selWERjegy].= " and left(logtime,10)='$_POST[nap]' ";
Line #289: $_SESSION[seL_nap]= $_POST[nap];
Line #290:} else {
Line #291: $_SESSION[selWERjegy]= " ";
Line #292: unset($_SESSION[seL_nap]);
Line #293:}
Line #294:
Line #295:if (isset($_POST[status]))
Line #296:if ($_POST[status]<>"*") $_SESSION[selWERjegy].= " and statusz='$_POST[status]' ";
Line #297:
Line #298:if (isset($_POST[honap]))
Line #299:if ($_POST[honap]<>"*") $_SESSION[selWERhonap]= $_POST[honap];
Line #300:else $_SESSION[selWERhonap]= "*";
Line #301:
Line #302:echo("_SESSION[selWERjegy]:".$_SESSION[selWERjegy]."<br>");
Line #303:echo("_SESSION[selWERhonap]:".$_SESSION[selWERhonap]."<hr>");
Line #304:
Line #305:
Line #306:$_SESSION[selWERmusorSZERVEZO]="";
Line #307:$_SESSION[FEJmusorSZERVEZO]="";
Line #308:if (isset($_POST[szervezo]))
Line #309:if ($_POST[szervezo]<>"*") {
Line #310: $_SESSION[selWERmusorSZERVEZO].= " and szervezo='$_POST[szervezo]' ";
Line #311: $_SESSION[FEJmusorSZERVEZO]=$_POST[szervezo];
Line #312:} else $_SESSION[selWERmusorSZERVEZO]= " ";
Line #313:
Line #314:$_SESSION[selWERmusorJOG]="";
Line #315:$_SESSION[FEJmusorJOG]="";
Line #316:if (isset($_POST[rendez]))
Line #317:if ($_POST[rendez]<>"*") {
Line #318: $_SESSION[selWERmusorJOG].= " and cimkieg3='$_POST[rendez]' ";
Line #319: $_SESSION[FEJmusorJOG]=$_POST[rendez];
Line #320:} else $_SESSION[selWERmusorJOG]= " ";
Line #321:
Line #322:if (isset($_POST[honap]))
Line #323:if ($_POST[honap]<>"*") {
Line #324: $_SESSION[selWERmusorEVHOszervezo]=$_SESSION[selWERmusorSZERVEZO] . " and datum_evho='$_POST[honap]'";
Line #325: $_SESSION[selWERmusorEVHOjog]=$_SESSION[selWERmusorJOG]." and datum_evho='$_POST[honap]'";
Line #326:
Line #327: $_SESSION[selWERmusorSZERVEZO].=" and left(datum_fej,7)='$_POST[honap]'";
Line #328: $_SESSION[selWERmusorJOG].=" and left(datum_fej,7)='$_POST[honap]'";
Line #329:}
Line #330:
Line #331:
Line #332:echo("_SESSION[selWERmusorSZERVEZO]:".$_SESSION[selWERmusorSZERVEZO]."<br>");
Line #333:echo("_SESSION[selWERmusorJOG]:".$_SESSION[selWERmusorJOG]."<br>");
Line #334:
Line #335:echo("_SESSION[selWERmusorEVHOszervezo]:".$_SESSION[selWERmusorSZERVEZO]."<br>");
Line #336:echo("_SESSION[selWERmusorEVHOjog]:".$_SESSION[selWERmusorJOG]."<hr>");
Line #337:
Line #338:
Line #339:
Line #340://$disQ = "SELECT Distinct szervezo FROM qj_musor where szervezo<>'' $werMho order by szervezo" ;
Line #341://$disQ = "SELECT Distinct cimkieg3 FROM qj_musor where cimkieg3<>'' $werMho order by cimkieg3" ;
Line #342:
Line #343:// Napok : $sel1 $_POST[nap]
Line #344:// Bizom : $sel2 $_POST[bizomanyos]
Line #345:
Line #346:
Line #347:// Szerv : $sel5 $_POST[szervezo]
Line #348:// Jog : $sel6 $_POST[rendez]
Line #349:
Line #350:
Line #351://include("../_inc_BI/gvarlist.inc")
Line #352:
Line #353:?>