INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-05-17 ','08:35:14');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-17','148','0','51200000','148','0','51200000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-16';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-16';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-16';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-05-16' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-16';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-16';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-16';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-16';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-17' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-16' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260517-0001','D','2026-05-17','08:35:33','','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260517-0001','D','2026-05-17','08:35:33','BCA','SALDO AWAL','SALDO AWAL','0','2025700276','2025700276');
UPDATE tp_system SET tgl_system='2026-05-17';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-05-17 ','08:36:03');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-05-17 ','08:45:38');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260517-0001','sales','1',' ','TOKO','BTLTMD','MDLT-ZBAI-25-0','MN COR FORTUNE MK ','','0.530','1','100.00','602000','0','0','0','602000','0','0','0','602000','2105','00028401','MDLT','159000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDLT-ZBAI-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-05-17' AND kode_barang='MDLT-ZBAI-25-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTLTMD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260517-0001','2026-05-17','0.530','2026-05-17','09:59:22','PLG0018805','602000','602000','0','602000','602000','sales','2026-05-17 09:59:21','FJ-260517-0001');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-17','FJ-260517-0001','2026-05-17','09:59:22','2105','602000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260517-0002','D','2026-05-17','09:59:22','sales','PENJUALAN','FJ-260517-0001','145440064','602000','146042064');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0001';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009479','X-00009479','AT ITALY BT SHB','GR','---','MDAT','BELI','BELI001','1307500','2026-05-17','1.340','1','sales','2026-05-17 10:23:24');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDAT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDAT','X-00009479','X-00009479');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260517-0001','FJ-260403-0003','2501','1','BELI','BELI001','MDAT', 'X-00009479', 'AT ITALY BT SHB','1.340','1.340','100.00','1568000','1307500','975746','1','1307500','1307500','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-05-17','BELI','BELI001','MDAT','MDAT','100.00','1.340','1.340','1','1.340','1.340','1');
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260517-0001','2026-05-17','2026-05-17','10:23:24','2501','---','1.340','1307500','1307500','1307500','1307500','1307500','sales','2026-05-17 10:23:24','FB-260517-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260517-0001','FITRIA','BLK BTG SUROPATI 5B/21','','','','sales','2026-05-17 10:23:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260517-0003','K','2026-05-17','10:23:24','sales','PEMBELIAN UMUM','FB-260517-0001','146042064','1307500','144734564','OPEN');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260517-0002','sales','1',' ','TOKO','BTATMT','MTAT-XLBG-28-0','AT ITALY BT SHB ','','1.130','1','100.00','2136000','0','0','0','2136000','0','0','0','2136000','2501','00022489','MTAT','227000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-XLBG-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2026-05-17' AND kode_barang='MTAT-XLBG-28-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMT' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260517-0002','2026-05-17','1.130','2026-05-17','10:27:38','PLG0018806','2136000','2136000','0','2136000','1307500','sales','2026-05-17 10:27:37','FJ-260517-0002');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-17','FJ-260517-0002','2026-05-17','10:27:38','2501','2136000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260517-0004','D','2026-05-17','10:27:38','sales','PENJUALAN','FJ-260517-0002','144734564','1307500','146042064','OPEN');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260517-0001','2026-05-17','2026-05-17 10:27:37','PENJUALAN : FJ-260517-0002','bca','BCA','828500','828500','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260517-0002','D','2026-05-17','10:27:38','BCA','PENJUALAN','FJ-260517-0002','2025700276','828500','2026528776','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','RIMA SAFITRI');
UPDATE tt_jual_head SET dibayar_rp='1307500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='828500' WHERE no_faktur_jual='FJ-260517-0002' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260517-0003','sales',' 1',' ','TOKO','BTCNMT','MTCN-ZBXI-62-0','CN COR ANAK TDK BT SHB ','','0.660','1','100.00','1247500','0','0','0','1247500','0','0','0','1247500','2501','00027876','MTCN','227000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-ZBXI-62-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2026-05-17' AND kode_barang='MTCN-ZBXI-62-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMT' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260517-0003','2026-05-17','0.660','2026-05-17','10:27:38','PLG0018807','1247500','1247500','0','1247500','0','sales','2026-05-17 10:27:37','FJ-260517-0002');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-17','FJ-260517-0003','2026-05-17','10:27:38','2501','1247500','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260517-0002','2026-05-17','2026-05-17 10:27:37','PENJUALAN : FJ-260517-0003','bca','BCA','1247500','1247500','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260517-0003','D','2026-05-17','10:27:38','BCA','PENJUALAN','FJ-260517-0003','2026528776','1247500','2027776276','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','RIMA SAFITRI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1247500' WHERE no_faktur_jual='FJ-260517-0003' LIMIT 1;
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260517-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260517-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0003';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260517-0004','sales','1',' ','TOKO','BTCNMD','MDCN-ZEAB-6-0','CN COR DB ANGGUR SHB ','','0.970','1','100.00','1101000','0','0','0','1101000','0','0','0','1101000','2105','00029482','MDCN','159000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZEAB-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-05-17' AND kode_barang='MDCN-ZEAB-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260517-0004','2026-05-17','0.970','2026-05-17','10:56:09','PLG0018808','1101000','1101000','0','1101000','1101000','sales','2026-05-17 10:56:09','FJ-260517-0004');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-17','FJ-260517-0004','2026-05-17','10:56:09','2105','1101000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260517-0005','D','2026-05-17','10:56:09','sales','PENJUALAN','FJ-260517-0004','146042064','1101000','147143064');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0004';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009480','X-00009480','CN CAP ANAK TDK BT SHB','GR','---','MTCN','BELI','BELI001','831500','2026-05-17','0.500','1','sales','2026-05-17 12:39:01');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTCN','X-00009480','X-00009480');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260517-0002','FJ-230222-0011','2501','1','BELI','BELI001','MTCN', 'X-00009480', 'CN CAP ANAK TDK BT SHB','0.510','0.500','100.00','360000','831500','1663000','1','831500','831500','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTCN' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260517-0002','2026-05-17','2026-05-17','12:39:00','2501','---','0.500','831500','831500','831500','831500','831500','sales','2026-05-17 12:39:01','FB-260517-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260517-0002','KAYLA','MADURA','','','','sales','2026-05-17 12:39:01');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260517-0006','K','2026-05-17','12:39:00','sales','PEMBELIAN UMUM','FB-260517-0002','147143064','831500','146311564','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260517-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260517-0002';