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 ('F325020837591','input','1',' MIH2 X KH ','TOKO','PM-H','H2I-YHXI-132-0','KL X SANTA ANAK KH 34 9K ','','1.950','1','100.00','2086000','0','0','15000','2085000','0','0','0','2085000','FIT','00364996','H2I','0','0','-','1','1080000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-YHXI-132-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.950',berat_jual_asli=berat_jual_asli+'1.950',stock_jual='1',berat_akhir=berat_akhir-'1.950',berat_akhir_asli=berat_akhir_asli-'1.950',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='H2I-YHXI-132-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 ('F325020837591','2025-11-02','1.950','2025-11-02','08:37:59','PLG0025494','2085000','2085000','0','2085000','2085000','input','2025-11-02 08:37:59','F32502083759');
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-02','F325020837591','2025-11-02','08:37:59','FIT','2085000','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-251102-0002','D','2025-11-02','08:37:59','input','PENJUALAN','F325020837591','502763000','2085000','504848000');
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 ('F325020853221','input','1',' MEF3 X KH ','TOKO','PM-F','F3E-YFBX-134-0','GL X RANTE HOLLOW P4 KH 8K ','','3.910','1','100.00','3871000','0','0','15000','3795000','0','0','0','3795000','FIT','00358219','F3E','0','0','-','1','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YFBX-134-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.910',berat_jual_asli=berat_jual_asli+'3.910',stock_jual='1',berat_akhir=berat_akhir-'3.910',berat_akhir_asli=berat_akhir_asli-'3.910',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='F3E-YFBX-134-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 ('F325020853221','2025-11-02','3.910','2025-11-02','08:53:23','PLG0025495','3795000','3795000','0','3795000','3795000','input','2025-11-02 08:53:22','F32502085322');
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-02','F325020853221','2025-11-02','08:53:23','FIT','3795000','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-251102-0003','D','2025-11-02','08:53:23','input','PENJUALAN','F325020853221','504848000','3795000','508643000');
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 ('F325020900121','input','1',' MEF3E X LT','TOKO','PM-F','F3E-YJBB-186-0','GL X RANTAI HOLLOW P3 LT 8K ','','1.020','1','100.00','1010000','0','0','15000','1010000','0','0','0','1010000','SIN','00374249','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJBB-186-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='F3E-YJBB-186-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 ('F325020900121','2025-11-02','1.020','2025-11-02','09:00:12','PLG0025496','1010000','1010000','0','1010000','1010000','input','2025-11-02 09:00:12','F32502090012');
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-02','F325020900121','2025-11-02','09:00:12','SIN','1010000','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-251102-0004','D','2025-11-02','09:00:12','input','PENJUALAN','F325020900121','508643000','1010000','509653000');
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 ('F325020923191','input','1',' MEE2 X HW ','TOKO','PM-E','E2E-YJBC-3-0','CC X MODEL MATA HW 13 8K ','','0.730','1','100.00','723000','0','0','15000','723000','0','0','0','723000','SIN','00374321','E2E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJBC-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.730',berat_jual_asli=berat_jual_asli+'0.730',stock_jual='1',berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='E2E-YJBC-3-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 ('F325020923191','2025-11-02','0.730','2025-11-02','09:23:20','PLG0025497','723000','723000','0','723000','723000','input','2025-11-02 09:23:19','F32502092319');
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-02','F325020923191','2025-11-02','09:23:20','SIN','723000','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-251102-0005','D','2025-11-02','09:23:20','input','PENJUALAN','F325020923191','509653000','723000','510376000');
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 ('F325020935181','input','1',' TFE8 X KH ','TOKO','PT-E','E8TF-XAXC-93-T','CC X MODEL SLEP VAR KH SI 17','','2.780','1','100.00','5060000','0','0','15000','5005000','0','0','0','5005000','FIT','T0052938','E8TF','0','0','-','1','1820000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E8TF-XAXC-93-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.780',berat_jual_asli=berat_jual_asli+'2.780',stock_jual='1',berat_akhir=berat_akhir-'2.780',berat_akhir_asli=berat_akhir_asli-'2.780',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='E8TF-XAXC-93-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F325020935181','2025-11-02','2.780','2025-11-02','09:35:19','PLG0025498','5005000','5005000','0','5005000','5005000','input','2025-11-02 09:35:18','F32502093518');
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-02','F325020935181','2025-11-02','09:35:19','FIT','5005000','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-251102-0006','D','2025-11-02','09:35:19','input','PENJUALAN','F325020935181','510376000','5005000','515381000');
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 ('F325020937511','input','1',' MEF1 X UB ','TOKO','PM-F','F1E-YJBA-179-0','GL X OVAL C SLEP UB 60 8K ','','2.460','1','100.00','2435000','0','0','15000','2435000','0','0','0','2435000','SIN','00374056','F1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YJBA-179-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.460',berat_jual_asli=berat_jual_asli+'2.460',stock_jual='1',berat_akhir=berat_akhir-'2.460',berat_akhir_asli=berat_akhir_asli-'2.460',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='F1E-YJBA-179-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 ('F325020937511','2025-11-02','2.460','2025-11-02','09:37:52','PLG0025499','2435000','2435000','0','2435000','2435000','input','2025-11-02 09:37:51','F32502093751');
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-02','F325020937511','2025-11-02','09:37:52','SIN','2435000','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-251102-0007','D','2025-11-02','09:37:52','input','PENJUALAN','F325020937511','515381000','2435000','517816000');
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 ('F325020956141','input','1',' MFB1F X UB','TOKO','PM-B','B1F-YGXE-253-0','GW X ITALY ARESO SLEP UB 8K ','','0.770','1','100.00','778000','0','0','15000','778000','0','0','0','778000','SIN','00359892','B1F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-YGXE-253-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='B1F-YGXE-253-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 ('F325020956141','2025-11-02','0.770','2025-11-02','09:56:15','PLG0025500','778000','778000','0','778000','778000','input','2025-11-02 09:56:14','F32502095614');
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-02','F325020956141','2025-11-02','09:56:15','SIN','778000','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-251102-0008','D','2025-11-02','09:56:15','input','PENJUALAN','F325020956141','517816000','778000','518594000');
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 ('F325021005061','input','1',' MDE2 X LG ','TOKO','PM-E','E2D-YFAD-11-0','CC X MODEL MATA LG 16 8K ','','1.010','1','100.00','980000','0','0','15000','980000','0','0','0','980000','SIN','00357291','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YFAD-11-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-11-02' AND kode_barang='E2D-YFAD-11-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 ('F325021005061','2025-11-02','1.010','2025-11-02','10:05:07','PLG0025501','980000','980000','0','980000','980000','input','2025-11-02 10:05:06','F32502100506');
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-02','F325021005061','2025-11-02','10:05:07','SIN','980000','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-251102-0009','D','2025-11-02','10:05:07','input','PENJUALAN','F325021005061','518594000','980000','519574000');
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 ('F325021018241','input','1',' MDE2 X CM ','TOKO','PM-E','E2D-YFBA-100-0','CC X MODEL MATA CM 12 8K ','','0.880','1','100.00','854000','0','0','15000','855000','0','0','0','855000','SIN','00358374','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YFBA-100-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.880',berat_jual_asli=berat_jual_asli+'0.880',stock_jual='1',berat_akhir=berat_akhir-'0.880',berat_akhir_asli=berat_akhir_asli-'0.880',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='E2D-YFBA-100-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 ('F325021018241','2025-11-02','0.880','2025-11-02','10:18:25','PLG0025502','855000','855000','0','855000','855000','input','2025-11-02 10:18:24','F32502101824');
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-02','F325021018241','2025-11-02','10:18:25','SIN','855000','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-251102-0010','D','2025-11-02','10:18:25','input','PENJUALAN','F325021018241','519574000','855000','520429000');
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 ('F325021024431','input','1',' MEB1E LG ','TOKO','PM-B','B1E-YJCX-40-0','GW TIFF MATA VAR LG 8K','','0.540','1','100.00','540000','0','0','15000','535000','0','0','0','535000','SIN','00375252','B1E','0','0','-','1','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJCX-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.540',berat_jual_asli=berat_jual_asli+'0.540',stock_jual='1',berat_akhir=berat_akhir-'0.540',berat_akhir_asli=berat_akhir_asli-'0.540',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='B1E-YJCX-40-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 ('F325021024431','2025-11-02','0.540','2025-11-02','10:24:44','PLG0025503','535000','535000','0','535000','535000','input','2025-11-02 10:24:43','F32502102443');
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-02','F325021024431','2025-11-02','10:24:44','SIN','535000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251102-0011','D','2025-11-02','10:24:44','input','PENJUALAN','F325021024431','520429000','535000','520964000');
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 ('F325021133061','input','1',' MJH2 X UB ','TOKO','PM-H','H2J-YJAC-108-0','KL X MILANO ANAK UB 34 9K ','','2.070','1','100.00','2256000','0','0','15000','2255000','0','0','0','2255000','SIN','00372838','H2J','0','0','-','1','1100000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YJAC-108-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='H2J-YJAC-108-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 ('F325021133061','2025-11-02','2.070','2025-11-02','11:33:06','PLG0025504','2255000','2255000','0','2255000','2255000','input','2025-11-02 11:33:06','F32502113306');
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-02','F325021133061','2025-11-02','11:33:06','SIN','2255000','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-251102-0012','D','2025-11-02','11:33:06','input','PENJUALAN','F325021133061','520964000','2255000','523219000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2255000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325021133061' 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 ('F325021133062','input',' 1',' MFD2F X LG','TOKO','PM-D','D2F-YDXI-282-0','LT X MODEL HURUF MATA LG C 8K ','','0.430','1','100.00','434000','0','0','15000','435000','0','0','0','435000','SIN','00348538','D2F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2F-YDXI-282-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.430',berat_jual_asli=berat_jual_asli+'0.430',stock_jual='1',berat_akhir=berat_akhir-'0.430',berat_akhir_asli=berat_akhir_asli-'0.430',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='D2F-YDXI-282-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325021133062','2025-11-02','0.430','2025-11-02','11:33:06','PLG0025505','435000','435000','0','435000','435000','input','2025-11-02 11:33:06','F32502113306');
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-02','F325021133062','2025-11-02','11:33:06','SIN','435000','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-251102-0013','D','2025-11-02','11:33:06','input','PENJUALAN','F325021133062','523219000','435000','523654000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='435000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325021133062' 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 ('F325021141501','input','1',' TAB0 X DW ','TOKO','PT-B','B0TA-VDBX-178-T','GW X MRICAN SLEP DW ','','0.500','1','100.00','855000','0','0','15000','855000','0','0','0','855000','AAT','T0033060','B0TA','0','0','-','0','1710000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B0TA-VDBX-178-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='B0TA-VDBX-178-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F325021141501','2025-11-02','0.500','2025-11-02','11:41:50','PLG0025506','855000','855000','0','855000','855000','input','2025-11-02 11:41:50','F32502114150');
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-02','F325021141501','2025-11-02','11:41:50','AAT','855000','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-251102-0014','D','2025-11-02','11:41:50','input','PENJUALAN','F325021141501','523654000','855000','524509000');
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 ('F325021155331','input','1',' MFH1F UB ','TOKO','PM-H','H1F-YJBA-265-0','KL SIEM COBRA ARESO VAR UB 8K ','','1.460','1','100.00','1475000','0','0','15000','1475000','0','0','0','1475000','SIN','00374142','H1F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YJBA-265-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.460',berat_jual_asli=berat_jual_asli+'1.460',stock_jual='1',berat_akhir=berat_akhir-'1.460',berat_akhir_asli=berat_akhir_asli-'1.460',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='H1F-YJBA-265-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 ('F325021155331','2025-11-02','1.460','2025-11-02','11:55:33','PLG0025507','1475000','1475000','0','1475000','1475000','input','2025-11-02 11:55:33','F32502115533');
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-02','F325021155331','2025-11-02','11:55:33','SIN','1475000','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-251102-0015','D','2025-11-02','11:55:33','input','PENJUALAN','F325021155331','524509000','1475000','525984000');
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 ('F325021157301','input','1',' MEE2 X UB ','TOKO','PM-E','E2E-YJAA-49-0','CC X MODEL MATA UB 14 8K ','','0.650','1','100.00','643000','0','0','15000','645000','0','0','0','645000','SIN','00372587','E2E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJAA-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='E2E-YJAA-49-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 ('F325021157301','2025-11-02','0.650','2025-11-02','11:57:31','PLG0025508','645000','645000','0','645000','645000','input','2025-11-02 11:57:30','F32502115730');
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-02','F325021157301','2025-11-02','11:57:31','SIN','645000','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-251102-0016','D','2025-11-02','11:57:31','input','PENJUALAN','F325021157301','525984000','645000','526629000');
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 ('F325021243081','input','1',' MEF3E UB ','TOKO','PM-F','F3E-YJAH-39-0','GL SANTA ARESO VAR SERUT UB 8K ','','1.980','1','100.00','1960000','0','0','15000','1960000','0','0','0','1960000','SIN','00373734','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJAH-39-0' 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-11-02' AND kode_barang='F3E-YJAH-39-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 ('F325021243081','2025-11-02','1.980','2025-11-02','12:43:09','PLG0025509','1960000','1960000','0','1960000','1960000','input','2025-11-02 12:43:08','F32502124308');
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-02','F325021243081','2025-11-02','12:43:09','SIN','1960000','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-251102-0017','D','2025-11-02','12:43:09','input','PENJUALAN','F325021243081','526629000','1960000','528589000');
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 ('F325021256041','input','1',' MGPE X 10K','TOKO','PM-P','PEG-YJCA-97-0','CC X SOLITAIRE MATA CM 12 8K','','1.360','1','100.00','1414000','0','0','15000','1400000','0','10000','0','1410000','SIN','00375484','PEG','0','0','-','1','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PEG-YJCA-97-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.360',berat_jual_asli=berat_jual_asli+'1.360',stock_jual='1',berat_akhir=berat_akhir-'1.360',berat_akhir_asli=berat_akhir_asli-'1.360',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='PEG-YJCA-97-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-P' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325021256041','2025-11-02','1.360','2025-11-02','12:56:04','PLG0025510','1400000','1400000','10000','1410000','1410000','input','2025-11-02 12:56:04','F32502125604');
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-02','F325021256041','2025-11-02','12:56:04','SIN','1410000','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-251102-0018','D','2025-11-02','12:56:04','input','PENJUALAN','F325021256041','528589000','1410000','529999000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1410000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325021256041' 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 ('F325021256042','input',' 1',' MED2 X LG ','TOKO','PM-D','D2E-UEAE-33-0','LT X MODEL HURUF MATA LG G ','','1.030','1','100.00','1020000','0','0','15000','1020000','0','0','0','1020000','SIN','00099811','D2E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-UEAE-33-0' 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-02' AND kode_barang='D2E-UEAE-33-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325021256042','2025-11-02','1.030','2025-11-02','12:56:04','PLG0025511','1020000','1020000','0','1020000','1020000','input','2025-11-02 12:56:04','F32502125604');
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-02','F325021256042','2025-11-02','12:56:04','SIN','1020000','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-251102-0019','D','2025-11-02','12:56:04','input','PENJUALAN','F325021256042','529999000','1020000','531019000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1020000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325021256042' 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 ('F325020124191','input','1',' MDE1 X OR ','TOKO','PM-E','E1D-YIBD-412-0','CC X BANGKOK POLOS SLEP OR 15 8K ','','0.970','1','100.00','941000','0','0','15000','940000','0','0','0','940000','SIN','00370833','E1D','0','0','-','1','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YIBD-412-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='E1D-YIBD-412-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 ('F325020124191','2025-11-02','0.970','2025-11-02','13:24:19','PLG0025512','940000','940000','0','940000','940000','input','2025-11-02 13:24:19','F32502012419');
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-02','F325020124191','2025-11-02','13:24:19','SIN','940000','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-251102-0020','D','2025-11-02','13:24:19','input','PENJUALAN','F325020124191','531019000','940000','531959000');
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 ('F325020144151','input','1',' MDE1 CM 10','TOKO','PM-E','E1D-YJBG-118-0','CC MODEL DAUN SLEP CM 10 8K ','','1.180','1','100.00','1145000','0','0','15000','1145000','0','0','0','1145000','SIN','00374910','E1D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJBG-118-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-11-02' AND kode_barang='E1D-YJBG-118-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 ('F325020144151','2025-11-02','1.180','2025-11-02','13:44:16','PLG0025513','1145000','1145000','0','1145000','1145000','input','2025-11-02 13:44:15','F32502014415');
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-02','F325020144151','2025-11-02','13:44:16','SIN','1145000','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-251102-0021','D','2025-11-02','13:44:16','input','PENJUALAN','F325020144151','531959000','1145000','533104000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1145000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325020144151' 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 ('F325020144152','input',' 1',' MEE2 5K CM','TOKO','PM-E','E2E-YCXE-129-0','CC MODEL AUREL MATA VAR CM 10 8K ','','0.730','1','100.00','723000','0','0','15000','723000','0','5000','0','728000','SIN','00341934','E2E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YCXE-129-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.730',berat_jual_asli=berat_jual_asli+'0.730',stock_jual='1',berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='E2E-YCXE-129-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 ('F325020144152','2025-11-02','0.730','2025-11-02','13:44:16','PLG0025514','723000','723000','5000','728000','728000','input','2025-11-02 13:44:15','F32502014415');
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-02','F325020144152','2025-11-02','13:44:16','SIN','728000','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-251102-0022','D','2025-11-02','13:44:16','input','PENJUALAN','F325020144152','533104000','728000','533832000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='728000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325020144152' 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 ('F325020144153','input',' 1',' MDE1 UB 16','TOKO','PM-E','E1D-YJCX-81-0','CC MODEL DAUN SLEP UB 16 8K ','','1.000','1','100.00','980000','0','0','15000','970000','0','0','0','970000','SIN','00375293','E1D','0','0','-','1','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJCX-81-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='E1D-YJCX-81-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 ('F325020144153','2025-11-02','1.000','2025-11-02','13:44:16','PLG0025515','970000','970000','0','970000','970000','input','2025-11-02 13:44:15','F32502014415');
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-02','F325020144153','2025-11-02','13:44:16','SIN','970000','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-251102-0023','D','2025-11-02','13:44:16','input','PENJUALAN','F325020144153','533832000','970000','534802000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='970000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325020144153' 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 ('F325020159381','input','1',' MEA1E LG ','TOKO','PM-A','A1E-YJCX-35-0','AT MODEL MATA LG 8K','','0.550','1','100.00','550000','0','0','15000','545000','0','0','0','545000','SIN','00375247','A1E','0','0','-','1','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJCX-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='A1E-YJCX-35-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 ('F325020159381','2025-11-02','0.550','2025-11-02','13:59:39','PLG0025516','545000','545000','0','545000','545000','input','2025-11-02 13:59:38','F32502015938');
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-02','F325020159381','2025-11-02','13:59:39','SIN','545000','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-251102-0024','D','2025-11-02','13:59:39','input','PENJUALAN','F325020159381','534802000','545000','535347000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325020159381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325020159381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325020159381';
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 ('F325020204251','kasir','1',' MEA1E LG ','TOKO','PM-A','A1E-YJCX-35-0','AT MODEL MATA LG 8K','','0.550','1','100.00','550000','0','0','15000','545000','0','0','0','545000','SIN','00375247','A1E','0','0','-','1','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJCX-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='A1E-YJCX-35-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 ('F325020204251','2025-11-02','0.550','2025-11-02','14:04:25','PLG0025517','545000','545000','0','545000','545000','kasir','2025-11-02 14:04:25','F32502020425');
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-02','F325020204251','2025-11-02','14:04:25','SIN','545000','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-251102-0026','D','2025-11-02','14:04:25','kasir','PENJUALAN','F325020204251','534802000','545000','535347000');
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 ('F325020210151','kasir','1',' TDE2 X YT ','TOKO','PT-E','E2TD-YIXE-11-T','CC X MODEL MATA VAR YT 9 17K ','','1.160','1','100.00','2065000','0','0','15000','2065000','0','0','0','2065000','SIN','T0072981','E2TD','0','0','-','0','1780000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YIXE-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.160',berat_jual_asli=berat_jual_asli+'1.160',stock_jual='1',berat_akhir=berat_akhir-'1.160',berat_akhir_asli=berat_akhir_asli-'1.160',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='E2TD-YIXE-11-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F325020210151','2025-11-02','1.160','2025-11-02','14:10:15','PLG0025518','2065000','2065000','0','2065000','2065000','kasir','2025-11-02 14:10:15','F32502021015');
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-02','F325020210151','2025-11-02','14:10:15','SIN','2065000','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-251102-0027','D','2025-11-02','14:10:15','kasir','PENJUALAN','F325020210151','535347000','2065000','537412000');
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 ('F325020213411','kasir','1',' MEF1 X CM ','TOKO','PM-F','F1E-YDBA-88-0','GL X OSROT TINJU SLEP ANAK CM 8K ','','1.450','1','100.00','1435000','0','0','15000','1435000','0','0','0','1435000','SIN','00350345','F1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YDBA-88-0' 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-02' AND kode_barang='F1E-YDBA-88-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 ('F325020213411','2025-11-02','1.450','2025-11-02','14:13:41','PLG0025519','1435000','1435000','0','1435000','1435000','kasir','2025-11-02 14:13:41','F32502021341');
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-02','F325020213411','2025-11-02','14:13:41','SIN','1435000','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-251102-0028','D','2025-11-02','14:13:41','kasir','PENJUALAN','F325020213411','537412000','1435000','538847000');
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-00017375','X-00017375','GL TRIXIE SERUT MODEL SPECTRA VAR UB 8K','GR','---','F3E','BELI','BELI001','1180000','2025-11-02','1.600','1','kasir','2025-11-02 14:31:53');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017375','X-00017375');
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-251102-0001','F325041130321','FIT','1','BELI','BELI001','F3E', 'X-00017375', 'GL TRIXIE SERUT MODEL SPECTRA VAR UB 8K','1.600','1.600','100.00','1285000','1180000','737500','1000000','1','1180000','1180000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.600',berat_beli_asli=berat_beli_asli+'1.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.600',berat_akhir_asli=berat_akhir_asli+'1.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-02' 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-251102-0001','2025-11-02','2025-11-02','14:31:53','FIT','---','1.600','1180000','1180000','1180000','1180000','1180000','kasir','2025-11-02 14:31:53','FB-251102-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251102-0001','SUSAN','KEPYAR PURWANTORO','','','','kasir','2025-11-02 14:31:53');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-02' 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-251102-0029','K','2025-11-02','14:31:53','kasir','PEMBELIAN UMUM','FB-251102-0001','538847000','1180000','537667000');
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-00017376','X-00017376','CC BANGKOK PASIR SLEP BW 10 8K','GR','---','E1E','BELI','BELI001','410000','2025-11-02','0.530','1','kasir','2025-11-02 14:32:40');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00017376','X-00017376');
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-251102-0002','F325131217351','AAT','1','BELI','BELI001','E1E', 'X-00017376', 'CC BANGKOK PASIR SLEP BW 10 8K','0.530','0.530','100.00','440000','410000','773585','1000000','1','410000','410000','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-11-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251102-0002','2025-11-02','2025-11-02','14:32:40','AAT','---','0.530','410000','410000','410000','410000','410000','kasir','2025-11-02 14:32:40','FB-251102-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251102-0002','ANISA','SUMBERGALIH','','','','kasir','2025-11-02 14:32:40');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-02' 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-251102-0030','K','2025-11-02','14:32:40','kasir','PEMBELIAN UMUM','FB-251102-0002','537667000','410000','537257000');
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-00017377','X-00017377','CC X MODEL MATA LG 14 8K','GR','---','E2D','BELI','BELI001','812000','2025-11-02','1.070','1','kasir','2025-11-02 14:33:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017377','X-00017377');
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-251102-0003','F325271109582','FIT','1','BELI','BELI001','E2D', 'X-00017377', 'CC X MODEL MATA LG 14 8K','1.070','1.070','100.00','875000','812000','758879','980000','1','812000','812000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.070',berat_beli_asli=berat_beli_asli+'1.070',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.070',berat_akhir_asli=berat_akhir_asli+'1.070',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-02' 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-251102-0003','2025-11-02','2025-11-02','14:33:14','FIT','---','1.070','812000','812000','812000','812000','812000','kasir','2025-11-02 14:33:14','FB-251102-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251102-0003','DESI PURWATI','KEMBANGAN 1/3 GESING KISMANTORO','','','','kasir','2025-11-02 14:33:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-02' 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-251102-0031','K','2025-11-02','14:33:14','kasir','PEMBELIAN UMUM','FB-251102-0003','537257000','812000','536445000');
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-00017378','X-00017378','CC MODEL HATI MATA VAR CM 14 8K','GR','---','E2D','BELI','BELI001','997000','2025-11-02','1.100','1','kasir','2025-11-02 14:33:52');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017378','X-00017378');
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-251102-0004','F325110816121','SIN','1','BELI','BELI001','E2D', 'X-00017378', 'CC MODEL HATI MATA VAR CM 14 8K','1.100','1.100','100.00','1085000','997000','906364','980000','1','997000','997000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.100',berat_beli_asli=berat_beli_asli+'1.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.100',berat_akhir_asli=berat_akhir_asli+'1.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-02' 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-251102-0004','2025-11-02','2025-11-02','14:33:51','SIN','---','1.100','997000','997000','997000','997000','997000','kasir','2025-11-02 14:33:52','FB-251102-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251102-0004','DEVIKA','TEMON BITING','','','','kasir','2025-11-02 14:33:52');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-02' 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-251102-0032','K','2025-11-02','14:33:51','kasir','PEMBELIAN UMUM','FB-251102-0004','536445000','997000','535448000');
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-00017379','X-00017379','CC ANAK MODEL BONEKA CAT MATA LG 8K','GR','---','E2E','BELI','BELI001','565000','2025-11-02','0.970','1','kasir','2025-11-02 14:34:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00017379','X-00017379');
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-251102-0005','F324140951001','FIT','1','BELI','BELI001','E2E', 'X-00017379', 'CC ANAK MODEL BONEKA CAT MATA LG 8K','1.000','0.970','100.00','588000','565000','582474','1000000','1','565000','565000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.970',berat_beli_asli=berat_beli_asli+'0.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.970',berat_akhir_asli=berat_akhir_asli+'0.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251102-0005','2025-11-02','2025-11-02','14:34:22','FIT','---','0.970','565000','565000','565000','565000','565000','kasir','2025-11-02 14:34:23','FB-251102-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251102-0005','AULIA','SIDOWAYAH PURWANTORO','','','','kasir','2025-11-02 14:34:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-02' 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-251102-0033','K','2025-11-02','14:34:22','kasir','PEMBELIAN UMUM','FB-251102-0005','535448000','565000','534883000');
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 ('F325020242041','input','1',' MDE2 X CM ','TOKO','PM-E','E2D-YHAD-125-0','CC X MODEL SOLITAIRE MATA CM 16 8K ','','0.880','1','100.00','854000','0','0','15000','855000','0','10000','0','865000','SIN','00365739','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YHAD-125-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.880',berat_jual_asli=berat_jual_asli+'0.880',stock_jual='1',berat_akhir=berat_akhir-'0.880',berat_akhir_asli=berat_akhir_asli-'0.880',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='E2D-YHAD-125-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 ('F325020242041','2025-11-02','0.880','2025-11-02','14:42:05','PLG0025520','855000','855000','10000','865000','865000','input','2025-11-02 14:42:04','F32502024204');
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-02','F325020242041','2025-11-02','14:42:05','SIN','865000','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-251102-0034','D','2025-11-02','14:42:05','input','PENJUALAN','F325020242041','534883000','865000','535748000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='865000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325020242041' 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 ('F325020242042','input',' 1',' MDE2 10K C','TOKO','PM-E','E2D-YJXF-56-0','CC WEDDING MATA CM 14 8K ','','1.530','1','100.00','1484000','0','0','15000','1485000','0','10000','0','1495000','SIN','00372353','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJXF-56-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='E2D-YJXF-56-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 ('F325020242042','2025-11-02','1.530','2025-11-02','14:42:05','PLG0025521','1485000','1485000','10000','1495000','1495000','input','2025-11-02 14:42:04','F32502024204');
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-02','F325020242042','2025-11-02','14:42:05','SIN','1495000','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-251102-0035','D','2025-11-02','14:42:05','input','PENJUALAN','F325020242042','535748000','1495000','537243000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1495000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325020242042' 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 ('F325020242371','input','1',' MGB1G X LG','TOKO','PM-B','B1G-YEXA-32-0','GW X TUSUK DAISY MATA LG 8K ','','0.310','1','100.00','319000','0','0','15000','320000','0','0','0','320000','SIN','00351625','B1G','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-YEXA-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='B1G-YEXA-32-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 ('F325020242371','2025-11-02','0.310','2025-11-02','14:42:38','PLG0025522','320000','320000','0','320000','320000','input','2025-11-02 14:42:37','F32502024237');
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-02','F325020242371','2025-11-02','14:42:38','SIN','320000','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-251102-0036','D','2025-11-02','14:42:38','input','PENJUALAN','F325020242371','537243000','320000','537563000');
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 ('F325020251311','input','1',' MEF1 X YT ','TOKO','PM-F','F1E-XJXA-155-0','GL X OVAL C YT 58 8K ','','3.480','1','100.00','3445000','0','0','15000','3445000','0','0','0','3445000','SIN','00319556','F1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-XJXA-155-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.480',berat_jual_asli=berat_jual_asli+'3.480',stock_jual='1',berat_akhir=berat_akhir-'3.480',berat_akhir_asli=berat_akhir_asli-'3.480',stock_akhir='0' WHERE tanggal='2025-11-02' AND kode_barang='F1E-XJXA-155-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 ('F325020251311','2025-11-02','3.480','2025-11-02','14:51:32','PLG0025523','3445000','3445000','0','3445000','3445000','input','2025-11-02 14:51:31','F32502025131');
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-02','F325020251311','2025-11-02','14:51:32','SIN','3445000','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-251102-0037','D','2025-11-02','14:51:32','input','PENJUALAN','F325020251311','537563000','3445000','541008000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325020124191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325020124191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325020124191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325020144151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325020144151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325020144151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325020144152' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325020144152' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325020144152';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325020144153' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325020144153' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325020144153';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325020204251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325020204251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325020204251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325020210151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325020210151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325020210151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325020213411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325020213411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325020213411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325020242041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325020242041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325020242041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325020242042' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325020242042' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325020242042';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325020242371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325020242371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325020242371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325020251311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325020251311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325020251311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325020837591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325020837591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325020837591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325020853221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325020853221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325020853221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325020900121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325020900121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325020900121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325020923191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325020923191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325020923191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325020935181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325020935181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325020935181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325020937511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325020937511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325020937511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325020956141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325020956141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325020956141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325021005061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325021005061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325021005061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325021018241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325021018241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325021018241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325021024431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325021024431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325021024431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325021133061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325021133061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325021133061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325021133062' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325021133062' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325021133062';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325021141501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325021141501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325021141501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325021155331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325021155331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325021155331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325021157301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325021157301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325021157301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325021243081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325021243081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325021243081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325021256041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325021256041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325021256041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325021256042' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325021256042' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325021256042';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251102-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251102-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251102-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251102-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251102-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251102-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251102-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251102-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251102-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251102-0005';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-03','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-03';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-02';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-02';
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-02' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-02';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-02';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-02';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-02';
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-03' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-02' 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-251103-0001','D','2025-11-03','15:47:44','SYSTEM','SALDO AWAL','SALDO AWAL','0','541008000','541008000');
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-251103-0001','D','2025-11-03','15:47:44','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-251103-0001','D','2025-11-03','15:47:44','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-251103-0001','D','2025-11-03','15:47:44','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
UPDATE tp_system SET tgl_system='2025-11-03';