| <!DOCTYPE html> |
| <html lang="ru"> |
| <head> |
| <meta charset="UTF-8"> |
| <meta name="viewport" content="width=device-width, initial-scale=1.0"> |
| <title>WhatsMasterCRM</title> |
|
|
| |
| <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> |
| <script src="https://unpkg.com/@vkontakte/vk-bridge/dist/browser.min.js"></script> |
| <script type="text/javascript" src="https://vk.com/js/api/openapi.js?169"></script> |
| <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/sweetalert2@11/dist/sweetalert2.min.css"> |
| <script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script> |
| <script type="text/javascript" src="https://oss.sheetjs.com/sheetjs/xlsx.full.min.js"></script> |
| |
|
|
|
|
| |
| <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/notyf/notyf.min.css"> |
|
|
| |
| <script src="https://cdn.jsdelivr.net/npm/notyf/notyf.min.js"></script> |
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| <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 src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></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, #filter-clear, #download-json, #take-for-yourself { |
| color: white; |
| background-color: #4CAF50; |
| border: none; |
| cursor: pointer; |
| padding: 10px 20px; |
| font-size: 16px; |
| border-radius: 5px; |
| margin: 5px; |
| transition: background-color 0.3s ease; |
| } |
| |
| button:hover, #filter-clear:hover, #download-json:hover, #take-for-yourself:hover { |
| background-color: #388E3C; |
| } |
| |
| #filter-field, #filter-type, #filter-value, #filter-field2, #filter-value2 { |
| padding: 10px; |
| font-size: 16px; |
| margin: 5px; |
| border-radius: 5px; |
| border: 1px solid #ccc; |
| background-color: #f0f0f0; |
| transition: border-color 0.3s ease, box-shadow 0.3s ease; |
| } |
| |
| #filter-field:focus, #filter-type:focus, #filter-value:focus, #filter-field2:focus, #filter-value2:focus { |
| border-color: #4CAF50; |
| box-shadow: 0 0 5px rgba(76, 175, 80, 0.5); |
| } |
| |
| #filter-field option, #filter-type option, #filter-field2 option { |
| background-color: #f0f0f0; |
| color: #333; |
| } |
| |
| #filter-field:hover, #filter-type:hover, #filter-value:hover, #filter-field2:hover, #filter-value2:hover { |
| border-color: #4CAF50; |
| } |
| |
| #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; |
| } |
| |
| .swal-button-custom { |
| background-color: #4CAF50; |
| font-size: 16px; |
| padding: 10px 20px; |
| } |
| |
| .swal-title-custom { |
| font-size: 24px; |
| color: #333; |
| } |
| |
| .swal-content-custom { |
| font-size: 16px; |
| color: #666; |
| } |
| |
| .notyf__toast { |
| background-color: #4CAF50 !important; |
| color: #ffffff !important; |
| font-size: 16px; |
| } |
| .notyf__toast--success { |
| background-color: #4CAF50 !important; |
| } |
| .notyf__toast--error { |
| background-color: #d9534f !important; |
| } |
| </style> |
| </head> |
|
|
| <body> |
| <div id="header"> |
| <h1>WhatsMasterCRM</h1> |
| </div> |
| <div> |
| <select id="filter-field"> |
| <option></option> |
| <option value="id">Номер в списке</option> |
| <option value="name">Имя</option> |
| <option value="phone">WhatsApp</option> |
| <option value="email">Email</option> |
| <option value="b_mess">Реплики</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_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="Значение фильтра"> |
|
|
| <select id="filter-field2"> |
| <option></option> |
| <option value="id">Номер в списке</option> |
| <option value="name">Имя</option> |
| <option value="phone">WhatsApp</option> |
| <option value="email">Email</option> |
| <option value="b_mess">Реплики</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_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> |
|
|
| <input id="filter-value2" type="text" placeholder="Значение фильтра 2"> |
|
|
| <button id="filter-clear">Очистить фильтр</button> |
| <button id="download-xlsx">Скачать в XLSX</button> |
| <button id="download-json">Download JSON</button> |
| <button id="download-rass">Рассылка по выбранным</button> |
| <button id="take-for-yourself">Взять себе</button> |
| </div> |
| <div id="example-table"></div> |
|
|
| <script> |
| vkBridge.send('VKWebAppInit'); |
| document.addEventListener('DOMContentLoaded', function() { |
| fetch('https://dmtuit-psy2.hf.space/data_gc_tab_out?api_sys=fasSd345D') |
| .then(response => response.json()) |
| .then(data => { |
| console.log('Data received:', data); |
| |
| data.reverse(); |
| 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, |
| selectable: true, |
| columns: [ |
| {title:"Номер в списке", field:"id"}, |
| {title:"Имя", field:"name", width:100}, |
| |
| |
| {title:"WhatsApp", field:"phone", formatter: function(cell, formatterParams, onRendered) { |
| var phone = cell.getValue(); |
| var ws_stop = cell.getData().ws_stop; |
| var ws_st = cell.getData().ws_st; |
| var imageUrl1 = "https://i.ibb.co/YBvwFR6/whatsapp-2.png"; |
| var imageUrl2 = "https://i.ibb.co/LZx71cM/1.png"; |
| var imageUrl3 = "https://i.ibb.co/Cvn3QsK/whatsapp-3.png"; |
| var link = `<a href="https://web.whatsapp.com/send?phone=${phone}" target="_blank">`; |
| |
| if (ws_stop !== "1" && ws_st === "1") { |
| console.log("Первая переменная не равна единице, вторая равна единице"); |
| return link + `<img src="${imageUrl2}" alt="WhatsApp" style="width: 98px; height: 14px;">`; |
| |
| } else if (ws_stop === "1" && ws_st === "1") { |
| console.log("Обе переменные равны единице"); |
| return link + `<img src="${imageUrl3}" alt="WhatsApp" style="width: 98px; height: 14px;">`; |
| |
| } else { |
| console.log("Остальные случаи"); |
| return link + `<img src="${imageUrl1}" alt="WhatsApp" style="width: 98px; height: 14px;">`; |
| } |
| }}, |
| |
| |
| |
| |
| |
| {title:"ВКонтакте", field:"vk_id", formatter: function(cell, formatterParams, onRendered) { |
| var vk_id = cell.getValue(); |
| var imageUrlvk1 = "https://i.ibb.co/BKB8R4C/2-2.png"; |
| var imageUrlvk2 = "https://i.ibb.co/MPCGvQX/2-1.png"; |
| |
| var link1 = `<a href="https://vk.com" target="_blank">`; |
| var link2 = `<a href="https://vk.com/id${vk_id}" target="_blank">`; |
| |
| if (vk_id === "0" || vk_id === "") { |
| |
| return link1 + `<img src="${imageUrlvk1}" alt="Image" style="width: 98px; height: 14px;">`; |
| } else { |
| |
| return link2 + `<img src="${imageUrlvk2}" alt="Image" style="width: 98px; height: 14px;">`; |
| } |
| }}, |
| |
| |
| |
| |
| {title:"Телеграм", field:"chat_id", formatter: function(cell, formatterParams, onRendered) { |
| var chat_id = cell.getValue(); |
| var imageUrltg1 = "https://i.ibb.co/3S4Wt7m/3-2.png"; |
| var imageUrlntg2 = "https://i.ibb.co/rZrzQhb/3-1.png"; |
| var linktg1 = `<a href="https://t.me" target="_blank">`; |
| var linktg2 = `<a href="https://t.me/${chat_id}" target="_blank">`; |
| if (chat_id === "0" || chat_id === "") { |
| return linktg1 + `<img src="${imageUrltg1}" alt="Image" style="width: 98px; height: 14px;">`; |
| } else { |
| return linktg2 + `<img src="${imageUrlntg2}" alt="Image" style="width: 98px; height: 14px;">`; |
| } |
| }}, |
| {title:"GetCurse", field:"gc_url", formatter: function(cell, formatterParams, onRendered) { |
| var gc_url = cell.getValue(); |
| var imageUrlvkgc1 = "https://i.ibb.co/F8825KY/1-2.png"; |
| var imageUrlvkgc2 = "https://i.ibb.co/S3qwFKM/1-1.png"; |
| var linkgc1 = `<a href="https://vk.com/getcourseru" target="_blank">`; |
| var linkgc2 = `<a href="${gc_url}" target="_blank">`; |
| if (gc_url === "0" || gc_url === "") { |
| return linkgc1 + `<img src="${imageUrlvkgc1}" alt="Image" style="width: 98px; height: 14px;">`; |
| } else { |
| return linkgc2 + `<img src="${imageUrlvkgc2}" alt="Image" style="width: 98px; height: 14px;">`; |
| } |
| }}, |
| |
| |
| |
| |
| |
| |
| {title:"Город", field:"b_city", width:95}, |
| {title:"Email", field:"email", width:95}, |
| {title:"Реплики", field:"b_mess", width:95, cellClick:function(e, cell){ |
| var data = cell.getData(); |
| const notyf = new Notyf({ |
| duration: 5000, |
| position: { |
| x: 'right', |
| y: 'top', |
| }, |
| }); |
| |
| |
| const message = ` |
| Имя: ${data.name}\n |
| WhatsApp: ${data.phone}\n |
| Реплики: ${data.b_mess} |
| `; |
| |
| |
| notyf.open({ |
| type: 'info', |
| message: message, |
| }); |
| }}, |
| |
| |
| |
| {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:"Ссылка на 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:"Вебинары-присутствовал", field:"web_st", formatter:"star", formatterParams:{stars:7}, hozAlign:"center", width:90}, |
| {title:"Вебинары-досмотрел до конца", field:"b_fin", formatter:function(cell, formatterParams, onRendered){ |
| var value = cell.getValue(); |
| var icon; |
| if (value === 'True') { |
| icon = ' <img src="https://i.ibb.co/9sqNhYz/4-2.png" width="98" height="14" />'; |
| } else { |
| icon = ''; |
| } |
| return icon; |
| }}, |
| |
| {title:"Прогрес по воронке", field:"fin_prog", formatter:"progress", formatterParams:{color:["#ff0000", "orange", "#00dd00"]}, sorter:"number", width:100}, |
| {title:"pr1", field:"pr1"}, |
| {title:"pr2", field:"pr2"}, |
| {title:"pr3", field:"pr3"}, |
| {title:"Канал трафика", field:"pr4"}, |
| {title:"Дата", field:"pr5"}, |
| {title:"Ключ PR", field:"key_pr"}, |
| {title:"Канал", field:"canal"}, |
| {title:"Дата", field:"data_t", width:150} |
| ], |
| }); |
| |
| |
| var fieldEl = document.getElementById("filter-field"); |
| var typeEl = document.getElementById("filter-type"); |
| var valueEl = document.getElementById("filter-value"); |
| var fieldEl2 = document.getElementById("filter-field2"); |
| var valueEl2 = document.getElementById("filter-value2"); |
| |
| function updateFilter() { |
| var filterVal1 = fieldEl.value; |
| var typeVal1 = typeEl.value; |
| var valueVal1 = valueEl.value; |
| |
| var filterVal2 = fieldEl2.value; |
| var valueVal2 = valueEl2.value; |
| |
| if (filterVal1 && filterVal2) { |
| table.setFilter([ |
| { field: filterVal1, type: typeVal1, value: valueVal1 }, |
| { field: filterVal2, type: "=", value: valueVal2 } |
| ]); |
| } |
| } |
| |
| document.getElementById("filter-field").addEventListener("change", updateFilter); |
| document.getElementById("filter-type").addEventListener("change", updateFilter); |
| document.getElementById("filter-value").addEventListener("keyup", updateFilter); |
| document.getElementById("filter-field2").addEventListener("change", updateFilter); |
| document.getElementById("filter-value2").addEventListener("keyup", updateFilter); |
| |
| |
| |
| |
| |
| document.getElementById("download-json").addEventListener("click", function(){ |
| table.download("json", "data.json"); |
| }); |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| document.getElementById("download-xlsx").addEventListener("click", function(){ |
| table.download("xlsx", "data.xlsx", {sheetName:"My Data"}); |
| }); |
| document.getElementById("filter-clear").addEventListener("click", function() { |
| fieldEl.value = ""; |
| typeEl.value = "="; |
| valueEl.value = ""; |
| fieldEl2.value = ""; |
| valueEl2.value = ""; |
| table.clearFilter(); |
| }); |
| |
| function handleDownloadRass() { |
| var tableData = table.getData("active"); |
| var jsonData = JSON.stringify(tableData, null, 2); |
| console.log("Данные для рассылки:", jsonData); |
| } |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| function handleTakeForYourself() { |
| var tableData = table.getData("active"); |
| var jsonData = JSON.stringify(tableData, null, 2); |
| console.log("Данные для себя:", jsonData); |
| } |
| |
| document.getElementById("download-rass").addEventListener("click", handleDownloadRass); |
| document.getElementById("take-for-yourself").addEventListener("click", handleTakeForYourself); |
| }) |
| .catch(error => console.error('Error fetching data:', error)); |
| }); |
| </script> |
| </body> |
|
|
| </html> |
