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

I want to display the BIRTHDATE of the customer in the calendar view? Is that possible?? if it is how will i ging to do that? can anyone please help me regarding with my problem?? thanks in advance

 

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

I add this in my xml:


        <record id="=calendar_id" model="ir.ui.view">
            <field name="name">calendar_name</field>
            <field name="model">res.partner</field>
            <field name="type">calendar</field>
            <field name="arch" type="xml">
                <calendar string="Calendar" date_start="birthday" color="name">
                    <field name="name"/>
                </calendar>
            </field>
        </record>

Ảnh đại diện
Huỷ bỏ

can u show me the pics of this output...

Tác giả

Sorry Mr. Anand for the late reply.

Tác giả

Sorry Mr. Anand for the late reply.

Câu trả lời hay nhất

Hai Alcaline..

First of all there is no specific module for Birthday event integeration..

But we have a alternate solution..

That is go to Message/Calendar In that

click the day you want and create a event... in that go to options tab and click 

Recurrent check box and give the untill the value every year

thats it..

Sorry I couldnt attach pics... since i have less karma..

Ảnh đại diện
Huỷ bỏ
Tác giả

thanks Anand

Câu trả lời hay nhất

Try This Sql view.

select h.id,concat(concat(date_part('Year',current_date),'-'),to_char(h.birthday, 'mm-dd')),r.name from hr_employee as h join resource_resource as r on h.resource_id=r.id ;

This for hr_employee table but u can use for res_partner just change it.



employee_birthday.py

from openerp import tools

from openerp.osv import fields,osv

class birthday_report(osv.osv):

_name = "birthday.report"

_auto = False

_columns = {

'name': fields.many2one('hr.employee','Employee'),

'dob' : fields.date('Birthday'),

}

def init(self, cr):

tools.drop_view_if_exists(cr, 'birthday_report')

cr.execute("""

create or replace view birthday_report as (

select

h.id as id,

h.id as name,

concat(concat(date_part('Year',current_date),'-'),to_char(h.birthday, 'mm-dd')) as dob

from

hr_employee as h

join

resource_resource as r

on

h.resource_id=r.id

)

""")

birthday_report()

employee_birthday_view.xml

<record id="view_birthday_report_calendar" model="ir.ui.view">

<field name="name">Employee Birthday</field>

<field name="model">birthday.report</field>

<field name="arch" type="xml">

<calendar string="Birthday" color="name"

date_start="dob"

quick_add="False" avatar_model="hr.employee">

<field name="name"/>

</calendar>

</field>

</record>


Thanks 

Ảnh đại diện
Huỷ bỏ