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 ('F225210927101','kasir','1',' TDE1 X YS ','TOKO','TBK-E','E1TD-YFBF-69-T','CC X VELG KACA YS 11 17K ','','1.030','1','100.00','1880000','0','0','15000','1880000','0','0','0','1880000','RTA','T0070436','E1TD','0','0','-','0','1825000');
UPDATE tm_barang SET tgl_last_jual='2025-11-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YFBF-69-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2025-11-21' AND kode_barang='E1TD-YFBF-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 ('F225210927101','2025-11-21','1.030','2025-11-21','09:27:10','PLG0074934','1880000','1880000','0','1880000','1880000','kasir','2025-11-21 09:27:10','F22521092710');
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-21','F225210927101','2025-11-21','09:27:10','RTA','1880000','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-251121-0002','D','2025-11-21','09:27:10','kasir','PENJUALAN','F225210927101','2919131000','1880000','2921011000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225210927101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225210927101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225210927101';
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 ('F225210934451','kasir','1',' MFF3 UB ','TOKO','SMBK-F','F3F-YKAI-10-T','GL KAKI JEDAR UB 8K ','OL','0.520','1','100.00','546000','0','0','15000','549000','0','5000','0','554000','RTA','T0075111','F3F','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2025-11-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YKAI-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-11-21' AND kode_barang='F3F-YKAI-10-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 ('F225210934451','2025-11-21','0.520','2025-11-21','09:34:45','PLG0074935','549000','549000','5000','554000','554000','kasir','2025-11-21 09:34:45','F22521093445');
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-21','F225210934451','2025-11-21','09:34:45','RTA','554000','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-251121-0003','D','2025-11-21','09:34:45','kasir','PENJUALAN','F225210934451','2921011000','554000','2921565000');
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 ('F225210950001','kasir','1',' TED2 LG I ','TOKO','TBK-D','D2TE-VIAG-30-T','LT HURUF MATA LG I ','OL','1.150','1','100.00','2122000','0','0','15000','2125000','0','8000','0','2133000','NS','T0037956','D2TE','0','0','-','0','1845000');
UPDATE tm_barang SET tgl_last_jual='2025-11-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2TE-VIAG-30-T' 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-21' AND kode_barang='D2TE-VIAG-30-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 ('F225210950001','2025-11-21','1.150','2025-11-21','09:50:00','PLG0074936','2125000','2125000','8000','2133000','2133000','kasir','2025-11-21 09:50:00','F22521095000');
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-21','F225210950001','2025-11-21','09:50:00','NS','2133000','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-251121-0004','D','2025-11-21','09:50:00','kasir','PENJUALAN','F225210950001','2921565000','2133000','2923698000');
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 ('F225211005551','kasir','1',' MDE1 CM 18','TOKO','SMBK-E','E1D-YJXA-75-T','CC MODEL BUNGA VAR CM 18 8K ','','1.600','1','100.00','1616000','0','0','15000','1608000','0','0','0','1608000','RTA','T0073567','E1D','0','0','-','1','995000');
UPDATE tm_barang SET tgl_last_jual='2025-11-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJXA-75-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.600',berat_jual_asli=berat_jual_asli+'1.600',stock_jual='1',berat_akhir=berat_akhir-'1.600',berat_akhir_asli=berat_akhir_asli-'1.600',stock_akhir='0' WHERE tanggal='2025-11-21' AND kode_barang='E1D-YJXA-75-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 ('F225211005551','2025-11-21','1.600','2025-11-21','10:05:56','PLG0074937','1608000','1608000','0','1608000','1608000','kasir','2025-11-21 10:05:55','F22521100555');
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-21','F225211005551','2025-11-21','10:05:56','RTA','1608000','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-251121-0005','D','2025-11-21','10:05:56','kasir','PENJUALAN','F225211005551','2923698000','1608000','2925306000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1608000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225211005551' 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 ('F225211005552','kasir',' 1',' MDE2 X PM ','TOKO','SMBK-E','E2D-YEAE-281-0','CC X MODEL MATA PM 16 8K ','','1.500','1','100.00','1515000','0','0','15000','1508000','0','0','0','1508000','RTA','00354053','E2D','0','0','-','1','995000');
UPDATE tm_barang SET tgl_last_jual='2025-11-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YEAE-281-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2025-11-21' AND kode_barang='E2D-YEAE-281-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 ('F225211005552','2025-11-21','1.500','2025-11-21','10:05:56','PLG0074938','1508000','1508000','0','1508000','1508000','kasir','2025-11-21 10:05:55','F22521100555');
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-21','F225211005552','2025-11-21','10:05:56','RTA','1508000','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-251121-0006','D','2025-11-21','10:05:56','kasir','PENJUALAN','F225211005552','2925306000','1508000','2926814000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1508000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225211005552' 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 ('F225211117511','kasir','1',' MEF3 YT ','TOKO','SMBK-F','F3E-YKAG-32-T','GL SANTA SERUT MODEL DAUN VAR YT 8K ','OL','1.960','1','100.00','2019000','0','0','15000','2020000','0','10000','0','2030000','NS','T0075035','F3E','0','0','-','0','1030000');
UPDATE tm_barang SET tgl_last_jual='2025-11-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKAG-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.960',berat_jual_asli=berat_jual_asli+'1.960',stock_jual='1',berat_akhir=berat_akhir-'1.960',berat_akhir_asli=berat_akhir_asli-'1.960',stock_akhir='0' WHERE tanggal='2025-11-21' AND kode_barang='F3E-YKAG-32-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 ('F225211117511','2025-11-21','1.960','2025-11-21','11:17:51','PLG0074939','2020000','2020000','10000','2030000','2030000','kasir','2025-11-21 11:17:51','F22521111751');
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-21','F225211117511','2025-11-21','11:17:51','NS','2030000','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-251121-0007','D','2025-11-21','11:17:51','kasir','PENJUALAN','F225211117511','2926814000','2030000','2928844000');
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 ('F225211129291','kasir','1',' MFE1 X AY ','TOKO','SMBK-E','E1F-YJXB-170-0','CC X RING POLOS AY 12 8K ','OL','0.450','1','100.00','472000','0','0','15000','475000','0','5000','0','480000','TJ','00371754','E1F','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2025-11-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-YJXB-170-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2025-11-21' AND kode_barang='E1F-YJXB-170-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 ('F225211129291','2025-11-21','0.450','2025-11-21','11:29:30','PLG0074940','475000','475000','5000','480000','480000','kasir','2025-11-21 11:29:29','F22521112929');
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-21','F225211129291','2025-11-21','11:29:30','TJ','480000','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-251121-0008','D','2025-11-21','11:29:30','kasir','PENJUALAN','F225211129291','2928844000','480000','2929324000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='480000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225211129291' 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 ('F225211129292','kasir',' 1',' MEE2 HTM 1','TOKO','SMBK-E','E2E-YJXB-27-T','CC PIPA MODEL MATA HTM 13 8K ','OL','0.530','1','100.00','546000','0','0','15000','549000','0','5000','0','554000','TJ','T0073607','E2E','0','0','-','0','1030000');
UPDATE tm_barang SET tgl_last_jual='2025-11-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXB-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2025-11-21' AND kode_barang='E2E-YJXB-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 ('F225211129292','2025-11-21','0.530','2025-11-21','11:29:30','PLG0074941','549000','549000','5000','554000','554000','kasir','2025-11-21 11:29:29','F22521112929');
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-21','F225211129292','2025-11-21','11:29:30','TJ','554000','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-251121-0009','D','2025-11-21','11:29:30','kasir','PENJUALAN','F225211129292','2929324000','554000','2929878000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='554000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225211129292' 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 ('F225211130241','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-YKBX-54-T','GL MODEL FLIK HW 8K ','OL','1.310','1','100.00','1349000','0','0','15000','1349000','0','7000','0','1356000','TJ','T0075227','F3E','0','0','-','0','1030000');
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 ('F225211131011','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-YKBX-54-T','GL MODEL FLIK HW 8K ','OL','1.310','1','100.00','1349000','0','0','15000','1349000','0','7000','0','1356000','TJ','T0075227','F3E','0','0','-','0','1030000');
UPDATE tm_barang SET tgl_last_jual='2025-11-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKBX-54-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.310',berat_jual_asli=berat_jual_asli+'1.310',stock_jual='1',berat_akhir=berat_akhir-'1.310',berat_akhir_asli=berat_akhir_asli-'1.310',stock_akhir='0' WHERE tanggal='2025-11-21' AND kode_barang='F3E-YKBX-54-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 ('F225211131011','2025-11-21','1.310','2025-11-21','11:31:01','PLG0074943','1349000','1349000','7000','1356000','1356000','kasir','2025-11-21 11:31:01','F22521113101');
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-21','F225211131011','2025-11-21','11:31:01','TJ','1356000','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-251121-0010','D','2025-11-21','11:31:01','kasir','PENJUALAN','F225211131011','2929878000','1356000','2931234000');
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 ('F225210113331','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-YKXC-18-T','AT TINDIK BABY LG 8K ','','0.520','1','100.00','536000','0','0','15000','529000','0','0','0','529000','RTA','T0074931','A1E','0','0','-','1','1030000');
UPDATE tm_barang SET tgl_last_jual='2025-11-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YKXC-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-11-21' AND kode_barang='A1E-YKXC-18-T' 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 ('F225210113331','2025-11-21','0.520','2025-11-21','13:13:34','PLG0074944','529000','529000','0','529000','0','kasir','2025-11-21 13:13:33','F22521011333');
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-21','F225210113331','2025-11-21','13:13:34','RTA','529000','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-251121-0001','2025-11-21','2025-11-21 13:13:33','PENJUALAN : F225210113331','8787676556','BCA','529000','529000','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-251121-0002','D','2025-11-21','13:13:34','BCA','PENJUALAN','F225210113331','4153319888','529000','4153848888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('8787676556','RATIFAH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='529000' WHERE no_faktur_jual='F225210113331' 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 ('F225210114331','kasir','1',' MEH1 UB 34','TOKO','SMBK-H','H1E-YHBX-196-0','KL GUCCI ANAK UB 34 8K ','','1.070','1','100.00','1102000','0','0','15000','1088000','0','0','0','1088000','RTA','00366474','H1E','0','0','-','1','1030000');
UPDATE tm_barang SET tgl_last_jual='2025-11-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YHBX-196-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2025-11-21' AND kode_barang='H1E-YHBX-196-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 ('F225210114331','2025-11-21','1.070','2025-11-21','13:14:33','PLG0074945','1088000','1088000','0','1088000','0','kasir','2025-11-21 13:14:33','F22521011433');
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-21','F225210114331','2025-11-21','13:14:33','RTA','1088000','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-251121-0002','2025-11-21','2025-11-21 13:14:33','PENJUALAN : F225210114331','898876767','BCA','1088000','1088000','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-251121-0003','D','2025-11-21','13:14:33','BCA','PENJUALAN','F225210114331','4153848888','1088000','4154936888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('898876767','RATIFAH');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225210114331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225210114331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225210114331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225210934451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225210934451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225210934451';
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 ('F225210117271','kasir','1',' MFD1 5K LG','TOKO','SMBK-D','D1F-YHBG-53-T','LT MODEL BONEKA CAT VAR LG 8K ','','0.400','1','100.00','420000','0','0','15000','415000','0','0','0','415000','RTA','T0072645','D1F','0','0','-','1','1050000');
UPDATE tm_barang SET tgl_last_jual='2025-11-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YHBG-53-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='2025-11-21' AND kode_barang='D1F-YHBG-53-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 ('F225210117271','2025-11-21','0.400','2025-11-21','13:17:28','PLG0074946','415000','415000','0','415000','0','kasir','2025-11-21 13:17:27','F22521011727');
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-21','F225210117271','2025-11-21','13:17:28','RTA','415000','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-251121-0003','2025-11-21','2025-11-21 13:17:27','PENJUALAN : F225210117271','89898787766765','BCA','415000','415000','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-251121-0004','D','2025-11-21','13:17:28','BCA','PENJUALAN','F225210117271','4154936888','415000','4155351888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('89898787766765','RATIFAH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='415000' WHERE no_faktur_jual='F225210117271' 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 ('F225210128231','kasir','1',' MEE1 LG 19','TOKO','SMBK-E','E1E-YKBX-15-T','CC MODEL DAUN VAR LG 19 8K ','','0.520','1','100.00','536000','0','0','15000','529000','0','0','0','529000','TIN','T0075188','E1E','0','0','-','1','1030000');
UPDATE tm_barang SET tgl_last_jual='2025-11-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YKBX-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-11-21' AND kode_barang='E1E-YKBX-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 ('F225210128231','2025-11-21','0.520','2025-11-21','13:28:24','PLG0074947','529000','529000','0','529000','529000','kasir','2025-11-21 13:28:23','F22521012823');
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-21','F225210128231','2025-11-21','13:28:24','TIN','529000','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-251121-0011','D','2025-11-21','13:28:24','kasir','PENJUALAN','F225210128231','2931234000','529000','2931763000');
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 ('F225210149161','kasir','1',' MEF1 10K Y','TOKO','SMBK-F','F1E-YJXB-14-T','GL ANAK OSROT BONEKA CAT YT 8K ','OL','1.450','1','100.00','1493000','0','0','15000','1491000','0','10000','0','1501000','TJ','T0073594','F1E','0','0','-','1','1030000');
UPDATE tm_barang SET tgl_last_jual='2025-11-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YJXB-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.450',berat_jual_asli=berat_jual_asli+'1.450',stock_jual='1',berat_akhir=berat_akhir-'1.450',berat_akhir_asli=berat_akhir_asli-'1.450',stock_akhir='0' WHERE tanggal='2025-11-21' AND kode_barang='F1E-YJXB-14-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 ('F225210149161','2025-11-21','1.450','2025-11-21','13:49:16','PLG0074948','1491000','1491000','10000','1501000','1501000','kasir','2025-11-21 13:49:16','F22521014916');
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-21','F225210149161','2025-11-21','13:49:16','TJ','1501000','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-251121-0012','D','2025-11-21','13:49:16','kasir','PENJUALAN','F225210149161','2931763000','1501000','2933264000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1501000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225210149161' 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 ('F225210149162','kasir',' 1',' MEF1 10K Y','TOKO','SMBK-F','F1E-YJXB-10-T','GL ANAK OSROT BONEKA CAT YT 8K ','OL','1.430','1','100.00','1473000','0','0','15000','1470000','0','10000','0','1480000','TJ','T0073590','F1E','0','0','-','1','1030000');
UPDATE tm_barang SET tgl_last_jual='2025-11-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YJXB-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.430',berat_jual_asli=berat_jual_asli+'1.430',stock_jual='1',berat_akhir=berat_akhir-'1.430',berat_akhir_asli=berat_akhir_asli-'1.430',stock_akhir='0' WHERE tanggal='2025-11-21' AND kode_barang='F1E-YJXB-10-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 ('F225210149162','2025-11-21','1.430','2025-11-21','13:49:16','PLG0074949','1470000','1470000','10000','1480000','1480000','kasir','2025-11-21 13:49:16','F22521014916');
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-21','F225210149162','2025-11-21','13:49:16','TJ','1480000','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-251121-0013','D','2025-11-21','13:49:16','kasir','PENJUALAN','F225210149162','2933264000','1480000','2934744000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1480000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225210149162' 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 ('F225210149163','kasir',' 1',' MEF1 LT 56','TOKO','SMBK-F','F1E-YJAE-32-T','GL OVAL DAUN SLEP LT 56 8K ','OL','4.250','1','100.00','4377000','0','0','15000','4379000','0','21000','0','4400000','TJ','T0074081','F1E','0','0','-','0','1030000');
UPDATE tm_barang SET tgl_last_jual='2025-11-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YJAE-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.250',berat_jual_asli=berat_jual_asli+'4.250',stock_jual='1',berat_akhir=berat_akhir-'4.250',berat_akhir_asli=berat_akhir_asli-'4.250',stock_akhir='0' WHERE tanggal='2025-11-21' AND kode_barang='F1E-YJAE-32-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 ('F225210149163','2025-11-21','4.250','2025-11-21','13:49:16','PLG0074950','4379000','4379000','21000','4400000','4400000','kasir','2025-11-21 13:49:16','F22521014916');
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-21','F225210149163','2025-11-21','13:49:16','TJ','4400000','21000');
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-251121-0014','D','2025-11-21','13:49:16','kasir','PENJUALAN','F225210149163','2934744000','4400000','2939144000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4400000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225210149163' 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 ('F225210149164','kasir',' 1',' MFB1 BW ','TOKO','SMBK-B','B1F-YKAE-11-T','GW TUSUK BUNGA PASIR BW 8K ','OL','0.480','1','100.00','504000','0','0','15000','506000','0','5000','0','511000','TJ','T0074969','B1F','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2025-11-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-YKAE-11-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-21' AND kode_barang='B1F-YKAE-11-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 ('F225210149164','2025-11-21','0.480','2025-11-21','13:49:16','PLG0074951','506000','506000','5000','511000','511000','kasir','2025-11-21 13:49:16','F22521014916');
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-21','F225210149164','2025-11-21','13:49:16','TJ','511000','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-251121-0015','D','2025-11-21','13:49:16','kasir','PENJUALAN','F225210149164','2939144000','511000','2939655000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='511000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225210149164' 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 ('F225210152021','kasir','1',' MFF3F UB ','TOKO','SMBK-F','F3F-YJAF-38-T','GL KOREA UB 8K ','','0.440','1','100.00','462000','0','0','15000','456000','0','0','0','456000','TIN','T0074164','F3F','0','0','-','1','1050000');
UPDATE tm_barang SET tgl_last_jual='2025-11-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YJAF-38-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.440',berat_jual_asli=berat_jual_asli+'0.440',stock_jual='1',berat_akhir=berat_akhir-'0.440',berat_akhir_asli=berat_akhir_asli-'0.440',stock_akhir='0' WHERE tanggal='2025-11-21' AND kode_barang='F3F-YJAF-38-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 ('F225210152021','2025-11-21','0.440','2025-11-21','13:52:03','PLG0074952','456000','456000','0','456000','456000','kasir','2025-11-21 13:52:02','F22521015202');
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-21','F225210152021','2025-11-21','13:52:03','TIN','456000','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-251121-0016','D','2025-11-21','13:52:03','kasir','PENJUALAN','F225210152021','2939655000','456000','2940111000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='456000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225210152021' 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 ('F225210152022','kasir',' 1',' MEE1 LG 22','TOKO','SMBK-E','E1E-YKBX-4-T','CC BANGKOK SLEP LG 22 8K ','','0.520','1','100.00','536000','0','0','15000','529000','0','0','0','529000','TIN','T0075177','E1E','0','0','-','1','1030000');
UPDATE tm_barang SET tgl_last_jual='2025-11-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YKBX-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-11-21' AND kode_barang='E1E-YKBX-4-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 ('F225210152022','2025-11-21','0.520','2025-11-21','13:52:03','PLG0074953','529000','529000','0','529000','529000','kasir','2025-11-21 13:52:02','F22521015202');
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-21','F225210152022','2025-11-21','13:52:03','TIN','529000','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-251121-0017','D','2025-11-21','13:52:03','kasir','PENJUALAN','F225210152022','2940111000','529000','2940640000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='529000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225210152022' 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 ('F225210224371','kasir','1',' MEA1 BW ','TOKO','SMBK-A','A1E-YKBX-36-T','AT MODEL ITALY PANJANG VAR BW 8K ','OL','0.550','1','100.00','566000','0','0','15000','565000','0','5000','0','570000','NS','T0075209','A1E','0','0','-','1','1030000');
UPDATE tm_barang SET tgl_last_jual='2025-11-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YKBX-36-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-21' AND kode_barang='A1E-YKBX-36-T' 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 ('F225210224371','2025-11-21','0.550','2025-11-21','14:24:37','PLG0074954','565000','565000','5000','570000','570000','kasir','2025-11-21 14:24:37','F22521022437');
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-21','F225210224371','2025-11-21','14:24:37','NS','570000','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-251121-0018','D','2025-11-21','14:24:37','kasir','PENJUALAN','F225210224371','2940640000','570000','2941210000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225210113331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225210113331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225210113331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225210117271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225210117271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225210117271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225210128231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225210128231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225210128231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225210149161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225210149161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225210149161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225210149162' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225210149162' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225210149162';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225210149163' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225210149163' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225210149163';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225210149164' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225210149164' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225210149164';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225210152021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225210152021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225210152021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225210152022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225210152022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225210152022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225210224371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225210224371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225210224371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225210950001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225210950001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225210950001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225211005551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225211005551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225211005551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225211005552' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225211005552' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225211005552';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225211117511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225211117511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225211117511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225211129291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225211129291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225211129291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225211129292' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225211129292' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225211129292';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225211131011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225211131011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225211131011';
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-00004848','X-00004848','AT MODEL HATI MATA CM 8K','GR','---','A1E','BELI','BELI001','423000','2025-11-21','0.470','1','kasir','2025-11-21 15:13:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00004848','X-00004848');
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-251121-0001','F225031033081','TIN','1','BELI','BELI001','A1E', 'X-00004848', 'AT MODEL HATI MATA CM 8K','0.470','0.470','100.00','470000','423000','900000','1030000','1','423000','423000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.470',berat_beli_asli=berat_beli_asli+'0.470',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.470',berat_akhir_asli=berat_akhir_asli+'0.470',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-21' 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-251121-0001','2025-11-21','2025-11-21','15:13:42','TIN','---','0.470','423000','423000','423000','423000','423000','kasir','2025-11-21 15:13:43','FB-251121-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251121-0001','ARUM','JENANGAN','','','','kasir','2025-11-21 15:13:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-21' 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-251121-0019','K','2025-11-21','15:13:42','kasir','PEMBELIAN UMUM','FB-251121-0001','2941210000','423000','2940787000');
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-00004849','X-00004849','CC WEDDING MATA CM 14 8K','GR','---','E2D','BELI','BELI001','1350000','2025-11-21','1.900','1','kasir','2025-11-21 15:14:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00004849','X-00004849');
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-251121-0002','F225300934082','NS','1','BELI','BELI001','E2D', 'X-00004849', 'CC WEDDING MATA CM 14 8K','2.010','1.900','100.00','1608000','1350000','710526','995000','1','1350000','1350000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.900',berat_beli_asli=berat_beli_asli+'1.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.900',berat_akhir_asli=berat_akhir_asli+'1.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251121-0002','2025-11-21','2025-11-21','15:14:14','NS','---','1.900','1350000','1350000','1350000','1350000','1350000','kasir','2025-11-21 15:14:14','FB-251121-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251121-0002','NITA','JURUG SOOKO','','','082234341770','kasir','2025-11-21 15:14:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-21' 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-251121-0020','K','2025-11-21','15:14:14','kasir','PEMBELIAN UMUM','FB-251121-0002','2940787000','1350000','2939437000');
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-00004850','X-00004850','GL FANCY KLINTING VAR UB 8K','GR','---','F3E','BELI','BELI001','995000','2025-11-21','1.000','1','kasir','2025-11-21 15:14:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00004850','X-00004850');
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-251121-0003','F225191124381','TIN','1','BELI','BELI001','F3E', 'X-00004850', 'GL FANCY KLINTING VAR UB 8K','1.000','1.000','100.00','1035000','995000','995000','1030000','1','995000','995000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-21' 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-251121-0003','2025-11-21','2025-11-21','15:14:29','TIN','---','1.000','995000','995000','995000','995000','995000','kasir','2025-11-21 15:14:29','FB-251121-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251121-0003','NOVI','PONOROGO','','','','kasir','2025-11-21 15:14:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-21' 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-251121-0021','K','2025-11-21','15:14:29','kasir','PEMBELIAN UMUM','FB-251121-0003','2939437000','995000','2938442000');
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-00004851','X-00004851','GL KOREA UB 8K','GR','---','F3F','BELI','BELI001','335000','2025-11-21','0.420','1','kasir','2025-11-21 15:17:53');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3F','X-00004851','X-00004851');
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-251121-0004','F225011233411','NS','1','BELI','BELI001','F3F', 'X-00004851', 'GL KOREA UB 8K','0.420','0.420','100.00','419000','335000','797619','1050000','1','335000','335000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.420',berat_beli_asli=berat_beli_asli+'0.420',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.420',berat_akhir_asli=berat_akhir_asli+'0.420',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3F' 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-251121-0004','2025-11-21','2025-11-21','15:17:52','NS','---','0.420','335000','335000','335000','335000','335000','kasir','2025-11-21 15:17:53','FB-251121-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251121-0004','RINA RISMA SARI','DS. LEDOKTEMPURO LUMAJANG','','','082330224196','kasir','2025-11-21 15:17:53');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-21' 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-251121-0022','K','2025-11-21','15:17:52','kasir','PEMBELIAN UMUM','FB-251121-0004','2938442000','335000','2938107000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251121-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251121-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251121-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251121-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251121-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251121-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251121-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251121-0004';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00004852','X-00004852','KL ITALY HW 44CM','GR','---','H1TF','BELI','BELI001','7500000','2025-11-21','5.000','1','admin','2025-11-21 15:58:08');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1TF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1TF','X-00004852','X-00004852');
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-251121-0005','F222070342411','RTA','1','BELI','BELI001','H1TF', 'X-00004852', 'KL ITALY HW 44CM','5.100','5.000','100.00','3902000','7500000','1500000','1865000','1','7500000','7500000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.000',berat_beli_asli=berat_beli_asli+'5.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.000',berat_akhir_asli=berat_akhir_asli+'5.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1TF' 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-251121-0005','2025-11-21','2025-11-21','15:58:08','RTA','---','5.000','7500000','7500000','7500000','7500000','7500000','admin','2025-11-21 15:58:08','FB-251121-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251121-0005','INA','JL KH ABDUL HADI 2/2 BABADAN','','','089696814133','admin','2025-11-21 15:58:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-21' 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-251121-0023','K','2025-11-21','15:58:08','admin','PEMBELIAN UMUM','FB-251121-0005','2938107000','7500000','2930607000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251121-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251121-0005';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-22','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-22';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-21';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-21';
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-21' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-21';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-21';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-21';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-21';
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-22' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-21' 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-251122-0001','D','2025-11-22','16:09:54','SYSTEM','SALDO AWAL','SALDO AWAL','0','2930607000','2930607000');
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-251122-0001','D','2025-11-22','16:09:54','BCA','SALDO AWAL','SALDO AWAL','0','4155351888','4155351888');
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-251122-0001','D','2025-11-22','16:09:54','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-251122-0001','D','2025-11-22','16:09:54','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-251122-0001','D','2025-11-22','16:09:54','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-251122-0001','D','2025-11-22','16:09:54','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2025-11-22';