def get_projects_from_request(request): """ Return the projects regarding the current request """ company_id = request.current_company projects = Project.query().filter_by(company_id=company_id).all() return projects
def query(self): company = self.request.context # We can't have projects without having customers if not company.customers: redirect_to_customerslist(self.request, company) return Project.query().outerjoin(Project.customers).filter( Project.company_id == company.id)
def test_gen_cancelinvoice_payment(dbsession, invoice): user = User.query().first() project = Project.query().first() invoice.project = project invoice.owner = user invoice.statusPersonAccount = user invoice.record_payment(mode="c", amount=1500) cinv = invoice.gen_cancelinvoice(user) assert len(cinv.lines) == len(invoice.lines) + len(invoice.discounts) + 1 assert cinv.lines[-1].cost == 1500
def test_gen_cancelinvoice_payment(self): user = User.query().first() project = Project.query().first() inv = self.getOne() inv.project = project inv.owner = user inv.statusPersonAccount = user inv.record_payment(mode="c", amount=1500) cinv = inv.gen_cancelinvoice(user) self.assertEqual(len(cinv.lines), len(inv.lines) + len(inv.discounts) + 1) self.assertEqual(cinv.lines[-1].cost, 1500)
def test_gen_cancelinvoice(dbsession, invoice): user = User.query().first() project = Project.query().first() invoice.project = project invoice.owner = user invoice.statusPersonAccount = user dbsession.add(invoice) dbsession.flush() cinv = invoice.gen_cancelinvoice(user) dbsession.add(cinv) dbsession.flush() assert cinv.name == "Avoir 1" assert cinv.total_ht() == -1 * invoice.total_ht() today = datetime.date.today() assert cinv.taskDate == today
def test_gen_cancelinvoice(self): user = User.query().first() project = Project.query().first() inv = self.getOne() inv.project = project inv.owner = user inv.statusPersonAccount = user self.session.add(inv) self.session.flush() cinv = inv.gen_cancelinvoice(user) self.session.add(cinv) self.session.flush() self.assertEqual(cinv.name, "Avoir 1") self.assertEqual(cinv.total_ht(), -1 * inv.total_ht()) today = datetime.date.today() self.assertEqual(cinv.taskDate, today)
def project(self): return Project.query().first()
def getone(): val = Project.query().filter(Project.name == "Projéct&$").first() if val is not None: val.__name__ = 'project' return val
def project(content): proj = Project.query().first() proj.code = "PRO1" return proj
def getone(): from autonomie.models.project import Project return Project.query().first()
def project(content): return Project.query().first()
def getOne(self): try: return Project.query().filter(Project.name=="Projéct&$").one() except: return None
def project(content): proj = Project.query().first() proj.code = "PRO1" proj.phases.append(Phase(name="test")) return proj
def getone(): val = Project.query().filter(Project.name=="Projéct&$").first() if val is not None: val.__name__ = 'project' return val