| <head> | |
| <meta charset="UTF-8"> | |
| <meta name="viewport" content="width=device-width, initial-scale=1.0"> | |
| <title>Tabulator Example</title> | |
| <link href="https://unpkg.com/tabulator-tables@6.2.1/dist/css/tabulator.min.css" rel="stylesheet"> | |
| <script type="text/javascript" src="https://unpkg.com/tabulator-tables@6.2.1/dist/js/tabulator.min.js"></script> | |
| <script type="text/javascript" src="https://oss.sheetjs.com/sheetjs/xlsx.full.min.js"></script> | |
| <style> | |
| body { | |
| font-family: Arial, sans-serif; | |
| text-align: center; | |
| background-color: #f0f0f0; | |
| margin: 0; | |
| padding: 0; | |
| } | |
| h1 { | |
| background-color: #4CAF50; | |
| color: white; | |
| padding: 20px; | |
| margin: 0; | |
| border-bottom: 2px solid #388E3C; | |
| font-size: 28px; | |
| text-shadow: 2px 2px 4px rgba(0, 0, 0, 0.3); | |
| } | |
| button[type="submit"] { | |
| color: white; | |
| background-color: #4CAF50; | |
| border: none; | |
| cursor: pointer; | |
| padding: 10px 20px; | |
| font-size: 16px; | |
| border-radius: 5px; | |
| margin-top: 20px; | |
| transition: background-color 0.3s ease; | |
| } | |
| button[type="submit"]:hover { | |
| background-color: #388E3C; | |
| } | |
| #mediaContainer { | |
| margin-top: 20px; | |
| display: flex; | |
| justify-content: center; | |
| align-items: center; | |
| flex-direction: column; | |
| max-width: 100%; | |
| height: auto; | |
| box-shadow: 0 4px 8px rgba(0, 0, 0, 0.1); | |
| border-radius: 10px; | |
| padding: 20px; | |
| background-color: white; | |
| } | |
| #mediaContainer img, #mediaContainer video { | |
| max-width: 100%; | |
| height: auto; | |
| object-fit: contain; | |
| border-radius: 10px; | |
| } | |
| #imageUrl { | |
| margin-top: 20px; | |
| font-size: 16px; | |
| color: #333; | |
| cursor: pointer; | |
| text-decoration: underline; | |
| transition: color 0.3s ease; | |
| } | |
| #imageUrl:hover { | |
| color: #4CAF50; | |
| } | |
| #progressBarContainer { | |
| width: 80%; | |
| margin: 20px auto; | |
| background-color: #ddd; | |
| border-radius: 13px; | |
| padding: 3px; | |
| box-shadow: inset 0 1px 3px rgba(0, 0, 0, 0.2); | |
| } | |
| #progressBar { | |
| width: 0%; | |
| height: 20px; | |
| background-color: #4CAF50; | |
| border-radius: 10px; | |
| text-align: center; | |
| line-height: 20px; | |
| color: white; | |
| transition: width 0.3s ease; | |
| } | |
| #filter-field, #filter-type, #filter-value, #filter-clear , #download-json{ | |
| padding: 10px; | |
| font-size: 16px; | |
| margin: 5px; | |
| } | |
| #filter-value { | |
| width: 200px; | |
| } | |
| #filter-clear { | |
| padding: 10px 20px; | |
| } | |
| #filter-field, #filter-type, #filter-value, #filter-clear, #download-json { | |
| padding: 10px; | |
| font-size: 16px; | |
| margin: 5px; | |
| border-radius: 5px; | |
| border: 1px solid #ccc; | |
| } | |
| #filter-value { | |
| width: 200px; | |
| background-color: #f0f0f0; | |
| } | |
| #filter-clear { | |
| padding: 10px 20px; | |
| background-color: #4CAF50; | |
| color: white; | |
| border: none; | |
| cursor: pointer; | |
| box-shadow: 0 2px 4px rgba(0, 0, 0, 0.2); | |
| transition: background-color 0.3s ease; | |
| } | |
| #filter-clear:hover { | |
| background-color: #388E3C; | |
| } | |
| #download-json { | |
| padding: 10px 20px; | |
| background-color: #4CAF50; | |
| color: white; | |
| border: none; | |
| cursor: pointer; | |
| box-shadow: 0 2px 4px rgba(0, 0, 0, 0.2); | |
| transition: background-color 0.3s ease; | |
| } | |
| #download-json:hover { | |
| background-color: #388E3C; | |
| } | |
| </style> | |
| </head> | |
| <body> | |
| <div id="header"> | |
| <h1>GetCurse - WhatsCRM</h1> | |
| </div> | |
| <div> | |
| <select id="filter-field"> | |
| <option></option> | |
| <option value="id">Номер в списке</option> | |
| <option value="name">Имя</option> | |
| <option value="phone">Телефон</option> | |
| <option value="email">Email</option> | |
| <option value="curator">Куратор</option> | |
| <option value="shop_st">Статус покупки</option> | |
| <option value="ad_url">Ссылка на пользователя в GC</option> | |
| <option value="vk_id">Ссылка на VK</option> | |
| <option value="chat_id">Ссылка на Tg</option> | |
| <option value="ws_st">Статус WhatsApp</option> | |
| <option value="ws_stop">Статус подписки</option> | |
| <option value="web_st">Вебинары</option> | |
| <option value="fin_prog">Прогрес по воронке</option> | |
| <option value="pr1">pr1</option> | |
| <option value="pr2">pr2</option> | |
| <option value="pr3">pr3</option> | |
| <option value="pr4">Канал трафика</option> | |
| <option value="pr5">Дата</option> | |
| <option value="key_pr">Ключ PR</option> | |
| <option value="canal">Канал</option> | |
| <option value="data_t">Дата</option> | |
| </select> | |
| <select id="filter-type"> | |
| <option value="=">=</option> | |
| <option value="<"><</option> | |
| <option value="<="><=</option> | |
| <option value=">">></option> | |
| <option value=">=">>=</option> | |
| <option value="!=">!=</option> | |
| <option value="like">like</option> | |
| </select> | |
| <input id="filter-value" type="text" placeholder="Значение фильтра"> | |
| <button id="filter-clear">Очистить фильтр</button> | |
| <button id="download-json">Рассылка по выбранным</button> | |
| </div> | |
| <div id="example-table"></div> | |
| <script> | |
| document.addEventListener('DOMContentLoaded', function() { | |
| fetch('/data_gc_tab_out?api_sys=fasSd345D') | |
| .then(response => response.json()) | |
| .then(data => { | |
| var linkFormatter = function(cell, formatterParams, onRendered) { | |
| var curator = cell.getValue(); | |
| var curatorLink = cell.getData().curator_link; | |
| return `<a href="${curatorLink}" target="_blank">${curator}</a>`; | |
| }; | |
| var table = new Tabulator("#example-table", { | |
| data: data, | |
| layout: "fitColumns", | |
| pagination: "local", | |
| paginationSize: 50, | |
| columns: [ | |
| {title: "Номер в списке", field: "id"}, | |
| {title: "Имя", field: "name"}, | |
| {title: "Телефон", field: "phone"}, | |
| {title: "Email", field: "email"}, | |
| {title: "Куратор", field: "curator", formatter: linkFormatter}, | |
| {title: "Статус покупки", field: "shop_st", formatter: function(cell, formatterParams, onRendered) { | |
| var status = cell.getValue(); | |
| var color; | |
| switch (status) { | |
| case 'green': color = 'green'; break; | |
| case 'red': color = 'red'; break; | |
| case 'yellow': color = 'yellow'; break; | |
| default: color = 'gray'; | |
| } | |
| return `<div style="width: 20px; height: 20px; background-color: ${color};"></div>`; | |
| }}, | |
| {title: "Ссылка на пользователя в GC", field: "ad_url", formatter: function(cell, formatterParams, onRendered) { | |
| var ad_url = cell.getValue(); | |
| return `<a href="${ad_url}" target="_blank">${ad_url}</a>`; | |
| }}, | |
| {title: "Ссылка на VK", field: "vk_id", formatter: function(cell, formatterParams, onRendered) { | |
| var vk_id = cell.getValue(); | |
| return `<a href="https://vk.com/id${vk_id}" target="_blank">${vk_id}</a>`; | |
| }}, | |
| {title: "Ссылка на Tg", field: "chat_id", formatter: function(cell, formatterParams, onRendered) { | |
| var chatId = cell.getValue(); | |
| if (chatId.startsWith('@')) { | |
| chatId = chatId.substring(1); | |
| } | |
| return `<a href="https://t.me/${chatId}" target="_blank">${chatId}</a>`; | |
| }}, | |
| {title: "Ссылка на WhatsApp", field: "phone", formatter: function(cell, formatterParams, onRendered) { | |
| var phone = cell.getValue(); | |
| return `<a href="https://web.whatsapp.com/send?phone=${phone}" target="_blank">${phone}</a>`; | |
| }}, | |
| {title: "Статус WhatsApp", field: "ws_st"}, | |
| {title: "Статус подписки", field: "ws_stop"}, | |
| {title: "Вебинары", field: "web_st", formatter: "star", formatterParams: {stars: 7}, hozAlign: "center", width: 120}, | |
| {title: "Прогрес по воронке", field: "fin_prog", formatter: "progress", formatterParams: {color: ["#00dd00", "orange", "rgb(255,0,0)"]}, sorter: "number", width: 100}, | |
| {title: "Город", field: "b_city"}, | |
| {title: "Финансы", field: "b_fin"}, | |
| {title: "Бан", field: "b_ban"}, | |
| {title: "Игнорирование", field: "b_ign"}, | |
| {title: "Баннеры", field: "b_baners"}, | |
| {title: "Кнопки", field: "b_butt"}, | |
| {title: "Сообщения", field: "b_mess"}, | |
| {title: "pr1", field: "pr1"}, | |
| {title: "pr2", field: "pr2"}, | |
| {title: "pr3", field: "pr3"}, | |
| {title: "pr4", field: "pr4"}, | |
| {title: "pr5", field: "pr5"}, | |
| {title: "Канал трафика", field: "canal"}, | |
| {title: "Дата", field: "data_t"}, | |
| ], | |
| }); | |
| document.getElementById("filter-clear").addEventListener("click", function() { | |
| document.getElementById("filter-field").value = ""; | |
| document.getElementById("filter-type").value = "="; | |
| document.getElementById("filter-value").value = ""; | |
| table.clearFilter(); | |
| }); | |
| function updateFilter() { | |
| var field = document.getElementById("filter-field").value; | |
| var type = document.getElementById("filter-type").value; | |
| var value = document.getElementById("filter-value").value; | |
| if (field) { | |
| table.setFilter(field, type, value); | |
| } | |
| } | |
| document.getElementById("filter-field").addEventListener("change", updateFilter); | |
| document.getElementById("filter-type").addEventListener("change", updateFilter); | |
| document.getElementById("filter-value").addEventListener("keyup", updateFilter); | |
| document.getElementById("download-json").addEventListener("click", function() { | |
| var selectedData = table.getSelectedData(); | |
| var jsonString = JSON.stringify(selectedData); | |
| var blob = new Blob([jsonString], {type: "application/json"}); | |
| var url = URL.createObjectURL(blob); | |
| var a = document.createElement("a"); | |
| a.href = url; | |
| a.download = "selectedData.json"; | |
| document.body.appendChild(a); | |
| a.click(); | |
| document.body.removeChild(a); | |
| }); | |
| }) | |
| .catch(error => { | |
| console.error('Error fetching data:', error); | |
| }); | |
| }); | |
| </script> | |
| </body> | |
| </html> |