Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 1 | # -*- coding: utf-8 -*- |
| 2 | # Copyright (c) 2018, earthians and contributors |
| 3 | # For license information, please see license.txt |
| 4 | |
| 5 | from __future__ import unicode_literals |
| 6 | import frappe |
| 7 | import datetime |
| 8 | from frappe import _ |
Jamsheer | 25dda3a | 2018-07-30 14:50:16 +0530 | [diff] [blame] | 9 | import math |
| 10 | from frappe.utils import time_diff_in_hours, rounded |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 11 | from erpnext.healthcare.doctype.healthcare_settings.healthcare_settings import get_income_account |
| 12 | from erpnext.healthcare.doctype.patient_appointment.patient_appointment import validity_exists |
| 13 | from erpnext.healthcare.doctype.fee_validity.fee_validity import create_fee_validity, update_fee_validity |
| 14 | |
| 15 | @frappe.whitelist() |
| 16 | def get_healthcare_services_to_invoice(patient): |
| 17 | patient = frappe.get_doc("Patient", patient) |
| 18 | if patient: |
| 19 | if patient.customer: |
| 20 | item_to_invoice = [] |
| 21 | patient_appointments = frappe.get_list("Patient Appointment",{'patient': patient.name, 'invoiced': False}, |
| 22 | order_by="appointment_date") |
| 23 | if patient_appointments: |
| 24 | fee_validity_details = [] |
| 25 | valid_days = frappe.db.get_value("Healthcare Settings", None, "valid_days") |
| 26 | max_visit = frappe.db.get_value("Healthcare Settings", None, "max_visit") |
| 27 | for patient_appointment in patient_appointments: |
| 28 | patient_appointment_obj = frappe.get_doc("Patient Appointment", patient_appointment['name']) |
| 29 | |
| 30 | if patient_appointment_obj.procedure_template: |
| 31 | if frappe.db.get_value("Clinical Procedure Template", patient_appointment_obj.procedure_template, "is_billable") == 1: |
| 32 | item_to_invoice.append({'reference_type': 'Patient Appointment', 'reference_name': patient_appointment_obj.name, 'service': patient_appointment_obj.procedure_template}) |
| 33 | else: |
| 34 | practitioner_exist_in_list = False |
| 35 | skip_invoice = False |
| 36 | if fee_validity_details: |
| 37 | for validity in fee_validity_details: |
| 38 | if validity['practitioner'] == patient_appointment_obj.practitioner: |
| 39 | practitioner_exist_in_list = True |
| 40 | if validity['valid_till'] >= patient_appointment_obj.appointment_date: |
| 41 | validity['visits'] = validity['visits']+1 |
| 42 | if int(max_visit) > validity['visits']: |
| 43 | skip_invoice = True |
| 44 | if not skip_invoice: |
| 45 | validity['visits'] = 1 |
| 46 | validity['valid_till'] = patient_appointment_obj.appointment_date + datetime.timedelta(days=int(valid_days)) |
| 47 | if not practitioner_exist_in_list: |
| 48 | valid_till = patient_appointment_obj.appointment_date + datetime.timedelta(days=int(valid_days)) |
| 49 | visits = 0 |
| 50 | validity_exist = validity_exists(patient_appointment_obj.practitioner, patient_appointment_obj.patient) |
| 51 | if validity_exist: |
| 52 | fee_validity = frappe.get_doc("Fee Validity", validity_exist[0][0]) |
| 53 | valid_till = fee_validity.valid_till |
| 54 | visits = fee_validity.visited |
| 55 | fee_validity_details.append({'practitioner': patient_appointment_obj.practitioner, |
| 56 | 'valid_till': valid_till, 'visits': visits}) |
| 57 | |
| 58 | if not skip_invoice: |
| 59 | practitioner_charge = 0 |
| 60 | income_account = None |
Jamsheer | 8da6f4e | 2018-07-26 21:03:17 +0530 | [diff] [blame] | 61 | service_item = None |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 62 | if patient_appointment_obj.practitioner: |
Jamsheer | 8da6f4e | 2018-07-26 21:03:17 +0530 | [diff] [blame] | 63 | service_item, practitioner_charge = service_item_and_practitioner_charge(patient_appointment_obj) |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 64 | income_account = get_income_account(patient_appointment_obj.practitioner, patient_appointment_obj.company) |
| 65 | item_to_invoice.append({'reference_type': 'Patient Appointment', 'reference_name': patient_appointment_obj.name, |
Jamsheer | 8da6f4e | 2018-07-26 21:03:17 +0530 | [diff] [blame] | 66 | 'service': service_item, 'rate': practitioner_charge, |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 67 | 'income_account': income_account}) |
| 68 | |
| 69 | encounters = frappe.get_list("Patient Encounter", {'patient': patient.name, 'invoiced': False, 'docstatus': 1}) |
| 70 | if encounters: |
| 71 | for encounter in encounters: |
| 72 | encounter_obj = frappe.get_doc("Patient Encounter", encounter['name']) |
| 73 | if not encounter_obj.appointment: |
| 74 | practitioner_charge = 0 |
| 75 | income_account = None |
Jamsheer | 8da6f4e | 2018-07-26 21:03:17 +0530 | [diff] [blame] | 76 | service_item = None |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 77 | if encounter_obj.practitioner: |
Jamsheer | 8da6f4e | 2018-07-26 21:03:17 +0530 | [diff] [blame] | 78 | service_item, practitioner_charge = service_item_and_practitioner_charge(encounter_obj) |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 79 | income_account = get_income_account(encounter_obj.practitioner, encounter_obj.company) |
Jamsheer | 8da6f4e | 2018-07-26 21:03:17 +0530 | [diff] [blame] | 80 | |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 81 | item_to_invoice.append({'reference_type': 'Patient Encounter', 'reference_name': encounter_obj.name, |
Jamsheer | 8da6f4e | 2018-07-26 21:03:17 +0530 | [diff] [blame] | 82 | 'service': service_item, 'rate': practitioner_charge, |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 83 | 'income_account': income_account}) |
| 84 | |
| 85 | lab_tests = frappe.get_list("Lab Test", {'patient': patient.name, 'invoiced': False}) |
| 86 | if lab_tests: |
| 87 | for lab_test in lab_tests: |
| 88 | lab_test_obj = frappe.get_doc("Lab Test", lab_test['name']) |
| 89 | if frappe.db.get_value("Lab Test Template", lab_test_obj.template, "is_billable") == 1: |
Jamsheer | 8da6f4e | 2018-07-26 21:03:17 +0530 | [diff] [blame] | 90 | item_to_invoice.append({'reference_type': 'Lab Test', 'reference_name': lab_test_obj.name, |
| 91 | 'service': frappe.db.get_value("Lab Test Template", lab_test_obj.template, "item")}) |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 92 | |
| 93 | lab_rxs = frappe.db.sql("""select lp.name from `tabPatient Encounter` et, |
| 94 | `tabLab Prescription` lp where et.patient=%s and lp.parent=et.name and lp.test_created=0 and lp.invoiced=0""", (patient.name)) |
| 95 | if lab_rxs: |
| 96 | for lab_rx in lab_rxs: |
| 97 | rx_obj = frappe.get_doc("Lab Prescription", lab_rx[0]) |
| 98 | if rx_obj.test_code and (frappe.db.get_value("Lab Test Template", rx_obj.test_code, "is_billable") == 1): |
Jamsheer | 8da6f4e | 2018-07-26 21:03:17 +0530 | [diff] [blame] | 99 | item_to_invoice.append({'reference_type': 'Lab Prescription', 'reference_name': rx_obj.name, |
| 100 | 'service': frappe.db.get_value("Lab Test Template", rx_obj.test_code, "item")}) |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 101 | |
| 102 | procedures = frappe.get_list("Clinical Procedure", {'patient': patient.name, 'invoiced': False}) |
| 103 | if procedures: |
| 104 | for procedure in procedures: |
| 105 | procedure_obj = frappe.get_doc("Clinical Procedure", procedure['name']) |
| 106 | if not procedure_obj.appointment: |
| 107 | if procedure_obj.procedure_template and (frappe.db.get_value("Clinical Procedure Template", procedure_obj.procedure_template, "is_billable") == 1): |
Jamsheer | 8da6f4e | 2018-07-26 21:03:17 +0530 | [diff] [blame] | 108 | item_to_invoice.append({'reference_type': 'Clinical Procedure', 'reference_name': procedure_obj.name, |
| 109 | 'service': frappe.db.get_value("Clinical Procedure Template", procedure_obj.procedure_template, "item")}) |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 110 | |
| 111 | procedure_rxs = frappe.db.sql("""select pp.name from `tabPatient Encounter` et, |
| 112 | `tabProcedure Prescription` pp where et.patient=%s and pp.parent=et.name and |
| 113 | pp.procedure_created=0 and pp.invoiced=0 and pp.appointment_booked=0""", (patient.name)) |
| 114 | if procedure_rxs: |
| 115 | for procedure_rx in procedure_rxs: |
| 116 | rx_obj = frappe.get_doc("Procedure Prescription", procedure_rx[0]) |
| 117 | if frappe.db.get_value("Clinical Procedure Template", rx_obj.procedure, "is_billable") == 1: |
Jamsheer | 8da6f4e | 2018-07-26 21:03:17 +0530 | [diff] [blame] | 118 | item_to_invoice.append({'reference_type': 'Procedure Prescription', 'reference_name': rx_obj.name, |
| 119 | 'service': frappe.db.get_value("Clinical Procedure Template", rx_obj.procedure, "item")}) |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 120 | |
Jamsheer | 8da6f4e | 2018-07-26 21:03:17 +0530 | [diff] [blame] | 121 | procedures = frappe.get_list("Clinical Procedure", |
| 122 | {'patient': patient.name, 'invoice_separately_as_consumables': True, 'consumption_invoiced': False, |
| 123 | 'consume_stock': True, 'status': 'Completed'}) |
| 124 | if procedures: |
| 125 | service_item = get_healthcare_service_item('clinical_procedure_consumable_item') |
| 126 | if not service_item: |
| 127 | msg = _(("Please Configure {0} in ").format("Clinical Procedure Consumable Item") \ |
| 128 | + """<b><a href="#Form/Healthcare Settings">Healthcare Settings</a></b>""") |
| 129 | frappe.throw(msg) |
| 130 | for procedure in procedures: |
| 131 | procedure_obj = frappe.get_doc("Clinical Procedure", procedure['name']) |
| 132 | item_to_invoice.append({'reference_type': 'Clinical Procedure', 'reference_name': procedure_obj.name, |
| 133 | 'service': service_item, 'rate': procedure_obj.consumable_total_amount, 'description': procedure_obj.consumption_details}) |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 134 | |
Jamsheer | 54ae74e | 2018-07-13 21:10:14 +0530 | [diff] [blame] | 135 | inpatient_services = frappe.db.sql("""select io.name, io.parent from `tabInpatient Record` ip, |
| 136 | `tabInpatient Occupancy` io where ip.patient=%s and io.parent=ip.name and |
| 137 | io.left=1 and io.invoiced=0""", (patient.name)) |
| 138 | if inpatient_services: |
| 139 | for inpatient_service in inpatient_services: |
| 140 | inpatient_occupancy = frappe.get_doc("Inpatient Occupancy", inpatient_service[0]) |
| 141 | service_unit_type = frappe.get_doc("Healthcare Service Unit Type", frappe.db.get_value("Healthcare Service Unit", inpatient_occupancy.service_unit, "service_unit_type")) |
| 142 | if service_unit_type and service_unit_type.is_billable == 1: |
Jamsheer | 25dda3a | 2018-07-30 14:50:16 +0530 | [diff] [blame] | 143 | hours_occupied = time_diff_in_hours(inpatient_occupancy.check_out, inpatient_occupancy.check_in) |
| 144 | qty = 0.5 |
| 145 | if hours_occupied > 0: |
| 146 | actual_qty = hours_occupied / service_unit_type.no_of_hours |
| 147 | floor = math.floor(actual_qty) |
| 148 | decimal_part = actual_qty - floor |
| 149 | if decimal_part > 0.5: |
| 150 | qty = rounded(floor + 1, 1) |
| 151 | elif decimal_part < 0.5 and decimal_part > 0: |
| 152 | qty = rounded(floor + 0.5, 1) |
| 153 | if qty <= 0: |
| 154 | qty = 0.5 |
Jamsheer | 54ae74e | 2018-07-13 21:10:14 +0530 | [diff] [blame] | 155 | item_to_invoice.append({'reference_type': 'Inpatient Occupancy', 'reference_name': inpatient_occupancy.name, |
| 156 | 'service': service_unit_type.item, 'qty': qty}) |
| 157 | |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 158 | return item_to_invoice |
| 159 | else: |
| 160 | frappe.throw(_("The Patient {0} do not have customer refrence to invoice").format(patient.name)) |
| 161 | |
Jamsheer | 8da6f4e | 2018-07-26 21:03:17 +0530 | [diff] [blame] | 162 | def service_item_and_practitioner_charge(doc): |
| 163 | is_ip = doc_is_ip(doc) |
| 164 | if is_ip: |
Jamsheer | ee5f9c7 | 2018-07-30 12:42:06 +0530 | [diff] [blame] | 165 | service_item = get_practitioner_service_item(doc.practitioner, "inpatient_visit_charge_item") |
| 166 | if not service_item: |
| 167 | service_item = get_healthcare_service_item("inpatient_visit_charge_item") |
Jamsheer | 8da6f4e | 2018-07-26 21:03:17 +0530 | [diff] [blame] | 168 | else: |
Jamsheer | ee5f9c7 | 2018-07-30 12:42:06 +0530 | [diff] [blame] | 169 | service_item = get_practitioner_service_item(doc.practitioner, "op_consulting_charge_item") |
| 170 | if not service_item: |
| 171 | service_item = get_healthcare_service_item("op_consulting_charge_item") |
Jamsheer | 8da6f4e | 2018-07-26 21:03:17 +0530 | [diff] [blame] | 172 | if not service_item: |
| 173 | throw_config_service_item(is_ip) |
| 174 | |
| 175 | practitioner_charge = get_practitioner_charge(doc.practitioner, is_ip) |
| 176 | if not practitioner_charge: |
| 177 | throw_config_practitioner_charge(is_ip, doc.practitioner) |
| 178 | |
| 179 | return service_item, practitioner_charge |
| 180 | |
| 181 | def throw_config_service_item(is_ip): |
| 182 | service_item_lable = "Out Patient Consulting Charge Item" |
| 183 | if is_ip: |
| 184 | service_item_lable = "Inpatient Visit Charge Item" |
| 185 | |
| 186 | msg = _(("Please Configure {0} in ").format(service_item_lable) \ |
| 187 | + """<b><a href="#Form/Healthcare Settings">Healthcare Settings</a></b>""") |
| 188 | frappe.throw(msg) |
| 189 | |
| 190 | def throw_config_practitioner_charge(is_ip, practitioner): |
| 191 | charge_name = "OP Consulting Charge" |
| 192 | if is_ip: |
| 193 | charge_name = "Inpatient Visit Charge" |
| 194 | |
| 195 | msg = _(("Please Configure {0} for Healthcare Practitioner").format(charge_name) \ |
| 196 | + """ <b><a href="#Form/Healthcare Practitioner/{0}">{0}</a></b>""".format(practitioner)) |
| 197 | frappe.throw(msg) |
| 198 | |
Jamsheer | ee5f9c7 | 2018-07-30 12:42:06 +0530 | [diff] [blame] | 199 | def get_practitioner_service_item(practitioner, service_item_field): |
| 200 | return frappe.db.get_value("Healthcare Practitioner", practitioner, service_item_field) |
| 201 | |
Jamsheer | 8da6f4e | 2018-07-26 21:03:17 +0530 | [diff] [blame] | 202 | def get_healthcare_service_item(service_item_field): |
| 203 | return frappe.db.get_value("Healthcare Settings", None, service_item_field) |
| 204 | |
| 205 | def doc_is_ip(doc): |
| 206 | is_ip = False |
| 207 | if doc.inpatient_record: |
| 208 | is_ip = True |
| 209 | return is_ip |
| 210 | |
| 211 | def get_practitioner_charge(practitioner, is_ip): |
| 212 | if is_ip: |
| 213 | practitioner_charge = frappe.db.get_value("Healthcare Practitioner", practitioner, "inpatient_visit_charge") |
| 214 | else: |
| 215 | practitioner_charge = frappe.db.get_value("Healthcare Practitioner", practitioner, "op_consulting_charge") |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 216 | if practitioner_charge: |
| 217 | return practitioner_charge |
Jamsheer | 8da6f4e | 2018-07-26 21:03:17 +0530 | [diff] [blame] | 218 | return False |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 219 | |
| 220 | def manage_invoice_submit_cancel(doc, method): |
| 221 | if doc.items: |
| 222 | for item in doc.items: |
| 223 | if item.reference_dt and item.reference_dn: |
| 224 | if frappe.get_meta(item.reference_dt).has_field("invoiced"): |
Jamsheer | 146683b | 2018-07-25 11:30:30 +0530 | [diff] [blame] | 225 | set_invoiced(item, method, doc.name) |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 226 | |
Jamsheer | 146683b | 2018-07-25 11:30:30 +0530 | [diff] [blame] | 227 | def set_invoiced(item, method, ref_invoice=None): |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 228 | invoiced = False |
| 229 | if(method=="on_submit"): |
| 230 | validate_invoiced_on_submit(item) |
| 231 | invoiced = True |
| 232 | |
Jamsheer | 8da6f4e | 2018-07-26 21:03:17 +0530 | [diff] [blame] | 233 | if item.reference_dt == 'Clinical Procedure': |
| 234 | if get_healthcare_service_item('clinical_procedure_consumable_item') == item.item_code: |
| 235 | frappe.db.set_value(item.reference_dt, item.reference_dn, "consumption_invoiced", invoiced) |
| 236 | else: |
| 237 | frappe.db.set_value(item.reference_dt, item.reference_dn, "invoiced", invoiced) |
| 238 | else: |
| 239 | frappe.db.set_value(item.reference_dt, item.reference_dn, "invoiced", invoiced) |
| 240 | |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 241 | if item.reference_dt == 'Patient Appointment': |
| 242 | if frappe.db.get_value('Patient Appointment', item.reference_dn, 'procedure_template'): |
| 243 | dt_from_appointment = "Clinical Procedure" |
| 244 | else: |
Jamsheer | 146683b | 2018-07-25 11:30:30 +0530 | [diff] [blame] | 245 | manage_fee_validity(item.reference_dn, method, ref_invoice) |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 246 | dt_from_appointment = "Patient Encounter" |
| 247 | manage_doc_for_appoitnment(dt_from_appointment, item.reference_dn, invoiced) |
| 248 | |
| 249 | elif item.reference_dt == 'Lab Prescription': |
| 250 | manage_prescriptions(invoiced, item.reference_dt, item.reference_dn, "Lab Test", "test_created") |
| 251 | |
| 252 | elif item.reference_dt == 'Procedure Prescription': |
| 253 | manage_prescriptions(invoiced, item.reference_dt, item.reference_dn, "Clinical Procedure", "procedure_created") |
| 254 | |
| 255 | def validate_invoiced_on_submit(item): |
Jamsheer | 8da6f4e | 2018-07-26 21:03:17 +0530 | [diff] [blame] | 256 | if item.reference_dt == 'Clinical Procedure' and get_healthcare_service_item('clinical_procedure_consumable_item') == item.item_code: |
| 257 | is_invoiced = frappe.db.get_value(item.reference_dt, item.reference_dn, "consumption_invoiced") |
| 258 | else: |
| 259 | is_invoiced = frappe.db.get_value(item.reference_dt, item.reference_dn, "invoiced") |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 260 | if is_invoiced == 1: |
| 261 | frappe.throw(_("The item referenced by {0} - {1} is already invoiced"\ |
| 262 | ).format(item.reference_dt, item.reference_dn)) |
| 263 | |
| 264 | def manage_prescriptions(invoiced, ref_dt, ref_dn, dt, created_check_field): |
| 265 | created = frappe.db.get_value(ref_dt, ref_dn, created_check_field) |
| 266 | if created == 1: |
| 267 | # Fetch the doc created for the prescription |
Jamsheer | eafb046 | 2018-07-25 13:15:12 +0530 | [diff] [blame] | 268 | doc_created = frappe.db.get_value(dt, {'prescription': ref_dn}) |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 269 | frappe.db.set_value(dt, doc_created, 'invoiced', invoiced) |
| 270 | |
Jamsheer | 146683b | 2018-07-25 11:30:30 +0530 | [diff] [blame] | 271 | def manage_fee_validity(appointment_name, method, ref_invoice=None): |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 272 | appointment_doc = frappe.get_doc("Patient Appointment", appointment_name) |
| 273 | validity_exist = validity_exists(appointment_doc.practitioner, appointment_doc.patient) |
| 274 | do_not_update = False |
| 275 | visited = 0 |
| 276 | if validity_exist: |
| 277 | fee_validity = frappe.get_doc("Fee Validity", validity_exist[0][0]) |
| 278 | # Check if the validity is valid |
| 279 | if (fee_validity.valid_till >= appointment_doc.appointment_date): |
| 280 | if (method == "on_cancel" and appointment_doc.status != "Closed"): |
| 281 | visited = fee_validity.visited - 1 |
| 282 | if visited < 0: |
| 283 | visited = 0 |
| 284 | frappe.db.set_value("Fee Validity", fee_validity.name, "visited", visited) |
| 285 | do_not_update = True |
| 286 | elif (fee_validity.visited < fee_validity.max_visit): |
| 287 | visited = fee_validity.visited + 1 |
| 288 | frappe.db.set_value("Fee Validity", fee_validity.name, "visited", visited) |
| 289 | do_not_update = True |
| 290 | else: |
| 291 | do_not_update = False |
| 292 | |
| 293 | if not do_not_update: |
Jamsheer | 146683b | 2018-07-25 11:30:30 +0530 | [diff] [blame] | 294 | fee_validity = update_fee_validity(fee_validity, appointment_doc.appointment_date, ref_invoice) |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 295 | visited = fee_validity.visited |
| 296 | else: |
Jamsheer | 146683b | 2018-07-25 11:30:30 +0530 | [diff] [blame] | 297 | fee_validity = create_fee_validity(appointment_doc.practitioner, appointment_doc.patient, appointment_doc.appointment_date, ref_invoice) |
Jamsheer | ba11972 | 2018-07-06 15:58:13 +0530 | [diff] [blame] | 298 | visited = fee_validity.visited |
| 299 | |
| 300 | # Mark All Patient Appointment invoiced = True in the validity range do not cross the max visit |
| 301 | if (method == "on_cancel"): |
| 302 | invoiced = True |
| 303 | else: |
| 304 | invoiced = False |
| 305 | patient_appointments = frappe.get_list("Patient Appointment",{'patient': fee_validity.patient, 'invoiced': invoiced, |
| 306 | 'appointment_date':("<=", fee_validity.valid_till), 'practitioner': fee_validity.practitioner}, order_by="appointment_date") |
| 307 | if patient_appointments and fee_validity: |
| 308 | visit = visited |
| 309 | for appointment in patient_appointments: |
| 310 | if (method == "on_cancel" and appointment.status != "Closed"): |
| 311 | visited = visited - 1 |
| 312 | if visited < 0: |
| 313 | visited = 0 |
| 314 | frappe.db.set_value("Fee Validity", fee_validity.name, "visited", visited) |
| 315 | frappe.db.set_value("Patient Appointment", appointment.name, "invoiced", False) |
| 316 | manage_doc_for_appoitnment("Patient Encounter", appointment.name, False) |
| 317 | elif int(fee_validity.max_visit) > visit: |
| 318 | visited = visited + 1 |
| 319 | frappe.db.set_value("Fee Validity", fee_validity.name, "visited", visited) |
| 320 | frappe.db.set_value("Patient Appointment", appointment.name, "invoiced", True) |
| 321 | manage_doc_for_appoitnment("Patient Encounter", appointment.name, True) |
| 322 | visit = visit + 1 |
| 323 | |
| 324 | def manage_doc_for_appoitnment(dt_from_appointment, appointment, invoiced): |
| 325 | dn_from_appointment = frappe.db.exists( |
| 326 | dt_from_appointment, |
| 327 | { |
| 328 | "appointment": appointment |
| 329 | } |
| 330 | ) |
| 331 | if dn_from_appointment: |
| 332 | frappe.db.set_value(dt_from_appointment, dn_from_appointment, "invoiced", invoiced) |
Jamsheer | e82f27a | 2018-07-30 11:28:37 +0530 | [diff] [blame] | 333 | |
| 334 | @frappe.whitelist() |
| 335 | def get_drugs_to_invoice(encounter): |
| 336 | encounter = frappe.get_doc("Patient Encounter", encounter) |
| 337 | if encounter: |
| 338 | patient = frappe.get_doc("Patient", encounter.patient) |
| 339 | if patient and patient.customer: |
| 340 | item_to_invoice = [] |
| 341 | for drug_line in encounter.drug_prescription: |
| 342 | if drug_line.drug_code: |
| 343 | qty = 1 |
| 344 | if frappe.db.get_value("Item", drug_line.drug_code, "stock_uom") == "Nos": |
| 345 | qty = drug_line.get_quantity() |
| 346 | item_to_invoice.append({'drug_code': drug_line.drug_code, 'quantity': qty, |
| 347 | 'description': drug_line.dosage+" for "+drug_line.period}) |
| 348 | return item_to_invoice |