def post(self):
parser = reqparse.RequestParser()
args = OffboardingSheet.parser.parse_args()
val = args['Products']
value = json.loads(val)
id_employ = args['id_employee']
#id_employee = json.loads(id_employ)
#requ_id = args['requesterid']
#requester_id = json.loads(requ_id)
sheet_signature = SignatureSheetModel.get_last_sheet(id_employ)
id_ss = sheet_signature.json()
signature_sheet_id = id_ss['id_signature']
onboarding_date = SignatureSheetModel.get_onboarding(id_employ)
if onboarding_date:
onboarding_date_json = onboarding_date.json()
onboarding_date__ = onboarding_date_json['updated']
else:
onboarding_date__ = "0000-00-00"
ref = []
canvas = CreatePDF()
relationship = AssetRelationships()
pdf_name = str(signature_sheet_id) + str(id_employ)
#signature_sheet_id = id_ss['id_signature']
#hacer un insert primero y luego llamar aqui el query para conseguir la hoja
#for x in value:
#print(x)
for prod in value:
#print(prod['ciid'])
#val = relationship.createRelationship(requ_id, prod['CIID'])
val = relationship.DeleteRelationship(id_employ, prod['ciid'])
#-----
print(val)
if (val == "Done"):
sp = SignatureProductsModel(signature_sheet_id,
prod['id_product'],
prod['product_name'],
prod['serial_number'],
prod['model'], prod['ciid'])
try:
sp.insert()
print("product inserted")
except:
return {'message': 'Row could not be inserted'}
print("item not inserted")
canvas.createTemplate(signature_sheet_id, ref, id_ss, pdf_name, value,
onboarding_date__)
path = pdf_name + ".pdf"
return {'message': 'done'}
def get(self):
"""Return all the signature sheets in the db"""
page = 1
per_page = 10
sheet = SignatureSheetModel.get_last_date()
records = SignatureSheetModel.query.order_by(
SignatureSheetModel.id_signature.desc()).limit(per_page).offset(
(page - 1) * per_page)
if records:
return {'SignatureSheets': list(map(lambda x: x.json(), records))}
return {'message': 'Nothing found'}
def get(self, id_employee):
"""Function that use the signature id (FK) as param, and return all the product list of the sheet"""
#ojo aqui
sheet_signature = SignatureSheetModel.get_last_id(id_employee)
id_ss = sheet_signature.json()
signature_sheet_id = id_ss['id_signature']
print("## Ultima Hoja ##")
print(signature_sheet_id)
prod = SignatureProductsModel.find_by_id(signature_sheet_id)
print(signature_sheet_id)
if prod:
return {'SignatureSheetsProducts': list(map(lambda x: x.json(), prod ))}
return {'message': 'Nothing Found'}
def post(self, args):
updated = args.get('updated', None)
id_type = args.get('id_type', None)
id_employee = args.get('id_employee', None)
first_name = args.get('first_name', None)
last_name = args.get('last_name', None)
email = args.get('email', None)
date = datetime.datetime.now()
#data = SignatureSheets.parser.parse_args()
if updated:
sheet = SignatureSheetModel(updated, id_type, id_employee,
first_name, last_name, email, 1, 1,
"504-xxxx-xxxx")
else:
sheet = SignatureSheetModel(date, id_type, id_employee, first_name,
last_name, email, 1, 1,
"504-xxxx-xxxx")
try:
sheet.insert()
return {'message': 'Signature Sheet correctly inserted'}
except:
return {'message': "something wrong probably item already exist"}
def post(self):
"""Function that Insert Products in the table, also create an create Realtionship object to make the changes in the asset Database"""
parser = reqparse.RequestParser()
args = SignatureProducts.parser.parse_args()
val = args['Products']
value = json.loads(val)
id_employ = args['id_employee']
id_employee = json.loads(id_employ)
requ_id = args['requesterid']
requester_id = json.loads(requ_id)
#poner un try
sheet_signature = SignatureSheetModel.get_last_sheet(id_employ)
id_ss = sheet_signature.json()
signature_sheet_id = id_ss['id_signature']
print('########################################################################')
print(signature_sheet_id)
print('########################################################################')
relationship = AssetRelationships()
print(value)
c = 0
for prod in value:
#print(prod['ciid'])
val = relationship.createRelationship(requ_id, prod['CIID'])
# print(prod['CIID'])
#-----
print('val' + val)
if(val == "Done" ):
sp = SignatureProductsModel(signature_sheet_id, prod['PRODUCT_CODE'], prod['CI_NAME'] , prod['SERIAL_NUMBER'], prod['MODEL'], prod['CIID'])
try:
sp.insert()
c = c+1
print("product inserted")
print(c)
except:
x = []
print("item not inserted")
for prod in value:
val = relationship.DeleteRelationship(id_employ,prod['CIID'])
productsSig = SignatureProductsModel.query.filter(SignatureProductsModel.id_signature == signature_sheet_id).all()
if productsSig:
x = list(map(lambda x: x.json(),productsSig))
for prod in x:
#sp = SignatureProductsModel(signature_sheet_id, prod['id_product'], prod['product_name'] , prod['serial_number'], prod['model'], prod['ciid'])
sp = SignatureProductsModel.query.filter(SignatureProductsModel.id == prod['id']).first()
sp.delete_item()
sheet = SignatureSheetModel.query.filter(SignatureSheetModel.id_signature == signature_sheet_id).first()
if sheet:
print('Deleting sheet')
sheet.delete_item()
return{'message': 'Row could not be inserted'}
#rolback
if(val != "Done"):
x = []
print("item not inserted")
for prod in value:
val = relationship.DeleteRelationship(id_employ,prod['CIID'])
productsSig = SignatureProductsModel.query.filter(SignatureProductsModel.id_signature == signature_sheet_id).all()
if productsSig:
x = list(map(lambda x: x.json(),productsSig))
for prod in x:
#sp = SignatureProductsModel(signature_sheet_id, prod['id_product'], prod['product_name'] , prod['serial_number'], prod['model'], prod['ciid'])
sp = SignatureProductsModel.query.filter(SignatureProductsModel.id == prod['id']).first()
sp.delete_item()
sheet = SignatureSheetModel.query.filter(SignatureSheetModel.id_signature == signature_sheet_id).first()
if sheet:
sheet.delete_item()
print("Borrar hoja")
return{'message': 'Row could not be inserted'}
print('onboarding date')
##hacer un if que traiga la fehca de la hoja tipo get onboarding
try:
if id_ss['id_type'] != 3:
onboarding_date = SignatureSheetModel.get_onboarding(id_employ)
if onboarding_date:
onboarding_date_json = onboarding_date.json()
onboarding_date__ = onboarding_date_json['updated']
else:
onboarding_date__ = "0000-00-00"
else:
onboarding_date = SignatureSheetModel.get_return_day(signature_sheet_id)
if onboarding_date:
onboarding_date_json = onboarding_date.json()
onboarding_date__ = onboarding_date_json['updated']
except:
onboarding_date__ = "0000-00-00"
#print(onboarding_date__)
#---Pendiente cambiar los nombres.
ref = []
canvas = CreatePDF()
pdf_name = str(signature_sheet_id) + str(id_employee)
#print(pdf_name)
#print('up')
#canvas.createTemplate(signature_sheet_id, value, id_employee, pdf_name)
canvas.createTemplate(signature_sheet_id, value, id_ss, pdf_name, ref , onboarding_date__)
path = pdf_name + ".pdf"
return {'message': 'done'}
def put(self, id_employee):
parser = reqparse.RequestParser()
#args = Signatureproduct.parser.parse_args()
args = Signatureproduct.parser.parse_args()
pr = args['Products_to_remove']
product_to_remove = json.loads(pr)
pa = args['Products_to_add']
product_to_add = json.loads(pa)
cp = args['current_products']
current_products = json.loads(cp)
us = args['user_info']
user_info = json.loads(us)
ty = args['type']
_type = json.loads(ty)
ref = []
for prod in current_products:
ref.append(prod)
for prod in current_products:
for prod2 in product_to_remove:
if(prod['ciid'] == prod2['ciid']):
ref.remove(prod)
relationship = AssetRelationships()
for x in product_to_remove:
val = relationship.DeleteRelationship(id_employee, x['ciid'])
requ_id = user_info[0]
sheet_signature = SignatureSheetModel.get_last_sheet(id_employee)
id_ss = sheet_signature.json()
signature_sheet_id = id_ss['id_signature']
onboarding_date = SignatureSheetModel.get_onboarding(id_employee)
if onboarding_date:
onboarding_date_json = onboarding_date.json()
onboarding_date__ = onboarding_date_json['updated']
else:
onboarding_date__ = "0000-00-00"
for prod in product_to_add:
print(".................")
val = relationship.createRelationship(requ_id['CIID'], prod['CIID'])
if(val == "Done" ):
sp = SignatureProductsModel(signature_sheet_id, prod['PRODUCT_CODE'], prod['CI_NAME'] , prod['SERIAL_NUMBER'], prod['MODEL'], prod['CIID'])
try:
sp.insert()
except:
return{'message': 'Row could not be inserted'}
for prod in ref:
sp = SignatureProductsModel(signature_sheet_id, prod['id_product'], prod['product_name'] , prod['serial_number'], prod['model'], prod['ciid'])
try:
sp.insert()
except:
return{'message': 'row could not be inserted'}
canvas = CreatePDF()
pdf_name = str(signature_sheet_id) + str(id_employee)
#canvas.createTemplate(signature_sheet_id, value, id_employee, pdf_name)
canvas.createTemplate(signature_sheet_id, product_to_add, id_ss, pdf_name, ref, onboarding_date__ )
path = pdf_name + ".pdf"
return {'message': 'done'}