<?php
//	$cabang=$_SESSION['login_cabang'];
	
//	if(!isset($_SESSION['login_user'])){
//		header('location: ../../login.php'); // Mengarahkan ke Home Page
//	}

	if(isset($_SESSION['pelanggan']) AND $_SESSION['pelanggan'] <> 'TRUE')
	{
		echo"<div class='w3-container w3-red'><p>Dilarang mengakses file ini.</p></div>";
		die();
	}

	//link buat paging
	$linkaksi = 'med.php?mod=pelanggan';

	if(isset($_GET['act']))
	{
		$act = $_GET['act'];
		$linkaksi .= '&act='.$act;
	}
	else
	{
		$act = '';
	}
	
	$aksi = 'mod/pelanggan/act_pelanggan.php';

	switch ($act) {
		case 'form':
			if(!empty($_GET['id']))
			{
				$act = "$aksi?mod=pelanggan&act=edit";
				$query = mysql_query("SELECT * FROM customer WHERE custno = '$_GET[id]' and cabang='$cabang'");
				$temukan = mysql_num_rows($query);
				if($temukan > 0)
				{
					$c = mysql_fetch_assoc($query);
				}
				else
				{
					header("location:med.php?mod=pelanggan");
				}

			}
			else
			{
				$act = "$aksi?mod=pelanggan&act=simpan";
			}

			echo"<div class='w3-container w3-small w3-pale-green w3-leftbar w3-border-green'>
				<h4 style='margin-bottom:0;padding-bottom:0;'>Form Data Pelanggan</h4>
				<p style='margin-top:0;padding-top:0;'><i>Form Input Data Pelanggan</i></p>
			</div>";

			echo "
			<div class='w3-container w3-small w3-pale-green w3-leftbar w3-border-green'>
			<form method='POST' action='$act'>
					<table border='1' width='220px' cellpadding='0' cellspacing='3'>
					<tr>
						<td class='tdLabelForm'>Kode Pelanggan</td>
						<td class='tdLabelForm'>
							<input size='10' maxlength='20' type='text' name='id'  value='"?><?php echo isset($c['custno']) ?
							$c['custno'] : '';?><?php echo"'"?> <?php echo isset($c['custno']) ? ' readonly' : ' ';?><?php echo" required>
						</td>		
					</tr>
					
					<tr>
						<td class='tdLabelForm'>Nama Pelanggan</td>
						
						<td class='tdTextForm'>
							<input type='text' name='nama_pelanggan' value='"?><?php echo isset($c['custname']) ? $c['custname'] : '';?><?php echo"' size=50 maxlength=60 required>
						</td>
					</tr>
					<tr>
						<td class='tdLabelForm'>Tanggal</td>
						<td class='tdLabelForm'>
							<input type='date' name='tgl'  value='"?><?php echo isset($c['tgl']) ? $c['tgl'] : '';?><?php echo"' required size=10 maxlength=10>
						</td>								
					</tr>	
					<tr>
						<td class='tdLabelForm'>No. Telpon</td>
						<td class='tdTextForm'>
							<input type='text' name='nomor_telp'  value='"?><?php echo isset($c['nomor_telp']) ? $c['telp'] : '';?><?php echo"' size=15 maxlength=20 required></input>
						</td>
					</tr>
					<tr>
						<td class='tdLabelForm'>Alamat</td>
						<td class='tdTextForm'>
							<textarea cols='50' rows='2' type='text' name='alamat'  value='"?><?php echo isset($c['alamat1']) ? $c['alamat'] : '';?><?php echo"' required>  </textarea>
						</td>
					</tr>
					<tr>
						<td class='tdLabelForm'>Wilayah</td>
						<td class='tdTextForm'>
							<input type='text' name='type'  value='"?><?php echo isset($c['kdwil']) ? $c['kdwil'] : '';?><?php echo"' size=5 maxlength=10 required>
						</td>
						<tr>
						<td class='tdLabelForm'>Type Pelanggan</td>
						<td class='tdTextForm'>
							<input type='text' name='type'  value='"?><?php echo isset($c['typecust']) ? $c['typecust'] : '';?><?php echo"' size=5 maxlength=10 required>
						</td>
					</tr>
					<tr>
						<td class='tdLabelForm'>Teknisi 1</td>
						<td class='tdTextForm'>
							<input type='text' name='teknisi'  value='"?><?php echo isset($c['kdslm']) ? $c['kdslm1'] : '';?><?php echo"' size=5 maxlength=10 required>
						</td>
					</tr>
					<tr>		
						<td class='tdLabelForm'>Teknisi 2</td>
						<td class='tdTextForm'>
								<input type='text' name='teknisi1'  value='"?><?php echo isset($c['kdslm1']) ? $c['kdslm1'] : '';?><?php echo"' size=5 maxlength=10  required>
						</td>
					</tr>
					<tr>		
						<td class='tdLabelForm'>Teknisi 3</td>
						<td class='tdTextForm'>
							<input type='text' name='teknisi2'  value='"?><?php echo isset($c['kdslm1']) ? $c['kdslm1'] : '';?><?php echo"' size=5 maxlength=10 required>
						</td>
					</tr>
					<tr>		
						<td class='tdLabelForm'>Status</td>
						<td class='tdTextForm'>
							<input type='text' name='status'   value='"?><?php echo isset($c['statusbaru']) ? $c['statusbaru'] : '';?><?php echo"' size=5 maxlength=10 required>
						</td>
					</tr>
					
					<tr>
						<td>&nbsp;</td>
						<td>&nbsp;</td>
						<td align='right'><button type='submit' name='submit' value='simpan' class='w3-btn'><i class='fa fa-save'></i> Simpan Data</button>&nbsp;

						<button type='button' class='w3-btn w3-orange' onclick='history.back()'><i class='fa fa-rotate-left'></i> Kembali</button></td>
					</tr>
				</table>
			</form>
			</div>";
			?>
				<script type="text/javascript">
					$(function()
					{
						$( ".dp" ).datepicker({
							dateFormat : "yy-mm-dd",
							showAnim : "fold"
						});
					});
				</script>
			<?php
		break;

		default :
			echo"<div class='w3-container w3-small w3-pale-green w3-leftbar w3-border-green'>
				<h4 style='margin-bottom:0;padding-bottom:0;'>Data Pelanggan</h4>
				<p style='margin-top:0;padding-top:0;'><i>Semua Data Pelanggan</i></p>
			</div>";

	//		flash('example_message');

			echo"<table style='margin-top:12px;'>
				<tr>
					<td>
						<form class='w3-tiny' action='' method='GET'>	
							<input type='hidden' name='mod' value='pelanggan'>
							<div class='w3-row'>
								<div class='w3-col s1'>
									<label class='w3-label'>Search</label>
								</div>
								<div class='w3-col s2'>
									<select name='field' class='w3-select w3-padding'>
										<option value=''>- Pilih -</option>
										<option value='nama_pelanggan'>NAMA PELANGGAN</option>
										<option value='nomor_telp'>NOMOR TELP</option>
										<option value='alamat'>ALAMAT</option></select>
								</div>
								<div class='w3-col s4'>
									<input type='text' name='cari' class='w3-input' placeholder='cari ...'>
								</div>
								<div class='w3-col s1'>
									<button type='submit' class='w3-btn w3-tiny'><i class='fa fa-paper-plane'></i> GO</button>
								</div>
							</div>
						</form>
					</td>
					<td align='right'><a href='med.php?mod=pelanggan' class='w3-btn w3-dark-grey w3-small'><i class='fa fa-refresh'></i> Refresh</a>
					<a href='med.php?mod=pelanggan&act=form' class='w3-btn w3-small w3-blue'><i class='fa fa-file'></i> Tambah</a></td>
				</tr>
				
			</table>";

			echo"<div style='margin-top:12px;margin-bottom:12px;'>
			<table class='w3-table w3-striped w3-bordered w3-tiny w3-hoverable tbl'>
				<thead>
					<tr class='w3-yellow'>
						<th>NO</th>
						<th>KODE PEL.</th>
						<th>NAMA PELANGGAN</th>
						<th>NOMOR TELP</th>
						<th>ALAMAT</th>
						<th>AKSI</th>
					</tr>
				</thead>
				<tbody>";

				$p      = new Paging;
				$batas  = 10;
			    if(isset($_GET['show']) && is_numeric($_GET['show']))
				{
					$batas = (int)$_GET['show'];
					$linkaksi .="&show=$_GET[show]";
				}

				$posisi = $p->cariPosisi($batas);

				$query = "SELECT custno,custname,telp,alamat1 FROM customer where cabang='$cabang' ";

				$q 	= "SELECT custno,custname,telp,alamat1 FROM customer where cabang='$cabang'";

				if(!empty($_GET['field']))
				{
					$hideinp = "<input type='hidden' name='field' value='$_GET[field]'>
								<input type='hidden' name='cari' value='$_GET[cari]'>";

					$linkaksi .= "&field=$_GET[field]&cari=$_GET[cari]";

					$query .= " WHERE $_GET[field] LIKE '%$_GET[cari]%'";
					$q .= " WHERE $_GET[field] LIKE '%$_GET[cari]%'";
				}

				$query .= " LIMIT $posisi, $batas";
				$q 	.= " ";
				

				$sql_kul = mysql_query($query);
				$fd_kul = mysql_num_rows($sql_kul);

				if($fd_kul > 0)
				{
					$no = $posisi + 1;
					while ($m = mysql_fetch_assoc($sql_kul)) {
						echo"<tr>
						
							<td>$no</td>
							<td>$m[custno]</td>
							<td>$m[custname]</td>
							<td>$m[telp]</td>
							<td>$m[alamat1]</td>
							<td><a href='med.php?mod=pelanggan&act=form&id=$m[custno]'><i class='fa fa-pencil-square w3-large w3-text-blue'></i></a> 
							<a href='$aksi?mod=pelanggan&act=hapus&id=$m[custno]' onclick=\"return confirm('Yakin hapus data');\"><i class='fa fa-trash w3-large w3-text-red'></i></a></td>
						
						</tr>";
						$no++;
					}
	

					$jmldata = mysql_num_rows(mysql_query($q));

					$jmlhalaman  = $p->jumlahHalaman($jmldata, $batas);
		    		$linkHalaman = $p->navHalaman($_GET['halaman'], $jmlhalaman, $linkaksi);
				}
				else
				{
					echo"<tr>
						<td colspan='5'><div class='w3-center'><i>Data Pelanggan Not Found.</i></div></td>
					</tr>";
				}
				

				echo"</tbody>

			</table></div>";

			echo"<div class='w3-row'>
				<div class='w3-col s1'>
					<form class='w3-tiny' action='' method='GET'>
						<input type='hidden' name='mod' value='pelanggan'>";
						if(!empty($hideinp))
						{
							echo $hideinp;
						}
						echo"<select class='w3-select w3-border' name='show' onchange='submit()'>
							<option value=''>- Show -</option>";
							$i=10;
							while($i <= 100)
							{
								if(isset($_GET['show']) AND (int)$_GET['show'] == $i)
								{
									echo"<option value='$i' selected>$i</option>";	
								}
								else
								{
									echo"<option value='$i'>$i</option>";
								}

								$i+=10;
							}
						echo"</select>
					</form>
				</div>
				<div class='w3-col s11'>
					<ul class='w3-pagination w3-right w3-tiny'>
						$linkHalaman
					</ul>
				</div>
			</div>";
		break;
	}

	
?>