New to the community? Start here

JQuery Datepicker / listing all Appointments for selected day

Hi,

could you help me create page to select a date and show all the appointments for that date?
-using the same Jquery datepicker (and datepicker css) as in the backend that includes the NON-working days. Prechosen date = Today
-good if jquery Datepicker hands over the date variable to MySQL (PHP)
-if not, also ok if the Jquery Datepicker puts the date in one of your shortcodes to display a list of appointments.

Thanks and best regards,
Chibi

Sajid
- DEV MAN’s Sidekick
- 1,316 pts: Hero points 9,763 pts: Rep. points LEVEL 27
Hi @Chibi

Hope you are doing good today :slight_smile:

Do you want to create a page for providers or clients ?

Also we have [app_my_appointments] and [app_worker_monthly_calendar] they both display appointments with dates.

Would not that work for you ?

Cheers, Sajid
Chibi
- Design Lord, Child of Thor
- 65 pts: Hero points 64 pts: Rep. points LEVEL 3
Hi Sajid,

I need a printable daily report (date can be chosen) of ALL appointments to that ONE date chosen by a datepicker. Can be done in front or even back end by ANY of the service providers even the admin - not only their own appointments.
App my appointment only shows appts for the active logged in service provider (have to log in all Service providers to get all). App worker monthly calendar shows the whole month.

JQuery.datepicker gets $selectdate... passes it on to SQL like select worker, name, phone, start, "additional fields" from app_appointments where status in (confirmed, reserved) and start = $selecteddate OR to [app_all_appointments status="confirmed, reserved" start = "$selected_date"]

Thanks in advance.

Chibi
Sajid
- DEV MAN’s Sidekick
- 1,316 pts: Hero points 9,763 pts: Rep. points LEVEL 27
Hi @Chibi

Hope you are doing good today :slight_smile:

All right, I am not sure how much it requires coding to develop it or customize the existing shortcode.

However I am flagging SLS (Second Line Support) for their invaluable feedback on this matter. He will respond here as soon as possible but please bear in mind that their response time might be slower than normal support, because they work on complex tickets like yours.

Take care and have a nice day :slight_smile:

Cheers, Sajid
Chibi
- Design Lord, Child of Thor
- 65 pts: Hero points 64 pts: Rep. points LEVEL 3
Hi @Sajid,

yayyy! Thanks.

Have a nice day too.

Chibi

Jude

DEV MAN

1,218 pts: Hero points 11,004 pts: Rep. points LEVEL 28

Hey Chibi

Sorry about the extreme delay here, it somehow slipped through the gaps. A possible way is to use the inbuilt export helper

global $appointments;

		$type = ! empty( $_POST['export_type'] ) ? $_POST['export_type'] : 'all';
		$apps = array();
		if ( 'selected' == $type && ! empty( $_POST['app'] ) ) {
			// selected appointments
			if ( $_POST['app'] ) {
				$apps = appointments_get_appointments( array( 'app_id' => array_map( 'absint', $_POST['app'] ) ) );
			}
		} else if ( 'type' == $type ) {
			$status = ! empty( $_POST['status'] ) ? $_POST['status'] : false;
			if ( 'active' === $status ) {
				$apps = appointments_get_appointments( array( 'status' => array( 'confirmed', 'paid' ) ) );
			} else if ( $status ) {
				$apps = appointments_get_appointments( array( 'status' => $status ) );
			}
		} else if ( 'all' == $type ) {
			$apps = appointments_get_appointments();
		}

Return the $apps variable and format it into a table and you should be set

Let us know if you still need help with this. Keeping my eyes open on this.

Thank you for being a WPMU DEV member and have a fantastic day!

Cheers
Jude