<?php
include_once "library/seslogin.php";
include_once "library/connection.php";
include_once "library/connection08.php";
include_once "library/library.php";
error_reporting(0);
if(isset($_POST['btnsave'])){
$txtnm =$_POST['txtnm'];
$txtpcode =$_POST['txtpcode'];
$pcodename =$_POST['pcodename'];
$txtthn =$_POST['txtthn'];
$txtdes =$_POST['txtdes'];
$txtclass =$_POST['txtclass'];
$txtgroup =$_POST['txtgroup'];
$txttype =$_POST['txttype'];
$txttglawal =$_POST['txttglawal'];
$txttglakhir=$_POST['txttglakhir'];
$txtjan_f =$_POST['txtjan_f'];
$txtjan_a =$_POST['txtjan_a'];
$txtfeb_f =$_POST['txtfeb_f'];
$txtfeb_a =$_POST['txtfeb_a'];
$txtmar_f =$_POST['txtmar_f'];
$txtmar_a =$_POST['txtmar_a'];
$txtapr_f =$_POST['txtapr_f'];
$txtapr_a =$_POST['txtapr_a'];
$txtmei_f =$_POST['txtmei_f'];
$txtmei_a =$_POST['txtmei_a'];
$txtjun_f =$_POST['txtjun_f'];
$txtjun_a =$_POST['txtjun_a'];
$txtjul_f =$_POST['txtjul_f'];
$txtjul_a =$_POST['txtjul_a'];
$txtags_f =$_POST['txtags_f'];
$txtags_a =$_POST['txtags_a'];
$txtsep_f =$_POST['txtsep_f'];
$txtsep_a =$_POST['txtsep_a'];
$txtokt_f =$_POST['txtokt_f'];
$txtokt_a =$_POST['txtokt_a'];
$txtnov_f =$_POST['txtnov_f'];
$txtnov_a =$_POST['txtnov_a'];
$txtdes_f =$_POST['txtdes_f'];
$txtdes_a =$_POST['txtdes_a'];
$txtnote_jan =$_POST['txtnote_jan'];
$txtnote_feb =$_POST['txtnote_feb'];
$txtnote_mar =$_POST['txtnote_mar'];
$txtnote_apr =$_POST['txtnote_apr'];
$txtnote_mei =$_POST['txtnote_mei'];
$txtnote_jun =$_POST['txtnote_jun'];
$txtnote_jul =$_POST['txtnote_jul'];
$txtnote_ags =$_POST['txtnote_ags'];
$txtnote_sep =$_POST['txtnote_sep'];
$txtnote_okt =$_POST['txtnote_okt'];
$txtnote_sep =$_POST['txtnote_nov'];
$txtnote_nov =$_POST['txtnote_des'];
$pesanerror = array();
if(trim($txtnm)==""){
$pesanerror[]="Tolong Isi Nama";
}
if(trim($txtpcode)==""){
$pesanerror[]="Tolong Isi Pcode";
}
if(trim($txtthn)==""){
$pesanerror[]="Tolong Isi Tahun";
}
if(trim($txtdes)==""){
$pesanerror[]="Tolong Isi Data Descripsi";
}
if(trim($txtclass)==""){
$pesanerror[]="Tolong Isi Data Class";
}
if(trim($txtgroup)==""){
$pesanerror[]="Tolong Isi Data Grup";
}
if(trim($txttype)==""){
$pesanerror[]="Tolong Isi Data Type";
}
if(count($pesanerror)>=1){
echo"<div class='mssgBox'>";
echo"<img src='images/attention.png'><br>";
$nopesan=0;
foreach($pesanerror as $indeks=>$pesan_tampil){
$nopesan++;
echo"$nopesan.$pesan_tampil<br>";
}echo"</div></br>";
}else{
$sqlins ="INSERT INTO datam(nama, pcode, pname, thn,
des, grup, class,
type, tglawal, tglakhir,
jan_f, jan_a, feb_f, feb_a,
mar_f, mar_a, apr_f, apr_a,
mei_f, mei_a, jun_f, jun_a,
jul_f, jul_a, ags_f, ags_a,
sep_f, sep_a, okt_f, okt_a,
nov_f, nov_a, des_f, des_a,
note_jan, note_feb, note_mar, note_apr,
note_mei, note_jun, note_jul, note_ags,
note_sep, note_okt, note_nov, note_des)
VALUE('$txtnm', '$txtpcode', '$pcodename', '$txtthn',
'$txtdes', '$txtgroup', '$txtclass',
'$txttype', '".InggrisTgl($txttglawal)."', '".InggrisTgl($txttglakhir)."',
'$txtjan_f', '$txtjan_a', '$txtfeb_f', '$txtfeb_a',
'$txtmar_f', '$txtmar_a', '$txtapr_f', '$txtapr_a',
'$txtmei_f', '$txtmei_a', '$txtjun_f', '$txtjun_a',
'$txtjul_f', '$txtjul_a', '$txtags_f', '$txtags_a',
'$txtsep_f', '$txtsep_a', '$txtokt_f', '$txtokt_a',
'$txtnov_f', '$txtnov_a', '$txtdes_f', '$txtdes_a',
'$txtnote_jan', '$txtnote_feb', '$txtnote_mar', '$txtnote_apr',
'$txtnote_mei', '$txtnote_jun', '$txtnote_jul', '$txtnote_ags',
'$txtnote_sep', '$txtnote_okt', '$txtnote_nov', '$txtnote_des')";
$qryins = mysql_query($sqlins,$koneksidb)or die("error sqlins".mysql_error());
if($qryins){
echo "<meta http-equiv='refresh' content='0; url=?open=Add_Data'>";
}exit;
}
}
$datanm =isset($_POST['txtnm'])?$_POST['txtnm']:'';
$datapcode = isset($_POST['txtpcode']) ? $_POST['txtpcode']: 'null';
$datapnama = isset($_POST['pcodename']) ? $_POST['pcodename']: '';
$datatglawal =isset($_POST['txttglawal'])?$_POST['txttglawal'] : date("d-m-Y");
$datatglakhir =isset($_POST['txttglakhir'])?$_POST['txttglakhir'] : date("d-m-Y");
$datathn =isset($_POST['txtthn'])?$_POST['txtthn']:'';
$datagroup = isset($_POST['txtgroup']) ? $_POST['txtgroup'] : 'null';
$dataclass = isset($_POST['txtclass']) ? $_POST['txtclass'] : 'null';
$datatype = isset($_POST['txttype']) ? $_POST['txttype']: 'null';
$datades =isset($_POST['txtdes'])?$_POST['txtdes']:'';
$datajan_f =isset($_POST['txtjan_f'])?$_POST['txtjan_f']:'';
$datajan_a =isset($_POST['txtjan_a'])?$_POST['txtjan_a']:'';
$datafeb_f =isset($_POST['txtfeb_f'])?$_POST['txtfeb_f']:'';
$datafeb_a =isset($_POST['txtfeb_a'])?$_POST['txtfeb_a']:'';
$datamar_f =isset($_POST['txtmar_f'])?$_POST['txtmar_f']:'';
$datamar_a =isset($_POST['txtmar_a'])?$_POST['txtmar_a']:'';
$dataapr_f =isset($_POST['txtapr_f'])?$_POST['txtapr_f']:'';
$dataapr_a =isset($_POST['txtapr_a'])?$_POST['txtapr_a']:'';
$datamei_f =isset($_POST['txtmei_f'])?$_POST['txtmei_f']:'';
$datamei_a =isset($_POST['txtmei_a'])?$_POST['txtmei_a']:'';
$datajun_f =isset($_POST['txtjun_f'])?$_POST['txtjun_f']:'';
$datajun_a =isset($_POST['txtjun_a'])?$_POST['txtjun_a']:'';
$datajul_f =isset($_POST['txtjul_f'])?$_POST['txtjul_f']:'';
$datajul_a =isset($_POST['txtjul_a'])?$_POST['txtjul_a']:'';
$dataags_f =isset($_POST['txtags_f'])?$_POST['txtags_f']:'';
$dataags_a =isset($_POST['txtags_a'])?$_POST['txtags_a']:'';
$datasep_f =isset($_POST['txtsep_f'])?$_POST['txtsep_f']:'';
$datasep_a =isset($_POST['txtsep_a'])?$_POST['txtsep_a']:'';
$dataokt_f =isset($_POST['txtokt_f'])?$_POST['txtokt_f']:'';
$dataokt_a =isset($_POST['txtokt_a'])?$_POST['txtokt_a']:'';
$datanov_f =isset($_POST['txtnov_f'])?$_POST['txtnov_f']:'';
$datanov_a =isset($_POST['txtnov_a'])?$_POST['txtnov_a']:'';
$datades_f =isset($_POST['txtdes_f'])?$_POST['txtdes_f']:'';
$datades_a =isset($_POST['txtdes_a'])?$_POST['txtdes_a']:'';
$datanote_jan =isset($_POST['txtnote_jan'])?$_POST['txtnote_jan']:'';
$datanote_feb =isset($_POST['txtnote_feb'])?$_POST['txtnote_feb']:'';
$datanote_mar =isset($_POST['txtnote_mar'])?$_POST['txtnote_mar']:'';
$datanote_apr =isset($_POST['txtnote_apr'])?$_POST['txtnote_apr']:'';
$datanote_mei =isset($_POST['txtnote_mei'])?$_POST['txtnote_mei']:'';
$datanote_jun =isset($_POST['txtnote_jun'])?$_POST['txtnote_jun']:'';
$datanote_jul =isset($_POST['txtnote_jul'])?$_POST['txtnote_jul']:'';
$datanote_ags =isset($_POST['txtnote_ags'])?$_POST['txtnote_ags']:'';
$datanote_sep =isset($_POST['txtnote_sep'])?$_POST['txtnote_sep']:'';
$datanote_okt =isset($_POST['txtnote_okt'])?$_POST['txtnote_okt']:'';
$datanote_nov =isset($_POST['txtnote_nov'])?$_POST['txtnote_nov']:'';
$datanote_des =isset($_POST['txtnote_jan'])?$_POST['txtnote_jan']:'';
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
<link rel="stylesheet" href="styles/js/jquery-ui-1.12.1/jquery-ui.css">
<script src="styles/js/jquery-3.2.1.js"></script>
<script src="styles/js/jquery-ui-1.12.1/jquery-ui.js" ></script>
<script>
$(function(){
$("#txtpcode").autocomplete({
source:"data.php",
minLength:1,
});
});
$(function(){
$("#pcodename").autocomplete({
source:"data1.php",
minLength:1,
});
});
</script>
</head>
<body>
<div class="row">
<div class="col-md-4">
<form action="<?php $_SERVER['PHP_SELF'];?>" method="post" name="form" target="_self">
<table class="table-list">
<tr>
<td colspan="3"><h3>Data Master</h3></td>
</tr>
<tr style="border:hidden">
<td>Nama</td>
<td>:</td>
<td colspan="2"><input type="text" name="txtnm" value="<?php echo $datanm; ?>" /></td>
</tr>
<tr style="border:hidden">
<td>Pcode</td>
<td>:</td>
<td><input name="txtpcode" id="txtpcode"><div></div></td>
</tr>
<tr style="border:hidden">
<td valign="top">Pcode Name</td>
<td valign="top">:</td>
<td colspan="2">
<textarea name="pcodename" id="pcodename" cols="25" rows="3"><?php echo $datapnama; ?></textarea>
</td>
</tr>
<tr style="border:hidden">
<td>Tahun</td>
<td>:</td>
<td colspan="2"><input type="text" name="txtthn" value="<?php echo $datathn; ?>" /></td>
</tr>
<tr style="border:hidden">
<td>Group</td>
<td>:</td>
<td colspan="2">
<select name="txtgroup">
<option value="null">....</option>
<?php
$bacaSql = "SELECT * FROM `group`";
$bacaQry = mysql_query($bacaSql, $koneksidb) or die ("Gagal Query".mysql_error());
while ($bacaData = mysql_fetch_array($bacaQry)) {
if ($bacaData['nama_group'] ==$datagroup) {
$cek = " selected";
} else { $cek=""; }
echo "<option value='$bacaData[nama_group]' $cek>$bacaData[nama_group]</option>";
}
?>
</select>
<input name="btnPilih" type="submit" value="Pilih"/>
</td>
</tr>
<tr style="border:hidden">
<td>Class</td>
<td>:</td>
<td colspan="2">
<select name="txtclass">
<option value="null">....</option>
<?php
$bacasql="SELECT * FROM `class` WHERE nama_group='$datagroup'";
$bacaqry=mysql_query($bacasql,$koneksidb)or die("Error CMD".mysql_error());
while($bacadata=mysql_fetch_array($bacaqry)){
if($bacadata['nama_class']==$dataclass){
$cek=" selected";
}else{$cek="";}
echo "<option value='$bacadata[nama_class]' $cek>$bacadata[nama_class]</option>";
}
?>
</select>
<input name="btnPilih" type="submit" value="Pilih"/>
</td>
</tr>
<tr style="border:hidden">
<td>Type</td>
<td>:</td>
<td colspan="2">
<select name="txttype">
<option value="null">....</option>
<?php
$bacasql="SELECT * FROM `type` WHERE nama_group='$datagroup' AND nama_class='$dataclass'";
$bacaqry=mysql_query($bacasql,$koneksidb)or die("Error CMD".mysql_error());
while($bacadata=mysql_fetch_array($bacaqry)){
if($bacadata['nama_type']==$datatype){
$cek=" selected";
}else{$cek="";}
echo "<option value='$bacadata[nama_type]' $cek>$bacadata[nama_type]</option>";
}
?>
</select>
</td>
</tr>
<tr style="border:hidden">
<td>Tanggal Awal</td>
<td>:</td>
<td style="border:hidden" colspan="2"><input name="txttglawal" value="<?php echo $datatglawal;?>" size="25" maxlength="25" class="tcal"/></td>
</tr>
<tr style="border:hidden">
<td>Tanggal Akhir</td>
<td>:</td>
<td style="border:hidden" colspan="2"><input name="txttglakhir" value="<?php echo $datatglakhir;?>" size="25" maxlength="25" class="tcal"/></td>
</tr>
<tr style="border:hidden">
<td valign="top">Deskripsi</td>
<td valign="top">:</td>
<td colspan="2">
<textarea name="txtdes" id="txtdes" cols="25" rows="4"><?php echo $datades; ?></textarea></td>
</tr>
<tr style="border:hidden">
<td colspan="3" align="right"><button type="submit" name="btnsave" class="btn btn-success"><span class="glyphicon glyphicon-save-file"></span> Save</button></td>
</tr>
</table>
</div>
<div class="col-md-6">
<table class="table-list">
<tr>
<td colspan="3" align="left"><h3>Summary</h3></td>
</tr>
<tr style="border:hidden" valign="top">
<td>Januari</td>
<td>:</td>
<td><input type="text" name="txtjan_f" value="<?php echo $datajan_f; ?>" placeholder="Forcash"></td>
<td><input type="text" name="txtjan_a" value="<?php echo $datajan_a; ?>" placeholder="Actual"></td>
<td><textarea name="txtnote_jan" cols="35" rows="1"><?php echo $datanote_jan; ?></textarea></td>
</tr>
<tr style="border:hidden" valign="top">
<td>Februari</td>
<td>:</td>
<td><input type="text" name="txtfeb_f" value="<?php echo $datafeb_f; ?>" placeholder="Forcash"></td>
<td><input type="text" name="txtfeb_a" value="<?php echo $datafeb_a; ?>" placeholder="Actual"></td>
<td><textarea name="txtnote_feb" cols="35" rows="1"><?php echo $datanote_feb; ?></textarea></td>
</tr>
<tr style="border:hidden" valign="top">
<td>Maret</td>
<td>:</td>
<td><input type="text" name="txtmar_f" value="<?php echo $datamar_f; ?>" placeholder="Forcash"></td>
<td><input type="text" name="txtmar_a" value="<?php echo $datamar_a; ?>" placeholder="Actual"></td>
<td><textarea name="txtnote_mar" cols="35" rows="1"><?php echo $datanote_mar; ?></textarea></td>
</tr>
<tr style="border:hidden" valign="top">
<td>April</td>
<td>:</td>
<td><input type="text" name="txtapr_f" value="<?php echo $dataapr_f; ?>" placeholder="Forcash"></td>
<td><input type="text" name="txtapr_a" value="<?php echo $dataapr_a; ?>" placeholder="Actual"></td>
<td><textarea name="txtnote_apr" cols="35" rows="1"><?php echo $datanote_apr; ?></textarea></td>
</tr>
<tr style="border:hidden" valign="top">
<td>Mei</td>
<td>:</td>
<td><input type="text" name="txtmei_f" value="<?php echo $datamei_f; ?>" placeholder="Forcash"></td>
<td><input type="text" name="txtmei_a" value="<?php echo $datamei_a; ?>" placeholder="Actual"></td>
<td><textarea name="txtnote_mei" cols="35" rows="1"><?php echo $datanote_mei; ?></textarea></td>
</tr>
<tr style="border:hidden" valign="top">
<td>Juni</td>
<td>:</td>
<td><input type="text" name="txtjun_f" value="<?php echo $datajun_f; ?>" placeholder="Forcash"></td>
<td><input type="text" name="txtjun_a" value="<?php echo $datajun_a; ?>" placeholder="Actual"></td>
<td><textarea name="txtnote_jun" cols="35" rows="1"><?php echo $datanote_jun; ?></textarea></td>
</tr>
<tr style="border:hidden" valign="top">
<td>Juli</td>
<td>:</td>
<td><input type="text" name="txtjul_f" value="<?php echo $datajul_f; ?>" placeholder="Forcash"></td>
<td><input type="text" name="txtjul_a" value="<?php echo $datajul_a; ?>" placeholder="Actual"></td>
<td><textarea name="txtnote_jul" cols="35" rows="1"><?php echo $datanote_jul; ?></textarea></td>
</tr>
<tr style="border:hidden" valign="top">
<td>Agustus</td>
<td>:</td>
<td><input type="text" name="txtags_f" value="<?php echo $dataags_f; ?>" placeholder="Forcash"></td>
<td><input type="text" name="txtags_a" value="<?php echo $dataags_a; ?>" placeholder="Actual"></td>
<td><textarea name="txtnote_ags" cols="35" rows="1"><?php echo $datanote_ags; ?></textarea></td>
</tr>
<tr style="border:hidden" valign="top">
<td>September</td>
<td>:</td>
<td><input type="text" name="txtsep_f" value="<?php echo $datasep_f; ?>" placeholder="Forcash"></td>
<td><input type="text" name="txtsep_a" value="<?php echo $datasep_a; ?>" placeholder="Actual"></td>
<td><textarea name="txtnote_sep" cols="35" rows="1"><?php echo $datanote_sep; ?></textarea></td>
</tr>
<tr style="border:hidden" valign="top">
<td>Oktober</td>
<td>:</td>
<td><input type="text" name="txtokt_f" value="<?php echo $dataokt_f; ?>" placeholder="Forcash"></td>
<td><input type="text" name="txtokt_a" value="<?php echo $dataokt_a; ?>" placeholder="Actual"></td>
<td><textarea name="txtnote_okt" cols="35" rows="1"><?php echo $datanote_okt; ?></textarea></td>
</tr>
<tr style="border:hidden" valign="top">
<td>November</td>
<td>:</td>
<td><input type="text" name="txtnov_f" value="<?php echo $datanov_f; ?>" placeholder="Forcash"></td>
<td><input type="text" name="txtnov_a" value="<?php echo $datanov_a; ?>" placeholder="Actual"></td>
<td><textarea name="txtnote_nov" cols="35" rows="1"><?php echo $datanote_nov; ?></textarea></td>
</tr>
<tr style="border:hidden" valign="top">
<td>Desember</td>
<td>:</td>
<td><input type="text" name="txtdes_f" value="<?php echo $datades_f; ?>" placeholder="Forcash"></td>
<td><input type="text" name="txtdes_a" value="<?php echo $datades_a; ?>" placeholder="Actual"></td>
<td><textarea name="txtnote_des" cols="35" rows="1"><?php echo $datanote_des; ?></textarea></td>
</tr>
<tr style="border:hidden">
<td colspan="3" align="center" valign="middle"></td>
</tr>
</table>
</script>
</form>
</div>
</div>
</body>
</html>