dv21_load/JDLGen.cs - main - developer.bami/DFM

dv21_load/JDLGen.cs
563 строки19 KB
Michael
add int8
09 апр 2025, 14:40
09 апр 2025, 14:405e001b6
using dv21_util;
using dv21_xsd;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Reflection;
using System.Runtime.InteropServices;
using System.Text;
using System.Windows.Forms;
using System.Xml;
using System.Xml.Schema;
using System.IO;


namespace dv21
{
    public class JDLGen
    {
        private StringBuilder sb;
        private StringBuilder i18n_en;
        private StringBuilder i18n_ru;
        private StringBuilder fk;
        private StringBuilder enums;
        private StringBuilder result;
        private StringBuilder mnu;

        private dv21.CardDefinition mcd;
        public dv21.CardDefinition cd
        {
            get
            {
                return mcd;
            }
            set
            {
                mcd = value;
            }
        }

        public JDLGen()
        {
            mcd = null;
            sb = new StringBuilder();
            fk = new StringBuilder();
            enums = new StringBuilder();
            result = new StringBuilder();
            i18n_ru = new StringBuilder();
            i18n_en = new StringBuilder();

        }


        


        private string MapBaseType(string dv21Type)
        {
            switch (dv21Type)
            {
                case "int":
                    return "Integer";

                case "int8":
                    return "Integer";

                case "bool":
                    return "Boolean";

                case "datetime":
                    return "LocalDate";

                case "enum":
                    return "Enum";

                case "bitmask":
                    return "AnyBlob";

                case "uniqueid":
                    return "UUID";

                case "userid":
                    return "Integer";

                case "string":
                    return "String";

                case "text":
                    return "String";


                case "unistring":
                    return "String";

                case "fileid":
                    return "TextBlob";

                case "json":
                    return "TextBlob";

                case "image":
                    return "ImageBlob";


                case "float":
                    return "Float";

                case "double":
                    return "Double";

                case "refid":
                    return "Integer";


            }
            return "Integer";  /*  " + dv21Type +" */

        }

        private void MakeSectionType(dv21.SectionType s, dv21.SectionType s_parent)
        {


            string idType = MapBaseType( MyUtils.GetIDType(s) );

            sb.AppendLine(" // " + MyUtils.C1(s.Alias));

            sb.AppendLine(" /* " + s.Name[0].Value + " */");

            sb.AppendLine("entity  " + MyUtils.C1(s.Alias) + "{");

            

            foreach (var nn in s.Name)
            {
                if(nn.Language=="ru")
                    i18n_ru.AppendLine(MyUtils.C1(s.Alias) + "="+ nn.Value);
                if (nn.Language == "en")
                    i18n_en.AppendLine(MyUtils.C1(s.Alias) + "=" + nn.Value);
            }

            i18n_ru.AppendLine(MyUtils.C1(s.Alias) + ".Id" + "=поле - ключ");


            if (s_parent != null)
            {
                sb.AppendLine("/* " + MyUtils.C1(s_parent.Alias) + "id - ' ссылка на родительскую таблицу " + s_parent.Name[0].Value + "' */");
                sb.AppendLine("/* \t\t" + MyUtils.C1(s_parent.Alias) + "Id " + idType +" required */");


                i18n_ru.AppendLine(MyUtils.C1(s.Alias) + "." + MyUtils.C1(s_parent.Alias) + "Id=ссылка на родительскую таблицу");
                


                fk.AppendLine("relationship OneToMany {");
                fk.AppendLine(MyUtils.C1(s_parent.Alias) + " to " + MyUtils.C1(s.Alias)+ "{ " + MyUtils.C1(s_parent.Alias) + "Id} " );
                fk.AppendLine("}");

            }

            int i;
            if (s.Field != null)
            {
                for (i = 0; i < s.Field.Length; i++)
                {
                    string pgtype = MapBaseType(s.Field[i].Type.ToString());
                    sb.AppendLine("/* " +  MyUtils.C1(s.Field[i].Alias) + " - '" + s.Field[i].Name[0].Value + "' */");


                    foreach (var nn in s.Field[i].Name)
                    {
                         if (nn.Language == "ru")
                            i18n_ru.AppendLine(MyUtils.C1(s.Alias) + "." + MyUtils.C1(s.Field[i].Alias) + "="  + nn.Value);
                        if (nn.Language == "en")
                            i18n_en.AppendLine(MyUtils.C1(s.Alias) + "." + MyUtils.C1(s.Field[i].Alias) + "="  + nn.Value);
                    }



                    if (s.Field[i].Enum != null && s.Field[i].Enum.Length > 0)
                    {
                        enums.AppendLine("enum " + MyUtils.C1(s.Field[i].Alias) + "Enum {");

                        int f;
                        for (f = 0; f < s.Field[i].Enum.Length; f++)
                        {
                        
                            enums.AppendLine(MyUtils.C1(s.Field[i].Alias) + s.Field[i].Enum[f].Value.ToString() +" (\"" + s.Field[i].Enum[f].Name +"\" )" ); 
                        }
                        enums.AppendLine("}");


                        if (s.Field[i].NotNull)
                            sb.AppendLine("\t\t" + MyUtils.C1(s.Field[i].Alias) + " " + MyUtils.C1(s.Field[i].Alias) + "Enum required");
                        else
                            sb.AppendLine("\t\t" + MyUtils.C1(s.Field[i].Alias) + " " + MyUtils.C1(s.Field[i].Alias) + "Enum ");

                    }
                    else if (s.Field[i].Reference)
                    {
                        CardDefinition refType = null;
                        SectionType refSection = null;
                        string refSchema = "";

                        refType = MyUtils.GetReferencedType(cd, s.Field[i].RefType);
                        if (refType != null)
                            refSection = MyUtils.GetReferencedSection(refType.Sections, s.Field[i].RefSection);

                        if (refSection != null)
                        {
                            refSchema = refType.Schema.ToLower() + ".";

                            if (s.Field[i].NotNull)
                                sb.AppendLine("/* \t\t" + MyUtils.C1(s.Field[i].Alias) + " " + pgtype + " required */");
                            else
                                sb.AppendLine("/* \t\t" + MyUtils.C1(s.Field[i].Alias) + " " + pgtype +"*/");

                            string BriefField = MyUtils.GetSectionBrief(refSection);

                            fk.AppendLine("relationship OneToMany {");
                            if(BriefField == "")
                                fk.AppendLine(MyUtils.C1(refSection.Alias) + " to " + MyUtils.C1(s.Alias) + " { " + MyUtils.C1(s.Field[i].Alias) + "} ");
                            else
                                fk.AppendLine(MyUtils.C1(refSection.Alias) + " to " + MyUtils.C1(s.Alias) + " { " + MyUtils.C1(s.Field[i].Alias) +"(" + MyUtils.C1(BriefField) + ") } ");
                            fk.AppendLine("}");
                        }
                        else
                        {
                            // не удалось разрезолвить - значит просто поле
                            if (s.Field[i].NotNull)
                            {
                                if (s.Field[i].UseforPK)
                                    sb.AppendLine("\t\t@id");
                                sb.AppendLine("\t\t" + MyUtils.C1(s.Field[i].Alias) + " " + pgtype + " required ");
                            }
                            else
                                sb.AppendLine("\t\t" + MyUtils.C1(s.Field[i].Alias) + " " + pgtype + "");
                        }

                        

                    }
                    else if (s.Field[i].MaxSpecified)
                    {
                        if (s.Field[i].NotNull)
                        {
                            if (s.Field[i].UseforPK)
                                sb.AppendLine("\t\t@id");
                            sb.AppendLine("\t\t" + MyUtils.C1(s.Field[i].Alias) + " " + pgtype + " maxlength(" + s.Field[i].Max.ToString() + ") required");
                        }
                        else
                            sb.AppendLine("\t\t" + MyUtils.C1(s.Field[i].Alias) + " " + pgtype + " maxlength(" + s.Field[i].Max.ToString() + ")");
                    }
                    else
                    {
                        if (s.Field[i].NotNull)
                        {
                            if (s.Field[i].UseforPK)
                                sb.AppendLine("\t\t@id");
                            sb.AppendLine("\t\t" + MyUtils.C1(s.Field[i].Alias) + " " + pgtype + " required ");
                        }
                        else
                            sb.AppendLine("\t\t" + MyUtils.C1(s.Field[i].Alias) + " " + pgtype + "");
                    }
                }

            }


            if (s.Type == dv21.SectionTypeType.tree)
            {
                sb.AppendLine("/* \t\t" + MyUtils.C1(s.Alias) + "_parent " + idType +" */");
                i18n_ru.AppendLine(MyUtils.C1(s.Alias) + "." + MyUtils.C1(s.Alias) + "_parent=родитель в деореве");

                fk.AppendLine("relationship OneToMany {");
                fk.AppendLine(MyUtils.C1(s.Alias) + " to " + MyUtils.C1(s.Alias) + " { " + MyUtils.C1(s.Alias) + "Parent } ");
                fk.AppendLine("}");
            }



            if (s.AddHistory)
            {
                sb.AppendLine("\t\t"+ MyUtils.C1("Effective_date_start") +" LocalDate");
                i18n_ru.AppendLine(MyUtils.C1(s.Alias) + "." + MyUtils.C1("Effective_date_start") + "=Дата начала действия");
                sb.AppendLine("\t\t"+ MyUtils.C1("Effective_date_end") +  " LocalDate");
                i18n_ru.AppendLine(MyUtils.C1(s.Alias) + "." + MyUtils.C1("Effective_date_end") + "=Дата завершения действия");

            }

            if (s.AddWhoInfo)
            {
                sb.AppendLine("\t\t"+ MyUtils.C1("Created_ts") + " LocalDate");
                sb.AppendLine("\t\t"+ MyUtils.C1("Created_by") + " String maxlength(64)");
                sb.AppendLine("\t\t"+ MyUtils.C1("Modified_ts") + " LocalDate");
                sb.AppendLine("\t\t" + MyUtils.C1("Modified_by ") +" String maxlength(64)");

                i18n_ru.AppendLine(MyUtils.C1(s.Alias) + "." + MyUtils.C1("Created_ts") + "=Дата создания");
                i18n_ru.AppendLine(MyUtils.C1(s.Alias) + "." + MyUtils.C1("Created_by") + "=Кем создано");
                i18n_ru.AppendLine(MyUtils.C1(s.Alias) + "." + MyUtils.C1("Modified_ts") + "=Дата изменения");
                i18n_ru.AppendLine(MyUtils.C1(s.Alias) + "." + MyUtils.C1("Modified_by") + "=Кем изменено");

            }


            sb.AppendLine("}"); // end of create table

            
            if (s.Section != null && s.Section.Length > 0)
            {

                for (i = 0; i < s.Section.Length; i++)
                {
                    MakeSectionType(s.Section[i], s);

                }
            }
            



            sb.AppendLine("");




        }

       
        public string Generate()
        {

            


            result.AppendLine("application {");
            result.AppendLine("  config {");
            result.AppendLine("     baseName " + MyUtils.C1(cd.Alias));
            result.AppendLine("     applicationType monolitic");
            result.AppendLine("	    authenticationType jwt");
            result.AppendLine("     serverPort 8080");
            result.AppendLine("	    buildTool 	maven");
            result.AppendLine("	    databaseType 	sql");
            result.AppendLine("	    prodDatabaseType   postgresql");        
            result.AppendLine("	    devDatabaseType 	postgresql");
            result.AppendLine("	    clientFramework 	angularX");
            //result.AppendLine("	    serviceDiscoveryType eureka");
            result.AppendLine("	    languages [ru,en]");
            result.AppendLine("	    packageName com.bami." + cd.Schema.ToLower() + "." + cd.Alias.ToLower());
            result.AppendLine("  }");
            result.AppendLine("  entities * ");
            result.AppendLine("}");




            GenerateOne();
            result.AppendLine(enums.ToString());
            result.AppendLine(sb.ToString());
            result.AppendLine(fk.ToString());

            if (i18n_ru.ToString() != "")
            {
                result.AppendLine("");
                result.AppendLine("/* локализация ru ");

                result.AppendLine(i18n_ru.ToString());

                result.AppendLine(" */ ");
            }

            if (i18n_en.ToString() != ""){
                result.AppendLine("");
                result.AppendLine("/* localization en ");

                result.AppendLine(i18n_en.ToString());

                result.AppendLine(" */ ");
            }

            return result.ToString();
        }


        public void GenerateOne()
        {

            int i;

            for (i = 0; i < cd.Sections.Length; i++)
            {
                MakeSectionType(cd.Sections[i], null);
            }
            
        }



        public string GenerateAll()
        {

            result.AppendLine("application {");
            result.AppendLine("  config {");
            result.AppendLine("     baseName FullApp" );
            result.AppendLine("     applicationType monolitic");
            result.AppendLine("	    authenticationType jwt");
            result.AppendLine("     serverPort 8080");
            result.AppendLine("	    buildTool 	maven");
            result.AppendLine("	    databaseType 	sql");
            result.AppendLine("	    prodDatabaseType   postgresql");
            result.AppendLine("	    devDatabaseType 	postgresql");
            result.AppendLine("	    clientFramework 	angularX");
            //result.AppendLine("	    serviceDiscoveryType eureka");
            result.AppendLine("	    languages [ru,en]");
            result.AppendLine("	    packageName com.bami.full.app");
            result.AppendLine("  }");
            result.AppendLine("  entities * ");
            result.AppendLine("}");



          
            CardDefinition refCD;
          
            int i;
            for (i = 0; i < MyUtils.cards.Count; i++)
            {
                refCD = null;
                try
                {
                    refCD = MyUtils.cards[i];
                }
                catch { }
                if (refCD != null)
                {
                    cd = refCD;
                    GenerateOne();
                }
            }
            result.AppendLine(enums.ToString());
            result.AppendLine(sb.ToString());
            result.AppendLine(fk.ToString());

            if (i18n_ru.ToString() != "")
            {
                result.AppendLine("");
                result.AppendLine("/* локализация ru ");

                result.AppendLine(i18n_ru.ToString());

                result.AppendLine(" */ ");
            }

            if (i18n_en.ToString() != "")
            {
                result.AppendLine("");
                result.AppendLine("/* localization en ");

                result.AppendLine(i18n_en.ToString());

                result.AppendLine(" */ ");
            }


            return result.ToString();
        }

        
        public void GenerateAlli18n(String app, string path) {

            mnu = new StringBuilder();

            CardDefinition refCD;

            int i;
            for (i = 0; i < MyUtils.cards.Count; i++)
            {
                refCD = null;
                try
                {
                    refCD = MyUtils.cards[i];
                }
                catch { }
               
                if (refCD != null)
                {
                    cd = refCD;
                    int j;

                    for (j = 0; j < cd.Sections.Length; j++)
                    {
                        Makei18n(cd.Sections[j], app, path);
                    }

                }
            }

            File.WriteAllText(path + "\\_global.json", mnu.ToString());
        }

        public void Makei18n(dv21.SectionType s, String app, String path)
        {
            StringBuilder t = new StringBuilder();
            t.AppendLine("{");
            t.AppendLine("  \"%App%\": {");
            t.AppendLine("    \"%alias%\": {");
            t.AppendLine("      \"home\": {");
            t.AppendLine("        \"title\": \"%table%\",");
            t.AppendLine("        \"refreshListLabel\": \"Обновить список\",");
            t.AppendLine("        \"createLabel\": \"Создать новый %table%\",");
            t.AppendLine("        \"createOrEditLabel\": \"Создать или отредактировать %table%\",");
            t.AppendLine("        \"notFound\": \"%table% не найдено\"");
            t.AppendLine("      },");
            t.AppendLine("      \"created\": \"Новый %table% создан с идентификатором {{ param }}\",");
            t.AppendLine("      \"updated\": \"%table% обновлен с идентификатором {{ param }}\",");
            t.AppendLine("      \"deleted\": \"%table% удален с идентификатором {{ param }}\",");
            t.AppendLine("      \"delete\": {");
            t.AppendLine("        \"question\": \"Вы уверены что хотите удалить %table% {{ id }}?\"");
            t.AppendLine("      },");
            t.AppendLine("      \"detail\": {");
            t.AppendLine("        \"title\": \"%table%\"");
            t.AppendLine("      },");
            t.AppendLine("      \"id\": \"ID\"");

            int i;
            if (s.Field != null)
            {
                for (i = 0; i < s.Field.Length; i++)
                {
                    t.AppendLine("      ,\"" + MyUtils.C2(s.Field[i].Alias ) + "\": \"" + s.Field[i].Name[0].Value + "\"");
                }
            }

            t.AppendLine("    }");
            t.AppendLine("  }");
            t.AppendLine("}");

            string sOut;
            sOut = t.ToString();
            sOut = sOut.Replace("%App%", app);
            sOut = sOut.Replace("%alias%", MyUtils.C2(s.Alias));
            sOut = sOut.Replace("%table%", s.Name[0].Value);

            File.WriteAllText(path + "\\" + MyUtils.C2(s.Alias) + ".json",sOut);


            mnu.AppendLine("\"" + MyUtils.C2(s.Alias) + "\":\"" + s.Name[0].Value + "\",");


            if (s.Section != null && s.Section.Length > 0)
            {

                for (i = 0; i < s.Section.Length; i++)
                {
                    Makei18n(s.Section[i], app, path);

                }
            }

        }

    }
}