/kiri.php

Large files files are truncated, but you can click here to view the full file

<?php

$PhpEncoder = new CPhpEncoder();

?>

<?php



// Halaman utama (Home)

if ($_GET['module']=='home'){

	

}



// Modul Rekam Nomor Arsip ==================================================================================//

elseif($_GET['module']=='rekamnoarsip'){

	echo "<div id='stylized' class='myform'>

			<form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

			<h1>Data alokasi nomor arsip</h1>

			<p>Data nomor arsip ini akan digunakan dalam perekaman dokumen arsip</p>

			</div>

			

			<br />

			<br />

			<div id='normaltable'>

			<table class='normaltable' width='100%'>

			<tr>

					<th width='10%'>No.</th>

					<th width='20%'>Kode BA</th>

					<th width='20%'>Nomor Rak</th>

					<th width='20%'>Nomor Baris</th>

					<th width='20%'>Nomor Box</th>

			</tr>";

			

			$q_refArsip			= mysql_query("SELECT * FROM r_nomorarsipsp2d ORDER BY kddept,norak,nobaris,nobox");

			$no	=1;

			$oddcol		= "#CCFF99";

			$evencol		= "#CCDD88";

			while($r_refArsip	= mysql_fetch_row($q_refArsip)){

			if($no % 2 == 0) {$color = $evencol;}

			else{$color = $oddcol;}

			echo "<tr bgcolor='$color'>

					<td>$no</td>

					<td>$r_refArsip[1]</td>

					<td>$r_refArsip[2]</td>

					<td>$r_refArsip[3]</td>

					<td>$r_refArsip[4]</td>

				</tr>";

				$no++;

			}

			echo "</table>

			</div>

			<br />

			&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type='submit' class='normaltablesubmit' name='showFormrekam' value='Tambah' />

			</form>";

}

// Modul Form Perekaman Referensi Arsip -----------------------------------------------------------------------------------------------------------------------------//

elseif($_POST['showFormrekam'] == 'Tambah'){			

		echo "<style type='text/css'>

			em { font-weight: bold; padding-right: 1em; vertical-align: top; }

			</style>

			<script>

			$(document).ready(function(){

				$('#form').validate();

			});

  			</script>

			<div id='stylized' class='myform'>

			<form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

			<h1>Form perekaman alokasi nomor arsip</h1>

			<p>Alokasi nomor arsip ini akan digunakan dalam perekaman dokumen arsip</p>

					<label>Kode Dept

					<span class='small'>Isikan kode dept</span>

					</label>

					<input type='text' id='kddept' class='required' minlength='3' name='kddept' maxlength='3' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'norak')\" />

	

					<label>Nomor Rak

					<span class='small'>Isikan nomor alokasi rak</span>

					</label>

					<input type='text' id='norak' name='norak' class='required' minlength='1' maxlength='4' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'nobaris')\" />

					

					<label>Nomor Baris

					<span class='small'>Isikan nomor alokasi baris</span>

					</label>

					<input type='text' id='nobaris' name='nobaris'  class='required' minlength='1' maxlength='4' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'nobox')\" />

					

					<label>Nomor Box

					<span class='small'>Isikan alokasi nomor box</span>

					</label>

					<input type='text' id='nobox' name='nobox'  class='required' minlength='1' maxlength='2' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />

					

					<input type='submit' value='Rekam' class='button' id='submit' name='Insertnoarsip' />

					<div class='spacer'></div>

			</form>

		</div>";

}



// Modul Insert Nomor Arsip ---------------------------------------------------------------------------------------------------------------------------------------------------------------------/

elseif($_POST['Insertnoarsip']=='Rekam'){

	$kddept	= $_POST['kddept'];

	$noRak	= $_POST['norak'];

	$norak	= sprintf("%04s",$noRak);

	$noBaris	= $_POST['nobaris'];

	$nobaris	= sprintf("%04s",$noBaris);

	$noBox	= $_POST['nobox'];

	$Nobox	= sprintf("%02s",$noBox);

	$nobox	= $kddept.$Nobox;

	// Pengecekan bahwa data tersebut belum ada pada database

	$qCdata	= mysql_query("SELECT * FROM r_nomorarsipsp2d

						WHERE kddept='$kddept' AND norak='$norak' AND nobaris='$nobaris' AND nobox='$nobox'");

	$rCdata	= mysql_fetch_row($qCdata);

	if(!$rCdata){

		// Apabila data belum ada maka proses inserting dilanjutkan

		$qI		= mysql_query("INSERT INTO r_nomorarsipsp2d(kddept,norak,nobaris,nobox)

							VALUES ('$kddept','$norak','$nobaris','$nobox')");

		$qC		= mysql_query("SELECT * FROM r_nomorarsipsp2d 

						WHERE kddept='$kddept' AND norak='$norak' AND nobaris='$nobaris' AND nobox='$nobox'");

		$rC		= mysql_fetch_row($qC);

		// Informasi bahwa data gagal di-insert



		if(!$rC){

			echo "<script type='text/javascript'>

					alert('Data gagal direkam!');

					self.history.back(-1);

				</script>";

		}

		else {

			echo "<script type='text/javascript'>

					alert('Data berhasil direkam');

					window.location='media.php?module=rekamnoarsip';

				</script>";

		}

	}

	else {

		echo "<script type='text/javascript'>

				alert('Data pernah direkam!');

				self.history.back(-1);

		</script>";

	}

}



// Modul Load ke Tabel Arsip ========================================================================================//

elseif($_GET['module']=='loadketabelarsip'){

	echo "<script type=\"text/javascript\">

				$(document).ready(function() {

					$('#tanggal').datepicker({

							changeMonth: true,

							changeYear: true

						});

					});

				$(document).ready(function() {

					$('#tanggal1').datepicker({

							changeMonth: true,

							changeYear: true

						});

					});

			</script>

				<div id='stylized' class='myform'>

				<form id='form' name='formLoadTabelArsip' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

				<h1>Form load data ke tabel arsip SP2D</h1> 

				<p>Pilih tanggal load SP2D</p>

  		 			<label>Tanggal Awal SP2D 

  		 			<span class='small'>Isikan tanggal awal SP2D</span>

					</label>  		 			

  		 			<input id=\"tanggal\" name=\"tgsp2d1\" type=\"text\" />

  		 			

  		 			<label>Tanggal Akhir SP2D 

  		 			<span class='small'>Isikan tanggal SP2D</span>

					</label>  		 			

  		 			<input id=\"tanggal1\" name=\"tgsp2d2\" type=\"text\" />

  	 				<input name='loadKeTabelArsip' type='submit' value='Load' class='button'>

					<div class='spacer'></div>

  	 			</form>

  	 			</div>";

}



// Modul Load ke Arsip ------------------------------------------------------------------------------------------------//

elseif($_POST['loadKeTabelArsip']=='Load'){

	$tanggal1	= $helper->dateConvert($_POST['tgsp2d1']);

	$tanggal2	= $helper->dateConvert($_POST['tgsp2d2']);

	

	if(substr($tanggal1,0,4) != substr($tanggal2,0,4))

	{

		echo "

		<script type='text/javascript'>

			alert('Tahun load data berbeda tahun, load hanya bisa dilakukan dalam rentang waktu satu tahun');

			window.location.replace('media.php?module=loadketabelarsip');

		</script>";

	}

	elseif($tanggal1 > $tanggal2)

	{

		echo "

		<script type='text/javascript'>

			alert('Tanggal awal load lebih besar daripada tanggal akhir load');

			window.location.replace('media.php?module=loadketabelarsip');

		</script>";

	}

	elseif(substr($tanggal1,0,4) == '2012' && substr($tanggal2,0,4) == '2012')

	{

		$koneksi = "config/koneksisp2d.php";

	}

	elseif(substr($tanggal1,0,4) == '2011' && substr($tanggal2,0,4) == '2011')

	{

		$koneksi = "config/koneksisp2d11.php";

	}



	include_once($koneksi);

	$qLoad		= mysql_query("SELECT DISTINCT nosp2d,tgsp2d,kdjendok,kddept,kdunit,kdsatker,nokarwas,kddekon,nospm,tgspm,noadvis FROM m_spmind WHERE tgsp2d BETWEEN '$tanggal1' AND '$tanggal2'");

	while($rLoad		= mysql_fetch_object($qLoad)){

			$nosp2d		= $rLoad->nosp2d;

			$tgsp2d		= $rLoad->tgsp2d;

			$kdjendok	= $rLoad->kdjendok;

			$kddept		= $rLoad->kddept;

			$kdunit		= $rLoad->kdunit;

			$kdsatker	= $rLoad->kdsatker;

			$nokarwas	= $rLoad->nokarwas;

			$kddekon	= $rLoad->kddekon;

			$nospm		= $rLoad->nospm;

			$tgspm		= $rLoad->tgspm;

			$noadvis	= $rLoad->noadvis;

			$datasp2d[]	= '("' . $nosp2d . '", "' . $tgsp2d . '", "' . $kdjendok . '", "' . $kddept . '", "' . $kdunit . '", "' . $kdsatker . '", "' . $nokarwas . '", "' . $kddekon . '", "' . $nospm . '", "' . $tgspm . '","' . $noadvis . '")';

	}

	

		$qInsert 	= "INSERT INTO monitor.d_arsipsp2d(nosp2d,tgsp2d,kdjendok,kddept,kdunit,kdsatker,nokarwas,kddekon,nospm,tgspm,noadvis) VALUES". implode(',',$datasp2d);

		$filename	= "insertintotable";

		$folder		= dirname(__FILE__)."/temp/".$filename;

		$handle		= @fopen($folder,"w");

		fwrite($handle,$qInsert);

		fclose($handle);

		include_once("config/koneksi.php");

		/* For windows user, start here

		 * For production you must change load_sp2d.bat because file's default is on d:\

		 * $output = system("cmd /c ".dirname(__FILE__).'/load_sp2d.bat');

		 * end here */

		 

		/* For unix family, start here */

		mysql_query($qInsert);

		$output = shell_exec('mysql -uroot -P3306 -hlocalhost -p monitor < /var/www/temp/'.$filename);

		/* end here */

		echo "

			<script type='text/javascript'>

				alert('Load data selesai');

			</script>";

}



// Modul Insert Arsip ========================================================================================//

elseif($_GET['module']=='insertarsip'){

	echo "<script type=\"text/javascript\">

				$(document).ready(function() {

					$('#tanggal').datepicker();

					});

			</script>

				<div id='stylized' class='myform'>

				<form id='form' name='formInsertArsip' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

				<h1>Form entri data arsip SP2D</h1> 

				<p>Tahap 1 - Entri tanggal SP2D</p>

  		 			<label>Tanggal SP2D 

  		 			<span class='small'>Isikan tanggal SP2D</span>

					</label>  		 			

  		 			<input id=\"tanggal\" name=\"tgsp2d\" type=\"text\" />

  	 				<input name='InsertTgArsip' type='submit' value='Tampilkan' class='button'>

					<div class='spacer'></div>

  	 			</form>

  	 			</div>";

}



// Modul Action Arsip ---------------------------------------------------------------------------------------//

elseif($_POST['InsertTgArsip']=='Tampilkan') {

	$Tglsp2d	= $_POST['tgsp2d'];

	$TglSp2d	= explode('/',$Tglsp2d);

	$tglsp2d	= $TglSp2d[0];

	$blnsp2d	= $TglSp2d[1];

	$thnsp2d	= $TglSp2d[2];

	

	$tgsp2d	= $thnsp2d."-".$blnsp2d."-".$tglsp2d;

	echo "<div id='stylized' class='myform'>

	<form id='form' name='formShowBAArsip' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

	<h1>Form entri data arsip SP2D</h1> 

		<p>Tahap 2 - Entri kode bagian anggaran SP2D</p>		

		<label>Bagian Anggaran

		<span class='small'>Isikan kode bagian anggaran SP2D</span>

		</label>";

		$qcBA	= mysql_query("SELECT kddept FROM d_arsipsp2d  WHERE tgsp2d='$tgsp2d' AND file=''")or die(mysql_error());

		$rcBA	= mysql_fetch_row($qcBA);

			if($rcBA == 0){

			echo "<script type='text/javascript'>

				alert('Data SP2D pada tanggal $Tglsp2d tidak ada');

				history.back(-1);

				</script>";

			}

			else{

				echo "<select name='kddept' size='1'>";

				$qBA		= mysql_query("SELECT DISTINCT a.kddept,b.nmdept FROM d_arsipsp2d a LEFT JOIN t_dept b ON a.kddept=b.kddept WHERE a.tgsp2d='$tgsp2d' AND file='' ORDER BY a.kddept")or die(mysql_error());

					echo "<option selected='selected'>--Bagian Anggaran--</option>";

					while($rBA	= mysql_fetch_array($qBA)){

									$ba		= $rBA['kddept'];

									$nmba	= $rBA['nmdept'];

							echo "<option value='$ba'>$ba - $nmba</option>";

							}

						echo "</select>

						<input name='tgsp2d' type='hidden' value='$tgsp2d' />

						<input name='ScanUploadArsip' type='submit' value='Tampilkan' class='button' />

						<div class='spacer'></div>

						</form>

						</div>";

				}

}



// Modul Scanning dan Upload Arsip SP2D -----------------------------------------------------------------------------------//

elseif($_POST['ScanUploadArsip']=='Tampilkan'){

	$tgsp2d		= $_POST['tgsp2d'];

	$kddept	= $_POST['kddept'];

	$qnmba	= mysql_query("SELECT nmdept FROM t_dept WHERE kddept='$kddept'")or die(mysql_error());

	$rnmba		= mysql_fetch_array($qnmba);

	$nmba		= $rnmba['nmdept'];

	echo "<div id='stylized' class='myform'>

			<form id='form' name='formShowNoDokArsip' method='post' enctype='multipart/form-data'  action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

			<h1>Form entri data arsip SP2D</h1> 

					<p>Tahap 3 - Scanning dan upload SP2D</p>

					<h3>Tanggal SP2D : $tgsp2d

					<br />

					Kementerian : $nmba</h3>

					

					</div>

					<br />	

					<div id='normaltable'>

					<table class='normaltable'>

					<tr>

						<th width='5%'>No.</th>

						<th width='8%'>No. SP2D</th>

						<th width='12%'>Kode Unik</th>

						<th width='8%'>Satker</th>

						<th width='8%'>No. SPM</th>

						<th width='20%'>Tgl. SPM</th>

						<th>Scanning</th>

					</tr>";

					

							$qsp2d	= mysql_query("SELECT DISTINCT * FROM d_arsipsp2d  WHERE tgsp2d='$tgsp2d' AND kddept='$kddept' AND file='' AND norak='' AND nobaris='' AND (nobox='' OR nobox2='') ORDER BY nosp2d,kdunit,kdsatker")or die(mysql_error());

							$oddcol		= "#CCFF99";

							$evencol		= "#CCDD88";

							$no	= 1;

							while($rsp2d	= mysql_fetch_array($qsp2d)){

								if($no % 2 == 0) {$color = $evencol;}

								else{$color = $oddcol;}

								$nosp2d	= $rsp2d['nosp2d'];

								$nospm	= $rsp2d['nospm'];

								$tgspm		= $rsp2d['tgspm'];

								$kdjendok	= $rsp2d['kdjendok'];

								$kddept	= $rsp2d['kddept'];

								$kdunit		= $rsp2d['kdunit'];

								$tgsp2d		= $rsp2d['tgsp2d'];

								$kdsatker	= $rsp2d['kdsatker'];

								$nokarwas	= $rsp2d['nokarwas'];

								$kddekon	= $rsp2d['kddekon'];

								$kdunik		= "$kdjendok.$kddept.$kdunit.$kddekon.$nokarwas";

								

						

						echo "<tr bgcolor='$color'>

								<td>$no</td>

								<td><b>$nosp2d</b></td>

								<td>$kdunik</td>

								<td>$kdsatker</td>

								<td>$nospm</td>

								<td>$tgspm</td>

								<td>

										<input type='file' name='fupload$no' />

										<input type='hidden' name='nosp2d$no' value='$nosp2d' />

								</td>

							</tr>";

						$no++;

					}

					$jdata	= $no-1;

					echo "<tr bgcolor='#AADD77'>

							<td colspan='8'>

							</td>

						</tr>

						</table>

							<input type='hidden' name='tgsp2d' value='$tgsp2d' />

							<input type='hidden' name='kddept' value='$kddept' />

							<input type='hidden' name='jdata' value='$jdata' />

							<input type='submit' class='normaltablesubmit' name='uploadbutton' value='Upload' />

						</form>

						</div>

						<div class='spacer'></div>

					</form>";

}



// Modul Upload Nama Arsip Hasil Scan SP2D -----------------------------------------------------------------------------------//

elseif($_POST['uploadbutton'] == "Upload"){

	$n	= $_POST['jdata'];

	$tgsp2d	= $_POST['tgsp2d'];

	$kddept= $_POST['kddept'];

	for($i=1; $i<=$n; $i++){

	

				$nosp2d	= $_POST['nosp2d'.$i];

				$lokasi_file	=$_FILES['fupload'.$i]['tmp_name'];

				$nama_file	=$_FILES['fupload'.$i]['name'];

				// Setting untuk Unix/Linux, untuk windows silakan disesuaikan

				$direktori	='file/'.basename($nama_file);

				

				

					move_uploaded_file($lokasi_file,$direktori);

					mysql_query("UPDATE d_arsipsp2d SET file='$nama_file' WHERE nosp2d='$nosp2d'");

					echo "<script type='text/javascript'>

							window.location.href='media.php?module=insertnorak&tgsp2d=$tgsp2d&kddept=$kddept';

					</script>";

	}

}

// Modul Pilih No. Rak, Baris, Box Arsip SP2D -----------------------------------------------------------------------------------//

elseif($_GET['module']=='insertnorak' && $_GET['tgsp2d'] && $_GET['kddept']){

	$tgsp2d		= $_GET['tgsp2d'];

	$kddept	= $_GET['kddept'];

	$qnmba	= mysql_query("SELECT nmdept FROM t_dept WHERE kddept='$kddept'")or die(mysql_error());

	$rnmba		= mysql_fetch_array($qnmba);

	$nmba		= $rnmba['nmdept'];

	echo "<div id='stylized' class='myform'>

			<form id='form' name='formShowNoRakArsip' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

			<h1>Form entri data arsip SP2D</h1> 

					<p>Tahap 4 - Pilih rak, baris, dan box untuk arsip SP2D</p>

					<h3>Tanggal SP2D : $tgsp2d

					<br />

					Kementerian : $nmba</h3>

					

					</div>

					<br />	

					<div id='normaltable'>

					<table class='normaltable'>

					<tr>

							<th>No.</th>

							<th>No. SP2D</th>

							<th>Kode Unik</th>

							<th>Satker</th>

							<th>No. SPM</th>

							<th>Tgl. SPM</th>

							<th>No. Rak</th>

							<th>No. Baris</th>

							<th>No. Box</th>

						</tr>";

			$qsp2d	= mysql_query("SELECT DISTINCT * FROM d_arsipsp2d  WHERE tgsp2d='$tgsp2d' AND kddept='$kddept' AND (norak='' OR nobaris='' OR nobox='')")or die(mysql_error());

			$no	= 1;

			$oddcol		= "#CCFF99";

			$evencol		= "#CCDD88";

			while($rsp2d	= mysql_fetch_array($qsp2d)){

				if($no % 2 == 0) {$color = $evencol;}

				else{$color = $oddcol;}

				$nosp2d	= $rsp2d['nosp2d'];

				$nospm	= $rsp2d['nospm'];

				$tgspm		= $rsp2d['tgspm'];

				$kdjendok	= $rsp2d['kdjendok'];

				$kddept	= $rsp2d['kddept'];

				$kdunit		= $rsp2d['kdunit'];

				$tgsp2d		= $rsp2d['tgsp2d'];

				$kdsatker	= $rsp2d['kdsatker'];

				$nokarwas	= $rsp2d['nokarwas'];

				$kddekon	= $rsp2d['kddekon'];

				$kdunik		= "$kdjendok.$kddept.$kdunit.$kddekon.$nokarwas";

				

				

					echo "<tr bgcolor='$color'>

							<td>$no</td>

							<td>$nosp2d</td>

							<td>$kdunik</td>

							<td>$kdsatker</td>

							<td>$nospm</td>

							<td>$tgspm</td>

							<td>

								<select name='norak$no'>";

									$qnorak	= mysql_query("SELECT DISTINCT norak FROM r_nomorarsipsp2d WHERE kddept='$kddept' ORDER BY norak")or die(mysql_error());

									echo "<option value='' selected='selected'>--No. Rak--</option>";

									while($rnorak	= mysql_fetch_array($qnorak)){

										 $norak		= $rnorak['norak'];

										echo "<option value='$norak'>$norak</option>";

									}

							echo "</select>

							</td>

							<td>

								<select name='nobaris$no'>";

									$qnobaris	= mysql_query("SELECT DISTINCT nobaris FROM r_nomorarsipsp2d WHERE kddept='$kddept' ORDER BY nobaris")or die(mysql_error());

									echo "<option value='' selected='selected'>--No. Baris--</option>";

									while($rnobaris	= mysql_fetch_array($qnobaris)){

										$nobaris	= $rnobaris['nobaris'];

										echo "<option value='$nobaris'>$nobaris</option>";

									}

							echo "</select>

							</td>

							<td>

								<select name='nobox$no'>";

									$qnobox	= mysql_query("SELECT DISTINCT nobox FROM r_nomorarsipsp2d WHERE kddept='$kddept' ORDER BY nobox")or die(mysql_error());

									echo "<option value='' selected='selected'>--No. Box--</option>";

									while($rnobox	= mysql_fetch_array($qnobox)){

										$nobox		= $rnobox['nobox'];

										echo "<option value='$nobox'>$nobox</option>";

									}

							echo "</select>

							</td>

							<input type='hidden' name='nosp2d$no' value='$nosp2d' />";

				$no++;

			}

			$jdata	= $no-1;

			echo "<tr>

					<td colspan='9'>

					<input type='hidden' name='jdata' value='$jdata' />

					<input type='submit' class='normaltablesubmit' name='insertTobox' value='Simpan' />

					</td>

					</table>

			<div class='spacer'></div>

		</form>

		</div>";

	}

// Modul Entri Arsip SP2D -----------------------------------------------------------------------------------//

elseif($_POST['insertTobox'] == "Simpan"){

	$n	= $_POST['jdata'];

	for($i=1; $i<=$n; $i++){

		$nosp2d	= $_POST['nosp2d'.$i];

		echo $nosp2d."<br />";

		$norak		= $_POST['norak'.$i];

		echo $norak."<br />";

		$nobaris	= $_POST['nobaris'.$i];

		echo $nobaris."<br />";

		$nobox		= $_POST['nobox'.$i];

		echo $nobox."<br />";

		

		mysql_query("UPDATE d_arsipsp2d SET norak='$norak', nobaris='$nobaris', nobox='$nobox' WHERE nosp2d='$nosp2d'");

		

		echo "<script type='text/javascript'>

				window.location.href='media.php?module=insertarsip';

		</script>";

		

	}

}





// Modul Form Search Arsip =======================================================================================//

elseif($_GET['module']=='searcharsip'){

	echo "<script type=\"text/javascript\">

			$(document).ready(function() {

					$('#tanggal').datepicker();

			});

		</script>

			<div id='stylized' class='myform'>

			<form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

			<h1>Form multikategori pencarian data dokumen arsip</h1>

			<p>Form ini digunakan dalam pencarian data dokumen arsip</p>

					

			<label>Bagian Anggaran</label>

			<input type='checkbox' class='checkbox' name='kddeptCek' />

			<input type='text' id='kddept' minlength='3' name='kddept' maxlength='3' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'tanggal')\" />

	

			<label>Tgl. SP2D</label>

			<input type='checkbox' class='checkbox' name='tgsp2dCek' />

			<input type='text' id='tanggal' name='tgsp2d' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'nosp2d')\" />

					

			<label>Nomor SP2D</label>

			<input type='checkbox' class='checkbox' name='nosp2dCek' />

			<input type='text' id='nosp2d' name='nosp2d'  maxlength='7' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'kdsatker')\" />

					

			<label>Kode Satker</label>

			<input type='checkbox' class='checkbox' name='kdsatkerCek' />

			<input type='text' id='kdsatker' name='kdsatker' maxlength='6' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'nospm')\" />

			

			<label>Nomor SPM</label>

			<input type='checkbox' class='checkbox' name='nospmCek' />

			<input type='text' id='nospm' name='nospm' maxlength='5' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'norak')\" />

					

			<label>Nomor Rak</label>

			<input type='checkbox' class='checkbox'  name='norakCek' />

			<input type='text' id='norak' name='norak' maxlength='4' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'nobaris')\" />

										

			<label>Nomor Baris</label>

			<input type='checkbox' class='checkbox' name='nobarisCek' />

			<input type='text' id='nobaris' name='nobaris' maxlength='4' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'nobox')\" />

								

			<label>Nomor Box</label>

			<input type='checkbox' class='checkbox' name='noboxCek' />

			<input type='text' id='nobox' name='nobox' maxlength='5' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />

			

			<input type='submit' value='Cari' class='button' id='submit' name='cariDoksp2d' />

			<div class='spacer'></div>

			</form>

			</div>";

}



// Modul  Search Arsip SP2D----------------------------------------------------------------------------------------------------------------------------------------------//

elseif($_POST['cariDoksp2d'] == "Cari"){

	$kddeptCek		= $_POST['kddeptCek'];

	$tgsp2dCek		= $_POST['tgsp2dCek'];

	$nosp2dCek	= $_POST['nosp2dCek'];

	$kdsatkerCek	= $_POST['kdsatkerCek'];

	$nospmCek		= $_POST['nospmCek'];

	$norakCek		= $_POST['norakCek'];

	$nobarisCek	= $_POST['nobarisCek'];

	$noboxCek		= $_POST['noboxCek'];

	$Kddept		= $_POST['kddept'];

	$kddept		= sprintf("%03s",$Kddept);

	$TgSp2d		= $_POST['tgsp2d'];

	$Tgsp2d		= explode("/",$TgSp2d);

	$TgSP2D		= $Tgsp2d[0];

	$BlSP2D		= $Tgsp2d[1];

	$ThSP2D		= $Tgsp2d[2];

	$tgsp2d			= $ThSP2D."-".$BlSP2D."-".$TgSP2D;

	$nosp2d		= $_POST['nosp2d'];

	$kdsatker		= $_POST['kdsatker'];

	

	$Nospm		= $_POST['nospm'];

	$nospm		= sprintf("%05s",$Nospm);

	

	$Norak			= $_POST['norak'];

	$norak			= sprintf("%04s",$Norak);

	

	$Nobaris		= $_POST['nobaris'];

	$nobaris		= sprintf("%04s",$Nobaris);

	

	$Nobox			= $_POST['nobox'];

	$nobox			= sprintf("%05s",$Nobox);

	

	$bagianWhere="";

	

	if(isset($kddeptCek)){

		$kddept;

		if(empty($bagianWhere)){

			$bagianWhere .= "kddept='$kddept'";

		}

	}

	if(isset($tgsp2dCek)){

		if(empty($bagianWhere)){

			$bagianWhere .= "tgsp2d='$tgsp2d'";

		}

		else{

			$bagianWhere .= "AND tgsp2d='$tgsp2d'";

		}

	}

	if(isset($nosp2dCek)){

		if(empty($bagianWhere)){

			$bagianWhere .= "nosp2d='$nosp2d'";

		}

		else{

			$bagianWhere .= "AND nosp2d='$nosp2d'";

		}

	}

	if(isset($kdsatkerCek)){

		if(empty($bagianWhere)){

			$bagianWhere .= "kdsatker='$kdsatker'";

		}

		else{

			$bagianWhere .= "AND kdsatker='$kdsatker'";

		}

	}

	if(isset($nospmCek)){

		if(empty($bagianWhere)){

			$bagianWhere .= "nospm='$nospm'";

		}

		else{

			$bagianWhere .= "AND nospm='$nospm'";

		}

	}

	if(isset($norakCek)){

		if(empty($bagianWhere)){

			$bagianWhere .= "norak='$norak'";

		}

		else{

			$bagianWhere .= "AND norak='$norak'";

		}

	}

	if(isset($nobarisCek)){

		if(empty($bagianWhere)){

			$bagianWhere .= "nobaris='$nobaris'";

		}

		else{

			$bagianWhere .= "AND nobaris='$nobaris'";

		}

	}

	if(isset($noboxCek)){

		if(empty($bagianWhere)){

			$bagianWhere .= "nobox LIKE '%$nobox%' OR nobox2 LIKE '%$nobox%'";

		}

		else{

			$bagianWhere .= "AND (nobox LIKE '%$nobox%' OR nobox2 LIKE '%$nobox%')";

		}

	}

	

	$queryCek	= "SELECT * FROM d_arsipsp2d WHERE ".$bagianWhere;

	$qCek		= mysql_query($queryCek)or die(mysql_error());

	$rCek		= mysql_fetch_row($qCek);

	

	if($rCek > 0){

		

		echo "<div id='stylized' class='myform'>

				<form id='form' name='formShowNoRakArsip' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

				<h1>Form hasil pencarian data arsip SP2D</h1> 

					<p>Hasil pencarian rak, baris, dan box untuk arsip SP2D</p>

					</form>

					</div>

					<br />	

					<table class='normaltable' border='0' cellpadding='2'>

					<tr>

					<th width='6%'>No.</th>

					<th width='10%'>No. SP2D</th>

					<th width='14%'>Tgl. SP2D</th>

					<th width='8%'>No. SPM</th>

					<th width='14%'>Tgl. SPM</th>

					<th width='12%'>Kode Unik</th>

					<th width='8%'>Satker</th>

					<th width='8%'>No. Rak</th>

					<th width='8%'>No. Baris</th>

					<th width='8%'>No. Box</th>

					<th width='10%'>File</th>

					<th colspan='2'>Tindakan</th>

					</tr>";

			

			$query		= "SELECT * FROM d_arsipsp2d WHERE ".$bagianWhere;

			$qCari		= mysql_query($query)or die(mysql_error());

			$no	= 1;

			$oddcol		= "#CCFF99";

			$evencol		= "#CCDD88";

			while($rCari		= mysql_fetch_array($qCari)){

				if($no % 2 == 0) {$color = $evencol;}

				else{$color = $oddcol;}

						$nosp2d	= $rCari['nosp2d'];

						$tgsp2d		= $rCari['tgsp2d'];

						$kdjendok	= $rCari['kdjendok'];

						$kddept	= $rCari['kddept'];

						$kdunit		= $rCari['kdunit'];

						$kdsatker	= $rCari['kdsatker'];

						$nokarwas	= $rCari['nokarwas'];

						$kddekon	= $rCari['kddekon'];

						$nospm	= $rCari['nospm'];

						$tgspm		= $rCari['tgspm'];

						$norak		= $rCari['norak'];

						$nobaris	= $rCari['nobaris'];

						$nobox		= $rCari['nobox'];

						$nobox2		= $rCari['nobox2'];

						$file		= $rCari['file'];

						$kdunik		= "$kdjendok.$kddept.$kdunit.$kddekon.$nokarwas";

					

						echo"<tr bgcolor='$color'>

								<td>$no</td>

								<td>$nosp2d</td>

								<td>$tgsp2d</td>

								<td>$nospm</td>

								<td>$tgspm</td>

								<td>$kdunik</td>

								<td>$kdsatker</td>

								<td><b><font color='#0000FF'>$norak</font></b></td>

								<td><b><font color='#D40103'>$nobaris</font></b></td>";

								if($nobox == "")

								{

									echo "<td><b><font color='#62079B'>$nobox2</font></b></td>";

								}

								else

								{

									echo "<td><b><font color='#62079B'>$nobox</font></b></td>";

								}

								echo "

								<td><b><i><a href='file/$file' target='_blank'>$file</a></b></i></td>

								<td>

									<form method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

										<input type='hidden' name='nosp2d' value='$nosp2d' />

										<input type='submit' class='normaltablesubmit' name='editDataBox' value='Edit' />

									</form>

								</td>

							</tr>";

						$no++;

						}

						echo"</table>";

					

	}

	else{

				echo "<script type='text/javascript'>

						alert('Data tersebut tidak ditemukan');

				</script>";			

	}

}	



//Modul Form Edit Data Dokumen SP2D ========================================================================//

elseif($_POST['editDataBox'] == 'Edit'){

	$nosp2d	= $_POST['nosp2d'];

	$qEdit		= mysql_query("SELECT * FROM d_arsipsp2d WHERE nosp2d='$nosp2d'");

	$rEdit		= mysql_fetch_array($qEdit);

		

	$kddept		= $rEdit['kddept'];

	$tgsp2d		= $helper->dateConvert($rEdit['tgsp2d']);

	$kdsatker	= $rEdit['kdsatker'];

	$nospm		= $rEdit['nospm'];

	$norak		= $rEdit['norak'];

	$nobaris	= $rEdit['nobaris'];

	$nobox		= $rEdit['nobox'];

	$Nobox2		= explode("-",$rEdit['nobox2']);

	$nobox2		= $Nobox2[1];

	$file		= $rEdit['file'];

	

	echo"<style type='text/css'>

			em { font-weight: bold; padding-right: 1em; vertical-align: top; }

		</style>

			<script>

			$(document).ready(function(){

				$('#form').validate();

			});

			</script>

					<div id='stylized' class='myform'>

					<form id='form' name='form' method='post' enctype='multipart/form-data' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

					<h1>Form edit data nomor rak, baris, box, dan file arsip SP2D</h1>

					<p>Form ini digunakan dalam melakukan perubahan data nomor rak, baris, box, dan file dokumen arsip</p>

							

					<label>Kode BA

					<span class='small'>Tidak dapat diubah</span>

					</label>

					<input type='text' id='kddept' minlength='3' name='kddept' maxlength='3' value='$kddept' readonly='readonly' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'tgsp2d')\" />

	

					<label>Tanggal SP2D

					<span class='small'>Tidak dapat diubah</span>

					</label>

					<input type='text' id='tgsp2d' name='tgsp2d'  value='$tgsp2d' readonly='readonly' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'nosp2d')\" />

					

					<label>Nomor SP2D

					<span class='small'>Tidak dapat diubah</span>

					</label>

					<input type='text' id='nosp2d' name='nosp2d'  value='$nosp2d' readonly='readonly' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'nospm')\" />

					

					<label>Nomor SPM

					<span class='small'>Tidak dapat diubah</span>

					</label>

					<input type='text' id='nospm' name='nospm' value='$nospm' readonly='readonly' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'kdsatker')\" />

							



					<label>Kode Satker

					<span class='small'>Tidak dapat diubah</span>

					</label>

					<input type='text' id='kdsatker' name='kdsatker' value='$kdsatker' readonly='readonly' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'norak')\" />

					

					<label>Nomor Rak

					<span class='small'>Dapat diubah</span>

					</label>

					<select name='norak'>";

					$qnorak	= mysql_query("SELECT DISTINCT norak FROM r_nomorarsipsp2d WHERE kddept='$kddept' AND norak!='$norak' ORDER BY norak")or die(mysql_error());

					echo "<option value='$norak' selected='selected'>$norak</option>";

					while($rnorak	= mysql_fetch_array($qnorak)){

						$norak		= $rnorak['norak'];

						echo "<option value='$norak'>$norak</option>";

					}

					echo "</select>

					

					<label>Nomor Baris

					<span class='small'>Dapat diubah</span>

					</label>

					<select name='nobaris'>";

					$qnobaris	= mysql_query("SELECT DISTINCT nobaris FROM r_nomorarsipsp2d WHERE kddept='$kddept' AND nobaris!='$nobaris' ORDER BY nobaris")or die(mysql_error());

					echo "<option value='$nobaris' selected='selected'>$nobaris</option>";

					while($rnobaris	= mysql_fetch_array($qnobaris)){

						$nobaris	= $rnobaris['nobaris'];

						echo "<option value='$nobaris'>$nobaris</option>";

					}

					echo "</select>

							

					<label>Nomor Box

					<span class='small'>Dapat diubah</span>

					</label>

					<select name='nobox'>";

					$qnobox	= mysql_query("SELECT DISTINCT nobox FROM r_nomorarsipsp2d WHERE kddept='$kddept' AND nobox!='$nobox' ORDER BY nobox")or die(mysql_error());

					echo "<option value='$nobox' selected='selected'>$nobox</option>";

					while($rnobox	= mysql_fetch_array($qnobox)){

						$nobox		= $rnobox['nobox'];

						echo "<option value='$nobox'>$nobox</option>";

					}

					echo "</select>

					

					<label>Nomor Box Metode 2

					<span class='small'>Dapat diubah</span>

					</label>

					<input type='text' id='nobox2' name='nobox2' value='$nobox2' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'file')\" />

					

					<label>File Upload

					<span class='small'>Dapat diubah, apabila tidak berubah biarkan kosong</span>

					</label>

					<input type='file' id='file' name='file' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />

									

					<input type='submit' value='Update' class='button' id='submit' name='Updatedataarsip' />

					<div class='spacer'></div>

					</form>

					</div>";

}



// Modul Update Data Nomor Rak, Baris, Box, dan File Arsip SP2D ----------------------------------------------------------------------------------------//

elseif($_POST['Updatedataarsip'] == 'Update'){

	$nosp2d			= $_POST['nosp2d'];

	$tgsp2d			= $helper->dateConvert($_POST['tgsp2d']);

	$tgsp2d			= str_replace("-","",$tgsp2d);

	$norak			= $_POST['norak'];

	$nobaris		= $_POST['nobaris'];

	$nobox			= $_POST['nobox'];

	$nobox2			= sprintf("%05s",$_POST['nobox2']);

	$nobox2			= $tgsp2d."-".$nobox2;

	$lokasi_file	= $_FILES['file']['tmp_name'];

	$nama_file		= $_FILES['file']['name'];

	// Setting untuk Unix/Linux, untuk windows silakan disesuaikan

	$direktori	='file/'.basename($nama_file);

	if(empty($nama_file)){			

		mysql_query("UPDATE d_arsipsp2d SET norak='$norak', nobaris='$nobaris', nobox='$nobox', nobox2='$nobox2'  WHERE nosp2d='$nosp2d'");

		echo "<script type='text/javascript'>

				alert('Nomor SP2D $nosp2d telah dilakukan perubahan data arsipnya dengan nomor rak $norak, nomor baris $nobaris, nomor box $nobox, atau nomor box metode 2 $nobox2!');

				window.location.replace('media.php?module=home');

		</script>";

	}	

	else{

		move_uploaded_file($lokasi_file,$direktori);

		mysql_query("UPDATE d_arsipsp2d SET file='$nama_file', norak='$norak', nobaris='$nobaris', nobox2='$nobox2',nobox='$nobox'  WHERE nosp2d='$nosp2d'");

		echo "<script type='text/javascript'>

				alert('Nomor SP2D $nosp2d telah dilakukan perubahan data arsipnya dengan nomor rak $norak, nomor baris $nobaris, nomor box $nobox, atau nomor box metode 2 $nobox2!');

				window.location.replace('media.php?module=home');

			</script>";

	}

}



// Modul Insert Arsip Metode 2 ===============================================================================//

elseif($_GET['module'] == 'insertarsip2')

{

	echo "

	<style type='text/css'>

			em { font-weight: bold; padding-right: 1em; vertical-align: top; }

	</style>

	<script>

			$(document).ready(function(){

				$('#form').validate();

			});

	</script>

	<div id='stylized' class='myform'>

				<form id='form' name='formInsertArsip' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

				<h1>Form entri data arsip SP2D Metode II</h1> 

				<p>Tahap 1 - Entri Nomor SP2D</p>";

					$q 		= "SELECT MAX(nobox2) AS maxNobox FROM d_arsipsp2d LIMIT 1";

					$qMaxNo	= mysql_query($q);

					$rMaxNo	= mysql_fetch_object($qMaxNo);

					$NewMaxNo = $rMaxNo->maxNobox;

					if($NewMaxNo == 0)

					{

						$newMaxNo = sprintf("%05s",++$NewMaxNo);

					}

					else

					{

						$explNewMaxNo	= explode("-",$NewMaxNo);

						$newMaxNo 		= $explNewMaxNo[1];

					}

				echo "

					Nomor Box Terakhir Yang Digunakan: 

					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

					<font color='#404040' size='4'><b>".$newMaxNo."</b></font>  		 			

  		 			<br />

  		 			<br />

  		 			<label>Nomor SP2D 

  		 			<span class='small'>Isikan nomor SP2D</span>

					</label> 

					<input type='hidden' name='nobox' value='$newMaxNo' />

  		 			<input id=\"nosp2d\" class=\"required\" name=\"nosp2d\" type=\"text\" minlength='7' maxlength='7' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit2')\" autofocus='autofocus' />

  		 			

  	 				<input id='submit2' name='InsertNoSP2D' type='submit' value='No.Box Lama' class='button1'>

  	 				<input id='submit3' name='InsertNoSP2D' type='submit' value='Ambil No.Box' class='button1'>

					<div class='spacer'></div>

  	 			</form>

  	 			</div>";

}



// Modul Penambahan No.Box Baru dan Validasi Nomor SP2D ----------------------------------------------------//

elseif($_POST['InsertNoSP2D'] == 'Ambil No.Box')

{

	echo "<script type='text/javascript'>

			$(document).ready(function() {

				$('#promptkonfirmasi').dialog({

					modal: true

				});

			});

	</script>";

	// casting to integer

	$nobox	= (int) $_POST['nobox'];

	$nobox++;

	$nobox	= sprintf("%05s",$nobox);

	$nosp2d	= strtoupper($_POST['nosp2d']);

	// query for checking existence data

	$q	 	= "SELECT nosp2d FROM d_arsipsp2d WHERE nosp2d='$nosp2d' LIMIT 1";

	$qCek	= mysql_query($q);

	$rCek	= mysql_num_rows($qCek);

	if($rCek == 0)

	{

		echo "

		<div id='promptkonfirmasi' title='informasi'>

			<br />

			<center>

			<b><font color='#FFFFFF' size='4'>Data tersebut tidak ada</font></b>

			<br />

			<br />

			<form id='form' name='formIKembaliArsip2' method='get' action='".htmlentities($_SERVER['PHP_SELF'])."'>

			<input type='hidden' name='module' value='insertarsip2' />

			<input type='submit' name='btnClose' value='Kembali' />

			</form>

			</center>

		</div>";

	}

	else

	{

		$q 		= "SELECT kddept,kdunit,kdsatker,kddekon,nosp2d,tgsp2d,nospm,tgspm FROM d_arsipsp2d WHERE nosp2d='$nosp2d' LIMIT 1";

		$qSp2d		= mysql_query($q);

		$rSp2d		= mysql_fetch_object($qSp2d);

		$kddept		= $rSp2d->kddept;

		$kdsatker	= $rSp2d->kdsatker;

		$kddekon	= $rSp2d->kddekon;

		$nosp2d		= $rSp2d->nosp2d;

		$tgsp2d		= $helper->dateConvert($rSp2d->tgsp2d);

		$newtgsp2d	= str_replace("-","",$rSp2d->tgsp2d);

		$nospm		= $rSp2d->nospm;

		$tgspm		= $helper->dateConvert($rSp2d->tgspm);

		echo"<style type='text/css'>

			em { font-weight: bold; padding-right: 1em; vertical-align: top; }

		</style>

			<script>

			$(document).ready(function(){

				$('#form').validate();

			});

			</script>

					<div id='stylized' class='myform'>

					<form id='form' name='frmEntriarsip' method='post' enctype='multipart/form-data' action='".htmlentities($_SERVER['PHP_SELF'])."'>

					<h1>Form entri data gudang, nomor rak, baris, box, dan file arsip SP2D</h1>

					<p>Tahap 2 - Form ini digunakan dalam melakukan entri data gudang, nomor rak, baris, box, dan file dokumen arsip

						<h3>Data SP2D</h3>

					</p>

							

					<label>Kode BA

					<span class='small'>Tidak dapat diubah</span>

					</label>

					<input type='text' id='kddept' minlength='3' name='kddept' maxlength='3' value='$kddept' readonly='readonly' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'tgsp2d')\" />

	

					<label>Tanggal SP2D

					<span class='small'>Tidak dapat diubah</span>

					</label>

					<input type='text' id='tgsp2d' name='tgsp2d'  value='$tgsp2d' readonly='readonly' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'nosp2d')\" />

					

					<label>Nomor SP2D

					<span class='small'>Tidak dapat diubah</span>

					</label>

					<input type='text' id='nosp2d' name='nosp2d'  value='$nosp2d' readonly='readonly' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'tgspm')\" />

					

					<label>Tanggal SPM

					<span class='small'>Tidak dapat diubah</span>

					</label>

					<input type='text' id='tgspm' name='tgspm' value='$tgspm' readonly='readonly' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'nospm')\" />

							

					<label>Nomor SPM

					<span class='small'>Tidak dapat diubah</span>

					</label>

					<input type='text' id='nospm' name='nospm'  value='$nospm' readonly='readonly' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'kdsatker')\" />

					

					<label>Kode Satker

					<span class='small'>Tidak dapat diubah</span>

					</label>

					<input type='text' id='kdsatker' name='kdsatker' value='$kdsatker' readonly='readonly' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'gudang')\" />

					

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<p>

					<h3>Data Arsip</h3>

				</p>

				<br />

					<label>Nama Gudang

					<span class='small'>Nama Gudang</span>

					</label>

					<select id='gudang' name='gudang' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'norak')\">

						<option value='' selected='selected'>--Nama Gudang--</option>";

						$qG		= "SELECT nm_gudang,ket_gudang FROM r_gudang ORDER BY id_gudang ASC";

						$qGudang= mysql_query($qG);

						while($rGudang = mysql_fetch_object($qGudang))

						{

							echo "<option value='".$rGudang->nm_gudang."'>Gudang ".$rGudang->nm_gudang." - ".$rGudang->ket_gudang."</option>";

						}

					echo "

					</select>

					

					<label>Nomor Rak

					<span class='small'>Nomor Rak</span>

					</label>

					<input type='text' id='norak' name='norak' minlength='1' maxlength='4' class='required' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'nobaris')\" autofocus='autofocus'  />

					

					<label>Nomor Baris

					<span class='small'>Nomor Baris</span>

					</label>

					<input type='text' id='nobaris' name='nobaris' minlength='1' maxlength='4' class='required' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'nobox')\" />

							

					<label>Nomor Box

					<span class='small'>Nomor Box (Otomatis)</span>

					</label>

					<input type='text' id='nobox' name='nobox' minlength='1' maxlength='14' readonly='readonly' value='".$newtgsp2d."-".$nobox."'onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'file')\" style='font-weight:bold;color:blue;' />

					

					<label>File Upload

					<span class='small'>File yang di-upload</span>

					</label>

					<input type='file' id='file' name='file' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />

									

					<input type='submit' value='Simpan' class='button' id='submit' name='Insertdataarsip2' />

					<div class='spacer'></div>

					</form>

					</div>";

	}

}



// Modul Simpan Arsip2 ------------------------------------------------------------------------------------//

elseif($_POST['Insertdataarsip2'] == 'Simpan')

{

	echo "<script type='text/javascript'>

			$(document).ready(function() {

				$('#promptkonfirmasi').dialog({

					modal: true

				});

			});

	</script>";

	$gudang		= $_POST['gudang'];

	if($gudang == "")

	{

		echo "

		<div id='promptkonfirmasi' title='Informasi'>

			<br />

			<center>

			<b><font color='#FFFFFF' size='4'>Anda belum memilih gudang</font></b>

			<br />

			<br />

			<form id='form' name='formIKembaliArsip2' method='get' action='".htmlentities($_SERVER['PHP_SELF'])."'>

			<input type='hidden' name='module' value='insertarsip2' />

			<input type='submit' name='btnClose' value='Kembali' />

			</form>

			</center>

		</div>";

	}

	else

	{

		$nosp2d 		= $_POST['nosp2d'];

		$norak			= sprintf("%04s",$_POST['norak']);

		$nobaris		= sprintf("%04s",$_POST['nobaris']);

		$nobox			= $_POST['nobox'];

		

		

		$lokasi_file	= $_FILES['file']['tmp_name'];

		$nama_file		= $_FILES['file']['name'];

		// Setting untuk Unix/Linux, untuk windows silakan disesuaikan

		$direktori		= 'file/'.basename($nama_file);



		// move files from temporary to directory

		move_uploaded_file($lokasi_file,$direktori);

		// update d_arsipsp2d

		$qSp2d		= "UPDATE d_arsipsp2d SET gudang='$gudang',norak='$norak',nobaris='$nobaris',nobox2='$nobox',file='$nama_file' WHERE nosp2d='$nosp2d'";

		mysql_query($qSp2d);

		// result checking

		$qCek		= mysql_query("SELECT gudang FROM d_arsipsp2d WHERE nosp2d='$nosp2d' LIMIT 1");

		$rCek		= mysql_num_rows($qCek);

		if($rCek == 0)

		{

			echo "

			<div id='promptkonfirmasi' title='Informasi'>

				<br />

				<center>

				<b><font color='#FFFFFF' size='4'>Data gagal disimpan</font></b>

				<br />

				<br />

				<form id='form' name='formIKembaliArsip2' method='get' action='".htmlentities($_SERVER['PHP_SELF'])."'>

				<input type='hidden' name='module' value='insertarsip2' />

				<input type='submit' name='btnClose' value='Kembali' />

				</form>

				</center>

			</div>";

		}

		else

		{

				echo "

				<div id='promptkonfirmasi' title='Informasi'>

					<br />

					<center>

					<b><font color='#FFFFFF' size='4'>Data berhasil disimpan</font></b>

					<br />

					<br />

					<form id='form' name='formIKembaliArsip2' method='get' action='".htmlentities($_SERVER['PHP_SELF'])."'>

					<input type='hidden' name='module' value='insertarsip2' />

					<input type='submit' name='btnClose' value='Kembali' />

					</form>

					</center>

				</div>";

		}

	}

}



// Modul No.Box Lama dan Validasi Nomor SP2D --------------------------------------------------------------//

elseif($_POST['InsertNoSP2D'] == 'No.Box Lama')

{

	echo "<script type='text/javascript'>

			$(document).ready(function() {

				$('#promptkonfirmasi').dialog({

					modal: true

				});

			});

	</script>";	

	$nobox	= $_POST['nobox'];

	$nosp2d	= strtoupper($_POST['nosp2d']);

	// query for checking existence data

	$q	 	= "SELECT nosp2d FROM d_arsipsp2d WHERE nosp2d='$nosp2d' LIMIT 1";

	$qCek	= mysql_query($q);

	$rCek	= mysql_num_rows($qCek);

	if($rCek == 0)

	{

		echo "

		<div id='promptkonfirmasi' title='informasi'>

			<br />

			<center>

			<b><font color='#FFFFFF' size='4'>Data tersebut tidak ada</font></b>

			<br />

			<br />

			<form id='form' name='formIKembaliArsip2' method='get' action='".htmlentities($_SERVER['PHP_SELF'])."'>

			<input type='hidden' name='module' value='insertarsip2' />

			<input type='submit' name='btnClose' value='Kembali' />

			</form>

			</center>

		</div>";

	}

	else

	{

		$q 		= "SELECT kddept,kdunit,kdsatker,kddekon,nosp2d,tgsp2d,nospm,tgspm FROM d_arsipsp2d WHERE nosp2d='$nosp2d' LIMIT 1";

		$qSp2d		= mysql_query($q);

		$rSp2d		= mysql_fetch_object($qSp2d);

		$kddept		= $rSp2d->kddept;

		$kdsatker	= $rSp2d->kdsatker;

		$kddekon	= $rSp2d->kddekon;

		$nosp2d		= $rSp2d->nosp2d;

		$tgsp2d		= $helper->dateConvert($rSp2d->tgsp2d);

		$newtgsp2d	= str_replace("-","",$rSp2d->tgsp2d);

		$nospm		= $rSp2d->nospm;

		$tgspm		= $helper->dateConvert($rSp2d->tgspm);

		echo"<style type='text/css'>

			em { font-weight: bold; padding-right: 1em; vertical-align: top; }

		</style>

			<script>

			$(document).ready(function(){

				$('#form').validate();

			});

			</script>

					<div id='stylized' class='myform'>

					<form id='form' name='frmEntriarsip' method='post' enctype='multipart/form-data' action='".htmlentities($_SERVER['PHP_SELF'])."'>

					<h1>Form entri data gudang, nomor rak, baris, box, dan file arsip SP2D</h1>

					<p>Tahap 2 - Form ini digunakan dalam melakukan entri data gudang, nomor rak, baris, box, dan file dokumen arsip

						<h3>Data SP2D</h3>

					</p>

							

					<label>Kode BA

					<span class='small'>Tidak dapat diubah</span>

					</label>

					<input type='text' id='kddept' minlength='3' name='kddept' maxlength='3' value='$kddept' readonly='readonly' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'tgsp2d')\" />

	

					<label>Tanggal SP2D

					<span class='small'>Tidak dapat diubah</span>

					</label>

					<input type='text' id='tgsp2d' name='tgsp2d'  value='$tgsp2d' readonly='readonly' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'nosp2d')\" />

					

					<label>Nomor SP2D

					<span class='small'>Tidak dapat diubah</span>

					</label>

					<input type='text' id='nosp2d' name='nosp2d'  value='$nosp2d' readonly='readonly' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'tgspm')\" />

					

					<label>Tanggal SPM

					<span class='small'>Tidak dapat diubah</span>

					</label>

					<input type='text' id='tgspm' name='tgspm' value='$tgspm' readonly='readonly' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'nospm')\" />

							

					<label>Nomor SPM

					<span class='small'>Tidak dapat diubah</span>

					</label>

					<input type='text' id='nospm' name='nospm'  value='$nospm' readonly='readonly' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'kdsatker')\" />

					

					<label>Kode Satker

					<span class='small'>Tidak dapat diubah</span>

					</label>

					<input type='text' id='kdsatker' name='kdsatker' value='$kdsatker' readonly='readonly' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'gudang')\" />

					

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<br />

				<p>

					<h3>Data Arsip</h3>

				</p>

				<br />

					<label>Nama Gudang

					<span class='small'>Nama Gudang</span>

					</label>

					<select id='gudang' name='gudang' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'norak')\">

						<option value='' …