Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function vvvvv(arr, dateCol, returnCol) {
- return arr.filter(g => isValidDate(g[dateCol - 1]) && new Date().getTime() >= g[dateCol - 1].getTime())
- .map(g => g[returnCol - 1]).join('\n');
- }
- function isValidDate(d) {
- return d instanceof Date && !isNaN(d);
- }
- function timer() {
- let ss = SpreadsheetApp.getActiveSpreadsheet();
- let ws = ss.getSheetByName("Сроки");
- let data = ws.getDataRange().getValues();
- let msg = vvvvv(data, 12, 3)
- if (msg) {
- sendMessage(clientIdChat, 'Уважаемый коллега, скоро закончится срок годности у следующего PLU ' + '\n' + '\n' + '<strong>' + clientName + '</strong>\n' + '\n' + 'Прошу тебя, предпринять меры.');
- }
- }
- function sendMessage(chatId, text, keyBoard) {
- let data = {
- method: 'post',
- payload: {
- method: 'sendMessage',
- chat_id: String(chatId),
- text: text,
- parse_mode: 'HTML',
- reply_markup: JSON.stringify(keyBoard)
- }
- }
- UrlFetchApp.fetch('https://api.telegram.org/bot' + token + '/', data);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement