def base_datos():
import StringIO
import os
right_version = right_firefox_version(request.env.http_user_agent)
if not "archivos" in session.keys():
session.archivos = []
form = SQLFORM.factory(submit_button='Enviar')
if form.accepts(request.vars, session):
response.flash = 'Procesando datos, espere'
#borrando = form.vars.principiocurso
if len(session.archivos) > 0:
import pdb
lista_completa = []
#SQLite=SQLiteConnection()
#SQLite.define_tables()
#dbcontrolies = SQLite.getDB()
#result = db.executesql(sql)
for archivo in session.archivos:
f = open(archivo)
linea = f.readline()
last_id = ""
while linea:
if linea != '\n' and linea != '':
linea = linea.split(",")
# Datos del portatil
serial_number = linea[1].replace("'", "")
id_trademark = linea[2]
laptop = Laptops(cdb, "", serial_number, id_trademark)
if not laptop.existsSerialNumber(laptop.serial_number):
laptop.add()
last_id = laptop.getIdbySerialNumber(
laptop.serial_number)
if last_id:
# Datos del registro historico
id_laptop = last_id
username = linea[9].replace("'", "")
name = linea[10].replace("'", "")
id_user_type = linea[6]
nif = linea[5].replace("'", "")
id_state = linea[8]
laptopshistory = LaptopsHistory(
cdb, "", id_laptop, id_state, id_user_type,
nif, username, name, "")
laptopshistory.add()
#dbcontrolies.laptops_historical.insert (**attributes)
linea = f.readline()
response.flash = T('Ficheros importados correctamente')
session.archivos = []
return dict(form=form, right_version=right_version)
def modifySerialNumber():
serialNumber = request.vars["serial_number"].strip()
if serialNumber=="":
response = "unassignment"
else:
l = Laptops(cdb,"","","","","","","","")
id_laptop = l.existsSerialNumber(serialNumber)
response=""
if not id_laptop:
response = "not_exists"
else:
lh = LaptopsHistory(cdb,"",id_laptop,"","","","","","")
data = lh.getLastHistory()
if data["username"]!="" and data["username"]!=request.vars['id']:
response = "already_assigned"
elif data["username"]!="" and data["username"]==request.vars['id']:
response = "OK"
else:
userData = getUserData(request.vars["id"])
lh = LaptopsHistory(cdb,"",id_laptop,"2","2",userData["nif"],request.vars["id"],userData["name"],"Reasignado")
lh.add()
response="OK"
return dict(response=response)
def base_datos():
import StringIO
import os
right_version=right_firefox_version(request.env.http_user_agent)
if not "archivos" in session.keys():
session.archivos=[]
form=SQLFORM.factory(submit_button='Enviar')
if form.accepts(request.vars, session):
response.flash = 'Procesando datos, espere'
#borrando = form.vars.principiocurso
if len(session.archivos)>0:
import pdb
lista_completa=[]
#SQLite=SQLiteConnection()
#SQLite.define_tables()
#dbcontrolies = SQLite.getDB()
#result = db.executesql(sql)
for archivo in session.archivos:
f = open(archivo)
linea = f.readline()
last_id = ""
while linea:
if linea!= '\n' and linea != '':
linea = linea.split(",")
# Datos del portatil
serial_number = linea[1].replace("'","")
id_trademark = linea[2]
laptop = Laptops (cdb,"",serial_number, id_trademark)
if not laptop.existsSerialNumber (laptop.serial_number):
laptop.add ()
last_id = laptop.getIdbySerialNumber (laptop.serial_number)
if last_id:
# Datos del registro historico
id_laptop = last_id
username = linea [9].replace("'","")
name = linea [10].replace("'","")
id_user_type = linea [6]
nif = linea [5].replace("'","")
id_state = linea [8]
laptopshistory = LaptopsHistory (cdb, "", id_laptop, id_state, id_user_type, nif, username, name, "")
laptopshistory.add ()
#dbcontrolies.laptops_historical.insert (**attributes)
linea = f.readline()
response.flash = T('Ficheros importados correctamente')
session.archivos=[]
return dict(form=form,right_version=right_version)
def reassignmentSerialNumber():
serialNumber = request.vars["serial_number"].strip()
newSerialNumber = request.vars["newSerial"].strip()
l = Laptops(cdb,"","","","","","","","")
if serialNumber!="":
id_laptop = l.existsSerialNumber(serialNumber)
unassignmentLaptop(id_laptop)
if newSerialNumber!="":
userData = getUserData(request.vars["username"])
id_laptop = l.existsSerialNumber(newSerialNumber)
lh = LaptopsHistory(cdb,"",id_laptop,"2","2",userData["nif"],request.vars["username"],userData["name"],"Reasignado")
lh.add()
return dict(response="OK")