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,status_otorisasi,harga_skrg) VALUES ('F326181010511','input','1',' MDB1 HW ','TOKO','PM-B','B1D-ZEAF-112-0','GW ITALY PANJANG PITA VAR HW 8K ','','0.840','1','100.00','907000','0','0','15000','900000','0','0','0','900000','AAT','00403906','B1D','0','0','-','1','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-05-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZEAF-112-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.840',berat_jual_asli=berat_jual_asli+'0.840',stock_jual='1',berat_akhir=berat_akhir-'0.840',berat_akhir_asli=berat_akhir_asli-'0.840',stock_akhir='0' WHERE tanggal='2026-05-18' AND kode_barang='B1D-ZEAF-112-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' 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 ('F326181010511','2026-05-18','0.840','2026-05-18','10:10:51','PLG0029235','900000','900000','0','900000','900000','input','2026-05-18 10:10:51','F32618101051');
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-18','F326181010511','2026-05-18','10:10:51','AAT','900000','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-260518-0002','D','2026-05-18','10:10:51','input','PENJUALAN','F326181010511','5056658000','900000','5057558000');
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,status_otorisasi,harga_skrg) VALUES ('F326181029331','input','1',' MDE2X 10K ','TOKO','PM-E','E2D-ZDAC-99-0','CC X WEDDING MATA CM 12 8K ','','2.000','1','100.00','2140000','0','0','15000','2140000','0','10000','0','2150000','FIT','00399269','E2D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-05-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDAC-99-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-05-18' AND kode_barang='E2D-ZDAC-99-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' 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 ('F326181029331','2026-05-18','2.000','2026-05-18','10:29:34','PLG0029236','2140000','2140000','10000','2150000','2150000','input','2026-05-18 10:29:33','F32618102933');
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-18','F326181029331','2026-05-18','10:29:34','FIT','2150000','10000');
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-260518-0003','D','2026-05-18','10:29:34','input','PENJUALAN','F326181029331','5057558000','2150000','5059708000');
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,status_otorisasi,harga_skrg) VALUES ('F326181043201','input','1',' MGB1G X AV','TOKO','PM-B','B1G-ZEXI-77-0','GW X TUSUK MRICAN SLEP AV 8K ','','0.250','1','100.00','282000','0','0','15000','282000','0','0','0','282000','AAT','00402898','B1G','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZEXI-77-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-05-18' AND kode_barang='B1G-ZEXI-77-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' 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 ('F326181043201','2026-05-18','0.250','2026-05-18','10:43:20','PLG0029237','282000','282000','0','282000','282000','input','2026-05-18 10:43:20','F32618104320');
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-18','F326181043201','2026-05-18','10:43:20','AAT','282000','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-260518-0004','D','2026-05-18','10:43:20','input','PENJUALAN','F326181043201','5059708000','282000','5059990000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='282000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326181043201' 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,status_otorisasi,harga_skrg) VALUES ('F326181043202','input',' 1',' MHD1 LG ','TOKO','PM-D','D1H-ZACX-200-0','LT SLOBOK KUPU ARESO LG 8K ','GL TALI HITAM','0.280','1','100.00','322000','0','0','15000','323000','0','30000','0','353000','AAT','00387501','D1H','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-05-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1H-ZACX-200-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.280',berat_jual_asli=berat_jual_asli+'0.280',stock_jual='1',berat_akhir=berat_akhir-'0.280',berat_akhir_asli=berat_akhir_asli-'0.280',stock_akhir='0' WHERE tanggal='2026-05-18' AND kode_barang='D1H-ZACX-200-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' 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 ('F326181043202','2026-05-18','0.280','2026-05-18','10:43:20','PLG0029238','323000','323000','30000','353000','353000','input','2026-05-18 10:43:20','F32618104320');
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-18','F326181043202','2026-05-18','10:43:20','AAT','353000','30000');
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-260518-0005','D','2026-05-18','10:43:20','input','PENJUALAN','F326181043202','5059990000','353000','5060343000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='353000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326181043202' 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,status_otorisasi,harga_skrg) VALUES ('F326181112511','input','1',' MEB1 X YT ','TOKO','PM-B','B1E-ZDBX-240-0','GW X MODEL SLEP YT 8K ','','0.580','1','100.00','632000','0','0','15000','633000','0','0','0','633000','LIS','00400177','B1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDBX-240-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-05-18' AND kode_barang='B1E-ZDBX-240-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' 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 ('F326181112511','2026-05-18','0.580','2026-05-18','11:12:51','PLG0029239','633000','633000','0','633000','633000','input','2026-05-18 11:12:51','F32618111251');
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-18','F326181112511','2026-05-18','11:12:51','LIS','633000','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-260518-0006','D','2026-05-18','11:12:51','input','PENJUALAN','F326181112511','5060343000','633000','5060976000');
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,status_otorisasi,harga_skrg) VALUES ('F326181125481','input','1',' TDE1 CM 14','TOKO','PT-E','E1TD-ZDXF-34-T','CC VELG POLOS CM 14 17K ','','1.050','1','100.00','2068000','0','0','15000','2068000','0','0','0','2068000','SIN','T0078496','E1TD','0','0','-','0','1970000');
UPDATE tm_barang SET tgl_last_jual='2026-05-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-ZDXF-34-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-05-18' AND kode_barang='E1TD-ZDXF-34-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-E' 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 ('F326181125481','2026-05-18','1.050','2026-05-18','11:25:49','PLG0029240','2068000','2068000','0','2068000','2068000','input','2026-05-18 11:25:48','F32618112548');
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-18','F326181125481','2026-05-18','11:25:49','SIN','2068000','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-260518-0007','D','2026-05-18','11:25:49','input','PENJUALAN','F326181125481','5060976000','2068000','5063044000');
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,status_otorisasi,harga_skrg) VALUES ('F326181200171','input','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZEXI-264-0','CC X MODEL SPECTRA CM 18 8K ','','1.100','1','100.00','1177000','0','0','15000','1178000','0','0','0','1178000','SIN','00403085','E1D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-05-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEXI-264-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2026-05-18' AND kode_barang='E1D-ZEXI-264-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' 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 ('F326181200171','2026-05-18','1.100','2026-05-18','12:00:17','PLG0029241','1178000','1178000','0','1178000','1178000','input','2026-05-18 12:00:17','F32618120017');
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-18','F326181200171','2026-05-18','12:00:17','SIN','1178000','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-260518-0008','D','2026-05-18','12:00:17','input','PENJUALAN','F326181200171','5063044000','1178000','5064222000');
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,status_otorisasi,harga_skrg) VALUES ('F326181211371','input','1',' MEF3 HW ','TOKO','PM-F','F3E-ZDCX-8-0','GL MODEL CAPELA ARESO VAR HW 8K ','','3.200','1','100.00','3488000','0','0','15000','3490000','0','0','0','3490000','AAT','00401867','F3E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDCX-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.200',berat_jual_asli=berat_jual_asli+'3.200',stock_jual='1',berat_akhir=berat_akhir-'3.200',berat_akhir_asli=berat_akhir_asli-'3.200',stock_akhir='0' WHERE tanggal='2026-05-18' AND kode_barang='F3E-ZDCX-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' 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 ('F326181211371','2026-05-18','3.200','2026-05-18','12:11:38','PLG0029242','3490000','3490000','0','3490000','3490000','input','2026-05-18 12:11:37','F32618121137');
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-18','F326181211371','2026-05-18','12:11:38','AAT','3490000','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-260518-0009','D','2026-05-18','12:11:38','input','PENJUALAN','F326181211371','5064222000','3490000','5067712000');
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,status_otorisasi,harga_skrg) VALUES ('F326181236061','input','1',' MEH1 HW ','TOKO','PM-H','H1E-ZDBC-194-0','KL SANTA MODEL 3C VAR HW 8K ','','2.280','1','100.00','2485000','0','0','15000','2485000','0','0','0','2485000','FIT','00400916','H1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDBC-194-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.280',berat_jual_asli=berat_jual_asli+'2.280',stock_jual='1',berat_akhir=berat_akhir-'2.280',berat_akhir_asli=berat_akhir_asli-'2.280',stock_akhir='0' WHERE tanggal='2026-05-18' AND kode_barang='H1E-ZDBC-194-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' 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 ('F326181236061','2026-05-18','2.280','2026-05-18','12:36:06','PLG0029243','2485000','2485000','0','2485000','2485000','input','2026-05-18 12:36:06','F32618123606');
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-18','F326181236061','2026-05-18','12:36:06','FIT','2485000','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-260518-0010','D','2026-05-18','12:36:06','input','PENJUALAN','F326181236061','5067712000','2485000','5070197000');
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,status_otorisasi,harga_skrg) VALUES ('F326180125081','input','1',' MDE1 CM 12','TOKO','PM-E','E1D-YCXE-112-0','CC MODEL BUNGA VAR CM 12 8K ','','0.950','1','100.00','1016000','0','0','15000','1015000','0','0','0','1015000','LIS','00341917','E1D','0','0','-','1','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-05-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YCXE-112-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-05-18' AND kode_barang='E1D-YCXE-112-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' 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 ('F326180125081','2026-05-18','0.950','2026-05-18','13:25:09','PLG0029244','1015000','1015000','0','1015000','1015000','input','2026-05-18 13:25:08','F32618012508');
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-18','F326180125081','2026-05-18','13:25:09','LIS','1015000','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-260518-0011','D','2026-05-18','13:25:09','input','PENJUALAN','F326180125081','5070197000','1015000','5071212000');
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,status_otorisasi,harga_skrg) VALUES ('F326180135241','input','1',' MEE2 X UB ','TOKO','PM-E','E2E-ZDBX-307-0','CC X MODEL MATA UB 10 8K ','','0.680','1','100.00','741000','0','0','15000','740000','0','0','0','740000','AAT','00400244','E2E','0','0','-','1','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDBX-307-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2026-05-18' AND kode_barang='E2E-ZDBX-307-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' 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 ('F326180135241','2026-05-18','0.680','2026-05-18','13:35:24','PLG0029245','740000','740000','0','740000','740000','input','2026-05-18 13:35:24','F32618013524');
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-18','F326180135241','2026-05-18','13:35:24','AAT','740000','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-260518-0012','D','2026-05-18','13:35:24','input','PENJUALAN','F326180135241','5071212000','740000','5071952000');
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,status_otorisasi,harga_skrg) VALUES ('F326180145531','input','1',' MEE1 LG 15','TOKO','PM-E','E1D-ZEAE-233-0','CC MODEL LINEA SLEP LG 15 8K','','0.450','1','100.00','486000','0','0','15000','490000','0','0','0','490000','AAT','00403711','E1D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-05-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEAE-233-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-05-18' AND kode_barang='E1D-ZEAE-233-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' 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 ('F326180145531','2026-05-18','0.450','2026-05-18','13:45:53','PLG0029246','490000','490000','0','490000','490000','input','2026-05-18 13:45:53','F32618014553');
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-18','F326180145531','2026-05-18','13:45:53','AAT','490000','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-260518-0013','D','2026-05-18','13:45:53','input','PENJUALAN','F326180145531','5071952000','490000','5072442000');
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-00019138','X-00019138','KL X GUCCI UB 44 8K','GR','---','H1E','BELI','BELI001','3017000','2026-05-18','2.950','1','kasir','2026-05-18 14:00:24');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00019138','X-00019138');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260518-0001','F326261040391','LIS','1','BELI','BELI001','H1E', 'X-00019138', 'KL X GUCCI UB 44 8K','2.950','2.950','100.00','3348000','3017000','1022712','1100000','1','3017000','3017000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.950',berat_beli_asli=berat_beli_asli+'2.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.950',berat_akhir_asli=berat_akhir_asli+'2.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' 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) VALUES ('FB-260518-0001','2026-05-18','2026-05-18','14:00:24','LIS','---','2.950','3017000','3017000','3017000','3017000','3017000','kasir','2026-05-18 14:00:24','FB-260518-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260518-0001','00400095','JERUK PACITAN','','','0859171710494','kasir','2026-05-18 14:00:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-18' 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) VALUES ('KK-260518-0014','K','2026-05-18','14:00:24','kasir','PEMBELIAN UMUM','FB-260518-0001','5072442000','3017000','5069425000');
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-00019139','X-00019139','LT X MODEL HURUF MATA LG T 8K','GR','---','D2F','BELI','BELI001','480000','2026-05-18','0.460','1','kasir','2026-05-18 14:00:24');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2F','X-00019139','X-00019139');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260518-0002','F326261040393','LIS','2','BELI','BELI001','D2F', 'X-00019139', 'LT X MODEL HURUF MATA LG T 8K','0.460','0.460','100.00','531000','480000','1043478','1120000','1','480000','480000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.460',berat_beli_asli=berat_beli_asli+'0.460',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.460',berat_akhir_asli=berat_akhir_asli+'0.460',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2F' 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) VALUES ('FB-260518-0002','2026-05-18','2026-05-18','14:00:24','LIS','---','0.460','480000','480000','480000','480000','480000','kasir','2026-05-18 14:00:24','FB-260518-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260518-0002','TRIWAHYUNI','JERUK PACITAN','','','0859171710494','kasir','2026-05-18 14:00:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-18' 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) VALUES ('KK-260518-0015','K','2026-05-18','14:00:24','kasir','PEMBELIAN UMUM','FB-260518-0002','5069425000','480000','5068945000');
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-00019140','X-00019140','CC COR M 8K','GR','---','E2E','BELI','BELI001','635000','2026-05-18','1.010','1','kasir','2026-05-18 14:01:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00019140','X-00019140');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260518-0003','F323051203532','AAT','1','BELI','BELI001','E2E', 'X-00019140', 'CC COR M 8K','1.010','1.010','100.00','472000','635000','628713','1100000','1','635000','635000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.010',berat_beli_asli=berat_beli_asli+'1.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.010',berat_akhir_asli=berat_akhir_asli+'1.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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) VALUES ('FB-260518-0003','2026-05-18','2026-05-18','14:01:29','AAT','---','1.010','635000','635000','635000','635000','635000','kasir','2026-05-18 14:01:30','FB-260518-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260518-0003','ZIAN','TEMULAWAK BULUKERTO','','','','kasir','2026-05-18 14:01:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-18' 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) VALUES ('KK-260518-0016','K','2026-05-18','14:01:29','kasir','PEMBELIAN UMUM','FB-260518-0003','5068945000','635000','5068310000');
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-00019141','X-00019141','KL RANTAI HOLLOW UB 42CM 17K','GR','---','H1TE','BELI','BELI001','1932000','2026-05-18','1.050','1','kasir','2026-05-18 14:02:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1TE','X-00019141','X-00019141');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260518-0004','F326170931261','LIS','1','BELI','BELI001','H1TE', 'X-00019141', 'KL RANTAI HOLLOW UB 42CM 17K','1.050','1.050','100.00','2258000','1932000','1840000','1990000','1','1932000','1932000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.050',berat_beli_asli=berat_beli_asli+'1.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.050',berat_akhir_asli=berat_akhir_asli+'1.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1TE' 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) VALUES ('FB-260518-0004','2026-05-18','2026-05-18','14:02:02','LIS','---','1.050','1932000','1932000','1932000','1932000','1932000','kasir','2026-05-18 14:02:02','FB-260518-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260518-0004','AIRA','SUMBER GALIH 5/3','','','088215675056','kasir','2026-05-18 14:02:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-18' 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) VALUES ('KK-260518-0017','K','2026-05-18','14:02:02','kasir','PEMBELIAN UMUM','FB-260518-0004','5068310000','1932000','5066378000');
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-00019142','X-00019142','CC X MODEL MATA LG 4 8K','GR','---','E2E','BELI','BELI001','620000','2026-05-18','0.880','1','kasir','2026-05-18 14:02:45');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00019142','X-00019142');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260518-0005','F324131052441','AAT','1','BELI','BELI001','E2E', 'X-00019142', 'CC X MODEL MATA LG 4 8K','0.880','0.880','100.00','538000','620000','704545','1100000','1','620000','620000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.880',berat_beli_asli=berat_beli_asli+'0.880',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.880',berat_akhir_asli=berat_akhir_asli+'0.880',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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) VALUES ('FB-260518-0005','2026-05-18','2026-05-18','14:02:44','AAT','---','0.880','620000','620000','620000','620000','620000','kasir','2026-05-18 14:02:45','FB-260518-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260518-0005','IMELIA','SENDANG JANGKUNG','','','','kasir','2026-05-18 14:02:45');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-18' 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) VALUES ('KK-260518-0018','K','2026-05-18','14:02:44','kasir','PEMBELIAN UMUM','FB-260518-0005','5066378000','620000','5065758000');
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-00019143','X-00019143','CC BANGKOK SLEP DG 18 17K','GR','---','E0TA','BELI','BELI001','810000','2026-05-18','0.500','1','kasir','2026-05-18 14:03:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-E0TA';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E0TA','X-00019143','X-00019143');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260518-0006','F326281030591','SIN','1','BELI','BELI001','E0TA', 'X-00019143', 'CC BANGKOK SLEP DG 18 17K','0.500','0.500','100.00','975000','810000','1620000','1900000','1','810000','810000','RUSAK');
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-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E0TA' 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) VALUES ('FB-260518-0006','2026-05-18','2026-05-18','14:03:06','SIN','---','0.500','810000','810000','810000','810000','810000','kasir','2026-05-18 14:03:06','FB-260518-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260518-0006','SRIATI','KEPYAR','','','','kasir','2026-05-18 14:03:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-18' 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) VALUES ('KK-260518-0019','K','2026-05-18','14:03:06','kasir','PEMBELIAN UMUM','FB-260518-0006','5065758000','810000','5064948000');
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-00019144','X-00019144','GL COR T 8K','GR','---','F1F','BELI','BELI001','1765000','2026-05-18','2.320','1','kasir','2026-05-18 14:06:45');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1F','X-00019144','X-00019144');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260518-0007','F323010854471','SIN','1','BELI','BELI001','F1F', 'X-00019144', 'GL COR T 8K','2.320','2.320','100.00','1090000','1765000','760776','1120000','1','1765000','1765000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.320',berat_beli_asli=berat_beli_asli+'2.320',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.320',berat_akhir_asli=berat_akhir_asli+'2.320',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1F' 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) VALUES ('FB-260518-0007','2026-05-18','2026-05-18','14:06:44','SIN','---','2.320','1765000','1765000','1765000','1765000','1765000','kasir','2026-05-18 14:06:45','FB-260518-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260518-0007','SSRI WAHYUNI','PLOSO PUHPELEM','','','','kasir','2026-05-18 14:06:45');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-18' 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) VALUES ('KK-260518-0020','K','2026-05-18','14:06:44','kasir','PEMBELIAN UMUM','FB-260518-0007','5064948000','1765000','5063183000');
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-00019145','X-00019145','CC MODEL BINTANG POLOS LG 18 8K','GR','---','E1G','BELI','BELI001','330000','2026-05-18','0.350','1','kasir','2026-05-18 14:07:12');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1G','X-00019145','X-00019145');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260518-0008','F326010110061','SIN','1','BELI','BELI001','E1G', 'X-00019145', 'CC MODEL BINTANG POLOS LG 18 8K','0.350','0.350','100.00','418000','330000','942857','1130000','1','330000','330000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.350',berat_beli_asli=berat_beli_asli+'0.350',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.350',berat_akhir_asli=berat_akhir_asli+'0.350',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1G' 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) VALUES ('FB-260518-0008','2026-05-18','2026-05-18','14:07:11','SIN','---','0.350','330000','330000','330000','330000','330000','kasir','2026-05-18 14:07:12','FB-260518-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260518-0008','MAURA','PUHPELEM','','','','kasir','2026-05-18 14:07:12');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-18' 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) VALUES ('KK-260518-0021','K','2026-05-18','14:07:11','kasir','PEMBELIAN UMUM','FB-260518-0008','5063183000','330000','5062853000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180125081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180125081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180125081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180135241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180135241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180135241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180145531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180145531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180145531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181010511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181010511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181010511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181029331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181029331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181029331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181043201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181043201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181043201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181043202' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181043202' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181043202';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181112511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181112511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181112511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181125481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181125481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181125481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181200171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181200171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181200171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181211371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181211371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181211371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181236061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181236061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181236061';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260518-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260518-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260518-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260518-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260518-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260518-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260518-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260518-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260518-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260518-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260518-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260518-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260518-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260518-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260518-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260518-0008';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-19','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-18';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-18';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-18';
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-18' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-18';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-18';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-18';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-18';
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-19' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-18' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
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-260519-0001','D','2026-05-19','15:15:07','SYSTEM','SALDO AWAL','SALDO AWAL','0','5062853000','5062853000');
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-260519-0001','D','2026-05-19','15:15:07','BCA','SALDO AWAL','SALDO AWAL','0','712562000','712562000');
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-260519-0001','D','2026-05-19','15:15:07','BRI','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-260519-0001','D','2026-05-19','15:15:07','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-05-19';