{"userId":"677","date":"2023-02-28 11:36:20","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('677', '14.139.54.115', '2023-02-28 11:36:20')"}
{"userId":"677","date":"2023-02-28 11:38:03","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1724', '2023-02-17', '677', '14.139.54.115', '677', '2023-02-28 11:38:03')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1724', '3281', '677', '2023-02-28', '1', '14.139.54.115', '677', '2023-02-28 11:38:10', '', '')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2817', '0', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2817', '1', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2817', '2', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2817', '3', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2817', '', '', 'Array', '', 'Array', '', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2817', '', '', 'Array', '', 'Array', '', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2817', '', '', 'Array', '', 'Array', '', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2817', '', '', 'Array', '', 'Array', '', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('108', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('109', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('113', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('114', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('117', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('118', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('118', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('119', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('120', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('121', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('122', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('123', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('124', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('125', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('126', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('127', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('128', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('129', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('130', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('132', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('133', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('134', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('135', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('136', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('137', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('138', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('139', '2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:38:10","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2817', '14.139.54.115', '677', '2023-02-28 11:38:10')"}
{"userId":"677","date":"2023-02-28 11:46:37","query":"UPDATE sitesupervision SET `siteid` = '1724', `userid` = '677', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-08', `numofsamplecollected` = '81', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:46:37', `locationtype` = '2', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '1', `prisontypetext` = '', `convictedprisoners` = '400', `undertrialprisoners` = '1075' WHERE ssid = '2817'"}
{"userId":"677","date":"2023-02-28 11:46:37","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Shah Hassan', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '3', `istrained` = '1', `remarks` = 'Dr. Ankit Gusain was present in prison at the time of visit, and also actively participated in the HSS21.', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:46:37' WHERE onssid = '11596'"}
{"userId":"677","date":"2023-02-28 11:46:37","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Dheeraj Kalra', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:46:37' WHERE onssid = '11597'"}
{"userId":"677","date":"2023-02-28 11:46:37","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Ranveer', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '03', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:46:37' WHERE onssid = '11598'"}
{"userId":"677","date":"2023-02-28 11:46:37","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:46:37' WHERE onssid = '11599'"}
{"userId":"677","date":"2023-02-28 11:46:37","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=266996 then '' when ansid=266998 then '' when ansid=267000 then '' when ansid=267002 then '' when ansid=267004 then '' when ansid=267006 then '' when ansid=267007 then ''  when ansid=267008 then ''   when ansid=267009 then ''   when ansid=267010 then ''   when ansid=267011 then ''   when ansid=267012 then ''   when ansid=267013 then ''  when ansid=267014 then '' when ansid=267015 then ''  when ansid=267016 then ''   when ansid=267017 then ''   when ansid=267018 then ''   when ansid=267019 then ''  when ansid=267020 then ''  when ansid=267021 then ''   when ansid=267022 then ''  when ansid=267023 then '' when ansid=267024 then '' when ansid=267025 then '' when ansid=267026 then '' when ansid=267027 then '' when ansid=267028 then '' when ansid=267029 then '' when ansid=267030 then '' when ansid=267031 then '' when ansid=267032 then '' when ansid=267033 then '' when ansid=267034 then ''  when ansid=267035 then ''   when ansid=267036 then ''  when ansid=267037 then '' when ansid=267038 then '' when ansid=267039 then '' when ansid=267040 then '' when ansid=267041 then '' when ansid=267042 then '' when ansid=267043 then '' when ansid=267044 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =677,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-28 11:46:37'\r\n\t\t\t\t\t\t\tWHERE ansid in ('266996','266998','267000','267002','267004','267006','267007','267008','267009','267010','267011','267012','267013','267014','267015','267016','267017','267018','267019','267020','267021','267022','267023','267024','267025','267026','267027','267028','267029','267030','267031','267032','267033','267034','267035','267036','267037','267038','267039','267040','267041','267042','267043','267044')"}
{"userId":"677","date":"2023-02-28 11:46:37","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:46:37' WHERE supvisstepid = '13885'"}
{"userId":"677","date":"2023-02-28 11:46:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:46:37' WHERE visitfeedbackid = '13861'"}
{"userId":"677","date":"2023-02-28 11:46:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:46:37' WHERE visitfeedbackid = '13862'"}
{"userId":"677","date":"2023-02-28 11:46:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:46:37' WHERE visitfeedbackid = '13863'"}
{"userId":"677","date":"2023-02-28 11:46:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:46:37' WHERE visitfeedbackid = '13864'"}
{"userId":"677","date":"2023-02-28 11:46:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:46:37' WHERE visitfeedbackid = '13865'"}
{"userId":"677","date":"2023-02-28 11:47:06","query":"UPDATE sitesupervision SET `siteid` = '1724', `userid` = '677', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-08', `numofsamplecollected` = '81', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:47:06', `locationtype` = '2', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '1', `prisontypetext` = '', `convictedprisoners` = '400', `undertrialprisoners` = '1075' WHERE ssid = '2817'"}
{"userId":"677","date":"2023-02-28 11:47:06","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Shah Hassan', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '3', `istrained` = '1', `remarks` = 'Dr. Ankit Gusain was present in prison at the time of visit, and also actively participated in the HSS21.', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:47:06' WHERE onssid = '11596'"}
{"userId":"677","date":"2023-02-28 11:47:06","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Dheeraj Kalra', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:47:06' WHERE onssid = '11597'"}
{"userId":"677","date":"2023-02-28 11:47:06","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Ranveer', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '03', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:47:06' WHERE onssid = '11598'"}
{"userId":"677","date":"2023-02-28 11:47:06","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:47:06' WHERE onssid = '11599'"}
{"userId":"677","date":"2023-02-28 11:47:06","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=266996 then '1' when ansid=266998 then '0' when ansid=267000 then '0' when ansid=267002 then '3' when ansid=267004 then '1' when ansid=267006 then '' when ansid=267007 then ''  when ansid=267008 then ''   when ansid=267009 then ''   when ansid=267010 then ''   when ansid=267011 then ''   when ansid=267012 then ''   when ansid=267013 then ''  when ansid=267014 then '' when ansid=267015 then ''  when ansid=267016 then ''   when ansid=267017 then ''   when ansid=267018 then ''   when ansid=267019 then ''  when ansid=267020 then ''  when ansid=267021 then ''   when ansid=267022 then ''  when ansid=267023 then '' when ansid=267024 then '' when ansid=267025 then '' when ansid=267026 then '' when ansid=267027 then '' when ansid=267028 then '' when ansid=267029 then '' when ansid=267030 then '' when ansid=267031 then '' when ansid=267032 then '' when ansid=267033 then '' when ansid=267034 then ''  when ansid=267035 then ''   when ansid=267036 then ''  when ansid=267037 then '' when ansid=267038 then '' when ansid=267039 then '' when ansid=267040 then '' when ansid=267041 then '' when ansid=267042 then '' when ansid=267043 then '' when ansid=267044 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =677,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-28 11:47:06'\r\n\t\t\t\t\t\t\tWHERE ansid in ('266996','266998','267000','267002','267004','267006','267007','267008','267009','267010','267011','267012','267013','267014','267015','267016','267017','267018','267019','267020','267021','267022','267023','267024','267025','267026','267027','267028','267029','267030','267031','267032','267033','267034','267035','267036','267037','267038','267039','267040','267041','267042','267043','267044')"}
{"userId":"677","date":"2023-02-28 11:47:06","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:47:06' WHERE supvisstepid = '13886'"}
{"userId":"677","date":"2023-02-28 11:47:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:47:06' WHERE visitfeedbackid = '13861'"}
{"userId":"677","date":"2023-02-28 11:47:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:47:06' WHERE visitfeedbackid = '13862'"}
{"userId":"677","date":"2023-02-28 11:47:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:47:06' WHERE visitfeedbackid = '13863'"}
{"userId":"677","date":"2023-02-28 11:47:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:47:06' WHERE visitfeedbackid = '13864'"}
{"userId":"677","date":"2023-02-28 11:47:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 11:47:06' WHERE visitfeedbackid = '13865'"}
{"userId":"677","date":"2023-02-28 12:06:54","query":"UPDATE sitesupervision SET `siteid` = '1724', `userid` = '677', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-08', `numofsamplecollected` = '81', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:06:54', `locationtype` = '2', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '1', `prisontypetext` = '', `convictedprisoners` = '400', `undertrialprisoners` = '1075' WHERE ssid = '2817'"}
{"userId":"677","date":"2023-02-28 12:06:54","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Shah Hassan', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '3', `istrained` = '1', `remarks` = 'Dr. Ankit Gusain was present in prison at the time of visit, and also actively participated in the HSS21.', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:06:54' WHERE onssid = '11596'"}
{"userId":"677","date":"2023-02-28 12:06:54","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Dheeraj Kalra', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:06:54' WHERE onssid = '11597'"}
{"userId":"677","date":"2023-02-28 12:06:54","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Ranveer', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '03', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:06:54' WHERE onssid = '11598'"}
{"userId":"677","date":"2023-02-28 12:06:54","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:06:54' WHERE onssid = '11599'"}
{"userId":"677","date":"2023-02-28 12:06:54","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=266996 then '1' when ansid=266998 then '0' when ansid=267000 then '0' when ansid=267002 then '3' when ansid=267004 then '1' when ansid=267006 then '81' when ansid=267007 then '20'  when ansid=267008 then ''   when ansid=267009 then '1'   when ansid=267010 then ''   when ansid=267011 then '1'   when ansid=267012 then ''   when ansid=267013 then '1'  when ansid=267014 then '16' when ansid=267015 then '1'  when ansid=267016 then 'Pharmacist: Mr. Sandeep Negi, Has activelt participated in HSS21.'   when ansid=267017 then '2'   when ansid=267018 then ''   when ansid=267019 then '1'  when ansid=267020 then '1'  when ansid=267021 then ''   when ansid=267022 then '1'  when ansid=267023 then '1' when ansid=267024 then '1' when ansid=267025 then '1' when ansid=267026 then '1' when ansid=267027 then '1' when ansid=267028 then '1' when ansid=267029 then '1' when ansid=267030 then '1' when ansid=267031 then '3' when ansid=267032 then '1' when ansid=267033 then '1' when ansid=267034 then '1'  when ansid=267035 then ''   when ansid=267036 then '1'  when ansid=267037 then '1' when ansid=267038 then '3' when ansid=267039 then '3' when ansid=267040 then '1' when ansid=267041 then '0' when ansid=267042 then '1. Puncture proof container and Blue cardboard box was not there, small plastic bucket was being used instead of puncture proof container.2. Dr. Hassan(site-incharge) and Mr. Dheeraj Kalra( Councellor)  were not present on the day of visit, but Dr. Ankit Gusain along with  Mr. Sandeep Negi (Pharmacist) were present on the day of visit doing the work  properly ( Both of them has actively participated in HSS-21, and were on-the -spot trained at that time)' when ansid=267043 then 'Yes, CTM- Dr. S.D. Kandpal on 10th February 2023.' when ansid=267044 then '1.Samples were to be transported to testing  lab on 18th Feb 2023.2.Puncture proof container and Blue cardboard box was not there, small plastic bucket was being used instead of puncture proof container.3.The persons actively participating in the program should be officially trained.' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =677,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-28 12:06:54'\r\n\t\t\t\t\t\t\tWHERE ansid in ('266996','266998','267000','267002','267004','267006','267007','267008','267009','267010','267011','267012','267013','267014','267015','267016','267017','267018','267019','267020','267021','267022','267023','267024','267025','267026','267027','267028','267029','267030','267031','267032','267033','267034','267035','267036','267037','267038','267039','267040','267041','267042','267043','267044')"}
{"userId":"677","date":"2023-02-28 12:06:54","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:06:54' WHERE supvisstepid = '13887'"}
{"userId":"677","date":"2023-02-28 12:06:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:06:54' WHERE visitfeedbackid = '13861'"}
{"userId":"677","date":"2023-02-28 12:06:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:06:54' WHERE visitfeedbackid = '13862'"}
{"userId":"677","date":"2023-02-28 12:06:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:06:54' WHERE visitfeedbackid = '13863'"}
{"userId":"677","date":"2023-02-28 12:06:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:06:54' WHERE visitfeedbackid = '13864'"}
{"userId":"677","date":"2023-02-28 12:06:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:06:54' WHERE visitfeedbackid = '13865'"}
{"userId":"677","date":"2023-02-28 12:08:53","query":"UPDATE sitesupervision SET `siteid` = '1724', `userid` = '677', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-08', `numofsamplecollected` = '81', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:08:53', `locationtype` = '2', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '1', `prisontypetext` = '', `convictedprisoners` = '400', `undertrialprisoners` = '1075' WHERE ssid = '2817'"}
{"userId":"677","date":"2023-02-28 12:08:53","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Shah Hassan', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '3', `istrained` = '1', `remarks` = 'Dr. Ankit Gusain was present in prison at the time of visit, and also actively participated in the HSS21.', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:08:53' WHERE onssid = '11596'"}
{"userId":"677","date":"2023-02-28 12:08:53","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Dheeraj Kalra', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:08:53' WHERE onssid = '11597'"}
{"userId":"677","date":"2023-02-28 12:08:53","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Ranveer', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '03', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:08:53' WHERE onssid = '11598'"}
{"userId":"677","date":"2023-02-28 12:08:53","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:08:53' WHERE onssid = '11599'"}
{"userId":"677","date":"2023-02-28 12:08:53","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=266996 then '1' when ansid=266998 then '0' when ansid=267000 then '0' when ansid=267002 then '3' when ansid=267004 then '1' when ansid=267006 then '81' when ansid=267007 then '20'  when ansid=267008 then ''   when ansid=267009 then '1'   when ansid=267010 then ''   when ansid=267011 then '1'   when ansid=267012 then ''   when ansid=267013 then '1'  when ansid=267014 then '16' when ansid=267015 then '1'  when ansid=267016 then 'Pharmacist: Mr. Sandeep Negi, Has activelt participated in HSS21.'   when ansid=267017 then '2'   when ansid=267018 then ''   when ansid=267019 then '1'  when ansid=267020 then '1'  when ansid=267021 then ''   when ansid=267022 then '1'  when ansid=267023 then '1' when ansid=267024 then '1' when ansid=267025 then '1' when ansid=267026 then '1' when ansid=267027 then '1' when ansid=267028 then '1' when ansid=267029 then '1' when ansid=267030 then '1' when ansid=267031 then '3' when ansid=267032 then '1' when ansid=267033 then '1' when ansid=267034 then '1'  when ansid=267035 then ''   when ansid=267036 then '1'  when ansid=267037 then '1' when ansid=267038 then '3' when ansid=267039 then '3' when ansid=267040 then '1' when ansid=267041 then '0' when ansid=267042 then '1. Puncture proof container and Blue cardboard box was not there, small plastic bucket was being used instead of puncture proof container.2. Dr. Hassan(site-incharge) and Mr. Dheeraj Kalra( Councellor)  were not present on the day of visit, but Dr. Ankit Gusain along with  Mr. Sandeep Negi (Pharmacist) were present on the day of visit doing the work  properly ( Both of them has actively participated in HSS-21, and were on-the -spot trained at that time)' when ansid=267043 then 'Yes, CTM- Dr. S.D. Kandpal on 10th February 2023.' when ansid=267044 then '1.Samples were to be transported to testing  lab on 18th Feb 2023.2.Puncture proof container and Blue cardboard box was not there, small plastic bucket was being used instead of puncture proof container.3.The persons actively participating in the program should be officially trained.' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =677,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-28 12:08:53'\r\n\t\t\t\t\t\t\tWHERE ansid in ('266996','266998','267000','267002','267004','267006','267007','267008','267009','267010','267011','267012','267013','267014','267015','267016','267017','267018','267019','267020','267021','267022','267023','267024','267025','267026','267027','267028','267029','267030','267031','267032','267033','267034','267035','267036','267037','267038','267039','267040','267041','267042','267043','267044')"}
{"userId":"677","date":"2023-02-28 12:08:53","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:08:53' WHERE supvisstepid = '13887'"}
{"userId":"677","date":"2023-02-28 12:08:53","query":"UPDATE visitfeedback SET `feedback` = 'Dr. Hassan (site-incharge) was not there on the time of visit, but program work was looked after by Dr. Ankit Gusain.', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:08:53' WHERE visitfeedbackid = '13861'"}
{"userId":"677","date":"2023-02-28 12:08:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:08:53' WHERE visitfeedbackid = '13862'"}
{"userId":"677","date":"2023-02-28 12:08:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:08:53' WHERE visitfeedbackid = '13863'"}
{"userId":"677","date":"2023-02-28 12:08:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:08:53' WHERE visitfeedbackid = '13864'"}
{"userId":"677","date":"2023-02-28 12:08:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:08:53' WHERE visitfeedbackid = '13865'"}
{"userId":"677","date":"2023-02-28 12:14:42","query":"UPDATE sitesupervision SET `siteid` = '1724', `userid` = '677', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-08', `numofsamplecollected` = '81', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:14:42', `locationtype` = '2', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '1', `prisontypetext` = '', `convictedprisoners` = '400', `undertrialprisoners` = '1075', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2817'"}
{"userId":"677","date":"2023-02-28 12:14:42","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Shah Hassan', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '3', `istrained` = '1', `remarks` = 'Dr. Ankit Gusain was present in prison at the time of visit, and also actively participated in the HSS21.', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:14:42' WHERE onssid = '11596'"}
{"userId":"677","date":"2023-02-28 12:14:42","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Dheeraj Kalra', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:14:42' WHERE onssid = '11597'"}
{"userId":"677","date":"2023-02-28 12:14:42","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Ranveer', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '03', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:14:42' WHERE onssid = '11598'"}
{"userId":"677","date":"2023-02-28 12:14:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:14:42' WHERE onssid = '11599'"}
{"userId":"677","date":"2023-02-28 12:14:42","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=266996 then '1' when ansid=266998 then '0' when ansid=267000 then '0' when ansid=267002 then '3' when ansid=267004 then '1' when ansid=267006 then '81' when ansid=267007 then '20'  when ansid=267008 then ''   when ansid=267009 then '1'   when ansid=267010 then ''   when ansid=267011 then '1'   when ansid=267012 then ''   when ansid=267013 then '1'  when ansid=267014 then '16' when ansid=267015 then '1'  when ansid=267016 then 'Pharmacist: Mr. Sandeep Negi, Has activelt participated in HSS21.'   when ansid=267017 then '2'   when ansid=267018 then ''   when ansid=267019 then '1'  when ansid=267020 then '1'  when ansid=267021 then ''   when ansid=267022 then '1'  when ansid=267023 then '1' when ansid=267024 then '1' when ansid=267025 then '1' when ansid=267026 then '1' when ansid=267027 then '1' when ansid=267028 then '1' when ansid=267029 then '1' when ansid=267030 then '1' when ansid=267031 then '3' when ansid=267032 then '1' when ansid=267033 then '1' when ansid=267034 then '1'  when ansid=267035 then ''   when ansid=267036 then '1'  when ansid=267037 then '1' when ansid=267038 then '3' when ansid=267039 then '3' when ansid=267040 then '1' when ansid=267041 then '0' when ansid=267042 then '1. Puncture proof container and Blue cardboard box was not there, small plastic bucket was being used instead of puncture proof container.2. Dr. Hassan(site-incharge) and Mr. Dheeraj Kalra( Councellor)  were not present on the day of visit, but Dr. Ankit Gusain along with  Mr. Sandeep Negi (Pharmacist) were present on the day of visit doing the work  properly ( Both of them has actively participated in HSS-21, and were on-the -spot trained at that time)' when ansid=267043 then 'Yes, CTM- Dr. S.D. Kandpal on 10th February 2023.' when ansid=267044 then '1.Samples were to be transported to testing  lab on 18th Feb 2023.2.Puncture proof container and Blue cardboard box was not there, small plastic bucket was being used instead of puncture proof container.3.The persons actively participating in the program should be officially trained.' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =677,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-28 12:14:42'\r\n\t\t\t\t\t\t\tWHERE ansid in ('266996','266998','267000','267002','267004','267006','267007','267008','267009','267010','267011','267012','267013','267014','267015','267016','267017','267018','267019','267020','267021','267022','267023','267024','267025','267026','267027','267028','267029','267030','267031','267032','267033','267034','267035','267036','267037','267038','267039','267040','267041','267042','267043','267044')"}
{"userId":"677","date":"2023-02-28 12:14:42","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:14:42' WHERE supvisstepid = '13888'"}
{"userId":"677","date":"2023-02-28 12:14:42","query":"UPDATE visitfeedback SET `feedback` = 'Dr. Hassan (site-incharge) was not there on the time of visit, but program work was looked after by Dr. Ankit Gusain.', `recommendation` = 'Dr. Ankit Gusain gussain has actively participated in the HSS-21, and was also on-site trained at the time of visit.- recommends to include the actively working persons to include in official training.', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:14:42' WHERE visitfeedbackid = '13861'"}
{"userId":"677","date":"2023-02-28 12:14:42","query":"UPDATE visitfeedback SET `feedback` = 'Mr. Dheeraj Kalra( Councellor)  were not present on the day of visit, but Mr. Sandeep Negi (Pharmacist) functioning instead.', `recommendation` = 'Mr. Sandeep Negi (Pharmacist) has also actively participated in the HSS-21, and was also on-site trained at the time of visit.- recommends to include the working persons to include in official training.', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:14:42' WHERE visitfeedbackid = '13862'"}
{"userId":"677","date":"2023-02-28 12:14:42","query":"UPDATE visitfeedback SET `feedback` = 'Puncture proof container and Blue cardboard box was not there, small plastic bucket was being used instead of puncture proof container.', `recommendation` = 'Advised to purchase the puncture proof container as early as possible and  maka a blue cardboard box.', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:14:42' WHERE visitfeedbackid = '13863'"}
{"userId":"677","date":"2023-02-28 12:14:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:14:42' WHERE visitfeedbackid = '13864'"}
{"userId":"677","date":"2023-02-28 12:14:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '677', `modifieddate` = '2023-02-28 12:14:42' WHERE visitfeedbackid = '13865'"}