[Care2002-developers] Fwd: Re: sample user roles

2010-09-24 Thread Gjergj Sheldija - AcmeTECH

 hi Robert,

you're right, my fault...
some typo corrections for the roles.

gj.

  second version, the first one has some typo errors

gj.

On 2010-09-23 12:39.MD, Gjergj Sheldija wrote:

  hi,

 i'm attaching some sample user roles, hope it help.
 it comprises those roles :

 Nurse_Registration
 Nurse_Midwife
 Nurse_Surgery
 Head_Nurse_Department
 Pharmacy_Department
 Obstetrics_Gynecology
 Doctor_Surgery
 Doctor_Department
 Doctor_Lab
 Doctor_Imaging
 Pharmacy_Hospital
 Tech_Hospital
 Blood_Bank
 Head_Department
 Head_HR
 Head_Surgery
 Head_Nurse_Surgery
 Head_Nurse_Surgery+Pharmacy
 Head_Nurse_Department+Pharmacy
 Nurse_General
 Lab_Technicial_Department
 Pharmacy_Imaging
 Lab_Technician
 Head_Nurse_Lab+Pharmacy
 Information_Office
 Billing
 Sterilisation
 Secretary
 Archive
 Med_Depot_Hospital
 Head_Medical_Commission
 Legal_Doctor
 Supervisor
 Medical_Consultant
 Care2x_Technician

 please remember that uses need to be attached to a department
 to be able to access that department

 gj.



SET SQL_MODE=NO_AUTO_VALUE_ON_ZERO;

-- 

--
-- Table structure for table `care_user_roles`
--

CREATE TABLE IF NOT EXISTS `care_user_roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT 'no_name',
  `permission` text COLLATE latin1_general_ci,
  `history` text COLLATE latin1_general_ci,
  `modify_id` varchar(35) COLLATE latin1_general_ci NOT NULL,
  `modify_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE 
CURRENT_TIMESTAMP,
  `create_id` varchar(35) COLLATE latin1_general_ci NOT NULL,
  `create_time` timestamp NOT NULL DEFAULT '-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci 
ROW_FORMAT=DYNAMIC COMMENT='InnoDB free: 7168 kB' AUTO_INCREMENT=104 ;

--
-- Dumping data for table `care_user_roles`
--

INSERT INTO `care_user_roles` (`id`, `role_name`, `permission`, `history`, 
`modify_id`, `modify_time`, `create_id`, `create_time`) VALUES
(60, 'Nurse_Registration', '_a_1_admissionwrite _a_2_admissionread 
_a_1_nursingstationallwrite _a_2_nursingstationallread 
_a_1_nursingdutyplanwrite _a_2_nursingdutyplanread _a_2_opnursedutyplanread 
_a_2_medocsread _a_2_doctorsdutyplanread _a_2_timestampallread 
_a_2_dutyplanallread ', 'Created by admin on   2007-10-31 18:28:51', 'admin', 
'2008-07-25 09:39:29', 'admin', '2007-10-31 18:28:28'),
(61, 'Nurse_Midwife', '_a_1_admissionwrite _a_2_admissionread 
_a_1_nursingstationallwrite _a_2_nursingstationallread 
_a_1_nursingdutyplanwrite _a_2_nursingdutyplanread _a_3_diagnosticsrequest 
_a_2_labresultsread _a_1_opdoctorallwrite _a_2_opnurseallwrite 
_a_3_opnurseallread _a_2_opnursedutyplanread _a_2_radioread _a_2_medocsread 
_a_2_doctorsdutyplanread _a_2_photoread _a_2_timestampallread 
_a_2_dutyplanallread ', 'Created by admin on   2007-10-31 18:29:59', 'admin', 
'2008-07-26 09:23:14', 'admin', '2007-10-31 18:29:36'),
(62, 'Nurse_Surgery', '_a_2_admissionread _a_1_nursingstationallwrite 
_a_2_nursingdutyplanread _a_3_diagnosticsrequest _a_2_labresultsread 
_a_2_opnurseallwrite _a_3_opnurseallread _a_2_opnursedutyplanread 
_a_2_radioread _a_2_medocsread _a_2_doctorsdutyplanread _a_2_timestampallread 
_a_2_dutyplanallread ', 'Created by admin on   2007-10-31 18:31:11', 'admin', 
'2008-07-24 18:50:03', 'admin', '2007-10-31 18:30:48'),
(64, 'Head_Nurse_Department', '_a_2_admissionread _a_1_nursingstationallwrite 
_a_1_nursingdutyplanwrite _a_3_diagnosticsrequest _a_2_labresultsread 
_a_2_radioread _a_1_medocswrite _a_2_medocsread _a_1_doctorsdutyplanwrite 
_a_2_photoread _a_2_timestampallread _a_2_dutyplanallread ', 'Created by admin 
on   2007-10-31 18:33:57', 'admin', '2008-07-24 18:53:24', 'admin', '2007-10-31 
18:33:34'),
(66, 'Pharmacy_Department', '_a_1_nursingstationallwrite 
_a_2_nursingstationallread _a_3_pharmaorder _a_4_pharmaread ', 'Created by 
admin on   2007-10-31 18:36:54', 'admin', '2008-01-21 15:10:12', 'admin', 
'2007-10-31 18:36:31'),
(67, 'Obstetrics_Gynecology', '_a_2_admissionread _a_1_nursingstationallwrite 
_a_2_nursingdutyplanread _a_1_diagnosticsresultwrite 
_a_2_diagnosticsreceptionwrite _a_1_labresultswrite _a_1_opdoctorallwrite 
_a_2_opnursedutyplanread _a_1_radiowrite _a_2_radioread _a_1_medocswrite 
_a_3_pharmaorder _a_4_pharmaread _a_2_doctorsdutyplanread _a_1_photowrite 
_a_2_timestampallread _a_2_dutyplanallread ', 'Created by admin on   2007-10-31 
18:47:36', 'admin', '2008-07-25 09:46:26', 'admin', '2007-10-31 18:47:13'),
(68, 'Doctor_Surgery', '_a_2_admissionread _a_1_nursingstationallwrite 
_a_2_nursingdutyplanread _a_1_diagnosticsresultwrite 
_a_2_diagnosticsreceptionwrite _a_2_labresultsread _a_1_opdoctorallwrite 
_a_2_opnurseallwrite _a_3_opnurseallread _a_2_opnursedutyplanread 
_a_1_radiowrite _a_1_medocswrite _a_3_pharmaorder _a_4_pharmaread 
_a_2_doctorsdutyplanread _a_1_photowrite _a_2_photoread _a_2_timestampallread 
_a_2_dutyplanallread ', 

Re: [Care2002-developers] Fwd: Re: sample user roles

2010-09-24 Thread Ap.Muthu
Working on your second list - will report on it shortly.

- Original Message - 
From: Gjergj Sheldija - AcmeTECH gjergj.sheld...@gmail.com
To: care2002-developers@lists.sourceforge.net
Sent: Friday, September 24, 2010 2:49 PM
Subject: [Care2002-developers] Fwd: Re: sample user roles


  hi Robert,

 you're right, my fault...
 some typo corrections for the roles.

 gj.

   second version, the first one has some typo errors

 gj.

 On 2010-09-23 12:39.MD, Gjergj Sheldija wrote:
   hi,

  i'm attaching some sample user roles, hope it help.
  it comprises those roles :

  Nurse_Registration
  Nurse_Midwife
  Nurse_Surgery
  Head_Nurse_Department
  Pharmacy_Department
  Obstetrics_Gynecology
  Doctor_Surgery
  Doctor_Department
  Doctor_Lab
  Doctor_Imaging
  Pharmacy_Hospital
  Tech_Hospital
  Blood_Bank
  Head_Department
  Head_HR
  Head_Surgery
  Head_Nurse_Surgery
  Head_Nurse_Surgery+Pharmacy
  Head_Nurse_Department+Pharmacy
  Nurse_General
  Lab_Technicial_Department
  Pharmacy_Imaging
  Lab_Technician
  Head_Nurse_Lab+Pharmacy
  Information_Office
  Billing
  Sterilisation
  Secretary
  Archive
  Med_Depot_Hospital
  Head_Medical_Commission
  Legal_Doctor
  Supervisor
  Medical_Consultant
  Care2x_Technician

  please remember that uses need to be attached to a department
  to be able to access that department

  gj.








 --
 Nokia and ATT present the 2010 Calling All Innovators-North America 
 contest
 Create new apps  games for the Nokia N8 for consumers in  U.S. and Canada
 $10 million total in prizes - $4M cash, 500 devices, nearly $6M in 
 marketing
 Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
 http://p.sf.net/sfu/nokia-dev2dev





 ___
 Care2002-developers mailing list
 Care2002-developers@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/care2002-developers
 



--
Nokia and ATT present the 2010 Calling All Innovators-North America contest
Create new apps  games for the Nokia N8 for consumers in  U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store 
http://p.sf.net/sfu/nokia-dev2dev
___
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/care2002-developers


[Care2002-developers] Fwd: Re: sample user roles

2010-09-23 Thread Gjergj Sheldija
  Hi Mauri,

exactly! this way the control over who access what
is much more fine grained and more hospital-like :)

this way you can have a general hospital registration,
which prints out a coupon ( via the print button in the registration form )
and send the patient to the specific dept/ward.
the the admission nurse of the ward scans the coupon,
which has a barcode, or searches for the patient and admits it.

besides this, there is another option, a bit more subtle,
multi pharmacies.
ex.
a hospital with a main depot, a main pharmacy, and a
pharmacy for each clinic/department.
so the  requests go from the clinic/department pharmacy
to the main pharmacy.
you can access this feature in the department creation, where
you can connect a pharmacy to a department or pharmacy.

and another thing, is the management of the drugs that every ward
must have during the night, ( it's called pronto in italy, don't know
how it's called in english )
which have to be returned to the department pharmacy the day after.

and, as a last thing is the prescription management. when a doctor/nurse
writes down the prescription in the nurse module for the patient
it automatically fills the request form of the department pharmacy to
the main
pharmacy.

it's a bit complex, but healthcare is like that :)

regards
gj.


On 2010-09-23 1:48.MD, Mauri Niemi wrote:
  Hi,

  Now I got the point. First the role gives me access to certain areas and
  then I have to give second time certain departments. It was said but was
  used to the idea in Tz version.

  Mauri

  2010/9/23 Gjergj Sheldijagjergj.sheld...@acme-tech.net

hi,

  you need to connect the users to their specific department to
  be able to access the department.
  the acl is like user -   role -   department

  gj.


  On 2010-09-23 1:10.MD, Mauri Niemi wrote:

  Hi,

  Thanks for this. When I am testing I have not been able to admit
  patients
  when the departments are not seen in the list, also not in ambulatory
  list.
  They are in admin department list but for some reason not shown
  where they
  are needed in clinical modules. I also created some departments and
  they
  are
  not seen in the list neither.

  Mauri

  2010/9/23 Gjergj Sheldijagjergj.sheld...@gmail.com

 hi,
  i'm attaching some sample user roles, hope it help.
  it comprises those roles :

  Nurse_Registration
  Nurse_Midwife
  Nurse_Surgery
  Head_Nurse_Department
  Pharmacy_Department
  Obstetrics_Gynecology
  Doctor_Surgery
  Doctor_Department
  Doctor_Lab
  Doctor_Imaging
  Pharmacy_Hospital
  Tech_Hospital
  Blood_Bank
  Head_Department
  Head_HR
  Head_Surgery
  Head_Nurse_Surgery
  Head_Nurse_Surgery+Pharmacy
  Head_Nurse_Department+Pharmacy
  Nurse_General
  Lab_Technicial_Department
  Pharmacy_Imaging
  Lab_Technician
  Head_Nurse_Lab+Pharmacy
  Information_Office
  Billing
  Sterilisation
  Secretary
  Archive
  Med_Depot_Hospital
  Head_Medical_Commission
  Legal_Doctor
  Supervisor
  Medical_Consultant
  Care2x_Technician

  please remember that uses need to be attached to a department
  to be able to access that department

  gj.



  
 --

  Start uncovering the many advantages of virtual appliances
  and start using them to simplify application deployment and
  accelerate your shift to cloud computing.
  http://p.sf.net/sfu/novell-sfdev2dev
  ___
  Care2002-developers mailing list
  Care2002-developers@lists.sourceforge.net
  https://lists.sourceforge.net/lists/listinfo/care2002-developers





--
Nokia and ATT present the 2010 Calling All Innovators-North America contest
Create new apps  games for the Nokia N8 for consumers in  U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store 
http://p.sf.net/sfu/nokia-dev2dev
___
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/care2002-developers