import json
import os

import requests
import openpyxl
from tqdm import tqdm


def get_data():
    if not os.path.exists('images'):
        os.mkdir('images')
    book = openpyxl.Workbook()
    for sheet in book.worksheets:
        sheet.append(['Название', 'Описание', 'Идентификатор', 'Учредитель', 'Сокращенное название',
                      'Тип собственности', 'КОПУК', 'Тип по профилю', 'ОГРН', 'ИНН', 'Юр. адрес',
                      'Фактическое нахождение', 'Телефон', 'Email', 'Сайт', 'Руководитель', 'ОКПО',
                      'Путь до фотографий'])
    params = {
        'limit': '20000',
        'offset': '0',
    }
    r = requests.get('https://goskatalog.ru/muzfo-rest/rest/museums', params=params)
    data = r.json()
    museums = data.get('museums')
    for museum in museums[:100]:
        try:
            inn = okpo = ogrn = address = mail = number = website = actual_address = headmaster = own_type = '-'
            i = 1
            id = museum.get('id')
            url = f'https://goskatalog.ru/muzfo-rest/rest/museums/{id}'
            r = requests.get(url)
            data = r.json()
            title = data.get('name')  # название
            abbreviation = data.get('abbreviation')  # сокращенное название
            annotation = data.get('annotation')  # описание
            if annotation == None:
                annotation = '-'
            else:
                annotation = annotation.replace('\n', '').replace('\r', '').replace('\t', '').strip()
            founder = data.get('founder')  # основатель
            kopuk = data.get('code')  # копук
            unic_identifier = data.get('fullUin')  # уникальный идентификатор
            # with open('data2.json', 'w', encoding='utf-8') as file:
            #     json.dump(data, file, indent=4, ensure_ascii=False)

            identifiers = data.get('identifiers')
            for identifier in identifiers:
                name = identifier.get('type')
                value = identifier.get('value')
                if name == 'INN':
                    inn = value  # инн
                elif name == 'OKPO':
                    okpo = value  # окпо
                elif name == 'OGRN':
                    ogrn = value  # огрн

            contacts = data.get('contacts')
            for contact in contacts:
                value = contact.get('contactValue')
                if '@' in value:
                    mail = value
                elif '+7' in value:
                    number = value
                elif 'http' in value:
                    website = value
                elif 'ул' in value or 'д' in value:
                    if address != '-':
                        if value != address:
                            actual_address = value
                            continue
                    address = value

            if actual_address == '-':
                actual_address = address

            images = data.get('images')

            file_title = title.replace('\\', '.') \
                             .replace('"', '').replace('|', '').replace('*', 'x').replace(':', '') \
                             .replace('?', '.').replace('<', '').replace('>', '').replace('/', '.')\
                             .replace('\n', '')[:200]
            for image in images:
                code = image.get('code')
                id = image.get('id')
                image_url = f'https://goskatalog.ru/muzfo-imaginator/rest/images/public/350/{code}/{id}.jpg'
                r = requests.get(image_url)
                with open(f'images/{file_title}_{i}.jpg', 'wb') as file:
                    file.write(r.content)
                i += 1

            profile_type = data.get('types')[0].get('name')  # тип по профилю

            employees = data.get('employees')
            for employee in employees:
                if employee.get('roleId') == 1:
                    headmaster = employee.get('name')  # руководитель

            ownershipid = data.get('ownershipId')
            if ownershipid == 3:
                own_type = 'Муниципальная'
            elif ownershipid == 2:
                own_type = 'Субъекта РФ'
            elif ownershipid == 1:
                own_type = 'Федеральная'

            for sheet in book.worksheets:
                sheet.append([annotation])
        except Exception as e:
            print(e)
        finally:
            book.save('data.xlsx')


def main():
    get_data()


if __name__ == '__main__':
    main()