{"userId":"114","date":"2019-04-02 11:36:56","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('114', '157.39.69.138', '2019-04-02 11:36:56')"} {"userId":"114","date":"2019-04-02 11:39:25","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1051', '2019-04-01', '114', '157.39.69.138', '114', '2019-04-02 11:39:25')"} {"userId":"114","date":"2019-04-02 11:43:03","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1051', '894', '114', '2019-04-02', '1', '157.39.69.138', '114', '2019-04-02 11:43:03', '', '')"} {"userId":"114","date":"2019-04-02 11:43:03","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('712', '0', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:03","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('712', '1', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:03","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('712', '2', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:03","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('712', '3', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:03","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('712', '4', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:03","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('712', '5', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:03","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('712', '', '', 'Array', '', 'Array', '', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:03","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('712', '', '', 'Array', '', 'Array', '', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:03","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('712', '', '', 'Array', '', 'Array', '', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:03","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('712', '', '', 'Array', '', 'Array', '', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('108', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('109', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('113', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('114', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('117', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('118', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('119', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('120', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('121', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('122', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('123', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('124', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('125', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('126', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('127', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('128', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('129', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('130', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('132', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"114","date":"2019-04-02 11:43:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('133', '712', '157.39.69.138', '114', '2019-04-02 11:43:03')"} {"userId":"145","date":"2019-04-02 14:16:46","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('145', '103.77.213.25', '2019-04-02 14:16:46')"} {"userId":"114","date":"2019-04-02 15:33:35","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('114', '157.39.69.138', '2019-04-02 15:33:35')"} {"userId":"114","date":"2019-04-02 15:36:42","query":"UPDATE sitesupervision SET `siteid` = '1051', `userid` = '114', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-27', `numofsamplecollected` = '160', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:36:42', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '911', `undertrialprisoners` = '2053' WHERE ssid = '712'"} {"userId":"114","date":"2019-04-02 15:36:42","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Manpreet', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:36:42' WHERE onssid = '3176'"} {"userId":"114","date":"2019-04-02 15:36:42","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Sukhpal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:36:42' WHERE onssid = '3177'"} {"userId":"114","date":"2019-04-02 15:36:42","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Ranjeet Singh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:36:42' WHERE onssid = '3178'"} {"userId":"114","date":"2019-04-02 15:36:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:36:42' WHERE onssid = '3179'"} {"userId":"114","date":"2019-04-02 15:36:42","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=74592 then '' when ansid=74594 then '' when ansid=74596 then '' when ansid=74598 then '' when ansid=74600 then '' when ansid=74602 then '' when ansid=74604 then '' when ansid=74606 then '' when ansid=74608 then '' when ansid=74610 then '' when ansid=74612 then '' when ansid=74614 then '' when ansid=74616 then '' when ansid=74618 then '' when ansid=74620 then '' when ansid=74622 then '' when ansid=74624 then '' when ansid=74626 then '' when ansid=74628 then '' when ansid=74630 then '' when ansid=74632 then '' when ansid=74634 then '' when ansid=74636 then '' when ansid=74638 then '' when ansid=74640 then '' when ansid=74642 then '' when ansid=74644 then '' when ansid=74646 then '' when ansid=74648 then '' when ansid=74649 then '' when ansid=74650 then '' when ansid=74651 then '' when ansid=74652 then '' when ansid=74653 then '' when ansid=74654 then '' when ansid=74655 then '' when ansid=74656 then '' when ansid=74657 then '' when ansid=74658 then '' when ansid=74659 then '' when ansid=74660 then '' when ansid=74661 then '' when ansid=74662 then '' when ansid=74663 then '' when ansid=74664 then '' when ansid=74665 then '' when ansid=74666 then '' when ansid=74667 then '' when ansid=74668 then '' when ansid=74669 then '' when ansid=74670 then '' when ansid=74671 then '' when ansid=74672 then '' when ansid=74673 then '' when ansid=74674 then '' when ansid=74675 then '' when ansid=74676 then '' when ansid=74677 then '' when ansid=74678 then '' when ansid=74679 then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.39.69.138',\n\t\t\t\t\t\t\t\tmodifiedby =114,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-02 15:36:42'\n\t\t\t\t\t\t\tWHERE ansid in ('74592','74594','74596','74598','74600','74602','74604','74606','74608','74610','74612','74614','74616','74618','74620','74622','74624','74626','74628','74630','74632','74634','74636','74638','74640','74642','74644','74646','74648','74649','74650','74651','74652','74653','74654','74655','74656','74657','74658','74659','74660','74661','74662','74663','74664','74665','74666','74667','74668','74669','74670','74671','74672','74673','74674','74675','74676','74677','74678','74679','','','','','','')"} {"userId":"114","date":"2019-04-02 15:37:38","query":"UPDATE sitesupervision SET `siteid` = '1051', `userid` = '114', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-27', `numofsamplecollected` = '160', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:37:38', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '911', `undertrialprisoners` = '2053' WHERE ssid = '712'"} {"userId":"114","date":"2019-04-02 15:37:38","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Manpreet', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:37:38' WHERE onssid = '3176'"} {"userId":"114","date":"2019-04-02 15:37:38","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Sukhpal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:37:38' WHERE onssid = '3177'"} {"userId":"114","date":"2019-04-02 15:37:38","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Ranjeet Singh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:37:38' WHERE onssid = '3178'"} {"userId":"114","date":"2019-04-02 15:37:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:37:38' WHERE onssid = '3179'"} {"userId":"114","date":"2019-04-02 15:37:38","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=74592 then '3' when ansid=74594 then '0' when ansid=74596 then '400' when ansid=74598 then '20' when ansid=74600 then '20' when ansid=74602 then '1' when ansid=74604 then '400' when ansid=74606 then '1' when ansid=74608 then '1' when ansid=74610 then '1' when ansid=74612 then '' when ansid=74614 then '' when ansid=74616 then '' when ansid=74618 then '' when ansid=74620 then '' when ansid=74622 then '' when ansid=74624 then '' when ansid=74626 then '' when ansid=74628 then '' when ansid=74630 then '' when ansid=74632 then '' when ansid=74634 then '' when ansid=74636 then '' when ansid=74638 then '' when ansid=74640 then '' when ansid=74642 then '' when ansid=74644 then '' when ansid=74646 then '' when ansid=74648 then '' when ansid=74649 then '' when ansid=74650 then '' when ansid=74651 then '' when ansid=74652 then '' when ansid=74653 then '' when ansid=74654 then '' when ansid=74655 then '' when ansid=74656 then '' when ansid=74657 then '' when ansid=74658 then '' when ansid=74659 then '' when ansid=74660 then '' when ansid=74661 then '' when ansid=74662 then '' when ansid=74663 then '' when ansid=74664 then '' when ansid=74665 then '' when ansid=74666 then '' when ansid=74667 then '' when ansid=74668 then '' when ansid=74669 then '' when ansid=74670 then '' when ansid=74671 then '' when ansid=74672 then '' when ansid=74673 then '' when ansid=74674 then '' when ansid=74675 then '' when ansid=74676 then '' when ansid=74677 then '' when ansid=74678 then '' when ansid=74679 then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.39.69.138',\n\t\t\t\t\t\t\t\tmodifiedby =114,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-02 15:37:38'\n\t\t\t\t\t\t\tWHERE ansid in ('74592','74594','74596','74598','74600','74602','74604','74606','74608','74610','74612','74614','74616','74618','74620','74622','74624','74626','74628','74630','74632','74634','74636','74638','74640','74642','74644','74646','74648','74649','74650','74651','74652','74653','74654','74655','74656','74657','74658','74659','74660','74661','74662','74663','74664','74665','74666','74667','74668','74669','74670','74671','74672','74673','74674','74675','74676','74677','74678','74679','','','','','','')"} {"userId":"114","date":"2019-04-02 15:39:21","query":"UPDATE sitesupervision SET `siteid` = '1051', `userid` = '114', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-27', `numofsamplecollected` = '160', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:39:21', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '911', `undertrialprisoners` = '2053' WHERE ssid = '712'"} {"userId":"114","date":"2019-04-02 15:39:21","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Manpreet', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:39:21' WHERE onssid = '3176'"} {"userId":"114","date":"2019-04-02 15:39:21","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Sukhpal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:39:21' WHERE onssid = '3177'"} {"userId":"114","date":"2019-04-02 15:39:21","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Ranjeet Singh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:39:21' WHERE onssid = '3178'"} {"userId":"114","date":"2019-04-02 15:39:21","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:39:21' WHERE onssid = '3179'"} {"userId":"114","date":"2019-04-02 15:39:21","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=74592 then '3' when ansid=74594 then '0' when ansid=74596 then '400' when ansid=74598 then '20' when ansid=74600 then '20' when ansid=74602 then '1' when ansid=74604 then '400' when ansid=74606 then '1' when ansid=74608 then '1' when ansid=74610 then '1' when ansid=74612 then '0' when ansid=74614 then '400' when ansid=74616 then '450' when ansid=74618 then '400' when ansid=74620 then '20' when ansid=74622 then '1' when ansid=74624 then '400' when ansid=74626 then '400' when ansid=74628 then '400' when ansid=74630 then '3' when ansid=74632 then '3' when ansid=74634 then '1' when ansid=74636 then '1' when ansid=74638 then '' when ansid=74640 then '' when ansid=74642 then '' when ansid=74644 then '' when ansid=74646 then '' when ansid=74648 then '' when ansid=74649 then '' when ansid=74650 then '' when ansid=74651 then '' when ansid=74652 then '' when ansid=74653 then '' when ansid=74654 then '' when ansid=74655 then '' when ansid=74656 then '' when ansid=74657 then '' when ansid=74658 then '' when ansid=74659 then '' when ansid=74660 then '' when ansid=74661 then '' when ansid=74662 then '' when ansid=74663 then '' when ansid=74664 then '' when ansid=74665 then '' when ansid=74666 then '' when ansid=74667 then '' when ansid=74668 then '' when ansid=74669 then '' when ansid=74670 then '' when ansid=74671 then '' when ansid=74672 then '' when ansid=74673 then '' when ansid=74674 then '' when ansid=74675 then '' when ansid=74676 then '' when ansid=74677 then '' when ansid=74678 then '' when ansid=74679 then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.39.69.138',\n\t\t\t\t\t\t\t\tmodifiedby =114,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-02 15:39:21'\n\t\t\t\t\t\t\tWHERE ansid in ('74592','74594','74596','74598','74600','74602','74604','74606','74608','74610','74612','74614','74616','74618','74620','74622','74624','74626','74628','74630','74632','74634','74636','74638','74640','74642','74644','74646','74648','74649','74650','74651','74652','74653','74654','74655','74656','74657','74658','74659','74660','74661','74662','74663','74664','74665','74666','74667','74668','74669','74670','74671','74672','74673','74674','74675','74676','74677','74678','74679','','','','','','')"} {"userId":"114","date":"2019-04-02 15:39:49","query":"UPDATE sitesupervision SET `siteid` = '1051', `userid` = '114', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-27', `numofsamplecollected` = '160', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:39:49', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '911', `undertrialprisoners` = '2053' WHERE ssid = '712'"} {"userId":"114","date":"2019-04-02 15:39:49","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Manpreet', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:39:49' WHERE onssid = '3176'"} {"userId":"114","date":"2019-04-02 15:39:49","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Sukhpal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:39:49' WHERE onssid = '3177'"} {"userId":"114","date":"2019-04-02 15:39:49","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Ranjeet Singh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:39:49' WHERE onssid = '3178'"} {"userId":"114","date":"2019-04-02 15:39:49","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:39:49' WHERE onssid = '3179'"} {"userId":"114","date":"2019-04-02 15:39:49","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=74592 then '3' when ansid=74594 then '0' when ansid=74596 then '400' when ansid=74598 then '20' when ansid=74600 then '20' when ansid=74602 then '1' when ansid=74604 then '400' when ansid=74606 then '1' when ansid=74608 then '1' when ansid=74610 then '1' when ansid=74612 then '0' when ansid=74614 then '400' when ansid=74616 then '450' when ansid=74618 then '400' when ansid=74620 then '20' when ansid=74622 then '1' when ansid=74624 then '400' when ansid=74626 then '400' when ansid=74628 then '400' when ansid=74630 then '3' when ansid=74632 then '3' when ansid=74634 then '1' when ansid=74636 then '1' when ansid=74638 then '1' when ansid=74640 then '1' when ansid=74642 then '0' when ansid=74644 then '2' when ansid=74646 then '0' when ansid=74648 then '' when ansid=74649 then '' when ansid=74650 then '' when ansid=74651 then '' when ansid=74652 then '' when ansid=74653 then '' when ansid=74654 then '' when ansid=74655 then '' when ansid=74656 then '' when ansid=74657 then '' when ansid=74658 then '' when ansid=74659 then '' when ansid=74660 then '' when ansid=74661 then '' when ansid=74662 then '' when ansid=74663 then '' when ansid=74664 then '' when ansid=74665 then '' when ansid=74666 then '' when ansid=74667 then '' when ansid=74668 then '' when ansid=74669 then '' when ansid=74670 then '' when ansid=74671 then '' when ansid=74672 then '' when ansid=74673 then '' when ansid=74674 then '' when ansid=74675 then '' when ansid=74676 then '' when ansid=74677 then '' when ansid=74678 then '' when ansid=74679 then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.39.69.138',\n\t\t\t\t\t\t\t\tmodifiedby =114,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-02 15:39:49'\n\t\t\t\t\t\t\tWHERE ansid in ('74592','74594','74596','74598','74600','74602','74604','74606','74608','74610','74612','74614','74616','74618','74620','74622','74624','74626','74628','74630','74632','74634','74636','74638','74640','74642','74644','74646','74648','74649','74650','74651','74652','74653','74654','74655','74656','74657','74658','74659','74660','74661','74662','74663','74664','74665','74666','74667','74668','74669','74670','74671','74672','74673','74674','74675','74676','74677','74678','74679','','','','','','')"} {"userId":"114","date":"2019-04-02 15:44:59","query":"UPDATE sitesupervision SET `siteid` = '1051', `userid` = '114', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-27', `numofsamplecollected` = '160', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:44:59', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '911', `undertrialprisoners` = '2053' WHERE ssid = '712'"} {"userId":"114","date":"2019-04-02 15:44:59","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Manpreet', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:44:59' WHERE onssid = '3176'"} {"userId":"114","date":"2019-04-02 15:44:59","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Sukhpal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:44:59' WHERE onssid = '3177'"} {"userId":"114","date":"2019-04-02 15:44:59","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Ranjeet Singh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:44:59' WHERE onssid = '3178'"} {"userId":"114","date":"2019-04-02 15:44:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:44:59' WHERE onssid = '3179'"} {"userId":"114","date":"2019-04-02 15:44:59","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=74592 then '3' when ansid=74594 then '0' when ansid=74596 then '400' when ansid=74598 then '20' when ansid=74600 then '20' when ansid=74602 then '1' when ansid=74604 then '400' when ansid=74606 then '1' when ansid=74608 then '1' when ansid=74610 then '1' when ansid=74612 then '0' when ansid=74614 then '400' when ansid=74616 then '450' when ansid=74618 then '400' when ansid=74620 then '20' when ansid=74622 then '1' when ansid=74624 then '400' when ansid=74626 then '400' when ansid=74628 then '400' when ansid=74630 then '3' when ansid=74632 then '3' when ansid=74634 then '1' when ansid=74636 then '1' when ansid=74638 then '1' when ansid=74640 then '1' when ansid=74642 then '0' when ansid=74644 then '2' when ansid=74646 then '0' when ansid=74648 then '35' when ansid=74649 then '3' when ansid=74650 then '' when ansid=74651 then '1' when ansid=74652 then '' when ansid=74653 then '1' when ansid=74654 then '' when ansid=74655 then '1' when ansid=74656 then '20' when ansid=74657 then '1' when ansid=74658 then 'Couselor' when ansid=74659 then '1' when ansid=74660 then '' when ansid=74661 then '1' when ansid=74662 then '1' when ansid=74663 then '1' when ansid=74664 then '1' when ansid=74665 then '1' when ansid=74666 then '1' when ansid=74667 then '1' when ansid=74668 then '2' when ansid=74669 then '1' when ansid=74670 then '1' when ansid=74671 then '1' when ansid=74672 then '3' when ansid=74673 then '2' when ansid=74674 then '1' when ansid=74675 then '2' when ansid=74676 then '' when ansid=74677 then '1' when ansid=74678 then '2' when ansid=74679 then '1' when ansid= then '2' when ansid= then '1' when ansid= then '0' when ansid= then 'None reported' when ansid= then 'On site training was given on day 1 of surveillance by a team of RI PGIMER and SACS.' when ansid= then 'Bio-medical waste segregation was not being done properly.Hypo-chlorite solution was not available and staff was not aware of it’s utility.' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.39.69.138',\n\t\t\t\t\t\t\t\tmodifiedby =114,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-02 15:44:59'\n\t\t\t\t\t\t\tWHERE ansid in ('74592','74594','74596','74598','74600','74602','74604','74606','74608','74610','74612','74614','74616','74618','74620','74622','74624','74626','74628','74630','74632','74634','74636','74638','74640','74642','74644','74646','74648','74649','74650','74651','74652','74653','74654','74655','74656','74657','74658','74659','74660','74661','74662','74663','74664','74665','74666','74667','74668','74669','74670','74671','74672','74673','74674','74675','74676','74677','74678','74679','','','','','','')"} {"userId":"114","date":"2019-04-02 15:48:38","query":"UPDATE sitesupervision SET `siteid` = '1051', `userid` = '114', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-27', `numofsamplecollected` = '160', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:48:38', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '911', `undertrialprisoners` = '2053', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '712'"} {"userId":"114","date":"2019-04-02 15:48:38","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Manpreet', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:48:38' WHERE onssid = '3176'"} {"userId":"114","date":"2019-04-02 15:48:38","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Sukhpal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:48:38' WHERE onssid = '3177'"} {"userId":"114","date":"2019-04-02 15:48:38","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Ranjeet Singh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:48:38' WHERE onssid = '3178'"} {"userId":"114","date":"2019-04-02 15:48:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:48:38' WHERE onssid = '3179'"} {"userId":"114","date":"2019-04-02 15:48:38","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=74592 then '3' when ansid=74594 then '0' when ansid=74596 then '400' when ansid=74598 then '20' when ansid=74600 then '20' when ansid=74602 then '1' when ansid=74604 then '400' when ansid=74606 then '1' when ansid=74608 then '1' when ansid=74610 then '1' when ansid=74612 then '0' when ansid=74614 then '400' when ansid=74616 then '450' when ansid=74618 then '400' when ansid=74620 then '20' when ansid=74622 then '1' when ansid=74624 then '400' when ansid=74626 then '400' when ansid=74628 then '400' when ansid=74630 then '3' when ansid=74632 then '3' when ansid=74634 then '1' when ansid=74636 then '1' when ansid=74638 then '1' when ansid=74640 then '1' when ansid=74642 then '0' when ansid=74644 then '2' when ansid=74646 then '0' when ansid=74648 then '35' when ansid=74649 then '3' when ansid=74650 then '' when ansid=74651 then '1' when ansid=74652 then '' when ansid=74653 then '1' when ansid=74654 then '' when ansid=74655 then '1' when ansid=74656 then '20' when ansid=74657 then '1' when ansid=74658 then 'Couselor' when ansid=74659 then '1' when ansid=74660 then '' when ansid=74661 then '1' when ansid=74662 then '1' when ansid=74663 then '1' when ansid=74664 then '1' when ansid=74665 then '1' when ansid=74666 then '1' when ansid=74667 then '1' when ansid=74668 then '2' when ansid=74669 then '1' when ansid=74670 then '1' when ansid=74671 then '1' when ansid=74672 then '3' when ansid=74673 then '2' when ansid=74674 then '1' when ansid=74675 then '2' when ansid=74676 then '' when ansid=74677 then '1' when ansid=74678 then '2' when ansid=74679 then '1' when ansid= then '2' when ansid= then '1' when ansid= then '0' when ansid= then 'None reported' when ansid= then 'On site training was given on day 1 of surveillance by a team of RI PGIMER and SACS.' when ansid= then 'Bio-medical waste segregation was not being done properly.Hypo-chlorite solution was not available and staff was not aware of it’s utility.' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.39.69.138',\n\t\t\t\t\t\t\t\tmodifiedby =114,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-02 15:48:38'\n\t\t\t\t\t\t\tWHERE ansid in ('74592','74594','74596','74598','74600','74602','74604','74606','74608','74610','74612','74614','74616','74618','74620','74622','74624','74626','74628','74630','74632','74634','74636','74638','74640','74642','74644','74646','74648','74649','74650','74651','74652','74653','74654','74655','74656','74657','74658','74659','74660','74661','74662','74663','74664','74665','74666','74667','74668','74669','74670','74671','74672','74673','74674','74675','74676','74677','74678','74679','','','','','','')"} {"userId":"114","date":"2019-04-02 15:49:01","query":"UPDATE sitesupervision SET `siteid` = '1051', `userid` = '114', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-27', `numofsamplecollected` = '160', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:49:01', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '911', `undertrialprisoners` = '2053', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '712'"} {"userId":"114","date":"2019-04-02 15:49:01","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Manpreet', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:49:01' WHERE onssid = '3176'"} {"userId":"114","date":"2019-04-02 15:49:01","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Sukhpal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:49:01' WHERE onssid = '3177'"} {"userId":"114","date":"2019-04-02 15:49:01","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Ranjeet Singh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:49:01' WHERE onssid = '3178'"} {"userId":"114","date":"2019-04-02 15:49:01","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:49:01' WHERE onssid = '3179'"} {"userId":"114","date":"2019-04-02 15:49:01","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=74592 then '3' when ansid=74594 then '0' when ansid=74596 then '400' when ansid=74598 then '20' when ansid=74600 then '20' when ansid=74602 then '1' when ansid=74604 then '400' when ansid=74606 then '1' when ansid=74608 then '1' when ansid=74610 then '1' when ansid=74612 then '0' when ansid=74614 then '400' when ansid=74616 then '450' when ansid=74618 then '400' when ansid=74620 then '20' when ansid=74622 then '1' when ansid=74624 then '400' when ansid=74626 then '400' when ansid=74628 then '400' when ansid=74630 then '3' when ansid=74632 then '3' when ansid=74634 then '1' when ansid=74636 then '1' when ansid=74638 then '1' when ansid=74640 then '1' when ansid=74642 then '0' when ansid=74644 then '2' when ansid=74646 then '0' when ansid=74648 then '35' when ansid=74649 then '3' when ansid=74650 then '' when ansid=74651 then '1' when ansid=74652 then '' when ansid=74653 then '1' when ansid=74654 then '' when ansid=74655 then '1' when ansid=74656 then '20' when ansid=74657 then '1' when ansid=74658 then 'Couselor' when ansid=74659 then '1' when ansid=74660 then '' when ansid=74661 then '1' when ansid=74662 then '1' when ansid=74663 then '1' when ansid=74664 then '1' when ansid=74665 then '1' when ansid=74666 then '1' when ansid=74667 then '1' when ansid=74668 then '2' when ansid=74669 then '1' when ansid=74670 then '1' when ansid=74671 then '1' when ansid=74672 then '3' when ansid=74673 then '2' when ansid=74674 then '1' when ansid=74675 then '2' when ansid=74676 then '' when ansid=74677 then '1' when ansid=74678 then '2' when ansid=74679 then '1' when ansid= then '2' when ansid= then '1' when ansid= then '0' when ansid= then 'None reported' when ansid= then 'On site training was given on day 1 of surveillance by a team of RI PGIMER and SACS.' when ansid= then 'Bio-medical waste segregation was not being done properly.Hypo-chlorite solution was not available and staff was not aware of it’s utility.' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.39.69.138',\n\t\t\t\t\t\t\t\tmodifiedby =114,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-02 15:49:01'\n\t\t\t\t\t\t\tWHERE ansid in ('74592','74594','74596','74598','74600','74602','74604','74606','74608','74610','74612','74614','74616','74618','74620','74622','74624','74626','74628','74630','74632','74634','74636','74638','74640','74642','74644','74646','74648','74649','74650','74651','74652','74653','74654','74655','74656','74657','74658','74659','74660','74661','74662','74663','74664','74665','74666','74667','74668','74669','74670','74671','74672','74673','74674','74675','74676','74677','74678','74679','','','','','','')"} {"userId":"114","date":"2019-04-02 15:49:15","query":"UPDATE sitesupervision SET `siteid` = '1051', `userid` = '114', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-27', `numofsamplecollected` = '160', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:49:15', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '911', `undertrialprisoners` = '2053', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '712'"} {"userId":"114","date":"2019-04-02 15:49:15","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Manpreet', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:49:15' WHERE onssid = '3176'"} {"userId":"114","date":"2019-04-02 15:49:15","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Sukhpal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:49:15' WHERE onssid = '3177'"} {"userId":"114","date":"2019-04-02 15:49:15","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Ranjeet Singh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:49:15' WHERE onssid = '3178'"} {"userId":"114","date":"2019-04-02 15:49:15","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:49:15' WHERE onssid = '3179'"} {"userId":"114","date":"2019-04-02 15:49:15","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=74592 then '3' when ansid=74594 then '0' when ansid=74596 then '400' when ansid=74598 then '20' when ansid=74600 then '20' when ansid=74602 then '1' when ansid=74604 then '400' when ansid=74606 then '1' when ansid=74608 then '1' when ansid=74610 then '1' when ansid=74612 then '0' when ansid=74614 then '400' when ansid=74616 then '450' when ansid=74618 then '400' when ansid=74620 then '20' when ansid=74622 then '1' when ansid=74624 then '400' when ansid=74626 then '400' when ansid=74628 then '400' when ansid=74630 then '3' when ansid=74632 then '3' when ansid=74634 then '1' when ansid=74636 then '1' when ansid=74638 then '1' when ansid=74640 then '1' when ansid=74642 then '0' when ansid=74644 then '2' when ansid=74646 then '0' when ansid=74648 then '35' when ansid=74649 then '3' when ansid=74650 then '' when ansid=74651 then '1' when ansid=74652 then '' when ansid=74653 then '1' when ansid=74654 then '' when ansid=74655 then '1' when ansid=74656 then '20' when ansid=74657 then '1' when ansid=74658 then 'Couselor' when ansid=74659 then '1' when ansid=74660 then '' when ansid=74661 then '1' when ansid=74662 then '1' when ansid=74663 then '1' when ansid=74664 then '1' when ansid=74665 then '1' when ansid=74666 then '1' when ansid=74667 then '1' when ansid=74668 then '2' when ansid=74669 then '1' when ansid=74670 then '1' when ansid=74671 then '1' when ansid=74672 then '3' when ansid=74673 then '2' when ansid=74674 then '1' when ansid=74675 then '2' when ansid=74676 then '' when ansid=74677 then '1' when ansid=74678 then '2' when ansid=74679 then '1' when ansid= then '2' when ansid= then '1' when ansid= then '0' when ansid= then 'None reported' when ansid= then 'On site training was given on day 1 of surveillance by a team of RI PGIMER and SACS.' when ansid= then 'Bio-medical waste segregation was not being done properly.Hypo-chlorite solution was not available and staff was not aware of it’s utility.' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.39.69.138',\n\t\t\t\t\t\t\t\tmodifiedby =114,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-02 15:49:15'\n\t\t\t\t\t\t\tWHERE ansid in ('74592','74594','74596','74598','74600','74602','74604','74606','74608','74610','74612','74614','74616','74618','74620','74622','74624','74626','74628','74630','74632','74634','74636','74638','74640','74642','74644','74646','74648','74649','74650','74651','74652','74653','74654','74655','74656','74657','74658','74659','74660','74661','74662','74663','74664','74665','74666','74667','74668','74669','74670','74671','74672','74673','74674','74675','74676','74677','74678','74679','','','','','','')"} {"userId":"114","date":"2019-04-02 15:49:18","query":"UPDATE sitesupervision SET `siteid` = '1051', `userid` = '114', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-27', `numofsamplecollected` = '160', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:49:18', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '911', `undertrialprisoners` = '2053', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '712'"} {"userId":"114","date":"2019-04-02 15:49:18","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Manpreet', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:49:18' WHERE onssid = '3176'"} {"userId":"114","date":"2019-04-02 15:49:18","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Sukhpal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:49:18' WHERE onssid = '3177'"} {"userId":"114","date":"2019-04-02 15:49:18","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Ranjeet Singh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:49:18' WHERE onssid = '3178'"} {"userId":"114","date":"2019-04-02 15:49:18","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:49:18' WHERE onssid = '3179'"} {"userId":"114","date":"2019-04-02 15:49:18","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=74592 then '3' when ansid=74594 then '0' when ansid=74596 then '400' when ansid=74598 then '20' when ansid=74600 then '20' when ansid=74602 then '1' when ansid=74604 then '400' when ansid=74606 then '1' when ansid=74608 then '1' when ansid=74610 then '1' when ansid=74612 then '0' when ansid=74614 then '400' when ansid=74616 then '450' when ansid=74618 then '400' when ansid=74620 then '20' when ansid=74622 then '1' when ansid=74624 then '400' when ansid=74626 then '400' when ansid=74628 then '400' when ansid=74630 then '3' when ansid=74632 then '3' when ansid=74634 then '1' when ansid=74636 then '1' when ansid=74638 then '1' when ansid=74640 then '1' when ansid=74642 then '0' when ansid=74644 then '2' when ansid=74646 then '0' when ansid=74648 then '35' when ansid=74649 then '3' when ansid=74650 then '' when ansid=74651 then '1' when ansid=74652 then '' when ansid=74653 then '1' when ansid=74654 then '' when ansid=74655 then '1' when ansid=74656 then '20' when ansid=74657 then '1' when ansid=74658 then 'Couselor' when ansid=74659 then '1' when ansid=74660 then '' when ansid=74661 then '1' when ansid=74662 then '1' when ansid=74663 then '1' when ansid=74664 then '1' when ansid=74665 then '1' when ansid=74666 then '1' when ansid=74667 then '1' when ansid=74668 then '2' when ansid=74669 then '1' when ansid=74670 then '1' when ansid=74671 then '1' when ansid=74672 then '3' when ansid=74673 then '2' when ansid=74674 then '1' when ansid=74675 then '2' when ansid=74676 then '' when ansid=74677 then '1' when ansid=74678 then '2' when ansid=74679 then '1' when ansid= then '2' when ansid= then '1' when ansid= then '0' when ansid= then 'None reported' when ansid= then 'On site training was given on day 1 of surveillance by a team of RI PGIMER and SACS.' when ansid= then 'Bio-medical waste segregation was not being done properly.Hypo-chlorite solution was not available and staff was not aware of it’s utility.' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.39.69.138',\n\t\t\t\t\t\t\t\tmodifiedby =114,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-02 15:49:18'\n\t\t\t\t\t\t\tWHERE ansid in ('74592','74594','74596','74598','74600','74602','74604','74606','74608','74610','74612','74614','74616','74618','74620','74622','74624','74626','74628','74630','74632','74634','74636','74638','74640','74642','74644','74646','74648','74649','74650','74651','74652','74653','74654','74655','74656','74657','74658','74659','74660','74661','74662','74663','74664','74665','74666','74667','74668','74669','74670','74671','74672','74673','74674','74675','74676','74677','74678','74679','','','','','','')"} {"userId":"114","date":"2019-04-02 15:49:18","query":"UPDATE sitesupervision SET `siteid` = '1051', `userid` = '114', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-27', `numofsamplecollected` = '160', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:49:18', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '911', `undertrialprisoners` = '2053', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '712'"} {"userId":"114","date":"2019-04-02 15:49:18","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Manpreet', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:49:18' WHERE onssid = '3176'"} {"userId":"114","date":"2019-04-02 15:49:18","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Sukhpal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:49:18' WHERE onssid = '3177'"} {"userId":"114","date":"2019-04-02 15:49:18","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Ranjeet Singh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:49:18' WHERE onssid = '3178'"} {"userId":"114","date":"2019-04-02 15:49:18","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.39.69.138', `modifiedby` = '114', `modifieddate` = '2019-04-02 15:49:18' WHERE onssid = '3179'"} {"userId":"114","date":"2019-04-02 15:49:18","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=74592 then '3' when ansid=74594 then '0' when ansid=74596 then '400' when ansid=74598 then '20' when ansid=74600 then '20' when ansid=74602 then '1' when ansid=74604 then '400' when ansid=74606 then '1' when ansid=74608 then '1' when ansid=74610 then '1' when ansid=74612 then '0' when ansid=74614 then '400' when ansid=74616 then '450' when ansid=74618 then '400' when ansid=74620 then '20' when ansid=74622 then '1' when ansid=74624 then '400' when ansid=74626 then '400' when ansid=74628 then '400' when ansid=74630 then '3' when ansid=74632 then '3' when ansid=74634 then '1' when ansid=74636 then '1' when ansid=74638 then '1' when ansid=74640 then '1' when ansid=74642 then '0' when ansid=74644 then '2' when ansid=74646 then '0' when ansid=74648 then '35' when ansid=74649 then '3' when ansid=74650 then '' when ansid=74651 then '1' when ansid=74652 then '' when ansid=74653 then '1' when ansid=74654 then '' when ansid=74655 then '1' when ansid=74656 then '20' when ansid=74657 then '1' when ansid=74658 then 'Couselor' when ansid=74659 then '1' when ansid=74660 then '' when ansid=74661 then '1' when ansid=74662 then '1' when ansid=74663 then '1' when ansid=74664 then '1' when ansid=74665 then '1' when ansid=74666 then '1' when ansid=74667 then '1' when ansid=74668 then '2' when ansid=74669 then '1' when ansid=74670 then '1' when ansid=74671 then '1' when ansid=74672 then '3' when ansid=74673 then '2' when ansid=74674 then '1' when ansid=74675 then '2' when ansid=74676 then '' when ansid=74677 then '1' when ansid=74678 then '2' when ansid=74679 then '1' when ansid= then '2' when ansid= then '1' when ansid= then '0' when ansid= then 'None reported' when ansid= then 'On site training was given on day 1 of surveillance by a team of RI PGIMER and SACS.' when ansid= then 'Bio-medical waste segregation was not being done properly.Hypo-chlorite solution was not available and staff was not aware of it’s utility.' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.39.69.138',\n\t\t\t\t\t\t\t\tmodifiedby =114,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-02 15:49:18'\n\t\t\t\t\t\t\tWHERE ansid in ('74592','74594','74596','74598','74600','74602','74604','74606','74608','74610','74612','74614','74616','74618','74620','74622','74624','74626','74628','74630','74632','74634','74636','74638','74640','74642','74644','74646','74648','74649','74650','74651','74652','74653','74654','74655','74656','74657','74658','74659','74660','74661','74662','74663','74664','74665','74666','74667','74668','74669','74670','74671','74672','74673','74674','74675','74676','74677','74678','74679','','','','','','')"}