[CK-Ledger-users] Re: HR question

[C K Wu <ck...@ch...>]

Hi, Marc,

Sorry for the delay in replying.

The error that you spotted is actually a bug.  I have taken 'payrolgrp'
out of the employee table and forgot to change the update logic :-(  .

As a temporary fix, modify the script, ../ck-hr/inc/class.employee.inc.php,
as follows,

At line 60, delete the words,            <,payrolgrp>
At line 62, delete the words,            <,'$e[payrolgrp]'>
At line 70, delete the words,            <,payrolgrp='$e[payrolgrp]'>

ie, delete the mechanism for updating the field, payrolgrp.

As to the first employee, the supervisor field does allow blank input
and the staff can actually be its own supervisor.  So, just create
the first employee with a blank supervisor.  Subsequently, the supervisor
field can be updated to other staff created later or to the employee
himself/herself.

Hope these help and thank you for spotting the bug.

Cheers,
CK



Marc Lutolf wrote:

> Hi CK,
>
> I'm getting the following error when trying to enter an employee into the HR
> module:
>
> Database error: Invalid SQL: INSERT INTO employee
> (id,name,prefix,family,given,suffix,nationalid,title,supervisor,dept,grade,p
> ayrolgrp) VALUES ('20007','Marc
> Lutolf','Mr','Lutolf','Marc','san','1','Partner','','20003','CEO','')
>
> It seems to be blowing up for lack of values in supervisor and payrolgrp.
> Not sure where to enter payrolgrp, but how can I enter a supervisor if this
> is the first person I'm entering.
>
> Any help appreciated,
>
> Marc