ameyawebonise

+----+--------------+--------------------------+-------------+-----------------------------------------------------------------------+---------------------------------------------------+---------+------------------------------------------------------------------------+------+----------+----------------------------------------------------------------------------------------------+
| id | select_type  | table                    | type        | possible_keys                                                         | key                                               | key_len | ref                                                                    | rows | filtered | Extra                                                                                        |
+----+--------------+--------------------------+-------------+-----------------------------------------------------------------------+---------------------------------------------------+---------+--------------------------------------------------------------

ameyawebonise

 DECLARE groupID INT;

    INSERT INTO TRACKER_REVIEW_AUDIT (trCTM_DataID, AUDIT_Date, EditWho_Id, WAS_Value, IS_Value, WAS_trCTM_ItemID, IS_trCTM_ItemID, WAS_Approved, IS_Approved, WAS_Expiration_Date, IS_Expiration_Date, WAS_Rej_Reason, IS_Rej_Reason, WAS_Reviewer, IS_Reviewer, WAS_Dose, IS_Dose, WAS_Administered_Date, IS_Administered_Date, IS_Test_Results, IS_Test_Result_Notes, IS_Next_Step, IS_Complete, IS_Pre, IS_Pre_Date, IS_Post, IS_Post_Date, WAS_Test_Results, WAS_Test_Result_Notes, WAS_Next_Step, WAS_Complete, WAS_Pre, WAS_Pre_Date, WAS_Post, WAS_Post_Date, IS_Record_Type, WAS_Record_Type, IS_trCTM_Status, WAS_trCTM_Status)
    VALUES (NEW.trCTM_DataID, NOW(), NEW.EDIT_Who, NULL, NEW.trCTM_Value, NULL, NEW.trCTM_ItemID, NULL, NEW.trCTM_Approved, NULL,NEW.trCTM_Expiration_Date, NULL, NEW.trCTM_Rej_Reason, NULL,  NEW.trCTM_Reviewer, NULL,  NEW.trCTM_Dose,NULL,  NEW.trCTM_Administered_Date,NEW.trCTM_Test_Results, NEW.trCTM_Test_Result_Notes, NEW.trCTM_Next_Step, NEW.trCTM_Complete, NEW.trCTM_Pre, NEW.tr

ameyawebonise

DECLARE groupId INT;

    INSERT INTO TRACKER_REVIEW_AUDIT (trCTM_DataID, AUDIT_Date, EditWho_Id, WAS_Value, IS_Value, WAS_trCTM_ItemID, IS_trCTM_ItemID, WAS_Approved, IS_Approved, WAS_Expiration_Date, IS_Expiration_Date, WAS_Rej_Reason, IS_Rej_Reason, WAS_Reviewer, IS_Reviewer, WAS_Dose, IS_Dose, WAS_Administered_Date, IS_Administered_Date, IS_Test_Results, IS_Test_Result_Notes, IS_Next_Step, IS_Complete, IS_Pre, IS_Pre_Date, IS_Post, IS_Post_Date, WAS_Test_Results, WAS_Test_Result_Notes, WAS_Next_Step, WAS_Complete, WAS_Pre, WAS_Pre_Date, WAS_Post, WAS_Post_Date, IS_Record_Type, WAS_Record_Type, IS_trCTM_Status, WAS_trCTM_Status)
    VALUES (NEW.trCTM_DataID, NOW(), COALESCE(NEW.EDIT_Who, OLD.EDIT_Who), OLD.trCTM_Value, NEW.trCTM_Value, OLD.trCTM_ItemID, NEW.trCTM_ItemID,OLD.trCTM_Approved, NEW.trCTM_Approved,OLD.trCTM_Expiration_Date,NEW.trCTM_Expiration_Date, OLD.trCTM_Rej_Reason, NEW.trCTM_Rej_Reason, OLD.trCTM_Reviewer, NEW.trCTM_Reviewer, OLD.trCTM_Dose, NEW.trCTM_Dose,OLD.trCTM_Administered_Date, NEW.

ameyawebonise

package com.magnus.newpack.webapp.tracker;

import com.magnus.foundation.spring.AppContext;
import com.magnus.newpack.model.TrackerCustomItem;
import com.magnus.newpack.webapp.action.tracker.CustomTrackerPage;
import mockit.Expectations;
import mockit.Mocked;
import org.apache.log4j.Logger;
import org.testng.Assert;
import org.testng.annotations.BeforeClass;

ameyawebonise

package com.magnus.newpack.webapp.tracker;

import com.magnus.foundation.spring.AppContext;
import com.magnus.newpack.model.TrackerCustomItem;
import com.magnus.newpack.webapp.action.tracker.CustomTrackerPage;
import mockit.Expectations;
import mockit.Mocked;
import org.apache.log4j.Logger;
import org.testng.Assert;
import org.testng.annotations.BeforeClass;

ameyawebonise

package com.magnus.newpack.dao;


import java.util.Collection;
import java.util.HashSet;
import java.util.Set;
import java.util.concurrent.TimeUnit;

import com.magnus.common.utils.MagnusPropertySettingsUtils;
import redis.clients.jedis.*;

ameyawebonise

data

2015-10-16 18:40:24.876 CaptnCrunch[7797:148721] docID {"studentId":1001812056,"nonce":"466693817.159792","session":"1fbe031c9d604acc62fe4ff658363036","docId":3547795}
Printing description of json:
{
    checksum = 292a7969883e58006a18ad002dc3fcd9;
    documentName = "Sample Influenza Release Form";
    extension = pdf;
    file = "JVBERi0xLjUNCiW1tbW1DQoxIDAgb2JqDQo8PC9UeXBlL0NhdGFsb2cvUGFnZXMgMiAwIFIvTGFuZyhlbi1VUykgL1N0cnVjdFRyZWVSb290IDM1IDAgUi9NYXJrSW5mbzw8L01hcmtlZCB0cnVlPj4+Pg0KZW5kb2JqDQoyIDAgb2JqDQo8PC9UeXBlL1BhZ2VzL0NvdW50IDEzL0tpZHNbIDMgMCBSIDggMCBSIDExIDAgUiAxMyAwIFIgMTYgMCBSIDE4IDAgUiAyMCAwIFIgMjIgMCBSIDI0IDAgUiAyNiAwIFIgMjggMCBSIDMwIDAgUiAzMiAwIFJdID4+DQplbmRvYmoNCjMgMCBvYmoNCjw8L1R5cGUvUGFnZS9QYXJlbnQgMiAwIFIvUmVzb3VyY2VzPDwvRm9udDw8L0YxIDUgMCBSPj4vWE9iamVjdDw8L0ltYWdlNyA3IDAgUj4+L1Byb2NTZXRbL1BERi9UZXh0L0ltYWdlQi9JbWFnZUMvSW1hZ2VJXSA+Pi9NZWRpYUJveFsgMCAwIDYxMiA3OTJdIC9Db250ZW50cyA0IDAgUi9Hcm91cDw8L1R5cGUvR3JvdXAvUy9UcmFuc3BhcmVuY3kvQ1MvRGV2aWNlUkdCPj4vVGFicy9TL1N0cnVjdFBhcmVudHMgMD4+DQpl

ameyawebonise

{
  "compliance" : "BOTH",
  "who" : [ {
    "lhs" : {
      "type" : "AllTrackers"
    },
    "operator" : null,
    "rhs" : [ ]
  } ],
  "what" : [ {