kicap/store_keeping
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
store_keeping/server2.sql

230 lines
21 KiB
SQL
Raw Permalink Blame History

-- phpMyAdmin SQL Dump
-- version 5.0.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 30, 2022 at 09:48 PM
-- Server version: 10.4.17-MariaDB
-- PHP Version: 7.4.15
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: `penjualan_ilham_online`
--
-- --------------------------------------------------------
--
-- Table structure for table `tb_barang`
--
CREATE TABLE `tb_barang` (
`no_barang` int(4) NOT NULL,
`kode_barang` varchar(6) NOT NULL,
`nama` varchar(100) NOT NULL,
`harga_jual` varchar(10) NOT NULL,
`jumlah` int(4) NOT NULL,
`foto` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `tb_barang`
--
INSERT INTO `tb_barang` (`no_barang`, `kode_barang`, `nama`, `harga_jual`, `jumlah`, `foto`) VALUES
(1, '123asd', 'asda', '123,123', 1497, 'brothers.jpg'),
(2, '435sdf', 'asdasd', '345,345', 3453, '79f509f5451cf0e66e0fa92bcf45a79ee95793b4_hq.jpg'),
(3, '456dfg', 'sdfgsdf', '345,546', 4570, '6564e6d48892e6ba325bda1ec27189c9b4b3b473_hq.jpg'),
(4, '454sfd', 'dsfsdf', '546,546', 456, 'Vorpal Sword.jpg'),
(5, 'sdfds3', '23423asdasd', '234,234', 2357, '11073968_844405842264361_5190470711960847490_n.jpg'),
(6, 'dfgh42', 'dfgfdg', '342,342', 234, '1-brjYnVlXwM3j_SWXImT0Rg.png'),
(7, 'dfg345', 'sdfsdf', '345,345', 4353, 'pemotong padi 1.jpg'),
(8, 'sdf234', '234sdfsdf', '234,234', 2342, '11073968_844405842264361_5190470711960847490_n.jpg'),
(9, 'fh4534', '34534', '345,345', 3453, '11073968_844405842264361_5190470711960847490_n.jpg'),
(10, 'fgds23', 'ef3234', '242,342', 2342, '11073968_844405842264361_5190470711960847490_n.jpg'),
(11, 'sd2342', 'sdfsdf', '234,234', 2342, 'asdasd.jpg'),
(12, '134ash', 'asdasd', '345,453', 3427, '27661905_1607403089353960_2137003018_n.jpg'),
(13, 'fgh654', '546', '456,456', 4564, '11073968_844405842264361_5190470711960847490_n.jpg'),
(14, 'asd565', 'fdsfsdf', '345,234', 2318, '11073968_844405842264361_5190470711960847490_n.jpg'),
(15, 'hf3454', '324234', '234,234', 2343, '79f509f5451cf0e66e0fa92bcf45a79ee95793b4_hq.jpg'),
(16, 'gfh456', 'dfgdfg', '50,000', 218, 'wp1987433-gin-ichimaru-wallpapers.jpg');
-- --------------------------------------------------------
--
-- Table structure for table `tb_login`
--
CREATE TABLE `tb_login` (
`no_login` int(2) NOT NULL,
`username` varchar(20) NOT NULL,
`password` varchar(150) NOT NULL,
`nama` varchar(100) NOT NULL,
`level` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `tb_login`
--
INSERT INTO `tb_login` (`no_login`, `username`, `password`, `nama`, `level`) VALUES
(2, 'admin', 'e739279cb28cdafd7373618313803524', 'Admin', 1);
-- --------------------------------------------------------
--
-- Table structure for table `tb_log_history`
--
CREATE TABLE `tb_log_history` (
`no_log` int(6) NOT NULL,
`no_barang` int(4) DEFAULT NULL,
`status` varchar(50) NOT NULL,
`ket` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`ket`)),
`waktu` datetime NOT NULL,
`dibaca` varchar(10) NOT NULL DEFAULT 'Belum'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `tb_log_history`
--
INSERT INTO `tb_log_history` (`no_log`, `no_barang`, `status`, `ket`, `waktu`, `dibaca`) VALUES
(1, 1, 'Penambahan Produk Baru', '{\"kode_barang\":\"123asd\",\"nama\":\"asdasdsadas1123\",\"harga_jual\":\"123,123\",\"jumlah\":\"1231\",\"pembelian_stok\":\"12,312,312\",\"bertanggungjawab\":\"1\"}', '2022-01-15 19:38:17', 'Sudah'),
(2, 2, 'Penambahan Produk Baru', '{\"kode_barang\":\"435sdf\",\"nama\":\"asdasd\",\"harga_jual\":\"345,345\",\"jumlah\":\"3453\",\"pembelian_stok\":\"34,534,534\",\"bertanggungjawab\":\"1\"}', '2022-01-15 19:39:26', 'Sudah'),
(3, 3, 'Penambahan Produk Baru', '{\"kode_barang\":\"456dfg\",\"nama\":\"sdfgsdf\",\"harga_jual\":\"345,546\",\"jumlah\":\"4565\",\"pembelian_stok\":\"3,453,422\",\"bertanggungjawab\":\"1\"}', '2022-01-15 19:39:42', 'Sudah'),
(4, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"1\",\"harga_pembelian_stok\":\"123,123\",\"total_stok\":\"1232\",\"jumlah_stok_sebelumnya\":\"1231\",\"bertanggungjawab\":\"1\"}', '2022-01-15 22:26:47', 'Sudah'),
(5, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"2\",\"harga_pembelian_stok\":\"12,313\",\"total_stok\":\"1234\",\"jumlah_stok_sebelumnya\":\"1232\"}', '2022-01-15 22:27:27', 'Sudah'),
(6, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"4\",\"harga_pembelian_stok\":\"123,123\",\"total_stok\":\"1238\",\"jumlah_stok_sebelumnya\":\"1234\"}', '2022-01-15 22:29:55', 'Sudah'),
(7, 4, 'Penambahan Produk Baru', '{\"kode_barang\":\"454sfd\",\"nama\":\"dsfsdf\",\"harga_jual\":\"546,546\",\"jumlah\":\"456\",\"pembelian_stok\":\"45,654,645\",\"bertanggungjawab\":\"1\"}', '2022-01-15 22:38:28', 'Sudah'),
(8, 3, 'Penambahan Stok', '{\"penambahan_stok\":\"3\",\"harga_pembelian_stok\":\"213,123\",\"total_stok\":\"4568\",\"jumlah_stok_sebelumnya\":\"4565\",\"bertanggungjawab\":\"1\"}', '2022-01-15 22:39:49', 'Sudah'),
(9, 3, 'Penambahan Stok', '{\"penambahan_stok\":\"4\",\"harga_pembelian_stok\":\"1,231,231\",\"total_stok\":\"4572\",\"jumlah_stok_sebelumnya\":\"4568\",\"bertanggungjawab\":\"1\"}', '2022-01-15 22:40:32', 'Sudah'),
(10, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"2\",\"harga_pembelian_stok\":\"1,231,232\",\"total_stok\":\"1240\",\"jumlah_stok_sebelumnya\":\"1238\",\"bertanggungjawab\":\"1\"}', '2022-01-15 22:55:28', 'Sudah'),
(11, 1, 'Edit Detail Produk', '{\"nama_lama\":\"asdasdsadas1123\",\"nama_baru\":\"asdasdsadas11231\",\"harga_lama\":\"123,123\",\"harga_baru\":\"1,231,231\",\"foto_lama\":\"1111..jpg\",\"foto_baru\":\"asdasd.jpg\",\"bertanggungjawab\":\"1\"}', '2022-01-16 00:42:35', 'Sudah'),
(12, 1, 'Edit Detail Produk', '{\"nama_lama\":\"asdasdsadas11231\",\"nama_baru\":\"asdasdsadas1123\",\"harga_lama\":\"1,231,231\",\"harga_baru\":\"123,123\",\"foto_lama\":\"asdasd.jpg\",\"foto_baru\":\"kembar.jpg\",\"bertanggungjawab\":\"1\"}', '2022-01-16 00:44:14', 'Sudah'),
(13, 1, 'Edit Detail Produk', '{\"nama_lama\":\"asdasdsadas1123\",\"nama_baru\":\"asdasdsadas11231\",\"harga_lama\":\"123,123\",\"harga_baru\":\"1,231,231\",\"foto_lama\":\"kembar.jpg\",\"foto_baru\":\"keluargaku.jpg\",\"bertanggungjawab\":\"1\"}', '2022-01-16 00:44:34', 'Sudah'),
(14, 1, 'Edit Detail Produk', '{\"nama_lama\":\"asdasdsadas11231\",\"nama_baru\":\"asdasdsadas11231\",\"harga_lama\":\"1,231,231\",\"harga_baru\":\"1,231,231\",\"foto_lama\":\"keluargaku.jpg\",\"foto_baru\":\"kembar.jpg\",\"bertanggungjawab\":\"1\"}', '2022-01-16 01:34:58', 'Sudah'),
(15, 5, 'Penambahan Produk Baru', '{\"kode_barang\":\"sdfds3\",\"nama\":\"23423asdasd\",\"harga_jual\":\"234,234\",\"jumlah\":\"2234\",\"pembelian_stok\":\"234,234,234\",\"bertanggungjawab\":\"1\"}', '2022-01-18 16:30:55', 'Sudah'),
(16, 6, 'Penambahan Produk Baru', '{\"kode_barang\":\"dfgh42\",\"nama\":\"dfgfdg\",\"harga_jual\":\"342,342\",\"jumlah\":\"234\",\"pembelian_stok\":\"2,342,342\",\"bertanggungjawab\":\"1\"}', '2022-01-18 16:35:17', 'Sudah'),
(17, 7, 'Penambahan Produk Baru', '{\"kode_barang\":\"dfg345\",\"nama\":\"sdfsdf\",\"harga_jual\":\"345,345\",\"jumlah\":\"4353\",\"pembelian_stok\":\"34,534,534\",\"bertanggungjawab\":\"1\"}', '2022-01-18 16:57:22', 'Sudah'),
(18, 8, 'Penambahan Produk Baru', '{\"kode_barang\":\"sdf234\",\"nama\":\"234sdfsdf\",\"harga_jual\":\"234,234\",\"jumlah\":\"2342\",\"pembelian_stok\":\"2,423,423\",\"bertanggungjawab\":\"1\"}', '2022-01-18 16:58:21', 'Sudah'),
(19, 9, 'Penambahan Produk Baru', '{\"kode_barang\":\"fh4534\",\"nama\":\"34534\",\"harga_jual\":\"345,345\",\"jumlah\":\"3453\",\"pembelian_stok\":\"345,345\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:04:04', 'Sudah'),
(20, 10, 'Penambahan Produk Baru', '{\"kode_barang\":\"fgds23\",\"nama\":\"ef3234\",\"harga_jual\":\"242,342\",\"jumlah\":\"2342\",\"pembelian_stok\":\"23,423,423\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:08:55', 'Sudah'),
(21, 11, 'Penambahan Produk Baru', '{\"kode_barang\":\"sd2342\",\"nama\":\"sdfsdf\",\"harga_jual\":\"234,234\",\"jumlah\":\"2342\",\"pembelian_stok\":\"234,234,234\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:09:56', 'Sudah'),
(22, 12, 'Penambahan Produk Baru', '{\"kode_barang\":\"134ash\",\"nama\":\"asdasd\",\"harga_jual\":\"345,453\",\"jumlah\":\"3453\",\"pembelian_stok\":\"34,534,534\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:20:46', 'Sudah'),
(23, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"123\",\"harga_pembelian_stok\":\"12,312,312\",\"total_stok\":\"1363\",\"jumlah_stok_sebelumnya\":\"1240\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:31:23', 'Sudah'),
(24, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"12\",\"harga_pembelian_stok\":\"123,123\",\"total_stok\":\"1375\",\"jumlah_stok_sebelumnya\":\"1363\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:33:13', 'Sudah'),
(25, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"12\",\"harga_pembelian_stok\":\"123,123\",\"total_stok\":\"1375\",\"jumlah_stok_sebelumnya\":\"1363\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:33:58', 'Sudah'),
(26, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"1\",\"harga_pembelian_stok\":\"12,313\",\"total_stok\":\"1376\",\"jumlah_stok_sebelumnya\":\"1375\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:34:47', 'Sudah'),
(27, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"1\",\"harga_pembelian_stok\":\"12,313\",\"total_stok\":\"1376\",\"jumlah_stok_sebelumnya\":\"1375\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:35:48', 'Sudah'),
(28, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"1\",\"harga_pembelian_stok\":\"12,313\",\"total_stok\":\"1376\",\"jumlah_stok_sebelumnya\":\"1375\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:36:45', 'Sudah'),
(29, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"123\",\"harga_pembelian_stok\":\"1\",\"total_stok\":\"1499\",\"jumlah_stok_sebelumnya\":\"1376\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:37:42', 'Sudah'),
(30, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"123\",\"harga_pembelian_stok\":\"12,312\",\"total_stok\":\"1499\",\"jumlah_stok_sebelumnya\":\"1376\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:39:02', 'Sudah'),
(31, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"123\",\"harga_pembelian_stok\":\"12,312\",\"total_stok\":\"1499\",\"jumlah_stok_sebelumnya\":\"1376\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:39:25', 'Sudah'),
(32, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"123\",\"harga_pembelian_stok\":\"12,312\",\"total_stok\":\"1499\",\"jumlah_stok_sebelumnya\":\"1376\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:39:36', 'Sudah'),
(33, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"123\",\"harga_pembelian_stok\":\"12,312\",\"total_stok\":\"1499\",\"jumlah_stok_sebelumnya\":\"1376\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:39:51', 'Sudah'),
(34, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"123\",\"harga_pembelian_stok\":\"12,312\",\"total_stok\":\"1499\",\"jumlah_stok_sebelumnya\":\"1376\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:40:51', 'Sudah'),
(35, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"123\",\"harga_pembelian_stok\":\"12,312\",\"total_stok\":\"1499\",\"jumlah_stok_sebelumnya\":\"1376\",\"bertanggungjawab\":\"1\"}', '2021-12-18 23:24:04', 'Sudah'),
(36, 13, 'Penambahan Produk Baru', '{\"kode_barang\":\"fgh654\",\"nama\":\"546\",\"harga_jual\":\"456,456\",\"jumlah\":\"4564\",\"pembelian_stok\":\"456,456\",\"bertanggungjawab\":\"1\"}', '2021-12-18 17:43:49', 'Sudah'),
(37, 14, 'Penambahan Produk Baru', '{\"kode_barang\":\"asd565\",\"nama\":\"fdsfsdf\",\"harga_jual\":\"345,234\",\"jumlah\":\"2342\",\"pembelian_stok\":\"23,423,423\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:46:31', 'Sudah'),
(38, 15, 'Penambahan Produk Baru', '{\"kode_barang\":\"hf3454\",\"nama\":\"324234\",\"harga_jual\":\"234,234\",\"jumlah\":\"2342\",\"pembelian_stok\":\"234,234\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:54:55', 'Sudah'),
(39, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"21\",\"harga_pembelian_stok\":\"123,123\",\"total_stok\":\"1520\",\"jumlah_stok_sebelumnya\":\"1499\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:55:39', 'Sudah'),
(40, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"1\",\"harga_pembelian_stok\":\"123,123\",\"total_stok\":\"1521\",\"jumlah_stok_sebelumnya\":\"1520\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:58:12', 'Sudah'),
(41, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"1\",\"harga_pembelian_stok\":\"123,123\",\"total_stok\":\"1521\",\"jumlah_stok_sebelumnya\":\"1520\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:58:46', 'Sudah'),
(42, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"1\",\"harga_pembelian_stok\":\"123,123\",\"total_stok\":\"1522\",\"jumlah_stok_sebelumnya\":\"1521\",\"bertanggungjawab\":\"1\"}', '2022-01-18 17:59:19', 'Sudah'),
(43, 5, 'Penambahan Stok', '{\"penambahan_stok\":\"123\",\"harga_pembelian_stok\":\"1\",\"total_stok\":\"2357\",\"jumlah_stok_sebelumnya\":\"2234\",\"bertanggungjawab\":\"1\"}', '2022-01-18 18:00:05', 'Sudah'),
(44, 15, 'Penambahan Stok', '{\"penambahan_stok\":\"1\",\"harga_pembelian_stok\":\"123\",\"total_stok\":\"2343\",\"jumlah_stok_sebelumnya\":\"2342\",\"bertanggungjawab\":\"1\"}', '2022-01-18 18:00:56', 'Sudah'),
(45, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"1\",\"harga_pembelian_stok\":\"123\",\"total_stok\":\"1523\",\"jumlah_stok_sebelumnya\":\"1522\",\"bertanggungjawab\":\"1\"}', '2022-01-18 18:30:19', 'Sudah'),
(46, 1, 'Penambahan Stok', '{\"penambahan_stok\":\"1\",\"harga_pembelian_stok\":\"123\",\"total_stok\":\"1523\",\"jumlah_stok_sebelumnya\":\"1522\",\"bertanggungjawab\":\"1\"}', '2022-01-18 18:30:43', 'Sudah'),
(47, 1, 'Edit Detail Produk', '{\"nama_lama\":\"asdasdsadas11231\",\"nama_baru\":\"asdasdsadas11231\",\"harga_lama\":\"1,231,231\",\"harga_baru\":\"1,231,231\",\"foto_lama\":\"kembar.jpg\",\"foto_baru\":\"1-brjYnVlXwM3j_SWXImT0Rg.png\",\"bertanggungjawab\":\"1\"}', '2022-01-18 18:47:59', 'Sudah'),
(48, 1, 'Edit Detail Produk', '{\"nama_lama\":\"asdasdsadas11231\",\"nama_baru\":\"asdasdsadas11231\",\"harga_lama\":\"1,231,231\",\"harga_baru\":\"1,231,231\",\"foto_lama\":\"1-brjYnVlXwM3j_SWXImT0Rg.png\",\"foto_baru\":\"6564e6d48892e6ba325bda1ec27189c9b4b3b473_hq.jpg\",\"bertanggungjawab\":\"1\"}', '2022-01-18 18:48:45', 'Sudah'),
(49, 1, 'Edit Detail Produk', '{\"nama_lama\":\"asdasdsadas11231\",\"nama_baru\":\"asdasdsadas11231\",\"harga_lama\":\"1,231,231\",\"harga_baru\":\"1,231,231\",\"foto_lama\":\"6564e6d48892e6ba325bda1ec27189c9b4b3b473_hq.jpg\",\"foto_baru\":\"1-brjYnVlXwM3j_SWXImT0Rg.png\",\"bertanggungjawab\":\"1\"}', '2022-01-18 18:50:05', 'Sudah'),
(50, 1, 'Edit Detail Produk', '{\"nama_lama\":\"asdasdsadas11231\",\"nama_baru\":\"asdasdsadas11231\",\"harga_lama\":\"1,231,231\",\"harga_baru\":\"1,231,231\",\"foto_lama\":\"1-brjYnVlXwM3j_SWXImT0Rg.png\",\"foto_baru\":\"27661905_1607403089353960_2137003018_n.jpg\",\"bertanggungjawab\":\"1\"}', '2022-01-18 18:51:17', 'Sudah'),
(51, 1, 'Edit Detail Produk', '{\"nama_lama\":\"asdasdsadas11231\",\"nama_baru\":\"asdasdsadas11231\",\"harga_lama\":\"1,231,231\",\"harga_baru\":\"1,231,231\",\"foto_lama\":\"27661905_1607403089353960_2137003018_n.jpg\",\"foto_baru\":\"1-brjYnVlXwM3j_SWXImT0Rg.png\",\"bertanggungjawab\":\"1\"}', '2022-01-18 18:51:45', 'Sudah'),
(52, 1, 'Edit Detail Produk', '{\"nama_lama\":\"asdasdsadas11231\",\"nama_baru\":\"asdasdsadas11231\",\"harga_lama\":\"1,231,231\",\"harga_baru\":\"1,231,231\",\"foto_lama\":\"1-brjYnVlXwM3j_SWXImT0Rg.png\",\"foto_baru\":\"79f509f5451cf0e66e0fa92bcf45a79ee95793b4_hq.jpg\",\"bertanggungjawab\":\"1\"}', '2022-01-18 18:52:21', 'Sudah'),
(70, 1, 'Penjualan Barang Spesifik', '{\"jumlah_pembelian\":\"1\",\"harga_jual\":\"1,231,231\",\"stok_sebelumnya\":\"1499\",\"stok_sekarang\":1498,\"total_harga\":1231231}', '2022-01-20 22:18:04', 'Sudah'),
(71, 12, 'Penjualan Barang Spesifik', '{\"jumlah_pembelian\":\"1\",\"harga_jual\":\"345,453\",\"stok_sebelumnya\":\"3429\",\"stok_sekarang\":3428,\"total_harga\":345453}', '2022-01-20 22:18:04', 'Sudah'),
(72, 14, 'Penjualan Barang Spesifik', '{\"jumlah_pembelian\":\"1\",\"harga_jual\":\"345,234\",\"stok_sebelumnya\":\"2319\",\"stok_sekarang\":2318,\"total_harga\":345234}', '2022-01-20 22:18:04', 'Sudah'),
(73, NULL, 'Penjualan Produk', '{\"total_belanja\":\"1,921,918\",\"pembayaran\":\"1,940,000\",\"baki\":\"18,082\",\"ket\":[{\"id\":1,\"kode_barang\":\"123asd\",\"jumlah\":\"1\",\"harga_jual\":\"1,231,231\",\"nama\":\"asdasdsadas11231\",\"total\":1231231,\"jumlah_stok_sebelumnya\":\"1499\",\"jumlah_stok_sekarang\":1498},{\"id\":12,\"kode_barang\":\"134ash\",\"jumlah\":\"1\",\"harga_jual\":\"345,453\",\"nama\":\"asdasd\",\"total\":345453,\"jumlah_stok_sebelumnya\":\"3429\",\"jumlah_stok_sekarang\":3428},{\"id\":14,\"kode_barang\":\"asd565\",\"jumlah\":\"1\",\"harga_jual\":\"345,234\",\"nama\":\"fdsfsdf\",\"total\":345234,\"jumlah_stok_sebelumnya\":\"2319\",\"jumlah_stok_sekarang\":2318}]}', '2022-01-20 22:18:04', 'Sudah'),
(74, 1, 'Penjualan Barang Spesifik', '{\"jumlah_pembelian\":\"1\",\"harga_jual\":\"1,231,231\",\"stok_sebelumnya\":\"1498\",\"stok_sekarang\":1497,\"total_harga\":1231231}', '2022-01-20 22:22:09', 'Sudah'),
(75, 12, 'Penjualan Barang Spesifik', '{\"jumlah_pembelian\":\"1\",\"harga_jual\":\"345,453\",\"stok_sebelumnya\":\"3428\",\"stok_sekarang\":3427,\"total_harga\":345453}', '2022-01-20 22:22:09', 'Sudah'),
(76, NULL, 'Penjualan Produk', '{\"total_belanja\":\"1,576,684\",\"pembayaran\":\"1,600,000\",\"baki\":\"23,316\",\"ket\":[{\"id\":1,\"kode_barang\":\"123asd\",\"jumlah\":\"1\",\"harga_jual\":\"1,231,231\",\"nama\":\"asdasdsadas11231\",\"total\":1231231,\"jumlah_stok_sebelumnya\":\"1498\",\"jumlah_stok_sekarang\":1497},{\"id\":12,\"kode_barang\":\"134ash\",\"jumlah\":\"1\",\"harga_jual\":\"345,453\",\"nama\":\"asdasd\",\"total\":345453,\"jumlah_stok_sebelumnya\":\"3428\",\"jumlah_stok_sekarang\":3427}]}', '2022-01-20 22:22:09', 'Sudah'),
(77, 1, 'Edit Detail Produk', '{\"nama_lama\":\"asdasdsadas11231\",\"nama_baru\":\"asda\",\"harga_lama\":\"1,231,231\",\"harga_baru\":\"123,123\",\"foto_lama\":\"79f509f5451cf0e66e0fa92bcf45a79ee95793b4_hq.jpg\",\"foto_baru\":\"brothers.jpg\",\"bertanggungjawab\":\"1\"}', '2022-01-20 23:59:52', 'Sudah'),
(78, 16, 'Penambahan Produk Baru', '{\"kode_barang\":\"gfh456\",\"nama\":\"dfgdfg\",\"harga_jual\":\"50,000\",\"jumlah\":\"200\",\"pembelian_stok\":\"5,000,000\",\"bertanggungjawab\":\"1\"}', '2022-01-21 04:03:41', 'Sudah'),
(79, 16, 'Penambahan Stok', '{\"penambahan_stok\":\"20\",\"harga_pembelian_stok\":\"200,000\",\"total_stok\":\"220\",\"jumlah_stok_sebelumnya\":\"200\",\"bertanggungjawab\":\"1\"}', '2022-01-21 04:04:39', 'Sudah'),
(80, 16, 'Edit Detail Produk', '{\"nama_lama\":\"dfgdfg\",\"nama_baru\":\"dfgdfg\",\"harga_lama\":\"50,000\",\"harga_baru\":\"50,000\",\"foto_lama\":\"wp1987505-gin-ichimaru-wallpapers.jpg\",\"foto_baru\":\"wp1987423-gin-ichimaru-wallpapers.jpg\",\"bertanggungjawab\":\"1\"}', '2022-01-24 04:05:21', 'Sudah'),
(81, 16, 'Edit Detail Produk', '{\"nama_lama\":\"dfgdfg\",\"nama_baru\":\"dfgdfg\",\"harga_lama\":\"50,000\",\"harga_baru\":\"50,000\",\"foto_lama\":\"wp1987423-gin-ichimaru-wallpapers.jpg\",\"foto_baru\":\"wp1987433-gin-ichimaru-wallpapers.jpg\",\"bertanggungjawab\":\"1\"}', '2022-01-24 04:08:36', 'Sudah'),
(82, 3, 'Penjualan Barang Spesifik', '{\"jumlah_pembelian\":\"2\",\"harga_jual\":\"345,546\",\"stok_sebelumnya\":\"4572\",\"stok_sekarang\":4570,\"total_harga\":691092}', '2022-01-21 06:45:41', 'Sudah'),
(83, 16, 'Penjualan Barang Spesifik', '{\"jumlah_pembelian\":\"2\",\"harga_jual\":\"50,000\",\"stok_sebelumnya\":\"220\",\"stok_sekarang\":218,\"total_harga\":100000}', '2022-01-21 04:09:37', 'Sudah'),
(84, NULL, 'Penjualan Produk', '{\"total_belanja\":\"791,092\",\"pembayaran\":\"800,000\",\"baki\":\"8,908\",\"ket\":[{\"id\":3,\"kode_barang\":\"456dfg\",\"jumlah\":\"2\",\"harga_jual\":\"345,546\",\"nama\":\"sdfgsdf\",\"total\":691092,\"jumlah_stok_sebelumnya\":\"4572\",\"jumlah_stok_sekarang\":4570},{\"id\":16,\"kode_barang\":\"gfh456\",\"jumlah\":\"2\",\"harga_jual\":\"50,000\",\"nama\":\"dfgdfg\",\"total\":100000,\"jumlah_stok_sebelumnya\":\"220\",\"jumlah_stok_sekarang\":218}]}', '2022-01-24 04:09:37', 'Sudah');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `tb_barang`
--
ALTER TABLE `tb_barang`
ADD PRIMARY KEY (`no_barang`),
ADD UNIQUE KEY `kode_barang` (`kode_barang`);
--
-- Indexes for table `tb_login`
--
ALTER TABLE `tb_login`
ADD PRIMARY KEY (`no_login`);
--
-- Indexes for table `tb_log_history`
--
ALTER TABLE `tb_log_history`
ADD PRIMARY KEY (`no_log`),
ADD KEY `no_barang` (`no_barang`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `tb_barang`
--
ALTER TABLE `tb_barang`
MODIFY `no_barang` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `tb_login`
--
ALTER TABLE `tb_login`
MODIFY `no_login` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `tb_log_history`
--
ALTER TABLE `tb_log_history`
MODIFY `no_log` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=85;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `tb_log_history`
--
ALTER TABLE `tb_log_history`
ADD CONSTRAINT `tb_log_history_ibfk_1` FOREIGN KEY (`no_barang`) REFERENCES `tb_barang` (`no_barang`) ON DELETE CASCADE ON UPDATE CASCADE;
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 */;
Reference in New Issue View Git Blame Copy Permalink