<html>
<head>
<title>Instalasi - Aplikasi Bengkel v2.0</title>
<link rel="shortcut icon" href="logo.jpg" type="image/x-icon"/>
<SCRIPT type="text/javascript" src="time.js"></SCRIPT>
<link href="css.css" rel="stylesheet" type="text/css">
<style>
	body {
		top:10;
		left:0;
		right:0; 
		font: normal 14px helvetica, sans-serif; color: #FFF;	
	}
	#box1 {
		width:450px;
		text-align:left;
		FONT-WEIGHT:normal;
		font-size:14px;
		color:#419514;
		float:center;
		vertical-align:middle;
		/*position: fixed;*/
		padding:10px 20px 0px 20px;
		margin-top:10px;
		margin-left:15px;
		margin-right:15px;
		margin-bottom:0px;
		//margin:50px auto;
		//margin-left:350px;
		//margin-top:0px;
		//margin-bottom:5px;
		border-radius:7px;
		border:0px solid white;
		background-color:#fff;
		box-shadow:1px 1px 12px gray;
	}
</style>
</head>

<body ONLOAD="startTime(),loginf();">
<script type="text/javascript">disableSelection(document.body);</script>
<?php include('date.php');?>
<p style='float:left; color:#FFF; font-weight:bold; height:1px; vertical-align:middle; padding:5px auto;'><b><?php echo "$hari, $tgl01 $bln $thn";?> | <font id="txtjam"></font></b></p>
<BR><BR><BR><BR><BR>
<CENTER>
	<span style='font-size:20px;font-weight:bold;'>INSTALASI SOFTWARE BENGKEL v3.0</span>

	
<?php
// Establishing koneksi with Server by passing server_name, user_id and password as a parameter
$koneksi = mysql_connect("localhost", "root", "") or die ('Error connecting to MySQL');;
// Selecting Database
$dbase="bengkelv2";

//KONEKSI DISPLAY RESULT
echo"<div id='box1' style='color:#77B222; width:450px; text-align:left;'>";
	if ($koneksi) {
		//CREATE DB
		$q = "CREATE DATABASE IF NOT EXISTS $dbase";
		$r = mysql_query($q);
		echo"<br>#Koneksi ke server MySQL <b>BERHASIL</b>dibuat.";
		if ($q) {
			echo"<br>#Database <b>$dbase</b> berhasil dibuat.";
			}
		//Koneksi ke DB yg baru dibuat
		$dblink = mysql_select_db($dbase, $koneksi) or die ("Database tidak konek!");
		if ($dblink) {
			echo"<br>#Koneksi ke Database <b>$dbase</b> BERHASIL.";
		}
	}
echo"<BR><BR>";

//buat table
$q1="CREATE TABLE IF NOT EXISTS `biaya_srv` (
  `no` int(3) NOT NULL AUTO_INCREMENT,
  `id` varchar(6) NOT NULL DEFAULT '',
  `tgl_input` date NOT NULL DEFAULT '0000-00-00',
  `jam_input` time NOT NULL DEFAULT '00:00:00',
  `waktu_update` datetime DEFAULT NULL,
  `nama` varchar(40) NOT NULL DEFAULT '',
  `hrg` int(13) NOT NULL DEFAULT '0',
  `diskon` tinyint(3) NOT NULL DEFAULT '0',
  `inputer` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=53 ;";
$r1=mysql_query($q1) or die('sql1 error:'.mysql_error());


$q2="CREATE TABLE IF NOT EXISTS `jenis_spl` (
  `no` int(2) NOT NULL AUTO_INCREMENT,
  `jenis_brg` varchar(20) NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;";
$r2=mysql_query($q2) or die('sql2 error:'.mysql_error());

$q3="CREATE TABLE IF NOT EXISTS `konsumen` (
  `no` int(8) NOT NULL AUTO_INCREMENT,
  `id` varchar(12) NOT NULL DEFAULT '',
  `tgl_reg` varchar(20) NOT NULL DEFAULT '' COMMENT 'tgl_jam',
  `nopol` varchar(10) NOT NULL DEFAULT '',
  `pemilik` varchar(40) NOT NULL DEFAULT '',
  `alamat` varchar(60) NOT NULL DEFAULT '',
  `kota` varchar(30) NOT NULL,
  `telp` varchar(20) NOT NULL DEFAULT '',
  `merk` varchar(20) NOT NULL DEFAULT '',
  `type` varchar(60) NOT NULL DEFAULT '',
  `warna` varchar(20) NOT NULL DEFAULT '',
  `thn` varchar(4) NOT NULL DEFAULT '',
  `silinder` int(3) NOT NULL DEFAULT '0',
  `no_rangka` varchar(20) NOT NULL DEFAULT '',
  `no_mesin` varchar(20) NOT NULL DEFAULT '',
  `tax` tinyint(2) NOT NULL DEFAULT '0',
  `officer` varchar(30) NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;";
$r3=mysql_query($q3) or die('sql3 error:'.mysql_error());


$q4="CREATE TABLE IF NOT EXISTS `login` (
  `no` tinyint(2) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL DEFAULT '',
  `password` varchar(20) NOT NULL DEFAULT '',
  `email` varchar(60) NOT NULL,
  `cab` varchar(2) NOT NULL,
  `time_reg` varchar(20) NOT NULL,
  `admin` tinyint(1) NOT NULL DEFAULT '0',
  `waktu_masuk` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `waktu_keluar` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ip_address` varchar(32) NOT NULL DEFAULT '',
  `timelog` varchar(20) NOT NULL DEFAULT '',
  `status` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;";
$r4=mysql_query($q4) or die('sql4 error:'.mysql_error());
//ISI LOGIN
$q4a="INSERT INTO `login` (`no`, `username`, `password`, `email`, `cab`, `time_reg`, `admin`, `waktu_masuk`, `waktu_keluar`, `ip_address`, `timelog`, `status`) VALUES
(1, 'admin', '*admin*', 'admin00@indomotor.net', '00', '2017-09-06 11:58:31', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', 'admin');";
$r4a=mysql_query($q4a) or die('sq4a error:'.mysql_error());

$q5="CREATE TABLE IF NOT EXISTS `logs` (
  `no` int(6) NOT NULL AUTO_INCREMENT,
  `menu` varchar(20) NOT NULL DEFAULT '',
  `rincian` varchar(250) NOT NULL DEFAULT '',
  `aksi` varchar(30) NOT NULL DEFAULT '',
  `officer` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=105 ;";
$r5=mysql_query($q5) or die('sql5 error:'.mysql_error());


$q6="CREATE TABLE IF NOT EXISTS `pembelian` (
  `no` int(6) NOT NULL AUTO_INCREMENT,
  `invoice` varchar(10) NOT NULL DEFAULT '',
  `barcode` varchar(20) NOT NULL,
  `kode_brg` varchar(8) NOT NULL DEFAULT '',
  `waktu` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `nama_barang` varchar(100) NOT NULL DEFAULT '',
  `satuan_brg` varchar(15) NOT NULL DEFAULT '0',
  `jenis` varchar(20) NOT NULL DEFAULT '0',
  `suplier` varchar(30) NOT NULL DEFAULT '0',
  `kode_suplier` varchar(20) NOT NULL DEFAULT '',
  `harga_beli` int(12) NOT NULL DEFAULT '0',
  `qty_awal` int(6) NOT NULL DEFAULT '0',
  `qty_add` int(4) NOT NULL DEFAULT '0',
  `subtotal` int(12) NOT NULL DEFAULT '0',
  `cab` varchar(2) NOT NULL,
  `user` varchar(12) NOT NULL DEFAULT '',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;";
$r6=mysql_query($q6) or die('sql6 error:'.mysql_error());

$q7="CREATE TABLE IF NOT EXISTS `penjualan` (
  `no` int(6) NOT NULL AUTO_INCREMENT,
  `token` int(4) NOT NULL DEFAULT '0',
  `invoice` varchar(11) NOT NULL DEFAULT '',
  `tgl` varchar(10) NOT NULL DEFAULT '',
  `jam` time NOT NULL DEFAULT '00:00:00',
  `id_brg` varchar(10) NOT NULL DEFAULT '',
  `barcode` varchar(20) NOT NULL,
  `nama_brg` varchar(40) NOT NULL DEFAULT '',
  `satuan` varchar(20) NOT NULL DEFAULT '',
  `hrg_satuan` int(13) NOT NULL DEFAULT '0',
  `jml` int(3) NOT NULL DEFAULT '0',
  `diskon` int(6) NOT NULL DEFAULT '0',
  `subtotal` int(13) NOT NULL DEFAULT '0',
  `bayar` int(6) NOT NULL DEFAULT '0',
  `kasir` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=53 ;";
$r7=mysql_query($q7) or die('sql7 error:'.mysql_error());

$q8="CREATE TABLE IF NOT EXISTS `produsen_brg` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `cab` varchar(2) NOT NULL,
  `produsen` varchar(30) NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;";
$r8=mysql_query($q8) or die('sql8 error:'.mysql_error());

$q9="CREATE TABLE IF NOT EXISTS `service` (
  `no` int(6) NOT NULL AUTO_INCREMENT,
  `id` varchar(12) NOT NULL DEFAULT '',
  `no_kwitansi` varchar(15) NOT NULL DEFAULT '',
  `hari` varchar(10) NOT NULL DEFAULT '',
  `tgl` varchar(10) NOT NULL DEFAULT '',
  `jam` time NOT NULL DEFAULT '00:00:00',
  `id_brg` varchar(10) NOT NULL DEFAULT '',
  `nama_brg` varchar(40) NOT NULL DEFAULT '',
  `hrg_satuan` int(13) NOT NULL DEFAULT '0',
  `jml` int(3) NOT NULL DEFAULT '0',
  `diskon` int(6) NOT NULL DEFAULT '0',
  `subtotal` int(13) NOT NULL DEFAULT '0',
  `bayar` int(9) NOT NULL DEFAULT '0',
  `jam_selesai` varchar(8) NOT NULL DEFAULT '00:00:00',
  `mekanik` varchar(60) NOT NULL,
  `officer` varchar(30) NOT NULL DEFAULT '',
  `keluhan` varchar(100) NOT NULL DEFAULT '',
  `status` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=132 ;";
$r9=mysql_query($q9) or die('sql9 error:'.mysql_error());

$q10="CREATE TABLE IF NOT EXISTS `setting` (
  `no` int(3) NOT NULL AUTO_INCREMENT,
  `cab` varchar(2) NOT NULL,
  `nama_bengkel` varchar(50) NOT NULL DEFAULT '',
  `alamat` varchar(100) NOT NULL DEFAULT '',
  `tlp` varchar(50) NOT NULL DEFAULT '',
  `manager` varchar(40) NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;";
$r10=mysql_query($q10) or die('sql10 error:'.mysql_error());
//ISI SETTING
$q10a="INSERT INTO `setting` (`no`, `cab`, `nama_bengkel`, `alamat`, `tlp`, `manager`) VALUES
(1, '00', 'PT INDOMOTOR', 'JL. SERPONG NO.xxx TANGSEL - TANGGERANG SELATAN-JAWA BARAT', '(021) XXXXXXX', 'SIGIT');";
$r10a=mysql_query($q10a) or die('q10a error:'.mysql_error());

$q11="CREATE TABLE IF NOT EXISTS `sparepart` (
  `no` int(3) NOT NULL AUTO_INCREMENT,
  `barcode` varchar(20) NOT NULL,
  `id_brg` varchar(10) NOT NULL DEFAULT '',
  `tgl_input` date NOT NULL DEFAULT '0000-00-00',
  `jam_input` time NOT NULL DEFAULT '00:00:00',
  `waktu_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `nama_brg` varchar(50) NOT NULL DEFAULT '',
  `kode_suplier` varchar(8) NOT NULL DEFAULT '',
  `nama_suplier` varchar(40) NOT NULL DEFAULT '',
  `stok` int(4) NOT NULL DEFAULT '0',
  `min_stok` int(3) NOT NULL DEFAULT '0',
  `satuan` varchar(30) NOT NULL DEFAULT '',
  `hrg_beli` int(13) NOT NULL DEFAULT '0',
  `hrg_jual` int(13) NOT NULL DEFAULT '0',
  `diskon` tinyint(3) NOT NULL DEFAULT '0',
  `jenis` varchar(30) NOT NULL DEFAULT '',
  `produsen` varchar(30) NOT NULL,
  `inputer` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;";
$r11=mysql_query($q11) or die('sql11 error:'.mysql_error());

$q12="CREATE TABLE IF NOT EXISTS `suplier` (
  `no` int(3) NOT NULL AUTO_INCREMENT,
  `id_suplier` varchar(8) NOT NULL DEFAULT '',
  `tgl_reg` date NOT NULL DEFAULT '0000-00-00',
  `nama` varchar(50) NOT NULL DEFAULT '',
  `alamat` varchar(100) NOT NULL DEFAULT '',
  `cp` varchar(30) NOT NULL DEFAULT '',
  `telp` varchar(30) NOT NULL DEFAULT '',
  `jenis` varchar(30) NOT NULL DEFAULT '',
  `inputer` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;";
$r12=mysql_query($q12) or die('sql12 error:'.mysql_error());

$q13="CREATE TABLE IF NOT EXISTS `transaksi` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `cab` varchar(2) NOT NULL,
  `kode` varchar(5) NOT NULL DEFAULT '',
  `tgl` date NOT NULL DEFAULT '0000-00-00',
  `jam` time NOT NULL,
  `nama_tr` varchar(100) NOT NULL DEFAULT '',
  `jenis_tr` varchar(100) NOT NULL DEFAULT '',
  `alokasi_tr` varchar(100) NOT NULL DEFAULT '',
  `nominal` int(12) NOT NULL DEFAULT '0',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;";
$r13=mysql_query($q13) or die('sql13 error:'.mysql_error());

$q14="CREATE TABLE IF NOT EXISTS `appcode` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `codemyapps` varchar(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;";
$r14=mysql_query($q14) or die('sql14 error:'.mysql_error());

//ISI APPCODE
/*
$mycompid=exec('whoami');
$mycompidexpl = explode('\\', $mycompid);
$mycompid1=$mycompidexpl[0];
$mycompid2=$mycompidexpl[1];
$mycompidciper1=md5($mycompid1);
$mycompid2a=strrev($mycompid2);
$mycompidciper2=md5($mycompid2a);
$myendchipper=$mycompidciper1.$mycompidciper2;
*/
$mycompid=$_SERVER['SERVER_NAME'];
$mycompid1=$mycompid;
$mycompid2=strrev($mycompid);
$mycompidciper1=md5($mycompid1);
$mycompidciper2=md5($mycompid2);
$myendchipper=strtoupper($mycompidciper1.$mycompidciper2);
$q14a="INSERT INTO appcode VALUES ('1', '$myendchipper');";
$r14a=mysql_query($q14a) or die('sql14a error:'.mysql_error());

//RESULT REPORT
$i=0;
$table=array("appcode", "biaya_srv", "jenis_spl", "konsumen", "login", "logs", "pembelian", "penjualan", "produsen_brg", "service", "setting", "sparepart", "suplier", "transaksi");
foreach ($table as $tblbengkel) {
	$i++;
	if ($q[$i]) {
		echo"<br>$i. Tabel <b>$tblbengkel</b> SUKSES dibuat.";
	}else {
		echo"<br>$i. Tabel <b>$tblbengkel</b> sudah ADA.";
	}
}
echo"<br><i>Your App Code is: <b>$myendchipper</b><i>.<br>";
echo"<br><center><a href='index.php'>Go to Aplication</a></center>";
echo"</div>";
?>

</CENTER>
</body>
</html> 