import django.core.validators import django.db.models.deletion from decimal import Decimal from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name='Role', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=100, unique=True)), ('description', models.TextField(blank=True)), ('permissions', models.JSONField(default=dict)), ('is_active', models.BooleanField(default=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ], options={'ordering': ['name']}, ), migrations.CreateModel( name='ApprovalRequest', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('module', models.CharField(max_length=50)), ('action', models.CharField(max_length=100)), ('target_type', models.CharField(max_length=100)), ('target_id', models.PositiveIntegerField()), ('summary', models.CharField(max_length=300)), ('details', models.TextField(blank=True)), ('status', models.CharField(choices=[('pending', 'Pending'), ('approved', 'Approved'), ('rejected', 'Rejected')], default='pending', max_length=20)), ('approved_at', models.DateTimeField(blank=True, null=True)), ('rejected_at', models.DateTimeField(blank=True, null=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('approved_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='approval_requests_approved', to=settings.AUTH_USER_MODEL)), ('requested_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='approval_requests_made', to=settings.AUTH_USER_MODEL)), ], options={'ordering': ['-created_at']}, ), migrations.CreateModel( name='Client', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=200)), ('company_name', models.CharField(max_length=300)), ('email', models.EmailField(max_length=254)), ('phone', models.CharField(blank=True, max_length=50)), ('tin', models.CharField(blank=True, max_length=50)), ('address', models.TextField(blank=True)), ('credit_limit', models.DecimalField(blank=True, decimal_places=2, default=Decimal('0'), max_digits=15)), ('payment_terms_days', models.PositiveIntegerField(default=30)), ('status', models.CharField(choices=[('active', 'Active'), ('inactive', 'Inactive')], default='active', max_length=20)), ('notes', models.TextField(blank=True)), ('is_active', models.BooleanField(default=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('created_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='created_clients', to=settings.AUTH_USER_MODEL)), ], options={'ordering': ['-created_at']}, ), migrations.CreateModel( name='CompanyDocument', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=300)), ('description', models.TextField(blank=True)), ('file', models.FileField(upload_to='company_documents/%Y/%m/')), ('is_active', models.BooleanField(default=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('uploaded_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='uploaded_company_documents', to=settings.AUTH_USER_MODEL)), ], options={'ordering': ['-created_at']}, ), migrations.CreateModel( name='Project', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=300)), ('description', models.TextField(blank=True)), ('start_date', models.DateField()), ('end_date', models.DateField()), ('status', models.CharField(choices=[('planning', 'Planning'), ('active', 'Active'), ('on_hold', 'On Hold'), ('completed', 'Completed'), ('cancelled', 'Cancelled')], default='planning', max_length=20)), ('priority', models.CharField(choices=[('low', 'Low'), ('medium', 'Medium'), ('high', 'High'), ('urgent', 'Urgent')], default='medium', max_length=20)), ('team_size', models.PositiveIntegerField(default=1)), ('is_active', models.BooleanField(default=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('client', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='projects', to='task_management.client')), ('created_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='created_projects', to=settings.AUTH_USER_MODEL)), ('project_manager', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='managed_projects', to=settings.AUTH_USER_MODEL)), ('team_members', models.ManyToManyField(blank=True, related_name='team_projects', to=settings.AUTH_USER_MODEL)), ], options={'ordering': ['-created_at']}, ), migrations.CreateModel( name='DocumentRequest', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=300)), ('description', models.TextField(blank=True, help_text='Internal description')), ('preview_text', models.TextField(blank=True, help_text='Text shown to client in portal')), ('requires_signature', models.BooleanField(default=True)), ('deadline', models.DateField(blank=True, null=True)), ('status', models.CharField(choices=[('draft', 'Draft'), ('sent', 'Sent to Client'), ('viewed', 'Viewed'), ('signed', 'Signed'), ('expired', 'Expired')], default='draft', max_length=20)), ('file', models.FileField(blank=True, null=True, upload_to='documents/')), ('portal_visible', models.BooleanField(default=False, help_text='When True, this document appears on the client portal')), ('signed', models.BooleanField(default=False)), ('signed_by', models.CharField(blank=True, max_length=200)), ('signed_at', models.DateTimeField(blank=True, null=True)), ('signed_file', models.FileField(blank=True, help_text='Signed document uploaded by client', null=True, upload_to='signed_documents/')), ('is_active', models.BooleanField(default=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('created_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='created_doc_requests', to=settings.AUTH_USER_MODEL)), ('project', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='document_requests', to='task_management.project')), ], options={'ordering': ['-created_at']}, ), migrations.CreateModel( name='AssetRequest', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=300)), ('description', models.TextField(blank=True)), ('required', models.BooleanField(default=True)), ('deadline', models.DateField(blank=True, null=True)), ('status', models.CharField(choices=[('draft', 'Draft'), ('requested', 'Requested'), ('uploaded', 'Uploaded'), ('approved', 'Approved'), ('rejected', 'Rejected')], default='draft', max_length=20)), ('portal_visible', models.BooleanField(default=False, help_text='When True, this asset request appears on the client portal')), ('file', models.FileField(blank=True, null=True, upload_to='assets/')), ('file_name', models.CharField(blank=True, max_length=300)), ('uploaded_at', models.DateTimeField(blank=True, null=True)), ('is_active', models.BooleanField(default=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('created_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='created_asset_requests', to=settings.AUTH_USER_MODEL)), ('project', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='asset_requests', to='task_management.project')), ], options={'ordering': ['-created_at']}, ), migrations.CreateModel( name='ActivityLog', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('action', models.CharField(choices=[('created', 'Created'), ('updated', 'Updated'), ('deleted', 'Deleted'), ('commented', 'Commented'), ('signed', 'Signed'), ('uploaded', 'Uploaded'), ('moved', 'Moved'), ('assigned', 'Assigned')], max_length=20)), ('target_type', models.CharField(max_length=50)), ('target_id', models.PositiveIntegerField(blank=True, null=True)), ('target_title', models.CharField(max_length=300)), ('details', models.TextField(blank=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='activity_logs', to=settings.AUTH_USER_MODEL)), ('project', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='activity_logs', to='task_management.project')), ], options={'ordering': ['-created_at']}, ), migrations.CreateModel( name='StaffProfile', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('job_title', models.CharField(blank=True, max_length=200)), ('avatar_color', models.CharField(default='#3b82f6', max_length=7)), ('is_active', models.BooleanField(default=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('role', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='staff_members', to='task_management.role')), ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='staff_profile', to=settings.AUTH_USER_MODEL)), ], options={'ordering': ['user__first_name', 'user__last_name']}, ), migrations.CreateModel( name='SystemNotification', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('category', models.CharField(choices=[('task', 'Task'), ('document', 'Document'), ('asset', 'Asset'), ('approval', 'Approval'), ('system', 'System')], default='system', max_length=20)), ('title', models.CharField(max_length=200)), ('message', models.TextField(blank=True)), ('link', models.CharField(blank=True, max_length=300)), ('is_read', models.BooleanField(default=False)), ('created_at', models.DateTimeField(auto_now_add=True)), ('read_at', models.DateTimeField(blank=True, null=True)), ('recipient', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='system_notifications', to=settings.AUTH_USER_MODEL)), ], options={'ordering': ['-created_at']}, ), migrations.CreateModel( name='Task', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=300)), ('description', models.TextField(blank=True)), ('start_date', models.DateField(blank=True, null=True)), ('due_date', models.DateField(blank=True, null=True)), ('status', models.CharField(choices=[('backlog', 'Backlog'), ('todo', 'To Do'), ('in_progress', 'In Progress'), ('review', 'Review'), ('completed', 'Completed')], default='backlog', max_length=20)), ('priority', models.CharField(choices=[('low', 'Low'), ('medium', 'Medium'), ('high', 'High'), ('urgent', 'Urgent')], default='medium', max_length=20)), ('estimated_hours', models.DecimalField(decimal_places=1, default=0, max_digits=6, validators=[django.core.validators.MinValueValidator(0)])), ('progress_percentage', models.IntegerField(default=0, validators=[django.core.validators.MinValueValidator(0), django.core.validators.MaxValueValidator(100)])), ('order', models.IntegerField(default=0)), ('is_active', models.BooleanField(default=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('assigned_to', models.ManyToManyField(blank=True, related_name='assigned_tasks', to=settings.AUTH_USER_MODEL)), ('created_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='created_tasks', to=settings.AUTH_USER_MODEL)), ('project', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='tasks', to='task_management.project')), ], options={'ordering': ['order', '-priority', 'due_date']}, ), migrations.CreateModel( name='TaskComment', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('comment', models.TextField()), ('attachment', models.FileField(blank=True, null=True, upload_to='task_comments/')), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('task', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='comments', to='task_management.task')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='task_comments', to=settings.AUTH_USER_MODEL)), ], options={'ordering': ['-created_at']}, ), ]