Перейти к содержимому
Меню
Чтобы взаимодействовать с сообществом, необходимо зарегистрироваться.
Этот вопрос был отмечен
7 Ответы
9144 Представления

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

 

Аватар
Отменить
Автор Лучший ответ

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>

Аватар
Отменить

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

Автор

Sorry Mr. Anand for the late reply.

Автор

Sorry Mr. Anand for the late reply.

Лучший ответ

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

Аватар
Отменить
Автор

thanks Anand

Лучший ответ

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 

Аватар
Отменить