(
SELECT pt.payment_type_pl_multiselect_id
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.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_id,
paymentTypeId: '$s.payment_type_id',
<div class="form-control link-container" id="paymentType"></div>
if ($("#paymentType")[0]) {
if (data.paymentTypeId && data.paymentType) {
$("#paymentType").html(
'<a class="btn btn-outline-secondary btn-sm" role="button" ' +
'href="view?viewCode=v_prod_line_hb_param_pl_multiselect&id=' +
data.paymentTypeId +
'">' +
data.paymentType +
'</a>'
);
} else {
$("#paymentType").html('');
}
}