INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-02-21 ','08:29:29');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-21','127','0','-130100000','127','0','-130100000');
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_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','08:29:46','BCA','SALDO AWAL','SALDO AWAL','0','1744912574','1744912574');
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','08:29:46','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-02-21';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-02-21 ','08:30:10');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-02-21 ','08:38:06');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-02-21 ','09:05:16');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-02-21 ','09:08:19');
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,potong_rp) VALUES ('FJ-260221-0001','sales','1',' ','TOKO','BTCNMD','MDCN-ZBAH-60-0','CN COR TDK BT LC2 ','','1.620','1','100.00','2033500','0','0','0','2033500','0','0','0','2033500','2106','00028303','MDCN','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZBAH-60-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.620',berat_jual_asli=berat_jual_asli+'1.620',stock_jual='1',berat_akhir=berat_akhir-'1.620',berat_akhir_asli=berat_akhir_asli-'1.620',stock_akhir='0' WHERE tanggal='2026-02-21' AND kode_barang='MDCN-ZBAH-60-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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 ('FJ-260221-0001','2026-02-21','1.620','2026-02-21','09:10:43','PLG0018112','2033500','2033500','0','2033500','2033500','sales','2026-02-21 09:10:42','FJ-260221-0001');
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-21','FJ-260221-0001','2026-02-21','09:10:43','2106','2033500','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-260221-0002','D','2026-02-21','09:10:43','sales','PENJUALAN','FJ-260221-0001','107872556','2033500','109906056');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260221-0001';
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-00009212','X-00009212','GL CAP HOLO 17CM KKT PER MK','GR','---','MDGL','BELI','BELI001','4328500','2026-02-21','4.010','1','sales','2026-02-21 09:13:41');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDGL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDGL','X-00009212','X-00009212');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260221-0001','FJ-251119-0001','2103','1','BELI','BELI001','MDGL', 'X-00009212', 'GL CAP HOLO 17CM KKT PER MK','4.010','4.010','100.00','4030500','4328500','1079426','1','4328500','4328500','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-02-21','BELI','BELI001','MDGL','MDGL','100.00','4.010','4.010','1','4.010','4.010','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,status_valid) VALUES ('FB-260221-0001','2026-02-21','2026-02-21','09:13:40','2103','---','4.010','4328500','4328500','4328500','4328500','4328500','sales','2026-02-21 09:13:41','FB-260221-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260221-0001','ANANG MACHRUP','TAMBAK ASRI KEMBANG TURI 109','','','083852648822','sales','2026-02-21 09:13:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-21' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260221-0003','K','2026-02-21','09:13:40','sales','PEMBELIAN UMUM','FB-260221-0001','109906056','4328500','105577556','OPEN');
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-00009213','X-00009213','CN COR TDK BT SHB','GR','---','MTCN','BELI','BELI001','1611500','2026-02-21','0.860','1','sales','2026-02-21 09:14:21');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTCN','X-00009213','X-00009213');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260221-0002','FJ-260208-0001','2404','1','BELI','BELI001','MTCN', 'X-00009213', 'CN COR TDK BT SHB','0.860','0.860','100.00','1832000','1611500','1873837','1','1611500','1611500','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.860',berat_beli_asli=berat_beli_asli+'0.860',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.860',berat_akhir_asli=berat_akhir_asli+'0.860',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTCN' 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,status_valid) VALUES ('FB-260221-0002','2026-02-21','2026-02-21','09:14:20','2404','---','0.860','1611500','1611500','1611500','1611500','1611500','sales','2026-02-21 09:14:21','FB-260221-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260221-0002','MAS AMAH','JL. KUNTI 41','','','','sales','2026-02-21 09:14:21');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-21' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260221-0004','K','2026-02-21','09:14:20','sales','PEMBELIAN UMUM','FB-260221-0002','105577556','1611500','103966056','OPEN');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-02-21 ','09:16:33');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260221-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260221-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260221-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260221-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-02-21 ','09:18:39');
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,potong_rp) VALUES ('FJ-260221-0002','sales','1',' ','TOKO','BTGLMD','MDGL-ZBAX-36-0','GL PAJERO MN LM5 16CM KKT PER SHB ','','4.900','1','100.00','6149500','0','0','0','6149500','0','0','0','6149500','2103','00027974','MDGL','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZBAX-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.900',berat_jual_asli=berat_jual_asli+'4.900',stock_jual='1',berat_akhir=berat_akhir-'4.900',berat_akhir_asli=berat_akhir_asli-'4.900',stock_akhir='0' WHERE tanggal='2026-02-21' AND kode_barang='MDGL-ZBAX-36-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' 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 ('FJ-260221-0002','2026-02-21','4.900','2026-02-21','09:26:49','PLG0018113','6149500','6149500','0','6149500','6149500','sales','2026-02-21 09:26:49','FJ-260221-0002');
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-21','FJ-260221-0002','2026-02-21','09:26:49','2103','6149500','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-260221-0005','D','2026-02-21','09:26:49','sales','PENJUALAN','FJ-260221-0002','103966056','6149500','110115556','OPEN');
UPDATE tt_jual_head SET dibayar_rp='6149500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260221-0002' 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,potong_rp) VALUES ('FJ-260221-0003','sales',' 1',' ','TOKO','BTCNMD','MDCN-ZBAX-28-0','CN CAP TDK BT SHB ','','0.720','1','100.00','904000','0','0','0','904000','0','0','0','904000','2103','00027966','MDCN','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZBAX-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.720',berat_jual_asli=berat_jual_asli+'0.720',stock_jual='1',berat_akhir=berat_akhir-'0.720',berat_akhir_asli=berat_akhir_asli-'0.720',stock_akhir='0' WHERE tanggal='2026-02-21' AND kode_barang='MDCN-ZBAX-28-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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 ('FJ-260221-0003','2026-02-21','0.720','2026-02-21','09:26:49','PLG0018114','904000','904000','0','904000','904000','sales','2026-02-21 09:26:49','FJ-260221-0002');
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-21','FJ-260221-0003','2026-02-21','09:26:49','2103','904000','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-260221-0006','D','2026-02-21','09:26:49','sales','PENJUALAN','FJ-260221-0003','110115556','904000','111019556','OPEN');
UPDATE tt_jual_head SET dibayar_rp='904000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260221-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260221-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260221-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-02-21 ','09:40:22');
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,potong_rp) VALUES ('FJ-260221-0004','sales','1',' ','TOKO','BTGLMD','MDGL-ZBAH-89-0','GL FANCY VAR 17CM KKT PER BLT LC2 ','','1.500','1','100.00','1882500','0','0','0','1882500','0','0','0','1882500','2402','00028332','MDGL','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZBAH-89-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-02-21' AND kode_barang='MDGL-ZBAH-89-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' 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 ('FJ-260221-0004','2026-02-21','1.500','2026-02-21','10:07:21','PLG0018115','1882500','1882500','0','1882500','0','sales','2026-02-21 10:07:21','FJ-260221-0004');
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-21','FJ-260221-0004','2026-02-21','10:07:21','2402','1882500','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-260221-0001','2026-02-21','2026-02-21 10:07:21','PENJUALAN : FJ-260221-0004','bca','BCA','1882500','1882500','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-260221-0002','D','2026-02-21','10:07:21','BCA','PENJUALAN','FJ-260221-0004','1744912574','1882500','1746795074','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','SAMSUL ARIFIN');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1882500' WHERE no_faktur_jual='FJ-260221-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260221-0004';
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,potong_rp) VALUES ('FJ-260221-0005','sales','1',' EX ','TOKO','BTCNMT','MTCN-YBBH-169-0','CN CAP RANTAI SUSUN SHB ','','1.920','1','100.00','4090000','0','0','0','4090000','0','0','0','4090000','2403','00023525','MTCN','256000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-YBBH-169-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.920',berat_jual_asli=berat_jual_asli+'1.920',stock_jual='1',berat_akhir=berat_akhir-'1.920',berat_akhir_asli=berat_akhir_asli-'1.920',stock_akhir='0' WHERE tanggal='2026-02-21' AND kode_barang='MTCN-YBBH-169-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMT' 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 ('FJ-260221-0005','2026-02-21','1.920','2026-02-21','10:29:53','PLG0018116','4090000','4090000','0','4090000','4090000','sales','2026-02-21 10:29:53','FJ-260221-0005');
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-21','FJ-260221-0005','2026-02-21','10:29:53','2403','4090000','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-260221-0007','D','2026-02-21','10:29:53','sales','PENJUALAN','FJ-260221-0005','111019556','4090000','115109556');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260221-0005';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-02-21 ','11:34:08');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260221-0001','1','MDLT-ZBAI-66-0','TOKO','BTLTMD','MN COR FORTUNE HURUF S BG ','1','0.530','RETUR SALAH BERAT');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-02-21 11:35:09',status_delete='0.520' WHERE kode_barang='MDLT-ZBAI-66-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDLT-ZBAI-66-0';
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZBAI-66-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.530,berat_hancur_asli=berat_hancur_asli+0.530, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTLTMD' AND kode_barang='MDLT-ZBAI-66-0' AND stock_akhir > 0;
INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date) VALUES ('BS-260221-0001','2026-02-21','admin','2026-02-21','11:35:09','admin','2026-02-21 11:35:09');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-21 ','12:28:12');
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,potong_rp) VALUES ('FJ-260221-0006','sales','1',' ','TOKO','BTKLMD','MDKL-ZBAX-62-0','KL PAJERO PJG 71CM KKT PER SHB ','','10.750','1','100.00','13491500','0','0','0','13491500','0','0','0','13491500','2403','00028000','MDKL','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDKL-ZBAX-62-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'10.750',berat_jual_asli=berat_jual_asli+'10.750',stock_jual='1',berat_akhir=berat_akhir-'10.750',berat_akhir_asli=berat_akhir_asli-'10.750',stock_akhir='0' WHERE tanggal='2026-02-21' AND kode_barang='MDKL-ZBAX-62-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMD' 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 ('FJ-260221-0006','2026-02-21','10.750','2026-02-21','12:29:12','PLG0018117','13491500','13491500','0','13491500','13491500','sales','2026-02-21 12:29:12','FJ-260221-0006');
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-21','FJ-260221-0006','2026-02-21','12:29:12','2403','13491500','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-260221-0008','D','2026-02-21','12:29:12','sales','PENJUALAN','FJ-260221-0006','115109556','13491500','128601056');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-02-21 ','12:29:54');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260221-0006';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-21 ','12:33:30');
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260221-0002','1','X-00009208','BELI','BELI001','CN COR BT SHB','1','0.680','561000.00' ,'0.00','561000','','561000','561000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-02-21 12:47:37' WHERE kode_barang='X-00009208' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009208' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009208' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.680',berat_hancur_asli=berat_hancur_asli+'0.680', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260221-0002','2','X-00009209','BELI','BELI001','CN COR TDK BT SHB','1','1.240','2323500.00' ,'0.00','2323500','','2323500','3445500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-02-21 12:47:37' WHERE kode_barang='X-00009209' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009209' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009209' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.240',berat_hancur_asli=berat_hancur_asli+'1.240', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.240',berat_akhir_asli=berat_akhir_asli-'1.240' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260221-0002','3','X-00009210','BELI','BELI001','GL RANGKAIAN COR 16CM KKT PER SHB','1','9.840','18440000.00' ,'0.00','18440000','','18440000','24209000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-02-21 12:47:37' WHERE kode_barang='X-00009210' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009210' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009210' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'9.840',berat_hancur_asli=berat_hancur_asli+'9.840', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'9.840',berat_akhir_asli=berat_akhir_asli-'9.840' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTGL' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260221-0002','4','X-00009211','BELI','BELI001','AT ITALY BT MK','1','1.780','2935000.00' ,'0.00','2935000','','2935000','45584000','RUSAK BIASA');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-02-21 12:47:37' WHERE kode_barang='X-00009211' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009211' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009211' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.780',berat_hancur_asli=berat_hancur_asli+'1.780', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.780',berat_akhir_asli=berat_akhir_asli-'1.780' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTAT' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_head(no_waste,sales_id,tgl_system,tgl_waste,jam_Waste,jml_beli_waste_rp,jml_jual_waste_rp,input_by,input_date) VALUES ('BS-260221-0002','adminpusat','2026-02-21','2026-02-21','12:47:37','24259500','45584000', 'adminpusat','2026-02-21 12:47:37');
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,potong_rp) VALUES ('FJ-260221-0007','sales','1',' ','TOKO','BTCNMD','MDCN-ZAAB-37-0','CN PIPA BT SHB','','0.760','1','100.00','954000','0','0','0','954000','0','0','0','954000','2502','00027511','MDCN','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZAAB-37-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-21' AND kode_barang='MDCN-ZAAB-37-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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 ('FJ-260221-0007','2026-02-21','0.760','2026-02-21','12:53:40','PLG0018118','954000','954000','0','954000','954000','sales','2026-02-21 12:53:40','FJ-260221-0007');
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-21','FJ-260221-0007','2026-02-21','12:53:40','2502','954000','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-260221-0009','D','2026-02-21','12:53:40','sales','PENJUALAN','FJ-260221-0007','128601056','954000','129555056');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260221-0007';
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,potong_rp) VALUES ('FJ-260221-0008','sales','1',' ','TOKO','BTATMD','MDAT-ZBBX-21-0','AT TINDIK ARESO UBS ','','0.420','1','100.00','527500','0','0','0','527500','0','0','0','527500','2401','00028569','MDAT','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDAT-ZBBX-21-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2026-02-21' AND kode_barang='MDAT-ZBBX-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMD' 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 ('FJ-260221-0008','2026-02-21','0.420','2026-02-21','13:00:49','PLG0018119','527500','527500','0','527500','527500','sales','2026-02-21 13:00:49','FJ-260221-0008');
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-21','FJ-260221-0008','2026-02-21','13:00:49','2401','527500','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-260221-0010','D','2026-02-21','13:00:49','sales','PENJUALAN','FJ-260221-0008','129555056','527500','130082556');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260221-0008';
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,potong_rp) VALUES ('FJ-260221-0009','sales','1',' ','TOKO','BTKLMT','MTKL-YCXF-188-0','KL FANCY ANAK DB 34CM KKT S SHB','','2.000','1','100.00','4260000','0','0','0','4260000','0','0','0','4260000','2403','00024002','MTKL','256000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTKL-YCXF-188-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-02-21' AND kode_barang='MTKL-YCXF-188-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMT' 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 ('FJ-260221-0009','2026-02-21','2.000','2026-02-21','13:27:06','PLG0018120','4260000','4260000','0','4260000','4260000','sales','2026-02-21 13:27:05','FJ-260221-0009');
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-21','FJ-260221-0009','2026-02-21','13:27:06','2403','4260000','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-260221-0011','D','2026-02-21','13:27:06','sales','PENJUALAN','FJ-260221-0009','130082556','4260000','134342556');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260221-0009';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-21 ','13:49:19');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-21 ','14:23:52');
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,potong_rp) VALUES ('FJ-260221-0010','sales','1',' ','TOKO','BTGLMD','MDGL-ZBAI-140-0','GL PAJERO MN HT4 20CM KKT PER SHB ','','9.870','1','100.00','12387000','0','0','0','12387000','0','0','0','12387000','2502','00028516','MDGL','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZBAI-140-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'9.870',berat_jual_asli=berat_jual_asli+'9.870',stock_jual='1',berat_akhir=berat_akhir-'9.870',berat_akhir_asli=berat_akhir_asli-'9.870',stock_akhir='0' WHERE tanggal='2026-02-21' AND kode_barang='MDGL-ZBAI-140-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' 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 ('FJ-260221-0010','2026-02-21','9.870','2026-02-21','14:30:21','PLG0018121','12387000','12387000','0','12387000','12387000','sales','2026-02-21 14:30:20','FJ-260221-0010');
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-21','FJ-260221-0010','2026-02-21','14:30:21','2502','12387000','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-260221-0012','D','2026-02-21','14:30:21','sales','PENJUALAN','FJ-260221-0010','134342556','12387000','146729556');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260221-0010';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-21 ','14:54:30');
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-00009214','X-00009214','GW CAP BT SHB','GR','---','MTGW','BELI','BELI001','742000','2026-02-21','0.450','1','sales','2026-02-21 15:18:01');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTGW';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTGW','X-00009214','X-00009214');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260221-0003','FJ-250418-0007','2403','1','BELI','BELI001','MTGW', 'X-00009214', 'GW CAP BT SHB','0.810','0.450','100.00','1122000','742000','1648889','1','742000','742000','RONGSOK');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-02-21','BELI','BELI001','MTGW','MTGW','100.00','0.450','0.450','1','0.450','0.450','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,status_valid) VALUES ('FB-260221-0003','2026-02-21','2026-02-21','15:18:01','2403','---','0.450','742000','742000','742000','742000','742000','sales','2026-02-21 15:18:01','FB-260221-0003','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260221-0003','FIFIT','TNH MRH SYR INDH','','','081216685584','sales','2026-02-21 15:18:01');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-21' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260221-0013','K','2026-02-21','15:18:01','sales','PEMBELIAN UMUM','FB-260221-0003','146729556','742000','145987556','OPEN');
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,potong_rp) VALUES ('FJ-260221-0011','sales','1',' ','TOKO','BTATMD','MDAT-ZBAH-36-0','AT COR KWT TDK BT LC2 ','','0.940','1','100.00','1180000','0','0','0','1180000','0','0','0','1180000','2403','00028279','MDAT','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDAT-ZBAH-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.940',berat_jual_asli=berat_jual_asli+'0.940',stock_jual='1',berat_akhir=berat_akhir-'0.940',berat_akhir_asli=berat_akhir_asli-'0.940',stock_akhir='0' WHERE tanggal='2026-02-21' AND kode_barang='MDAT-ZBAH-36-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMD' 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 ('FJ-260221-0011','2026-02-21','0.940','2026-02-21','15:19:23','PLG0018122','1180000','1180000','0','1180000','1180000','sales','2026-02-21 15:19:22','FJ-260221-0011');
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-21','FJ-260221-0011','2026-02-21','15:19:23','2403','1180000','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-260221-0014','D','2026-02-21','15:19:23','sales','PENJUALAN','FJ-260221-0011','145987556','1180000','147167556');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260221-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260221-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260221-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260221-0011';