✨ qualified biographical note - models

1 files changed, 78 insertions, 0 deletions

diff --git a/ishtar_common/migrations/0274_qualifiedbiographicalnote.py b/ishtar_common/migrations/0274_qualifiedbiographicalnote.py
new file mode 100644
index 000000000..4713937cc
--- /dev/null
+++ b/ishtar_common/migrations/0274_qualifiedbiographicalnote.py
@@ -0,0 +1,78 @@
+# Generated by Django 4.2.19 on 2026-03-24 15:39
+
+from django.conf import settings
+import django.contrib.postgres.search
+import django.core.validators
+from django.db import migrations, models
+import django.db.models.deletion
+import django.utils.timezone
+import ishtar_common.models
+import ishtar_common.models_common
+import re
+import uuid
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
+        ('ishtar_common', '0273_searchcache'),
+    ]
+
+    operations = [
+        migrations.AlterField(
+            model_name='documenttemplate',
+            name='export_format',
+            field=models.CharField(blank=True, choices=[('docx', 'DOCX'), ('html', 'HTML'), ('pdf', 'PDF'), ('xlsx', 'XLSX')], default='', max_length=4, verbose_name='Export format'),
+        ),
+        migrations.CreateModel(
+            name='QualifiedBiographicalNoteType',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('label', models.TextField(verbose_name='Label')),
+                ('txt_idx', models.TextField(help_text='The slug is the standardized version of the name. It contains only lowercase letters, numbers and hyphens. Each slug must be unique.', unique=True, validators=[django.core.validators.RegexValidator(re.compile('^[-a-zA-Z0-9_]+\\Z'), 'Enter a valid “slug” consisting of letters, numbers, underscores or hyphens.', 'invalid')], verbose_name='Textual ID')),
+                ('comment', models.TextField(blank=True, default='', verbose_name='Comment')),
+                ('available', models.BooleanField(default=True, verbose_name='Available')),
+                ('order', models.IntegerField(default=1, verbose_name='Order')),
+                ('parent', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='ishtar_common.qualifiedbiographicalnotetype', verbose_name='Parent')),
+            ],
+            options={
+                'verbose_name': 'Qualification type',
+                'verbose_name_plural': 'Qualification types',
+                'ordering': ['order', 'label'],
+            },
+            bases=(ishtar_common.models_common.Cached, models.Model),
+        ),
+        migrations.CreateModel(
+            name='QualifiedBiographicalNote',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('search_vector', django.contrib.postgres.search.SearchVectorField(blank=True, help_text='Auto filled at save', null=True, verbose_name='Search vector')),
+                ('timestamp_geo', models.IntegerField(blank=True, null=True, verbose_name='Timestamp geo')),
+                ('timestamp_label', models.IntegerField(blank=True, null=True, verbose_name='Timestamp label')),
+                ('data', models.JSONField(blank=True, default=dict)),
+                ('last_modified', models.DateTimeField(blank=True, default=django.utils.timezone.now)),
+                ('created', models.DateTimeField(blank=True, default=django.utils.timezone.now)),
+                ('history_m2m', models.JSONField(blank=True, default=dict)),
+                ('need_update', models.BooleanField(default=False, verbose_name='Need update')),
+                ('locked', models.BooleanField(default=False, verbose_name='Item locked for edition')),
+                ('uuid', models.UUIDField(default=uuid.uuid4)),
+                ('cached_label', models.TextField(blank=True, db_index=True, default='', verbose_name='Cached name')),
+                ('biographical_note', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='qualified_biographicalnote', to='ishtar_common.biographicalnote', verbose_name='Biographical note')),
+                ('history_creator', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL, verbose_name='Creator')),
+                ('history_modifier', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL, verbose_name='Last editor')),
+                ('imports', models.ManyToManyField(blank=True, related_name='imported_%(app_label)s_%(class)s', to='ishtar_common.import', verbose_name='Created by imports')),
+                ('imports_updated', models.ManyToManyField(blank=True, related_name='import_updated_%(app_label)s_%(class)s', to='ishtar_common.import', verbose_name='Updated by imports')),
+                ('ishtar_users', models.ManyToManyField(blank=True, related_name='%(class)s_associated', to='ishtar_common.ishtaruser')),
+                ('lock_user', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL, verbose_name='Locked by')),
+                ('qualification_type', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='ishtar_common.qualifiedbiographicalnotetype', verbose_name='Qualification type')),
+            ],
+            options={
+                'verbose_name': 'Qualified biographical note',
+                'verbose_name_plural': 'Qualified biographical notes',
+                'ordering': ('qualification_type__order', 'biographical_note__denomination'),
+                'permissions': (('view_own_qualifiedbiographicalnote', 'Can view own Qualified biographical note'), ('change_own_qualifiedbiographicalnote', 'Can change own Qualified biographical note'), ('delete_own_qualifiedbiographicalnote', 'Can delete own Qualified biographical note')),
+            },
+            bases=(ishtar_common.models_common.StatisticItem, ishtar_common.models_common.TemplateItem, models.Model, ishtar_common.models_common.CachedGen, ishtar_common.models_common.FixAssociated, ishtar_common.models.ValueGetter, ishtar_common.models_common.MainItem),
+        ),
+    ]