Hi Team,
In odoo16 timesheet module i have custom module timesheet based on approval so in table their is column approved_hours it should be based on users input but currently i am facing the issue and their one more column is there unapproved hours so these field should work like total hours is 40 and approved hours is 20 remaining 20 hours should reflect in unapproved hours
please find the code of python
from odoo import models, fields, api, _
class TimesheetValidation(models.Model):
_inherit = 'account.analytic.line'
state = fields.Selection([
('draft', 'Draft'), ('submitted', 'Submitted'), ('approved', 'Approved'), ('rejected', 'Rejected'),('approved_hours','Approved_Hours'),('approved_by_customer', 'Approved_By_Customer'),('unapporved_hours', 'Unapproved_Hours')
], default='draft', string="States")
status = fields.Selection([('draft','Draft'),
('reject', 'Reject'), ('approve', 'Approved')
], string="Status", required=True, default='draft')
employee_id = fields.Many2one('hr.employee', string="Employee", required=True)
approved_id = fields.Many2one('res.users', string='Approved By')
rejected_id = fields.Many2one('res.users', string='Rejected By')
approved_date = fields.Datetime('Approved Date')
rejected_date = fields.Datetime('Rejected Date')
rejected_reason = fields.Char('Rejected Reason')
approved_hours = fields.Text('Approved Hours')
approved_by_customer = fields.Text('Approved By Customer')
unapproved_hours = fields.Text('Unapproved hours')
@api.depends('unit_amount')
def _compute_approved_hours(self):
for record in self:
record.approved_hours = record.hours
@api.model
def create(self, vals):
vals['state'] = 'submitted'
return super(TimesheetValidation, self).create(vals)
class TimeSheetValidationWizard(models.TransientModel):
_name = 'timesheet.validation.wizard'
reason = fields.Char('Rejected Reason')
approved_id = fields.Many2one('res.users', string='Approved By')
rejected_id = fields.Many2one('res.users', string='Rejected By')
approved_date = fields.Datetime('Approved Date')
rejected_date = fields.Datetime('Rejected Date')
status = fields.Selection([('draft','Draft'),
('reject', 'Reject'), ('approve', 'Approved')
], string="Status", required=True, default='approve')
def reject(self):
active_id = self._context.get('active_id')
current_record = self.env['account.analytic.line'].search([('id', '=', active_id)])
current_record.status = 'reject'
if current_record.status == 'reject':
current_record.rejected_id = self.rejected_id
current_record.rejected_reason = self.reason
current_record.state = 'rejected'
mail_template = self.env.ref('ak_timesheet_approval.timesheet_validation_email_template')
mail_template.send_mail(current_record.id, force_send=True)
def approve(self):
active_id = self._context.get('active_id')
current_record = self.env['account.analytic.line'].search([('id', '=', active_id)])
current_record.status = 'approve'
if current_record.status == 'approve':
current_record.approved_id = self.approved_id
current_record.state = 'approved'
mail_template = self.env.ref('ak_timesheet_approval.timesheet_validation_email_template')
mail_template.send_mail(current_record.id, force_send=True)
and XML code
    
       Approve Or Reject TimeSheet
       timesheet.validation.wizard
       form
       new
        {'form_view_ref':'ak_timesheet_approval.open_wizard_for_reject_reason'}
    
    
    
       timesheet.validation.form.customise
       account.analytic.line
       
       
          
             
                
             
          
          
                
                
          
          
            
            
        
       
    
    
       Approve TimeSheets
       account.analytic.line
       
          
             
             
             
             
             
             
             
             
             
             
             
             
             
          
       
    
    
       Reject Reason
       timesheet.validation.wizard
       
          
             
                
                
                    
                    
                   
                   
                   
                
             
             
          
       
    
    
       Approve TimeSheets
       account.analytic.line
       tree
        {'tree_view_ref':'ak_timesheet_approval.approve_timesheet_tree'}
    
 
    
    
    
    
     
       
       
          
             
