10. Creating QWeb Reports | Odoo 10 Development Essentials

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Odoo 10 Development Essentials

By : Daniel Reis

5 (1)

Odoo 10 Development Essentials

5 (1)

By: Daniel Reis

Overview of this book

Odoo is one of the fastest growing open source, business application development software products available. With announcement of Odoo 10, there are many new features added to Odoo and the face of business applications developed with Odoo has changed. This book will not only teach you how to build and customize business applications with Odoo, but it also covers all the new features that Odoo has to offer. This book is the latest resource on developing and customizing Odoo 10 applications. It comes packed with much more and refined content than its predecessor. It will start with building business applications from scratch and will cover topics such as module extensions, inheritance, working with data, user interfaces, and so on. The book also covers the latest features of Odoo 10, in addition to front end development, testing and debugging techniques. The book will also talk about Odoo Community and Odoo Enterprise.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Getting Started with Odoo Development

1. Getting Started with Odoo Development

Setting up a host for the Odoo server

Installing Odoo from the source

Initializing a new Odoo database

A word about Odoo product versions

More server configuration options

Developing from your workstation

Installing third-party modules

Summary

2. Building Your First Odoo Application

2. Building Your First Odoo Application

Essential concepts

The model layer

The view layer

The business logic layer

Setting up access security

Better describing the module

Summary

3. Inheritance – Extending Existing Applications

3. Inheritance – Extending Existing Applications

Adding sharing capabilities to the To-Do app

Extending models

Extending views

More model inheritance mechanisms

Modifying data

Summary

4. Module Data

4. Module Data

Understanding external identifiers

Exporting and importing data

Module data

XML data files

Summary

5. Models – Structuring the Application Data

5. Models – Structuring the Application Data

Organizing application features into modules

Creating models

Creating fields

Relationships between models

Computed fields

Model Constraints

Summary

6. Views - Designing the User Interface

6. Views - Designing the User Interface

Defining the user interface with XML files

Context and domain

The form views

View semantic components

Dynamic views

List views

Search views

Calendar views

Graph and pivot views

Other view types

Summary

7. ORM Application Logic – Supporting Business Processes

7. ORM Application Logic – Supporting Business Processes

Creating a wizard

Working with the ORM API

Working with recordsets

Summary

8. Writing Tests and Debugging Your Code

8. Writing Tests and Debugging Your Code

Unit tests

Adding unit tests

Writing test cases

Setting up tests

Testing exceptions

Running tests

About YAML tests

Development tools

Summary

9. QWeb and Kanban Views

9. QWeb and Kanban Views

About kanban boards

Designing kanban views

The QWeb templating language

Inheritance on kanban views

Custom CSS and JavaScript assets

Summary

10. Creating QWeb Reports

10. Creating QWeb Reports

Installing wkhtmltopdf

Creating business reports

QWeb report templates

Presenting data in reports

Rendering images

Summary totals and running totals

Defining paper formats

Enabling language translation in reports

Reports based on custom SQL

Summary

11. Creating Website Frontend Features

11. Creating Website Frontend Features

Roadmap

Our first web page

Building websites

Website forms

Summary

12. External API – Integrating with Other Systems

12. External API – Integrating with Other Systems

Setting up a Python client

Calling the Odoo API using XML-RPC

Writing a Notes desktop application

Introducing the ERPpeek client

Summary

13. Deployment Checklist – Going Live

13. Deployment Checklist – Going Live

Available prebuilt packages

Installing dependencies

Multiprocessing workers

Using a reverse proxy

Server and module updates

Summary

Presenting data in reports

Unlike Kanban views, the QWeb templates in reports are rendered server side, and use a Python QWeb implementation. We can see this as two implementations of the same specification, and there are some differences that we need to be aware of.

To start with, QWeb expressions are evaluated using Python syntax, not JavaScript. For the simplest expressions, there may be little or no difference, but more complex operations will probably be different.

The way expressions are evaluated is also different. For reports, we have the following variables available:

docs is an iterable collection with the records to print
doc_ids is a list of the IDs of the records to print
doc_model identifies the model of the records, todo.task for example
time is is a reference to Python's time library
user is the record for the user running the report
res_company is the record for the current user's company

The report content is written in HTML, field values can be referenced using the t-field attribute...

Visually different images

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Odoo 10 Development Essentials

Search

Your notes and bookmarks