Bi-Dir

QJ_musorPUBLIC.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:///*include('bilib.inc');
Line #77://BISQLcon();
Line #78:
Line #79://@mysql_query('SET CHARACTER SET latin2');
Line #80://@mysql_query("SET NAMES 'latin2'");
Line #81://*/
Line #82:
Line #83:$mentve="";
Line #84:
Line #85:if (isset($_POST[wid]))
Line #86:{
Line #87:
Line #88://if (isset($_POST[copy]))
Line #89://echo("COPY...");
Line #90:
Line #91://$sel = "SELECT * FROM qj_szinpad where hely_kod='".$_POST[helyszin]."'" ;
Line #92://$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #93://$sor = mysql_fetch_array( $sql);
Line #94:
Line #95:
Line #96:
Line #97: //wid usr_kod szoveg archiv future erkezesi JeBe FormaJel 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_Azonosito 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_heig
Line #98:
Line #99:if ($_POST[helyszin]<>'*' and isset($_POST[helyszin])) $helyupd="
Line #100:`hely_kod`='$_POST[helyszin]',
Line #101:`helyszin`='$sor[helyszin]',";
Line #102:else $helyupd='';
Line #103:
Line #104:
Line #105: $datum_fej=$_POST[datum_fej];
Line #106:
Line #107:} else $datum_fej=$_POST[belep];
Line #108:
Line #109:if (isset($_POST[szervezo]) and substr($_SESSION[Qusr_kod],0,2)=="EF" )
Line #110:$szervezo="`szervezo`='$_POST[szervezo]',"; else $szervezo="";
Line #111:
Line #112:$datum_evho=substr($datum_fej,0,7);
Line #113:
Line #114://echo ($szervezo."/".$_POST[Qdef_user]."<hr>");
Line #115:
Line #116://if ($_SESSION[login]=="BI(c)")
Line #117:$SQLarc = "UPDATE `qj_musor` SET `Adoszam`='$_POST[Adoszam]',
Line #118:`Szjszam`='$_POST[Szjszam]', `AFA_jel`='$_POST[AFA_jel]',
Line #119:`erkezesi`='$_POST[erkezesi]', `archiv`='$_POST[archiv]',
Line #120: `cimkieg1`='$_POST[cimkieg1]',
Line #121: `cimkieg2`='$_POST[cimkieg2]',
Line #122: `cimkieg3`='$_POST[cimkieg3]',
Line #123: $helyupd $szervezo
Line #124: `arnev`='$_POST[arnev]',
Line #125: `alapar1`='$_POST[alapar1]',
Line #126: `alapar2`='$_POST[alapar2]',
Line #127: `alapar3`='$_POST[alapar3]',
Line #128: `alapar4`='$_POST[alapar4]',
Line #129: `alapar5`='$_POST[alapar5]',
Line #130: `alapar6`='$_POST[alapar6]',
Line #131: `alapar7`='$_POST[alapar7]',
Line #132: `alapar8`='$_POST[alapar8]',
Line #133: `alapar9`='$_POST[alapar9]',
Line #134: `alapar0`='$_POST[alapar0]',
Line #135: `sum_keszlet`='$_POST[sum_keszlet]',
Line #136: `web`='$_POST[web]',
Line #137: `datum`='$_POST[datum]',
Line #138: `datum_fej`='$datum_fej',
Line #139: `datum_evho`='$datum_evho',
Line #140: `cim`='$_POST[cim]'
Line #141: where `wid`='".$_GET[wjid]."'; ";
Line #142://else
Line #143:if ($_SESSION[login]=="???")
Line #144:$SQLarc = "UPDATE `qj_musor` SET `Adoszam`='$_POST[Adoszam]',
Line #145:`Szjszam`='$_POST[Szjszam]', `AFA_jel`='$_POST[AFA_jel]',
Line #146:`erkezesi`='$_POST[erkezesi]', `archiv`='$_POST[archiv]',
Line #147: `cimkieg1`='$_POST[cimkieg1]',
Line #148: `cimkieg2`='$_POST[cimkieg2]',
Line #149: `cimkieg3`='$_POST[cimkieg3]',
Line #150: `sum_keszlet`='$_POST[sum_keszlet]',
Line #151: `arnev`='$_POST[arnev]',
Line #152: `alapar1`='$_POST[alapar1]',
Line #153: `alapar2`='$_POST[alapar2]',
Line #154: `alapar3`='$_POST[alapar3]',
Line #155: `alapar4`='$_POST[alapar4]',
Line #156: `alapar5`='$_POST[alapar5]',
Line #157: `alapar6`='$_POST[alapar6]',
Line #158: `alapar7`='$_POST[alapar7]',
Line #159: `alapar8`='$_POST[alapar8]',
Line #160: `alapar9`='$_POST[alapar9]',
Line #161: `alapar0`='$_POST[alapar0]',
Line #162: `web`='$_POST[web]',
Line #163: `datum`='$_POST[datum]',
Line #164: `datum_fej`='$datum_fej',
Line #165: `cim`='$_POST[cim]'
Line #166: where `wid`='".$_GET[wjid]."'; ";
Line #167:
Line #168:// echo($SQLarc."<hr>");
Line #169:
Line #170:
Line #171://echo("<font color=blue>Adatok mentve !!!</font>");
Line #172:
Line #173:$ido=date("H:i:s");
Line #174:$mentve="<font color=blue>Adatok mentve !!! $ido </font><br>";
Line #175:
Line #176:}
Line #177:
Line #178:IF (isset($_POST[szervezo])) $_SESSION[szervezo]=$_POST[szervezo];
Line #179:
Line #180:$sel = "SELECT * FROM qj_musor where wid='".$_GET[wjid]."'" ;
Line #181:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #182:$sor = mysql_fetch_array( $sql);
Line #183:
Line #184:$wjid=$sor[wid];
Line #185:$Adoszam=$sor[Adoszam];
Line #186:$Szjszam=$sor[Szjszam];
Line #187:$AFA_jel=$sor[AFA_jel];
Line #188:$web=$sor[web];
Line #189:
Line #190:$szervezo=$sor[szervezo];
Line #191:
Line #192:if (!isset($_POST[szervezo])) $_POST[szervezo]=$szervezo;
Line #193:
Line #194:$keres="SELECT * FROM qj_login where archiv='#SZERVEZ#' ORDER BY nev";
Line #195:
Line #196:$nurS=mysql_num_rows($eredmeny);
Line #197:
Line #198://?//onchange=this.form.submit(); return true name='szervezo'>";
Line #199:
Line #200:
Line #201:onchange= return true name='szervezo'>";
Line #202:
Line #203:
Line #204:while ( $egy_sor = mysql_fetch_array( $eredmeny ) )
Line #205:{
Line #206:if (strtolower($_POST[szervezo])==strtolower($egy_sor[email_kod])) $sel=" SELECTED "; else $sel="";
Line #207:$szer.="<option value='".$egy_sor[email_kod]."' $sel>".$egy_sor[nev]."</option>";
Line #208:}
Line #209:$szer.="</SELECT>";
Line #210:
Line #211:if ($nurS==0) $szer="";
Line #212:
Line #213:
Line #214:$erkezesi=$sor[erkezesi];
Line #215:$archiv=$sor[archiv];
Line #216:
Line #217:$belep=$sor[datum_fej];
Line #218:
Line #219:$hely_kod=$sor[hely_kod];
Line #220:
Line #221:$datum=$sor[datum];
Line #222:$datum_fej=$sor[datum_fej];
Line #223:
Line #224:if ($sor[datum_kod]=="")
Line #225:{
Line #226:$SQLarc = "UPDATE `qj_musor` SET
Line #227: `datum_kod`='".$sor[usr_kod]."D".substr("00000".$wjid,-5)."'
Line #228: where `wid`='".$wjid."'";
Line #229:
Line #230:
Line #231:}
Line #232:
Line #233:$cim=$sor[cim];
Line #234:
Line #235:$cimkieg1=$sor[cimkieg1];
Line #236:$cimkieg2=$sor[cimkieg2];
Line #237:$cimkieg3=$sor[cimkieg3];
Line #238:
Line #239:$alapar1=$sor[alapar1];
Line #240:$alapar2=$sor[alapar2];
Line #241:$alapar3=$sor[alapar3];
Line #242:$alapar4=$sor[alapar4];
Line #243:
Line #244:$alapar5=$sor[alapar5];
Line #245:$alapar6=$sor[alapar6];
Line #246:$alapar7=$sor[alapar7];
Line #247:$alapar8=$sor[alapar8];
Line #248:
Line #249:$alapar9=$sor[alapar9];
Line #250:$alapar0=$sor[alapar0];
Line #251:$arnev=$sor[arnev];
Line #252:$sum_keszlet=$sor[sum_keszlet];
Line #253:
Line #254:if (!isset($_POST[helyszin])) $_POST[helyszin]=$hely_kod;
Line #255:
Line #256:$disQ = "SELECT * FROM qj_sql where szoveg='Arsav' order by widarc" ;
Line #257:
Line #258:
Line #259:
Line #260:while ( $disC = mysql_fetch_array( $disR )) {
Line #261: $ARtitle[$disC[widarc]]=$disC[sql_memo];
Line #262:}
Line #263:
Line #264:
Line #265:/*$disQ = "SELECT helyszin,hely_kod FROM qj_szinpad order by hely_kod" ;
Line #266:
Line #267:
Line #268:
Line #269:
Line #270:
Line #271:$helyszin="";
Line #272:
Line #273:while ( $disC = mysql_fetch_array( $disR )) {
Line #274: if ($disC[hely_kod]==$_POST[helyszin])
Line #275: {$helyszin=$disC[helyszin]; $sel="SELECTED";}
Line #276: else $sel="";
Line #277:
Line #278: if (trim($disC[helyszin])<>"")
Line #279: $sel1.="<option value='".$disC[hely_kod]."' $sel >".$disC[hely_kod]." ".$disC[helyszin]."</option>";
Line #280:}
Line #281:$sel1.="</SELECT>";
Line #282:*/
Line #283:
Line #284:$sel1="";
Line #285:
Line #286:
Line #287:// 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 #288:
Line #289:if ($_SESSION[login]=="BI(c)")
Line #290: $ie = '<a target=adatframe href="QJ_musorEDIT.php?&wjid='.$wjid.$evad.
Line #291: '"><img src="../_Screen/edit.png" border=0><font color=red size=+3>'.$wjid.'</font></a>';
Line #292:else $ie="";
Line #293:
Line #294:$fej="<font size=+1 ><i>".$sor[datum]." </i>".$sor[helyszin]."  ".$ie.
Line #295:"<font size=+1 color=red>   (".$sor[datum_kod].")<br><font size=+2>".$sor[cim]."</font >"
Line #296:?>
Line #297:
Line #298:<form name=myForm
Line #299:
Line #300:>
Line #301:
Line #302:<table border=1 align=center bgcolor='gold'>
Line #303:
Line #304:
Line #305:<? echo($fej); ?>
Line #306:<tr>
Line #307:<td align=left colspan=4>
Line #308:<?
Line #309:if ($_SESSION[login]=="BI(c)") {
Line #310:?>
Line #311:
Line #312:
Line #313:
Line #314:
Line #315:
Line #316:
Line #317:
Line #318:
Line #319:<?
Line #320:}
Line #321:?>
Line #322:
Line #323:
Line #324:<? if ($erkezesi<>'Y') echo(' CHECKED '); ?>
Line #325:
Line #326:
Line #327:
Line #328:<? if ($erkezesi=='Y') echo(' CHECKED '); ?>
Line #329:
Line #330:
Line #331:
Line #332:<? if ($archiv<>'*') echo(' CHECKED '); ?>
Line #333:
Line #334:
Line #335:
Line #336:<? if ($archiv=='*') echo(' CHECKED '); ?>
Line #337:
Line #338:
Line #339:
Line #340:
Line #341:
Line #342:
Line #343:<? if ($web<>'web') echo(' CHECKED '); ?>
Line #344:>INTRA 
Line #345:
Line #346:
Line #347:<? if ($web=='web') echo(' CHECKED '); ?>
Line #348:>WEB 
Line #349:
Line #350:
Line #351:
Line #352:</td>
Line #353:
Line #354:</tr>
Line #355:
Line #356:
Line #357:<tr>
Line #358:<td colspan=3 align=left>
Line #359:<? echo($mentve);?>
Line #360:
Line #361:
Line #362:
Line #363:
Line #364:</td>
Line #365:<?
Line #366:
Line #367:?>
Line #368:
Line #369:<td align=center>
Line #370:
Line #371:</td>
Line #372:<?
Line #373:}
Line #374:?>
Line #375:
Line #376:</tr>
Line #377:
Line #378:<?
Line #379://if ($_SESSION[admin]=="ADMIN") {
Line #380:?>
Line #381:
Line #382:<tr>
Line #383:<td colspan=3 align=left >
Line #384:
Line #385:
Line #386:
Line #387:
Line #388:
Line #389:
Line #390:
Line #391:<td>
Line #392:
Line #393:
Line #394:
Line #395:
Line #396:</td>
Line #397:</tr>
Line #398:
Line #399:
Line #400:<tr>
Line #401:<td colspan=3 align=left >
Line #402:
Line #403:
Line #404:
Line #405:
Line #406:
Line #407:
Line #408:</td>
Line #409:<td>
Line #410:
Line #411:</td>
Line #412:</tr>
Line #413:<?
Line #414://}
Line #415:?>
Line #416:<tr>
Line #417:
Line #418:
Line #419:
Line #420:
Line #421:<input type='TEXT' value='<? echo($cim);?>'
Line #422:size=100 name='cim' ><br>
Line #423:<input type='TEXT' value='<? echo($cimkieg1);?>'
Line #424:size=100 name='cimkieg1' ><br>
Line #425:<input type='TEXT' value='<? echo($cimkieg2);?>'
Line #426:size=100 name='cimkieg2' >
Line #427:</td>
Line #428:
Line #429:<td>
Line #430:
Line #431: <br>
Line #432:
Line #433: <br>
Line #434:
Line #435: name='sum_keszlet' >
Line #436:</td></tr>
Line #437:
Line #438:
Line #439:<tr>
Line #440:
Line #441:<input type='TEXT' value='<? echo($Adoszam);?>' name='Adoszam'
Line #442: >
Line #443:<input type='hidden' value='<? echo($wid);?>' name='wid'>
Line #444:</td>
Line #445:
Line #446:
Line #447:<input type='TEXT' value='<? echo($Szjszam);?>' name='Szjszam'
Line #448: >
Line #449:</td>
Line #450:
Line #451:
Line #452:<input type='TEXT' value='<? echo($AFA_jel);?>' name='AFA_jel'>
Line #453:</td>
Line #454:
Line #455:</tr>
Line #456:<tr>
Line #457:
Line #458:
Line #459:<input type='TEXT' value='<? echo($cimkieg3);?>'
Line #460:
Line #461:
Line #462:</td>
Line #463:
Line #464:</tr>
Line #465:
Line #466:</table></form>
Line #467:
Line #468:<?
Line #469:
Line #470:echo($e);
Line #471:
Line #472:?>