Daje-Plugin-Languages

 view release on metacpan or  search on metacpan

lib/Daje/Database/Languages.pm  view on Meta::CPAN

(
    languages_translations_pkey  SERIAL NOT NULL,
    editnum bigint NOT NULL DEFAULT 1,
    insby character varying COLLATE pg_catalog."default" NOT NULL DEFAULT 'System'::character varying,
    insdatetime timestamp without time zone NOT NULL DEFAULT now(),
    modby character varying COLLATE pg_catalog."default" NOT NULL DEFAULT 'System'::character varying,
    moddatetime timestamp without time zone NOT NULL DEFAULT now(),
            languages_lan_fkey BIGINT  NOT NULL, -- 
                    languages_translation_keys_fkey BIGINT  NOT NULL, -- 
                        translation  VARCHAR  NOT NULL , -- Translation to selected language
                        locked  BOOLEAN  NOT NULL DEFAULT false , -- Translation locked for automatic updates
                CONSTRAINT languages_translations_pkey PRIMARY KEY (languages_translations_pkey)
);
    
CREATE TABLE IF NOT EXISTS languages_lan -- 
(
    languages_lan_pkey  SERIAL NOT NULL,
    editnum bigint NOT NULL DEFAULT 1,
    insby character varying COLLATE pg_catalog."default" NOT NULL DEFAULT 'System'::character varying,
    insdatetime timestamp without time zone NOT NULL DEFAULT now(),
    modby character varying COLLATE pg_catalog."default" NOT NULL DEFAULT 'System'::character varying,

lib/Daje/Database/Languages.pm  view on Meta::CPAN

);
    

CREATE OR REPLACE VIEW v_languages_types AS  -- 
    SELECT languages_types_pkey, editnum, insby, insdatetime, modby, moddatetime, type
          FROM languages_types;
CREATE OR REPLACE VIEW v_languages_translations AS  -- 
    SELECT languages_translations_pkey, editnum, insby, insdatetime, modby, moddatetime,languages_lan_fkey,
     languages_translation_keys_fkey,
      translation,
      locked
          FROM languages_translations;
CREATE OR REPLACE VIEW v_languages_lan AS  -- 
    SELECT languages_lan_pkey, editnum, insby, insdatetime, modby, moddatetime, language,
      browser_code,
      iso_code
          FROM languages_lan;
CREATE OR REPLACE VIEW v_languages_translation_keys AS  -- 
    SELECT languages_translation_keys_pkey, editnum, insby, insdatetime, modby, moddatetime, plugin,
      field,
     languages_types_fkey,
      key,
      comment
          FROM languages_translation_keys;


CREATE OR REPLACE VIEW v_languages_types_list AS -- 
    SELECT languages_types_pkey, editnum, insby, insdatetime, modby, moddatetime, type     FROM languages_types;

CREATE OR REPLACE VIEW v_languages_translations_list AS -- 
    SELECT languages_translations_pkey, editnum, insby, insdatetime, modby, moddatetime,     (SELECT iso_code FROM languages_lan WHERE languages_lan_pkey = languages_lan_fkey) as languages_lan_iso_code,languages_lan_fkey,languages_translation_keys_fk...

CREATE OR REPLACE VIEW v_languages_lan_list AS -- 
    SELECT languages_lan_pkey, editnum, insby, insdatetime, modby, moddatetime, language, browser_code, iso_code     FROM languages_lan;

CREATE OR REPLACE VIEW v_languages_translation_keys_list AS -- 
    SELECT languages_translation_keys_pkey, editnum, insby, insdatetime, modby, moddatetime, plugin, field,     (SELECT type FROM languages_types WHERE languages_types_pkey = languages_types_fkey) as languages_types_type,languages_types_fkey, key, co...



-- Load a list of translations for a specific window, from plugin and key

lib/Daje/Database/Model/Super/LanguagesTranslations.pm  view on Meta::CPAN

# This file is generated automatically by Daje Tools 2026-02-25 11:52:03.
# It will be re-created by Daje Tools again and any changes
# will be over written.
#
# <!-- Autogenerated file 2026-02-25 11:52:03 -->

our $VERSION = '0.01';

has 'fields' => '"languages_translations_pkey", "editnum", "insby", "insdatetime", "modby", "moddatetime",
"languages_lan_fkey",
"languages_translation_keys_fkey","translation","locked"';
has 'primary_key_name' => "languages_translations_pkey";
has 'table_name' => "languages_translations"; # 
has 'mandatory' => 'languages_lan_fkey,languages_translation_keys_fkey,translation,locked,';
has 'workflow' => '';

async sub load_languages_lan_fkey_p($self, $languages_lan_fkey) {
    return $self->load_languages_lan_fkey($languages_lan_fkey);
}

sub load_languages_lan_fkey($self, $languages_lan_fkey) {
    return $self->load_fkey(
        $self->table_name, $self->fields(), "languages_lan_fkey", $languages_lan_fkey
    );

lib/Daje/Database/View/Super/vLanguagesTranslations.pm  view on Meta::CPAN

#

# This file is generated automatically by Daje Tools 2026-02-25 11:52:03.
# It will be re-created by Daje Tools again and any changes
# will be over written.
#
# <!-- Autogenerated file 2026-02-25 11:52:03 -->

our $VERSION = '0.01';

has 'fields' => '"languages_translations_pkey", "editnum", "insby", "insdatetime", "modby", "moddatetime","languages_lan_fkey","languages_translation_keys_fkey","translation","locked"';
has 'primary_key_name' => "languages_translations_pkey";
has 'table_name' => "v_languages_translations";


async sub load_languages_lan_fkey_p($self, $languages_lan_fkey) {
    return $self->load_languages_lan_fkey($languages_lan_fkey);
}

sub load_languages_lan_fkey($self, $languages_lan_fkey) {
    return $self->load_fkey(

lib/Daje/Database/View/Super/vLanguagesTranslationsList.pm  view on Meta::CPAN

# This file is generated automatically by Daje Tools 2026-02-25 11:52:03.
# It will be re-created by Daje Tools again and any changes
# will be over written.
#
# <!-- Autogenerated file 2026-02-25 11:52:03 -->

our $VERSION = '0.01';

has 'fields' => '"languages_translations_pkey", "editnum", "insby", "insdatetime", "modby", "moddatetime",languages_lan_iso_code,
"languages_lan_fkey",
"languages_translation_keys_fkey","translation","locked"';
has 'primary_key_name' => "languages_translations_pkey";
has 'table_name' => "v_languages_translations_list";

async sub load_all_languages_lan_list_p($self) {
    return $self->load_all_languages_lan_list();
}

sub load_all_languages_lan_list($self) {
    return $self->load_a_full_list(
        $self->table_name, $self->fields()

lib/Daje/Plugin/Languages/Languages.pm  view on Meta::CPAN

                key => 'translations',
                field => 'translation',
                type => 'Tool tips',
                translation => 'Translation to selected language',
                comment => 'Translation to selected language'
            };
         
          push @keys,  {
                plugin => 'languages',
                key => 'translations',
                field => 'locked',
                type => 'Label',
                translation => 'Locked',
                comment => 'Translation locked for automatic updates'
            };
           push @keys, {
                plugin => 'languages',
                key => 'translations',
                field => 'locked',
                type => 'Tool tips',
                translation => 'Translation locked for automatic updates',
                comment => 'Translation locked for automatic updates'
            };
         
        push @keys, {
                plugin => 'languages',
                key => 'lan',
                field => 'table',
                type => 'Label',
                translation => 'Language',
                comment => 'The supported languages',
            };