INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-14 ','08:20:05');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-04-14 ','10:05:36');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-14 ','10:08:15');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-14','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-14';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-13';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-13';
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-04-13' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-13';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-13';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-13';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-13';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-14' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-13' 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-260414-0001','D','2026-04-14','10:11:53','TBC','SALDO AWAL','SALDO AWAL','0','21584831514','21584831514');
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-260414-0001','D','2026-04-14','10:11:53','BCD','SALDO AWAL','SALDO AWAL','0','1357533500','1357533500');
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-260414-0001','D','2026-04-14','10:11:53','','SALDO AWAL','SALDO AWAL','0','250000','250000');
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-260414-0001','D','2026-04-14','10:11:53','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000');
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-260414-0001','D','2026-04-14','10:11:53','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000');
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-260414-0001','D','2026-04-14','10:11:53','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000');
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-260414-0001','D','2026-04-14','10:11:53','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000');
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-260414-0001','D','2026-04-14','10:11:53','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000');
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-260414-0001','D','2026-04-14','10:11:53','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
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-260414-0001','D','2026-04-14','10:11:53','SHO','SALDO AWAL','SALDO AWAL','0','142865650','142865650');
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-260414-0001','D','2026-04-14','10:11:53','KET','SALDO AWAL','SALDO AWAL','0','152646000','152646000');
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-260414-0001','D','2026-04-14','10:11:53','BCK','SALDO AWAL','SALDO AWAL','0','1980308000','1980308000');
UPDATE tp_system SET tgl_system='2026-04-14';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-14 ','10:53:18');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-14 ','11:23:48');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-04-14 ','11:48:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-14 ','12:10:04');
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 ('FJ-260414-0001','kasir','1',' 750K-13-00','TOKO','MMPER','PMM-YGAF-17-0','CINCIN SILVER 925 ','','2.410','1','100.00','50000','0','0','17000','900000','0','0','0','900000','ALIKA','00037236','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YGAF-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.410',berat_jual_asli=berat_jual_asli+'2.410',stock_jual='1',berat_akhir=berat_akhir-'2.410',berat_akhir_asli=berat_akhir_asli-'2.410',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='PMM-YGAF-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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 ('FJ-260414-0001','2026-04-14','2.410','2026-04-14','12:14:06','PLG0010432','900000','900000','0','900000','0','kasir','2026-04-14 12:14:06','FJ-260414-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-04-14','FJ-260414-0001','2026-04-14','12:14:06','ALIKA','900000','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-260414-0001','2026-04-14','2026-04-14 12:14:06','PENJUALAN : FJ-260414-0001','.','TBC','900000','900000','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-260414-0002','D','2026-04-14','12:14:06','TBC','PENJUALAN','FJ-260414-0001','21584831514','900000','21585731514','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='900000' WHERE no_faktur_jual='FJ-260414-0001' 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,keterangan) VALUES ('FJ-260414-0002','kasir',' 1',' 700K-18-00','TOKO','MMPER','PMM-YGXD-8-0','CINCIN SILVER 925 ','','2.780','1','100.00','65000','0','0','17000','850000','0','0','0','850000','ALIKA','00036954','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YGXD-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.780',berat_jual_asli=berat_jual_asli+'2.780',stock_jual='1',berat_akhir=berat_akhir-'2.780',berat_akhir_asli=berat_akhir_asli-'2.780',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='PMM-YGXD-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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 ('FJ-260414-0002','2026-04-14','2.780','2026-04-14','12:14:06','PLG0010433','850000','850000','0','850000','0','kasir','2026-04-14 12:14:06','FJ-260414-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-04-14','FJ-260414-0002','2026-04-14','12:14:06','ALIKA','850000','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-260414-0002','2026-04-14','2026-04-14 12:14:06','PENJUALAN : FJ-260414-0002','.','TBC','850000','850000','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-260414-0003','D','2026-04-14','12:14:06','TBC','PENJUALAN','FJ-260414-0002','21585731514','850000','21586581514','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='1750000' WHERE no_faktur_jual='FJ-260414-0002' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-04-14 ','12:25:41');
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 ('FJ-260414-0003','kasirbip','1',' 700K-15-00','TOKO','DUPERBDG','LXPER-ZBBD-26-0','CINCIN SILVER 925 ','','3.940','1','100.00','402000','0','0','17000','800000','0','0','0','800000','PUT','00041772','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZBBD-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.940',berat_jual_asli=berat_jual_asli+'3.940',stock_jual='1',berat_akhir=berat_akhir-'3.940',berat_akhir_asli=berat_akhir_asli-'3.940',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='LXPER-ZBBD-26-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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 ('FJ-260414-0003','2026-04-14','3.940','2026-04-14','12:29:56','PLG0010434','800000','800000','0','800000','0','kasirbip','2026-04-14 12:29:56','FJ-260414-0003','','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-04-14','FJ-260414-0003','2026-04-14','12:29:56','PUT','800000','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-260414-0003','2026-04-14','2026-04-14 12:29:56','PENJUALAN : FJ-260414-0003','','TBC','800000','800000','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-260414-0004','D','2026-04-14','12:29:56','TBC','PENJUALAN','FJ-260414-0003','21586581514','800000','21587381514','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='800000' WHERE no_faktur_jual='FJ-260414-0003' 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,keterangan) VALUES ('FJ-260414-0004','kasirbip',' 1',' 700K-13-00','TOKO','DUPERBDG','LXPER-ZBAH-14-0','CINCIN SILVER 925 ','','1.080','1','100.00','111000','0','0','17000','800000','0','0','0','800000','PUT','00041632','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZBAH-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='LXPER-ZBAH-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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 ('FJ-260414-0004','2026-04-14','1.080','2026-04-14','12:29:56','PLG0010435','800000','800000','0','800000','0','kasirbip','2026-04-14 12:29:56','FJ-260414-0003','','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-04-14','FJ-260414-0004','2026-04-14','12:29:56','PUT','800000','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-260414-0004','2026-04-14','2026-04-14 12:29:56','PENJUALAN : FJ-260414-0004','','TBC','800000','800000','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-260414-0005','D','2026-04-14','12:29:56','TBC','PENJUALAN','FJ-260414-0004','21587381514','800000','21588181514','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='1600000' WHERE no_faktur_jual='FJ-260414-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260414-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260414-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-04-14 ','12:55:45');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-14 ','13:32:09');
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-20260414-0001','1','TFC-ZDAC-20-0','1','1.650','1.650','TOKO','TFC.BALIK','TOKO','TFCBR');
DELETE FROM tm_barang WHERE kode_barang='TFC-ZDAC-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFC-ZDAC-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFC-ZDAC-20-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFC-ZDAC-20-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCBR',tgl_last_beli='2026-04-14 13:32:46' WHERE kode_barang='TFC-ZDAC-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFC-ZDAC-20-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-04-14 13:32:46','TOKO','TFCBR','TFC','TFC-ZDAC-20-0','1','1.650','1.650','1','1.650','1.650','75.00');
DELETE FROM tm_dept WHERE kode_dept='TFC' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFC' 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='TFC-ZDAC-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFC-ZDAC-20-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-14' WHERE no_faktur_beli='FB-260314-0001';
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-20260414-0001','1','TFC-ZDAC-36-0','1','1.880','1.880','TOKO','TFC.BALIK','TOKO','TFCBR');
DELETE FROM tm_barang WHERE kode_barang='TFC-ZDAC-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFC-ZDAC-36-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFC-ZDAC-36-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFC-ZDAC-36-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCBR',tgl_last_beli='2026-04-14 13:32:46' WHERE kode_barang='TFC-ZDAC-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFC-ZDAC-36-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-04-14 13:32:46','TOKO','TFCBR','TFC','TFC-ZDAC-36-0','1','1.880','1.880','1','1.880','1.880','83.00');
DELETE FROM tm_dept WHERE kode_dept='TFC' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFC' 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='TFC-ZDAC-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFC-ZDAC-36-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-14' WHERE no_faktur_beli='FB-260330-0001';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260414-0001','2026-04-14','13:32','3.530','kasir','2026-04-14 13:32:46');
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-20260414-0002','1','PSPRT-ZDAD-2-0','1','3.490','3.490','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZDAD-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZDAD-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZDAD-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZDAD-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-04-14 13:34:24' WHERE kode_barang='PSPRT-ZDAD-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZDAD-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-04-14 13:34:24','TOKO','MMPSN','PSPRT','PSPRT-ZDAD-2-0','1','3.490','3.490','1','3.490','3.490','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZDAD-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZDAD-2-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-14' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260414-0002','2026-04-14','13:33','3.490','kasir','2026-04-14 13:34:23');
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 ('FJ-260414-0005','kasirbip','1',' 700K-12-00','TOKO','DUPERBDG','LXPER-ZBAH-16-0','CINCIN SILVER 925 ','','3.270','1','100.00','334000','0','0','17000','850000','0','0','0','850000','KUR','00041634','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZBAH-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.270',berat_jual_asli=berat_jual_asli+'3.270',stock_jual='1',berat_akhir=berat_akhir-'3.270',berat_akhir_asli=berat_akhir_asli-'3.270',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='LXPER-ZBAH-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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 ('FJ-260414-0005','2026-04-14','3.270','2026-04-14','14:21:39','PLG0010436','850000','850000','0','850000','0','kasirbip','2026-04-14 14:21:38','FJ-260414-0005','','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-04-14','FJ-260414-0005','2026-04-14','14:21:39','KUR','850000','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-260414-0005','2026-04-14','2026-04-14 14:21:38','PENJUALAN : FJ-260414-0005','','TBC','850000','850000','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-260414-0006','D','2026-04-14','14:21:39','TBC','PENJUALAN','FJ-260414-0005','21588181514','850000','21589031514','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='850000' WHERE no_faktur_jual='FJ-260414-0005' 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,keterangan) VALUES ('FJ-260414-0006','kasirbip',' 1',' 700K-17-00','TOKO','DUPERBDG','LXPER-ZDXI-22-0','CINCIN SILVER 925 ','','4.150','1','100.00','424000','0','0','17000','800000','0','0','0','800000','KUR','00042416','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZDXI-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.150',berat_jual_asli=berat_jual_asli+'4.150',stock_jual='1',berat_akhir=berat_akhir-'4.150',berat_akhir_asli=berat_akhir_asli-'4.150',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='LXPER-ZDXI-22-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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 ('FJ-260414-0006','2026-04-14','4.150','2026-04-14','14:21:39','PLG0010437','800000','800000','0','800000','0','kasirbip','2026-04-14 14:21:38','FJ-260414-0005','','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-04-14','FJ-260414-0006','2026-04-14','14:21:39','KUR','800000','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-260414-0006','2026-04-14','2026-04-14 14:21:38','PENJUALAN : FJ-260414-0006','','TBC','800000','800000','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-260414-0007','D','2026-04-14','14:21:39','TBC','PENJUALAN','FJ-260414-0006','21589031514','800000','21589831514','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='1650000' WHERE no_faktur_jual='FJ-260414-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260414-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260414-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260414-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260414-0002';
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 ('FJ-260414-0007','kasir','1',' 700K-9-724','TOKO','MMPER','PMM-ZAXG-8-0','CINCIN SILVER 925 ','','1.150','1','100.00','71000','0','0','17000','400000','0','0','0','400000','ASRI','00040771','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZAXG-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='PMM-ZAXG-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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 ('FJ-260414-0007','2026-04-14','1.150','2026-04-14','15:14:24','PLG0010438','400000','400000','0','400000','0','kasir','2026-04-14 15:14:24','FJ-260414-0007','','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-04-14','FJ-260414-0007','2026-04-14','15:14:24','ASRI','400000','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-260414-0007','2026-04-14','2026-04-14 15:14:24','PENJUALAN : FJ-260414-0007','.','TBC','400000','400000','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-260414-0008','D','2026-04-14','15:14:24','TBC','PENJUALAN','FJ-260414-0007','21589831514','400000','21590231514','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='400000' WHERE no_faktur_jual='FJ-260414-0007' 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,keterangan) VALUES ('FJ-260414-0008','kasir',' 1',' 500K-22-93','TOKO','MMPER','PMM-ZDXG-4-0','CINCIN SILVER 925 ','','2.140','1','100.00','219000','0','0','17000','450000','0','0','0','450000','ASRI','00042319','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZDXG-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.140',berat_jual_asli=berat_jual_asli+'2.140',stock_jual='1',berat_akhir=berat_akhir-'2.140',berat_akhir_asli=berat_akhir_asli-'2.140',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='PMM-ZDXG-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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 ('FJ-260414-0008','2026-04-14','2.140','2026-04-14','15:14:24','PLG0010439','450000','450000','0','450000','0','kasir','2026-04-14 15:14:24','FJ-260414-0007','','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-04-14','FJ-260414-0008','2026-04-14','15:14:24','ASRI','450000','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-260414-0008','2026-04-14','2026-04-14 15:14:24','PENJUALAN : FJ-260414-0008','.','TBC','450000','450000','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-260414-0009','D','2026-04-14','15:14:24','TBC','PENJUALAN','FJ-260414-0008','21590231514','450000','21590681514','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='850000' WHERE no_faktur_jual='FJ-260414-0008' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01953','ASRI','1','SLV','COWOK GRF YUSNA RESIZE KE 20 CROM KOMBINASI RG DAN DOFF AMPLASNYA PUTIH CEWEK GRF ADI RESIZE KE 15 5 CROM FULL ROSEGOLD','3.290','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-01953','2026-04-14','2026-04-14','15:19:22','PLG0010440','kasir','2026-04-17','kasir','2026-04-14 15:19:22','3.290','0','0','0','0','0','0','0','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-20260414-0003','1','PBDG-ZDAC-1-0','1','2.460','2.460','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDAC-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDAC-1-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDAC-1-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-14 16:14:05' WHERE kode_barang='PBDG-ZDAC-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDAC-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-04-14 16:14:05','TOKO','BIPPER','PBDG','PBDG-ZDAC-1-0','1','2.460','2.460','1','2.460','2.460','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZDAC-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-1-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-14' 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-20260414-0003','1','PBDG-ZDAC-2-0','1','2.430','2.430','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDAC-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDAC-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDAC-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-14 16:14:05' WHERE kode_barang='PBDG-ZDAC-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDAC-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-04-14 16:14:05','TOKO','BIPPER','PBDG','PBDG-ZDAC-2-0','1','2.430','2.430','1','2.430','2.430','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZDAC-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-2-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-14' 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-20260414-0003','1','PBDG-ZDAC-3-0','1','2.210','2.210','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDAC-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDAC-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDAC-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-14 16:14:05' WHERE kode_barang='PBDG-ZDAC-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDAC-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-04-14 16:14:05','TOKO','BIPPER','PBDG','PBDG-ZDAC-3-0','1','2.210','2.210','1','2.210','2.210','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZDAC-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-3-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-14' 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-20260414-0003','1','PBDG-ZDAC-4-0','1','2.180','2.180','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDAC-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDAC-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDAC-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-14 16:14:05' WHERE kode_barang='PBDG-ZDAC-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDAC-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-04-14 16:14:05','TOKO','BIPPER','PBDG','PBDG-ZDAC-4-0','1','2.180','2.180','1','2.180','2.180','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZDAC-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-4-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-14' 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-20260414-0003','1','PBDG-ZDAC-5-0','1','2.090','2.090','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDAC-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDAC-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDAC-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-14 16:14:05' WHERE kode_barang='PBDG-ZDAC-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDAC-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-04-14 16:14:05','TOKO','BIPPER','PBDG','PBDG-ZDAC-5-0','1','2.090','2.090','1','2.090','2.090','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZDAC-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-5-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-14' 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-20260414-0003','1','PBDG-ZDAC-6-0','1','2.000','2.000','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDAC-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDAC-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDAC-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-14 16:14:05' WHERE kode_barang='PBDG-ZDAC-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDAC-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-04-14 16:14:05','TOKO','BIPPER','PBDG','PBDG-ZDAC-6-0','1','2.000','2.000','1','2.000','2.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZDAC-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-6-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-14' 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-20260414-0003','1','PBDG-ZDAC-7-0','1','3.490','3.490','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDAC-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDAC-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDAC-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-14 16:14:05' WHERE kode_barang='PBDG-ZDAC-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDAC-7-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-04-14 16:14:05','TOKO','BIPPER','PBDG','PBDG-ZDAC-7-0','1','3.490','3.490','1','3.490','3.490','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZDAC-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-7-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-14' 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-20260414-0003','1','PBDG-ZDAC-8-0','1','3.880','3.880','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDAC-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDAC-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDAC-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-14 16:14:06' WHERE kode_barang='PBDG-ZDAC-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDAC-8-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-04-14 16:14:06','TOKO','BIPPER','PBDG','PBDG-ZDAC-8-0','1','3.880','3.880','1','3.880','3.880','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZDAC-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-8-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-14' 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-20260414-0003','1','PBDG-ZDAC-9-0','1','3.660','3.660','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDAC-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDAC-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDAC-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-14 16:14:06' WHERE kode_barang='PBDG-ZDAC-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDAC-9-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-04-14 16:14:06','TOKO','BIPPER','PBDG','PBDG-ZDAC-9-0','1','3.660','3.660','1','3.660','3.660','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZDAC-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-9-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-14' 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-20260414-0003','1','PBDG-ZDAC-10-0','1','3.520','3.520','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDAC-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDAC-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDAC-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-14 16:14:06' WHERE kode_barang='PBDG-ZDAC-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDAC-10-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-04-14 16:14:06','TOKO','BIPPER','PBDG','PBDG-ZDAC-10-0','1','3.520','3.520','1','3.520','3.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZDAC-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-10-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-14' 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-20260414-0003','1','PBDG-ZDAC-11-0','1','3.760','3.760','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDAC-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDAC-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDAC-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-14 16:14:06' WHERE kode_barang='PBDG-ZDAC-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDAC-11-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-04-14 16:14:06','TOKO','BIPPER','PBDG','PBDG-ZDAC-11-0','1','3.760','3.760','1','3.760','3.760','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZDAC-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-11-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-14' 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-20260414-0003','1','PBDG-ZDAC-12-0','1','2.430','2.430','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDAC-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDAC-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDAC-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-14 16:14:06' WHERE kode_barang='PBDG-ZDAC-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDAC-12-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-04-14 16:14:06','TOKO','BIPPER','PBDG','PBDG-ZDAC-12-0','1','2.430','2.430','1','2.430','2.430','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZDAC-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-12-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-14' 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-20260414-0003','1','PBDG-ZDAC-13-0','1','2.240','2.240','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDAC-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDAC-13-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDAC-13-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-14 16:14:06' WHERE kode_barang='PBDG-ZDAC-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDAC-13-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-04-14 16:14:06','TOKO','BIPPER','PBDG','PBDG-ZDAC-13-0','1','2.240','2.240','1','2.240','2.240','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZDAC-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-13-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-14' 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-20260414-0003','1','PBDG-ZDAC-14-0','1','2.430','2.430','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDAC-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDAC-14-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDAC-14-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-14 16:14:06' WHERE kode_barang='PBDG-ZDAC-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDAC-14-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-04-14 16:14:06','TOKO','BIPPER','PBDG','PBDG-ZDAC-14-0','1','2.430','2.430','1','2.430','2.430','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZDAC-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDAC-14-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-14' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260414-0003','2026-04-14','16:13','38.780','kasirbip','2026-04-14 16:14:05');
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 ('FJ-260414-0009','kasirbip','1',' 1.1K-10-24','TOKO','BIPPER','PBDG-ZDAC-13-0','CINCIN SILVER 925 ','','2.240','1','100.00','229000','0','0','17000','1200000','0','0','0','1200000','SULIS','00042480','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDAC-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.240',berat_jual_asli=berat_jual_asli+'2.240',stock_jual='1',berat_akhir=berat_akhir-'2.240',berat_akhir_asli=berat_akhir_asli-'2.240',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='PBDG-ZDAC-13-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-260414-0009','2026-04-14','2.240','2026-04-14','17:45:25','PLG0010441','1200000','1200000','0','1200000','0','kasirbip','2026-04-14 17:45:25','FJ-260414-0009','','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-04-14','FJ-260414-0009','2026-04-14','17:45:25','SULIS','1200000','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-260414-0009','2026-04-14','2026-04-14 17:45:25','PENJUALAN : FJ-260414-0009','.','TBC','1200000','1200000','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-260414-0010','D','2026-04-14','17:45:25','TBC','PENJUALAN','FJ-260414-0009','21590681514','1200000','21591881514','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='1200000' WHERE no_faktur_jual='FJ-260414-0009' 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,keterangan) VALUES ('FJ-260414-0010','kasirbip',' 1',' 700K-175-2','TOKO','BIPPER','PBDG-ZDXG-35-0','CINCIN SILVER 925 ','','2.380','1','100.00','243000','0','0','17000','800000','0','0','0','800000','SULIS','00042350','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDXG-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.380',berat_jual_asli=berat_jual_asli+'2.380',stock_jual='1',berat_akhir=berat_akhir-'2.380',berat_akhir_asli=berat_akhir_asli-'2.380',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='PBDG-ZDXG-35-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-260414-0010','2026-04-14','2.380','2026-04-14','17:45:25','PLG0010442','800000','800000','0','800000','0','kasirbip','2026-04-14 17:45:25','FJ-260414-0009','','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-04-14','FJ-260414-0010','2026-04-14','17:45:25','SULIS','800000','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-260414-0010','2026-04-14','2026-04-14 17:45:25','PENJUALAN : FJ-260414-0010','.','TBC','800000','800000','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-260414-0011','D','2026-04-14','17:45:25','TBC','PENJUALAN','FJ-260414-0010','21591881514','800000','21592681514','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='2000000' WHERE no_faktur_jual='FJ-260414-0010' LIMIT 1;
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-00000344','X-00000344','GIWANG TFA-21109','GR','---','TFA','BELI','BELI001','12400000','2026-04-14','3.640','1','kasir','2026-04-14 17:45:56');
DELETE FROM tp_barang WHERE kode_dept = 'X-TFA';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-TFA','X-00000344','X-00000344');
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-260414-0001','FJ-260130-0010','FIR','1','BELI','BELI001','TFA', 'X-00000344', 'GIWANG TFA-21109','3.640','3.640','75.00','15500000','12400000','3406593','1','12400000','12400000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.640',berat_beli_asli=berat_beli_asli+'3.640',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.640',berat_akhir_asli=berat_akhir_asli+'3.640',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='TFA' 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,type_bayar) VALUES ('FB-260414-0001','2026-04-14','2026-04-14','17:45:55','FIR','---','3.640','12400000','12400000','12400000','12400000','12400000','kasir','2026-04-14 17:45:56','FB-260414-0001','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260414-0001','KHAIRANY','JKT','','JKT','0','kasir','2026-04-14 17:45:56');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260414-0011','2026-04-14','2026-04-14 17:45:56','PEMBELIAN UMUM : FB-260414-0001','.','TBC','12400000','12400000');
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 ('KK-260414-0012','K','2026-04-14','17:45:55','TBC','PEMBELIAN UMUM','FB-260414-0001','21592681514','12400000','21580281514','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260414-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260414-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260414-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260414-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260414-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260414-0010';
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-260414-0002','K','2026-04-14','17:49:46','kasir','BELANJA','BAYAR WIFI THIFA','5361100','450000','4911100');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-04-14 ','17:58:36');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01952','ASRI','1','PLD','WEDDING RING','','','5.000','','10.00','1','1200000','300000','0','700000','2200000','size 25 crom putih doff amplas','grf deby & cipto','model papan list 5 mili','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260414-0012','2026-04-14','2026-04-14 18:19:32','PESANAN : DP-01952','.','TBC','1760000','1760000');
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-260414-0013','D','2026-04-14','18:19:32','TBC','PESANAN','DP-01952','21580281514','1760000','21582041514','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01952','2026-04-14','2026-04-14','18:19:32','PLG0010443','ASRI','2026-04-28','kasir','2026-04-14 18:19:32','5.000','0','0','0','1760000','0','700000','2200000','2200000','440000');
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 ('FJ-260414-0011','kasir','1',' TFCMR75-85','TOKO','TFCINMAS','TFCMR-ZBBF-73-0','THIFA CINCIN MAS RG ','','2.980','1','85.00','6589000','0','0','17000','6600000','0','0','0','6600000','FIR','00041972','TFCMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-ZBBF-73-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.980',berat_jual_asli=berat_jual_asli+'2.980',stock_jual='1',berat_akhir=berat_akhir-'2.980',berat_akhir_asli=berat_akhir_asli-'2.980',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='TFCMR-ZBBF-73-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' 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 ('FJ-260414-0011','2026-04-14','2.980','2026-04-14','18:41:32','PLG0010444','6600000','6600000','0','6600000','0','kasir','2026-04-14 18:41:31','FJ-260414-0011','','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-04-14','FJ-260414-0011','2026-04-14','18:41:32','FIR','6600000','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-260414-0013','2026-04-14','2026-04-14 18:41:31','PENJUALAN : FJ-260414-0011','.','TBC','6600000','6600000','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-260414-0014','D','2026-04-14','18:41:32','TBC','PENJUALAN','FJ-260414-0011','21582041514','6600000','21588641514','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='6600000' WHERE no_faktur_jual='FJ-260414-0011' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260414-0011';
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 ('FJ-260414-0012','kasirbip','1',' 750K-9-002','TOKO','DUPERBDG','LXPER-ZDXI-41-0','CINCIN SILVER 925 ','','2.400','1','100.00','245000','0','0','17000','850000','0','0','0','850000','PUT','00042435','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZDXI-41-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.400',berat_jual_asli=berat_jual_asli+'2.400',stock_jual='1',berat_akhir=berat_akhir-'2.400',berat_akhir_asli=berat_akhir_asli-'2.400',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='LXPER-ZDXI-41-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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 ('FJ-260414-0012','2026-04-14','2.400','2026-04-14','18:42:53','PLG0010445','850000','850000','0','850000','0','kasirbip','2026-04-14 18:42:53','FJ-260414-0012','','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-04-14','FJ-260414-0012','2026-04-14','18:42:53','PUT','850000','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-260414-0014','2026-04-14','2026-04-14 18:42:53','PENJUALAN : FJ-260414-0012','','TBC','850000','850000','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-260414-0015','D','2026-04-14','18:42:53','TBC','PENJUALAN','FJ-260414-0012','21588641514','850000','21589491514','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='850000' WHERE no_faktur_jual='FJ-260414-0012' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260414-0012';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01954','SULIS','1','CC SILVER','SZ 14 5 FONT TIMES NEW ROMAN PUTIH DOFF AMPLASS','2.000','1','50000','50000');
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-260414-0015','2026-04-14','2026-04-14 20:19:44','SERVICE : SV-01954','.','TBC','50000','50000','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-260414-0016','D','2026-04-14','20:19:44','TBC','SERVICE','SV-01954','21589491514','50000','21589541514','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
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-01954','2026-04-14','2026-04-14','20:19:44','PLG0010446','kasirbip','2026-05-03','kasirbip','2026-04-14 20:19:44','2.000','0','0','0','50000','0','50000','50000','0');
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 ('FJ-260414-0013','kasirbip','1',' 1.1K-14-23','TOKO','BIPPER','PBDG-ZDXG-13-0','CINCIN SILVER 925 ','','2.610','1','100.00','267000','0','0','17000','1200000','0','0','0','1200000','MIA','00042328','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDXG-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.610',berat_jual_asli=berat_jual_asli+'2.610',stock_jual='1',berat_akhir=berat_akhir-'2.610',berat_akhir_asli=berat_akhir_asli-'2.610',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='PBDG-ZDXG-13-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-260414-0013','2026-04-14','2.610','2026-04-14','20:26:33','PLG0010447','1200000','1200000','0','1200000','0','kasirbip','2026-04-14 20:26:32','FJ-260414-0013','','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-04-14','FJ-260414-0013','2026-04-14','20:26:33','MIA','1200000','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-260414-0016','2026-04-14','2026-04-14 20:26:32','PENJUALAN : FJ-260414-0013','.','TBC','1200000','1200000','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-260414-0017','D','2026-04-14','20:26:33','TBC','PENJUALAN','FJ-260414-0013','21589541514','1200000','21590741514','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='1200000' WHERE no_faktur_jual='FJ-260414-0013' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01953','MIA','1','PER','WED RING','','','3.000','','925.00','1','100000','0','1000000','0','1000000','SZ 23 PUTIH DOFF SEMPROT','1 ZIRCON','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260414-0017','2026-04-14','2026-04-14 20:29:27','PESANAN : DP-01953','.','TBC','1000000','1000000');
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-260414-0018','D','2026-04-14','20:29:27','TBC','PESANAN','DP-01953','21590741514','1000000','21591741514','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01953','2026-04-14','2026-04-14','20:29:27','PLG0010448','MIA','2026-05-01','kasirbip','2026-04-14 20:29:27','3.000','0','0','0','1000000','0','0','1000000','1000000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('owner','2026-04-14 ','20:39:48');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-14 ','20:41:12');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2026-04-14 20:41:32');
CREATE TABLE th_20260414_204132 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20260414_204132_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='DUPERBDG' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2026-04-14',jam_taking= '20:42:26',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-68-0' AND kode_barcode='00042383';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-68-0','00042383','2026-04-14',' 20:44:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-74-0' AND kode_barcode='00041735';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-74-0','00041735','2026-04-14',' 20:44:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXI-25-0' AND kode_barcode='00042419';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXI-25-0','00042419','2026-04-14',' 20:45:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-62-0' AND kode_barcode='00042377';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-62-0','00042377','2026-04-14',' 20:45:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBAG-22-0' AND kode_barcode='00041598';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBAG-22-0','00041598','2026-04-14',' 20:45:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-53-0' AND kode_barcode='00042368';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-53-0','00042368','2026-04-14',' 20:45:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-44-0' AND kode_barcode='00041705';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-44-0','00041705','2026-04-14',' 20:46:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-49-0' AND kode_barcode='00042364';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-49-0','00042364','2026-04-14',' 20:46:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-59-0' AND kode_barcode='00042374';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-59-0','00042374','2026-04-14',' 20:46:39','1','kasir');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260414-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260414-0013';
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-55-0' AND kode_barcode='00042370';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-55-0','00042370','2026-04-14',' 20:46:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-40-0' AND kode_barcode='00041701';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-40-0','00041701','2026-04-14',' 20:47:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-65-0' AND kode_barcode='00042380';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-65-0','00042380','2026-04-14',' 20:47:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-71-0' AND kode_barcode='00041732';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-71-0','00041732','2026-04-14',' 20:47:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-33-0' AND kode_barcode='00041694';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-33-0','00041694','2026-04-14',' 20:47:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-49-0' AND kode_barcode='00041710';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-49-0','00041710','2026-04-14',' 20:47:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZCXB-39-0' AND kode_barcode='00042100';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZCXB-39-0','00042100','2026-04-14',' 20:48:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-75-0' AND kode_barcode='00042390';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-75-0','00042390','2026-04-14',' 20:48:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-69-0' AND kode_barcode='00041730';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-69-0','00041730','2026-04-14',' 20:48:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-61-0' AND kode_barcode='00041722';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-61-0','00041722','2026-04-14',' 20:48:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-27-0' AND kode_barcode='00041688';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-27-0','00041688','2026-04-14',' 20:48:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-15-0' AND kode_barcode='00041676';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-15-0','00041676','2026-04-14',' 20:49:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-54-0' AND kode_barcode='00042369';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-54-0','00042369','2026-04-14',' 20:49:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-58-0' AND kode_barcode='00042373';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-58-0','00042373','2026-04-14',' 20:49:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-28-0' AND kode_barcode='00041689';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-28-0','00041689','2026-04-14',' 20:49:49','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-11-0' AND kode_barcode='00041672';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-11-0','00041672','2026-04-14',' 20:50:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-61-0' AND kode_barcode='00042376';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-61-0','00042376','2026-04-14',' 20:50:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-63-0' AND kode_barcode='00041724';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-63-0','00041724','2026-04-14',' 20:50:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-45-0' AND kode_barcode='00041706';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-45-0','00041706','2026-04-14',' 20:50:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBD-36-0' AND kode_barcode='00041782';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBD-36-0','00041782','2026-04-14',' 20:51:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-9-0' AND kode_barcode='00041670';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-9-0','00041670','2026-04-14',' 20:51:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-19-0' AND kode_barcode='00041680';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-19-0','00041680','2026-04-14',' 20:51:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-65-0' AND kode_barcode='00041726';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-65-0','00041726','2026-04-14',' 20:51:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBD-24-0' AND kode_barcode='00041770';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBD-24-0','00041770','2026-04-14',' 20:52:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXI-29-0' AND kode_barcode='00042423';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXI-29-0','00042423','2026-04-14',' 20:52:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZCXB-25-0' AND kode_barcode='00042086';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZCXB-25-0','00042086','2026-04-14',' 20:52:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBD-13-0' AND kode_barcode='00041759';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBD-13-0','00041759','2026-04-14',' 20:52:36','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBD-22-0' AND kode_barcode='00041768';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBD-22-0','00041768','2026-04-14',' 20:53:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-71-0' AND kode_barcode='00042386';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-71-0','00042386','2026-04-14',' 20:53:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXI-36-0' AND kode_barcode='00042430';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXI-36-0','00042430','2026-04-14',' 20:53:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZCXB-32-0' AND kode_barcode='00042093';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZCXB-32-0','00042093','2026-04-14',' 20:53:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-56-0' AND kode_barcode='00042371';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-56-0','00042371','2026-04-14',' 20:54:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-51-0' AND kode_barcode='00042366';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-51-0','00042366','2026-04-14',' 20:54:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXI-43-0' AND kode_barcode='00042437';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXI-43-0','00042437','2026-04-14',' 20:54:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBAG-5-0' AND kode_barcode='00041581';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBAG-5-0','00041581','2026-04-14',' 20:54:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-67-0' AND kode_barcode='00042382';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-67-0','00042382','2026-04-14',' 20:55:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-76-0' AND kode_barcode='00042391';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-76-0','00042391','2026-04-14',' 20:55:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXI-40-0' AND kode_barcode='00042434';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXI-40-0','00042434','2026-04-14',' 20:55:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-64-0' AND kode_barcode='00042379';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-64-0','00042379','2026-04-14',' 20:55:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-73-0' AND kode_barcode='00042388';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-73-0','00042388','2026-04-14',' 20:55:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-72-0' AND kode_barcode='00042387';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-72-0','00042387','2026-04-14',' 20:56:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZCXB-37-0' AND kode_barcode='00042098';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZCXB-37-0','00042098','2026-04-14',' 20:56:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-39-0' AND kode_barcode='00041700';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-39-0','00041700','2026-04-14',' 20:56:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-57-0' AND kode_barcode='00042372';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-57-0','00042372','2026-04-14',' 20:56:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBD-20-0' AND kode_barcode='00041766';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBD-20-0','00041766','2026-04-14',' 20:56:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-22-0' AND kode_barcode='00041683';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-22-0','00041683','2026-04-14',' 20:56:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZCXB-7-0' AND kode_barcode='00042068';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZCXB-7-0','00042068','2026-04-14',' 20:57:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBD-28-0' AND kode_barcode='00041774';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBD-28-0','00041774','2026-04-14',' 20:58:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBAG-9-0' AND kode_barcode='00041585';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBAG-9-0','00041585','2026-04-14',' 20:58:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZCXB-8-0' AND kode_barcode='00042069';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZCXB-8-0','00042069','2026-04-14',' 20:58:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-31-0' AND kode_barcode='00041692';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-31-0','00041692','2026-04-14',' 20:58:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-20-0' AND kode_barcode='00041681';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-20-0','00041681','2026-04-14',' 20:59:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBD-25-0' AND kode_barcode='00041771';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBD-25-0','00041771','2026-04-14',' 20:59:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXI-34-0' AND kode_barcode='00042428';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXI-34-0','00042428','2026-04-14',' 20:59:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZCXB-38-0' AND kode_barcode='00042099';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZCXB-38-0','00042099','2026-04-14',' 20:59:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-52-0' AND kode_barcode='00041713';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-52-0','00041713','2026-04-14',' 20:59:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZCXB-1-0' AND kode_barcode='00042062';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZCXB-1-0','00042062','2026-04-14',' 20:59:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXI-39-0' AND kode_barcode='00042433';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXI-39-0','00042433','2026-04-14',' 21:00:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-25-0' AND kode_barcode='00041686';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-25-0','00041686','2026-04-14',' 21:00:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-30-0' AND kode_barcode='00041691';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-30-0','00041691','2026-04-14',' 21:00:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXI-35-0' AND kode_barcode='00042429';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXI-35-0','00042429','2026-04-14',' 21:00:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXI-30-0' AND kode_barcode='00042424';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXI-30-0','00042424','2026-04-14',' 21:01:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXI-33-0' AND kode_barcode='00042427';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXI-33-0','00042427','2026-04-14',' 21:01:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZCXB-6-0' AND kode_barcode='00042067';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZCXB-6-0','00042067','2026-04-14',' 21:01:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBAG-4-0' AND kode_barcode='00041580';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBAG-4-0','00041580','2026-04-14',' 21:01:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXI-27-0' AND kode_barcode='00042421';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXI-27-0','00042421','2026-04-14',' 21:01:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZCXB-44-0' AND kode_barcode='00042105';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZCXB-44-0','00042105','2026-04-14',' 21:01:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXI-32-0' AND kode_barcode='00042426';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXI-32-0','00042426','2026-04-14',' 21:02:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXI-42-0' AND kode_barcode='00042436';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXI-42-0','00042436','2026-04-14',' 21:02:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-41-0' AND kode_barcode='00041702';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-41-0','00041702','2026-04-14',' 21:02:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-67-0' AND kode_barcode='00041728';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-67-0','00041728','2026-04-14',' 21:02:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-43-0' AND kode_barcode='00041704';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-43-0','00041704','2026-04-14',' 21:02:49','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZCXB-29-0' AND kode_barcode='00042090';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZCXB-29-0','00042090','2026-04-14',' 21:02:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-70-0' AND kode_barcode='00042385';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-70-0','00042385','2026-04-14',' 21:03:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-68-0' AND kode_barcode='00041729';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-68-0','00041729','2026-04-14',' 21:03:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBD-30-0' AND kode_barcode='00041776';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBD-30-0','00041776','2026-04-14',' 21:03:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-55-0' AND kode_barcode='00041716';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-55-0','00041716','2026-04-14',' 21:03:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBAH-21-0' AND kode_barcode='00041639';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBAH-21-0','00041639','2026-04-14',' 21:03:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-38-0' AND kode_barcode='00041699';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-38-0','00041699','2026-04-14',' 21:04:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXI-31-0' AND kode_barcode='00042425';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXI-31-0','00042425','2026-04-14',' 21:04:11','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBD-21-0' AND kode_barcode='00041767';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBD-21-0','00041767','2026-04-14',' 21:04:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXI-23-0' AND kode_barcode='00042417';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXI-23-0','00042417','2026-04-14',' 21:04:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-63-0' AND kode_barcode='00042378';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-63-0','00042378','2026-04-14',' 21:04:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXI-26-0' AND kode_barcode='00042420';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXI-26-0','00042420','2026-04-14',' 21:04:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZCXB-45-0' AND kode_barcode='00042106';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZCXB-45-0','00042106','2026-04-14',' 21:04:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZCXB-40-0' AND kode_barcode='00042101';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZCXB-40-0','00042101','2026-04-14',' 21:05:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-58-0' AND kode_barcode='00041719';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-58-0','00041719','2026-04-14',' 21:05:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBAH-32-0' AND kode_barcode='00041650';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBAH-32-0','00041650','2026-04-14',' 21:06:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-32-0' AND kode_barcode='00041693';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-32-0','00041693','2026-04-14',' 21:06:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-48-0' AND kode_barcode='00042363';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-48-0','00042363','2026-04-14',' 21:06:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXI-21-0' AND kode_barcode='00042415';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXI-21-0','00042415','2026-04-14',' 21:07:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZCXB-47-0' AND kode_barcode='00042108';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZCXB-47-0','00042108','2026-04-14',' 21:07:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZCXB-34-0' AND kode_barcode='00042095';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZCXB-34-0','00042095','2026-04-14',' 21:07:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZCXB-23-0' AND kode_barcode='00042084';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZCXB-23-0','00042084','2026-04-14',' 21:07:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBAG-18-0' AND kode_barcode='00041594';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBAG-18-0','00041594','2026-04-14',' 21:08:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-74-0' AND kode_barcode='00042389';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-74-0','00042389','2026-04-14',' 21:08:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZCXB-12-0' AND kode_barcode='00042073';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZCXB-12-0','00042073','2026-04-14',' 21:08:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-53-0' AND kode_barcode='00041714';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-53-0','00041714','2026-04-14',' 21:08:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-35-0' AND kode_barcode='00041696';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-35-0','00041696','2026-04-14',' 21:09:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXI-28-0' AND kode_barcode='00042422';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXI-28-0','00042422','2026-04-14',' 21:09:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXI-38-0' AND kode_barcode='00042432';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXI-38-0','00042432','2026-04-14',' 21:09:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZCXB-31-0' AND kode_barcode='00042092';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZCXB-31-0','00042092','2026-04-14',' 21:09:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBD-33-0' AND kode_barcode='00041779';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBD-33-0','00041779','2026-04-14',' 21:09:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBD-29-0' AND kode_barcode='00041775';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBD-29-0','00041775','2026-04-14',' 21:09:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-47-0' AND kode_barcode='00041708';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-47-0','00041708','2026-04-14',' 21:10:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZDXG-47-0' AND kode_barcode='00042362';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZDXG-47-0','00042362','2026-04-14',' 21:10:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZCXB-41-0' AND kode_barcode='00042102';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZCXB-41-0','00042102','2026-04-14',' 21:10:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-8-0' AND kode_barcode='00041669';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-8-0','00041669','2026-04-14',' 21:10:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZCXB-4-0' AND kode_barcode='00042065';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZCXB-4-0','00042065','2026-04-14',' 21:10:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-7-0' AND kode_barcode='00041668';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-7-0','00041668','2026-04-14',' 21:11:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LXPER-ZBBC-23-0' AND kode_barcode='00041684';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LXPER-ZBBC-23-0','00041684','2026-04-14',' 21:11:11','1','kasir');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-14 ','21:13:42');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2026-04-14 21:14:00');
CREATE TABLE th_20260414_211400 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20260414_211400_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2026-04-14 21:14:08');
CREATE TABLE th_20260414_211408 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20260414_211408_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-04-14 ','21:39:01');