Bi-Dir

QB_musorPUBLIC.inc

Line #0:<?
Line #1:
Line #2:$mentve="";
Line #3:
Line #4:if (isset($_POST[wid]))
Line #5:{
Line #6:
Line #7:if ($_POST[helyszin]<>'*' and isset($_POST[helyszin])) $helyupd="
Line #8:`hely_kod`='$_POST[helyszin]',
Line #9:`helyszin`='$sor[helyszin]',";
Line #10:else $helyupd='';
Line #11:
Line #12:
Line #13: $datum_fej=$_POST[datum_fej];
Line #14:
Line #15:} else $datum_fej=$_POST[belep];
Line #16:
Line #17:if (isset($_POST[szervezo]) and substr($_SESSION[Qusr_kod],0,2)=="EF" )
Line #18:$szervezo="`szervezo`='$_POST[szervezo]',"; else $szervezo="";
Line #19:
Line #20:IF (substr($datum_fej,0,3)<>"Bel") $datum_evho="`datum_evho`='".substr($datum_fej,0,7)."',"; else $datum_evho="";
Line #21:
Line #22:
Line #23:IF (substr($datum_fej,0,3)<>"Bel") $datum_evho="`datum_evho`='".substr($datum_fej,0,7)."',"; else $datum_evho="";
Line #24:
Line #25:
Line #26://echo ($szervezo."/".$_POST[Qdef_user]."<hr>");
Line #27:
Line #28:if ($_SESSION[login]=="BI(c)")
Line #29:$SQLarc = "UPDATE `qj_musor` SET `Adoszam`='$_POST[Adoszam]',
Line #30:`Szjszam`='$_POST[Szjszam]', `AFA_jel`='$_POST[AFA_jel]',
Line #31:`erkezesi`='$_POST[erkezesi]', `archiv`='$_POST[archiv]',
Line #32: `cimkieg1`='$_POST[cimkieg1]',
Line #33: `cimkieg2`='$_POST[cimkieg2]',
Line #34: `cimkieg3`='$_POST[cimkieg3]',
Line #35: $helyupd $szervezo
Line #36: `arnev`='$_POST[arnev]',
Line #37: `alapar1`='$_POST[alapar1]',
Line #38: `alapar2`='$_POST[alapar2]',
Line #39: `alapar3`='$_POST[alapar3]',
Line #40: `alapar4`='$_POST[alapar4]',
Line #41: `alapar5`='$_POST[alapar5]',
Line #42: `alapar6`='$_POST[alapar6]',
Line #43: `alapar7`='$_POST[alapar7]',
Line #44: `alapar8`='$_POST[alapar8]',
Line #45: `alapar9`='$_POST[alapar9]',
Line #46: `alapar0`='$_POST[alapar0]',
Line #47: `sum_keszlet`='$_POST[sum_keszlet]',
Line #48: `web`='$_POST[web]',
Line #49: `datum`='$_POST[datum]',
Line #50: `datum_fej`='$datum_fej',
Line #51: $datum_evho
Line #52: `cim`='$_POST[cim]'
Line #53: where `wid`='".$_GET[wjid]."'; ";
Line #54:else
Line #55:$SQLarc = "UPDATE `qj_musor` SET `Adoszam`='$_POST[Adoszam]',
Line #56:`Szjszam`='$_POST[Szjszam]', `AFA_jel`='$_POST[AFA_jel]',
Line #57:`erkezesi`='$_POST[erkezesi]', `archiv`='$_POST[archiv]',
Line #58: `cimkieg1`='$_POST[cimkieg1]',
Line #59: `cimkieg2`='$_POST[cimkieg2]',
Line #60: `cimkieg3`='$_POST[cimkieg3]',
Line #61: `sum_keszlet`='$_POST[sum_keszlet]',
Line #62: $szervezo
Line #63: `arnev`='$_POST[arnev]',
Line #64: `alapar1`='$_POST[alapar1]',
Line #65: `alapar2`='$_POST[alapar2]',
Line #66: `alapar3`='$_POST[alapar3]',
Line #67: `alapar4`='$_POST[alapar4]',
Line #68: `alapar5`='$_POST[alapar5]',
Line #69: `alapar6`='$_POST[alapar6]',
Line #70: `alapar7`='$_POST[alapar7]',
Line #71: `alapar8`='$_POST[alapar8]',
Line #72: `alapar9`='$_POST[alapar9]',
Line #73: `alapar0`='$_POST[alapar0]',
Line #74: `web`='$_POST[web]',
Line #75: `datum`='$_POST[datum]',
Line #76: `datum_fej`='$datum_fej',
Line #77: `cim`='$_POST[cim]'
Line #78: where `wid`='".$_GET[wjid]."'; ";
Line #79:
Line #80:// echo($SQLarc."<hr>");
Line #81:
Line #82:
Line #83://echo("<font color=blue>Adatok mentve !!!</font>");
Line #84:
Line #85:$ido=date("H:i:s");
Line #86:$mentve="<font color=blue>Adatok mentve !!! $ido </font><br>";
Line #87:
Line #88:}
Line #89:
Line #90:IF (isset($_POST[szervezo])) $_SESSION[szervezo]=$_POST[szervezo];
Line #91:
Line #92:$sel = "SELECT * FROM qj_musor where wid='".$_GET[wjid]."'" ;
Line #93:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #94:$sor = mysql_fetch_array( $sql);
Line #95:
Line #96:$wjid=$sor[wid];
Line #97:$Adoszam=$sor[Adoszam];
Line #98:$Szjszam=$sor[Szjszam];
Line #99:$AFA_jel=$sor[AFA_jel];
Line #100:$web=$sor[web];
Line #101:
Line #102:$szervezo=$sor[szervezo];
Line #103:
Line #104:if (!isset($_POST[szervezo])) $_POST[szervezo]=$szervezo;
Line #105:
Line #106:$keres="SELECT * FROM qj_login where archiv='#SZERVEZ#' ORDER BY nev";
Line #107:
Line #108:$nurS=mysql_num_rows($eredmeny);
Line #109:
Line #110://?//onchange=this.form.submit(); return true name='szervezo'>";
Line #111:
Line #112:
Line #113:onchange= return true name='szervezo'>";
Line #114:
Line #115:
Line #116:while ( $egy_sor = mysql_fetch_array( $eredmeny ) )
Line #117:{
Line #118:if (strtolower($_POST[szervezo])==strtolower($egy_sor[email_kod])) $sel=" SELECTED "; else $sel="";
Line #119:$szer.="<option value='".$egy_sor[email_kod]."' $sel>".$egy_sor[nev]."</option>";
Line #120:}
Line #121:$szer.="</SELECT>";
Line #122:
Line #123:if ($nurS==0) $szer="";
Line #124:
Line #125:
Line #126:$erkezesi=$sor[erkezesi];
Line #127:$archiv=$sor[archiv];
Line #128:
Line #129:$belep=$sor[datum_fej];
Line #130:
Line #131:$hely_kod=$sor[hely_kod];
Line #132:
Line #133:$datum=$sor[datum];
Line #134:$datum_fej=$sor[datum_fej];
Line #135:
Line #136:if ($sor[datum_kod]=="")
Line #137:{
Line #138:$SQLarc = "UPDATE `qj_musor` SET
Line #139: `datum_kod`='".$sor[usr_kod]."D".substr("00000".$wjid,-5)."'
Line #140: where `wid`='".$wjid."'";
Line #141:
Line #142:
Line #143:}
Line #144:
Line #145:$cim=$sor[cim];
Line #146:
Line #147:$cimkieg1=$sor[cimkieg1];
Line #148:$cimkieg2=$sor[cimkieg2];
Line #149:$cimkieg3=$sor[cimkieg3];
Line #150:
Line #151:$alapar1=$sor[alapar1];
Line #152:$alapar2=$sor[alapar2];
Line #153:$alapar3=$sor[alapar3];
Line #154:$alapar4=$sor[alapar4];
Line #155:
Line #156:$alapar5=$sor[alapar5];
Line #157:$alapar6=$sor[alapar6];
Line #158:$alapar7=$sor[alapar7];
Line #159:$alapar8=$sor[alapar8];
Line #160:
Line #161:$alapar9=$sor[alapar9];
Line #162:$alapar0=$sor[alapar0];
Line #163:$arnev=$sor[arnev];
Line #164:$sum_keszlet=$sor[sum_keszlet];
Line #165:
Line #166:if (!isset($_POST[helyszin])) $_POST[helyszin]=$hely_kod;
Line #167:
Line #168:$disQ = "SELECT * FROM qj_sql where szoveg='Arsav' order by widarc" ;
Line #169:
Line #170:
Line #171:
Line #172:while ( $disC = mysql_fetch_array( $disR )) {
Line #173: $ARtitle[$disC[widarc]]=$disC[sql_memo];
Line #174:}
Line #175:
Line #176:
Line #177:/*$disQ = "SELECT helyszin,hely_kod FROM qj_szinpad order by hely_kod" ;
Line #178:
Line #179:
Line #180:
Line #181:
Line #182:
Line #183:$helyszin="";
Line #184:
Line #185:while ( $disC = mysql_fetch_array( $disR )) {
Line #186: if ($disC[hely_kod]==$_POST[helyszin])
Line #187: {$helyszin=$disC[helyszin]; $sel="SELECTED";}
Line #188: else $sel="";
Line #189:
Line #190: if (trim($disC[helyszin])<>"")
Line #191: $sel1.="<option value='".$disC[hely_kod]."' $sel >".$disC[hely_kod]." ".$disC[helyszin]."</option>";
Line #192:}
Line #193:$sel1.="</SELECT>";
Line #194:*/
Line #195:
Line #196:$sel1="";
Line #197:
Line #198:
Line #199:// 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 #200:
Line #201:if ($_SESSION[login]=="BI(c)")
Line #202: $ie = '<a target=adatframe href="QJ_musorEDIT.php?&wjid='.$wjid.$evad.
Line #203: '"><img src="../_Screen/edit.png" border=0><font color=red size=+3>'.$wjid.'</font></a>';
Line #204:else $ie="";
Line #205:
Line #206:$fej="<font size=+1 ><i>".$sor[datum]." </i>".$sor[helyszin]."  ".$ie.
Line #207:"<font size=+1 color=red>   (".$sor[datum_kod].")<br><font size=+2>".$sor[cim]."</font >"
Line #208:
Line #209:
Line #210:?>
Line #211:
Line #212:
Line #213:<form name=myForm
Line #214:
Line #215:>
Line #216:
Line #217:<table border=1 align=center bgcolor='gold'>
Line #218:
Line #219:
Line #220:<? echo($fej); ?>
Line #221:<tr>
Line #222:<td align=left colspan=4>
Line #223:<?
Line #224:if ($_SESSION[login]=="BI(c)") {
Line #225:?>
Line #226:
Line #227:
Line #228:
Line #229:
Line #230:
Line #231:
Line #232:
Line #233:
Line #234:<?
Line #235:}
Line #236:?>
Line #237:
Line #238:
Line #239:<? if ($erkezesi<>'Y') echo(' CHECKED '); ?>
Line #240:
Line #241:
Line #242:
Line #243:<? if ($erkezesi=='Y') echo(' CHECKED '); ?>
Line #244:
Line #245:
Line #246:
Line #247:<? if ($archiv<>'*') echo(' CHECKED '); ?>
Line #248:
Line #249:
Line #250:
Line #251:<? if ($archiv=='*') echo(' CHECKED '); ?>
Line #252:
Line #253:
Line #254:
Line #255:
Line #256:
Line #257:
Line #258:<? if ($web<>'web') echo(' CHECKED '); ?>
Line #259:>INTRA 
Line #260:
Line #261:
Line #262:<? if ($web=='web') echo(' CHECKED '); ?>
Line #263:>WEB 
Line #264:
Line #265:
Line #266:
Line #267:</td>
Line #268:
Line #269:</tr>
Line #270:
Line #271:
Line #272:<tr>
Line #273:<td colspan=3 align=left>
Line #274:<? echo($mentve);?>
Line #275:
Line #276:
Line #277:
Line #278:
Line #279:</td>
Line #280:<?
Line #281:
Line #282:?>
Line #283:
Line #284:<td align=center>
Line #285:
Line #286:</td>
Line #287:<?
Line #288:}
Line #289:?>
Line #290:
Line #291:</tr>
Line #292:
Line #293:<?
Line #294:if ($_SESSION[admin]=="ADMIN") {
Line #295:?>
Line #296:
Line #297:<tr>
Line #298:<td colspan=3 align=left >
Line #299:
Line #300:
Line #301:
Line #302:
Line #303:
Line #304:
Line #305:
Line #306:<td>
Line #307:
Line #308:
Line #309:
Line #310:
Line #311:</td>
Line #312:</tr>
Line #313:
Line #314:
Line #315:<tr>
Line #316:<td colspan=3 align=left >
Line #317:
Line #318:
Line #319:
Line #320:
Line #321:
Line #322:
Line #323:</td>
Line #324:<td>
Line #325:
Line #326:</td>
Line #327:</tr>
Line #328:<?
Line #329:}
Line #330:?>
Line #331:<tr>
Line #332:
Line #333:
Line #334:
Line #335:
Line #336:<input type='TEXT' value='<? echo($cim);?>'
Line #337:size=100 name='cim' ><br>
Line #338:<input type='TEXT' value='<? echo($cimkieg1);?>'
Line #339:size=100 name='cimkieg1' ><br>
Line #340:<input type='TEXT' value='<? echo($cimkieg2);?>'
Line #341:size=100 name='cimkieg2' >
Line #342:</td>
Line #343:
Line #344:<td>
Line #345:
Line #346: <br>
Line #347:
Line #348: <br>
Line #349:
Line #350: name='sum_keszlet' >
Line #351:</td></tr>
Line #352:
Line #353:
Line #354:<tr>
Line #355:
Line #356:<input type='TEXT' value='<? echo($Adoszam);?>' name='Adoszam'
Line #357: >
Line #358:<input type='hidden' value='<? echo($wid);?>' name='wid'>
Line #359:</td>
Line #360:
Line #361:
Line #362:<input type='TEXT' value='<? echo($Szjszam);?>' name='Szjszam'
Line #363: >
Line #364:</td>
Line #365:
Line #366:
Line #367:<input type='TEXT' value='<? echo($AFA_jel);?>' name='AFA_jel'>
Line #368:</td>
Line #369:
Line #370:</tr>
Line #371:<tr>
Line #372:
Line #373:
Line #374:<input type='TEXT' value='<? echo($cimkieg3);?>'
Line #375:
Line #376:
Line #377:</td>
Line #378:
Line #379:</tr>
Line #380:
Line #381:</table></form>
Line #382:
Line #383:<?
Line #384:
Line #385:echo($e);
Line #386:
Line #387:?>
Line #388:<SCRIPT LANGUAGE="JavaScript" SRC="calendar.js"></SCRIPT>