pranav nachnekar | 2791054 | 2019-09-03 12:04:52 +0530 | [diff] [blame] | 1 | import frappe |
| 2 | import datetime |
pranav nachnekar | c5b2a58 | 2019-09-03 14:16:47 +0530 | [diff] [blame] | 3 | import json |
Pranav Nachanekar | 93670fe | 2019-10-03 11:58:02 +0530 | [diff] [blame] | 4 | import pytz |
pranav nachnekar | 2791054 | 2019-09-03 12:04:52 +0530 | [diff] [blame] | 5 | |
Pranav Nachanekar | 91a5649 | 2019-09-17 16:58:41 +0530 | [diff] [blame] | 6 | |
| 7 | WEEKDAYS = ["Monday", "Tuesday", "Wednesday", |
| 8 | "Thursday", "Friday", "Saturday", "Sunday"] |
| 9 | |
Pranav Nachanekar | 63dbacd | 2019-09-09 15:19:57 +0530 | [diff] [blame] | 10 | no_cache = 1 |
| 11 | |
Pranav Nachanekar | 9e36a9e | 2019-10-04 11:28:29 +0530 | [diff] [blame^] | 12 | def get_context(context): |
| 13 | is_enabled = frappe.db.get_single_value('Appointment Booking Settings','enable_scheduling') |
| 14 | if is_enabled: |
| 15 | return context |
| 16 | else: |
| 17 | raise frappe.DoesNotExistError |
Pranav Nachanekar | 110f4ea | 2019-09-09 17:04:25 +0530 | [diff] [blame] | 18 | |
pranav nachnekar | 2791054 | 2019-09-03 12:04:52 +0530 | [diff] [blame] | 19 | @frappe.whitelist(allow_guest=True) |
| 20 | def get_appointment_settings(): |
| 21 | settings = frappe.get_doc('Appointment Booking Settings') |
| 22 | return settings |
| 23 | |
Pranav Nachanekar | afe52e8 | 2019-10-03 16:35:08 +0530 | [diff] [blame] | 24 | @frappe.whitelist(allow_guest=True) |
| 25 | def is_enabled(): |
| 26 | enable_scheduling = frappe.db.get_single_value('Appointment Booking Settings','enable_scheduling') |
| 27 | return enable_scheduling |
| 28 | |
Pranav Nachanekar | 110f4ea | 2019-09-09 17:04:25 +0530 | [diff] [blame] | 29 | |
pranav nachnekar | 2791054 | 2019-09-03 12:04:52 +0530 | [diff] [blame] | 30 | @frappe.whitelist(allow_guest=True) |
| 31 | def get_holiday_list(holiday_list_name): |
Pranav Nachanekar | 110f4ea | 2019-09-09 17:04:25 +0530 | [diff] [blame] | 32 | holiday_list = frappe.get_doc('Holiday List', holiday_list_name) |
pranav nachnekar | 2791054 | 2019-09-03 12:04:52 +0530 | [diff] [blame] | 33 | return holiday_list |
| 34 | |
Pranav Nachanekar | 110f4ea | 2019-09-09 17:04:25 +0530 | [diff] [blame] | 35 | |
pranav nachnekar | 2791054 | 2019-09-03 12:04:52 +0530 | [diff] [blame] | 36 | @frappe.whitelist(allow_guest=True) |
| 37 | def get_timezones(): |
Pranav Nachanekar | 93670fe | 2019-10-03 11:58:02 +0530 | [diff] [blame] | 38 | return pytz.all_timezones |
pranav nachnekar | 2791054 | 2019-09-03 12:04:52 +0530 | [diff] [blame] | 39 | |
Pranav Nachanekar | 110f4ea | 2019-09-09 17:04:25 +0530 | [diff] [blame] | 40 | |
pranav nachnekar | 2791054 | 2019-09-03 12:04:52 +0530 | [diff] [blame] | 41 | @frappe.whitelist(allow_guest=True) |
Pranav Nachanekar | 110f4ea | 2019-09-09 17:04:25 +0530 | [diff] [blame] | 42 | def get_appointment_slots(date, timezone): |
Pranav Nachanekar | 93670fe | 2019-10-03 11:58:02 +0530 | [diff] [blame] | 43 | import pytz |
| 44 | guest_timezone = pytz.timezone(timezone) |
pranav nachnekar | 2791054 | 2019-09-03 12:04:52 +0530 | [diff] [blame] | 45 | format_string = '%Y-%m-%d %H:%M:%S' |
Pranav Nachanekar | 110f4ea | 2019-09-09 17:04:25 +0530 | [diff] [blame] | 46 | query_start_time = datetime.datetime.strptime( |
| 47 | date + ' 00:00:00', format_string) |
| 48 | query_end_time = datetime.datetime.strptime( |
| 49 | date + ' 23:59:59', format_string) |
Pranav Nachanekar | 93670fe | 2019-10-03 11:58:02 +0530 | [diff] [blame] | 50 | local_timezone = frappe.utils.get_time_zone() |
| 51 | local_timezone = pytz.timezone(local_timezone) |
| 52 | query_start_time = guest_timezone.localize(query_start_time) |
| 53 | query_end_time = guest_timezone.localize(query_end_time) |
| 54 | query_start_time = query_start_time.astimezone(local_timezone) |
| 55 | query_end_time = query_end_time.astimezone(local_timezone) |
Pranav Nachanekar | ba99945 | 2019-09-19 11:21:05 +0530 | [diff] [blame] | 56 | now = datetime.datetime.now() |
Pranav Nachanekar | 93670fe | 2019-10-03 11:58:02 +0530 | [diff] [blame] | 57 | # now = local_timezone.localize(now) |
pranav nachnekar | 2791054 | 2019-09-03 12:04:52 +0530 | [diff] [blame] | 58 | # Database queries |
| 59 | settings = frappe.get_doc('Appointment Booking Settings') |
| 60 | holiday_list = frappe.get_doc('Holiday List', settings.holiday_list) |
Pranav Nachanekar | 110f4ea | 2019-09-09 17:04:25 +0530 | [diff] [blame] | 61 | timeslots = get_available_slots_between( |
| 62 | query_start_time, query_end_time, settings) |
| 63 | |
pranav nachnekar | 2791054 | 2019-09-03 12:04:52 +0530 | [diff] [blame] | 64 | # Filter timeslots based on date |
| 65 | converted_timeslots = [] |
| 66 | for timeslot in timeslots: |
Pranav Nachanekar | 93670fe | 2019-10-03 11:58:02 +0530 | [diff] [blame] | 67 | timeslot = local_timezone.localize(timeslot) |
Pranav Nachanekar | 93670fe | 2019-10-03 11:58:02 +0530 | [diff] [blame] | 68 | timeslot = timeslot.astimezone(guest_timezone) |
| 69 | timeslot = timeslot.replace(tzinfo=None) |
pranav nachnekar | 2791054 | 2019-09-03 12:04:52 +0530 | [diff] [blame] | 70 | # Check if holiday |
Pranav Nachanekar | 110f4ea | 2019-09-09 17:04:25 +0530 | [diff] [blame] | 71 | if _is_holiday(timeslot.date(), holiday_list): |
| 72 | converted_timeslots.append( |
Pranav Nachanekar | 93670fe | 2019-10-03 11:58:02 +0530 | [diff] [blame] | 73 | dict(time=timeslot, availability=False)) |
pranav nachnekar | 2791054 | 2019-09-03 12:04:52 +0530 | [diff] [blame] | 74 | continue |
| 75 | # Check availability |
Pranav Nachanekar | ba99945 | 2019-09-19 11:21:05 +0530 | [diff] [blame] | 76 | if check_availabilty(timeslot, settings) and timeslot >= now: |
Pranav Nachanekar | 110f4ea | 2019-09-09 17:04:25 +0530 | [diff] [blame] | 77 | converted_timeslots.append( |
Pranav Nachanekar | 93670fe | 2019-10-03 11:58:02 +0530 | [diff] [blame] | 78 | dict(time=timeslot, availability=True)) |
pranav nachnekar | 2791054 | 2019-09-03 12:04:52 +0530 | [diff] [blame] | 79 | else: |
Pranav Nachanekar | 110f4ea | 2019-09-09 17:04:25 +0530 | [diff] [blame] | 80 | converted_timeslots.append( |
Pranav Nachanekar | 93670fe | 2019-10-03 11:58:02 +0530 | [diff] [blame] | 81 | dict(time=timeslot, availability=False)) |
Pranav Nachanekar | 110f4ea | 2019-09-09 17:04:25 +0530 | [diff] [blame] | 82 | date_required = datetime.datetime.strptime( |
| 83 | date + ' 00:00:00', format_string).date() |
| 84 | converted_timeslots = filter_timeslots(date_required, converted_timeslots) |
pranav nachnekar | 2791054 | 2019-09-03 12:04:52 +0530 | [diff] [blame] | 85 | return converted_timeslots |
| 86 | |
Pranav Nachanekar | 110f4ea | 2019-09-09 17:04:25 +0530 | [diff] [blame] | 87 | |
pranav nachnekar | 2791054 | 2019-09-03 12:04:52 +0530 | [diff] [blame] | 88 | def get_available_slots_between(query_start_time, query_end_time, settings): |
| 89 | records = _get_records(query_start_time, query_end_time, settings) |
| 90 | timeslots = [] |
| 91 | appointment_duration = datetime.timedelta( |
| 92 | minutes=settings.appointment_duration) |
| 93 | for record in records: |
| 94 | if record.day_of_week == WEEKDAYS[query_start_time.weekday()]: |
| 95 | current_time = _deltatime_to_datetime( |
| 96 | query_start_time, record.from_time) |
| 97 | end_time = _deltatime_to_datetime( |
| 98 | query_start_time, record.to_time) |
Pranav Nachanekar | 110f4ea | 2019-09-09 17:04:25 +0530 | [diff] [blame] | 99 | else: |
pranav nachnekar | 2791054 | 2019-09-03 12:04:52 +0530 | [diff] [blame] | 100 | current_time = _deltatime_to_datetime( |
| 101 | query_end_time, record.from_time) |
| 102 | end_time = _deltatime_to_datetime( |
| 103 | query_end_time, record.to_time) |
| 104 | while current_time + appointment_duration <= end_time: |
| 105 | timeslots.append(current_time) |
| 106 | current_time += appointment_duration |
| 107 | return timeslots |
| 108 | |
Pranav Nachanekar | 110f4ea | 2019-09-09 17:04:25 +0530 | [diff] [blame] | 109 | |
| 110 | @frappe.whitelist(allow_guest=True) |
| 111 | def create_appointment(date, time, contact): |
pranav nachnekar | c5b2a58 | 2019-09-03 14:16:47 +0530 | [diff] [blame] | 112 | appointment = frappe.new_doc('Appointment') |
| 113 | format_string = '%Y-%m-%d %H:%M:%S' |
Pranav Nachanekar | 110f4ea | 2019-09-09 17:04:25 +0530 | [diff] [blame] | 114 | appointment.scheduled_time = datetime.datetime.strptime( |
| 115 | date+" "+time, format_string) |
pranav nachnekar | c5b2a58 | 2019-09-03 14:16:47 +0530 | [diff] [blame] | 116 | contact = json.loads(contact) |
| 117 | appointment.customer_name = contact['name'] |
Pranav Nachanekar | db21f86 | 2019-09-09 17:01:40 +0530 | [diff] [blame] | 118 | appointment.customer_phone_number = contact['number'] |
pranav nachnekar | c5b2a58 | 2019-09-03 14:16:47 +0530 | [diff] [blame] | 119 | appointment.customer_skype = contact['skype'] |
| 120 | appointment.customer_details = contact['notes'] |
Pranav Nachanekar | b6b27d9 | 2019-09-23 14:16:13 +0530 | [diff] [blame] | 121 | appointment.customer_email = contact['email'] |
Pranav Nachanekar | 6f486f3 | 2019-09-10 13:12:28 +0530 | [diff] [blame] | 122 | appointment.status = 'Open' |
pranav nachnekar | c5b2a58 | 2019-09-03 14:16:47 +0530 | [diff] [blame] | 123 | appointment.insert() |
pranav nachnekar | 2791054 | 2019-09-03 12:04:52 +0530 | [diff] [blame] | 124 | |
pranav nachnekar | c5b2a58 | 2019-09-03 14:16:47 +0530 | [diff] [blame] | 125 | |
| 126 | # Helper Functions |
Pranav Nachanekar | 110f4ea | 2019-09-09 17:04:25 +0530 | [diff] [blame] | 127 | def filter_timeslots(date, timeslots): |
pranav nachnekar | 2791054 | 2019-09-03 12:04:52 +0530 | [diff] [blame] | 128 | filtered_timeslots = [] |
| 129 | for timeslot in timeslots: |
| 130 | if(timeslot['time'].date() == date): |
| 131 | filtered_timeslots.append(timeslot) |
| 132 | return filtered_timeslots |
| 133 | |
Pranav Nachanekar | 110f4ea | 2019-09-09 17:04:25 +0530 | [diff] [blame] | 134 | def check_availabilty(timeslot, settings): |
| 135 | return frappe.db.count('Appointment', {'scheduled_time': timeslot}) < settings.number_of_agents |
| 136 | |
pranav nachnekar | 2791054 | 2019-09-03 12:04:52 +0530 | [diff] [blame] | 137 | def _is_holiday(date, holiday_list): |
| 138 | for holiday in holiday_list.holidays: |
| 139 | if holiday.holiday_date == date: |
| 140 | return True |
| 141 | return False |
| 142 | |
| 143 | def _get_records(start_time, end_time, settings): |
| 144 | records = [] |
| 145 | for record in settings.availability_of_slots: |
| 146 | if record.day_of_week == WEEKDAYS[start_time.weekday()] or record.day_of_week == WEEKDAYS[end_time.weekday()]: |
| 147 | records.append(record) |
| 148 | return records |
| 149 | |
| 150 | def _deltatime_to_datetime(date, deltatime): |
| 151 | time = (datetime.datetime.min + deltatime).time() |
| 152 | return datetime.datetime.combine(date.date(), time) |
| 153 | |
| 154 | def _datetime_to_deltatime(date_time): |
Pranav Nachanekar | 110f4ea | 2019-09-09 17:04:25 +0530 | [diff] [blame] | 155 | midnight = datetime.datetime.combine(date_time.date(), datetime.time.min) |
Pranav Nachanekar | 93670fe | 2019-10-03 11:58:02 +0530 | [diff] [blame] | 156 | return (date_time-midnight) |