/** * Export Appointment to CSV */ public function executeExportToCSV() { $start_date = new DateTime($this->getParameter('date_start')); $start_date = $start_date->format('Y-m-d H:i:s'); $end_date = new DateTime($this->getParameter('date_end')); $end_date = $end_date->modify('+1 day')->format('Y-m-d H:i:s'); $delimiter = $this->getParameter('delimiter', ','); header('Content-Type: text/csv; charset=utf-8'); header('Content-Disposition: attachment; filename=Appointments.csv'); $header = array(__('Booking Time', 'bookly'), __('Staff Member', 'bookly'), __('Service', 'bookly'), __('Duration', 'bookly'), __('Price', 'bookly'), __('Customer', 'bookly'), __('Phone', 'bookly'), __('Email', 'bookly')); $custom_fields = array(); $fields_data = json_decode(get_option('ab_custom_fields')); foreach ($fields_data as $field_data) { $custom_fields[$field_data->id] = ''; $header[] = $field_data->label; } $output = fopen('php://output', 'w'); fwrite($output, pack("CCC", 0xef, 0xbb, 0xbf)); fputcsv($output, $header, $delimiter); $rows = AB_CustomerAppointment::query()->select('r.id, r.number_of_persons, r.coupon_discount, r.coupon_deduction, st.full_name AS staff_name, s.title AS service_title, s.duration AS service_duration, c.name AS customer_name, c.phone AS customer_phone, c.email AS customer_email, ss.price, a.start_date')->leftJoin('AB_Appointment', 'a', 'a.id = r.appointment_id')->leftJoin('AB_Service', 's', 's.id = a.service_id')->leftJoin('AB_Staff', 'st', 'st.id = a.staff_id')->leftJoin('AB_Customer', 'c', 'c.id = r.customer_id')->leftJoin('AB_StaffService', 'ss', 'ss.staff_id = st.id AND ss.service_id = s.id')->whereBetween('a.start_date', $start_date, $end_date)->sortBy('a.start_date')->order(AB_Query::ORDER_DESCENDING)->fetchArray(); foreach ($rows as $row) { if ($row['coupon_discount'] or $row['coupon_deduction']) { $coupon = new AB_Coupon(); $coupon->set('discount', $row['coupon_discount']); $coupon->set('deduction', $row['coupon_deduction']); $row['price'] = $coupon->apply($row['price']); } $row['price'] *= $row['number_of_persons']; $row_data = array($row['start_date'], $row['staff_name'], $row['service_title'], AB_Service::durationToString($row['service_duration']), AB_Utils::formatPrice($row['price']), $row['customer_name'], $row['customer_phone'], $row['customer_email']); $customer_appointment = new AB_CustomerAppointment(); $customer_appointment->load($row['id']); foreach ($customer_appointment->getCustomFields() as $custom_field) { $custom_fields[$custom_field['id']] = $custom_field['value']; } fputcsv($output, array_merge($row_data, $custom_fields), $delimiter); $custom_fields = array_map(function () { return ''; }, $custom_fields); } fclose($output); exit; }
echo AB_Service::durationToString($service['duration']); ?> </option> <?php } ?> <option value="<?php echo $j * 60; ?> " <?php selected($service['duration'], $j * 60); ?> > <?php echo AB_Service::durationToString($j * 60); ?> </option> <?php } ?> <option value="86400" <?php selected($service['duration'], 86400); ?> > <?php _e('All day', 'bookly'); ?> </option> </select> </td>
</div> <?php } ?> <table class="form-horizontal"> <tr> <td><?php _e('Time slot length', 'ab'); ?> </td> <td> <select name="ab_settings_time_slot_length" style="width: 200px;"> <?php foreach (array(5, 10, 12, 15, 20, 30, 60) as $duration) { $duration_output = AB_Service::durationToString($duration * 60); ?> <option value="<?php echo $duration; ?> " <?php selected(get_option('ab_settings_time_slot_length'), $duration); ?> > <?php echo $duration_output; ?> </option> <?php } ?>
?> ><?php _e('Disabled', 'bookly'); ?> </option> <?php foreach (array_merge(range(1, 12), array(24, 48)) as $hour) { ?> <option value="<?php echo $hour; ?> " <?php selected(get_option('ab_settings_minimum_time_prior_booking'), $hour); ?> ><?php echo AB_Service::durationToString($hour * 3600); ?> </option> <?php } ?> </select> </td> <td class="ab-valign-top"> <?php AB_Utils::popover(__('Set a minimum amount of time before the chosen appointment (for example, require the customer to book at least 1 hour before the appointment time).', 'bookly')); ?> </td> </tr> <tr> <td>
/** * Get data needed for appointment form initialisation. */ public function executeGetDataForAppointmentForm() { $result = array('staff' => array(), 'customers' => array(), 'custom_fields' => array(), 'time' => array(), 'time_interval' => get_option('ab_settings_time_slot_length') * 60); // Staff list. $staff_members = AB_Utils::isCurrentUserAdmin() ? AB_Staff::query()->sortBy('position')->find() : AB_Staff::query()->where('wp_user_id', get_current_user_id())->find(); /** @var AB_Staff $staff_member */ foreach ($staff_members as $staff_member) { $services = array(); foreach ($staff_member->getStaffServices() as $staff_service) { $services[] = array('id' => $staff_service->service->get('id'), 'title' => sprintf('%s (%s)', $staff_service->service->get('title'), AB_Service::durationToString($staff_service->service->get('duration'))), 'duration' => $staff_service->service->get('duration'), 'capacity' => $staff_service->get('capacity')); } $result['staff'][] = array('id' => $staff_member->get('id'), 'full_name' => $staff_member->get('full_name'), 'services' => $services); } // Customers list. foreach (AB_Customer::query()->sortBy('name')->find() as $customer) { $name = $customer->get('name'); if ($customer->get('email') != '' || $customer->get('phone') != '') { $name .= ' (' . trim($customer->get('email') . ', ' . $customer->get('phone'), ', ') . ')'; } $result['customers'][] = array('id' => $customer->get('id'), 'name' => $name, 'custom_fields' => array(), 'number_of_persons' => 1); } // Time list. $ts_length = AB_BookingConfiguration::getTimeSlotLength(); $time_start = AB_StaffScheduleItem::WORKING_START_TIME; $time_end = AB_StaffScheduleItem::WORKING_END_TIME; // Run the loop. while ($time_start <= $time_end) { $result['time'][] = array('value' => AB_DateTimeUtils::buildTimeString($time_start, false), 'title' => AB_DateTimeUtils::formatTime($time_start)); $time_start += $ts_length; } wp_send_json($result); }