consulta.py 5.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130
  1. # -*- coding: utf-8 -*-
  2. from openerp import models, fields, api
  3. class ClinicMedicvisit(models.Model):
  4. _inherit = 'clinic.history'
  5. @api.model
  6. def getClinicMedicvisit(self,domain):
  7. ClinicMedicvisit = self.env['clinic.history'].search(domain)
  8. values = []
  9. for clinichistory in ClinicMedicvisit:
  10. try:
  11. street = clinichistory.partner_id.street
  12. except Exception as e:
  13. street = ''
  14. values.append({
  15. # ID
  16. 'id': clinichistory.id,
  17. # WORKORDER INFO
  18. 'name': clinichistory.name or "",
  19. 'user_name': clinichistory.user_id.name or "",
  20. 'paramedico_name': clinichistory.paramedico_id.name or "",
  21. 'order_date': clinichistory.order_date or "",
  22. 'name_movil': clinichistory.name_movil or "",
  23. 'at_base': clinichistory.at_base or "",
  24. 'nro_salida': clinichistory.nro_salida or "",
  25. 'planned_start_date': clinichistory.planned_start_date or "",
  26. 'programado': clinichistory.programado or "",
  27. 'edad_paciente': clinichistory.edad_paciente or "",
  28. 'antig_trabajo': clinichistory.antig_trabajo or "",
  29. 'planned_end_date': clinichistory.planned_end_date or "",
  30. 'lugar_visita': clinichistory.lugar_visita or "",
  31. 'tipo_paciente': clinichistory.tipo_paciente or "",
  32. 'uso_gel': clinichistory.uso_gel or "",
  33. 'seguro': clinichistory.seguro or "",
  34. 'nro_socio': clinichistory.nro_socio or "",
  35. 'alergico': clinichistory.alergico or "",
  36. 'tipo_alergico': clinichistory.tipo_alergico or "",
  37. 'embarazada': clinichistory.embarazada or "",
  38. 'antecedente_paciente': clinichistory.antecedente_paciente or "",
  39. 'respuesta_tratamiento': clinichistory.respuesta_tratamiento or "",
  40. 'pa': clinichistory.pa or "",
  41. 'fc': clinichistory.fc or "",
  42. 'fr': clinichistory.fr or "",
  43. 'temp': clinichistory.temp or "",
  44. 'so': clinichistory.so or "",
  45. 'hgt': clinichistory.hgt or "",
  46. 'motivo': clinichistory.motivo or "",
  47. 'diagnostic': clinichistory.diagnostic or "",
  48. 'indicacion': clinichistory.indicacion or "",
  49. 'recommendations': clinichistory.recommendations or "",
  50. 'epicrisis': clinichistory.epicrisis or "",
  51. 'presuntivo': clinichistory.presuntivo or "",
  52. 'clasificacion': clinichistory.clasificacion or "",
  53. 'informado': clinichistory.informado or "",
  54. 'entregado': clinichistory.entregado or "",
  55. 'signature_image_paramedico': clinichistory.signature_image_paramedico or "",
  56. 'signature_image_medico': clinichistory.signature_image_medico or "",
  57. 'signature_image_paciente': clinichistory.signature_image_paciente or "",
  58. # PARTNER INFO
  59. 'partner_id': clinichistory.partner_id.id or "",
  60. 'partner_name': clinichistory.partner_id.name or "",
  61. 'partner_ruc': clinichistory.partner_id.ruc or "",
  62. 'partner_address': street or "",
  63. 'partner_phone': clinichistory.partner_id.phone or "",
  64. 'partner_mobile': clinichistory.partner_id.mobile or "",
  65. 'partner_fecha_nac ': clinichistory.partner_id.fecha_nac or "",
  66. 'partner_sexo': clinichistory.partner_id.sexo or "",
  67. # COMPANY INFO
  68. 'company_id': clinichistory.user_id.company_id.id or "",
  69. 'company_name': clinichistory.user_id.company_id.name or "",
  70. 'company_logo': clinichistory.user_id.company_id.logo or "",
  71. 'company_address': clinichistory.user_id.company_id.street2 or "",
  72. 'company_phone': clinichistory.user_id.company_id.phone or "",
  73. 'vat': clinichistory.user_id.company_id.vat or "",
  74. # USER INFO
  75. 'user_id': clinichistory.user_id.id or "",
  76. 'user_image': clinichistory.user_id.image or "",
  77. })
  78. return values
  79. class ClinicMedicvisitLine(models.Model):
  80. _inherit = 'clinic.history.line'
  81. @api.model
  82. def getClinicMedicvisitLine(self,domain):
  83. ClinicMedicvisitLine = self.env['clinic.history.line'].search(domain)
  84. values = []
  85. for line in ClinicMedicvisitLine:
  86. values.append({
  87. # ID
  88. 'id': line.id,
  89. # LINE INFO
  90. 'clinichistory_id': line.clinichistory_id.id,
  91. 'description': line.description or "",
  92. 'quantity': line.quantity or "",
  93. 'brand': line.brand or "",
  94. 'number': line.number or "",
  95. })
  96. return values
  97. class ClinicInsumosvisitLine(models.Model):
  98. _inherit = 'clinic.insumos.line'
  99. @api.model
  100. def getClinicInsumosvisitLine(self,domain):
  101. ClinicInsumosvisitLine = self.env['clinic.insumos.line'].search(domain)
  102. values = []
  103. for line in ClinicInsumosvisitLine:
  104. values.append({
  105. # ID
  106. 'id': line.id,
  107. # LINE INFO
  108. 'clinicinsumos_id': line.clinichistory_id.id,
  109. 'product_id':[
  110. line.product_id.id,
  111. line.product_id.name,
  112. ],
  113. 'quantity': line.quantity or "",
  114. 'brand': line.brand or "",
  115. 'number': line.number or "",
  116. })
  117. return values