 
      
    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