{"userId":"1","date":"2019-04-14 18:52:58","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '49.34.68.240', '2019-04-14 18:52:58')"}
{"userId":"30","date":"2019-04-14 20:36:20","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('30', '117.214.49.125', '2019-04-14 20:36:20')"}
{"userId":"30","date":"2019-04-14 20:41:49","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('357', '2019-04-02', '30', '117.214.49.125', '30', '2019-04-14 20:41:49')"}
{"userId":"30","date":"2019-04-14 20:42:08","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('373', '2019-04-03', '30', '117.214.49.125', '30', '2019-04-14 20:42:08')"}
{"userId":"30","date":"2019-04-14 20:42:25","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('372', '2019-04-05', '30', '117.214.49.125', '30', '2019-04-14 20:42:25')"}
{"userId":"30","date":"2019-04-14 20:42:42","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('356', '2019-04-06', '30', '117.214.49.125', '30', '2019-04-14 20:42:42')"}
{"userId":"30","date":"2019-04-14 20:43:00","query":"UPDATE sitesupervision SET `siteid` = '351', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-04-12', `numofsamplecollected` = '160', `ipaddress` = '117.214.49.125', `modifiedby` = '30', `modifieddate` = '2019-04-14 20:43:00', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '724'"}
{"userId":"30","date":"2019-04-14 20:43:00","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Suchandran', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.49.125', `modifiedby` = '30', `modifieddate` = '2019-04-14 20:43:00' WHERE onssid = '3224'"}
{"userId":"30","date":"2019-04-14 20:43:00","query":"UPDATE onsitestaffs SET `staffname` = 'Pramila Kumari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '13', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.49.125', `modifiedby` = '30', `modifieddate` = '2019-04-14 20:43:00' WHERE onssid = '3225'"}
{"userId":"30","date":"2019-04-14 20:43:00","query":"UPDATE onsitestaffs SET `staffname` = 'Sunil Kumar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.49.125', `modifiedby` = '30', `modifieddate` = '2019-04-14 20:43:00' WHERE onssid = '3226'"}
{"userId":"30","date":"2019-04-14 20:43:00","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.49.125', `modifiedby` = '30', `modifieddate` = '2019-04-14 20:43:00' WHERE onssid = '3227'"}
{"userId":"30","date":"2019-04-14 20:43:00","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=75834 then '1' when ansid=75835 then '1' when ansid=75836 then '1' when ansid=75837 then '' when ansid=75838 then ''  when ansid=75839 then ''   when ansid=75840 then '1'  when ansid=75841 then '' when ansid=75843 then '' when ansid=75845 then '' when ansid=75847 then '' when ansid=75849 then '' when ansid=75851 then '' when ansid=75853 then '' when ansid=75855 then '' when ansid=75857 then '' when ansid=75859 then '' when ansid=75861 then '' when ansid=75863 then '' when ansid=75865 then '' when ansid=75867 then '' when ansid=75869 then '' when ansid=75871 then '' when ansid=75873 then '' when ansid=75875 then '' when ansid=75877 then '' when ansid=75879 then '' when ansid=75881 then '' when ansid=75883 then '' when ansid=75885 then '' when ansid=75887 then '' when ansid=75889 then '' when ansid=75891 then '' when ansid=75893 then '' when ansid=75894 then '' when ansid=75895 then '' when ansid=75896 then ''  when ansid=75897 then ''   when ansid=75898 then ''  when ansid=75899 then ''  when ansid=75900 then ''   when ansid=75901 then ''   when ansid=75902 then ''   when ansid=75903 then ''  when ansid=75904 then '' when ansid=75905 then '' when ansid=75906 then ''  when ansid=75907 then ''   when ansid=75908 then ''   when ansid=75909 then ''   when ansid=75910 then ''  when ansid=75911 then ''  when ansid=75912 then ''   when ansid=75913 then ''  when ansid=75914 then '' when ansid=75915 then '' when ansid=75916 then '' when ansid=75917 then '' when ansid=75918 then '' when ansid=75919 then '' when ansid=75920 then '' when ansid=75921 then '' when ansid=75922 then ''  when ansid=75923 then ''   when ansid=75924 then ''   when ansid=75925 then ''   when ansid=75926 then ''  when ansid=75927 then '' when ansid=75928 then ''  when ansid=75929 then ''   when ansid=75930 then ''  when ansid=75931 then '' when ansid=75932 then '' when ansid=75933 then '' when ansid=75934 then '' when ansid=75935 then '' when ansid=75936 then '' when ansid=75937 then '' when ansid=75938 then '' when ansid=75939 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.49.125',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-14 20:43:00'\n\t\t\t\t\t\t\tWHERE ansid in ('75834','75835','75836','75837','75838','75839','75840','75841','75843','75845','75847','75849','75851','75853','75855','75857','75859','75861','75863','75865','75867','75869','75871','75873','75875','75877','75879','75881','75883','75885','75887','75889','75891','75893','75894','75895','75896','75897','75898','75899','75900','75901','75902','75903','75904','75905','75906','75907','75908','75909','75910','75911','75912','75913','75914','75915','75916','75917','75918','75919','75920','75921','75922','75923','75924','75925','75926','75927','75928','75929','75930','75931','75932','75933','75934','75935','75936','75937','75938','75939')"}
{"userId":"30","date":"2019-04-14 20:43:00","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.49.125', `modifiedby` = '30', `modifieddate` = '2019-04-14 20:43:00' WHERE supvisstepid = '4645'"}
{"userId":"30","date":"2019-04-14 20:43:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.49.125', `modifiedby` = '30', `modifieddate` = '2019-04-14 20:43:00' WHERE visitfeedbackid = '3396'"}
{"userId":"30","date":"2019-04-14 20:43:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.49.125', `modifiedby` = '30', `modifieddate` = '2019-04-14 20:43:00' WHERE visitfeedbackid = '3397'"}
{"userId":"30","date":"2019-04-14 20:43:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.49.125', `modifiedby` = '30', `modifieddate` = '2019-04-14 20:43:00' WHERE visitfeedbackid = '3398'"}
{"userId":"30","date":"2019-04-14 20:43:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.49.125', `modifiedby` = '30', `modifieddate` = '2019-04-14 20:43:00' WHERE visitfeedbackid = '3399'"}
{"userId":"30","date":"2019-04-14 20:43:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.49.125', `modifiedby` = '30', `modifieddate` = '2019-04-14 20:43:00' WHERE visitfeedbackid = '3400'"}