1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
import datetime
import operator
import pooler
import time
from report import report_sxw
class skillreport(report_sxw.rml_parse):
def __init__(self, cr, uid, name, context):
super(skillreport, self).__init__(cr, uid, name, context)
self.localcontext.update({
'time' : time,
'get_data' : self._getData,
'get_skill':self._getskill,
})
def _getskill(self,ids):
res=[]
t_ids=pooler.get_pool(self.cr.dbname).get('hr_skill.evaluation.skill').search(self.cr,self.uid,[('evaluation_id','=',ids)])
res1=pooler.get_pool(self.cr.dbname).get('hr_skill.evaluation.skill').browse(self.cr,self.uid,t_ids)
return res1
def _getData(self,form):
res=[]
eval_id=[]
emp_id=[]
final=[]
id = form['s_ids']
if id:
self.cr.execute("select evaluation_id from hr_skill_evaluation_skill where skill_id=%d"%id)
eval_id.append(self.cr.fetchall())
for i in range(0,len(eval_id[0])):
res.append(eval_id[0][i][0])
for i in range(0,len(res)):
final.append(pooler.get_pool(self.cr.dbname).get('hr_skill.evaluation').browse(self.cr,self.uid,res[i],))
return final
report_sxw.report_sxw('report.skillreport','hr_skill.evaluation','addons/hr_skill/report/skillreport.rml',parser=skillreport,)
|