• View
• Edit
• History
• Print

Gs-tele

var sss = SpreadsheetApp.openById('1yP6mxkcQYIPEVlPxxxLnkCkcH2jcUnEMGvPoU');
//sss.getRange("F1").setValue(pes);
var sh1 = sss.getSheetByName('Sheet1');
var sh2 = sss.getSheetByName('Sheet2');


function t(){
sh1.getRange("F1").setValue("test saja")
sh2.getRange("A1").setValue("test saja")
}


function doGet(e) {
return HtmlService.createHtmlOutput("ver.007");
}

function pesanku(id,text) {
  text = encodeURIComponent(text)
  var url = "https://api.telegram.org/bot"+token+"/sendMessage?chat_id=" + id + "&text=" + text;
  var response = UrlFetchApp.fetch(url);
  var js = JSON.parse(response);
  var message_id = js.result.message_id
  return message_id
}

function sendText(id,text) {
  text = encodeURIComponent(text)
  var token = "1106869693:AAGjQ8yEAOqxxx0uBUYvv_33dwMfcw";
  var url = "https://api.telegram.org/bot"+token+"/sendMessage?chat_id=" + id + "&text=" + text;
  var response = UrlFetchApp.fetch(url);
}

function balas(mid,text) {
  text = encodeURIComponent(text)
  var token = "1106869693:AAGjQ8yEAOqWmxxxx0uBUYvv_33dwMfcw";
  var url = "https://api.telegram.org/bot"+token+"/sendMessage?chat_id=-1001325133914&text="+text+"&reply_to_message_id="+mid;
  var response = UrlFetchApp.fetch(url);
  var url = "https://api.telegram.org/bot"+token+"/deleteMessage?chat_id=-1001325133914&message_id="+mid;
  var response = UrlFetchApp.fetch(url);
}

function xbalas(mid,text) {
  text = encodeURIComponent(text)
  var token = "1106869693:AAGjQ8yEAOqWmxxx0uBUYvv_33dwMfcw";
  var url = "https://api.telegram.org/bot"+token+"/sendMessage?chat_id=-1001325133914&text="+text;
  var response = UrlFetchApp.fetch(url);
  var url = "https://api.telegram.org/bot"+token+"/deleteMessage?chat_id=-1001325133914&message_id="+mid;
  var response = UrlFetchApp.fetch(url);
}

function hapus(mid) {
  var token = "1106869693:AAGjQ8yxxxq90uBUYvv_33dwMfcw";
  var url = "https://api.telegram.org/bot"+token+"/deleteMessage?chat_id=-1001325133914&message_id=" +mid;
  var response = UrlFetchApp.fetch(url);
}

function doPost(e) {
  var data = JSON.parse(e.postData.contents);
  var text = data.message.text;
  var id = data.message.chat.id;

  var name = data.message.chat.first_name + " " + data.message.chat.last_name;

  var from = data.message.from.id;
  var uname = data.message.from.username;
  var ffname = data.message.from.first_name;
  var flname = data.message.from.last_name;
       if(flname == undefined){flname = ""}
  var fname = ffname + " " + flname;
  var msid = data.message.message_id;

  var ch_type = data.message.chat.type;


  if(uname== undefined){
    balas(msid,fname+" silahkan buat @username dulu yah...!!!\nubek-ubek menu profil...");
    return
  } 

  if(ch_type=="private"){
    if(id=="242539199"){ //lanjutkan...!!! 
    }else{ sendText(id,"sorry out of services...!!!"); return; }
  }

  //sss.getRange("F3").setValue(from);
if(id=="-1001325133914"){ simpan01(from,fname,uname);  }



if (text == ("/help")){ var answer = "help";

}else if (text == ("/rank")){ xco(msid)

}else if (text.substring(0, 9) == ("bro suhu ")){
  var ss = text.split(' ')
  suhu(ss[2],msid)


}else if (text.substring(0, 1) == ("#") && id=="2425300000"){
  var ss = text.split('#')
  var del1 = sendText("-100132513000000000",ss[1])
  var del2 = sh1.getRange("E1").getValue()
  hapus(del2)
  sh1.getRange("E1").setValue(del1)


}else if (text.substring(0, 1) == ("/")){ hapus(msid) }



}


function suhu(cit,msid){

      var api = "https://api.openweathermap.org/data/2.5/weather?q="+cit+"&appid=b179001a4a328b426e2adae9c470981a&units=metric";
      var res2 = UrlFetchApp.fetch(api);
      var retw2 = res2.getContentText();
      var obj = JSON.parse(retw2);
      var name = obj.name;
      var weather = obj.weather[0].main;
      var weather2 = obj.weather[0].description;
	var temp = obj.main.temp;
	var temp1 = obj.main.temp_min;
	var temp2 = obj.main.temp_max;
	var speed = obj.wind.speed;
	var clouds = obj.clouds.all;

  if(weather==undefined){
    var ha = "Sorry, City Not Found...."
  }else{
    var ha = "City : "+name+"\nTemp : "+temp+" Celsius\nWeather : "+weather+" - "+weather2+"\nWind Speed : "+speed+" m/s\nClouds : "+clouds+"%"
  }

  //sendText(-1001325133914,ha)
  balas(msid,ha)
}



function simpan01(cid,fname,uname){
 var y = sss.getLastRow()
 for(var i=1;i<y+1;i++){
    var value = sss.getRange("A"+i).getValue();
    if(value == cid){ 
      var cr = i; 
    }
}


  if(cr == undefined) {
    var nr0 = sss.getLastRow()
    var nr1 = nr0+1
    sss.getRange("A"+nr1).setValue(cid);
    sss.getRange("B"+nr1).setValue(fname);
    sss.getRange("C"+nr1).setValue("1");

  }else{
    var old = sss.getRange("C"+cr).getValue();
    old = old+1
    sss.getRange("C"+cr).setValue(old);
    sss.getRange("D"+cr).setValue("@"+uname);

  }  
  return true
}



function xco(id){

 var y = sss.getLastRow()
 sss.sort(3, false);
 var pes = ""
 for(var i=1;i<y+1;i++){
    var nama = sss.getRange("B"+i).getValue();
    var jum = sss.getRange("C"+i).getValue();
   pes = pes+nama+" : "+jum+"\n";
}
xbalas(id,pes);
//sendText(id,pes);
//sendText("-1001325133914",pes);
//sss.getRange("F1").setValue(pes);
return pes
}