|
<!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/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> |
|
<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; |
|
} |
|
</style> |
|
</head> |
|
<body> |
|
<div id="header"> |
|
<h1>База синхронизации с GetCourse</h1> |
|
</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); |
|
|
|
|
|
data.forEach(item => { |
|
if (!item.curator) { |
|
item.curator = 'Unknown'; |
|
} |
|
}); |
|
|
|
var table = new Tabulator("#example-table", { |
|
data: data, |
|
layout: "fitColumns", |
|
columns: [ |
|
{title:"Номер в списке", field:"id"}, |
|
{title:"Имя", field:"name"}, |
|
{title:"Телефон", field:"phone"}, |
|
{title:"Email", field:"email"}, |
|
{title:"Куратор", field:"curator"}, |
|
{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"}, |
|
{title:"Прогрес по воронке", field:"fin_progress"}, |
|
{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"} |
|
], |
|
}); |
|
}) |
|
.catch(error => console.error('Error fetching data:', error)); |
|
}); |
|
</script> |
|
</body> |
|
</html> |
