# Generated by Django 5.0.6 on 2026-11-02 07:03

import Company.models
import django.db.models.deletion
import django.utils.timezone
from decimal import Decimal
from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Attendance_Status',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('last_run_date', models.DateField(blank=True, null=True)),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
            ],
        ),
        migrations.CreateModel(
            name='company_details',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('company_id', models.CharField(blank=True, db_index=True, default=Company.models.generate_company_id, max_length=8, unique=True)),
                ('email', models.EmailField(max_length=254, unique=True)),
                ('password', models.CharField(max_length=12)),
                ('contact_no', models.CharField(max_length=15, unique=True)),
                ('verification_code', models.CharField(blank=True, max_length=6, null=True)),
                ('is_verified', models.BooleanField(default=False)),
                ('status', models.BooleanField(db_index=True, default=False)),
                ('Attendance_camera', models.BooleanField(blank=True, default=False, null=True)),
                ('Company_logo', models.ImageField(blank=True, null=True, upload_to='company/logos/')),
                ('Company_address', models.TextField(blank=True, null=True)),
                ('Registered_Company_Name', models.CharField(blank=True, max_length=100, null=True)),
                ('Brand_Name', models.CharField(blank=True, max_length=100, null=True)),
                ('Company_Official_Email', models.EmailField(blank=True, max_length=254, null=True)),
                ('Company_Official_Contact', models.CharField(blank=True, max_length=15, null=True)),
                ('Website', models.CharField(blank=True, max_length=50, null=True)),
                ('Domain_Name', models.CharField(blank=True, max_length=50, null=True)),
                ('Industry_Type', models.CharField(blank=True, max_length=100, null=True)),
                ('REGISTERED_OFFICE_add', models.CharField(blank=True, max_length=500, null=True)),
                ('CORPORATE_OFFICE_add', models.CharField(blank=True, max_length=500, null=True)),
                ('CUSTOM_ADDRESS_TITLE_add', models.CharField(blank=True, max_length=500, null=True)),
                ('LIVE_ANNOUNCEMENTS', models.CharField(blank=True, max_length=1000, null=True)),
                ('COMPANY_POLICIES', models.CharField(blank=True, max_length=2000, null=True)),
                ('office_latitude', models.FloatField(blank=True, null=True)),
                ('office_longitude', models.FloatField(blank=True, null=True)),
                ('allowed_radius', models.IntegerField(default=200)),
                ('api_key', models.CharField(blank=True, max_length=64, null=True, unique=True)),
                ('company_status', models.CharField(choices=[('ACTIVE', 'Active'), ('INACTIVE', 'Inactive'), ('SUSPENDED', 'Suspended'), ('TRIAL', 'Trial'), ('EXPIRED', 'Expired')], db_index=True, default='TRIAL', max_length=20)),
                ('plan', models.CharField(choices=[('FREE', 'Free'), ('BASIC', 'Basic'), ('PRO', 'Professional'), ('ENTERPRISE', 'Enterprise')], db_index=True, default='FREE', max_length=20)),
                ('subscription_start_date', models.DateField(blank=True, null=True)),
                ('subscription_end_date', models.DateField(blank=True, null=True)),
                ('trial_start_date', models.DateField(blank=True, null=True)),
                ('trial_end_date', models.DateField(blank=True, null=True)),
                ('employee_limit', models.PositiveIntegerField(default=10)),
                ('admin_limit', models.PositiveIntegerField(default=1)),
                ('hr_limit', models.PositiveIntegerField(default=2)),
                ('device_limit', models.PositiveIntegerField(default=1)),
                ('allow_attendance', models.BooleanField(default=True)),
                ('allow_payroll', models.BooleanField(default=True)),
                ('allow_leave', models.BooleanField(default=True)),
                ('allow_expense', models.BooleanField(default=True)),
                ('allow_invoice', models.BooleanField(default=True)),
                ('allow_bank', models.BooleanField(default=True)),
                ('allow_ai', models.BooleanField(default=True)),
                ('allow_mobile_app', models.BooleanField(default=True)),
                ('allow_biometric', models.BooleanField(default=True)),
                ('allow_api', models.BooleanField(default=True)),
                ('created_by_superadmin', models.BooleanField(default=True)),
                ('notes', models.TextField(blank=True, null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
            ],
        ),
        migrations.CreateModel(
            name='Client',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('client_id', models.CharField(blank=True, default=Company.models.generate_client_id, max_length=8, unique=True)),
                ('Employee_ID', models.CharField(blank=True, max_length=100, null=True)),
                ('name', models.CharField(max_length=255)),
                ('email', models.EmailField(max_length=254, unique=True)),
                ('phone', models.CharField(blank=True, max_length=15, null=True)),
                ('address', models.TextField(blank=True, null=True)),
                ('gst_number', models.CharField(blank=True, max_length=15, null=True)),
                ('pan_number', models.CharField(blank=True, max_length=10, null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('bank_name', models.CharField(blank=True, max_length=255, null=True)),
                ('account_number', models.CharField(blank=True, max_length=20, null=True, unique=True)),
                ('ifsc_code', models.CharField(blank=True, max_length=11, null=True)),
                ('account_type', models.CharField(blank=True, choices=[('Saving', 'Saving'), ('Current', 'Current')], max_length=10, null=True)),
                ('is_active', models.BooleanField(default=True)),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='clients', to='Company.company_details')),
            ],
        ),
        migrations.CreateModel(
            name='BankTransaction',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('Employee_ID', models.CharField(blank=True, max_length=100, null=True)),
                ('transaction_type', models.CharField(choices=[('Credit', 'Credit'), ('Debit', 'Debit')], max_length=20)),
                ('amount', models.DecimalField(decimal_places=2, max_digits=10)),
                ('date', models.DateField(default=django.utils.timezone.now)),
                ('description', models.TextField(blank=True, null=True)),
                ('reference_number', models.CharField(blank=True, max_length=100, null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('client', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='bank_transactions', to='Company.client')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='bank_transactions', to='Company.company_details')),
            ],
        ),
        migrations.CreateModel(
            name='Expense',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('Employee_ID', models.CharField(blank=True, max_length=100, null=True)),
                ('title', models.CharField(max_length=255)),
                ('category', models.CharField(choices=[('Salary', 'Salary'), ('Office Supplies', 'Office Supplies'), ('Utilities', 'Utilities'), ('Marketing', 'Marketing'), ('Travel', 'Travel')], max_length=50)),
                ('amount', models.DecimalField(decimal_places=2, max_digits=10)),
                ('date', models.DateField(default=django.utils.timezone.now)),
                ('description', models.TextField(blank=True, null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='expenses', to='Company.company_details')),
            ],
        ),
        migrations.CreateModel(
            name='Invoice',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('Employee_ID', models.CharField(blank=True, max_length=100, null=True)),
                ('invoice_number', models.CharField(blank=True, max_length=20, null=True, unique=True)),
                ('amount', models.DecimalField(decimal_places=2, max_digits=10)),
                ('due_date', models.DateField()),
                ('status', models.CharField(choices=[('Pending', 'Pending'), ('Paid', 'Paid')], default='Pending', max_length=20)),
                ('gst_percentage', models.DecimalField(blank=True, decimal_places=2, default=Decimal('0.00'), max_digits=5, null=True)),
                ('tds_percentage', models.DecimalField(blank=True, decimal_places=2, default=Decimal('0.00'), max_digits=5, null=True)),
                ('gst_amount', models.DecimalField(blank=True, decimal_places=2, default=Decimal('0.00'), max_digits=10, null=True)),
                ('tds_amount', models.DecimalField(blank=True, decimal_places=2, default=Decimal('0.00'), max_digits=10, null=True)),
                ('total_tax', models.DecimalField(blank=True, decimal_places=2, default=Decimal('0.00'), max_digits=10, null=True)),
                ('grand_total', models.DecimalField(blank=True, decimal_places=2, default=Decimal('0.00'), max_digits=10, null=True)),
                ('payment_transaction_created', models.BooleanField(default=False)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('client', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='invoices', to='Company.client')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='invoices', to='Company.company_details')),
            ],
        ),
        migrations.CreateModel(
            name='ProfitLoss',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('Employee_ID', models.CharField(blank=True, max_length=100, null=True)),
                ('month', models.CharField(max_length=50)),
                ('revenue', models.DecimalField(decimal_places=2, max_digits=12)),
                ('expenses', models.DecimalField(decimal_places=2, max_digits=12)),
                ('net_profit', models.DecimalField(decimal_places=2, max_digits=12)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='profit_loss_reports', to='Company.company_details')),
            ],
        ),
        migrations.CreateModel(
            name='AuthLog',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('actor_type', models.CharField(choices=[('SUPERADMIN', 'Super Admin'), ('COMPANY_ADMIN', 'Company Admin'), ('EMPLOYEE', 'Employee')], db_index=True, max_length=20)),
                ('identifier', models.CharField(blank=True, db_index=True, max_length=150, null=True)),
                ('actor_id', models.CharField(blank=True, db_index=True, max_length=100, null=True)),
                ('action', models.CharField(choices=[('LOGIN', 'Login'), ('LOGOUT', 'Logout')], db_index=True, max_length=10)),
                ('status', models.CharField(choices=[('SUCCESS', 'Success'), ('FAILED', 'Failed')], db_index=True, default='SUCCESS', max_length=10)),
                ('reason', models.CharField(blank=True, max_length=255, null=True)),
                ('ip_address', models.GenericIPAddressField(blank=True, null=True)),
                ('user_agent', models.CharField(blank=True, max_length=255, null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True, db_index=True)),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('company', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='auth_logs', to='Company.company_details')),
            ],
            options={
                'ordering': ['-created_at'],
                'indexes': [models.Index(fields=['actor_type', 'action', 'created_at'], name='Company_aut_actor_t_047225_idx'), models.Index(fields=['company', 'created_at'], name='Company_aut_company_58c35e_idx')],
            },
        ),
        migrations.CreateModel(
            name='Holiday',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=150)),
                ('date', models.DateField()),
                ('holiday_type', models.CharField(choices=[('National', 'National'), ('Regional', 'Regional'), ('Optional', 'Optional'), ('Company', 'Company'), ('National', 'National'), ('Festival', 'Festival')], default='Company', max_length=20)),
                ('description', models.TextField(blank=True, null=True)),
                ('is_active', models.BooleanField(default=True)),
                ('source', models.CharField(choices=[('manual', 'Manual'), ('automatic', 'Automatic')], db_index=True, default='manual', max_length=20)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='holidays', to='Company.company_details')),
            ],
            options={
                'ordering': ['date'],
                'indexes': [models.Index(fields=['company', 'date'], name='Company_hol_company_d56546_idx')],
                'unique_together': {('company', 'date', 'name')},
            },
        ),
    ]
