<?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="bengkel";

//KONEKSI DISPLAY RESULT
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 pembelian (
 no int(6) NOT NULL auto_increment,
  invoice varchar(10) NOT NULL default '',
  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',
  user varchar(12) NOT NULL default '',
  PRIMARY KEY  (no)
  ) TYPE=MyISAM;";
$r1=mysql_query($q1) or die('sql1 error:'.mysql_error());


$q2="CREATE TABLE IF NOT EXISTS transaksi (
  no int(11) NOT NULL auto_increment,
  kode varchar(5) NOT NULL default '',
  tgl date NOT NULL default '0000-00-00',
  nama_tr varchar(250) 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)
) TYPE=MyISAM;";
$r2=mysql_query($q2) or die('sql2 error:'.mysql_error());

$q3="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 '',
  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 '2000-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)
) TYPE=MyISAM;";
$r3=mysql_query($q3) or die('sql3 error:'.mysql_error());
$q3a="INSERT INTO `login` (`no`, `username`, `password`, `admin`, `waktu_masuk`, `waktu_keluar`, `ip_address`, `timelog`, `status`) VALUES
(1, 'admin', '*admin*', 1, '2017-02-03 10:08:01', '2017-02-03 10:22:12', '', '', 'admin'),
(2, 'agus', 'agus123', 0, '0000-00-00 00:00:00', '2017-01-31 09:11:40', '', '', 'gudang'),
(3, 'kasir', '123456', 0, '2016-12-29 14:25:40', '2017-01-31 09:11:40', '', '', 'kasir');";
$r3a=mysql_query($q3a) or die('sq3a error:'.mysql_error());

$q4="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)
) TYPE=MyISAM;";
$r4=mysql_query($q4) or die('sql4 error:'.mysql_error());

$q5="CREATE TABLE IF NOT EXISTS setting (
	nama_toko varchar(50) NOT NULL default '',
  alamat varchar(100) NOT NULL default '',
  tlp varchar(50) NOT NULL default ''
) TYPE=MyISAM;";
$r5=mysql_query($q5) or die('sql5 error:'.mysql_error());
$q5a="INSERT INTO `setting` (`nama_toko`, `alamat`, `tlp`) VALUES
('ELLEGANT MOTORS', 'Jl. RAYA CIBIRU NO.142 BANDUNG', '(022) 8452012');";
$r5a=mysql_query($q5a) or die('sq5a error:'.mysql_error());


$q6="CREATE TABLE IF NOT EXISTS sparepart (
  no int(3) NOT NULL auto_increment,
  id_brg varchar(4) 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 '',
  inputer varchar(30) NOT NULL default '',
  PRIMARY KEY  (no)
) TYPE=MyISAM;";
$r6=mysql_query($q6) or die('sql6 error:'.mysql_error());

$q7="CREATE TABLE IF NOT EXISTS biaya_srv (
  no int(3) NOT NULL auto_increment,
  id varchar(4) 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)
) TYPE=MyISAM;";
$r7=mysql_query($q7) or die('sql7 error:'.mysql_error());

$q8="CREATE TABLE IF NOT EXISTS konsumen (
  no int(6) NOT NULL auto_increment,
  id varchar(10) NOT NULL default '',
  tgl_reg varchar(10) NOT NULL default '',
  nopol varchar(10) NOT NULL default '',
  pemilik varchar(40) NOT NULL default '',
  alamat varchar(60) NOT NULL default '',
  telp varchar(20) NOT NULL default '',
  merk varchar(20) NOT NULL default '',
  type varchar(20) NOT NULL default '',
  jenis varchar(20) NOT NULL default '',
  warna varchar(20) NOT NULL default '',
  model 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',
  PRIMARY KEY  (no)
) TYPE=MyISAM;";
$r8=mysql_query($q8) or die('sql8 error:'.mysql_error());

$q9="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)
) TYPE=MyISAM;";
$r9=mysql_query($q9) or die('sql9 error:'.mysql_error());

$q10="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 '',
  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)
) TYPE=MyISAM;";
$r10=mysql_query($q10) or die('sql10 error:'.mysql_error());

$q11="CREATE TABLE IF NOT EXISTS service (
  no int(6) NOT NULL auto_increment,
  id varchar(10) NOT NULL default '',
  no_kwitansi varchar(10) 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',
  officer varchar(30) NOT NULL default '',
  keluhan varchar(100) NOT NULL default '',
  status varchar(20) NOT NULL default '',
  PRIMARY KEY  (no)
) TYPE=MyISAM;";
$r11=mysql_query($q11) or die('sql11 error:'.mysql_error());

$q12="CREATE TABLE IF NOT EXISTS appcode(
  id int(2) NOT NULL auto_increment,
  codemyapps varchar(64) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;";
$r12=mysql_query($q12) or die('sql12 error:'.mysql_error());
$mycompid=exec('whoami');
$mycompidexpl = explode('\\', $mycompid);
$mycompid1=$mycompidexpl[0];
$mycompid2=$mycompidexpl[1];
$mycompidciper1=md5($mycompid1);
$mycompid2a=strrev($mycompid2);
$mycompidciper2=md5($mycompid2a);
$myendchipper=$mycompidciper1.$mycompidciper2;
$q12a="INSERT INTO appcode VALUES ('1', '$myendchipper');";
$r12a=mysql_query($q12a) or die('sql12a error:'.mysql_error());

//RESULT REPORT
$i=0;
$table=array("pembelian", "biaya_srv","konsumen","login","logs","penjualan","service","setting","sparepart","suplier","transaksi", "appcode");
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>";
?> 