def add_faturas():
print "Ficheiro clientes_dev.csv deve estar no /TMP"
print "Formato do ficheiro Nomecliente,valor"
print "Mudar o IP do Servidor"
print "Mudar o Usuario e a Senha para Importar"
# client= FrappeClient("http://192.168.229.139:8000","*****@*****.**","demo123456789")
client = FrappeClient("http://127.0.0.1:8000", "*****@*****.**",
"demo123456789")
# loop no txt,csv and get Client, Valor
# Lancamento de Devedores com IS OPENING=1
with open('/tmp/clientes_dev.csv') as csvfile:
readCSV = csv.reader(csvfile)
print "Lendo o ficheiro..."
for row in readCSV:
if (len(row[0]) > 1): #(row[0].strip() != "0"):
nomecliente = row[0]
valorcliente = row[1]
print nomecliente
print valorcliente
try:
existe = frappe.get_doc("Customer", nomecliente)
except frappe.DoesNotExistError:
print "Cliente ", unicode(
nomecliente.strip()), " nao existe"
print existe.name == nomecliente
if (existe.name == nomecliente):
doc = {
"company":
"AngolaERP",
"conversion_rate":
1.0,
"currency":
"KZ",
"customer":
nomecliente,
"customer_name":
nomecliente,
"debit_to":
"31121000-Clientes Nacionais - CF",
"docstatus":
0,
"doctype":
"Sales Invoice",
"due_date":
frappe.utils.nowdate(),
"is_opening":
"Yes",
"is_pos":
0,
"is_recurring":
0,
"is_return":
0,
"items": [{
"cost_center": "Main - CF",
"item_code": "BFWDB",
"qty": 1.0,
"rate": flt(valorcliente)
}],
"status":
"Draft",
"submit_on_creation":
0,
"taxes": [{
"account_head":
"34210000-Imposto De Producao E Consumo - CF",
"charge_type": "On Net Total",
"cost_center": "Main - CF",
"description": "IPC %10",
"included_in_print_rate": 0,
"rate": 10.0
}],
"taxes_and_charges":
"Imposto de Consumo"
}
print doc
x = client.session.post(
"http://127.0.0.1:8000/api/resource/Sales Invoice",
data={"data": json.dumps(doc)})
print x
client.logout()
