#! /usr/bin/env python
# coding: UTF8
import MySQLdb
import pycurl
import base64
import json
import datetime

db = MySQLdb.connect(host="xxx.xxx.x.xx", user="xxxxx", passwd="xxxxxx", db="xxxxx", charset = 'utf8')

cursor = db.cursor()

cursor.execute("SELECT DataConsulta, Dias, HoraConsulta, HoraSaida, nome, Consulta, centrodb.LocalConsulta.Descricao, Contato FROM centrodb.RegistoConsultas LEFT OUTER JOIN centrodb.LocalConsulta ON centrodb.LocalConsulta.Id = centrodb.RegistoConsultas.`Local` LEFT OUTER JOIN centrodb.UtentesCons ON centrodb.UtentesCons.codigoutente = centrodb.RegistoConsultas.Utente LEFT OUTER JOIN centrodb.DiasSemana ON centrodb.DiasSemana.Id = centrodb.RegistoConsultas.DiaSemana")

myresult = cursor.fetchall()

for linha in myresult:
 DataConsulta = linha[0]
 Dias = linha[1]
 HoraConsulta = linha[2]
 HoraSaida = linha[3]
 nome = linha[4]
 Consulta = linha[5]
 Descricao = linha[6]
 Contato = linha[7]

 today = datetime.date.today()
 data = today + datetime.timedelta(days=7)

 if DataConsulta == data:
  if __name__ == "__main__":
    url ="https://dashboard.360nrs.com/api/rest/sms"
    usrPass = "xxxxxxx:xxxxxxx"
    data = json.dumps({
    "to":[Contato],
    "from":"xxxxxxxx",
    "message":"LAR. Consulta de " + Consulta + " em " + DataConsulta + " para " + nome + ". " + Descricao + ". Responda Sim/Não para o acompanhamento. ",
    })
    b64Val = base64.b64encode(usrPass)
    headers=["Accept:Application/json","Authorization:Basic %s"%b64Val]
    c = pycurl.Curl()
    c.setopt(pycurl.URL, url)
    c.setopt(pycurl.HTTPHEADER,headers)
    c.setopt(pycurl.POST, 1)
    c.setopt(pycurl.POSTFIELDS, data)
    c.setopt(pycurl.SSL_VERIFYHOST, 0)
    c.setopt(pycurl.SSL_VERIFYPEER, 0)
    c.perform()
    http_code = c.getinfo(pycurl.HTTP_CODE)
    print(http_code)