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 ('F326200956341','kasir','1',' TAB0 X DW ','TOKO','PT-B','B0TA-WEXI-93-T','GW X MRICAN POLOS DW ','','1.000','1','100.00','2140000','0','0','15000','2140000','0','0','0','2140000','AAT','T0044194','B0TA','0','0','-','0','2140000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B0TA-WEXI-93-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='B0TA-WEXI-93-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 ('F326200956341','2026-02-20','1.000','2026-02-20','09:56:34','PLG0027245','2140000','2140000','0','2140000','2140000','kasir','2026-02-20 09:56:34','F32620095634');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-20','F326200956341','2026-02-20','09:56:34','AAT','2140000','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-260220-0002','D','2026-02-20','09:56:34','kasir','PENJUALAN','F326200956341','2496487000','2140000','2498627000');
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 ('F326201041211','input','1',' MEH1 X UB ','TOKO','PM-H','H1E-ZABC-116-0','KL X GUCCI ANAK UB 34 8K ','','1.910','1','100.00','2368000','0','0','15000','2368000','0','0','0','2368000','FIT','00386746','H1E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZABC-116-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.910',berat_jual_asli=berat_jual_asli+'1.910',stock_jual='1',berat_akhir=berat_akhir-'1.910',berat_akhir_asli=berat_akhir_asli-'1.910',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='H1E-ZABC-116-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 ('F326201041211','2026-02-20','1.910','2026-02-20','10:41:22','PLG0027246','2368000','2368000','0','2368000','2368000','input','2026-02-20 10:41:21','F32620104121');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-20','F326201041211','2026-02-20','10:41:22','FIT','2368000','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-260220-0003','D','2026-02-20','10:41:22','input','PENJUALAN','F326201041211','2498627000','2368000','2500995000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2368000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326201041211' 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 ('F326201041212','input',' 1',' MEF1 TD 42','TOKO','PM-F','F1E-YCXE-273-0','GL BANGKOK C ANAK SLEP TD 42 8K ','','2.030','1','100.00','2517000','0','0','15000','2517000','0','0','0','2517000','FIT','00342078','F1E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YCXE-273-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='F1E-YCXE-273-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 ('F326201041212','2026-02-20','2.030','2026-02-20','10:41:22','PLG0027247','2517000','2517000','0','2517000','2517000','input','2026-02-20 10:41:21','F32620104121');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-20','F326201041212','2026-02-20','10:41:22','FIT','2517000','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-260220-0004','D','2026-02-20','10:41:22','input','PENJUALAN','F326201041212','2500995000','2517000','2503512000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2517000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326201041212' 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 ('F326201045241','input','1',' TFE8 X KH ','TOKO','PT-E','E8TF-WHAB-102-T','CC X MODEL BUNGA SLEP KH SI 10','','1.530','1','100.00','3442000','0','0','15000','3443000','0','0','0','3443000','FIT','T0047403','E8TF','0','0','-','0','2250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E8TF-WHAB-102-T' 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='2026-02-20' AND kode_barang='E8TF-WHAB-102-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 ('F326201045241','2026-02-20','1.530','2026-02-20','10:45:24','PLG0027248','3443000','3443000','0','3443000','3443000','input','2026-02-20 10:45:24','F32620104524');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-20','F326201045241','2026-02-20','10:45:24','FIT','3443000','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-260220-0005','D','2026-02-20','10:45:24','input','PENJUALAN','F326201045241','2503512000','3443000','2506955000');
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 ('F326201057291','input','1',' MEF3 LT ','TOKO','PM-F','F3E-ZBAI-287-0','GL TRIXIE BUNGA CLOVER SLEP LT 8K ','','1.480','1','100.00','1850000','0','0','15000','1835000','0','0','0','1835000','FIT','00390959','F3E','0','0','-','1','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAI-287-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.480',berat_jual_asli=berat_jual_asli+'1.480',stock_jual='1',berat_akhir=berat_akhir-'1.480',berat_akhir_asli=berat_akhir_asli-'1.480',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='F3E-ZBAI-287-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 ('F326201057291','2026-02-20','1.480','2026-02-20','10:57:30','PLG0027249','1835000','1835000','0','1835000','1835000','input','2026-02-20 10:57:29','F32620105729');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-20','F326201057291','2026-02-20','10:57:30','FIT','1835000','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-260220-0006','D','2026-02-20','10:57:30','input','PENJUALAN','F326201057291','2506955000','1835000','2508790000');
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 ('F326201059201','input','1',' MEF3E HW ','TOKO','PM-F','F3E-ZBAD-4-0','GL TIFF SLEP VAR HW 8K ','','1.270','1','100.00','1575000','0','0','15000','1575000','0','0','0','1575000','SIN','00389610','F3E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAD-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.270',berat_jual_asli=berat_jual_asli+'1.270',stock_jual='1',berat_akhir=berat_akhir-'1.270',berat_akhir_asli=berat_akhir_asli-'1.270',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='F3E-ZBAD-4-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 ('F326201059201','2026-02-20','1.270','2026-02-20','10:59:21','PLG0027250','1575000','1575000','0','1575000','1575000','input','2026-02-20 10:59:20','F32620105920');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-20','F326201059201','2026-02-20','10:59:21','SIN','1575000','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-260220-0007','D','2026-02-20','10:59:21','input','PENJUALAN','F326201059201','2508790000','1575000','2510365000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1575000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326201059201' 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 ('F326201059202','input',' 1',' MEF3 UB ','TOKO','PM-F','F3E-ZACX-223-0','GL MODEL GENIA UB 8K ','','0.480','1','100.00','595000','0','0','15000','595000','0','0','0','595000','SIN','00387524','F3E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZACX-223-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='F3E-ZACX-223-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 ('F326201059202','2026-02-20','0.480','2026-02-20','10:59:21','PLG0027251','595000','595000','0','595000','595000','input','2026-02-20 10:59:20','F32620105920');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-20','F326201059202','2026-02-20','10:59:21','SIN','595000','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-260220-0008','D','2026-02-20','10:59:21','input','PENJUALAN','F326201059202','2510365000','595000','2510960000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='595000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326201059202' 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 ('F326201156321','input','1',' MDA1 HW ','TOKO','PM-A','A1D-ZBAF-311-0','AT MODEL BOLA ARESO VAR HW 8K ','','0.850','1','100.00','1037000','0','0','15000','1037000','0','0','0','1037000','FIT','00390284','A1D','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZBAF-311-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='A1D-ZBAF-311-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 ('F326201156321','2026-02-20','0.850','2026-02-20','11:56:32','PLG0027252','1037000','1037000','0','1037000','1037000','input','2026-02-20 11:56:32','F32620115632');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-20','F326201156321','2026-02-20','11:56:32','FIT','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-260220-0009','D','2026-02-20','11:56:32','input','PENJUALAN','F326201156321','2510960000','1037000','2511997000','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='F326201156321' 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 ('F326201156322','input',' 1',' MEE1 LG 9 ','TOKO','PM-E','E1E-ZAXH-127-T','CC MODEL DAUN LG 9 8K ','','0.410','1','100.00','508000','0','0','15000','508000','0','0','0','508000','FIT','T0076450','E1E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZAXH-127-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='E1E-ZAXH-127-T' 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 ('F326201156322','2026-02-20','0.410','2026-02-20','11:56:32','PLG0027253','508000','508000','0','508000','508000','input','2026-02-20 11:56:32','F32620115632');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-20','F326201156322','2026-02-20','11:56:32','FIT','508000','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-260220-0010','D','2026-02-20','11:56:32','input','PENJUALAN','F326201156322','2511997000','508000','2512505000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='508000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326201156322' 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 ('F326201251421','input','1',' MEF3E X HW','TOKO','PM-F','F3E-YKXD-100-0','GL X RANTAI HOLLOW MATA VAR HW 8K ','','3.920','1','100.00','4861000','0','0','15000','4860000','0','0','0','4860000','AAT','00376636','F3E','0','0','-','1','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKXD-100-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.920',berat_jual_asli=berat_jual_asli+'3.920',stock_jual='1',berat_akhir=berat_akhir-'3.920',berat_akhir_asli=berat_akhir_asli-'3.920',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='F3E-YKXD-100-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 ('F326201251421','2026-02-20','3.920','2026-02-20','12:51:43','PLG0027254','4860000','4860000','0','4860000','4860000','input','2026-02-20 12:51:42','F32620125142');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-20','F326201251421','2026-02-20','12:51:43','AAT','4860000','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-260220-0011','D','2026-02-20','12:51:43','input','PENJUALAN','F326201251421','2512505000','4860000','2517365000');
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 ('F326200123441','input','1',' MGB1 LG ','TOKO','PM-B','B1G-ZACX-216-0','GW TOGE MODEL MRICAN POLOS LG 8K ','','0.280','1','100.00','358000','0','0','15000','358000','0','0','0','358000','FIT','00387517','B1G','0','0','-','0','1290000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZACX-216-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.280',berat_jual_asli=berat_jual_asli+'0.280',stock_jual='1',berat_akhir=berat_akhir-'0.280',berat_akhir_asli=berat_akhir_asli-'0.280',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='B1G-ZACX-216-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 ('F326200123441','2026-02-20','0.280','2026-02-20','13:23:44','PLG0027255','358000','358000','0','358000','358000','input','2026-02-20 13:23:44','F32620012344');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-20','F326200123441','2026-02-20','13:23:44','FIT','358000','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-260220-0012','D','2026-02-20','13:23:44','input','PENJUALAN','F326200123441','2517365000','358000','2517723000');
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-00018254','X-00018254','GW TUSUK MRICAN SLEP HK 8K','GR','---','B1H','BELI','BELI001','300000','2026-02-20','0.260','1','kasir','2026-02-20 13:27:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1H';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1H','X-00018254','X-00018254');
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-260220-0001','F326171233461','FIT','1','BELI','BELI001','B1H', 'X-00018254', 'GW TUSUK MRICAN SLEP HK 8K','0.260','0.260','100.00','338000','300000','1153846','1300000','1','300000','300000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.260',berat_beli_asli=berat_beli_asli+'0.260',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.260',berat_akhir_asli=berat_akhir_asli+'0.260',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1H' 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-260220-0001','2026-02-20','2026-02-20','13:27:42','FIT','---','0.260','300000','300000','300000','300000','300000','kasir','2026-02-20 13:27:43','FB-260220-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260220-0001','RAYA','BULUKERTO','','','','kasir','2026-02-20 13:27:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-20' 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-260220-0013','K','2026-02-20','13:27:42','kasir','PEMBELIAN UMUM','FB-260220-0001','2517723000','300000','2517423000');
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-00018255','X-00018255','KL X SANTA SEMI UB 56 9K','GR','---','H2I','BELI','BELI001','5020000','2026-02-20','5.000','1','kasir','2026-02-20 13:31:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00018255','X-00018255');
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-260220-0002','F325100833521','SIN','1','BELI','BELI001','H2I', 'X-00018255', 'KL X SANTA SEMI UB 56 9K','5.000','5.000','100.00','5400000','5020000','1004000','1320000','1','5020000','5020000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.000',berat_beli_asli=berat_beli_asli+'5.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.000',berat_akhir_asli=berat_akhir_asli+'5.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2I' 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-260220-0002','2026-02-20','2026-02-20','13:31:10','SIN','---','5.000','5020000','5020000','5020000','5020000','5020000','kasir','2026-02-20 13:31:10','FB-260220-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260220-0002','SULASTRI','SUKOHARJO','','','','kasir','2026-02-20 13:31:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-20' 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-260220-0014','K','2026-02-20','13:31:10','kasir','PEMBELIAN UMUM','FB-260220-0002','2517423000','5020000','2512403000');
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-00018256','X-00018256','LT X MODEL HURUF MATA MJ A','GR','---','D2TE','BELI','BELI001','2080000','2026-02-20','1.250','1','kasir','2026-02-20 13:31:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2TE','X-00018256','X-00018256');
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-260220-0003','F325100833523','SIN','1','BELI','BELI001','D2TE', 'X-00018256', 'LT X MODEL HURUF MATA MJ A','1.250','1.250','100.00','2213000','2080000','1664000','2230000','1','2080000','2080000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.250',berat_beli_asli=berat_beli_asli+'1.250',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.250',berat_akhir_asli=berat_akhir_asli+'1.250',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2TE' 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-260220-0003','2026-02-20','2026-02-20','13:31:33','SIN','---','1.250','2080000','2080000','2080000','2080000','2080000','kasir','2026-02-20 13:31:33','FB-260220-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260220-0003','SULASTRI','SUKOHARJO','','','','kasir','2026-02-20 13:31:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-20' 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-260220-0015','K','2026-02-20','13:31:33','kasir','PEMBELIAN UMUM','FB-260220-0003','2512403000','2080000','2510323000');
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-00018257','X-00018257','KL SANTA KH 42 8K','GR','---','H1E','BELI','BELI001','2382000','2026-02-20','2.050','1','kasir','2026-02-20 13:32:15');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00018257','X-00018257');
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-260220-0004','F326111226251','AAT','1','BELI','BELI001','H1E', 'X-00018257', 'KL SANTA KH 42 8K','2.050','2.050','100.00','2585000','2382000','1161951','1250000','1','2382000','2382000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.050',berat_beli_asli=berat_beli_asli+'2.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.050',berat_akhir_asli=berat_akhir_asli+'2.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' 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-260220-0004','2026-02-20','2026-02-20','13:32:14','AAT','---','2.050','2382000','2382000','2382000','2382000','2382000','kasir','2026-02-20 13:32:15','FB-260220-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260220-0004','SITI','SLOGOHIMO','','','','kasir','2026-02-20 13:32:15');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-20' 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-260220-0016','K','2026-02-20','13:32:14','kasir','PEMBELIAN UMUM','FB-260220-0004','2510323000','2382000','2507941000');
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 ('F326200152481','kasir','1',' MEA1E X LG','TOKO','PM-A','A1E-YLAF-114-0','AT X GYPSY ANAK SLEP LG 8K ','','0.500','1','100.00','620000','0','0','15000','620000','0','0','0','620000','FIT','00381298','A1E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLAF-114-0' 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='2026-02-20' AND kode_barang='A1E-YLAF-114-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 ('F326200152481','2026-02-20','0.500','2026-02-20','13:52:48','PLG0027256','620000','620000','0','620000','620000','kasir','2026-02-20 13:52:48','F32620015248');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-20','F326200152481','2026-02-20','13:52:48','FIT','620000','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-260220-0017','D','2026-02-20','13:52:48','kasir','PENJUALAN','F326200152481','2507941000','620000','2508561000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='620000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326200152481' 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 ('F326200152482','kasir',' 1',' MEA1 5K CM','TOKO','PM-A','A1E-ZBAF-272-0','AT ANAK BONEKA CAT VAR CM 8K ','','0.500','1','100.00','620000','0','0','15000','620000','0','5000','0','625000','FIT','00390244','A1E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZBAF-272-0' 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='2026-02-20' AND kode_barang='A1E-ZBAF-272-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 ('F326200152482','2026-02-20','0.500','2026-02-20','13:52:48','PLG0027257','620000','620000','5000','625000','625000','kasir','2026-02-20 13:52:48','F32620015248');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-20','F326200152482','2026-02-20','13:52:48','FIT','625000','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-260220-0018','D','2026-02-20','13:52:48','kasir','PENJUALAN','F326200152482','2508561000','625000','2509186000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='625000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326200152482' 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 ('F326200244191','kasir','1',' MEE2 X CM ','TOKO','PM-E','E2E-ZBXF-125-0','CC X LISTERING MATA CM 16 8K ','','0.760','1','100.00','942000','0','0','15000','943000','0','0','0','943000','FIT','00388707','E2E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZBXF-125-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.760',berat_jual_asli=berat_jual_asli+'0.760',stock_jual='1',berat_akhir=berat_akhir-'0.760',berat_akhir_asli=berat_akhir_asli-'0.760',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='E2E-ZBXF-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 ('F326200244191','2026-02-20','0.760','2026-02-20','14:44:19','PLG0027258','943000','943000','0','943000','943000','kasir','2026-02-20 14:44:19','F32620024419');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-20','F326200244191','2026-02-20','14:44:19','FIT','943000','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-260220-0019','D','2026-02-20','14:44:19','kasir','PENJUALAN','F326200244191','2509186000','943000','2510129000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260220-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260220-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260220-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260220-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260220-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260220-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260220-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260220-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200123441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200123441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200123441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200152481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200152481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200152481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200152482' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200152482' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200152482';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200244191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200244191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200244191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200956341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200956341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200956341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201041211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201041211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201041211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201041212' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201041212' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201041212';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201045241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201045241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201045241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201057291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201057291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201057291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201059201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201059201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201059201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201059202' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201059202' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201059202';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201156321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201156321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201156321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201156322' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201156322' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201156322';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201251421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201251421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201251421';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-21','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-21';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-20';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-20';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-02-20' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-20';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-20';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-20';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-20';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202601 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
UPDATE tt_barang_saldo SET tanggal= '2026-02-21' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-20' 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-260221-0001','D','2026-02-21','15:21:22','SYSTEM','SALDO AWAL','SALDO AWAL','0','2510129000','2510129000');
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-260221-0001','D','2026-02-21','15:21:22','BCA','SALDO AWAL','SALDO AWAL','0','707186000','707186000');
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-260221-0001','D','2026-02-21','15:21:22','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-260221-0001','D','2026-02-21','15:21:22','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-02-21';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260221-0001','1','D1E-ZBBX-28-0','1','0.610','0.610','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-ZBBX-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZBBX-28-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-02-21 16:38:12' WHERE kode_barang='D1E-ZBBX-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZBBX-28-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-21 16:38:12','TOKO','PM-D','D1E','D1E-ZBBX-28-0','1','0.610','0.610','1','0.610','0.610','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1E-ZBBX-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZBBX-28-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260221-0001','1','D1E-ZBBX-30-0','1','0.620','0.620','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-ZBBX-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZBBX-30-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-02-21 16:38:12' WHERE kode_barang='D1E-ZBBX-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZBBX-30-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-21 16:38:12','TOKO','PM-D','D1E','D1E-ZBBX-30-0','1','0.620','0.620','1','0.620','0.620','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1E-ZBBX-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZBBX-30-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260221-0001','2026-02-21','16:38','1.230','admpindah','2026-02-20 16:38:12');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260221-0001','1','F3E-ZAAE-58-0','1','1.620','1.620','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZAAE-58-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZAAE-58-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-02-21 16:38:32' WHERE kode_barang='F3E-ZAAE-58-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZAAE-58-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-21 16:38:32','TOKO','PM-F','F3E','F3E-ZAAE-58-0','1','1.620','1.620','1','1.620','1.620','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZAAE-58-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZAAE-58-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260221-0001','2026-02-21','16:38','1.620','admpindah','2026-02-20 16:38:31');