Python
9
Вклад в тег
var xhr = new XMLHttpRequest();
xhr.open('GET', 'Get133Report.aspx?date=' + date, true);
xhr.responseType = 'arraybuffer';
xhr.onload = function (e) {
var blob = new Blob([this.response], { type: 'application/vnd.ms-excel' });
var downloadUrl = URL.createObjectURL(blob);
var a = document.createElement("a");
a.href = downloadUrl;
a.download = "Отчет_133_" + date + ".xls";
document.body.appendChild(a);
a.click();
HideProgress();
};
ShowProgress();
xhr.send();
functionName
должно находиться внутри функции-обработчика onclick
UPDATE dataset d
SET d.price =
(SELECT TOP 1 price FROM dataset d1 WHERE
d.good_id=d1.good_id AND d.owner_id=d1.owner_id AND d1.price IS NOT NULL AND
d1.year_id<=d.year_id AND d1.week_number<=d.week_number
ORDER BY d1.year_id DESC, d1.week_number DESC)
WHERE d.price IS NULL