acc_hr_expense.py
8.6 KB
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
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
# -*- coding: utf-8 -*-
import logging
from odoo import api, SUPERUSER_ID, fields, models, _
from odoo.http import request
import logging
import xlrd
from collections import Counter
import re
import datetime as dt
import xlrd
import xlwt
import pytz
import sys,os
file_url = 'my_addons/acct_expense'
file_url = os.path.join(sys.path[0],file_url)
import logging
from odoo.tools.misc import DEFAULT_SERVER_DATETIME_FORMAT
from datetime import datetime
# from ..controllers.common import localizeStrTime
from odoo.exceptions import UserError, ValidationError
_logger = logging.getLogger(__name__)
def check_path(image_path):
try:
dir_path = os.path.dirname(image_path)
if not os.path.exists(dir_path):
os.makedirs(dir_path)
except OSError as e:
logging.debug("file cant be created!{}".format(e))
return True
class AccHrExpenseSheet(models.Model):
"""
库存移动继承
"""
_inherit = "hr.expense.sheet"
expense_line_ids = fields.One2many('hr.expense', 'sheet_id', string='Expense Lines', states={'approve': [('readonly', True)], 'done': [('readonly', True)], 'post': [('readonly', True)],'teller': [('readonly', True)],'boss': [('readonly', True)]}, copy=False)
state = fields.Selection([
('draft', 'Draft'),
('submit', 'Submitted'),
('approve', 'Approved'),
('teller', '出纳已审核'),
('boss', '管理部已审核'),
('post', 'Posted'),
('done', 'Paid'),
('cancel', 'Refused')
], string='Status', index=True, readonly=True, track_visibility='onchange', copy=False, default='draft', required=True, help='Expense Report State')
@api.multi
def action_sheet_move_create(self):
res = super(AccHrExpenseSheet,self).action_sheet_move_create()
process_state = self.state
if process_state == 'teller':
raise ValidationError("需由出纳审批完成才可进行此操作")
if process_state == 'boss':
raise ValidationError("需由管理部门审批完成才可进行此操作")
return res
@api.multi
def action_submit_sheet(self):
res = super(AccHrExpenseSheet,self).action_submit_sheet()
# toaddrs = ['jie.dong@acctronics.cn']
toaddrs = []
toaddrs.append(self.user_id.login)
# toaddrs = ['jie.dong@acctronics.cn']
subjects = "{}费用报销单{}审批".format(self.employee_id.name,self.name)
message = "{}的费用报销单{}需要您审批,请及时处理".format(self.employee_id.name,self.name)
self.env['acc.tools'].send_report_email(subjects,message,toaddrs)
self.env.user.notify_success(message='提交成功')
@api.multi
def approve_expense_sheets(self):
res = super(AccHrExpenseSheet,self).approve_expense_sheets()
toaddrs = ['mei.hong@neotel-technology.com']
# toaddrs.append(self.user_id.login)
# toaddrs = ['jie.dong@acctronics.cn']
subjects = "{}费用报销单{}审批".format(self.employee_id.name,self.name)
message = "{}的费用报销单{}部门经理已批准,请及时处理".format(self.employee_id.name,self.name)
self.env['acc.tools'].send_report_email(subjects,message,toaddrs)
@api.multi
def teller_accept(self):
self.filtered(lambda r: r.state == 'approve').write({'state': 'teller'})
# toaddrs = ['al@neotel-technology.com']
# subjects = "{}费用报销单{}审批".format(self.employee_id.name,self.name)
# message = "{}的费用报销单{}出纳已核准,请及时处理".format(self.employee_id.name,self.name)
# self.env['acc.tools'].send_report_email(subjects,message,toaddrs)
return True
@api.multi
def boss_accept(self):
self.filtered(lambda r: r.state == 'teller').write({'state': 'boss'})
toaddrs = ['hongyan.chen@neotel-technology.com']
# toaddrs.append(self.user_id.login)
# toaddrs = ['jie.dong@acctronics.cn']
subjects = "{}费用报销单{}审批".format(self.employee_id.name,self.name)
message = "{}的费用报销单{}管理部已批准,请及时处理".format(self.employee_id.name,self.name)
self.env['acc.tools'].send_report_email(subjects,message,toaddrs)
self.env.user.notify_success(message='审核成功')
return True
def save_exel(self, header, body, file_name):
wbk = xlwt.Workbook(encoding='utf-8', style_compression=0)
# wbk.write(codecs.BOM_UTF8)
style1 = xlwt.easyxf('font: bold True;''alignment: horz center,vert center')
sheet = wbk.add_sheet('sheet1', cell_overwrite_ok=True)
# sheet.write(codecs.BOM_UTF8)
sheet.write(0, 0, 'some text')
sheet.write(0, 0, 'this should overwrite') ##重新设置，需要cell_overwrite_ok=True
n = 0
for i in range(len(header)):
sheet.write(n, i, header[i])
for i in range(len(body)):
n += 1
for j in range(len(body[i])):
# sheet.write(n, j, body[i][j], self.set_style())
sheet.write(n, j, body[i][j])
wbk.save(file_name) ##该文件名必须存在
def export_record(self,file_name):
"""
导出采购单信息
:return:
"""
return {
'type': 'ir.actions.act_url',
'url': '/download/work/files_export?file=%s' % (file_name),
'target': 'self'
}
def export_expense_record(self):
cr = self.env.cr
# if not product_state and not payment_state:
all_total = """ SELECT
h.NAME AS name,
h.description as description,
h.date as edate,
h.total_amount as amount,
pt.name as pname
FROM
hr_expense h
LEFT JOIN product_product pp on h.product_id = pp.id
LEFT JOIN product_template pt on pt.id = pp.product_tmpl_id
WHERE
sheet_id = %s """%(self.id)
cr.execute(all_total)
result = cr.dictfetchall()
detail_list_all=[]
# print result
# strftime("%Y%m%d_%H%M%S")
i= 0
for line in result:
detail_list_first = []
i += 1
# print ((line.get('create_date').strftime("%Y-%m-%d %H:%M:%S"))[0:11])
detail_list_first.append(i)
detail_list_first.append(line.get('edate').strftime("%Y-%m-%d"))
# if line.get('edate'):
# detail_list_first.append(line.get('forcast_date').strftime("%Y-%m-%d"))
# else:
# detail_list_first.append(line.get('forcast_date'))
detail_list_first.append(line.get('name'))
detail_list_first.append(line.get('pname'))
detail_list_first.append(line.get('description'))
detail_list_first.append(line.get('amount'))
detail_list_all.append(detail_list_first)
dir_path = os.path.join(file_url, 'Administrator')
filename = "{}.xls".format('费用报告明细表')
file_path = os.path.join(dir_path, filename)
check_path(file_path)
head = ['序号', '日期','说明','报销产品名称','备注','金额']
self.save_exel(head, detail_list_all, file_path)
return self.export_record(file_path)
class AccHrExpense(models.Model):
"""
"""
_inherit = "hr.expense"
# state = fields.Selection([
# ('draft', 'To Submit'),
# ('reported', 'Submitted'),
# ('approved', 'Approved'),
# ('done', 'Paid'),
# ('refused', 'Refused')
# ], compute='_compute_state', string='Status', copy=False, index=True, readonly=True, store=True, help="Status of the expense.")
@api.depends('sheet_id', 'sheet_id.account_move_id', 'sheet_id.state')
def _compute_state(self):
res = super(AccHrExpense, self)._compute_state()
for rec in self:
# if not expense.sheet_id or expense.sheet_id.state == 'draft':
# expense.state = "draft"
# elif expense.sheet_id.state == "cancel":
# expense.state = "refused"
# elif expense.sheet_id.state == "approve" or expense.sheet_id.state == "post":
# expense.state = "approved"
# elif not expense.sheet_id.account_move_id:
# expense.state = "reported"
# else:
# expense.state = "done"
if rec.sheet_id.state == 'teller' or rec.sheet_id.state == 'boss':
rec.state = "approved"