QC_napiADOselect.inc

---

Line #0:
Line #1:
Line #2:IF (isset($_POST[adoszam])) $_SESSION[QC_adoszam]=$_POST[adoszam];
Line #3:
Line #4:
Line #5:IF (!isset($_POST[adoszam]) )
Line #6:{ $_SESSION[QC_adoszam]="*";
Line #7:}
Line #8:
Line #9:IF ((!isset($_POST[adoszam]) or isset($_POST[submit] )) and !isset($_GET[adoszam]))
Line #10:{
Line #11: echo "<script>
Line #12:window.open('".$napiADOselect."?&adoszam=*','_self');
Line #13:</script>";
Line #14:}
Line #15:
Line #16:
Line #17:$disQ = "SELECT Distinct Adoszam,cimkieg3 FROM qj_musor where cimkieg3<>'' order by cimkieg3" ;
Line #18:
Line #19:
Line #20:
Line #21:onchange=this.form.submit(); return true name='adoszam'>";
Line #22:
Line #23:
Line #24:IF ($_SESSION[QC_adoszam]=="") $selS=" SELECTED "; else $selS="";;
Line #25:
Line #26:$si=0;
Line #27:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #28:
Line #29: ++$si;
Line #30: if ($disC[Adoszam]==$_POST[adoszam]) $sel="SELECTED"; else $sel="";
Line #31: $selA.="<option value='".$disC[Adoszam]."' $sel >".$disC[cimkieg3]."</option>";
Line #32:}
Line #33:
Line #34:$selA.="</SELECT>";
Line #35:
Line #36:echo "
Line #37:<form name='formF' method='POST' target='' action=''>
Line #38:
Line #39:$selA </form>
Line #40:";
Line #41:
Line #42://///////////////////////////////////////////////////////////////
Line #43:
Line #44:IF (isset($_SESSION[QC_adoszam]) and $_SESSION[QC_adoszam]=="*") $_SESSION[QC_adoWER]="";
Line #45:else {
Line #46:
Line #47:$adoSEL="";
Line #48:IF ($_SESSION[QC_adoszam]=="") $adoSEL=" and cimkieg3='' ";
Line #49:else $adoSEL=" and Adoszam='".$_SESSION[QC_adoszam]."' ";
Line #50:$adoSQL = "SELECT distinct datum_kod FROM qj_musor where future <>'*' $adoSEL";
Line #51:
Line #52:
Line #53:$nurREC=mysql_num_rows($adoREC);
Line #54://?// echo($adoSQL."<hr>".$nurREC."<hr>");
Line #55:
Line #56:$wer=" and (";
Line #57:$or= " ";
Line #58:$weri=0;
Line #59:
Line #60:while ( $adoSOR = mysql_fetch_array( $adoREC )){
Line #61: $nurADO=1;
Line #62: if (isset($_SESSION[L_nap])) {
Line #63: $adoX="SELECT wid FROM qj_jegy where datum_kod='".$adoSOR[datum_kod]."' and
Line #64: ($_SESSION[SQL_elad]) and left(logtime,10)='".
Line #65: $_SESSION[L_nap]."' limit 1";
Line #66:
Line #67:
Line #68: $nurADO=mysql_num_rows($adoY);
Line #69: }
Line #70: if ($nurADO>0) {
Line #71://?// echo($adoX."<hr>".$nurADO."<hr>");
Line #72: $wer.=$or." datum_kod='". $adoSOR[datum_kod]."' ";
Line #73: $or= " or ";
Line #74: ++$weri;
Line #75: }
Line #76:}
Line #77:
Line #78:$wer.=" )";
Line #79:
Line #80:
Line #81:
Line #82:}
Line #83:
Line #84:
Line #85:
Line #86:
Line #87: $_SESSION[QC_adoszam]="*";
Line #88: echo "<script>
Line #89: alert('Nincs adat!');
Line #90: window.open('".$napiADOselect."','_self');
Line #91: </script>";
Line #92: exit;
Line #93:}
Line #94:
Line #95://?//echo($adoSQL."<hr>".$_SESSION[QC_adoWER]."<hr>");
Line #96:
Line #97:/*
Line #98:if ($_SESSION[QC_adoszam]<>"*") {
Line #99: $_SESSION[L_adoszam]=$_SESSION[QC_adoszam];
Line #100:
Line #101:$keres = "SELECT * FROM qj_musor where future<>'*' $_SESSION[QC_adoWER]";
Line #102:
Line #103:$musor=mysql_fetch_array($meredmeny);
Line #104:
Line #105:if ($_SESSION[QC_adoszam]<>"") {
Line #106: $sajat=$musor[cimkieg3];
Line #107:
Line #108:} else
Line #109:
Line #110:
Line #111:}
Line #112:*/
Line #113:
Line #114:?>