---

DO $check$
DECLARE
    v_base varchar(255);
    v_cookies text;
    v_response bytea;
    v_text text;
BEGIN
    SELECT web_base
    INTO v_base
    FROM tools.settings
    LIMIT 1;

    v_cookies := robot.login_ex2(v_base, 'bb_robot');

    IF coalesce(v_cookies, '') = '' THEN
        RAISE EXCEPTION 'Не удалось авторизовать bb_robot';
    END IF;

    BEGIN
        v_response := robot.get_page_data(
            v_base,
            'queryModel?queryModelCode=J6JzujYq',
            v_cookies,
            json_build_object(
                'start_date_app', '',
                'end_date_app', '',
                'isChecked', true,
                'contract_activity_type', 'ALL'
            )
        );

        v_text := convert_from(v_response, 'UTF8');

        RAISE NOTICE 'Период: % — %',
            current_date - 1, current_date;

        RAISE NOTICE 'Начало ответа модели: %',
            left(v_text, 1000);
    EXCEPTION WHEN OTHERS THEN
        PERFORM robot.logout_ex(v_base, v_cookies);
        RAISE;
    END;

    PERFORM robot.logout_ex(v_base, v_cookies);
END;
$check$;