Hello Emir,
thanks for the bug report. Here is the solution to that:
a) Open the /include/care_api_classes/class_personell.php
b) Locate the "_getOCDutyPlan()" method (line: 341)
c) Locate the sql query below it (line: 347)
d) Replace the sql query with the following:
$this->sql="SELECT $elems FROM $this->tb_dpoc WHERE role_nr=$role_nr AND
dept_nr=$dept_nr AND year=$year AND month=$month" ;
Note the difference, in the corrrected query the single qoutes previously
enclosing the $role_nr, $dept_nr, $year and $month are now removed.
Also, when you assign a doctor on oncall duty, assign him to the department to
which the nursing ward belongs.
I have tested the patch on my system, it works now. Try it :-)
Regards,
elpidio
On Tuesday 25 May 2004 05:51, Emir Prcic wrote:
> I have noticed something in Nursing module in Wards.
> In Quick Informer there is this
>
> Doctor (on Duty):
>
> Is this active, cause it seems like it is not. I have tried setting a doc
> in DOC Scheduler for a specific department but it does not show in Quick
> Informer. Also loging in as the doctor on duty for that day in that ward
> and in that department does not bring any changes....
-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g.
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id149&alloc_id�66&op=click
_______________________________________________
Care2002-developers mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/care2002-developers