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)