//
function trim(s)
{
	var len = s.length;
	if (len == 0)
		return s;
		
	var idxLeft = 0, idxRight = len - 1;
	
	// trim left
	var i = idxLeft;
	while (i < len)
	{
		var ch = s.charAt(i);
		if (ch != " " && ch != "\t")
			break;
		i++;
	}
	if (i < len)
		idxLeft = i;
	
	// trim right
	i = idxRight;
	while (i > idxLeft)
	{
		var ch = s.charAt(i);
		if (ch != " " && ch != "\t")
			break;
		--i;
	}
	if (i > idxLeft)
		idxRight = i;

	return s.substring(idxLeft, idxRight+1);
}

// map of digital asset id
function IDMap(oldId, newId)
{
	this.oldId = oldId;
	this.newId = newId;
}

function wrongParam()
{
    WScript.StdErr.WriteLine("Usage: CScript //E:JavaScript dbUpgradeDLPTemplate.js working-directory data-source db-name auth-mode user-name password computer-name");
    WScript.Quit(1);
}

if(WScript.Arguments.length!=7)
{
	wrongParam();
}

var fso = new ActiveXObject("Scripting.FileSystemObject");
var instalDir = WScript.Arguments(0);
var dataSource = WScript.Arguments(1);
var dbName = WScript.Arguments(2);
var authMode = WScript.Arguments(3);
var userName = WScript.Arguments(4);
var userPW = WScript.Arguments(5);
var computerName=WScript.Arguments(6);
var sWorkingDirectory = instalDir+"\\config";
var DLPBackupXml = "DlpDataBackup.xml";

WScript.StdOut.WriteLine("");
WScript.StdOut.WriteLine("--------------------------log started------------------------------");
var currentDate = new Date();
WScript.StdOut.WriteLine(currentDate);
WScript.StdOut.WriteLine("");


if (fso.FolderExists(sWorkingDirectory))
{
    try
    {
		var connectStr="";
		if(authMode=="1")
		{
			connectStr="Provider=SQLNCLI11;Application Name=PortalProtect;Integrated Security=SSPI;Persist Security Info=False;Data Source="+dataSource+";Initial Catalog="+dbName+";";
			WScript.StdOut.WriteLine(connectStr);
		}
		else
		{
			connectStr="Provider=SQLNCLI11;Application Name=PortalProtect;Data Source="+dataSource+";Initial Catalog="+dbName+";Persist Security Info=True;User ID="+userName+";Password=";
			WScript.StdOut.WriteLine(connectStr);
			connectStr=connectStr+userPW+";";
		}
        var dbProfile = new DatabaseProfile(instalDir,connectStr);
		dbProfile.ImportDLPData();     	
    }
    catch(e)
    {
    	WScript.StdErr.WriteLine("catch exception in the outest catch");
        WScript.StdErr.WriteLine(e.message + " (" +  e.number + ") ");
        WScript.Quit(e.number);
    }
}
else
{
    wrongParam();
}


function DatabaseProfile(instalDir,connectStr)
{
    var log = new Log(true);
    this.HomeDir = instalDir;
    WScript.Echo("product_home_dir:" + this.HomeDir);
	
    ///////////////////////////////////////////////////////////////////////////////////////////////
    this.ImportDLPData = function()
    {
        var conn = new ActiveXObject("ADODB.Connection");
		conn.Open(connectStr);
        
		function SqlScriptIterator(sqlInstallScript, bHaltOnError)
        {
            try
            {
            	sqlInstallScript=sqlInstallScript.replace(/\n/g,"\r\n");
                conn.Execute(sqlInstallScript);
                log.Write(sqlInstallScript);
            }
            catch(e)
            {
                if (bHaltOnError)
                {
                    throw e;
                }
                else
                {
					log.Write(sqlInstallScript);
                    log.Write("Expected error: ", e.message, " (", e.number, ") ");
                }

            }
            return true;
        }
		
    	var comp = XDoc();
    	var xml_path = sWorkingDirectory + "\\Compliance_Template.xml";
    	WScript.Echo("loading " + xml_path + " ...");
		var loaded = comp.load(xml_path);
		
		if (loaded)
		{
			WScript.Echo("load success");
			this.GetDLPTemplateInstallScripts(comp, SqlScriptIterator, conn);
		}
		else
			WScript.Echo("load failed");
    }
	
	this.GetDLPTemplateInstallScripts = function(dom, visitor, cn)
	{
		WScript.Echo("Enter GetDLPTemplateInstallScripts");
		
		var uniPref = "N";
		
		// backup dlp data to xml file
		if (cn != null)
		{
			// backup templates
			var dom_temp = XDoc();
			dom_temp.loadXML("<dlp><templates/><templateMgr/></dlp>");
			var templatesNode = dom_temp.selectSingleNode("/dlp/templates");
			
			var sql = "SELECT CFG_INDEX,CFG_DEFAULT_INSTANCE,DLP_TEMPLATE_NAME,DLP_TEMPLATE_DESCRIPTION," +
				"DLP_TEMPLATE_BUILTIN,DLP_TEMPLATE_ELEMENT FROM TM_DLPFilterTemplate"+computerName+" WHERE " +
				"CFG_INDEX<>'SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_TEMPLATE_DEFAULT'";
			var rs = cn.Execute(sql);
			while (!rs.EOF)
			{
				var tmpl = dom_temp.createElement("template");
				tmpl.setAttribute("cfg_index", rs(0).Value);
				tmpl.setAttribute("def_instance", rs(1).Value);
				tmpl.setAttribute("name", rs(2).Value);
				tmpl.setAttribute("description", rs(3).Value);
				tmpl.setAttribute("builtin", rs(4).Value);
				tmpl.text = rs(5).Value;
				templatesNode.appendChild(tmpl);
				
				rs.MoveNext();
			}
			rs.Close();
			
			// backup mgr table
			var mgrNode = dom_temp.selectSingleNode("/dlp/templateMgr");
			sql = "SELECT CFG_INDEX,DLP_TEMPLATE_LIST_CFGSETTING_MV FROM TM_DLPTemplateManagement"+computerName;
			rs = cn.Execute(sql);
			while (!rs.EOF)
			{
				var mgr = dom_temp.createElement("mgr");
				mgr.setAttribute("cfg_index", rs(0).Value);
				mgr.text = rs(1).Value;
				mgrNode.appendChild(mgr);
				
				rs.MoveNext();
			}
			rs.Close();
			
			dom_temp.save(sWorkingDirectory + "\\" + DLPBackupXml);
		}
		
		// delete built-in templates
		var sql = "DELETE FROM TM_DLPFilterTemplate"+computerName+" WHERE DLP_TEMPLATE_BUILTIN=" + "1" ;
		visitor(sql, true);
		
		var allUsrCfgIndexes = "";
		var allDefCfgIndexes = "";
		var arrSql = new Array();
		
		if (cn != null)
		{
			var indexPrefix = "SMEX_PLC_NULL:";
			// update the xml content of user created templates
			// and record their cfg_index
			var daMap = this.GetDigitalAssetMap();
			var rs = cn.Execute("SELECT CFG_INDEX,DLP_TEMPLATE_ELEMENT FROM TM_DLPFilterTemplate"+computerName);
	        
	        while (!rs.EOF)
	        {
	        	var cfgIndex = rs(0).Value;
	        	var content = rs(1).Value;
	        	if (content.length > 0)
	        	{
		        	for (var i=0; i<daMap.length; ++i)
		        	{
		        		var repExp = "sourceName=\"" + daMap[i].oldId + "\"";
		        		repExp = repExp.replace(/\x2B/g, "\\+");
		        		repExp = repExp.replace(/\x28/g, "\\(");
		        		repExp = repExp.replace(/\x29/g, "\\)");
		        		var newExp = "sourceName=\"" + daMap[i].newId + "\"";
			        	var re = new RegExp(repExp, "g");
			        	content = content.replace(re, newExp);
			        }
			        
		        	var sql = "UPDATE TM_DLPFilterTemplate"+computerName+" SET DLP_TEMPLATE_ELEMENT=" + uniPref + "'" +
	        			content + "' WHERE CFG_INDEX='" + cfgIndex + "'";
	        		arrSql.push(sql);
	        	
	        		allUsrCfgIndexes += "TM_DLPFilterTemplate:" + cfgIndex.substr(indexPrefix.length) + ":";
	            }
			    
		        rs.MoveNext();
	        }
			rs.Close();
			
			for (var i=0; i<arrSql.length; ++i)
				visitor(arrSql[i]);
				
			arrSql.length = 0;
		}
		
		// insert new built-in templates from xml
		var tmpls = dom.selectNodes("/SAPolicy/complianceTemplates/template");
		for (var i=0; i<tmpls.length; ++i)
		{
			var internalName = tmpls[i].attributes.getNamedItem("name").text;
			if (internalName == "00000000-0000-0000-0004-000000000219")
				continue;
			var cfgIndex = "SMEX_SUB_CFG_DLP_TEMPLATE" + internalName;
			var displayName = tmpls[i].attributes.getNamedItem("display_name").text.replace(/'/g, "''");
			var builtin = tmpls[i].attributes.getNamedItem("pre-defined").text;
		    builtin = (builtin == "true") ? 1 : 0;
			var desc = tmpls[i].attributes.getNamedItem("description").text.replace(/'/g, "''");
			var content = tmpls[i].xml.replace(/'/g, "''");
			
			var industry = "";
			var collIndustry = dom.selectNodes("/SAPolicy/industries/industry[.//template_id='" + internalName + "']/@name");
			for (var j=0; j<collIndustry.length; ++j) 
			{ 
				industry += collIndustry[j].text.replace(/'/g, "''")+";"; 
			}
			
			var region = "";
			var collRegion = dom.selectNodes("/SAPolicy/regions/region[.//template_id='" + internalName+ "']/@name");
			for (var k=0; k<collRegion.length; ++k) 
			{ 
				region += collRegion[k].text.replace(/'/g, "''")+";"; 
			}
			
			if (!visitor("INSERT INTO TM_DLPFilterTemplate"+computerName+" (CFG_INDEX, DLP_TEMPLATE_NAME, DLP_TEMPLATE_BUILTIN, " +
				"DLP_TEMPLATE_DESCRIPTION, DLP_TEMPLATE_ELEMENT, DLP_TEMPLATE_INDUSTRY, DLP_TEMPLATE_REGION) VALUES ('SMEX_PLC_NULL:" + 
				cfgIndex + "', " + uniPref + "'" + displayName + "', " + builtin + ", " + uniPref + "'" + desc + "', '" + 
				content + "', '"+ industry + "', '"+ region + "')", true))
				return;
			
			allDefCfgIndexes += "TM_DLPFilterTemplate:" + cfgIndex + ":";
		}
		
		visitor("UPDATE TM_DLPTemplateManagement"+computerName+" SET DLP_TEMPLATE_LIST_CFGSETTING_MV='" + allDefCfgIndexes + 
			"' WHERE CFG_INDEX='SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_TEMPLATE_MANAGEMENT_DEFAULT'", true);
		visitor("UPDATE TM_DLPTemplateManagement"+computerName+" SET DLP_TEMPLATE_LIST_CFGSETTING_MV='" + allDefCfgIndexes + 
			allUsrCfgIndexes + "' WHERE CFG_INDEX='SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_TEMPLATE_MANAGEMENT'", true);
		
		if (cn != null)
		{
			// update built-in template id in policy table
			var tmplId = this.GetDLPTemplateIdMap();
			var nameMap = this.GetDLPRuleNameMap();
			rs = cn.Execute("SELECT CFG_INDEX,DLP_TEMPLATE_LIST_CFGSETTING_REF,DLP_RULE_NAME FROM TM_DLPFilterRule"+computerName);
	        while (!rs.EOF)
	        {
	        	var cfgIndex = rs(0).Value;
	        	var slist = rs(1).Value;
	        	if (slist.length > 0)
	        	{
		        	for (var i=0; i<tmplId.length; ++i)
		        	{
		        		var re = new RegExp(tmplId[i].oldId, "");
		        		slist = slist.replace(re, tmplId[i].newId);
		        	}
		        }
				var ruleName = rs(2).Value;
				if (ruleName.length > 0)
	        	{
		        	for (var i=0; i<nameMap.length; ++i)
		        	{
		        		ruleName = ruleName.replace(nameMap[i].oldId, nameMap[i].newId);
		        	}
		        }
				
	        	arrSql.push("UPDATE TM_DLPFilterRule"+computerName+" SET DLP_TEMPLATE_LIST_CFGSETTING_REF='" + slist + "', DLP_RULE_NAME ='" + ruleName + "' WHERE CFG_INDEX='" + cfgIndex + "'");
	        	rs.MoveNext();
	        }
	        rs.Close();
	        
	        for (var i=0; i<arrSql.length; ++i)
				visitor(arrSql[i]);
		}
		
		WScript.Echo("Leave GetDLPTemplateInstallScripts");
	}
	
	this.GetDigitalAssetMap = function()
	{
		var arrMap = new Array();
		var daMapFile = sWorkingDirectory + "\\cfg_dlp_da_map.txt";
		var fso = new ActiveXObject("Scripting.FileSystemObject");
		var f = fso.OpenTextFile(daMapFile, 1, false);
		while (!f.AtEndOfStream)
		{
			var s = f.ReadLine();
			if (s.length > 0)
			{
				if (s.charAt(0) != "#")
				{
					var tabIndex = s.indexOf("\t");
					if (tabIndex > 0)
					{
						var left = s.substring(0, tabIndex);
						var right = s.substr(tabIndex+1);
						arrMap.push(new IDMap(trim(left), trim(right)));
					}
				}
			}
		}
		f.Close();
		
		return arrMap;
	}
	
	this.GetDLPRuleNameMap = function()
	{
		var arr = [
		    new IDMap("DATA PROTECTION (GLBA)","Data Loss Prevention (GLBA)"),
			new IDMap("DATA PROTECTION (HIPAA)","Data Loss Prevention (HIPAA)"),
			new IDMap("DATA PROTECTION (PCI-DSS)","Data Loss Prevention (PCI-DSS)"),
			new IDMap("DATA PROTECTION (SB-1386)","Data Loss Prevention (SB-1386)"),
			new IDMap("DATA PROTECTION (US PII)","Data Loss Prevention (US PII)")
		];
		return arr;
	}
	
	this.GetDLPTemplateIdMap = function()
	{
		var arr = [
			new IDMap("F084907F-B35F-41ff-BD8E-DD174C69A5EE", "00000000-0000-0000-0004-000000000001"), //"glba"
			new IDMap("FE5D56B7-C127-4e1c-99F5-169622459EF9", "00000000-0000-0000-0004-000000000002"), //"hipaa"
			new IDMap("27EABD79-6D9D-440b-8681-5AB21B486645", "00000000-0000-0000-0004-000000000003"), //"pcidss"
			new IDMap("495F6370-8F6B-4ff2-9D18-6EF2DF8FD67E", "00000000-0000-0000-0004-000000000004"), //"sb1386"
			new IDMap("210566AE-D693-4f81-8416-EFF2A48FDA8C", "00000000-0000-0000-0004-000000000005"), //"uspii"
			new IDMap("E155E535-EF13-4dad-99F3-ED9E22CAEF9C", "00000000-0000-0000-0004-000000000048"), //"source_code"
			
			new IDMap("16F4538D-9CD8-43bf-8DCF-3D485EB56D52", "00000000-0000-0000-0004-000000000100"), //"jp_pi_100"
			new IDMap("525B0E99-C090-4496-B67E-62C93107EB2A", "00000000-0000-0000-0004-000000000099"), //"jp_pi_10"
			new IDMap("18FF6835-4EED-4c38-AB9B-835F86135FC0", "00000000-0000-0000-0004-000000000101"), //"jp_pi_50"
			new IDMap("D6CF7EBA-FE92-44f7-AB9A-7BC6908A7FAD", "00000000-0000-0000-0004-000000000097"), //"jp_pi_obk50"
			new IDMap("E58DBD06-99FD-4219-BF57-06C4F6EDD6BF", "00000000-0000-0000-0004-000000000098"), //"jp_pi_h50"
			new IDMap("B9DEA4EF-1C9F-4a6b-A222-395CAB45173B", "00000000-0000-0000-0004-000000000102") //"jp_pi_k50"
		];
		return arr;
	}
}
///////////////////////////////////////////////////////////////////////////////////////////////////
function XDoc()
{
    var oXmlDoc = null;
    if (oXmlDoc == null) { try { oXmlDoc = new ActiveXObject("MSXML2.DOMDocument.6.0"); 
        oXmlDoc.setProperty("ProhibitDTD", false);    // MSXML 6 
	    oXmlDoc.setProperty("UseInlineSchema", true); // MSXML 6 
	    oXmlDoc.setProperty("AllowXsltScript", true); 
        oXmlDoc.setProperty("AllowDocumentFunction", true); } catch(e) {} }
    if (oXmlDoc == null) { try { oXmlDoc = new ActiveXObject("MSXML2.DOMDocument.4.0"); } catch(e) {} }
    if (oXmlDoc == null) { try { oXmlDoc = new ActiveXObject("MSXML2.DOMDocument.3.0"); } catch(e) {} }
    if (oXmlDoc == null) throw "unable to create a MSXML instance";
    oXmlDoc.validateOnParse = false;
    oXmlDoc.resolveExternals = true;
    return oXmlDoc;
}
///////////////////////////////////////////////////////////////////////////////////////////////////
function Log(enable)
{
    this.Write = function ()
    {
        for (i = 0; i != arguments.length; ++i)
            WriteImp(arguments[i]);
        WriteImp("\n");
    }
    this.WriteFormat = function(fmtString)
    {
        var strFormated = new String(fmtString);
        for (i = 1; i < arguments.length; ++i)
            strFormated = strFormated.replace("%" + i + "%", arguments[i]);
        WriteImp(strFormated);
        WriteImp("\n");
    }
    function WriteImp(item)
    {
        if (enable)
            WScript.Echo(item);
    }
}

