|
<!DOCTYPE html> |
|
<html lang="en"> |
|
<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/[email protected]/dist/css/tabulator.min.css" rel="stylesheet"> |
|
<script type="text/javascript" src="https://unpkg.com/[email protected]/dist/js/tabulator.min.js"></script> |
|
<style> |
|
|
|
|
|
</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_statys_full">Статус покупки</option> |
|
<option value="ad_url">Ссылка на пользователя в GC</option> |
|
<option value="vk_id">Ссылка на VK</option> |
|
<option value="chat_id">Ссылка на Tg</option> |
|
<option value="ws_statys">Статус WhatsApp</option> |
|
<option value="ws_stop">Стутус подписки</option> |
|
<option value="web_statys">Вебинары</option> |
|
<option value="fin_progress">Прогрес по воронке</option> |
|
<option value="pr1">utm_source</option> |
|
<option value="pr2">utm_medium</option> |
|
<option value="pr3">utm_campaign</option> |
|
<option value="pr4">utm_term</option> |
|
<option value="pr5">utm_content</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="export-json">Экспортировать JSON</button> |
|
</div> |
|
<div id="example-table"></div> |
|
|
|
<script> |
|
document.addEventListener('DOMContentLoaded', function() { |
|
fetch('https://dmtuit-gc-api-ras.hf.space/data_gc_tab_out?api_sys=fasSd345D') |
|
.then(response => response.json()) |
|
.then(data => { |
|
console.log('Data received:', data); |
|
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: function(cell, formatterParams, onRendered) { |
|
var curator = cell.getValue(); |
|
var curatorLink = cell.getData().curator_link; |
|
return `<a href="${curatorLink}" target="_blank">${curator}</a>`; |
|
}}, |
|
{title:"Статус покупки", field:"shop_statys_full", 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_statys"}, |
|
{title:"Стутус подписки", field:"ws_stop"}, |
|
{title:"Вебинары", field:"web_statys", formatter:"star", formatterParams:{stars:7}, hozAlign:"center", width:120}, |
|
{title:"Прогрес по воронке", field:"fin_progress", formatter:"progress", formatterParams:{color:["#00dd00", "orange", "rgb(255,0,0)"]}, sorter:"number", width:100}, |
|
{title:"utm_source", field:"pr1"}, |
|
{title:"utm_medium", field:"pr2"}, |
|
{title:"utm_campaign", field:"pr3"}, |
|
{title:"utm_term", field:"pr4"}, |
|
{title:"utm_content", field:"pr5"} |
|
], |
|
}); |
|
|
|
|
|
var fieldEl = document.getElementById("filter-field"); |
|
var typeEl = document.getElementById("filter-type"); |
|
var valueEl = document.getElementById("filter-value"); |
|
|
|
function updateFilter() { |
|
var filterVal = fieldEl.options[fieldEl.selectedIndex].value; |
|
var typeVal = typeEl.options[typeEl.selectedIndex].value; |
|
if (filterVal) { |
|
table.setFilter(filterVal, typeVal, valueEl.value); |
|
} |
|
} |
|
|
|
document.getElementById("filter-field").addEventListener("change", updateFilter); |
|
document.getElementById("filter-type").addEventListener("change", updateFilter); |
|
document.getElementById("filter-value").addEventListener("keyup", updateFilter); |
|
|
|
document.getElementById("filter-clear").addEventListener("click", function() { |
|
fieldEl.value = ""; |
|
typeEl.value = "="; |
|
valueEl.value = ""; |
|
table.clearFilter(); |
|
}); |
|
|
|
|
|
document.getElementById("export-json").addEventListener("click", function() { |
|
var filteredData = table.getData("filtered"); |
|
var jsonData = JSON.stringify(filteredData, null, 2); |
|
console.log("Filtered data as JSON:", jsonData); |
|
var blob = new Blob([jsonData], {type: "application/json"}); |
|
var url = URL.createObjectURL(blob); |
|
var a = document.createElement("a"); |
|
a.href = url; |
|
a.download = "filtered_data.json"; |
|
document.body.appendChild(a); |
|
a.click(); |
|
document.body.removeChild(a); |
|
}); |
|
}) |
|
.catch(error => console.error('Error fetching data:', error)); |
|
}); |
|
</script> |
|
</body> |
|
</html> |
|
|
