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 ('F225120826591','kasir','1',' TFF3 20K B','TOKO','TBK-F','F3TF-YJXB-140-T','GL TRIXIE MODEL PASIR VAR BG 17K ','OL','2.810','1','100.00','5170000','0','0','15000','5277000','0','20000','0','5297000','NS','T0073720','F3TF','0','0','-','0','1840000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TF-YJXB-140-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.810',berat_jual_asli=berat_jual_asli+'2.810',stock_jual='1',berat_akhir=berat_akhir-'2.810',berat_akhir_asli=berat_akhir_asli-'2.810',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='F3TF-YJXB-140-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225120826591','2025-11-12','2.810','2025-11-12','08:27:00','PLG0074743','5277000','5277000','20000','5297000','5297000','kasir','2025-11-12 08:26:59','F22512082659');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225120826591','2025-11-12','08:27:00','NS','5297000','20000');
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-251112-0002','D','2025-11-12','08:27:00','kasir','PENJUALAN','F225120826591','2676065000','5297000','2681362000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120826591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120826591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120826591';
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 ('F225120829161','kasir','1',' MFF3F X UB','TOKO','SMBK-F','F3F-YJBB-198-0','GL X JEDAR UB 8K ','OLH','1.720','1','100.00','1754000','0','0','15000','1823000','0','17000','0','1840000','TJ','00374261','F3F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YJBB-198-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.720',berat_jual_asli=berat_jual_asli+'1.720',stock_jual='1',berat_akhir=berat_akhir-'1.720',berat_akhir_asli=berat_akhir_asli-'1.720',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='F3F-YJBB-198-0' 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 ('F225120829161','2025-11-12','1.720','2025-11-12','08:29:16','PLG0074744','1823000','1823000','17000','1840000','1840000','kasir','2025-11-12 08:29:16','F22512082916');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225120829161','2025-11-12','08:29:16','TJ','1840000','17000');
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-251112-0003','D','2025-11-12','08:29:16','kasir','PENJUALAN','F225120829161','2681362000','1840000','2683202000');
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 ('F225120943211','kasir','1',' MEE2 HTM 1','TOKO','SMBK-E','E2E-YJXB-32-T','CC PIPA MODEL MATA HTM 17 8K ','','0.460','1','100.00','460000','0','0','15000','476000','0','0','0','476000','TIN','T0073612','E2E','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXB-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='E2E-YJXB-32-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 ('F225120943211','2025-11-12','0.460','2025-11-12','09:43:21','PLG0074745','476000','476000','0','476000','476000','kasir','2025-11-12 09:43:21','F22512094321');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225120943211','2025-11-12','09:43:21','TIN','476000','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-251112-0004','D','2025-11-12','09:43:21','kasir','PENJUALAN','F225120943211','2683202000','476000','2683678000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='476000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225120943211' 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 ('F225120943212','kasir',' 1',' MGF3G UB ','TOKO','SMBK-F','F3G-YJAE-57-T','GL RANTAI HOLLOW UB 8K ','','0.330','1','100.00','343000','0','0','15000','355000','0','0','0','355000','TIN','T0074106','F3G','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3G-YJAE-57-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.330',berat_jual_asli=berat_jual_asli+'0.330',stock_jual='1',berat_akhir=berat_akhir-'0.330',berat_akhir_asli=berat_akhir_asli-'0.330',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='F3G-YJAE-57-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 ('F225120943212','2025-11-12','0.330','2025-11-12','09:43:21','PLG0074746','355000','355000','0','355000','355000','kasir','2025-11-12 09:43:21','F22512094321');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225120943212','2025-11-12','09:43:21','TIN','355000','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-251112-0005','D','2025-11-12','09:43:21','kasir','PENJUALAN','F225120943212','2683678000','355000','2684033000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='355000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225120943212' 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 ('F225120946081','kasir','1',' MGE1 X UB ','TOKO','SMBK-E','E1G-YKXA-333-0','CC X RING POLOS UB 12 8K ','OL','0.320','1','100.00','333000','0','0','15000','349000','0','5000','0','354000','NS','00375904','E1G','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-YKXA-333-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='E1G-YKXA-333-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 ('F225120946081','2025-11-12','0.320','2025-11-12','09:46:09','PLG0074747','349000','349000','5000','354000','354000','kasir','2025-11-12 09:46:08','F22512094608');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225120946081','2025-11-12','09:46:09','NS','354000','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-251112-0006','D','2025-11-12','09:46:09','kasir','PENJUALAN','F225120946081','2684033000','354000','2684387000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='354000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225120946081' 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 ('F225120946082','kasir',' 1',' MGE1 HW 15','TOKO','SMBK-E','E1G-YKXA-2-T','CC LISTRING GELOMBANG SLEP HW 15 8K ','OL','0.380','1','100.00','395000','0','0','15000','414000','0','5000','0','419000','NS','T0074797','E1G','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-YKXA-2-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='2025-11-12' AND kode_barang='E1G-YKXA-2-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 ('F225120946082','2025-11-12','0.380','2025-11-12','09:46:09','PLG0074748','414000','414000','5000','419000','419000','kasir','2025-11-12 09:46:08','F22512094608');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225120946082','2025-11-12','09:46:09','NS','419000','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-251112-0007','D','2025-11-12','09:46:09','kasir','PENJUALAN','F225120946082','2684387000','419000','2684806000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='419000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225120946082' 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 ('F225120946381','kasir','1',' MEE2E CM 1','TOKO','SMBK-E','E2E-YJAH-41-T','CC MODEL MATA CM 11 8K ','OL','0.790','1','100.00','790000','0','0','15000','830000','0','5000','0','835000','NS','T0074254','E2E','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJAH-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.790',berat_jual_asli=berat_jual_asli+'0.790',stock_jual='1',berat_akhir=berat_akhir-'0.790',berat_akhir_asli=berat_akhir_asli-'0.790',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='E2E-YJAH-41-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 ('F225120946381','2025-11-12','0.790','2025-11-12','09:46:39','PLG0074749','830000','830000','5000','835000','835000','kasir','2025-11-12 09:46:38','F22512094638');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225120946381','2025-11-12','09:46:39','NS','835000','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-251112-0008','D','2025-11-12','09:46:39','kasir','PENJUALAN','F225120946381','2684806000','835000','2685641000');
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 ('F225120946571','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YJBC-85-0','CC X SOLITAIRE MATA CM 18 8K ','OL','1.100','1','100.00','1078000','0','0','15000','1145000','0','10000','0','1155000','NS','00374403','E2D','0','0','-','0','1015000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJBC-85-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='E2D-YJBC-85-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 ('F225120946571','2025-11-12','1.100','2025-11-12','09:46:57','PLG0074750','1145000','1145000','10000','1155000','1155000','kasir','2025-11-12 09:46:57','F22512094657');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225120946571','2025-11-12','09:46:57','NS','1155000','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-251112-0009','D','2025-11-12','09:46:57','kasir','PENJUALAN','F225120946571','2685641000','1155000','2686796000');
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 ('F225120958031','kasir','1',' TFF3 25K B','TOKO','TBK-F','F3TF-YJXF-121-T','GL KREPYAK MODEL PASIR VAR BG 17K ','','5.930','1','100.00','10911000','0','0','15000','11148000','0','25000','0','11173000','TJ','T0074019','F3TF','0','0','-','0','1840000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TF-YJXF-121-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.930',berat_jual_asli=berat_jual_asli+'5.930',stock_jual='1',berat_akhir=berat_akhir-'5.930',berat_akhir_asli=berat_akhir_asli-'5.930',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='F3TF-YJXF-121-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225120958031','2025-11-12','5.930','2025-11-12','09:58:03','PLG0074751','11148000','11148000','25000','11173000','11173000','kasir','2025-11-12 09:58:03','F22512095803');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225120958031','2025-11-12','09:58:03','TJ','11173000','25000');
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-251112-0010','D','2025-11-12','09:58:03','kasir','PENJUALAN','F225120958031','2686796000','11173000','2697969000');
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 ('F225121007021','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YJAC-306-0','CC X SOLITAIRE MATA CM 14 8K ','','1.150','1','100.00','1127000','0','0','15000','1167000','0','5000','0','1172000','RHM','00373036','E2D','0','0','-','0','1015000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJAC-306-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='E2D-YJAC-306-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 ('F225121007021','2025-11-12','1.150','2025-11-12','10:07:02','PLG0074752','1167000','1167000','5000','1172000','1172000','kasir','2025-11-12 10:07:02','F22512100702');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225121007021','2025-11-12','10:07:02','RHM','1172000','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-251112-0011','D','2025-11-12','10:07:02','kasir','PENJUALAN','F225121007021','2697969000','1172000','2699141000');
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 ('F225121007341','kasir','1',' MFB1 5K LG','TOKO','SMBK-B','B1F-YKXC-23-T','GW TOGE MODEL BONEKA CAT LG 8K ','OL','0.550','1','100.00','561000','0','0','15000','586000','0','5000','0','591000','TJ','T0074936','B1F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-YKXC-23-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='2025-11-12' AND kode_barang='B1F-YKXC-23-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 ('F225121007341','2025-11-12','0.550','2025-11-12','10:07:34','PLG0074753','586000','586000','5000','591000','0','kasir','2025-11-12 10:07:34','F22512100734');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225121007341','2025-11-12','10:07:34','TJ','591000','5000');
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-251112-0001','2025-11-12','2025-11-12 10:07:34','PENJUALAN : F225121007341','894798404','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-251112-0002','D','2025-11-12','10:07:34','BCA','PENJUALAN','F225121007341','4137068888','591000','4137659888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('894798404','HILDA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='591000' WHERE no_faktur_jual='F225121007341' 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 ('F225121008191','kasir','1',' MED1 CM ','TOKO','SMBK-D','D1E-YJXF-92-T','LT MODEL BUNGA VAR CM 8K ','OL','0.610','1','100.00','610000','0','0','15000','638000','0','5000','0','643000','TJ','T0073990','D1E','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJXF-92-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='D1E-YJXF-92-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 ('F225121008191','2025-11-12','0.610','2025-11-12','10:08:19','PLG0074754','638000','638000','5000','643000','0','kasir','2025-11-12 10:08:19','F22512100819');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225121008191','2025-11-12','10:08:19','TJ','643000','5000');
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-251112-0002','2025-11-12','2025-11-12 10:08:19','PENJUALAN : F225121008191','897202470924','BCA','643000','643000','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-251112-0003','D','2025-11-12','10:08:19','BCA','PENJUALAN','F225121008191','4137659888','643000','4138302888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('897202470924','HILDA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='643000' WHERE no_faktur_jual='F225121008191' 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 ('F225121155291','kasir','1',' MEB1 CM PE','TOKO','SMBK-B','B1E-YKXA-52-T','GW TUSUK MODEL HATI MATA CM PE 8K ','','0.730','1','100.00','730000','0','0','15000','756000','0','0','0','756000','NS','T0074847','B1E','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YKXA-52-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.730',berat_jual_asli=berat_jual_asli+'0.730',stock_jual='1',berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='B1E-YKXA-52-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 ('F225121155291','2025-11-12','0.730','2025-11-12','11:55:29','PLG0074755','756000','756000','0','756000','756000','kasir','2025-11-12 11:55:29','F22512115529');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225121155291','2025-11-12','11:55:29','NS','756000','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-251112-0012','D','2025-11-12','11:55:29','kasir','PENJUALAN','F225121155291','2699141000','756000','2699897000');
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 ('F225121213141','kasir','1',' TFF3 20K B','TOKO','TBK-F','F3TF-YJXB-140-T','GL TRIXIE MODEL PASIR VAR BG 17K ','OL','2.810','1','100.00','5170000','0','0','15000','5305000','0','20000','0','5325000','NS','T0073720','F3TF','0','0','-','0','1840000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TF-YJXB-140-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.810',berat_jual_asli=berat_jual_asli+'2.810',stock_jual='1',berat_akhir=berat_akhir-'2.810',berat_akhir_asli=berat_akhir_asli-'2.810',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='F3TF-YJXB-140-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225121213141','2025-11-12','2.810','2025-11-12','12:13:14','PLG0074756','5305000','5305000','20000','5325000','5325000','kasir','2025-11-12 12:13:14','F22512121314');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225121213141','2025-11-12','12:13:14','NS','5325000','20000');
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-251112-0014','D','2025-11-12','12:13:14','kasir','PENJUALAN','F225121213141','2694600000','5325000','2699925000');
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 ('F225121215031','kasir','1',' MDE2 X BM ','TOKO','SMBK-E','E2D-YIAC-349-0','CC X SOLITAIRE MATA BM 16 8K ','OL','1.700','1','100.00','1666000','0','0','15000','1775000','0','10000','0','1785000','NS','00369433','E2D','0','0','-','0','1015000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIAC-349-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.700',berat_jual_asli=berat_jual_asli+'1.700',stock_jual='1',berat_akhir=berat_akhir-'1.700',berat_akhir_asli=berat_akhir_asli-'1.700',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='E2D-YIAC-349-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 ('F225121215031','2025-11-12','1.700','2025-11-12','12:15:04','PLG0074757','1775000','1775000','10000','1785000','1785000','kasir','2025-11-12 12:15:03','F22512121503');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225121215031','2025-11-12','12:15:04','NS','1785000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251112-0015','D','2025-11-12','12:15:04','kasir','PENJUALAN','F225121215031','2699925000','1785000','2701710000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1785000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225121215031' 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 ('F225121215032','kasir',' 1',' MDE2 X BM ','TOKO','SMBK-E','E2D-YJBC-92-0','CC X SOLITAIRE MATA BM 18 8K ','OL','1.820','1','100.00','1784000','0','0','15000','1901000','0','10000','0','1911000','NS','00374410','E2D','0','0','-','0','1015000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJBC-92-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.820',berat_jual_asli=berat_jual_asli+'1.820',stock_jual='1',berat_akhir=berat_akhir-'1.820',berat_akhir_asli=berat_akhir_asli-'1.820',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='E2D-YJBC-92-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 ('F225121215032','2025-11-12','1.820','2025-11-12','12:15:04','PLG0074758','1901000','1901000','10000','1911000','1911000','kasir','2025-11-12 12:15:03','F22512121503');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225121215032','2025-11-12','12:15:04','NS','1911000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251112-0016','D','2025-11-12','12:15:04','kasir','PENJUALAN','F225121215032','2701710000','1911000','2703621000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1911000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225121215032' 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 ('F225121215033','kasir',' 1',' MEE2 X AY ','TOKO','SMBK-E','E2E-YKXD-51-0','CC X LISTERING MATA AY 10 8K ','OL','0.700','1','100.00','700000','0','0','15000','735000','0','5000','0','740000','NS','00376587','E2E','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YKXD-51-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='E2E-YKXD-51-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 ('F225121215033','2025-11-12','0.700','2025-11-12','12:15:04','PLG0074759','735000','735000','5000','740000','740000','kasir','2025-11-12 12:15:03','F22512121503');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225121215033','2025-11-12','12:15:04','NS','740000','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-251112-0017','D','2025-11-12','12:15:04','kasir','PENJUALAN','F225121215033','2703621000','740000','2704361000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='740000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225121215033' 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 ('F225121219001','kasir','1',' MEH1E HW 4','TOKO','SMBK-H','H1E-YJBD-110-T','KL RANTAI CD HW 42 8K ','OL','1.990','1','100.00','1990000','0','0','15000','2070000','0','10000','0','2080000','TJ','T0074460','H1E','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJBD-110-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.990',berat_jual_asli=berat_jual_asli+'1.990',stock_jual='1',berat_akhir=berat_akhir-'1.990',berat_akhir_asli=berat_akhir_asli-'1.990',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='H1E-YJBD-110-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 ('F225121219001','2025-11-12','1.990','2025-11-12','12:19:01','PLG0074760','2070000','2070000','10000','2080000','2080000','kasir','2025-11-12 12:19:00','F22512121900');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225121219001','2025-11-12','12:19:01','TJ','2080000','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-251112-0018','D','2025-11-12','12:19:01','kasir','PENJUALAN','F225121219001','2704361000','2080000','2706441000');
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 ('F225121223321','kasir','1',' MEF1 PM 60','TOKO','SMBK-F','F1E-YJBC-15-T','GL BANGKOK SLEP PM 60 8K ','','4.980','1','100.00','4980000','0','0','15000','5154000','0','0','0','5154000','RHM','T0074388','F1E','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YJBC-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.980',berat_jual_asli=berat_jual_asli+'4.980',stock_jual='1',berat_akhir=berat_akhir-'4.980',berat_akhir_asli=berat_akhir_asli-'4.980',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='F1E-YJBC-15-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 ('F225121223321','2025-11-12','4.980','2025-11-12','12:23:32','PLG0074761','5154000','5154000','0','5154000','5154000','kasir','2025-11-12 12:23:32','F22512122332');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225121223321','2025-11-12','12:23:32','RHM','5154000','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-251112-0019','D','2025-11-12','12:23:32','kasir','PENJUALAN','F225121223321','2706441000','5154000','2711595000');
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 ('F225121232281','kasir','1',' TEF3 X UB ','TOKO','TBK-F','F3TE-VIAI-105-T','GL X FANCY VAR UB ','OL','3.230','1','100.00','5879000','0','0','15000','6017000','0','23000','0','6040000','TJ','T0038107','F3TE','0','0','-','0','1820000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-VIAI-105-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.230',berat_jual_asli=berat_jual_asli+'3.230',stock_jual='1',berat_akhir=berat_akhir-'3.230',berat_akhir_asli=berat_akhir_asli-'3.230',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='F3TE-VIAI-105-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225121232281','2025-11-12','3.230','2025-11-12','12:32:29','PLG0074762','6017000','6017000','23000','6040000','6040000','kasir','2025-11-12 12:32:28','F22512123228');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225121232281','2025-11-12','12:32:29','TJ','6040000','23000');
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-251112-0020','D','2025-11-12','12:32:29','kasir','PENJUALAN','F225121232281','2711595000','6040000','2717635000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='6040000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225121232281' 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 ('F225121232282','kasir',' 1',' TEF3 X YT ','TOKO','TBK-F','F3TE-YFBF-97-T','GL X MODEL FANCY VAR YT 17K ','OL','2.800','1','100.00','5096000','0','0','15000','5216000','0','20000','0','5236000','TJ','T0070464','F3TE','0','0','-','0','1820000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YFBF-97-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.800',berat_jual_asli=berat_jual_asli+'2.800',stock_jual='1',berat_akhir=berat_akhir-'2.800',berat_akhir_asli=berat_akhir_asli-'2.800',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='F3TE-YFBF-97-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225121232282','2025-11-12','2.800','2025-11-12','12:32:29','PLG0074763','5216000','5216000','20000','5236000','5236000','kasir','2025-11-12 12:32:28','F22512123228');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225121232282','2025-11-12','12:32:29','TJ','5236000','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-251112-0021','D','2025-11-12','12:32:29','kasir','PENJUALAN','F225121232282','2717635000','5236000','2722871000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5236000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225121232282' 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 ('F225120109461','kasir','1',' MEF1 15K U','TOKO','SMBK-F','F1E-YIXH-60-T','GL BANGKOK TIMBUL SLEP VAR UB D56 8K ','OL','4.000','1','100.00','4000000','0','0','15000','4180000','0','20000','0','4200000','NS','T0073069','F1E','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YIXH-60-T' 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='2025-11-12' AND kode_barang='F1E-YIXH-60-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 ('F225120109461','2025-11-12','4.000','2025-11-12','13:09:47','PLG0074764','4180000','4180000','20000','4200000','4200000','kasir','2025-11-12 13:09:46','F22512010946');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225120109461','2025-11-12','13:09:47','NS','4200000','20000');
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-251112-0022','D','2025-11-12','13:09:47','kasir','PENJUALAN','F225120109461','2722871000','4200000','2727071000');
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 ('F225120111591','kasir','1',' MDA1D X LG','TOKO','SMBK-A','A1D-YIAE-32-0','AT X MODEL MATA VAR LG 8K ','OL TW','1.050','1','100.00','1029000','0','0','15000','1092000','0','11000','0','1103000','NS','00369483','A1D','0','0','-','0','1015000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YIAE-32-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='2025-11-12' AND kode_barang='A1D-YIAE-32-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 ('F225120111591','2025-11-12','1.050','2025-11-12','13:12:00','PLG0074765','1092000','1092000','11000','1103000','1103000','kasir','2025-11-12 13:11:59','F22512011159');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225120111591','2025-11-12','13:12:00','NS','1103000','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-251112-0023','D','2025-11-12','13:12:00','kasir','PENJUALAN','F225120111591','2727071000','1103000','2728174000');
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 ('F225120204201','kasir','1',' MFH1 UB 40','TOKO','SMBK-H','H1F-YIXD-17-T','KL MILANO UB 40CM 8K ','OL','2.100','1','100.00','2142000','0','0','15000','2226000','0','11000','0','2237000','RTA','T0072869','H1F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YIXD-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='H1F-YIXD-17-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 ('F225120204201','2025-11-12','2.100','2025-11-12','14:04:20','PLG0074766','2226000','2226000','11000','2237000','0','kasir','2025-11-12 14:04:20','F22512020420');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225120204201','2025-11-12','14:04:20','RTA','2237000','11000');
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-251112-0003','2025-11-12','2025-11-12 14:04:20','PENJUALAN : F225120204201','898787766765','BCA','2237000','2237000','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-251112-0004','D','2025-11-12','14:04:20','BCA','PENJUALAN','F225120204201','4138302888','2237000','4140539888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('898787766765','ENES');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2237000' WHERE no_faktur_jual='F225120204201' LIMIT 1;
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-00004820','X-00004820','LT MODEL HATI KRAWANG VAR UB 8K','GR','---','D1E','BELI','BELI001','1011000','2025-11-12','1.350','1','kasir','2025-11-12 14:07:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1E','X-00004820','X-00004820');
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-251112-0001','F225120229331','RHM','1','BELI','BELI001','D1E', 'X-00004820', 'LT MODEL HATI KRAWANG VAR UB 8K','1.350','1.350','100.00','1123000','1011000','748889','1035000','1','1011000','1011000','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 ='2025-11-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1E' 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-251112-0001','2025-11-12','2025-11-12','14:07:47','RHM','---','1.350','1011000','1011000','1011000','1011000','1011000','kasir','2025-11-12 14:07:47','FB-251112-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251112-0001','MARTINI','CRABAK SLAHUNG','','','082141783177','kasir','2025-11-12 14:07:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251112-0024','K','2025-11-12','14:07:47','kasir','PEMBELIAN UMUM','FB-251112-0001','2728174000','1011000','2727163000');
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-00004821','X-00004821','CC X MODEL MATA CM 16 8K','GR','---','E2E','BELI','BELI001','678000','2025-11-12','0.930','1','kasir','2025-11-12 14:08:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00004821','X-00004821');
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-251112-0002','F224060107521','NS','1','BELI','BELI001','E2E', 'X-00004821', 'CC X MODEL MATA CM 16 8K','1.080','0.930','100.00','673000','678000','729032','1035000','1','678000','678000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.930',berat_beli_asli=berat_beli_asli+'0.930',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.930',berat_akhir_asli=berat_akhir_asli+'0.930',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251112-0002','2025-11-12','2025-11-12','14:08:50','NS','---','0.930','678000','678000','678000','678000','678000','kasir','2025-11-12 14:08:50','FB-251112-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251112-0002','RUYATI','','','','','kasir','2025-11-12 14:08:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251112-0025','K','2025-11-12','14:08:50','kasir','PEMBELIAN UMUM','FB-251112-0002','2727163000','678000','2726485000');
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-00004822','X-00004822','KL X SANTA MATA VAR UB 42 9K','GR','---','H3J','BELI','BELI001','1909000','2025-11-12','2.300','1','kasir','2025-11-12 14:08:51');
DELETE FROM tp_barang WHERE kode_dept = 'X-H3J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H3J','X-00004822','X-00004822');
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-251112-0003','F224120126451','NS','2','BELI','BELI001','H3J', 'X-00004822', 'KL X SANTA MATA VAR UB 42 9K','2.460','2.300','100.00','1626000','1909000','830000','1135000','1','1909000','1909000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.300',berat_beli_asli=berat_beli_asli+'2.300',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.300',berat_akhir_asli=berat_akhir_asli+'2.300',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H3J' 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-251112-0003','2025-11-12','2025-11-12','14:08:50','NS','---','2.300','1909000','1909000','1909000','1909000','1909000','kasir','2025-11-12 14:08:51','FB-251112-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251112-0003','WINDI AGUSTINA','','','','','kasir','2025-11-12 14:08:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251112-0026','K','2025-11-12','14:08:50','kasir','PEMBELIAN UMUM','FB-251112-0003','2726485000','1909000','2724576000');
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-00004823','X-00004823','CC MODEL MATA LG 9','GR','---','E2TE','BELI','BELI001','1116000','2025-11-12','0.750','1','kasir','2025-11-12 14:09:44');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00004823','X-00004823');
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-251112-0004','F224240148551','NS','1','BELI','BELI001','E2TE', 'X-00004823', 'CC MODEL MATA LG 9','0.850','0.750','100.00','735000','1116000','1488000','1820000','1','1116000','1116000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.750',berat_beli_asli=berat_beli_asli+'0.750',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.750',berat_akhir_asli=berat_akhir_asli+'0.750',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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-251112-0004','2025-11-12','2025-11-12','14:09:44','NS','---','0.750','1116000','1116000','1116000','1116000','1116000','kasir','2025-11-12 14:09:44','FB-251112-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251112-0004','WINDI AGUSTINA','SUMOROTO','','','','kasir','2025-11-12 14:09:44');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251112-0027','K','2025-11-12','14:09:44','kasir','PEMBELIAN UMUM','FB-251112-0004','2724576000','1116000','2723460000');
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-00004824','X-00004824','CC MODEL SOLITAIRE LOVE MATA CM 10','GR','---','E2TE','BELI','BELI001','1564000','2025-11-12','1.050','1','kasir','2025-11-12 14:09:44');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00004824','X-00004824');
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-251112-0005','F224240149431','NS','2','BELI','BELI001','E2TE', 'X-00004824', 'CC MODEL SOLITAIRE LOVE MATA CM 10','1.200','1.050','100.00','1028000','1564000','1489524','1820000','1','1564000','1564000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.050',berat_beli_asli=berat_beli_asli+'1.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.050',berat_akhir_asli=berat_akhir_asli+'1.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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-251112-0005','2025-11-12','2025-11-12','14:09:44','NS','---','1.050','1564000','1564000','1564000','1564000','1564000','kasir','2025-11-12 14:09:44','FB-251112-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251112-0005','WINDI AGUSTINA','SUMOROTO','','','','kasir','2025-11-12 14:09:44');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251112-0028','K','2025-11-12','14:09:44','kasir','PEMBELIAN UMUM','FB-251112-0005','2723460000','1564000','2721896000');
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 ('F225120210491','kasir','1',' MEF1 X UB ','TOKO','SMBK-F','F1E-YFXI-12-0','GL X OVAL C GELOMBANG UB 56 8K ','','3.730','1','100.00','3730000','0','0','15000','3861000','0','0','0','3861000','TIN','00356757','F1E','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YFXI-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.730',berat_jual_asli=berat_jual_asli+'3.730',stock_jual='1',berat_akhir=berat_akhir-'3.730',berat_akhir_asli=berat_akhir_asli-'3.730',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='F1E-YFXI-12-0' 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 ('F225120210491','2025-11-12','3.730','2025-11-12','14:10:49','PLG0074767','3861000','3861000','0','3861000','3861000','kasir','2025-11-12 14:10:49','F22512021049');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225120210491','2025-11-12','14:10:49','TIN','3861000','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-251112-0029','D','2025-11-12','14:10:49','kasir','PENJUALAN','F225120210491','2721896000','3861000','2725757000');
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-00004825','X-00004825','CC MODEL KUPU MATA VAR LG 13 17K','GR','---','E2TE','BELI','BELI001','908000','2025-11-12','0.610','1','kasir','2025-11-12 14:13:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00004825','X-00004825');
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-251112-0006','F225221056362','NS','1','BELI','BELI001','E2TE', 'X-00004825', 'CC MODEL KUPU MATA VAR LG 13 17K','0.710','0.610','100.00','860000','908000','1488525','1820000','1','908000','908000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.610',berat_beli_asli=berat_beli_asli+'0.610',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.610',berat_akhir_asli=berat_akhir_asli+'0.610',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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-251112-0006','2025-11-12','2025-11-12','14:13:47','NS','---','0.610','908000','908000','908000','908000','908000','kasir','2025-11-12 14:13:47','FB-251112-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251112-0006','WINDI AGUSTINA','PONOROGO','','','','kasir','2025-11-12 14:13:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251112-0030','K','2025-11-12','14:13:47','kasir','PEMBELIAN UMUM','FB-251112-0006','2725757000','908000','2724849000');
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-00004826','X-00004826','CC MODEL KUPU MATA VAR UB 12 17K','GR','---','E2TE','BELI','BELI001','1028000','2025-11-12','0.690','1','kasir','2025-11-12 14:13:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00004826','X-00004826');
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-251112-0007','F225221056361','NS','2','BELI','BELI001','E2TE', 'X-00004826', 'CC MODEL KUPU MATA VAR UB 12 17K','0.740','0.690','100.00','896000','1028000','1489855','1820000','1','1028000','1028000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.690',berat_beli_asli=berat_beli_asli+'0.690',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.690',berat_akhir_asli=berat_akhir_asli+'0.690',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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-251112-0007','2025-11-12','2025-11-12','14:13:47','NS','---','0.690','1028000','1028000','1028000','1028000','1028000','kasir','2025-11-12 14:13:47','FB-251112-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251112-0007','WINDI AGUSTINA','PONOROGO','','','','kasir','2025-11-12 14:13:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251112-0031','K','2025-11-12','14:13:47','kasir','PEMBELIAN UMUM','FB-251112-0007','2724849000','1028000','2723821000');
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 ('F225120225531','kasir','1',' TDE2 X CM ','TOKO','TBK-E','E2TD-YDBC-69-T','CC X MODEL AUREL MATA CM 12 17K ','OL','0.930','1','100.00','1674000','0','0','15000','1739000','0','7000','0','1746000','TJ','T0068883','E2TD','0','0','-','0','1800000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YDBC-69-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='2025-11-12' AND kode_barang='E2TD-YDBC-69-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 ('F225120225531','2025-11-12','0.930','2025-11-12','14:25:53','PLG0074768','1739000','1739000','7000','1746000','1746000','kasir','2025-11-12 14:25:53','F22512022553');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225120225531','2025-11-12','14:25:53','TJ','1746000','7000');
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-251112-0032','D','2025-11-12','14:25:53','kasir','PENJUALAN','F225120225531','2723821000','1746000','2725567000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1746000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225120225531' 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 ('F225120225532','kasir',' 1',' TDE1 5K CM','TOKO','TBK-E','E1TD-YIXD-33-T','CC MODEL KUPU CAT VAR CM 12 8K ','OL','0.960','1','100.00','1728000','0','0','15000','1795000','0','7000','0','1802000','TJ','T0072885','E1TD','0','0','-','0','1800000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YIXD-33-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='2025-11-12' AND kode_barang='E1TD-YIXD-33-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 ('F225120225532','2025-11-12','0.960','2025-11-12','14:25:53','PLG0074769','1795000','1795000','7000','1802000','1802000','kasir','2025-11-12 14:25:53','F22512022553');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225120225532','2025-11-12','14:25:53','TJ','1802000','7000');
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-251112-0033','D','2025-11-12','14:25:53','kasir','PENJUALAN','F225120225532','2725567000','1802000','2727369000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1802000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225120225532' 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 ('F225120229081','kasir','1',' MDE2 X MJ ','TOKO','SMBK-E','E2D-YKAA-305-0','CC X MODEL MATA MJ 16 8K ','OL','0.830','1','100.00','842000','0','0','15000','867000','0','5000','0','872000','RTA','00377271','E2D','0','0','-','0','1015000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YKAA-305-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.830',berat_jual_asli=berat_jual_asli+'0.830',stock_jual='1',berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='E2D-YKAA-305-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 ('F225120229081','2025-11-12','0.830','2025-11-12','14:29:08','PLG0074770','867000','867000','5000','872000','0','kasir','2025-11-12 14:29:08','F22512022908');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225120229081','2025-11-12','14:29:08','RTA','872000','5000');
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-251112-0004','2025-11-12','2025-11-12 14:29:08','PENJUALAN : F225120229081','89887767667','BCA','872000','872000','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-251112-0005','D','2025-11-12','14:29:08','BCA','PENJUALAN','F225120229081','4140539888','872000','4141411888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('89887767667','INTAN');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='872000' WHERE no_faktur_jual='F225120229081' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120109461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120109461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120109461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120111591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120111591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120111591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120204201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120204201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120204201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120210491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120210491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120210491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120225531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120225531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120225531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120225532' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120225532' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120225532';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120229081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120229081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120229081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120829161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120829161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120829161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120943211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120943211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120943211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120943212' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120943212' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120943212';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120946081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120946081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120946081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120946082' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120946082' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120946082';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120946381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120946381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120946381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120946571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120946571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120946571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120958031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120958031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120958031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121007021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121007021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121007021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121007341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121007341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121007341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121008191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121008191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121008191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121155291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121155291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121155291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121213141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121213141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121213141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121215031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121215031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121215031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121215032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121215032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121215032';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121215033' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121215033' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121215033';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121219001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121219001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121219001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121223321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121223321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121223321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121232281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121232281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121232281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121232282' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121232282' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121232282';
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 ('F225120244011','kasir','1',' MEE2 5K LG','TOKO','SMBK-E','E2E-YJBI-92-T','CC MODEL MATA VAR LG 14 8K ','OL','0.480','1','100.00','480000','0','0','15000','497000','0','5000','0','502000','NS','T0074652','E2E','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJBI-92-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='E2E-YJBI-92-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 ('F225120244011','2025-11-12','0.480','2025-11-12','14:44:02','PLG0074771','497000','497000','5000','502000','502000','kasir','2025-11-12 14:44:01','F22512024401');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225120244011','2025-11-12','14:44:02','NS','502000','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-251112-0034','D','2025-11-12','14:44:02','kasir','PENJUALAN','F225120244011','2727369000','502000','2727871000');
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 ('F225120247571','kasir','1',' TGD1 LG ','TOKO','TBK-D','D1TG-YJXF-123-T','LT SLOBOK BOLA ARESO LG 17K ','','0.300','1','100.00','558000','0','0','15000','573000','0','7000','0','580000','TJ','T0074021','D1TG','0','0','-','0','1860000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1TG-YJXF-123-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='D1TG-YJXF-123-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225120247571','2025-11-12','0.300','2025-11-12','14:47:58','PLG0074772','573000','573000','7000','580000','580000','kasir','2025-11-12 14:47:57','F22512024757');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F225120247571','2025-11-12','14:47:58','TJ','580000','7000');
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-251112-0035','D','2025-11-12','14:47:58','kasir','PENJUALAN','F225120247571','2727871000','580000','2728451000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120244011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120244011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120244011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120247571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120247571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120247571';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251112-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251112-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251112-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251112-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251112-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251112-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251112-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251112-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251112-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251112-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251112-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251112-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251112-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251112-0007';
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-00004827','X-00004827','GL SANTA SERUT INFINITY SLEP UB','GR','---','F3TG','BELI','BELI001','3054000','2025-11-12','2.050','1','kasir','2025-11-12 15:57:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3TG';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3TG','X-00004827','X-00004827');
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-251112-0008','F222241125591','RTA','1','BELI','BELI001','F3TG', 'X-00004827', 'GL SANTA SERUT INFINITY SLEP UB','2.090','2.050','100.00','1527000','3054000','1489756','1860000','1','3054000','3054000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.050',berat_beli_asli=berat_beli_asli+'2.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.050',berat_akhir_asli=berat_akhir_asli+'2.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3TG' 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-251112-0008','2025-11-12','2025-11-12','15:57:09','RTA','---','2.050','3054000','3054000','3054000','3054000','3054000','kasir','2025-11-12 15:57:10','FB-251112-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251112-0008','VN','HK','','','','kasir','2025-11-12 15:57:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251112-0036','K','2025-11-12','15:57:09','kasir','PEMBELIAN UMUM','FB-251112-0008','2728451000','3054000','2725397000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251112-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251112-0008';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-13','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-13';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-12';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-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='2025-11-12' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-12';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-12';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-12';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-12';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-13' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-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-251113-0001','D','2025-11-13','16:02:10','SYSTEM','SALDO AWAL','SALDO AWAL','0','2725397000','2725397000');
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-251113-0001','D','2025-11-13','16:02:10','BCA','SALDO AWAL','SALDO AWAL','0','4141411888','4141411888');
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-251113-0001','D','2025-11-13','16:02:10','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
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-251113-0001','D','2025-11-13','16:02:10','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-251113-0001','D','2025-11-13','16:02:10','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-251113-0001','D','2025-11-13','16:02:10','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2025-11-13';