---

(
    SELECT ms.name
    FROM prod_line.pens_product_param_pl p_term
    JOIN prod_line.param_pl def_term
        ON def_term.id = p_term.param_pl_id
    JOIN prod_line.table_param_pl_payment_term pt
        ON pt.pens_product_param_pl_id = p_term.id
    LEFT JOIN prod_line.hb_param_pl_multiselect ms
        ON ms.id = pt.payment_type_pl_multiselect_id
    WHERE p_term.pens_product_id = pp.id
      AND def_term.brief = 'СрокВыплаты'
      AND pt.payment_type_pl_multiselect_id IS NOT NULL
      AND (
          pt.app_date_from IS NULL
          OR c.date >= pt.app_date_from
      )
      AND (
          pt.app_date_to IS NULL
          OR c.date <= pt.app_date_to
      )
    ORDER BY pt.app_date_from DESC NULLS LAST, pt.id DESC
    LIMIT 1
) AS payment_type,





(
    SELECT pt.max_term_to
    FROM prod_line.pens_product_param_pl p_term
    JOIN prod_line.param_pl def_term
        ON def_term.id = p_term.param_pl_id
    JOIN prod_line.table_param_pl_payment_term pt
        ON pt.pens_product_param_pl_id = p_term.id
    WHERE p_term.pens_product_id = pp.id
      AND def_term.brief = 'СрокВыплаты'
      AND pt.max_term_to IS NOT NULL
      AND (
          pt.app_date_from IS NULL
          OR c.date >= pt.app_date_from
      )
      AND (
          pt.app_date_to IS NULL
          OR c.date <= pt.app_date_to
      )
    ORDER BY pt.app_date_from DESC NULLS LAST, pt.id DESC
    LIMIT 1
) AS max_payment_term,




maxPaymentTerm: '$s.max_payment_term',




<div class="col-sm-4">
    <label for="maxPaymentTerm">Максимальный срок выплаты</label>
    <input
        type="text"
        class="form-control"
        id="maxPaymentTerm"
    />
</div>




$("#maxPaymentTerm").val(data.maxPaymentTerm);