INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-09 ','08:06:10'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-09','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-08'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-08'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-08'; 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='2025-12-08' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-08'; DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-08'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-08'; DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-08'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11'; UPDATE tt_barang_saldo SET tanggal= '2025-12-09' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-08' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; UPDATE tp_system SET tgl_system='2025-12-09'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-09 ','08:07:37'); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CMMM-YLXI-1-0','00040389','1.150K-115 ','CINCIN MAS MM ','','GR','---','GOLD','CMMM','TOKO','MMCM','5329500','2025-12-09','5329500','2.860','83.00','75','100000','2245000.00','1','0.14', 'input','2025-12-09 08:27:32','2.860','0','','16750.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CMMM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMMM','CMMM-YLXI-1-0','00040389'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-09','CMMM-YLXI-1-0','CMMM','TOKO','MMCM','83.00','2.860','2.860','1','2.860','2.860','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CMMM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMMM','1.150K-115 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PLDMM-YLXI-2-0','00040390','PLDMM-00005 ','CINCIN PALADIUM PLDMM-00005 ','','GR','---','PLD','PLDMM','TOKO','MMPLD','217000','2025-12-09','217000','1.610','6.00','10','100000','2245000.00','1','0.04', 'input','2025-12-09 08:28:40','1.610','0','','16750.00','','TOKO','FREETAG','','10','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'PLDMM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLDMM','PLDMM-YLXI-2-0','00040390'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-09','PLDMM-YLXI-2-0','PLDMM','TOKO','MMPLD','6.00','1.610','1.610','1','1.610','1.610','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PLDMM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLDMM','PLDMM-00005 '); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0001','1','CMMM-YLXI-1-0','1','2.860','TOKO','MMCM'); DELETE FROM tm_barang_export WHERE kode_barang='CMMM-YLXI-1-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CMMM-YLXI-1-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='CMMM-YLXI-1-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CMMM-YLXI-1-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='CMMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CMMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMCM'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMCM'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CMMM-YLXI-1-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.860',berat_out_asli='2.860', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.860',berat_akhir_asli =berat_akhir_asli-'2.860' WHERE kode_barang='CMMM-YLXI-1-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-251209-0001','2025-12-09','2025-12-09','08:43','2.860','input','2025-12-09 08:43:38','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0002','1','PLDMM-YLXI-2-0','1','1.610','TOKO','MMPLD'); DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-YLXI-2-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-YLXI-2-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-YLXI-2-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-YLXI-2-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-YLXI-2-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.610',berat_out_asli='1.610', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.610',berat_akhir_asli =berat_akhir_asli-'1.610' WHERE kode_barang='PLDMM-YLXI-2-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-251209-0002','2025-12-09','2025-12-09','08:43','1.610','input','2025-12-09 08:43:54','THIFA'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-09 ','08:46:48'); UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='2304000',harga_beli ='2304000' WHERE kode_barcode='00001136' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='4667000',harga_beli ='4667000' WHERE kode_barcode='00001394' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='181500',harga_beli ='181500' WHERE kode_barcode='00001984' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='2640500',harga_beli ='2640500' WHERE kode_barcode='00002031' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='5845500',harga_beli ='5845500' WHERE kode_barcode='00002094' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='2190000',harga_beli ='2190000' WHERE kode_barcode='00003287' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='2094500',harga_beli ='2094500' WHERE kode_barcode='00003288' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='2133000',harga_beli ='2133000' WHERE kode_barcode='00003289' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='5084000',harga_beli ='5084000' WHERE kode_barcode='00003290' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='18773500',harga_beli ='18773500' WHERE kode_barcode='00003291' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='2612000',harga_beli ='2612000' WHERE kode_barcode='00005675' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='2588500',harga_beli ='2588500' WHERE kode_barcode='00005680' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='2446000',harga_beli ='2446000' WHERE kode_barcode='00005686' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='2541000',harga_beli ='2541000' WHERE kode_barcode='00005694' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='2517000',harga_beli ='2517000' WHERE kode_barcode='00005695' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='7065000',harga_beli ='7065000' WHERE kode_barcode='00006371' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='2705000',harga_beli ='2705000' WHERE kode_barcode='00007446' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='9690500',harga_beli ='9690500' WHERE kode_barcode='00007503' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='3495500',harga_beli ='3495500' WHERE kode_barcode='00014815' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='4109000',harga_beli ='4109000' WHERE kode_barcode='00015245' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='4220500',harga_beli ='4220500' WHERE kode_barcode='00015248' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='4964500',harga_beli ='4964500' WHERE kode_barcode='00016090' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='4016000',harga_beli ='4016000' WHERE kode_barcode='00016091' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='5745000',harga_beli ='5745000' WHERE kode_barcode='00019597' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='6860500',harga_beli ='6860500' WHERE kode_barcode='00019598' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='8273500',harga_beli ='8273500' WHERE kode_barcode='00019599' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='6693500',harga_beli ='6693500' WHERE kode_barcode='00020277' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='1394500',harga_beli ='1394500' WHERE kode_barcode='00020571' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='2584500',harga_beli ='2584500' WHERE kode_barcode='00023554' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='3942000',harga_beli ='3942000' WHERE kode_barcode='00023557' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='3570000',harga_beli ='3570000' WHERE kode_barcode='00023558' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='2045500',harga_beli ='2045500' WHERE kode_barcode='00023559' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='1971000',harga_beli ='1971000' WHERE kode_barcode='00023560' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='6042500',harga_beli ='6042500' WHERE kode_barcode='00023561' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='7251000',harga_beli ='7251000' WHERE kode_barcode='00023565' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='3235500',harga_beli ='3235500' WHERE kode_barcode='00023566' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='6414500',harga_beli ='6414500' WHERE kode_barcode='00023567' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='5094500',harga_beli ='5094500' WHERE kode_barcode='00023569' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='2473000',harga_beli ='2473000' WHERE kode_barcode='00023577' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='2101000',harga_beli ='2101000' WHERE kode_barcode='00023578' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='4778500',harga_beli ='4778500' WHERE kode_barcode='00023579' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='3347000',harga_beli ='3347000' WHERE kode_barcode='00023581' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='4961000',harga_beli ='4961000' WHERE kode_barcode='00023587' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='6396000',harga_beli ='6396000' WHERE kode_barcode='00023669' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='9686500',harga_beli ='9686500' WHERE kode_barcode='00023670' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='8738500',harga_beli ='8738500' WHERE kode_barcode='00023671' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='3198000',harga_beli ='3198000' WHERE kode_barcode='00023673' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='4983000',harga_beli ='4983000' WHERE kode_barcode='00023675' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='6953500',harga_beli ='6953500' WHERE kode_barcode='00023677' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='6340000',harga_beli ='6340000' WHERE kode_barcode='00023678' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='6526000',harga_beli ='6526000' WHERE kode_barcode='00023696' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='7493000',harga_beli ='7493000' WHERE kode_barcode='00023698' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='14948000',harga_beli ='14948000' WHERE kode_barcode='00023884' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='1525000',harga_beli ='1525000' WHERE kode_barcode='00023899' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='1525000',harga_beli ='1525000' WHERE kode_barcode='00023900' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='1450500',harga_beli ='1450500' WHERE kode_barcode='00023902' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='1394500',harga_beli ='1394500' WHERE kode_barcode='00023903' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='4611000',harga_beli ='4611000' WHERE kode_barcode='00023909' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='7920500',harga_beli ='7920500' WHERE kode_barcode='00023910' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='9054500',harga_beli ='9054500' WHERE kode_barcode='00023911' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='7697500',harga_beli ='7697500' WHERE kode_barcode='00023963' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='7214000',harga_beli ='7214000' WHERE kode_barcode='00024003' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='7902000',harga_beli ='7902000' WHERE kode_barcode='00024088' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='7046500',harga_beli ='7046500' WHERE kode_barcode='00024116' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='4202000',harga_beli ='4202000' WHERE kode_barcode='00024117' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='50440500',harga_beli ='50440500' WHERE kode_barcode='00024185' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='7846000',harga_beli ='7846000' WHERE kode_barcode='00024187' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='7251000',harga_beli ='7251000' WHERE kode_barcode='00024190' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='5373500',harga_beli ='5373500' WHERE kode_barcode='00024191' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='10319000',harga_beli ='10319000' WHERE kode_barcode='00024259' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='11974500',harga_beli ='11974500' WHERE kode_barcode='00024357' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='6879500',harga_beli ='6879500' WHERE kode_barcode='00024362' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='5559500',harga_beli ='5559500' WHERE kode_barcode='00025021' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='6098500',harga_beli ='6098500' WHERE kode_barcode='00026264' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='4778500',harga_beli ='4778500' WHERE kode_barcode='00026265' LIMIT 1; UPDATE tm_group SET harga='2240000' WHERE kode_group = 'DM' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2240000','input','2025-12-09 11:33:00'); UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='15708000',harga_beli ='15708000' WHERE kode_barcode='00001173' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='9215500',harga_beli ='9215500' WHERE kode_barcode='00001223' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='4855500',harga_beli ='4855500' WHERE kode_barcode='00001224' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='4893500',harga_beli ='4893500' WHERE kode_barcode='00001225' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='5678500',harga_beli ='5678500' WHERE kode_barcode='00002442' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='4310500',harga_beli ='4310500' WHERE kode_barcode='00004222' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='10705000',harga_beli ='10705000' WHERE kode_barcode='00006106' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='3286000',harga_beli ='3286000' WHERE kode_barcode='00006485' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='12320000',harga_beli ='12320000' WHERE kode_barcode='00034435' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='5857000',harga_beli ='5857000' WHERE kode_barcode='00038144' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='8515500',harga_beli ='8515500' WHERE kode_barcode='00040368' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='4890000',harga_beli ='4890000' WHERE kode_barcode='00040369' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='4704000',harga_beli ='4704000' WHERE kode_barcode='00040370' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='3886000',harga_beli ='3886000' WHERE kode_barcode='00040371' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='3663000',harga_beli ='3663000' WHERE kode_barcode='00040372' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='3384000',harga_beli ='3384000' WHERE kode_barcode='00040373' LIMIT 1; UPDATE tm_group SET harga='2240000' WHERE kode_group = 'GOLD' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2240000','input','2025-12-09 11:33:07'); UPDATE tm_group SET harga='2240000' WHERE kode_group = 'PLD' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','2240000','input','2025-12-09 11:33:10'); UPDATE tm_group SET harga='2240000' WHERE kode_group = 'PSBRE' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2240000','input','2025-12-09 11:33:14'); UPDATE tm_group SET harga='2240000' WHERE kode_group = 'PSBRL' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2240000','input','2025-12-09 11:33:17'); UPDATE tm_group SET harga='2240000' WHERE kode_group = 'PSBRT' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2240000','input','2025-12-09 11:33:21'); UPDATE tm_group SET harga='2240000' WHERE kode_group = 'PSGE' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2240000','input','2025-12-09 11:33:25'); UPDATE tm_group SET harga='2240000' WHERE kode_group = 'PSGL' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2240000','input','2025-12-09 11:33:29'); UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='3384000',harga_beli ='3384000' WHERE kode_barcode='00033486' LIMIT 1; UPDATE tm_group SET harga='2240000' WHERE kode_group = 'PSGT' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2240000','input','2025-12-09 11:33:34'); UPDATE tm_group SET harga='2240000' WHERE kode_group = 'PSPLE' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','2240000','input','2025-12-09 11:33:37'); UPDATE tm_group SET harga='2240000' WHERE kode_group = 'PSPLL' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','2240000','input','2025-12-09 11:33:41'); UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='280000',harga_beli ='280000' WHERE kode_barcode='00040374' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2240000',harga_jual='364500',harga_beli ='364500' WHERE kode_barcode='00040375' LIMIT 1; UPDATE tm_group SET harga='2240000' WHERE kode_group = 'PSPLT' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','2240000','input','2025-12-09 11:33:44'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-09 ','13:04:10'); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01430'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-YLXI-3-0','00040391','DP-01430BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','219500','2025-12-09','219500','1.630','6.00','10','300000','2240000.00','1','0.14', 'input','2025-12-09 13:15:09','1.630','0','','16750.00','','TOKO','FREETAG','','10','','','PSN01430BIP','1','RS 14','','DP-01430'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YLXI-3-0','00040391'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-09','PSPLT-YLXI-3-0','PSPLT','TOKO','PSNB','6.00','1.630','1.630','1','1.630','1.630','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01430BIP '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251128-0004'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251128-0004'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-YLXI-4-0','00040392','CBRE-00934 ','CINCIN CBRE-00934 ','','GR','---','DM','CBRE','TOKO','CBRE','2436000','2025-12-09','2436000','1.310','83.00','75.00','0','2240000.00','1','0.04', 'input','2025-12-09 14:20:34','1.310','0','53.25','16750.00','','TOKO','FREETAG','','10','','0','IDB 13 000 000','2','RS15 1125 3B1','BE-251128-0004',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YLXI-4-0','00040392'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-09','CBRE-YLXI-4-0','CBRE','TOKO','CBRE','83.00','1.310','1.310','1','1.310','1.310','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-00934 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YLXI-4-0','00040392','RD','1','0.050 ','480','24'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YLXI-4-0','00040392','RD','8','0.065 ','450','29.25'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251209-0001','1','CBRE-YLXI-4-0','1','1.310','1.310','TOKO','CBRE','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YLXI-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-09','TOKO','SEM-BALIK','CBRE','CBRE-YLXI-4-0','83.00','1','1.310','1.310','1','1.310','1.310'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.310',berat_out_asli=berat_out_asli+'1.310',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-09' AND kode_barang='CBRE-YLXI-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251209-0001','2025-12-09','2025-12-09','14:20','1.31','input','2025-12-09 14:20:49'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251128-0002'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251128-0002'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-YLXI-5-0','00040393','CBRE-05899 ','CINCIN CBRE-05899 ','','GR','---','DM','CBRE','TOKO','CBRE','5006500','2025-12-09','5006500','2.980','75.00','75','0','2240000.00','1','0.04', 'input','2025-12-09 14:23:23','2.980','0','324.00','16750.00','','TOKO','FREETAG','','10','','0','IDB 37 500 000','2','RS125 1125 9B6','BE-251128-0002',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YLXI-5-0','00040393'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-09','CBRE-YLXI-5-0','CBRE','TOKO','CBRE','75.00','2.980','2.980','1','2.980','2.980','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-05899 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YLXI-5-0','00040393','RD','1','0.240 ','1050','252'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YLXI-5-0','00040393','RD','58','0.225 ','320','72'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251209-0002','1','CBRE-YLXI-5-0','1','2.980','2.980','TOKO','CBRE','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YLXI-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-09','TOKO','SEM-BALIK','CBRE','CBRE-YLXI-5-0','75.00','1','2.980','2.980','1','2.980','2.980'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.980',berat_out_asli=berat_out_asli+'2.980',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-09' AND kode_barang='CBRE-YLXI-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251209-0002','2025-12-09','2025-12-09','14:23','2.98','input','2025-12-09 14:23:36'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251128-0001'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251128-0001'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LBRE-YLXI-6-0','00040394','LBRE-00203 ','LIONTIN LBRE-00203 ','','GR','---','DM','LBRE','TOKO','LBRE','2789000','2025-12-09','2789000','1.660','75.00','75','0','2240000.00','1','0.04', 'input','2025-12-09 14:26:03','1.660','0','169.60','16750.00','','TOKO','FREETAG','','10','','0','IDB 21 000 000','2','1125 5B450','BE-251128-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'LBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LBRE','LBRE-YLXI-6-0','00040394'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-09','LBRE-YLXI-6-0','LBRE','TOKO','LBRE','75.00','1.660','1.660','1','1.660','1.660','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LBRE','LBRE-00203 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-YLXI-6-0','00040394','RD','1','0.015 ','320','4.8'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-YLXI-6-0','00040394','RD','1','0.050 ','320','16'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-YLXI-6-0','00040394','RD','12','0.385 ','320','123.2'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-YLXI-6-0','00040394','RD','19','0.080 ','320','25.6'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251209-0003','1','LBRE-YLXI-6-0','1','1.660','1.660','TOKO','LBRE','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='LBRE-YLXI-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-09','TOKO','SEM-BALIK','LBRE','LBRE-YLXI-6-0','75.00','1','1.660','1.660','1','1.660','1.660'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.660',berat_out_asli=berat_out_asli+'1.660',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-09' AND kode_barang='LBRE-YLXI-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251209-0003','2025-12-09','2025-12-09','14:26','1.66','input','2025-12-09 14:26:16'); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-251128-0001'; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-251128-0001'; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFA-YLXI-7-0','00040395','TFA-21074 ','ANTING TFA-21074 ','','GR','---','DM','TFA','TOKO','TFA','7207500','2025-12-09','7207500','4.290','75.00','75','0','2240000.00','1','0.04', 'input','2025-12-09 14:28:34','4.290','0','256.50','16750.00','','TOKO','FREETAG','','10','','0','IDB 41 500 000','2','1125 11B5','FB-251128-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'TFA' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFA','TFA-YLXI-7-0','00040395'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-09','TFA-YLXI-7-0','TFA','TOKO','TFA','75.00','4.290','4.290','1','4.290','4.290','1'); DELETE FROM tp_kode_intern WHERE kode_dept='TFA'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFA','TFA-21074 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFA-YLXI-7-0','00040395','RD','62','0.570 ','450','256.5'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251209-0004','1','TFA-YLXI-7-0','1','4.290','4.290','TOKO','TFA','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='TFA-YLXI-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TFA'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-09','TOKO','SEM-BALIK','TFA','TFA-YLXI-7-0','75.00','1','4.290','4.290','1','4.290','4.290'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.290',berat_out_asli=berat_out_asli+'4.290',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-09' AND kode_barang='TFA-YLXI-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TFA' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251209-0004','2025-12-09','2025-12-09','14:28','4.29','input','2025-12-09 14:28:52'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251129-0001'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251129-0001'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-YLXI-8-0','00040396','CBRE-04493 ','CINCIN CBRE-04493 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','3024000','2025-12-09','3024000','1.800','75.00','75.00','0','2240000.00','1','0.04', 'input','2025-12-09 14:30:41','1.800','0','94.20','16750.00','0','TOKO','FREETAG','','10','','0','IDB 18 000 000','5','RS15 1125 4B4','BE-251129-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YLXI-8-0','00040396'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-09','CBRE-YLXI-8-0','CBRE','TOKO','CBRE.BALIK','75.00','1.800','1.800','1','1.800','1.800','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-04493 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YLXI-8-0','00040396','RD','20','0.115 ','450','51.75'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YLXI-8-0','00040396','RD','8','0.025 ','450','11.25'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YLXI-8-0','00040396','RD','1','0.065 ','480','31.2'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251209-0005','1','CBRE-YLXI-8-0','1','1.800','1.800','TOKO','CBRE.BALIK','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YLXI-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-09','TOKO','SEM-BALIK','CBRE','CBRE-YLXI-8-0','75.00','1','1.800','1.800','1','1.800','1.800'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.800',berat_out_asli=berat_out_asli+'1.800',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-09' AND kode_barang='CBRE-YLXI-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251209-0005','2025-12-09','2025-12-09','14:30','1.8','input','2025-12-09 14:30:53'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251130-0003'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251130-0003'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKBE-YLXI-9-0','00040397','CKBE-01176 ','CINCIN KAWIN CKBE-01176 ','','GR','---','DM','CKBE','TOKO','SEM-BALIK','3293000','2025-12-09','3293000','1.960','75.00','75','0','2240000.00','1','0.14', 'input','2025-12-09 14:36:25','1.960','0','12.60','16750.00','','TOKO','FREETAG','','10','','','IDB 15 000 000','1','RS11 1125 1B9','BE-251130-0003',''); DELETE FROM tp_barang WHERE kode_dept = 'CKBE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKBE','CKBE-YLXI-9-0','00040397'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-09','CKBE-YLXI-9-0','CKBE','TOKO','SEM-BALIK','75.00','1.960','1.960','1','1.960','1.960','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKBE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKBE','CKBE-01176 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CKBE-YLXI-9-0','00040397','RD','1','0.030 ','420','12.6'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251130-0001'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251130-0001'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-YLXI-10-0','00040398','CBR0892 ','CINCIN CBR0892 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','2318500','2025-12-09','2318500','1.380','75.00','75','0','2240000.00','1','0.14', 'input','2025-12-09 14:38:09','1.380','0','74.40','16750.00','','TOKO','FREETAG','','10','','','IDB 13 000 000','1','RS11 1125 2B750','BE-251130-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YLXI-10-0','00040398'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-09','CBRE-YLXI-10-0','CBRE','TOKO','SEM-BALIK','75.00','1.380','1.380','1','1.380','1.380','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBR0892 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YLXI-10-0','00040398','RD','1','0.120 ','620','74.4'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251130-0002'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251130-0002'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('AMP-YLXI-11-0','00040399','AMPE75-76% ','ANTING MAS PUTIH ','','GR','---','GOLD','AMP','TOKO','SEM-EMAS','2656000','2025-12-09','2656000','1.560','76.00','75','0','2240000.00','1','0.14', 'input','2025-12-09 14:39:14','1.560','0','','16750.00','','TOKO','FREETAG','','2','','','','1','','BE-251130-0002',''); DELETE FROM tp_barang WHERE kode_dept = 'AMP' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('AMP','AMP-YLXI-11-0','00040399'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-09','AMP-YLXI-11-0','AMP','TOKO','SEM-EMAS','76.00','1.560','1.560','1','1.560','1.560','1'); DELETE FROM tp_kode_intern WHERE kode_dept='AMP'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('AMP','AMPE75-76% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251201-0003'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251201-0003'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-YLXI-12-0','00040400','CBRE-06179 ','CBRE-06179 GIA 7462778880 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','4872000','2025-12-09','4872000','2.900','75.00','75','0','2240000.00','1','0.04', 'input','2025-12-09 14:42:18','2.900','0','476.40','16750.00','','TOKO','FREETAG','','10','','0','GIE 46 000 000','4','FVVS2 1225 12B8','BE-251201-0003',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YLXI-12-0','00040400'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-09','CBRE-YLXI-12-0','CBRE','TOKO','CBRE.BALIK','75.00','2.900','2.900','1','2.900','2.900','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06179 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YLXI-12-0','00040400','RD','16','0.170 ','420','71.4'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YLXI-12-0','00040400','EMR','1','0.300 ','1350','405'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251209-0006','1','CBRE-YLXI-12-0','1','2.900','2.900','TOKO','CBRE.BALIK','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YLXI-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-09','TOKO','SEM-BALIK','CBRE','CBRE-YLXI-12-0','75.00','1','2.900','2.900','1','2.900','2.900'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.900',berat_out_asli=berat_out_asli+'2.900',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-09' AND kode_barang='CBRE-YLXI-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251209-0006','2025-12-09','2025-12-09','14:42','2.9','input','2025-12-09 14:42:31'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251201-0002'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251201-0002'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('ABRE-YLXI-13-0','00040401','ABRE-02093 ','ANTING ABRE-02093 ','','GR','---','DM','ABRE','TOKO','ABRE.BALIK','2082500','2025-12-09','2082500','1.120','83.00','75','0','2240000.00','1','0.04', 'input','2025-12-09 14:44:14','1.120','475000','29.25','16750.00','','TOKO','FREETAG','','10','','0','IDB 12 000 000','2','ANT751225 3B050','BE-251201-0002',''); DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-YLXI-13-0','00040401'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-09','ABRE-YLXI-13-0','ABRE','TOKO','ABRE.BALIK','83.00','1.120','1.120','1','1.120','1.120','1'); DELETE FROM tp_kode_intern WHERE kode_dept='ABRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-02093 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YLXI-13-0','00040401','RD','16','0.065 ','450','29.25'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251209-0007','1','ABRE-YLXI-13-0','1','1.120','1.120','TOKO','ABRE.BALIK','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='ABRE-YLXI-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-09','TOKO','SEM-BALIK','ABRE','ABRE-YLXI-13-0','83.00','1','1.120','1.120','1','1.120','1.120'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.120',berat_out_asli=berat_out_asli+'1.120',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-09' AND kode_barang='ABRE-YLXI-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251209-0007','2025-12-09','2025-12-09','14:44','1.12','input','2025-12-09 14:44:29'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251201-0001'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251201-0001'; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-YLXI-14-0','00040402','CBRE-04389 ','CINCIN CBRE-04389 ','','GR','---','DM','CBRE','TOKO','CBRE','5897000','2025-12-09','5897000','3.510','75.00','75','0','2240000.00','1','0.04', 'input','2025-12-09 14:46:25','3.510','0','298.30','16750.00','','TOKO','FREETAG','','10','','0','IDB 39 000 000','2','RS12 1225 10B4','BE-251201-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YLXI-14-0','00040402'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-09','CBRE-YLXI-14-0','CBRE','TOKO','CBRE','75.00','3.510','3.510','1','3.510','3.510','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-04389 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YLXI-14-0','00040402','RD','1','0.125 ','620','77.5'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YLXI-14-0','00040402','RD','2','0.085 ','320','27.2'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YLXI-14-0','00040402','RD','6','0.395 ','320','126.4'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YLXI-14-0','00040402','RD','28','0.210 ','320','67.2'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251209-0008','1','CBRE-YLXI-14-0','1','3.510','3.510','TOKO','CBRE','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YLXI-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-09','TOKO','SEM-BALIK','CBRE','CBRE-YLXI-14-0','75.00','1','3.510','3.510','1','3.510','3.510'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.510',berat_out_asli=berat_out_asli+'3.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-09' AND kode_barang='CBRE-YLXI-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251209-0008','2025-12-09','2025-12-09','14:46','3.51','input','2025-12-09 14:46:38'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0003','1','BDCM-YLXH-1-0','1','4.580','TOKO','CMBD'); DELETE FROM tm_barang_export WHERE kode_barang='BDCM-YLXH-1-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='BDCM-YLXH-1-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='BDCM-YLXH-1-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='BDCM-YLXH-1-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='BDCM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMBD'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMBD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='BDCM-YLXH-1-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.580',berat_out_asli='4.580', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.580',berat_akhir_asli =berat_akhir_asli-'4.580' WHERE kode_barang='BDCM-YLXH-1-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0003','2','BDCM-YLXH-2-0','1','2.630','TOKO','CMBD'); DELETE FROM tm_barang_export WHERE kode_barang='BDCM-YLXH-2-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='BDCM-YLXH-2-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='BDCM-YLXH-2-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='BDCM-YLXH-2-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='BDCM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMBD'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMBD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='BDCM-YLXH-2-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.630',berat_out_asli='2.630', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.630',berat_akhir_asli =berat_akhir_asli-'2.630' WHERE kode_barang='BDCM-YLXH-2-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0003','3','BDCM-YLXH-3-0','1','2.530','TOKO','CMBD'); DELETE FROM tm_barang_export WHERE kode_barang='BDCM-YLXH-3-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='BDCM-YLXH-3-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='BDCM-YLXH-3-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='BDCM-YLXH-3-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='BDCM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMBD'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMBD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='BDCM-YLXH-3-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.530',berat_out_asli='2.530', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.530',berat_akhir_asli =berat_akhir_asli-'2.530' WHERE kode_barang='BDCM-YLXH-3-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0003','4','BDCM-YLXH-4-0','1','2.090','TOKO','CMBD'); DELETE FROM tm_barang_export WHERE kode_barang='BDCM-YLXH-4-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='BDCM-YLXH-4-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='BDCM-YLXH-4-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='BDCM-YLXH-4-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='BDCM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMBD'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMBD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='BDCM-YLXH-4-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.090',berat_out_asli='2.090', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.090',berat_akhir_asli =berat_akhir_asli-'2.090' WHERE kode_barang='BDCM-YLXH-4-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0003','5','BDCM-YLXH-5-0','1','1.970','TOKO','CMBD'); DELETE FROM tm_barang_export WHERE kode_barang='BDCM-YLXH-5-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='BDCM-YLXH-5-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='BDCM-YLXH-5-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='BDCM-YLXH-5-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='BDCM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMBD'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMBD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='BDCM-YLXH-5-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.970',berat_out_asli='1.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.970',berat_akhir_asli =berat_akhir_asli-'1.970' WHERE kode_barang='BDCM-YLXH-5-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0003','6','BDCM-YLXH-6-0','1','1.820','TOKO','CMBD'); DELETE FROM tm_barang_export WHERE kode_barang='BDCM-YLXH-6-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='BDCM-YLXH-6-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='BDCM-YLXH-6-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='BDCM-YLXH-6-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='BDCM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMBD'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMBD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='BDCM-YLXH-6-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.820',berat_out_asli='1.820', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.820',berat_akhir_asli =berat_akhir_asli-'1.820' WHERE kode_barang='BDCM-YLXH-6-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-251209-0003','2025-12-09','2025-12-09','14:49','1.820','input','2025-12-09 14:49:52','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0004','1','PBDG-YLXH-9-0','1','2.180','TOKO','PBDG'); DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YLXH-9-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-YLXH-9-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-YLXH-9-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-YLXH-9-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-YLXH-9-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.180',berat_out_asli='2.180', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.180',berat_akhir_asli =berat_akhir_asli-'2.180' WHERE kode_barang='PBDG-YLXH-9-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0004','2','PBDG-YLXH-10-0','1','2.100','TOKO','PBDG'); DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YLXH-10-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-YLXH-10-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-YLXH-10-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-YLXH-10-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-YLXH-10-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.100',berat_out_asli='2.100', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.100',berat_akhir_asli =berat_akhir_asli-'2.100' WHERE kode_barang='PBDG-YLXH-10-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0004','3','PBDG-YLXH-11-0','1','2.010','TOKO','PBDG'); DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YLXH-11-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-YLXH-11-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-YLXH-11-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-YLXH-11-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-YLXH-11-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.010',berat_out_asli='2.010', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.010',berat_akhir_asli =berat_akhir_asli-'2.010' WHERE kode_barang='PBDG-YLXH-11-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0004','4','PBDG-YLXH-12-0','1','1.880','TOKO','PBDG'); DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YLXH-12-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-YLXH-12-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-YLXH-12-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-YLXH-12-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-YLXH-12-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.880',berat_out_asli='1.880', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.880',berat_akhir_asli =berat_akhir_asli-'1.880' WHERE kode_barang='PBDG-YLXH-12-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0004','5','PBDG-YLXH-13-0','1','1.910','TOKO','PBDG'); DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YLXH-13-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-YLXH-13-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-YLXH-13-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-YLXH-13-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-YLXH-13-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.910',berat_out_asli='1.910', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.910',berat_akhir_asli =berat_akhir_asli-'1.910' WHERE kode_barang='PBDG-YLXH-13-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0004','6','PBDG-YLXH-14-0','1','1.850','TOKO','PBDG'); DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YLXH-14-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-YLXH-14-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-YLXH-14-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-YLXH-14-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-YLXH-14-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.850',berat_out_asli='1.850', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.850',berat_akhir_asli =berat_akhir_asli-'1.850' WHERE kode_barang='PBDG-YLXH-14-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0004','7','PBDG-YLXH-15-0','1','1.570','TOKO','PBDG'); DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YLXH-15-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-YLXH-15-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-YLXH-15-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-YLXH-15-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-YLXH-15-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.570',berat_out_asli='1.570', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.570',berat_akhir_asli =berat_akhir_asli-'1.570' WHERE kode_barang='PBDG-YLXH-15-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0004','8','PBDG-YLXH-16-0','1','2.170','TOKO','PBDG'); DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YLXH-16-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-YLXH-16-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-YLXH-16-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-YLXH-16-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-YLXH-16-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.170',berat_out_asli='2.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.170',berat_akhir_asli =berat_akhir_asli-'2.170' WHERE kode_barang='PBDG-YLXH-16-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0004','9','PBDG-YLXH-17-0','1','5.220','TOKO','PBDG'); DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YLXH-17-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-YLXH-17-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-YLXH-17-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-YLXH-17-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-YLXH-17-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.220',berat_out_asli='5.220', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.220',berat_akhir_asli =berat_akhir_asli-'5.220' WHERE kode_barang='PBDG-YLXH-17-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0004','10','PBDG-YLXH-18-0','1','5.280','TOKO','PBDG'); DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YLXH-18-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-YLXH-18-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-YLXH-18-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-YLXH-18-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-YLXH-18-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.280',berat_out_asli='5.280', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.280',berat_akhir_asli =berat_akhir_asli-'5.280' WHERE kode_barang='PBDG-YLXH-18-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0004','11','PBDG-YLXH-19-0','1','5.320','TOKO','PBDG'); DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YLXH-19-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-YLXH-19-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-YLXH-19-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-YLXH-19-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-YLXH-19-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.320',berat_out_asli='5.320', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.320',berat_akhir_asli =berat_akhir_asli-'5.320' WHERE kode_barang='PBDG-YLXH-19-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0004','12','PBDG-YLXH-20-0','1','2.840','TOKO','PBDG'); DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YLXH-20-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-YLXH-20-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-YLXH-20-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-YLXH-20-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-YLXH-20-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.840',berat_out_asli='2.840', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.840',berat_akhir_asli =berat_akhir_asli-'2.840' WHERE kode_barang='PBDG-YLXH-20-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0004','13','PBDG-YLXH-21-0','1','2.670','TOKO','PBDG'); DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YLXH-21-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-YLXH-21-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-YLXH-21-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-YLXH-21-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-YLXH-21-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.670',berat_out_asli='2.670', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.670',berat_akhir_asli =berat_akhir_asli-'2.670' WHERE kode_barang='PBDG-YLXH-21-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-251209-0004','2025-12-09','2025-12-09','14:51','2.670','input','2025-12-09 14:51:56','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0005','1','PSPLT-YLXH-7-0','1','2.080','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YLXH-7-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-YLXH-7-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-YLXH-7-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-YLXH-7-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-YLXH-7-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.080',berat_out_asli='2.080', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.080',berat_akhir_asli =berat_akhir_asli-'2.080' WHERE kode_barang='PSPLT-YLXH-7-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0005','2','PSPLT-YLXH-8-0','1','2.710','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YLXH-8-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-YLXH-8-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-YLXH-8-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-YLXH-8-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-YLXH-8-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.710',berat_out_asli='2.710', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.710',berat_akhir_asli =berat_akhir_asli-'2.710' WHERE kode_barang='PSPLT-YLXH-8-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0005','3','PSPLT-YLXI-3-0','1','1.630','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YLXI-3-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-YLXI-3-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-YLXI-3-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-YLXI-3-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-YLXI-3-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.630',berat_out_asli='1.630', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.630',berat_akhir_asli =berat_akhir_asli-'1.630' WHERE kode_barang='PSPLT-YLXI-3-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-251209-0005','2025-12-09','2025-12-09','14:57','1.630','input','2025-12-09 14:57:34','THIFA'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251209-0009','1','ABRE-YLXI-13-0','1','1.120','1.120','TOKO','SEM-BALIK','TOKO','ABRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='ABRE.BALIK' WHERE kode_barang='ABRE-YLXI-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'1.120',berat_in_asli=berat_in_asli+'1.120',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.120',berat_akhir_asli=berat_akhir_asli+'1.120' WHERE tanggal='2025-12-09' AND kode_barang='ABRE-YLXI-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.BALIK'; UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.120',berat_out_asli=berat_out_asli+'1.120',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-09' AND kode_barang='ABRE-YLXI-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251209-0009','2025-12-09','2025-12-09','15:22','1.12','input','2025-12-09 15:22:29'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251209-0010','1','AMP-YLXI-11-0','1','1.560','1.560','TOKO','SEM-EMAS','TOKO','AMPE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='AMPE.BALIK' WHERE kode_barang='AMP-YLXI-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-09','TOKO','AMPE.BALIK','AMP','AMP-YLXI-11-0','76.00','1','1.560','1.560','1','1.560','1.560'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.560',berat_out_asli=berat_out_asli+'1.560',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-09' AND kode_barang='AMP-YLXI-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251209-0010','2025-12-09','2025-12-09','15:22','1.56','input','2025-12-09 15:22:50'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251209-0011','1','CKBE-YLXI-9-0','1','1.960','1.960','TOKO','SEM-BALIK','TOKO','CKBE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CKBE.BALIK' WHERE kode_barang='CKBE-YLXI-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-09','TOKO','CKBE.BALIK','CKBE','CKBE-YLXI-9-0','75.00','1','1.960','1.960','1','1.960','1.960'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.960',berat_out_asli=berat_out_asli+'1.960',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-09' AND kode_barang='CKBE-YLXI-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251209-0011','2025-12-09','2025-12-09','15:23','1.96','input','2025-12-09 15:23:41'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251209-0012','1','LBRE-YLXI-6-0','1','1.660','1.660','TOKO','SEM-BALIK','TOKO','LBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='LBRE.BALIK' WHERE kode_barang='LBRE-YLXI-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-09','TOKO','LBRE.BALIK','LBRE','LBRE-YLXI-6-0','75.00','1','1.660','1.660','1','1.660','1.660'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.660',berat_out_asli=berat_out_asli+'1.660',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-09' AND kode_barang='LBRE-YLXI-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251209-0012','2025-12-09','2025-12-09','15:23','1.66','input','2025-12-09 15:23:56'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251209-0013','1','TFA-YLXI-7-0','1','4.290','4.290','TOKO','SEM-BALIK','TOKO','TFA.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='TFA.BALIK' WHERE kode_barang='TFA-YLXI-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-09','TOKO','TFA.BALIK','TFA','TFA-YLXI-7-0','75.00','1','4.290','4.290','1','4.290','4.290'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.290',berat_out_asli=berat_out_asli+'4.290',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-09' AND kode_barang='TFA-YLXI-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251209-0013','2025-12-09','2025-12-09','15:24','4.29','input','2025-12-09 15:24:11'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251209-0014','1','CBRE-YLXI-12-0','1','2.900','2.900','TOKO','SEM-BALIK','TOKO','CBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-YLXI-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'2.900',berat_in_asli=berat_in_asli+'2.900',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'2.900',berat_akhir_asli=berat_akhir_asli+'2.900' WHERE tanggal='2025-12-09' AND kode_barang='CBRE-YLXI-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK'; UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.900',berat_out_asli=berat_out_asli+'2.900',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-09' AND kode_barang='CBRE-YLXI-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251209-0014','2','CBRE-YLXI-10-0','1','1.380','1.380','TOKO','SEM-BALIK','TOKO','CBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-YLXI-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-09','TOKO','CBRE.BALIK','CBRE','CBRE-YLXI-10-0','75.00','1','1.380','1.380','1','1.380','1.380'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.380',berat_out_asli=berat_out_asli+'1.380',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-09' AND kode_barang='CBRE-YLXI-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251209-0014','3','CBRE-YLXI-4-0','1','1.310','1.310','TOKO','SEM-BALIK','TOKO','CBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-YLXI-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-09','TOKO','CBRE.BALIK','CBRE','CBRE-YLXI-4-0','83.00','1','1.310','1.310','1','1.310','1.310'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.310',berat_out_asli=berat_out_asli+'1.310',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-09' AND kode_barang='CBRE-YLXI-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251209-0014','4','CBRE-YLXI-14-0','1','3.510','3.510','TOKO','SEM-BALIK','TOKO','CBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-YLXI-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-09','TOKO','CBRE.BALIK','CBRE','CBRE-YLXI-14-0','75.00','1','3.510','3.510','1','3.510','3.510'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.510',berat_out_asli=berat_out_asli+'3.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-09' AND kode_barang='CBRE-YLXI-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251209-0014','5','CBRE-YLXI-8-0','1','1.800','1.800','TOKO','SEM-BALIK','TOKO','CBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-YLXI-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'1.800',berat_in_asli=berat_in_asli+'1.800',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.800',berat_akhir_asli=berat_akhir_asli+'1.800' WHERE tanggal='2025-12-09' AND kode_barang='CBRE-YLXI-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK'; UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.800',berat_out_asli=berat_out_asli+'1.800',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-09' AND kode_barang='CBRE-YLXI-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251209-0014','6','CBRE-YLXI-5-0','1','2.980','2.980','TOKO','SEM-BALIK','TOKO','CBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-YLXI-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-09','TOKO','CBRE.BALIK','CBRE','CBRE-YLXI-5-0','75.00','1','2.980','2.980','1','2.980','2.980'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.980',berat_out_asli=berat_out_asli+'2.980',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-09' AND kode_barang='CBRE-YLXI-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251209-0014','2025-12-09','2025-12-09','15:24','13.88','input','2025-12-09 15:25:20');