Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision b2c069f6

Von Werner Hahn vor etwa 1 Jahr hinzugefügt

  • ID b2c069f6686fecc5a05a5daed40512ca238f6450
  • Vorgänger 92d44251
  • Nachfolger 925f7303

Dispostionsmanager Controller an record_type angepasst

Unterschiede anzeigen:

SL/DB/Manager/Part.pm
103 103
  LEFT OUTER JOIN oe o ON (oi.trans_id = o.id)
104 104
  WHERE
105 105
    oi.parts_id = ?
106
    AND (NOT COALESCE(o.quotation, FALSE))
106
    AND (o.record_type = 'purchase_order')
107 107
    AND (NOT COALESCE(o.closed,    FALSE))
108 108
    AND (NOT COALESCE(o.delivered, FALSE))
109 109
    AND (COALESCE(o.vendor_id, 0) <> 0)
......
116 116
  LEFT OUTER JOIN oe o ON (oi.trans_id = o.id)
117 117
  WHERE
118 118
    oi.parts_id = ?
119
    AND (NOT COALESCE(o.quotation, FALSE))
119
    AND (o.record_type = 'purchase_order')
120 120
    AND (NOT COALESCE(o.closed,    FALSE))
121 121
    AND (NOT COALESCE(o.delivered, FALSE))
122 122
    AND (o.vendor_id is not null)

Auch abrufbar als: Unified diff