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 ('F325140853231','input','1',' MDE2 5K YT','TOKO','PM-E','E2D-YHAB-105-0','CC MODEL MATA SLEP VAR YT 21 8K ','','0.820','1','100.00','720000','0','0','15000','720000','0','0','0','720000','SIN','00365360','E2D','0','0','-','0','878000');
UPDATE tm_barang SET tgl_last_jual='2025-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YHAB-105-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.820',berat_jual_asli=berat_jual_asli+'0.820',stock_jual='1',berat_akhir=berat_akhir-'0.820',berat_akhir_asli=berat_akhir_asli-'0.820',stock_akhir='0' WHERE tanggal='2025-09-14' AND kode_barang='E2D-YHAB-105-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325140853231','2025-09-14','0.820','2025-09-14','08:53:24','PLG0024869','720000','720000','0','720000','720000','input','2025-09-14 08:53:23','F32514085323');
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-09-14','F325140853231','2025-09-14','08:53:24','SIN','720000','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-250914-0002','D','2025-09-14','08:53:24','input','PENJUALAN','F325140853231','-10773000','720000','-10053000');
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 ('F325140935351','input','1',' MDE2 X LT ','TOKO','PM-E','E2D-YGAA-201-0','CC X MODEL LISTERING MATA LT 14 8K ','','1.180','1','100.00','1036000','0','0','15000','1037000','0','0','0','1037000','SIN','00360754','E2D','0','0','-','0','878000');
UPDATE tm_barang SET tgl_last_jual='2025-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YGAA-201-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.180',berat_jual_asli=berat_jual_asli+'1.180',stock_jual='1',berat_akhir=berat_akhir-'1.180',berat_akhir_asli=berat_akhir_asli-'1.180',stock_akhir='0' WHERE tanggal='2025-09-14' AND kode_barang='E2D-YGAA-201-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325140935351','2025-09-14','1.180','2025-09-14','09:35:36','PLG0024870','1037000','1037000','0','1037000','1037000','input','2025-09-14 09:35:35','F32514093535');
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-09-14','F325140935351','2025-09-14','09:35:36','SIN','1037000','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-250914-0003','D','2025-09-14','09:35:36','input','PENJUALAN','F325140935351','-10053000','1037000','-9016000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1037000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325140935351' 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 ('F325140935352','input',' 1',' MEE1 HW 15','TOKO','PM-E','E1E-YIXH-38-0','CC MODEL SLEP VAR HW 15 8K ','','0.620','1','100.00','555000','0','0','15000','555000','0','0','0','555000','SIN','00368594','E1E','0','0','-','0','895000');
UPDATE tm_barang SET tgl_last_jual='2025-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YIXH-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.620',berat_jual_asli=berat_jual_asli+'0.620',stock_jual='1',berat_akhir=berat_akhir-'0.620',berat_akhir_asli=berat_akhir_asli-'0.620',stock_akhir='0' WHERE tanggal='2025-09-14' AND kode_barang='E1E-YIXH-38-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325140935352','2025-09-14','0.620','2025-09-14','09:35:36','PLG0024871','555000','555000','0','555000','555000','input','2025-09-14 09:35:35','F32514093535');
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-09-14','F325140935352','2025-09-14','09:35:36','SIN','555000','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-250914-0004','D','2025-09-14','09:35:36','input','PENJUALAN','F325140935352','-9016000','555000','-8461000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='555000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325140935352' 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 ('F325140935353','input',' 1',' MEE1 CM 14','TOKO','PM-E','E1E-YIXD-171-0','CC MODEL DAUN VAR CM 14 8K ','','0.700','1','100.00','626000','0','0','15000','626000','0','0','0','626000','SIN','00367928','E1E','0','0','-','0','895000');
UPDATE tm_barang SET tgl_last_jual='2025-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YIXD-171-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-09-14' AND kode_barang='E1E-YIXD-171-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325140935353','2025-09-14','0.700','2025-09-14','09:35:36','PLG0024872','626000','626000','0','626000','626000','input','2025-09-14 09:35:35','F32514093535');
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-09-14','F325140935353','2025-09-14','09:35:36','SIN','626000','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-250914-0005','D','2025-09-14','09:35:36','input','PENJUALAN','F325140935353','-8461000','626000','-7835000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='626000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325140935353' 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 ('F325141016271','input','1',' MEE1 UB 13','TOKO','PM-E','E1E-YHXH-277-0','CC MODEL DAUN VAR UB 13 8K ','','0.660','1','100.00','591000','0','0','15000','590000','0','0','0','590000','AAT','00364805','E1E','0','0','-','1','895000');
UPDATE tm_barang SET tgl_last_jual='2025-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YHXH-277-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2025-09-14' AND kode_barang='E1E-YHXH-277-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325141016271','2025-09-14','0.660','2025-09-14','10:16:27','PLG0024873','590000','590000','0','590000','590000','input','2025-09-14 10:16:27','F32514101627');
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-09-14','F325141016271','2025-09-14','10:16:27','AAT','590000','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-250914-0006','D','2025-09-14','10:16:27','input','PENJUALAN','F325141016271','-7835000','590000','-7245000');
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 ('F325141042431','input','1',' MGB1G LG ','TOKO','PM-B','B1G-YGXD-236-0','GW MODEL TAUGE MRICAN LG 8K ','','0.300','1','100.00','279000','0','0','15000','280000','0','0','0','280000','AAT','00359552','B1G','0','0','-','0','929000');
UPDATE tm_barang SET tgl_last_jual='2025-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-YGXD-236-0' 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-09-14' AND kode_barang='B1G-YGXD-236-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325141042431','2025-09-14','0.300','2025-09-14','10:42:43','PLG0024874','280000','280000','0','280000','280000','input','2025-09-14 10:42:43','F32514104243');
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-09-14','F325141042431','2025-09-14','10:42:43','AAT','280000','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-250914-0007','D','2025-09-14','10:42:43','input','PENJUALAN','F325141042431','-7245000','280000','-6965000');
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 ('F325141103511','input','1',' TEF3 UB ','TOKO','PT-F','F3TE-YFAA-86-T','GL RANTAI HOLLOW SIRIP UB 17K ','','1.980','1','100.00','3148000','0','0','15000','3148000','0','0','0','3148000','FIT','T0069937','F3TE','0','0','-','0','1590000');
UPDATE tm_barang SET tgl_last_jual='2025-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YFAA-86-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2025-09-14' AND kode_barang='F3TE-YFAA-86-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325141103511','2025-09-14','1.980','2025-09-14','11:03:52','PLG0024875','3148000','3148000','0','3148000','3148000','input','2025-09-14 11:03:51','F32514110351');
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-09-14','F325141103511','2025-09-14','11:03:52','FIT','3148000','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-250914-0008','D','2025-09-14','11:03:52','input','PENJUALAN','F325141103511','-6965000','3148000','-3817000');
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 ('F325141112521','input','1',' MEA1E X DG','TOKO','PM-A','A1E-YEXE-93-0','AT X BABY TINDIK DG 8K ','','0.510','1','100.00','456000','0','0','15000','455000','0','0','0','455000','AAT','00352976','A1E','0','0','-','1','895000');
UPDATE tm_barang SET tgl_last_jual='2025-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YEXE-93-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2025-09-14' AND kode_barang='A1E-YEXE-93-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325141112521','2025-09-14','0.510','2025-09-14','11:12:53','PLG0024876','455000','455000','0','455000','455000','input','2025-09-14 11:12:52','F32514111252');
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-09-14','F325141112521','2025-09-14','11:12:53','AAT','455000','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-250914-0009','D','2025-09-14','11:12:53','input','PENJUALAN','F325141112521','-3817000','455000','-3362000');
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 ('F325141123221','kasir','1',' MEA1 LG ','TOKO','PM-A','A1E-YGXB-153-0','AT MODEL MATA VAR LG 8K ','','0.570','1','100.00','510000','0','0','15000','510000','0','0','0','510000','AAT','00359238','A1E','0','0','-','0','895000');
UPDATE tm_barang SET tgl_last_jual='2025-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YGXB-153-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2025-09-14' AND kode_barang='A1E-YGXB-153-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325141123221','2025-09-14','0.570','2025-09-14','11:23:23','PLG0024877','510000','510000','0','510000','510000','kasir','2025-09-14 11:23:22','F32514112322');
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-09-14','F325141123221','2025-09-14','11:23:23','AAT','510000','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-250914-0010','D','2025-09-14','11:23:23','kasir','PENJUALAN','F325141123221','-3362000','510000','-2852000');
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-00016981','X-00016981','GL LEMES 8K','GR','---','F3E','BELI','BELI001','850000','2025-09-14','1.050','1','kasir','2025-09-14 11:39:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00016981','X-00016981');
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-250914-0001','00367518','AAT','1','BELI','BELI001','F3E', 'X-00016981', 'GL LEMES 8K','1.050','1.050','100.00','926000','850000','809524','895000','1','850000','850000','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-09-14' 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-250914-0001','2025-09-14','2025-09-14','11:39:14','AAT','---','1.050','850000','850000','850000','850000','850000','kasir','2025-09-14 11:39:14','FB-250914-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250914-0001','MARLINA','DS TEMON SAMPUNG','','','','kasir','2025-09-14 11:39:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-14' 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-250914-0011','K','2025-09-14','11:39:14','kasir','PEMBELIAN UMUM','FB-250914-0001','-2852000','850000','-3702000');
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-00016982','X-00016982','GL SIEM MODEL HATI VAR LT 8K','GR','---','F3E','BELI','BELI001','960000','2025-09-14','1.210','1','kasir','2025-09-14 11:40:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00016982','X-00016982');
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-250914-0002','F325310900192','FIT','1','BELI','BELI001','F3E', 'X-00016982', 'GL SIEM MODEL HATI VAR LT 8K','1.210','1.210','100.00','1045000','960000','793388','895000','1','960000','960000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.210',berat_beli_asli=berat_beli_asli+'1.210',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.210',berat_akhir_asli=berat_akhir_asli+'1.210',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-14' 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-250914-0002','2025-09-14','2025-09-14','11:40:45','FIT','---','1.210','960000','960000','960000','960000','960000','kasir','2025-09-14 11:40:46','FB-250914-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250914-0002','RATNA','SLOGOHIMO','','','','kasir','2025-09-14 11:40:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-14' 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-250914-0012','K','2025-09-14','11:40:45','kasir','PEMBELIAN UMUM','FB-250914-0002','-3702000','960000','-4662000');
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-00016983','X-00016983','AT TINDIK BABY DG 8K','GR','---','A1E','BELI','BELI001','327000','2025-09-14','0.530','1','kasir','2025-09-14 11:41:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00016983','X-00016983');
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-250914-0003','F324141226211','AAT','1','BELI','BELI001','A1E', 'X-00016983', 'AT TINDIK BABY DG 8K','0.530','0.530','100.00','353000','327000','616981','895000','1','327000','327000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-14' 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-250914-0003','2025-09-14','2025-09-14','11:41:30','AAT','---','0.530','327000','327000','327000','327000','327000','kasir','2025-09-14 11:41:30','FB-250914-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250914-0003','SUPRI','TUNGGUR JURON SLOGOHIMO','','','','kasir','2025-09-14 11:41:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-14' 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-250914-0013','K','2025-09-14','11:41:30','kasir','PEMBELIAN UMUM','FB-250914-0003','-4662000','327000','-4989000');
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-00016984','X-00016984','LT COR M 8K','GR','---','D2E','BELI','BELI001','745000','2025-09-14','1.380','1','kasir','2025-09-14 11:42:42');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00016984','X-00016984');
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-250914-0004','F323301055271','FIT','1','BELI','BELI001','D2E', 'X-00016984', 'LT COR M 8K','1.380','1.380','100.00','673000','745000','539855','895000','1','745000','745000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.380',berat_beli_asli=berat_beli_asli+'1.380',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.380',berat_akhir_asli=berat_akhir_asli+'1.380',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' 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-250914-0004','2025-09-14','2025-09-14','11:42:41','FIT','---','1.380','745000','745000','745000','745000','745000','kasir','2025-09-14 11:42:42','FB-250914-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250914-0004','LINDA','MIRICINDE','','','','kasir','2025-09-14 11:42:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-14' 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-250914-0014','K','2025-09-14','11:42:41','kasir','PEMBELIAN UMUM','FB-250914-0004','-4989000','745000','-5734000');
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 ('F325141156161','kasir','1',' MEF3E X LT','TOKO','PM-F','F3E-XLXI-57-0','GL X RANTAI HOLLOW P4 SLEP LT 8K ','','9.980','1','100.00','8932000','0','0','15000','8933000','0','0','0','8933000','AAT','00329106','F3E','0','0','-','0','895000');
UPDATE tm_barang SET tgl_last_jual='2025-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-XLXI-57-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'9.980',berat_jual_asli=berat_jual_asli+'9.980',stock_jual='1',berat_akhir=berat_akhir-'9.980',berat_akhir_asli=berat_akhir_asli-'9.980',stock_akhir='0' WHERE tanggal='2025-09-14' AND kode_barang='F3E-XLXI-57-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325141156161','2025-09-14','9.980','2025-09-14','11:56:16','PLG0024878','8933000','8933000','0','8933000','8933000','kasir','2025-09-14 11:56:16','F32514115616');
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-09-14','F325141156161','2025-09-14','11:56:16','AAT','8933000','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-250914-0015','D','2025-09-14','11:56:16','kasir','PENJUALAN','F325141156161','-5734000','8933000','3199000');
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 ('F325140148251','kasir','1',' MDE1 X HA ','TOKO','PM-E','E1D-YEBD-406-0','CC X KUKU MACAN HA 16 8K ','','1.010','1','100.00','887000','0','0','15000','888000','0','0','0','888000','FIT','00355493','E1D','0','0','-','0','878000');
UPDATE tm_barang SET tgl_last_jual='2025-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YEBD-406-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2025-09-14' AND kode_barang='E1D-YEBD-406-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325140148251','2025-09-14','1.010','2025-09-14','13:48:26','PLG0024879','888000','888000','0','888000','888000','kasir','2025-09-14 13:48:25','F32514014825');
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-09-14','F325140148251','2025-09-14','13:48:26','FIT','888000','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-250914-0016','D','2025-09-14','13:48:26','kasir','PENJUALAN','F325140148251','3199000','888000','4087000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='888000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325140148251' 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 ('F325140148252','kasir',' 1',' MDE2 CM 22','TOKO','PM-E','E2D-YDAH-139-0','CC MODEL MATA SLEP VAR CM 22 8K ','','2.140','1','100.00','1879000','0','0','15000','1880000','0','0','0','1880000','FIT','00349763','E2D','0','0','-','0','878000');
UPDATE tm_barang SET tgl_last_jual='2025-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YDAH-139-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.140',berat_jual_asli=berat_jual_asli+'2.140',stock_jual='1',berat_akhir=berat_akhir-'2.140',berat_akhir_asli=berat_akhir_asli-'2.140',stock_akhir='0' WHERE tanggal='2025-09-14' AND kode_barang='E2D-YDAH-139-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325140148252','2025-09-14','2.140','2025-09-14','13:48:26','PLG0024880','1880000','1880000','0','1880000','1880000','kasir','2025-09-14 13:48:25','F32514014825');
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-09-14','F325140148252','2025-09-14','13:48:26','FIT','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,status_valid) VALUES ('KM-250914-0017','D','2025-09-14','13:48:26','kasir','PENJUALAN','F325140148252','4087000','1880000','5967000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1880000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325140148252' 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 ('F325140148253','kasir',' 1',' MDE2 X HA ','TOKO','PM-E','E2D-YEAI-259-0','CC X MODEL SLEP HA 19 8K ','','1.520','1','100.00','1335000','0','0','15000','1335000','0','0','0','1335000','FIT','00354743','E2D','0','0','-','0','878000');
UPDATE tm_barang SET tgl_last_jual='2025-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YEAI-259-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2025-09-14' AND kode_barang='E2D-YEAI-259-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325140148253','2025-09-14','1.520','2025-09-14','13:48:26','PLG0024881','1335000','1335000','0','1335000','1335000','kasir','2025-09-14 13:48:25','F32514014825');
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-09-14','F325140148253','2025-09-14','13:48:26','FIT','1335000','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-250914-0018','D','2025-09-14','13:48:26','kasir','PENJUALAN','F325140148253','5967000','1335000','7302000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1335000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325140148253' 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 ('F325140149531','kasir','1',' MEE2 YT 20','TOKO','PM-E','E2E-YHXE-186-0','CC MODEL MATA VAR YT 20 8K ','','0.600','1','100.00','537000','0','0','15000','537000','0','0','0','537000','SIN','00363973','E2E','0','0','-','0','895000');
UPDATE tm_barang SET tgl_last_jual='2025-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YHXE-186-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2025-09-14' AND kode_barang='E2E-YHXE-186-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325140149531','2025-09-14','0.600','2025-09-14','13:49:53','PLG0024882','537000','537000','0','537000','537000','kasir','2025-09-14 13:49:53','F32514014953');
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-09-14','F325140149531','2025-09-14','13:49:53','SIN','537000','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-250914-0019','D','2025-09-14','13:49:53','kasir','PENJUALAN','F325140149531','7302000','537000','7839000');
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 ('F325140156261','kasir','1',' MIH2 X KH ','TOKO','PM-H','H2I-XLXD-2-0','KL X KOREA KH 46 9K ','','9.910','1','100.00','9543000','0','0','15000','9545000','0','0','0','9545000','FIT','00328373','H2I','0','0','-','0','963000');
UPDATE tm_barang SET tgl_last_jual='2025-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-XLXD-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'9.910',berat_jual_asli=berat_jual_asli+'9.910',stock_jual='1',berat_akhir=berat_akhir-'9.910',berat_akhir_asli=berat_akhir_asli-'9.910',stock_akhir='0' WHERE tanggal='2025-09-14' AND kode_barang='H2I-XLXD-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325140156261','2025-09-14','9.910','2025-09-14','13:56:26','PLG0024883','9545000','9545000','0','9545000','9545000','kasir','2025-09-14 13:56:26','F32514015626');
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-09-14','F325140156261','2025-09-14','13:56:26','FIT','9545000','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-250914-0020','D','2025-09-14','13:56:26','kasir','PENJUALAN','F325140156261','7839000','9545000','17384000');
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-00016985','X-00016985','CC X BANGKOK SLEP OR 20 8K','GR','---','E1D','BELI','BELI001','755000','2025-09-14','1.000','1','kasir','2025-09-14 14:34:01');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00016985','X-00016985');
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-250914-0005','F325300918163','FIT','1','BELI','BELI001','E1D', 'X-00016985', 'CC X BANGKOK SLEP OR 20 8K','1.000','1.000','100.00','813000','755000','755000','878000','1','755000','755000','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-09-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-250914-0005','2025-09-14','2025-09-14','14:34:01','FIT','---','1.000','755000','755000','755000','755000','755000','kasir','2025-09-14 14:34:01','FB-250914-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250914-0005','BU TIN','DAGANGAN NGERJO BULUKERTO','','','','kasir','2025-09-14 14:34:01');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-14' 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-250914-0021','K','2025-09-14','14:34:01','kasir','PEMBELIAN UMUM','FB-250914-0005','17384000','755000','16629000');
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 ('F325140300131','kasir','1',' MEF3E X UB','TOKO','PM-F','F3E-YFBH-86-0','GL X SANTAI MATA VAR SERUT UB 8K ','','1.550','1','100.00','1387000','0','0','15000','1387000','0','0','0','1387000','FIT','00358794','F3E','0','0','-','0','895000');
UPDATE tm_barang SET tgl_last_jual='2025-09-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YFBH-86-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2025-09-14' AND kode_barang='F3E-YFBH-86-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325140300131','2025-09-14','1.550','2025-09-14','15:00:14','PLG0024884','1387000','1387000','0','1387000','1387000','kasir','2025-09-14 15:00:13','F32514030013');
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-09-14','F325140300131','2025-09-14','15:00:14','FIT','1387000','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-250914-0022','D','2025-09-14','15:00:14','kasir','PENJUALAN','F325140300131','16629000','1387000','18016000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325140148251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325140148251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325140148251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325140148252' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325140148252' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325140148252';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325140148253' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325140148253' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325140148253';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325140149531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325140149531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325140149531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325140156261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325140156261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325140156261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325140300131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325140300131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325140300131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325140853231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325140853231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325140853231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325140935351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325140935351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325140935351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325140935352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325140935352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325140935352';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325140935353' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325140935353' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325140935353';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325141016271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325141016271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325141016271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325141042431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325141042431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325141042431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325141103511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325141103511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325141103511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325141112521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325141112521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325141112521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325141123221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325141123221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325141123221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325141156161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325141156161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325141156161';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250914-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250914-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250914-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250914-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250914-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250914-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250914-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250914-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250914-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250914-0005';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-15','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-15';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-14';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-14';
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-09-14' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-14';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-14';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-14';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-14';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202508 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
UPDATE tt_barang_saldo SET tanggal= '2025-09-15' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-14' 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-250915-0001','D','2025-09-15','15:20:53','SYSTEM','SALDO AWAL','SALDO AWAL','0','18016000','18016000');
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-250915-0001','D','2025-09-15','15:20:53','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
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-250915-0001','D','2025-09-15','15:20:53','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-250915-0001','D','2025-09-15','15:20:53','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2025-09-15';