<?php session_start();
	if (!$_SESSION['nama']){
		echo "<script language=JavaScript>";
		echo "location.href = 'login.php';";
		echo "</script>";
	}
	include ("../koneksi.php");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
	<head>
		<title> WEBSITE BACKOFFICE </title>
		<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
		<link href="style.css" rel="stylesheet" type="text/css">
		<script language="JavaScript" type="text/javascript" src="richtext.js"></script>
		<script language="JavaScript" type="text/javascript">
		<!--
		function submitForm() {
			//make sure hidden and iframe value are in sync before submitting form
			//to sync only 1 rte, use updateRTE(rte)
			//to sync all rtes, use updateRTEs
			updateRTE('deskripsi');
			//updateRTEs();
			//alert("rte1 = " + document.RTEDemo.content.value);
			
			//change the following line to true to submit form
			return true;
		}
		
		//Usage: initRTE(imagesPath, includesPath, cssFile)
		initRTE("images/", "", "");
		//-->
		</script>				
	</head>	
	<body>
		<center>
			<table width="800">
				<tr valign="top">
					<td width="162" class="bg">
						<?php include("kiri.php"); ?>
					</td>
					<td>
						<!-- Begin Kanan -->
						<table width="166">
							<tr height="28"><td></td></tr>
							<tr>
								<td align="right">
									<img src="images/LOGO_PENTA_putih.jpg" border="0"><br>
									<font size="3"><strong>WEBSITE BACKOFFICE</strong></font>
								</td>
							</tr>
						</table>
						<hr color="#EEEEEE" size="1">
						<table><tr height="9"><td></td></tr></table>
						<?php 
						@ $action = $_REQUEST["action"];
						if ($action=="add") {
							?>
							<table width="100%" cellpadding="5" cellspacing="0" border="0">
								<tr><td><strong>JOURNAL --> ADD JOURNAL</strong></td></tr>
								<tr valign="top">
									<td>									
										<form method="post" action="proses.php" enctype="multipart/form-data" name="form1" onSubmit="return submitForm();">
											<table width="100%" cellpadding="3">
												<tr>
													<td>Date</td>
													<td>:</td>
													<td>
														<select name="tgl">
															<?php
															for($i=1; $i<=31; $i++) {
																?>
																<option value="<?=$i?>"><?=$i?></option>
																<?php
															}
															?>
														</select>
														<select name="bln">
															<?php
															for($i=1; $i<=12; $i++) {
																?>
																<option value="<?=$i?>"><?=$i?></option>
																<?php
															}
															?>
														</select>
														<select name="thn">
															<?php
															for($i=2013; $i<=2020; $i++) {
																?>
																<option value="<?=$i?>"><?=$i?></option>
																<?php
															}
															?>
														</select>														
													</td>
												</tr>												
												<tr>
													<td>Title</td>
													<td>:</td>
													<td><input type="text" name="title" size="75"></td>
												</tr>
												<tr valign="top">
													<td>Descriptions</td>
													<td>:</td>
													<td>
														<script language="JavaScript" type="text/javascript">
															<!--
																//Usage: writeRichText(fieldname, html, width, height, buttons, readOnly)
																writeRichText('deskripsi', '<?php echo $deskripsi; ?>', 10, 300, true, false);
															//-->
														</script>															
													</td>
												</tr>
												<tr valign="top">
													<td>News Image</td>
													<td>:</td>
													<td><input type="file" name="gambar" size="15"></td>
												</tr>
												<tr>
													<td colspan="2"></td>
													<td>
														<input type="submit" value="Submit">
														<input type="button" value="Cancel" onclick="javascript:history.go(-1)">
														<input type="hidden" name="action" value="add">
														<input type="hidden" name="module" value="journal">														
													</td>
												</tr>
											</table>											
										</form>
									</td>
								</tr>
							</table>																													
							<?php
						} else if ($action=="edit") {
							$id = $_REQUEST["id"];
							$query="select * from tbjournal where pkid='".$id."'";
							$hasil=mysql_query($query);
							while($data=mysql_fetch_array($hasil)){	
								$deskripsi=$data["deskripsi"];
								$deskripsi = str_replace("'", "&acute;", $deskripsi);	
								$deskripsi = str_replace(chr(13), "", $deskripsi);
								$deskripsi = str_replace(chr(10), "", $deskripsi);								
								?>
								<table width="100%" cellpadding="5" cellspacing="0" border="0">
									<tr><td><strong>JOURNAL --> EDIT JOURNAL</strong></td></tr>
									<tr valign="top">
										<td>									
											<form method="post" action="proses.php" enctype="multipart/form-data" name="form1" onSubmit="return submitForm();">
												<table width="100%" cellpadding="3">
													<tr>
														<td>Date</td>
														<td>:</td>
														<td>
															<?php 
															$tanggal = explode("-", $data["dateentry"]);						
															?>
															<select name="tgl">
																<?php																
																for($i=1; $i<=31; $i++) {
																	?>
																	<option <?php if($i == (int)$tanggal[2]) echo "selected";?> value="<?=$i?>"><?=$i?></option>
																	<?php
																}
																?>
															</select>
															<select name="bln">
																<?php
																for($i=1; $i<=12; $i++) {
																	?>
																	<option <?php if($i == (int)$tanggal[1]) echo "selected";?> value="<?=$i?>"><?=$i?></option>
																	<?php
																}
																?>
															</select>
															<select name="thn">
																<?php
																for($i=2006; $i<=2020; $i++) {
																	?>
																	<option <?php if($i == (int)$tanggal[0]) echo "selected";?> value="<?=$i?>"><?=$i?></option>
																	<?php
																}
																?>
															</select>														
														</td>
													</tr>												
													<tr>
														<td>Title</td>
														<td>:</td>
														<td><input type="text" name="title" size="75" value="<?php echo $data["title"];?>"></td>
													</tr>
													<tr valign="top">
														<td>Descriptions</td>
														<td>:</td>
														<td>
															<script language="JavaScript" type="text/javascript">
																<!--
																	//Usage: writeRichText(fieldname, html, width, height, buttons, readOnly)
																	writeRichText('deskripsi', '<?php echo $deskripsi; ?>', 10, 300, true, false);
																//-->
															</script>															
														</td>
													</tr>
													<tr valign="top">
														<td>News Image</td>
														<td>:</td>
														<td>
															<img src="../images/journal/<?php echo $data["gambar"]; ?>" width="250" border="0"> <br>
															<input type="file" name="gambar" size="15">
														</td>
													</tr>
													<tr>
														<td colspan="2"></td>
														<td>
															<input type="submit" value="Submit">
															<input type="button" value="Cancel" onclick="javascript:history.go(-1)">
															<input type="hidden" name="action" value="edit">
															<input type="hidden" name="module" value="journal">														
															<input type="hidden" name="id" value="<?php echo $data["pkid"]; ?>">
															<input type="hidden" name="oldgambar" value="<?php echo $data["gambar"]; ?>">
														</td>
													</tr>
												</table>											
											</form>
										</td>
									</tr>
								</table>																																					
								<?php
							}
						} else if ($action=="delete") {
							$id = $_REQUEST["id"];
							$query="select * from tbjournal where pkid = ".$id;
							//echo $query;
							$hasil=mysql_query($query);												
							while($data=mysql_fetch_array($hasil)){	
								?>
								<table width="100%" cellpadding="5" cellspacing="0" border="0">
									<tr><td><strong>JOURNAL --> DELETE JOURNAL</strong></td></tr>
									<tr valign="top">
										<td>									
											<form method="post" action="proses.php" enctype="multipart/form-data" name="form1" onSubmit="return submitForm();">
												Are you sure you want to delete the following data
												<table cellpadding="3" cellspacing="1" bgcolor="#666666">
													<tr bgcolor="#FFFFFF">
														<td>
															<table cellpadding="6">
																<tr>
																	<td>Title</td>
																	<td>:</td>
																	<td><?php echo $data["title"];?></td>
																</tr>
																<tr valign="top">
																	<td>Descriptions</td>
																	<td>:</td>
																	<td><?php echo $data["deskripsi"];?></td>
																</tr>
																<tr>
																	<td colspan="2"></td>
																	<td>
																		<input type="submit" value="&nbsp;&nbsp;Yes&nbsp;&nbsp;">
																		<input type="button" value="&nbsp;&nbsp; No &nbsp;&nbsp;" onclick="javascript:history.go(-1)">
																		<input type="hidden" name="action" value="delete">
																		<input type="hidden" name="module" value="journal">
																		<input type="hidden" name="id" value="<?php echo $data["pkid"];?>">
																		<input type="hidden" name="gambar" value="<?php echo $data["gambar"];?>">
																	</td>
																</tr>
															</table>
														</td>
													</tr>
												</table>											
											</form>
										</td>
									</tr>
								</table>								
								<?php
							}	
						} else {
							?>
							<table width="100%" cellpadding="5" cellspacing="0" border="0">
								<tr><td><strong>Journal --> LIST Journal</strong></td></tr>
								<tr valign="top">
									<td>
										<div align="right"><a href="archives.php?menu=3&action=add"><strong>Add News</strong></a></div>
										<table width="100%" cellpadding="6" cellspacing="1" bgcolor="#CCCCCC">
											<tr bgcolor="#EEEEEE">
												<td width="5%" align="center"><strong>ID</strong></td>
												<td width="75%"><strong>Title</strong></td>
												<td width="20%" align="center"><strong>Action</strong></td>
											</tr>										
											<?php 
											if ($koneksi){
												@ $nomor = 0;
												$query="select * from tbjournal order by dateentry desc";
												$hasil=mysql_query($query);												
												while($data=mysql_fetch_array($hasil)){													
													$nomor=$nomor+1;
													?>
													<tr bgcolor="#FFFFFF">
														<td align="center"><?php echo $nomor; ?> </td>
														<td><?php echo $data["title"]; ?></td>
														<td align="center">
															<a href="archives.php?menu=3&action=edit&id=<?php echo $data["pkid"]; ?>">Edit</a>&nbsp;|&nbsp;
															<a href="archives.php?menu=3&action=delete&id=<?php echo $data["pkid"]; ?>">Delete</a>
														</td>
													</tr>
													<?php
												}
											}	
											?>
										</table>
									</td>
								</tr>
							</table>				
							<?php
						}
						?>
						<!-- Begin Kanan -->
					</td>
				</tr>
			</table>
		</center>
	</body>
</html>	