Server : Apache/2.4.41 (Ubuntu) System : Linux absol.cf 5.4.0-198-generic #218-Ubuntu SMP Fri Sep 27 20:18:53 UTC 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, Directory :  /var/www/html/libs/absol-sheet/example_data/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

window.getPrice = function (brand, product) {
    if (!brand || !product) return 0;
    return 1000000 * (1 + parseInt(brand.match(/[0-9][0-9]$/g)[0]) / 100) * (1 + parseInt(product.match(/[0-9][0-9]$/g)[0]) / 100);
};

window.getDiscount = function (brand) {
    return (1 + parseInt(brand.match(/[0-9][0-9]$/g)[0]) / 100) * 0.2;
};

module.exports = {
    name: "4",
    id: "Q9LbVRShJfCvu7BJ",
    propertyNames: [
        "type_1_1651227307699",
        "type_1_1651227314730",
        "type_1_1651227330287",
        "quantity",
        "price",
        "type_1_1651227352837",
        "discount_percent",
        "cash"
    ],
    propertyDescriptors: {
        cash: {
            type: "number",
            text: "Thành tiền (VNĐ)",
            calc: "=type_1_1651227352837 * (1 - getDiscount(type_1_1651227314730))",
            floatFixed: 0
        },
        discount_percent: {
            type: "text",
            text: "Chiết khấu (%)",
            calc: "=Math.floor(getDiscount(type_1_1651227314730) * 100) + '%'",
            format: {
                maximumFractionDigits: 20,
                minimumFractionDigits: 0
            }
        },
        price: {
            type: "number",
            text: "Đơn giá (VNĐ)",
            calc: "=getPrice(type_1_1651227314730, type_1_1651227330287)",
        },
        quantity: {
            type: "number",
            text: "Số lượng",
            required: true
        },
        type_1_1651227307699: {
            type: "Date",
            text: "Ngày phát sinh",
            required: true
        },
        type_1_1651227314730: {
            type: "enum",
            emptyValue: 0,
            text: "Nhãn hiệu",
            items: [
                {
                    text: "-- Chọn giá trị --",
                    value: 0
                },
                {
                    text: "Tiền Phong",
                    value: "type_1_1651227035533"
                },
                {
                    text: "Dismy",
                    value: "type_1_1651227050181"
                },
                {
                    text: "Vesbo",
                    value: "type_1_1651227058116"
                },
                {
                    text: "Tân Á",
                    value: "type_1_1651227066869"
                },
                {
                    text: "Asico",
                    value: "type_1_1651227073850"
                },
                {
                    text: "Đệ Nhất",
                    value: "type_1_1651227085679"
                },
                {
                    text: "Bình Minh",
                    value: "type_1_1651227093141"
                },
                {
                    text: "Hoa Sen",
                    value: "type_1_1651227096208"
                },
                {
                    text: "Dekko",
                    value: "type_1_1651227108898"
                },
                {
                    text: "Sino",
                    value: "type_1_1651227115627"
                },
                {
                    text: "ERP",
                    value: "type_1_1651227122159"
                },
                {
                    text: "Khác",
                    value: "type_1_1651227134847"
                }
            ],
            required: true
        },
        type_1_1651227330287: {
            type: "enum",
            emptyValue: 0,
            text: "Sản phẩm",
            items: [
                {
                    text: "-- Chọn giá trị --",
                    value: 0
                },
                {
                    text: "PVC",
                    value: "type_1_1651227179076"
                },
                {
                    text: "PP-R",
                    value: "type_1_1651227182306"
                },
                {
                    text: "HDPE",
                    value: "type_1_1651227192307"
                }
            ],
            required: true
        },
        type_1_1651227352837: {
            type: "number",
            text: "Số tiền (Đã chiết khấu, trước VAT, VNĐ)",
            calc: '=price*quantity',
            format: {
                maximumFractionDigits: 20,
                minimumFractionDigits: 0
            }
        },
    },

    records: [
        {
            type_1_1651227307699: new Date(1682096400000),
            type_1_1651227314730: "type_1_1651227035533",
            type_1_1651227330287: "type_1_1651227179076",
            type_1_1651227352837: 6000000,
            quantity: 6
        },
        {
            type_1_1651227307699: new Date(1687798800000),
            type_1_1651227314730: "type_1_1651227035533",
            type_1_1651227330287: "type_1_1651227182306",
            type_1_1651227352837: 4000000,
            quantity: 4
        },
        {
            type_1_1651227307699: new Date(1687798800000),
            type_1_1651227314730: "type_1_1651227035533",
            type_1_1651227330287: "type_1_1651227192307",
            type_1_1651227352837: 2000000,
            quantity: 14
        },
        {
            type_1_1651227307699: new Date(1687798800000),
            type_1_1651227314730: "type_1_1651227093141",
            type_1_1651227330287: "type_1_1651227182306",
            type_1_1651227352837: 2000000,
            quantity: 14
        },
        ...Array(100).fill(0).map((_, i) => ({
            type_1_1651227307699: new Date(1687798800000 + i * 86400000),
            type_1_1651227314730: "type_1_1651227035533",
            type_1_1651227330287: "type_1_1651227179076",
            type_1_1651227352837: 6000000,

            quantity: i * 17 % 31 + 2
        }))
    ]
}