INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-14 ','09:56:14');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260314-0001','kasir','1',' LGM5-120% ','TOKO','LM','LGM5-ZBXC-22-0','LM ANTAM 5 GR H75670444 ','','5.000','1','120.00','15606000','0','0','17100','16000000','0','0','0','16000000','ILU','00041316','LGM5','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LGM5-ZBXC-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.000',berat_jual_asli=berat_jual_asli+'5.000',stock_jual='1',berat_akhir=berat_akhir-'5.000',berat_akhir_asli=berat_akhir_asli-'5.000',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='LGM5-ZBXC-22-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='LM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260314-0001','2026-03-14','5.000','2026-03-14','12:00:00','PLG0028225','16000000','16000000','0','16000000','16000000','kasir','2026-03-14 12:00:00','FE-260314-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-14','FE-260314-0001','2026-03-14','12:00:00','ILU','16000000','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-260314-0002','D','2026-03-14','12:00:00','kasir','PENJUALAN','FE-260314-0001','6884940','16000000','22884940','OPEN');
UPDATE tt_jual_head SET dibayar_rp='16000000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FE-260314-0001' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260314-0002','kasir',' 1',' LGM5-120% ','TOKO','LM','LGM5-ZBXC-21-0','LM ANTAM 5 GR H75670456 ','','5.000','1','120.00','15606000','0','0','17100','16000000','0','0','0','16000000','ILU','00041315','LGM5','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LGM5-ZBXC-21-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.000',berat_jual_asli=berat_jual_asli+'5.000',stock_jual='1',berat_akhir=berat_akhir-'5.000',berat_akhir_asli=berat_akhir_asli-'5.000',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='LGM5-ZBXC-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='LM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260314-0002','2026-03-14','5.000','2026-03-14','12:00:00','PLG0028226','16000000','16000000','0','16000000','14000000','kasir','2026-03-14 12:00:00','FE-260314-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-14','FE-260314-0002','2026-03-14','12:00:00','ILU','16000000','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-260314-0003','D','2026-03-14','12:00:00','kasir','PENJUALAN','FE-260314-0002','22884940','14000000','36884940','OPEN');
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-260314-0001','2026-03-14','2026-03-14 12:00:00','PENJUALAN : FE-260314-0002','','TBC','2000000','2000000','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-260314-0002','D','2026-03-14','12:00:00','TBC','PENJUALAN','FE-260314-0002','95789128885','2000000','95791128885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='14000000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2000000' WHERE no_faktur_jual='FE-260314-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260314-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260314-0002';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260314-0003','kasir','1',' CBRE-06997','TOKO','CBR','CBRE-ZCXB-65-0','CBRE-06997 GIA 1425963653 ','','3.050','1','83.00','26228000','17387500','1017','17100','37000000','0','0','0','37000000','ILU','00042126','CBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-ZCXB-65-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='CBRE-ZCXB-65-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260314-0003','2026-03-14','3.050','2026-03-14','12:46:29','PLG0028227','37000000','37000000','0','37000000','37000000','kasir','2026-03-14 12:46:28','FE-260314-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-14','FE-260314-0003','2026-03-14','12:46:29','ILU','37000000','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-260314-0004','D','2026-03-14','12:46:29','kasir','PENJUALAN BERLIAN','FE-260314-0003','36884940','37000000','73884940');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260314-0003';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260314-0004','kasir','1',' DP-02956 ','TOKO','PSN','PSGE-ZCAX-3-0','CINCIN EMAS ','','2.060','1','83.00','4884000','0','0','17100','6370000','0','0','0','6370000','ASRI','00042227','PSGE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGE-ZCAX-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='PSGE-ZCAX-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260314-0004','2026-03-14','2.060','2026-03-14','12:57:14','PLG0028228','6370000','6370000','0','6370000','0','kasir','2026-03-14 12:57:14','FE-260314-0004','DP-02956','4976000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-14','FE-260314-0004','2026-03-14','12:57:14','ASRI','6370000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260314-0002','2026-03-14','2026-03-14 12:57:14','PENJUALAN : FE-260314-0004','.','TBC','1394000','1394000','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-260314-0003','D','2026-03-14','12:57:14','TBC','PENJUALAN','FE-260314-0004','95791128885','1394000','95792522885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1394000' WHERE no_faktur_jual='FE-260314-0004' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260314-0005','kasir',' 1',' DP-02957 ','TOKO','PSN','PSPLE-ZBBF-102-0','CINCIN PALADIUM ','','4.280','1','17.00','961000','0','0','17100','1984000','0','0','0','1984000','ASRI','00042001','PSPLE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLE-ZBBF-102-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.280',berat_jual_asli=berat_jual_asli+'4.280',stock_jual='1',berat_akhir=berat_akhir-'4.280',berat_akhir_asli=berat_akhir_asli-'4.280',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='PSPLE-ZBBF-102-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260314-0005','2026-03-14','4.280','2026-03-14','12:57:14','PLG0028229','1984000','1984000','0','1984000','0','kasir','2026-03-14 12:57:14','FE-260314-0004','DP-02957','1760000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-14','FE-260314-0005','2026-03-14','12:57:14','ASRI','1984000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260314-0003','2026-03-14','2026-03-14 12:57:14','PENJUALAN : FE-260314-0005','.','TBC','224000','224000','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-260314-0004','D','2026-03-14','12:57:14','TBC','PENJUALAN','FE-260314-0005','95792522885','224000','95792746885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1618000' WHERE no_faktur_jual='FE-260314-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260314-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260314-0005';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260314-0006','kasir','1',' CBRE-05210','TOKO','CBR','CBRE-YCAI-13-0','CINCIN CBRE-05210','','4.580','1','83.00','18939000','7523000','440','17100','22000000','0','0','0','22000000','BARY','00034895','CBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-YCAI-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.580',berat_jual_asli=berat_jual_asli+'4.580',stock_jual='1',berat_akhir=berat_akhir-'4.580',berat_akhir_asli=berat_akhir_asli-'4.580',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='CBRE-YCAI-13-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260314-0006','2026-03-14','4.580','2026-03-14','13:23:07','PLG0028230','22000000','22000000','0','22000000','0','kasir','2026-03-14 13:23:07','FE-260314-0006','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-14','FE-260314-0006','2026-03-14','13:23:07','BARY','22000000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260314-0004','2026-03-14','2026-03-14 13:23:07','PENJUALAN : FE-260314-0006','','TBC','22000000','22000000','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-260314-0005','D','2026-03-14','13:23:07','TBC','PENJUALAN BERLIAN','FE-260314-0006','95792746885','22000000','95814746885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='22000000' WHERE no_faktur_jual='FE-260314-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260314-0006';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260314-0007','kasir','1',' 700K-17-95','TOKO','PERAK','CKPRE-ZBAX-24-0','CINCIN SILVER 925 ','','3.100','1','100.00','317000','0','0','17100','800000','0','0','0','800000','ILU','00041460','CKPRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-ZBAX-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.100',berat_jual_asli=berat_jual_asli+'3.100',stock_jual='1',berat_akhir=berat_akhir-'3.100',berat_akhir_asli=berat_akhir_asli-'3.100',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='CKPRE-ZBAX-24-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PERAK' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260314-0007','2026-03-14','3.100','2026-03-14','15:02:51','PLG0028231','800000','800000','0','800000','0','kasir','2026-03-14 15:02:50','FE-260314-0007','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-14','FE-260314-0007','2026-03-14','15:02:51','ILU','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260314-0005','2026-03-14','2026-03-14 15:02:50','PENJUALAN : FE-260314-0007','','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260314-0006','D','2026-03-14','15:02:51','TBC','PENJUALAN','FE-260314-0007','95814746885','800000','95815546885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FE-260314-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260314-0007';
UPDATE tt_service_head SET tgl_selesai='2026-03-14',  status ='DONE' WHERE no_service='SV-08066';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-08066';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-03-14',  status ='CLOS' WHERE no_service='SV-08066';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-08066';
DELETE FROM tm_berlian WHERE kode_barang='CMP-YCXE-77-0';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CMP-YCXE-77-0','00034580','00034580','CINCIN MAS PUTIH ','CINCIN MAS PUTIH','','','4868000','4868000',' 0','0','kasir','2026-03-14 15:41:49');
UPDATE tm_barang SET nama_barang='CINCIN MAS PUTIH' ,nama_atribut='' ,kode_intern='CMPE75-83% ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='75',total_usd_ext='',total_usd='0' WHERE kode_barang='CMP-YCXE-77-0' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260314-0008','kasir','1',' 500K-19-97','TOKO','PERAK','CKPRE-ZBAC-9-0','CINCIN SILVER 925','','1.860','1','100.00','190000','0','0','17100','600000','0','0','0','600000','NANA','00041538','CKPRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-ZBAC-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.860',berat_jual_asli=berat_jual_asli+'1.860',stock_jual='1',berat_akhir=berat_akhir-'1.860',berat_akhir_asli=berat_akhir_asli-'1.860',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='CKPRE-ZBAC-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PERAK' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260314-0008','2026-03-14','1.860','2026-03-14','15:42:12','PLG0028232','600000','600000','0','600000','0','kasir','2026-03-14 15:42:12','FE-260314-0008','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-14','FE-260314-0008','2026-03-14','15:42:12','NANA','600000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260314-0006','2026-03-14','2026-03-14 15:42:12','PENJUALAN : FE-260314-0008','','TBC','600000','600000','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-260314-0007','D','2026-03-14','15:42:12','TBC','PENJUALAN','FE-260314-0008','95815546885','600000','95816146885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='600000' WHERE no_faktur_jual='FE-260314-0008' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260314-0009','kasir',' 1',' CMPE75-83%','TOKO','CMP','CMP-YCXE-77-0','CINCIN MAS PUTIH','','2.300','1','83.00','4917000','0','0','17100','5186000','0','0','0','5186000','NANA','00034580','CMP','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CMP-YCXE-77-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.300',berat_jual_asli=berat_jual_asli+'2.300',stock_jual='1',berat_akhir=berat_akhir-'2.300',berat_akhir_asli=berat_akhir_asli-'2.300',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='CMP-YCXE-77-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CMP' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260314-0009','2026-03-14','2.300','2026-03-14','15:42:12','PLG0028233','5186000','5186000','0','5186000','0','kasir','2026-03-14 15:42:12','FE-260314-0008','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-14','FE-260314-0009','2026-03-14','15:42:12','NANA','5186000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260314-0007','2026-03-14','2026-03-14 15:42:12','PENJUALAN : FE-260314-0009','','TBC','5186000','5186000','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-260314-0008','D','2026-03-14','15:42:12','TBC','PENJUALAN','FE-260314-0009','95816146885','5186000','95821332885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='5786000' WHERE no_faktur_jual='FE-260314-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260314-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260314-0009';
DELETE FROM tm_berlian WHERE kode_barang='CKPRE-YHBE-19-0';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CKPRE-YHBE-19-0','00038264','00038264','CINCIN SILVER 925 ','CINCIN SILVER 925','','','140000','140000',' 150000','150000','kasir','2026-03-14 15:47:21');
UPDATE tm_barang SET nama_barang='CINCIN SILVER 925' ,nama_atribut='' ,kode_intern='700K-145-780 ', kadar_cetak='925.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='CKPRE-YHBE-19-0' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260314-0010','kasir','1',' 700K-23-94','TOKO','PERAK','CKPRE-ZBAX-17-0','CINCIN SILVER 925 ','','5.000','1','100.00','510000','0','0','17100','800000','0','0','0','800000','BARY','00041453','CKPRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-ZBAX-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.000',berat_jual_asli=berat_jual_asli+'5.000',stock_jual='1',berat_akhir=berat_akhir-'5.000',berat_akhir_asli=berat_akhir_asli-'5.000',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='CKPRE-ZBAX-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PERAK' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260314-0010','2026-03-14','5.000','2026-03-14','15:48:06','PLG0028234','800000','800000','0','800000','0','kasir','2026-03-14 15:48:06','FE-260314-0010','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-14','FE-260314-0010','2026-03-14','15:48:06','BARY','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260314-0008','2026-03-14','2026-03-14 15:48:06','PENJUALAN : FE-260314-0010','','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260314-0009','D','2026-03-14','15:48:06','TBC','PENJUALAN','FE-260314-0010','95821332885','800000','95822132885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FE-260314-0010' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260314-0011','kasir',' 1',' 700K-145-7','TOKO','PERAK','CKPRE-YHBE-19-0','CINCIN SILVER 925','','1.400','1','100.00','143000','0','0','17100','800000','0','0','0','800000','BARY','00038264','CKPRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-YHBE-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.400',berat_jual_asli=berat_jual_asli+'1.400',stock_jual='1',berat_akhir=berat_akhir-'1.400',berat_akhir_asli=berat_akhir_asli-'1.400',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='CKPRE-YHBE-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PERAK' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260314-0011','2026-03-14','1.400','2026-03-14','15:48:06','PLG0028235','800000','800000','0','800000','0','kasir','2026-03-14 15:48:06','FE-260314-0010','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-14','FE-260314-0011','2026-03-14','15:48:06','BARY','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260314-0009','2026-03-14','2026-03-14 15:48:06','PENJUALAN : FE-260314-0011','','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260314-0010','D','2026-03-14','15:48:06','TBC','PENJUALAN','FE-260314-0011','95822132885','800000','95822932885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1600000' WHERE no_faktur_jual='FE-260314-0011' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260314-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260314-0011';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-14 ','16:00:46');
DELETE FROM tm_berlian WHERE kode_barang='LMP-YCXE-105-0';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('LMP-YCXE-105-0','00034608','00034608','LIONTIN MAS PUTIH ','LIONTIN MAS PUTIH','','','1333500','1333500',' 0','0','kasir','2026-03-14 16:06:55');
UPDATE tm_barang SET nama_barang='LIONTIN MAS PUTIH' ,nama_atribut='' ,kode_intern='LMPE75-83% ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='75',total_usd_ext='',total_usd='0' WHERE kode_barang='LMP-YCXE-105-0' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260314-0012','kasir','1',' LMPE75-83%','TOKO','LMP','LMP-YCXE-105-0','LIONTIN MAS PUTIH','','0.630','1','83.00','1347000','0','0','17100','1400000','0','0','0','1400000','kasir','00034608','LMP','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LMP-YCXE-105-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='LMP-YCXE-105-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='LMP' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260314-0012','2026-03-14','0.630','2026-03-14','16:07:36','PLG0000001','1400000','1400000','0','1400000','0','kasir','2026-03-14 16:07:35','FE-260314-0012','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-14','FE-260314-0012','2026-03-14','16:07:36','kasir','1400000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260314-0010','2026-03-14','2026-03-14 16:07:35','PENJUALAN : FE-260314-0012','','TBC','1400000','1400000','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-260314-0011','D','2026-03-14','16:07:36','TBC','PENJUALAN','FE-260314-0012','95822932885','1400000','95824332885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1400000' WHERE no_faktur_jual='FE-260314-0012' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260314-0012';
UPDATE tt_service_head SET tgl_selesai='2026-03-14',  status ='DONE' WHERE no_service='SV-08075';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-08075';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-03-14',  status ='CLOS' WHERE no_service='SV-08075';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-08075';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-14 ','16:49:49');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260314-0013','kasir','1',' KMKE70-71%','TOKO','KMK','KMK-ZBXB-19-0','KALUNG MAS KUNING ','','2.910','1','71.00','5375000','0','0','17100','5500000','0','0','0','5500000','NANA','00041288','KMK','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='KMK-ZBXB-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.910',berat_jual_asli=berat_jual_asli+'2.910',stock_jual='1',berat_akhir=berat_akhir-'2.910',berat_akhir_asli=berat_akhir_asli-'2.910',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='KMK-ZBXB-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='KMK' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260314-0013','2026-03-14','2.910','2026-03-14','16:53:34','PLG0028236','5500000','5500000','0','5500000','0','kasir','2026-03-14 16:53:34','FE-260314-0013','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-14','FE-260314-0013','2026-03-14','16:53:34','NANA','5500000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260314-0011','2026-03-14','2026-03-14 16:53:34','PENJUALAN : FE-260314-0013','.','TBC','5500000','5500000','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-260314-0012','D','2026-03-14','16:53:34','TBC','PENJUALAN','FE-260314-0013','95824332885','5500000','95829832885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='5500000' WHERE no_faktur_jual='FE-260314-0013' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009130','X-00009130','GELANG GBRE-00800','GR','---','GBRE','BELI','BELI001','8385000','2026-03-14','6.390','1','kasir','2026-03-14 17:06:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-GBRE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-GBRE','X-00009130','X-00009130');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-260314-0001','FE-231028-0004','IQB','1','BELI','BELI001','GBRE', 'X-00009130', 'GELANG GBRE-00800','6.410','6.390','75.00','12900000','8385000','1312207','1','8385000','8385000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'6.390',berat_beli_asli=berat_beli_asli+'6.390',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'6.390',berat_akhir_asli=berat_akhir_asli+'6.390',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='GBRE' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('BE-260314-0001','2026-03-14','2026-03-14','17:06:16','IQB','---','6.390','8385000','8385000','8385000','8385000','8385000','kasir','2026-03-14 17:06:16','BE-260314-0001','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260314-0001','KEKE ROSSY PARENGKUAN','-','','','0','kasir','2026-03-14 17:06:16');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260314-0012','2026-03-14','2026-03-14 17:06:16','PEMBELIAN UMUM : BE-260314-0001','-','TBC','8385000','8385000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-260314-0013','K','2026-03-14','17:06:16','TBC','PEMBELIAN UMUM','BE-260314-0001','95829832885','8385000','95821447885','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260314-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260314-0001';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260314-0014','kasir','1',' 700K-17-91','TOKO','PERAK','CKPRE-ZAAF-40-0','CINCIN SILVER 925 ','','4.660','1','100.00','476000','0','0','17100','800000','0','0','0','800000','ONLNANA','00040977','CKPRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-ZAAF-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.660',berat_jual_asli=berat_jual_asli+'4.660',stock_jual='1',berat_akhir=berat_akhir-'4.660',berat_akhir_asli=berat_akhir_asli-'4.660',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='CKPRE-ZAAF-40-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PERAK' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260314-0014','2026-03-14','4.660','2026-03-14','17:28:29','PLG0028237','800000','800000','0','800000','0','kasir','2026-03-14 17:28:28','FE-260314-0014','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-14','FE-260314-0014','2026-03-14','17:28:29','ONLNANA','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260314-0013','2026-03-14','2026-03-14 17:28:28','PENJUALAN : FE-260314-0014','','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260314-0014','D','2026-03-14','17:28:29','TBC','PENJUALAN','FE-260314-0014','95821447885','800000','95822247885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FE-260314-0014' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260314-0015','kasir',' 1',' 800K-13-99','TOKO','PERAK','CKPRE-ZBBG-49-0','CINCIN SILVER 925 ','','1.530','1','100.00','157000','0','0','17100','900000','0','0','0','900000','ONLNANA','00042051','CKPRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-ZBBG-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='CKPRE-ZBBG-49-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PERAK' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260314-0015','2026-03-14','1.530','2026-03-14','17:28:29','PLG0028238','900000','900000','0','900000','0','kasir','2026-03-14 17:28:28','FE-260314-0014','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-14','FE-260314-0015','2026-03-14','17:28:29','ONLNANA','900000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260314-0014','2026-03-14','2026-03-14 17:28:28','PENJUALAN : FE-260314-0015','','TBC','900000','900000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260314-0015','D','2026-03-14','17:28:29','TBC','PENJUALAN','FE-260314-0015','95822247885','900000','95823147885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1700000' WHERE no_faktur_jual='FE-260314-0015' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260314-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260314-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260314-0015';
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2026-03-14 17:29:56');
CREATE TABLE th_20260314_172956 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20260314_172956_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='GLK' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2026-03-14',jam_taking= '17:30:13',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='GLKR-XLBG-5-0' AND kode_barcode='00032965';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKR-XLBG-5-0','00032965','2026-03-14',' 17:35:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKR-XAAH-57-0' AND kode_barcode='00025980';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKR-XAAH-57-0','00025980','2026-03-14',' 17:36:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-UDBB-1' AND kode_barcode='00006105';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-UDBB-1','00006105','2026-03-14',' 17:36:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKR-XLBG-71-0' AND kode_barcode='00033031';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKR-XLBG-71-0','00033031','2026-03-14',' 17:36:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLK-TDXG-21' AND kode_barcode='A0000469';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLK-TDXG-21','A0000469','2026-03-14',' 17:36:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLK-TDXG-17' AND kode_barcode='A0000465';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLK-TDXG-17','A0000465','2026-03-14',' 17:37:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKR-XIXF-37-0' AND kode_barcode='00031157';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKR-XIXF-37-0','00031157','2026-03-14',' 17:37:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKR-ZBBE-76-0' AND kode_barcode='00041862';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKR-ZBBE-76-0','00041862','2026-03-14',' 17:37:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKR-XLBG-7-0' AND kode_barcode='00032967';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKR-XLBG-7-0','00032967','2026-03-14',' 17:37:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKR-XLBG-2-0' AND kode_barcode='00032962';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKR-XLBG-2-0','00032962','2026-03-14',' 17:37:27','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-XLBG-68-0' AND kode_barcode='00033028';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-XLBG-68-0','00033028','2026-03-14',' 17:37:41','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKR-ZBBE-78-0' AND kode_barcode='00041864';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKR-ZBBE-78-0','00041864','2026-03-14',' 17:37:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKR-XLBG-4-0' AND kode_barcode='00032964';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKR-XLBG-4-0','00032964','2026-03-14',' 17:38:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-ZBBE-74-0' AND kode_barcode='00041860';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-ZBBE-74-0','00041860','2026-03-14',' 17:39:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-XLBG-42-0' AND kode_barcode='00033002';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-XLBG-42-0','00033002','2026-03-14',' 17:39:36','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-WFBB-30-0' AND kode_barcode='00022569';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-WFBB-30-0','00022569','2026-03-14',' 17:39:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-WLAE-7-0' AND kode_barcode='00025360';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-WLAE-7-0','00025360','2026-03-14',' 17:40:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKK-UCXF-7' AND kode_barcode='00004553';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKK-UCXF-7','00004553','2026-03-14',' 17:40:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKR-XLBG-10-0' AND kode_barcode='00032970';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKR-XLBG-10-0','00032970','2026-03-14',' 17:41:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKK-XABB-24-0' AND kode_barcode='00026179';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKK-XABB-24-0','00026179','2026-03-14',' 17:41:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-XLBG-43-0' AND kode_barcode='00033003';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-XLBG-43-0','00033003','2026-03-14',' 17:42:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-YCXE-60-0' AND kode_barcode='00034563';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-YCXE-60-0','00034563','2026-03-14',' 17:42:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLK-TDXG-24' AND kode_barcode='A0000472';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLK-TDXG-24','A0000472','2026-03-14',' 17:43:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-XIXF-40-0' AND kode_barcode='00031160';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-XIXF-40-0','00031160','2026-03-14',' 17:43:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKK-XAXC-13-0' AND kode_barcode='00025583';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKK-XAXC-13-0','00025583','2026-03-14',' 17:44:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKR-WFAC-8-0' AND kode_barcode='00022361';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKR-WFAC-8-0','00022361','2026-03-14',' 17:44:19','1','kasir');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-14 ','17:44:56');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-UCXF-12' AND kode_barcode='00004536';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-UCXF-12','00004536','2026-03-14',' 17:46:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKK-UCXF-16' AND kode_barcode='00004562';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKK-UCXF-16','00004562','2026-03-14',' 17:46:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKK-UCXF-15' AND kode_barcode='00004561';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKK-UCXF-15','00004561','2026-03-14',' 17:46:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKK-ULBH-34-0' AND kode_barcode='00011425';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKK-ULBH-34-0','00011425','2026-03-14',' 17:47:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKK-UCXF-9' AND kode_barcode='00004555';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKK-UCXF-9','00004555','2026-03-14',' 17:47:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-UCXF-6' AND kode_barcode='00004530';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-UCXF-6','00004530','2026-03-14',' 17:47:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-XEBB-19-0' AND kode_barcode='00028559';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-XEBB-19-0','00028559','2026-03-14',' 17:47:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-UCXF-5' AND kode_barcode='00004529';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-UCXF-5','00004529','2026-03-14',' 17:47:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLK-TDXG-7' AND kode_barcode='A0000455';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLK-TDXG-7','A0000455','2026-03-14',' 17:47:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLK-TDXG-29' AND kode_barcode='A0000477';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLK-TDXG-29','A0000477','2026-03-14',' 17:47:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKK-YHAE-121-0' AND kode_barcode='00038163';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKK-YHAE-121-0','00038163','2026-03-14',' 17:47:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLK-TDXG-20' AND kode_barcode='A0000468';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLK-TDXG-20','A0000468','2026-03-14',' 17:48:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLK-TDXG-9' AND kode_barcode='A0000457';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLK-TDXG-9','A0000457','2026-03-14',' 17:48:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKK-UCBX-1' AND kode_barcode='00005044';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKK-UCBX-1','00005044','2026-03-14',' 17:48:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-ZBBE-73-0' AND kode_barcode='00041859';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-ZBBE-73-0','00041859','2026-03-14',' 17:48:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLK-TDXG-11' AND kode_barcode='A0000459';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLK-TDXG-11','A0000459','2026-03-14',' 17:48:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKK-PGBG-5-0' AND kode_barcode='00016314';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKK-PGBG-5-0','00016314','2026-03-14',' 17:48:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKK-ULXB-1-0' AND kode_barcode='00010697';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKK-ULXB-1-0','00010697','2026-03-14',' 17:49:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-UCXF-19' AND kode_barcode='00004544';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-UCXF-19','00004544','2026-03-14',' 17:49:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLK-TDXG-27' AND kode_barcode='A0000475';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLK-TDXG-27','A0000475','2026-03-14',' 17:49:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-VAAB-19-0' AND kode_barcode='00011687';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-VAAB-19-0','00011687','2026-03-14',' 17:49:27','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKK-UCXF-18' AND kode_barcode='00004564';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKK-UCXF-18','00004564','2026-03-14',' 17:49:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-PHAE-22-0' AND kode_barcode='00016618';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-PHAE-22-0','00016618','2026-03-14',' 17:49:41','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKR-YCXF-1-0' AND kode_barcode='00034628';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKR-YCXF-1-0','00034628','2026-03-14',' 17:49:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKR-YCXE-62-0' AND kode_barcode='00034565';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKR-YCXE-62-0','00034565','2026-03-14',' 17:49:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLK-TDXG-18' AND kode_barcode='A0000466';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLK-TDXG-18','A0000466','2026-03-14',' 17:50:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-UCXF-3' AND kode_barcode='00004527';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-UCXF-3','00004527','2026-03-14',' 17:50:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-UCXF-4' AND kode_barcode='00004528';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-UCXF-4','00004528','2026-03-14',' 17:50:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKK-VEAG-1-0' AND kode_barcode='00014505';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKK-VEAG-1-0','00014505','2026-03-14',' 17:50:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLK-TDXG-12' AND kode_barcode='A0000460';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLK-TDXG-12','A0000460','2026-03-14',' 17:50:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKR-YKAI-29-0' AND kode_barcode='00039689';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKR-YKAI-29-0','00039689','2026-03-14',' 17:50:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-XIXF-18-0' AND kode_barcode='00031138';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-XIXF-18-0','00031138','2026-03-14',' 17:50:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKR-YHBF-1-0' AND kode_barcode='00038299';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKR-YHBF-1-0','00038299','2026-03-14',' 17:50:49','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-UCXF-7' AND kode_barcode='00004531';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-UCXF-7','00004531','2026-03-14',' 17:50:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKR-ZBBE-75-0' AND kode_barcode='00041861';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKR-ZBBE-75-0','00041861','2026-03-14',' 17:51:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKK-XAXC-11-0' AND kode_barcode='00025581';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKK-XAXC-11-0','00025581','2026-03-14',' 17:51:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKR-XLBG-9-0' AND kode_barcode='00032969';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKR-XLBG-9-0','00032969','2026-03-14',' 17:51:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKK-PFBG-29-0' AND kode_barcode='00015618';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKK-PFBG-29-0','00015618','2026-03-14',' 17:51:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLK-TDXG-28' AND kode_barcode='A0000476';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLK-TDXG-28','A0000476','2026-03-14',' 17:51:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-XLBG-67-0' AND kode_barcode='00033027';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-XLBG-67-0','00033027','2026-03-14',' 17:51:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKR-YHBF-6-0' AND kode_barcode='00038304';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKR-YHBF-6-0','00038304','2026-03-14',' 17:51:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKP-XIXF-17-0' AND kode_barcode='00031137';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKP-XIXF-17-0','00031137','2026-03-14',' 17:51:49','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='GLKR-ZBBE-77-0' AND kode_barcode='00041863';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLKR-ZBBE-77-0','00041863','2026-03-14',' 17:51:55','1','kasir');
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-00009131','X-00009131','CBRE02703','GR','---','CBR','BELI','BELI001','3936000','2026-03-14','2.510','1','kasir','2026-03-14 18:10:01');
DELETE FROM tp_barang WHERE kode_dept = 'X-CBR';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBR','X-00009131','X-00009131');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-260314-0002','00011210','NANA','1','BELI','BELI001','CBR', 'X-00009131', 'CBRE02703','2.620','2.510','75.00','4920000','3936000','1568127','1','3936000','3936000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.510',berat_beli_asli=berat_beli_asli+'2.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.510',berat_akhir_asli=berat_akhir_asli+'2.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CBR' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('BE-260314-0002','2026-03-14','2026-03-14','18:10:01','NANA','---','2.510','3936000','3936000','3936000','3936000','3936000','kasir','2026-03-14 18:10:01','BE-260314-0002','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260314-0002','-','-','','','','kasir','2026-03-14 18:10:01');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260314-0015','2026-03-14','2026-03-14 18:10:01','PEMBELIAN UMUM : BE-260314-0002','-','TBC','3936000','3936000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-260314-0016','K','2026-03-14','18:10:01','TBC','PEMBELIAN UMUM','BE-260314-0002','95823147885','3936000','95819211885','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-14 ','18:10:10');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260314-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260314-0002';
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-260314-0005','K','2026-03-14','18:20:07','kasir','KAS BESAR','UANG VISIT MITA','73884940','50000','73834940');
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-260314-0006','K','2026-03-14','18:20:20','kasir','KIRIM PAKET','JNE TANGERANG','73834940','18000','73816940');
UPDATE tm_credit_card SET nama_customer='-',no_ktp='-',alamat1=' - ' ,alamat2=' - ' ,kota= ' - ' ,no_telp='-',tgl_valid_until='-',tgl_last_gesek='2026-03-14 18:21:38' WHERE id_card = '-';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260314-0016','kasir','1',' ABRE-02063','TOKO','ABR','ABRE-YHAE-2-0','GIWANG ABRE-02063','','3.770','1','83.00','16862000','7349000','430','17100','20000000','0','0','0','20000000','BARY','00038044','ABRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='ABRE-YHAE-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.770',berat_jual_asli=berat_jual_asli+'3.770',stock_jual='1',berat_akhir=berat_akhir-'3.770',berat_akhir_asli=berat_akhir_asli-'3.770',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='ABRE-YHAE-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='ABR' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260314-0016','2026-03-14','3.770','2026-03-14','18:21:39','PLG0028239','20000000','20000000','0','20000000','0','kasir','2026-03-14 18:21:38','FE-260314-0016','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-14','FE-260314-0016','2026-03-14','18:21:39','BARY','20000000','0');
INSERT INTO tt_card(no_trx,tgl_system,tgl_trx,deskripsi,id_card,kode_bank,jml_cash_rp,card_rp,card_fee_rp) VALUES ('CC-260314-0001','2026-03-14','2026-03-14 18:21:38','PENJUALAN : FE-260314-0016','','BCK','20000000','20000000','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-260314-0002','D','2026-03-14','18:21:39','BCK','PENJUALAN BERLIAN','FE-260314-0016','16470607978.088','20000000','16490607978.088','CARD');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='20000000',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FE-260314-0016' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260314-0016';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260314-0017','kasir','1',' 700K-12-94','TOKO','PERAK','CKPRE-ZBAX-10-0','CINCIN SILVER 925 ','','1.140','1','100.00','117000','0','0','17100','400000','0','0','0','400000','NANA','00041446','CKPRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-ZBAX-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.140',berat_jual_asli=berat_jual_asli+'1.140',stock_jual='1',berat_akhir=berat_akhir-'1.140',berat_akhir_asli=berat_akhir_asli-'1.140',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='CKPRE-ZBAX-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PERAK' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260314-0017','2026-03-14','1.140','2026-03-14','19:31:32','PLG0028240','400000','400000','0','400000','0','kasir','2026-03-14 19:31:31','FE-260314-0017','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-14','FE-260314-0017','2026-03-14','19:31:32','NANA','400000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260314-0016','2026-03-14','2026-03-14 19:31:31','PENJUALAN : FE-260314-0017','.','TBC','400000','400000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260314-0017','D','2026-03-14','19:31:32','TBC','PENJUALAN','FE-260314-0017','95819211885','400000','95819611885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='400000' WHERE no_faktur_jual='FE-260314-0017' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260314-0018','kasir',' 1',' 500K-20-97','TOKO','PERAK','CKPRE-ZBAC-11-0','CINCIN SILVER 925','','1.880','1','100.00','192000','0','0','17100','450000','0','0','0','450000','NANA','00041540','CKPRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-ZBAC-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.880',berat_jual_asli=berat_jual_asli+'1.880',stock_jual='1',berat_akhir=berat_akhir-'1.880',berat_akhir_asli=berat_akhir_asli-'1.880',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='CKPRE-ZBAC-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PERAK' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260314-0018','2026-03-14','1.880','2026-03-14','19:31:32','PLG0028241','450000','450000','0','450000','0','kasir','2026-03-14 19:31:31','FE-260314-0017','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-14','FE-260314-0018','2026-03-14','19:31:32','NANA','450000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260314-0017','2026-03-14','2026-03-14 19:31:31','PENJUALAN : FE-260314-0018','.','TBC','450000','450000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260314-0018','D','2026-03-14','19:31:32','TBC','PENJUALAN','FE-260314-0018','95819611885','450000','95820061885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FE-260314-0018' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260314-0017';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260314-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260314-0018';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-15','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-12';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-14';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-14';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-03-14' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-14';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-14';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-14';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-14';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-15' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-14' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260315-0001','D','2026-03-15','20:33:00','TBC','SALDO AWAL','SALDO AWAL','0','95820061885','95820061885');
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-260315-0001','D','2026-03-15','20:33:00','BCK','SALDO AWAL','SALDO AWAL','0','16490607978.088','16490607978.088');
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-260315-0001','D','2026-03-15','20:33:00','BCD','SALDO AWAL','SALDO AWAL','0','14996321700','14996321700');
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-260315-0001','D','2026-03-15','20:33:00','TMR','SALDO AWAL','SALDO AWAL','0','8562183779','8562183779');
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-260315-0001','D','2026-03-15','20:33:00','SHO','SALDO AWAL','SALDO AWAL','0','2747005684','2747005684');
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-260315-0001','D','2026-03-15','20:33:00','BNI','SALDO AWAL','SALDO AWAL','0','79502900','79502900');
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-260315-0001','D','2026-03-15','20:33:00','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000');
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-260315-0001','D','2026-03-15','20:33:00','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000');
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-260315-0001','D','2026-03-15','20:33:00','4000000','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-260315-0001','D','2026-03-15','20:33:00','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000');
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-260315-0001','D','2026-03-15','20:33:00','3450000','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-260315-0001','D','2026-03-15','20:33:00','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000');
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-260315-0001','D','2026-03-15','20:33:00','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000');
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-260315-0001','D','2026-03-15','20:33:00','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092');
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-260315-0001','D','2026-03-15','20:33:00','BCA','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-260315-0001','D','2026-03-15','20:33:00','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000');
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-260315-0001','D','2026-03-15','20:33:00','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000');
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-260315-0001','D','2026-03-15','20:33:00','6000000','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-260315-0001','D','2026-03-15','20:33:00','MANDIRI','SALDO AWAL','SALDO AWAL','0','295387450','295387450');
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-260315-0001','D','2026-03-15','20:33:00','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581');
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-260315-0001','D','2026-03-15','20:33:00','KET','SALDO AWAL','SALDO AWAL','0','130319250','130319250');
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-260315-0001','D','2026-03-15','20:33:00','','SALDO AWAL','SALDO AWAL','0','16885500','16885500');
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-260315-0001','D','2026-03-15','20:33:00','DPE','SALDO AWAL','SALDO AWAL','0','226012000','226012000');
UPDATE tp_system SET tgl_system='2026-03-15';