INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260403-0001','1','B1D-ZBAD-244-0','1','0.800','0.800','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1D-ZBAD-244-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1D-ZBAD-244-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-04-03 07:58:47' WHERE kode_barang='B1D-ZBAD-244-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1D-ZBAD-244-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-03 07:58:47','TOKO','PM-B','B1D','B1D-ZBAD-244-0','1','0.800','0.800','1','0.800','0.800','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1D-ZBAD-244-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1D-ZBAD-244-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260403-0001','1','B1E-ZCCX-453-0','1','0.580','0.580','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZCCX-453-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZCCX-453-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-04-03 07:58:47' WHERE kode_barang='B1E-ZCCX-453-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZCCX-453-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-03 07:58:47','TOKO','PM-B','B1E','B1E-ZCCX-453-0','1','0.580','0.580','1','0.580','0.580','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZCCX-453-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZCCX-453-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260403-0001','2026-04-03','07:58','1.380','admpindah','2026-04-03 07:58:46');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260403-0001','1','H1E-ZCBX-262-0','1','1.960','1.960','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZCBX-262-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZCBX-262-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-04-03 07:59:11' WHERE kode_barang='H1E-ZCBX-262-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZCBX-262-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-03 07:59:11','TOKO','PM-H','H1E','H1E-ZCBX-262-0','1','1.960','1.960','1','1.960','1.960','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZCBX-262-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZCBX-262-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260403-0001','2026-04-03','07:59','1.960','admpindah','2026-04-03 07:59:11');
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 ('F326030849111','input','1',' MEF3 HW ','TOKO','PM-F','F3E-ZBAF-91-0','GL HARLEY MODEL DAUN VAR HW 8K ','','1.830','1','100.00','2123000','0','0','15000','2123000','0','0','0','2123000','FIT','00390063','F3E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAF-91-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.830',berat_jual_asli=berat_jual_asli+'1.830',stock_jual='1',berat_akhir=berat_akhir-'1.830',berat_akhir_asli=berat_akhir_asli-'1.830',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='F3E-ZBAF-91-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 ('F326030849111','2026-04-03','1.830','2026-04-03','08:49:12','PLG0028385','2123000','2123000','0','2123000','2123000','input','2026-04-03 08:49:11','F32603084911');
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-04-03','F326030849111','2026-04-03','08:49:12','FIT','2123000','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-260403-0002','D','2026-04-03','08:49:12','input','PENJUALAN','F326030849111','4123310000','2123000','4125433000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2123000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326030849111' 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 ('F326030849112','input',' 1',' MEH1 XXX K','TOKO','PM-H','H1E-ZCAD-74-0','KL XXX NORI KH 44 8K ','','2.010','1','100.00','2332000','0','0','15000','2272000','0','0','0','2272000','FIT','00394202','H1E','0','0','-','1','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCAD-74-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.010',berat_jual_asli=berat_jual_asli+'2.010',stock_jual='1',berat_akhir=berat_akhir-'2.010',berat_akhir_asli=berat_akhir_asli-'2.010',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='H1E-ZCAD-74-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 ('F326030849112','2026-04-03','2.010','2026-04-03','08:49:12','PLG0028386','2272000','2272000','0','2272000','2272000','input','2026-04-03 08:49:11','F32603084911');
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-04-03','F326030849112','2026-04-03','08:49:12','FIT','2272000','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-260403-0003','D','2026-04-03','08:49:12','input','PENJUALAN','F326030849112','4125433000','2272000','4127705000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2272000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326030849112' 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 ('F326030906021','input','1',' TEF1 UB D6','TOKO','PT-F','F1TE-XKBB-53-T','GL OVAL MODEL C UB D60 17K ','','2.100','1','100.00','4441000','0','0','15000','4440000','0','0','0','4440000','AAT','T0064225','F1TE','0','0','-','1','2115000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TE-XKBB-53-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='F1TE-XKBB-53-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326030906021','2026-04-03','2.100','2026-04-03','09:06:03','PLG0028387','4440000','4440000','0','4440000','4440000','input','2026-04-03 09:06:02','F32603090602');
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-04-03','F326030906021','2026-04-03','09:06:03','AAT','4440000','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-260403-0004','D','2026-04-03','09:06:03','input','PENJUALAN','F326030906021','4127705000','4440000','4132145000');
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 ('F326030908421','input','1',' MDE2 X BM ','TOKO','PM-E','E2D-ZBXF-71-0','CC X MODEL MATA BM 22 8K ','','1.560','1','100.00','1778000','0','0','15000','1778000','0','0','0','1778000','SIN','00388653','E2D','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZBXF-71-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.560',berat_jual_asli=berat_jual_asli+'1.560',stock_jual='1',berat_akhir=berat_akhir-'1.560',berat_akhir_asli=berat_akhir_asli-'1.560',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='E2D-ZBXF-71-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 ('F326030908421','2026-04-03','1.560','2026-04-03','09:08:43','PLG0028388','1778000','1778000','0','1778000','1778000','input','2026-04-03 09:08:42','F32603090842');
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-04-03','F326030908421','2026-04-03','09:08:43','SIN','1778000','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-260403-0005','D','2026-04-03','09:08:43','input','PENJUALAN','F326030908421','4132145000','1778000','4133923000');
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 ('F326030937321','input','1',' MEE2 X LG ','TOKO','PM-E','E2E-ZCBE-240-0','CC X BONEKA ANAK CAT MATA LG 8K ','','0.550','1','100.00','638000','0','0','15000','639000','0','0','0','639000','AAT','00396702','E2E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCBE-240-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='E2E-ZCBE-240-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 ('F326030937321','2026-04-03','0.550','2026-04-03','09:37:32','PLG0028389','639000','639000','0','639000','639000','input','2026-04-03 09:37:32','F32603093732');
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-04-03','F326030937321','2026-04-03','09:37:32','AAT','639000','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-260403-0006','D','2026-04-03','09:37:32','input','PENJUALAN','F326030937321','4133923000','639000','4134562000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='639000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326030937321' 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 ('F326030937322','input',' 1',' MEE2 X KH ','TOKO','PM-E','E2E-XDXF-321-0','CC X MODEL MATA KH 16 8K ','','1.020','1','100.00','1183000','0','0','15000','1183000','0','0','0','1183000','AAT','00290441','E2E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-XDXF-321-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='E2E-XDXF-321-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 ('F326030937322','2026-04-03','1.020','2026-04-03','09:37:32','PLG0028390','1183000','1183000','0','1183000','1183000','input','2026-04-03 09:37:32','F32603093732');
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-04-03','F326030937322','2026-04-03','09:37:32','AAT','1183000','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-260403-0007','D','2026-04-03','09:37:32','input','PENJUALAN','F326030937322','4134562000','1183000','4135745000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1183000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326030937322' 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 ('F326031001041','input','1',' MEE1 X UB ','TOKO','PM-E','E1E-ZCAI-589-0','CC X MODEL SLEP UB 12 8K ','','0.450','1','100.00','522000','0','0','15000','523000','0','0','0','523000','LIS','00395987','E1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAI-589-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-04-03' AND kode_barang='E1E-ZCAI-589-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 ('F326031001041','2026-04-03','0.450','2026-04-03','10:01:04','PLG0028391','523000','523000','0','523000','523000','input','2026-04-03 10:01:04','F32603100104');
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-04-03','F326031001041','2026-04-03','10:01:04','LIS','523000','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-260403-0008','D','2026-04-03','10:01:04','input','PENJUALAN','F326031001041','4135745000','523000','4136268000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='523000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326031001041' 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 ('F326031001042','input',' 1',' MEE1 X CM ','TOKO','PM-E','E1E-ZCBE-242-0','CC X MODEL SLEP CM 12 8K ','','0.680','1','100.00','789000','0','0','15000','790000','0','0','0','790000','LIS','00396704','E1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCBE-242-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-04-03' AND kode_barang='E1E-ZCBE-242-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 ('F326031001042','2026-04-03','0.680','2026-04-03','10:01:04','PLG0028392','790000','790000','0','790000','790000','input','2026-04-03 10:01:04','F32603100104');
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-04-03','F326031001042','2026-04-03','10:01:04','LIS','790000','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-260403-0009','D','2026-04-03','10:01:04','input','PENJUALAN','F326031001042','4136268000','790000','4137058000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='790000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326031001042' 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 ('F326031002111','input','1',' MEF3E X UB','TOKO','PM-F','F3E-ZBXF-23-0','GL X CAPELLA SLEP UB 8K ','','2.190','1','100.00','2540000','0','0','15000','2540000','0','0','0','2540000','SIN','00388605','F3E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBXF-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.190',berat_jual_asli=berat_jual_asli+'2.190',stock_jual='1',berat_akhir=berat_akhir-'2.190',berat_akhir_asli=berat_akhir_asli-'2.190',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='F3E-ZBXF-23-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 ('F326031002111','2026-04-03','2.190','2026-04-03','10:02:12','PLG0028393','2540000','2540000','0','2540000','2540000','input','2026-04-03 10:02:11','F32603100211');
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-04-03','F326031002111','2026-04-03','10:02:12','SIN','2540000','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-260403-0010','D','2026-04-03','10:02:12','input','PENJUALAN','F326031002111','4137058000','2540000','4139598000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2540000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326031002111' 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 ('F326031002112','input',' 1',' MEE1 X BG ','TOKO','PM-E','E1E-XCAE-304-0','CC X MODEL SLEP BG 16 8K ','','1.000','1','100.00','1160000','0','0','15000','1160000','0','0','0','1160000','SIN','00286148','E1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-XCAE-304-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='E1E-XCAE-304-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 ('F326031002112','2026-04-03','1.000','2026-04-03','10:02:12','PLG0028394','1160000','1160000','0','1160000','1160000','input','2026-04-03 10:02:11','F32603100211');
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-04-03','F326031002112','2026-04-03','10:02:12','SIN','1160000','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-260403-0011','D','2026-04-03','10:02:12','input','PENJUALAN','F326031002112','4139598000','1160000','4140758000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1160000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326031002112' 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 ('F326031019391','input','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZCCX-519-0','CC X SPIRAL MATA CM 12 8K ','','1.330','1','100.00','1516000','0','0','15000','1516000','0','0','0','1516000','LIS','00397173','E2D','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCCX-519-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.330',berat_jual_asli=berat_jual_asli+'1.330',stock_jual='1',berat_akhir=berat_akhir-'1.330',berat_akhir_asli=berat_akhir_asli-'1.330',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='E2D-ZCCX-519-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 ('F326031019391','2026-04-03','1.330','2026-04-03','10:19:40','PLG0028395','1516000','1516000','0','1516000','1516000','input','2026-04-03 10:19:39','F32603101939');
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-04-03','F326031019391','2026-04-03','10:19:40','LIS','1516000','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-260403-0012','D','2026-04-03','10:19:40','input','PENJUALAN','F326031019391','4140758000','1516000','4142274000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1516000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326031019391' 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 ('F326031019392','input',' 1',' MEF3E X PM','TOKO','PM-F','F3E-ZAAE-47-0','GL X KREPYAK SISIK NAGA SLEP PM 8K ','','7.980','1','100.00','9257000','0','0','15000','9257000','0','0','0','9257000','LIS','00385296','F3E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZAAE-47-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'7.980',berat_jual_asli=berat_jual_asli+'7.980',stock_jual='1',berat_akhir=berat_akhir-'7.980',berat_akhir_asli=berat_akhir_asli-'7.980',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='F3E-ZAAE-47-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 ('F326031019392','2026-04-03','7.980','2026-04-03','10:19:40','PLG0028396','9257000','9257000','0','9257000','9257000','input','2026-04-03 10:19:39','F32603101939');
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-04-03','F326031019392','2026-04-03','10:19:40','LIS','9257000','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-260403-0013','D','2026-04-03','10:19:40','input','PENJUALAN','F326031019392','4142274000','9257000','4151531000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='9257000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326031019392' 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 ('F326031020531','input','1',' MDE1 X OR ','TOKO','PM-E','E1D-ZCCA-166-0','CC X MODEL SLEP OR 14 8K ','','0.850','1','100.00','969000','0','0','15000','960000','0','0','0','960000','FIT','00397389','E1D','0','0','-','1','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCCA-166-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='E1D-ZCCA-166-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 ('F326031020531','2026-04-03','0.850','2026-04-03','10:20:54','PLG0028397','960000','960000','0','960000','960000','input','2026-04-03 10:20:53','F32603102053');
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-04-03','F326031020531','2026-04-03','10:20:54','FIT','960000','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-260403-0014','D','2026-04-03','10:20:54','input','PENJUALAN','F326031020531','4151531000','960000','4152491000');
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 ('F326031031381','input','1',' MEH1 UB 42','TOKO','PM-H','H1E-ZDXA-40-0','KL NORY UB 42CM 8K ','','1.550','1','100.00','1798000','0','0','15000','1798000','0','0','0','1798000','SIN','00397519','H1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDXA-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='H1E-ZDXA-40-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 ('F326031031381','2026-04-03','1.550','2026-04-03','10:31:38','PLG0028398','1798000','1798000','0','1798000','1798000','input','2026-04-03 10:31:38','F32603103138');
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-04-03','F326031031381','2026-04-03','10:31:38','SIN','1798000','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-260403-0015','D','2026-04-03','10:31:38','input','PENJUALAN','F326031031381','4152491000','1798000','4154289000');
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 ('F326031037481','input','1',' MGF3G UB ','TOKO','PM-F','F3G-ZCAG-162-0','GL BORSALINO UB 8K ','','0.360','1','100.00','432000','0','0','15000','433000','0','0','0','433000','FIT','00394880','F3G','0','0','-','0','1200000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3G-ZCAG-162-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='F3G-ZCAG-162-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 ('F326031037481','2026-04-03','0.360','2026-04-03','10:37:49','PLG0028399','433000','433000','0','433000','433000','input','2026-04-03 10:37:48','F32603103748');
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-04-03','F326031037481','2026-04-03','10:37:49','FIT','433000','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-260403-0016','D','2026-04-03','10:37:49','input','PENJUALAN','F326031037481','4154289000','433000','4154722000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='433000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326031037481' 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 ('F326031037482','input',' 1',' MEE1 X UB ','TOKO','PM-E','E1E-ZCAI-183-0','CC X MODEL SLEP UB 14 8K ','','0.460','1','100.00','534000','0','0','15000','535000','0','0','0','535000','FIT','00395579','E1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAI-183-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='E1E-ZCAI-183-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 ('F326031037482','2026-04-03','0.460','2026-04-03','10:37:49','PLG0028400','535000','535000','0','535000','535000','input','2026-04-03 10:37:48','F32603103748');
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-04-03','F326031037482','2026-04-03','10:37:49','FIT','535000','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-260403-0017','D','2026-04-03','10:37:49','input','PENJUALAN','F326031037482','4154722000','535000','4155257000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='535000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326031037482' 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 ('F326031040251','input','1',' MEF1 TD D3','TOKO','PM-F','F1E-XLXC-67-0','GL ANAK BANGKOK MODEL C TD D36 8K ','','2.000','1','100.00','2320000','0','0','15000','2320000','0','0','0','2320000','LIS','00328366','F1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-XLXC-67-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-04-03' AND kode_barang='F1E-XLXC-67-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 ('F326031040251','2026-04-03','2.000','2026-04-03','10:40:25','PLG0028401','2320000','2320000','0','2320000','2320000','input','2026-04-03 10:40:25','F32603104025');
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-04-03','F326031040251','2026-04-03','10:40:25','LIS','2320000','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-260403-0018','D','2026-04-03','10:40:25','input','PENJUALAN','F326031040251','4155257000','2320000','4157577000');
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 ('F326031046101','input','1',' MGE1 UB 18','TOKO','PM-E','E1G-ZCAH-343-0','CC PIPA SLEP UB 18 8K ','','0.370','1','100.00','444000','0','0','15000','445000','0','0','0','445000','SIN','00395298','E1G','0','0','-','0','1200000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-ZCAH-343-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='E1G-ZCAH-343-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 ('F326031046101','2026-04-03','0.370','2026-04-03','10:46:11','PLG0028402','445000','445000','0','445000','445000','input','2026-04-03 10:46:10','F32603104610');
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-04-03','F326031046101','2026-04-03','10:46:11','SIN','445000','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-260403-0019','D','2026-04-03','10:46:11','input','PENJUALAN','F326031046101','4157577000','445000','4158022000');
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 ('F326031112341','input','1',' MDE2 X LG ','TOKO','PM-E','E2D-YLXH-30-0','CC X MODEL MATA LG 14 8K ','','0.970','1','100.00','1106000','0','0','15000','1105000','0','0','0','1105000','AAT','00380152','E2D','0','0','-','1','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YLXH-30-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-04-03' AND kode_barang='E2D-YLXH-30-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 ('F326031112341','2026-04-03','0.970','2026-04-03','11:12:34','PLG0028403','1105000','1105000','0','1105000','1105000','input','2026-04-03 11:12:34','F32603111234');
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-04-03','F326031112341','2026-04-03','11:12:34','AAT','1105000','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-260403-0020','D','2026-04-03','11:12:34','input','PENJUALAN','F326031112341','4158022000','1105000','4159127000');
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 ('F326031120241','input','1',' MEH1 UB 32','TOKO','PM-H','H1E-ZDXA-37-0','KL ANAK GUCCI UB 32CM 8K ','','1.060','1','100.00','1230000','0','0','15000','1230000','0','0','0','1230000','SIN','00397516','H1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDXA-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='H1E-ZDXA-37-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 ('F326031120241','2026-04-03','1.060','2026-04-03','11:20:25','PLG0028404','1230000','1230000','0','1230000','1230000','input','2026-04-03 11:20:24','F32603112024');
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-04-03','F326031120241','2026-04-03','11:20:25','SIN','1230000','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-260403-0021','D','2026-04-03','11:20:25','input','PENJUALAN','F326031120241','4159127000','1230000','4160357000');
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 ('F326031147001','input','1',' MEA1E X UB','TOKO','PM-A','A1E-ZCBE-198-0','AT X HUGGIES SLEP UB 8K ','','0.680','1','100.00','789000','0','0','15000','790000','0','0','0','790000','LIS','00396660','A1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZCBE-198-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-04-03' AND kode_barang='A1E-ZCBE-198-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' 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 ('F326031147001','2026-04-03','0.680','2026-04-03','11:47:00','PLG0028405','790000','790000','0','790000','790000','input','2026-04-03 11:47:00','F32603114700');
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-04-03','F326031147001','2026-04-03','11:47:00','LIS','790000','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-260403-0022','D','2026-04-03','11:47:00','input','PENJUALAN','F326031147001','4160357000','790000','4161147000');
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-00018686','X-00018686','CC BANGKOK SLEP LG 15 8K','GR','---','E1E','BELI','BELI001','477000','2026-04-03','0.480','1','kasir','2026-04-03 13:12:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00018686','X-00018686');
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-260403-0001','F326120907201','FIT','1','BELI','BELI001','E1E', 'X-00018686', 'CC BANGKOK SLEP LG 15 8K','0.480','0.480','100.00','600000','477000','993750','1170000','1','477000','477000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.480',berat_beli_asli=berat_beli_asli+'0.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.480',berat_akhir_asli=berat_akhir_asli+'0.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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-260403-0001','2026-04-03','2026-04-03','13:12:16','FIT','---','0.480','477000','477000','477000','477000','477000','kasir','2026-04-03 13:12:16','FB-260403-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260403-0001','WAGI','BITING SENAYU','','','081392805157','kasir','2026-04-03 13:12:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-03' 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-260403-0023','K','2026-04-03','13:12:16','kasir','PEMBELIAN UMUM','FB-260403-0001','4161147000','477000','4160670000');
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-00018687','X-00018687','CC MODEL SLEP VAR LG 14 8K','GR','---','E1D','BELI','BELI001','917000','2026-04-03','1.210','1','kasir','2026-04-03 13:13:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00018687','X-00018687');
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-260403-0002','F324311203411','AAT','1','BELI','BELI001','E1D', 'X-00018687', 'CC MODEL SLEP VAR LG 14 8K','1.210','1.210','100.00','725000','917000','757851','1150000','1','917000','917000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.210',berat_beli_asli=berat_beli_asli+'1.210',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.210',berat_akhir_asli=berat_akhir_asli+'1.210',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' 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-260403-0002','2026-04-03','2026-04-03','13:13:17','AAT','---','1.210','917000','917000','917000','917000','917000','kasir','2026-04-03 13:13:18','FB-260403-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260403-0002','CESA','JERUK PACITAN','','','','kasir','2026-04-03 13:13:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-03' 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-260403-0024','K','2026-04-03','13:13:17','kasir','PEMBELIAN UMUM','FB-260403-0002','4160670000','917000','4159753000');
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-00018688','X-00018688','AT X DAISY MATA CM','GR','---','A1E','BELI','BELI001','232000','2026-04-03','0.480','1','kasir','2026-04-03 13:13:56');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00018688','X-00018688');
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-260403-0003','F322060850491','SIN','1','BELI','BELI001','A1E', 'X-00018688', 'AT X DAISY MATA CM','0.980','0.480','100.00','405000','232000','483333','1170000','1','232000','232000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.480',berat_beli_asli=berat_beli_asli+'0.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.480',berat_akhir_asli=berat_akhir_asli+'0.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' 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-260403-0003','2026-04-03','2026-04-03','13:13:55','SIN','---','0.480','232000','232000','232000','232000','232000','kasir','2026-04-03 13:13:56','FB-260403-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260403-0003','KATENI','GADUNGAN KISMANTORO','','','','kasir','2026-04-03 13:13:56');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-03' 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-260403-0025','K','2026-04-03','13:13:55','kasir','PEMBELIAN UMUM','FB-260403-0003','4159753000','232000','4159521000');
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-00018689','X-00018689','CC X WEDDING MATA CM 16','GR','---','E2E','BELI','BELI001','1320000','2026-04-03','1.780','1','kasir','2026-04-03 13:14:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018689','X-00018689');
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-260403-0004','F322060842511','FIT','1','BELI','BELI001','E2E', 'X-00018689', 'CC X WEDDING MATA CM 16','1.780','1.780','100.00','730000','1320000','741573','1170000','1','1320000','1320000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.780',berat_beli_asli=berat_beli_asli+'1.780',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.780',berat_akhir_asli=berat_akhir_asli+'1.780',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-03' 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-260403-0004','2026-04-03','2026-04-03','13:14:46','FIT','---','1.780','1320000','1320000','1320000','1320000','1320000','kasir','2026-04-03 13:14:46','FB-260403-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260403-0004','KATENI','GADUNGAN KISMANTORO','','','','kasir','2026-04-03 13:14:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-03' 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-260403-0026','K','2026-04-03','13:14:46','kasir','PEMBELIAN UMUM','FB-260403-0004','4159521000','1320000','4158201000');
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-00018690','X-00018690','CC MODEL DAUN VAR CM 12 8K','GR','---','E1E','BELI','BELI001','635000','2026-04-03','0.700','1','kasir','2026-04-03 13:15:12');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00018690','X-00018690');
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-260403-0005','F325301240241','AAT','1','BELI','BELI001','E1E', 'X-00018690', 'CC MODEL DAUN VAR CM 12 8K','0.700','0.700','100.00','675000','635000','907143','1170000','1','635000','635000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.700',berat_beli_asli=berat_beli_asli+'0.700',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.700',berat_akhir_asli=berat_akhir_asli+'0.700',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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-260403-0005','2026-04-03','2026-04-03','13:15:12','AAT','---','0.700','635000','635000','635000','635000','635000','kasir','2026-04-03 13:15:12','FB-260403-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260403-0005','DINDA','JATIREJO','','','','kasir','2026-04-03 13:15:12');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-03' 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-260403-0027','K','2026-04-03','13:15:12','kasir','PEMBELIAN UMUM','FB-260403-0005','4158201000','635000','4157566000');
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-00018691','X-00018691','GL ANAK BANGKOK MODEL C TD D42 8K','GR','---','F1E','BELI','BELI001','1545000','2026-04-03','1.960','1','kasir','2026-04-03 13:15:42');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00018691','X-00018691');
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-260403-0006','F325181211561','LIS','1','BELI','BELI001','F1E', 'X-00018691', 'GL ANAK BANGKOK MODEL C TD D42 8K','1.960','1.960','100.00','1665000','1545000','788265','1170000','1','1545000','1545000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.960',berat_beli_asli=berat_beli_asli+'1.960',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.960',berat_akhir_asli=berat_akhir_asli+'1.960',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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-260403-0006','2026-04-03','2026-04-03','13:15:42','LIS','---','1.960','1545000','1545000','1545000','1545000','1545000','kasir','2026-04-03 13:15:42','FB-260403-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260403-0006','RINA','BADEGAN','','','081807923885','kasir','2026-04-03 13:15:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-03' 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-260403-0028','K','2026-04-03','13:15:42','kasir','PEMBELIAN UMUM','FB-260403-0006','4157566000','1545000','4156021000');
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-00018692','X-00018692','CC ANAK MODEL BONEKA MATA CAT VAR CM 8K','GR','---','E2F','BELI','BELI001','530000','2026-04-03','0.750','1','kasir','2026-04-03 13:16:19');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2F','X-00018692','X-00018692');
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-260403-0007','F325241257051','LIS','1','BELI','BELI001','E2F', 'X-00018692', 'CC ANAK MODEL BONEKA MATA CAT VAR CM 8K','0.750','0.750','100.00','570000','530000','706667','1180000','1','530000','530000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.750',berat_beli_asli=berat_beli_asli+'0.750',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.750',berat_akhir_asli=berat_akhir_asli+'0.750',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2F' 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-260403-0007','2026-04-03','2026-04-03','13:16:18','LIS','---','0.750','530000','530000','530000','530000','530000','kasir','2026-04-03 13:16:19','FB-260403-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260403-0007','MBK RINA','BADEGAN 6/1','','','081807923885','kasir','2026-04-03 13:16:19');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-03' 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-260403-0029','K','2026-04-03','13:16:18','kasir','PEMBELIAN UMUM','FB-260403-0007','4156021000','530000','4155491000');
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-00018693','X-00018693','CC X KUKU MACAN HA 10 8K','GR','---','E1E','BELI','BELI001','555000','2026-04-03','0.510','1','kasir','2026-04-03 13:16:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00018693','X-00018693');
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-260403-0008','F326191142432','SIN','1','BELI','BELI001','E1E', 'X-00018693', 'CC X KUKU MACAN HA 10 8K','0.510','0.510','100.00','600000','555000','1088235','1170000','1','555000','555000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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-260403-0008','2026-04-03','2026-04-03','13:16:49','SIN','---','0.510','555000','555000','555000','555000','555000','kasir','2026-04-03 13:16:50','FB-260403-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260403-0008','RISKA PUTRI','BITING','','','0856088913004','kasir','2026-04-03 13:16:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-03' 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-260403-0030','K','2026-04-03','13:16:49','kasir','PEMBELIAN UMUM','FB-260403-0008','4155491000','555000','4154936000');
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-00018694','X-00018694','AT X MODEL KLIP MATA CM 8K','GR','---','A1D','BELI','BELI001','1115000','2026-04-03','1.180','1','kasir','2026-04-03 13:17:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00018694','X-00018694');
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-260403-0009','F325070911091','SIN','1','BELI','BELI001','A1D', 'X-00018694', 'AT X MODEL KLIP MATA CM 8K','1.180','1.180','100.00','1188000','1115000','944915','1150000','1','1115000','1115000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.180',berat_beli_asli=berat_beli_asli+'1.180',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.180',berat_akhir_asli=berat_akhir_asli+'1.180',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' 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-260403-0009','2026-04-03','2026-04-03','13:17:32','SIN','---','1.180','1115000','1115000','1115000','1115000','1115000','kasir','2026-04-03 13:17:33','FB-260403-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260403-0009','MELANI','TINASAT KISMANTORO','','','','kasir','2026-04-03 13:17:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-03' 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-260403-0031','K','2026-04-03','13:17:32','kasir','PEMBELIAN UMUM','FB-260403-0009','4154936000','1115000','4153821000');
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-00018695','X-00018695','GL OVAL MODEL PAKU MATA UB D56 8K','GR','---','F2E','BELI','BELI001','2432000','2026-04-03','2.260','1','kasir','2026-04-03 13:18:08');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00018695','X-00018695');
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-260403-0010','F326100958021','AAT','1','BELI','BELI001','F2E', 'X-00018695', 'GL OVAL MODEL PAKU MATA UB D56 8K','2.260','2.260','100.00','2723000','2432000','1076106','1170000','1','2432000','2432000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.260',berat_beli_asli=berat_beli_asli+'2.260',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.260',berat_akhir_asli=berat_akhir_asli+'2.260',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F2E' 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-260403-0010','2026-04-03','2026-04-03','13:18:07','AAT','---','2.260','2432000','2432000','2432000','2432000','2432000','kasir','2026-04-03 13:18:08','FB-260403-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260403-0010','LIS','BRENGGOLO JATIROTO','','','081806292322','kasir','2026-04-03 13:18:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-03' 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-260403-0032','K','2026-04-03','13:18:07','kasir','PEMBELIAN UMUM','FB-260403-0010','4153821000','2432000','4151389000');
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-00018696','X-00018696','CC COR M 8K','GR','---','E2E','BELI','BELI001','625000','2026-04-03','0.930','1','kasir','2026-04-03 13:19:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018696','X-00018696');
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-260403-0011','t0056625','LIS','1','BELI','BELI001','E2E', 'X-00018696', 'CC COR M 8K','0.930','0.930','100.00','560000','625000','672043','1170000','1','625000','625000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.930',berat_beli_asli=berat_beli_asli+'0.930',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.930',berat_akhir_asli=berat_akhir_asli+'0.930',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-03' 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-260403-0011','2026-04-03','2026-04-03','13:19:32','LIS','---','0.930','625000','625000','625000','625000','625000','kasir','2026-04-03 13:19:33','FB-260403-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260403-0011','RINA','BADEGAN','','','','kasir','2026-04-03 13:19:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-03' 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-260403-0033','K','2026-04-03','13:19:32','kasir','PEMBELIAN UMUM','FB-260403-0011','4151389000','625000','4150764000');
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 ('F326030137171','kasir','1',' MEF3E X LT','TOKO','PM-F','F3E-ZCBX-205-0','GL X FANCY ANAK SLEP LT 8K ','','2.030','1','100.00','2355000','0','0','15000','2355000','0','0','0','2355000','FIT','00396412','F3E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCBX-205-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='F3E-ZCBX-205-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 ('F326030137171','2026-04-03','2.030','2026-04-03','13:37:17','PLG0028406','2355000','2355000','0','2355000','2355000','kasir','2026-04-03 13:37:17','F32603013717');
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-04-03','F326030137171','2026-04-03','13:37:17','FIT','2355000','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-260403-0034','D','2026-04-03','13:37:17','kasir','PENJUALAN','F326030137171','4150764000','2355000','4153119000');
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 ('F326030142041','kasir','1',' MGD1 5K AY','TOKO','PM-D','D1G-ZBXC-12-0','LT SLOBOK HATI SLEP AY 8K ','GL MIAMI MERAH','0.350','1','100.00','420000','0','0','15000','420000','0','45000','0','465000','SIN','00387691','D1G','0','0','-','0','1200000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZBXC-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='D1G-ZBXC-12-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 ('F326030142041','2026-04-03','0.350','2026-04-03','13:42:04','PLG0028407','420000','420000','45000','465000','465000','kasir','2026-04-03 13:42:04','F32603014204');
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-04-03','F326030142041','2026-04-03','13:42:04','SIN','465000','45000');
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-260403-0035','D','2026-04-03','13:42:04','kasir','PENJUALAN','F326030142041','4153119000','465000','4153584000');
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-00018697','X-00018697','CC MODEL MATA VAR YT 9 8K','GR','---','E2D','BELI','BELI001','1120000','2026-04-03','1.060','1','kasir','2026-04-03 13:53:00');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00018697','X-00018697');
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-260403-0012','F326290947171','LIS','1','BELI','BELI001','E2D', 'X-00018697', 'CC MODEL MATA VAR YT 9 8K','1.060','1.060','100.00','1425000','1120000','1056604','1150000','1','1120000','1120000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.060',berat_beli_asli=berat_beli_asli+'1.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.060',berat_akhir_asli=berat_akhir_asli+'1.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' 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-260403-0012','2026-04-03','2026-04-03','13:52:59','LIS','---','1.060','1120000','1120000','1120000','1120000','1120000','kasir','2026-04-03 13:53:00','FB-260403-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260403-0012','DAMA','GAMBIRANOM KISMANTORO','','','0895325142828','kasir','2026-04-03 13:53:00');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-03' 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-260403-0036','K','2026-04-03','13:52:59','kasir','PEMBELIAN UMUM','FB-260403-0012','4153584000','1120000','4152464000');
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 ('F326030200251','kasir','1',' MEF3E X PM','TOKO','PM-F','F3E-YKBD-64-0','GL X SISIK NAGA SLEP PM 8K ','','6.750','1','100.00','7830000','0','0','15000','7830000','0','0','0','7830000','LIS','00378473','F3E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKBD-64-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.750',berat_jual_asli=berat_jual_asli+'6.750',stock_jual='1',berat_akhir=berat_akhir-'6.750',berat_akhir_asli=berat_akhir_asli-'6.750',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='F3E-YKBD-64-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 ('F326030200251','2026-04-03','6.750','2026-04-03','14:00:25','PLG0028408','7830000','7830000','0','7830000','7830000','kasir','2026-04-03 14:00:25','F32603020025');
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-04-03','F326030200251','2026-04-03','14:00:25','LIS','7830000','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-260403-0037','D','2026-04-03','14:00:25','kasir','PENJUALAN','F326030200251','4152464000','7830000','4160294000');
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 ('F326030208031','kasir','1',' MEF3 HW ','TOKO','PM-F','F3E-ZDXA-32-0','GL FLIK MODEL DAUN VAR HW 8K ','','1.760','1','100.00','2042000','0','0','15000','2040000','0','0','0','2040000','AAT','00397511','F3E','0','0','-','1','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDXA-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.760',berat_jual_asli=berat_jual_asli+'1.760',stock_jual='1',berat_akhir=berat_akhir-'1.760',berat_akhir_asli=berat_akhir_asli-'1.760',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='F3E-ZDXA-32-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 ('F326030208031','2026-04-03','1.760','2026-04-03','14:08:04','PLG0028409','2040000','2040000','0','2040000','2040000','kasir','2026-04-03 14:08:03','F32603020803');
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-04-03','F326030208031','2026-04-03','14:08:04','AAT','2040000','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-260403-0038','D','2026-04-03','14:08:04','kasir','PENJUALAN','F326030208031','4160294000','2040000','4162334000');
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 ('F326030224031','kasir','1',' MEF3 X HW ','TOKO','PM-F','F3E-ZCBX-193-0','GL X CASTELI ARESO VAR HW 8K ','','1.910','1','100.00','2216000','0','0','15000','2215000','0','0','0','2215000','SIN','00396400','F3E','0','0','-','1','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCBX-193-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.910',berat_jual_asli=berat_jual_asli+'1.910',stock_jual='1',berat_akhir=berat_akhir-'1.910',berat_akhir_asli=berat_akhir_asli-'1.910',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='F3E-ZCBX-193-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 ('F326030224031','2026-04-03','1.910','2026-04-03','14:24:04','PLG0028410','2215000','2215000','0','2215000','2215000','kasir','2026-04-03 14:24:03','F32603022403');
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-04-03','F326030224031','2026-04-03','14:24:04','SIN','2215000','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-260403-0039','D','2026-04-03','14:24:04','kasir','PENJUALAN','F326030224031','4162334000','2215000','4164549000');
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 ('F326030230361','kasir','1',' MEH1 UB 44','TOKO','PM-H','H1E-ZDXA-46-0','KL KOREA UB 44CM 8K ','','3.100','1','100.00','3596000','0','0','15000','3596000','0','0','0','3596000','AAT','00397525','H1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDXA-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.100',berat_jual_asli=berat_jual_asli+'3.100',stock_jual='1',berat_akhir=berat_akhir-'3.100',berat_akhir_asli=berat_akhir_asli-'3.100',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='H1E-ZDXA-46-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 ('F326030230361','2026-04-03','3.100','2026-04-03','14:30:37','PLG0028411','3596000','3596000','0','3596000','3596000','kasir','2026-04-03 14:30:36','F32603023036');
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-04-03','F326030230361','2026-04-03','14:30:37','AAT','3596000','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-260403-0040','D','2026-04-03','14:30:37','kasir','PENJUALAN','F326030230361','4164549000','3596000','4168145000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3596000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326030230361' 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 ('F326030230362','kasir',' 1',' MEF3E X KH','TOKO','PM-F','F3E-ZABH-74-0','GL X FRANCO SLEP KH 8K ','','2.890','1','100.00','3352000','0','0','15000','3354000','0','0','0','3354000','AAT','00386932','F3E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZABH-74-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.890',berat_jual_asli=berat_jual_asli+'2.890',stock_jual='1',berat_akhir=berat_akhir-'2.890',berat_akhir_asli=berat_akhir_asli-'2.890',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='F3E-ZABH-74-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 ('F326030230362','2026-04-03','2.890','2026-04-03','14:30:37','PLG0028412','3354000','3354000','0','3354000','3354000','kasir','2026-04-03 14:30:36','F32603023036');
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-04-03','F326030230362','2026-04-03','14:30:37','AAT','3354000','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-260403-0041','D','2026-04-03','14:30:37','kasir','PENJUALAN','F326030230362','4168145000','3354000','4171499000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3354000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326030230362' 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 ('F326030234241','kasir','1',' MDD2D X CM','TOKO','PM-D','D2D-ZCAD-45-0','LT X MODEL NAGA MATA HITAM CM 8K ','','0.980','1','100.00','1117000','0','0','15000','1108000','0','0','0','1108000','FIT','00394173','D2D','0','0','-','1','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZCAD-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='D2D-ZCAD-45-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 ('F326030234241','2026-04-03','0.980','2026-04-03','14:34:25','PLG0028413','1108000','1108000','0','1108000','1108000','kasir','2026-04-03 14:34:24','F32603023424');
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-04-03','F326030234241','2026-04-03','14:34:25','FIT','1108000','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-260403-0042','D','2026-04-03','14:34:25','kasir','PENJUALAN','F326030234241','4171499000','1108000','4172607000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1108000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326030234241' 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 ('F326030234242','kasir',' 1',' MEE2 X CM ','TOKO','PM-E','E2E-ZCXI-38-0','CC X MODEL MATA CM 10 8K ','','0.750','1','100.00','870000','0','0','15000','870000','0','0','0','870000','FIT','00392853','E2E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCXI-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='E2E-ZCXI-38-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 ('F326030234242','2026-04-03','0.750','2026-04-03','14:34:25','PLG0028414','870000','870000','0','870000','870000','kasir','2026-04-03 14:34:24','F32603023424');
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-04-03','F326030234242','2026-04-03','14:34:25','FIT','870000','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-260403-0043','D','2026-04-03','14:34:25','kasir','PENJUALAN','F326030234242','4172607000','870000','4173477000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='870000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326030234242' 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 ('F326030235001','kasir','1',' MEF3E X UB','TOKO','PM-F','F3E-ZCAI-307-0','GL X TIFF VAR SERUT UB 8K ','','1.310','1','100.00','1520000','0','0','15000','1520000','0','0','0','1520000','FIT','00395705','F3E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCAI-307-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.310',berat_jual_asli=berat_jual_asli+'1.310',stock_jual='1',berat_akhir=berat_akhir-'1.310',berat_akhir_asli=berat_akhir_asli-'1.310',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='F3E-ZCAI-307-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 ('F326030235001','2026-04-03','1.310','2026-04-03','14:35:01','PLG0028415','1520000','1520000','0','1520000','1520000','kasir','2026-04-03 14:35:00','F32603023500');
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-04-03','F326030235001','2026-04-03','14:35:01','FIT','1520000','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-260403-0044','D','2026-04-03','14:35:01','kasir','PENJUALAN','F326030235001','4173477000','1520000','4174997000');
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 ('F326030235481','kasir','1',' MEB1 5K HW','TOKO','PM-B','B1E-YKXC-383-0','GW TRIXIE PANJANG BUNGA CAT VAR HW 8K ','','0.930','1','100.00','1079000','0','0','15000','1080000','0','5000','0','1085000','FIT','00376311','B1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YKXC-383-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.930',berat_jual_asli=berat_jual_asli+'0.930',stock_jual='1',berat_akhir=berat_akhir-'0.930',berat_akhir_asli=berat_akhir_asli-'0.930',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='B1E-YKXC-383-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 ('F326030235481','2026-04-03','0.930','2026-04-03','14:35:48','PLG0028416','1080000','1080000','5000','1085000','1085000','kasir','2026-04-03 14:35:48','F32603023548');
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-04-03','F326030235481','2026-04-03','14:35:48','FIT','1085000','5000');
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-260403-0045','D','2026-04-03','14:35:48','kasir','PENJUALAN','F326030235481','4174997000','1085000','4176082000');
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-00018698','X-00018698','GL X RANTAI HOLLOW PLAT MATA YT','GR','---','F3E','BELI','BELI001','5845000','2026-04-03','7.800','1','kasir','2026-04-03 14:48:26');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00018698','X-00018698');
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-260403-0013','F322280217271','SIN','1','BELI','BELI001','F3E', 'X-00018698', 'GL X RANTAI HOLLOW PLAT MATA YT','7.800','7.800','100.00','3200000','5845000','749359','1170000','1','5845000','5845000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'7.800',berat_beli_asli=berat_beli_asli+'7.800',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'7.800',berat_akhir_asli=berat_akhir_asli+'7.800',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' 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-260403-0013','2026-04-03','2026-04-03','14:48:26','SIN','---','7.800','5845000','5845000','5845000','5845000','5845000','kasir','2026-04-03 14:48:26','FB-260403-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260403-0013','NATASYA','KISMANTORO','','','','kasir','2026-04-03 14:48:26');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-03' 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-260403-0046','K','2026-04-03','14:48:26','kasir','PEMBELIAN UMUM','FB-260403-0013','4176082000','5845000','4170237000');
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-00018699','X-00018699','GL XXX PIPA MATA PM 58 8K','GR','---','F2E','BELI','BELI001','2255000','2026-04-03','2.910','1','kasir','2026-04-03 14:49:15');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00018699','X-00018699');
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-260403-0014','F325160221361','SIN','1','BELI','BELI001','F2E', 'X-00018699', 'GL XXX PIPA MATA PM 58 8K','2.910','2.910','100.00','2640000','2255000','774914','1170000','1','2255000','2255000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.910',berat_beli_asli=berat_beli_asli+'2.910',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.910',berat_akhir_asli=berat_akhir_asli+'2.910',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F2E' 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-260403-0014','2026-04-03','2026-04-03','14:49:14','SIN','---','2.910','2255000','2255000','2255000','2255000','2255000','kasir','2026-04-03 14:49:15','FB-260403-0014');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260403-0014','FERY','NAWANGAN','','','082132711379','kasir','2026-04-03 14:49:15');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-03' 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-260403-0047','K','2026-04-03','14:49:14','kasir','PEMBELIAN UMUM','FB-260403-0014','4170237000','2255000','4167982000');
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-00018700','X-00018700','GL X ANAK OSROT BONEKA CAT VAR LG 8K','GR','---','F1E','BELI','BELI001','810000','2026-04-03','1.030','1','kasir','2026-04-03 14:50:01');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00018700','X-00018700');
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-260403-0015','F325100203001','LIS','1','BELI','BELI001','F1E', 'X-00018700', 'GL X ANAK OSROT BONEKA CAT VAR LG 8K','1.030','1.030','100.00','1030000','810000','786408','1170000','1','810000','810000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.030',berat_beli_asli=berat_beli_asli+'1.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.030',berat_akhir_asli=berat_akhir_asli+'1.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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-260403-0015','2026-04-03','2026-04-03','14:50:00','LIS','---','1.030','810000','810000','810000','810000','810000','kasir','2026-04-03 14:50:01','FB-260403-0015');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260403-0015','VINA','SUGIHAN BULUKERTO','','','085327590770','kasir','2026-04-03 14:50:01');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-03' 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-260403-0048','K','2026-04-03','14:50:00','kasir','PEMBELIAN UMUM','FB-260403-0015','4167982000','810000','4167172000');
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 ('F326030253321','kasir','1',' MDE2 10K C','TOKO','PM-E','E2D-ZCAX-277-0','CC WEDDING MATA CM 12 8K ','','1.520','1','100.00','1733000','0','0','15000','1733000','0','10000','0','1743000','SIN','00393254','E2D','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAX-277-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='E2D-ZCAX-277-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 ('F326030253321','2026-04-03','1.520','2026-04-03','14:53:32','PLG0028417','1733000','1733000','10000','1743000','1743000','kasir','2026-04-03 14:53:32','F32603025332');
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-04-03','F326030253321','2026-04-03','14:53:32','SIN','1743000','10000');
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-260403-0049','D','2026-04-03','14:53:32','kasir','PENJUALAN','F326030253321','4167172000','1743000','4168915000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1743000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326030253321' 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 ('F326030253322','kasir',' 1',' MDE2 10K C','TOKO','PM-E','E2D-ZDXA-54-0','CC WEDDING MATA CM 14 8K ','','1.530','1','100.00','1744000','0','0','15000','1745000','0','10000','0','1755000','SIN','00397533','E2D','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDXA-54-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-04-03' AND kode_barang='E2D-ZDXA-54-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 ('F326030253322','2026-04-03','1.530','2026-04-03','14:53:32','PLG0028418','1745000','1745000','10000','1755000','1755000','kasir','2026-04-03 14:53:32','F32603025332');
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-04-03','F326030253322','2026-04-03','14:53:32','SIN','1755000','10000');
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-260403-0050','D','2026-04-03','14:53:32','kasir','PENJUALAN','F326030253322','4168915000','1755000','4170670000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1755000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326030253322' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030137171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030137171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030137171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030142041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030142041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030142041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030200251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030200251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030200251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030208031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030208031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030208031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030224031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030224031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030224031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030230361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030230361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030230361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030230362' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030230362' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030230362';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030234241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030234241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030234241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030234242' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030234242' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030234242';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030235001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030235001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030235001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030235481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030235481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030235481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030253321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030253321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030253321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030253322' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030253322' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030253322';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030849111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030849111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030849111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030849112' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030849112' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030849112';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030906021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030906021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030906021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030908421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030908421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030908421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030937321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030937321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030937321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030937322' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030937322' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030937322';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326031001041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326031001041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326031001041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326031001042' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326031001042' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326031001042';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326031002111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326031002111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326031002111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326031002112' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326031002112' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326031002112';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326031019391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326031019391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326031019391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326031019392' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326031019392' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326031019392';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326031020531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326031020531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326031020531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326031031381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326031031381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326031031381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326031037481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326031037481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326031037481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326031037482' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326031037482' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326031037482';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326031040251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326031040251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326031040251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326031046101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326031046101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326031046101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326031112341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326031112341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326031112341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326031120241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326031120241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326031120241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326031147001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326031147001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326031147001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260403-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260403-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260403-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260403-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260403-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260403-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260403-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260403-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260403-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260403-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260403-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260403-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260403-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260403-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260403-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260403-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260403-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260403-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260403-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260403-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260403-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260403-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260403-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260403-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260403-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260403-0013';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260403-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260403-0014';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260403-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260403-0015';
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260403-0001','1','E0TA-WHCA-99-T','1','1.000','1.000','TOKO','PT-E','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='TBK-E' WHERE kode_barang='E0TA-WHCA-99-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PT-E';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-03','TOKO','TBK-E','E0TA','E0TA-WHCA-99-T','100.00','1','1.000','1.000','1','1.000','1.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.000',berat_out_asli=berat_out_asli+'1.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-03' AND kode_barang='E0TA-WHCA-99-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PT-E' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260403-0001','2026-04-03','2026-04-03','16:14','1','input','2026-04-03 16:14:51');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-04','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-04';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-03';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-03';
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-04-03' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-03';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-03';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-03';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-03';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-04' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-03' 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-260404-0001','D','2026-04-04','16:24:21','SYSTEM','SALDO AWAL','SALDO AWAL','0','4170670000','4170670000');
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-260404-0001','D','2026-04-04','16:24:21','BCA','SALDO AWAL','SALDO AWAL','0','707186000','707186000');
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-260404-0001','D','2026-04-04','16:24:21','DLL','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-260404-0001','D','2026-04-04','16:24:21','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-04-04';