def remove(self):
deletedevices = conexion.Add(
'delete from devices where environment = %s', [self.id])
deleteClient = conexion.Add(
"delete from clients where enviroment = %s", [self.id])
delete = conexion.Add("delete from bridge where id_environments = %s",
[self.id])
deleteEnv = conexion.Add("delete from environments where id = %s",
[self.id])
def delete_client(self):
cmm1 = conexion.Add(
"delete from devices where (environment = %s and client = %s)",
[self.enviroment, self.identification])
cmm2 = conexion.Add(
"delete from clients where (enviroment = %s and identification = %s)",
[self.enviroment, self.identification])
if cmm1:
return 'Ok'
def create(self):
now = datetime.datetime.now() - datetime.timedelta(hours=5)
insert = conexion.Add(
"insert into environments (img,name,key_code,creation_date,created_by) values (%s,%s,%s,%s,%s)",
[self.img, self.name, self.key_code, now, self.created_by])
consult = conexion.search(
"select id from environments where key_code = %s", [self.key_code])
insert2 = conexion.Add(
"insert into bridge (id_user,id_environments,v_admin,linking_date,state) values (%s,%s,%s,%s,%s)",
[self.created_by, consult[0][0], 1, now, 1])
def remove_sevice(self):
now = datetime.now()
cmm = conexion.Add(
"update devices set status = %s , departure_date = %s where (id = %s and environment = %s)",
[self.status, now, self.id, self.enviroment])
if cmm:
return 'Ok'
def change_status(self):
now = datetime.now()
cmm = conexion.Add(
"update devices set status = %s, start_process = %s, process_start_date = %s where id = %s and environment = %s",
[self.status, self.user, now, self.id, self.enviroment])
if cmm:
return 'Ok'
def modification_pass(self):
now = datetime.now()
respuesta = conexion.Add(
'update users set password = %s, recovery_date = %s where code = %s',
[self.password, now, self.code])
if respuesta:
return 'Ok'
def create_user(self):
respuesta = conexion.Add(
"insert into users (name,surname,email,password,img,activated,code) values (%s,%s,%s,%s,%s,%s,%s);",
[
self.name, self.surname, self.email, self.password,
"https://firebasestorage.googleapis.com/v0/b/datafilter-32b92.appspot.com/o/profile%2Fpngegg.png?alt=media&token=3f31a154-ef66-487c-abfd-962b3c349e88",
0, self.code
])
def add_client(self):
cmm = conexion.Add(
"insert into Clients (id,enviroment,email,name,surname,phone,address) values (%s,%s,%s,%s,%s,%s,%s)",
[
self.id, self.enviroment, self.email, self.name, self.surname,
self.phone, self.address
])
if cmm:
return 'Ok'
def save_info_repair(self):
cmm = conexion.Add(
"update devices set failure = %s, diagnosis = %s, solution = %s where (id = %s and environment = %s)",
[
self.failure, self.diagnosis, self.solution, self.id,
self.enviroment
])
if cmm:
return 'Ok'
def edit_client(self):
cmm = conexion.Add(
"update clients set name = %s, surname = %s, email = %s, phone = %s, address = %s where (enviroment = %s and identification = %s)",
[
self.name, self.surname, self.email, self.phone, self.address,
self.enviroment, self.identification
])
if cmm:
return 'Ok'
def search_clients(self):
data = {}
data['clients'] = []
cmm = conexion.Add("select * from Clients where (enviroment = %s and id = %s)",[self.enviroment, self.id])
if(cmm):
for i in cmm:
data['clients'].append({'id':i[0],'enviroment':i[1],'email':i[2],'name':i[3],'surname':i[4],'phone':i[5],'address':i[6]})
return data['clients']
else:
return None
def edit_device(self):
cmm = conexion.Add(
'update devices set type = %s, model = %s, brand = %s, serial = %s, accessories = %s, conditions = %s, work_to_do = %s where id = %s',
[
self.device, self.model, self.brand, self.serial,
self.accessories, self.condition, self.work_to_do, self.id
])
if (cmm):
return cmm
else:
return None
def add_device(self):
now = datetime.now()
cmm = conexion.Add(
"insert into devices (client,environment,user,type,model,brand,serial,accessories,conditions,work_to_do,status,admission_date) values (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)",
[
self.client, self.enviroment, self.user, self.device,
self.model, self.brand, self.serial, self.accessories,
self.condition, self.work_to_do, 1, now
])
if cmm:
return 'Ok'
def send_email_recover(self):
respuesta = conexion.search(
'select name,email from users where email = %s', [self.email])
if respuesta:
for i in respuesta:
now = datetime.now() + timedelta(hours=24)
resp = conexion.Add(
'update users set code=%s, recovery_date= %s where email = %s',
[self.code, now, self.email])
return i[0]
else:
return None
def manage_user_join_by_Code(self):
now = datetime.now()
data = {}
data['manage'] = []
consult1 = conexion.search('select count(*) from bridge b, users u, environments e where b.id_user = u.id and b.id_environments = e.id and e.key_code = %s and b.id_user = %s',[self.key_code,self.id])
if(consult1[0][0] != 0):
return "stError"
else:
consult = conexion.search('select id from environments where key_code = %s',[self.key_code])
if(consult):
consult2 = conexion.Add('insert into bridge (id_user,id_environments,v_admin,linking_date,state) values (%s,%s,%s,%s,%s)',[int(self.id),int(consult[0][0]),0,now,1])
else:
return "stError101"
def check_repair(self):
now = datetime.now()
cmm = conexion.search(
"select failure,diagnosis,solution from devices where (id = %s and environment = %s)",
[self.id, self.enviroment])
if (self.status == 3):
if (cmm[0][0] != None and cmm[0][1] != None and cmm[0][2] != None):
if ((len(cmm[0][0]) != 0) and (len(cmm[0][1]) != 0)
and (len(cmm[0][2]) != 0)):
cod = conexion.Add(
"update devices set status = %s,finish_date = %s where (id = %s and environment = %s)",
[self.status, now, self.id, self.enviroment])
return "success"
else:
return 'error3'
else:
return 'error3'
def edit_name(self):
update = conexion.Add(
'update users set name = %s, surname = %s where id = %s',
[self.name, self.surname, self.id])
if update:
return 'Ok'
def save_picture(self):
update = conexion.Add("update users set img = %s where id = %s",
[self.img, self.id])
return 'Ok'
def manage_change_status(self):
update = conexion.Add("update bridge set state = %s where id = %s",
[self.state, self.id])
return None
def main_register_client(self, identification, env, name, surname, email,
phone, address):
create = conexion.Add(
'insert into clients (identification,enviroment,name,surname,email,phone,address) values (%s,%s,%s,%s,%s,%s,%s)',
[identification, env, name, surname, email, phone, address])
return None
def activated_account(self):
respuesta = conexion.Add(
'update users set activated = %s where code = %s',
[self.activated, self.code])
def contact_us(self):
cmm = conexion.Add(
"insert into contact_information (name,email,message,viewed) values (%s,%s,%s,%s)",
[self.name, self.email, self.message, self.viewed])
if cmm:
return 'Ok'
def change_password(self):
update = conexion.Add('update users set password = %s where id = %s',
[self.password, self.id])
if update:
return 'Ok'
def manega_users_remove(self):
consult = conexion.Add("delete from bridge where id = %s", [self.id])
return consult
def delete(self):
cmm = conexion.Add(
"delete from devices where id = %s and environment = %s",
[self.id, self.enviroment])
if cmm:
return 'Ok'
