"""Add a 'Company LinkedIn' item under the Master Data sidebar group.

Run:  python add_company_linkedin_menu.py   (idempotent)
"""
import django, os, sys


def run():
    from apps.menus.models import Menu
    parent = Menu.objects.filter(name="Master Data", parent__isnull=True).first()
    if not parent:
        print("ERROR: 'Master Data' parent not found — run master-data seeders first.")
        sys.exit(1)
    last = parent.children.order_by("-sort_order").first()
    item, created = Menu.objects.get_or_create(
        name="Company LinkedIn", parent=parent,
        defaults={
            "route": "/master-data/company-linkedin", "icon": "fa-brands fa-linkedin",
            "sort_order": (last.sort_order + 1) if last else 1,
            "permission_code": "", "is_active": True, "admin_only": True,
        },
    )
    if not created:
        item.route = "/master-data/company-linkedin"; item.icon = "fa-brands fa-linkedin"
        item.is_active = True; item.admin_only = True; item.save()
    print(f"{'Created' if created else 'Updated'} 'Company LinkedIn' menu under Master Data.")


if __name__ == "__main__":
    sys.path.append(os.path.dirname(os.path.dirname(os.path.abspath(__file__))))
    os.environ.setdefault("DJANGO_SETTINGS_MODULE", "config.settings.dev")
    django.setup()
    run()