from django.db import models

# Create your models here.
from django.db import models


class role_table(models.Model):
    company_id = models.IntegerField(default=1)
    name = models.CharField(max_length=150, null=True)
    role_type = models.CharField(max_length=30, null=True)
    descriptions = models.CharField(max_length=150, null=True)
    status = models.IntegerField(default=1)
    branch_id = models.IntegerField(default=0)
    is_default = models.IntegerField(default=0)
    is_active = models.IntegerField(default=1)
    created_on = models.DateTimeField()
    updated_on = models.DateTimeField()
    created_by = models.IntegerField()
    updated_by = models.IntegerField()

    class Meta:
        db_table = "user_roles"

    def save(self, *args, **kwargs):
        if self.name:
            self.name = self.name.strip().title()       
        super(role_table, self).save(*args, **kwargs)




class module_table(models.Model):
    name = models.CharField(max_length=150, null=True)
    keyword = models.CharField(max_length=150, null=True)
    sort_order_no = models.IntegerField()
    is_admin = models.IntegerField(default=1)
    is_branch = models.IntegerField(default=0)
    is_wholesale = models.IntegerField(default=0)
    is_active = models.IntegerField(default=1)
    status = models.IntegerField(default=1)
    created_on = models.DateTimeField()
    updated_on = models.DateTimeField()
    created_by = models.IntegerField()
    updated_by = models.IntegerField()

    class Meta:
        db_table = "user_module"


class privilege_table(models.Model):
    role_id = models.IntegerField()
    module_id = models.IntegerField()
    is_create = models.IntegerField(default=0)
    is_read = models.IntegerField(default=0)
    is_update = models.IntegerField(default=0)
    is_delete = models.IntegerField(default=0)
    is_active = models.IntegerField(default=1)
    status = models.IntegerField(default=1)
    created_on = models.DateTimeField()
    updated_on = models.DateTimeField()
    created_by = models.IntegerField()
    updated_by = models.IntegerField()

    class Meta:
        db_table = "user_privilege"