I am going to build a site with multiple language support, and I need to have the ability to control the workflow of the articles, companies, products. All with multiple language support and multiple versioning. Does anyone have the solution for this already or I need to start from scratch?
我将构建一个具有多语言支持的站点,我需要能够控制文章,公司和产品的工作流程。全部具有多语言支持和多版本控制。有没有人已经有解决方案,或者我需要从头开始?
2 个解决方案
#1
Have you tried looking at the Database models at Database Answers ?
您是否尝试在Database Answers查看数据库模型?
Of course, you could use MS SharePoint.
当然,您可以使用MS SharePoint。
Have you looked at:
你看过了吗:
Joomla is an award-winning content management system (CMS), which enables you to build Web sites and powerful online applications. Many aspects, including its ease-of-use and extensibility, have made Joomla the most popular Web site software available. Best of all, Joomla is an open source solution that is freely available to everyone.
Joomla是一个屡获殊荣的内容管理系统(CMS),它使您能够构建网站和强大的在线应用程序。许多方面,包括易用性和可扩展性,使Joomla成为最受欢迎的网站软件。最重要的是,Joomla是一个免费提供给所有人的开源解决方案。
#2
As your question is very broad, I will attempt to give you an answer with a simple example. This can be extended to every entity you want to store. Let us assume you have an article entity.
Article (articleID, langID, ENUTitle, ENUContent, authorID)
由于您的问题非常广泛,我将尝试用一个简单的例子给您一个答案。这可以扩展到您要存储的每个实体。我们假设您有一个文章实体。文章(articleID,langID,ENUTitle,ENUContent,authorID)
By default you can store English language content in the main table. The same content or translated content can be stored in a separate language translation table.
默认情况下,您可以在主表中存储英语语言内容。相同的内容或翻译的内容可以存储在单独的语言翻译表中。
Article_Translation(ID, articleID, langID, langTitle, langContent)
Article_Translation(ID,articleID,langID,langTitle,langContent)
example of content
内容的例子
insert into article values ('art101','ENU','New Website for Developers','* is new and useful','BKM')
Insert into article_translation (1023, 'art101','FRA','nouveau site Web pour les développeurs','* est nouveau et utile','BKM')
Insert into article_translation (1024, 'art101','SPA','nuevo sitio web para desarrolladores','* es nuevo y útil','BKM')
Depending on your user language preference, content can either be displayed from article table or article translation table
根据您的用户语言首选项,可以从文章表或文章转换表中显示内容
In general, for every entity that needs translation, you will need a main table and language translation table.
通常,对于需要翻译的每个实体,您都需要一个主表和语言转换表。
#1
Have you tried looking at the Database models at Database Answers ?
您是否尝试在Database Answers查看数据库模型?
Of course, you could use MS SharePoint.
当然,您可以使用MS SharePoint。
Have you looked at:
你看过了吗:
Joomla is an award-winning content management system (CMS), which enables you to build Web sites and powerful online applications. Many aspects, including its ease-of-use and extensibility, have made Joomla the most popular Web site software available. Best of all, Joomla is an open source solution that is freely available to everyone.
Joomla是一个屡获殊荣的内容管理系统(CMS),它使您能够构建网站和强大的在线应用程序。许多方面,包括易用性和可扩展性,使Joomla成为最受欢迎的网站软件。最重要的是,Joomla是一个免费提供给所有人的开源解决方案。
#2
As your question is very broad, I will attempt to give you an answer with a simple example. This can be extended to every entity you want to store. Let us assume you have an article entity.
Article (articleID, langID, ENUTitle, ENUContent, authorID)
由于您的问题非常广泛,我将尝试用一个简单的例子给您一个答案。这可以扩展到您要存储的每个实体。我们假设您有一个文章实体。文章(articleID,langID,ENUTitle,ENUContent,authorID)
By default you can store English language content in the main table. The same content or translated content can be stored in a separate language translation table.
默认情况下,您可以在主表中存储英语语言内容。相同的内容或翻译的内容可以存储在单独的语言翻译表中。
Article_Translation(ID, articleID, langID, langTitle, langContent)
Article_Translation(ID,articleID,langID,langTitle,langContent)
example of content
内容的例子
insert into article values ('art101','ENU','New Website for Developers','* is new and useful','BKM')
Insert into article_translation (1023, 'art101','FRA','nouveau site Web pour les développeurs','* est nouveau et utile','BKM')
Insert into article_translation (1024, 'art101','SPA','nuevo sitio web para desarrolladores','* es nuevo y útil','BKM')
Depending on your user language preference, content can either be displayed from article table or article translation table
根据您的用户语言首选项,可以从文章表或文章转换表中显示内容
In general, for every entity that needs translation, you will need a main table and language translation table.
通常,对于需要翻译的每个实体,您都需要一个主表和语言转换表。