def get(self):
schema = PaymentTypeSchema(many=True)
if request.args.get("uuid"):
query = PaymentType.query.filter_by(uuid=request.args.get("uuid"))
else:
query = PaymentType.query
return paginate(query.order_by(PaymentType.uuid.asc()), schema)
def get(self):
schema = LocalPurchaseOrderSchema(many=True)
if request.args.get("uuid") and request.args.get("tran_type"):
query = LocalPurchaseOrder.query.filter_by(
entity_id=request.args.get("uuid"),
tran_type=request.args.get("tran_type"),
)
elif request.args.get("uuid"):
vendor = Vendor.get(uuid=request.args.get("uuid"))
if vendor:
query = LocalPurchaseOrder.query.filter_by(
credit=vendor.account.id)
else:
query = LocalPurchaseOrder.query.filter_by(
entity_id=request.args.get("uuid"))
elif request.args.get("reference"):
query = LocalPurchaseOrder.query.filter_by(
reference=request.args.get("reference"))
elif request.args.get("code"):
query = LocalPurchaseOrder.query.filter_by(
uuid=request.args.get("code"))
elif request.args.get("entity") is not None:
query = LocalPurchaseOrder.query.filter_by(
entity_id=request.args.get("entity"))
else:
query = LocalPurchaseOrder.query
query = query.order_by(LocalPurchaseOrder.date_created.desc())
return paginate(query, schema)
def get(self):
schema = ChargeSchema(many=True)
chargecode = request.args.get("code")
amount = request.args.get("amount")
if chargecode and amount:
# query = get_charge(chargecode, amount)
query = Charge.query.filter(
and_(
Charge.code == chargecode,
Charge.min_value <= amount,
Charge.max_value >= amount,
)).first()
app.logger.info(query.amount)
if query.charge_type == "percentage":
charge_fee = (int(query.amount) / 100) * int(amount)
response = {"charge": charge_fee}
else:
response = {"charge": query.amount}
return json.dumps(response), 207
elif chargecode:
query = Charge.query.filter_by(code=chargecode)
else:
query = Charge.query
return paginate(query, schema)
def get(self):
schema = EntitySchema(many=True)
if request.args.get("uuid") is not None:
uuid = request.args.get("uuid")
query = Entity.query.filter_by(uuid=uuid)
else:
query = Entity.query
return paginate(query.order_by(Entity.id.desc()), schema)
def get(self):
schema = VehicleSchema(many=True)
if request.args.get("customer") is not None:
query = Vehicle.query.filter_by(
customer_id=request.args.get("customer"))
else:
query = Vehicle.query
return paginate(query, schema)
def get(self):
schema = TarriffSchema(many=True)
tarriffcode = request.args.get("code")
if tarriffcode is not None:
query = Tarriff.query.filter_by(uuid=tarriffcode)
else:
query = Tarriff.query
return paginate(query, schema)
def get(self):
schema = ServiceSchema(many=True)
servicecode = request.args.get("code")
if servicecode is not None:
query = Service.query.filter_by(uuid=servicecode)
else:
query = Service.query
return paginate(query, schema)
def get(self):
schema = ItemCategorySchema(many=True)
if request.args.get("entity") is not None:
query = ItemCategory.query.filter_by(
entity_id=request.args.get("entity"))
else:
query = ItemCategory.query
return paginate(query, schema)
def get(self):
schema = RoleSchema(many=True)
if request.args.get("category") is not None:
category = request.args.get("category")
query = Role.query.filter_by(category=category)
else:
query = Role.query
return paginate(query, schema)
def get(self):
schema = TransactionTypeSchema(many=True)
if request.args.get("uuid") is not None:
uuid = request.args.get("uuid")
query = TransactionType.query.filter_by(uuid=uuid)
else:
query = TransactionType.query
return paginate(query, schema)
def get(self):
schema = WorkItemSchema(many=True)
code = request.args.get('code')
request.args.get('amount')
if code:
query = WorkItem.query.filter_by(request_id=code)
else:
query = WorkItem.query
return paginate(query, schema)
def get(self):
schema = LpoItemSchema(many=True)
code = request.args.get("code")
amount = request.args.get("amount")
if code:
query = LpoItem.query.filter_by(order_id=code)
else:
query = LpoItem.query
return paginate(query, schema)
def get(self):
schema = EmployeeTypeSchema(many=True)
if request.args.get("entity") is not None:
company = request.args.get("entity")
query = EmployeeType.query.filter_by(entity_id=company)
elif request.args.get("uuid") is not None:
uuid = request.args.get("uuid")
query = EmployeeType.query.filter_by(uuid=uuid)
else:
query = EmployeeType.query
return paginate(query, schema)
def get(self):
schema = UserSchema(many=True)
if request.args.get("username") is not None:
username = request.args.get("username")
query = User.query.filter_by(username=username)
elif request.args.get("company") is not None:
company = request.args.get("company")
query = User.query.filter_by(company_id=company)
else:
query = User.query
return paginate(query.order_by(User.id.desc()), schema)
def get(self):
schema = AccountSchema(many=True)
if request.args.get("owner") is not None:
query = Account.query.filter_by(owner_id=request.args.get("owner"))
elif request.args.get("type") is not None:
query = Account.query.filter_by(acc_type=request.args.get("type"))
elif request.args.get("uuid") is not None:
query = Account.query.filter_by(uuid=request.args.get("uuid"))
elif request.args.get("entity") is not None:
query = Account.query.filter_by(group=request.args.get("entity"))
else:
query = Account.query
return paginate(query, schema)
def get(self):
schema = CustomerSchema(many=True)
if request.args.get("entity") and request.args.get("phone"):
query = Customer.query.filter_by(
entity_id=request.args.get("entity"),
phone=request.args.get("phone"))
elif request.args.get("entity") is not None:
query = Customer.query.filter_by(
entity_id=request.args.get("entity"))
elif request.args.get("phone") is not None:
query = Customer.query.filter_by(phone=request.args.get("phone"))
elif request.args.get("uuid") is not None:
query = Customer.query.filter_by(uuid=request.args.get("uuid"))
else:
query = Customer.query
return paginate(query.order_by(Customer.id.desc()), schema)
def get(self):
schema = JobSchema(many=True)
jobcode = request.args.get('code')
if jobcode is not None:
query = Job.query.filter_by(uuid=jobcode)
elif request.args.get('entity'):
query = \
Job.query.filter_by(entity_id=request.args.get('entity'
))
elif request.args.get('employee'):
query = \
Job.query.filter_by(employee_id=request.args.get('employee'
))
elif request.args.get('request'):
query = \
Job.query.filter_by(request_id=request.args.get('request'
))
else:
query = Job.query
return paginate(query, schema)
def get(self):
schema = CommissionAccountSchema(many=True)
if request.args.get('code') is not None and request.args.get('entity'):
code = request.args.get('code')
entity = request.args.get('entity')
query = CommissionAccount.query.filter_by(code=code,
entity_id=entity)
elif request.args.get('entity') is not None:
query = CommissionAccount.query.filter_by(
entity_id=request.args.get('entity'))
elif request.args.get('code') is not None:
query = CommissionAccount.query.filter_by(
code=request.args.get('code'))
elif request.args.get('uuid') is not None:
query = CommissionAccount.query.filter_by(
uuid=request.args.get('uuid'))
else:
query = CommissionAccount.query
return paginate(query, schema)
def get(self):
schema = EntrySchema(many=True)
if request.args.get("uuid") and request.args.get("tran_type"):
query = Entry.query.filter_by(
entity_id=request.args.get("uuid"),
tran_type=request.args.get("tran_type"),
)
elif request.args.get("uuid"):
vendor = Vendor.get(uuid=request.args.get("uuid"))
if vendor:
query = Entry.query.filter_by(credit=vendor.account.id)
else:
query = Entry.query.filter_by(entity_id=request.args.get("uuid"))
elif request.args.get("reference"):
query = Entry.query.filter_by(reference=request.args.get("reference"))
else:
query = Entry.query
query = query.order_by(Entry.date_created.desc(), Entry.amount.desc())
return paginate(query, schema)
def get(self):
schema = ExpenseSchema(many=True)
if request.args.get("item") or request.args.get('from'):
from_date = request.args.get('from')
to_date = request.args.get('to')
item = request.args.get('item')
query = Expense.query
if item != '':
query = query.filter_by(item=item)
if from_date and to_date:
query = query.filter(
Expense.date_created.between(from_date, to_date))
elif request.args.get("entity") is not None:
query = Expense.query.filter_by(
entity_id=request.args.get("entity"))
else:
query = Expense.query
return paginate(query.order_by(Expense.date_created.desc()), schema)
def get(self):
schema = TransactionSchema(many=True)
if request.args.get("type"):
from_date = request.args.get('from')
to_date = request.args.get('to')
tran_type = request.args.get('type')
query = Transaction.query.filter_by(tran_type=tran_type)
query = query.filter(Transaction.date_created.between(from_date,to_date))
elif request.args.get("uuid") is not None:
uuid = request.args.get("uuid")
query = Transaction.query.filter_by(uuid=uuid)
elif request.args.get("company") is not None:
company = request.args.get("company")
query = Transaction.query.filter_by(entity_id=company)
else:
query = Transaction.query
return paginate(query.order_by(Transaction.date_created.desc()), schema)
def get(self):
schema = ItemLogSchema(many=True)
if request.args.get("type"):
from_date = request.args.get('from')
to_date = request.args.get('to')
tran_type = request.args.get('type')
item = request.args.get('item_id')
query = ItemLog.query.filter_by(category=tran_type)
if item:
query = ItemLog.query.filter_by(category=tran_type,
item_id=item)
if from_date and to_date:
query = query.filter(
ItemLog.date_created.between(from_date, to_date))
elif request.args.get("uuid") and request.args.get("tran_type"):
query = ItemLog.query.filter_by(
entity_id=request.args.get("uuid"),
category=request.args.get("tran_type"),
)
elif request.args.get("uuid"):
vendor = Vendor.get(uuid=request.args.get("uuid"))
if vendor:
query = ItemLog.query.filter_by(credit=vendor.account.id)
else:
query = ItemLog.query.filter_by(
entity_id=request.args.get("uuid"))
elif request.args.get("reference"):
query = ItemLog.query.filter_by(
reference=request.args.get("reference"))
elif request.args.get("entity") is not None:
query = ItemLog.query.filter_by(
entity_id=request.args.get("entity"))
else:
query = ItemLog.query
query = query.order_by(ItemLog.date_created.desc())
return paginate(query, schema)
def get(self):
schema = VehicleModelSchema(many=True)
query = VehicleModel.query
return paginate(query, schema)
def get(self):
schema = AccountTypeSchema(many=True)
query = AccountType.query
return paginate(query, schema)
def get(self):
schema = SettingSchema(many=True)
query = Setting.query
return paginate(query, schema)
def get(self):
schema = MakeSchema(many=True)
query = Make.query
return paginate(query, schema)
def get(self):
schema = VendorSchema(many=True)
query = Vendor.query
return paginate(query, schema)
def get(self):
schema = VehicleTypeSchema(many=True)
query = VehicleType.query
return paginate(query, schema)
