- Posts: 18
- Thank you received: 0
How to arrange employee
- Xavier
- Topic Author
- Offline
- New Member
-
Less
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.
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.
- Mr. Dam
-
- Offline
- Administrator
-
Less
More
- Posts: 13052
- Thank you received: 1696
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
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
-
Less
More
- Posts: 18
- Thank you received: 0
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.
- Mr. Dam
-
- Offline
- Administrator
-
Less
More
- Posts: 13052
- Thank you received: 1696
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
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
Support
Documentation
Information
Copyright © 2025 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.