130
130
)""" % (self._table, self._select(), self._from(), self._group_by())
132
132
self.env.cr.execute(sql)
137
CREATE OR REPLACE VIEW view_account_invoice_total AS
139
ai.sale_id AS order_id,
140
string_agg(ai.number, ' ') as invoice_list,
141
ai.date_invoice AS date,
142
max(partner_id) AS partner_id,
143
max(partner_shipping_id) AS partner_shipping_id,
144
max(warehouse_id) AS warehouse_id,
145
max(user_id) AS user_id,
146
sum(amount_untaxed_signed) AS amount_untaxed_signed
148
FROM account_invoice ai
149
WHERE type IN ('out_invoice', 'out_refund')
150
GROUP BY ai.date_invoice, ai.sale_id
155
CREATE OR REPLACE VIEW view_sale_order_line_keys AS
158
l.order_id as order_id,
159
sum(l.stat_weight) as stat_weight,
160
sum(l.stat_ht) as stat_ht,
161
sum(l.stat_transport) as stat_transport,
162
sum(l.stat_total) as stat_total,
164
p.categ_id as categ_id
168
left join product_product p on (l.product_id=p.id)
176
vait.order_id AS order_id,
177
vait.invoice_list AS invoice_list,
178
vsolk.categ_id AS categ_id,
179
vsolk.stat_weight * vait.amount_untaxed_signed AS weight,
180
vsolk.stat_ht * vait.amount_untaxed_signed AS stat_ht,
181
vsolk.stat_transport * vait.amount_untaxed_signed AS stat_transport,
182
vsolk.stat_total * vait.amount_untaxed_signed AS stat_total
185
FROM view_account_invoice_total vait, view_sale_order_line_keys vsolk
186
WHERE vait.order_id = vsolk.order_id
188
negative price , weight...
b'\\ No newline at end of file'