I want Islamic Arabic date in my database. So i add a textbox and manually enter the Islamic Arabic date on that textbox. When i enter Islamic Arabic date, it will automatically convert into Gregorian date.
But i don't know, where should i give the logic?
from openerp.osv import fields, osv
import math
from datetime import date
def intPart(floatNum):
if floatNum < -0.0000001: return math.ceil(floatNum - 0.0000001)
return math.floor(floatNum + 0.0000001)def Hijri2Gregorian(yr,mth,day):
jd1 = intPart((11 * yr + 3) / 30.0)
jd2 = intPart((mth - 1) / 2.0)
jd = jd1 + 354 * yr + 30 * mth - jd2 + day + 1948440 - 385if jd > 2299160:
l = jd + 68569
n = intPart((4 * l) / 146097.0)
l = l - intPart((146097 * n + 3) / 4.0)
i = intPart((4000 * (l + 1)) / 1461001.0)
l = l - intPart((1461 * i) / 4.0) + 31
j = intPart((80 * l) / 2447.0)
d = l - intPart((2447 * j) / 80.0)
l = intPart(j / 11.0)
m = j + 2 - 12 * l
y = 100 * (n - 49) + i + l
else:
j = jd + 1402
k = intPart((j - 1) / 1461.0)
l = j - 1461 * k
n = intPart((l - 1) / 365.0) - intPart(l / 1461.0)
i = l - 365 * n + 30
j = intPart((80 * i) / 2447.0)
d = i - intPart((2447 * j) / 80.0)
i = intPart(j / 11.0)
m = j + 2 - 12 * i
y = 4 * k + n + i - 4716return y, m, d
class hr_extra(osv.osv):
_inherit = "hr.employee"
def _get_hijri_date(self, cr, uid, ids, name, args, context=None):
res = {}
for self_data in self.browse(cr, uid, ids, context=context):
islamic_date = self_data.islamic_date
list = islamic_date.split('.')
yr = islamic_date(str(list[0]))
mth = islamic_date(str(list[1]))
day = islamic_date(str(list[2]))
Hijri2Gregorian(yr,mth,day)
return res
_columns = {
'islamic_date' : fields.char('Islamic Date'),
'english_date' : fields.function(_get_hijri_date, select=True,string='English Date'),
#'date' : fields.date(_get_english_date,string='Alert Date'),
}
hr_extra()
<record id="hr_extra_form" model="ir.ui.view">
<field name="name">hr.extra.form.inherit</field>
<field name="model">hr.employee</field>
<field name="inherit_id" ref="hr.view_employee_form"/>
<field name="arch" type="xml"> <field name="otherid" position="after">
<field name="islamic_date"/>
<field name="english_date"/>
</field>
</field>
</record>