Work Order Reprogramming allows you to create new schedule versions of existing work orders while maintaining the link to the original order. Reprogrammed orders (Type 5) inherit key properties from their parent Initial Orders (Type 4) but allow updated schedules, resources, and budgets.
Reprogrammed orders maintain a link to the original work order through the ot_principal field and are sequentially numbered via num_reprogramacion.
Two computed properties help track reprogramming relationships:
operaciones/models/ote_models.py
@propertydef tiene_reprogramaciones(self): """Retorna True si esta OT tiene reprogramaciones asociadas""" if self.id_tipo_id != 4: # Solo para OTs iniciales return False return OTE.objects.filter( ot_principal=self.id, id_tipo_id=5, estatus__in=[-1, 1] ).exists()@propertydef count_reprogramaciones(self): """Retorna el número de reprogramaciones asociadas""" if self.id_tipo_id != 4: return 0 return OTE.objects.filter( ot_principal=self.id, id_tipo_id=5, estatus__in=[-1, 1] ).count()
tiene_reprogramaciones
Boolean check if initial order has active reprogrammed versions
count_reprogramaciones
Count of active reprogrammed orders linked to this initial order
These properties only return meaningful data for Initial Orders (Type 4). They filter for active status (-1 or 1) to exclude logically deleted records.
To populate the Initial Order selector when creating reprogrammed orders:
operaciones/views/ote.py
@require_http_methods(["GET"])def obtener_ots_principales(request): """Obtener todas las OTs para el selector de OT principal""" try: ot_id = request.GET.get('ot_id') ots = OTE.objects.filter( id_tipo=4, ).exclude( estatus=0, ).values('id', 'orden_trabajo', 'descripcion_trabajo', 'oficio_ot').order_by('-id') data = list(ots) return JsonResponse(data, safe=False) except Exception as e: return JsonResponse([], safe=False)
The system includes a comprehensive import script for historical work orders with reprogramming:
importar_ot.py
def procesar_reprogramacion(fila, contador): """ Procesa una reprogramación (tipo 5) """ try: tipo_ot_id = 5 # Siempre 5 para reprogramaciones try: tipo_ot = Tipo.objects.get(id=5) except Tipo.DoesNotExist: tipo_ot = Tipo.objects.filter( nivel_afectacion=2, descripcion__icontains="REPROGRAMACION" ).first() # Buscar OT principal ot_principal = None ot_principal_id = None if not pd.isna(fila['ot_principal']) and fila['ot_principal']: orden_trabajo_principal = str(fila['ot_principal']).strip() ot_principal = obtener_ot_principal_por_orden_trabajo( orden_trabajo_principal, tipo_ot_id ) if ot_principal: ot_principal_id = ot_principal.id pte_principal = ot_principal.id_pte_header else: return False, f"No se encontró OT principal: {orden_trabajo_principal}" if not ot_principal: return False, "Reprogramación sin OT principal especificada"
def obtener_ot_principal_por_orden_trabajo(orden_trabajo_principal, tipo_ot_actual): """ Busca OT principal (tipo 4) por orden_trabajo para las reprogramadas (tipo 5) """ if tipo_ot_actual != 5: return None try: ot_principal = OTE.objects.filter( orden_trabajo=orden_trabajo_principal, id_tipo_id=4 # Solo OTs iniciales ).first() if ot_principal: print(f"✓ OT principal encontrada: {orden_trabajo_principal} (ID: {ot_principal.id})") return ot_principal else: print(f"⚠ OT principal NO encontrada para reprogramación: {orden_trabajo_principal}") return None except Exception as e: print(f"✗ Error buscando OT principal: {e}") return None
The import script validates that parent orders are Type 4 and exist before creating reprogrammed orders. This prevents orphaned reprogramming records.
Reprogrammed orders inherit the PTE reference from their parent:
importar_ot.py
if ot_principal: ot_principal_id = ot_principal.id pte_principal = ot_principal.id_pte_header print(f"✓ Usando PTE de OT principal: {pte_principal.oficio_pte}")# Later in the code...ot.id_pte_header = pte_principal # Usar PTE de la OT principalot.ot_principal = ot_principal_id
This ensures the entire family of work orders (initial + all reprogrammed versions) remain linked to the same planning document (PTE).
