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-20260507-0001','1','E2E-ZBAX-152-0','1','0.530','0.530','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZBAX-152-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZBAX-152-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-05-07 08:10:47' WHERE kode_barang='E2E-ZBAX-152-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZBAX-152-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-05-07 08:10:47','TOKO','SMBK-E','E2E','E2E-ZBAX-152-0','1','0.530','0.530','1','0.530','0.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' 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='E2E-ZBAX-152-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZBAX-152-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260507-0001','2026-05-07','08:10','0.530','input','2026-05-07 08:10:47');
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 ('F3E-ZEXG-1-T','T0079266','MEF3 PM ','GL MODEL DAUN SLEP PM 8K ','','GR','---','ME','F3E','TOKO','01-SEM','3413000','2026-05-07','3413000','3.020','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:26:45','3.020','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZEXG-1-T','T0079266');
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-05-07','F3E-ZEXG-1-T','F3E','TOKO','01-SEM','100.00','3.020','3.020','1','3.020','3.020','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-ZEXG-2-T','T0079267','MEF1 TD D56 ','GL OVAL MODEL C TD D56 8K ','','GR','---','ME','F1E','TOKO','01-SEM','5989000','2026-05-07','5989000','5.300','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:28:13','5.300','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-ZEXG-2-T','T0079267');
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-05-07','F1E-ZEXG-2-T','F1E','TOKO','01-SEM','100.00','5.300','5.300','1','5.300','5.300','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-ZEXG-3-T','T0079268','MEF1 TD D54 ','GL OVAL MODEL C GELOMBANG TD D54 8K ','','GR','---','ME','F1E','TOKO','01-SEM','3141500','2026-05-07','3141500','2.780','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:28:40','2.780','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-ZEXG-3-T','T0079268');
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-05-07','F1E-ZEXG-3-T','F1E','TOKO','01-SEM','100.00','2.780','2.780','1','2.780','2.780','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-ZEXG-4-T','T0079269','MEF1 TD D56 ','GL BANGKOK MODEL C TD D56 8K ','','GR','---','ME','F1E','TOKO','01-SEM','3243500','2026-05-07','3243500','2.870','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:29:15','2.870','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-ZEXG-4-T','T0079269');
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-05-07','F1E-ZEXG-4-T','F1E','TOKO','01-SEM','100.00','2.870','2.870','1','2.870','2.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 ('F3E-ZEXG-5-T','T0079270','MEF3 UB ','GL RANTAI HOLLOW PLAT UB 8K ','','GR','---','ME','F3E','TOKO','01-SEM','994500','2026-05-07','994500','0.880','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:30:09','0.880','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZEXG-5-T','T0079270');
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-05-07','F3E-ZEXG-5-T','F3E','TOKO','01-SEM','100.00','0.880','0.880','1','0.880','0.880','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 ('F3E-ZEXG-6-T','T0079271','MEF3 UB ','GL RANTAI HOLLOW PLAT UB 8K ','','GR','---','ME','F3E','TOKO','01-SEM','994500','2026-05-07','994500','0.880','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:30:22','0.880','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZEXG-6-T','T0079271');
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-05-07','F3E-ZEXG-6-T','F3E','TOKO','01-SEM','100.00','0.880','0.880','1','0.880','0.880','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-ZEXG-7-T','T0079272','MED1 5K BW ','LT MODEL PEANUT PASIR VAR BW 8K ','','GR','---','ME','D1E','TOKO','01-SEM','452000','2026-05-07','452000','0.400','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:32:18','0.400','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-ZEXG-7-T','T0079272');
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-05-07','D1E-ZEXG-7-T','D1E','TOKO','01-SEM','100.00','0.400','0.400','1','0.400','0.400','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-ZEXG-8-T','T0079273','MED1 5K BW ','LT MODEL PEANUT PASIR VAR BW 8K ','','GR','---','ME','D1E','TOKO','01-SEM','384500','2026-05-07','384500','0.340','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:32:40','0.340','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-ZEXG-8-T','T0079273');
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-05-07','D1E-ZEXG-8-T','D1E','TOKO','01-SEM','100.00','0.340','0.340','1','0.340','0.340','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-ZEXG-9-T','T0079274','MED1 5K BW ','LT MODEL PEANUT PASIR VAR BW 8K ','','GR','---','ME','D1E','TOKO','01-SEM','463500','2026-05-07','463500','0.410','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:32:54','0.410','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-ZEXG-9-T','T0079274');
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-05-07','D1E-ZEXG-9-T','D1E','TOKO','01-SEM','100.00','0.410','0.410','1','0.410','0.410','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-ZEXG-10-T','T0079275','MED1 5K BW ','LT MODEL PEANUT PASIR VAR BW 8K ','','GR','---','ME','D1E','TOKO','01-SEM','497500','2026-05-07','497500','0.440','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:33:00','0.440','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-ZEXG-10-T','T0079275');
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-05-07','D1E-ZEXG-10-T','D1E','TOKO','01-SEM','100.00','0.440','0.440','1','0.440','0.440','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-260507-0001','1','F3E-ZEXG-1-T','1','3.020','3.020','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='F3E-ZEXG-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-05-07','TOKO','SMBK-F','F3E','F3E-ZEXG-1-T','100.00','1','3.020','3.020','1','3.020','3.020');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.020',berat_out_asli=berat_out_asli+'3.020',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-07' AND kode_barang='F3E-ZEXG-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-260507-0001','2','F1E-ZEXG-2-T','1','5.300','5.300','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-ZEXG-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-05-07','TOKO','SMBK-F','F1E','F1E-ZEXG-2-T','100.00','1','5.300','5.300','1','5.300','5.300');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.300',berat_out_asli=berat_out_asli+'5.300',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-07' AND kode_barang='F1E-ZEXG-2-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-260507-0001','3','F1E-ZEXG-3-T','1','2.780','2.780','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-ZEXG-3-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-05-07','TOKO','SMBK-F','F1E','F1E-ZEXG-3-T','100.00','1','2.780','2.780','1','2.780','2.780');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.780',berat_out_asli=berat_out_asli+'2.780',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-07' AND kode_barang='F1E-ZEXG-3-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-260507-0001','2026-05-07','2026-05-07','08:33','11.1','input','2026-05-07 08:33:51');
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-260507-0002','1','F1E-ZEXG-4-T','1','2.870','2.870','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-ZEXG-4-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-05-07','TOKO','SMBK-F','F1E','F1E-ZEXG-4-T','100.00','1','2.870','2.870','1','2.870','2.870');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.870',berat_out_asli=berat_out_asli+'2.870',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-07' AND kode_barang='F1E-ZEXG-4-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-260507-0002','2','F3E-ZEXG-5-T','1','0.880','0.880','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='F3E-ZEXG-5-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-05-07','TOKO','SMBK-F','F3E','F3E-ZEXG-5-T','100.00','1','0.880','0.880','1','0.880','0.880');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.880',berat_out_asli=berat_out_asli+'0.880',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-07' AND kode_barang='F3E-ZEXG-5-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-260507-0002','3','F3E-ZEXG-6-T','1','0.880','0.880','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='F3E-ZEXG-6-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-05-07','TOKO','SMBK-F','F3E','F3E-ZEXG-6-T','100.00','1','0.880','0.880','1','0.880','0.880');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.880',berat_out_asli=berat_out_asli+'0.880',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-07' AND kode_barang='F3E-ZEXG-6-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-260507-0002','2026-05-07','2026-05-07','08:33','4.63','input','2026-05-07 08:35:37');
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-260507-0003','1','D1E-ZEXG-7-T','1','0.400','0.400','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-ZEXG-7-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-05-07','TOKO','SMBK-D','D1E','D1E-ZEXG-7-T','100.00','1','0.400','0.400','1','0.400','0.400');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.400',berat_out_asli=berat_out_asli+'0.400',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-07' AND kode_barang='D1E-ZEXG-7-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-260507-0003','2','D1E-ZEXG-8-T','1','0.340','0.340','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-ZEXG-8-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-05-07','TOKO','SMBK-D','D1E','D1E-ZEXG-8-T','100.00','1','0.340','0.340','1','0.340','0.340');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.340',berat_out_asli=berat_out_asli+'0.340',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-07' AND kode_barang='D1E-ZEXG-8-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-260507-0003','3','D1E-ZEXG-9-T','1','0.410','0.410','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-ZEXG-9-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-05-07','TOKO','SMBK-D','D1E','D1E-ZEXG-9-T','100.00','1','0.410','0.410','1','0.410','0.410');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.410',berat_out_asli=berat_out_asli+'0.410',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-07' AND kode_barang='D1E-ZEXG-9-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-260507-0003','4','D1E-ZEXG-10-T','1','0.440','0.440','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-ZEXG-10-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-05-07','TOKO','SMBK-D','D1E','D1E-ZEXG-10-T','100.00','1','0.440','0.440','1','0.440','0.440');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.440',berat_out_asli=berat_out_asli+'0.440',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-07' AND kode_barang='D1E-ZEXG-10-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-260507-0003','2026-05-07','2026-05-07','08:35','1.59','input','2026-05-07 08:36:10');
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-ZEXG-11-T','T0079276','MEE1 HTM 16 ','CC PIPA MODEL DAUN HTM 16 8K ','','GR','---','ME','E1E','TOKO','01-SEM','520000','2026-05-07','520000','0.460','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:38:13','0.460','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-ZEXG-11-T','T0079276');
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-05-07','E1E-ZEXG-11-T','E1E','TOKO','01-SEM','100.00','0.460','0.460','1','0.460','0.460','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-ZEXG-12-T','T0079277','MDE2 10K CM 16 ','CC WEDDING MATA CM 16 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1660500','2026-05-07','1660500','1.530','100.00','8','0','1085000.00','1','0.04', 'input','2026-05-07 08:38:49','1.530','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-ZEXG-12-T','T0079277');
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-05-07','E2D-ZEXG-12-T','E2D','TOKO','01-SEM','100.00','1.530','1.530','1','1.530','1.530','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-ZEXG-13-T','T0079278','MDE2 10K CM 20 ','CC WEDDING MATA CM 20 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1649500','2026-05-07','1649500','1.520','100.00','8','0','1085000.00','1','0.04', 'input','2026-05-07 08:39:16','1.520','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-ZEXG-13-T','T0079278');
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-05-07','E2D-ZEXG-13-T','E2D','TOKO','01-SEM','100.00','1.520','1.520','1','1.520','1.520','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-260507-0004','1','E1E-ZEXG-11-T','1','0.46','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-ZEXG-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-05-07','TOKO','SMBK-E','E1E','E1E-ZEXG-11-T' , '1','0.46','0.46', '1','0.46','0.46','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.46',berat_out_asli=berat_out_asli+'0.46',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1E-ZEXG-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-260507-0004','2','E2D-ZEXG-12-T','1','1.53','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-ZEXG-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-05-07','TOKO','SMBK-E','E2D','E2D-ZEXG-12-T' , '1','1.53','1.53', '1','1.53','1.53','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.53',berat_out_asli=berat_out_asli+'1.53',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-ZEXG-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-260507-0004','3','E2D-ZEXG-13-T','1','1.52','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-ZEXG-13-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-05-07','TOKO','SMBK-E','E2D','E2D-ZEXG-13-T' , '1','1.52','1.52', '1','1.52','1.52','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.52',berat_out_asli=berat_out_asli+'1.52',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-ZEXG-13-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-260507-0004','2026-05-07','2026-05-07','08:39','3.51','input','2026-05-07 08:39:35');
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 ('D1D-ZEXG-14-T','T0079279','MDD1 5K LG ','LT MODEL FINE GOLD PLAT LG 8K ','','GR','---','MD','D1D','TOKO','01-SEM','1096000','2026-05-07','1096000','1.010','100.00','8','0','1085000.00','1','0.04', 'input','2026-05-07 08:41:35','1.010','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1D','D1D-ZEXG-14-T','T0079279');
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-05-07','D1D-ZEXG-14-T','D1D','TOKO','01-SEM','100.00','1.010','1.010','1','1.010','1.010','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 ('D1D-ZEXG-15-T','T0079280','MDD1 5K LG ','LT MODEL FINE GOLD PLAT LG 8K ','','GR','---','MD','D1D','TOKO','01-SEM','1096000','2026-05-07','1096000','1.010','100.00','8','0','1085000.00','1','0.04', 'input','2026-05-07 08:41:45','1.010','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1D','D1D-ZEXG-15-T','T0079280');
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-05-07','D1D-ZEXG-15-T','D1D','TOKO','01-SEM','100.00','1.010','1.010','1','1.010','1.010','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-ZEXG-16-T','T0079281','MED1 CM ','LT MODEL BUNGA TULIP CM 8K ','','GR','---','ME','D1E','TOKO','01-SEM','701000','2026-05-07','701000','0.620','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:42:23','0.620','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-ZEXG-16-T','T0079281');
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-05-07','D1E-ZEXG-16-T','D1E','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 ('D1E-ZEXG-17-T','T0079282','MED1 LG ','LT MODEL HATI POLOS LG 8K ','','GR','---','ME','D1E','TOKO','01-SEM','565000','2026-05-07','565000','0.500','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:42:52','0.500','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-ZEXG-17-T','T0079282');
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-05-07','D1E-ZEXG-17-T','D1E','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 ('D1E-ZEXG-18-T','T0079283','MED1 LG ','LT MODEL HATI POLOS LG 8K ','','GR','---','ME','D1E','TOKO','01-SEM','588000','2026-05-07','588000','0.520','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:42:58','0.520','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-ZEXG-18-T','T0079283');
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-05-07','D1E-ZEXG-18-T','D1E','TOKO','01-SEM','100.00','0.520','0.520','1','0.520','0.520','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 ('D1G-ZEXG-19-T','T0079284','MGD1 5K AY ','LT SLOBOK MODEL BINTANG ARESO AY 8K ','','GR','---','MG','D1G','TOKO','01-SEM','229000','2026-05-07','229000','0.200','100.00','8','0','1145000.00','1','0.04', 'input','2026-05-07 08:43:57','0.200','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1G' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1G','D1G-ZEXG-19-T','T0079284');
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-05-07','D1G-ZEXG-19-T','D1G','TOKO','01-SEM','100.00','0.200','0.200','1','0.200','0.200','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 ('D1G-ZEXG-20-T','T0079285','MGD1 5K AY ','LT SLOBOK MODEL BINTANG ARESO AY 8K ','','GR','---','MG','D1G','TOKO','01-SEM','252000','2026-05-07','252000','0.220','100.00','8','0','1145000.00','1','0.04', 'input','2026-05-07 08:44:04','0.220','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1G' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1G','D1G-ZEXG-20-T','T0079285');
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-05-07','D1G-ZEXG-20-T','D1G','TOKO','01-SEM','100.00','0.220','0.220','1','0.220','0.220','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 ('D1F-ZEXG-21-T','T0079286','MFD15K AY ','LT SLOBOK HATI PASIR AY 8K ','','GR','---','MF','D1F','TOKO','01-SEM','427500','2026-05-07','427500','0.380','100.00','8','0','1125000.00','1','0.04', 'input','2026-05-07 08:45:38','0.380','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1F' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1F','D1F-ZEXG-21-T','T0079286');
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-05-07','D1F-ZEXG-21-T','D1F','TOKO','01-SEM','100.00','0.380','0.380','1','0.380','0.380','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 ('D1F-ZEXG-22-T','T0079287','MFD15K AY ','LT SLOBOK HATI PASIR AY 8K ','','GR','---','MF','D1F','TOKO','01-SEM','394000','2026-05-07','394000','0.350','100.00','8','0','1125000.00','1','0.04', 'input','2026-05-07 08:45:45','0.350','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1F' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1F','D1F-ZEXG-22-T','T0079287');
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-05-07','D1F-ZEXG-22-T','D1F','TOKO','01-SEM','100.00','0.350','0.350','1','0.350','0.350','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 ('D1F-ZEXG-23-T','T0079288','MFD1 5K BG ','LT SLOBOK KUPU PASIR VAR BG 8K ','','GR','---','MF','D1F','TOKO','01-SEM','472500','2026-05-07','472500','0.420','100.00','8','0','1125000.00','1','0.04', 'input','2026-05-07 08:46:10','0.420','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1F' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1F','D1F-ZEXG-23-T','T0079288');
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-05-07','D1F-ZEXG-23-T','D1F','TOKO','01-SEM','100.00','0.420','0.420','1','0.420','0.420','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 ('D1F-ZEXG-24-T','T0079289','MFD1 LG ','LT MODEL DAUN SLEP VAR LG 8K ','','GR','---','MF','D1F','TOKO','01-SEM','394000','2026-05-07','394000','0.350','100.00','8','0','1125000.00','1','0.04', 'input','2026-05-07 08:46:34','0.350','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1F' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1F','D1F-ZEXG-24-T','T0079289');
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-05-07','D1F-ZEXG-24-T','D1F','TOKO','01-SEM','100.00','0.350','0.350','1','0.350','0.350','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 ('D1F-ZEXG-25-T','T0079290','MFD1 LG ','LT MODEL DAUN SLEP VAR LG 8K ','','GR','---','MF','D1F','TOKO','01-SEM','394000','2026-05-07','394000','0.350','100.00','8','0','1125000.00','1','0.04', 'input','2026-05-07 08:46:41','0.350','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1F' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1F','D1F-ZEXG-25-T','T0079290');
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-05-07','D1F-ZEXG-25-T','D1F','TOKO','01-SEM','100.00','0.350','0.350','1','0.350','0.350','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-260507-0005','1','D1D-ZEXG-14-T','1','1.01','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1D-ZEXG-14-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-05-07','TOKO','SMBK-D','D1D','D1D-ZEXG-14-T' , '1','1.01','1.01', '1','1.01','1.01','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.01',berat_out_asli=berat_out_asli+'1.01',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1D-ZEXG-14-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-260507-0005','2','D1D-ZEXG-15-T','1','1.01','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1D-ZEXG-15-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-05-07','TOKO','SMBK-D','D1D','D1D-ZEXG-15-T' , '1','1.01','1.01', '1','1.01','1.01','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.01',berat_out_asli=berat_out_asli+'1.01',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1D-ZEXG-15-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-260507-0005','3','D1E-ZEXG-16-T','1','0.62','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1E-ZEXG-16-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-05-07','TOKO','SMBK-D','D1E','D1E-ZEXG-16-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='D1E-ZEXG-16-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-260507-0005','4','D1E-ZEXG-17-T','1','0.5','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1E-ZEXG-17-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-05-07','TOKO','SMBK-D','D1E','D1E-ZEXG-17-T' , '1','0.5','0.5', '1','0.5','0.5','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.5',berat_out_asli=berat_out_asli+'0.5',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1E-ZEXG-17-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-260507-0005','5','D1E-ZEXG-18-T','1','0.52','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1E-ZEXG-18-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-05-07','TOKO','SMBK-D','D1E','D1E-ZEXG-18-T' , '1','0.52','0.52', '1','0.52','0.52','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.52',berat_out_asli=berat_out_asli+'0.52',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1E-ZEXG-18-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-260507-0005','6','D1F-ZEXG-21-T','1','0.38','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1F-ZEXG-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-05-07','TOKO','SMBK-D','D1F','D1F-ZEXG-21-T' , '1','0.38','0.38', '1','0.38','0.38','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.38',berat_out_asli=berat_out_asli+'0.38',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1F-ZEXG-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-260507-0005','7','D1F-ZEXG-22-T','1','0.35','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1F-ZEXG-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-05-07','TOKO','SMBK-D','D1F','D1F-ZEXG-22-T' , '1','0.35','0.35', '1','0.35','0.35','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.35',berat_out_asli=berat_out_asli+'0.35',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1F-ZEXG-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-260507-0005','8','D1F-ZEXG-23-T','1','0.42','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1F-ZEXG-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-05-07','TOKO','SMBK-D','D1F','D1F-ZEXG-23-T' , '1','0.42','0.42', '1','0.42','0.42','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.42',berat_out_asli=berat_out_asli+'0.42',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1F-ZEXG-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-260507-0005','9','D1F-ZEXG-24-T','1','0.35','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1F-ZEXG-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-05-07','TOKO','SMBK-D','D1F','D1F-ZEXG-24-T' , '1','0.35','0.35', '1','0.35','0.35','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.35',berat_out_asli=berat_out_asli+'0.35',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1F-ZEXG-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-260507-0005','10','D1F-ZEXG-25-T','1','0.35','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1F-ZEXG-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-05-07','TOKO','SMBK-D','D1F','D1F-ZEXG-25-T' , '1','0.35','0.35', '1','0.35','0.35','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.35',berat_out_asli=berat_out_asli+'0.35',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1F-ZEXG-25-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-260507-0005','11','D1G-ZEXG-19-T','1','0.2','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1G-ZEXG-19-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-05-07','TOKO','SMBK-D','D1G','D1G-ZEXG-19-T' , '1','0.2','0.2', '1','0.2','0.2','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.2',berat_out_asli=berat_out_asli+'0.2',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1G-ZEXG-19-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-260507-0005','12','D1G-ZEXG-20-T','1','0.22','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1G-ZEXG-20-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-05-07','TOKO','SMBK-D','D1G','D1G-ZEXG-20-T' , '1','0.22','0.22', '1','0.22','0.22','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.22',berat_out_asli=berat_out_asli+'0.22',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1G-ZEXG-20-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-260507-0005','2026-05-07','2026-05-07','08:46','5.93','input','2026-05-07 08:46:56');
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 ('F3E-ZEXG-26-T','T0079291','MEF3 UB ','GL KOREA UB 8K ','','GR','---','ME','F3E','TOKO','01-SEM','960500','2026-05-07','960500','0.850','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:51:38','0.850','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZEXG-26-T','T0079291');
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-05-07','F3E-ZEXG-26-T','F3E','TOKO','01-SEM','100.00','0.850','0.850','1','0.850','0.850','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 ('F3E-ZEXG-27-T','T0079292','MEF3 UB ','GL KOREA UB 8K ','','GR','---','ME','F3E','TOKO','01-SEM','972000','2026-05-07','972000','0.860','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:51:47','0.860','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZEXG-27-T','T0079292');
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-05-07','F3E-ZEXG-27-T','F3E','TOKO','01-SEM','100.00','0.860','0.860','1','0.860','0.860','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 ('F3E-ZEXG-28-T','T0079293','MEF3 UB ','GL KOREA UB 8K ','','GR','---','ME','F3E','TOKO','01-SEM','983500','2026-05-07','983500','0.870','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:51:56','0.870','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZEXG-28-T','T0079293');
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-05-07','F3E-ZEXG-28-T','F3E','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 ('F3E-ZEXG-29-T','T0079294','MEF3 UB ','GL KOREA UB 8K ','','GR','---','ME','F3E','TOKO','01-SEM','972000','2026-05-07','972000','0.860','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:52:07','0.860','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZEXG-29-T','T0079294');
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-05-07','F3E-ZEXG-29-T','F3E','TOKO','01-SEM','100.00','0.860','0.860','1','0.860','0.860','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 ('F3E-ZEXG-30-T','T0079295','MEF3 UB ','GL MODEL FLIK PIPIH UB 8K ','','GR','---','ME','F3E','TOKO','01-SEM','1107500','2026-05-07','1107500','0.980','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:53:09','0.980','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZEXG-30-T','T0079295');
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-05-07','F3E-ZEXG-30-T','F3E','TOKO','01-SEM','100.00','0.980','0.980','1','0.980','0.980','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 ('F3E-ZEXG-31-T','T0079296','MEF3 UB ','GL MODEL FLIK PIPIH UB 8K ','','GR','---','ME','F3E','TOKO','01-SEM','1299500','2026-05-07','1299500','1.150','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:53:20','1.150','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZEXG-31-T','T0079296');
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-05-07','F3E-ZEXG-31-T','F3E','TOKO','01-SEM','100.00','1.150','1.150','1','1.150','1.150','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 ('F3E-ZEXG-32-T','T0079297','MEF3 HW ','GL MODEL FANCY SLEP VAR HW 8K ','','GR','---','ME','F3E','TOKO','01-SEM','1638500','2026-05-07','1638500','1.450','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:54:02','1.450','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZEXG-32-T','T0079297');
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-05-07','F3E-ZEXG-32-T','F3E','TOKO','01-SEM','100.00','1.450','1.450','1','1.450','1.450','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 ('F3E-ZEXG-33-T','T0079298','MEF3 HW ','GL MODEL CAPELA VAR HW 8K ','','GR','---','ME','F3E','TOKO','01-SEM','1379000','2026-05-07','1379000','1.220','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:54:25','1.220','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZEXG-33-T','T0079298');
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-05-07','F3E-ZEXG-33-T','F3E','TOKO','01-SEM','100.00','1.220','1.220','1','1.220','1.220','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 ('F3E-ZEXG-34-T','T0079299','MEF3 KH ','GL KAKI MODEL FANCY VAR KH 8K ','','GR','---','ME','F3E','TOKO','01-SEM','2316500','2026-05-07','2316500','2.050','100.00','8','0','1130000.00','1','0.04', 'input','2026-05-07 08:55:07','2.050','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZEXG-34-T','T0079299');
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-05-07','F3E-ZEXG-34-T','F3E','TOKO','01-SEM','100.00','2.050','2.050','1','2.050','2.050','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-260507-0006','1','F3E-ZEXG-26-T','1','0.85','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-ZEXG-26-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-05-07','TOKO','SMBK-F','F3E','F3E-ZEXG-26-T' , '1','0.85','0.85', '1','0.85','0.85','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.85',berat_out_asli=berat_out_asli+'0.85',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-ZEXG-26-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-260507-0006','2','F3E-ZEXG-27-T','1','0.86','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-ZEXG-27-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-05-07','TOKO','SMBK-F','F3E','F3E-ZEXG-27-T' , '1','0.86','0.86', '1','0.86','0.86','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.86',berat_out_asli=berat_out_asli+'0.86',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-ZEXG-27-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-260507-0006','3','F3E-ZEXG-28-T','1','0.87','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-ZEXG-28-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-05-07','TOKO','SMBK-F','F3E','F3E-ZEXG-28-T' , '1','0.87','0.87', '1','0.87','0.87','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.87',berat_out_asli=berat_out_asli+'0.87',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-ZEXG-28-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-260507-0006','4','F3E-ZEXG-29-T','1','0.86','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-ZEXG-29-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-05-07','TOKO','SMBK-F','F3E','F3E-ZEXG-29-T' , '1','0.86','0.86', '1','0.86','0.86','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.86',berat_out_asli=berat_out_asli+'0.86',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-ZEXG-29-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-260507-0006','5','F3E-ZEXG-30-T','1','0.98','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-ZEXG-30-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-05-07','TOKO','SMBK-F','F3E','F3E-ZEXG-30-T' , '1','0.98','0.98', '1','0.98','0.98','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.98',berat_out_asli=berat_out_asli+'0.98',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-ZEXG-30-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-260507-0006','6','F3E-ZEXG-31-T','1','1.15','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-ZEXG-31-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-05-07','TOKO','SMBK-F','F3E','F3E-ZEXG-31-T' , '1','1.15','1.15', '1','1.15','1.15','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.15',berat_out_asli=berat_out_asli+'1.15',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-ZEXG-31-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-260507-0006','7','F3E-ZEXG-32-T','1','1.45','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-ZEXG-32-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-05-07','TOKO','SMBK-F','F3E','F3E-ZEXG-32-T' , '1','1.45','1.45', '1','1.45','1.45','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.45',berat_out_asli=berat_out_asli+'1.45',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-ZEXG-32-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-260507-0006','8','F3E-ZEXG-33-T','1','1.22','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-ZEXG-33-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-05-07','TOKO','SMBK-F','F3E','F3E-ZEXG-33-T' , '1','1.22','1.22', '1','1.22','1.22','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.22',berat_out_asli=berat_out_asli+'1.22',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-ZEXG-33-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-260507-0006','9','F3E-ZEXG-34-T','1','2.05','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-ZEXG-34-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-05-07','TOKO','SMBK-F','F3E','F3E-ZEXG-34-T' , '1','2.05','2.05', '1','2.05','2.05','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.05',berat_out_asli=berat_out_asli+'2.05',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-ZEXG-34-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-260507-0006','2026-05-07','2026-05-07','08:55','10.29','input','2026-05-07 08:55:36');
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 ('F226070902381','kasir','1',' MFD1F X BG','TOKO','SMBK-D','D1F-ZEXB-48-0','LT X SLOBOK BALOK HURUF BG H 8K ','OL','0.400','1','100.00','450000','0','0','15000','466000','0','5000','0','471000','TIN','00402064','D1F','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZEXB-48-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='D1F-ZEXB-48-0' 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 ('F226070902381','2026-05-07','0.400','2026-05-07','09:02:38','PLG0079762','466000','466000','5000','471000','471000','kasir','2026-05-07 09:02:38','F22607090238');
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-05-07','F226070902381','2026-05-07','09:02:38','TIN','471000','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-260507-0002','D','2026-05-07','09:02:38','kasir','PENJUALAN','F226070902381','9307801000','471000','9308272000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='471000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070902381' 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 ('F226070902382','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZCCA-49-T','LT SLOBOK BALOK HURUF BG N 8K ','OL','0.620','1','100.00','697000','0','0','15000','722000','0','5000','0','727000','TIN','T0078345','D1F','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZCCA-49-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.620',berat_jual_asli=berat_jual_asli+'0.620',stock_jual='1',berat_akhir=berat_akhir-'0.620',berat_akhir_asli=berat_akhir_asli-'0.620',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='D1F-ZCCA-49-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 ('F226070902382','2026-05-07','0.620','2026-05-07','09:02:38','PLG0079763','722000','722000','5000','727000','727000','kasir','2026-05-07 09:02:38','F22607090238');
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-05-07','F226070902382','2026-05-07','09:02:38','TIN','727000','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-260507-0003','D','2026-05-07','09:02:38','kasir','PENJUALAN','F226070902382','9308272000','727000','9308999000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='727000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070902382' 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 ('F226070917221','kasir','1',' MEH1 KH 42','TOKO','SMBK-H','H1E-ZAAG-27-T','KL SANTA KH 42CM 8K ','OL','3.020','1','100.00','3337000','0','0','15000','3428000','0','15000','0','3443000','TIN','T0076621','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZAAG-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.020',berat_jual_asli=berat_jual_asli+'3.020',stock_jual='1',berat_akhir=berat_akhir-'3.020',berat_akhir_asli=berat_akhir_asli-'3.020',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='H1E-ZAAG-27-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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 ('F226070917221','2026-05-07','3.020','2026-05-07','09:17:22','PLG0079764','3428000','3428000','15000','3443000','0','kasir','2026-05-07 09:17:22','F22607091722');
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-05-07','F226070917221','2026-05-07','09:17:22','TIN','3443000','15000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260507-0001','2026-05-07','2026-05-07 09:17:22','PENJUALAN : F226070917221','354754666858','BCA','3443000','3443000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260507-0002','D','2026-05-07','09:17:22','BCA','PENJUALAN','F226070917221','4402329888','3443000','4405772888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('354754666858','EMI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3443000' WHERE no_faktur_jual='F226070917221' 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 ('F226070944161','kasir','1',' MEF3 YT ','TOKO','SMBK-F','F3E-YGBB-102-T','GL MODEL CAPELA HATI ARESO VAR YT 8K ','OL','2.750','1','100.00','3039000','0','0','15000','3121000','0','14000','0','3135000','RTA','T0071374','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YGBB-102-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.750',berat_jual_asli=berat_jual_asli+'2.750',stock_jual='1',berat_akhir=berat_akhir-'2.750',berat_akhir_asli=berat_akhir_asli-'2.750',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='F3E-YGBB-102-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 ('F226070944161','2026-05-07','2.750','2026-05-07','09:44:17','PLG0079765','3121000','3121000','14000','3135000','3135000','kasir','2026-05-07 09:44:16','F22607094416');
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-05-07','F226070944161','2026-05-07','09:44:17','RTA','3135000','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-260507-0004','D','2026-05-07','09:44:17','kasir','PENJUALAN','F226070944161','9308999000','3135000','9312134000');
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 ('F226070951131','kasir','1',' MEF3E X KH','TOKO','SMBK-F','F3E-ZEXB-73-0','GL X KOREA SLEP KH 8K ','','1.230','1','100.00','1359000','0','0','15000','1390000','0','0','0','1390000','RHM','00402089','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXB-73-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.230',berat_jual_asli=berat_jual_asli+'1.230',stock_jual='1',berat_akhir=berat_akhir-'1.230',berat_akhir_asli=berat_akhir_asli-'1.230',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='F3E-ZEXB-73-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 ('F226070951131','2026-05-07','1.230','2026-05-07','09:51:13','PLG0079766','1390000','1390000','0','1390000','1390000','kasir','2026-05-07 09:51:13','F22607095113');
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-05-07','F226070951131','2026-05-07','09:51:13','RHM','1390000','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-260507-0005','D','2026-05-07','09:51:13','kasir','PENJUALAN','F226070951131','9312134000','1390000','9313524000');
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-260507-0007','1','D1F-YGBA-19-0','1','0.500','0.500','TOKO','SMBK-D','TOKO','BK-D');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-D' WHERE kode_barang='D1F-YGBA-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-D';
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-05-07','TOKO','BK-D','D1F','D1F-YGBA-19-0','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-05-07' AND kode_barang='D1F-YGBA-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-D' 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-260507-0007','2026-05-07','2026-05-07','10:04','0.5','admin','2026-05-07 10:04:24');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226071020481','kasir','1',' MEF1 UB D5','TOKO','SMBK-F','F1E-ZDXI-1-T','GL OVAL MODEL C UB D52 8K ','','2.260','1','100.00','2497000','0','0','15000','2555000','0','0','0','2555000','RTA','T0078593','F1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZDXI-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.260',berat_jual_asli=berat_jual_asli+'2.260',stock_jual='1',berat_akhir=berat_akhir-'2.260',berat_akhir_asli=berat_akhir_asli-'2.260',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='F1E-ZDXI-1-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 ('F226071020481','2026-05-07','2.260','2026-05-07','10:20:48','PLG0079767','2555000','2555000','0','2555000','2555000','kasir','2026-05-07 10:20:48','F22607102048');
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-05-07','F226071020481','2026-05-07','10:20:48','RTA','2555000','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-260507-0006','D','2026-05-07','10:20:48','kasir','PENJUALAN','F226071020481','9313524000','2555000','9316079000');
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 ('F226071058031','kasir','1',' MEH1 UB ','TOKO','SMBK-H','H1E-ZEXA-1-T','KL TRIXIE MODEL MATA VAR UB 8K ','OL','2.100','1','100.00','2320000','0','0','15000','2383000','0','11000','0','2394000','RTA','T0079113','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEXA-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='H1E-ZEXA-1-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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 ('F226071058031','2026-05-07','2.100','2026-05-07','10:58:03','PLG0079768','2383000','2383000','11000','2394000','2394000','kasir','2026-05-07 10:58:03','F22607105803');
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-05-07','F226071058031','2026-05-07','10:58:03','RTA','2394000','11000');
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-260507-0007','D','2026-05-07','10:58:03','kasir','PENJUALAN','F226071058031','9316079000','2394000','9318473000');
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 ('F226071109161','kasir','1',' MEH1 10K U','TOKO','SMBK-H','H1E-ZEXF-1-T','KL TRIXIE BOLA PASIR ARESO VAR UB 8K ','OL','1.460','1','100.00','1613000','0','0','15000','1662000','0','10000','0','1672000','RTA','T0079162','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEXF-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.460',berat_jual_asli=berat_jual_asli+'1.460',stock_jual='1',berat_akhir=berat_akhir-'1.460',berat_akhir_asli=berat_akhir_asli-'1.460',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='H1E-ZEXF-1-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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 ('F226071109161','2026-05-07','1.460','2026-05-07','11:09:16','PLG0079769','1662000','1662000','10000','1672000','1672000','kasir','2026-05-07 11:09:16','F22607110916');
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-05-07','F226071109161','2026-05-07','11:09:16','RTA','1672000','10000');
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-260507-0008','D','2026-05-07','11:09:16','kasir','PENJUALAN','F226071109161','9318473000','1672000','9320145000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1672000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226071109161' 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 ('F226071109162','kasir',' 1',' MEH1 HW ','TOKO','SMBK-H','H1E-ZEXF-2-T','KL RANTAI HOLLOW MODEL CD VAR HW 8K ','OL','1.980','1','100.00','2188000','0','0','15000','2257000','0','10000','0','2267000','RTA','T0079163','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEXF-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='H1E-ZEXF-2-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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 ('F226071109162','2026-05-07','1.980','2026-05-07','11:09:16','PLG0079770','2257000','2257000','10000','2267000','2267000','kasir','2026-05-07 11:09:16','F22607110916');
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-05-07','F226071109162','2026-05-07','11:09:16','RTA','2267000','10000');
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-260507-0009','D','2026-05-07','11:09:16','kasir','PENJUALAN','F226071109162','9320145000','2267000','9322412000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2267000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226071109162' 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 ('F226071121461','kasir','1',' MED2 LG ','TOKO','SMBK-D','D2E-YFAD-22-T','LT MODEL MATA VAR LG 8K ','OLS NKUX','0.560','1','100.00','619000','0','0','15000','641000','0','78000','0','719000','TIN','T0070097','D2E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YFAD-22-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='D2E-YFAD-22-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 ('F226071121461','2026-05-07','0.560','2026-05-07','11:21:47','PLG0079771','641000','641000','78000','719000','719000','kasir','2026-05-07 11:21:46','F22607112146');
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-05-07','F226071121461','2026-05-07','11:21:47','TIN','719000','78000');
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-260507-0010','D','2026-05-07','11:21:47','kasir','PENJUALAN','F226071121461','9322412000','719000','9323131000');
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 ('F226071127531','kasir','1',' MED1 5K BW','TOKO','SMBK-D','D1E-ZEXG-7-T','LT MODEL PEANUT PASIR VAR BW 8K ','OL','0.400','1','100.00','452000','0','0','15000','458000','0','5000','0','463000','NS','T0079272','D1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZEXG-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='D1E-ZEXG-7-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 ('F226071127531','2026-05-07','0.400','2026-05-07','11:27:53','PLG0079772','458000','458000','5000','463000','463000','kasir','2026-05-07 11:27:53','F22607112753');
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-05-07','F226071127531','2026-05-07','11:27:53','NS','463000','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-260507-0011','D','2026-05-07','11:27:53','kasir','PENJUALAN','F226071127531','9323131000','463000','9323594000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='463000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226071127531' 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 ('F226071127532','kasir',' 1',' MED1 5K BW','TOKO','SMBK-D','D1E-ZEXG-8-T','LT MODEL PEANUT PASIR VAR BW 8K ','OL','0.340','1','100.00','384000','0','0','15000','396000','0','5000','0','401000','NS','T0079273','D1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZEXG-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.340',berat_jual_asli=berat_jual_asli+'0.340',stock_jual='1',berat_akhir=berat_akhir-'0.340',berat_akhir_asli=berat_akhir_asli-'0.340',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='D1E-ZEXG-8-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 ('F226071127532','2026-05-07','0.340','2026-05-07','11:27:53','PLG0079773','396000','396000','5000','401000','401000','kasir','2026-05-07 11:27:53','F22607112753');
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-05-07','F226071127532','2026-05-07','11:27:53','NS','401000','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-260507-0012','D','2026-05-07','11:27:53','kasir','PENJUALAN','F226071127532','9323594000','401000','9323995000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='401000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226071127532' 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 ('F226071127533','kasir',' 1',' MED1 5K BW','TOKO','SMBK-D','D1E-ZEXG-10-T','LT MODEL PEANUT PASIR VAR BW 8K ','OL','0.440','1','100.00','497000','0','0','15000','504000','0','5000','0','509000','NS','T0079275','D1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZEXG-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.440',berat_jual_asli=berat_jual_asli+'0.440',stock_jual='1',berat_akhir=berat_akhir-'0.440',berat_akhir_asli=berat_akhir_asli-'0.440',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='D1E-ZEXG-10-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 ('F226071127533','2026-05-07','0.440','2026-05-07','11:27:53','PLG0079774','504000','504000','5000','509000','509000','kasir','2026-05-07 11:27:53','F22607112753');
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-05-07','F226071127533','2026-05-07','11:27:53','NS','509000','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-260507-0013','D','2026-05-07','11:27:53','kasir','PENJUALAN','F226071127533','9323995000','509000','9324504000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='509000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226071127533' 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 ('F226071127534','kasir',' 1',' MED1 5K BW','TOKO','SMBK-D','D1E-ZEXG-9-T','LT MODEL PEANUT PASIR VAR BW 8K ','OL','0.410','1','100.00','463000','0','0','15000','470000','0','5000','0','475000','NS','T0079274','D1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZEXG-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='D1E-ZEXG-9-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 ('F226071127534','2026-05-07','0.410','2026-05-07','11:27:53','PLG0079775','470000','470000','5000','475000','475000','kasir','2026-05-07 11:27:53','F22607112753');
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-05-07','F226071127534','2026-05-07','11:27:53','NS','475000','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-260507-0014','D','2026-05-07','11:27:53','kasir','PENJUALAN','F226071127534','9324504000','475000','9324979000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='475000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226071127534' 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 ('F226071130141','kasir','1',' MEH1 UB 44','TOKO','SMBK-H','H1E-ZEXF-93-T','KL KOREA UB 44CM 8K ','OL TW','1.480','1','100.00','1635000','0','0','15000','1680000','0','15000','0','1695000','NS','T0079254','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEXF-93-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.480',berat_jual_asli=berat_jual_asli+'1.480',stock_jual='1',berat_akhir=berat_akhir-'1.480',berat_akhir_asli=berat_akhir_asli-'1.480',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='H1E-ZEXF-93-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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 ('F226071130141','2026-05-07','1.480','2026-05-07','11:30:15','PLG0079776','1680000','1680000','15000','1695000','1695000','kasir','2026-05-07 11:30:14','F22607113014');
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-05-07','F226071130141','2026-05-07','11:30:15','NS','1695000','15000');
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-260507-0015','D','2026-05-07','11:30:15','kasir','PENJUALAN','F226071130141','9324979000','1695000','9326674000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1695000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226071130141' 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 ('F226071130142','kasir',' 1',' MEH1 UB 45','TOKO','SMBK-H','H1E-ZCAB-31-T','KL KOREA UB 45CM 8K ','OL TW','1.380','1','100.00','1525000','0','0','15000','1566000','0','14000','0','1580000','NS','T0078102','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCAB-31-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.380',berat_jual_asli=berat_jual_asli+'1.380',stock_jual='1',berat_akhir=berat_akhir-'1.380',berat_akhir_asli=berat_akhir_asli-'1.380',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='H1E-ZCAB-31-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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 ('F226071130142','2026-05-07','1.380','2026-05-07','11:30:15','PLG0079777','1566000','1566000','14000','1580000','1580000','kasir','2026-05-07 11:30:14','F22607113014');
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-05-07','F226071130142','2026-05-07','11:30:15','NS','1580000','14000');
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-260507-0016','D','2026-05-07','11:30:15','kasir','PENJUALAN','F226071130142','9326674000','1580000','9328254000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1580000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226071130142' 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 ('F226071223591','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZDBG-297-0','CC X MODEL MATA CM 14 8K ','','2.330','1','100.00','2528000','0','0','15000','2540000','0','10000','0','2550000','TIN','00401540','E2D','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDBG-297-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.330',berat_jual_asli=berat_jual_asli+'2.330',stock_jual='1',berat_akhir=berat_akhir-'2.330',berat_akhir_asli=berat_akhir_asli-'2.330',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='E2D-ZDBG-297-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 ('F226071223591','2026-05-07','2.330','2026-05-07','12:24:00','PLG0079778','2540000','2540000','10000','2550000','2550000','kasir','2026-05-07 12:23:59','F22607122359');
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-05-07','F226071223591','2026-05-07','12:24:00','TIN','2550000','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-260507-0017','D','2026-05-07','12:24:00','kasir','PENJUALAN','F226071223591','9328254000','2550000','9330804000');
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 ('F226071226591','kasir','1',' MDA1D X LG','TOKO','SMBK-A','A1D-YLXF-171-0','AT X MODEL KLIP MATA LG 8K ','','1.030','1','100.00','1118000','0','0','15000','1164000','0','0','0','1164000','RTA','00379987','A1D','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YLXF-171-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='A1D-YLXF-171-0' 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 ('F226071226591','2026-05-07','1.030','2026-05-07','12:26:59','PLG0079779','1164000','1164000','0','1164000','1164000','kasir','2026-05-07 12:26:59','F22607122659');
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-05-07','F226071226591','2026-05-07','12:26:59','RTA','1164000','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-260507-0018','D','2026-05-07','12:26:59','kasir','PENJUALAN','F226071226591','9330804000','1164000','9331968000');
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 ('F226071259051','kasir','1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZEXF-77-T','CC MODEL PITA PASIR VAR CM 12 8K ','OL','0.800','1','100.00','884000','0','0','15000','912000','0','5000','0','917000','NS','T0079238','E1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXF-77-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='E1E-ZEXF-77-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 ('F226071259051','2026-05-07','0.800','2026-05-07','12:59:06','PLG0079780','912000','912000','5000','917000','917000','kasir','2026-05-07 12:59:05','F22607125905');
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-05-07','F226071259051','2026-05-07','12:59:06','NS','917000','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-260507-0019','D','2026-05-07','12:59:06','kasir','PENJUALAN','F226071259051','9331968000','917000','9332885000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='917000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226071259051' 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 ('F226071259052','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZEXF-71-T','CC MODEL PITA PASIR VAR CM 12 8K ','OL','0.800','1','100.00','884000','0','0','15000','912000','0','5000','0','917000','NS','T0079232','E1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXF-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='E1E-ZEXF-71-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 ('F226071259052','2026-05-07','0.800','2026-05-07','12:59:06','PLG0079781','912000','912000','5000','917000','917000','kasir','2026-05-07 12:59:05','F22607125905');
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-05-07','F226071259052','2026-05-07','12:59:06','NS','917000','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-260507-0020','D','2026-05-07','12:59:06','kasir','PENJUALAN','F226071259052','9332885000','917000','9333802000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='917000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226071259052' 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 ('F226071259053','kasir',' 1',' MEE1 LG 14','TOKO','SMBK-E','E1E-ZEXF-54-T','CC MODEL LINEA LG 14 8K ','OL','0.480','1','100.00','530000','0','0','15000','547000','0','5000','0','552000','NS','T0079215','E1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXF-54-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-05-07' AND kode_barang='E1E-ZEXF-54-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 ('F226071259053','2026-05-07','0.480','2026-05-07','12:59:06','PLG0079782','547000','547000','5000','552000','552000','kasir','2026-05-07 12:59:05','F22607125905');
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-05-07','F226071259053','2026-05-07','12:59:06','NS','552000','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-260507-0021','D','2026-05-07','12:59:06','kasir','PENJUALAN','F226071259053','9333802000','552000','9334354000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='552000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226071259053' 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 ('F226071259054','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZEXF-63-T','CC MODEL PLAT PASIR VAR CM 10 8K ','OL','0.560','1','100.00','619000','0','0','15000','638000','0','5000','0','643000','NS','T0079224','E1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXF-63-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='E1E-ZEXF-63-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 ('F226071259054','2026-05-07','0.560','2026-05-07','12:59:06','PLG0079783','638000','638000','5000','643000','643000','kasir','2026-05-07 12:59:05','F22607125905');
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-05-07','F226071259054','2026-05-07','12:59:06','NS','643000','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-260507-0022','D','2026-05-07','12:59:06','kasir','PENJUALAN','F226071259054','9334354000','643000','9334997000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='643000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226071259054' 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 ('F226070124201','kasir','1',' TEA1 X LG ','TOKO','TBK-A','A1TE-ZDXD-101-T','AT X MODEL HATI MATA VAR LG 17K ','','0.650','1','100.00','1300000','0','0','15000','1326000','0','0','0','1326000','RTA','T0078388','A1TE','0','0','-','0','2000000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TE-ZDXD-101-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-05-07' AND kode_barang='A1TE-ZDXD-101-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226070124201','2026-05-07','0.650','2026-05-07','13:24:21','PLG0079784','1326000','1326000','0','1326000','1326000','kasir','2026-05-07 13:24:20','F22607012420');
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-05-07','F226070124201','2026-05-07','13:24:21','RTA','1326000','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-260507-0023','D','2026-05-07','13:24:21','kasir','PENJUALAN','F226070124201','9334997000','1326000','9336323000');
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 ('F226070125401','kasir','1',' MDE1 CM 14','TOKO','SMBK-E','E1D-ZDXG-27-T','CC POLOS CM 14 8K ','','1.000','1','100.00','1085000','0','0','15000','1110000','0','0','0','1110000','RTA','T0078567','E1D','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDXG-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='E1D-ZDXG-27-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 ('F226070125401','2026-05-07','1.000','2026-05-07','13:25:41','PLG0079785','1110000','1110000','0','1110000','1110000','kasir','2026-05-07 13:25:40','F22607012540');
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-05-07','F226070125401','2026-05-07','13:25:41','RTA','1110000','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-260507-0024','D','2026-05-07','13:25:41','kasir','PENJUALAN','F226070125401','9336323000','1110000','9337433000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1110000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070125401' 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 ('F226070125402','kasir',' 1',' MEF1 TD D4','TOKO','SMBK-F','F1E-ZBAI-87-T','GL ANAK BANGKOK MODEL C TD D42 8K ','','1.950','1','100.00','2155000','0','0','15000','2205000','0','0','0','2205000','RTA','T0077619','F1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZBAI-87-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.950',berat_jual_asli=berat_jual_asli+'1.950',stock_jual='1',berat_akhir=berat_akhir-'1.950',berat_akhir_asli=berat_akhir_asli-'1.950',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='F1E-ZBAI-87-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 ('F226070125402','2026-05-07','1.950','2026-05-07','13:25:41','PLG0079786','2205000','2205000','0','2205000','2205000','kasir','2026-05-07 13:25:40','F22607012540');
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-05-07','F226070125402','2026-05-07','13:25:41','RTA','2205000','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-260507-0025','D','2026-05-07','13:25:41','kasir','PENJUALAN','F226070125402','9337433000','2205000','9339638000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2205000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070125402' 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 ('F226070127421','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZEXF-9-T','GL SANTA SERUT PITA VAR UB 8K ','OL','1.430','1','100.00','1580000','0','0','15000','1623000','0','7000','0','1630000','NS','T0079170','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXF-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.430',berat_jual_asli=berat_jual_asli+'1.430',stock_jual='1',berat_akhir=berat_akhir-'1.430',berat_akhir_asli=berat_akhir_asli-'1.430',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='F3E-ZEXF-9-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 ('F226070127421','2026-05-07','1.430','2026-05-07','13:27:43','PLG0079787','1623000','1623000','7000','1630000','1630000','kasir','2026-05-07 13:27:42','F22607012742');
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-05-07','F226070127421','2026-05-07','13:27:43','NS','1630000','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-260507-0026','D','2026-05-07','13:27:43','kasir','PENJUALAN','F226070127421','9339638000','1630000','9341268000');
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 ('F226070133021','kasir','1',' MEE1 X LG1','TOKO','SMBK-E','E1E-ZEXE-85-0','CC X MODEL DAUN SLEP LG 18 8K ','OL','0.510','1','100.00','564000','0','0','15000','581000','0','5000','0','586000','NS','00402258','E1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXE-85-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='E1E-ZEXE-85-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 ('F226070133021','2026-05-07','0.510','2026-05-07','13:33:03','PLG0079788','581000','581000','5000','586000','586000','kasir','2026-05-07 13:33:02','F22607013302');
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-05-07','F226070133021','2026-05-07','13:33:03','NS','586000','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-260507-0027','D','2026-05-07','13:33:03','kasir','PENJUALAN','F226070133021','9341268000','586000','9341854000');
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 ('F226070236391','kasir','1',' MEH1 X UB ','TOKO','SMBK-H','H1E-ZDBX-174-0','KL X CARENDELANO HURUF UB N 8K ','','2.100','1','100.00','2320000','0','0','15000','2373000','0','10000','0','2383000','RHM','00400111','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDBX-174-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='H1E-ZDBX-174-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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 ('F226070236391','2026-05-07','2.100','2026-05-07','14:36:40','PLG0079789','2373000','2373000','10000','2383000','2383000','kasir','2026-05-07 14:36:39','F22607023639');
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-05-07','F226070236391','2026-05-07','14:36:40','RHM','2383000','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-260507-0028','D','2026-05-07','14:36:40','kasir','PENJUALAN','F226070236391','9341854000','2383000','9344237000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070124201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070124201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070124201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070125401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070125401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070125401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070125402' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070125402' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070125402';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070127421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070127421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070127421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070133021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070133021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070133021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070236391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070236391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070236391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070902381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070902381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070902381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070902382' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070902382' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070902382';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070917221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070917221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070917221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070944161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070944161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070944161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070951131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070951131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070951131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071020481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071020481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071020481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071058031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071058031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071058031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071109161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071109161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071109161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071109162' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071109162' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071109162';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071121461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071121461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071121461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071127531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071127531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071127531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071127532' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071127532' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071127532';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071127533' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071127533' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071127533';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071127534' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071127534' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071127534';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071130141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071130141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071130141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071130142' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071130142' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071130142';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071223591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071223591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071223591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071226591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071226591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071226591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071259051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071259051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071259051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071259052' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071259052' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071259052';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071259053' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071259053' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071259053';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071259054' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071259054' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071259054';
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-00005327','X-00005327','CC MODEL HATI MATA CAT VAR CM 12 8K','GR','---','E2E','BELI','BELI001','502000','2026-05-07','0.880','1','admin','2026-05-07 14:42:20');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00005327','X-00005327');
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-260507-0001','F224311214072','TIN','1','BELI','BELI001','E2E', 'X-00005327', 'CC MODEL HATI MATA CAT VAR CM 12 8K','0.880','0.880','100.00','546000','502000','570455','1130000','1','502000','502000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.880',berat_beli_asli=berat_beli_asli+'0.880',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.880',berat_akhir_asli=berat_akhir_asli+'0.880',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-260507-0001','2026-05-07','2026-05-07','14:42:19','TIN','---','0.880','502000','502000','502000','502000','502000','admin','2026-05-07 14:42:20','FB-260507-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260507-0001','MARSYA','HK','','','','admin','2026-05-07 14:42:20');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-07' 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-260507-0029','K','2026-05-07','14:42:19','admin','PEMBELIAN UMUM','FB-260507-0001','9344237000','502000','9343735000');
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-00005328','X-00005328','KL NORY ANAK KH 34','GR','---','H1E','BELI','BELI001','2294000','2026-05-07','2.980','1','admin','2026-05-07 14:44:39');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00005328','X-00005328');
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-260507-0002','F224021158541','RTA','1','BELI','BELI001','H1E', 'X-00005328', 'KL NORY ANAK KH 34','3.080','2.980','100.00','2003000','2294000','769799','1130000','1','2294000','2294000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.980',berat_beli_asli=berat_beli_asli+'2.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.980',berat_akhir_asli=berat_akhir_asli+'2.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-07' 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-260507-0002','2026-05-07','2026-05-07','14:44:39','RTA','---','2.980','2294000','2294000','2294000','2294000','2294000','admin','2026-05-07 14:44:39','FB-260507-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260507-0002','TIKA','SAWOO','','','082142273400','admin','2026-05-07 14:44:39');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-07' 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-260507-0030','K','2026-05-07','14:44:39','admin','PEMBELIAN UMUM','FB-260507-0002','9343735000','2294000','9341441000');
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-00005329','X-00005329','AT KLIP MODEL BONEKA CAT VAR LG 8K','GR','---','A1E','BELI','BELI001','308000','2026-05-07','0.400','1','admin','2026-05-07 14:44:39');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00005329','X-00005329');
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-260507-0003','F224021158542','RTA','2','BELI','BELI001','A1E', 'X-00005329', 'AT KLIP MODEL BONEKA CAT VAR LG 8K','0.980','0.400','100.00','627000','308000','770000','1130000','1','308000','308000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.400',berat_beli_asli=berat_beli_asli+'0.400',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.400',berat_akhir_asli=berat_akhir_asli+'0.400',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' 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-260507-0003','2026-05-07','2026-05-07','14:44:39','RTA','---','0.400','308000','308000','308000','308000','308000','admin','2026-05-07 14:44:39','FB-260507-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260507-0003','TIKA','SAWOO','','','082142273400','admin','2026-05-07 14:44:39');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-07' 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-260507-0031','K','2026-05-07','14:44:39','admin','PEMBELIAN UMUM','FB-260507-0003','9341441000','308000','9341133000');
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-00005330','X-00005330','CC COR M 8K','GR','---','E2E','BELI','BELI001','845000','2026-05-07','1.000','1','admin','2026-05-07 14:47:11');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00005330','X-00005330');
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-260507-0004','F223301131371','TIN','1','BELI','BELI001','E2E', 'X-00005330', 'CC COR M 8K','1.280','1.000','100.00','635000','845000','845000','1130000','1','845000','845000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-260507-0004','2026-05-07','2026-05-07','14:47:11','TIN','---','1.000','845000','845000','845000','845000','845000','admin','2026-05-07 14:47:11','FB-260507-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260507-0004','NUR','DOLOPO','','','','admin','2026-05-07 14:47:11');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-07' 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-260507-0032','K','2026-05-07','14:47:11','admin','PEMBELIAN UMUM','FB-260507-0004','9341133000','845000','9340288000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260507-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260507-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260507-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260507-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260507-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260507-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260507-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260507-0004';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226070301501','kasir','1',' MEE1 YT 14','TOKO','SMBK-E','E1E-ZDBA-17-T','CC BANGKOK MODEL C YT 14 8K ','OL','0.460','1','100.00','508000','0','0','15000','525000','0','5000','0','530000','TIN','T0078788','E1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBA-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='E1E-ZDBA-17-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 ('F226070301501','2026-05-07','0.460','2026-05-07','15:01:51','PLG0079790','525000','525000','5000','530000','530000','kasir','2026-05-07 15:01:50','F22607030150');
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-05-07','F226070301501','2026-05-07','15:01:51','TIN','530000','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-260507-0033','D','2026-05-07','15:01:51','kasir','PENJUALAN','F226070301501','9340288000','530000','9340818000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='530000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070301501' 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 ('F226070301502','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZDXA-3-T','GL GUCCI UB 8K ','OL','0.580','1','100.00','641000','0','0','15000','661000','0','5000','0','666000','TIN','T0078384','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDXA-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='F3E-ZDXA-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 ('F226070301502','2026-05-07','0.580','2026-05-07','15:01:51','PLG0079791','661000','661000','5000','666000','666000','kasir','2026-05-07 15:01:50','F22607030150');
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-05-07','F226070301502','2026-05-07','15:01:51','TIN','666000','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-260507-0034','D','2026-05-07','15:01:51','kasir','PENJUALAN','F226070301502','9340818000','666000','9341484000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='666000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070301502' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070301501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070301501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070301501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070301502' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070301502' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070301502';
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 ('F226070323301','kasir','1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZBAC-2-T','GL MODEL FLIK HW 8K ','','1.350','1','100.00','1492000','0','0','15000','1526000','0','0','0','1526000','RTA','T0077211','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAC-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.350',berat_jual_asli=berat_jual_asli+'1.350',stock_jual='1',berat_akhir=berat_akhir-'1.350',berat_akhir_asli=berat_akhir_asli-'1.350',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='F3E-ZBAC-2-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 ('F226070323301','2026-05-07','1.350','2026-05-07','15:23:31','PLG0079792','1526000','1526000','0','1526000','1526000','kasir','2026-05-07 15:23:30','F22607032330');
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-05-07','F226070323301','2026-05-07','15:23:31','RTA','1526000','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-260507-0035','D','2026-05-07','15:23:31','kasir','PENJUALAN','F226070323301','9341484000','1526000','9343010000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070323301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070323301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070323301';
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 ('F226070338091','admin','1',' MED1 HW ','TOKO','SMBK-D','D1E-ZDXF-63-T','LT MODEL BUNGA CLOVER SLEP HW 8K ','OL','0.470','1','100.00','519000','0','0','15000','538000','0','5000','0','543000','NS','T0078525','D1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZDXF-63-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='D1E-ZDXF-63-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 ('F226070338091','2026-05-07','0.470','2026-05-07','15:38:09','PLG0079793','538000','538000','5000','543000','543000','admin','2026-05-07 15:38:09','F22607033809');
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-05-07','F226070338091','2026-05-07','15:38:09','NS','543000','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-260507-0036','D','2026-05-07','15:38:09','admin','PENJUALAN','F226070338091','9343010000','543000','9343553000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='543000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070338091' 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 ('F226070338092','admin',' 1',' MED1 LG ','TOKO','SMBK-D','D1E-ZCXE-131-T','LT MODEL PITA VAR LG 8K ','OL','0.500','1','100.00','552000','0','0','15000','573000','0','5000','0','578000','NS','T0077807','D1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZCXE-131-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-05-07' AND kode_barang='D1E-ZCXE-131-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 ('F226070338092','2026-05-07','0.500','2026-05-07','15:38:09','PLG0079794','573000','573000','5000','578000','578000','admin','2026-05-07 15:38:09','F22607033809');
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-05-07','F226070338092','2026-05-07','15:38:09','NS','578000','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-260507-0037','D','2026-05-07','15:38:09','admin','PENJUALAN','F226070338092','9343553000','578000','9344131000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='578000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070338092' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070338091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070338091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070338091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070338092' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070338092' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070338092';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-08','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-07';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-07';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-07';
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-05-07' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-07';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-07';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-07';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-07';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-08' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-07' 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-260508-0001','D','2026-05-08','16:02:41','SYSTEM','SALDO AWAL','SALDO AWAL','0','9344131000','9344131000');
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-260508-0001','D','2026-05-08','16:02:41','BCA','SALDO AWAL','SALDO AWAL','0','4405772888','4405772888');
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-260508-0001','D','2026-05-08','16:02:41','','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-260508-0001','D','2026-05-08','16:02:41','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-260508-0001','D','2026-05-08','16:02:41','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-260508-0001','D','2026-05-08','16:02:41','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2026-05-08';