INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-28 ','09:56:25');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-28','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-28';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-27';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-27';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-02-27' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-27';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-27';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-27';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-27';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202601 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
UPDATE tt_barang_saldo SET tanggal= '2026-02-28' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-27' 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-260228-0001','D','2026-02-28','10:05:18','TBC','SALDO AWAL','SALDO AWAL','0','20692790514','20692790514');
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-260228-0001','D','2026-02-28','10:05:18','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-260228-0001','D','2026-02-28','10:05:18','BCD','SALDO AWAL','SALDO AWAL','0','1350233500','1350233500');
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-260228-0001','D','2026-02-28','10:05:18','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-260228-0001','D','2026-02-28','10:05:18','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-260228-0001','D','2026-02-28','10:05:18','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-260228-0001','D','2026-02-28','10:05:18','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-260228-0001','D','2026-02-28','10:05:18','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-260228-0001','D','2026-02-28','10:05:18','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-260228-0001','D','2026-02-28','10:05:18','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-260228-0001','D','2026-02-28','10:05:18','BCK','SALDO AWAL','SALDO AWAL','0','1967608000','1967608000');
UPDATE tp_system SET tgl_system='2026-02-28';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-28 ','10:27:02');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-28 ','10:47:41');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2026-02-28 10:47:55');
CREATE TABLE th_20260228_104755 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20260228_104755_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 ='MMCBR' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2026-02-28',jam_taking= '10:48:08',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='CBRMM-YGXD-1-0' AND kode_barcode='00036947';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CBRMM-YGXD-1-0','00036947','2026-02-28',' 10:50:43','1','kasir');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2026-02-28 10:52:32');
CREATE TABLE th_20260228_105232 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20260228_105232_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 ='MMCKB' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2026-02-28',jam_taking= '10:52:44',input_by='kasir';
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 ='MMCKB' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2026-02-28',jam_taking= '10:53:04',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='CKBMM-YFCX-30-0' AND kode_barcode='00036831';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKBMM-YFCX-30-0','00036831','2026-02-28',' 10:53:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CKBMM-YFCX-23-0' AND kode_barcode='00036824';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKBMM-YFCX-23-0','00036824','2026-02-28',' 10:53:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CKBMM-YFCX-24-0' AND kode_barcode='00036825';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKBMM-YFCX-24-0','00036825','2026-02-28',' 10:53:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CKBMM-YFCX-27-0' AND kode_barcode='00036828';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKBMM-YFCX-27-0','00036828','2026-02-28',' 10:53:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CKBMM-YFCX-22-0' AND kode_barcode='00036823';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKBMM-YFCX-22-0','00036823','2026-02-28',' 10:53:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CKBMM-YFCX-31-0' AND kode_barcode='00036832';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKBMM-YFCX-31-0','00036832','2026-02-28',' 10:53:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CKBMM-YFCX-26-0' AND kode_barcode='00036827';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKBMM-YFCX-26-0','00036827','2026-02-28',' 10:53:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CKBMM-YFCX-25-0' AND kode_barcode='00036826';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKBMM-YFCX-25-0','00036826','2026-02-28',' 10:53:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CKBMM-YFCX-29-0' AND kode_barcode='00036830';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKBMM-YFCX-29-0','00036830','2026-02-28',' 10:53:57','1','kasir');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2026-02-28 10:54:46');
CREATE TABLE th_20260228_105446 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20260228_105446_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 ='MMCM' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2026-02-28',jam_taking= '10:55:01',input_by='kasir';
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 ='MMCM' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2026-02-28',jam_taking= '10:55:12',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-ZBAF-21-0' AND kode_barcode='00041576';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-ZBAF-21-0','00041576','2026-02-28',' 10:55:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-YFBC-13-0' AND kode_barcode='00036623';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-YFBC-13-0','00036623','2026-02-28',' 10:55:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-YFBC-11-0' AND kode_barcode='00036621';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-YFBC-11-0','00036621','2026-02-28',' 10:55:49','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-ZBAF-19-0' AND kode_barcode='00041574';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-ZBAF-19-0','00041574','2026-02-28',' 10:55:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-YGAG-25-0' AND kode_barcode='00037288';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-YGAG-25-0','00037288','2026-02-28',' 10:55:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-YFBC-14-0' AND kode_barcode='00036624';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-YFBC-14-0','00036624','2026-02-28',' 10:56:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-YGAG-11-0' AND kode_barcode='00037274';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-YGAG-11-0','00037274','2026-02-28',' 10:56:11','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-ZABA-15-0' AND kode_barcode='00041062';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-ZABA-15-0','00041062','2026-02-28',' 10:56:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-YGAG-17-0' AND kode_barcode='00037280';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-YGAG-17-0','00037280','2026-02-28',' 10:56:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-YGAG-20-0' AND kode_barcode='00037283';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-YGAG-20-0','00037283','2026-02-28',' 10:56:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-YGAG-15-0' AND kode_barcode='00037278';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-YGAG-15-0','00037278','2026-02-28',' 10:56:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-YFBC-18-0' AND kode_barcode='00036628';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-YFBC-18-0','00036628','2026-02-28',' 10:56:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-YFBC-16-0' AND kode_barcode='00036626';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-YFBC-16-0','00036626','2026-02-28',' 10:56:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-YGAG-10-0' AND kode_barcode='00037273';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-YGAG-10-0','00037273','2026-02-28',' 10:57:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-YGAG-9-0' AND kode_barcode='00037272';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-YGAG-9-0','00037272','2026-02-28',' 10:57:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-YGXA-20-0' AND kode_barcode='00036852';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-YGXA-20-0','00036852','2026-02-28',' 10:57:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-ZABA-13-0' AND kode_barcode='00041060';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-ZABA-13-0','00041060','2026-02-28',' 10:57:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-YGXA-23-0' AND kode_barcode='00036855';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-YGXA-23-0','00036855','2026-02-28',' 10:57:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-YGAG-21-0' AND kode_barcode='00037284';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-YGAG-21-0','00037284','2026-02-28',' 10:57:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-YFBC-17-0' AND kode_barcode='00036627';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-YFBC-17-0','00036627','2026-02-28',' 10:57:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-YGXA-21-0' AND kode_barcode='00036853';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-YGXA-21-0','00036853','2026-02-28',' 10:57:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-ZBAF-20-0' AND kode_barcode='00041575';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-ZBAF-20-0','00041575','2026-02-28',' 10:58:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-ZBAF-18-0' AND kode_barcode='00041573';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-ZBAF-18-0','00041573','2026-02-28',' 10:58:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-YGXA-16-0' AND kode_barcode='00036848';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-YGXA-16-0','00036848','2026-02-28',' 10:59:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-ZABA-12-0' AND kode_barcode='00041059';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-ZABA-12-0','00041059','2026-02-28',' 10:59:11','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-YGXG-25-0' AND kode_barcode='00037019';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-YGXG-25-0','00037019','2026-02-28',' 10:59:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMMM-YKAA-6-0' AND kode_barcode='00039558';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMMM-YKAA-6-0','00039558','2026-02-28',' 10:59:25','1','kasir');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2026-02-28 11:01:05');
CREATE TABLE th_20260228_110105 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20260228_110105_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 ='MMPLD' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2026-02-28',jam_taking= '11:01:17',input_by='kasir';
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 ='MMPLD' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2026-02-28',jam_taking= '11:01:33',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-ZACX-40-0' AND kode_barcode='00041254';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-ZACX-40-0','00041254','2026-02-28',' 11:02:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-YLBB-7-0' AND kode_barcode='00040657';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-YLBB-7-0','00040657','2026-02-28',' 11:02:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-ZACX-38-0' AND kode_barcode='00041252';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-ZACX-38-0','00041252','2026-02-28',' 11:02:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-ZACX-18-0' AND kode_barcode='00041232';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-ZACX-18-0','00041232','2026-02-28',' 11:02:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-ZACX-16-0' AND kode_barcode='00041230';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-ZACX-16-0','00041230','2026-02-28',' 11:03:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-YLAA-2-0' AND kode_barcode='00040537';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-YLAA-2-0','00040537','2026-02-28',' 11:03:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-ZACX-12-0' AND kode_barcode='00041226';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-ZACX-12-0','00041226','2026-02-28',' 11:03:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-ZAAE-43-0' AND kode_barcode='00040928';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-ZAAE-43-0','00040928','2026-02-28',' 11:03:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-ZACX-36-0' AND kode_barcode='00041250';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-ZACX-36-0','00041250','2026-02-28',' 11:03:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-ZAAE-35-0' AND kode_barcode='00040920';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-ZAAE-35-0','00040920','2026-02-28',' 11:03:36','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-ZAAE-37-0' AND kode_barcode='00040922';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-ZAAE-37-0','00040922','2026-02-28',' 11:03:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-ZACX-19-0' AND kode_barcode='00041233';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-ZACX-19-0','00041233','2026-02-28',' 11:05:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-ZAAE-36-0' AND kode_barcode='00040921';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-ZAAE-36-0','00040921','2026-02-28',' 11:05:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-ZACX-39-0' AND kode_barcode='00041253';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-ZACX-39-0','00041253','2026-02-28',' 11:05:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-ZACX-11-0' AND kode_barcode='00041225';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-ZACX-11-0','00041225','2026-02-28',' 11:05:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-ZAAE-44-0' AND kode_barcode='00040929';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-ZAAE-44-0','00040929','2026-02-28',' 11:05:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-ZACX-20-0' AND kode_barcode='00041234';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-ZACX-20-0','00041234','2026-02-28',' 11:05:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-ZAAE-42-0' AND kode_barcode='00040927';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-ZAAE-42-0','00040927','2026-02-28',' 11:05:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-ZACX-15-0' AND kode_barcode='00041229';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-ZACX-15-0','00041229','2026-02-28',' 11:05:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-ZACX-13-0' AND kode_barcode='00041227';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-ZACX-13-0','00041227','2026-02-28',' 11:05:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-ZACX-37-0' AND kode_barcode='00041251';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-ZACX-37-0','00041251','2026-02-28',' 11:05:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-ZAAE-34-0' AND kode_barcode='00040919';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-ZAAE-34-0','00040919','2026-02-28',' 11:06:02','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-ZACX-35-0' AND kode_barcode='00041249';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-ZACX-35-0','00041249','2026-02-28',' 11:06:11','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PLDMM-YLXI-2-0' AND kode_barcode='00040390';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PLDMM-YLXI-2-0','00040390','2026-02-28',' 11:06:18','1','kasir');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2026-02-28 11:08:57');
CREATE TABLE th_20260228_110857 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20260228_110857_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 ='MMPSN' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2026-02-28',jam_taking= '11:09:21',input_by='kasir';
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 ='MMPSN' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2026-02-28',jam_taking= '11:09:45',input_by='kasir';
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 ='MMPSN' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2026-02-28',jam_taking= '11:11:48',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='PSGT-ZBBF-97-0' AND kode_barcode='00041996';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PSGT-ZBBF-97-0','00041996','2026-02-28',' 11:13:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PSPLT-ZBBF-100-0' AND kode_barcode='00041999';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PSPLT-ZBBF-100-0','00041999','2026-02-28',' 11:13:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PSPRT-ZBBF-98-0' AND kode_barcode='00041997';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PSPRT-ZBBF-98-0','00041997','2026-02-28',' 11:14:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PSPLT-ZBBD-39-0' AND kode_barcode='00041785';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PSPLT-ZBBD-39-0','00041785','2026-02-28',' 11:14:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PSPLT-ZBBG-53-0' AND kode_barcode='00042055';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PSPLT-ZBBG-53-0','00042055','2026-02-28',' 11:14:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PSPLT-ZBBD-38-0' AND kode_barcode='00041784';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PSPLT-ZBBD-38-0','00041784','2026-02-28',' 11:14:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PSPRT-ZBBD-40-0' AND kode_barcode='00041786';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PSPRT-ZBBD-40-0','00041786','2026-02-28',' 11:14:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PSPLT-ZBBG-54-0' AND kode_barcode='00042056';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PSPLT-ZBBG-54-0','00042056','2026-02-28',' 11:14:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PSPLT-ZBBC-3-0' AND kode_barcode='00041664';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PSPLT-ZBBC-3-0','00041664','2026-02-28',' 11:14:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PSGT-ZBAH-1-0' AND kode_barcode='00041619';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PSGT-ZBAH-1-0','00041619','2026-02-28',' 11:14:41','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PSGT-ZBBF-95-0' AND kode_barcode='00041994';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PSGT-ZBBF-95-0','00041994','2026-02-28',' 11:14:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PSPLT-ZBBG-52-0' AND kode_barcode='00042054';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PSPLT-ZBBG-52-0','00042054','2026-02-28',' 11:14:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PSPLT-ZBBF-99-0' AND kode_barcode='00041998';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PSPLT-ZBBF-99-0','00041998','2026-02-28',' 11:14:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PSGT-ZBBF-96-0' AND kode_barcode='00041995';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PSGT-ZBBF-96-0','00041995','2026-02-28',' 11:15:04','1','kasir');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2026-02-28 11:16:26');
CREATE TABLE th_20260228_111626 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20260228_111626_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 ='MMPER' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2026-02-28',jam_taking= '11:16:35',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBBG-16-0' AND kode_barcode='00042018';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBBG-16-0','00042018','2026-02-28',' 11:17:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBBG-18-0' AND kode_barcode='00042020';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBBG-18-0','00042020','2026-02-28',' 11:17:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBBG-42-0' AND kode_barcode='00042044';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBBG-42-0','00042044','2026-02-28',' 11:17:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBBG-34-0' AND kode_barcode='00042036';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBBG-34-0','00042036','2026-02-28',' 11:17:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBBG-38-0' AND kode_barcode='00042040';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBBG-38-0','00042040','2026-02-28',' 11:17:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBBG-40-0' AND kode_barcode='00042042';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBBG-40-0','00042042','2026-02-28',' 11:17:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-145-0' AND kode_barcode='00036586';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-145-0','00036586','2026-02-28',' 11:17:49','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXB-15-0' AND kode_barcode='00036886';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXB-15-0','00036886','2026-02-28',' 11:17:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-133-0' AND kode_barcode='00036574';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-133-0','00036574','2026-02-28',' 11:18:02','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBBG-20-0' AND kode_barcode='00042022';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBBG-20-0','00042022','2026-02-28',' 11:18:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGAF-20-0' AND kode_barcode='00037239';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGAF-20-0','00037239','2026-02-28',' 11:18:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXB-17-0' AND kode_barcode='00036888';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXB-17-0','00036888','2026-02-28',' 11:18:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGAE-25-0' AND kode_barcode='00037205';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGAE-25-0','00037205','2026-02-28',' 11:18:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXC-21-0' AND kode_barcode='00036939';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXC-21-0','00036939','2026-02-28',' 11:18:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXD-6-0' AND kode_barcode='00036952';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXD-6-0','00036952','2026-02-28',' 11:18:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-127-0' AND kode_barcode='00036568';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-127-0','00036568','2026-02-28',' 11:18:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXD-4-0' AND kode_barcode='00036950';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXD-4-0','00036950','2026-02-28',' 11:18:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBI-71-0' AND kode_barcode='00037707';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBI-71-0','00037707','2026-02-28',' 11:18:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-169-0' AND kode_barcode='00036610';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-169-0','00036610','2026-02-28',' 11:19:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGCX-32-0' AND kode_barcode='00037771';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGCX-32-0','00037771','2026-02-28',' 11:19:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXC-10-0' AND kode_barcode='00036928';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXC-10-0','00036928','2026-02-28',' 11:19:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBBG-36-0' AND kode_barcode='00042038';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBBG-36-0','00042038','2026-02-28',' 11:19:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YIXH-44-0' AND kode_barcode='00038638';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YIXH-44-0','00038638','2026-02-28',' 11:19:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXC-28-0' AND kode_barcode='00036946';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXC-28-0','00036946','2026-02-28',' 11:19:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBI-83-0' AND kode_barcode='00037719';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBI-83-0','00037719','2026-02-28',' 11:20:05','1','kasir');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-28 ','11:20:33');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBBG-37-0' AND kode_barcode='00042039';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBBG-37-0','00042039','2026-02-28',' 11:21:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBBG-41-0' AND kode_barcode='00042043';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBBG-41-0','00042043','2026-02-28',' 11:21:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBBG-19-0' AND kode_barcode='00042021';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBBG-19-0','00042021','2026-02-28',' 11:21:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBBG-35-0' AND kode_barcode='00042037';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBBG-35-0','00042037','2026-02-28',' 11:21:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXC-27-0' AND kode_barcode='00036945';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXC-27-0','00036945','2026-02-28',' 11:21:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YIXH-45-0' AND kode_barcode='00038639';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YIXH-45-0','00038639','2026-02-28',' 11:21:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXC-19-0' AND kode_barcode='00036937';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXC-19-0','00036937','2026-02-28',' 11:22:02','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-110-0' AND kode_barcode='00036551';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-110-0','00036551','2026-02-28',' 11:22:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBI-100-0' AND kode_barcode='00037736';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBI-100-0','00037736','2026-02-28',' 11:22:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBBG-21-0' AND kode_barcode='00042023';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBBG-21-0','00042023','2026-02-28',' 11:22:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBAA-7-0' AND kode_barcode='00041496';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBAA-7-0','00041496','2026-02-28',' 11:22:20','1','kasir');
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-260228-0001','kasir','1',' BDC-00106 ','TOKO','TFCBR','BDC-YBBE-15-0','CINCIN BDC-00106','','1.110','1','83.00','4349000','1303000','77','17000','5200000','0','0','0','5200000','RISIANA','00034368','BDC','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDC-YBBE-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.110',berat_jual_asli=berat_jual_asli+'1.110',stock_jual='1',berat_akhir=berat_akhir-'1.110',berat_akhir_asli=berat_akhir_asli-'1.110',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='BDC-YBBE-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCBR' 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-260228-0001','2026-02-28','1.110','2026-02-28','11:22:30','PLG0009683','5200000','5200000','0','5200000','0','kasir','2026-02-28 11:22:30','FJ-260228-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-28','FJ-260228-0001','2026-02-28','11:22:30','RISIANA','5200000','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-260228-0001','2026-02-28','2026-02-28 11:22:30','PENJUALAN : FJ-260228-0001','','TBC','5200000','5200000','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-260228-0002','D','2026-02-28','11:22:30','TBC','PENJUALAN BERLIAN','FJ-260228-0001','20692790514','5200000','20697990514','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='5200000' WHERE no_faktur_jual='FJ-260228-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0001';
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBBG-17-0' AND kode_barcode='00042019';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBBG-17-0','00042019','2026-02-28',' 11:22:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBBG-15-0' AND kode_barcode='00042017';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBBG-15-0','00042017','2026-02-28',' 11:22:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBBG-39-0' AND kode_barcode='00042041';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBBG-39-0','00042041','2026-02-28',' 11:23:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-132-0' AND kode_barcode='00036573';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-132-0','00036573','2026-02-28',' 11:23:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBBG-33-0' AND kode_barcode='00042035';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBBG-33-0','00042035','2026-02-28',' 11:23:11','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXC-23-0' AND kode_barcode='00036941';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXC-23-0','00036941','2026-02-28',' 11:23:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBAA-2-0' AND kode_barcode='00041491';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBAA-2-0','00041491','2026-02-28',' 11:24:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-142-0' AND kode_barcode='00036583';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-142-0','00036583','2026-02-28',' 11:24:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-156-0' AND kode_barcode='00036597';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-156-0','00036597','2026-02-28',' 11:24:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGCX-33-0' AND kode_barcode='00037772';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGCX-33-0','00037772','2026-02-28',' 11:24:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXG-3-0' AND kode_barcode='00036997';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXG-3-0','00036997','2026-02-28',' 11:24:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXI-7-0' AND kode_barcode='00037068';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXI-7-0','00037068','2026-02-28',' 11:24:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBC-47-0' AND kode_barcode='00036657';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBC-47-0','00036657','2026-02-28',' 11:37:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-76-0' AND kode_barcode='00036517';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-76-0','00036517','2026-02-28',' 11:37:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGAX-15-0' AND kode_barcode='00037119';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGAX-15-0','00037119','2026-02-28',' 11:37:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXB-9-0' AND kode_barcode='00036880';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXB-9-0','00036880','2026-02-28',' 11:37:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-82-0' AND kode_barcode='00040484';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-82-0','00040484','2026-02-28',' 11:37:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-84-0' AND kode_barcode='00040486';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-84-0','00040486','2026-02-28',' 11:37:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-78-0' AND kode_barcode='00036519';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-78-0','00036519','2026-02-28',' 11:37:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-113-0' AND kode_barcode='00036554';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-113-0','00036554','2026-02-28',' 11:37:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-48-0' AND kode_barcode='00036489';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-48-0','00036489','2026-02-28',' 11:37:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGAD-14-0' AND kode_barcode='00037172';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGAD-14-0','00037172','2026-02-28',' 11:38:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBD-21-0' AND kode_barcode='00037483';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBD-21-0','00037483','2026-02-28',' 11:38:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-132-0' AND kode_barcode='00040534';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-132-0','00040534','2026-02-28',' 11:38:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGAE-21-0' AND kode_barcode='00037201';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGAE-21-0','00037201','2026-02-28',' 11:38:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBI-91-0' AND kode_barcode='00037727';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBI-91-0','00037727','2026-02-28',' 11:38:54','1','kasir');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-02-28 ','11:38:56');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGBA-34-0' AND kode_barcode='00037372';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGBA-34-0','00037372','2026-02-28',' 11:38:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGCX-26-0' AND kode_barcode='00037765';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGCX-26-0','00037765','2026-02-28',' 11:39:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBH-10-0' AND kode_barcode='00037592';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBH-10-0','00037592','2026-02-28',' 11:39:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBI-87-0' AND kode_barcode='00037723';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBI-87-0','00037723','2026-02-28',' 11:39:27','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXC-20-0' AND kode_barcode='00036938';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXC-20-0','00036938','2026-02-28',' 11:39:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXH-8-0' AND kode_barcode='00037037';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXH-8-0','00037037','2026-02-28',' 11:39:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-86-0' AND kode_barcode='00040488';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-86-0','00040488','2026-02-28',' 11:40:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKBF-19-0' AND kode_barcode='00040014';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKBF-19-0','00040014','2026-02-28',' 11:40:05','1','kasir');
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-260228-0002','kasirbip','1',' DP-01745BI','TOKO','BIPPSN','PSPRT-ZBBC-85-0','1PS CINCIN PERAK ','','4.800','1','100.00','490000','0','0','17000','1600000','0','0','0','1600000','SULIS','00041746','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZBBC-85-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.800',berat_jual_asli=berat_jual_asli+'4.800',stock_jual='1',berat_akhir=berat_akhir-'4.800',berat_akhir_asli=berat_akhir_asli-'4.800',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PSPRT-ZBBC-85-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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-260228-0002','2026-02-28','4.800','2026-02-28','11:40:34','PLG0009684','1600000','1600000','0','1600000','0','kasirbip','2026-02-28 11:40:33','FJ-260228-0002','DP-01745','1600000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-28','FJ-260228-0002','2026-02-28','11:40:34','SULIS','1600000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260228-0002' LIMIT 1;
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBXC-13-0' AND kode_barcode='00041307';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBXC-13-0','00041307','2026-02-28',' 11:40:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKAD-54-0' AND kode_barcode='00039631';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKAD-54-0','00039631','2026-02-28',' 11:40:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGAX-24-0' AND kode_barcode='00037128';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGAX-24-0','00037128','2026-02-28',' 11:40:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKAD-64-0' AND kode_barcode='00039641';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKAD-64-0','00039641','2026-02-28',' 11:41:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-111-0' AND kode_barcode='00036552';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-111-0','00036552','2026-02-28',' 11:41:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKBD-55-0' AND kode_barcode='00039827';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKBD-55-0','00039827','2026-02-28',' 11:41:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBH-8-0' AND kode_barcode='00037590';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBH-8-0','00037590','2026-02-28',' 11:41:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YIXH-19-0' AND kode_barcode='00038613';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YIXH-19-0','00038613','2026-02-28',' 11:42:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-24-0' AND kode_barcode='00036465';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-24-0','00036465','2026-02-28',' 11:42:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-97-0' AND kode_barcode='00036538';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-97-0','00036538','2026-02-28',' 11:42:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKBF-14-0' AND kode_barcode='00040009';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKBF-14-0','00040009','2026-02-28',' 11:42:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-75-0' AND kode_barcode='00036516';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-75-0','00036516','2026-02-28',' 11:42:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKBF-2-0' AND kode_barcode='00039997';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKBF-2-0','00039997','2026-02-28',' 11:43:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKBD-58-0' AND kode_barcode='00039830';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKBD-58-0','00039830','2026-02-28',' 11:43:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-83-0' AND kode_barcode='00040485';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-83-0','00040485','2026-02-28',' 11:43:41','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGAX-14-0' AND kode_barcode='00037118';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGAX-14-0','00037118','2026-02-28',' 11:43:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-28-0' AND kode_barcode='00036469';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-28-0','00036469','2026-02-28',' 11:43:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBI-18-0' AND kode_barcode='00037654';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBI-18-0','00037654','2026-02-28',' 11:44:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBC-34-0' AND kode_barcode='00036644';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBC-34-0','00036644','2026-02-28',' 11:44:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-168-0' AND kode_barcode='00036609';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-168-0','00036609','2026-02-28',' 11:44:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YIXC-10-0' AND kode_barcode='00038515';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YIXC-10-0','00038515','2026-02-28',' 11:44:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGCX-28-0' AND kode_barcode='00037767';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGCX-28-0','00037767','2026-02-28',' 11:44:51','1','kasir');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0002';
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-81-0' AND kode_barcode='00040483';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-81-0','00040483','2026-02-28',' 11:45:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-91-0' AND kode_barcode='00040493';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-91-0','00040493','2026-02-28',' 11:45:27','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-121-0' AND kode_barcode='00040523';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-121-0','00040523','2026-02-28',' 11:45:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGBA-32-0' AND kode_barcode='00037370';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGBA-32-0','00037370','2026-02-28',' 11:45:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXD-17-0' AND kode_barcode='00036963';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXD-17-0','00036963','2026-02-28',' 11:45:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-57-0' AND kode_barcode='00036498';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-57-0','00036498','2026-02-28',' 11:46:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBC-26-0' AND kode_barcode='00036636';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBC-26-0','00036636','2026-02-28',' 11:46:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGCX-17-0' AND kode_barcode='00037756';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGCX-17-0','00037756','2026-02-28',' 11:46:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKAD-50-0' AND kode_barcode='00039627';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKAD-50-0','00039627','2026-02-28',' 11:46:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKBD-56-0' AND kode_barcode='00039828';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKBD-56-0','00039828','2026-02-28',' 11:47:02','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-136-0' AND kode_barcode='00036577';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-136-0','00036577','2026-02-28',' 11:47:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBI-52-0' AND kode_barcode='00037688';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBI-52-0','00037688','2026-02-28',' 11:47:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-117-0' AND kode_barcode='00040519';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-117-0','00040519','2026-02-28',' 11:47:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXD-7-0' AND kode_barcode='00036953';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXD-7-0','00036953','2026-02-28',' 11:47:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBC-25-0' AND kode_barcode='00036635';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBC-25-0','00036635','2026-02-28',' 11:47:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGCX-24-0' AND kode_barcode='00037763';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGCX-24-0','00037763','2026-02-28',' 11:47:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBD-8-0' AND kode_barcode='00037470';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBD-8-0','00037470','2026-02-28',' 11:48:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKAD-60-0' AND kode_barcode='00039637';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKAD-60-0','00039637','2026-02-28',' 11:48:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBC-46-0' AND kode_barcode='00036656';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBC-46-0','00036656','2026-02-28',' 11:48:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKBD-60-0' AND kode_barcode='00039832';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKBD-60-0','00039832','2026-02-28',' 11:49:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKBD-59-0' AND kode_barcode='00039831';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKBD-59-0','00039831','2026-02-28',' 11:49:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXC-13-0' AND kode_barcode='00036931';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXC-13-0','00036931','2026-02-28',' 11:49:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-79-0' AND kode_barcode='00040481';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-79-0','00040481','2026-02-28',' 11:49:41','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBI-98-0' AND kode_barcode='00037734';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBI-98-0','00037734','2026-02-28',' 11:49:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-72-0' AND kode_barcode='00036513';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-72-0','00036513','2026-02-28',' 11:49:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YIXH-47-0' AND kode_barcode='00038641';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YIXH-47-0','00038641','2026-02-28',' 11:49:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLBE-10-0' AND kode_barcode='00040694';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLBE-10-0','00040694','2026-02-28',' 11:50:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKAD-66-0' AND kode_barcode='00039643';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKAD-66-0','00039643','2026-02-28',' 11:50:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-30-0' AND kode_barcode='00036471';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-30-0','00036471','2026-02-28',' 11:50:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXG-11-0' AND kode_barcode='00037005';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXG-11-0','00037005','2026-02-28',' 11:51:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXI-4-0' AND kode_barcode='00037065';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXI-4-0','00037065','2026-02-28',' 11:51:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKBF-13-0' AND kode_barcode='00040008';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKBF-13-0','00040008','2026-02-28',' 11:52:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-84-0' AND kode_barcode='00036525';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-84-0','00036525','2026-02-28',' 11:52:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXI-14-0' AND kode_barcode='00037075';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXI-14-0','00037075','2026-02-28',' 11:52:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBD-52-0' AND kode_barcode='00037514';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBD-52-0','00037514','2026-02-28',' 11:52:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBI-99-0' AND kode_barcode='00037735';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBI-99-0','00037735','2026-02-28',' 11:52:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-116-0' AND kode_barcode='00040518';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-116-0','00040518','2026-02-28',' 11:52:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZAXI-15-0' AND kode_barcode='00040792';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZAXI-15-0','00040792','2026-02-28',' 11:52:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBI-16-0' AND kode_barcode='00037652';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBI-16-0','00037652','2026-02-28',' 11:53:02','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXB-13-0' AND kode_barcode='00036884';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXB-13-0','00036884','2026-02-28',' 11:53:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBI-55-0' AND kode_barcode='00037691';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBI-55-0','00037691','2026-02-28',' 11:53:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXI-10-0' AND kode_barcode='00037071';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXI-10-0','00037071','2026-02-28',' 11:53:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBH-14-0' AND kode_barcode='00037596';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBH-14-0','00037596','2026-02-28',' 11:53:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-108-0' AND kode_barcode='00036549';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-108-0','00036549','2026-02-28',' 11:53:27','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-112-0' AND kode_barcode='00040514';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-112-0','00040514','2026-02-28',' 11:53:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXD-8-0' AND kode_barcode='00036954';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXD-8-0','00036954','2026-02-28',' 11:53:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-34-0' AND kode_barcode='00036475';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-34-0','00036475','2026-02-28',' 11:53:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBI-14-0' AND kode_barcode='00037650';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBI-14-0','00037650','2026-02-28',' 11:53:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBH-12-0' AND kode_barcode='00037594';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBH-12-0','00037594','2026-02-28',' 11:54:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-110-0' AND kode_barcode='00040512';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-110-0','00040512','2026-02-28',' 11:54:27','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXI-12-0' AND kode_barcode='00037073';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXI-12-0','00037073','2026-02-28',' 11:54:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBD-32-0' AND kode_barcode='00037494';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBD-32-0','00037494','2026-02-28',' 11:55:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXI-13-0' AND kode_barcode='00037074';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXI-13-0','00037074','2026-02-28',' 11:55:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBC-38-0' AND kode_barcode='00036648';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBC-38-0','00036648','2026-02-28',' 11:55:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBI-9-0' AND kode_barcode='00037645';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBI-9-0','00037645','2026-02-28',' 11:55:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBI-90-0' AND kode_barcode='00037726';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBI-90-0','00037726','2026-02-28',' 11:55:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXG-19-0' AND kode_barcode='00037013';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXG-19-0','00037013','2026-02-28',' 11:55:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKAD-56-0' AND kode_barcode='00039633';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKAD-56-0','00039633','2026-02-28',' 11:56:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-77-0' AND kode_barcode='00036518';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-77-0','00036518','2026-02-28',' 11:56:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-104-0' AND kode_barcode='00040506';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-104-0','00040506','2026-02-28',' 11:56:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZABX-21-0' AND kode_barcode='00041047';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZABX-21-0','00041047','2026-02-28',' 11:56:49','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBC-30-0' AND kode_barcode='00036640';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBC-30-0','00036640','2026-02-28',' 11:57:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-83-0' AND kode_barcode='00036524';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-83-0','00036524','2026-02-28',' 11:57:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZAXG-12-0' AND kode_barcode='00040775';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZAXG-12-0','00040775','2026-02-28',' 11:57:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBI-74-0' AND kode_barcode='00037710';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBI-74-0','00037710','2026-02-28',' 11:57:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXH-5-0' AND kode_barcode='00037034';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXH-5-0','00037034','2026-02-28',' 11:57:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-99-0' AND kode_barcode='00036540';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-99-0','00036540','2026-02-28',' 11:57:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKBF-16-0' AND kode_barcode='00040011';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKBF-16-0','00040011','2026-02-28',' 11:57:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKBD-54-0' AND kode_barcode='00039826';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKBD-54-0','00039826','2026-02-28',' 11:57:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBH-18-0' AND kode_barcode='00037600';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBH-18-0','00037600','2026-02-28',' 11:58:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBI-89-0' AND kode_barcode='00037725';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBI-89-0','00037725','2026-02-28',' 11:58:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGAE-31-0' AND kode_barcode='00037211';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGAE-31-0','00037211','2026-02-28',' 11:58:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBD-36-0' AND kode_barcode='00037498';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBD-36-0','00037498','2026-02-28',' 11:58:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXG-5-0' AND kode_barcode='00036999';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXG-5-0','00036999','2026-02-28',' 11:58:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXI-11-0' AND kode_barcode='00037072';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXI-11-0','00037072','2026-02-28',' 11:59:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-91-0' AND kode_barcode='00036532';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-91-0','00036532','2026-02-28',' 11:59:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBAX-38-0' AND kode_barcode='00041474';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBAX-38-0','00041474','2026-02-28',' 11:59:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBD-33-0' AND kode_barcode='00037495';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBD-33-0','00037495','2026-02-28',' 11:59:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBD-41-0' AND kode_barcode='00037503';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBD-41-0','00037503','2026-02-28',' 11:59:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXI-9-0' AND kode_barcode='00037070';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXI-9-0','00037070','2026-02-28',' 11:59:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-103-0' AND kode_barcode='00040505';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-103-0','00040505','2026-02-28',' 11:59:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YIXH-22-0' AND kode_barcode='00038616';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YIXH-22-0','00038616','2026-02-28',' 11:59:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-135-0' AND kode_barcode='00036576';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-135-0','00036576','2026-02-28',' 11:59:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-93-0' AND kode_barcode='00040495';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-93-0','00040495','2026-02-28',' 12:00:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBC-32-0' AND kode_barcode='00036642';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBC-32-0','00036642','2026-02-28',' 12:00:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-107-0' AND kode_barcode='00040509';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-107-0','00040509','2026-02-28',' 12:00:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZAXF-14-0' AND kode_barcode='00040760';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZAXF-14-0','00040760','2026-02-28',' 12:00:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-162-0' AND kode_barcode='00036603';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-162-0','00036603','2026-02-28',' 12:00:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBC-50-0' AND kode_barcode='00036660';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBC-50-0','00036660','2026-02-28',' 12:00:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBH-3-0' AND kode_barcode='00037585';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBH-3-0','00037585','2026-02-28',' 12:00:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKAD-22-0' AND kode_barcode='00039599';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKAD-22-0','00039599','2026-02-28',' 12:02:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-102-0' AND kode_barcode='00036543';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-102-0','00036543','2026-02-28',' 12:02:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZAXI-54-0' AND kode_barcode='00040831';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZAXI-54-0','00040831','2026-02-28',' 12:02:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXI-6-0' AND kode_barcode='00037067';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXI-6-0','00037067','2026-02-28',' 12:02:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKBD-57-0' AND kode_barcode='00039829';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKBD-57-0','00039829','2026-02-28',' 12:02:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YIXH-46-0' AND kode_barcode='00038640';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YIXH-46-0','00038640','2026-02-28',' 12:02:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YIXH-28-0' AND kode_barcode='00038622';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YIXH-28-0','00038622','2026-02-28',' 12:02:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKAD-40-0' AND kode_barcode='00039617';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKAD-40-0','00039617','2026-02-28',' 12:03:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBXC-16-0' AND kode_barcode='00041310';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBXC-16-0','00041310','2026-02-28',' 12:03:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXH-10-0' AND kode_barcode='00037039';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXH-10-0','00037039','2026-02-28',' 12:03:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZAXI-38-0' AND kode_barcode='00040815';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZAXI-38-0','00040815','2026-02-28',' 12:03:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXG-2-0' AND kode_barcode='00036996';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXG-2-0','00036996','2026-02-28',' 12:03:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBBC-83-0' AND kode_barcode='00041744';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBBC-83-0','00041744','2026-02-28',' 12:03:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YIXH-26-0' AND kode_barcode='00038620';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YIXH-26-0','00038620','2026-02-28',' 12:04:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGAX-20-0' AND kode_barcode='00037124';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGAX-20-0','00037124','2026-02-28',' 12:04:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKBD-50-0' AND kode_barcode='00039822';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKBD-50-0','00039822','2026-02-28',' 12:05:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXC-9-0' AND kode_barcode='00036927';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXC-9-0','00036927','2026-02-28',' 12:05:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-97-0' AND kode_barcode='00040499';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-97-0','00040499','2026-02-28',' 12:05:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZAXG-8-0' AND kode_barcode='00040771';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZAXG-8-0','00040771','2026-02-28',' 12:05:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKAD-62-0' AND kode_barcode='00039639';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKAD-62-0','00039639','2026-02-28',' 12:05:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKAD-39-0' AND kode_barcode='00039616';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKAD-39-0','00039616','2026-02-28',' 12:05:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBBD-7-0' AND kode_barcode='00041753';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBBD-7-0','00041753','2026-02-28',' 12:05:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZAXI-44-0' AND kode_barcode='00040821';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZAXI-44-0','00040821','2026-02-28',' 12:05:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-68-0' AND kode_barcode='00036509';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-68-0','00036509','2026-02-28',' 12:05:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKAD-55-0' AND kode_barcode='00039632';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKAD-55-0','00039632','2026-02-28',' 12:06:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YHAA-11-0' AND kode_barcode='00037922';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YHAA-11-0','00037922','2026-02-28',' 12:06:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZAXI-32-0' AND kode_barcode='00040809';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZAXI-32-0','00040809','2026-02-28',' 12:06:11','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-92-0' AND kode_barcode='00040494';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-92-0','00040494','2026-02-28',' 12:06:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXD-3-0' AND kode_barcode='00036949';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXD-3-0','00036949','2026-02-28',' 12:07:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGCX-4-0' AND kode_barcode='00037743';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGCX-4-0','00037743','2026-02-28',' 12:07:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-101-0' AND kode_barcode='00040503';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-101-0','00040503','2026-02-28',' 12:07:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-40-0' AND kode_barcode='00036481';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-40-0','00036481','2026-02-28',' 12:07:36','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-49-0' AND kode_barcode='00036490';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-49-0','00036490','2026-02-28',' 12:07:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-37-0' AND kode_barcode='00036478';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-37-0','00036478','2026-02-28',' 12:07:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBD-43-0' AND kode_barcode='00037505';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBD-43-0','00037505','2026-02-28',' 12:07:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBAX-40-0' AND kode_barcode='00041476';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBAX-40-0','00041476','2026-02-28',' 12:08:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKAD-63-0' AND kode_barcode='00039640';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKAD-63-0','00039640','2026-02-28',' 12:08:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLXD-134-0' AND kode_barcode='00040314';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLXD-134-0','00040314','2026-02-28',' 12:08:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZABX-8-0' AND kode_barcode='00041034';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZABX-8-0','00041034','2026-02-28',' 12:08:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBD-40-0' AND kode_barcode='00037502';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBD-40-0','00037502','2026-02-28',' 12:08:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKAD-51-0' AND kode_barcode='00039628';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKAD-51-0','00039628','2026-02-28',' 12:08:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-80-0' AND kode_barcode='00040482';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-80-0','00040482','2026-02-28',' 12:08:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGBA-33-0' AND kode_barcode='00037371';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGBA-33-0','00037371','2026-02-28',' 12:08:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-74-0' AND kode_barcode='00040476';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-74-0','00040476','2026-02-28',' 12:09:02','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZAXI-49-0' AND kode_barcode='00040826';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZAXI-49-0','00040826','2026-02-28',' 12:09:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKBF-18-0' AND kode_barcode='00040013';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKBF-18-0','00040013','2026-02-28',' 12:09:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBI-97-0' AND kode_barcode='00037733';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBI-97-0','00037733','2026-02-28',' 12:09:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZAXI-51-0' AND kode_barcode='00040828';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZAXI-51-0','00040828','2026-02-28',' 12:09:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZAXG-14-0' AND kode_barcode='00040777';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZAXG-14-0','00040777','2026-02-28',' 12:09:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBD-51-0' AND kode_barcode='00037513';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBD-51-0','00037513','2026-02-28',' 12:09:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBC-42-0' AND kode_barcode='00036652';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBC-42-0','00036652','2026-02-28',' 12:09:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGCX-2-0' AND kode_barcode='00037741';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGCX-2-0','00037741','2026-02-28',' 12:10:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKBF-17-0' AND kode_barcode='00040012';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKBF-17-0','00040012','2026-02-28',' 12:10:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKAD-67-0' AND kode_barcode='00039644';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKAD-67-0','00039644','2026-02-28',' 12:10:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-66-0' AND kode_barcode='00036507';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-66-0','00036507','2026-02-28',' 12:10:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZAXI-48-0' AND kode_barcode='00040825';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZAXI-48-0','00040825','2026-02-28',' 12:10:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXG-21-0' AND kode_barcode='00037015';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXG-21-0','00037015','2026-02-28',' 12:10:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-99-0' AND kode_barcode='00040501';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-99-0','00040501','2026-02-28',' 12:10:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXD-11-0' AND kode_barcode='00036957';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXD-11-0','00036957','2026-02-28',' 12:11:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKAD-17-0' AND kode_barcode='00039594';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKAD-17-0','00039594','2026-02-28',' 12:11:11','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZAXI-46-0' AND kode_barcode='00040823';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZAXI-46-0','00040823','2026-02-28',' 12:12:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-124-0' AND kode_barcode='00040526';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-124-0','00040526','2026-02-28',' 12:12:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXH-12-0' AND kode_barcode='00037041';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXH-12-0','00037041','2026-02-28',' 12:12:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKAD-59-0' AND kode_barcode='00039636';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKAD-59-0','00039636','2026-02-28',' 12:12:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBC-45-0' AND kode_barcode='00036655';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBC-45-0','00036655','2026-02-28',' 12:12:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-120-0' AND kode_barcode='00040522';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-120-0','00040522','2026-02-28',' 12:12:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGAF-17-0' AND kode_barcode='00037236';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGAF-17-0','00037236','2026-02-28',' 12:12:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZABF-30-0' AND kode_barcode='00041168';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZABF-30-0','00041168','2026-02-28',' 12:13:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXD-16-0' AND kode_barcode='00036962';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXD-16-0','00036962','2026-02-28',' 12:13:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBBD-8-0' AND kode_barcode='00041754';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBBD-8-0','00041754','2026-02-28',' 12:13:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGAX-25-0' AND kode_barcode='00037129';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGAX-25-0','00037129','2026-02-28',' 12:13:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-88-0' AND kode_barcode='00040490';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-88-0','00040490','2026-02-28',' 12:13:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXG-22-0' AND kode_barcode='00037016';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXG-22-0','00037016','2026-02-28',' 12:13:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YIXH-37-0' AND kode_barcode='00038631';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YIXH-37-0','00038631','2026-02-28',' 12:14:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-131-0' AND kode_barcode='00040533';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-131-0','00040533','2026-02-28',' 12:14:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-47-0' AND kode_barcode='00036488';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-47-0','00036488','2026-02-28',' 12:14:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-105-0' AND kode_barcode='00040507';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-105-0','00040507','2026-02-28',' 12:14:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZAXI-57-0' AND kode_barcode='00040834';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZAXI-57-0','00040834','2026-02-28',' 12:15:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YIXH-21-0' AND kode_barcode='00038615';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YIXH-21-0','00038615','2026-02-28',' 12:15:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YIXH-33-0' AND kode_barcode='00038627';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YIXH-33-0','00038627','2026-02-28',' 12:15:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZAXI-47-0' AND kode_barcode='00040824';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZAXI-47-0','00040824','2026-02-28',' 12:15:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBC-27-0' AND kode_barcode='00036637';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBC-27-0','00036637','2026-02-28',' 12:15:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-90-0' AND kode_barcode='00036531';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-90-0','00036531','2026-02-28',' 12:16:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-98-0' AND kode_barcode='00040500';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-98-0','00040500','2026-02-28',' 12:16:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZAXI-16-0' AND kode_barcode='00040793';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZAXI-16-0','00040793','2026-02-28',' 12:16:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-89-0' AND kode_barcode='00040491';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-89-0','00040491','2026-02-28',' 12:16:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGAF-16-0' AND kode_barcode='00037235';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGAF-16-0','00037235','2026-02-28',' 12:16:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YIXC-12-0' AND kode_barcode='00038517';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YIXC-12-0','00038517','2026-02-28',' 12:17:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-61-0' AND kode_barcode='00036502';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-61-0','00036502','2026-02-28',' 12:17:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZAXI-37-0' AND kode_barcode='00040814';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZAXI-37-0','00040814','2026-02-28',' 12:17:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YIXH-29-0' AND kode_barcode='00038623';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YIXH-29-0','00038623','2026-02-28',' 12:17:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-109-0' AND kode_barcode='00040511';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-109-0','00040511','2026-02-28',' 12:17:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGCX-18-0' AND kode_barcode='00037757';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGCX-18-0','00037757','2026-02-28',' 12:17:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGAD-12-0' AND kode_barcode='00037170';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGAD-12-0','00037170','2026-02-28',' 12:17:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-102-0' AND kode_barcode='00040504';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-102-0','00040504','2026-02-28',' 12:17:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-64-0' AND kode_barcode='00036505';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-64-0','00036505','2026-02-28',' 12:18:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-60-0' AND kode_barcode='00036501';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-60-0','00036501','2026-02-28',' 12:18:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-90-0' AND kode_barcode='00040492';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-90-0','00040492','2026-02-28',' 12:18:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZABF-32-0' AND kode_barcode='00041170';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZABF-32-0','00041170','2026-02-28',' 12:18:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-96-0' AND kode_barcode='00040498';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-96-0','00040498','2026-02-28',' 12:18:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-78-0' AND kode_barcode='00040480';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-78-0','00040480','2026-02-28',' 12:18:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZAXI-58-0' AND kode_barcode='00040835';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZAXI-58-0','00040835','2026-02-28',' 12:18:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBD-46-0' AND kode_barcode='00037508';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBD-46-0','00037508','2026-02-28',' 12:18:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXD-15-0' AND kode_barcode='00036961';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXD-15-0','00036961','2026-02-28',' 12:18:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXB-8-0' AND kode_barcode='00036879';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXB-8-0','00036879','2026-02-28',' 12:19:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-119-0' AND kode_barcode='00040521';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-119-0','00040521','2026-02-28',' 12:19:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-52-0' AND kode_barcode='00036493';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-52-0','00036493','2026-02-28',' 12:19:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-113-0' AND kode_barcode='00040515';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-113-0','00040515','2026-02-28',' 12:19:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGAF-12-0' AND kode_barcode='00037231';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGAF-12-0','00037231','2026-02-28',' 12:19:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-77-0' AND kode_barcode='00040479';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-77-0','00040479','2026-02-28',' 12:19:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-32-0' AND kode_barcode='00036473';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-32-0','00036473','2026-02-28',' 12:19:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-51-0' AND kode_barcode='00036492';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-51-0','00036492','2026-02-28',' 12:19:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-118-0' AND kode_barcode='00040520';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-118-0','00040520','2026-02-28',' 12:20:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBXC-10-0' AND kode_barcode='00041304';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBXC-10-0','00041304','2026-02-28',' 12:21:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-155-0' AND kode_barcode='00036596';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-155-0','00036596','2026-02-28',' 12:22:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBAA-3-0' AND kode_barcode='00041492';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBAA-3-0','00041492','2026-02-28',' 12:22:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBAA-5-0' AND kode_barcode='00041494';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBAA-5-0','00041494','2026-02-28',' 12:22:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGCX-30-0' AND kode_barcode='00037769';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGCX-30-0','00037769','2026-02-28',' 12:22:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZAXG-11-0' AND kode_barcode='00040774';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZAXG-11-0','00040774','2026-02-28',' 12:22:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXD-30-0' AND kode_barcode='00036976';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXD-30-0','00036976','2026-02-28',' 12:22:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-143-0' AND kode_barcode='00036584';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-143-0','00036584','2026-02-28',' 12:22:49','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXD-29-0' AND kode_barcode='00036975';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXD-29-0','00036975','2026-02-28',' 12:23:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXG-20-0' AND kode_barcode='00037014';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXG-20-0','00037014','2026-02-28',' 12:23:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBXC-12-0' AND kode_barcode='00041306';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBXC-12-0','00041306','2026-02-28',' 12:23:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBXC-8-0' AND kode_barcode='00041302';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBXC-8-0','00041302','2026-02-28',' 12:23:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-31-0' AND kode_barcode='00036472';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-31-0','00036472','2026-02-28',' 12:23:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-160-0' AND kode_barcode='00036601';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-160-0','00036601','2026-02-28',' 12:23:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXC-25-0' AND kode_barcode='00036943';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXC-25-0','00036943','2026-02-28',' 12:23:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBAA-4-0' AND kode_barcode='00041493';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBAA-4-0','00041493','2026-02-28',' 12:24:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBXC-11-0' AND kode_barcode='00041305';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBXC-11-0','00041305','2026-02-28',' 12:24:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXD-9-0' AND kode_barcode='00036955';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXD-9-0','00036955','2026-02-28',' 12:24:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-26-0' AND kode_barcode='00036467';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-26-0','00036467','2026-02-28',' 12:24:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKAD-68-0' AND kode_barcode='00039645';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKAD-68-0','00039645','2026-02-28',' 12:24:27','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXH-17-0' AND kode_barcode='00037046';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXH-17-0','00037046','2026-02-28',' 12:25:02','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBBC-82-0' AND kode_barcode='00041743';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBBC-82-0','00041743','2026-02-28',' 12:25:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXD-35-0' AND kode_barcode='00036981';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXD-35-0','00036981','2026-02-28',' 12:25:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXD-40-0' AND kode_barcode='00036986';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXD-40-0','00036986','2026-02-28',' 12:25:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBD-11-0' AND kode_barcode='00037473';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBD-11-0','00037473','2026-02-28',' 12:26:02','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXD-5-0' AND kode_barcode='00036951';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXD-5-0','00036951','2026-02-28',' 12:26:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-75-0' AND kode_barcode='00040477';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-75-0','00040477','2026-02-28',' 12:26:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZAXG-10-0' AND kode_barcode='00040773';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZAXG-10-0','00040773','2026-02-28',' 12:26:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXC-11-0' AND kode_barcode='00036929';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXC-11-0','00036929','2026-02-28',' 12:26:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-122-0' AND kode_barcode='00036563';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-122-0','00036563','2026-02-28',' 12:26:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKAD-44-0' AND kode_barcode='00039621';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKAD-44-0','00039621','2026-02-28',' 12:26:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBXC-17-0' AND kode_barcode='00041311';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBXC-17-0','00041311','2026-02-28',' 12:27:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLXD-131-0' AND kode_barcode='00040311';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLXD-131-0','00040311','2026-02-28',' 12:27:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YLAX-106-0' AND kode_barcode='00040508';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YLAX-106-0','00040508','2026-02-28',' 12:27:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXC-12-0' AND kode_barcode='00036930';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXC-12-0','00036930','2026-02-28',' 12:27:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGBD-34-0' AND kode_barcode='00037496';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGBD-34-0','00037496','2026-02-28',' 12:27:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXD-34-0' AND kode_barcode='00036980';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXD-34-0','00036980','2026-02-28',' 12:27:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGCX-42-0' AND kode_barcode='00037781';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGCX-42-0','00037781','2026-02-28',' 12:27:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBSD-YGCX-14-0' AND kode_barcode='00037753';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBSD-YGCX-14-0','00037753','2026-02-28',' 12:27:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKBF-15-0' AND kode_barcode='00040010';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKBF-15-0','00040010','2026-02-28',' 12:27:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKAD-61-0' AND kode_barcode='00039638';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKAD-61-0','00039638','2026-02-28',' 12:27:36','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXD-37-0' AND kode_barcode='00036983';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXD-37-0','00036983','2026-02-28',' 12:27:41','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKBF-10-0' AND kode_barcode='00040005';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKBF-10-0','00040005','2026-02-28',' 12:27:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGXD-39-0' AND kode_barcode='00036985';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGXD-39-0','00036985','2026-02-28',' 12:28:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YGAF-25-0' AND kode_barcode='00037244';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YGAF-25-0','00037244','2026-02-28',' 12:28:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKBF-7-0' AND kode_barcode='00040002';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKBF-7-0','00040002','2026-02-28',' 12:28:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YKBF-6-0' AND kode_barcode='00040001';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YKBF-6-0','00040001','2026-02-28',' 12:28:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-114-0' AND kode_barcode='00036555';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-114-0','00036555','2026-02-28',' 12:28:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YFBX-116-0' AND kode_barcode='00036557';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YFBX-116-0','00036557','2026-02-28',' 12:28:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-YHAA-12-0' AND kode_barcode='00037923';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-YHAA-12-0','00037923','2026-02-28',' 12:28:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PMM-ZBXC-15-0' AND kode_barcode='00041309';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PMM-ZBXC-15-0','00041309','2026-02-28',' 12:28:57','1','kasir');
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-260228-0003','kasir','1',' 700K-175-6','TOKO','MMPER','PMM-YLAX-118-0','CINCIN SILVER 925 ','','2.230','1','100.00','137000','0','0','17000','800000','0','0','0','800000','NISA','00040520','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YLAX-118-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.230',berat_jual_asli=berat_jual_asli+'2.230',stock_jual='1',berat_akhir=berat_akhir-'2.230',berat_akhir_asli=berat_akhir_asli-'2.230',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PMM-YLAX-118-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-260228-0003','2026-02-28','2.230','2026-02-28','12:41:25','PLG0009685','800000','800000','0','800000','0','kasir','2026-02-28 12:41:25','FJ-260228-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-02-28','FJ-260228-0003','2026-02-28','12:41:25','NISA','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-260228-0002','2026-02-28','2026-02-28 12:41:25','PENJUALAN : FJ-260228-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-260228-0003','D','2026-02-28','12:41:25','TBC','PENJUALAN','FJ-260228-0003','20697990514','800000','20698790514','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-260228-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-260228-0004','kasir','1',' DP-01721MM','TOKO','MMPSN','PSGT-ZBBF-97-0','CINCIN EMAS','','2.250','1','83.00','5182000','0','0','17000','6555000','0','0','0','6555000','NISA','00041996','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZBBF-97-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.250',berat_jual_asli=berat_jual_asli+'2.250',stock_jual='1',berat_akhir=berat_akhir-'2.250',berat_akhir_asli=berat_akhir_asli-'2.250',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PSGT-ZBBF-97-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-260228-0004','2026-02-28','2.250','2026-02-28','12:43:35','PLG0009686','6555000','6555000','0','6555000','0','kasir','2026-02-28 12:43:34','FJ-260228-0004','DP-01721','4744000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-28','FJ-260228-0004','2026-02-28','12:43:35','NISA','6555000','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-260228-0003','2026-02-28','2026-02-28 12:43:34','PENJUALAN : FJ-260228-0004','.','TBC','1811000','1811000','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-260228-0004','D','2026-02-28','12:43:35','TBC','PENJUALAN','FJ-260228-0004','20698790514','1811000','20700601514','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='1811000' WHERE no_faktur_jual='FJ-260228-0004' 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-260228-0005','kasir',' 1',' DP-01722MM','TOKO','MMPSN','PSPLT-ZBBG-52-0','CINCIN PALADIUM ','','2.620','1','32.00','1108000','0','0','17000','2010000','0','0','0','2010000','NISA','00042054','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZBBG-52-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.620',berat_jual_asli=berat_jual_asli+'2.620',stock_jual='1',berat_akhir=berat_akhir-'2.620',berat_akhir_asli=berat_akhir_asli-'2.620',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PSPLT-ZBBG-52-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-260228-0005','2026-02-28','2.620','2026-02-28','12:43:35','PLG0009687','2010000','2010000','0','2010000','0','kasir','2026-02-28 12:43:34','FJ-260228-0004','DP-01722','1760000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-28','FJ-260228-0005','2026-02-28','12:43:35','NISA','2010000','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-260228-0004','2026-02-28','2026-02-28 12:43:34','PENJUALAN : FJ-260228-0005','.','TBC','250000','250000','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-260228-0005','D','2026-02-28','12:43:35','TBC','PENJUALAN','FJ-260228-0005','20700601514','250000','20700851514','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='2061000' WHERE no_faktur_jual='FJ-260228-0005' 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-01788','SULIS','1','PER','WEDINGRING','','','3.000','','925.00','1','100000','0','1000000','0','1000000','putih glosy','size 11 font berkshire swash','grafir: PARHAN','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-260228-0005','2026-02-28','2026-02-28 12:44:48','PESANAN : DP-01788','.','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-260228-0006','D','2026-02-28','12:44:48','TBC','PESANAN','DP-01788','20700851514','1000000','20701851514','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-01788','2026-02-28','2026-02-28','12:44:48','PLG0009688','SULIS','2026-03-14','kasirbip','2026-02-28 12:44:48','3.000','0','0','0','1000000','0','0','1000000','1000000','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01845','NISA','1','1PC CCN SLV','RESIZE KE 23 HARGA KONFIR GRF FARASH KRUM ULANG','2.230','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-01845','2026-02-28','2026-02-28','12:44:59','PLG0009689','kasir','2026-03-01','kasir','2026-02-28 12:44:59','2.230','0','0','0','0','0','0','0','0');
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-01789','SULIS','1','PER','WED RING','','','3.000','','925.00','1','100000','0','800000','0','800000','model tanpa permata putih doff semprot','sz 19 font berkshire swash','grafir CUCU','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-260228-0006','2026-02-28','2026-02-28 12:49:01','PESANAN : DP-01789','.','TBC','800000','800000');
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-260228-0007','D','2026-02-28','12:49:01','TBC','PESANAN','DP-01789','20701851514','800000','20702651514','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-01789','2026-02-28','2026-02-28','12:49:01','PLG0009690','SULIS','2026-03-14','kasirbip','2026-02-28 12:49:01','3.000','0','0','0','800000','0','0','800000','800000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-28 ','13:35:24');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-02-28 ','13:36:23');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01846','SULIS','1','PLD DAN SILVER','CWE SZ 11 5 KEDUANYA PUTIH GLOSY FONT BERKSHIRE SWASH','3.000','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-01846','2026-02-28','2026-02-28','13:36:35','PLG0009691','kasirbip','2026-03-08','kasirbip','2026-02-28 13:36:35','3.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-02-28 ','13:37:17');
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-01790','GIN','1','PER','WED RING','','','3.000','','925.00','1','100000','0','850000','0','850000','putih glossy model seperti contoh','sz 215','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260228-0007','2026-02-28','2026-02-28 13:47:45','PESANAN : DP-01790','.','TBC','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,jenis_trx) VALUES ('KM-260228-0008','D','2026-02-28','13:47:45','TBC','PESANAN','DP-01790','20702651514','850000','20703501514','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-01790','2026-02-28','2026-02-28','13:47:45','PLG0009692','GIN','2026-03-16','kasirbip','2026-02-28 13:47:45','3.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-28 ','13:48:02');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-28 ','13:49:09');
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-01791','GIN ','1','PER','WED RING','','','3.000','','925.00','1','100000','0','1000000','0','1000000','putih glossy','sz 14 font vintage rotter','grafir Rendi','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-260228-0008','2026-02-28','2026-02-28 15:55:44','PESANAN : DP-01791','.','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-260228-0009','D','2026-02-28','15:55:44','TBC','PESANAN','DP-01791','20703501514','1000000','20704501514','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-01791','2026-02-28','2026-02-28','15:55:44','PLG0009693','GIN ','2026-03-20','kasirbip','2026-02-28 15:55:44','3.000','0','0','0','1000000','0','0','1000000','1000000','0');
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-01792','GIN','1','PER','WED RING','','','3.000','','925.00','1','100000','0','800000','0','800000','putih glossy','sz 21 font vintage rotter','grafir Diani','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260228-0009','2026-02-28','2026-02-28 15:59:22','PESANAN : DP-01792','.','TBC','800000','800000');
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-260228-0010','D','2026-02-28','15:59:22','TBC','PESANAN','DP-01792','20704501514','800000','20705301514','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-01792','2026-02-28','2026-02-28','15:59:22','PLG0009694','GIN','2026-03-20','kasirbip','2026-02-28 15:59:22','3.000','0','0','0','800000','0','0','800000','800000','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-260228-0006','kasirbip','1',' DP-01645BI','TOKO','BIPPSN','PSGT-ZBAF-4-0','CINCIN EMAS ','','2.530','1','58.00','4019000','0','0','17000','6743000','0','0','0','6743000','SULIS','00041559','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZBAF-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.530',berat_jual_asli=berat_jual_asli+'2.530',stock_jual='1',berat_akhir=berat_akhir-'2.530',berat_akhir_asli=berat_akhir_asli-'2.530',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PSGT-ZBAF-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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-260228-0006','2026-02-28','2.530','2026-02-28','16:12:14','PLG0009695','6743000','6743000','0','6743000','0','kasirbip','2026-02-28 16:12:14','FJ-260228-0006','DP-01645','5300000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-28','FJ-260228-0006','2026-02-28','16:12:14','SULIS','6743000','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-260228-0010','2026-02-28','2026-02-28 16:12:14','PENJUALAN : FJ-260228-0006','.','TBC','1443000','1443000','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-260228-0011','D','2026-02-28','16:12:14','TBC','PENJUALAN','FJ-260228-0006','20705301514','1443000','20706744514','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='1443000' WHERE no_faktur_jual='FJ-260228-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0006';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01847','SULIS','1','CC EMAS','FONT BERKSHIRE SWASH','2.530','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-01847','2026-02-28','2026-02-28','16:21:38','PLG0009696','kasirbip','2026-04-07','kasirbip','2026-02-28 16:21:38','2.530','0','0','0','0','0','0','0','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-260228-0007','kasir','1',' DP-01710MM','TOKO','MMPSN','PSPLT-ZBBF-100-0','CINCIN PALADIUM ','','2.360','1','32.00','998000','0','0','17000','1880000','0','0','0','1880000','NISA','00041999','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZBBF-100-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.360',berat_jual_asli=berat_jual_asli+'2.360',stock_jual='1',berat_akhir=berat_akhir-'2.360',berat_akhir_asli=berat_akhir_asli-'2.360',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PSPLT-ZBBF-100-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-260228-0007','2026-02-28','2.360','2026-02-28','16:21:44','PLG0009697','1880000','1880000','0','1880000','0','kasir','2026-02-28 16:21:43','FJ-260228-0007','DP-01710','1560000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-28','FJ-260228-0007','2026-02-28','16:21:44','NISA','1880000','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-260228-0011','2026-02-28','2026-02-28 16:21:43','PENJUALAN : FJ-260228-0007','.','TBC','320000','320000','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-260228-0012','D','2026-02-28','16:21:44','TBC','PENJUALAN','FJ-260228-0007','20706744514','320000','20707064514','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='320000' WHERE no_faktur_jual='FJ-260228-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-260228-0008','kasir',' 1',' DP-01711MM','TOKO','MMPSN','PSPLT-ZBBF-99-0','CINCIN PALADIUM ','','2.630','1','32.00','1111000','0','0','17000','2015000','0','0','0','2015000','NISA','00041998','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZBBF-99-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.630',berat_jual_asli=berat_jual_asli+'2.630',stock_jual='1',berat_akhir=berat_akhir-'2.630',berat_akhir_asli=berat_akhir_asli-'2.630',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PSPLT-ZBBF-99-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-260228-0008','2026-02-28','2.630','2026-02-28','16:21:44','PLG0009698','2015000','2015000','0','2015000','0','kasir','2026-02-28 16:21:43','FJ-260228-0007','DP-01711','1560000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-28','FJ-260228-0008','2026-02-28','16:21:44','NISA','2015000','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-260228-0012','2026-02-28','2026-02-28 16:21:43','PENJUALAN : FJ-260228-0008','.','TBC','455000','455000','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-260228-0013','D','2026-02-28','16:21:44','TBC','PENJUALAN','FJ-260228-0008','20707064514','455000','20707519514','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='775000' WHERE no_faktur_jual='FJ-260228-0008' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-02-28 ','16:22:06');
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-01793','NISA','1','PER','CINCIN NIKAH','','','2.000','','925.00','1','100000','0','800000','0','800000','size 24 grf debby??','krum putih dove sesuai cth','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260228-0013','2026-02-28','2026-02-28 16:27:39','PESANAN : DP-01793','.','TBC','800000','800000');
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-260228-0014','D','2026-02-28','16:27:39','TBC','PESANAN','DP-01793','20707519514','800000','20708319514','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-01793','2026-02-28','2026-02-28','16:27:39','PLG0009699','NISA','2026-03-17','kasir','2026-02-28 16:27:39','2.000','0','0','0','800000','0','0','800000','800000','0');
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-01794','GIN','1','PLD','WED RING','','','1.500','','10.00','1','1200000','300000','0','750000','1200000','9 zirkon putih glossy','sz 7 font vladimir','grafir : Restu','90000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260228-0014','2026-02-28','2026-02-28 16:59:01','PESANAN : DP-01794','.','TBC','700000','700000');
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-260228-0015','D','2026-02-28','16:59:01','TBC','PESANAN','DP-01794','20708319514','700000','20709019514','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-01794','2026-02-28','2026-02-28','16:59:01','PLG0009700','GIN','2026-03-20','kasirbip','2026-02-28 16:59:01','1.500','0','0','0','700000','0','750000','1290000','1290000','590000');
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-01795','GIN','1','PLD','WED RING','','','2.500','','10.00','1','1200000','300000','0','750000','1500000','1 zirkon putih doff semprot','sz 135 font vladimir','grafir: Salwa','10000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260228-0015','2026-02-28','2026-02-28 17:02:50','PESANAN : DP-01795','.','TBC','700000','700000');
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-260228-0016','D','2026-02-28','17:02:50','TBC','PESANAN','DP-01795','20709019514','700000','20709719514','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-01795','2026-02-28','2026-02-28','17:02:50','PLG0009701','GIN','2026-03-20','kasirbip','2026-02-28 17:02:50','2.500','0','0','0','700000','0','750000','1510000','1510000','810000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-28 ','17:04:00');
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-01796','KUR','1','PLD','WED RING','','','2.500','','10.00','1','1200000','300000','0','750000','1500000','putih glossy 15 zirkon','sz 9 font berkshire swash','grafir Hamid','150000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260228-0016','2026-02-28','2026-02-28 17:20:22','PESANAN : DP-01796','.','TBC','787500','787500');
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-260228-0017','D','2026-02-28','17:20:22','TBC','PESANAN','DP-01796','20709719514','787500','20710507014','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-01796','2026-02-28','2026-02-28','17:20:22','PLG0009702','KUR','2026-03-20','kasirbip','2026-02-28 17:20:22','2.500','0','0','0','787500','0','750000','1650000','1650000','862500');
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-01797','KUR','1','PLD','WED RING','','','2.500','','10.00','1','1200000','300000','0','750000','1500000','putih doff amplas','sz 18 font berkshire swash','grafit Mila','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-260228-0017','2026-02-28','2026-02-28 17:24:27','PESANAN : DP-01797','.','TBC','787500','787500');
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-260228-0018','D','2026-02-28','17:24:27','TBC','PESANAN','DP-01797','20710507014','787500','20711294514','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-01797','2026-02-28','2026-02-28','17:24:27','PLG0009703','KUR','2026-03-20','kasirbip','2026-02-28 17:24:27','2.500','0','0','0','787500','0','750000','1500000','1500000','712500');
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-260228-0009','kasirbip','1',' 700K-19-22','TOKO','BIPPER','PBDG-ZBAA-25-0','CINCIN SILVER 925 ','','4.000','1','100.00','408000','0','0','17000','850000','0','0','0','850000','KUR','00041514','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBAA-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.000',berat_jual_asli=berat_jual_asli+'4.000',stock_jual='1',berat_akhir=berat_akhir-'4.000',berat_akhir_asli=berat_akhir_asli-'4.000',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PBDG-ZBAA-25-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-260228-0009','2026-02-28','4.000','2026-02-28','17:38:57','PLG0009704','850000','850000','0','850000','0','kasirbip','2026-02-28 17:38:57','FJ-260228-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-02-28','FJ-260228-0009','2026-02-28','17:38:57','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-260228-0018','2026-02-28','2026-02-28 17:38:57','PENJUALAN : FJ-260228-0009','.','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-260228-0019','D','2026-02-28','17:38:57','TBC','PENJUALAN','FJ-260228-0009','20711294514','850000','20712144514','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-260228-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0009';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01848','KUR','1','CC SILVER','WARNA PUTIH DOFF SEMPROT','4.000','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-01848','2026-02-28','2026-02-28','17:42:36','PLG0009705','kasirbip','2026-03-01','kasirbip','2026-02-28 17:42:36','4.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-02-28 ','17:42:56');
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-260228-0010','kasir','1',' DP-01720MM','TOKO','MMPSN','PSPRT-ZBBD-40-0','CINCIN PERAK ','','3.380','1','100.00','345000','0','0','17000','800000','0','0','0','800000','DE','00041786','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZBBD-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.380',berat_jual_asli=berat_jual_asli+'3.380',stock_jual='1',berat_akhir=berat_akhir-'3.380',berat_akhir_asli=berat_akhir_asli-'3.380',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PSPRT-ZBBD-40-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-260228-0010','2026-02-28','3.380','2026-02-28','17:43:34','PLG0009706','800000','800000','0','800000','0','kasir','2026-02-28 17:43:34','FJ-260228-0010','DP-01720','800000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-28','FJ-260228-0010','2026-02-28','17:43:34','DE','800000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260228-0010' 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-260228-0011','kasir',' 1',' DP-01719MM','TOKO','MMPSN','PSPRT-ZBBF-98-0','CINCIN PERAK ','','2.280','1','100.00','234000','0','0','17000','850000','0','0','0','850000','DE','00041997','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZBBF-98-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.280',berat_jual_asli=berat_jual_asli+'2.280',stock_jual='1',berat_akhir=berat_akhir-'2.280',berat_akhir_asli=berat_akhir_asli-'2.280',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PSPRT-ZBBF-98-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-260228-0011','2026-02-28','2.280','2026-02-28','17:43:34','PLG0009707','850000','850000','0','850000','0','kasir','2026-02-28 17:43:34','FJ-260228-0010','DP-01719','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-28','FJ-260228-0011','2026-02-28','17:43:34','DE','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260228-0011' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0011';
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-01798','SULIS','1','PLD','WED RING','','','2.500','','10.00','1','1200000','300000','0','750000','1500000','3 zircon putih glosy','sz 9.5 font times new roman','grf BBN . FFA','30000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260228-0019','2026-02-28','2026-02-28 19:06:30','PESANAN : DP-01798','.','TBC','765000','765000');
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-260228-0020','D','2026-02-28','19:06:30','TBC','PESANAN','DP-01798','20712144514','765000','20712909514','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-01798','2026-02-28','2026-02-28','19:06:30','PLG0009708','SULIS','2026-03-20','kasirbip','2026-02-28 19:06:30','2.500','0','0','0','765000','0','750000','1530000','1530000','765000');
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-01799','SULIS','1','PLD','WED RING','','','3.500','','10.00','1','1200000','300000','0','700000','1750000','sz 17.5 model tanpa permata','putih glosy font times new roman','FFA . BBN','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260228-0020','2026-02-28','2026-02-28 19:11:40','PESANAN : DP-01799','.','TBC','875000','875000');
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-260228-0021','D','2026-02-28','19:11:40','TBC','PESANAN','DP-01799','20712909514','875000','20713784514','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-01799','2026-02-28','2026-02-28','19:11:40','PLG0009709','SULIS','2026-03-20','kasirbip','2026-02-28 19:11:40','3.500','0','0','0','875000','0','700000','1750000','1750000','875000');
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-01800','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','800000','0','800000','sz 13 putih glosy 1 zircon','font vladimir','grf Nana & Falih','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260228-0021','2026-02-28','2026-02-28 19:17:08','PESANAN : DP-01800','.','TBC','800000','800000');
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-260228-0022','D','2026-02-28','19:17:08','TBC','PESANAN','DP-01800','20713784514','800000','20714584514','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-01800','2026-02-28','2026-02-28','19:17:08','PLG0009710','SULIS','2026-03-20','kasirbip','2026-02-28 19:17:08','2.000','0','0','0','800000','0','0','800000','800000','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-260228-0012','kasirbip','1',' DP-01694BI','TOKO','BIPPSN','PSGT-ZBAH-10-0','CINCIN EMAS ','','2.070','1','83.00','4680000','0','0','17000','6115000','0','0','0','6115000','SULIS','00041628','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZBAH-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PSGT-ZBAH-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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-260228-0012','2026-02-28','2.070','2026-02-28','19:35:00','PLG0009711','6115000','6115000','0','6115000','0','kasirbip','2026-02-28 19:35:00','FJ-260228-0012','DP-01694','4752000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-28','FJ-260228-0012','2026-02-28','19:35:00','SULIS','6115000','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-260228-0022','2026-02-28','2026-02-28 19:35:00','PENJUALAN : FJ-260228-0012','.','TBC','1363000','1363000','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-260228-0023','D','2026-02-28','19:35:00','TBC','PENJUALAN','FJ-260228-0012','20714584514','1363000','20715947514','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='1363000' WHERE no_faktur_jual='FJ-260228-0012' 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-260228-0013','kasirbip',' 1',' DP-01695BI','TOKO','BIPPSN','PSPLT-ZBAF-7-0','CINCIN PALADIUM ','','4.030','1','17.00','905000','0','0','17000','1709000','0','0','0','1709000','SULIS','00041562','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZBAF-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.030',berat_jual_asli=berat_jual_asli+'4.030',stock_jual='1',berat_akhir=berat_akhir-'4.030',berat_akhir_asli=berat_akhir_asli-'4.030',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PSPLT-ZBAF-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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-260228-0013','2026-02-28','4.030','2026-02-28','19:35:00','PLG0009712','1709000','1709000','0','1709000','0','kasirbip','2026-02-28 19:35:00','FJ-260228-0012','DP-01695','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-28','FJ-260228-0013','2026-02-28','19:35:00','SULIS','1709000','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-260228-0023','2026-02-28','2026-02-28 19:35:00','PENJUALAN : FJ-260228-0013','.','TBC','859000','859000','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-260228-0024','D','2026-02-28','19:35:00','TBC','PENJUALAN','FJ-260228-0013','20715947514','859000','20716806514','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='2222000' WHERE no_faktur_jual='FJ-260228-0013' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0013';
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-260228-0014','kasirbip','1',' 700K-15-22','TOKO','BIPPER','PBDG-ZBAA-13-0','CINCIN SILVER 925 ','','2.310','1','100.00','236000','0','0','17000','850000','0','0','0','850000','KUR','00041502','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBAA-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.310',berat_jual_asli=berat_jual_asli+'2.310',stock_jual='1',berat_akhir=berat_akhir-'2.310',berat_akhir_asli=berat_akhir_asli-'2.310',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PBDG-ZBAA-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-260228-0014','2026-02-28','2.310','2026-02-28','19:45:55','PLG0009713','850000','850000','0','850000','0','kasirbip','2026-02-28 19:45:55','FJ-260228-0014','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-28','FJ-260228-0014','2026-02-28','19:45:55','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-260228-0024','2026-02-28','2026-02-28 19:45:55','PENJUALAN : FJ-260228-0014','.','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-260228-0025','D','2026-02-28','19:45:55','TBC','PENJUALAN','FJ-260228-0014','20716806514','850000','20717656514','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-260228-0014' 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-260228-0015','kasirbip',' 1',' 700K-12-21','TOKO','BIPPER','PBDG-ZAAF-4-0','CINCIN SILVER 925 ','','2.390','1','100.00','147000','0','0','17000','850000','0','0','0','850000','KUR','00040941','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZAAF-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.390',berat_jual_asli=berat_jual_asli+'2.390',stock_jual='1',berat_akhir=berat_akhir-'2.390',berat_akhir_asli=berat_akhir_asli-'2.390',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PBDG-ZAAF-4-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-260228-0015','2026-02-28','2.390','2026-02-28','19:45:55','PLG0009714','850000','850000','0','850000','0','kasirbip','2026-02-28 19:45:55','FJ-260228-0014','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-28','FJ-260228-0015','2026-02-28','19:45:55','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-260228-0025','2026-02-28','2026-02-28 19:45:55','PENJUALAN : FJ-260228-0015','.','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-260228-0026','D','2026-02-28','19:45:55','TBC','PENJUALAN','FJ-260228-0015','20717656514','850000','20718506514','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='1700000' WHERE no_faktur_jual='FJ-260228-0015' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0015';
UPDATE th_user_login SET tgl_logout = '2026-02-28', jam_logout = '20:29:01' WHERE user_id = 'kasir' AND tgl_login = '2026-02-28' AND jam_login= '10:27:02';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-02-28 ','20:29:39');
DELETE FROM tm_berlian WHERE kode_barang='PMM-YFBC-42-0';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('PMM-YFBC-42-0','00036652','00036652','CINCIN SILVER 925 ','CINCIN SILVER 925','','','40500','40500',' 150000','150000','Nagatech','2026-02-28 20:36:33');
UPDATE tm_barang SET nama_barang='CINCIN SILVER 925' ,nama_atribut='' ,kode_intern='700K-12-00176 ', kadar_cetak='925.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='PMM-YFBC-42-0' 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-260228-0016','Nagatech','1',' 850K-13-64','TOKO','MMPER','PMM-YLAX-80-0','CINCIN SILVER 925 ','','1.780','1','100.00','110000','0','0','17000','950000','0','0','0','950000','DE','00040482','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YLAX-80-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.780',berat_jual_asli=berat_jual_asli+'1.780',stock_jual='1',berat_akhir=berat_akhir-'1.780',berat_akhir_asli=berat_akhir_asli-'1.780',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PMM-YLAX-80-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-260228-0016','2026-02-28','1.780','2026-02-28','20:38:01','PLG0009715','950000','950000','0','950000','0','Nagatech','2026-02-28 20:38:01','FJ-260228-0016','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-28','FJ-260228-0016','2026-02-28','20:38:01','DE','950000','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-260228-0026','2026-02-28','2026-02-28 20:38:01','PENJUALAN : FJ-260228-0016','.','TBC','950000','950000','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-260228-0027','D','2026-02-28','20:38:01','TBC','PENJUALAN','FJ-260228-0016','20718506514','950000','20719456514','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='950000' WHERE no_faktur_jual='FJ-260228-0016' 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-260228-0017','Nagatech',' 1',' 700K-12-00','TOKO','MMPER','PMM-YFBC-42-0','CINCIN SILVER 925','','2.010','1','100.00','47000','0','0','17000','800000','0','0','0','800000','DE','00036652','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBC-42-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.010',berat_jual_asli=berat_jual_asli+'2.010',stock_jual='1',berat_akhir=berat_akhir-'2.010',berat_akhir_asli=berat_akhir_asli-'2.010',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PMM-YFBC-42-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-260228-0017','2026-02-28','2.010','2026-02-28','20:38:01','PLG0009716','800000','800000','0','800000','0','Nagatech','2026-02-28 20:38:01','FJ-260228-0016','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-28','FJ-260228-0017','2026-02-28','20:38:01','DE','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-260228-0027','2026-02-28','2026-02-28 20:38:01','PENJUALAN : FJ-260228-0017','.','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-260228-0028','D','2026-02-28','20:38:01','TBC','PENJUALAN','FJ-260228-0017','20719456514','800000','20720256514','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-260228-0017' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZBBC-83-0';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('PMM-ZBBC-83-0','00041744','00041744','CINCIN SILVER 925 ','CINCIN SILVER 925','','','116500','116500',' 250000','250000','Nagatech','2026-02-28 20:41:26');
UPDATE tm_barang SET nama_barang='CINCIN SILVER 925' ,nama_atribut='' ,kode_intern='700K-15-811 ', kadar_cetak='925.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='PMM-ZBBC-83-0' 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-260228-0018','Nagatech','1',' 500K-21-76','TOKO','MMPER','PMM-ZABX-8-0','CINCIN SILVER 925 ','','2.150','1','100.00','132000','0','0','17000','500000','0','0','0','500000','NISA','00041034','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZABX-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.150',berat_jual_asli=berat_jual_asli+'2.150',stock_jual='1',berat_akhir=berat_akhir-'2.150',berat_akhir_asli=berat_akhir_asli-'2.150',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PMM-ZABX-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-260228-0018','2026-02-28','2.150','2026-02-28','20:42:07','PLG0009717','500000','500000','0','500000','0','Nagatech','2026-02-28 20:42:07','FJ-260228-0018','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-28','FJ-260228-0018','2026-02-28','20:42:07','NISA','500000','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-260228-0028','2026-02-28','2026-02-28 20:42:07','PENJUALAN : FJ-260228-0018','.','TBC','500000','500000','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-260228-0029','D','2026-02-28','20:42:07','TBC','PENJUALAN','FJ-260228-0018','20720256514','500000','20720756514','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='500000' WHERE no_faktur_jual='FJ-260228-0018' 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-260228-0019','Nagatech',' 1',' 700K-15-81','TOKO','MMPER','PMM-ZBBC-83-0','CINCIN SILVER 925','','1.160','1','100.00','119000','0','0','17000','350000','0','0','0','350000','NISA','00041744','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZBBC-83-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.160',berat_jual_asli=berat_jual_asli+'1.160',stock_jual='1',berat_akhir=berat_akhir-'1.160',berat_akhir_asli=berat_akhir_asli-'1.160',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PMM-ZBBC-83-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-260228-0019','2026-02-28','1.160','2026-02-28','20:42:07','PLG0009718','350000','350000','0','350000','0','Nagatech','2026-02-28 20:42:07','FJ-260228-0018','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-28','FJ-260228-0019','2026-02-28','20:42:07','NISA','350000','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-260228-0029','2026-02-28','2026-02-28 20:42:07','PENJUALAN : FJ-260228-0019','.','TBC','350000','350000','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-260228-0030','D','2026-02-28','20:42:07','TBC','PENJUALAN','FJ-260228-0019','20720756514','350000','20721106514','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-260228-0019' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZBBC-82-0';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('PMM-ZBBC-82-0','00041743','00041743','CINCIN SILVER 925 ','CINCIN SILVER 925','','','110500','110500',' 250000','250000','Nagatech','2026-02-28 20:45:05');
UPDATE tm_barang SET nama_barang='CINCIN SILVER 925' ,nama_atribut='' ,kode_intern='700K-13-810 ', kadar_cetak='925.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='PMM-ZBBC-82-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZBXC-8-0';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('PMM-ZBXC-8-0','00041302','00041302','CINCIN SILVER 925 ','CINCIN SILVER 925','','','212000','212000',' 250000','250000','Nagatech','2026-02-28 20:48:34');
UPDATE tm_barang SET nama_barang='CINCIN SILVER 925' ,nama_atribut='' ,kode_intern='500K-22-790 ', kadar_cetak='925.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='PMM-ZBXC-8-0' 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-260228-0020','Nagatech','1',' 700K-13-81','TOKO','MMPER','PMM-ZBBC-82-0','CINCIN SILVER 925','','1.100','1','100.00','113000','0','0','17000','350000','0','0','0','350000','DE','00041743','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZBBC-82-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PMM-ZBBC-82-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-260228-0020','2026-02-28','1.100','2026-02-28','20:48:50','PLG0009719','350000','350000','0','350000','0','Nagatech','2026-02-28 20:48:50','FJ-260228-0020','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-28','FJ-260228-0020','2026-02-28','20:48:50','DE','350000','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-260228-0030','2026-02-28','2026-02-28 20:48:50','PENJUALAN : FJ-260228-0020','.','TBC','350000','350000','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-260228-0031','D','2026-02-28','20:48:50','TBC','PENJUALAN','FJ-260228-0020','20721106514','350000','20721456514','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='350000' WHERE no_faktur_jual='FJ-260228-0020' 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-260228-0021','Nagatech',' 1',' 500K-22-79','TOKO','MMPER','PMM-ZBXC-8-0','CINCIN SILVER 925','','2.120','1','100.00','217000','0','0','17000','500000','0','0','0','500000','DE','00041302','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZBXC-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.120',berat_jual_asli=berat_jual_asli+'2.120',stock_jual='1',berat_akhir=berat_akhir-'2.120',berat_akhir_asli=berat_akhir_asli-'2.120',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PMM-ZBXC-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-260228-0021','2026-02-28','2.120','2026-02-28','20:48:50','PLG0009720','500000','500000','0','500000','0','Nagatech','2026-02-28 20:48:50','FJ-260228-0020','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-28','FJ-260228-0021','2026-02-28','20:48:50','DE','500000','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-260228-0031','2026-02-28','2026-02-28 20:48:50','PENJUALAN : FJ-260228-0021','.','TBC','500000','500000','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-260228-0032','D','2026-02-28','20:48:50','TBC','PENJUALAN','FJ-260228-0021','20721456514','500000','20721956514','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-260228-0021' 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-01849','DE','1','2PC CCN SLV','CEWE RESIZE KE 11 GRF KEMAL DAN COWO RESIZE KE 20 GRF GITA','3.220','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-01849','2026-02-28','2026-02-28','20:50:48','PLG0009721','Nagatech','2026-03-01','Nagatech','2026-02-28 20:50:48','3.220','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-02-28 ','20:53:13');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01850','NISA','1','2PC CCN SLV','CEWE RESIZE KE 11 GRF ERDY DAN COWOW RESIZE KE 18 GRF NABILA KRUM PUTIH','3.310','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-01850','2026-02-28','2026-02-28','20:53:25','PLG0009722','Nagatech','2026-03-01','Nagatech','2026-02-28 20:53:25','3.310','0','0','0','0','0','0','0','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01851','DE','1','2PC CCN SLV','CEWE RESIZE KE 11 5 GRF RYAN DAN COW RESIZE KE 14 GRF MARIA KRUM FULL PUTIH GLOSI','3.790','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-01851','2026-02-28','2026-02-28','20:54:42','PLG0009723','Nagatech','2026-03-01','Nagatech','2026-02-28 20:54:42','3.790','0','0','0','0','0','0','0','0');
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-01801','GIN','1','GOLD','WED RING','','','4.580','','75.00','1','2720000','2450000','0','750000','11971000','14 zirkon rose gold glosy','sz 105 font berkshire swash','grafir Agus','140000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260228-0032','2026-02-28','2026-02-28 21:02:12','PESANAN : DP-01801','.','TBC','5677500','5677500');
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-260228-0033','D','2026-02-28','21:02:12','TBC','PESANAN','DP-01801','20721956514','5677500','20727634014','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-01801','2026-02-28','2026-02-28','21:02:12','PLG0009724','GIN','2026-03-20','kasirbip','2026-02-28 21:02:12','4.580','0','0','0','5677500','0','750000','12111000','12111000','6433500');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-28 ','21:07:38');
UPDATE tt_service_head SET tgl_selesai='2026-02-28',  status ='DONE' WHERE no_service='SV-01836';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01836';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-02-28',  status ='CLOS' WHERE no_service='SV-01836';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01836';
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-01802','GIN','1','GOLD','WED RING','','','4.020','','75.00','1','2720000','2450000','0','750000','10599000','rose gold putih doff amplas','sz 20 font berkshire swash','grafir Dewi','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-260228-0033','2026-02-28','2026-02-28 21:17:12','PESANAN : DP-01802','.','TBC','5677500','5677500');
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-260228-0034','D','2026-02-28','21:17:12','TBC','PESANAN','DP-01802','20727634014','5677500','20733311514','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-01802','2026-02-28','2026-02-28','21:17:12','PLG0009725','GIN','2026-03-20','kasirbip','2026-02-28 21:17:12','4.020','0','0','0','5677500','0','750000','10599000','10599000','4921500');
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-260228-0022','kasirbip','1',' 750K-21-22','TOKO','BIPPER','PBDG-ZBXE-7-0','CINCIN SILVER 925 ','','4.120','1','100.00','421000','0','0','17000','900000','0','0','0','900000','KUR','00041330','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBXE-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.120',berat_jual_asli=berat_jual_asli+'4.120',stock_jual='1',berat_akhir=berat_akhir-'4.120',berat_akhir_asli=berat_akhir_asli-'4.120',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PBDG-ZBXE-7-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-260228-0022','2026-02-28','4.120','2026-02-28','21:29:24','PLG0009726','900000','900000','0','900000','0','kasirbip','2026-02-28 21:29:24','FJ-260228-0022','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-28','FJ-260228-0022','2026-02-28','21:29:24','KUR','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-260228-0034','2026-02-28','2026-02-28 21:29:24','PENJUALAN : FJ-260228-0022','.','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-260228-0035','D','2026-02-28','21:29:24','TBC','PENJUALAN','FJ-260228-0022','20733311514','900000','20734211514','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-260228-0022' 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-260228-0023','kasirbip',' 1',' 850K-11-13','TOKO','BIPPER','PBDG-YFXD-36-0','CINCIN SILVER 925 ','','1.620','1','100.00','38000','0','0','17000','1000000','0','0','0','1000000','KUR','00036126','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YFXD-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.620',berat_jual_asli=berat_jual_asli+'1.620',stock_jual='1',berat_akhir=berat_akhir-'1.620',berat_akhir_asli=berat_akhir_asli-'1.620',stock_akhir='0' WHERE tanggal='2026-02-28' AND kode_barang='PBDG-YFXD-36-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-260228-0023','2026-02-28','1.620','2026-02-28','21:29:24','PLG0009727','1000000','1000000','0','1000000','0','kasirbip','2026-02-28 21:29:24','FJ-260228-0022','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-28','FJ-260228-0023','2026-02-28','21:29:24','KUR','1000000','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-260228-0035','2026-02-28','2026-02-28 21:29:24','PENJUALAN : FJ-260228-0023','.','TBC','1000000','1000000','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-260228-0036','D','2026-02-28','21:29:24','TBC','PENJUALAN','FJ-260228-0023','20734211514','1000000','20735211514','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='1900000' WHERE no_faktur_jual='FJ-260228-0023' 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-01852','KUR','1','SEPASANG CC SILVER','CWE KECILIN NO 10 FONT BERKSHIRE SWASH GRAFIR','4.000','2','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-01852','2026-02-28','2026-02-28','21:35:59','PLG0009728','kasirbip','2026-03-11','kasirbip','2026-02-28 21:35:59','4.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-02-28 ','21:36:22');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0017';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0019';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0020';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260228-0023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260228-0023';