INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-25 ','10:15:33'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-25 ','10:37:53'); INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2026-04-25 10:47:16'); CREATE TABLE th_20260425_104716 SELECT * FROM tt_barang_stock; CREATE TABLE th_20260425_104716_lebih SELECT * FROM tt_barang_stock_lebih; DELETE FROM tt_barang_stock; DELETE FROM tt_barang_stock_lebih; DELETE FROM tt_barang_stock WHERE stock_fisik*1=0; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='GLR' AND stock_on_hand*1 =1 AND harga_jual*1 > 0; UPDATE tt_barang_stock SET tgl_taking= '2026-04-25',jam_taking= '10:47:35',input_by='kasir'; DELETE FROM tt_barang_stock WHERE stock_fisik*1=0; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='GLR' AND stock_on_hand*1 =1 AND harga_jual*1 > 0; UPDATE tt_barang_stock SET tgl_taking= '2026-04-25',jam_taking= '10:47:46',input_by='kasir'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-25 ','10:47:55'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-ZBBE-42-0' AND kode_barcode='00041828'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-ZBBE-42-0','00041828','2026-04-25',' 10:53:15','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-YKAI-44-0' AND kode_barcode='00039704'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-YKAI-44-0','00039704','2026-04-25',' 10:53:26','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-YKAI-35-0' AND kode_barcode='00039695'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-YKAI-35-0','00039695','2026-04-25',' 10:53:33','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-YKAI-33-0' AND kode_barcode='00039693'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-YKAI-33-0','00039693','2026-04-25',' 10:53:39','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-XIXF-15-0' AND kode_barcode='00031135'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-XIXF-15-0','00031135','2026-04-25',' 10:53:44','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-ZBBE-110-0' AND kode_barcode='00041896'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-ZBBE-110-0','00041896','2026-04-25',' 10:53:59','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-ZBBE-46-0' AND kode_barcode='00041832'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-ZBBE-46-0','00041832','2026-04-25',' 10:54:04','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-ZBBE-112-0' AND kode_barcode='00041898'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-ZBBE-112-0','00041898','2026-04-25',' 10:54:12','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-YCXE-97-0' AND kode_barcode='00034600'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-YCXE-97-0','00034600','2026-04-25',' 10:54:38','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-YCXF-7-0' AND kode_barcode='00034634'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-YCXF-7-0','00034634','2026-04-25',' 10:54:43','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-XLBG-19-0' AND kode_barcode='00032979'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-XLBG-19-0','00032979','2026-04-25',' 10:55:00','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-YCXE-96-0' AND kode_barcode='00034599'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-YCXE-96-0','00034599','2026-04-25',' 10:55:04','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-XLBG-66-0' AND kode_barcode='00033026'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-XLBG-66-0','00033026','2026-04-25',' 10:55:12','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-ZBBE-47-0' AND kode_barcode='00041833'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-ZBBE-47-0','00041833','2026-04-25',' 10:55:21','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-ZBBE-109-0' AND kode_barcode='00041895'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-ZBBE-109-0','00041895','2026-04-25',' 10:55:27','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-YCXE-58-0' AND kode_barcode='00034561'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-YCXE-58-0','00034561','2026-04-25',' 10:55:33','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-ZBBE-111-0' AND kode_barcode='00041897'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-ZBBE-111-0','00041897','2026-04-25',' 10:55:40','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-WIXB-1-0' AND kode_barcode='00023771'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-WIXB-1-0','00023771','2026-04-25',' 10:55:46','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-ULAD-44-0' AND kode_barcode='00010957'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-ULAD-44-0','00010957','2026-04-25',' 10:55:52','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-YCXE-95-0' AND kode_barcode='00034598'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-YCXE-95-0','00034598','2026-04-25',' 10:55:58','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-WGXH-20-0' AND kode_barcode='00022831'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-WGXH-20-0','00022831','2026-04-25',' 10:56:05','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-ZBBE-41-0' AND kode_barcode='00041827'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-ZBBE-41-0','00041827','2026-04-25',' 10:56:12','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-XLBG-18-0' AND kode_barcode='00032978'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-XLBG-18-0','00032978','2026-04-25',' 10:56:26','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-ULAD-47-0' AND kode_barcode='00010960'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-ULAD-47-0','00010960','2026-04-25',' 10:56:34','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-XLBG-17-0' AND kode_barcode='00032977'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-XLBG-17-0','00032977','2026-04-25',' 10:56:48','1','kasir'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-25 ','10:56:57'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-XLBG-12-0' AND kode_barcode='00032972'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-XLBG-12-0','00032972','2026-04-25',' 10:56:52','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-YCXE-52-0' AND kode_barcode='00034555'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-YCXE-52-0','00034555','2026-04-25',' 10:57:00','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-XLBG-133-0' AND kode_barcode='00033093'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-XLBG-133-0','00033093','2026-04-25',' 10:57:10','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-XHBA-51-0' AND kode_barcode='00030747'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-XHBA-51-0','00030747','2026-04-25',' 10:57:15','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-YHAE-128-0' AND kode_barcode='00038170'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-YHAE-128-0','00038170','2026-04-25',' 10:57:22','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-YIBC-29-0' AND kode_barcode='00038861'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-YIBC-29-0','00038861','2026-04-25',' 10:57:31','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-XLBG-14-0' AND kode_barcode='00032974'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-XLBG-14-0','00032974','2026-04-25',' 10:57:37','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-XLBG-15-0' AND kode_barcode='00032975'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-XLBG-15-0','00032975','2026-04-25',' 10:57:40','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-ZABF-37-0' AND kode_barcode='00041175'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-ZABF-37-0','00041175','2026-04-25',' 10:57:51','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-XLBG-21-0' AND kode_barcode='00032981'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-XLBG-21-0','00032981','2026-04-25',' 10:57:57','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-YKAI-45-0' AND kode_barcode='00039705'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-YKAI-45-0','00039705','2026-04-25',' 10:58:03','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-XIXF-16-0' AND kode_barcode='00031136'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-XIXF-16-0','00031136','2026-04-25',' 10:58:11','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-YKAI-34-0' AND kode_barcode='00039694'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-YKAI-34-0','00039694','2026-04-25',' 10:58:21','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-YABI-11-0' AND kode_barcode='00033769'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-YABI-11-0','00033769','2026-04-25',' 10:58:26','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-UGBH-7-0' AND kode_barcode='00007813'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-UGBH-7-0','00007813','2026-04-25',' 10:58:32','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-ZBBE-45-0' AND kode_barcode='00041831'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-ZBBE-45-0','00041831','2026-04-25',' 10:58:40','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-YKAI-30-0' AND kode_barcode='00039690'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-YKAI-30-0','00039690','2026-04-25',' 10:58:49','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-XLBG-136-0' AND kode_barcode='00033096'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-XLBG-136-0','00033096','2026-04-25',' 10:58:55','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-XLBG-53-0' AND kode_barcode='00033013'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-XLBG-53-0','00033013','2026-04-25',' 10:59:02','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-YHAE-129-0' AND kode_barcode='00038171'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-YHAE-129-0','00038171','2026-04-25',' 10:59:10','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-XLBG-16-0' AND kode_barcode='00032976'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-XLBG-16-0','00032976','2026-04-25',' 10:59:15','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-XLBG-137-0' AND kode_barcode='00033097'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-XLBG-137-0','00033097','2026-04-25',' 10:59:20','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLR-TDXC-28' AND kode_barcode='A0000045'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLR-TDXC-28','A0000045','2026-04-25',' 10:59:38','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLR-TDXC-6' AND kode_barcode='A0000023'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLR-TDXC-6','A0000023','2026-04-25',' 10:59:44','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLR-TDXC-27' AND kode_barcode='A0000044'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLR-TDXC-27','A0000044','2026-04-25',' 10:59:56','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRK-YHAE-122-0' AND kode_barcode='00038164'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRK-YHAE-122-0','00038164','2026-04-25',' 11:00:03','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLR-TDXC-14' AND kode_barcode='A0000031'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLR-TDXC-14','A0000031','2026-04-25',' 11:00:14','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRK-VLBH-8-0' AND kode_barcode='00019425'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRK-VLBH-8-0','00019425','2026-04-25',' 11:00:21','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRK-PGBG-21-0' AND kode_barcode='00016330'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRK-PGBG-21-0','00016330','2026-04-25',' 11:00:28','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRK-UIBG-104-0' AND kode_barcode='00009187'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRK-UIBG-104-0','00009187','2026-04-25',' 11:00:33','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRK-UCXH-10' AND kode_barcode='00004613'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRK-UCXH-10','00004613','2026-04-25',' 11:00:40','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRK-UIBG-105-0' AND kode_barcode='00009188'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRK-UIBG-105-0','00009188','2026-04-25',' 11:00:47','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-UCXH-28' AND kode_barcode='00004595'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-UCXH-28','00004595','2026-04-25',' 11:00:56','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLR-TDXC-21' AND kode_barcode='A0000038'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLR-TDXC-21','A0000038','2026-04-25',' 11:01:05','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRK-UCXH-15' AND kode_barcode='00004618'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRK-UCXH-15','00004618','2026-04-25',' 11:01:15','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRK-UCXH-16' AND kode_barcode='00004619'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRK-UCXH-16','00004619','2026-04-25',' 11:01:21','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRK-XKBH-6-0' AND kode_barcode='00032347'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRK-XKBH-6-0','00032347','2026-04-25',' 11:01:29','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLR-TDXC-24' AND kode_barcode='A0000041'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLR-TDXC-24','A0000041','2026-04-25',' 11:01:39','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLR-TDXC-19' AND kode_barcode='A0000036'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLR-TDXC-19','A0000036','2026-04-25',' 11:01:49','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRK-UCXH-12' AND kode_barcode='00004615'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRK-UCXH-12','00004615','2026-04-25',' 11:01:59','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLR-TDXC-18' AND kode_barcode='A0000035'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLR-TDXC-18','A0000035','2026-04-25',' 11:02:08','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRK-PIBX-14-0' AND kode_barcode='00017332'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRK-PIBX-14-0','00017332','2026-04-25',' 11:02:23','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRR-ULAD-46-0' AND kode_barcode='00010959'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRR-ULAD-46-0','00010959','2026-04-25',' 11:02:30','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRK-UIBG-102-0' AND kode_barcode='00009185'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRK-UIBG-102-0','00009185','2026-04-25',' 11:02:36','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRK-UKXE-1-0' AND kode_barcode='00010153'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRK-UKXE-1-0','00010153','2026-04-25',' 11:02:42','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRK-UFXI-1' AND kode_barcode='00006768'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRK-UFXI-1','00006768','2026-04-25',' 11:02:49','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLR-TDXC-16' AND kode_barcode='A0000033'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLR-TDXC-16','A0000033','2026-04-25',' 11:02:57','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLR-TDXC-8' AND kode_barcode='A0000025'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLR-TDXC-8','A0000025','2026-04-25',' 11:03:05','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-XAAI-24-0' AND kode_barcode='00026047'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-XAAI-24-0','00026047','2026-04-25',' 11:03:21','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLR-TDXB-10' AND kode_barcode='A0000011'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLR-TDXB-10','A0000011','2026-04-25',' 11:03:33','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-WIXB-6-0' AND kode_barcode='00023776'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-WIXB-6-0','00023776','2026-04-25',' 11:03:46','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLR-TDXB-9' AND kode_barcode='A0000010'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLR-TDXB-9','A0000010','2026-04-25',' 11:03:59','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLR-TDXB-4' AND kode_barcode='A0000004'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLR-TDXB-4','A0000004','2026-04-25',' 11:04:09','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLR-TDXC-5' AND kode_barcode='A0000022'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLR-TDXC-5','A0000022','2026-04-25',' 11:04:18','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLR-TDXB-13' AND kode_barcode='A0000014'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLR-TDXB-13','A0000014','2026-04-25',' 11:04:25','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-YCXE-56-0' AND kode_barcode='00034559'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-YCXE-56-0','00034559','2026-04-25',' 11:04:41','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-ZBBE-39-0' AND kode_barcode='00041825'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-ZBBE-39-0','00041825','2026-04-25',' 11:04:49','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-YHAE-123-0' AND kode_barcode='00038165'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-YHAE-123-0','00038165','2026-04-25',' 11:04:56','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-ZBXI-11-0' AND kode_barcode='00041422'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-ZBXI-11-0','00041422','2026-04-25',' 11:05:03','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-YHAE-126-0' AND kode_barcode='00038168'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-YHAE-126-0','00038168','2026-04-25',' 11:05:13','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLR-TDXB-3' AND kode_barcode='A0000003'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLR-TDXB-3','A0000003','2026-04-25',' 11:05:22','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-UCXH-11' AND kode_barcode='00004576'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-UCXH-11','00004576','2026-04-25',' 11:05:34','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLR-TDXC-23' AND kode_barcode='A0000040'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLR-TDXC-23','A0000040','2026-04-25',' 11:05:47','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-YHAE-124-0' AND kode_barcode='00038166'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-YHAE-124-0','00038166','2026-04-25',' 11:05:57','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-WGXD-14-0' AND kode_barcode='00022734'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-WGXD-14-0','00022734','2026-04-25',' 11:06:04','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-XLBG-26-0' AND kode_barcode='00032986'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-XLBG-26-0','00032986','2026-04-25',' 11:06:11','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-YHAE-125-0' AND kode_barcode='00038167'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-YHAE-125-0','00038167','2026-04-25',' 11:06:19','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLR-TDXB-7' AND kode_barcode='A0000008'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLR-TDXB-7','A0000008','2026-04-25',' 11:06:32','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-UCXH-12' AND kode_barcode='00004577'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-UCXH-12','00004577','2026-04-25',' 11:06:42','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-WJAI-8-0' AND kode_barcode='00024567'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-WJAI-8-0','00024567','2026-04-25',' 11:06:51','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-UHAH-18-0' AND kode_barcode='00008113'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-UHAH-18-0','00008113','2026-04-25',' 11:07:01','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-UIBG-90-0' AND kode_barcode='00009173'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-UIBG-90-0','00009173','2026-04-25',' 11:07:08','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-UKBE-5-0' AND kode_barcode='00010576'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-UKBE-5-0','00010576','2026-04-25',' 11:07:17','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-XLBG-28-0' AND kode_barcode='00032988'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-XLBG-28-0','00032988','2026-04-25',' 11:07:23','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-XBXE-4-0' AND kode_barcode='00026404'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-XBXE-4-0','00026404','2026-04-25',' 11:07:32','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-XLBG-44-0' AND kode_barcode='00033004'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-XLBG-44-0','00033004','2026-04-25',' 11:07:39','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-YHAE-127-0' AND kode_barcode='00038169'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-YHAE-127-0','00038169','2026-04-25',' 11:07:48','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-YKAI-39-0' AND kode_barcode='00039699'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-YKAI-39-0','00039699','2026-04-25',' 11:07:53','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLR-TDXB-6' AND kode_barcode='A0000007'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLR-TDXB-6','A0000007','2026-04-25',' 11:08:05','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-UCXH-5' AND kode_barcode='00004570'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-UCXH-5','00004570','2026-04-25',' 11:08:13','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLR-TDXB-12' AND kode_barcode='A0000013'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLR-TDXB-12','A0000013','2026-04-25',' 11:08:21','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-XLBF-70-0' AND kode_barcode='00032959'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-XLBF-70-0','00032959','2026-04-25',' 11:08:28','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-XAAH-80-0' AND kode_barcode='00026003'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-XAAH-80-0','00026003','2026-04-25',' 11:08:35','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-UCXH-18' AND kode_barcode='00004583'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-UCXH-18','00004583','2026-04-25',' 11:08:41','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-XBAC-16-0' AND kode_barcode='00026597'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-XBAC-16-0','00026597','2026-04-25',' 11:08:47','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLR-TDXB-2' AND kode_barcode='A0000002'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLR-TDXB-2','A0000002','2026-04-25',' 11:08:53','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='GLRP-XAAI-26-0' AND kode_barcode='00026049'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('GLRP-XAAI-26-0','00026049','2026-04-25',' 11:08:58','1','kasir'); INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08122','BARY','1','ABRE','DICROM KOMBINASI ROSEGOLD','1.040','1','0','0'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-08122','2026-04-25','2026-04-25','11:09:16','PLG0028465','kasir','2026-04-28','kasir','2026-04-25 11:09:16','1.040','0','0','0','0','0','0','0','0'); INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2026-04-25 11:10:50'); CREATE TABLE th_20260425_111050 SELECT * FROM tt_barang_stock; CREATE TABLE th_20260425_111050_lebih SELECT * FROM tt_barang_stock_lebih; DELETE FROM tt_barang_stock; DELETE FROM tt_barang_stock_lebih; INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2026-04-25 11:10:53'); CREATE TABLE th_20260425_111053 SELECT * FROM tt_barang_stock; CREATE TABLE th_20260425_111053_lebih SELECT * FROM tt_barang_stock_lebih; DELETE FROM tt_barang_stock; DELETE FROM tt_barang_stock_lebih; DELETE FROM tt_barang_stock WHERE stock_fisik*1=0; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='PERAK' AND stock_on_hand*1 =1 AND harga_jual*1 > 0; UPDATE tt_barang_stock SET tgl_taking= '2026-04-25',jam_taking= '11:11:04',input_by='kasir'; DELETE FROM tt_barang_stock WHERE stock_fisik*1=0; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='PERAK' AND stock_on_hand*1 =1 AND harga_jual*1 > 0; UPDATE tt_barang_stock SET tgl_taking= '2026-04-25',jam_taking= '11:11:14',input_by='kasir'; DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZBBG-50-0' AND kode_barcode='00042052'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZBBG-50-0','00042052','2026-04-25',' 11:12:06','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-26-0' AND kode_barcode='00042621'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-26-0','00042621','2026-04-25',' 11:12:13','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZBAX-34-0' AND kode_barcode='00041470'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZBAX-34-0','00041470','2026-04-25',' 11:12:16','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-2-0' AND kode_barcode='00042597'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-2-0','00042597','2026-04-25',' 11:12:19','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDBD-15-0' AND kode_barcode='00042775'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDBD-15-0','00042775','2026-04-25',' 11:12:23','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YLAX-30-0' AND kode_barcode='00040432'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YLAX-30-0','00040432','2026-04-25',' 11:12:26','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-36-0' AND kode_barcode='00042631'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-36-0','00042631','2026-04-25',' 11:12:32','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDBA-35-0' AND kode_barcode='00042708'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDBA-35-0','00042708','2026-04-25',' 11:12:34','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YLAX-48-0' AND kode_barcode='00040450'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YLAX-48-0','00040450','2026-04-25',' 11:12:41','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDBA-29-0' AND kode_barcode='00042702'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDBA-29-0','00042702','2026-04-25',' 11:12:43','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDBA-33-0' AND kode_barcode='00042706'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDBA-33-0','00042706','2026-04-25',' 11:12:45','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-24-0' AND kode_barcode='00042619'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-24-0','00042619','2026-04-25',' 11:12:48','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YGAA-4-0' AND kode_barcode='00037135'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YGAA-4-0','00037135','2026-04-25',' 11:12:50','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZBAC-6-0' AND kode_barcode='00041535'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZBAC-6-0','00041535','2026-04-25',' 11:12:52','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPER-TFAB-16' AND kode_barcode='00000796'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPER-TFAB-16','00000796','2026-04-25',' 11:13:01','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YLAX-12-0' AND kode_barcode='00040414'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YLAX-12-0','00040414','2026-04-25',' 11:13:07','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-34-0' AND kode_barcode='00042629'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-34-0','00042629','2026-04-25',' 11:13:09','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YLAX-16-0' AND kode_barcode='00040418'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YLAX-16-0','00040418','2026-04-25',' 11:13:16','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YLAX-32-0' AND kode_barcode='00040434'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YLAX-32-0','00040434','2026-04-25',' 11:13:17','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPER-TFAB-27' AND kode_barcode='00000807'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPER-TFAB-27','00000807','2026-04-25',' 11:13:22','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YLAX-36-0' AND kode_barcode='00040438'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YLAX-36-0','00040438','2026-04-25',' 11:13:26','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YLAX-46-0' AND kode_barcode='00040448'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YLAX-46-0','00040448','2026-04-25',' 11:13:28','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPEN-TJAD-1' AND kode_barcode='N0001121'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPEN-TJAD-1','N0001121','2026-04-25',' 11:13:34','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YHBH-28-0' AND kode_barcode='00038340'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YHBH-28-0','00038340','2026-04-25',' 11:13:38','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPER-TFAB-17' AND kode_barcode='00000797'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPER-TFAB-17','00000797','2026-04-25',' 11:13:40','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-42-0' AND kode_barcode='00042637'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-42-0','00042637','2026-04-25',' 11:13:46','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZBAX-2-0' AND kode_barcode='00041438'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZBAX-2-0','00041438','2026-04-25',' 11:13:47','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDBA-27-0' AND kode_barcode='00042700'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDBA-27-0','00042700','2026-04-25',' 11:13:50','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YLAX-44-0' AND kode_barcode='00040446'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YLAX-44-0','00040446','2026-04-25',' 11:13:54','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YHBH-30-0' AND kode_barcode='00038342'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YHBH-30-0','00038342','2026-04-25',' 11:13:57','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPER-TFXI-22' AND kode_barcode='A0000827'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPER-TFXI-22','A0000827','2026-04-25',' 11:14:01','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YJXF-8-0' AND kode_barcode='00039014'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YJXF-8-0','00039014','2026-04-25',' 11:14:03','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-40-0' AND kode_barcode='00042635'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-40-0','00042635','2026-04-25',' 11:14:09','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-46-0' AND kode_barcode='00042641'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-46-0','00042641','2026-04-25',' 11:14:13','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZAXI-20-0' AND kode_barcode='00040797'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZAXI-20-0','00040797','2026-04-25',' 11:14:17','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-38-0' AND kode_barcode='00042633'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-38-0','00042633','2026-04-25',' 11:14:20','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-UCXH-3' AND kode_barcode='00004597'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-UCXH-3','00004597','2026-04-25',' 11:14:35','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YHBH-38-0' AND kode_barcode='00038350'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YHBH-38-0','00038350','2026-04-25',' 11:14:36','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPER-TFXF-44' AND kode_barcode='A0000779'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPER-TFXF-44','A0000779','2026-04-25',' 11:14:39','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPER-TFAB-26' AND kode_barcode='00000806'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPER-TFAB-26','00000806','2026-04-25',' 11:14:41','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YLAX-4-0' AND kode_barcode='00040406'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YLAX-4-0','00040406','2026-04-25',' 11:14:43','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPER-TFXF-30' AND kode_barcode='A0000765'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPER-TFXF-30','A0000765','2026-04-25',' 11:14:46','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZBAX-22-0' AND kode_barcode='00041458'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZBAX-22-0','00041458','2026-04-25',' 11:14:53','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-30-0' AND kode_barcode='00042625'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-30-0','00042625','2026-04-25',' 11:15:01','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-UBXD-23' AND kode_barcode='00003926'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-UBXD-23','00003926','2026-04-25',' 11:15:04','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPER-TFXF-19' AND kode_barcode='A0000754'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPER-TFXF-19','A0000754','2026-04-25',' 11:15:08','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDBD-13-0' AND kode_barcode='00042773'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDBD-13-0','00042773','2026-04-25',' 11:15:10','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZAAF-37-0' AND kode_barcode='00040974'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZAAF-37-0','00040974','2026-04-25',' 11:15:12','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-39-0' AND kode_barcode='00042634'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-39-0','00042634','2026-04-25',' 11:15:16','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-27-0' AND kode_barcode='00042622'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-27-0','00042622','2026-04-25',' 11:15:19','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZBAC-8-0' AND kode_barcode='00041537'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZBAC-8-0','00041537','2026-04-25',' 11:15:25','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-33-0' AND kode_barcode='00042628'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-33-0','00042628','2026-04-25',' 11:15:36','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDBA-31-0' AND kode_barcode='00042704'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDBA-31-0','00042704','2026-04-25',' 11:15:48','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZBAX-6-0' AND kode_barcode='00041442'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZBAX-6-0','00041442','2026-04-25',' 11:15:56','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-35-0' AND kode_barcode='00042630'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-35-0','00042630','2026-04-25',' 11:16:09','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZBAC-1-0' AND kode_barcode='00041530'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZBAC-1-0','00041530','2026-04-25',' 11:16:23','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YHBH-10-0' AND kode_barcode='00038322'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YHBH-10-0','00038322','2026-04-25',' 11:16:39','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDBA-26-0' AND kode_barcode='00042699'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDBA-26-0','00042699','2026-04-25',' 11:16:45','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YJXF-5-0' AND kode_barcode='00039011'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YJXF-5-0','00039011','2026-04-25',' 11:16:51','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDBD-14-0' AND kode_barcode='00042774'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDBD-14-0','00042774','2026-04-25',' 11:17:00','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YLAX-39-0' AND kode_barcode='00040441'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YLAX-39-0','00040441','2026-04-25',' 11:17:04','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZAAF-38-0' AND kode_barcode='00040975'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZAAF-38-0','00040975','2026-04-25',' 11:17:09','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-43-0' AND kode_barcode='00042638'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-43-0','00042638','2026-04-25',' 11:17:49','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YJXF-9-0' AND kode_barcode='00039015'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YJXF-9-0','00039015','2026-04-25',' 11:17:53','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZBBD-6-0' AND kode_barcode='00041752'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZBBD-6-0','00041752','2026-04-25',' 11:17:57','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YLAX-9-0' AND kode_barcode='00040411'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YLAX-9-0','00040411','2026-04-25',' 11:18:02','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YJXF-17-0' AND kode_barcode='00039023'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YJXF-17-0','00039023','2026-04-25',' 11:18:06','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDBA-28-0' AND kode_barcode='00042701'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDBA-28-0','00042701','2026-04-25',' 11:18:10','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZBAC-13-0' AND kode_barcode='00041542'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZBAC-13-0','00041542','2026-04-25',' 11:18:14','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YHBH-33-0' AND kode_barcode='00038345'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YHBH-33-0','00038345','2026-04-25',' 11:18:18','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YJXF-15-0' AND kode_barcode='00039021'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YJXF-15-0','00039021','2026-04-25',' 11:18:22','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YHBH-9-0' AND kode_barcode='00038321'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YHBH-9-0','00038321','2026-04-25',' 11:18:26','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YLAX-35-0' AND kode_barcode='00040437'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YLAX-35-0','00040437','2026-04-25',' 11:18:31','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZBAX-33-0' AND kode_barcode='00041469'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZBAX-33-0','00041469','2026-04-25',' 11:18:35','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YLAX-43-0' AND kode_barcode='00040445'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YLAX-43-0','00040445','2026-04-25',' 11:18:40','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZBAX-27-0' AND kode_barcode='00041463'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZBAX-27-0','00041463','2026-04-25',' 11:18:44','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-3-0' AND kode_barcode='00042598'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-3-0','00042598','2026-04-25',' 11:18:50','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZBAX-29-0' AND kode_barcode='00041465'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZBAX-29-0','00041465','2026-04-25',' 11:18:56','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPER-TFAB-42' AND kode_barcode='00000822'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPER-TFAB-42','00000822','2026-04-25',' 11:19:04','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YLAX-7-0' AND kode_barcode='00040409'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YLAX-7-0','00040409','2026-04-25',' 11:19:08','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZBBG-44-0' AND kode_barcode='00042046'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZBBG-44-0','00042046','2026-04-25',' 11:19:15','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-UBAI-3' AND kode_barcode='00004153'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-UBAI-3','00004153','2026-04-25',' 11:19:19','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YJXF-3-0' AND kode_barcode='00039009'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YJXF-3-0','00039009','2026-04-25',' 11:19:24','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YJXF-7-0' AND kode_barcode='00039013'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YJXF-7-0','00039013','2026-04-25',' 11:19:29','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDBA-34-0' AND kode_barcode='00042707'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDBA-34-0','00042707','2026-04-25',' 11:19:34','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZBAX-3-0' AND kode_barcode='00041439'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZBAX-3-0','00041439','2026-04-25',' 11:19:38','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YFCX-17-0' AND kode_barcode='00036818'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YFCX-17-0','00036818','2026-04-25',' 11:19:44','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZBAC-19-0' AND kode_barcode='00041548'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZBAC-19-0','00041548','2026-04-25',' 11:19:49','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZBAC-15-0' AND kode_barcode='00041544'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZBAC-15-0','00041544','2026-04-25',' 11:19:53','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YJXF-13-0' AND kode_barcode='00039019'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YJXF-13-0','00039019','2026-04-25',' 11:20:00','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZAXI-21-0' AND kode_barcode='00040798'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZAXI-21-0','00040798','2026-04-25',' 11:20:05','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDBD-12-0' AND kode_barcode='00042772'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDBD-12-0','00042772','2026-04-25',' 11:20:11','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-25-0' AND kode_barcode='00042620'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-25-0','00042620','2026-04-25',' 11:20:15','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPER-TFAB-39' AND kode_barcode='00000819'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPER-TFAB-39','00000819','2026-04-25',' 11:20:20','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-PGXA-23-0' AND kode_barcode='00015750'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-PGXA-23-0','00015750','2026-04-25',' 11:20:28','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZBAC-17-0' AND kode_barcode='00041546'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZBAC-17-0','00041546','2026-04-25',' 11:20:33','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YLAX-19-0' AND kode_barcode='00040421'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YLAX-19-0','00040421','2026-04-25',' 11:20:39','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZBAX-36-0' AND kode_barcode='00041472'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZBAX-36-0','00041472','2026-04-25',' 11:20:43','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZAAF-36-0' AND kode_barcode='00040973'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZAAF-36-0','00040973','2026-04-25',' 11:20:47','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-37-0' AND kode_barcode='00042632'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-37-0','00042632','2026-04-25',' 11:20:51','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YLAX-33-0' AND kode_barcode='00040435'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YLAX-33-0','00040435','2026-04-25',' 11:20:55','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-45-0' AND kode_barcode='00042640'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-45-0','00042640','2026-04-25',' 11:20:59','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YLAX-45-0' AND kode_barcode='00040447'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YLAX-45-0','00040447','2026-04-25',' 11:21:04','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDBA-30-0' AND kode_barcode='00042703'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDBA-30-0','00042703','2026-04-25',' 11:21:11','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YLAX-49-0' AND kode_barcode='00040451'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YLAX-49-0','00040451','2026-04-25',' 11:21:15','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YLAX-41-0' AND kode_barcode='00040443'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YLAX-41-0','00040443','2026-04-25',' 11:21:19','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YHBH-37-0' AND kode_barcode='00038349'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YHBH-37-0','00038349','2026-04-25',' 11:21:25','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-29-0' AND kode_barcode='00042624'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-29-0','00042624','2026-04-25',' 11:21:30','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-1-0' AND kode_barcode='00042596'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-1-0','00042596','2026-04-25',' 11:21:36','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YLAX-5-0' AND kode_barcode='00040407'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YLAX-5-0','00040407','2026-04-25',' 11:21:40','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-ZDAF-31-0' AND kode_barcode='00042626'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-ZDAF-31-0','00042626','2026-04-25',' 11:21:47','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPER-TFAB-3' AND kode_barcode='00000783'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPER-TFAB-3','00000783','2026-04-25',' 11:22:39','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPER-TFBX-8' AND kode_barcode='00000854'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPER-TFBX-8','00000854','2026-04-25',' 11:22:41','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-XECX-32-0' AND kode_barcode='00028732'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-XECX-32-0','00028732','2026-04-25',' 11:22:45','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-PHXC-23-0' AND kode_barcode='00016456'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-PHXC-23-0','00016456','2026-04-25',' 11:22:47','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YHBH-32-0' AND kode_barcode='00038344'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YHBH-32-0','00038344','2026-04-25',' 11:22:50','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YHBH-36-0' AND kode_barcode='00038348'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YHBH-36-0','00038348','2026-04-25',' 11:22:52','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YJXF-14-0' AND kode_barcode='00039020'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YJXF-14-0','00039020','2026-04-25',' 11:22:55','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-PFBH-14-0' AND kode_barcode='00015645'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-PFBH-14-0','00015645','2026-04-25',' 11:22:57','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-TLAA-3' AND kode_barcode='00002847'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-TLAA-3','00002847','2026-04-25',' 11:23:01','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YHBH-34-0' AND kode_barcode='00038346'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YHBH-34-0','00038346','2026-04-25',' 11:23:08','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPER-TFBX-2' AND kode_barcode='00000848'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPER-TFBX-2','00000848','2026-04-25',' 11:23:11','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YFCX-19-0' AND kode_barcode='00036820'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YFCX-19-0','00036820','2026-04-25',' 11:23:19','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-UFBC-55-0' AND kode_barcode='00007085'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-UFBC-55-0','00007085','2026-04-25',' 11:23:27','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YJXF-11-0' AND kode_barcode='00039017'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YJXF-11-0','00039017','2026-04-25',' 11:23:32','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YJXF-19-0' AND kode_barcode='00039025'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YJXF-19-0','00039025','2026-04-25',' 11:23:36','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-TLBC-6' AND kode_barcode='00003200'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-TLBC-6','00003200','2026-04-25',' 11:23:39','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPER-TFXI-8' AND kode_barcode='A0000795'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPER-TFXI-8','A0000795','2026-04-25',' 11:23:45','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-PFBA-47-0' AND kode_barcode='00015465'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-PFBA-47-0','00015465','2026-04-25',' 11:23:51','1','kasir'); DELETE FROM tt_barang_stock WHERE kode_barang='CKPRE-YHBH-35-0' AND kode_barcode='00038347'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPRE-YHBH-35-0','00038347','2026-04-25',' 11:23:56','1','kasir'); UPDATE tm_credit_card SET nama_customer='-',no_ktp='-',alamat1=' - ' ,alamat2=' - ' ,kota= ' - ' ,no_telp='-',tgl_valid_until='-',tgl_last_gesek='2026-04-25 11:24:05' WHERE id_card = '--'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260425-0001','kasir','1',' CBRE-05669','TOKO','CBR','CBRE-ZBBE-5-0','CINCIN CBRE-05669 ','','3.200','1','75.00','12995000','5693000','333','17100','17500000','0','0','0','17500000','FIR','00041791','CBRE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-ZBBE-5-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.200',berat_jual_asli=berat_jual_asli+'3.200',stock_jual='1',berat_akhir=berat_akhir-'3.200',berat_akhir_asli=berat_akhir_asli-'3.200',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='CBRE-ZBBE-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260425-0001','2026-04-25','3.200','2026-04-25','11:24:06','PLG0028466','17500000','17500000','0','17500000','0','kasir','2026-04-25 11:24:05','FE-260425-0001','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','FE-260425-0001','2026-04-25','11:24:06','FIR','17500000','0'); INSERT INTO tt_debet(no_trx,tgl_system,tgl_trx,deskripsi,id_card,kode_bank,jml_cash_rp,debet_rp,debet_fee_rp) VALUES ('DC-260425-0001','2026-04-25','2026-04-25 11:24:05','PENJUALAN : FE-260425-0001','','BCD','17500000','17500000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260425-0002','D','2026-04-25','11:24:06','BCD','PENJUALAN BERLIAN','FE-260425-0001','15022321700','17500000','15039821700','DEBET'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='17500000',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FE-260425-0001' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260425-0001'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08123','FIR','1','CBRE05669','JD NO 16 CROM ROSEGOLD','3.200','1','200000','200000'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-08123','2026-04-25','2026-04-25','11:27:56','PLG0028467','kasir','2026-04-28','kasir','2026-04-25 11:27:56','3.200','200000','0','0','0','0','200000','200000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260425-0002','D','2026-04-25','11:27:56','kasir','SERVICE','SV-08123','3190940','200000','3390940'); UPDATE tt_service_head SET tgl_selesai='2026-04-25', status ='DONE' WHERE no_service='SV-08121'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-08121'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-04-25', status ='CLOS' WHERE no_service='SV-08121'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-08121'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260425-0002','kasir','1',' CKBE-00981','TOKO','CKB','CKBE-XHAB-1-0','CINCIN KAWIN CKBE-00981','','3.080','1','83.00','8520000','889000','52','17100','10000000','0','0','0','10000000','ILU','00030508','CKBE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKBE-XHAB-1-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.080',berat_jual_asli=berat_jual_asli+'3.080',stock_jual='1',berat_akhir=berat_akhir-'3.080',berat_akhir_asli=berat_akhir_asli-'3.080',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='CKBE-XHAB-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CKB' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260425-0002','2026-04-25','3.080','2026-04-25','12:34:02','PLG0028468','10000000','10000000','0','10000000','0','kasir','2026-04-25 12:34:02','FE-260425-0002','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','FE-260425-0002','2026-04-25','12:34:02','ILU','10000000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260425-0001','2026-04-25','2026-04-25 12:34:02','PENJUALAN : FE-260425-0002','','TBC','10000000','10000000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260425-0002','D','2026-04-25','12:34:02','TBC','PENJUALAN BERLIAN','FE-260425-0002','96654502385','10000000','96664502385','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='10000000' WHERE no_faktur_jual='FE-260425-0002' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260425-0002'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08124','ILU','1','CKBE00981','CKBE GRF ARBI CROM PUTIH DOF AMPLAS DAN CWO GRF YANA CROM PUTIH DOF AMPLAS','3.080','1','0','0'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-08124','2026-04-25','2026-04-25','12:36:57','PLG0028469','kasir','2026-04-28','kasir','2026-04-25 12:36:57','3.080','0','0','0','0','0','0','0','0'); UPDATE tt_service_head SET tgl_selesai='2026-04-25', status ='DONE' WHERE no_service='SV-08113'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-08113'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-04-25', status ='CLOS' WHERE no_service='SV-08113'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-08113'; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260425-0003','K','2026-04-25','14:23:19','kasir','BELANJA','VITAMIN KUKU','3390940','15000','3375940'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260425-0003','kasir','1',' DP-02978 ','TOKO','PSN','PSPLE-ZDBX-4-0','CINCIN PALADIUM ','','2.400','1','32.00','1015000','0','0','17100','2200000','0','0','0','2200000','ILU','00042665','PSPLE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLE-ZDBX-4-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.400',berat_jual_asli=berat_jual_asli+'2.400',stock_jual='1',berat_akhir=berat_akhir-'2.400',berat_akhir_asli=berat_akhir_asli-'2.400',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='PSPLE-ZDBX-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260425-0003','2026-04-25','2.400','2026-04-25','14:52:22','PLG0028470','2200000','2200000','0','2200000','0','kasir','2026-04-25 14:52:21','FE-260425-0003','DP-02978','1200000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','FE-260425-0003','2026-04-25','14:52:22','ILU','2200000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260425-0002','2026-04-25','2026-04-25 14:52:21','PENJUALAN : FE-260425-0003','','TBC','2200000','2200000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260425-0003','D','2026-04-25','14:52:22','TBC','PENJUALAN','FE-260425-0003','96664502385','2200000','96666702385','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2200000' WHERE no_faktur_jual='FE-260425-0003' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260425-0004','kasir',' 1',' DP-02979 ','TOKO','PSN','PSPLE-ZDBB-38-0','CINCIN PALADIUM ','','3.720','1','32.00','1572000','0','0','17100','2670000','0','0','0','2670000','ILU','00042758','PSPLE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLE-ZDBB-38-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.720',berat_jual_asli=berat_jual_asli+'3.720',stock_jual='1',berat_akhir=berat_akhir-'3.720',berat_akhir_asli=berat_akhir_asli-'3.720',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='PSPLE-ZDBB-38-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260425-0004','2026-04-25','3.720','2026-04-25','14:52:22','PLG0028471','2670000','2670000','0','2670000','0','kasir','2026-04-25 14:52:21','FE-260425-0003','DP-02979','1300000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','FE-260425-0004','2026-04-25','14:52:22','ILU','2670000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2200000' WHERE no_faktur_jual='FE-260425-0004' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260425-0003'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260425-0004'; INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009198','X-00009198','CINCIN CBRE-06417','GR','---','CBRE','BELI','BELI001','6240000','2026-04-25','2.040','1','kasir','2026-04-25 15:02:53'); DELETE FROM tp_barang WHERE kode_dept = 'X-CBRE'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBRE','X-00009198','X-00009198'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-260425-0001','FE-250208-0003','NANA','1','BELI','BELI001','CBRE', 'X-00009198', 'CINCIN CBRE-06417','2.040','2.040','75.00','7800000','6240000','3058824','1','6240000','6240000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.040',berat_beli_asli=berat_beli_asli+'2.040',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.040',berat_akhir_asli=berat_akhir_asli+'2.040',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CBRE' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('BE-260425-0001','2026-04-25','2026-04-25','15:02:53','NANA','---','2.040','6240000','6240000','6240000','6240000','6240000','kasir','2026-04-25 15:02:53','BE-260425-0001','OPEN','TRANSFER'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260425-0001','RANI CEIN','-','','','-','kasir','2026-04-25 15:02:53'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260425-0003','2026-04-25','2026-04-25 15:02:53','PEMBELIAN UMUM : BE-260425-0001','-','TBC','6240000','6240000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-260425-0004','K','2026-04-25','15:02:53','TBC','PEMBELIAN UMUM','BE-260425-0001','96666702385','6240000','96660462385','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-',''); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260425-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260425-0001'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260425-0005','kasir','1',' CBRE-06629','TOKO','CBR','CBRE-ZDAD-13-0','CINCIN CBRE-06629 ','','1.330','1','83.00','4822000','1513000','88','17100','6100000','0','0','0','6100000','BARY','00042519','CBRE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-ZDAD-13-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.330',berat_jual_asli=berat_jual_asli+'1.330',stock_jual='1',berat_akhir=berat_akhir-'1.330',berat_akhir_asli=berat_akhir_asli-'1.330',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='CBRE-ZDAD-13-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260425-0005','2026-04-25','1.330','2026-04-25','16:02:37','PLG0028472','6100000','6100000','0','6100000','0','kasir','2026-04-25 16:02:36','FE-260425-0005','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','FE-260425-0005','2026-04-25','16:02:37','BARY','6100000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260425-0004','2026-04-25','2026-04-25 16:02:36','PENJUALAN : FE-260425-0005','','TBC','6100000','6100000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260425-0005','D','2026-04-25','16:02:37','TBC','PENJUALAN BERLIAN','FE-260425-0005','96660462385','6100000','96666562385','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='6100000' WHERE no_faktur_jual='FE-260425-0005' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260425-0006','kasir',' 1',' CKPDE-0007','TOKO','CKPDE','CKPDE-ZBBC-78-0','CINCIN KAWIN CKPDE-00073 ','','4.700','1','17.00','1055000','0','0','17100','2100000','0','0','0','2100000','BARY','00041739','CKPDE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPDE-ZBBC-78-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.700',berat_jual_asli=berat_jual_asli+'4.700',stock_jual='1',berat_akhir=berat_akhir-'4.700',berat_akhir_asli=berat_akhir_asli-'4.700',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='CKPDE-ZBBC-78-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CKPDE' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260425-0006','2026-04-25','4.700','2026-04-25','16:02:37','PLG0028473','2100000','2100000','0','2100000','0','kasir','2026-04-25 16:02:36','FE-260425-0005','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','FE-260425-0006','2026-04-25','16:02:37','BARY','2100000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260425-0005','2026-04-25','2026-04-25 16:02:36','PENJUALAN : FE-260425-0006','','TBC','2100000','2100000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260425-0006','D','2026-04-25','16:02:37','TBC','PENJUALAN','FE-260425-0006','96666562385','2100000','96668662385','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='8200000' WHERE no_faktur_jual='FE-260425-0006' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260425-0007','kasir','1',' CBRE-06635','TOKO','CBR','CBRE-ZBBE-8-0','CINCIN CBRE-06635 ','','1.880','1','83.00','6083000','1550500','91','17100','7800000','0','0','0','7800000','BARY','00041794','CBRE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-ZBBE-8-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.880',berat_jual_asli=berat_jual_asli+'1.880',stock_jual='1',berat_akhir=berat_akhir-'1.880',berat_akhir_asli=berat_akhir_asli-'1.880',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='CBRE-ZBBE-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260425-0007','2026-04-25','1.880','2026-04-25','16:04:32','PLG0028474','7800000','7800000','0','7800000','0','kasir','2026-04-25 16:04:31','FE-260425-0007','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','FE-260425-0007','2026-04-25','16:04:32','BARY','7800000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260425-0006','2026-04-25','2026-04-25 16:04:31','PENJUALAN : FE-260425-0007','','TBC','7800000','7800000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260425-0007','D','2026-04-25','16:04:32','TBC','PENJUALAN BERLIAN','FE-260425-0007','96668662385','7800000','96676462385','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='7800000' WHERE no_faktur_jual='FE-260425-0007' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260425-0005'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260425-0006'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260425-0007'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08125','BARY','1','CBRE DAN PALADIUM','CBRE06629 KECILIN SETENGAH NOMOR DAN CBRE06635 BESARI SETENGAH NOMOR GRF ALMAS FADHANI DAN CWO GRF MAHADEWI CROM SEMUA NYA FULL PUTIH DOF AMPLAS','7.910','3','0','0'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-08125','2026-04-25','2026-04-25','16:13:57','PLG0028475','kasir','2026-04-28','kasir','2026-04-25 16:13:57','7.910','0','0','0','0','0','0','0','0'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009199','X-00009199','CBRE03220','GR','---','CBR','BELI','BELI001','9100000','2026-04-25','3.780','1','kasir','2026-04-25 16:49:09'); DELETE FROM tp_barang WHERE kode_dept = 'X-CBR'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBR','X-00009199','X-00009199'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-260425-0002','0001782','BARY','1','BELI','BELI001','CBR', 'X-00009199', 'CBRE03220','3.780','3.780','75.00','11500000','9100000','2407407','1','9100000','9100000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.780',berat_beli_asli=berat_beli_asli+'3.780',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.780',berat_akhir_asli=berat_akhir_asli+'3.780',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CBR' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('BE-260425-0002','2026-04-25','2026-04-25','16:49:08','BARY','---','3.780','9100000','9100000','9100000','9100000','9100000','kasir','2026-04-25 16:49:09','BE-260425-0002','OPEN','TRANSFER'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260425-0002','-','-','','','','kasir','2026-04-25 16:49:09'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260425-0007','2026-04-25','2026-04-25 16:49:09','PEMBELIAN UMUM : BE-260425-0002','-','TBC','9100000','9100000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-260425-0008','K','2026-04-25','16:49:08','TBC','PEMBELIAN UMUM','BE-260425-0002','96676462385','9100000','96667362385','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-',''); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-25 ','16:58:21'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260425-0008','kasir','1',' CMRE75-85%','TOKO','CMP','CMR-YHAE-132-0','CINCIN MAS ROSE GOLD ','','1.350','1','85.00','2986000','0','0','17100','3040000','0','0','0','3040000','FAISAL','00038174','CMR','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CMR-YHAE-132-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.350',berat_jual_asli=berat_jual_asli+'1.350',stock_jual='1',berat_akhir=berat_akhir-'1.350',berat_akhir_asli=berat_akhir_asli-'1.350',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='CMR-YHAE-132-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CMP' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260425-0008','2026-04-25','1.350','2026-04-25','16:59:16','PLG0028476','3040000','3040000','0','3040000','0','kasir','2026-04-25 16:59:16','FE-260425-0008','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','FE-260425-0008','2026-04-25','16:59:16','FAISAL','3040000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260425-0008','2026-04-25','2026-04-25 16:59:16','PENJUALAN : FE-260425-0008','','TBC','3040000','3040000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260425-0009','D','2026-04-25','16:59:16','TBC','PENJUALAN','FE-260425-0008','96667362385','3040000','96670402385','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3040000' WHERE no_faktur_jual='FE-260425-0008' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260425-0009','kasir',' 1',' 500K-23-10','TOKO','PERAK','CKPRE-ZDBD-14-0','CINCIN SILVER 925 ','','2.080','1','100.00','213000','0','0','17100','600000','0','0','0','600000','FAISAL','00042774','CKPRE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-ZDBD-14-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='CKPRE-ZDBD-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PERAK' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260425-0009','2026-04-25','2.080','2026-04-25','16:59:16','PLG0028477','600000','600000','0','600000','0','kasir','2026-04-25 16:59:16','FE-260425-0008','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','FE-260425-0009','2026-04-25','16:59:16','FAISAL','600000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260425-0009','2026-04-25','2026-04-25 16:59:16','PENJUALAN : FE-260425-0009','','TBC','600000','600000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260425-0010','D','2026-04-25','16:59:16','TBC','PENJUALAN','FE-260425-0009','96670402385','600000','96671002385','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3640000' WHERE no_faktur_jual='FE-260425-0009' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260425-0008'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260425-0009'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08126','DINA','1','CINCIN SILVER','JD NO 18 GRF ROS ANDI CROM PUTIH DOF AMPLAS','2.080','1','0','0'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-08126','2026-04-25','2026-04-25','17:02:45','PLG0028478','kasir','2026-04-28','kasir','2026-04-25 17:02:45','2.080','0','0','0','0','0','0','0','0'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260425-0010','kasir','1',' CBRE-00110','TOKO','CBR','CBRE-ZCAA-5-0','CINCIN CBRE-00110 ','','0.600','1','83.00','2244000','769500','45','17100','3200000','0','0','0','3200000','ILU','00042241','CBRE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-ZCAA-5-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='CBRE-ZCAA-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260425-0010','2026-04-25','0.600','2026-04-25','17:08:29','PLG0028479','3200000','3200000','0','3200000','0','kasir','2026-04-25 17:08:28','FE-260425-0010','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','FE-260425-0010','2026-04-25','17:08:29','ILU','3200000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260425-0010','2026-04-25','2026-04-25 17:08:28','PENJUALAN : FE-260425-0010','','TBC','3200000','3200000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260425-0011','D','2026-04-25','17:08:29','TBC','PENJUALAN BERLIAN','FE-260425-0010','96671002385','3200000','96674202385','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3200000' WHERE no_faktur_jual='FE-260425-0010' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260425-0010'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-25 ','17:15:56'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-25 ','17:57:02'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009200','X-00009200','LBRE00390','GR','---','LBR','BELI','BELI001','2655200','2026-04-25','0.820','1','kasir','2026-04-25 17:57:39'); DELETE FROM tp_barang WHERE kode_dept = 'X-LBR'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-LBR','X-00009200','X-00009200'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-260425-0003','-','ILU','1','BELI','BELI001','LBR', 'X-00009200', 'LBRE00390','0.820','0.820','75.00','3319000','2655200','3238049','1','2655200','2655200','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.820',berat_beli_asli=berat_beli_asli+'0.820',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.820',berat_akhir_asli=berat_akhir_asli+'0.820',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='LBR' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('BE-260425-0003','2026-04-25','2026-04-25','17:57:38','ILU','---','0.820','2655200','2655200','2655200','2655200','2655200','kasir','2026-04-25 17:57:39','BE-260425-0003','OPEN','TRANSFER'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260425-0003','-','-','','','','kasir','2026-04-25 17:57:39'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260425-0011','2026-04-25','2026-04-25 17:57:39','PEMBELIAN UMUM : BE-260425-0003','-','TBC','2655200','2655200'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-260425-0012','K','2026-04-25','17:57:38','TBC','PEMBELIAN UMUM','BE-260425-0003','96674202385','2655200','96671547185','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-',''); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260425-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260425-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260425-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260425-0003'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260425-0011','kasir','1',' CBRE-06702','TOKO','CBR','CBRE-ZDBB-19-0','CINCIN CBRE-06702 ','','1.420','1','83.00','6651000','2981000','174','17100','7500000','0','0','0','7500000','ONLBARRY','00042739','CBRE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-ZDBB-19-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.420',berat_jual_asli=berat_jual_asli+'1.420',stock_jual='1',berat_akhir=berat_akhir-'1.420',berat_akhir_asli=berat_akhir_asli-'1.420',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='CBRE-ZDBB-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260425-0011','2026-04-25','1.420','2026-04-25','18:00:44','PLG0028480','7500000','7500000','0','7500000','0','kasir','2026-04-25 18:00:44','FE-260425-0011','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','FE-260425-0011','2026-04-25','18:00:44','ONLBARRY','7500000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260425-0012','2026-04-25','2026-04-25 18:00:44','PENJUALAN : FE-260425-0011','','TBC','7500000','7500000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260425-0013','D','2026-04-25','18:00:44','TBC','PENJUALAN BERLIAN','FE-260425-0011','96671547185','7500000','96679047185','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='7500000' WHERE no_faktur_jual='FE-260425-0011' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260425-0011'; UPDATE tt_service_head SET tgl_selesai='2026-04-25', status ='DONE' WHERE no_service='SV-08115'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-08115'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-04-25', status ='CLOS' WHERE no_service='SV-08115'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-08115'; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260425-0004','K','2026-04-25','18:25:01','kasir','KIRIM PAKET','JNE TANGGERANG','3375940','18000','3357940'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260425-0005','K','2026-04-25','18:25:53','kasir','KIRIM PAKET','JNE PADANG','3357940','32000','3325940'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260425-0006','K','2026-04-25','18:29:09','kasir','KAS BESAR','UANG PARKIR MITA','3325940','50000','3275940'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260425-0007','D','2026-04-25','18:30:01','kasir','KAS BESAR','SV08113','3275940','1750000','5025940'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260425-0012','kasir','1',' CBRE-06475','TOKO','CBR','CBRE-ZDAC-23-0','CBRE-06475 GIA 7313 GIA 5170 ','','1.960','1','83.00','17743000','11899500','696','17100','20000000','0','0','0','20000000','BARY','00042490','CBRE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-ZDAC-23-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.960',berat_jual_asli=berat_jual_asli+'1.960',stock_jual='1',berat_akhir=berat_akhir-'1.960',berat_akhir_asli=berat_akhir_asli-'1.960',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='CBRE-ZDAC-23-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260425-0012','2026-04-25','1.960','2026-04-25','19:53:40','PLG0028481','20000000','20000000','0','20000000','0','kasir','2026-04-25 19:53:39','FE-260425-0012','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','FE-260425-0012','2026-04-25','19:53:40','BARY','20000000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260425-0013','2026-04-25','2026-04-25 19:53:39','PENJUALAN : FE-260425-0012','','TBC','20000000','20000000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260425-0014','D','2026-04-25','19:53:40','TBC','PENJUALAN BERLIAN','FE-260425-0012','96679047185','20000000','96699047185','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='20000000' WHERE no_faktur_jual='FE-260425-0012' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260425-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260425-0012'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08127','BARY','1','CBRE06475','DIBESARIN JD NO 21 CROM PUTIH HARGA KONFIRMASI','4.200','2','0','0'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-08127','2026-04-25','2026-04-25','19:58:16','PLG0028482','kasir','2026-04-28','kasir','2026-04-25 19:58:16','4.200','0','0','0','0','0','0','0','0'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-26','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-26'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-25'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-25'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-04-25' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-25'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-25'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-25'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-25'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03'; UPDATE tt_barang_saldo SET tanggal= '2026-04-26' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-25' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','TBC','SALDO AWAL','SALDO AWAL','0','96699047185','96699047185'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','BCD','SALDO AWAL','SALDO AWAL','0','15039821700','15039821700'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','TMR','SALDO AWAL','SALDO AWAL','0','8689183779','8689183779'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','BNI','SALDO AWAL','SALDO AWAL','0','84527900','84527900'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','SHO','SALDO AWAL','SALDO AWAL','0','2747005684','2747005684'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','4000000','SALDO AWAL','SALDO AWAL','0','0','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','3450000','SALDO AWAL','SALDO AWAL','0','0','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','BCA','SALDO AWAL','SALDO AWAL','0','0','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','6000000','SALDO AWAL','SALDO AWAL','0','0','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','MANDIRI','SALDO AWAL','SALDO AWAL','0','295387450','295387450'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','KET','SALDO AWAL','SALDO AWAL','0','130319250','130319250'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','','SALDO AWAL','SALDO AWAL','0','16885500','16885500'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','DPE','SALDO AWAL','SALDO AWAL','0','226012000','226012000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260426-0001','D','2026-04-26','20:18:46','BCK','SALDO AWAL','SALDO AWAL','0','16534707978.088','16534707978.088'); UPDATE tp_system SET tgl_system='2026-04-26';