Bi-Dir

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