using System;
using System.Collections.Generic;
using System.Text;
using MercatorUi;
using MercatorApi;
namespace Crm
{
public class Customizer : MercatorUi.ICustomizers.IStringUpdater
{
public string StringUpdate(string ReqSql)
{
string id = Api.StrExtract(ReqSql, "<ID>", "</ID>");
if (id.StartsWith("CRMCALENDAR"))
{
return ReqSql.Replace("as owner,ACTTEMPL.color",
"as owner, case "
+ "when actions.MODULE = 'XLEAD' and actions.ID_SIG != '' and(select X_COLOR from xlead where xlead.X_ID = actions.ID_SIG) != '' "
+ "then (select X_COLOR from xlead where xlead.X_ID = actions.ID_SIG) "
+ "else ACTTEMPL.color end as COLOR");
}
else
return ReqSql;
}
}
}