QJ_musorCREATE.inc

---

Line #0:<?php
Line #1:
Line #2:
Line #3:
Line #4:IF (isset($_POST[berlet_nev])) $_SESSION[berlet_nev]=$_POST[berlet_nev];
Line #5:IF (isset($_SESSION[berlet_nev])) $berlet_nev=$_SESSION[berlet_nev];
Line #6:
Line #7:IF (isset($_POST[datumjel])) $_SESSION[datumjel]=$_POST[datumjel];
Line #8:IF (isset($_SESSION[datumjel])) $datumjel=$_SESSION[datumjel];
Line #9:IF (isset($_POST[datum])) $_SESSION[datum]=$_POST[datum];
Line #10:IF (isset($_SESSION[datum])) $datum=$_SESSION[datum];
Line #11:
Line #12:
Line #13:$selE.="</SELECT>";
Line #14:
Line #15:
Line #16:
Line #17:
Line #18:$sel2="<SELECT TITLE='berlet_nev'
Line #19:onchange=this.form.submit(); return true name='berlet_nev'>";
Line #20:
Line #21:
Line #22:
Line #23:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #24:if ($disC[berlet_nev]==$_POST[berlet_nev]) $sel="SELECTED"; else $sel="";
Line #25:$sel2.="<option value='".$disC[berlet_nev]."' $sel >".$disC[berlet_nev]."</option>";
Line #26:}
Line #27:
Line #28:$sel2.="</SELECT>";
Line #29:
Line #30:
Line #31:
Line #32:
Line #33:?>
Line #34:
Line #35:<FORM name=cimform target=sframe action='QJ_musorCREATE.php' method='post'>
Line #36:
Line #37:<? echo($sel2); ?> &nbsp; &nbsp;
Line #38:<!---
Line #39:<br>
Line #40:<input type='text' value='<?php print $datumjel; ?>' name='datumjel' size=50>
Line #41:<input type='text' value='<?php print $datum; ?>' name='datum'>
Line #42:--->
Line #43:
Line #44:</form>
Line #45:
Line #46:<?
Line #47:
Line #48:
Line #49:
Line #50:
Line #51:
Line #52:
Line #53:
Line #54:
Line #55:
Line #56:IF (isset($_SESSION[berlet_nev])) { $wer=" where berlet_nev='".$_SESSION[berlet_nev]."'";}
Line #57:
Line #58:IF ($_SESSION[berlet_nev]=="") {
Line #59:IF ($_SESSION[login]=="BI(c)")
Line #60: $wer=" ";
Line #61:else
Line #62: $wer=" where future<>'*' ";
Line #63: }
Line #64:
Line #65:$keres = "SELECT * FROM qj_musor $wer $extra ORDER BY datum_fej";
Line #66:
Line #67:///////////////////
Line #68://BI_alert($keres);
Line #69:///////////////////
Line #70://?//echo($keres."<br>");
Line #71:
Line #72:
Line #73:$nur=mysql_num_rows($eredmeny);
Line #74:
Line #75:echo('<table border=1 STYLE="{color : black; font-size: 12px;}" ALIGN="center">');
Line #76:
Line #77:$berlet_kod="*";
Line #78:$li=0;
Line #79:$BHoszto=0;
Line #80:while ( $egy_sor = mysql_fetch_array( $eredmeny )) {
Line #81:
Line #82:$h=$egy_sor[helyszin].'<br>&nbsp;'.$egy_sor[cim].'<br>&nbsp;'.$egy_sor[datum];
Line #83:$q=$egy_sor[datum_kod];
Line #84:
Line #85:$berlet_kod=$egy_sor[berlet_Azonosito];
Line #86:
Line #87:$datumjel=str_replace(" ","~",$datumjel);
Line #88:
Line #89:
Line #90:$rel_rejt="<br><a target=infoframe href='QJ_sqlJEGY.php?&parancs=// Update qj_musor set berlet_nev=~".
Line #91:
Line #92:else $rel_rejt="";
Line #93:
Line #94:
Line #95:
Line #96: target=adatframe ><IMG width=20 height=20
Line #97: SRC='../_Screen/datum.gif' border=0></a>";
Line #98:
Line #99:
Line #100:<IMG width=20 height=20
Line #101:SRC='../_Screen/people.bmp' border=0></a>";
Line #102:$bref="";
Line #103:
Line #104:$cref="<a href=QJ_raportNEW.php?&musor_kod=$egy_sor[datum_kod] title='Raport lap' target=adatframe>
Line #105:<IMG width=20 height=20
Line #106:SRC='../_Screen/transfer.gif' border=0></a>";
Line #107:
Line #108:
Line #109:<IMG width=20 height=20
Line #110:SRC='../_Screen/tsticky.gif' border=0></a>";
Line #111:
Line #112:
Line #113:
Line #114:
Line #115:
Line #116:$c="QJ_helyrajz.php?&musor_kod=".$egy_sor[datum_kod];
Line #117:$atf="QJ_musorPUBLIC.php?&wjid=".$egy_sor[wid];
Line #118:if ($egy_sor[JeBe]=="Jegy" and $egy_sor[last_index]<2 )
Line #119:$OKEZ="<a href=QJ_musorSTART.php?&wjid=$egy_sor[wid]&BHoszto=$BHoszto&berlet_kod=$berlet_kod&datum=$datum&datumjel=$datumjel TARGET='adatframe'>$yy</a>";
Line #120:else { $OKEZ=""; }
Line #121:
Line #122:$OKEZ.="<font color=red>".$egy_sor[JeBe]."<br><font color=blue>".$egy_sor[FormaJel]."</font>";
Line #123://$bh="QJ_SIforgat.php?&musor_kod=".$egy_sor[datum_kod];
Line #124:$bh=$bhurl.$egy_sor[datum_kod];
Line #125:
Line #126:$Jkeres = "SELECT * FROM qj_jegy where datum_kod='$egy_sor[datum_kod]' and archiv='-' and statusz<>'' and left(statusz,2)<>'St' and left(statusz,2)<>'El'";
Line #127:
Line #128:$nur=mysql_num_rows($Jeredmeny);
Line #129:
Line #130:
Line #131:
Line #132:if ($egy_sor[archiv]=="*") $rejtett="<br><font color=blue>REJTETT</font>"; else $rejtett="";
Line #133:
Line #134:
Line #135:
Line #136:href='QJ_vevoLIST.php?&musor_kod=$egy_sor[datum_kod]' >
Line #137:
Line #138:
Line #139:
Line #140:href='QJ_vevoABClist.php?&musor_kod=$egy_sor[datum_kod]' >
Line #141:
Line #142:
Line #143:
Line #144:if ($bimod=="Y")
Line #145:
Line #146:echo "<tr>
Line #147:<td>$OKEZ<br>
Line #148:<td><a href=$atf TARGET='adatframe'>$qq</a><br>
Line #149:<td><a href=$c TARGET='adatframe'>$ww</a><br>
Line #150:<td><b>$egy_sor[datum]</b>$future</td>
Line #151:<td><font color=red><b>$egy_sor[cim] $rel_rejt $rejtett</b></td>
Line #152:<td align=left>$egy_sor[helyszin] $erkezesi</td>
Line #153:<td align=left><font color=red size=+2><b>$egy_sor[last_index]</b></td>
Line #154:<td align=left><font color=blue><b>$egy_sor[berlet_kod]<br><font size=+2>$nur</font></b></td>
Line #155:<td align=left><a target=infoframe href=QJ_helyrajz.php?&musor_kod=".$egy_sor[berlet_Azonosito].">$egy_sor[berlet_Azonosito]</a></td>
Line #156:<td><a href=$bh TARGET='adatframe'>$zz</a><br>
Line #157:<td align=left><b>$egy_sor[datum_kod]</b><br>
Line #158:$cref
Line #159:$aref
Line #160:$bref
Line #161:$dref
Line #162:$xlsX
Line #163:$xlsA
Line #164:</td>
Line #165:" ;
Line #166:else
Line #167:echo "<tr>
Line #168:<td><a href=$atf TARGET='adatframe'>$qq</a><br>
Line #169:<td><a href=$c TARGET='adatframe'>$ww</a><br>
Line #170:<td><b>$egy_sor[datum]</b><br></td>
Line #171:<td><font color=red><b>$egy_sor[cim]</b></td>
Line #172:<td align=left>$egy_sor[helyszin] $erkezesi</td>
Line #173:<td align=left><b>$egy_sor[datum_kod]</b><br>
Line #174:$cref
Line #175:$aref
Line #176:$bref
Line #177:$dref
Line #178:$xlsX
Line #179:$xlsA
Line #180:</td>
Line #181:" ;
Line #182:
Line #183:
Line #184:echo"</tr>";
Line #185:
Line #186:
Line #187:
Line #188:}
Line #189:
Line #190:echo('</table>');
Line #191:
Line #192:
Line #193:include("../_inc_BI/BI_Copyright.php");
Line #194:
Line #195:include("QJ_stop.php")
Line #196:
Line #197:?>
Line #198:
Line #199:
Line #200:
Line #201:<body background='hatadat.jpg' CELLSPACING='0' CELLPADDING='0' >
Line #202:</body>