How to arrange employee

  • Xavier
  • Topic Author
  • Offline
  • New Member
  • New Member
More
11 years 10 months ago #32103 by Xavier
How to arrange employee was created by Xavier
Hi There,

Can you please advice how to arrange the employees on the tab. I want certain employee to be in the first tab. It seem current arrangement is based on employee creation time, the last employee created will be the 1st employee in the tab.

Please Log in or Create an account to join the conversation.

More
11 years 10 months ago #32113 by Mr. Dam
Replied by Mr. Dam on topic Re: How to arrange employee
Hi Xavier,
Currently, OS Services Booking doesn't have option to order employees, but i can make the change in the source code to order employees by name, is that ok for you?
Thanks
Dam

Please Log in or Create an account to join the conversation.

  • Xavier
  • Topic Author
  • Offline
  • New Member
  • New Member
More
11 years 10 months ago #32123 by Xavier
Replied by Xavier on topic Re: How to arrange employee
Can you please guide me where to do the changes to the source code?

Please Log in or Create an account to join the conversation.

More
11 years 10 months ago #32131 by Mr. Dam
Replied by Mr. Dam on topic Re: How to arrange employee
Hi,
To change the order by name, please follow these steps:
1. Open file :
components > com_osservicesbooking > classes > ajax.php
2. find this code
$db->setQuery("Select a.* from #__app_sch_employee as a inner join #__app_sch_employee_service as b on a.id = b.employee_id where a.published = '1' and b.service_id = '$sid' and b.".$day." = '1' and a.id NOT IN (Select eid from #__app_sch_employee_rest_days where rest_date = '$day1') $vidSql order by b.ordering");
and change to
$db->setQuery("Select a.* from #__app_sch_employee as a inner join #__app_sch_employee_service as b on a.id = b.employee_id where a.published = '1' and b.service_id = '$sid' and b.".$day." = '1' and a.id NOT IN (Select eid from #__app_sch_employee_rest_days where rest_date = '$day1') $vidSql order by a.employee_name");

Good luck
Dam

Please Log in or Create an account to join the conversation.

Moderators: Mr. Dam