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;
        }
    }
}