INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-20','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-17';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-19';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-19';
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-03-19' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-19';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-19';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-19';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-19';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-20' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-19' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260320-0001','D','2026-03-20','07:50:44','SYSTEM','SALDO AWAL','SALDO AWAL','0','7423721000','7423721000');
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-260320-0001','D','2026-03-20','07:50:44','BCA','SALDO AWAL','SALDO AWAL','0','4317221888','4317221888');
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-260320-0001','D','2026-03-20','07:50:44','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
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-260320-0001','D','2026-03-20','07:50:44','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260320-0001','D','2026-03-20','07:50:44','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260320-0001','D','2026-03-20','07:50:44','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2026-03-20';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F1E-ZCBX-1-T','T0078211','MEF1 UB D52 ','GL OVAL MODEL C UB D52 8K ','','GR','---','ME','F1E','TOKO','01-SEM','2499000','2026-03-20','2499000','2.100','100.00','8','0','1190000.00','1','0.04', 'input','2026-03-20 08:57:16','2.100','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F1E','F1E-ZCBX-1-T','T0078211');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','F1E-ZCBX-1-T','F1E','TOKO','01-SEM','100.00','2.100','2.100','1','2.100','2.100','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F1E-ZCBX-2-T','T0078212','MEF1 UB D52 ','GL OVAL MODEL C UB D52 8K ','','GR','---','ME','F1E','TOKO','01-SEM','2630000','2026-03-20','2630000','2.210','100.00','8','0','1190000.00','1','0.04', 'input','2026-03-20 08:57:24','2.210','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F1E','F1E-ZCBX-2-T','T0078212');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','F1E-ZCBX-2-T','F1E','TOKO','01-SEM','100.00','2.210','2.210','1','2.210','2.210','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZCBX-3-T','T0078213','MDE2 CM 16 ','CC WEDDING MATA CM 16 8K ','','GR','---','MD','E2D','TOKO','01-SEM','2609500','2026-03-20','2609500','2.230','100.00','8','0','1170000.00','1','0.04', 'input','2026-03-20 09:00:24','2.230','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZCBX-3-T','T0078213');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','E2D-ZCBX-3-T','E2D','TOKO','01-SEM','100.00','2.230','2.230','1','2.230','2.230','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZCBX-4-T','T0078214','MDE2 CM 16 ','CC WEDDING MATA CM 16 8K ','','GR','---','MD','E2D','TOKO','01-SEM','2457000','2026-03-20','2457000','2.100','100.00','8','0','1170000.00','1','0.04', 'input','2026-03-20 09:00:30','2.100','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZCBX-4-T','T0078214');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','E2D-ZCBX-4-T','E2D','TOKO','01-SEM','100.00','2.100','2.100','1','2.100','2.100','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZCBX-5-T','T0078215','MDE2 CM 24 ','CC WEDDING MATA CM 24 8K ','','GR','---','MD','E2D','TOKO','01-SEM','2586000','2026-03-20','2586000','2.210','100.00','8','0','1170000.00','1','0.04', 'input','2026-03-20 09:00:43','2.210','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZCBX-5-T','T0078215');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','E2D-ZCBX-5-T','E2D','TOKO','01-SEM','100.00','2.210','2.210','1','2.210','2.210','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZCBX-6-T','T0078216','MEE1 CM 15 ','CC MODEL SLEP VAR CM 15 8K ','','GR','---','ME','E1E','TOKO','01-SEM','654500','2026-03-20','654500','0.550','100.00','8','0','1190000.00','1','0.04', 'input','2026-03-20 09:03:04','0.550','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZCBX-6-T','T0078216');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','E1E-ZCBX-6-T','E1E','TOKO','01-SEM','100.00','0.550','0.550','1','0.550','0.550','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZCBX-7-T','T0078217','MEE1 CM 13 ','CC MODEL SLEP VAR CM 13 8K ','','GR','---','ME','E1E','TOKO','01-SEM','738000','2026-03-20','738000','0.620','100.00','8','0','1190000.00','1','0.04', 'input','2026-03-20 09:03:17','0.620','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZCBX-7-T','T0078217');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','E1E-ZCBX-7-T','E1E','TOKO','01-SEM','100.00','0.620','0.620','1','0.620','0.620','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZCBX-8-T','T0078218','MEE1 CM 13 ','CC MODEL SLEP VAR CM 13 8K ','','GR','---','ME','E1E','TOKO','01-SEM','750000','2026-03-20','750000','0.630','100.00','8','0','1190000.00','1','0.04', 'input','2026-03-20 09:03:29','0.630','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZCBX-8-T','T0078218');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','E1E-ZCBX-8-T','E1E','TOKO','01-SEM','100.00','0.630','0.630','1','0.630','0.630','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZCBX-9-T','T0078219','MEE1 CM 14 ','CC MODEL SLEP VAR CM 14 8K ','','GR','---','ME','E1E','TOKO','01-SEM','654500','2026-03-20','654500','0.550','100.00','8','0','1190000.00','1','0.04', 'input','2026-03-20 09:04:00','0.550','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZCBX-9-T','T0078219');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','E1E-ZCBX-9-T','E1E','TOKO','01-SEM','100.00','0.550','0.550','1','0.550','0.550','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZCBX-10-T','T0078220','MEE1 CM 12 ','CC MODEL SLEP VAR CM 12 8K ','','GR','---','ME','E1E','TOKO','01-SEM','571500','2026-03-20','571500','0.480','100.00','8','0','1190000.00','1','0.04', 'input','2026-03-20 09:04:10','0.480','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZCBX-10-T','T0078220');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','E1E-ZCBX-10-T','E1E','TOKO','01-SEM','100.00','0.480','0.480','1','0.480','0.480','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZCBX-11-T','T0078221','MEE1 CM 15 ','CC MODEL SLEP VAR HW 15 8K ','','GR','---','ME','E1E','TOKO','01-SEM','833000','2026-03-20','833000','0.700','100.00','8','0','1190000.00','1','0.04', 'input','2026-03-20 09:04:40','0.700','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZCBX-11-T','T0078221');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','E1E-ZCBX-11-T','E1E','TOKO','01-SEM','100.00','0.700','0.700','1','0.700','0.700','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZCBX-12-T','T0078222','MEE1 CM 17 ','CC MODEL SLEP VAR HW 17 8K ','','GR','---','ME','E1E','TOKO','01-SEM','916500','2026-03-20','916500','0.770','100.00','8','0','1190000.00','1','0.04', 'input','2026-03-20 09:04:48','0.770','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZCBX-12-T','T0078222');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','E1E-ZCBX-12-T','E1E','TOKO','01-SEM','100.00','0.770','0.770','1','0.770','0.770','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0001','1','F1E-ZCBX-1-T','1','2.100','2.100','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-F' WHERE kode_barang='F1E-ZCBX-1-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-20','TOKO','SMBK-F','F1E','F1E-ZCBX-1-T','100.00','1','2.100','2.100','1','2.100','2.100');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.100',berat_out_asli=berat_out_asli+'2.100',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-20' AND kode_barang='F1E-ZCBX-1-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0001','2','F1E-ZCBX-2-T','1','2.210','2.210','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-F' WHERE kode_barang='F1E-ZCBX-2-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-20','TOKO','SMBK-F','F1E','F1E-ZCBX-2-T','100.00','1','2.210','2.210','1','2.210','2.210');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.210',berat_out_asli=berat_out_asli+'2.210',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-20' AND kode_barang='F1E-ZCBX-2-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260320-0001','2026-03-20','2026-03-20','09:05','4.31','input','2026-03-20 09:05:42');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0002','1','E1E-ZCBX-10-T','1','0.48','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1E-ZCBX-10-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-20','TOKO','SMBK-E','E1E','E1E-ZCBX-10-T' , '1','0.48','0.48', '1','0.48','0.48','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.48',berat_out_asli=berat_out_asli+'0.48',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1E-ZCBX-10-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0002','2','E1E-ZCBX-11-T','1','0.7','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1E-ZCBX-11-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-20','TOKO','SMBK-E','E1E','E1E-ZCBX-11-T' , '1','0.7','0.7', '1','0.7','0.7','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.7',berat_out_asli=berat_out_asli+'0.7',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1E-ZCBX-11-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0002','3','E1E-ZCBX-12-T','1','0.77','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1E-ZCBX-12-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-20','TOKO','SMBK-E','E1E','E1E-ZCBX-12-T' , '1','0.77','0.77', '1','0.77','0.77','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.77',berat_out_asli=berat_out_asli+'0.77',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1E-ZCBX-12-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0002','4','E1E-ZCBX-6-T','1','0.55','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1E-ZCBX-6-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-20','TOKO','SMBK-E','E1E','E1E-ZCBX-6-T' , '1','0.55','0.55', '1','0.55','0.55','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.55',berat_out_asli=berat_out_asli+'0.55',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1E-ZCBX-6-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0002','5','E1E-ZCBX-7-T','1','0.62','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1E-ZCBX-7-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-20','TOKO','SMBK-E','E1E','E1E-ZCBX-7-T' , '1','0.62','0.62', '1','0.62','0.62','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.62',berat_out_asli=berat_out_asli+'0.62',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1E-ZCBX-7-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0002','6','E1E-ZCBX-8-T','1','0.63','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1E-ZCBX-8-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-20','TOKO','SMBK-E','E1E','E1E-ZCBX-8-T' , '1','0.63','0.63', '1','0.63','0.63','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.63',berat_out_asli=berat_out_asli+'0.63',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1E-ZCBX-8-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0002','7','E1E-ZCBX-9-T','1','0.55','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1E-ZCBX-9-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-20','TOKO','SMBK-E','E1E','E1E-ZCBX-9-T' , '1','0.55','0.55', '1','0.55','0.55','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.55',berat_out_asli=berat_out_asli+'0.55',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1E-ZCBX-9-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0002','8','E2D-ZCBX-3-T','1','2.23','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-ZCBX-3-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-20','TOKO','SMBK-E','E2D','E2D-ZCBX-3-T' , '1','2.23','2.23', '1','2.23','2.23','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.23',berat_out_asli=berat_out_asli+'2.23',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-ZCBX-3-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0002','9','E2D-ZCBX-4-T','1','2.1','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-ZCBX-4-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-20','TOKO','SMBK-E','E2D','E2D-ZCBX-4-T' , '1','2.1','2.1', '1','2.1','2.1','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.1',berat_out_asli=berat_out_asli+'2.1',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-ZCBX-4-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0002','10','E2D-ZCBX-5-T','1','2.21','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-ZCBX-5-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-20','TOKO','SMBK-E','E2D','E2D-ZCBX-5-T' , '1','2.21','2.21', '1','2.21','2.21','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.21',berat_out_asli=berat_out_asli+'2.21',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-ZCBX-5-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-260320-0002','2026-03-20','2026-03-20','09:06','10.84','input','2026-03-20 09:06:27');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226200911411','kasir','1',' TAE0 X DW ','TOKO','TBK-E','E0TA-WCXA-13-T','CC X POLOS DW 12 ','','2.000','1','100.00','4120000','0','0','15000','4120000','0','0','0','4120000','RTA','T0042439','E0TA','0','0','-','0','2060000');
UPDATE tm_barang SET tgl_last_jual='2026-03-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E0TA-WCXA-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-03-20' AND kode_barang='E0TA-WCXA-13-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200911411','2026-03-20','2.000','2026-03-20','09:11:42','PLG0078354','4120000','4120000','0','4120000','4120000','kasir','2026-03-20 09:11:41','F22620091141');
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-03-20','F226200911411','2026-03-20','09:11:42','RTA','4120000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260320-0002','D','2026-03-20','09:11:42','kasir','PENJUALAN','F226200911411','7423721000','4120000','7427841000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226200914391','kasir','1',' MEF3E X LT','TOKO','SMBK-F','F3E-ZCXB-324-0','GL X RANTAI HOLLOW ANAK P3 SLEP LT 8K ','','1.050','1','100.00','1249000','0','0','15000','1250000','0','0','0','1250000','TIN','00391747','F3E','0','0','-','0','1190000');
UPDATE tm_barang SET tgl_last_jual='2026-03-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCXB-324-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-03-20' AND kode_barang='F3E-ZCXB-324-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200914391','2026-03-20','1.050','2026-03-20','09:14:39','PLG0078355','1250000','1250000','0','1250000','1250000','kasir','2026-03-20 09:14:39','F22620091439');
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-03-20','F226200914391','2026-03-20','09:14:39','TIN','1250000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260320-0003','D','2026-03-20','09:14:39','kasir','PENJUALAN','F226200914391','7427841000','1250000','7429091000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226200916231','kasir','1',' MEF3 7K HW','TOKO','SMBK-F','F3E-YHXG-418-0','GL SIEM MODEL KUPU SLEP 3C VAR HW 8K ','OL','1.440','1','100.00','1714000','0','0','15000','1729000','0','14000','0','1743000','RTA','00364467','F3E','0','0','-','0','1190000');
UPDATE tm_barang SET tgl_last_jual='2026-03-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YHXG-418-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.440',berat_jual_asli=berat_jual_asli+'1.440',stock_jual='1',berat_akhir=berat_akhir-'1.440',berat_akhir_asli=berat_akhir_asli-'1.440',stock_akhir='0' WHERE tanggal='2026-03-20' AND kode_barang='F3E-YHXG-418-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200916231','2026-03-20','1.440','2026-03-20','09:16:23','PLG0078356','1729000','1729000','14000','1743000','1743000','kasir','2026-03-20 09:16:23','F22620091623');
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-03-20','F226200916231','2026-03-20','09:16:23','RTA','1743000','14000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260320-0004','D','2026-03-20','09:16:23','kasir','PENJUALAN','F226200916231','7429091000','1743000','7430834000');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('A1E-ZCBX-13-T','T0078223','MEA1 LG ','AT MODEL DEASY MATA LG 8K ','','GR','---','ME','A1E','TOKO','01-SEM','595000','2026-03-20','595000','0.500','100.00','8','0','1190000.00','1','0.04', 'input','2026-03-20 09:28:00','0.500','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1E','A1E-ZCBX-13-T','T0078223');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','A1E-ZCBX-13-T','A1E','TOKO','01-SEM','100.00','0.500','0.500','1','0.500','0.500','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('A1E-ZCBX-14-T','T0078224','MEA1 LG ','AT MODEL DEASY MATA LG 8K ','','GR','---','ME','A1E','TOKO','01-SEM','607000','2026-03-20','607000','0.510','100.00','8','0','1190000.00','1','0.04', 'input','2026-03-20 09:28:08','0.510','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1E','A1E-ZCBX-14-T','T0078224');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','A1E-ZCBX-14-T','A1E','TOKO','01-SEM','100.00','0.510','0.510','1','0.510','0.510','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('A1D-ZCBX-15-T','T0078225','MDA1 HW ','AT MODEL BUNGA CLOVER SLEP HW 8K ','','GR','---','MD','A1D','TOKO','01-SEM','1018000','2026-03-20','1018000','0.870','100.00','8','0','1170000.00','1','0.04', 'input','2026-03-20 09:28:54','0.870','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1D','A1D-ZCBX-15-T','T0078225');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','A1D-ZCBX-15-T','A1D','TOKO','01-SEM','100.00','0.870','0.870','1','0.870','0.870','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('A1D-ZCBX-16-T','T0078226','MDA1 UB ','AT KLIP MODEL C UB 8K ','','GR','---','MD','A1D','TOKO','01-SEM','1310500','2026-03-20','1310500','1.120','100.00','8','0','1170000.00','1','0.04', 'input','2026-03-20 09:29:17','1.120','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1D','A1D-ZCBX-16-T','T0078226');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','A1D-ZCBX-16-T','A1D','TOKO','01-SEM','100.00','1.120','1.120','1','1.120','1.120','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1E-ZCBX-17-T','T0078227','MED1 MJ ','LT MODEL HATI VAR MJ 8K ','','GR','---','ME','D1E','TOKO','01-SEM','654500','2026-03-20','654500','0.550','100.00','8','','1190000.00','1','0.04', 'input','2026-03-20 09:30:36','0.550','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1E','D1E-ZCBX-17-T','T0078227');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','D1E-ZCBX-17-T','D1E','TOKO','01-SEM','100.00','0.550','0.550','1','0.550','0.550','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1E-ZCBX-18-T','T0078228','MED1 MJ ','LT MODEL HATI VAR MJ 8K ','','GR','---','ME','D1E','TOKO','01-SEM','607000','2026-03-20','607000','0.510','100.00','8','0','1190000.00','1','0.04', 'input','2026-03-20 09:30:47','0.510','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1E','D1E-ZCBX-18-T','T0078228');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','D1E-ZCBX-18-T','D1E','TOKO','01-SEM','100.00','0.510','0.510','1','0.510','0.510','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1E-ZCBX-19-T','T0078229','MED1 MJ ','LT MODEL BUNGA VAR MJ 8K ','','GR','---','ME','D1E','TOKO','01-SEM','690500','2026-03-20','690500','0.580','100.00','8','0','1190000.00','1','0.04', 'input','2026-03-20 09:31:13','0.580','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1E','D1E-ZCBX-19-T','T0078229');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','D1E-ZCBX-19-T','D1E','TOKO','01-SEM','100.00','0.580','0.580','1','0.580','0.580','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1E-ZCBX-20-T','T0078230','MED1 MJ ','LT MODEL BUNGA VAR MJ 8K ','','GR','---','ME','D1E','TOKO','01-SEM','714000','2026-03-20','714000','0.600','100.00','8','0','1190000.00','1','0.04', 'input','2026-03-20 09:31:24','0.600','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1E','D1E-ZCBX-20-T','T0078230');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','D1E-ZCBX-20-T','D1E','TOKO','01-SEM','100.00','0.600','0.600','1','0.600','0.600','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-ZCBX-21-T','T0078231','MEH1 KH 42 ','KL SIEM COBRA KH 42CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','1487500','2026-03-20','1487500','1.250','100.00','8','0','1190000.00','1','0.04', 'input','2026-03-20 09:32:32','1.250','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-ZCBX-21-T','T0078231');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','H1E-ZCBX-21-T','H1E','TOKO','01-SEM','100.00','1.250','1.250','1','1.250','1.250','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-ZCBX-22-T','T0078232','MEH1 KH 42 ','KL SIEM COBRA KH 42CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','1499500','2026-03-20','1499500','1.260','100.00','8','0','1190000.00','1','0.04', 'input','2026-03-20 09:32:42','1.260','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-ZCBX-22-T','T0078232');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','H1E-ZCBX-22-T','H1E','TOKO','01-SEM','100.00','1.260','1.260','1','1.260','1.260','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-ZCBX-23-T','T0078233','MEH1 UB 40 ','KL MILANO UB 40CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','2416000','2026-03-20','2416000','2.030','100.00','8','0','1190000.00','1','0.04', 'input','2026-03-20 09:33:29','2.030','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-ZCBX-23-T','T0078233');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','H1E-ZCBX-23-T','H1E','TOKO','01-SEM','100.00','2.030','2.030','1','2.030','2.030','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-ZCBX-24-T','T0078234','MEH1 UB 40 ','KL MILANO UB 40CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','2523000','2026-03-20','2523000','2.120','100.00','8','0','1190000.00','1','0.04', 'input','2026-03-20 09:33:39','2.120','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-ZCBX-24-T','T0078234');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','H1E-ZCBX-24-T','H1E','TOKO','01-SEM','100.00','2.120','2.120','1','2.120','2.120','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-ZCBX-25-T','T0078235','MEH1 UB 40 ','KL MILANO UB 40CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','4879000','2026-03-20','4879000','4.100','100.00','8','0','1190000.00','1','0.04', 'input','2026-03-20 09:34:01','4.100','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-ZCBX-25-T','T0078235');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-20','H1E-ZCBX-25-T','H1E','TOKO','01-SEM','100.00','4.100','4.100','1','4.100','4.100','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0003','1','A1E-ZCBX-13-T','1','0.500','0.500','TOKO','01-SEM','TOKO','SMBK-A');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-A' WHERE kode_barang='A1E-ZCBX-13-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-20','TOKO','SMBK-A','A1E','A1E-ZCBX-13-T','100.00','1','0.500','0.500','1','0.500','0.500');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.500',berat_out_asli=berat_out_asli+'0.500',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-20' AND kode_barang='A1E-ZCBX-13-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0003','2','A1E-ZCBX-14-T','1','0.510','0.510','TOKO','01-SEM','TOKO','SMBK-A');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-A' WHERE kode_barang='A1E-ZCBX-14-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-20','TOKO','SMBK-A','A1E','A1E-ZCBX-14-T','100.00','1','0.510','0.510','1','0.510','0.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.510',berat_out_asli=berat_out_asli+'0.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-20' AND kode_barang='A1E-ZCBX-14-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0003','3','A1D-ZCBX-15-T','1','0.870','0.870','TOKO','01-SEM','TOKO','SMBK-A');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-A' WHERE kode_barang='A1D-ZCBX-15-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-20','TOKO','SMBK-A','A1D','A1D-ZCBX-15-T','100.00','1','0.870','0.870','1','0.870','0.870');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.870',berat_out_asli=berat_out_asli+'0.870',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-20' AND kode_barang='A1D-ZCBX-15-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0003','4','A1D-ZCBX-16-T','1','1.120','1.120','TOKO','01-SEM','TOKO','SMBK-A');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-A' WHERE kode_barang='A1D-ZCBX-16-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-20','TOKO','SMBK-A','A1D','A1D-ZCBX-16-T','100.00','1','1.120','1.120','1','1.120','1.120');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.120',berat_out_asli=berat_out_asli+'1.120',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-20' AND kode_barang='A1D-ZCBX-16-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260320-0003','2026-03-20','2026-03-20','09:37','3','input','2026-03-20 09:37:23');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0004','1','D1E-ZCBX-17-T','1','0.550','0.550','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-D' WHERE kode_barang='D1E-ZCBX-17-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-20','TOKO','SMBK-D','D1E','D1E-ZCBX-17-T','100.00','1','0.550','0.550','1','0.550','0.550');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.550',berat_out_asli=berat_out_asli+'0.550',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-20' AND kode_barang='D1E-ZCBX-17-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0004','2','D1E-ZCBX-18-T','1','0.510','0.510','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-D' WHERE kode_barang='D1E-ZCBX-18-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-20','TOKO','SMBK-D','D1E','D1E-ZCBX-18-T','100.00','1','0.510','0.510','1','0.510','0.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.510',berat_out_asli=berat_out_asli+'0.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-20' AND kode_barang='D1E-ZCBX-18-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0004','3','D1E-ZCBX-19-T','1','0.580','0.580','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-D' WHERE kode_barang='D1E-ZCBX-19-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-20','TOKO','SMBK-D','D1E','D1E-ZCBX-19-T','100.00','1','0.580','0.580','1','0.580','0.580');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.580',berat_out_asli=berat_out_asli+'0.580',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-20' AND kode_barang='D1E-ZCBX-19-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0004','4','D1E-ZCBX-20-T','1','0.600','0.600','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-D' WHERE kode_barang='D1E-ZCBX-20-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-20','TOKO','SMBK-D','D1E','D1E-ZCBX-20-T','100.00','1','0.600','0.600','1','0.600','0.600');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.600',berat_out_asli=berat_out_asli+'0.600',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-20' AND kode_barang='D1E-ZCBX-20-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260320-0004','2026-03-20','2026-03-20','09:37','2.24','input','2026-03-20 09:38:05');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0005','1','H1E-ZCBX-21-T','1','1.25','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-ZCBX-21-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-20','TOKO','SMBK-H','H1E','H1E-ZCBX-21-T' , '1','1.25','1.25', '1','1.25','1.25','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.25',berat_out_asli=berat_out_asli+'1.25',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-ZCBX-21-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0005','2','H1E-ZCBX-22-T','1','1.26','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-ZCBX-22-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-20','TOKO','SMBK-H','H1E','H1E-ZCBX-22-T' , '1','1.26','1.26', '1','1.26','1.26','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.26',berat_out_asli=berat_out_asli+'1.26',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-ZCBX-22-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0005','3','H1E-ZCBX-23-T','1','2.03','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-ZCBX-23-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-20','TOKO','SMBK-H','H1E','H1E-ZCBX-23-T' , '1','2.03','2.03', '1','2.03','2.03','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.03',berat_out_asli=berat_out_asli+'2.03',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-ZCBX-23-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0005','4','H1E-ZCBX-24-T','1','2.12','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-ZCBX-24-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-20','TOKO','SMBK-H','H1E','H1E-ZCBX-24-T' , '1','2.12','2.12', '1','2.12','2.12','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.12',berat_out_asli=berat_out_asli+'2.12',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-ZCBX-24-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0005','5','H1E-ZCBX-25-T','1','4.1','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-ZCBX-25-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-20','TOKO','SMBK-H','H1E','H1E-ZCBX-25-T' , '1','4.1','4.1', '1','4.1','4.1','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.1',berat_out_asli=berat_out_asli+'4.1',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-ZCBX-25-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-260320-0005','2026-03-20','2026-03-20','09:38','10.76','input','2026-03-20 09:38:33');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226201047081','kasir','1',' TDD2 X UB ','TOKO','TBK-D','D2TD-YLAA-20-T','LT X COR MODEL MATA UB 17K ','','0.850','1','100.00','1819000','0','0','15000','1788000','0','0','0','1788000','TIN','T0075678','D2TD','0','0','-','1','2140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2TD-YLAA-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-03-20' AND kode_barang='D2TD-YLAA-20-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226201047081','2026-03-20','0.850','2026-03-20','10:47:09','PLG0078357','1788000','1788000','0','1788000','1788000','kasir','2026-03-20 10:47:08','F22620104708');
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-03-20','F226201047081','2026-03-20','10:47:09','TIN','1788000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260320-0005','D','2026-03-20','10:47:09','kasir','PENJUALAN','F226201047081','7430834000','1788000','7432622000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201047081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201047081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201047081';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226201057171','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-YLCX-36-T','LT SLOBOK BALOK HURUF BG N 8K ','OLS V78K','0.650','1','100.00','786000','0','0','15000','800000','0','115000','0','915000','TIN','T0076277','D1F','0','0','-','0','1210000');
UPDATE tm_barang SET tgl_last_jual='2026-03-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YLCX-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-03-20' AND kode_barang='D1F-YLCX-36-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226201057171','2026-03-20','0.650','2026-03-20','10:57:17','PLG0078358','800000','800000','115000','915000','915000','kasir','2026-03-20 10:57:17','F22620105717');
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-03-20','F226201057171','2026-03-20','10:57:17','TIN','915000','115000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260320-0006','D','2026-03-20','10:57:17','kasir','PENJUALAN','F226201057171','7432622000','915000','7433537000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226201058341','kasir','1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZABA-30-T','AS EXTENSION LG 8K ','OLS DQQ2','0.200','1','100.00','246000','0','0','15000','255000','0','47000','0','302000','TIN','T0076803','S1G','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-03-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZABA-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-03-20' AND kode_barang='S1G-ZABA-30-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226201058341','2026-03-20','0.200','2026-03-20','10:58:35','PLG0078359','255000','255000','47000','302000','302000','kasir','2026-03-20 10:58:34','F22620105834');
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-03-20','F226201058341','2026-03-20','10:58:35','TIN','302000','47000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260320-0007','D','2026-03-20','10:58:35','kasir','PENJUALAN','F226201058341','7433537000','302000','7433839000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='302000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201058341' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226201058342','kasir',' 1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZABA-13-T','AS EXTENSION LG 8K ','OLS DQQ2','0.200','1','100.00','246000','0','0','15000','255000','0','47000','0','302000','TIN','T0076786','S1G','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-03-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZABA-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-03-20' AND kode_barang='S1G-ZABA-13-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226201058342','2026-03-20','0.200','2026-03-20','10:58:35','PLG0078360','255000','255000','47000','302000','302000','kasir','2026-03-20 10:58:34','F22620105834');
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-03-20','F226201058342','2026-03-20','10:58:35','TIN','302000','47000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260320-0008','D','2026-03-20','10:58:35','kasir','PENJUALAN','F226201058342','7433839000','302000','7434141000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='302000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201058342' LIMIT 1;
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260320-0001','1','A1D-ZABC-4-0','1','1.000','1.000','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZABC-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZABC-4-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-03-20 11:24:19' WHERE kode_barang='A1D-ZABC-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZABC-4-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-20 11:24:19','TOKO','SMBK-A','A1D','A1D-ZABC-4-0','1','1.000','1.000','1','1.000','1.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-ZABC-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZABC-4-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260320-0001','1','A1E-ZCAX-313-0','1','0.480','0.480','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZCAX-313-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZCAX-313-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-03-20 11:24:19' WHERE kode_barang='A1E-ZCAX-313-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZCAX-313-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-20 11:24:19','TOKO','SMBK-A','A1E','A1E-ZCAX-313-0','1','0.480','0.480','1','0.480','0.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZCAX-313-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZCAX-313-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260320-0001','2026-03-20','11:24','1.480','input','2026-03-20 11:24:18');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260320-0001','1','D1E-ZCBX-106-0','1','0.510','0.510','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-ZCBX-106-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZCBX-106-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-03-20 11:24:39' WHERE kode_barang='D1E-ZCBX-106-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZCBX-106-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-20 11:24:39','TOKO','SMBK-D','D1E','D1E-ZCBX-106-0','1','0.510','0.510','1','0.510','0.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1E-ZCBX-106-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZCBX-106-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260320-0001','1','D1E-ZCBX-107-0','1','0.480','0.480','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-ZCBX-107-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZCBX-107-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-03-20 11:24:39' WHERE kode_barang='D1E-ZCBX-107-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZCBX-107-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-20 11:24:39','TOKO','SMBK-D','D1E','D1E-ZCBX-107-0','1','0.480','0.480','1','0.480','0.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1E-ZCBX-107-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZCBX-107-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260320-0001','1','D1E-ZCBX-108-0','1','0.500','0.500','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-ZCBX-108-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZCBX-108-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-03-20 11:24:39' WHERE kode_barang='D1E-ZCBX-108-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZCBX-108-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-20 11:24:39','TOKO','SMBK-D','D1E','D1E-ZCBX-108-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1E-ZCBX-108-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZCBX-108-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260320-0001','2026-03-20','11:24','1.490','input','2026-03-20 11:24:38');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0006','1','F1E-ZCAB-16-T','1','2.020','2.020','TOKO','SMBK-F','TOKO','BK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-F' WHERE kode_barang='F1E-ZCAB-16-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-20','TOKO','BK-F','F1E','F1E-ZCAB-16-T','100.00','1','2.020','2.020','1','2.020','2.020');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.020',berat_out_asli=berat_out_asli+'2.020',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-20' AND kode_barang='F1E-ZCAB-16-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0006','2','F1E-ZCAB-13-T','1','1.910','1.910','TOKO','SMBK-F','TOKO','BK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-F' WHERE kode_barang='F1E-ZCAB-13-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-20','TOKO','BK-F','F1E','F1E-ZCAB-13-T','100.00','1','1.910','1.910','1','1.910','1.910');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.910',berat_out_asli=berat_out_asli+'1.910',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-20' AND kode_barang='F1E-ZCAB-13-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260320-0006','3','F1E-ZCAB-14-T','1','2.050','2.050','TOKO','SMBK-F','TOKO','BK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-F' WHERE kode_barang='F1E-ZCAB-14-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-20','TOKO','BK-F','F1E','F1E-ZCAB-14-T','100.00','1','2.050','2.050','1','2.050','2.050');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.050',berat_out_asli=berat_out_asli+'2.050',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-20' AND kode_barang='F1E-ZCAB-14-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260320-0006','2026-03-20','2026-03-20','11:27','5.98','admin','2026-03-20 11:27:53');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226201158391','kasir','1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZBAH-42-T','LT MODEL DAUN VAR LG 8K ','','0.300','1','100.00','369000','0','0','15000','370000','0','0','0','370000','RTA','T0077487','D1G','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-03-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZBAH-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2026-03-20' AND kode_barang='D1G-ZBAH-42-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226201158391','2026-03-20','0.300','2026-03-20','11:58:39','PLG0078361','370000','370000','0','370000','370000','kasir','2026-03-20 11:58:39','F22620115839');
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-03-20','F226201158391','2026-03-20','11:58:39','RTA','370000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260320-0009','D','2026-03-20','11:58:39','kasir','PENJUALAN','F226201158391','7434141000','370000','7434511000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226201207381','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZCAX-50-T','GL MODEL CAPELA VAR HW 8K ','','1.370','1','100.00','1630000','0','0','15000','1630000','0','0','0','1630000','NS','T0077991','F3E','0','0','-','0','1190000');
UPDATE tm_barang SET tgl_last_jual='2026-03-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCAX-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.370',berat_jual_asli=berat_jual_asli+'1.370',stock_jual='1',berat_akhir=berat_akhir-'1.370',berat_akhir_asli=berat_akhir_asli-'1.370',stock_akhir='0' WHERE tanggal='2026-03-20' AND kode_barang='F3E-ZCAX-50-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226201207381','2026-03-20','1.370','2026-03-20','12:07:39','PLG0078362','1630000','1630000','0','1630000','1630000','kasir','2026-03-20 12:07:38','F22620120738');
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-03-20','F226201207381','2026-03-20','12:07:39','NS','1630000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260320-0010','D','2026-03-20','12:07:39','kasir','PENJUALAN','F226201207381','7434511000','1630000','7436141000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226200123491','kasir','1',' MEF3 KH ','TOKO','SMBK-F','F3E-YKAE-24-T','GL RANTAI HOLLOW DOUBLE KH 8K ','','2.520','1','100.00','2999000','0','0','15000','3000000','0','0','0','3000000','RTA','T0074982','F3E','0','0','-','0','1190000');
UPDATE tm_barang SET tgl_last_jual='2026-03-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKAE-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.520',berat_jual_asli=berat_jual_asli+'2.520',stock_jual='1',berat_akhir=berat_akhir-'2.520',berat_akhir_asli=berat_akhir_asli-'2.520',stock_akhir='0' WHERE tanggal='2026-03-20' AND kode_barang='F3E-YKAE-24-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200123491','2026-03-20','2.520','2026-03-20','13:23:49','PLG0078363','3000000','3000000','0','3000000','3000000','kasir','2026-03-20 13:23:49','F22620012349');
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-03-20','F226200123491','2026-03-20','13:23:49','RTA','3000000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260320-0011','D','2026-03-20','13:23:49','kasir','PENJUALAN','F226200123491','7436141000','3000000','7439141000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226200144541','kasir','1',' TDE2 X YT ','TOKO','TBK-E','E2TD-YLAA-41-T','CC X COR MODEL SPECTRA 10 YT 17K ','','1.400','1','100.00','2996000','0','0','15000','2996000','0','7000','0','3003000','TIN','T0075699','E2TD','0','0','-','0','2140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YLAA-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.400',berat_jual_asli=berat_jual_asli+'1.400',stock_jual='1',berat_akhir=berat_akhir-'1.400',berat_akhir_asli=berat_akhir_asli-'1.400',stock_akhir='0' WHERE tanggal='2026-03-20' AND kode_barang='E2TD-YLAA-41-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200144541','2026-03-20','1.400','2026-03-20','13:44:55','PLG0078364','2996000','2996000','7000','3003000','3003000','kasir','2026-03-20 13:44:54','F22620014454');
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-03-20','F226200144541','2026-03-20','13:44:55','TIN','3003000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260320-0012','D','2026-03-20','13:44:55','kasir','PENJUALAN','F226200144541','7439141000','3003000','7442144000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005211','X-00005211','KL SANTA KH 42CM 8K','GR','---','H1E','BELI','BELI001','1465000','2026-03-20','1.930','1','kasir','2026-03-20 13:53:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00005211','X-00005211');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260320-0001','F225261117012','RHM','1','BELI','BELI001','H1E', 'X-00005211', 'KL SANTA KH 42CM 8K','2.050','1.930','100.00','1565000','1465000','759067','1190000','1','1465000','1465000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.930',berat_beli_asli=berat_beli_asli+'1.930',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.930',berat_akhir_asli=berat_akhir_asli+'1.930',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260320-0001','2026-03-20','2026-03-20','13:53:31','RHM','---','1.930','1465000','1465000','1465000','1465000','1465000','kasir','2026-03-20 13:53:31','FB-260320-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260320-0001','MURYANI','KARANGPATIHAN BALONG','','','083802196467','kasir','2026-03-20 13:53:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-20' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260320-0013','K','2026-03-20','13:53:31','kasir','PEMBELIAN UMUM','FB-260320-0001','7442144000','1465000','7440679000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005212','X-00005212','CC BANGKOK PASIR SLEP BW 16 8K','GR','---','E1E','BELI','BELI001','455000','2026-03-20','0.600','1','kasir','2026-03-20 13:53:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00005212','X-00005212');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260320-0002','F225261117011','RHM','2','BELI','BELI001','E1E', 'X-00005212', 'CC BANGKOK PASIR SLEP BW 16 8K','0.610','0.600','100.00','465000','455000','758333','1190000','1','455000','455000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.600',berat_beli_asli=berat_beli_asli+'0.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.600',berat_akhir_asli=berat_akhir_asli+'0.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260320-0002','2026-03-20','2026-03-20','13:53:31','RHM','---','0.600','455000','455000','455000','455000','455000','kasir','2026-03-20 13:53:31','FB-260320-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260320-0002','MURYANI','KARANGPATIHAN BALONG','','','083802196467','kasir','2026-03-20 13:53:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-20' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260320-0014','K','2026-03-20','13:53:31','kasir','PEMBELIAN UMUM','FB-260320-0002','7440679000','455000','7440224000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226200238361','kasir','1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZCAA-72-T','LT SLOBOK BUNGA ARESO VAR LG 8K ','','0.280','1','100.00','344000','0','0','15000','347000','0','5000','0','352000','RTA','T0078071','D1G','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-03-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZCAA-72-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.280',berat_jual_asli=berat_jual_asli+'0.280',stock_jual='1',berat_akhir=berat_akhir-'0.280',berat_akhir_asli=berat_akhir_asli-'0.280',stock_akhir='0' WHERE tanggal='2026-03-20' AND kode_barang='D1G-ZCAA-72-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200238361','2026-03-20','0.280','2026-03-20','14:38:36','PLG0078365','347000','347000','5000','352000','352000','kasir','2026-03-20 14:38:36','F22620023836');
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-03-20','F226200238361','2026-03-20','14:38:36','RTA','352000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260320-0015','D','2026-03-20','14:38:36','kasir','PENJUALAN','F226200238361','7440224000','352000','7440576000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='352000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226200238361' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226200238362','kasir',' 1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZCAA-71-T','LT SLOBOK BUNGA ARESO VAR LG 8K ','OL','0.280','1','100.00','344000','0','0','15000','347000','0','5000','0','352000','RTA','T0078070','D1G','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-03-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZCAA-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.280',berat_jual_asli=berat_jual_asli+'0.280',stock_jual='1',berat_akhir=berat_akhir-'0.280',berat_akhir_asli=berat_akhir_asli-'0.280',stock_akhir='0' WHERE tanggal='2026-03-20' AND kode_barang='D1G-ZCAA-71-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200238362','2026-03-20','0.280','2026-03-20','14:38:36','PLG0078366','347000','347000','5000','352000','352000','kasir','2026-03-20 14:38:36','F22620023836');
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-03-20','F226200238362','2026-03-20','14:38:36','RTA','352000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260320-0016','D','2026-03-20','14:38:36','kasir','PENJUALAN','F226200238362','7440576000','352000','7440928000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='352000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226200238362' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005213','X-00005213','CC X COR MODEL SPECTRA 10 YT 17K','GR','---','E2TD','BELI','BELI001','2846000','2026-03-20','1.400','1','kasir','2026-03-20 15:30:42');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TD';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TD','X-00005213','X-00005213');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260320-0003','F226200144541','TIN','1','BELI','BELI001','E2TD', 'X-00005213', 'CC X COR MODEL SPECTRA 10 YT 17K','1.400','1.400','100.00','2996000','2846000','2032857','2140000','1','2846000','2846000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.400',berat_beli_asli=berat_beli_asli+'1.400',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.400',berat_akhir_asli=berat_akhir_asli+'1.400',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TD' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260320-0003','2026-03-20','2026-03-20','15:30:41','TIN','---','1.400','2846000','2846000','2846000','2846000','2846000','kasir','2026-03-20 15:30:42','FB-260320-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260320-0003','ENDANG','SAWOO','','','081357502241','kasir','2026-03-20 15:30:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-20' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260320-0017','K','2026-03-20','15:30:41','kasir','PEMBELIAN UMUM','FB-260320-0003','7440928000','2846000','7438082000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226200333041','kasir','1',' MEF3 5K LT','TOKO','SMBK-F','F3E-ZAAI-59-T','GL RANTAI HOLLOW P3 SLEP LT 8K ','','1.050','1','100.00','1249000','0','0','15000','1250000','0','5000','0','1255000','RHM','T0076724','F3E','0','0','-','0','1190000');
UPDATE tm_barang SET tgl_last_jual='2026-03-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZAAI-59-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-03-20' AND kode_barang='F3E-ZAAI-59-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200333041','2026-03-20','1.050','2026-03-20','15:33:04','PLG0078367','1250000','1250000','5000','1255000','1255000','kasir','2026-03-20 15:33:04','F22620033304');
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-03-20','F226200333041','2026-03-20','15:33:04','RHM','1255000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260320-0018','D','2026-03-20','15:33:04','kasir','PENJUALAN','F226200333041','7438082000','1255000','7439337000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226200354141','kasir','1',' TDE1 X MJ ','TOKO','TBK-E','E1TD-YIXD-63-T','CC X MODEL C MJ 16 17K ','','2.020','1','100.00','4323000','0','0','15000','4323000','0','0','0','4323000','TIN','T0072915','E1TD','0','0','-','0','2140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YIXD-63-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-03-20' AND kode_barang='E1TD-YIXD-63-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200354141','2026-03-20','2.020','2026-03-20','15:54:15','PLG0078368','4323000','4323000','0','4323000','4323000','kasir','2026-03-20 15:54:14','F22620035414');
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-03-20','F226200354141','2026-03-20','15:54:15','TIN','4323000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260320-0019','D','2026-03-20','15:54:15','kasir','PENJUALAN','F226200354141','7439337000','4323000','7443660000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200123491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200123491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200123491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200144541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200144541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200144541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200238361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200238361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200238361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200238362' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200238362' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200238362';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200333041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200333041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200333041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200354141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200354141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200354141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200911411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200911411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200911411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200914391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200914391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200914391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200916231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200916231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200916231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201057171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201057171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201057171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201058341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201058341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201058341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201058342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201058342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201058342';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201158391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201158391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201158391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201207381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201207381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201207381';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260320-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260320-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260320-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260320-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260320-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260320-0003';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226200435161','kasir','1',' MEA1 CM ','TOKO','SMBK-A','A1E-ZAAG-8-T','AT MODEL BOLA ARESO CM 8K ','','0.480','1','100.00','571000','0','0','15000','572000','0','0','0','572000','NS','T0076602','A1E','0','0','-','0','1190000');
UPDATE tm_barang SET tgl_last_jual='2026-03-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZAAG-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-03-20' AND kode_barang='A1E-ZAAG-8-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200435161','2026-03-20','0.480','2026-03-20','16:35:16','PLG0078369','572000','572000','0','572000','572000','kasir','2026-03-20 16:35:16','F22620043516');
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-03-20','F226200435161','2026-03-20','16:35:16','NS','572000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260320-0020','D','2026-03-20','16:35:16','kasir','PENJUALAN','F226200435161','7443660000','572000','7444232000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='572000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226200435161' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226200435162','kasir',' 1',' MEE2 X YT ','TOKO','SMBK-E','E2E-YJBC-46-0','CC X MODEL MATA YT 20 8K ','','0.660','1','100.00','785000','0','0','15000','785000','0','5000','0','790000','NS','00374364','E2E','0','0','-','0','1190000');
UPDATE tm_barang SET tgl_last_jual='2026-03-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJBC-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2026-03-20' AND kode_barang='E2E-YJBC-46-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200435162','2026-03-20','0.660','2026-03-20','16:35:16','PLG0078370','785000','785000','5000','790000','790000','kasir','2026-03-20 16:35:16','F22620043516');
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-03-20','F226200435162','2026-03-20','16:35:16','NS','790000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260320-0021','D','2026-03-20','16:35:16','kasir','PENJUALAN','F226200435162','7444232000','790000','7445022000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='790000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226200435162' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226200446301','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZCXE-45-T','CC WEDDING MATA CM 14 8K ','','1.520','1','100.00','1778000','0','0','15000','1778000','0','10000','0','1788000','RTA','T0077721','E2D','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-03-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCXE-45-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2026-03-20' AND kode_barang='E2D-ZCXE-45-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200446301','2026-03-20','1.520','2026-03-20','16:46:30','PLG0078371','1778000','1778000','10000','1788000','1788000','kasir','2026-03-20 16:46:30','F22620044630');
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-03-20','F226200446301','2026-03-20','16:46:30','RTA','1788000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260320-0022','D','2026-03-20','16:46:30','kasir','PENJUALAN','F226200446301','7445022000','1788000','7446810000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226200447191','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-ZCAB-10-T','GL OVAL MODEL C TD D58 8K ','','5.040','1','100.00','5998000','0','0','15000','5998000','0','0','0','5998000','RTA','T0078081','F1E','0','0','-','0','1190000');
UPDATE tm_barang SET tgl_last_jual='2026-03-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCAB-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.040',berat_jual_asli=berat_jual_asli+'5.040',stock_jual='1',berat_akhir=berat_akhir-'5.040',berat_akhir_asli=berat_akhir_asli-'5.040',stock_akhir='0' WHERE tanggal='2026-03-20' AND kode_barang='F1E-ZCAB-10-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200447191','2026-03-20','5.040','2026-03-20','16:47:19','PLG0078372','5998000','5998000','0','5998000','5998000','kasir','2026-03-20 16:47:19','F22620044719');
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-03-20','F226200447191','2026-03-20','16:47:19','RTA','5998000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260320-0023','D','2026-03-20','16:47:19','kasir','PENJUALAN','F226200447191','7446810000','5998000','7452808000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226200448201','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-ZAXG-3-T','GL OVAL MODEL C TD D58 8K ','','3.280','1','100.00','3903000','0','0','15000','3903000','0','0','0','3903000','RTA','T0076294','F1E','0','0','-','0','1190000');
UPDATE tm_barang SET tgl_last_jual='2026-03-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZAXG-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.280',berat_jual_asli=berat_jual_asli+'3.280',stock_jual='1',berat_akhir=berat_akhir-'3.280',berat_akhir_asli=berat_akhir_asli-'3.280',stock_akhir='0' WHERE tanggal='2026-03-20' AND kode_barang='F1E-ZAXG-3-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200448201','2026-03-20','3.280','2026-03-20','16:48:20','PLG0078373','3903000','3903000','0','3903000','3903000','kasir','2026-03-20 16:48:20','F22620044820');
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-03-20','F226200448201','2026-03-20','16:48:20','RTA','3903000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260320-0024','D','2026-03-20','16:48:20','kasir','PENJUALAN','F226200448201','7452808000','3903000','7456711000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200435161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200435161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200435161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200435162' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200435162' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200435162';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200446301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200446301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200446301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200447191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200447191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200447191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200448201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200448201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200448201';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-21','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-18';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-20';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-20';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-03-20' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-20';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-20';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-20';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-20';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-21' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-20' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260321-0001','D','2026-03-21','17:03:59','SYSTEM','SALDO AWAL','SALDO AWAL','0','7456711000','7456711000');
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-260321-0001','D','2026-03-21','17:03:59','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260321-0001','D','2026-03-21','17:03:59','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260321-0001','D','2026-03-21','17:03:59','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260321-0001','D','2026-03-21','17:03:59','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
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-260321-0001','D','2026-03-21','17:03:59','BCA','SALDO AWAL','SALDO AWAL','0','4317221888','4317221888');
UPDATE tp_system SET tgl_system='2026-03-21';