Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
7 Replies
9124 Tampilan

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

 

Avatar
Buang
Penulis Jawaban Terbai

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>

Avatar
Buang

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

Penulis

Sorry Mr. Anand for the late reply.

Penulis

Sorry Mr. Anand for the late reply.

Jawaban Terbai

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..

Avatar
Buang
Penulis

thanks Anand

Jawaban Terbai

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 

Avatar
Buang