{"userId":"1","date":"2021-01-06 23:24:42","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '49.34.24.62', '2021-01-06 23:24:42')"}
{"userId":"1","date":"2021-01-06 23:25:56","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('Test Gandhinar', '3', '12', '5', '158', '1223', '1', '500', '49.34.24.62', '1', '2021-01-06 23:25:56')"}
{"userId":"1","date":"2021-01-06 23:26:41","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1097', '2021-01-06', '1', '49.34.24.62', '1', '2021-01-06 23:26:41')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1097', '940', '1', '2021-01-06', '1', '49.34.24.62', '1', '2021-01-06 23:31:57', '', '')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('752', '0', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('752', '1', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('752', '2', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('752', '3', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('752', '', '', 'Array', '', 'Array', '', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('752', '', '', 'Array', '', 'Array', '', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('752', '', '', 'Array', '', 'Array', '', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('752', '', '', 'Array', '', 'Array', '', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:31:57","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('752', '49.34.24.62', '1', '2021-01-06 23:31:57')"}
{"userId":"1","date":"2021-01-06 23:35:33","query":"UPDATE sitesupervision SET `siteid` = '1097', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-06', `numofsamplecollected` = '65', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:35:33', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '752'"}
{"userId":"1","date":"2021-01-06 23:35:33","query":"UPDATE onsitestaffs SET `staffname` = 'Paresh Patel', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = 'test 1', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:35:33' WHERE onssid = '3336'"}
{"userId":"1","date":"2021-01-06 23:35:33","query":"UPDATE onsitestaffs SET `staffname` = 'Makank Dave', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = 'test 2', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:35:33' WHERE onssid = '3337'"}
{"userId":"1","date":"2021-01-06 23:35:33","query":"UPDATE onsitestaffs SET `staffname` = 'Usha Shah', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '0', `remarks` = 'test 3', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:35:33' WHERE onssid = '3338'"}
{"userId":"1","date":"2021-01-06 23:35:33","query":"UPDATE onsitestaffs SET `staffname` = 'Om Prakash', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '3', `istrained` = '1', `remarks` = 'test 4', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:35:33' WHERE onssid = '3339'"}
{"userId":"1","date":"2021-01-06 23:35:33","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=78742 then '1' when ansid=78743 then '3' when ansid=78744 then '3' when ansid=78745 then '66' when ansid=78746 then '60' when ansid=78747 then '3' when ansid=78748 then '3' when ansid=78749 then '' when ansid=78750 then '' when ansid=78751 then '' when ansid=78752 then '' when ansid=78753 then '' when ansid=78754 then '' when ansid=78755 then '' when ansid=78756 then '' when ansid=78757 then '' when ansid=78758 then '' when ansid=78759 then '' when ansid=78760 then '' when ansid=78761 then ''  when ansid=78762 then ''   when ansid=78763 then ''  when ansid=78764 then ''  when ansid=78765 then ''   when ansid=78766 then ''   when ansid=78767 then ''   when ansid=78768 then ''   when ansid=78769 then ''   when ansid=78770 then ''  when ansid=78771 then '' when ansid=78772 then '' when ansid=78773 then ''  when ansid=78774 then ''   when ansid=78775 then ''   when ansid=78776 then ''   when ansid=78777 then ''   when ansid=78778 then ''   when ansid=78779 then ''   when ansid=78780 then ''   when ansid=78781 then ''   when ansid=78782 then ''   when ansid=78783 then ''   when ansid=78784 then ''   when ansid=78785 then ''   when ansid=78786 then ''   when ansid=78787 then ''  when ansid=78788 then '' when ansid=78789 then '' when ansid=78790 then '' when ansid=78791 then '' when ansid=78792 then '' when ansid=78793 then '' when ansid=78794 then '' when ansid=78795 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '49.34.24.62',\n\t\t\t\t\t\t\t\tmodifiedby =1,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-06 23:35:33'\n\t\t\t\t\t\t\tWHERE ansid in ('78742','78743','78744','78745','78746','78747','78748','78749','78750','78751','78752','78753','78754','78755','78756','78757','78758','78759','78760','78761','78762','78763','78764','78765','78766','78767','78768','78769','78770','78771','78772','78773','78774','78775','78776','78777','78778','78779','78780','78781','78782','78783','78784','78785','78786','78787','78788','78789','78790','78791','78792','78793','78794','78795')"}
{"userId":"1","date":"2021-01-06 23:35:33","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:35:33' WHERE supvisstepid = '4811'"}
{"userId":"1","date":"2021-01-06 23:35:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:35:33' WHERE visitfeedbackid = '3536'"}
{"userId":"1","date":"2021-01-06 23:35:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:35:33' WHERE visitfeedbackid = '3537'"}
{"userId":"1","date":"2021-01-06 23:35:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:35:33' WHERE visitfeedbackid = '3538'"}
{"userId":"1","date":"2021-01-06 23:35:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:35:33' WHERE visitfeedbackid = '3539'"}
{"userId":"1","date":"2021-01-06 23:35:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:35:33' WHERE visitfeedbackid = '3540'"}
{"userId":"1","date":"2021-01-06 23:36:28","query":"UPDATE sitesupervision SET `siteid` = '1097', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-06', `numofsamplecollected` = '65', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:36:28', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '752'"}
{"userId":"1","date":"2021-01-06 23:36:28","query":"UPDATE onsitestaffs SET `staffname` = 'Paresh Patel', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = 'test 1', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:36:28' WHERE onssid = '3336'"}
{"userId":"1","date":"2021-01-06 23:36:28","query":"UPDATE onsitestaffs SET `staffname` = 'Makank Dave', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = 'test 2', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:36:28' WHERE onssid = '3337'"}
{"userId":"1","date":"2021-01-06 23:36:28","query":"UPDATE onsitestaffs SET `staffname` = 'Usha Shah', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '0', `remarks` = 'test 3', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:36:28' WHERE onssid = '3338'"}
{"userId":"1","date":"2021-01-06 23:36:28","query":"UPDATE onsitestaffs SET `staffname` = 'Om Prakash', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '3', `istrained` = '1', `remarks` = 'test 4', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:36:28' WHERE onssid = '3339'"}
{"userId":"1","date":"2021-01-06 23:36:28","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=78742 then '1' when ansid=78743 then '3' when ansid=78744 then '3' when ansid=78745 then '66' when ansid=78746 then '60' when ansid=78747 then '3' when ansid=78748 then '3' when ansid=78749 then '2' when ansid=78750 then '2' when ansid=78751 then '1' when ansid=78752 then '1' when ansid=78753 then '2' when ansid=78754 then '1' when ansid=78755 then '3' when ansid=78756 then '3' when ansid=78757 then '2' when ansid=78758 then '' when ansid=78759 then '' when ansid=78760 then '' when ansid=78761 then ''  when ansid=78762 then ''   when ansid=78763 then ''  when ansid=78764 then ''  when ansid=78765 then ''   when ansid=78766 then ''   when ansid=78767 then ''   when ansid=78768 then ''   when ansid=78769 then ''   when ansid=78770 then ''  when ansid=78771 then '' when ansid=78772 then '' when ansid=78773 then ''  when ansid=78774 then ''   when ansid=78775 then ''   when ansid=78776 then ''   when ansid=78777 then ''   when ansid=78778 then ''   when ansid=78779 then ''   when ansid=78780 then ''   when ansid=78781 then ''   when ansid=78782 then ''   when ansid=78783 then ''   when ansid=78784 then ''   when ansid=78785 then ''   when ansid=78786 then ''   when ansid=78787 then ''  when ansid=78788 then '' when ansid=78789 then '' when ansid=78790 then '' when ansid=78791 then '' when ansid=78792 then '' when ansid=78793 then '' when ansid=78794 then '' when ansid=78795 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '49.34.24.62',\n\t\t\t\t\t\t\t\tmodifiedby =1,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-06 23:36:28'\n\t\t\t\t\t\t\tWHERE ansid in ('78742','78743','78744','78745','78746','78747','78748','78749','78750','78751','78752','78753','78754','78755','78756','78757','78758','78759','78760','78761','78762','78763','78764','78765','78766','78767','78768','78769','78770','78771','78772','78773','78774','78775','78776','78777','78778','78779','78780','78781','78782','78783','78784','78785','78786','78787','78788','78789','78790','78791','78792','78793','78794','78795')"}
{"userId":"1","date":"2021-01-06 23:36:28","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:36:28' WHERE supvisstepid = '4812'"}
{"userId":"1","date":"2021-01-06 23:36:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:36:28' WHERE visitfeedbackid = '3536'"}
{"userId":"1","date":"2021-01-06 23:36:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:36:28' WHERE visitfeedbackid = '3537'"}
{"userId":"1","date":"2021-01-06 23:36:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:36:28' WHERE visitfeedbackid = '3538'"}
{"userId":"1","date":"2021-01-06 23:36:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:36:28' WHERE visitfeedbackid = '3539'"}
{"userId":"1","date":"2021-01-06 23:36:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:36:28' WHERE visitfeedbackid = '3540'"}
{"userId":"1","date":"2021-01-06 23:48:25","query":"UPDATE sitesupervision SET `siteid` = '1097', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-06', `numofsamplecollected` = '65', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:48:25', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '752'"}
{"userId":"1","date":"2021-01-06 23:48:25","query":"UPDATE onsitestaffs SET `staffname` = 'Paresh Patel', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = 'test 1', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:48:25' WHERE onssid = '3336'"}
{"userId":"1","date":"2021-01-06 23:48:25","query":"UPDATE onsitestaffs SET `staffname` = 'Makank Dave', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = 'test 2', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:48:25' WHERE onssid = '3337'"}
{"userId":"1","date":"2021-01-06 23:48:25","query":"UPDATE onsitestaffs SET `staffname` = 'Usha Shah', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '0', `remarks` = 'test 3', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:48:25' WHERE onssid = '3338'"}
{"userId":"1","date":"2021-01-06 23:48:25","query":"UPDATE onsitestaffs SET `staffname` = 'Om Prakash', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '3', `istrained` = '1', `remarks` = 'test 4', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:48:25' WHERE onssid = '3339'"}
{"userId":"1","date":"2021-01-06 23:48:25","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=78742 then '1' when ansid=78743 then '3' when ansid=78744 then '3' when ansid=78745 then '66' when ansid=78746 then '60' when ansid=78747 then '3' when ansid=78748 then '3' when ansid=78749 then '2' when ansid=78750 then '2' when ansid=78751 then '1' when ansid=78752 then '1' when ansid=78753 then '2' when ansid=78754 then '1' when ansid=78755 then '3' when ansid=78756 then '3' when ansid=78757 then '2' when ansid=78758 then '56' when ansid=78759 then '45' when ansid=78760 then '75' when ansid=78761 then '1'  when ansid=78762 then 'not required'   when ansid=78763 then '2'  when ansid=78764 then '1'  when ansid=78765 then 'I dont\\'t know'   when ansid=78766 then '3'   when ansid=78767 then ''   when ansid=78768 then '1'   when ansid=78769 then 'Medical Officer'   when ansid=78770 then '3'  when ansid=78771 then '1' when ansid=78772 then '1' when ansid=78773 then '1'  when ansid=78774 then 'abcdefgh'   when ansid=78775 then '3'   when ansid=78776 then '123465'   when ansid=78777 then '3'   when ansid=78778 then ''   when ansid=78779 then '2'   when ansid=78780 then ''   when ansid=78781 then '1'   when ansid=78782 then 'omomom'   when ansid=78783 then '3'   when ansid=78784 then 'asdfg'   when ansid=78785 then '4'   when ansid=78786 then 'post001'   when ansid=78787 then '4'  when ansid=78788 then '1' when ansid=78789 then '1' when ansid=78790 then '1' when ansid=78791 then '1' when ansid=78792 then '1' when ansid=78793 then 'This is test for question no 25' when ansid=78794 then 'This is test for question no 24' when ansid=78795 then 'This is test for question no 27' end),\n\t\t\t\t\t\t\t\t ipaddress = '49.34.24.62',\n\t\t\t\t\t\t\t\tmodifiedby =1,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-06 23:48:25'\n\t\t\t\t\t\t\tWHERE ansid in ('78742','78743','78744','78745','78746','78747','78748','78749','78750','78751','78752','78753','78754','78755','78756','78757','78758','78759','78760','78761','78762','78763','78764','78765','78766','78767','78768','78769','78770','78771','78772','78773','78774','78775','78776','78777','78778','78779','78780','78781','78782','78783','78784','78785','78786','78787','78788','78789','78790','78791','78792','78793','78794','78795')"}
{"userId":"1","date":"2021-01-06 23:48:25","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:48:25' WHERE supvisstepid = '4813'"}
{"userId":"1","date":"2021-01-06 23:48:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:48:25' WHERE visitfeedbackid = '3536'"}
{"userId":"1","date":"2021-01-06 23:48:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:48:25' WHERE visitfeedbackid = '3537'"}
{"userId":"1","date":"2021-01-06 23:48:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:48:25' WHERE visitfeedbackid = '3538'"}
{"userId":"1","date":"2021-01-06 23:48:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:48:25' WHERE visitfeedbackid = '3539'"}
{"userId":"1","date":"2021-01-06 23:48:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.24.62', `modifiedby` = '1', `modifieddate` = '2021-01-06 23:48:25' WHERE visitfeedbackid = '3540'"}