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 ('F226120909101','kasir','1',' MEE1 X HW ','TOKO','SMBK-E','E1E-ZHBF-290-0','CC X GELOMBANG CAT HITAM HW 13 8K ','OLS XP9QQ','0.650','1','100.00','686000','0','0','15000','718000','0','77000','0','795000','DIN','00420662','E1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHBF-290-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='E1E-ZHBF-290-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120909101','2026-09-12','0.650','2026-09-12','09:09:10','PLG0084852','718000','718000','77000','795000','795000','kasir','2026-09-12 09:09:10','F22612090910');
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-09-12','F226120909101','2026-09-12','09:09:10','DIN','795000','77000');
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-260912-0002','D','2026-09-12','09:09:10','kasir','PENJUALAN','F226120909101','14943268000','795000','14944063000');
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 ('F226120910261','kasir','1',' MGPD LG R ','TOKO','SMBK-P','PDG-YFBF-153-T','LT WG MODEL HURUF MATA LG R 8K ','OLS GNY8V','0.600','1','100.00','657000','0','0','15000','687000','0','80000','0','767000','DIN','T0070520','PDG','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PDG-YFBF-153-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='PDG-YFBF-153-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-P' 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 ('F226120910261','2026-09-12','0.600','2026-09-12','09:10:26','PLG0084853','687000','687000','80000','767000','767000','kasir','2026-09-12 09:10:26','F22612091026');
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-09-12','F226120910261','2026-09-12','09:10:26','DIN','767000','80000');
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-260912-0003','D','2026-09-12','09:10:26','kasir','PENJUALAN','F226120910261','14944063000','767000','14944830000');
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 ('F226120911111','kasir','1',' MEE2 KH 14','TOKO','SMBK-E','E2E-ZIXI-89-T','CC MODEL SNAKE MATA VAR KH 14 8K ','OL','0.450','1','100.00','475000','0','0','15000','482000','0','5000','0','487000','NS','T0083344','E2E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZIXI-89-T' 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-09-12' AND kode_barang='E2E-ZIXI-89-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120911111','2026-09-12','0.450','2026-09-12','09:11:12','PLG0084854','482000','482000','5000','487000','487000','kasir','2026-09-12 09:11:11','F22612091111');
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-09-12','F226120911111','2026-09-12','09:11:12','NS','487000','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-260912-0004','D','2026-09-12','09:11:12','kasir','PENJUALAN','F226120911111','14944830000','487000','14945317000');
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 ('F226120911311','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZIXG-46-T','GL MODEL CAPELA HATI VAR HW 8K ','OL','1.670','1','100.00','1762000','0','0','15000','1779000','0','8000','0','1787000','NS','T0083105','F3E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIXG-46-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.670',berat_jual_asli=berat_jual_asli+'1.670',stock_jual='1',berat_akhir=berat_akhir-'1.670',berat_akhir_asli=berat_akhir_asli-'1.670',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='F3E-ZIXG-46-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120911311','2026-09-12','1.670','2026-09-12','09:11:31','PLG0084855','1779000','1779000','8000','1787000','1787000','kasir','2026-09-12 09:11:31','F22612091131');
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-09-12','F226120911311','2026-09-12','09:11:31','NS','1787000','8000');
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-260912-0005','D','2026-09-12','09:11:31','kasir','PENJUALAN','F226120911311','14945317000','1787000','14947104000');
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 ('F226120943581','kasir','1',' MDE1 LG 18','TOKO','SMBK-E','E1D-ZIXH-20-T','CC MODEL ISYANA LG 18 8K ','','1.050','1','100.00','1087000','0','0','15000','1087000','0','0','0','1087000','NS','T0083167','E1D','0','0','-','0','1030000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZIXH-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='E1D-ZIXH-20-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120943581','2026-09-12','1.050','2026-09-12','09:43:59','PLG0084856','1087000','1087000','0','1087000','1087000','kasir','2026-09-12 09:43:58','F22612094358');
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-09-12','F226120943581','2026-09-12','09:43:59','NS','1087000','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-260912-0006','D','2026-09-12','09:43:59','kasir','PENJUALAN','F226120943581','14947104000','1087000','14948191000');
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('F1E-ZFXD-114-T','T0080279','T0080279','GL OVAL C SLEP TD 65 8K ','GL OVAL C SLEP TD 65 8K','','','4167500','4167500',' 0','0','input','2026-09-12 09:47:43');
UPDATE tm_barang SET nama_barang='GL OVAL C SLEP TD 65 8K' ,nama_atribut='' ,kode_intern='MEF1E TD 65 ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='F1E-ZFXD-114-T' 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 ('F226120948351','kasir','1',' MEF1E TD 6','TOKO','SMBK-F','F1E-ZFXD-114-T','GL OVAL C SLEP TD 65 8K','','3.950','1','100.00','4167000','0','0','15000','4167000','0','0','0','4167000','NS','T0080279','F1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFXD-114-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.950',berat_jual_asli=berat_jual_asli+'3.950',stock_jual='1',berat_akhir=berat_akhir-'3.950',berat_akhir_asli=berat_akhir_asli-'3.950',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='F1E-ZFXD-114-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120948351','2026-09-12','3.950','2026-09-12','09:48:35','PLG0084857','4167000','4167000','0','4167000','4167000','kasir','2026-09-12 09:48:35','F22612094835');
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-09-12','F226120948351','2026-09-12','09:48:35','NS','4167000','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-260912-0007','D','2026-09-12','09:48:35','kasir','PENJUALAN','F226120948351','14948191000','4167000','14952358000');
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 ('F226120949401','kasir','1',' MDE1 X CM ','TOKO','SMBK-E','E1D-ZGBA-242-0','CC X MODEL SLEP CM 18 8K ','','1.190','1','100.00','1232000','0','0','15000','1232000','0','0','0','1232000','RHM','00414724','E1D','0','0','-','0','1030000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGBA-242-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.190',berat_jual_asli=berat_jual_asli+'1.190',stock_jual='1',berat_akhir=berat_akhir-'1.190',berat_akhir_asli=berat_akhir_asli-'1.190',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='E1D-ZGBA-242-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120949401','2026-09-12','1.190','2026-09-12','09:49:41','PLG0084858','1232000','1232000','0','1232000','1232000','kasir','2026-09-12 09:49:40','F22612094940');
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-09-12','F226120949401','2026-09-12','09:49:41','RHM','1232000','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-260912-0008','D','2026-09-12','09:49:41','kasir','PENJUALAN','F226120949401','14952358000','1232000','14953590000');
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 ('F226120952371','kasir','1',' MEH1 LG ','TOKO','SMBK-H','H1E-ZIAA-67-T','KL TRIXIE MODEL MELODY MATA VAR LG 8K ','OL','0.960','1','100.00','1008000','0','0','15000','1022000','0','5000','0','1027000','LUS','T0083365','H1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZIAA-67-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='H1E-ZIAA-67-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120952371','2026-09-12','0.960','2026-09-12','09:52:37','PLG0084859','1022000','1022000','5000','1027000','1027000','kasir','2026-09-12 09:52:37','F22612095237');
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-09-12','F226120952371','2026-09-12','09:52:37','LUS','1027000','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-260912-0009','D','2026-09-12','09:52:37','kasir','PENJUALAN','F226120952371','14953590000','1027000','14954617000');
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 ('F226120957041','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZIXH-15-T','CC WEDDING MATA CM 16 8K','OL','1.630','1','100.00','1687000','0','0','15000','1693000','0','10000','0','1703000','NS','T0083162','E2D','0','0','-','0','1030000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZIXH-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.630',berat_jual_asli=berat_jual_asli+'1.630',stock_jual='1',berat_akhir=berat_akhir-'1.630',berat_akhir_asli=berat_akhir_asli-'1.630',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='E2D-ZIXH-15-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120957041','2026-09-12','1.630','2026-09-12','09:57:04','PLG0084860','1693000','1693000','10000','1703000','1703000','kasir','2026-09-12 09:57:04','F22612095704');
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-09-12','F226120957041','2026-09-12','09:57:04','NS','1703000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260912-0010','D','2026-09-12','09:57:04','kasir','PENJUALAN','F226120957041','14954617000','1703000','14956320000');
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 ('F226120958041','kasir','1',' MEH1 LG ','TOKO','SMBK-H','H1E-ZIAA-65-T','KL TRIXIE MODEL MELODY MATA VAR LG 8K ','OL','0.960','1','100.00','1008000','0','0','15000','1022000','0','5000','0','1027000','LUS','T0083363','H1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZIAA-65-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='H1E-ZIAA-65-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120958041','2026-09-12','0.960','2026-09-12','09:58:04','PLG0084861','1022000','1022000','5000','1027000','1027000','kasir','2026-09-12 09:58:04','F22612095804');
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-09-12','F226120958041','2026-09-12','09:58:04','LUS','1027000','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-260912-0011','D','2026-09-12','09:58:04','kasir','PENJUALAN','F226120958041','14956320000','1027000','14957347000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120952371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120952371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120952371';
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 ('F226121015441','kasir','1',' MEH1 LG ','TOKO','SMBK-H','H1E-ZIAA-66-T','KL TRIXIE MODEL MELODY MATA VAR LG 8K ','OL','0.940','1','100.00','987000','0','0','15000','1001000','0','5000','0','1006000','DIN','T0083364','H1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZIAA-66-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.940',berat_jual_asli=berat_jual_asli+'0.940',stock_jual='1',berat_akhir=berat_akhir-'0.940',berat_akhir_asli=berat_akhir_asli-'0.940',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='H1E-ZIAA-66-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226121015441','2026-09-12','0.940','2026-09-12','10:15:45','PLG0084862','1001000','1001000','5000','1006000','1006000','kasir','2026-09-12 10:15:44','F22612101544');
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-09-12','F226121015441','2026-09-12','10:15:45','DIN','1006000','5000');
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-260912-0013','D','2026-09-12','10:15:45','kasir','PENJUALAN','F226121015441','14956320000','1006000','14957326000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1006000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226121015441' 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 ('F226121015442','kasir',' 1',' MEH1 LG ','TOKO','SMBK-H','H1E-ZIAA-68-T','KL TRIXIE MODEL MELODY MATA VAR LG 8K ','OL','0.970','1','100.00','1018000','0','0','15000','1033000','0','5000','0','1038000','DIN','T0083366','H1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZIAA-68-T' 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-09-12' AND kode_barang='H1E-ZIAA-68-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226121015442','2026-09-12','0.970','2026-09-12','10:15:45','PLG0084863','1033000','1033000','5000','1038000','1038000','kasir','2026-09-12 10:15:44','F22612101544');
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-09-12','F226121015442','2026-09-12','10:15:45','DIN','1038000','5000');
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-260912-0014','D','2026-09-12','10:15:45','kasir','PENJUALAN','F226121015442','14957326000','1038000','14958364000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1038000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226121015442' 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 ('F226121015443','kasir',' 1',' MEE2E KH 2','TOKO','SMBK-E','E2E-ZHBI-59-T','CC MODEL SNAKE MATA SLEP KH 20 8K ','OL','0.510','1','100.00','538000','0','0','15000','543000','0','5000','0','548000','DIN','T0082748','E2E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHBI-59-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='E2E-ZHBI-59-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226121015443','2026-09-12','0.510','2026-09-12','10:15:45','PLG0084864','543000','543000','5000','548000','548000','kasir','2026-09-12 10:15:44','F22612101544');
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-09-12','F226121015443','2026-09-12','10:15:45','DIN','548000','5000');
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-260912-0015','D','2026-09-12','10:15:45','kasir','PENJUALAN','F226121015443','14958364000','548000','14958912000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='548000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226121015443' 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 ('F226121015444','kasir',' 1',' MEB1 LG ','TOKO','SMBK-B','B1E-ZIXI-33-T','GW TRIXIE PANJANG RABBIT MATA LG 8K ','OL','0.550','1','100.00','580000','0','0','15000','586000','0','5000','0','591000','DIN','T0083288','B1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZIXI-33-T' 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-09-12' AND kode_barang='B1E-ZIXI-33-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226121015444','2026-09-12','0.550','2026-09-12','10:15:45','PLG0084865','586000','586000','5000','591000','591000','kasir','2026-09-12 10:15:44','F22612101544');
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-09-12','F226121015444','2026-09-12','10:15:45','DIN','591000','5000');
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-260912-0016','D','2026-09-12','10:15:45','kasir','PENJUALAN','F226121015444','14958912000','591000','14959503000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='591000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226121015444' 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 ('F226121015445','kasir',' 1',' MED1 5K LG','TOKO','SMBK-D','D1E-ZIAA-118-T','LT MODEL LUCKY CAT VAR LG 8K ','OL','0.550','1','100.00','577000','0','0','15000','586000','0','5000','0','591000','DIN','T0083416','D1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZIAA-118-T' 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-09-12' AND kode_barang='D1E-ZIAA-118-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226121015445','2026-09-12','0.550','2026-09-12','10:15:45','PLG0084866','586000','586000','5000','591000','591000','kasir','2026-09-12 10:15:44','F22612101544');
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-09-12','F226121015445','2026-09-12','10:15:45','DIN','591000','5000');
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-260912-0017','D','2026-09-12','10:15:45','kasir','PENJUALAN','F226121015445','14959503000','591000','14960094000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='591000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226121015445' 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 ('F226121015446','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZHAA-49-T','LT SLOBOK HURUF A BG 8K ','OL','0.550','1','100.00','591000','0','0','15000','597000','0','5000','0','602000','DIN','T0082189','D1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZHAA-49-T' 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-09-12' AND kode_barang='D1F-ZHAA-49-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226121015446','2026-09-12','0.550','2026-09-12','10:15:45','PLG0084867','597000','597000','5000','602000','602000','kasir','2026-09-12 10:15:44','F22612101544');
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-09-12','F226121015446','2026-09-12','10:15:45','DIN','602000','5000');
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-260912-0018','D','2026-09-12','10:15:45','kasir','PENJUALAN','F226121015446','14960094000','602000','14960696000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='602000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226121015446' 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 ('F226121029341','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZIAA-123-T','LT MODEL MERAK PASIR VAR BG 8K ','OL','0.930','1','100.00','1004000','0','0','15000','1014000','0','5000','0','1019000','DIN','T0083421','D1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZIAA-123-T' 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-09-12' AND kode_barang='D1F-ZIAA-123-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226121029341','2026-09-12','0.930','2026-09-12','10:29:35','PLG0084868','1014000','1014000','5000','1019000','1019000','kasir','2026-09-12 10:29:34','F22612102934');
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-09-12','F226121029341','2026-09-12','10:29:35','DIN','1019000','5000');
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-260912-0019','D','2026-09-12','10:29:35','kasir','PENJUALAN','F226121029341','14960696000','1019000','14961715000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1019000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226121029341' 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 ('F226121029342','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZIAA-121-T','LT MODEL BUNGA PASIR VAR BG 8K ','OL','1.130','1','100.00','1220000','0','0','15000','1226000','0','6000','0','1232000','DIN','T0083419','D1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZIAA-121-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='D1F-ZIAA-121-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226121029342','2026-09-12','1.130','2026-09-12','10:29:35','PLG0084869','1226000','1226000','6000','1232000','1232000','kasir','2026-09-12 10:29:34','F22612102934');
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-09-12','F226121029342','2026-09-12','10:29:35','DIN','1232000','6000');
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-260912-0020','D','2026-09-12','10:29:35','kasir','PENJUALAN','F226121029342','14961715000','1232000','14962947000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1232000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226121029342' 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 ('F226121029343','kasir',' 1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZIAA-139-T','AS EXTENSION LG 8K ','OL','0.170','1','100.00','186000','0','0','15000','192000','0','5000','0','197000','DIN','T0083437','S1G','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZIAA-139-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.170',berat_jual_asli=berat_jual_asli+'0.170',stock_jual='1',berat_akhir=berat_akhir-'0.170',berat_akhir_asli=berat_akhir_asli-'0.170',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='S1G-ZIAA-139-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F226121029343','2026-09-12','0.170','2026-09-12','10:29:35','PLG0084870','192000','192000','5000','197000','197000','kasir','2026-09-12 10:29:34','F22612102934');
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-09-12','F226121029343','2026-09-12','10:29:35','DIN','197000','5000');
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-260912-0021','D','2026-09-12','10:29:35','kasir','PENJUALAN','F226121029343','14962947000','197000','14963144000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='197000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226121029343' 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 ('F226121029344','kasir',' 1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZIAA-144-T','AS EXTENSION LG 8K ','OL','0.180','1','100.00','197000','0','0','15000','203000','0','5000','0','208000','DIN','T0083442','S1G','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZIAA-144-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.180',berat_jual_asli=berat_jual_asli+'0.180',stock_jual='1',berat_akhir=berat_akhir-'0.180',berat_akhir_asli=berat_akhir_asli-'0.180',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='S1G-ZIAA-144-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F226121029344','2026-09-12','0.180','2026-09-12','10:29:35','PLG0084871','203000','203000','5000','208000','208000','kasir','2026-09-12 10:29:34','F22612102934');
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-09-12','F226121029344','2026-09-12','10:29:35','DIN','208000','5000');
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-260912-0022','D','2026-09-12','10:29:35','kasir','PENJUALAN','F226121029344','14963144000','208000','14963352000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='208000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226121029344' 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 ('F226121038091','kasir','1',' MFE1 KH 14','TOKO','SMBK-E','E1F-ZIXG-77-T','CC MODEL HATI SLEP VAR KH 14 8K','','0.370','1','100.00','398000','0','0','15000','398000','0','0','0','398000','TJ','T0083136','E1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIXG-77-T' 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-09-12' AND kode_barang='E1F-ZIXG-77-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226121038091','2026-09-12','0.370','2026-09-12','10:38:10','PLG0084872','398000','398000','0','398000','398000','kasir','2026-09-12 10:38:09','F22612103809');
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-09-12','F226121038091','2026-09-12','10:38:10','TJ','398000','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-260912-0023','D','2026-09-12','10:38:10','kasir','PENJUALAN','F226121038091','14963352000','398000','14963750000');
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-20260912-0001','1','D1F-ZIXH-240-0','1','0.570','0.570','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-ZIXH-240-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-ZIXH-240-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-09-12 10:54:58' WHERE kode_barang='D1F-ZIXH-240-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-ZIXH-240-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-09-12 10:54:58','TOKO','SMBK-D','D1F','D1F-ZIXH-240-0','1','0.570','0.570','1','0.570','0.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-ZIXH-240-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-ZIXH-240-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260912-0001','2026-09-12','10:54','0.570','input','2026-09-12 10:54:57');
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 ('F226121100541','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZHBE-134-0','CC X MODEL MATA CM 22 8K ','','1.050','1','100.00','1087000','0','0','15000','1087000','0','0','0','1087000','DIN','00420176','E2D','0','0','-','0','1030000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZHBE-134-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='E2D-ZHBE-134-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226121100541','2026-09-12','1.050','2026-09-12','11:00:55','PLG0084873','1087000','1087000','0','1087000','1087000','kasir','2026-09-12 11:00:54','F22612110054');
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-09-12','F226121100541','2026-09-12','11:00:55','DIN','1087000','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-260912-0024','D','2026-09-12','11:00:55','kasir','PENJUALAN','F226121100541','14963750000','1087000','14964837000');
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 ('F226121114281','kasir','1',' MED1 LG ','TOKO','SMBK-D','D1E-ZHAA-78-T','LT SLOBOK BOLA SLEP LG 8K ','OL','0.450','1','100.00','475000','0','0','15000','480000','0','5000','0','485000','TJ','T0082218','D1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZHAA-78-T' 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-09-12' AND kode_barang='D1E-ZHAA-78-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226121114281','2026-09-12','0.450','2026-09-12','11:14:28','PLG0084874','480000','480000','5000','485000','485000','kasir','2026-09-12 11:14:28','F22612111428');
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-09-12','F226121114281','2026-09-12','11:14:28','TJ','485000','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-260912-0025','D','2026-09-12','11:14:28','kasir','PENJUALAN','F226121114281','14964837000','485000','14965322000');
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 ('F226121124031','kasir','1',' MDE2 X LG ','TOKO','SMBK-E','E2D-ZGCX-172-0','CC X METRO MATA LG 18 8K ','','1.360','1','100.00','1408000','0','0','15000','1408000','0','0','0','1408000','LUS','00416071','E2D','0','0','-','0','1030000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGCX-172-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.360',berat_jual_asli=berat_jual_asli+'1.360',stock_jual='1',berat_akhir=berat_akhir-'1.360',berat_akhir_asli=berat_akhir_asli-'1.360',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='E2D-ZGCX-172-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226121124031','2026-09-12','1.360','2026-09-12','11:24:04','PLG0084875','1408000','1408000','0','1408000','1408000','kasir','2026-09-12 11:24:03','F22612112403');
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-09-12','F226121124031','2026-09-12','11:24:04','LUS','1408000','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-260912-0026','D','2026-09-12','11:24:04','kasir','PENJUALAN','F226121124031','14965322000','1408000','14966730000');
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 ('F226121124451','kasir','1',' MEH1 15K U','TOKO','SMBK-H','H1E-ZHBG-69-T','KL ITALY BOLA ARESO SLEP UB 42 8K ','OL','2.620','1','100.00','2764000','0','0','15000','2775000','0','15000','0','2790000','LUS','T0082575','H1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHBG-69-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.620',berat_jual_asli=berat_jual_asli+'2.620',stock_jual='1',berat_akhir=berat_akhir-'2.620',berat_akhir_asli=berat_akhir_asli-'2.620',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='H1E-ZHBG-69-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226121124451','2026-09-12','2.620','2026-09-12','11:24:45','PLG0084876','2775000','2775000','15000','2790000','2790000','kasir','2026-09-12 11:24:45','F22612112445');
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-09-12','F226121124451','2026-09-12','11:24:45','LUS','2790000','15000');
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-260912-0027','D','2026-09-12','11:24:45','kasir','PENJUALAN','F226121124451','14966730000','2790000','14969520000');
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 ('F226121146581','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZEXF-87-T','LT SLOBOK BALOK HURUF BG L 8K ','OL','0.450','1','100.00','484000','0','0','15000','619000','0','5000','0','624000','DIN','T0079248','D1F','0','0','-','0','1090000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZEXF-87-T' 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-09-12' AND kode_barang='D1F-ZEXF-87-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226121146581','2026-09-12','0.450','2026-09-12','11:46:58','PLG0084877','619000','619000','5000','624000','624000','kasir','2026-09-12 11:46:58','F22612114658');
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-09-12','F226121146581','2026-09-12','11:46:58','DIN','624000','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-260912-0028','D','2026-09-12','11:46:58','kasir','PENJUALAN','F226121146581','14969520000','624000','14970144000');
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 ('F226121148091','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZIXH-240-0','LT SLOBOK HURUF BALOK BG A 8K ','OL','0.570','1','100.00','613000','0','0','15000','619000','0','5000','0','624000','DIN','00422507','D1F','0','0','-','0','1090000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZIXH-240-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='D1F-ZIXH-240-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226121148091','2026-09-12','0.570','2026-09-12','11:48:09','PLG0084878','619000','619000','5000','624000','624000','kasir','2026-09-12 11:48:09','F22612114809');
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-09-12','F226121148091','2026-09-12','11:48:09','DIN','624000','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-260912-0029','D','2026-09-12','11:48:09','kasir','PENJUALAN','F226121148091','14970144000','624000','14970768000');
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('D1F-ZEXF-87-T','T0079248','T0079248','LT SLOBOK BALOK HURUF BG L 8K ','LT SLOBOK BALOK HURUF BG L 8K','','','484000','484000',' 0','0','input','2026-09-12 11:54:40');
UPDATE tm_barang SET nama_barang='LT SLOBOK BALOK HURUF BG L 8K' ,nama_atribut='' ,kode_intern='MFD1 5K BG L ', kadar_cetak='8.00', potongan='0',tagid='T0079248',harga_modal='0' WHERE kode_barang='D1F-ZEXF-87-T' 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 ('F226121200391','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZEXF-87-T','LT SLOBOK BALOK HURUF BG L 8K','OL','0.450','1','100.00','484000','0','0','15000','489000','0','5000','0','494000','DIN','T0079248','D1F','0','0','-','0','1090000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZEXF-87-T' 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-09-12' AND kode_barang='D1F-ZEXF-87-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226121200391','2026-09-12','0.450','2026-09-12','12:00:40','PLG0084879','489000','489000','5000','494000','494000','kasir','2026-09-12 12:00:39','F22612120039');
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-09-12','F226121200391','2026-09-12','12:00:40','DIN','494000','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-260912-0031','D','2026-09-12','12:00:40','kasir','PENJUALAN','F226121200391','14970144000','494000','14970638000');
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('E1TD-ZGAG-24-T','T0081247','T0081247','CC VELG POLOS SLEP CM 16 17K ','CC VELG POLOS SLEP CM 16 17K','','','1940000','1940000',' 0','0','input','2026-09-12 12:16:28');
UPDATE tm_barang SET nama_barang='CC VELG POLOS SLEP CM 16 17K' ,nama_atribut='' ,kode_intern='TDE1 CM 16 ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='E1TD-ZGAG-24-T' 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 ('F226121217301','kasir','1',' TDE1 CM 16','TOKO','TBK-E','E1TD-ZGAG-24-T','CC VELG POLOS SLEP CM 16 17K','','1.000','1','100.00','1940000','0','0','15000','1910000','0','0','0','1910000','NS','T0081247','E1TD','0','0','-','1','1940000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-ZGAG-24-T' 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-09-12' AND kode_barang='E1TD-ZGAG-24-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226121217301','2026-09-12','1.000','2026-09-12','12:17:30','PLG0084880','1910000','1910000','0','1910000','0','kasir','2026-09-12 12:17:30','F22612121730');
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-09-12','F226121217301','2026-09-12','12:17:30','NS','1910000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260912-0001','2026-09-12','2026-09-12 12:17:30','PENJUALAN : F226121217301','827419874912','BCA','1910000','1910000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260912-0002','D','2026-09-12','12:17:30','BCA','PENJUALAN','F226121217301','4802919888','1910000','4804829888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('827419874912','SUMARNI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1910000' WHERE no_faktur_jual='F226121217301' 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 ('F226121227231','kasir','1',' MEE1 LG 14','TOKO','SMBK-E','E1E-ZIAA-163-T','CC MODEL ISYANA LG 14 8K ','','0.570','1','100.00','598000','0','0','15000','601000','0','0','0','601000','TJ','T0083461','E1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZIAA-163-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='E1E-ZIAA-163-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226121227231','2026-09-12','0.570','2026-09-12','12:27:23','PLG0084881','601000','601000','0','601000','601000','kasir','2026-09-12 12:27:23','F22612122723');
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-09-12','F226121227231','2026-09-12','12:27:23','TJ','601000','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-260912-0032','D','2026-09-12','12:27:23','kasir','PENJUALAN','F226121227231','14970638000','601000','14971239000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='601000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226121227231' 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 ('F226121227232','kasir',' 1',' MFE2 KH 10','TOKO','SMBK-E','E2F-ZIXI-91-T','CC MODEL PAKU MATA VAR KH 10 8K ','','0.400','1','100.00','430000','0','0','15000','430000','0','0','0','430000','TJ','T0083346','E2F','0','0','-','0','1090000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZIXI-91-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='E2F-ZIXI-91-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226121227232','2026-09-12','0.400','2026-09-12','12:27:23','PLG0084882','430000','430000','0','430000','430000','kasir','2026-09-12 12:27:23','F22612122723');
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-09-12','F226121227232','2026-09-12','12:27:23','TJ','430000','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-260912-0033','D','2026-09-12','12:27:23','kasir','PENJUALAN','F226121227232','14971239000','430000','14971669000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='430000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226121227232' 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 ('F226121227233','kasir',' 1',' MFE1 KH 12','TOKO','SMBK-E','E1F-ZIXH-24-T','CC MODEL BUNGA CLOVER SLEP KH 12 8K ','','0.360','1','100.00','387000','0','0','15000','387000','0','0','0','387000','TJ','T0083171','E1F','0','0','-','0','1090000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIXH-24-T' 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-09-12' AND kode_barang='E1F-ZIXH-24-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226121227233','2026-09-12','0.360','2026-09-12','12:27:23','PLG0084883','387000','387000','0','387000','387000','kasir','2026-09-12 12:27:23','F22612122723');
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-09-12','F226121227233','2026-09-12','12:27:23','TJ','387000','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-260912-0034','D','2026-09-12','12:27:23','kasir','PENJUALAN','F226121227233','14971669000','387000','14972056000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='387000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226121227233' 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 ('F226121228271','kasir','1',' MEE2E CM 1','TOKO','SMBK-E','E2E-ZHCA-24-T','CC SOLITAIRE MATA SLEP CM 10 8K ','','0.780','1','100.00','823000','0','0','15000','823000','0','0','0','823000','DIN','T0082813','E2E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHCA-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.780',berat_jual_asli=berat_jual_asli+'0.780',stock_jual='1',berat_akhir=berat_akhir-'0.780',berat_akhir_asli=berat_akhir_asli-'0.780',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='E2E-ZHCA-24-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226121228271','2026-09-12','0.780','2026-09-12','12:28:27','PLG0084884','823000','823000','0','823000','823000','kasir','2026-09-12 12:28:27','F22612122827');
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-09-12','F226121228271','2026-09-12','12:28:27','DIN','823000','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-260912-0035','D','2026-09-12','12:28:27','kasir','PENJUALAN','F226121228271','14972056000','823000','14972879000');
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 ('F226121239381','kasir','1',' MFE2 KH 14','TOKO','SMBK-E','E2F-ZIXH-40-T','CC MODEL PAKU MATA VAR KH 14 8K ','','0.380','1','100.00','408000','0','0','15000','409000','0','0','0','409000','NOV','T0083187','E2F','0','0','-','0','1090000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZIXH-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='E2F-ZIXH-40-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226121239381','2026-09-12','0.380','2026-09-12','12:39:38','PLG0084885','409000','409000','0','409000','0','kasir','2026-09-12 12:39:38','F22612123938');
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-09-12','F226121239381','2026-09-12','12:39:38','NOV','409000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260912-0002','2026-09-12','2026-09-12 12:39:38','PENJUALAN : F226121239381','435566879090886','BCA','409000','409000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260912-0003','D','2026-09-12','12:39:38','BCA','PENJUALAN','F226121239381','4804829888','409000','4805238888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('435566879090886','MEYDA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='409000' WHERE no_faktur_jual='F226121239381' LIMIT 1;
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-20260912-0001','1','E1F-YICX-62-T','1','0.550','0.550','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-YICX-62-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-YICX-62-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-12 12:55:57' WHERE kode_barang='E1F-YICX-62-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-YICX-62-T' 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-09-12 12:55:57','TOKO','SMBK-E','E1F','E1F-YICX-62-T','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-YICX-62-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-YICX-62-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260912-0001','2026-09-12','12:55','0.550','input','2026-09-12 12:55:56');
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 ('F226120102561','kasir','1',' MFE1 AY 15','TOKO','SMBK-E','E1F-YICX-62-T','CC MODEL UNTIR AY 15 8K ','OLS K5XJH','0.550','1','100.00','591000','0','0','15000','619000','0','63000','0','682000','DIN','T0073474','E1F','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-YICX-62-T' 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-09-12' AND kode_barang='E1F-YICX-62-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120102561','2026-09-12','0.550','2026-09-12','13:02:57','PLG0084886','619000','619000','63000','682000','682000','kasir','2026-09-12 13:02:56','F22612010256');
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-09-12','F226120102561','2026-09-12','13:02:57','DIN','682000','63000');
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-260912-0036','D','2026-09-12','13:02:57','kasir','PENJUALAN','F226120102561','14972879000','682000','14973561000');
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 ('F226120124111','kasir','1',' MEF1 LG D5','TOKO','SMBK-F','F1E-ZIAA-71-T','GL OVAL TINJU BOLA ARESO LG D54 8K ','OL','2.130','1','100.00','2236000','0','0','15000','2257000','0','11000','0','2268000','NS','T0083369','F1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZIAA-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.130',berat_jual_asli=berat_jual_asli+'2.130',stock_jual='1',berat_akhir=berat_akhir-'2.130',berat_akhir_asli=berat_akhir_asli-'2.130',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='F1E-ZIAA-71-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120124111','2026-09-12','2.130','2026-09-12','13:24:12','PLG0084887','2257000','2257000','11000','2268000','2268000','kasir','2026-09-12 13:24:11','F22612012411');
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-09-12','F226120124111','2026-09-12','13:24:12','NS','2268000','11000');
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-260912-0037','D','2026-09-12','13:24:12','kasir','PENJUALAN','F226120124111','14973561000','2268000','14975829000');
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 ('F226120155341','kasir','1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZIAA-131-T','LT CHARM DAUN LG 8K ','OL','0.220','1','100.00','241000','0','0','15000','243000','0','5000','0','248000','NS','T0083429','D1G','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZIAA-131-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.220',berat_jual_asli=berat_jual_asli+'0.220',stock_jual='1',berat_akhir=berat_akhir-'0.220',berat_akhir_asli=berat_akhir_asli-'0.220',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='D1G-ZIAA-131-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120155341','2026-09-12','0.220','2026-09-12','13:55:35','PLG0084888','243000','243000','5000','248000','248000','kasir','2026-09-12 13:55:34','F22612015534');
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-09-12','F226120155341','2026-09-12','13:55:35','NS','248000','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-260912-0038','D','2026-09-12','13:55:35','kasir','PENJUALAN','F226120155341','14975829000','248000','14976077000');
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 ('F226120156341','kasir','1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZIAA-150-T','AS EXTENSION LG 8K ','OL','0.180','1','100.00','197000','0','0','15000','203000','0','5000','0','208000','NS','T0083448','S1G','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZIAA-150-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.180',berat_jual_asli=berat_jual_asli+'0.180',stock_jual='1',berat_akhir=berat_akhir-'0.180',berat_akhir_asli=berat_akhir_asli-'0.180',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='S1G-ZIAA-150-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F226120156341','2026-09-12','0.180','2026-09-12','13:56:34','PLG0084889','203000','203000','5000','208000','208000','kasir','2026-09-12 13:56:34','F22612015634');
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-09-12','F226120156341','2026-09-12','13:56:34','NS','208000','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-260912-0039','D','2026-09-12','13:56:34','kasir','PENJUALAN','F226120156341','14976077000','208000','14976285000');
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 ('F226120217031','kasir','1',' MFE1 KH 18','TOKO','SMBK-E','E1F-ZIAA-189-T','CC MODEL BUNGA CLOVER SLEP KH 18 8K ','OL','0.370','1','100.00','400000','0','0','15000','401000','0','5000','0','406000','TJ','T0083487','E1F','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIAA-189-T' 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-09-12' AND kode_barang='E1F-ZIAA-189-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120217031','2026-09-12','0.370','2026-09-12','14:17:04','PLG0084890','401000','401000','5000','406000','406000','kasir','2026-09-12 14:17:03','F22612021703');
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-09-12','F226120217031','2026-09-12','14:17:04','TJ','406000','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-260912-0040','D','2026-09-12','14:17:04','kasir','PENJUALAN','F226120217031','14976285000','406000','14976691000');
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 ('F226120231041','kasir','1',' MEF1E YT 5','TOKO','SMBK-F','F1E-ZHXC-106-T','GL OVAL C SLEP YT 52 8K ','OL','2.000','1','100.00','2110000','0','0','15000','2120000','0','10000','0','2130000','DIN','T0081835','F1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZHXC-106-T' 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-09-12' AND kode_barang='F1E-ZHXC-106-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120231041','2026-09-12','2.000','2026-09-12','14:31:05','PLG0084891','2120000','2120000','10000','2130000','2130000','kasir','2026-09-12 14:31:04','F22612023104');
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-09-12','F226120231041','2026-09-12','14:31:05','DIN','2130000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260912-0041','D','2026-09-12','14:31:05','kasir','PENJUALAN','F226120231041','14976691000','2130000','14978821000');
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('F3E-ZEAB-28-T','T0079386','T0079386','GL LONG LING VAR UB 8K ','GL LONG LING VAR UB 8K','','','2131500','2131500',' 0','0','input','2026-09-12 14:36:38');
UPDATE tm_barang SET nama_barang='GL LONG LING VAR UB 8K' ,nama_atribut='' ,kode_intern='MEF3 UB ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='F3E-ZEAB-28-T' 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 ('F226120237431','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZEAB-28-T','GL LONG LING VAR UB 8K','','2.020','1','100.00','2131000','0','0','15000','2131000','0','0','0','2131000','TJ','T0079386','F3E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEAB-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='F3E-ZEAB-28-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120237431','2026-09-12','2.020','2026-09-12','14:37:43','PLG0084892','2131000','2131000','0','2131000','2131000','kasir','2026-09-12 14:37:43','F22612023743');
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-09-12','F226120237431','2026-09-12','14:37:43','TJ','2131000','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-260912-0042','D','2026-09-12','14:37:43','kasir','PENJUALAN','F226120237431','14978821000','2131000','14980952000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120102561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120102561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120102561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120124111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120124111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120124111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120155341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120155341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120155341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120156341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120156341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120156341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120217031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120217031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120217031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120231041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120231041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120231041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120237431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120237431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120237431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120909101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120909101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120909101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120910261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120910261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120910261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120911111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120911111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120911111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120911311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120911311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120911311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120943581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120943581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120943581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120948351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120948351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120948351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120949401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120949401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120949401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120957041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120957041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120957041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120958041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120958041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120958041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121015441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121015441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121015441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121015442' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121015442' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121015442';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121015443' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121015443' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121015443';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121015444' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121015444' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121015444';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121015445' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121015445' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121015445';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121015446' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121015446' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121015446';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121029341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121029341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121029341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121029342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121029342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121029342';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121029343' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121029343' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121029343';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121029344' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121029344' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121029344';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121038091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121038091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121038091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121100541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121100541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121100541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121114281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121114281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121114281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121124031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121124031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121124031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121124451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121124451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121124451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121148091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121148091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121148091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121200391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121200391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121200391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121217301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121217301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121217301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121227231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121227231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121227231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121227232' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121227232' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121227232';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121227233' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121227233' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121227233';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121228271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121228271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121228271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226121239381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226121239381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226121239381';
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 ('F226120246461','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZIAX-134-0','CC X SOLITAIRE MATA CM 14 8K ','OL','1.810','1','100.00','1864000','0','0','15000','1891000','0','10000','0','1901000','NS','00422938','E2D','0','0','-','0','1030000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZIAX-134-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.810',berat_jual_asli=berat_jual_asli+'1.810',stock_jual='1',berat_akhir=berat_akhir-'1.810',berat_akhir_asli=berat_akhir_asli-'1.810',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='E2D-ZIAX-134-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120246461','2026-09-12','1.810','2026-09-12','14:46:47','PLG0084893','1891000','1891000','10000','1901000','1901000','kasir','2026-09-12 14:46:46','F22612024646');
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-09-12','F226120246461','2026-09-12','14:46:47','NS','1901000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260912-0043','D','2026-09-12','14:46:47','kasir','PENJUALAN','F226120246461','14980952000','1901000','14982853000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120246461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120246461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120246461';
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 ('F226120301481','kasir','1',' MJH2 X UB ','TOKO','SMBK-H','H2J-XHBD-27-0','KL X GUCCI UB 44 9K ','OL','4.000','1','100.00','4680000','0','0','15000','4640000','0','20000','0','4660000','DIN','00313398','H2J','0','0','-','1','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-XHBD-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.000',berat_jual_asli=berat_jual_asli+'4.000',stock_jual='1',berat_akhir=berat_akhir-'4.000',berat_akhir_asli=berat_akhir_asli-'4.000',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='H2J-XHBD-27-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120301481','2026-09-12','4.000','2026-09-12','15:01:49','PLG0084894','4640000','4640000','20000','4660000','4660000','kasir','2026-09-12 15:01:48','F22612030148');
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-09-12','F226120301481','2026-09-12','15:01:49','DIN','4660000','20000');
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-260912-0044','D','2026-09-12','15:01:49','kasir','PENJUALAN','F226120301481','14982853000','4660000','14987513000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4660000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226120301481' 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 ('F226120301482','kasir',' 1',' MDB1 X CM ','TOKO','SMBK-B','B1D-ZHBE-186-0','GW X PANJANG DAUN SLEP CM 8K ','OL','1.060','1','100.00','1097000','0','0','15000','1103000','0','5000','0','1108000','DIN','00420228','B1D','0','0','-','0','1030000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZHBE-186-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-09-12' AND kode_barang='B1D-ZHBE-186-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120301482','2026-09-12','1.060','2026-09-12','15:01:49','PLG0084895','1103000','1103000','5000','1108000','1108000','kasir','2026-09-12 15:01:48','F22612030148');
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-09-12','F226120301482','2026-09-12','15:01:49','DIN','1108000','5000');
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-260912-0045','D','2026-09-12','15:01:49','kasir','PENJUALAN','F226120301482','14987513000','1108000','14988621000','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='F226120301482' 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 ('F226120301483','kasir',' 1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZIAA-135-T','LT CHARM DAUN LG 8K ','OL','0.200','1','100.00','219000','0','0','15000','221000','0','5000','0','226000','DIN','T0083433','D1G','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZIAA-135-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='D1G-ZIAA-135-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120301483','2026-09-12','0.200','2026-09-12','15:01:49','PLG0084896','221000','221000','5000','226000','226000','kasir','2026-09-12 15:01:48','F22612030148');
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-09-12','F226120301483','2026-09-12','15:01:49','DIN','226000','5000');
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-260912-0046','D','2026-09-12','15:01:49','kasir','PENJUALAN','F226120301483','14988621000','226000','14988847000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='226000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226120301483' 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 ('F226120301484','kasir',' 1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZIAA-138-T','LT CHARM DAUN LG 8K ','OL','0.210','1','100.00','230000','0','0','15000','232000','0','5000','0','237000','DIN','T0083436','D1G','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZIAA-138-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.210',berat_jual_asli=berat_jual_asli+'0.210',stock_jual='1',berat_akhir=berat_akhir-'0.210',berat_akhir_asli=berat_akhir_asli-'0.210',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='D1G-ZIAA-138-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120301484','2026-09-12','0.210','2026-09-12','15:01:49','PLG0084897','232000','232000','5000','237000','237000','kasir','2026-09-12 15:01:48','F22612030148');
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-09-12','F226120301484','2026-09-12','15:01:49','DIN','237000','5000');
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-260912-0047','D','2026-09-12','15:01:49','kasir','PENJUALAN','F226120301484','14988847000','237000','14989084000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='237000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226120301484' 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 ('F226120301485','kasir',' 1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZIAA-133-T','LT CHARM DAUN LG 8K ','OL','0.220','1','100.00','241000','0','0','15000','243000','0','5000','0','248000','DIN','T0083431','D1G','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZIAA-133-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.220',berat_jual_asli=berat_jual_asli+'0.220',stock_jual='1',berat_akhir=berat_akhir-'0.220',berat_akhir_asli=berat_akhir_asli-'0.220',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='D1G-ZIAA-133-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120301485','2026-09-12','0.220','2026-09-12','15:01:49','PLG0084898','243000','243000','5000','248000','248000','kasir','2026-09-12 15:01:48','F22612030148');
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-09-12','F226120301485','2026-09-12','15:01:49','DIN','248000','5000');
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-260912-0048','D','2026-09-12','15:01:49','kasir','PENJUALAN','F226120301485','14989084000','248000','14989332000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='248000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226120301485' 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 ('F226120302331','kasir','1',' MED1E LG ','TOKO','SMBK-D','D1E-ZHXD-67-T','LT CHARM KARAWANG PITA SLEP LG 8K ','OL','0.710','1','100.00','749000','0','0','15000','756000','0','5000','0','761000','DIN','T0081905','D1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZHXD-67-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.710',berat_jual_asli=berat_jual_asli+'0.710',stock_jual='1',berat_akhir=berat_akhir-'0.710',berat_akhir_asli=berat_akhir_asli-'0.710',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='D1E-ZHXD-67-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120302331','2026-09-12','0.710','2026-09-12','15:02:34','PLG0084899','756000','756000','5000','761000','761000','kasir','2026-09-12 15:02:33','F22612030233');
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-09-12','F226120302331','2026-09-12','15:02:34','DIN','761000','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-260912-0049','D','2026-09-12','15:02:34','kasir','PENJUALAN','F226120302331','14989332000','761000','14990093000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120301481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120301481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120301481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120301482' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120301482' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120301482';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120301483' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120301483' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120301483';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120301484' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120301484' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120301484';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120301485' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120301485' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120301485';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120302331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120302331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120302331';
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 ('F226120306091','kasir','1',' MEA1E X LG','TOKO','SMBK-A','A1E-ZHXH-54-0','AT X GYPSY ANAK HATI VAR LG 8K ','OL','0.550','1','100.00','580000','0','0','15000','586000','0','5000','0','591000','DIN','00417783','A1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZHXH-54-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-09-12' AND kode_barang='A1E-ZHXH-54-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120306091','2026-09-12','0.550','2026-09-12','15:06:09','PLG0084900','586000','586000','5000','591000','591000','kasir','2026-09-12 15:06:09','F22612030609');
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-09-12','F226120306091','2026-09-12','15:06:09','DIN','591000','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-260912-0050','D','2026-09-12','15:06:09','kasir','PENJUALAN','F226120306091','14990093000','591000','14990684000');
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 ('F226120307001','kasir','1',' MFE1 KH 12','TOKO','SMBK-E','E1F-ZIXH-27-T','CC MODEL BUNGA CLOVER SLEP KH 12 8K ','','0.360','1','100.00','387000','0','0','15000','387000','0','0','0','387000','LUS','T0083174','E1F','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIXH-27-T' 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-09-12' AND kode_barang='E1F-ZIXH-27-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120307001','2026-09-12','0.360','2026-09-12','15:07:00','PLG0084901','387000','387000','0','387000','387000','kasir','2026-09-12 15:07:00','F22612030700');
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-09-12','F226120307001','2026-09-12','15:07:00','LUS','387000','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-260912-0051','D','2026-09-12','15:07:00','kasir','PENJUALAN','F226120307001','14990684000','387000','14991071000');
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-00005701','X-00005701','GL ANAK BANGKOK MODEL C TD D42 8K','GR','---','F1E','BELI','BELI001','1628000','2026-09-12','1.930','1','kasir','2026-09-12 15:22:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00005701','X-00005701');
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-260912-0001','F226070125402','LUS','1','BELI','BELI001','F1E', 'X-00005701', 'GL ANAK BANGKOK MODEL C TD D42 8K','1.950','1.930','100.00','2205000','1628000','843523','1050000','1','1628000','1628000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.930',berat_beli_asli=berat_beli_asli+'1.930',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.930',berat_akhir_asli=berat_akhir_asli+'1.930',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-12' 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-260912-0001','2026-09-12','2026-09-12','15:22:08','LUS','---','1.930','1628000','1628000','1628000','1628000','1628000','kasir','2026-09-12 15:22:09','FB-260912-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260912-0001','FAUS','PARINGAN JENANGAN','','','081235121500','kasir','2026-09-12 15:22:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-12' 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-260912-0052','K','2026-09-12','15:22:08','kasir','PEMBELIAN UMUM','FB-260912-0001','14991071000','1628000','14989443000');
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-00005702','X-00005702','AT X ITALY SLEP VAR BW 8K','GR','---','A1E','BELI','BELI001','523000','2026-09-12','0.540','1','kasir','2026-09-12 15:23:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00005702','X-00005702');
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-260912-0002','F226300303051','LUS','1','BELI','BELI001','A1E', 'X-00005702', 'AT X ITALY SLEP VAR BW 8K','0.550','0.540','100.00','630000','523000','968519','1050000','1','523000','523000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.540',berat_beli_asli=berat_beli_asli+'0.540',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.540',berat_akhir_asli=berat_akhir_asli+'0.540',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-12' 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-260912-0002','2026-09-12','2026-09-12','15:23:46','LUS','---','0.540','523000','523000','523000','523000','523000','kasir','2026-09-12 15:23:47','FB-260912-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260912-0002','LS','','','','','kasir','2026-09-12 15:23:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-12' 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-260912-0053','K','2026-09-12','15:23:46','kasir','PEMBELIAN UMUM','FB-260912-0002','14989443000','523000','14988920000');
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-00005703','X-00005703','GL TRIXIE SERUT MODEL BUNGA VAR LG 8K','GR','---','F3E','BELI','BELI001','1280000','2026-09-12','1.350','1','kasir','2026-09-12 15:24:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00005703','X-00005703');
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-260912-0003','F226130824161','NOV','1','BELI','BELI001','F3E', 'X-00005703', 'GL TRIXIE SERUT MODEL BUNGA VAR LG 8K','1.350','1.350','100.00','1519000','1280000','948148','1050000','1','1280000','1280000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.350',berat_beli_asli=berat_beli_asli+'1.350',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.350',berat_akhir_asli=berat_akhir_asli+'1.350',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-12' 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-260912-0003','2026-09-12','2026-09-12','15:24:18','NOV','---','1.350','1280000','1280000','1280000','1280000','1280000','kasir','2026-09-12 15:24:18','FB-260912-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260912-0003','AMIRUL HIDAYATI','PONOROGO','','','','kasir','2026-09-12 15:24:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-12' 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-260912-0054','K','2026-09-12','15:24:18','kasir','PEMBELIAN UMUM','FB-260912-0003','14988920000','1280000','14987640000');
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-00005704','X-00005704','CC PIPA KUKU MACAN SLEP CM 16 8K','GR','---','E1E','BELI','BELI001','570000','2026-09-12','0.600','1','kasir','2026-09-12 15:25:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00005704','X-00005704');
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-260912-0004','F226080150461','LUS','1','BELI','BELI001','E1E', 'X-00005704', 'CC PIPA KUKU MACAN SLEP CM 16 8K','0.600','0.600','100.00','720000','570000','950000','1050000','1','570000','570000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.600',berat_beli_asli=berat_beli_asli+'0.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.600',berat_akhir_asli=berat_akhir_asli+'0.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-12' 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-260912-0004','2026-09-12','2026-09-12','15:25:16','LUS','---','0.600','570000','570000','570000','570000','570000','kasir','2026-09-12 15:25:16','FB-260912-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260912-0004','LUKI','JL. PARANGBARIS 3 KADIPATEN','','','081224833524','kasir','2026-09-12 15:25:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-12' 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-260912-0055','K','2026-09-12','15:25:16','kasir','PEMBELIAN UMUM','FB-260912-0004','14987640000','570000','14987070000');
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-00005705','X-00005705','CC PIPA KUKU MACAN SLEP CM 16 8K','GR','---','E1E','BELI','BELI001','570000','2026-09-12','0.600','1','kasir','2026-09-12 15:26:05');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00005705','X-00005705');
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-260912-0005','F226171029291','LUS','1','BELI','BELI001','E1E', 'X-00005705', 'CC PIPA KUKU MACAN SLEP CM 16 8K','0.600','0.600','100.00','717000','570000','950000','1050000','1','570000','570000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.600',berat_beli_asli=berat_beli_asli+'0.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.600',berat_akhir_asli=berat_akhir_asli+'0.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-12' 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-260912-0005','2026-09-12','2026-09-12','15:26:04','LUS','---','0.600','570000','570000','570000','570000','570000','kasir','2026-09-12 15:26:05','FB-260912-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260912-0005','YUNI','JALAN PARANG BARIS PASAR PON','','','081224833524','kasir','2026-09-12 15:26:05');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-12' 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-260912-0056','K','2026-09-12','15:26:04','kasir','PEMBELIAN UMUM','FB-260912-0005','14987070000','570000','14986500000');
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-00005706','X-00005706','LT X MODEL ARESO SLEP UB 8K','GR','---','D1F','BELI','BELI001','355000','2026-09-12','0.360','1','kasir','2026-09-12 15:26:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1F','X-00005706','X-00005706');
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-260912-0006','F226241154541','LUS','1','BELI','BELI001','D1F', 'X-00005706', 'LT X MODEL ARESO SLEP UB 8K','0.360','0.360','100.00','401000','355000','986111','1075000','1','355000','355000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.360',berat_beli_asli=berat_beli_asli+'0.360',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.360',berat_akhir_asli=berat_akhir_asli+'0.360',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1F' 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-260912-0006','2026-09-12','2026-09-12','15:26:45','LUS','---','0.360','355000','355000','355000','355000','355000','kasir','2026-09-12 15:26:46','FB-260912-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260912-0006','ARUM','JENANGAN 02/01','','','','kasir','2026-09-12 15:26:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-12' 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-260912-0057','K','2026-09-12','15:26:45','kasir','PEMBELIAN UMUM','FB-260912-0006','14986500000','355000','14986145000');
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-00005707','X-00005707','AT MODEL ITALY VAR SLEP UB 8K','GR','---','A1D','BELI','BELI001','884000','2026-09-12','0.950','1','kasir','2026-09-12 15:27:28');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00005707','X-00005707');
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-260912-0007','F226170155131','DIN','1','BELI','BELI001','A1D', 'X-00005707', 'AT MODEL ITALY VAR SLEP UB 8K','0.950','0.950','100.00','1059000','884000','930526','1030000','1','884000','884000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.950',berat_beli_asli=berat_beli_asli+'0.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.950',berat_akhir_asli=berat_akhir_asli+'0.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-12' 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-260912-0007','2026-09-12','2026-09-12','15:27:27','DIN','---','0.950','884000','884000','884000','884000','884000','kasir','2026-09-12 15:27:28','FB-260912-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260912-0007','GUSTYA','','','','','kasir','2026-09-12 15:27:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-12' 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-260912-0058','K','2026-09-12','15:27:27','kasir','PEMBELIAN UMUM','FB-260912-0007','14986145000','884000','14985261000');
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-00005708','X-00005708','CC MODEL CAT SLEP BM 16 8K','GR','---','E1E','BELI','BELI001','569000','2026-09-12','0.600','1','kasir','2026-09-12 15:27:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00005708','X-00005708');
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-260912-0008','F226260126421','DIN','1','BELI','BELI001','E1E', 'X-00005708', 'CC MODEL CAT SLEP BM 16 8K','0.600','0.600','100.00','640000','569000','948333','1050000','1','569000','569000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.600',berat_beli_asli=berat_beli_asli+'0.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.600',berat_akhir_asli=berat_akhir_asli+'0.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-12' 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-260912-0008','2026-09-12','2026-09-12','15:27:48','DIN','---','0.600','569000','569000','569000','569000','569000','kasir','2026-09-12 15:27:48','FB-260912-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260912-0008','YUSTINA','TENGGER SLAHUNG','','','082124852636','kasir','2026-09-12 15:27:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-12' 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-260912-0059','K','2026-09-12','15:27:48','kasir','PEMBELIAN UMUM','FB-260912-0008','14985261000','569000','14984692000');
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-00005709','X-00005709','GL CAPELLA SLEP HW 8K','GR','---','F3E','BELI','BELI001','1195000','2026-09-12','1.260','1','kasir','2026-09-12 15:28:08');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00005709','X-00005709');
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-260912-0009','F226110347121','DIN','1','BELI','BELI001','F3E', 'X-00005709', 'GL CAPELLA SLEP HW 8K','1.260','1.260','100.00','1336000','1195000','948413','1050000','1','1195000','1195000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.260',berat_beli_asli=berat_beli_asli+'1.260',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.260',berat_akhir_asli=berat_akhir_asli+'1.260',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-12' 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-260912-0009','2026-09-12','2026-09-12','15:28:07','DIN','---','1.260','1195000','1195000','1195000','1195000','1195000','kasir','2026-09-12 15:28:08','FB-260912-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260912-0009','GUSTYA','SLAHUNG','','','082124852636','kasir','2026-09-12 15:28:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-12' 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-260912-0060','K','2026-09-12','15:28:07','kasir','PEMBELIAN UMUM','FB-260912-0009','14984692000','1195000','14983497000');
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 ('F226120333251','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZHBF-275-0','CC X MODEL MATA CM 14 8K ','','0.860','1','100.00','890000','0','0','15000','890000','0','0','0','890000','LUS','00420647','E2D','0','0','-','0','1030000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZHBF-275-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='E2D-ZHBF-275-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120333251','2026-09-12','0.860','2026-09-12','15:33:26','PLG0084902','890000','890000','0','890000','890000','kasir','2026-09-12 15:33:25','F22612033325');
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-09-12','F226120333251','2026-09-12','15:33:26','LUS','890000','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-260912-0061','D','2026-09-12','15:33:26','kasir','PENJUALAN','F226120333251','14983497000','890000','14984387000');
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 ('F226120334001','kasir','1',' MEF3 LT ','TOKO','SMBK-F','F3E-ZIAA-92-T','GL MODEL VERONA VAR LT 8K ','ol','1.520','1','100.00','1596000','0','0','15000','1612000','0','8000','0','1620000','LUS','T0083390','F3E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIAA-92-T' 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-09-12' AND kode_barang='F3E-ZIAA-92-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120334001','2026-09-12','1.520','2026-09-12','15:34:01','PLG0084903','1612000','1612000','8000','1620000','1620000','kasir','2026-09-12 15:34:00','F22612033400');
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-09-12','F226120334001','2026-09-12','15:34:01','LUS','1620000','8000');
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-260912-0062','D','2026-09-12','15:34:01','kasir','PENJUALAN','F226120334001','14984387000','1620000','14986007000');
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 ('F226120338001','kasir','1',' MEF1 LG D5','TOKO','SMBK-F','F1E-ZIAA-72-T','GL OVAL TINJU BOLA ARESO LG D56 8K ','','2.200','1','100.00','2310000','0','0','15000','2321000','0','0','0','2321000','NOV','T0083370','F1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZIAA-72-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.200',berat_jual_asli=berat_jual_asli+'2.200',stock_jual='1',berat_akhir=berat_akhir-'2.200',berat_akhir_asli=berat_akhir_asli-'2.200',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='F1E-ZIAA-72-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120338001','2026-09-12','2.200','2026-09-12','15:38:00','PLG0084904','2321000','2321000','0','2321000','2321000','kasir','2026-09-12 15:38:00','F22612033800');
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-09-12','F226120338001','2026-09-12','15:38:00','NOV','2321000','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-260912-0063','D','2026-09-12','15:38:00','kasir','PENJUALAN','F226120338001','14986007000','2321000','14988328000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120306091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120306091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120306091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120307001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120307001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120307001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120333251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120333251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120333251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120334001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120334001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120334001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120338001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120338001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120338001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260912-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260912-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260912-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260912-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260912-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260912-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260912-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260912-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260912-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260912-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260912-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260912-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260912-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260912-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260912-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260912-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260912-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260912-0009';
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 ('F226120343571','kasir','1',' MED2E LG C','TOKO','SMBK-D','D2E-ZHXH-4-T','LT HURUF MATA SLEP LG C 8K ','','0.560','1','100.00','591000','0','0','15000','591000','0','0','0','591000','NS','T0082123','D2E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZHXH-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-09-12' AND kode_barang='D2E-ZHXH-4-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226120343571','2026-09-12','0.560','2026-09-12','15:43:58','PLG0084905','591000','591000','0','591000','0','kasir','2026-09-12 15:43:57','F22612034357');
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-09-12','F226120343571','2026-09-12','15:43:58','NS','591000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260912-0003','2026-09-12','2026-09-12 15:43:57','PENJUALAN : F226120343571','098765432','BCA','591000','591000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260912-0004','D','2026-09-12','15:43:58','BCA','PENJUALAN','F226120343571','4805238888','591000','4805829888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('098765432','ANISA');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226120343571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226120343571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226120343571';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-13','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-13';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-12';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-12';
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-09-12' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-12';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-12';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-12';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-12';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-13' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-12' 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-260913-0001','D','2026-09-13','16:21:39','SYSTEM','SALDO AWAL','SALDO AWAL','0','14988328000','14988328000');
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-260913-0001','D','2026-09-13','16:21:39','BCA','SALDO AWAL','SALDO AWAL','0','4805829888','4805829888');
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-260913-0001','D','2026-09-13','16:21:39','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-260913-0001','D','2026-09-13','16:21:39','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260913-0001','D','2026-09-13','16:21:39','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
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-260913-0001','D','2026-09-13','16:21:39','','SALDO AWAL','SALDO AWAL','0','3346000','3346000');
UPDATE tp_system SET tgl_system='2026-09-13';