#! /usr/bin/env python
# -*- coding: utf-8 -*-
import MySQLdb
import pycurl
import base64
import json
import datetime

db = MySQLdb.connect(host="xxx.xxx.x.xx", user="xxxxx", passwd="xxxxxx", db="xxxxxxx", 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 = "xxxxxx:xxxxxx"
    data = json.dumps({
    u"to":[Contato],
    u"from":u"xxxxxxx",
    u"message":u"LAR. Relembramos que o utente {} tem Consulta de {} no dia {} às {} no {}. Responda Sim/Não para confirmar o acompanhamento. ".format(
        nome, Consulta, DataConsulta, HoraConsulta, Descricao),
    u"encoding":u"gsm-pt",
    u"parts":u"2"
    })
    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)