INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-24 ','08:58:52');
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-20260224-0001','1','CBRE-ZBBD-1-0','1','1.060','1.060','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZBBD-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZBBD-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZBBD-1-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZBBD-1-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-02-24 08:59:06' WHERE kode_barang='CBRE-ZBBD-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZBBD-1-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-24 08:59:06','TOKO','CBR','CBRE','CBRE-ZBBD-1-0','1','1.060','1.060','1','1.060','1.060','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZBBD-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZBBD-1-0';
UPDATE tt_beli_detail SET tgl_terima='2026-02-24' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260224-0001','2026-02-24','08:59','1.060','kasir','2026-02-24 08:59:06');
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-20260224-0002','1','CKPDE-ZBBC-76-0','1','4.360','4.360','TOKO','CKPDE','TOKO','CKPDE');
DELETE FROM tm_barang WHERE kode_barang='CKPDE-ZBBC-76-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPDE-ZBBC-76-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKPDE-ZBBC-76-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPDE-ZBBC-76-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CKPDE',tgl_last_beli='2026-02-24 08:59:45' WHERE kode_barang='CKPDE-ZBBC-76-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKPDE-ZBBC-76-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-24 08:59:45','TOKO','CKPDE','CKPDE','CKPDE-ZBBC-76-0','1','4.360','4.360','1','4.360','4.360','17.00');
DELETE FROM tm_dept WHERE kode_dept='CKPDE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPDE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPDE-ZBBC-76-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKPDE-ZBBC-76-0';
UPDATE tt_beli_detail SET tgl_terima='2026-02-24' WHERE no_faktur_beli='';
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-20260224-0002','1','CKPDE-ZBBC-77-0','1','4.550','4.550','TOKO','CKPDE','TOKO','CKPDE');
DELETE FROM tm_barang WHERE kode_barang='CKPDE-ZBBC-77-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPDE-ZBBC-77-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKPDE-ZBBC-77-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPDE-ZBBC-77-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CKPDE',tgl_last_beli='2026-02-24 08:59:45' WHERE kode_barang='CKPDE-ZBBC-77-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKPDE-ZBBC-77-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-24 08:59:45','TOKO','CKPDE','CKPDE','CKPDE-ZBBC-77-0','1','4.550','4.550','1','4.550','4.550','17.00');
DELETE FROM tm_dept WHERE kode_dept='CKPDE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPDE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPDE-ZBBC-77-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKPDE-ZBBC-77-0';
UPDATE tt_beli_detail SET tgl_terima='2026-02-24' WHERE no_faktur_beli='';
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-20260224-0002','1','CKPDE-ZBBC-78-0','1','4.700','4.700','TOKO','CKPDE','TOKO','CKPDE');
DELETE FROM tm_barang WHERE kode_barang='CKPDE-ZBBC-78-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPDE-ZBBC-78-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKPDE-ZBBC-78-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPDE-ZBBC-78-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CKPDE',tgl_last_beli='2026-02-24 08:59:45' WHERE kode_barang='CKPDE-ZBBC-78-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKPDE-ZBBC-78-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-24 08:59:45','TOKO','CKPDE','CKPDE','CKPDE-ZBBC-78-0','1','4.700','4.700','1','4.700','4.700','17.00');
DELETE FROM tm_dept WHERE kode_dept='CKPDE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPDE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPDE-ZBBC-78-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKPDE-ZBBC-78-0';
UPDATE tt_beli_detail SET tgl_terima='2026-02-24' WHERE no_faktur_beli='';
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-20260224-0002','1','CKPDE-ZBBC-79-0','1','4.770','4.770','TOKO','CKPDE','TOKO','CKPDE');
DELETE FROM tm_barang WHERE kode_barang='CKPDE-ZBBC-79-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPDE-ZBBC-79-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKPDE-ZBBC-79-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPDE-ZBBC-79-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CKPDE',tgl_last_beli='2026-02-24 08:59:45' WHERE kode_barang='CKPDE-ZBBC-79-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKPDE-ZBBC-79-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-24 08:59:45','TOKO','CKPDE','CKPDE','CKPDE-ZBBC-79-0','1','4.770','4.770','1','4.770','4.770','17.00');
DELETE FROM tm_dept WHERE kode_dept='CKPDE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPDE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPDE-ZBBC-79-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKPDE-ZBBC-79-0';
UPDATE tt_beli_detail SET tgl_terima='2026-02-24' WHERE no_faktur_beli='';
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-20260224-0002','1','CKPDE-ZBBC-80-0','1','4.790','4.790','TOKO','CKPDE','TOKO','CKPDE');
DELETE FROM tm_barang WHERE kode_barang='CKPDE-ZBBC-80-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPDE-ZBBC-80-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKPDE-ZBBC-80-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPDE-ZBBC-80-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CKPDE',tgl_last_beli='2026-02-24 08:59:45' WHERE kode_barang='CKPDE-ZBBC-80-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKPDE-ZBBC-80-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-24 08:59:45','TOKO','CKPDE','CKPDE','CKPDE-ZBBC-80-0','1','4.790','4.790','1','4.790','4.790','17.00');
DELETE FROM tm_dept WHERE kode_dept='CKPDE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPDE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPDE-ZBBC-80-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKPDE-ZBBC-80-0';
UPDATE tt_beli_detail SET tgl_terima='2026-02-24' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260224-0002','2026-02-24','08:59','23.170','kasir','2026-02-24 08:59:44');
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-20260224-0003','1','CKPRE-ZBBD-2-0','1','1.270','1.270','TOKO','PER','TOKO','PERAK');
DELETE FROM tm_barang WHERE kode_barang='CKPRE-ZBBD-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPRE-ZBBD-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKPRE-ZBBD-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPRE-ZBBD-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PERAK',tgl_last_beli='2026-02-24 09:00:26' WHERE kode_barang='CKPRE-ZBBD-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKPRE-ZBBD-2-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-24 09:00:26','TOKO','PERAK','CKPRE','CKPRE-ZBBD-2-0','1','1.270','1.270','1','1.270','1.270','100.00');
DELETE FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPRE-ZBBD-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZBBD-2-0';
UPDATE tt_beli_detail SET tgl_terima='2026-02-24' WHERE no_faktur_beli='';
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-20260224-0003','1','CKPRE-ZBBD-3-0','1','1.220','1.220','TOKO','PER','TOKO','PERAK');
DELETE FROM tm_barang WHERE kode_barang='CKPRE-ZBBD-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPRE-ZBBD-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKPRE-ZBBD-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPRE-ZBBD-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PERAK',tgl_last_beli='2026-02-24 09:00:26' WHERE kode_barang='CKPRE-ZBBD-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKPRE-ZBBD-3-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-24 09:00:26','TOKO','PERAK','CKPRE','CKPRE-ZBBD-3-0','1','1.220','1.220','1','1.220','1.220','100.00');
DELETE FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPRE-ZBBD-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZBBD-3-0';
UPDATE tt_beli_detail SET tgl_terima='2026-02-24' WHERE no_faktur_beli='';
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-20260224-0003','1','CKPRE-ZBBD-4-0','1','1.230','1.230','TOKO','PER','TOKO','PERAK');
DELETE FROM tm_barang WHERE kode_barang='CKPRE-ZBBD-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPRE-ZBBD-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKPRE-ZBBD-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPRE-ZBBD-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PERAK',tgl_last_beli='2026-02-24 09:00:26' WHERE kode_barang='CKPRE-ZBBD-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKPRE-ZBBD-4-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-24 09:00:26','TOKO','PERAK','CKPRE','CKPRE-ZBBD-4-0','1','1.230','1.230','1','1.230','1.230','100.00');
DELETE FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPRE-ZBBD-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZBBD-4-0';
UPDATE tt_beli_detail SET tgl_terima='2026-02-24' WHERE no_faktur_beli='';
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-20260224-0003','1','CKPRE-ZBBD-5-0','1','1.230','1.230','TOKO','PER','TOKO','PERAK');
DELETE FROM tm_barang WHERE kode_barang='CKPRE-ZBBD-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPRE-ZBBD-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKPRE-ZBBD-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPRE-ZBBD-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PERAK',tgl_last_beli='2026-02-24 09:00:26' WHERE kode_barang='CKPRE-ZBBD-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKPRE-ZBBD-5-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-24 09:00:26','TOKO','PERAK','CKPRE','CKPRE-ZBBD-5-0','1','1.230','1.230','1','1.230','1.230','100.00');
DELETE FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPRE-ZBBD-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZBBD-5-0';
UPDATE tt_beli_detail SET tgl_terima='2026-02-24' WHERE no_faktur_beli='';
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-20260224-0003','1','CKPRE-ZBBD-6-0','1','1.250','1.250','TOKO','PER','TOKO','PERAK');
DELETE FROM tm_barang WHERE kode_barang='CKPRE-ZBBD-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPRE-ZBBD-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKPRE-ZBBD-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPRE-ZBBD-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PERAK',tgl_last_beli='2026-02-24 09:00:26' WHERE kode_barang='CKPRE-ZBBD-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKPRE-ZBBD-6-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-24 09:00:26','TOKO','PERAK','CKPRE','CKPRE-ZBBD-6-0','1','1.250','1.250','1','1.250','1.250','100.00');
DELETE FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPRE-ZBBD-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZBBD-6-0';
UPDATE tt_beli_detail SET tgl_terima='2026-02-24' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260224-0003','2026-02-24','09:00','6.200','kasir','2026-02-24 09:00:25');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-02-24 ','10:33:43');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-24 ','10:44:40');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-02-24 ','11:02:44');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-02-24 ','11:08:24');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-02-24 ','11:09:02');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-02-24 ','11:09:17');
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,keterangan) VALUES ('FE-260224-0001','kasir','1',' CBRE-06990','TOKO','CBR','CBRE-ZBBD-1-0','CBRE-06990 GIA 7478252865 ','','1.060','1','83.00','7863000','4772500','279','17100','10000000','0','0','0','10000000','ONLNANA','00041747','CBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-ZBBD-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='CBRE-ZBBD-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' 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,no_persekot,dp_pesanan) VALUES ('FE-260224-0001','2026-02-24','1.060','2026-02-24','11:10:38','PLG0028062','10000000','10000000','0','10000000','0','kasir','2026-02-24 11:10:37','FE-260224-0001','','POTONG');
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-24','FE-260224-0001','2026-02-24','11:10:38','ONLNANA','10000000','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-260224-0001','2026-02-24','2026-02-24 11:10:37','PENJUALAN : FE-260224-0001','','TBC','10000000','10000000','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-260224-0002','D','2026-02-24','11:10:38','TBC','PENJUALAN BERLIAN','FE-260224-0001','95337701885','10000000','95347701885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='10000000' WHERE no_faktur_jual='FE-260224-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260224-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260224-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260224-0001';
UPDATE tt_service_head SET tgl_selesai='2008-12-25',  status ='DONE' WHERE no_service='DP/081209/001';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='DP/081209/001';
UPDATE tt_service_head SET tgl_selesai='2026-02-24',  status ='DONE' WHERE no_service='SV-08035';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-08035';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-24 ','12:21:15');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('owner','2026-02-24 ','13:17:06');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('owner','2026-02-24 ','13:18:24');
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,keterangan) VALUES ('FE-260224-0002','kasir','1',' CBRE-06156','TOKO','CBR','CBRE-XBXF-4-0','CINCIN CBRE-06156','','3.440','1','83.00','17834000','7740500','453','17100','19500000','0','0','0','19500000','ONLILUNG','00026415','CBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-XBXF-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.440',berat_jual_asli=berat_jual_asli+'3.440',stock_jual='1',berat_akhir=berat_akhir-'3.440',berat_akhir_asli=berat_akhir_asli-'3.440',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='CBRE-XBXF-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' 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,no_persekot,dp_pesanan) VALUES ('FE-260224-0002','2026-02-24','3.440','2026-02-24','13:19:09','PLG0028063','19500000','19500000','0','19500000','0','kasir','2026-02-24 13:19:09','FE-260224-0002','','POTONG');
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-24','FE-260224-0002','2026-02-24','13:19:09','ONLILUNG','19500000','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-260224-0002','2026-02-24','2026-02-24 13:19:09','PENJUALAN : FE-260224-0002','','TBC','19500000','19500000','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-260224-0003','D','2026-02-24','13:19:09','TBC','PENJUALAN BERLIAN','FE-260224-0002','95347701885','19500000','95367201885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='19500000' WHERE no_faktur_jual='FE-260224-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260224-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260224-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260224-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-24 ','13:25:46');
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-02-24',  status ='CLOS' WHERE no_service='SV-08035';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-08035';
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,keterangan) VALUES ('FE-260224-0003','kasir','1',' DP-02941 ','TOKO','PSN','PSBRE-ZBAC-23-0','CINCIN BERLIAN DAN SILVER ','','1.640','1','83.00','5025000','865500','51','17100','6200000','0','0','0','6200000','NANA','00041552','PSBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBRE-ZBAC-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.640',berat_jual_asli=berat_jual_asli+'1.640',stock_jual='1',berat_akhir=berat_akhir-'1.640',berat_akhir_asli=berat_akhir_asli-'1.640',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='PSBRE-ZBAC-23-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PSN' 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,no_persekot,dp_pesanan) VALUES ('FE-260224-0003','2026-02-24','1.640','2026-02-24','13:29:01','PLG0028064','6200000','6200000','0','6200000','0','kasir','2026-02-24 13:29:01','FE-260224-0003','DP-02941','3000000');
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-24','FE-260224-0003','2026-02-24','13:29:01','NANA','6200000','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-260224-0003','2026-02-24','2026-02-24 13:29:01','PENJUALAN : FE-260224-0003','','TBC','3200000','3200000','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-260224-0004','D','2026-02-24','13:29:01','TBC','PENJUALAN BERLIAN','FE-260224-0003','95367201885','3200000','95370401885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3200000' WHERE no_faktur_jual='FE-260224-0003' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-24 ','13:29:54');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260224-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260224-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260224-0003';
UPDATE tm_credit_card SET nama_customer='-',no_ktp='-',alamat1=' - ' ,alamat2=' - ' ,kota= ' - ' ,no_telp='-',tgl_valid_until='-',tgl_last_gesek='2026-02-24 13:39:38' WHERE id_card = '-';
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,keterangan) VALUES ('FE-260224-0004','kasir','1',' GBRE-00682','TOKO','GBR','GBRE-YKBD-36-0','GELANG GBRE-00682','','9.350','1','75.00','41466000','18622000','1089','17100','55000000','0','0','0','55000000','FAISAL','00039808','GBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='GBRE-YKBD-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'9.350',berat_jual_asli=berat_jual_asli+'9.350',stock_jual='1',berat_akhir=berat_akhir-'9.350',berat_akhir_asli=berat_akhir_asli-'9.350',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='GBRE-YKBD-36-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='GBR' 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,no_persekot,dp_pesanan) VALUES ('FE-260224-0004','2026-02-24','9.350','2026-02-24','13:39:40','PLG0028065','55000000','55000000','0','55000000','0','kasir','2026-02-24 13:39:39','FE-260224-0004','','POTONG');
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-24','FE-260224-0004','2026-02-24','13:39:40','FAISAL','55000000','0');
INSERT INTO tt_debet(no_trx,tgl_system,tgl_trx,deskripsi,id_card,kode_bank,jml_cash_rp,debet_rp,debet_fee_rp) VALUES ('DC-260224-0001','2026-02-24','2026-02-24 13:39:39','PENJUALAN : FE-260224-0004','','BCD','55000000','55000000','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-260224-0002','D','2026-02-24','13:39:40','BCD','PENJUALAN BERLIAN','FE-260224-0004','14938321700','55000000','14993321700','DEBET');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='55000000',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FE-260224-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260224-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260224-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260224-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-24 ','13:41:45');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08040','ILU','1','CBRE06156','DIKECILIN JD NO 11 CROM PUTIH','3.440','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-08040','2026-02-24','2026-02-24','13:49:08','PLG0028066','kasir','2026-02-26','kasir','2026-02-24 13:49:08','3.440','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-24 ','13:50:08');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-02-24 ','14:00:21');
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,keterangan) VALUES ('FE-260224-0005','kasir','1',' DP-02946 ','TOKO','PSN','PSPRE-ZBAG-39-0','CINCIN PERAK ','','1.240','1','100.00','127000','0','0','17100','850000','0','0','0','850000','FAISAL','00041615','PSPRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRE-ZBAG-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.240',berat_jual_asli=berat_jual_asli+'1.240',stock_jual='1',berat_akhir=berat_akhir-'1.240',berat_akhir_asli=berat_akhir_asli-'1.240',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='PSPRE-ZBAG-39-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PSN' 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,no_persekot,dp_pesanan) VALUES ('FE-260224-0005','2026-02-24','1.240','2026-02-24','14:52:45','PLG0028067','850000','850000','0','850000','0','kasir','2026-02-24 14:52:44','FE-260224-0005','DP-02946','850000');
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-24','FE-260224-0005','2026-02-24','14:52:45','FAISAL','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FE-260224-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260224-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260224-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260224-0005';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08041','NANA','1','SLV','RESIZE KE 11 CRUM PUTIH','1.410','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-08041','2026-02-24','2026-02-24','15:23:24','PLG0028068','kasir','2026-02-26','kasir','2026-02-24 15:23:24','1.410','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-24 ','15:35:43');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08042','BARY','1','CBR','PASANG MATA 1 CRUM PUTIH','3.080','1','150000','150000');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-08042','2026-02-24','2026-02-24','16:06:22','PLG0028069','kasir','2026-02-26','kasir','2026-02-24 16:06:22','3.080','0','0','0','0','0','150000','150000','150000');
UPDATE tt_service_head SET tgl_selesai='2026-02-24',  status ='DONE' WHERE no_service='SV-08036';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-08036';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-02-24',  status ='CLOS' WHERE no_service='SV-08036';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-08036';
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-260224-0002','K','2026-02-24','17:23:23','kasir','KIRIM PAKET','JNE RANGKASBITUNG','6330440','26000','6304440');
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-260224-0003','K','2026-02-24','17:23:39','kasir','KIRIM PAKET','JNE SAWANGAN','6304440','18000','6286440');
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-260224-0004','K','2026-02-24','17:23:55','kasir','KIRIM PAKET','JNE DENPASAR','6286440','60000','6226440');