Bi-Dir

QJ_musorPUBLIC_MK.inc

Line #0:<html>
Line #1:<head>
Line #2:<title>Qjegy2010</title>
Line #3:<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2">
Line #4:</head>
Line #5:<SCRIPT LANGUAGE="JavaScript" SRC="calendar.js"></SCRIPT>
Line #6:
Line #7:
Line #8:<SCRIPT LANGUAGE="JavaScript">
Line #9:
Line #10:
Line #11: function format(input){
Line #12: var num = input.value.replace(/\,/g,'');
Line #13: if(!isNaN(num)){
Line #14: }
Line #15: else{ alert('Nem numerikus!');
Line #16: input.value = input.value.substring(0,input.value.length-1);
Line #17: }
Line #18: }
Line #19:
Line #20:function uresCheck(mezo){
Line #21: if (mezo.value != "") return true;
Line #22: else{
Line #23:
Line #24: return false;
Line #25: }
Line #26:}
Line #27:
Line #28:function teszt(adat,minta){
Line #29: for (var i=0; i<adat.length; i++)
Line #30: if (minta.indexOf(adat.charAt(i)) == -1)
Line #31: return false;
Line #32:
Line #33: return true;
Line #34:}
Line #35:
Line #36:function tartalmaz(adat,minta){
Line #37: for (var i=0; i<adat.length; i++)
Line #38: if (minta.indexOf(adat.charAt(i)) != -1)
Line #39: return true;
Line #40: return false;
Line #41:}
Line #42:
Line #43:function telefonCheck(mezo){
Line #44: if (!uresCheck(mezo)) return false;
Line #45: if (!teszt(mezo.value,"1234567890()/- ") || !tartalmaz(mezo.value,"1234567890")){
Line #46:
Line #47: return false;
Line #48: }
Line #49: else{
Line #50:
Line #51: return true;
Line #52: }
Line #53:}
Line #54:
Line #55:
Line #56:function numerikusCheck(mezo){
Line #57: if (!uresCheck(mezo)) return false;
Line #58: if (!teszt(mezo.value,"1234567890")){
Line #59:
Line #60: return false;
Line #61: }
Line #62: else{
Line #63:
Line #64: return true;
Line #65: }
Line #66:}
Line #67:
Line #68:
Line #69:
Line #70:// -->
Line #71:</SCRIPT>
Line #72:
Line #73:
Line #74:<?
Line #75:
Line #76:$login=$_SESSION[login];
Line #77:if ($_SESSION[admin]=="ADMIN") $login="BI(c)";
Line #78:
Line #79:///*include('bilib.inc');
Line #80://BISQLcon();
Line #81:
Line #82://@mysql_query('SET CHARACTER SET latin2');
Line #83://@mysql_query("SET NAMES 'latin2'");
Line #84://*/
Line #85:
Line #86:$mentve="";
Line #87:
Line #88:if (isset($_POST[wid]))
Line #89:{
Line #90:
Line #91:if ($login=="BI(c)") {
Line #92:
Line #93:
Line #94: $datum_fej=$_POST[datum_fej];
Line #95:
Line #96:} else $datum_fej=$_POST[belep];
Line #97:
Line #98:$SQLarc = "UPDATE `qj_musor` SET `Adoszam`='$_POST[Adoszam]',
Line #99:`Szjszam`='$_POST[Szjszam]', `AFA_jel`='$_POST[AFA_jel]',
Line #100:`erkezesi`='$_POST[erkezesi]', `archiv`='$_POST[archiv]',
Line #101: `cimkieg1`='$_POST[cimkieg1]',
Line #102: `cimkieg2`='$_POST[cimkieg2]',
Line #103: `cimkieg3`='$_POST[cimkieg3]',
Line #104: `JeBe`='$_POST[napi]',
Line #105: `arnev`='$_POST[arnev]',
Line #106: `alapar1`='$_POST[alapar1]',
Line #107: `alapar2`='$_POST[alapar2]',
Line #108: `alapar3`='$_POST[alapar3]',
Line #109: `alapar4`='$_POST[alapar4]',
Line #110: `alapar5`='$_POST[alapar5]',
Line #111: `alapar6`='$_POST[alapar6]',
Line #112: `alapar7`='$_POST[alapar7]',
Line #113: `alapar8`='$_POST[alapar8]',
Line #114: `alapar9`='$_POST[alapar9]',
Line #115: `alapar0`='$_POST[alapar0]',
Line #116: `sum_keszlet`='$_POST[sum_keszlet]',
Line #117: `web`='$_POST[web]',
Line #118: `datum`='$_POST[datum]',
Line #119: `datum_fej`='$datum_fej',
Line #120:`datum_evho`='$_POST[datum_evho]',
Line #121: `cim`='$_POST[cim]'
Line #122: where `wid`='".$_GET[wjid]."'; ";
Line #123:} else {
Line #124:$datum_fej=$_POST[belep];
Line #125:$SQLarc = "UPDATE `qj_musor` SET `Adoszam`='$_POST[Adoszam]',
Line #126:`Szjszam`='$_POST[Szjszam]', `AFA_jel`='$_POST[AFA_jel]',
Line #127: `archiv`='$_POST[archiv]',
Line #128: `cimkieg1`='$_POST[cimkieg1]',
Line #129: `cimkieg2`='$_POST[cimkieg2]',
Line #130: `cimkieg3`='$_POST[cimkieg3]',
Line #131: `sum_keszlet`='$_POST[sum_keszlet]',
Line #132: `web`='$_POST[web]',
Line #133: `datum`='$_POST[datum]',
Line #134: `datum_fej`='$datum_fej',
Line #135:`datum_evho`='$_POST[datum_evho]',
Line #136: `cim`='$_POST[cim]'
Line #137: where `wid`='".$_GET[wjid]."'; ";
Line #138:}
Line #139:
Line #140:// echo($SQLarc."<hr>");
Line #141:
Line #142:
Line #143://echo("<font color=blue>Adatok mentve !!!</font>");
Line #144:
Line #145:$ido=date("H:i:s");
Line #146:$mentve="<font color=blue>Adatok mentve !!! $ido </font><br>";
Line #147:
Line #148:}
Line #149:
Line #150:
Line #151:$sel = "SELECT * FROM qj_musor where wid='".$_GET[wjid]."'" ;
Line #152:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #153:$sor = mysql_fetch_array( $sql);
Line #154:
Line #155:$wjid=$sor[wid];
Line #156:$Adoszam=$sor[Adoszam];
Line #157:$Szjszam=$sor[Szjszam];
Line #158:$AFA_jel=$sor[AFA_jel];
Line #159:$web=$sor[web];
Line #160:$napi=$sor[JeBe];
Line #161:$erkezesi=$sor[erkezesi];
Line #162:$archiv=$sor[archiv];
Line #163:
Line #164:$belep=$sor[datum_fej];
Line #165:
Line #166:$hely_kod=$sor[hely_kod];
Line #167:
Line #168:$datum=$sor[datum];
Line #169:$datum_fej=$sor[datum_fej];
Line #170:$datum_evho=$sor[datum_evho];
Line #171:
Line #172:
Line #173:if ($sor[datum_kod]=="")
Line #174:{
Line #175:$SQLarc = "UPDATE `qj_musor` SET
Line #176: `datum_kod`='".$sor[usr_kod]."D".substr("00000".$wjid,-5)."'
Line #177: where `wid`='".$wjid."'";
Line #178:
Line #179:
Line #180:}
Line #181:
Line #182:$cim=$sor[cim];
Line #183:
Line #184:$cimkieg1=$sor[cimkieg1];
Line #185:$cimkieg2=$sor[cimkieg2];
Line #186:$cimkieg3=$sor[cimkieg3];
Line #187:
Line #188:$alapar1=$sor[alapar1];
Line #189:$alapar2=$sor[alapar2];
Line #190:$alapar3=$sor[alapar3];
Line #191:$alapar4=$sor[alapar4];
Line #192:
Line #193:$alapar5=$sor[alapar5];
Line #194:$alapar6=$sor[alapar6];
Line #195:$alapar7=$sor[alapar7];
Line #196:$alapar8=$sor[alapar8];
Line #197:
Line #198:$alapar9=$sor[alapar9];
Line #199:$alapar0=$sor[alapar0];
Line #200:$arnev=$sor[arnev];
Line #201:$sum_keszlet=$sor[sum_keszlet];
Line #202:
Line #203:if (!isset($_POST[helyszin])) $_POST[helyszin]=$hely_kod;
Line #204:
Line #205:$disQ = "SELECT * FROM qj_sql where szoveg='Arsav' order by widarc" ;
Line #206:
Line #207:
Line #208:
Line #209:while ( $disC = mysql_fetch_array( $disR )) {
Line #210: $ARtitle[$disC[widarc]]=$disC[sql_memo];
Line #211:}
Line #212:
Line #213:
Line #214:/*$disQ = "SELECT helyszin,hely_kod FROM qj_szinpad order by hely_kod" ;
Line #215:
Line #216:
Line #217:
Line #218:
Line #219:
Line #220:$helyszin="";
Line #221:
Line #222:while ( $disC = mysql_fetch_array( $disR )) {
Line #223: if ($disC[hely_kod]==$_POST[helyszin])
Line #224: {$helyszin=$disC[helyszin]; $sel="SELECTED";}
Line #225: else $sel="";
Line #226:
Line #227: if (trim($disC[helyszin])<>"")
Line #228: $sel1.="<option value='".$disC[hely_kod]."' $sel >".$disC[hely_kod]." ".$disC[helyszin]."</option>";
Line #229:}
Line #230:$sel1.="</SELECT>";
Line #231:*/
Line #232:
Line #233:$sel1="";
Line #234:
Line #235:
Line #236:// wid usr_kod szoveg archiv future erkezesi JeBe FormaJel web jegy_col jegy_row printer_offset berlet_mid Adoszam Szjszam AFA_jel AFA logo_url sum_keszlet akt_keszlet start_datum end_datum datum datum_kod berlet_kod datum_url datum_fej cim cimkieg1 cimkieg2 cimkieg3 cim_kod cim_url helyszin hely_kod arnev arkod alapar1 alapar2 alapar3 alapar4 alapar5 alapar6 alapar7 alapar8 hely_url kep_url kep_with kep_height
Line #237:
Line #238:if ($_SESSION[login]=="BI(c)")
Line #239: $ie = '<br><a target=adatframe href="QJ_musorEDIT.php?&wjid='.$wjid.
Line #240: '"><img src="../_Screen/edit.png" border=0><font color=red size=+2>'.$wjid.'</font></a>';
Line #241:else $ie="";
Line #242:
Line #243:
Line #244:$datum_kod=$sor[datum_kod];
Line #245:$disY = "SELECT * FROM qj_ear where datum_kod='$datum_kod' order by qj_arkod,szoveg" ;
Line #246:
Line #247://echo($disQ."<hr>");
Line #248:
Line #249:$sel3="";
Line #250:$br="";
Line #251:$ari=0;
Line #252:
Line #253:
Line #254:$_SESSION[_Q_refress]="QJ_musorPUBLIC.php?&wjid=$wjid";
Line #255:$_SESSION[_Q_target]="adatframe";
Line #256:
Line #257:
Line #258:while ( $disD = mysql_fetch_array( $disZ ) ) {
Line #259:
Line #260:
Line #261:if ($login=="BI(c)")
Line #262:$sel3.="<tr bgcolor=PaleGoldenRod>".
Line #263:"<td align=left ><table border=0 width=100%>
Line #264:<td align=left >
Line #265:<a target=infoframe href=_Q_sqlRECopy.php?&wjid=$disD[wid]&tabla=qj_ear&view=qj_arnev;qj_arkod;qj_ear1;&update=qj_arnev;qj_arkod;qj_ear1;&datum_kod=$datum_kod>
Line #266:
Line #267:<td align=right>
Line #268:($disD[wid])   
Line #269:<a target=infoframe href=_Q_sqlRECopy.php?&wjid=$disD[wid]&delete=Yes&tabla=qj_ear&view=qj_arnev;qj_arkod;qj_ear1;&datum_kod=$datum_kod>
Line #270:
Line #271:</table></td>
Line #272:<td align=right > <b>".$disD[qj_arnev]."</b>
Line #273:</td>";
Line #274:else
Line #275:$sel3.="<tr bgcolor=PaleGoldenRod>".
Line #276:"<td align=right ></td><td align=right > <b>".$disD[qj_arnev]."</b></td>";
Line #277:++$ari;
Line #278:
Line #279:if ($disD[qj_ear1]>0) $sel3.=" <td align=right ><b>".$disD[qj_ear1]."</b></td>";
Line #280://if ($disC[qj_ear2]>0) $sel3.=" <td align=right ><b>".$disC[qj_ear2]."</b></td>";
Line #281://if ($disC[qj_ear3]>0) $sel3.=" <td align=right ><b>".$disC[qj_ear3]."</b></td>";
Line #282://if ($disC[qj_ear4]>0) $sel3.=" <td align=right ><b>".$disC[qj_ear4]."</b></td>";
Line #283:$sel3.="</tr>";
Line #284:}
Line #285:
Line #286:
Line #287:if ($ari==0)
Line #288:$sel3="<tr bgcolor=PaleGoldenRod>".
Line #289:"<td align=right >
Line #290:<a target=infoframe href=_Q_sqlRECopy.php?&wjid=$wjid&tabla=qj_musor&view=arnev;alapar1;&update=arnev;alapar1;&datum_kod=$datum_kod>
Line #291:
Line #292:<td align=right ><b>".$alapar1."</b></td></tr>";
Line #293:
Line #294:$fej="<table align=center width=100%><tr><td><font size=+1 color=blue>".$sor[helyszin].
Line #295:"</td><td><font size=+1><i>".$sor[datum].
Line #296:"</i>  <br><font size=+3>".
Line #297:$sor[cim]."</td><td align=right><font size=+1 color=red>   (".$sor[datum_kod].
Line #298:")</font >".$ie."</td></tr></table>";
Line #299: echo($fej);
Line #300:
Line #301:?>
Line #302:
Line #303:
Line #304:<form name=myForm
Line #305:
Line #306:>
Line #307:
Line #308:<table border=1 align=center bgcolor='aqua'>
Line #309:
Line #310:<tr>
Line #311:<td align=left colspan=4>
Line #312:<?
Line #313:if ($login=="BI(c)") {
Line #314:?>
Line #315:
Line #316:
Line #317:
Line #318:
Line #319:
Line #320:
Line #321:
Line #322:
Line #323:
Line #324:
Line #325:
Line #326:<? if ($napi<>'Napi') echo(' CHECKED '); ?>
Line #327:>FIX 
Line #328:
Line #329:
Line #330:<? if ($napi=='Napi') echo(' CHECKED '); ?>
Line #331:>Napi 
Line #332:
Line #333:
Line #334:<? if ($erkezesi<>'Y') echo(' CHECKED '); ?>
Line #335:
Line #336:
Line #337:
Line #338:<? if ($erkezesi=='Y') echo(' CHECKED '); ?>
Line #339:
Line #340:<?
Line #341:}
Line #342:?>
Line #343:
Line #344:
Line #345:<? if ($archiv<>'*') echo(' CHECKED '); ?>
Line #346:
Line #347:
Line #348:
Line #349:<? if ($archiv=='*') echo(' CHECKED '); ?>
Line #350:>Rejtett 
Line #351:
Line #352:
Line #353:
Line #354:
Line #355:
Line #356:<? if ($web<>'web') echo(' CHECKED '); ?>
Line #357:>INTRA 
Line #358:
Line #359:
Line #360:<? if ($web=='web') echo(' CHECKED '); ?>
Line #361:>WEB 
Line #362:
Line #363:
Line #364:</td>
Line #365:
Line #366:</tr>
Line #367:
Line #368:
Line #369:<tr>
Line #370:<td colspan=3 align=left>
Line #371:<? echo($mentve);?>
Line #372:
Line #373:
Line #374:
Line #375:
Line #376:</td>
Line #377:<?
Line #378:
Line #379:?>
Line #380:
Line #381:<td align=center>
Line #382:
Line #383:</td>
Line #384:<?
Line #385:}
Line #386:?>
Line #387:
Line #388:</tr>
Line #389:
Line #390:<?
Line #391:echo($sel3);
Line #392:
Line #393:if ($_SESSION[login]=="BI(c)") {
Line #394:
Line #395:?>
Line #396:
Line #397:<tr>
Line #398:<td colspan=3 align=left >
Line #399:
Line #400:
Line #401:
Line #402:
Line #403:
Line #404:
Line #405:
Line #406:<td>
Line #407:
Line #408:
Line #409:
Line #410:
Line #411:</td>
Line #412:</tr>
Line #413:
Line #414:
Line #415:<tr>
Line #416:<td colspan=3 align=left >
Line #417:
Line #418:
Line #419:
Line #420:
Line #421:
Line #422:
Line #423:</td>
Line #424:<td>
Line #425:
Line #426:</td>
Line #427:</tr>
Line #428:<?
Line #429:}
Line #430:?>
Line #431:<tr>
Line #432:
Line #433:
Line #434:
Line #435:
Line #436:<input type='TEXT' value='<? echo($cim);?>'
Line #437:size=100 name='cim' ><br>
Line #438:<input type='TEXT' value='<? echo($cimkieg1);?>'
Line #439:size=100 name='cimkieg1' ><br>
Line #440:<input type='TEXT' value='<? echo($cimkieg2);?>'
Line #441:size=100 name='cimkieg2' >
Line #442:</td>
Line #443:
Line #444:<td>
Line #445:
Line #446:
Line #447:
Line #448: <br>--->
Line #449:
Line #450: name='sum_keszlet' >
Line #451:</td></tr>
Line #452:
Line #453:
Line #454:<tr>
Line #455:
Line #456:<input type='TEXT' value='<? echo($Adoszam);?>' name='Adoszam'
Line #457: >
Line #458:<input type='hidden' value='<? echo($wid);?>' name='wid'>
Line #459:</td>
Line #460:
Line #461:
Line #462:<input type='TEXT' value='<? echo($Szjszam);?>' name='Szjszam'
Line #463: >
Line #464:</td>
Line #465:
Line #466:
Line #467:
Line #468:</td>
Line #469:
Line #470:
Line #471:<input type='TEXT' size=8 value='<? echo($datum_evho);?>' name='datum_evho'>
Line #472:</td>
Line #473:
Line #474:</tr>
Line #475:<tr>
Line #476:
Line #477:
Line #478:<input type='TEXT' value='<? echo($cimkieg3);?>'
Line #479:
Line #480:
Line #481:
Line #482:</td>
Line #483:
Line #484:</tr>
Line #485:
Line #486:
Line #487:
Line #488:
Line #489:</table></form>
Line #490:
Line #491:
Line #492:
Line #493:
Line #494:<?
Line #495:
Line #496:echo($e);
Line #497:
Line #498://include("QJ_varlist.php");
Line #499:
Line #500:?>