Skip to Content
Meniu
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
Această întrebare a fost marcată
7 Răspunsuri
9112 Vizualizări

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

 

Imagine profil
Abandonează
Autor Cel mai bun răspuns

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>

Imagine profil
Abandonează

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

Autor

Sorry Mr. Anand for the late reply.

Autor

Sorry Mr. Anand for the late reply.

Cel mai bun răspuns

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

Imagine profil
Abandonează
Autor

thanks Anand

Cel mai bun răspuns

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 

Imagine profil
Abandonează