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-20260728-0001','1','A1E-ZGBX-209-0','1','0.540','0.540','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZGBX-209-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZGBX-209-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-07-28 07:50:29' WHERE kode_barang='A1E-ZGBX-209-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZGBX-209-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-07-28 07:50:29','TOKO','PM-A','A1E','A1E-ZGBX-209-0','1','0.540','0.540','1','0.540','0.540','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZGBX-209-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZGBX-209-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260728-0001','2026-07-28','07:50','0.540','admpindah','2026-07-28 07:50:28');
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-20260728-0001','1','B1E-ZGBB-259-0','1','0.610','0.610','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZGBB-259-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZGBB-259-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-07-28 07:50:48' WHERE kode_barang='B1E-ZGBB-259-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZGBB-259-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-07-28 07:50:48','TOKO','PM-B','B1E','B1E-ZGBB-259-0','1','0.610','0.610','1','0.610','0.610','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' 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='B1E-ZGBB-259-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZGBB-259-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260728-0001','2026-07-28','07:50','0.610','admpindah','2026-07-28 07:50:47');
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-20260728-0001','1','H2I-ZFCX-225-0','1','3.050','3.050','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2I-ZFCX-225-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2I-ZFCX-225-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-07-28 07:51:11' WHERE kode_barang='H2I-ZFCX-225-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2I-ZFCX-225-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-07-28 07:51:11','TOKO','PM-H','H2I','H2I-ZFCX-225-0','1','3.050','3.050','1','3.050','3.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2I' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2I' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MI' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MI' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2I-ZFCX-225-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2I-ZFCX-225-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260728-0001','2026-07-28','07:50','3.050','admpindah','2026-07-28 07:51:10');
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 ('F326281141281','input','1',' TEE2 X YT ','TOKO','PT-E','E2TE-VABE-171-T','CC X MODEL MATA YT 10 ','','0.750','1','100.00','1425000','0','0','15000','1425000','0','0','0','1425000','FIT','T0027928','E2TE','0','0','-','0','1900000');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-VABE-171-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='E2TE-VABE-171-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326281141281','2026-07-28','0.750','2026-07-28','11:41:28','PLG0030543','1425000','1425000','0','1425000','1425000','input','2026-07-28 11:41:28','F32628114128');
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-07-28','F326281141281','2026-07-28','11:41:28','FIT','1425000','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-260728-0002','D','2026-07-28','11:41:28','input','PENJUALAN','F326281141281','6562487000','1425000','6563912000');
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 ('F326281243101','input','1',' MEB1E BM ','TOKO','PM-B','B1E-ZFBE-163-0','GW MODEL PANJANG VAR SLEP BM 8K ','','0.600','1','100.00','621000','0','0','15000','620000','0','0','0','620000','SIN','00410441','B1E','0','0','-','1','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZFBE-163-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='B1E-ZFBE-163-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' 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 ('F326281243101','2026-07-28','0.600','2026-07-28','12:43:11','PLG0030544','620000','620000','0','620000','620000','input','2026-07-28 12:43:10','F32628124310');
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-07-28','F326281243101','2026-07-28','12:43:11','SIN','620000','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-260728-0003','D','2026-07-28','12:43:11','input','PENJUALAN','F326281243101','6563912000','620000','6564532000');
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 ('F326281256451','input','1',' MDE2 X CM ','TOKO','PM-E','E2D-YGXG-235-0','CC X MODEL MATA CM 16 8K ','','0.980','1','100.00','995000','0','0','15000','995000','0','0','0','995000','SIN','00360220','E2D','0','0','-','0','1015000');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YGXG-235-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='E2D-YGXG-235-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326281256451','2026-07-28','0.980','2026-07-28','12:56:45','PLG0030545','995000','995000','0','995000','995000','input','2026-07-28 12:56:45','F32628125645');
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-07-28','F326281256451','2026-07-28','12:56:45','SIN','995000','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-260728-0004','D','2026-07-28','12:56:45','input','PENJUALAN','F326281256451','6564532000','995000','6565527000');
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 ('F326280119571','input','1',' MEH1E KH 4','TOKO','PM-H','H1E-ZGAA-79-0','KL NORI KH 44 8K ','','4.050','1','100.00','4192000','0','0','15000','4192000','0','0','0','4192000','SIN','00413258','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGAA-79-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.050',berat_jual_asli=berat_jual_asli+'4.050',stock_jual='1',berat_akhir=berat_akhir-'4.050',berat_akhir_asli=berat_akhir_asli-'4.050',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='H1E-ZGAA-79-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326280119571','2026-07-28','4.050','2026-07-28','13:19:58','PLG0030546','4192000','4192000','0','4192000','4192000','input','2026-07-28 13:19:57','F32628011957');
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-07-28','F326280119571','2026-07-28','13:19:58','SIN','4192000','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-260728-0005','D','2026-07-28','13:19:58','input','PENJUALAN','F326280119571','6565527000','4192000','6569719000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4192000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326280119571' 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 ('F326280119572','input',' 1',' MED1E X UB','TOKO','PM-D','D1E-ZFCX-31-0','LT X MODEL BOLA PASIR UB 8K ','','0.640','1','100.00','662000','0','0','15000','663000','0','0','0','663000','SIN','00411238','D1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZFCX-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.640',berat_jual_asli=berat_jual_asli+'0.640',stock_jual='1',berat_akhir=berat_akhir-'0.640',berat_akhir_asli=berat_akhir_asli-'0.640',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='D1E-ZFCX-31-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326280119572','2026-07-28','0.640','2026-07-28','13:19:58','PLG0030547','663000','663000','0','663000','663000','input','2026-07-28 13:19:57','F32628011957');
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-07-28','F326280119572','2026-07-28','13:19:58','SIN','663000','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-260728-0006','D','2026-07-28','13:19:58','input','PENJUALAN','F326280119572','6569719000','663000','6570382000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='663000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326280119572' 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 ('F326280121211','input','1',' MFE1 LG 12','TOKO','PM-E','E1F-ZGXA-337-0','CC MODEL ISYANA SLEP LG 12 8K ','','0.400','1','100.00','422000','0','0','15000','423000','0','0','0','423000','SIN','00411861','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGXA-337-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-07-28' AND kode_barang='E1F-ZGXA-337-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326280121211','2026-07-28','0.400','2026-07-28','13:21:21','PLG0030548','423000','423000','0','423000','423000','input','2026-07-28 13:21:21','F32628012121');
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-07-28','F326280121211','2026-07-28','13:21:21','SIN','423000','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-260728-0007','D','2026-07-28','13:21:21','input','PENJUALAN','F326280121211','6570382000','423000','6570805000');
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-00019764','X-00019764','CC VELG POLOS CM 14 8K','GR','---','E1D','BELI','BELI001','1442000','2026-07-28','1.530','1','kasir','2026-07-28 13:58:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019764','X-00019764');
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-260728-0001','F326260835041','SIN','1','BELI','BELI001','E1D', 'X-00019764', 'CC VELG POLOS CM 14 8K','1.530','1.530','100.00','1705000','1442000','942484','1015000','1','1442000','1442000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.530',berat_beli_asli=berat_beli_asli+'1.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.530',berat_akhir_asli=berat_akhir_asli+'1.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' 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-260728-0001','2026-07-28','2026-07-28','13:58:06','SIN','---','1.530','1442000','1442000','1442000','1442000','1442000','kasir','2026-07-28 13:58:06','FB-260728-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260728-0001','PARMI','GENENG BULUKERTO','','','','kasir','2026-07-28 13:58:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-28' 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-260728-0008','K','2026-07-28','13:58:06','kasir','PEMBELIAN UMUM','FB-260728-0001','6570805000','1442000','6569363000');
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 ('F326280158461','kasir','1',' MDE1 X YS ','TOKO','PM-E','E1D-YLXH-139-0','CC X VELG KACA YS 12 8K ','','2.000','1','100.00','2030000','0','0','15000','2030000','0','0','0','2030000','AAT','00380261','E1D','0','0','-','0','1015000');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YLXH-139-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='E1D-YLXH-139-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326280158461','2026-07-28','2.000','2026-07-28','13:58:47','PLG0030549','2030000','2030000','0','2030000','2030000','kasir','2026-07-28 13:58:46','F32628015846');
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-07-28','F326280158461','2026-07-28','13:58:47','AAT','2030000','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-260728-0009','D','2026-07-28','13:58:47','kasir','PENJUALAN','F326280158461','6569363000','2030000','6571393000');
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-00019765','X-00019765','CC BANGKOK POLOS UB 14 8K','GR','---','E1E','BELI','BELI001','510000','2026-07-28','0.530','1','kasir','2026-07-28 14:00:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019765','X-00019765');
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-260728-0002','F326121130333','AAT','1','BELI','BELI001','E1E', 'X-00019765', 'CC BANGKOK POLOS UB 14 8K','0.530','0.530','100.00','600000','510000','962264','1045000','1','510000','510000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260728-0002','2026-07-28','2026-07-28','14:00:06','AAT','---','0.530','510000','510000','510000','510000','510000','kasir','2026-07-28 14:00:06','FB-260728-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260728-0002','ERNA','TEGALREJO PURWANTORO','','','082134087574','kasir','2026-07-28 14:00:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-28' 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-260728-0010','K','2026-07-28','14:00:06','kasir','PEMBELIAN UMUM','FB-260728-0002','6571393000','510000','6570883000');
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-00019766','X-00019766','GL X FANCY SLEP LT 8K','GR','---','F3E','BELI','BELI001','947000','2026-07-28','1.030','1','kasir','2026-07-28 14:25:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019766','X-00019766');
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-260728-0003','F326060238011','SIN','1','BELI','BELI001','F3E', 'X-00019766', 'GL X FANCY SLEP LT 8K','1.050','1.030','100.00','1208000','947000','919417','1045000','1','947000','947000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.030',berat_beli_asli=berat_beli_asli+'1.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.030',berat_akhir_asli=berat_akhir_asli+'1.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' 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-260728-0003','2026-07-28','2026-07-28','14:25:28','SIN','---','1.030','947000','947000','947000','947000','947000','kasir','2026-07-28 14:25:29','FB-260728-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260728-0003','TITIK','PAGER UKIR','','','','kasir','2026-07-28 14:25:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-28' 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-260728-0011','K','2026-07-28','14:25:28','kasir','PEMBELIAN UMUM','FB-260728-0003','6570883000','947000','6569936000');
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 ('F326280255571','kasir','1',' MDE2D BM 2','TOKO','PM-E','E2D-ZFXB-94-0','CC MODEL MATA SLEP BM 20 8K ','','1.670','1','100.00','1695000','0','0','15000','1695000','0','0','0','1695000','LIS','00406486','E2D','0','0','-','0','1015000');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFXB-94-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.670',berat_jual_asli=berat_jual_asli+'1.670',stock_jual='1',berat_akhir=berat_akhir-'1.670',berat_akhir_asli=berat_akhir_asli-'1.670',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='E2D-ZFXB-94-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326280255571','2026-07-28','1.670','2026-07-28','14:55:58','PLG0030550','1695000','1695000','0','1695000','1695000','kasir','2026-07-28 14:55:57','F32628025557');
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-07-28','F326280255571','2026-07-28','14:55:58','LIS','1695000','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-260728-0012','D','2026-07-28','14:55:58','kasir','PENJUALAN','F326280255571','6569936000','1695000','6571631000');
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 ('F326280257151','kasir','1',' MEA1E LG ','TOKO','PM-A','A1E-ZFXD-324-0','AT DAISY MATA SLEP LG 8K ','','0.520','1','100.00','538000','0','0','15000','538000','0','0','0','538000','SIN','00407203','A1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZFXD-324-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='A1E-ZFXD-324-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326280257151','2026-07-28','0.520','2026-07-28','14:57:15','PLG0030551','538000','538000','0','538000','538000','kasir','2026-07-28 14:57:15','F32628025715');
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-07-28','F326280257151','2026-07-28','14:57:15','SIN','538000','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-260728-0013','D','2026-07-28','14:57:15','kasir','PENJUALAN','F326280257151','6571631000','538000','6572169000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260728-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260728-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260728-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260728-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260728-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260728-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280119571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280119571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280119571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280119572' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280119572' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280119572';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280121211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280121211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280121211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280158461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280158461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280158461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280255571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280255571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280255571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280257151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280257151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280257151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281141281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281141281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281141281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281243101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281243101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281243101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281256451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281256451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281256451';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-29','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-28';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-28';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-28';
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-07-28' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-28';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-28';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-28';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-28';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-29' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-28' 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-260729-0001','D','2026-07-29','15:20:11','SYSTEM','SALDO AWAL','SALDO AWAL','0','6572169000','6572169000');
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-260729-0001','D','2026-07-29','15:20:11','BCA','SALDO AWAL','SALDO AWAL','0','738685000','738685000');
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-260729-0001','D','2026-07-29','15:20:11','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-260729-0001','D','2026-07-29','15:20:11','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-07-29';