Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
2 Trả lời
14257 Lượt xem

Hello all,

I want to make a filter in a search view.

This filter must accept invoices when their date is in this the current week or the last week.

We consider that the week begins at monday. We consider that the week ends at sunday.

If we are at the beginning of the week actually, we don't go back for 14 days. Current week always begins to the last monday (or the actual monday if we already are monday) and last week always begin to the previous monday. (Do you understand what I mean? Not easy to write it in english...) 

Ảnh đại diện
Huỷ bỏ
Tác giả Câu trả lời hay nhất

I propose this filter :

(monday is weekday 0. sunday is weekday 6)

<filter string="Current and last weeks" name="currentandlastlastweeks" domain="[
        ('date','&gt;=',(context_today()+relativedelta(weeks=-2,days=1,weekday=0)).strftime('%Y-%m-%d')),
        ('date','&lt;',(context_today()+relativedelta(weekday=6)).strftime('%Y-%m-%d'))
                    ]" help="Journal invoices of the current and the last weeks" />


Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

Hi,

One way would be: Group By > Add Custom Group > "Accounting Date" , and then in Group By > Accounting Date you can select "Week" , and the invoices will be divided between Wxx, Wxy, ...

BR

Ricardo


Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
4
thg 8 22
13043
0
thg 3 24
1003
2
thg 9 24
27458
1
thg 8 25
99
0
thg 7 25
930