Kafdrop

{"id":"8ea3e3d9-ef4b-4012-9320-2b7488bd64f9","sql":"update jupviecnoibo.databasechangeloglock set locked = 1, lockedby = 'report-7d879db7bd-4q77m (10.42.3.29)', lockgranted = '2025-11-29 22:12:22.041' where id = 1 and locked = 0","binlogFileName":"mysql-bin.000167","binlogPos":102518848,"createdDate":1764429142}

{"id":"0dbe3377-5c1e-4fe5-9009-420de1bf5eca","sql":"update jupviecnoibo.databasechangeloglock set locked = 0, lockedby = null, lockgranted = null where id = 1","binlogFileName":"mysql-bin.000167","binlogPos":102519172,"createdDate":1764429144}

{"id":"015fb59d-6bf8-41a1-9f52-459b81797894","sql":"update notifications.databasechangeloglock set locked = 1, lockedby = 'notification-5cc656894b-gh7cn (10.42.3.28)', lockgranted = '2025-11-29 22:12:28.505' where id = 1 and locked = 0","binlogFileName":"mysql-bin.000167","binlogPos":102519426,"createdDate":1764429148}

{"id":"d0c0b9b8-ad03-4a27-8534-ff9a125d9945","sql":"update notifications.databasechangeloglock set locked = 0, lockedby = null, lockgranted = null where id = 1","binlogFileName":"mysql-bin.000167","binlogPos":102519758,"createdDate":1764429150}

{"id":"b4d95c0a-2f68-4fc0-a00b-3f4db57034ba","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.073000', updated_by='svc_client', active=1, ancestorjobid=6993, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=67202, contracttype=2, holidaycontract=0, leaderid=142381, periodtype=-1, productpackageid=1, requiredleader=1, customerid=142260, customername='thanh18', customerphone='0961990018', customersegmentid=2, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t4, ngày 08/01/2025\\nđc: xã đàn, nam đồng.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2025-01-08 08:00:00', lastmatchat=timestamp'2025-01-07 15:42:01', address='420 xã đàn, nam đồng, đống đa, hà nội', addressdetail='420', addressid=7807, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020217895507812, longitude=105.80853271484375, wardid=11, wardname='nam đồng', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2025-01-07 15:43:01', prioritizedmaids='[]', referenceid=7284, shifts='[{\\\"shiftid\\\":1271807,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2025-01-08t08:00:00\\\",\\\"totime\\\":\\\"2025-01-08t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":10.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2025-01-08 12:00:00', type=0 where id=6994","binlogFileName":"mysql-bin.000167","binlogPos":102520014,"createdDate":1764429361}

{"id":"72fb5db5-9615-4d35-8744-59fe096b786b","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.177000', updated_by='svc_client', active=1, ancestorjobid=5080, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65430, contracttype=2, holidaycontract=0, leaderid=139883, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t7, 08:00-12:00 t7, 08:00-09:00 t7, ngày 29/07/2023\\nđc: nguyễn chí thanh, thành công, đống đa.', note='', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-07-29 08:00:00', lastmatchat=timestamp'2023-07-28 10:57:01', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2023-07-28 11:02:01', prioritizedmaids='[]', referenceid=5349, shifts='[{\\\"shiftid\\\":1265635,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-07-29t08:00:00\\\",\\\"totime\\\":\\\"2023-07-29t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1265636,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-07-29t08:00:00\\\",\\\"totime\\\":\\\"2023-07-29t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1265637,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-07-29t08:00:00\\\",\\\"totime\\\":\\\"2023-07-29t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-07-29 12:00:00', type=0 where id=5081","binlogFileName":"mysql-bin.000167","binlogPos":102521952,"createdDate":1764429361}

{"id":"6a7b1292-74f4-4af9-afa2-c5c9cd417c95","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.226000', updated_by='svc_client', active=1, ancestorjobid=5033, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65387, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141765, customername='tu hoang', customerphone='0989131326', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t5, 08:00-12:00 t5, 08:00-09:00 t5, ngày 20/07/2023\\nđc: nguyễn chí thanh, lang ha, đống đa.', note='loại nhà: căn hộ\\ndiện tích: 150 - 180m2 tổng sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-07-20 11:15:00', lastmatchat=timestamp'2023-07-19 14:20:04', address='91 nguyễn chí thanh, lang ha, đống đa, hanoi, vietnam', addressdetail='91 nguyễn chí thanh, lang ha, đống đa, hanoi, vietnam, láng hạ, đống đa, hà nội, việt nam.', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.015148162841797, longitude=105.81246948242188, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2023-07-19 17:20:04', prioritizedmaids='[]', referenceid=5303, shifts='[{\\\"shiftid\\\":1265570,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-07-20t11:15:00\\\",\\\"totime\\\":\\\"2023-07-20t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":0,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-07-20 12:00:00', type=4 where id=5035","binlogFileName":"mysql-bin.000167","binlogPos":102524623,"createdDate":1764429361}

{"id":"f9a6e5ce-e760-4f45-8b4e-6d8ca59930c4","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.246000', updated_by='svc_client', active=1, ancestorjobid=4985, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65332, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141866, customername='test222', customerphone='0961888222', customersegmentid=1, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t5, 08:00-12:00 t5, 08:00-09:00 t5, ngày 06/07/2023\\nđc: đường nguyễn chí thanh, láng hạ, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-07-06 11:15:00', lastmatchat=timestamp'2023-07-05 13:44:40', address='91 đường nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020977020263672, longitude=105.80912780761719, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2023-07-05 16:44:40', prioritizedmaids='[]', referenceid=5254, shifts='[{\\\"shiftid\\\":1265196,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-07-06t11:15:00\\\",\\\"totime\\\":\\\"2023-07-06t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":0,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-07-06 12:00:00', type=4 where id=4987","binlogFileName":"mysql-bin.000167","binlogPos":102526716,"createdDate":1764429361}

{"id":"7eb2de09-9218-494a-ac19-ea02bfb0ebdc","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.267000', updated_by='svc_client', active=1, ancestorjobid=4853, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65183, contracttype=2, holidaycontract=0, leaderid=3161, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141765, customername='tu hoang', customerphone='0989131326', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t6, 08:00-12:00 t6, 08:00-09:00 t6, ngày 23/06/2023\\nđc: nguyễn chí thanh, lang ha, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-06-23 08:00:00', lastmatchat=timestamp'2023-06-22 14:44:00', address='91 nguyễn chí thanh, lang ha, đống đa, hanoi, vietnam', addressdetail='91 nguyễn chí thanh, lang ha, đống đa, hanoi, vietnam, láng hạ, đống đa, hà nội, việt nam.', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.015148162841797, longitude=105.81246948242188, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2023-06-22 14:49:00', prioritizedmaids='[]', referenceid=5117, shifts='[{\\\"shiftid\\\":1264892,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-06-23t08:00:00\\\",\\\"totime\\\":\\\"2023-06-23t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1264893,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-06-23t08:00:00\\\",\\\"totime\\\":\\\"2023-06-23t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-06-23 12:00:00', type=0 where id=4854","binlogFileName":"mysql-bin.000167","binlogPos":102528732,"createdDate":1764429361}

{"id":"9c7eec2a-a3ec-410c-93c1-84f81ce33e2e","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.285000', updated_by='svc_client', active=1, ancestorjobid=4813, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65152, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141826, customername='nguyễn thế điền', customerphone='0795335203', customersegmentid=1, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t2, 08:00-12:00 t2, 08:00-09:00 t2, ngày 26/06/2023\\nđc: nguyễn chí thanh, láng hạ, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-06-26 11:15:00', lastmatchat=timestamp'2023-06-20 16:35:28', address='91 nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='test', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.02005958557129, longitude=105.80879974365234, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2023-06-20 19:35:28', prioritizedmaids='[]', referenceid=5078, shifts='[{\\\"shiftid\\\":1264796,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-06-26t11:15:00\\\",\\\"totime\\\":\\\"2023-06-26t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":0,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-06-26 12:00:00', type=4 where id=4815","binlogFileName":"mysql-bin.000167","binlogPos":102531195,"createdDate":1764429361}

{"id":"2e557a0c-40d4-47ad-9cca-253c4b1708ff","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.302000', updated_by='svc_client', active=1, ancestorjobid=4781, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65128, contracttype=2, holidaycontract=0, leaderid=3161, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141826, customername='nguyễn thế điền', customerphone='0795335203', customersegmentid=1, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 cn, 08:00-12:00 cn, 08:00-09:00 cn, ngày 18/06/2023\\nđc: nguyễn chí thanh, láng hạ, đống đa.', note='loại nhà: căn hộ\\ndiện tích: 60 - 90m2 tổng sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-06-18 08:00:00', lastmatchat=timestamp'2023-06-17 14:46:02', address='91 nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='test', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.02005958557129, longitude=105.80879974365234, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2023-06-17 14:51:02', prioritizedmaids='[]', referenceid=5045, shifts='[{\\\"shiftid\\\":1264727,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-06-18t08:00:00\\\",\\\"totime\\\":\\\"2023-06-18t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1264728,\\\"maidid\\\":140341,\\\"fromtime\\\":\\\"2023-06-18t08:00:00\\\",\\\"totime\\\":\\\"2023-06-18t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1264729,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-06-18t08:00:00\\\",\\\"totime\\\":\\\"2023-06-18t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1264730,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-06-18t08:00:00\\\",\\\"totime\\\":\\\"2023-06-18t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-06-18 12:00:00', type=0 where id=4782","binlogFileName":"mysql-bin.000167","binlogPos":102533210,"createdDate":1764429361}

{"id":"f25fcc50-113b-4425-8021-973b3fb358fd","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.319000', updated_by='svc_client', active=1, ancestorjobid=4650, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65004, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141866, customername='test222', customerphone='0961888222', customersegmentid=1, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t7, 08:00-12:00 t7, 08:00-09:00 t7, ngày 27/05/2023\\nđc: đường nguyễn chí thanh, láng hạ, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-05-27 11:15:00', lastmatchat=timestamp'2023-05-26 14:45:09', address='91 đường nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020977020263672, longitude=105.80912780761719, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2023-05-26 14:50:09', prioritizedmaids='[]', referenceid=4915, shifts='[{\\\"shiftid\\\":1264289,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-05-27t11:15:00\\\",\\\"totime\\\":\\\"2023-05-27t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":0,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-05-27 12:00:00', type=4 where id=4652","binlogFileName":"mysql-bin.000167","binlogPos":102536317,"createdDate":1764429361}

{"id":"5e22ac50-420d-470f-ae0b-69693845fc9a","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.335000', updated_by='svc_client', active=1, ancestorjobid=4582, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64952, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='quan dt 009', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t7, 08:00-12:00 t7, 08:00-09:00 t7, ngày 20/05/2023\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-05-20 11:15:00', lastmatchat=timestamp'2023-05-19 14:10:56', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 b', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.022565841674805, longitude=105.80961608886719, wardid=4, wardname='láng thượng', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2023-05-19 14:15:56', prioritizedmaids='[]', referenceid=4847, shifts='[{\\\"shiftid\\\":1264082,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-05-20t11:15:00\\\",\\\"totime\\\":\\\"2023-05-20t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":0,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-05-20 12:00:00', type=4 where id=4584","binlogFileName":"mysql-bin.000167","binlogPos":102538335,"createdDate":1764429361}

{"id":"7bbfd332-d7d8-4a1d-93d4-7f96a39b3876","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.351000', updated_by='svc_client', active=1, ancestorjobid=4234, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64654, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141826, customername='nguyễn thế điền', customerphone='0795335203', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t6, 08:00-12:00 t6, 08:00-09:00 t6, ngày 14/04/2023\\nđc: nguyễn chí thanh, láng hạ, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-04-14 11:15:00', lastmatchat=timestamp'2023-04-08 08:40:52', address='91 nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='test', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.02005958557129, longitude=105.80879974365234, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2023-04-08 08:45:52', prioritizedmaids='[]', referenceid=4498, shifts='[{\\\"shiftid\\\":1263283,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-04-14t11:15:00\\\",\\\"totime\\\":\\\"2023-04-14t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":0,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-04-14 12:00:00', type=4 where id=4236","binlogFileName":"mysql-bin.000167","binlogPos":102540320,"createdDate":1764429361}

{"id":"cdd14595-2743-480b-80f9-1c950c84e66f","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.367000', updated_by='svc_client', active=1, ancestorjobid=4224, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64648, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141826, customername='nguyễn thế điền', customerphone='0795335203', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 cn, 08:00-12:00 cn, 08:00-09:00 cn, ngày 09/04/2023\\nđc: nguyễn chí thanh, láng hạ, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-04-09 11:15:00', lastmatchat=timestamp'2023-04-07 17:21:15', address='91 nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='test', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.02005958557129, longitude=105.80879974365234, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2023-04-07 17:26:15', prioritizedmaids='[]', referenceid=4488, shifts='[{\\\"shiftid\\\":1263264,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-04-09t11:15:00\\\",\\\"totime\\\":\\\"2023-04-09t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":0,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-04-09 12:00:00', type=4 where id=4226","binlogFileName":"mysql-bin.000167","binlogPos":102542337,"createdDate":1764429361}

{"id":"23d6ae82-f3bc-4553-8ccb-c5bbc6621507","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.384000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64637, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=142016, customername='quan dt', customerphone='0966611162', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 17:00-18:00 t6, 17:00-21:00 t6, 20:15-21:00 t6, ngày 07/04/2023\\nđc: đường nguyễn chí thanh, láng hạ, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-04-07 17:00:00', lastmatchat=timestamp'2023-04-07 11:30:01', address='91 đường nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='m3-m4', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020427703857422, longitude=105.80892181396484, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2023-04-07 11:35:01', prioritizedmaids='[]', referenceid=4470, shifts='[{\\\"shiftid\\\":1263215,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-04-07t17:00:00\\\",\\\"totime\\\":\\\"2023-04-07t18:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":0,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1263216,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-04-07t20:15:00\\\",\\\"totime\\\":\\\"2023-04-07t21:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":0,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-04-07 21:00:00', type=4 where id=4208","binlogFileName":"mysql-bin.000167","binlogPos":102544354,"createdDate":1764429361}

{"id":"1f0e348c-6d66-4dbc-99f1-1b86843d4758","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.405000', updated_by='svc_client', active=1, ancestorjobid=4063, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64480, contracttype=2, holidaycontract=0, leaderid=141625, periodtype=-1, productpackageid=1, requiredleader=1, customerid=142182, customername='pham viet hoang 3', customerphone='0904521431', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t6, ngày 24/03/2023\\nđc: nguyễn chí thanh, quận đống đa, thành công, ba đình.', note='loại nhà: biệt thự\\ndiện tích: 180 - 210m2 mặt sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-03-24 13:00:00', lastmatchat=timestamp'2023-03-14 09:33:06', address='91, nguyễn chí thanh, quận đống đa, thành công, ba đình, hà nội, việt nam', addressdetail='tầng 14', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.019901275634766, longitude=105.80845642089844, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2023-03-14 09:34:06', prioritizedmaids='[]', referenceid=4326, shifts='[{\\\"shiftid\\\":1262620,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-03-24t13:00:00\\\",\\\"totime\\\":\\\"2023-03-24t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1262621,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-03-24t13:00:00\\\",\\\"totime\\\":\\\"2023-03-24t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1262622,\\\"maidid\\\":141930,\\\"fromtime\\\":\\\"2023-03-24t13:00:00\\\",\\\"totime\\\":\\\"2023-03-24t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1262623,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-03-24t13:00:00\\\",\\\"totime\\\":\\\"2023-03-24t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1262624,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-03-24t13:00:00\\\",\\\"totime\\\":\\\"2023-03-24t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1262625,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-03-24t13:00:00\\\",\\\"totime\\\":\\\"2023-03-24t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-03-24 17:00:00', type=0 where id=4064","binlogFileName":"mysql-bin.000167","binlogPos":102546734,"createdDate":1764429361}

{"id":"fd194d78-d09a-470b-9469-4e0c41b55fcd","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.441000', updated_by='svc_client', active=1, ancestorjobid=4028, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64446, contracttype=2, holidaycontract=0, leaderid=141625, periodtype=-1, productpackageid=1, requiredleader=1, customerid=142182, customername='pham viet hoang 3', customerphone='0904521431', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 17:00-21:00 t5, ngày 09/03/2023\\nđc: nguyễn chí thanh, quận đống đa, thành công, ba đình.', note='loại nhà: văn phòng\\ndiện tích: 90 - 120m2 mặt sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-03-09 17:00:00', lastmatchat=timestamp'2023-03-09 04:49:00', address='91, nguyễn chí thanh, quận đống đa, thành công, ba đình, hà nội, việt nam', addressdetail='tầng 14', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.019901275634766, longitude=105.80845642089844, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=10, nextmatchat=timestamp'2023-03-09 04:50:00', prioritizedmaids='[]', referenceid=4291, shifts='[{\\\"shiftid\\\":1262517,\\\"maidid\\\":3161,\\\"fromtime\\\":\\\"2023-03-09t17:00:00\\\",\\\"totime\\\":\\\"2023-03-09t21:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1262518,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-03-09t17:00:00\\\",\\\"totime\\\":\\\"2023-03-09t21:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1262519,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-03-09t17:00:00\\\",\\\"totime\\\":\\\"2023-03-09t21:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-03-09 21:00:00', type=0 where id=4029","binlogFileName":"mysql-bin.000167","binlogPos":102550584,"createdDate":1764429361}

{"id":"42763399-c8bb-40a3-bc6a-fc78c9b4cdcd","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.461000', updated_by='svc_client', active=1, ancestorjobid=4014, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64431, contracttype=2, holidaycontract=0, leaderid=141821, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 17:00-21:00 t7, ngày 25/02/2023\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-02-25 17:00:00', lastmatchat=timestamp'2023-02-25 08:34:00', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=10, nextmatchat=timestamp'2023-02-25 08:35:00', prioritizedmaids='[]', referenceid=4264, shifts='[{\\\"shiftid\\\":1262489,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-02-25t17:00:00\\\",\\\"totime\\\":\\\"2023-02-25t21:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-02-25 21:00:00', type=0 where id=4015","binlogFileName":"mysql-bin.000167","binlogPos":102553344,"createdDate":1764429361}

{"id":"948e7fe5-8bab-4c1c-bf13-566765437321","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.481000', updated_by='svc_client', active=1, ancestorjobid=5089, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65441, contracttype=2, holidaycontract=0, leaderid=139883, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='quan dt 009', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t4, 08:00-12:00 t4, 08:00-09:00 t4, ngày 09/08/2023\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-08-09 08:00:00', lastmatchat=timestamp'2023-08-08 16:53:01', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 b', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.022565841674805, longitude=105.80961608886719, wardid=4, wardname='láng thượng', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2023-08-08 16:58:01', prioritizedmaids='[]', referenceid=5358, shifts='[{\\\"shiftid\\\":1265650,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-08-09t08:00:00\\\",\\\"totime\\\":\\\"2023-08-09t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1265651,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-08-09t08:00:00\\\",\\\"totime\\\":\\\"2023-08-09t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1265652,\\\"maidid\\\":141821,\\\"fromtime\\\":\\\"2023-08-09t08:00:00\\\",\\\"totime\\\":\\\"2023-08-09t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-08-09 12:00:00', type=0 where id=5090","binlogFileName":"mysql-bin.000167","binlogPos":102555336,"createdDate":1764429361}

{"id":"d8f4aee7-ee9c-4bee-aeb4-b2d5bdb50004","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.500000', updated_by='svc_client', active=1, ancestorjobid=5439, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65810, contracttype=2, holidaycontract=0, leaderid=141821, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141826, customername='nguyễn thế điền', customerphone='0795335203', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t3, 08:00-12:00 t3, 08:00-09:00 t3, ngày 28/11/2023\\nđc: nguyễn chí thanh, láng hạ, đống đa.', note='loại nhà: căn hộ\\ndiện tích: 60 - 90m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2023-11-28 08:00:00', lastmatchat=timestamp'2023-11-27 16:23:00', address='91 nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='test', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.02005958557129, longitude=105.80879974365234, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2023-11-27 16:28:00', prioritizedmaids='[]', referenceid=5714, shifts='[{\\\"shiftid\\\":1266655,\\\"maidid\\\":141605,\\\"fromtime\\\":\\\"2023-11-28t08:00:00\\\",\\\"totime\\\":\\\"2023-11-28t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":95000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1266656,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-11-28t08:00:00\\\",\\\"totime\\\":\\\"2023-11-28t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":95000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1266657,\\\"maidid\\\":141611,\\\"fromtime\\\":\\\"2023-11-28t08:00:00\\\",\\\"totime\\\":\\\"2023-11-28t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":95000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-11-28 12:00:00', type=0 where id=5440","binlogFileName":"mysql-bin.000167","binlogPos":102558048,"createdDate":1764429361}

{"id":"7824cc4b-f999-45f2-9907-e835a439124f","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.533000', updated_by='svc_client', active=1, ancestorjobid=5594, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65895, contracttype=2, holidaycontract=0, leaderid=141821, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141826, customername='nguyễn thế điền', customerphone='0795335203', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t3, 08:00-12:00 t3, 08:00-09:00 t3, ngày 12/12/2023\\nđc: nguyễn chí thanh, láng hạ, đống đa.', note='loại nhà: căn hộ\\ndiện tích: 90 - 120m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2023-12-12 08:00:00', lastmatchat=timestamp'2023-12-11 10:43:00', address='91 nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='test', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.02005958557129, longitude=105.80879974365234, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2023-12-11 10:48:00', prioritizedmaids='[]', referenceid=5877, shifts='[{\\\"shiftid\\\":1266831,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-12-12t08:00:00\\\",\\\"totime\\\":\\\"2023-12-12t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":95000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1266832,\\\"maidid\\\":141605,\\\"fromtime\\\":\\\"2023-12-12t08:00:00\\\",\\\"totime\\\":\\\"2023-12-12t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":95000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1266833,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-12-12t08:00:00\\\",\\\"totime\\\":\\\"2023-12-12t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":95000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1266834,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-12-12t08:00:00\\\",\\\"totime\\\":\\\"2023-12-12t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":95000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1266835,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-12-12t08:00:00\\\",\\\"totime\\\":\\\"2023-12-12t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":95000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1266836,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-12-12t08:00:00\\\",\\\"totime\\\":\\\"2023-12-12t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":95000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-12-12 12:00:00', type=0 where id=5595","binlogFileName":"mysql-bin.000167","binlogPos":102560788,"createdDate":1764429361}

{"id":"6b77543e-a786-4694-b21f-544828307f2a","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.553000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[29]', contractid=67152, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='dang the quan', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype='all_shifts', bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t5, 08:00-09:00 t5, ngày 26/12/2024\\nđc: a đường nguyễn chí thanh, láng hạ.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\ncẩn thận đồ dễ vỡ', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2024-12-26 08:00:00', lastmatchat=timestamp'2024-12-25 15:09:35', address='91a đường nguyễn chí thanh, láng hạ, đống đa, hà nội', addressdetail='p1309, tầng 13', addressid=7870, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020227432250977, longitude=105.80854034423828, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2024-12-25 18:09:35', prioritizedmaids='[]', referenceid=7211, shifts='[{\\\"shiftid\\\":1271643,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-12-26t08:00:00\\\",\\\"totime\\\":\\\"2024-12-26t09:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":0,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1271644,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-12-26t11:15:00\\\",\\\"totime\\\":\\\"2024-12-26t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":0,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2024-12-26 12:00:00', type=4 where id=6921","binlogFileName":"mysql-bin.000167","binlogPos":102564601,"createdDate":1764429361}

{"id":"78282adc-c8b0-48f4-ad13-c578ab0c6784","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.602000', updated_by='svc_client', active=1, ancestorjobid=6608, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=66755, contracttype=2, holidaycontract=0, leaderid=141821, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='đặng thế quân', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t5, ngày 12/09/2024\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2024-09-12 08:00:00', lastmatchat=timestamp'2024-09-11 11:01:00', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 a', addressid=7818, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020057678222656, longitude=105.80872344970703, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2024-09-11 11:06:00', prioritizedmaids='[]', referenceid=6893, shifts='[{\\\"shiftid\\\":1269868,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-09-12t08:00:00\\\",\\\"totime\\\":\\\"2024-09-12t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2024-09-12 12:00:00', type=0 where id=6609","binlogFileName":"mysql-bin.000167","binlogPos":102566993,"createdDate":1764429361}

{"id":"b45911ea-170b-4911-8ddb-0e09ee237eb8","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.620000', updated_by='svc_client', active=1, ancestorjobid=6603, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=66754, contracttype=2, holidaycontract=0, leaderid=16296, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='đặng thế quân', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t5, ngày 12/09/2024\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2024-09-12 08:00:00', lastmatchat=timestamp'2024-09-11 11:00:01', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 a', addressid=7818, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020057678222656, longitude=105.80872344970703, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2024-09-11 11:05:01', prioritizedmaids='[]', referenceid=6888, shifts='[{\\\"shiftid\\\":1269863,\\\"maidid\\\":141611,\\\"fromtime\\\":\\\"2024-09-12t08:00:00\\\",\\\"totime\\\":\\\"2024-09-12t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1269864,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-09-12t08:00:00\\\",\\\"totime\\\":\\\"2024-09-12t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2024-09-12 12:00:00', type=0 where id=6604","binlogFileName":"mysql-bin.000167","binlogPos":102568959,"createdDate":1764429361}

{"id":"26ae2b53-d3f1-42a8-8d6e-282f9e7a868f","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.642000', updated_by='svc_client', active=1, ancestorjobid=6593, autoaccept=0, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=66747, contracttype=2, holidaycontract=0, leaderid=16296, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='đặng thế quân', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t7, ngày 07/09/2024\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2024-09-07 13:00:00', lastmatchat=timestamp'2024-09-06 11:12:00', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 a', addressid=7818, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020057678222656, longitude=105.80872344970703, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2024-09-06 11:17:00', prioritizedmaids='[]', referenceid=6878, shifts='[{\\\"shiftid\\\":1269853,\\\"maidid\\\":141611,\\\"fromtime\\\":\\\"2024-09-07t13:00:00\\\",\\\"totime\\\":\\\"2024-09-07t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1269854,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-09-07t13:00:00\\\",\\\"totime\\\":\\\"2024-09-07t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2024-09-07 17:00:00', type=0 where id=6594","binlogFileName":"mysql-bin.000167","binlogPos":102571282,"createdDate":1764429361}

{"id":"d43e0899-74e3-4797-b9f4-88c0d5e6367f","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.657000', updated_by='svc_client', active=1, ancestorjobid=6587, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=66745, contracttype=2, holidaycontract=0, leaderid=141821, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='đặng thế quân', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t7, ngày 07/09/2024\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2024-09-07 08:00:00', lastmatchat=timestamp'2024-09-06 10:16:01', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 a', addressid=7818, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020057678222656, longitude=105.80872344970703, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2024-09-06 10:21:01', prioritizedmaids='[]', referenceid=6872, shifts='[{\\\"shiftid\\\":1269846,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-09-07t08:00:00\\\",\\\"totime\\\":\\\"2024-09-07t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2024-09-07 12:00:00', type=0 where id=6588","binlogFileName":"mysql-bin.000167","binlogPos":102573605,"createdDate":1764429361}

{"id":"01d0ca2c-2ec7-4df6-b092-06f96447b6e5","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.674000', updated_by='svc_client', active=1, ancestorjobid=6412, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=66553, contracttype=2, holidaycontract=0, leaderid=16296, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='đặng thế quân', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t5, ngày 25/07/2024\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\ntest', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2024-07-25 08:00:00', lastmatchat=timestamp'2024-07-24 17:38:00', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 a', addressid=7818, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020057678222656, longitude=105.80872344970703, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2024-07-24 17:43:00', prioritizedmaids='[]', referenceid=6696, shifts='[{\\\"shiftid\\\":1269275,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-07-25t08:00:00\\\",\\\"totime\\\":\\\"2024-07-25t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1269276,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-07-25t08:00:00\\\",\\\"totime\\\":\\\"2024-07-25t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2024-07-25 12:00:00', type=0 where id=6413","binlogFileName":"mysql-bin.000167","binlogPos":102575571,"createdDate":1764429361}

{"id":"a5aa43ff-8f6c-45c8-a7f6-33ab8e4a7db7","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.697000', updated_by='svc_client', active=1, ancestorjobid=6214, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=66377, contracttype=2, holidaycontract=0, leaderid=16296, periodtype=-1, productpackageid=1, requiredleader=1, customerid=142260, customername='thanh18', customerphone='0961990018', customersegmentid=2, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t4, ngày 03/04/2024\\nđc: láng hạ, phường láng hạ.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2024-04-03 13:00:00', lastmatchat=timestamp'2024-04-02 19:06:00', address='100 láng hạ, phường láng hạ, quận đống đa, thành phố hà nội', addressdetail='100 lh', addressid=7785, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.01149559020996, longitude=105.81134033203125, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2024-04-02 19:11:00', prioritizedmaids='[]', referenceid=6498, shifts='[{\\\"shiftid\\\":1268382,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-04-03t13:00:00\\\",\\\"totime\\\":\\\"2024-04-03t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1268383,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-04-03t13:00:00\\\",\\\"totime\\\":\\\"2024-04-03t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2024-04-03 17:00:00', type=0 where id=6215","binlogFileName":"mysql-bin.000167","binlogPos":102577899,"createdDate":1764429361}

{"id":"f2f951c1-89ae-48ea-9578-b2636ec9811e","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.711000', updated_by='svc_client', active=1, ancestorjobid=6075, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=66240, contracttype=2, holidaycontract=0, leaderid=16296, periodtype=-1, productpackageid=1, requiredleader=1, customerid=142254, customername='test 13', customerphone='0961990013', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t4, 08:00-12:00 t4, 08:00-09:00 t4, ngày 07/02/2024\\nđc: nguyễn chí thanh, phường láng hạ.', note='loại nhà: căn hộ\\ndiện tích: 60 - 90m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2024-02-07 08:00:00', lastmatchat=timestamp'2024-02-06 12:06:03', address='91 nguyễn chí thanh, phường láng hạ, quận đống đa, thành phố hà nội', addressdetail='x', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020858764648438, longitude=105.8090591430664, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2024-02-06 12:11:03', prioritizedmaids='[]', referenceid=6359, shifts='[{\\\"shiftid\\\":1267917,\\\"maidid\\\":141611,\\\"fromtime\\\":\\\"2024-02-07t08:00:00\\\",\\\"totime\\\":\\\"2024-02-07t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267918,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-02-07t08:00:00\\\",\\\"totime\\\":\\\"2024-02-07t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267919,\\\"maidid\\\":141605,\\\"fromtime\\\":\\\"2024-02-07t08:00:00\\\",\\\"totime\\\":\\\"2024-02-07t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2024-02-07 12:00:00', type=0 where id=6076","binlogFileName":"mysql-bin.000167","binlogPos":102580234,"createdDate":1764429361}

{"id":"60e536d6-1770-4bfa-ba6b-790d4f0a01cf","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.733000', updated_by='svc_client', active=1, ancestorjobid=6328, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=66225, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=5, requiredleader=0, customerid=141705, customername='bá thành 009', customerphone='0961990009', customersegmentid=2, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"định kỳ\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-11:30 t3 từ ngày 06/02/2024 đến ngày 09/04/2024\\nđc: nguyễn chí thanh, phường láng hạ.', note='', retailshipmentids='[]', toolrequired=0, fromtime=timestamp'2024-02-06 08:00:00', lastmatchat=timestamp'2024-01-29 12:42:01', address='91 nguyễn chí thanh, phường láng hạ, quận đống đa, thành phố hà nội', addressdetail='ds', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020858764648438, longitude=105.8090591430664, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2024-01-29 12:47:01', prioritizedmaids='[]', referenceid=6330, shifts='[{\\\"shiftid\\\":1267810,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-02-06t08:00:00\\\",\\\"totime\\\":\\\"2024-02-06t11:30:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":160000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267802,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-02-20t08:00:00\\\",\\\"totime\\\":\\\"2024-02-20t11:30:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":146000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267804,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-02-27t08:00:00\\\",\\\"totime\\\":\\\"2024-02-27t11:30:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":97000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267806,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-03-05t08:00:00\\\",\\\"totime\\\":\\\"2024-03-05t11:30:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":97000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267803,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-03-12t08:00:00\\\",\\\"totime\\\":\\\"2024-03-12t11:30:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":97000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267807,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-03-19t08:00:00\\\",\\\"totime\\\":\\\"2024-03-19t11:30:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":97000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267805,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-03-26t08:00:00\\\",\\\"totime\\\":\\\"2024-03-26t11:30:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":97000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267808,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-04-02t08:00:00\\\",\\\"totime\\\":\\\"2024-04-02t11:30:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":97000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267809,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-04-09t08:00:00\\\",\\\"totime\\\":\\\"2024-04-09t11:30:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":160000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2024-04-09 11:30:00', type=0 where id=6047","binlogFileName":"mysql-bin.000167","binlogPos":102582973,"createdDate":1764429361}

{"id":"c3338c05-9710-472e-9fe3-f15c46d9909b","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.751000', updated_by='svc_client', active=1, ancestorjobid=6005, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=66183, contracttype=2, holidaycontract=0, leaderid=16296, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='quan dt 009', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-14:00 t4, 13:00-17:00 t4, 16:15-17:00 t4, ngày 24/01/2024\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2024-01-24 13:00:00', lastmatchat=timestamp'2024-01-23 10:31:01', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 a', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.022565841674805, longitude=105.80961608886719, wardid=4, wardname='láng thượng', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2024-01-23 10:36:01', prioritizedmaids='[]', referenceid=6289, shifts='[{\\\"shiftid\\\":1267699,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-01-24t13:00:00\\\",\\\"totime\\\":\\\"2024-01-24t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267700,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-01-24t13:00:00\\\",\\\"totime\\\":\\\"2024-01-24t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2024-01-24 17:00:00', type=0 where id=6006","binlogFileName":"mysql-bin.000167","binlogPos":102587791,"createdDate":1764429361}

{"id":"9a6b3b9d-ef7b-491f-80a7-034fdb576d74","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.769000', updated_by='svc_client', active=1, ancestorjobid=5970, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=66156, contracttype=2, holidaycontract=0, leaderid=16296, periodtype=-1, productpackageid=1, requiredleader=1, customerid=142016, customername='quan dt', customerphone='0966611162', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t6, 08:00-12:00 t6, 08:00-09:00 t6, ngày 19/01/2024\\nđc: a nguyễn chí thanh, láng hạ, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2024-01-19 08:00:00', lastmatchat=timestamp'2024-01-18 16:47:01', address='91a nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='91a nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam, láng hạ, đống đa, hà nội, việt nam.', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.015148162841797, longitude=105.81246948242188, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2024-01-18 16:52:01', prioritizedmaids='[]', referenceid=6254, shifts='[{\\\"shiftid\\\":1267522,\\\"maidid\\\":141605,\\\"fromtime\\\":\\\"2024-01-19t08:00:00\\\",\\\"totime\\\":\\\"2024-01-19t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267523,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-01-19t08:00:00\\\",\\\"totime\\\":\\\"2024-01-19t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2024-01-19 12:00:00', type=0 where id=5971","binlogFileName":"mysql-bin.000167","binlogPos":102590144,"createdDate":1764429361}

{"id":"86eceb92-c14b-4ae0-a162-d670573a389f","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.786000', updated_by='svc_client', active=1, ancestorjobid=5844, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=66001, contracttype=2, holidaycontract=0, leaderid=141821, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141826, customername='nguyễn thế điền', customerphone='0795335203', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-14:00 t5, 13:00-17:00 t5, 16:15-17:00 t5, ngày 28/12/2023\\nđc: nguyễn chí thanh, láng hạ, đống đa.', note='', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2023-12-28 13:00:00', lastmatchat=timestamp'2023-12-25 19:34:00', address='91 nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='test', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.02005958557129, longitude=105.80879974365234, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2023-12-25 19:39:00', prioritizedmaids='[]', referenceid=6127, shifts='[{\\\"shiftid\\\":1267208,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-12-28t13:00:00\\\",\\\"totime\\\":\\\"2023-12-28t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-12-28 17:00:00', type=0 where id=5845","binlogFileName":"mysql-bin.000167","binlogPos":102592633,"createdDate":1764429361}

{"id":"98c6531e-f2c5-4d29-98f6-a556a68fd48a","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.804000', updated_by='svc_client', active=1, ancestorjobid=5720, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65952, contracttype=2, holidaycontract=0, leaderid=141821, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='quan dt 009', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t3, 08:00-12:00 t3, 08:00-09:00 t3, ngày 19/12/2023\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2023-12-19 08:00:00', lastmatchat=timestamp'2023-12-18 17:01:01', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 e', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.022565841674805, longitude=105.80961608886719, wardid=4, wardname='láng thượng', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2023-12-18 17:06:01', prioritizedmaids='[]', referenceid=6003, shifts='[{\\\"shiftid\\\":1267011,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-12-19t08:00:00\\\",\\\"totime\\\":\\\"2023-12-19t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":95000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267012,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-12-19t08:00:00\\\",\\\"totime\\\":\\\"2023-12-19t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":95000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-12-19 12:00:00', type=0 where id=5721","binlogFileName":"mysql-bin.000167","binlogPos":102594596,"createdDate":1764429361}

{"id":"afc16467-81ca-4db7-88e0-45e95a3d2fce","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.835000', updated_by='svc_client', active=1, ancestorjobid=5702, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65944, contracttype=2, holidaycontract=0, leaderid=141821, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='quan dt 009', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-14:00 t7, 13:00-17:00 t7, 16:15-17:00 t7, ngày 16/12/2023\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: 90 - 120m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2023-12-16 13:00:00', lastmatchat=timestamp'2023-12-13 18:45:02', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 e', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.022565841674805, longitude=105.80961608886719, wardid=4, wardname='láng thượng', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2023-12-13 18:50:02', prioritizedmaids='[]', referenceid=5985, shifts='[{\\\"shiftid\\\":1266952,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-12-16t13:00:00\\\",\\\"totime\\\":\\\"2023-12-16t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1266953,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-12-16t13:00:00\\\",\\\"totime\\\":\\\"2023-12-16t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1266954,\\\"maidid\\\":140341,\\\"fromtime\\\":\\\"2023-12-16t13:00:00\\\",\\\"totime\\\":\\\"2023-12-16t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1266955,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-12-16t13:00:00\\\",\\\"totime\\\":\\\"2023-12-16t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-12-16 17:00:00', type=0 where id=5703","binlogFileName":"mysql-bin.000167","binlogPos":102596948,"createdDate":1764429361}

{"id":"c96d6a53-961e-4985-9205-8e99fe1901ca","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.851000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64416, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 17:00-21:00 t4, ngày 15/02/2023\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2023-02-15 17:00:00', lastmatchat=timestamp'2023-02-15 11:30:08', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2023-02-15 11:31:08', prioritizedmaids='[]', referenceid=4254, shifts='[{\\\"shiftid\\\":1262271,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-02-15t17:00:00\\\",\\\"totime\\\":\\\"2023-02-15t21:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":225000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-02-15 21:00:00', type=4 where id=4005","binlogFileName":"mysql-bin.000167","binlogPos":102600017,"createdDate":1764429361}

{"id":"b5b7142a-2265-4caf-8bfa-98fdf10b6595","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.867000', updated_by='svc_client', active=1, ancestorjobid=3980, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64381, contracttype=2, holidaycontract=0, leaderid=3161, periodtype=-1, productpackageid=1, requiredleader=1, customerid=142017, customername='quandt 03', customerphone='0966611163', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t6, ngày 10/02/2023\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2023-02-10 13:00:00', lastmatchat=timestamp'2023-02-07 16:40:00', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 a', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.022565841674805, longitude=105.80961608886719, wardid=4, wardname='láng thượng', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=10, nextmatchat=timestamp'2023-02-07 16:41:00', prioritizedmaids='[]', referenceid=4230, shifts='[{\\\"shiftid\\\":1261981,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-02-10t13:00:00\\\",\\\"totime\\\":\\\"2023-02-10t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1261982,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-02-10t13:00:00\\\",\\\"totime\\\":\\\"2023-02-10t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-02-10 17:00:00', type=0 where id=3981","binlogFileName":"mysql-bin.000167","binlogPos":102602002,"createdDate":1764429361}

{"id":"b6b8129c-4812-4b9b-96df-baa51d4712f4","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.907000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64168, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t4, ngày 21/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 30 - 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-21 08:00:00', lastmatchat=timestamp'2022-12-20 11:24:59', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2022-12-20 11:25:59', prioritizedmaids='[]', referenceid=4071, shifts='[{\\\"shiftid\\\":1261599,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-21t08:00:00\\\",\\\"totime\\\":\\\"2022-12-21t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":62000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-21 12:00:00', type=4 where id=3822","binlogFileName":"mysql-bin.000167","binlogPos":102604330,"createdDate":1764429361}

{"id":"92aa24f9-d916-4db4-8bc3-ad01ed27266c","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.922000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64166, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t4, ngày 21/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 30 - 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-21 08:00:00', lastmatchat=timestamp'2022-12-20 11:22:39', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2022-12-20 11:23:39', prioritizedmaids='[]', referenceid=4069, shifts='[{\\\"shiftid\\\":1261595,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-21t08:00:00\\\",\\\"totime\\\":\\\"2022-12-21t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":62000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-21 12:00:00', type=4 where id=3820","binlogFileName":"mysql-bin.000167","binlogPos":102606319,"createdDate":1764429361}

{"id":"5a7f214d-5c19-407b-9983-25e58f130deb","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.938000', updated_by='svc_client', active=1, ancestorjobid=3817, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64163, contracttype=2, holidaycontract=0, leaderid=3161, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t4, ngày 21/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: căn hộ\\ndiện tích: 120 - 150m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-21 08:00:00', lastmatchat=timestamp'2022-12-20 11:13:00', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=10, nextmatchat=timestamp'2022-12-20 11:14:00', prioritizedmaids='[]', referenceid=4067, shifts='[{\\\"shiftid\\\":1261583,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-21t08:00:00\\\",\\\"totime\\\":\\\"2022-12-21t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":62000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1261584,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-21t08:00:00\\\",\\\"totime\\\":\\\"2022-12-21t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":62000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1261585,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-21t08:00:00\\\",\\\"totime\\\":\\\"2022-12-21t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":62000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1261586,\\\"maidid\\\":141930,\\\"fromtime\\\":\\\"2022-12-21t08:00:00\\\",\\\"totime\\\":\\\"2022-12-21t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":62000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1261587,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-21t08:00:00\\\",\\\"totime\\\":\\\"2022-12-21t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":62000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-21 12:00:00', type=0 where id=3818","binlogFileName":"mysql-bin.000167","binlogPos":102608308,"createdDate":1764429361}

{"id":"b30ede11-028a-4c09-b87d-15ce99e93455","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.953000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64153, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141826, customername='nguyễn thế điền', customerphone='0795335203', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t6, ngày 23/12/2022\\nđc: nguyễn chí thanh, láng hạ, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 30 - 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-23 13:00:00', lastmatchat=timestamp'2022-12-19 14:07:58', address='91 nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='test', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.02005958557129, longitude=105.80879974365234, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2022-12-19 14:08:58', prioritizedmaids='[]', referenceid=4050, shifts='[{\\\"shiftid\\\":1261564,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-23t13:00:00\\\",\\\"totime\\\":\\\"2022-12-23t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":68000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-23 17:00:00', type=4 where id=3801","binlogFileName":"mysql-bin.000167","binlogPos":102611739,"createdDate":1764429361}

{"id":"993e97db-4472-4c38-93eb-931dab2b9098","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:01.993000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64150, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 cn, ngày 18/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 30 - 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-18 13:00:00', lastmatchat=timestamp'2022-12-17 14:54:19', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2022-12-17 14:55:19', prioritizedmaids='[]', referenceid=4046, shifts='[{\\\"shiftid\\\":1261557,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-18t13:00:00\\\",\\\"totime\\\":\\\"2022-12-18t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":68000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-18 17:00:00', type=4 where id=3797","binlogFileName":"mysql-bin.000167","binlogPos":102613738,"createdDate":1764429361}

{"id":"661df33f-fb08-45c1-b2ad-0a3d2399495f","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.008000', updated_by='svc_client', active=1, ancestorjobid=3781, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64140, contracttype=2, holidaycontract=0, leaderid=3161, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t7, ngày 17/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 90 - 120m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-17 08:00:00', lastmatchat=timestamp'2022-12-15 17:58:00', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=10, nextmatchat=timestamp'2022-12-15 17:59:00', prioritizedmaids='[]', referenceid=4031, shifts='[{\\\"shiftid\\\":1261539,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-17t08:00:00\\\",\\\"totime\\\":\\\"2022-12-17t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":68000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1261540,\\\"maidid\\\":141821,\\\"fromtime\\\":\\\"2022-12-17t08:00:00\\\",\\\"totime\\\":\\\"2022-12-17t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":68000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1261541,\\\"maidid\\\":15936,\\\"fromtime\\\":\\\"2022-12-17t08:00:00\\\",\\\"totime\\\":\\\"2022-12-17t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":68000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-17 12:00:00', type=0 where id=3782","binlogFileName":"mysql-bin.000167","binlogPos":102615727,"createdDate":1764429362}

{"id":"7ba7c601-66be-4d73-9949-fce1e6159e60","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.026000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64139, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t6, ngày 16/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 90 - 120m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-16 13:00:00', lastmatchat=timestamp'2022-12-15 17:52:47', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2022-12-15 17:53:47', prioritizedmaids='[]', referenceid=4029, shifts='[{\\\"shiftid\\\":1261534,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-16t13:00:00\\\",\\\"totime\\\":\\\"2022-12-16t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":68000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-16 17:00:00', type=4 where id=3780","binlogFileName":"mysql-bin.000167","binlogPos":102618444,"createdDate":1764429362}

{"id":"b2a5dd5d-ff47-4595-8d68-0dee88387946","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.041000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64137, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t6, ngày 16/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 90 - 120m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-16 13:00:00', lastmatchat=timestamp'2022-12-15 17:30:49', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2022-12-15 17:31:49', prioritizedmaids='[]', referenceid=4026, shifts='[{\\\"shiftid\\\":1261526,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-16t13:00:00\\\",\\\"totime\\\":\\\"2022-12-16t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":68000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-16 17:00:00', type=4 where id=3777","binlogFileName":"mysql-bin.000167","binlogPos":102620434,"createdDate":1764429362}

{"id":"0869ca87-afba-4ac3-9ba4-83d86baacd8e","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.055000', updated_by='svc_client', active=1, ancestorjobid=3775, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64136, contracttype=2, holidaycontract=0, leaderid=3161, periodtype=-1, productpackageid=1, requiredleader=1, customerid=142017, customername='quandt 03', customerphone='0966611163', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 cn, ngày 18/12/2022\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: dưới 30m2 mặt sàn\\ntest', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-18 13:00:00', lastmatchat=timestamp'2022-12-15 17:34:00', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 a', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.022565841674805, longitude=105.80961608886719, wardid=4, wardname='láng thượng', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=10, nextmatchat=timestamp'2022-12-15 17:35:00', prioritizedmaids='[]', referenceid=4025, shifts='[{\\\"shiftid\\\":1261524,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-18t13:00:00\\\",\\\"totime\\\":\\\"2022-12-18t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":193000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1261525,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-18t13:00:00\\\",\\\"totime\\\":\\\"2022-12-18t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":193000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-18 17:00:00', type=0 where id=3776","binlogFileName":"mysql-bin.000167","binlogPos":102622424,"createdDate":1764429362}

{"id":"cfc9528a-022b-4acc-801a-7f6e73e5e1b1","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.071000', updated_by='svc_client', active=1, ancestorjobid=3773, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64135, contracttype=2, holidaycontract=0, leaderid=3161, periodtype=-1, productpackageid=1, requiredleader=1, customerid=142017, customername='quandt 03', customerphone='0966611163', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t7, ngày 17/12/2022\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 30m2 mặt sàn\\nthis is a test', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-17 13:00:00', lastmatchat=timestamp'2022-12-15 17:29:00', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 a', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.022565841674805, longitude=105.80961608886719, wardid=4, wardname='láng thượng', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=10, nextmatchat=timestamp'2022-12-15 17:30:00', prioritizedmaids='[]', referenceid=4023, shifts='[{\\\"shiftid\\\":1261521,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-17t13:00:00\\\",\\\"totime\\\":\\\"2022-12-17t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":193000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1261522,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-17t13:00:00\\\",\\\"totime\\\":\\\"2022-12-17t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":193000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-17 17:00:00', type=0 where id=3774","binlogFileName":"mysql-bin.000167","binlogPos":102624764,"createdDate":1764429362}

{"id":"03cf1255-bb67-4416-89ee-ae9485a4c177","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.086000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64134, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=142017, customername='quandt 03', customerphone='0966611163', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t6, ngày 16/12/2022\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 30 - 60m2 mặt sàn\\nlàm sạch sẽ', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-16 13:00:00', lastmatchat=timestamp'2022-12-15 17:08:08', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 a', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.022565841674805, longitude=105.80961608886719, wardid=4, wardname='láng thượng', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2022-12-15 17:09:08', prioritizedmaids='[]', referenceid=4021, shifts='[{\\\"shiftid\\\":1261516,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-16t13:00:00\\\",\\\"totime\\\":\\\"2022-12-16t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":193000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-16 17:00:00', type=4 where id=3772","binlogFileName":"mysql-bin.000167","binlogPos":102627106,"createdDate":1764429362}

{"id":"91fc8aad-b754-4083-87d4-ec577463d965","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.101000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64131, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t6, ngày 16/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 60 - 90m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-16 13:00:00', lastmatchat=timestamp'2022-12-15 16:57:49', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2022-12-15 16:58:49', prioritizedmaids='[]', referenceid=4017, shifts='[{\\\"shiftid\\\":1261510,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-16t13:00:00\\\",\\\"totime\\\":\\\"2022-12-16t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":68000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-16 17:00:00', type=4 where id=3768","binlogFileName":"mysql-bin.000167","binlogPos":102629088,"createdDate":1764429362}

{"id":"040f4007-b0f1-474e-b819-82d48bdfbc77","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.116000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64117, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141826, customername='nguyễn thế điền', customerphone='0795335203', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t4, ngày 14/12/2022\\nđc: nguyễn chí thanh, láng hạ, đống đa.', note='loại nhà: căn hộ\\ndiện tích: 60 - 90m2 mặt sàn\\nthời lượng: 4 nhân viên x 4 giờ\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-14 13:00:00', lastmatchat=timestamp'2022-12-13 15:44:54', address='91 nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='test', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.02005958557129, longitude=105.80879974365234, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2022-12-13 15:45:54', prioritizedmaids='[]', referenceid=3998, shifts='[{\\\"shiftid\\\":1261483,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-14t13:00:00\\\",\\\"totime\\\":\\\"2022-12-14t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":62000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-14 17:00:00', type=4 where id=3749","binlogFileName":"mysql-bin.000167","binlogPos":102631077,"createdDate":1764429362}

{"id":"4cca3812-c1ae-4538-a716-f68180c59ee5","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.131000', updated_by='svc_client', active=1, ancestorjobid=3740, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64110, contracttype=2, holidaycontract=0, leaderid=3161, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t3, ngày 13/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 30 - 60m2 mặt sàn\\nthời lượng: 2 nhân viên x 4 giờ\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-13 13:00:00', lastmatchat=timestamp'2022-12-12 17:56:00', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=10, nextmatchat=timestamp'2022-12-12 17:57:00', prioritizedmaids='[]', referenceid=3990, shifts='[{\\\"shiftid\\\":1261466,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-13t13:00:00\\\",\\\"totime\\\":\\\"2022-12-13t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":59000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-13 17:00:00', type=0 where id=3741","binlogFileName":"mysql-bin.000167","binlogPos":102633110,"createdDate":1764429362}

{"id":"14566b8e-ee4a-4071-93cb-0996770edc05","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.146000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64171, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t4, ngày 21/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: căn hộ\\ndiện tích: 90 - 120m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-21 08:00:00', lastmatchat=timestamp'2022-12-20 11:38:28', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2022-12-20 11:39:28', prioritizedmaids='[]', referenceid=4074, shifts='[{\\\"shiftid\\\":1261604,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-21t08:00:00\\\",\\\"totime\\\":\\\"2022-12-21t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":62000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-21 12:00:00', type=4 where id=3825","binlogFileName":"mysql-bin.000167","binlogPos":102635146,"createdDate":1764429362}

{"id":"e0b2e8c2-354f-4345-826f-09017006abcf","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.162000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64172, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t4, ngày 21/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 30 - 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-21 08:00:00', lastmatchat=timestamp'2022-12-20 11:56:35', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2022-12-20 11:57:35', prioritizedmaids='[]', referenceid=4075, shifts='[{\\\"shiftid\\\":1261608,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-21t08:00:00\\\",\\\"totime\\\":\\\"2022-12-21t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":62000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-21 12:00:00', type=4 where id=3826","binlogFileName":"mysql-bin.000167","binlogPos":102637128,"createdDate":1764429362}

{"id":"dc733313-2246-4d68-b022-006a1ae290ce","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.175000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=63455, contracttype=3, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=4, requiredleader=0, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"dùng lẻ\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-16:30 t5, ngày 24/11/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-11-24 13:00:00', lastmatchat=timestamp'2022-11-21 16:15:00', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=4, nextmatchat=timestamp'2022-11-21 16:16:00', prioritizedmaids='[]', referenceid=3799, shifts='[{\\\"shiftid\\\":1258929,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-11-24t13:00:00\\\",\\\"totime\\\":\\\"2022-11-24t16:30:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":65000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":false,\\\"forleader\\\":null,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-11-24 16:30:00', type=0 where id=3575","binlogFileName":"mysql-bin.000167","binlogPos":102639117,"createdDate":1764429362}

{"id":"c12cd783-ed6c-4b8f-ba8a-0886231a711b","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.184000', updated_by='svc_client', active=1, ancestorjobid=3880, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64214, contracttype=2, holidaycontract=0, leaderid=141821, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t4, ngày 28/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: dưới 60m2 mặt sàn\\ntest', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-28 08:00:00', lastmatchat=timestamp'2022-12-27 09:47:00', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=10, nextmatchat=timestamp'2022-12-27 09:48:00', prioritizedmaids='[]', referenceid=4130, shifts='[{\\\"shiftid\\\":1261694,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-28t08:00:00\\\",\\\"totime\\\":\\\"2022-12-28t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":62000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1261695,\\\"maidid\\\":140190,\\\"fromtime\\\":\\\"2022-12-28t08:00:00\\\",\\\"totime\\\":\\\"2022-12-28t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":62000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-28 12:00:00', type=0 where id=3881","binlogFileName":"mysql-bin.000167","binlogPos":102641033,"createdDate":1764429362}

{"id":"2f70a6a8-cac9-42e1-9da8-6bd8795a5592","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.193000', updated_by='svc_client', active=1, ancestorjobid=3876, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64212, contracttype=2, holidaycontract=0, leaderid=141930, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 17:00-21:00 t3, ngày 27/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 30 - 60m2 mặt sàn\\ntest jv', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-27 17:00:00', lastmatchat=timestamp'2022-12-26 17:14:00', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=10, nextmatchat=timestamp'2022-12-26 17:15:00', prioritizedmaids='[]', referenceid=4126, shifts='[{\\\"shiftid\\\":1261690,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-27t17:00:00\\\",\\\"totime\\\":\\\"2022-12-27t21:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":59000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-27 21:00:00', type=0 where id=3877","binlogFileName":"mysql-bin.000167","binlogPos":102643396,"createdDate":1764429362}

{"id":"a9286de5-88b0-406f-878c-f9a035dcb501","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.205000', updated_by='svc_client', active=1, ancestorjobid=3873, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64210, contracttype=2, holidaycontract=0, leaderid=3161, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t3, ngày 27/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 30 - 60m2 mặt sàn\\ntest tvs', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-27 08:00:00', lastmatchat=timestamp'2022-12-26 17:05:00', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=10, nextmatchat=timestamp'2022-12-26 17:06:00', prioritizedmaids='[]', referenceid=4123, shifts='[{\\\"shiftid\\\":1261686,\\\"maidid\\\":141930,\\\"fromtime\\\":\\\"2022-12-27t08:00:00\\\",\\\"totime\\\":\\\"2022-12-27t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":59000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1261687,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-27t08:00:00\\\",\\\"totime\\\":\\\"2022-12-27t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":59000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-27 12:00:00', type=0 where id=3874","binlogFileName":"mysql-bin.000167","binlogPos":102645399,"createdDate":1764429362}

{"id":"4568125e-f199-4d7e-a4b6-bea666075dd4","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.230000', updated_by='svc_client', active=1, ancestorjobid=3871, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64209, contracttype=2, holidaycontract=0, leaderid=3161, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t3, ngày 27/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 30 - 60m2 mặt sàn\\ntest tvs', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-27 13:00:00', lastmatchat=timestamp'2022-12-26 16:29:00', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=10, nextmatchat=timestamp'2022-12-26 16:30:00', prioritizedmaids='[]', referenceid=4121, shifts='[{\\\"shiftid\\\":1261683,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-27t13:00:00\\\",\\\"totime\\\":\\\"2022-12-27t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":59000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1261684,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-27t13:00:00\\\",\\\"totime\\\":\\\"2022-12-27t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":59000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-27 17:00:00', type=0 where id=3872","binlogFileName":"mysql-bin.000167","binlogPos":102647761,"createdDate":1764429362}

{"id":"cf7c0188-df05-42cd-ac61-f5805601c334","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.241000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64197, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=142017, customername='quandt 03', customerphone='0966611163', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t7, ngày 24/12/2022\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: dưới 30m2 mặt sàn\\ntest', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-24 08:00:00', lastmatchat=timestamp'2022-12-23 09:16:36', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 a', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.022565841674805, longitude=105.80961608886719, wardid=4, wardname='láng thượng', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2022-12-23 09:17:36', prioritizedmaids='[]', referenceid=4106, shifts='[{\\\"shiftid\\\":1261660,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-24t08:00:00\\\",\\\"totime\\\":\\\"2022-12-24t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":68000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-24 12:00:00', type=4 where id=3857","binlogFileName":"mysql-bin.000167","binlogPos":102650124,"createdDate":1764429362}

{"id":"f7995925-80ca-4c53-bf3b-7f2ac7af77ac","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.253000', updated_by='svc_client', active=1, ancestorjobid=3855, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64196, contracttype=2, holidaycontract=0, leaderid=3161, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 17:00-21:00 cn, ngày 25/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 30 - 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-25 17:00:00', lastmatchat=timestamp'2022-12-22 17:53:00', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=10, nextmatchat=timestamp'2022-12-22 17:54:00', prioritizedmaids='[]', referenceid=4105, shifts='[{\\\"shiftid\\\":1261658,\\\"maidid\\\":141930,\\\"fromtime\\\":\\\"2022-12-25t17:00:00\\\",\\\"totime\\\":\\\"2022-12-25t21:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":68000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1261659,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-25t17:00:00\\\",\\\"totime\\\":\\\"2022-12-25t21:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":68000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-25 21:00:00', type=0 where id=3856","binlogFileName":"mysql-bin.000167","binlogPos":102652096,"createdDate":1764429362}

{"id":"89f907ca-3ced-4016-becd-7b5aa9785a4b","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.267000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64193, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t6, ngày 23/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 30 - 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-23 13:00:00', lastmatchat=timestamp'2022-12-22 16:42:48', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2022-12-22 16:43:48', prioritizedmaids='[]', referenceid=4099, shifts='[{\\\"shiftid\\\":1261651,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-23t13:00:00\\\",\\\"totime\\\":\\\"2022-12-23t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":68000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-23 17:00:00', type=4 where id=3850","binlogFileName":"mysql-bin.000167","binlogPos":102654450,"createdDate":1764429362}

{"id":"7e779dfd-587a-4983-8022-5b416528611d","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.279000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64192, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t6, ngày 23/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 30 - 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-23 13:00:00', lastmatchat=timestamp'2022-12-22 16:25:18', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2022-12-22 16:26:18', prioritizedmaids='[]', referenceid=4098, shifts='[{\\\"shiftid\\\":1261649,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-23t13:00:00\\\",\\\"totime\\\":\\\"2022-12-23t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":68000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-23 17:00:00', type=4 where id=3849","binlogFileName":"mysql-bin.000167","binlogPos":102656439,"createdDate":1764429362}

{"id":"3eb764ea-9fd8-4567-ac65-257089fb7c49","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.293000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64191, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t6, ngày 23/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 30 - 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-23 13:00:00', lastmatchat=timestamp'2022-12-22 15:40:14', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2022-12-22 15:41:14', prioritizedmaids='[]', referenceid=4097, shifts='[{\\\"shiftid\\\":1261646,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-23t13:00:00\\\",\\\"totime\\\":\\\"2022-12-23t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":68000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-23 17:00:00', type=4 where id=3848","binlogFileName":"mysql-bin.000167","binlogPos":102658428,"createdDate":1764429362}

{"id":"4f5ad846-ca7c-43a5-9e40-372e4e8090b8","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.305000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64179, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t5, ngày 22/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 30 - 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-22 13:00:00', lastmatchat=timestamp'2022-12-21 17:52:05', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2022-12-21 17:53:05', prioritizedmaids='[]', referenceid=4094, shifts='[{\\\"shiftid\\\":1261622,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-22t13:00:00\\\",\\\"totime\\\":\\\"2022-12-22t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":62000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":true,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-22 17:00:00', type=4 where id=3845","binlogFileName":"mysql-bin.000167","binlogPos":102660417,"createdDate":1764429362}

{"id":"736110cc-9b97-4df9-93f7-12339511551e","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.315000', updated_by='svc_client', active=1, ancestorjobid=3837, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64181, contracttype=2, holidaycontract=0, leaderid=3161, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t6, ngày 23/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 30 - 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-23 08:00:00', lastmatchat=timestamp'2022-12-21 15:43:00', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=10, nextmatchat=timestamp'2022-12-21 15:44:00', prioritizedmaids='[]', referenceid=4087, shifts='[{\\\"shiftid\\\":1261629,\\\"maidid\\\":141930,\\\"fromtime\\\":\\\"2022-12-23t08:00:00\\\",\\\"totime\\\":\\\"2022-12-23t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":68000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1261630,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-23t08:00:00\\\",\\\"totime\\\":\\\"2022-12-23t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":68000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-23 12:00:00', type=0 where id=3838","binlogFileName":"mysql-bin.000167","binlogPos":102662406,"createdDate":1764429362}

{"id":"bfb39ff8-6250-4a4b-a594-126a6786295d","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.326000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64180, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141765, customername='tu hoang', customerphone='0989131326', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t5, ngày 22/12/2022\\nđc: nguyễn chí thanh, lang ha, đống đa.', note='loại nhà: căn hộ\\ndiện tích: 60 - 90m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-22 13:00:00', lastmatchat=timestamp'2022-12-21 15:38:26', address='91 nguyễn chí thanh, lang ha, đống đa, hanoi, vietnam', addressdetail='91 nguyễn chí thanh, lang ha, đống đa, hanoi, vietnam, láng hạ, đống đa, hà nội, việt nam.', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.015148162841797, longitude=105.81246948242188, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2022-12-21 15:39:26', prioritizedmaids='[]', referenceid=4085, shifts='[{\\\"shiftid\\\":1261625,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-22t13:00:00\\\",\\\"totime\\\":\\\"2022-12-22t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":62000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-22 17:00:00', type=4 where id=3836","binlogFileName":"mysql-bin.000167","binlogPos":102664760,"createdDate":1764429362}

{"id":"9f434dd6-876e-4900-9f17-dc0dfd7131a7","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.340000', updated_by='svc_client', active=1, ancestorjobid=3832, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64178, contracttype=2, holidaycontract=0, leaderid=3161, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t5, ngày 22/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 30 - 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-22 13:00:00', lastmatchat=timestamp'2022-12-21 13:33:01', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=10, nextmatchat=timestamp'2022-12-21 13:34:01', prioritizedmaids='[]', referenceid=4082, shifts='[{\\\"shiftid\\\":1261620,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-22t13:00:00\\\",\\\"totime\\\":\\\"2022-12-22t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":62000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1261621,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-22t13:00:00\\\",\\\"totime\\\":\\\"2022-12-22t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":62000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-22 17:00:00', type=0 where id=3833","binlogFileName":"mysql-bin.000167","binlogPos":102666830,"createdDate":1764429362}

{"id":"9e5e1390-2707-4f7e-baff-b58d120ae243","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.350000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64221, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141826, customername='nguyễn thế điền', customerphone='0795335203', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t4, ngày 04/01/2023\\nđc: nguyễn chí thanh, láng hạ, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: dưới 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2023-01-04 08:00:00', lastmatchat=timestamp'2022-12-28 13:34:56', address='91 nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='test', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.02005958557129, longitude=105.80879974365234, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2022-12-28 13:35:56', prioritizedmaids='[]', referenceid=4139, shifts='[{\\\"shiftid\\\":1261710,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-01-04t08:00:00\\\",\\\"totime\\\":\\\"2023-01-04t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-01-04 12:00:00', type=4 where id=3890","binlogFileName":"mysql-bin.000167","binlogPos":102669185,"createdDate":1764429362}

{"id":"41122e38-80f9-4721-90f1-6d23b485e792","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:16:02.360000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64177, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t5, ngày 22/12/2022\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: nhà mặt đất\\ndiện tích: 30 - 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2022-12-22 08:00:00', lastmatchat=timestamp'2022-12-21 10:49:25', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2022-12-21 10:50:25', prioritizedmaids='[]', referenceid=4080, shifts='[{\\\"shiftid\\\":1261616,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2022-12-22t08:00:00\\\",\\\"totime\\\":\\\"2022-12-22t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":62000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2022-12-22 12:00:00', type=4 where id=3831","binlogFileName":"mysql-bin.000167","binlogPos":102671188,"createdDate":1764429362}

{"id":"c613f43f-5e46-44f3-abbd-1c17500cd21f","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.195000', updated_by='svc_client', active=1, ancestorjobid=6993, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=67202, contracttype=2, holidaycontract=0, leaderid=142381, periodtype=-1, productpackageid=1, requiredleader=1, customerid=142260, customername='thanh18', customerphone='0961990018', customersegmentid=2, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t4, ngày 08/01/2025\\nđc: xã đàn, nam đồng.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2025-01-08 08:00:00', lastmatchat=timestamp'2025-01-07 15:42:01', address='420 xã đàn, nam đồng, đống đa, hà nội', addressdetail='420', addressid=7807, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020217895507812, longitude=105.80853271484375, wardid=11, wardname='nam đồng', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2025-01-07 15:43:01', prioritizedmaids='[]', referenceid=7284, shifts='[{\\\"shiftid\\\":1271807,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2025-01-08t08:00:00\\\",\\\"totime\\\":\\\"2025-01-08t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":10.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2025-01-08 12:00:00', type=0 where id=6994","binlogFileName":"mysql-bin.000167","binlogPos":102673177,"createdDate":1764429420}

{"id":"23cbfc60-a2f1-4e0a-bece-8da0e4697234","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.210000', updated_by='svc_client', active=1, ancestorjobid=5080, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65430, contracttype=2, holidaycontract=0, leaderid=139883, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t7, 08:00-12:00 t7, 08:00-09:00 t7, ngày 29/07/2023\\nđc: nguyễn chí thanh, thành công, đống đa.', note='', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-07-29 08:00:00', lastmatchat=timestamp'2023-07-28 10:57:01', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2023-07-28 11:02:01', prioritizedmaids='[]', referenceid=5349, shifts='[{\\\"shiftid\\\":1265635,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-07-29t08:00:00\\\",\\\"totime\\\":\\\"2023-07-29t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1265636,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-07-29t08:00:00\\\",\\\"totime\\\":\\\"2023-07-29t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1265637,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-07-29t08:00:00\\\",\\\"totime\\\":\\\"2023-07-29t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-07-29 12:00:00', type=0 where id=5081","binlogFileName":"mysql-bin.000167","binlogPos":102675115,"createdDate":1764429420}

{"id":"f764a7e9-5e30-4620-9a7b-724cc07bb247","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.223000', updated_by='svc_client', active=1, ancestorjobid=5033, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65387, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141765, customername='tu hoang', customerphone='0989131326', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t5, 08:00-12:00 t5, 08:00-09:00 t5, ngày 20/07/2023\\nđc: nguyễn chí thanh, lang ha, đống đa.', note='loại nhà: căn hộ\\ndiện tích: 150 - 180m2 tổng sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-07-20 11:15:00', lastmatchat=timestamp'2023-07-19 14:20:04', address='91 nguyễn chí thanh, lang ha, đống đa, hanoi, vietnam', addressdetail='91 nguyễn chí thanh, lang ha, đống đa, hanoi, vietnam, láng hạ, đống đa, hà nội, việt nam.', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.015148162841797, longitude=105.81246948242188, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2023-07-19 17:20:04', prioritizedmaids='[]', referenceid=5303, shifts='[{\\\"shiftid\\\":1265570,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-07-20t11:15:00\\\",\\\"totime\\\":\\\"2023-07-20t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":0,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-07-20 12:00:00', type=4 where id=5035","binlogFileName":"mysql-bin.000167","binlogPos":102677786,"createdDate":1764429420}

{"id":"d1f68503-6fb2-4444-81cd-1d20cbd2e5b6","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.236000', updated_by='svc_client', active=1, ancestorjobid=4985, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65332, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141866, customername='test222', customerphone='0961888222', customersegmentid=1, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t5, 08:00-12:00 t5, 08:00-09:00 t5, ngày 06/07/2023\\nđc: đường nguyễn chí thanh, láng hạ, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-07-06 11:15:00', lastmatchat=timestamp'2023-07-05 13:44:40', address='91 đường nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020977020263672, longitude=105.80912780761719, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2023-07-05 16:44:40', prioritizedmaids='[]', referenceid=5254, shifts='[{\\\"shiftid\\\":1265196,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-07-06t11:15:00\\\",\\\"totime\\\":\\\"2023-07-06t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":0,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-07-06 12:00:00', type=4 where id=4987","binlogFileName":"mysql-bin.000167","binlogPos":102679879,"createdDate":1764429420}

{"id":"119b35a4-8918-4630-909b-1de7be9c2422","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.250000', updated_by='svc_client', active=1, ancestorjobid=4853, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65183, contracttype=2, holidaycontract=0, leaderid=3161, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141765, customername='tu hoang', customerphone='0989131326', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t6, 08:00-12:00 t6, 08:00-09:00 t6, ngày 23/06/2023\\nđc: nguyễn chí thanh, lang ha, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-06-23 08:00:00', lastmatchat=timestamp'2023-06-22 14:44:00', address='91 nguyễn chí thanh, lang ha, đống đa, hanoi, vietnam', addressdetail='91 nguyễn chí thanh, lang ha, đống đa, hanoi, vietnam, láng hạ, đống đa, hà nội, việt nam.', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.015148162841797, longitude=105.81246948242188, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2023-06-22 14:49:00', prioritizedmaids='[]', referenceid=5117, shifts='[{\\\"shiftid\\\":1264892,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-06-23t08:00:00\\\",\\\"totime\\\":\\\"2023-06-23t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1264893,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-06-23t08:00:00\\\",\\\"totime\\\":\\\"2023-06-23t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-06-23 12:00:00', type=0 where id=4854","binlogFileName":"mysql-bin.000167","binlogPos":102681895,"createdDate":1764429420}

{"id":"1d06adb6-380b-4143-ab11-99ae44fe7984","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.263000', updated_by='svc_client', active=1, ancestorjobid=4813, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65152, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141826, customername='nguyễn thế điền', customerphone='0795335203', customersegmentid=1, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t2, 08:00-12:00 t2, 08:00-09:00 t2, ngày 26/06/2023\\nđc: nguyễn chí thanh, láng hạ, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-06-26 11:15:00', lastmatchat=timestamp'2023-06-20 16:35:28', address='91 nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='test', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.02005958557129, longitude=105.80879974365234, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2023-06-20 19:35:28', prioritizedmaids='[]', referenceid=5078, shifts='[{\\\"shiftid\\\":1264796,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-06-26t11:15:00\\\",\\\"totime\\\":\\\"2023-06-26t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":0,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-06-26 12:00:00', type=4 where id=4815","binlogFileName":"mysql-bin.000167","binlogPos":102684358,"createdDate":1764429420}

{"id":"a2f45c74-8e65-4d82-8602-e6f4d116fbd6","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.277000', updated_by='svc_client', active=1, ancestorjobid=4781, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65128, contracttype=2, holidaycontract=0, leaderid=3161, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141826, customername='nguyễn thế điền', customerphone='0795335203', customersegmentid=1, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 cn, 08:00-12:00 cn, 08:00-09:00 cn, ngày 18/06/2023\\nđc: nguyễn chí thanh, láng hạ, đống đa.', note='loại nhà: căn hộ\\ndiện tích: 60 - 90m2 tổng sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-06-18 08:00:00', lastmatchat=timestamp'2023-06-17 14:46:02', address='91 nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='test', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.02005958557129, longitude=105.80879974365234, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2023-06-17 14:51:02', prioritizedmaids='[]', referenceid=5045, shifts='[{\\\"shiftid\\\":1264727,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-06-18t08:00:00\\\",\\\"totime\\\":\\\"2023-06-18t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1264728,\\\"maidid\\\":140341,\\\"fromtime\\\":\\\"2023-06-18t08:00:00\\\",\\\"totime\\\":\\\"2023-06-18t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1264729,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-06-18t08:00:00\\\",\\\"totime\\\":\\\"2023-06-18t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1264730,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-06-18t08:00:00\\\",\\\"totime\\\":\\\"2023-06-18t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-06-18 12:00:00', type=0 where id=4782","binlogFileName":"mysql-bin.000167","binlogPos":102686373,"createdDate":1764429420}

{"id":"c328662a-82a3-404c-b721-c364f513d847","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.290000', updated_by='svc_client', active=1, ancestorjobid=4582, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64952, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='quan dt 009', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t7, 08:00-12:00 t7, 08:00-09:00 t7, ngày 20/05/2023\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-05-20 11:15:00', lastmatchat=timestamp'2023-05-19 14:10:56', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 b', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.022565841674805, longitude=105.80961608886719, wardid=4, wardname='láng thượng', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2023-05-19 14:15:56', prioritizedmaids='[]', referenceid=4847, shifts='[{\\\"shiftid\\\":1264082,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-05-20t11:15:00\\\",\\\"totime\\\":\\\"2023-05-20t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":0,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-05-20 12:00:00', type=4 where id=4584","binlogFileName":"mysql-bin.000167","binlogPos":102689480,"createdDate":1764429420}

{"id":"629d1fbc-a704-4f0b-8302-eb6633049de9","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.301000', updated_by='svc_client', active=1, ancestorjobid=4234, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64654, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141826, customername='nguyễn thế điền', customerphone='0795335203', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t6, 08:00-12:00 t6, 08:00-09:00 t6, ngày 14/04/2023\\nđc: nguyễn chí thanh, láng hạ, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-04-14 11:15:00', lastmatchat=timestamp'2023-04-08 08:40:52', address='91 nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='test', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.02005958557129, longitude=105.80879974365234, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2023-04-08 08:45:52', prioritizedmaids='[]', referenceid=4498, shifts='[{\\\"shiftid\\\":1263283,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-04-14t11:15:00\\\",\\\"totime\\\":\\\"2023-04-14t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":0,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-04-14 12:00:00', type=4 where id=4236","binlogFileName":"mysql-bin.000167","binlogPos":102691465,"createdDate":1764429420}

{"id":"e3e66715-deb0-4eee-81ec-3e77ae6cc92e","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.309000', updated_by='svc_client', active=1, ancestorjobid=4224, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64648, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141826, customername='nguyễn thế điền', customerphone='0795335203', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 cn, 08:00-12:00 cn, 08:00-09:00 cn, ngày 09/04/2023\\nđc: nguyễn chí thanh, láng hạ, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-04-09 11:15:00', lastmatchat=timestamp'2023-04-07 17:21:15', address='91 nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='test', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.02005958557129, longitude=105.80879974365234, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2023-04-07 17:26:15', prioritizedmaids='[]', referenceid=4488, shifts='[{\\\"shiftid\\\":1263264,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-04-09t11:15:00\\\",\\\"totime\\\":\\\"2023-04-09t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":0,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-04-09 12:00:00', type=4 where id=4226","binlogFileName":"mysql-bin.000167","binlogPos":102693482,"createdDate":1764429420}

{"id":"e6290b19-5473-4be4-8fb4-f734d843d3cf","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.317000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64637, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=142016, customername='quan dt', customerphone='0966611162', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 17:00-18:00 t6, 17:00-21:00 t6, 20:15-21:00 t6, ngày 07/04/2023\\nđc: đường nguyễn chí thanh, láng hạ, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-04-07 17:00:00', lastmatchat=timestamp'2023-04-07 11:30:01', address='91 đường nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='m3-m4', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020427703857422, longitude=105.80892181396484, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2023-04-07 11:35:01', prioritizedmaids='[]', referenceid=4470, shifts='[{\\\"shiftid\\\":1263215,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-04-07t17:00:00\\\",\\\"totime\\\":\\\"2023-04-07t18:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":0,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1263216,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-04-07t20:15:00\\\",\\\"totime\\\":\\\"2023-04-07t21:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":0,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-04-07 21:00:00', type=4 where id=4208","binlogFileName":"mysql-bin.000167","binlogPos":102695499,"createdDate":1764429420}

{"id":"0c4c05b9-9fc7-446e-9933-7937793eeb76","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.329000', updated_by='svc_client', active=1, ancestorjobid=4063, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64480, contracttype=2, holidaycontract=0, leaderid=141625, periodtype=-1, productpackageid=1, requiredleader=1, customerid=142182, customername='pham viet hoang 3', customerphone='0904521431', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t6, ngày 24/03/2023\\nđc: nguyễn chí thanh, quận đống đa, thành công, ba đình.', note='loại nhà: biệt thự\\ndiện tích: 180 - 210m2 mặt sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-03-24 13:00:00', lastmatchat=timestamp'2023-03-14 09:33:06', address='91, nguyễn chí thanh, quận đống đa, thành công, ba đình, hà nội, việt nam', addressdetail='tầng 14', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.019901275634766, longitude=105.80845642089844, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2023-03-14 09:34:06', prioritizedmaids='[]', referenceid=4326, shifts='[{\\\"shiftid\\\":1262620,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-03-24t13:00:00\\\",\\\"totime\\\":\\\"2023-03-24t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1262621,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-03-24t13:00:00\\\",\\\"totime\\\":\\\"2023-03-24t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1262622,\\\"maidid\\\":141930,\\\"fromtime\\\":\\\"2023-03-24t13:00:00\\\",\\\"totime\\\":\\\"2023-03-24t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1262623,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-03-24t13:00:00\\\",\\\"totime\\\":\\\"2023-03-24t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1262624,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-03-24t13:00:00\\\",\\\"totime\\\":\\\"2023-03-24t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1262625,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-03-24t13:00:00\\\",\\\"totime\\\":\\\"2023-03-24t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-03-24 17:00:00', type=0 where id=4064","binlogFileName":"mysql-bin.000167","binlogPos":102697879,"createdDate":1764429420}

{"id":"355115a6-33af-4ee2-b54c-377d206d1ca0","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.348000', updated_by='svc_client', active=1, ancestorjobid=4028, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64446, contracttype=2, holidaycontract=0, leaderid=141625, periodtype=-1, productpackageid=1, requiredleader=1, customerid=142182, customername='pham viet hoang 3', customerphone='0904521431', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 17:00-21:00 t5, ngày 09/03/2023\\nđc: nguyễn chí thanh, quận đống đa, thành công, ba đình.', note='loại nhà: văn phòng\\ndiện tích: 90 - 120m2 mặt sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-03-09 17:00:00', lastmatchat=timestamp'2023-03-09 04:49:00', address='91, nguyễn chí thanh, quận đống đa, thành công, ba đình, hà nội, việt nam', addressdetail='tầng 14', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.019901275634766, longitude=105.80845642089844, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=10, nextmatchat=timestamp'2023-03-09 04:50:00', prioritizedmaids='[]', referenceid=4291, shifts='[{\\\"shiftid\\\":1262517,\\\"maidid\\\":3161,\\\"fromtime\\\":\\\"2023-03-09t17:00:00\\\",\\\"totime\\\":\\\"2023-03-09t21:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1262518,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-03-09t17:00:00\\\",\\\"totime\\\":\\\"2023-03-09t21:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1262519,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-03-09t17:00:00\\\",\\\"totime\\\":\\\"2023-03-09t21:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-03-09 21:00:00', type=0 where id=4029","binlogFileName":"mysql-bin.000167","binlogPos":102701729,"createdDate":1764429420}

{"id":"0fb10b9b-c783-4958-b28b-4c2966d30a82","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.360000', updated_by='svc_client', active=1, ancestorjobid=4014, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64431, contracttype=2, holidaycontract=0, leaderid=141821, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 17:00-21:00 t7, ngày 25/02/2023\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-02-25 17:00:00', lastmatchat=timestamp'2023-02-25 08:34:00', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=10, nextmatchat=timestamp'2023-02-25 08:35:00', prioritizedmaids='[]', referenceid=4264, shifts='[{\\\"shiftid\\\":1262489,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-02-25t17:00:00\\\",\\\"totime\\\":\\\"2023-02-25t21:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-02-25 21:00:00', type=0 where id=4015","binlogFileName":"mysql-bin.000167","binlogPos":102704489,"createdDate":1764429420}

{"id":"cc50cf9e-b2aa-408f-8bac-f3e35c67d3ff","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.373000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=64416, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141831, customername='thành666', customerphone='0961888666', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 17:00-21:00 t4, ngày 15/02/2023\\nđc: nguyễn chí thanh, thành công, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 mặt sàn\\n', retailshipmentids=null, toolrequired=0, fromtime=timestamp'2023-02-15 17:00:00', lastmatchat=timestamp'2023-02-15 11:30:08', address='91 nguyễn chí thanh, thành công, đống đa, hà nội, việt nam', addressdetail='91', addressid=null, areaid=null, areaname=null, cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020536422729492, longitude=105.80963134765625, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2023-02-15 11:31:08', prioritizedmaids='[]', referenceid=4254, shifts='[{\\\"shiftid\\\":1262271,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-02-15t17:00:00\\\",\\\"totime\\\":\\\"2023-02-15t21:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":225000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":null,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-02-15 21:00:00', type=4 where id=4005","binlogFileName":"mysql-bin.000167","binlogPos":102706481,"createdDate":1764429420}

{"id":"dfc8c427-d40f-4773-a1fd-a7440974266a","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.386000', updated_by='svc_client', active=1, ancestorjobid=5089, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65441, contracttype=2, holidaycontract=0, leaderid=139883, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='quan dt 009', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t4, 08:00-12:00 t4, 08:00-09:00 t4, ngày 09/08/2023\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids=null, toolrequired=1, fromtime=timestamp'2023-08-09 08:00:00', lastmatchat=timestamp'2023-08-08 16:53:01', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 b', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.022565841674805, longitude=105.80961608886719, wardid=4, wardname='láng thượng', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2023-08-08 16:58:01', prioritizedmaids='[]', referenceid=5358, shifts='[{\\\"shiftid\\\":1265650,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-08-09t08:00:00\\\",\\\"totime\\\":\\\"2023-08-09t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1265651,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-08-09t08:00:00\\\",\\\"totime\\\":\\\"2023-08-09t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1265652,\\\"maidid\\\":141821,\\\"fromtime\\\":\\\"2023-08-09t08:00:00\\\",\\\"totime\\\":\\\"2023-08-09t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-08-09 12:00:00', type=0 where id=5090","binlogFileName":"mysql-bin.000167","binlogPos":102708466,"createdDate":1764429420}

{"id":"2cc5f5b3-c5a1-485b-8e1f-cf816631cf30","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.401000', updated_by='svc_client', active=1, ancestorjobid=5439, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65810, contracttype=2, holidaycontract=0, leaderid=141821, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141826, customername='nguyễn thế điền', customerphone='0795335203', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t3, 08:00-12:00 t3, 08:00-09:00 t3, ngày 28/11/2023\\nđc: nguyễn chí thanh, láng hạ, đống đa.', note='loại nhà: căn hộ\\ndiện tích: 60 - 90m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2023-11-28 08:00:00', lastmatchat=timestamp'2023-11-27 16:23:00', address='91 nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='test', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.02005958557129, longitude=105.80879974365234, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2023-11-27 16:28:00', prioritizedmaids='[]', referenceid=5714, shifts='[{\\\"shiftid\\\":1266655,\\\"maidid\\\":141605,\\\"fromtime\\\":\\\"2023-11-28t08:00:00\\\",\\\"totime\\\":\\\"2023-11-28t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":95000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1266656,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-11-28t08:00:00\\\",\\\"totime\\\":\\\"2023-11-28t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":95000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1266657,\\\"maidid\\\":141611,\\\"fromtime\\\":\\\"2023-11-28t08:00:00\\\",\\\"totime\\\":\\\"2023-11-28t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":95000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-11-28 12:00:00', type=0 where id=5440","binlogFileName":"mysql-bin.000167","binlogPos":102711178,"createdDate":1764429420}

{"id":"10a2b87b-7831-4551-97df-6a4cdfe37c9b","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.415000', updated_by='svc_client', active=1, ancestorjobid=null, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[29]', contractid=67152, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='dang the quan', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype='all_shifts', bonus=0, cashtocollect=0, customercarenote='', forleader=1, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t5, 08:00-09:00 t5, ngày 26/12/2024\\nđc: a đường nguyễn chí thanh, láng hạ.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\ncẩn thận đồ dễ vỡ', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2024-12-26 08:00:00', lastmatchat=timestamp'2024-12-25 15:09:35', address='91a đường nguyễn chí thanh, láng hạ, đống đa, hà nội', addressdetail='p1309, tầng 13', addressid=7870, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020227432250977, longitude=105.80854034423828, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=1, nextmatchat=timestamp'2024-12-25 18:09:35', prioritizedmaids='[]', referenceid=7211, shifts='[{\\\"shiftid\\\":1271643,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-12-26t08:00:00\\\",\\\"totime\\\":\\\"2024-12-26t09:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":0,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1271644,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-12-26t11:15:00\\\",\\\"totime\\\":\\\"2024-12-26t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":0,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":true,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2024-12-26 12:00:00', type=4 where id=6921","binlogFileName":"mysql-bin.000167","binlogPos":102713918,"createdDate":1764429420}

{"id":"333bd503-c355-4fc5-a662-e962cca53d51","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.429000', updated_by='svc_client', active=1, ancestorjobid=6608, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=66755, contracttype=2, holidaycontract=0, leaderid=141821, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='đặng thế quân', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t5, ngày 12/09/2024\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2024-09-12 08:00:00', lastmatchat=timestamp'2024-09-11 11:01:00', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 a', addressid=7818, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020057678222656, longitude=105.80872344970703, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2024-09-11 11:06:00', prioritizedmaids='[]', referenceid=6893, shifts='[{\\\"shiftid\\\":1269868,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-09-12t08:00:00\\\",\\\"totime\\\":\\\"2024-09-12t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2024-09-12 12:00:00', type=0 where id=6609","binlogFileName":"mysql-bin.000167","binlogPos":102716310,"createdDate":1764429420}

{"id":"ae9ae077-d666-410d-9a49-77e14a2627c4","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.444000', updated_by='svc_client', active=1, ancestorjobid=6603, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=66754, contracttype=2, holidaycontract=0, leaderid=16296, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='đặng thế quân', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t5, ngày 12/09/2024\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2024-09-12 08:00:00', lastmatchat=timestamp'2024-09-11 11:00:01', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 a', addressid=7818, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020057678222656, longitude=105.80872344970703, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2024-09-11 11:05:01', prioritizedmaids='[]', referenceid=6888, shifts='[{\\\"shiftid\\\":1269863,\\\"maidid\\\":141611,\\\"fromtime\\\":\\\"2024-09-12t08:00:00\\\",\\\"totime\\\":\\\"2024-09-12t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1269864,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-09-12t08:00:00\\\",\\\"totime\\\":\\\"2024-09-12t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2024-09-12 12:00:00', type=0 where id=6604","binlogFileName":"mysql-bin.000167","binlogPos":102718276,"createdDate":1764429420}

{"id":"f618dc9d-2941-4886-b1e8-e36562251970","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.456000', updated_by='svc_client', active=1, ancestorjobid=6593, autoaccept=0, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=66747, contracttype=2, holidaycontract=0, leaderid=16296, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='đặng thế quân', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t7, ngày 07/09/2024\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2024-09-07 13:00:00', lastmatchat=timestamp'2024-09-06 11:12:00', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 a', addressid=7818, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020057678222656, longitude=105.80872344970703, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2024-09-06 11:17:00', prioritizedmaids='[]', referenceid=6878, shifts='[{\\\"shiftid\\\":1269853,\\\"maidid\\\":141611,\\\"fromtime\\\":\\\"2024-09-07t13:00:00\\\",\\\"totime\\\":\\\"2024-09-07t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1269854,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-09-07t13:00:00\\\",\\\"totime\\\":\\\"2024-09-07t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2024-09-07 17:00:00', type=0 where id=6594","binlogFileName":"mysql-bin.000167","binlogPos":102720599,"createdDate":1764429420}

{"id":"c74a4a97-014b-4269-be2e-c04598b186dd","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.467000', updated_by='svc_client', active=1, ancestorjobid=6587, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=66745, contracttype=2, holidaycontract=0, leaderid=141821, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='đặng thế quân', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t7, ngày 07/09/2024\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2024-09-07 08:00:00', lastmatchat=timestamp'2024-09-06 10:16:01', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 a', addressid=7818, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020057678222656, longitude=105.80872344970703, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2024-09-06 10:21:01', prioritizedmaids='[]', referenceid=6872, shifts='[{\\\"shiftid\\\":1269846,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-09-07t08:00:00\\\",\\\"totime\\\":\\\"2024-09-07t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2024-09-07 12:00:00', type=0 where id=6588","binlogFileName":"mysql-bin.000167","binlogPos":102722922,"createdDate":1764429420}

{"id":"c52966f9-fb3f-4b44-afc3-15be582c391d","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.479000', updated_by='svc_client', active=1, ancestorjobid=6412, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=66553, contracttype=2, holidaycontract=0, leaderid=16296, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='đặng thế quân', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-12:00 t5, ngày 25/07/2024\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\ntest', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2024-07-25 08:00:00', lastmatchat=timestamp'2024-07-24 17:38:00', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 a', addressid=7818, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020057678222656, longitude=105.80872344970703, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2024-07-24 17:43:00', prioritizedmaids='[]', referenceid=6696, shifts='[{\\\"shiftid\\\":1269275,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-07-25t08:00:00\\\",\\\"totime\\\":\\\"2024-07-25t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1269276,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-07-25t08:00:00\\\",\\\"totime\\\":\\\"2024-07-25t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2024-07-25 12:00:00', type=0 where id=6413","binlogFileName":"mysql-bin.000167","binlogPos":102724888,"createdDate":1764429420}

{"id":"911ae580-3fc1-484c-9fa9-ec66e826a2bd","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.491000', updated_by='svc_client', active=1, ancestorjobid=6214, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=66377, contracttype=2, holidaycontract=0, leaderid=16296, periodtype=-1, productpackageid=1, requiredleader=1, customerid=142260, customername='thanh18', customerphone='0961990018', customersegmentid=2, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-17:00 t4, ngày 03/04/2024\\nđc: láng hạ, phường láng hạ.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2024-04-03 13:00:00', lastmatchat=timestamp'2024-04-02 19:06:00', address='100 láng hạ, phường láng hạ, quận đống đa, thành phố hà nội', addressdetail='100 lh', addressid=7785, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.01149559020996, longitude=105.81134033203125, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2024-04-02 19:11:00', prioritizedmaids='[]', referenceid=6498, shifts='[{\\\"shiftid\\\":1268382,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-04-03t13:00:00\\\",\\\"totime\\\":\\\"2024-04-03t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1268383,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-04-03t13:00:00\\\",\\\"totime\\\":\\\"2024-04-03t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2024-04-03 17:00:00', type=0 where id=6215","binlogFileName":"mysql-bin.000167","binlogPos":102727216,"createdDate":1764429420}

{"id":"ecd07667-c80e-40b0-ba0b-5e03e8f3b2e4","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.503000', updated_by='svc_client', active=1, ancestorjobid=6328, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=66225, contracttype=2, holidaycontract=0, leaderid=0, periodtype=-1, productpackageid=5, requiredleader=0, customerid=141705, customername='bá thành 009', customerphone='0961990009', customersegmentid=2, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"định kỳ\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 08:00-11:30 t3 từ ngày 06/02/2024 đến ngày 09/04/2024\\nđc: nguyễn chí thanh, phường láng hạ.', note='', retailshipmentids='[]', toolrequired=0, fromtime=timestamp'2024-02-06 08:00:00', lastmatchat=timestamp'2024-01-29 12:42:01', address='91 nguyễn chí thanh, phường láng hạ, quận đống đa, thành phố hà nội', addressdetail='ds', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.020858764648438, longitude=105.8090591430664, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2024-01-29 12:47:01', prioritizedmaids='[]', referenceid=6330, shifts='[{\\\"shiftid\\\":1267810,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-02-06t08:00:00\\\",\\\"totime\\\":\\\"2024-02-06t11:30:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":160000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267802,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-02-20t08:00:00\\\",\\\"totime\\\":\\\"2024-02-20t11:30:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":146000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267804,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-02-27t08:00:00\\\",\\\"totime\\\":\\\"2024-02-27t11:30:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":97000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267806,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-03-05t08:00:00\\\",\\\"totime\\\":\\\"2024-03-05t11:30:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":97000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267803,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-03-12t08:00:00\\\",\\\"totime\\\":\\\"2024-03-12t11:30:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":97000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267807,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-03-19t08:00:00\\\",\\\"totime\\\":\\\"2024-03-19t11:30:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":97000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267805,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-03-26t08:00:00\\\",\\\"totime\\\":\\\"2024-03-26t11:30:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":97000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267808,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-04-02t08:00:00\\\",\\\"totime\\\":\\\"2024-04-02t11:30:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":97000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267809,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-04-09t08:00:00\\\",\\\"totime\\\":\\\"2024-04-09t11:30:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":160000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2024-04-09 11:30:00', type=0 where id=6047","binlogFileName":"mysql-bin.000167","binlogPos":102729551,"createdDate":1764429420}

{"id":"57ad0c3b-7c28-4e9f-8b6b-394230ae3f37","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.515000', updated_by='svc_client', active=1, ancestorjobid=6005, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=66183, contracttype=2, holidaycontract=0, leaderid=16296, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='quan dt 009', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-14:00 t4, 13:00-17:00 t4, 16:15-17:00 t4, ngày 24/01/2024\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2024-01-24 13:00:00', lastmatchat=timestamp'2024-01-23 10:31:01', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 a', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.022565841674805, longitude=105.80961608886719, wardid=4, wardname='láng thượng', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2024-01-23 10:36:01', prioritizedmaids='[]', referenceid=6289, shifts='[{\\\"shiftid\\\":1267699,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-01-24t13:00:00\\\",\\\"totime\\\":\\\"2024-01-24t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267700,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-01-24t13:00:00\\\",\\\"totime\\\":\\\"2024-01-24t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2024-01-24 17:00:00', type=0 where id=6006","binlogFileName":"mysql-bin.000167","binlogPos":102734369,"createdDate":1764429420}

{"id":"151ecdea-546b-4324-ba0a-7471283d9eaf","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.526000', updated_by='svc_client', active=1, ancestorjobid=5970, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=66156, contracttype=2, holidaycontract=0, leaderid=16296, periodtype=-1, productpackageid=1, requiredleader=1, customerid=142016, customername='quan dt', customerphone='0966611162', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t6, 08:00-12:00 t6, 08:00-09:00 t6, ngày 19/01/2024\\nđc: a nguyễn chí thanh, láng hạ, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2024-01-19 08:00:00', lastmatchat=timestamp'2024-01-18 16:47:01', address='91a nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='91a nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam, láng hạ, đống đa, hà nội, việt nam.', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.015148162841797, longitude=105.81246948242188, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2024-01-18 16:52:01', prioritizedmaids='[]', referenceid=6254, shifts='[{\\\"shiftid\\\":1267522,\\\"maidid\\\":141605,\\\"fromtime\\\":\\\"2024-01-19t08:00:00\\\",\\\"totime\\\":\\\"2024-01-19t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267523,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2024-01-19t08:00:00\\\",\\\"totime\\\":\\\"2024-01-19t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2024-01-19 12:00:00', type=0 where id=5971","binlogFileName":"mysql-bin.000167","binlogPos":102736722,"createdDate":1764429420}

{"id":"49796e3e-2fe6-45e0-985a-8b9461bdcc0f","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.536000', updated_by='svc_client', active=1, ancestorjobid=5844, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=66001, contracttype=2, holidaycontract=0, leaderid=141821, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141826, customername='nguyễn thế điền', customerphone='0795335203', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-14:00 t5, 13:00-17:00 t5, 16:15-17:00 t5, ngày 28/12/2023\\nđc: nguyễn chí thanh, láng hạ, đống đa.', note='', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2023-12-28 13:00:00', lastmatchat=timestamp'2023-12-25 19:34:00', address='91 nguyễn chí thanh, láng hạ, đống đa, hà nội, việt nam', addressdetail='test', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.02005958557129, longitude=105.80879974365234, wardid=8, wardname='láng hạ', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2023-12-25 19:39:00', prioritizedmaids='[]', referenceid=6127, shifts='[{\\\"shiftid\\\":1267208,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-12-28t13:00:00\\\",\\\"totime\\\":\\\"2023-12-28t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":100000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-12-28 17:00:00', type=0 where id=5845","binlogFileName":"mysql-bin.000167","binlogPos":102739211,"createdDate":1764429420}

{"id":"90c55f3f-dcab-4257-ae81-f6e0624a6b3b","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.548000', updated_by='svc_client', active=1, ancestorjobid=5720, autoaccept=null, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65952, contracttype=2, holidaycontract=0, leaderid=141821, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='quan dt 009', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 11:15-12:00 t3, 08:00-12:00 t3, 08:00-09:00 t3, ngày 19/12/2023\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: dưới 60m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2023-12-19 08:00:00', lastmatchat=timestamp'2023-12-18 17:01:01', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 e', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.022565841674805, longitude=105.80961608886719, wardid=4, wardname='láng thượng', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2023-12-18 17:06:01', prioritizedmaids='[]', referenceid=6003, shifts='[{\\\"shiftid\\\":1267011,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-12-19t08:00:00\\\",\\\"totime\\\":\\\"2023-12-19t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":95000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1267012,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-12-19t08:00:00\\\",\\\"totime\\\":\\\"2023-12-19t12:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":95000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-12-19 12:00:00', type=0 where id=5721","binlogFileName":"mysql-bin.000167","binlogPos":102741174,"createdDate":1764429420}

{"id":"d9d896a1-e81f-4764-8ab9-71e5de8ddcdc","sql":"update matching_job set updated_at=timestamp'2025-11-29 22:17:00.560000', updated_by='svc_client', active=1, ancestorjobid=5702, autoaccept=1, blacklistmaids='[]', canceledat=null, chosenmaids='[]', contractaddonids='[]', contractid=65944, contracttype=2, holidaycontract=0, leaderid=141821, periodtype=-1, productpackageid=1, requiredleader=1, customerid=141983, customername='quan dt 009', customerphone='0966611161', customersegmentid=null, deepcleaningleaderjobtype=null, bonus=0, cashtocollect=0, customercarenote='', forleader=0, labels='[{\\\"label\\\":\\\"tổng vệ sinh\\\",\\\"url\\\":null,\\\"color\\\":null,\\\"border\\\":null,\\\"background\\\":null}]', message='ca: 13:00-14:00 t7, 13:00-17:00 t7, 16:15-17:00 t7, ngày 16/12/2023\\nđc: nguyễn chí thanh, đống đa.', note='loại nhà: căn hộ\\ndiện tích: 90 - 120m2 tổng sàn\\n', retailshipmentids='[]', toolrequired=1, fromtime=timestamp'2023-12-16 13:00:00', lastmatchat=timestamp'2023-12-13 18:45:02', address='nguyễn chí thanh, đống đa, hà nội, việt nam', addressdetail='91 e', addressid=null, areaid=0, areaname='', cityid=2, cityname='hà nội', districtid=4, districtname='q. đống đa', latitude=21.022565841674805, longitude=105.80961608886719, wardid=4, wardname='láng thượng', maidtrainingjobtype=null, matchsuccessat=null, matchingstep=15, nextmatchat=timestamp'2023-12-13 18:50:02', prioritizedmaids='[]', referenceid=5985, shifts='[{\\\"shiftid\\\":1266952,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-12-16t13:00:00\\\",\\\"totime\\\":\\\"2023-12-16t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1266953,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-12-16t13:00:00\\\",\\\"totime\\\":\\\"2023-12-16t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1266954,\\\"maidid\\\":140341,\\\"fromtime\\\":\\\"2023-12-16t13:00:00\\\",\\\"totime\\\":\\\"2023-12-16t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0},{\\\"shiftid\\\":1266955,\\\"maidid\\\":null,\\\"fromtime\\\":\\\"2023-12-16t13:00:00\\\",\\\"totime\\\":\\\"2023-12-16t17:00:00\\\",\\\"price\\\":0,\\\"serviceprice\\\":0,\\\"priceperhour\\\":110000,\\\"vatpercent\\\":0.0,\\\"ceilroundtax\\\":false,\\\"registrationschedule\\\":null,\\\"forleader\\\":false,\\\"distance\\\":null,\\\"cashtocollect\\\":0,\\\"retailshipmentids\\\":null,\\\"undefinedtime\\\":null,\\\"daytype\\\":0}]', totime=timestamp'2023-12-16 17:00:00', type=0 where id=5703","binlogFileName":"mysql-bin.000167","binlogPos":102743526,"createdDate":1764429420}