def update(id:int):
company_id = session["user"]["company_id"]
### check existing customer
if not db.is_existing(table="customers", conditions={"id":id, "company_id": company_id}):
return jsonify(info="Customer not found"),404
req = request.get_json(force=True)
req = Customer.parse(req, "update")
if "errors" in req:
return jsonify(errors=req["errors"]),400
req = req["customer"]
customer = {}
#name
if "name" in req:
if db.is_existing(table="customers", conditions={"name":req["name"],"company_id": company_id}):
return jsonify(info="Customer with the same name already exists"),400
customer["name"] = req["name"]
#address
if "address" in req:
customer["address"] = req["address"]
#location
if "location" in req :
customer["location_lat"] = req["location"]["lat"]
customer["location_lng"] = req["location"]["lng"]
#phone
if "phone" in req:
customer["phone"] = req["phone"]
db.update(table="customers", params=customer, conditions={"id":id})
return jsonify(info="Customer data updated successfully"),200
def create():
req = request.get_json(force=True)
customer = Customer.parse(req, "create")
if "errors" in customer:
return jsonify(errors=customer["errors"]),400
customer = customer["customer"]
### check customer name duplication
company_id = session["user"]["company_id"]
if db.is_existing(table="customers",
conditions={"name":customer["name"], "company_id":company_id}):
return jsonify(info="Customer with the same name already exist"),400
# record customer
data = {
"name" : customer["name"],
"address" : customer["address"],
"location_lat" : customer["location"]["lat"],
"location_lng" : customer["location"]["lng"],
"phone" : customer["phone"],
"company_id" : company_id
}
customerId= db.insert(table="customers", params=data)
return jsonify(info="Customer created successfully", customerId=customerId),200