def post(self):
try:
data = request.json
connector.collection('employee').insert_one(data)
return jsonify({'success': True, 'message': 'success!'})
except:
return jsonify({'success': False, 'message': 'error!'})
def post(self):
try:
data = request.json
connector.collection('service').insert_one(data)
return jsonify({'message': 'success', 'status': True})
except:
return jsonify({'message': 'error', 'status': False})
def delete(self, id):
try:
where = {'_id': ObjectId(id)}
value = {'$set': {'status': False}}
connector.collection('employee').update_one(where, value)
return jsonify({'success': True, 'message': 'success!'})
except:
return jsonify({'success': False, 'message': 'error!'})
def delete(self, id):
try:
where = {'_id': ObjectId(id)}
value = {'$set': {'delived': True}}
connector.collection('service').update_one(where, value)
return jsonify({'message': 'success', 'status': True})
except:
return jsonify({'message': 'error', 'status': False})
def put(self, id):
try:
data = request.json
where = {'_id':ObjectId(id)}
value = {'$set':{'username':data['username'],
'password':data['password'],
'role':data['role']}}
connector.collection('user').update_one(where, value)
return jsonify({'message':'success', 'status':True})
except:
return jsonify({'message':'error', 'status':False})
def put(self, id):
try:
data = request.json
where = {'_id':ObjectId(id)}
value = {'$set':{'client':data['client'],
'brand':data['brand'],
'model':data['model'],
'year':data['year'],
'milage':data['milage'],
'cilinder':data['cilinder'],
'colour':data['colour'],
'transmision':data['transmision']}}
connector.collection('automobile').update_one(where, value)
return jsonify({'success':True, 'message':'success!'})
except:
return jsonify({'success':False, 'message':'error!'})
def get(self):
try:
document = connector.collection('service').find({'status':True})
employee = []
amount = []
data = []
for item in document:
if not self.in_list(employee, item['employee']):
employee.append(item['employee'])
for item in employee:
get = connector.collection('service').find({'employee':item})
amount.append(get.count())
data.append({'data':amount})
return jsonify({'success':True, 'message':'success', 'data':data, 'employee':employee})
except:
return jsonify({'success':False, 'message':'error!'})
def get(self):
try:
document = connector.collection('automobile').find({'status':True})
brands = []
data = []
for item in document:
if not self.in_list(brands, item['brand']):
brands.append(item['brand'])
for item in brands:
one = connector.collection('automobile').find({'brand':item, 'transmision':'Automatico'})
two = connector.collection('automobile').find({'brand':item, 'transmision':'Automatizadas o secuenciales'})
thr = connector.collection('automobile').find({'brand':item, 'transmision':'Automatizada de doble embrague'})
fou = connector.collection('automobile').find({'brand':item, 'transmision':'CVT'})
data.append({'data':[one.count(), two.count(), thr.count(), fou.count()],'label':item})
return jsonify({'success':True, 'message':'success', 'data':data})
except:
return jsonify({'success':False, 'message':'error!'})
def get(self, username, password):
try:
document = connector.collection('user').find_one({"username":username, "password":password, 'status':True})
data = {'id':str(document['_id']),
'username':document['username'],
'password':document['password'],
'role':document['role'],
'status':document['status']}
return jsonify({'message':'success', 'status':True, 'data':data})
except:
return jsonify({'message':'error', 'status':False})
def get(self, id):
try:
document = connector.collection('user').find_one({'_id':ObjectId(id)})
data = {'id':str(document['_id']),
'username':document['username'],
'password':document['password'],
'role':document['role'],
'status':document['status']}
response = {'message':'success', 'status':True, 'data':data}
return jsonify(response)
except:
return jsonify({'message':'error', 'status':False})
def get(self):
try:
ListA = []
ListB = []
data = []
document = connector.collection('automobile').find({'status':True})
for item in document:
ListA.append(int(item['year']))
document = connector.collection('automobile').find({'status':True})
for item in document:
ListB.append(int(item['cilinder']))
data.append(self.correlation(ListA, ListA))
document = connector.collection('automobile').find({'status':True})
for item in document:
ListA.append(int(item['milage']))
document = connector.collection('automobile').find({'status':True})
for item in document:
ListB.append(int(item['cilinder']))
data.append(self.correlation(ListA, ListA))
document = connector.collection('automobile').find({'status':True})
for item in document:
ListA.append(int(item['milage']))
document = connector.collection('automobile').find({'status':True})
for item in document:
ListB.append(int(item['year']))
data.append(self.correlation(ListA, ListA))
label = ['Año-Cilindraje', 'Kilometraje-Cilindraje', 'Kilometraje-Año']
return jsonify({'success':True, 'message':'success', 'data':data, 'label':label})
except:
return jsonify({'success':False, 'message':'error!'})
def put(self, id):
try:
data = request.json
where = {'_id': ObjectId(id)}
value = {
'$set': {
'name': data['name'],
'address': data['address'],
'nss': data['phone'],
'rfc': data['rfc'],
'curp': data['curp'],
'phone': data['phone'],
'email': data['email'],
'birthDate': data['birthDate'],
'salary': data['salary'],
'role': data['role']
}
}
connector.collection('employee').update_one(where, value)
return jsonify({'success': True, 'message': 'success!'})
except:
return jsonify({'success': False, 'message': 'error!'})
def get(self):
try:
document = connector.collection('user').find({'status':True})
data = []
for field in document:
data.append({'id':str(field['_id']),
'username':field['username'],
'password':field['password'],
'role':field['role'],
'status':field['status']})
response = {'message':'success', 'status':True, 'data':data}
return jsonify(response)
except:
return jsonify({'message':'error', 'status':False})
def get(self, id):
try:
document = connector.collection('automobile').find_one({'_id':ObjectId(id)})
data = {'id':str(document['_id']),
'client':document['client'],
'brand':document['brand'],
'model':document['model'],
'year':document['year'],
'milage':document['milage'],
'cilinder':document['cilinder'],
'colour':document['colour'],
'transmision':document['transmision'],
'status':document['status']}
response = {'success':True, 'message':'success!', 'data':data}
return jsonify(response)
except:
return jsonify({'success':False, 'message':'error!'})
def get(self, id):
try:
document = connector.collection('service').find_one(
{'_id': ObjectId(id)})
data = {
'id': str(document['_id']),
'auto': document['auto'],
'employee': document['employee'],
'entreDate': document['entreDate'],
'endedDate': document['endedDate'],
'description': document['description'],
'delived': field['delived'],
'finished': field['finished'],
'status': document['status']
}
response = {'message': 'success', 'status': True, 'data': data}
return jsonify(response)
except:
return jsonify({'message': 'error', 'status': False})
def get(self, id):
try:
document = connector.collection('automobile').find({'client':id})
data = []
for field in document:
data.append({'id':str(field['_id']),
'client':field['client'],
'brand':field['brand'],
'model':field['model'],
'year':field['year'],
'milage':field['milage'],
'cilinder':field['cilinder'],
'colour':field['colour'],
'transmision':field['transmision'],
'status':field['status']})
response = {'success':True, 'message':'success!', 'data':data}
return jsonify(response)
except:
return jsonify({'success':False, 'message':'error!'})
def get(self):
try:
document = connector.collection('service').find({'status': True})
data = []
for field in document:
data.append({
'id': str(field['_id']),
'auto': field['auto'],
'client': field['client'],
'employee': field['employee'],
'entreDate': field['entreDate'],
'endedDate': field['endedDate'],
'description': field['description'],
'delived': field['delived'],
'finished': field['finished'],
'status': field['status']
})
response = {'message': 'success', 'status': True, 'data': data}
return jsonify(response)
except:
return jsonify({'message': 'error', 'status': False})
def get(self, id):
try:
document = connector.collection('employee').find_one(
{'_id': ObjectId(id)})
data = {
'id': str(document['_id']),
'name': document['name'],
'address': document['address'],
'nss': document['phone'],
'rfc': document['rfc'],
'curp': document['curp'],
'phone': document['phone'],
'email': document['email'],
'birthDate': document['birthDate'],
'salary': document['salary'],
'role': document['role'],
'status': document['status']
}
response = {'success': True, 'message': 'success!', 'data': data}
return jsonify(response)
except:
return jsonify({'success': False, 'message': 'error!'})
def get(self):
try:
document = connector.collection('employee').find({'status': True})
data = []
for field in document:
data.append({
'id': str(field['_id']),
'name': field['name'],
'address': field['address'],
'nss': field['phone'],
'rfc': field['rfc'],
'curp': field['curp'],
'phone': field['phone'],
'email': field['email'],
'birthDate': field['birthDate'],
'salary': field['salary'],
'role': field['role'],
'status': field['status']
})
response = {'success': True, 'message': 'success!', 'data': data}
return jsonify(response)
except:
return jsonify({'success': False, 'message': 'error!'})
import math
# Connector to MongoDB
from Connector import connector
# ListA = [85, 80, 83, 70, 81, 65, 64, 72, 69, 75, 75, 72, 81, 71]
# ListB = [85, 90, 86, 96, 80, 70, 65, 95, 70, 80, 70, 81, 75, 91]
ListA = []
ListB = []
document = connector.collection('automobile').find({'status': True})
for item in document:
ListA.append(int(item['year']))
print(ListA)
document = connector.collection('automobile').find({'status': True})
for item in document:
ListB.append(int(item['cilinder']))
print(ListB)
def Media(Lista):
Total = 0
for Elemento in Lista:
Total += Elemento
return Total / len(Lista)
def DesviacionEstandar(Lista, Media):
i = 0
Total = 0
def get(self):
try:
connector.collection('automobile').find({'status':True})
return jsonify({'success':True, 'message':'success'})
except:
return jsonify({'success':False, 'message':'error!'})
