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
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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
Create an account today to enjoy exclusive features and engage with our awesome community!
Înscrie-te