Bi-Dir

QQ_musorNAPTARcreate.inc

Line #0:<?php
Line #1:if (isset($_SESSION['Dump'])) echo("QJEGY`2013v3.01 QQ_musorNAPTAR.inc *** ACTION =".$L_PHP." <hr>");
Line #2:
Line #3:$selEVHO="musor";
Line #4:if (isset($_GET[nyomtat])) {
Line #5:?>
Line #6:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #7:<?PHP
Line #8:$hatterszin="";
Line #9:$bord="0";
Line #10:} else {
Line #11:$hatterszin=" bgcolor=Moccasin ";
Line #12:$bord="1";
Line #13:
Line #14:}
Line #15:
Line #16:include("../_inc_QJ/QS_selectELOADASmusor.inc");
Line #17:// include("../_inc_QJ/QS_selectHELYSZINmusor.inc");
Line #18:include("../_inc_QJ/QS_selectORAPERC.inc");
Line #19:
Line #20:include("../_inc_QJ/QQ_musorhoSELECT.inc");
Line #21:
Line #22:
Line #23:
Line #24:
Line #25:$L_PHP="QQ_musorNAPTAR.php";
Line #26:include("QJ_listafej.php");
Line #27:
Line #28:echo "
Line #29:<table border=".$bord." $hatterszin >
Line #30:";
Line #31:
Line #32:$szin="";
Line #33:$osft=0;
Line #34:$i=0;
Line #35:
Line #36:
Line #37:
Line #38:$napnev[2]="kedd";
Line #39:$napnev[3]="szerda";
Line #40:
Line #41:
Line #42:$napnev[6]="szombat";
Line #43:
Line #44:
Line #45:
Line #46:
Line #47:
Line #48:
Line #49:
Line #50:
Line #51:$honev[8]="augusztus";
Line #52:$honev[9]="szeptember";
Line #53:
Line #54:$honev[11]="movember";
Line #55:$honev[12]="december";
Line #56:
Line #57:$Rhonap=str_replace("-",".",$_POST[Rhonap]); // biztos, ami biztos !!!
Line #58:
Line #59:$ev=0+substr($Rhonap,0,4);
Line #60:$ho=0+substr($Rhonap,-2);
Line #61:
Line #62:if ($QS_kezdonap=="") $Knap=1; else $Knap=$QS_kezdonap;
Line #63:
Line #64:
Line #65://for ($nap = 1; $nap < 32; $nap++) {
Line #66:
Line #67:for ($i = $Knap; $i <= 31; $i++) {
Line #68:
Line #69: $nap=$i;
Line #70:
Line #71: if (checkdate ( $ho , $nap , $ev )) {
Line #72:
Line #73: if ($szin=="bgcolor=Thistle") $szin="bgcolor=yellow"; else $szin="bgcolor=Thistle";
Line #74:
Line #75:
Line #76:
Line #77:
Line #78:
Line #79:$datum=$ev."-".$ho."-".$nap;
Line #80:
Line #81:$napVAL=strtotime(str_replace(".","-",$datum));
Line #82:
Line #83:$napind=date("w",$napVAL);
Line #84:$Enapnev=date("l",$napVAL);
Line #85:$hoind=date("m",$napVAL);
Line #86:
Line #87:$ev=date("Y",$napVAL);
Line #88:
Line #89:$hoind=($hoind+0);
Line #90:
Line #91:$pos=strpos(strtolower($egy_sor[datum]),strtolower($napnev[$napind]));
Line #92:$len=strlen($egy_sor[datum]);
Line #93:$ido=substr($egy_sor[datum],strlen($napnev[$napind])+$pos-$len);
Line #94:
Line #95:
Line #96:$idojel=substr($ido,0,$orapos);
Line #97:$orapos=strpos($idojel,":");
Line #98:$idojelURL=$idojel;
Line #99:if ($orapos==0) $idojelURL=$idojel.":00";
Line #100:$napszam=(0+date("d",$nap));
Line #101:
Line #102:$Gdatum=str_replace("Y",$ev,$egy_sor[datum_url]);
Line #103:$Gdatum=str_replace(".d"," ".$napszam.".",$Gdatum);
Line #104:$Gdatum=str_replace("M",strtolower($honev[$hoind]),$Gdatum);
Line #105:$Gdatum=str_replace("D",strtolower($napnev[$napind]),$Gdatum);
Line #106:$Gdatum=str_replace("H:i",$idojel,$Gdatum);
Line #107:
Line #108:
Line #109:
Line #110:
Line #111:if ($napind==0 or $napind==6 )
Line #112:$hatterszin=" bgcolor=Silver "; else
Line #113:$hatterszin=" bgcolor=Moccasin ";
Line #114:
Line #115:
Line #116://if ($egy_sor[archiv]=="*")
Line #117:$info=" Rejtett ";
Line #118://else $info="";
Line #119://if ($egy_sor[web]=="web")
Line #120:$info.="<font color=red><b> WEB </b>";
Line #121://if ($info<>"") $
Line #122:$info="<hr>".$info;
Line #123:
Line #124:
Line #125:
Line #126:$QS_nap="<input type='hidden' value='".date("Y.m.d",$napVAL)."' name='QS_nap'>";
Line #127://$QS_evhonap="<input type='hidden' value='".date("Y",$napVAL).". ".$honev[$hoind].". ".date("d",$napVAL). "' name='QS_evhonap'>";
Line #128:$QS_evhonap="<input type='hidden' value='".date("Y",$napVAL).". ".$honev[$hoind].". ".$napIR. "' name='QS_evhonap'>";
Line #129:$QS_napnev="<input type='hidden' value='".$napnev[$napind]."' name='QS_napnev'>";
Line #130:$QS_honev="<input type='hidden' value='".$honev[$hoind]."' name='QS_honev'>";
Line #131:$QS_orajel="<input type='hidden' value='".$QS_idojel."' name='QS_idojel'>";
Line #132:
Line #133:$QS_ev="<input type='hidden' value='".date("Y",$napVAL)."' name='QS_ev'>";
Line #134:$QS_ho="<input type='hidden' value='".date("m",$napVAL)."' name='QS_ho'>";
Line #135:
Line #136: $tr="</tr><tr $hatterszin>
Line #137: <td align=right ><font color=$szin>".date("Y.m.d",$napVAL)." <br> $napnev[$napind]</font></td>
Line #138: ";
Line #139:
Line #140:
Line #141:echo $tr;
Line #142:
Line #143:$wer=" and datum_fej='".date("Y.m.d",$napVAL)."' ";
Line #144:
Line #145:///////////////////////////////////////////
Line #146:$parancs="SELECT * FROM qj_musor where future<>'*' $wer ORDER BY datum_ev, datum_ho,datum_nap,datum_idopont,datum ";
Line #147:
Line #148:
Line #149:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #150:{
Line #151:
Line #152:$Qid[$i]=$egy_sor[wid];
Line #153:$wjid=$egy_sor[wid];
Line #154:$datum_kod=$egy_sor[datum_kod];
Line #155:
Line #156:if ($egy_sor[archiv]=="*") $info=" Rejtett "; else $info="";
Line #157:if ($egy_sor[web]=="web") $info.="<font color=red><b> WEB </b>";
Line #158:if ($info<>"") $info="<hr>".$info;
Line #159:
Line #160://////////////// IDE KELL ////////////
Line #161:include("../_inc_QJ/QQ_musorREL.inc");
Line #162://////////////////////////////////////
Line #163:
Line #164:
Line #165:if($QS_kezdonap<>"") {
Line #166: $refFULLmusor="<br>";
Line #167: $dt=$egy_sor[datum_napnev]." ".$egy_sor[datum_idopont]." ".$egy_sor[datum_idojel];
Line #168: } else {
Line #169: $refFULLmusor="<br>".$refFULLmusor."<br>";
Line #170: $dt=$egy_sor[datum];
Line #171: }
Line #172:
Line #173:// MINDIG KELL !!!
Line #174:$dt=$egy_sor[datum];
Line #175:
Line #176://$mcall $cref $aref $bref $dref $xlsX $medi $egy_sor[datum] datum_ev datum_ho datum_honev datum_nap datum_napnev datum_idopont datum_idojel musor_bevitel datum
Line #177:echo"
Line #178:<td align=center $szin >
Line #179:<font color=blue size=+1>$egy_sor[datum_kod]</font>
Line #180:$refFULLmusor
Line #181:<font color=red>
Line #182:$dt
Line #183:</font><br><b>$egy_sor[cim]</b><br>$egy_sor[helyszin]
Line #184:<font color=blue>$info</font>
Line #185:</td>";
Line #186:
Line #187:// if ($szin=="bgcolor=gold") $szin="bgcolor=yellow"; else $szin="bgcolor=gold";
Line #188: if ($szin=="bgcolor=Thistle") $szin="bgcolor=yellow"; else $szin="bgcolor=Thistle";
Line #189:
Line #190:}
Line #191:///////////////////////////////////////////
Line #192:
Line #193:$bup="<FORM name=by$i target=adatframe action='QQ_musorNAPTARupdate.php?&sqlfile=temaop&wjid=-1&bixupd=-1' method='post'>";
Line #194:$bup.="<table border=0 align=center >";
Line #195://$bup.="<td align=left>";
Line #196:$bup.="<tr><td align=left>
Line #197:
Line #198: $QS_cim
Line #199: $QS_hszin <br>
Line #200:
Line #201:$QS_nap $QS_napnev $QS_evhonap $QS_oraperc $QS_orajel $QS_honev
Line #202:";
Line #203://RecNo:$i
Line #204://$bup.="<td align=center>RecNo:$i";
Line #205://$bup.='    
Line #206:// <a target=infoframe href="QJ_attach.php?&wjid='.$i.'&tabla=ml_szoba">
Line #207:// <img src="../_Screen/attachment.png" border=0></a>';
Line #208:
Line #209:$bup.="<input type='hidden' value='$i' name='Wjid'>";
Line #210:$bup.="</td></tr></table></FORM>";
Line #211:
Line #212:
Line #213:echo"
Line #214:<td align=center $szin>
Line #215:$bup
Line #216:</td>";
Line #217:
Line #218:}}
Line #219:
Line #220:
Line #221:echo "
Line #222:</table>
Line #223:";
Line #224:
Line #225:
Line #226:
Line #227:if (isset($_SESSION['Dump'])) {
Line #228:include("../_inc_QJ/QQ_varlist.php");
Line #229:}
Line #230:
Line #231://unset($_SESSION[NyugtaVissza]);
Line #232:
Line #233:if (isset($_GET[nyomtat])) {
Line #234:
Line #235:include("../_inc_QJ/QL_listaveg.inc");
Line #236:
Line #237:echo("<body onload='printit()'></body>");
Line #238:
Line #239:?>
Line #240:<SCRIPT Language="Javascript">
Line #241:
Line #242:function printit(){
Line #243:
Line #244:window.print();
Line #245:
Line #246:}
Line #247:
Line #248:
Line #249:</script>
Line #250:<?PHP
Line #251:}
Line #252:
Line #253:
Line #254:function XcheckData($date)
Line #255:{
Line #256: if (!isset($date) || $date=="")
Line #257: {
Line #258: return false;
Line #259: }
Line #260:
Line #261: list($dd,$mm,$yy)=explode("/",$date);
Line #262: if ($dd!="" && $mm!="" && $yy!="")
Line #263: {
Line #264: if (is_numeric($yy) && is_numeric($mm) && is_numeric($dd))
Line #265: {
Line #266: return checkdate($mm,$dd,$yy);
Line #267:
Line #268: }
Line #269: }
Line #270: return false;
Line #271:
Line #272:}
Line #273:?>