namespace DevadminDAL.Query.ClientModule
{
    public static class ClientModuleQB
    {
        public const string GET_MODULE_CLIENTMODULE_SQL = @"
            SELECT DISTINCT
                m.MODULEID   AS ModuleId,
                m.MODULECODE AS ModuleCode,
                m.MODULENAME AS ModuleName
            FROM MCLIENTMODULE cm
            INNER JOIN MMODULE m          ON m.MODULEID   = cm.MODULEID
            INNER JOIN MMODULEVSMENU mvm  ON mvm.MODULEID = cm.MODULEID
            INNER JOIN MROLEVSMENU rvm    ON rvm.MENUID   = mvm.MENUID
            WHERE 1=1
            AND (@clientid   IS NULL OR cm.CLIENTID              = @clientid)
            AND (@modulecode IS NULL OR m.MODULECODE LIKE '%' + @modulecode + '%')
            AND (@modulename IS NULL OR m.MODULENAME LIKE '%' + @modulename + '%')
            AND (@roleid     IS NULL OR rvm.ROLEID               = @roleid)";

        public const string GET_MODULE_CLIENTMODULE_PG = @"
            SELECT DISTINCT
                m.MODULEID   AS ""ModuleId"",
                m.MODULECODE AS ""ModuleCode"",
                m.MODULENAME AS ""ModuleName""
            FROM MCLIENTMODULE cm
            INNER JOIN MMODULE m          ON m.MODULEID   = cm.MODULEID
            INNER JOIN MMODULEVSMENU mvm  ON mvm.MODULEID = cm.MODULEID
            INNER JOIN MROLEVSMENU rvm    ON rvm.MENUID   = mvm.MENUID
            WHERE 1=1
            AND (:clientid   IS NULL OR cm.CLIENTID              = :clientid)
            AND (:modulecode IS NULL OR m.MODULECODE LIKE '%' || :modulecode || '%')
            AND (:modulename IS NULL OR m.MODULENAME LIKE '%' || :modulename || '%')
            AND (:roleid     IS NULL OR rvm.ROLEID               = :roleid)";

        public const string GET_MODULE_CLIENTMODULE_ORACLE = @";";
        public const string GET_MODULE_CLIENTMODULE_MYSQL  = @";";

        public const string GET_ROLEVSMODULE_CLIENTMODULE_SQL = @"
            SELECT DISTINCT
                cm.MODULEID  AS ModuleId,
                m.MODULECODE AS ModuleCode,
                m.MODULENAME AS ModuleName
            FROM MCLIENTMODULE cm
            INNER JOIN MMODULE m ON m.MODULEID = cm.MODULEID
            WHERE 1=1
            AND (@clientid   IS NULL OR cm.CLIENTID              = @clientid)
            AND (@modulecode IS NULL OR m.MODULECODE LIKE '%' + @modulecode + '%')
            AND (@modulename IS NULL OR m.MODULENAME LIKE '%' + @modulename + '%')";

        public const string GET_ROLEVSMODULE_CLIENTMODULE_PG = @"
            SELECT DISTINCT
                cm.MODULEID  AS ""ModuleId"",
                m.MODULECODE AS ""ModuleCode"",
                m.MODULENAME AS ""ModuleName""
            FROM MCLIENTMODULE cm
            INNER JOIN MMODULE m ON m.MODULEID = cm.MODULEID
            WHERE 1=1
            AND (:clientid   IS NULL OR cm.CLIENTID              = :clientid)
            AND (:modulecode IS NULL OR m.MODULECODE LIKE '%' || :modulecode || '%')
            AND (:modulename IS NULL OR m.MODULENAME LIKE '%' || :modulename || '%')";

        public const string GET_ROLEVSMODULE_CLIENTMODULE_ORACLE = @";";
        public const string GET_ROLEVSMODULE_CLIENTMODULE_MYSQL  = @";";
    }
}