|
<!DOCTYPE html> |
|
<html> |
|
<head> |
|
<title>GetCurse - WhatsCRM</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> |
|
</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> |
