-- phpMyAdmin SQL Dump
-- version 5.0.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Aug 06, 2025 at 07:48 PM
-- Server version: 10.4.17-MariaDB
-- PHP Version: 7.2.34

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `db_kasir`
--

-- --------------------------------------------------------

--
-- Table structure for table `barang`
--

CREATE TABLE `barang` (
  `id` int(11) NOT NULL,
  `id_barang` varchar(100) NOT NULL,
  `nama_barang` text NOT NULL,
  `stok_barang` varchar(250) NOT NULL,
  `harga_barang` varchar(250) NOT NULL,
  `tgl_input` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `barang`
--

INSERT INTO `barang` (`id`, `id_barang`, `nama_barang`, `stok_barang`, `harga_barang`, `tgl_input`) VALUES
(43, 'BRG001', 'Mie Sedap Soto', '95', '3000', '03-08-2025, 16:40'),
(44, 'BRG002', 'Mie Sedap Seddap', '916', '3500', '03-08-2025, 17:28'),
(45, 'BRG003', 'Sarimi 2 Goreng', '20', '4000', '05-08-2025, 1:01');

-- --------------------------------------------------------

--
-- Table structure for table `keranjang`
--

CREATE TABLE `keranjang` (
  `id_cart` int(11) NOT NULL,
  `kode_barang` varchar(255) NOT NULL,
  `nama_barang` varchar(255) NOT NULL,
  `harga_barang` varchar(255) NOT NULL,
  `quantity` text NOT NULL,
  `diskon` varchar(250) NOT NULL,
  `subtotal` varchar(255) NOT NULL,
  `tgl_input` varchar(255) NOT NULL,
  `no_transaksi` varchar(255) NOT NULL,
  `bayar` varchar(255) NOT NULL,
  `kembalian` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `keranjang`
--

INSERT INTO `keranjang` (`id_cart`, `kode_barang`, `nama_barang`, `harga_barang`, `quantity`, `diskon`, `subtotal`, `tgl_input`, `no_transaksi`, `bayar`, `kembalian`) VALUES
(187, 'BRG002', 'Mie Sedap Seddap', '3500', '3', '500', '10500', '2025-08-06', 'AD60820252259', '10000', '0');

-- --------------------------------------------------------

--
-- Table structure for table `laporanku`
--

CREATE TABLE `laporanku` (
  `id_cart` int(11) NOT NULL,
  `kode_barang` varchar(255) NOT NULL,
  `nama_barang` varchar(255) NOT NULL,
  `harga_barang` varchar(255) NOT NULL,
  `quantity` text NOT NULL,
  `diskon` varchar(250) NOT NULL,
  `subtotal` varchar(255) NOT NULL,
  `tgl_input` varchar(250) NOT NULL,
  `no_transaksi` varchar(255) NOT NULL,
  `bayar` varchar(255) NOT NULL,
  `kembalian` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `laporanku`
--

INSERT INTO `laporanku` (`id_cart`, `kode_barang`, `nama_barang`, `harga_barang`, `quantity`, `diskon`, `subtotal`, `tgl_input`, `no_transaksi`, `bayar`, `kembalian`) VALUES
(115, 'BRG001', 'Mie Sedap Soto', '3000', '2', '', '6000', '2025-08-03', 'AD30820251211', '6000', '0'),
(116, 'BRG004', 'Mie Sedap Soto', '3000', '2', '', '6000', '2025-08-03', 'AD30820251607', '10000', '4000'),
(117, 'BRG001', 'Mie Sedap Soto', '3000', '1', '', '3000', '2025-08-03', 'AD30820251641', '5000', '2000'),
(118, 'BRG001', 'Mie Sedap Soto', '3000', '2', '', '6000', '2025-08-03', 'AD30820251714', '10000', '4000'),
(119, 'BRG001', 'Mie Sedap Soto', '3000', '2', '', '6000', '2025-08-03', 'AD30820251728', '20000', '3500'),
(120, 'BRG002', 'Mie Sedap Seddap', '3500', '3', '', '10500', '2025-08-03', 'AD30820251728', '20000', '3500'),
(121, 'BRG001', 'Mie Sedap Soto', '3000', '4', '', '12000', '2025-08-03', 'AD30820251809', '12000', '0'),
(168, 'BRG002', 'Mie Sedap Seddap', '3500', '3', '', '10500', '2025-08-04', 'AD40820252358', '10000', '0'),
(169, 'BRG002', 'Mie Sedap Seddap', '3500', '3', '', '10500', '2025-08-05', 'AD5082025000', '10000', '0'),
(175, 'BRG001', 'Mie Sedap Soto', '3000', '4', '1000', '12000', '2025-08-05', 'AD5082025012', '0', '0'),
(176, 'BRG002', 'Mie Sedap Seddap', '3500', '3', '', '10500', '2025-08-05', 'AD5082025018', '10000', '0'),
(181, 'BRG002', 'Mie Sedap Seddap', '3500', '3', '500', '10500', '2025-08-05', 'AD5082025042', '10000', '0'),
(182, 'BRG001', 'Mie Sedap Soto', '3000', '5', '1000', '15000', '2025-08-05', 'AD5082025043', '15000', '1000'),
(183, 'BRG002', 'Mie Sedap Seddap', '3500', '3', '500', '10500', '2025-08-05', 'AD5082025100', '20000', '10000'),
(184, 'BRG003', 'Sarimi 2 Goreng', '4000', '4', '1000', '16000', '2025-08-05', 'AD5082025102', '20000', '5000'),
(185, 'BRG002', 'Mie Sedap Seddap', '3500', '3', '500', '10500', '2025-08-06', 'AD60820252158', '10000', '0');

-- --------------------------------------------------------

--
-- Table structure for table `login`
--

CREATE TABLE `login` (
  `id_login` int(11) NOT NULL,
  `nama_toko` varchar(50) NOT NULL,
  `user` varchar(250) NOT NULL,
  `pass` varchar(250) NOT NULL,
  `alamat` varchar(255) NOT NULL,
  `telp` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `login`
--

INSERT INTO `login` (`id_login`, `nama_toko`, `user`, `pass`, `alamat`, `telp`) VALUES
(1, 'TOKO WAWAN', 'admin', 'admin', 'Sumberbendo RT 002 RW 003 Bumirejo Kesamben Blitar', '082139058923');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `barang`
--
ALTER TABLE `barang`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `keranjang`
--
ALTER TABLE `keranjang`
  ADD PRIMARY KEY (`id_cart`);

--
-- Indexes for table `laporanku`
--
ALTER TABLE `laporanku`
  ADD PRIMARY KEY (`id_cart`);

--
-- Indexes for table `login`
--
ALTER TABLE `login`
  ADD PRIMARY KEY (`id_login`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `barang`
--
ALTER TABLE `barang`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

--
-- AUTO_INCREMENT for table `keranjang`
--
ALTER TABLE `keranjang`
  MODIFY `id_cart` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=188;

--
-- AUTO_INCREMENT for table `laporanku`
--
ALTER TABLE `laporanku`
  MODIFY `id_cart` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=186;

--
-- AUTO_INCREMENT for table `login`
--
ALTER TABLE `login`
  MODIFY `id_login` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
