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 ('F226200828121','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-YLXE-39-T','GL LEMES TIFFANY VAR HW 8K ','','1.950','1','100.00','2428000','0','0','15000','2438000','0','0','0','2438000','RTA','T0075566','F3E','0','0','-','0','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLXE-39-T' 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='2026-02-20' AND kode_barang='F3E-YLXE-39-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200828121','2026-02-20','1.950','2026-02-20','08:28:12','PLG0077431','2438000','2438000','0','2438000','0','kasir','2026-02-20 08:28:12','F22620082812');
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','F226200828121','2026-02-20','08:28:12','RTA','2438000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260220-0001','2026-02-20','2026-02-20 08:28:12','PENJUALAN : F226200828121','9808987877667','BCA','2438000','2438000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260220-0002','D','2026-02-20','08:28:12','BCA','PENJUALAN','F226200828121','4278207888','2438000','4280645888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('9808987877667','LEONA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2438000' WHERE no_faktur_jual='F226200828121' 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 ('F226200828561','kasir','1',' MEE2 HTM 1','TOKO','SMBK-E','E2E-ZBAH-65-T','CC PIPA MODEL PITA MATA VAR HTM 15 8K ','','0.540','1','100.00','672000','0','0','15000','675000','0','0','0','675000','RTA','T0077510','E2E','0','0','-','0','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZBAH-65-T' 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='2026-02-20' AND kode_barang='E2E-ZBAH-65-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200828561','2026-02-20','0.540','2026-02-20','08:28:57','PLG0077432','675000','675000','0','675000','0','kasir','2026-02-20 08:28:56','F22620082856');
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','F226200828561','2026-02-20','08:28:57','RTA','675000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260220-0002','2026-02-20','2026-02-20 08:28:56','PENJUALAN : F226200828561','88776656565','BCA','675000','675000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260220-0003','D','2026-02-20','08:28:57','BCA','PENJUALAN','F226200828561','4280645888','675000','4281320888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('88776656565','LEONA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='675000' WHERE no_faktur_jual='F226200828561' 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 ('F226200835191','kasir','1',' MDA1 CM ','TOKO','SMBK-A','A1D-ZBAD-85-T','AT KLIP MODEL DAUN VAR CM 8K ','','1.040','1','100.00','1274000','0','0','15000','1280000','0','0','0','1280000','NS','T0077374','A1D','0','0','-','0','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZBAD-85-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.040',berat_jual_asli=berat_jual_asli+'1.040',stock_jual='1',berat_akhir=berat_akhir-'1.040',berat_akhir_asli=berat_akhir_asli-'1.040',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='A1D-ZBAD-85-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200835191','2026-02-20','1.040','2026-02-20','08:35:20','PLG0077433','1280000','1280000','0','1280000','1280000','kasir','2026-02-20 08:35:19','F22620083519');
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','F226200835191','2026-02-20','08:35:20','NS','1280000','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','08:35:20','kasir','PENJUALAN','F226200835191','6178384000','1280000','6179664000');
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 ('F226200915181','kasir','1',' MEB1E 5K H','TOKO','SMBK-B','B1E-ZBAC-63-T','GW TIFF CAT VAR HW 8K ','','0.550','1','100.00','685000','0','0','15000','688000','0','5000','0','693000','RTA','T0077272','B1E','0','0','-','0','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZBAC-63-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='B1E-ZBAC-63-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200915181','2026-02-20','0.550','2026-02-20','09:15:18','PLG0077434','688000','688000','5000','693000','693000','kasir','2026-02-20 09:15:18','F22620091518');
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','F226200915181','2026-02-20','09:15:18','RTA','693000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260220-0003','D','2026-02-20','09:15:18','kasir','PENJUALAN','F226200915181','6179664000','693000','6180357000');
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 ('F226200945451','kasir','1',' MEE1E CM 1','TOKO','SMBK-E','E1E-YLBX-41-T','CC MODEL SLEP CM 12 8K ','','0.680','1','100.00','847000','0','0','15000','850000','0','0','0','850000','NS','T0076026','E1E','0','0','-','0','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YLBX-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='E1E-YLBX-41-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200945451','2026-02-20','0.680','2026-02-20','09:45:45','PLG0077435','850000','850000','0','850000','850000','kasir','2026-02-20 09:45:45','F22620094545');
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','F226200945451','2026-02-20','09:45:45','NS','850000','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-0004','D','2026-02-20','09:45:45','kasir','PENJUALAN','F226200945451','6180357000','850000','6181207000');
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 ('F226201006501','kasir','1',' MED1 HW ','TOKO','SMBK-D','D1E-ZBAI-45-T','LT LETTERA PANJANG HW 8K ','OL','0.730','1','100.00','894000','0','0','15000','920000','0','5000','0','925000','RTA','T0077577','D1E','0','0','-','0','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZBAI-45-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.730',berat_jual_asli=berat_jual_asli+'0.730',stock_jual='1',berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='D1E-ZBAI-45-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226201006501','2026-02-20','0.730','2026-02-20','10:06:50','PLG0077436','920000','920000','5000','925000','925000','kasir','2026-02-20 10:06:50','F22620100650');
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','F226201006501','2026-02-20','10:06:50','RTA','925000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260220-0005','D','2026-02-20','10:06:50','kasir','PENJUALAN','F226201006501','6181207000','925000','6182132000');
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 ('F226201023431','kasir','1',' MEF2 UB D5','TOKO','SMBK-F','F2E-ZBAX-42-T','GL OVAL MODEL PAKU MATA VAR UB D56 8K ','OLS HCNFJ','2.450','1','100.00','3050000','0','0','15000','3063000','0','290000','0','3353000','RHM','T0077157','F2E','0','0','-','0','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZBAX-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.450',berat_jual_asli=berat_jual_asli+'2.450',stock_jual='1',berat_akhir=berat_akhir-'2.450',berat_akhir_asli=berat_akhir_asli-'2.450',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='F2E-ZBAX-42-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226201023431','2026-02-20','2.450','2026-02-20','10:23:43','PLG0077437','3063000','3063000','290000','3353000','3353000','kasir','2026-02-20 10:23:43','F22620102343');
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','F226201023431','2026-02-20','10:23:43','RHM','3353000','290000');
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:23:43','kasir','PENJUALAN','F226201023431','6182132000','3353000','6185485000');
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 ('F226201024451','kasir','1',' MIF4 KH ','TOKO','SMBK-F','F4I-WFBI-10-T','GL SANTA VAR KLINTING KH ','OLS 5RMU0','3.010','1','100.00','3988000','0','0','15000','4003000','0','213000','0','4216000','RHM','T0045687','F4I','0','0','-','0','1325000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F4I-WFBI-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.010',berat_jual_asli=berat_jual_asli+'3.010',stock_jual='1',berat_akhir=berat_akhir-'3.010',berat_akhir_asli=berat_akhir_asli-'3.010',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='F4I-WFBI-10-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226201024451','2026-02-20','3.010','2026-02-20','10:24:45','PLG0077438','4003000','4003000','213000','4216000','4216000','kasir','2026-02-20 10:24:45','F22620102445');
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','F226201024451','2026-02-20','10:24:45','RHM','4216000','213000');
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-0007','D','2026-02-20','10:24:45','kasir','PENJUALAN','F226201024451','6185485000','4216000','6189701000');
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 ('F226201029421','kasir','1',' MFD1 8K BG','TOKO','SMBK-D','D1F-ZBAH-45-T','LT MODEL BUNGA PASIR VAR BG 8K ','OL','1.110','1','100.00','1404000','0','0','15000','1418000','0','8000','0','1426000','TIN','T0077490','D1F','0','0','-','0','1265000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZBAH-45-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.110',berat_jual_asli=berat_jual_asli+'1.110',stock_jual='1',berat_akhir=berat_akhir-'1.110',berat_akhir_asli=berat_akhir_asli-'1.110',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='D1F-ZBAH-45-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226201029421','2026-02-20','1.110','2026-02-20','10:29:42','PLG0077439','1418000','1418000','8000','1426000','1426000','kasir','2026-02-20 10:29:42','F22620102942');
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','F226201029421','2026-02-20','10:29:42','TIN','1426000','8000');
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:29:42','kasir','PENJUALAN','F226201029421','6189701000','1426000','6191127000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1426000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201029421' 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 ('F226201029422','kasir',' 1',' MFD1 8K BG','TOKO','SMBK-D','D1F-ZBAH-44-T','LT MODEL BUNGA PASIR VAR BG 8K ','OL','1.140','1','100.00','1442000','0','0','15000','1457000','0','8000','0','1465000','TIN','T0077489','D1F','0','0','-','0','1265000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZBAH-44-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.140',berat_jual_asli=berat_jual_asli+'1.140',stock_jual='1',berat_akhir=berat_akhir-'1.140',berat_akhir_asli=berat_akhir_asli-'1.140',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='D1F-ZBAH-44-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226201029422','2026-02-20','1.140','2026-02-20','10:29:42','PLG0077440','1457000','1457000','8000','1465000','1465000','kasir','2026-02-20 10:29:42','F22620102942');
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','F226201029422','2026-02-20','10:29:42','TIN','1465000','8000');
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','10:29:42','kasir','PENJUALAN','F226201029422','6191127000','1465000','6192592000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1465000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201029422' 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 ('F226201105501','kasir','1',' MDE1 CM 14','TOKO','SMBK-E','E1D-ZBAI-29-T','CC MODEL DAUN VAR CM 14 8K ','','0.850','1','100.00','1041000','0','0','15000','1046000','0','0','0','1046000','TIN','T0077561','E1D','0','0','-','0','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZBAI-29-T' 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='E1D-ZBAI-29-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226201105501','2026-02-20','0.850','2026-02-20','11:05:51','PLG0077441','1046000','1046000','0','1046000','1046000','kasir','2026-02-20 11:05:50','F22620110550');
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','F226201105501','2026-02-20','11:05:51','TIN','1046000','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-0010','D','2026-02-20','11:05:51','kasir','PENJUALAN','F226201105501','6192592000','1046000','6193638000');
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 ('F226201132041','kasir','1',' MEB1 CM S ','TOKO','SMBK-B','B1E-ZBAI-77-T','GW ITALY PANJANG ALPHABET CM S 8K ','OL','0.580','1','100.00','710000','0','0','15000','732000','0','5000','0','737000','TIN','T0077609','B1E','0','0','-','0','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZBAI-77-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='B1E-ZBAI-77-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226201132041','2026-02-20','0.580','2026-02-20','11:32:04','PLG0077442','732000','732000','5000','737000','737000','kasir','2026-02-20 11:32:04','F22620113204');
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','F226201132041','2026-02-20','11:32:04','TIN','737000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260220-0011','D','2026-02-20','11:32:04','kasir','PENJUALAN','F226201132041','6193638000','737000','6194375000');
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 ('F226201202541','kasir','1',' MFD1F X BG','TOKO','SMBK-D','D1F-YGBD-28-0','LT X SLOBOK HURUF BULAT BG I 8K ','OLS WJ01Q','0.500','1','100.00','632000','0','0','15000','645000','0','90000','0','735000','RHM','00362266','D1F','0','0','-','0','1265000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YGBD-28-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='D1F-YGBD-28-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226201202541','2026-02-20','0.500','2026-02-20','12:02:54','PLG0077443','645000','645000','90000','735000','735000','kasir','2026-02-20 12:02:54','F22620120254');
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','F226201202541','2026-02-20','12:02:54','RHM','735000','90000');
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','12:02:54','kasir','PENJUALAN','F226201202541','6194375000','735000','6195110000');
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 ('F226201206461','kasir','1',' MEF1 10K Y','TOKO','SMBK-F','F1E-YJXB-6-T','GL ANAK OSROT BONEKA CAT YT 8K ','','1.460','1','100.00','1818000','0','0','15000','1825000','0','10000','0','1835000','RTA','T0073586','F1E','0','0','-','0','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YJXB-6-T' 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='2026-02-20' AND kode_barang='F1E-YJXB-6-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226201206461','2026-02-20','1.460','2026-02-20','12:06:46','PLG0077444','1825000','1825000','10000','1835000','1835000','kasir','2026-02-20 12:06:46','F22620120646');
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','F226201206461','2026-02-20','12:06:46','RTA','1835000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260220-0013','D','2026-02-20','12:06:46','kasir','PENJUALAN','F226201206461','6195110000','1835000','6196945000');
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 ('F226201234011','kasir','1',' MEE2E CM 1','TOKO','SMBK-E','E2E-ZBAC-41-T','CC WEDDING MATA CM 14 8K ','ol','1.100','1','100.00','1369000','0','0','15000','1380000','0','6000','0','1386000','TIN','T0077250','E2E','0','0','-','0','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZBAC-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='E2E-ZBAC-41-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226201234011','2026-02-20','1.100','2026-02-20','12:34:01','PLG0077445','1380000','1380000','6000','1386000','1386000','kasir','2026-02-20 12:34:01','F22620123401');
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','F226201234011','2026-02-20','12:34:01','TIN','1386000','6000');
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-0014','D','2026-02-20','12:34:01','kasir','PENJUALAN','F226201234011','6196945000','1386000','6198331000');
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 ('F226201234501','kasir','1',' TEF3 HW ','TOKO','TBK-F','F3TE-YJBH-72-T','GL MODEL FLIK CAPELA VAR HW 17K ','ol','1.830','1','100.00','4099000','0','0','15000','4114000','0','13000','0','4127000','TIN','T0074554','F3TE','0','0','-','0','2240000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YJBH-72-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.830',berat_jual_asli=berat_jual_asli+'1.830',stock_jual='1',berat_akhir=berat_akhir-'1.830',berat_akhir_asli=berat_akhir_asli-'1.830',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='F3TE-YJBH-72-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226201234501','2026-02-20','1.830','2026-02-20','12:34:50','PLG0077446','4114000','4114000','13000','4127000','4127000','kasir','2026-02-20 12:34:50','F22620123450');
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','F226201234501','2026-02-20','12:34:50','TIN','4127000','13000');
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-0015','D','2026-02-20','12:34:50','kasir','PENJUALAN','F226201234501','6198331000','4127000','6202458000');
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 ('F226200122211','Nagatech','1',' MEB1E 5K H','TOKO','SMBK-B','B1E-ZBAC-62-T','GW TIFF CAT VAR HW 8K ','ol','0.530','1','100.00','660000','0','0','15000','670000','0','5000','0','675000','TIN','T0077271','B1E','0','0','-','0','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZBAC-62-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='B1E-ZBAC-62-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200122211','2026-02-20','0.530','2026-02-20','13:22:21','PLG0077447','670000','670000','5000','675000','675000','Nagatech','2026-02-20 13:22:21','F22620012221');
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','F226200122211','2026-02-20','13:22:21','TIN','675000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260220-0016','D','2026-02-20','13:22:21','Nagatech','PENJUALAN','F226200122211','6202458000','675000','6203133000');
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 ('F226200123341','Nagatech','1',' MEE2 X YT ','TOKO','SMBK-E','E2D-ZAXI-401-0','CC X MODEL MATA YT 20 8K','ol','0.770','1','100.00','943000','0','0','15000','970000','0','5000','0','975000','RTA','00384778','E2D','0','0','-','0','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZAXI-401-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='2026-02-20' AND kode_barang='E2D-ZAXI-401-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200123341','2026-02-20','0.770','2026-02-20','13:23:34','PLG0077448','970000','970000','5000','975000','975000','Nagatech','2026-02-20 13:23:34','F22620012334');
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','F226200123341','2026-02-20','13:23:34','RTA','975000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260220-0017','D','2026-02-20','13:23:34','Nagatech','PENJUALAN','F226200123341','6203133000','975000','6204108000');
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 ('F226200132101','kasir','1',' MEE1 CM 15','TOKO','SMBK-E','E1E-ZACA-13-T','CC MODEL RANTAI SLEP CM 15 8K ','','0.600','1','100.00','747000','0','0','15000','750000','0','0','0','750000','NS','T0077067','E1E','0','0','-','0','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZACA-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='E1E-ZACA-13-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200132101','2026-02-20','0.600','2026-02-20','13:32:10','PLG0077449','750000','750000','0','750000','750000','kasir','2026-02-20 13:32:10','F22620013210');
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','F226200132101','2026-02-20','13:32:10','NS','750000','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-0018','D','2026-02-20','13:32:10','kasir','PENJUALAN','F226200132101','6204108000','750000','6204858000');
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 ('F226200138091','kasir','1',' MEF3 LT ','TOKO','SMBK-F','F3E-ZBAI-96-T','GL RANTAI HOLLOW P3 SLEP LT 8K ','OL','1.070','1','100.00','1311000','0','0','15000','1343000','0','5000','0','1348000','RTA','T0077628','F3E','0','0','-','0','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAI-96-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='F3E-ZBAI-96-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200138091','2026-02-20','1.070','2026-02-20','13:38:10','PLG0077450','1343000','1343000','5000','1348000','1348000','kasir','2026-02-20 13:38:09','F22620013809');
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','F226200138091','2026-02-20','13:38:10','RTA','1348000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260220-0019','D','2026-02-20','13:38:10','kasir','PENJUALAN','F226200138091','6204858000','1348000','6206206000');
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-20260220-0001','1','F3E-ZBXI-57-0','1','4.580','4.580','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZBXI-57-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZBXI-57-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-02-20 13:42:49' WHERE kode_barang='F3E-ZBXI-57-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZBXI-57-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-20 13:42:49','TOKO','SMBK-F','F3E','F3E-ZBXI-57-0','1','4.580','4.580','1','4.580','4.580','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-ZBXI-57-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZBXI-57-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260220-0001','2026-02-20','13:42','4.580','input','2026-02-20 13:42:48');
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 ('F226200221421','Nagatech','1',' MDA1D X UB','TOKO','SMBK-A','A1D-ZBAA-74-0','AT X ITALY SLEP VAR UB 8K ','','1.030','1','100.00','1262000','0','0','15000','1267000','0','0','0','1267000','TIN','00389220','A1D','0','0','-','0','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZBAA-74-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='2026-02-20' AND kode_barang='A1D-ZBAA-74-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200221421','2026-02-20','1.030','2026-02-20','14:21:43','PLG0077451','1267000','1267000','0','1267000','1267000','Nagatech','2026-02-20 14:21:42','F22620022142');
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','F226200221421','2026-02-20','14:21:43','TIN','1267000','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-0020','D','2026-02-20','14:21:43','Nagatech','PENJUALAN','F226200221421','6206206000','1267000','6207473000');
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 ('F226200232301','Nagatech','1',' MEF3E MT ','TOKO','SMBK-F','F3E-ZBXI-57-0','GL KREPYAK HARLEY SLEP MT 8K ','OLS T91Q9','4.580','1','100.00','5725000','0','0','15000','5725000','0','475000','0','6200000','RHM','00388900','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-ZBXI-57-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.580',berat_jual_asli=berat_jual_asli+'4.580',stock_jual='1',berat_akhir=berat_akhir-'4.580',berat_akhir_asli=berat_akhir_asli-'4.580',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='F3E-ZBXI-57-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200232301','2026-02-20','4.580','2026-02-20','14:32:30','PLG0077452','5725000','5725000','475000','6200000','6200000','Nagatech','2026-02-20 14:32:30','F22620023230');
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','F226200232301','2026-02-20','14:32:30','RHM','6200000','475000');
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-0021','D','2026-02-20','14:32:30','Nagatech','PENJUALAN','F226200232301','6207473000','6200000','6213673000');
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 ('F226200240321','Nagatech','1',' TEF3 X LT ','TOKO','TBK-F','F3TE-YLBF-49-T','GL X RANTAI HOLLOW P4 SLEP LT 17K ','OL','3.950','1','100.00','8848000','0','0','15000','8860000','0','28000','0','8888000','NS','T0076219','F3TE','0','0','-','0','2240000');
UPDATE tm_barang SET tgl_last_jual='2026-02-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YLBF-49-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.950',berat_jual_asli=berat_jual_asli+'3.950',stock_jual='1',berat_akhir=berat_akhir-'3.950',berat_akhir_asli=berat_akhir_asli-'3.950',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='F3TE-YLBF-49-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200240321','2026-02-20','3.950','2026-02-20','14:40:32','PLG0077453','8860000','8860000','28000','8888000','8888000','Nagatech','2026-02-20 14:40:32','F22620024032');
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','F226200240321','2026-02-20','14:40:32','NS','8888000','28000');
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-0022','D','2026-02-20','14:40:32','Nagatech','PENJUALAN','F226200240321','6213673000','8888000','6222561000');
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 ('F226200241561','Nagatech','1',' MEE1 5K UB','TOKO','SMBK-E','E1E-ZBAI-38-T','CC BANGKOK PASIR UB 15 8K ','OL','0.560','1','100.00','686000','0','0','15000','708000','0','5000','0','713000','NS','T0077570','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-ZBAI-38-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='E1E-ZBAI-38-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200241561','2026-02-20','0.560','2026-02-20','14:41:57','PLG0077454','708000','708000','5000','713000','713000','Nagatech','2026-02-20 14:41:56','F22620024156');
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','F226200241561','2026-02-20','14:41:57','NS','713000','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-0023','D','2026-02-20','14:41:57','Nagatech','PENJUALAN','F226200241561','6222561000','713000','6223274000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='713000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226200241561' 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 ('F226200241562','Nagatech',' 1',' MEE1 5K UB','TOKO','SMBK-E','E1E-ZBAI-39-T','CC BANGKOK PASIR UB 15 8K ','OL','0.560','1','100.00','686000','0','0','15000','708000','0','5000','0','713000','NS','T0077571','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-ZBAI-39-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='E1E-ZBAI-39-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200241562','2026-02-20','0.560','2026-02-20','14:41:57','PLG0077455','708000','708000','5000','713000','713000','Nagatech','2026-02-20 14:41:56','F22620024156');
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','F226200241562','2026-02-20','14:41:57','NS','713000','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-0024','D','2026-02-20','14:41:57','Nagatech','PENJUALAN','F226200241562','6223274000','713000','6223987000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='713000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226200241562' 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 ('F226200241563','Nagatech',' 1',' MEE1 5K UB','TOKO','SMBK-E','E1E-ZBAI-36-T','CC BANGKOK PASIR UB 13 8K ','OL','0.560','1','100.00','686000','0','0','15000','708000','0','5000','0','713000','NS','T0077568','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-ZBAI-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='E1E-ZBAI-36-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200241563','2026-02-20','0.560','2026-02-20','14:41:57','PLG0077456','708000','708000','5000','713000','713000','Nagatech','2026-02-20 14:41:56','F22620024156');
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','F226200241563','2026-02-20','14:41:57','NS','713000','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-0025','D','2026-02-20','14:41:57','Nagatech','PENJUALAN','F226200241563','6223987000','713000','6224700000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='713000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226200241563' 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 ('F226200241564','Nagatech',' 1',' MEE1 5K UB','TOKO','SMBK-E','E1E-ZBAI-37-T','CC BANGKOK PASIR UB 15 8K ','OL','0.550','1','100.00','674000','0','0','15000','696000','0','5000','0','701000','NS','T0077569','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-ZBAI-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='E1E-ZBAI-37-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200241564','2026-02-20','0.550','2026-02-20','14:41:57','PLG0077457','696000','696000','5000','701000','701000','Nagatech','2026-02-20 14:41:56','F22620024156');
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','F226200241564','2026-02-20','14:41:57','NS','701000','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-0026','D','2026-02-20','14:41:57','Nagatech','PENJUALAN','F226200241564','6224700000','701000','6225401000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='701000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226200241564' 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 ('F226200241565','Nagatech',' 1',' MEE1 5K UB','TOKO','SMBK-E','E1E-ZBAI-35-T','CC BANGKOK PASIR UB 13 8K ','OL','0.570','1','100.00','698000','0','0','15000','721000','0','5000','0','726000','NS','T0077567','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-ZBAI-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-02-20' AND kode_barang='E1E-ZBAI-35-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200241565','2026-02-20','0.570','2026-02-20','14:41:57','PLG0077458','721000','721000','5000','726000','726000','Nagatech','2026-02-20 14:41:56','F22620024156');
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','F226200241565','2026-02-20','14:41:57','NS','726000','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-0027','D','2026-02-20','14:41:57','Nagatech','PENJUALAN','F226200241565','6225401000','726000','6226127000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='726000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226200241565' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200122211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200122211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200122211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200123341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200123341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200123341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200132101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200132101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200132101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200138091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200138091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200138091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200221421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200221421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200221421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200232301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200232301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200232301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200240321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200240321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200240321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200241561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200241561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200241561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200241562' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200241562' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200241562';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200241563' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200241563' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200241563';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200241564' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200241564' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200241564';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200241565' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200241565' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200241565';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200828121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200828121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200828121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200828561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200828561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200828561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200835191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200835191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200835191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200915181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200915181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200915181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200945451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200945451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200945451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201006501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201006501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201006501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201023431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201023431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201023431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201024451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201024451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201024451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201029421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201029421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201029421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201029422' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201029422' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201029422';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201105501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201105501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201105501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201132041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201132041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201132041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201202541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201202541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201202541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201206461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201206461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201206461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201234011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201234011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201234011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201234501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201234501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201234501';
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-00005112','X-00005112','AT MODEL TETES ARESO UB 8K','GR','---','A1F','BELI','BELI001','596000','2026-02-20','0.670','1','kasir','2026-02-20 15:39:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00005112','X-00005112');
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','F225081126311','RTA','1','BELI','BELI001','A1F', 'X-00005112', 'AT MODEL TETES ARESO UB 8K','0.720','0.670','100.00','577000','596000','889552','1265000','1','596000','596000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.670',berat_beli_asli=berat_beli_asli+'0.670',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.670',berat_akhir_asli=berat_akhir_asli+'0.670',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1F' 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','15:39:47','RTA','---','0.670','596000','596000','596000','596000','596000','kasir','2026-02-20 15:39:48','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','MB MINI','JL BASUKI RAHMAD 36','','','085796210346','kasir','2026-02-20 15:39:48');
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-0028','K','2026-02-20','15:39:47','kasir','PEMBELIAN UMUM','FB-260220-0001','6226127000','596000','6225531000');
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-00005113','X-00005113','CC OSROT ANAK BONEKA CAT MATA VAR LG 8K','GR','---','E2F','BELI','BELI001','462000','2026-02-20','0.530','1','kasir','2026-02-20 15:40:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2F','X-00005113','X-00005113');
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','F225180911551','RTA','1','BELI','BELI001','E2F', 'X-00005113', 'CC OSROT ANAK BONEKA CAT MATA VAR LG 8K','0.530','0.530','100.00','578000','462000','871698','1265000','1','462000','462000','RUSAK');
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 ='2026-02-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2F' 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','15:40:54','RTA','---','0.530','462000','462000','462000','462000','462000','kasir','2026-02-20 15:40:54','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','HAPPY','2/4 NGURI LEMBEYAN MAGETAN','','','085132009499','kasir','2026-02-20 15:40:54');
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-0029','K','2026-02-20','15:40:54','kasir','PEMBELIAN UMUM','FB-260220-0002','6225531000','462000','6225069000');
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-00005114','X-00005114','AT KLIP MODEL DAUN VAR CM 8K','GR','---','A1D','BELI','BELI001','1267000','2026-02-20','1.040','1','kasir','2026-02-20 15:41:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00005114','X-00005114');
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','F226200835191','TIN','1','BELI','BELI001','A1D', 'X-00005114', 'AT KLIP MODEL DAUN VAR CM 8K','1.040','1.040','100.00','1280000','1267000','1218269','1225000','1','1267000','1267000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.040',berat_beli_asli=berat_beli_asli+'1.040',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.040',berat_akhir_asli=berat_akhir_asli+'1.040',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' 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','15:41:17','TIN','---','1.040','1267000','1267000','1267000','1267000','1267000','kasir','2026-02-20 15:41:17','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','KALIMAH','BABADAN','','','085132047236','kasir','2026-02-20 15:41:17');
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-0030','K','2026-02-20','15:41:17','kasir','PEMBELIAN UMUM','FB-260220-0003','6225069000','1267000','6223802000');
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';
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','16:41:35','SYSTEM','SALDO AWAL','SALDO AWAL','0','6223802000','6223802000');
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','16:41:35','BCA','SALDO AWAL','SALDO AWAL','0','4281320888','4281320888');
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','16:41:35','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260221-0001','D','2026-02-21','16:41:35','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','16:41:35','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-260221-0001','D','2026-02-21','16:41:35','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
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-27-0','1','0.600','0.600','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-ZBBX-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZBBX-27-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-02-21 16:45:12' WHERE kode_barang='D1E-ZBBX-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZBBX-27-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:45:12','TOKO','SMBK-D','D1E','D1E-ZBBX-27-0','1','0.600','0.600','1','0.600','0.600','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-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZBBX-27-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-29-0','1','0.580','0.580','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-ZBBX-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZBBX-29-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-02-21 16:45:12' WHERE kode_barang='D1E-ZBBX-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZBBX-29-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:45:12','TOKO','SMBK-D','D1E','D1E-ZBBX-29-0','1','0.580','0.580','1','0.580','0.580','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-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZBBX-29-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:44','1.180','input','2026-02-20 16:45:12');