{"userId":null,"date":"2021-02-03 10:01:52","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('37', '171160', '0', '14.139.54.114', '', '2021-02-03 10:01:52')"} {"userId":null,"date":"2021-02-03 10:02:29","query":"UPDATE usermst SET `password` = '48609e1a89fdde2961e47932d972449a', `modifieddate` = '2021-02-03 10:02:29', `ipaddress` = '14.139.54.114' WHERE userid = '37'"} {"userId":"34","date":"2021-02-03 13:26:22","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('34', '27.61.90.63', '2021-02-03 13:26:22')"} {"userId":"5","date":"2021-02-03 13:32:18","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('5', '117.205.221.10', '2021-02-03 13:32:18')"} {"userId":"5","date":"2021-02-03 13:33:21","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('5', '117.205.221.10', '2021-02-03 13:33:21')"} {"userId":"5","date":"2021-02-03 13:34:39","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Rabendra', 'Sen', 'reasen2006@rediffmail.com', '9436169847', '', '', '25d55ad283aa400af464c76d713c07ad', '5', '117.205.221.10', '5', '2021-02-03 13:34:39')"} {"userId":"5","date":"2021-02-03 13:34:39","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('427', '101', '37', '0', '2', '0', '117.205.221.10', '5', '2021-02-03 13:34:39')"} {"userId":"5","date":"2021-02-03 13:35:50","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Sanjit Lal', 'Poddar', 'tsacs_sanjit@yahoo.in', '8787847051', '', '', '25d55ad283aa400af464c76d713c07ad', '5', '117.205.221.10', '5', '2021-02-03 13:35:50')"} {"userId":"5","date":"2021-02-03 13:35:50","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('428', '101', '37', '0', '2', '0', '117.205.221.10', '5', '2021-02-03 13:35:50')"} {"userId":"110","date":"2021-02-03 13:36:53","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('110', '117.205.221.10', '2021-02-03 13:36:53')"} {"userId":"5","date":"2021-02-03 13:51:17","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('5', '117.205.221.10', '2021-02-03 13:51:17')"} {"userId":"12","date":"2021-02-03 13:52:20","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('12', '117.205.221.10', '2021-02-03 13:52:20')"} {"userId":"34","date":"2021-02-03 13:52:38","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('34', '27.61.90.63', '2021-02-03 13:52:38')"} {"userId":"138","date":"2021-02-03 13:52:45","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('138', '117.205.221.10', '2021-02-03 13:52:45')"} {"userId":"139","date":"2021-02-03 13:53:06","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('139', '117.205.221.10', '2021-02-03 13:53:06')"} {"userId":"34","date":"2021-02-03 13:54:58","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('34', '27.61.90.63', '2021-02-03 13:54:58')"} {"userId":"34","date":"2021-02-03 13:57:19","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('34', '27.61.90.63', '2021-02-03 13:57:19')"} {"userId":"5","date":"2021-02-03 14:00:31","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('5', '117.205.221.10', '2021-02-03 14:00:31')"} {"userId":"5","date":"2021-02-03 14:07:04","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('5', '117.205.221.10', '2021-02-03 14:07:04')"} {"userId":"2","date":"2021-02-03 14:19:14","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '103.211.54.38', '2021-02-03 14:19:14')"} {"userId":"322","date":"2021-02-03 14:38:38","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('322', '117.207.41.4', '2021-02-03 14:38:38')"} {"userId":"322","date":"2021-02-03 14:40:11","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('565', '2021-02-10', '322', '117.207.41.4', '322', '2021-02-03 14:40:11')"} {"userId":"322","date":"2021-02-03 14:41:09","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('566', '2021-02-10', '322', '117.207.41.4', '322', '2021-02-03 14:41:09')"} {"userId":"322","date":"2021-02-03 14:49:06","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('534', '2021-02-17', '322', '117.207.41.4', '322', '2021-02-03 14:49:06')"} {"userId":"322","date":"2021-02-03 14:49:14","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('535', '2021-02-17', '322', '117.207.41.4', '322', '2021-02-03 14:49:14')"} {"userId":"322","date":"2021-02-03 14:51:38","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1078', '2021-02-23', '322', '117.207.41.4', '322', '2021-02-03 14:51:38')"} {"userId":"322","date":"2021-02-03 14:55:42","query":"UPDATE plannedsites SET `isdeleted` = '1', `ipaddress` = '117.207.41.4', `modifiedby` = '322', `modifieddate` = '2021-02-03 14:55:42' WHERE plansiteid = '988'"} {"userId":"322","date":"2021-02-03 14:55:42","query":"UPDATE sitesupervision SET `isdeleted` = '1', `ipaddress` = '117.207.41.4', `modifiedby` = '322', `modifieddate` = '2021-02-03 14:55:42' WHERE ssid = ''"} {"userId":"322","date":"2021-02-03 14:55:46","query":"UPDATE plannedsites SET `isdeleted` = '1', `ipaddress` = '117.207.41.4', `modifiedby` = '322', `modifieddate` = '2021-02-03 14:55:46' WHERE plansiteid = '989'"} {"userId":"322","date":"2021-02-03 14:55:46","query":"UPDATE sitesupervision SET `isdeleted` = '1', `ipaddress` = '117.207.41.4', `modifiedby` = '322', `modifieddate` = '2021-02-03 14:55:46' WHERE ssid = ''"} {"userId":"322","date":"2021-02-03 14:55:49","query":"UPDATE plannedsites SET `isdeleted` = '1', `ipaddress` = '117.207.41.4', `modifiedby` = '322', `modifieddate` = '2021-02-03 14:55:49' WHERE plansiteid = '986'"} {"userId":"322","date":"2021-02-03 14:55:49","query":"UPDATE sitesupervision SET `isdeleted` = '1', `ipaddress` = '117.207.41.4', `modifiedby` = '322', `modifieddate` = '2021-02-03 14:55:49' WHERE ssid = ''"} {"userId":"322","date":"2021-02-03 14:55:53","query":"UPDATE plannedsites SET `isdeleted` = '1', `ipaddress` = '117.207.41.4', `modifiedby` = '322', `modifieddate` = '2021-02-03 14:55:53' WHERE plansiteid = '987'"} {"userId":"322","date":"2021-02-03 14:55:53","query":"UPDATE sitesupervision SET `isdeleted` = '1', `ipaddress` = '117.207.41.4', `modifiedby` = '322', `modifieddate` = '2021-02-03 14:55:53' WHERE ssid = ''"} {"userId":"2","date":"2021-02-03 14:59:32","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Abhoy', 'Prasad', 'apd_bsacs@bihar.gov.in', '8092552676', 'APD', 'BSACS', 'e10adc3949ba59abbe56e057f20f883e', '5', '103.211.54.38', '2', '2021-02-03 14:59:32')"} {"userId":"2","date":"2021-02-03 14:59:32","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('429', '101', '5', '0', '3', '0', '103.211.54.38', '2', '2021-02-03 14:59:32')"} {"userId":"2","date":"2021-02-03 15:02:35","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Shailesh', 'Kumar', 'shailesh.shukla@planindia.org', '7080959982', '', 'BSACS', 'e10adc3949ba59abbe56e057f20f883e', '5', '103.211.54.38', '2', '2021-02-03 15:02:35')"} {"userId":"2","date":"2021-02-03 15:02:35","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('430', '101', '5', '0', '3', '0', '103.211.54.38', '2', '2021-02-03 15:02:35')"} {"userId":"2","date":"2021-02-03 15:04:49","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Mithilesh', 'Pandey', 'adictcbsacs@gmail.com', '9470836970', 'AD ICTC', 'BSACS', 'e10adc3949ba59abbe56e057f20f883e', '5', '103.211.54.38', '2', '2021-02-03 15:04:49')"} {"userId":"2","date":"2021-02-03 15:04:49","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('431', '101', '5', '0', '3', '0', '103.211.54.38', '2', '2021-02-03 15:04:49')"} {"userId":"2","date":"2021-02-03 15:07:03","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Rajeev', 'Ranjan', 'bsacs2012adti@gmail.com', '9431184643', 'AD TI', 'BSACS', 'e10adc3949ba59abbe56e057f20f883e', '5', '103.211.54.38', '2', '2021-02-03 15:07:03')"} {"userId":"2","date":"2021-02-03 15:07:03","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('432', '101', '5', '0', '3', '0', '103.211.54.38', '2', '2021-02-03 15:07:03')"} {"userId":"2","date":"2021-02-03 15:07:51","query":"UPDATE usermst SET `firstname` = 'Shailesh', `lastname` = 'Kumar', `email` = 'shailesh.shukla@planindia.org', `mobilenum` = '7080959982', `designation` = 'TE-SPIR', `organization` = 'BSACS', `roleid` = '5', `ipaddress` = '103.211.54.38', `createdby` = '2', `createddate` = '2021-02-03 15:07:51' WHERE userid = '430'"} {"userId":"2","date":"2021-02-03 15:07:51","query":"UPDATE userlocation SET `userid` = '430', `countryid` = '101', `stateid` = '5', `riid` = '3', `cityid` = '', `districtid` = '', `ipaddress` = '103.211.54.38', `createdby` = '2', `createddate` = '2021-02-03 15:07:51' WHERE userid = '430'"} {"userId":"2","date":"2021-02-03 15:09:49","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Yaseer', 'Imam', 'yasir5358@gmail.com', '7739812070', 'M & E Officer', 'BSACS', 'e10adc3949ba59abbe56e057f20f883e', '5', '103.211.54.38', '2', '2021-02-03 15:09:49')"} {"userId":"2","date":"2021-02-03 15:09:49","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('433', '101', '5', '0', '', '0', '103.211.54.38', '2', '2021-02-03 15:09:49')"} {"userId":"430","date":"2021-02-03 15:20:42","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('430', '117.247.66.206', '2021-02-03 15:20:42')"} {"userId":"386","date":"2021-02-03 15:27:02","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('386', '103.211.54.38', '2021-02-03 15:27:02')"} {"userId":"430","date":"2021-02-03 15:27:15","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('378', '2021-02-09', '430', '117.247.66.206', '430', '2021-02-03 15:27:15')"} {"userId":"386","date":"2021-02-03 15:30:17","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Satyajeet', 'Srivastava', 'satyajeet.srivastava@phfi.org', '9546748315', 'Technical Expert (SPIR)', 'TSU UPSACS', 'e10adc3949ba59abbe56e057f20f883e', '1', '103.211.54.38', '386', '2021-02-03 15:30:17')"} {"userId":"386","date":"2021-02-03 15:30:17","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('434', '101', '38', '656', '', '4933', '103.211.54.38', '386', '2021-02-03 15:30:17')"} {"userId":"386","date":"2021-02-03 15:33:48","query":"UPDATE usermst SET `firstname` = 'Satyajeet', `lastname` = 'Srivastava', `email` = 'satyajeet.srivastava@phfi.org', `mobilenum` = '9546748315', `designation` = 'Technical Expert (SPIR)', `organization` = 'TSU UPSACS', `roleid` = '5', `ipaddress` = '103.211.54.38', `createdby` = '386', `createddate` = '2021-02-03 15:33:48' WHERE userid = '434'"} {"userId":"386","date":"2021-02-03 15:33:48","query":"UPDATE userlocation SET `userid` = '434', `countryid` = '101', `stateid` = '38', `riid` = '3', `cityid` = '4933', `districtid` = '656', `ipaddress` = '103.211.54.38', `createdby` = '386', `createddate` = '2021-02-03 15:33:48' WHERE userid = '434'"} {"userId":"386","date":"2021-02-03 16:06:00","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('386', '103.211.54.38', '2021-02-03 16:06:00')"} {"userId":"243","date":"2021-02-03 17:34:36","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('243', '103.211.54.38', '2021-02-03 17:34:36')"} {"userId":"315","date":"2021-02-03 17:42:48","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('315', '106.77.36.247', '2021-02-03 17:42:48')"} {"userId":"243","date":"2021-02-03 17:45:04","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('243', '103.211.54.38', '2021-02-03 17:45:04')"} {"userId":"2","date":"2021-02-03 17:45:20","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '14.139.245.2', '2021-02-03 17:45:20')"} {"userId":"2","date":"2021-02-03 17:45:22","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '14.139.245.2', '2021-02-03 17:45:22')"} {"userId":"2","date":"2021-02-03 17:45:22","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '14.139.245.2', '2021-02-03 17:45:22')"} {"userId":"2","date":"2021-02-03 17:45:29","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '14.139.245.2', '2021-02-03 17:45:29')"} {"userId":"2","date":"2021-02-03 17:45:30","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '14.139.245.2', '2021-02-03 17:45:30')"} {"userId":"2","date":"2021-02-03 17:45:32","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '14.139.245.2', '2021-02-03 17:45:32')"} {"userId":"2","date":"2021-02-03 17:45:41","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '103.211.54.38', '2021-02-03 17:45:41')"} {"userId":"2","date":"2021-02-03 17:45:47","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '103.211.54.38', '2021-02-03 17:45:47')"} {"userId":"275","date":"2021-02-03 17:47:07","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('275', '124.123.169.144', '2021-02-03 17:47:07')"} {"userId":"275","date":"2021-02-03 17:48:19","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('275', '124.123.169.144', '2021-02-03 17:48:19')"} {"userId":"2","date":"2021-02-03 17:48:45","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('201', '2021-02-15', '2', '103.211.54.38', '2', '2021-02-03 17:48:45')"} {"userId":"2","date":"2021-02-03 17:49:09","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('211', '2021-02-17', '2', '103.211.54.38', '2', '2021-02-03 17:49:09')"} {"userId":"2","date":"2021-02-03 17:52:01","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('254', '2021-02-17', '2', '103.211.54.38', '2', '2021-02-03 17:52:01')"} {"userId":"2","date":"2021-02-03 17:52:20","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('256', '2021-02-16', '2', '103.211.54.38', '2', '2021-02-03 17:52:20')"} {"userId":"2","date":"2021-02-03 17:52:52","query":"UPDATE plannedsites SET `siteid` = '254', `visitdate` = '2021-02-16', `ipaddress` = '103.211.54.38', `modifiedby` = '2', `modifieddate` = '2021-02-03 17:52:52' WHERE plansiteid = '994'"} {"userId":"2","date":"2021-02-03 17:53:06","query":"UPDATE plannedsites SET `isdeleted` = '1', `ipaddress` = '103.211.54.38', `modifiedby` = '2', `modifieddate` = '2021-02-03 17:53:06' WHERE plansiteid = '963'"} {"userId":"2","date":"2021-02-03 17:53:06","query":"UPDATE sitesupervision SET `isdeleted` = '1', `ipaddress` = '103.211.54.38', `modifiedby` = '2', `modifieddate` = '2021-02-03 17:53:06' WHERE ssid = ''"} {"userId":"2","date":"2021-02-03 17:55:21","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1099', '2021-02-17', '2', '103.211.54.38', '2', '2021-02-03 17:55:21')"} {"userId":"2","date":"2021-02-03 17:57:06","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1112', '2021-02-16', '2', '103.211.54.38', '2', '2021-02-03 17:57:06')"} {"userId":"275","date":"2021-02-03 18:00:01","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('502', '2021-02-04', '275', '124.123.169.144', '275', '2021-02-03 18:00:01')"} {"userId":"275","date":"2021-02-03 18:02:08","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('503', '2021-02-04', '275', '124.123.169.144', '275', '2021-02-03 18:02:08')"} {"userId":"275","date":"2021-02-03 18:03:30","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('509', '2021-02-05', '275', '124.123.169.144', '275', '2021-02-03 18:03:30')"} {"userId":"275","date":"2021-02-03 18:03:41","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('510', '2021-02-05', '275', '124.123.169.144', '275', '2021-02-03 18:03:41')"} {"userId":"275","date":"2021-02-03 18:04:24","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('504', '2021-02-08', '275', '124.123.169.144', '275', '2021-02-03 18:04:24')"} {"userId":"275","date":"2021-02-03 18:05:11","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('504', '2021-02-09', '275', '124.123.169.144', '275', '2021-02-03 18:05:11')"} {"userId":"275","date":"2021-02-03 18:05:36","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('505', '2021-02-09', '275', '124.123.169.144', '275', '2021-02-03 18:05:36')"} {"userId":"275","date":"2021-02-03 18:06:17","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1286', '2021-02-09', '275', '124.123.169.144', '275', '2021-02-03 18:06:17')"} {"userId":"53","date":"2021-02-03 20:12:56","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('53', '49.37.6.34', '2021-02-03 20:12:56')"} {"userId":"53","date":"2021-02-03 20:14:36","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1397', '2021-02-04', '53', '49.37.6.34', '53', '2021-02-03 20:14:36')"} {"userId":"53","date":"2021-02-03 20:14:59","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1394', '2021-02-05', '53', '49.37.6.34', '53', '2021-02-03 20:14:59')"} {"userId":"53","date":"2021-02-03 20:15:20","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1401', '2021-02-05', '53', '49.37.6.34', '53', '2021-02-03 20:15:20')"} {"userId":"53","date":"2021-02-03 20:15:51","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1386', '2021-02-06', '53', '49.37.6.34', '53', '2021-02-03 20:15:51')"} {"userId":"53","date":"2021-02-03 20:17:46","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1383', '2021-02-10', '53', '49.37.6.34', '53', '2021-02-03 20:17:46')"} {"userId":"53","date":"2021-02-03 20:18:12","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1400', '2021-02-13', '53', '49.37.6.34', '53', '2021-02-03 20:18:12')"} {"userId":"394","date":"2021-02-03 21:48:37","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('394', '47.29.169.219', '2021-02-03 21:48:37')"} {"userId":"394","date":"2021-02-03 21:54:34","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('394', '47.29.147.89', '2021-02-03 21:54:34')"} {"userId":"2","date":"2021-02-03 22:00:41","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '122.176.151.202', '2021-02-03 22:00:41')"} {"userId":"2","date":"2021-02-03 22:01:09","query":"UPDATE usermst SET `password` = '43fd182a9c45094395bc6a3e01efb07d', `modifiedby` = '2', `modifieddate` = '2021-02-03 22:01:09', `ipaddress` = '122.176.151.202' WHERE userid = '2'"} {"userId":"2","date":"2021-02-03 22:01:52","query":"UPDATE usermst SET `firstname` = 'Anwita', `lastname` = 'Khaitan', `email` = 'anwitakhaitan@gmail.com', `mobilenum` = '9999369429', `designation` = 'Consultant cum Project Coordinator', `organization` = 'NI-AIIMS', `roleid` = '2', `ipaddress` = '122.176.151.202', `createdby` = '2', `createddate` = '2021-02-03 22:01:52' WHERE userid = '386'"} {"userId":"2","date":"2021-02-03 22:01:52","query":"UPDATE userlocation SET `userid` = '386', `countryid` = '101', `stateid` = '10', `riid` = '', `cityid` = '707', `districtid` = '141', `ipaddress` = '122.176.151.202', `createdby` = '2', `createddate` = '2021-02-03 22:01:52' WHERE userid = '386'"} {"userId":"2","date":"2021-02-03 22:02:09","query":"UPDATE usermst SET `ipaddress` = '122.176.151.202', `modifiedby` = '2', `modifieddate` = '2021-02-03 22:02:09', `isdeleted` = '1' WHERE userid = '243'"} {"userId":"2","date":"2021-02-03 22:02:54","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '122.176.151.202', '2021-02-03 22:02:54')"} {"userId":"2","date":"2021-02-03 22:04:07","query":"UPDATE usermst SET `firstname` = 'Anwita', `lastname` = 'Khaitan', `email` = 'anwitakhaitan@gmail.com', `mobilenum` = '9999369429', `designation` = 'Consultant cum Project Coordinator', `organization` = 'NI-AIIMS', `roleid` = '3', `ipaddress` = '122.176.151.202', `createdby` = '2', `createddate` = '2021-02-03 22:04:07' WHERE userid = '386'"} {"userId":"2","date":"2021-02-03 22:04:07","query":"UPDATE userlocation SET `userid` = '386', `countryid` = '101', `stateid` = '10', `riid` = '3', `cityid` = '0', `districtid` = '0', `ipaddress` = '122.176.151.202', `createdby` = '2', `createddate` = '2021-02-03 22:04:07' WHERE userid = '386'"} {"userId":"2","date":"2021-02-03 22:04:32","query":"UPDATE usermst SET `ipaddress` = '122.176.151.202', `modifiedby` = '2', `modifieddate` = '2021-02-03 22:04:32', `isdeleted` = '1' WHERE userid = '374'"} {"userId":"2","date":"2021-02-03 22:05:20","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('RIAIIMS', 'HSS', 'riaiims.hss@gmail.com', '7042647893', '', '', 'd4b4b23931c9a88d67da4ac7412e48e5', '3', '122.176.151.202', '2', '2021-02-03 22:05:20')"} {"userId":"2","date":"2021-02-03 22:05:20","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('435', '101', '10', '0', '3', '0', '122.176.151.202', '2', '2021-02-03 22:05:20')"} {"userId":"394","date":"2021-02-03 22:58:52","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('394', '47.29.136.130', '2021-02-03 22:58:52')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1393', '975', '394', '2021-02-03', '1', '47.29.164.27', '394', '2021-02-03 23:00:59', '', '')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('779', '0', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('779', '1', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('779', '2', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('779', '3', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('779', '', '', 'Array', '', 'Array', '', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('779', '', '', 'Array', '', 'Array', '', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('779', '', '', 'Array', '', 'Array', '', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('779', '', '', 'Array', '', 'Array', '', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('183', '779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:00:59","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('779', '47.29.164.27', '394', '2021-02-03 23:00:59')"} {"userId":"394","date":"2021-02-03 23:06:53","query":"UPDATE sitesupervision SET `siteid` = '1393', `userid` = '394', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '5', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:06:53', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '779'"} {"userId":"394","date":"2021-02-03 23:06:53","query":"UPDATE onsitestaffs SET `staffname` = 'Pradip Bezboruah', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:06:53' WHERE onssid = '3444'"} {"userId":"394","date":"2021-02-03 23:06:53","query":"UPDATE onsitestaffs SET `staffname` = 'Mridusmita Nath', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'Newly joined', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:06:53' WHERE onssid = '3445'"} {"userId":"394","date":"2021-02-03 23:06:53","query":"UPDATE onsitestaffs SET `staffname` = 'Dipankar Hazarika', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:06:53' WHERE onssid = '3446'"} {"userId":"394","date":"2021-02-03 23:06:53","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:06:53' WHERE onssid = '3447'"} {"userId":"394","date":"2021-02-03 23:06:53","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=81045 then '2' when ansid=81046 then '1' when ansid=81047 then '1' when ansid=81048 then '0' when ansid=81049 then '0' when ansid=81050 then '3' when ansid=81051 then '3' when ansid=81052 then '' when ansid=81053 then '' when ansid=81054 then '' when ansid=81055 then '' when ansid=81056 then '' when ansid=81057 then '' when ansid=81058 then '' when ansid=81059 then '' when ansid=81060 then '' when ansid=81061 then '' when ansid=81062 then '' when ansid=81063 then '' when ansid=81064 then '' when ansid=81065 then '' when ansid=81066 then '' when ansid=81067 then '' when ansid=81068 then '' when ansid=81069 then '' when ansid=81070 then '' when ansid=81071 then '' when ansid=81072 then '' when ansid=81073 then '' when ansid=81074 then '' when ansid=81075 then '' when ansid=81076 then '' when ansid=81077 then '' when ansid=81078 then '' when ansid=81079 then '' when ansid=81080 then '' when ansid=81081 then '' when ansid=81082 then '' when ansid=81083 then '' when ansid=81084 then '' when ansid=81085 then '' when ansid=81086 then '' when ansid=81087 then '' when ansid=81088 then '' when ansid=81089 then '' when ansid=81090 then '' when ansid=81091 then '' when ansid=81092 then '' when ansid=81093 then '' when ansid=81094 then '' when ansid=81095 then '' when ansid=81096 then '' when ansid=81097 then '' when ansid=81098 then '' when ansid=81099 then '' when ansid=81100 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.29.136.130',\n\t\t\t\t\t\t\t\tmodifiedby =394,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-02-03 23:06:53'\n\t\t\t\t\t\t\tWHERE ansid in ('81045','81046','81047','81048','81049','81050','81051','81052','81053','81054','81055','81056','81057','81058','81059','81060','81061','81062','81063','81064','81065','81066','81067','81068','81069','81070','81071','81072','81073','81074','81075','81076','81077','81078','81079','81080','81081','81082','81083','81084','81085','81086','81087','81088','81089','81090','81091','81092','81093','81094','81095','81096','81097','81098','81099','81100')"} {"userId":"394","date":"2021-02-03 23:06:53","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:06:53' WHERE supvisstepid = '4934'"} {"userId":"394","date":"2021-02-03 23:06:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:06:53' WHERE visitfeedbackid = '3671'"} {"userId":"394","date":"2021-02-03 23:06:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:06:53' WHERE visitfeedbackid = '3672'"} {"userId":"394","date":"2021-02-03 23:06:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:06:53' WHERE visitfeedbackid = '3673'"} {"userId":"394","date":"2021-02-03 23:06:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:06:53' WHERE visitfeedbackid = '3674'"} {"userId":"394","date":"2021-02-03 23:06:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:06:53' WHERE visitfeedbackid = '3675'"} {"userId":"394","date":"2021-02-03 23:08:18","query":"UPDATE sitesupervision SET `siteid` = '1393', `userid` = '394', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '5', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:08:18', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '779'"} {"userId":"394","date":"2021-02-03 23:08:18","query":"UPDATE onsitestaffs SET `staffname` = 'Pradip Bezboruah', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:08:18' WHERE onssid = '3444'"} {"userId":"394","date":"2021-02-03 23:08:18","query":"UPDATE onsitestaffs SET `staffname` = 'Mridusmita Nath', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'Newly joined', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:08:18' WHERE onssid = '3445'"} {"userId":"394","date":"2021-02-03 23:08:18","query":"UPDATE onsitestaffs SET `staffname` = 'Dipankar Hazarika', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:08:18' WHERE onssid = '3446'"} {"userId":"394","date":"2021-02-03 23:08:18","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:08:18' WHERE onssid = '3447'"} {"userId":"394","date":"2021-02-03 23:08:18","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=81045 then '2' when ansid=81046 then '1' when ansid=81047 then '1' when ansid=81048 then '0' when ansid=81049 then '0' when ansid=81050 then '3' when ansid=81051 then '3' when ansid=81052 then '' when ansid=81053 then '' when ansid=81054 then '' when ansid=81055 then '' when ansid=81056 then '' when ansid=81057 then '' when ansid=81058 then '' when ansid=81059 then '' when ansid=81060 then '' when ansid=81061 then '' when ansid=81062 then '' when ansid=81063 then '' when ansid=81064 then '' when ansid=81065 then '' when ansid=81066 then '' when ansid=81067 then '' when ansid=81068 then '' when ansid=81069 then '' when ansid=81070 then '' when ansid=81071 then '' when ansid=81072 then '' when ansid=81073 then '' when ansid=81074 then '' when ansid=81075 then '' when ansid=81076 then '' when ansid=81077 then '' when ansid=81078 then '' when ansid=81079 then '' when ansid=81080 then '' when ansid=81081 then '' when ansid=81082 then '' when ansid=81083 then '' when ansid=81084 then '' when ansid=81085 then '' when ansid=81086 then '' when ansid=81087 then '' when ansid=81088 then '' when ansid=81089 then '' when ansid=81090 then '' when ansid=81091 then '' when ansid=81092 then '' when ansid=81093 then '' when ansid=81094 then '' when ansid=81095 then '' when ansid=81096 then '' when ansid=81097 then '' when ansid=81098 then '' when ansid=81099 then '' when ansid=81100 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.29.136.130',\n\t\t\t\t\t\t\t\tmodifiedby =394,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-02-03 23:08:18'\n\t\t\t\t\t\t\tWHERE ansid in ('81045','81046','81047','81048','81049','81050','81051','81052','81053','81054','81055','81056','81057','81058','81059','81060','81061','81062','81063','81064','81065','81066','81067','81068','81069','81070','81071','81072','81073','81074','81075','81076','81077','81078','81079','81080','81081','81082','81083','81084','81085','81086','81087','81088','81089','81090','81091','81092','81093','81094','81095','81096','81097','81098','81099','81100')"} {"userId":"394","date":"2021-02-03 23:08:18","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:08:18' WHERE supvisstepid = '4934'"} {"userId":"394","date":"2021-02-03 23:08:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:08:18' WHERE visitfeedbackid = '3671'"} {"userId":"394","date":"2021-02-03 23:08:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:08:18' WHERE visitfeedbackid = '3672'"} {"userId":"394","date":"2021-02-03 23:08:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:08:18' WHERE visitfeedbackid = '3673'"} {"userId":"394","date":"2021-02-03 23:08:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:08:18' WHERE visitfeedbackid = '3674'"} {"userId":"394","date":"2021-02-03 23:08:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:08:18' WHERE visitfeedbackid = '3675'"} {"userId":"394","date":"2021-02-03 23:09:39","query":"UPDATE sitesupervision SET `siteid` = '1393', `userid` = '394', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '5', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:09:39', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '779'"} {"userId":"394","date":"2021-02-03 23:09:39","query":"UPDATE onsitestaffs SET `staffname` = 'Pradip Bezboruah', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:09:39' WHERE onssid = '3444'"} {"userId":"394","date":"2021-02-03 23:09:39","query":"UPDATE onsitestaffs SET `staffname` = 'Mridusmita Nath', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'Newly joined', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:09:39' WHERE onssid = '3445'"} {"userId":"394","date":"2021-02-03 23:09:39","query":"UPDATE onsitestaffs SET `staffname` = 'Dipankar Hazarika', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:09:39' WHERE onssid = '3446'"} {"userId":"394","date":"2021-02-03 23:09:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:09:39' WHERE onssid = '3447'"} {"userId":"394","date":"2021-02-03 23:09:39","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=81045 then '2' when ansid=81046 then '1' when ansid=81047 then '1' when ansid=81048 then '0' when ansid=81049 then '0' when ansid=81050 then '3' when ansid=81051 then '3' when ansid=81052 then '1' when ansid=81053 then '1' when ansid=81054 then '2' when ansid=81055 then '2' when ansid=81056 then '1' when ansid=81057 then '1' when ansid=81058 then '3' when ansid=81059 then '1' when ansid=81060 then '1' when ansid=81061 then '' when ansid=81062 then '' when ansid=81063 then '' when ansid=81064 then '' when ansid=81065 then '' when ansid=81066 then '' when ansid=81067 then '' when ansid=81068 then '' when ansid=81069 then '' when ansid=81070 then '' when ansid=81071 then '' when ansid=81072 then '' when ansid=81073 then '' when ansid=81074 then '' when ansid=81075 then '' when ansid=81076 then '' when ansid=81077 then '' when ansid=81078 then '' when ansid=81079 then '' when ansid=81080 then '' when ansid=81081 then '' when ansid=81082 then '' when ansid=81083 then '' when ansid=81084 then '' when ansid=81085 then '' when ansid=81086 then '' when ansid=81087 then '' when ansid=81088 then '' when ansid=81089 then '' when ansid=81090 then '' when ansid=81091 then '' when ansid=81092 then '' when ansid=81093 then '' when ansid=81094 then '' when ansid=81095 then '' when ansid=81096 then '' when ansid=81097 then '' when ansid=81098 then '' when ansid=81099 then '' when ansid=81100 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.29.136.130',\n\t\t\t\t\t\t\t\tmodifiedby =394,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-02-03 23:09:39'\n\t\t\t\t\t\t\tWHERE ansid in ('81045','81046','81047','81048','81049','81050','81051','81052','81053','81054','81055','81056','81057','81058','81059','81060','81061','81062','81063','81064','81065','81066','81067','81068','81069','81070','81071','81072','81073','81074','81075','81076','81077','81078','81079','81080','81081','81082','81083','81084','81085','81086','81087','81088','81089','81090','81091','81092','81093','81094','81095','81096','81097','81098','81099','81100')"} {"userId":"394","date":"2021-02-03 23:09:39","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:09:39' WHERE supvisstepid = '4935'"} {"userId":"394","date":"2021-02-03 23:09:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:09:39' WHERE visitfeedbackid = '3671'"} {"userId":"394","date":"2021-02-03 23:09:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:09:39' WHERE visitfeedbackid = '3672'"} {"userId":"394","date":"2021-02-03 23:09:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:09:39' WHERE visitfeedbackid = '3673'"} {"userId":"394","date":"2021-02-03 23:09:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:09:39' WHERE visitfeedbackid = '3674'"} {"userId":"394","date":"2021-02-03 23:09:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:09:39' WHERE visitfeedbackid = '3675'"} {"userId":"394","date":"2021-02-03 23:26:08","query":"UPDATE sitesupervision SET `siteid` = '1393', `userid` = '394', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '5', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:26:08', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '779'"} {"userId":"394","date":"2021-02-03 23:26:08","query":"UPDATE onsitestaffs SET `staffname` = 'Pradip Bezboruah', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:26:08' WHERE onssid = '3444'"} {"userId":"394","date":"2021-02-03 23:26:08","query":"UPDATE onsitestaffs SET `staffname` = 'Mridusmita Nath', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'Newly joined', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:26:08' WHERE onssid = '3445'"} {"userId":"394","date":"2021-02-03 23:26:08","query":"UPDATE onsitestaffs SET `staffname` = 'Dipankar Hazarika', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:26:08' WHERE onssid = '3446'"} {"userId":"394","date":"2021-02-03 23:26:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:26:08' WHERE onssid = '3447'"} {"userId":"394","date":"2021-02-03 23:26:08","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=81045 then '2' when ansid=81046 then '1' when ansid=81047 then '1' when ansid=81048 then '0' when ansid=81049 then '0' when ansid=81050 then '3' when ansid=81051 then '3' when ansid=81052 then '1' when ansid=81053 then '1' when ansid=81054 then '2' when ansid=81055 then '2' when ansid=81056 then '1' when ansid=81057 then '1' when ansid=81058 then '3' when ansid=81059 then '1' when ansid=81060 then '1' when ansid=81061 then '2' when ansid=81062 then '2' when ansid=81063 then '5' when ansid=81064 then '1' when ansid=81065 then '' when ansid=81066 then '1' when ansid=81067 then '' when ansid=81068 then '1' when ansid=81069 then '' when ansid=81070 then '2' when ansid=81071 then '' when ansid=81072 then '1' when ansid=81073 then '' when ansid=81074 then '1' when ansid=81075 then '1' when ansid=81076 then '1' when ansid=81077 then '2' when ansid=81078 then '' when ansid=81079 then '1' when ansid=81080 then '' when ansid=81081 then '1' when ansid=81082 then '' when ansid=81083 then '1' when ansid=81084 then '' when ansid=81085 then '1' when ansid=81086 then '' when ansid=81087 then '1' when ansid=81088 then '' when ansid=81089 then '2' when ansid=81090 then '' when ansid=81091 then '2' when ansid=81092 then '2' when ansid=81093 then '2' when ansid=81094 then '1' when ansid=81095 then '1' when ansid=81096 then '1' when ansid=81097 then 'Drying box was not available as per requirement for storage of unused DBS cards. It has been made available immediately on the same day after instructions for storage of the same as per guidelines.' when ansid=81098 then 'No earlier supervisory visits has been made to this site in this session .' when ansid=81099 then '1. Data form was not completely filled by the Counsellor because of some understanding problems. Hands on training has been given to rectify the problems to correctly or completely and consistently fill the Data form.2.DBS (unused) cards were not properly stored as per guidelines because of unavailability of adequate numbers of drying box. Advised them to immediately purchased the same for storage of the same.3. PE wise list was not prepared. Advised them to prepare it as soon as possible or by today.' when ansid=81100 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.29.136.130',\n\t\t\t\t\t\t\t\tmodifiedby =394,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-02-03 23:26:08'\n\t\t\t\t\t\t\tWHERE ansid in ('81045','81046','81047','81048','81049','81050','81051','81052','81053','81054','81055','81056','81057','81058','81059','81060','81061','81062','81063','81064','81065','81066','81067','81068','81069','81070','81071','81072','81073','81074','81075','81076','81077','81078','81079','81080','81081','81082','81083','81084','81085','81086','81087','81088','81089','81090','81091','81092','81093','81094','81095','81096','81097','81098','81099','81100')"} {"userId":"394","date":"2021-02-03 23:26:08","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:26:08' WHERE supvisstepid = '4936'"} {"userId":"394","date":"2021-02-03 23:26:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:26:08' WHERE visitfeedbackid = '3671'"} {"userId":"394","date":"2021-02-03 23:26:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:26:08' WHERE visitfeedbackid = '3672'"} {"userId":"394","date":"2021-02-03 23:26:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:26:08' WHERE visitfeedbackid = '3673'"} {"userId":"394","date":"2021-02-03 23:26:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:26:08' WHERE visitfeedbackid = '3674'"} {"userId":"394","date":"2021-02-03 23:26:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.136.130', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:26:08' WHERE visitfeedbackid = '3675'"} {"userId":"394","date":"2021-02-03 23:48:07","query":"UPDATE sitesupervision SET `siteid` = '1393', `userid` = '394', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '5', `ipaddress` = '47.29.164.27', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:48:07', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '779'"} {"userId":"394","date":"2021-02-03 23:48:07","query":"UPDATE onsitestaffs SET `staffname` = 'Pradip Bezboruah', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.164.27', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:48:07' WHERE onssid = '3444'"} {"userId":"394","date":"2021-02-03 23:48:07","query":"UPDATE onsitestaffs SET `staffname` = 'Mridusmita Nath', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'Newly joined', `ipaddress` = '47.29.164.27', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:48:07' WHERE onssid = '3445'"} {"userId":"394","date":"2021-02-03 23:48:07","query":"UPDATE onsitestaffs SET `staffname` = 'Dipankar Hazarika', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.164.27', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:48:07' WHERE onssid = '3446'"} {"userId":"394","date":"2021-02-03 23:48:07","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.164.27', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:48:07' WHERE onssid = '3447'"} {"userId":"394","date":"2021-02-03 23:48:07","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=81045 then '2' when ansid=81046 then '1' when ansid=81047 then '1' when ansid=81048 then '0' when ansid=81049 then '0' when ansid=81050 then '3' when ansid=81051 then '3' when ansid=81052 then '1' when ansid=81053 then '1' when ansid=81054 then '2' when ansid=81055 then '2' when ansid=81056 then '1' when ansid=81057 then '1' when ansid=81058 then '3' when ansid=81059 then '1' when ansid=81060 then '1' when ansid=81061 then '2' when ansid=81062 then '2' when ansid=81063 then '5' when ansid=81064 then '1' when ansid=81065 then '' when ansid=81066 then '1' when ansid=81067 then '' when ansid=81068 then '1' when ansid=81069 then '' when ansid=81070 then '2' when ansid=81071 then '' when ansid=81072 then '1' when ansid=81073 then '' when ansid=81074 then '1' when ansid=81075 then '1' when ansid=81076 then '1' when ansid=81077 then '2' when ansid=81078 then '' when ansid=81079 then '1' when ansid=81080 then '' when ansid=81081 then '1' when ansid=81082 then '' when ansid=81083 then '1' when ansid=81084 then '' when ansid=81085 then '1' when ansid=81086 then '' when ansid=81087 then '1' when ansid=81088 then '' when ansid=81089 then '2' when ansid=81090 then '' when ansid=81091 then '2' when ansid=81092 then '2' when ansid=81093 then '2' when ansid=81094 then '1' when ansid=81095 then '1' when ansid=81096 then '1' when ansid=81097 then 'Drying box was not available as per requirement for storage of unused DBS cards. It has been made available immediately on the same day after instructions for storage of the same as per guidelines.' when ansid=81098 then 'No earlier supervisory visits has been made to this site in this session .' when ansid=81099 then '1. Data form was not completely filled by the Counsellor because of some understanding problems. Hands on training has been given to rectify the problems to correctly or completely and consistently fill the Data form.2.DBS (unused) cards were not properly stored as per guidelines because of unavailability of adequate numbers of drying box. Advised them to immediately purchased the same for storage of the same.3. PE wise list was not prepared. Advised them to prepare it as soon as possible or by today.' when ansid=81100 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.29.164.27',\n\t\t\t\t\t\t\t\tmodifiedby =394,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-02-03 23:48:07'\n\t\t\t\t\t\t\tWHERE ansid in ('81045','81046','81047','81048','81049','81050','81051','81052','81053','81054','81055','81056','81057','81058','81059','81060','81061','81062','81063','81064','81065','81066','81067','81068','81069','81070','81071','81072','81073','81074','81075','81076','81077','81078','81079','81080','81081','81082','81083','81084','81085','81086','81087','81088','81089','81090','81091','81092','81093','81094','81095','81096','81097','81098','81099','81100')"} {"userId":"394","date":"2021-02-03 23:48:07","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.29.164.27', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:48:07' WHERE supvisstepid = '4937'"} {"userId":"394","date":"2021-02-03 23:48:07","query":"UPDATE visitfeedback SET `feedback` = 'Data form was incompletely filled by the Counsellor because of some understanding problems about the questions in the data form. Hands on training has been given to counsellor to improve her understandings.', `recommendation` = 'Site in charge was instructed to guide the Counsellor while filling the data forms .', `ipaddress` = '47.29.164.27', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:48:07' WHERE visitfeedbackid = '3671'"} {"userId":"394","date":"2021-02-03 23:48:07","query":"UPDATE visitfeedback SET `feedback` = 'Unused DBS cards were not properly stored as per the guidelines because of unavailability of drying box. Instruction has been given to immediately purchase it or make it available for storage of the same.', `recommendation` = 'Storage of used and unused DBS cards as per guidelines', `ipaddress` = '47.29.164.27', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:48:07' WHERE visitfeedbackid = '3672'"} {"userId":"394","date":"2021-02-03 23:48:07","query":"UPDATE visitfeedback SET `feedback` = 'PE wise list was not prepared. It has been instructed to prepare the PE wise list immediately from the master list supplied by SACS.', `recommendation` = 'Drying rack should always be kept inside the closed lid box in vertical position.', `ipaddress` = '47.29.164.27', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:48:07' WHERE visitfeedbackid = '3673'"} {"userId":"394","date":"2021-02-03 23:48:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = 'Universal safety precautions should always be followed while drawing or handling blood .', `ipaddress` = '47.29.164.27', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:48:07' WHERE visitfeedbackid = '3674'"} {"userId":"394","date":"2021-02-03 23:48:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.164.27', `modifiedby` = '394', `modifieddate` = '2021-02-03 23:48:07' WHERE visitfeedbackid = '3675'"}