consulta.py 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147
  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. 'respuesta_tratamiento': clinichistory.respuesta_tratamiento or "",
  39. 'pa': clinichistory.pa or "",
  40. 'fc': clinichistory.fc or "",
  41. 'fr': clinichistory.fr or "",
  42. 'temp': clinichistory.temp or "",
  43. 'so': clinichistory.so or "",
  44. 'hgt': clinichistory.hgt or "",
  45. 'ost': clinichistory.ost or "",
  46. 'asm': clinichistory.asm or "",
  47. 'card': clinichistory.card or "",
  48. 'acv': clinichistory.acv or "",
  49. 'conv': clinichistory.conv or "",
  50. 'hta': clinichistory.hta or "",
  51. 'epoc': clinichistory.epoc or "",
  52. 'otro': clinichistory.otro or "",
  53. 'motivo': clinichistory.motivo or "",
  54. 'diagnostic': clinichistory.diagnostic or "",
  55. 'indicacion': clinichistory.indicacion or "",
  56. 'recommendations': clinichistory.recommendations or "",
  57. 'epicrisis': clinichistory.epicrisis or "",
  58. 'presuntivo': clinichistory.presuntivo or "",
  59. 'clasificacion': clinichistory.clasificacion or "",
  60. 'informado': clinichistory.informado or "",
  61. 'entregado': clinichistory.entregado or "",
  62. 'signature_image_paramedico': clinichistory.signature_image_paramedico or "",
  63. 'signature_image_medico': clinichistory.signature_image_medico or "",
  64. 'signature_image_paciente': clinichistory.signature_image_paciente or "",
  65. # PARTNER INFO
  66. 'partner_id': clinichistory.partner_id.id or "",
  67. 'partner_name': clinichistory.partner_id.name or "",
  68. 'paciente_id': clinichistory.paciente_id.id or "",
  69. 'paciente_name': clinichistory.paciente_id.name or "",
  70. 'partner_ruc': clinichistory.partner_id.ruc or "",
  71. 'partner_address': street or "",
  72. 'partner_phone': clinichistory.partner_id.phone or "",
  73. 'partner_mobile': clinichistory.partner_id.mobile or "",
  74. 'partner_fecha_nac ': clinichistory.partner_id.fecha_nac or "",
  75. 'partner_sexo': clinichistory.partner_id.sexo or "",
  76. # COMPANY INFO
  77. 'company_id': clinichistory.user_id.company_id.id or "",
  78. 'company_name': clinichistory.user_id.company_id.name or "",
  79. 'company_logo': clinichistory.user_id.company_id.logo or "",
  80. 'company_address': clinichistory.user_id.company_id.street2 or "",
  81. 'company_phone': clinichistory.user_id.company_id.phone or "",
  82. 'vat': clinichistory.user_id.company_id.vat or "",
  83. # USER INFO
  84. 'user_id': clinichistory.user_id.id or "",
  85. 'user_image': clinichistory.user_id.image or "",
  86. })
  87. return values
  88. class ClinicMedicvisitLine(models.Model):
  89. _inherit = 'clinic.history.line'
  90. @api.model
  91. def getClinicMedicvisitLine(self,domain):
  92. ClinicMedicvisitLine = self.env['clinic.history.line'].search(domain)
  93. values = []
  94. for line in ClinicMedicvisitLine:
  95. values.append({
  96. # ID
  97. 'id': line.id,
  98. # LINE INFO
  99. 'clinichistory_id': line.clinichistory_id.id,
  100. 'product_id':[
  101. line.product_id.id,
  102. line.product_id.name,
  103. ],
  104. 'quantity': line.quantity or "",
  105. 'brand': line.brand or "",
  106. 'number': line.number or "",
  107. })
  108. return values
  109. class ClinicInsumosvisitLine(models.Model):
  110. _inherit = 'clinic.insumos.line'
  111. @api.model
  112. def getClinicInsumosvisitLine(self,domain):
  113. ClinicInsumosvisitLine = self.env['clinic.insumos.line'].search(domain)
  114. values = []
  115. for line in ClinicInsumosvisitLine:
  116. values.append({
  117. # ID
  118. 'id': line.id,
  119. # LINE INFO
  120. 'clinicinsumos_id': line.clinichistory_id.id,
  121. 'product_id':[
  122. line.product_id.id,
  123. line.product_id.name,
  124. ],
  125. 'quantity': line.quantity or "",
  126. 'brand': line.brand or "",
  127. 'number': line.number or "",
  128. })
  129. return values