☰

Greasy Fork is available in English.

Bitrix24 Convert Input To Select

Tasks doesn't have dropdown lists in our version of B24, this scripts solves this problem.

Fra 28.03.2024. Se den seneste versjonen.

// ==UserScript==
// @name         Bitrix24 Convert Input To Select
// @namespace    https://crm.globaldrive.ru/
// @version      1.0.0
// @description  Tasks doesn't have dropdown lists in our version of B24, this scripts solves this problem.
// @author       Dzorogh 
// @match        https://crm.globaldrive.ru/*
// @require      https://cdn.jsdelivr.net/npm/[email protected]
// @grant        GM_addStyle
// ==/UserScript==

(async function() {
    
    const getSheetId = (lsKey) => {
        let sheetId = localStorage.getItem(lsKey);

        if (!sheetId || sheetId === 'null') {
            sheetId = prompt('Please enter Google Sheet Id');

            if (sheetId) {
                localStorage.setItem(lsKey, sheetId);
            }
        }

        return sheetId;
    }

    const parseExcel = async (sheetId, sheetName) => {
        const parser = new PublicGoogleSheetsParser(sheetId, { sheetName })
        const parserData = await parser.parse();

        console.log('convertInputToSelect: parserData', parserData)

        if (!parserData.length) {
            localStorage.removeItem(lsKey);
        }

        return parserData
    }
    
    const convertInputToSelect = async (sheetId, sheetName, fieldId) => {
        const parserData = await parseExcel(sheetId, sheetName);

        const options = parserData.map((item) => {
            return item.value;
        })

        console.log('convertInputToSelect: options', options)

        const defaultOption = parserData.find((item) => {
            return item.is_default == 1;
        })

        console.log('convertInputToSelect: defaultOption', defaultOption)

        const inputElement = document.querySelector(`input[name*='${fieldId}']`);

        if (!inputElement) {
            console.error(inputElement)
            throw new Error('Element not found')
        }

        const copyAttsTo = (from, to) => {
            const attrs = from.attributes;

            for (const attr of attrs) {
                if (attr.name !== 'size') {
                    to.setAttribute(attr.name, attr.value);
                }
            }
        }
        
        const newSelectElement = document.createElement("select");

        copyAttsTo(inputElement, newSelectElement);

        inputElement.replaceWith(newSelectElement);

        newSelectElement.style.width = '100%';

        options.unshift('')

        options.forEach((option) => {
            const optionElement = document.createElement('option');
            optionElement.value = option;
            optionElement.textContent = option;

            if (inputElement.value === option) {
                optionElement.selected = true;
            } else if (!inputElement.value && defaultOption && defaultOption.value === option) {
                optionElement.selected = true;
            }

            newSelectElement.append(optionElement);
        })
    }

    const parseConfig = async (sheetId, sheetName) => {
        return parserData = await parseExcel(sheetId, sheetName);
    }

    const lsKey = 'convertInputToSelectSheetId';
    const configListName = '[Config]';

    const sheetId = getSheetId(lsKey);

    if (!sheetId) {
        console.error('No sheet ID provided');
        return false;
    }

    const config = await parseConfig(sheetId, configListName);

    console.log(config)

    config.forEach((field) => {
        convertInputToSelect(sheetId, field.list_name, field.field_id) 
    });
})();