页面历史

function paramToString(v) {
    return v == null ? null: v.toString();
}
function main(spreadsheetReport) {
    var r = spreadsheetReport.getRowCount(); //获取电子表格总行数
    for (var i = 2; i < r; i++) {
        var td = spreadsheetReport.getCell(i, 2); //根据行列号获取单元格
        var td1 = spreadsheetReport.getCell(i, 3); //根据行列号获取单元格
        var v = parseFloat(td.innerText.replace("/,"/g, ""));//替换所有逗号再转换
        if (v > 100) {
            var img = document.createElement("IMG");
            img.src = "/smartbi/vision/img/alertdialog/up.gif"; //获取图片
            td1.appendChild(img); //图片放在单元格最后面
            //td.insertBefore(img, td.firstChild);//图片单元格最前面
        }
        else {
            var img = document.createElement("IMG");
            img.src = "/smartbi/vision/img/alertdialog/down.gif";
            td1.appendChild(img);
            //td.insertBefore(img, td.firstChild);//图片放在单元格最前面
        }
    }
    for (var i = 2; i < r; i++) {
        debugger;
        var td3 = spreadsheetReport.getCell(i, 3);
        var aa = spreadsheetReport.getCell(i, 1).innerText;
        debugger;
        td3.style.cursor = "pointer";
        debugger;
        td3.onclick = function(e) {
            debugger;
            var paramsInfo = [];
            var aa = "";
            if(this.previousSibling && this.previousSibling.previousSibling) {
                aa = this.previousSibling.previousSibling.innerText;
            }
            
            
            paramsInfo.push({
                name: "产品类别",
                value: paramToString(aa),
                displayValue: paramToString(aa)
            });
            //@smartbi.openOtherPage:"I4028818a4f5da2d70153e4e45e1f1bad"
            openURL("openresource.jsp?resid=I4028818a4f5da2d70153e4e45e1f1bad&showtoolbar=true&refresh=true", [{
                name: "paramsInfo",
                value: lang.toJSONString(paramsInfo)
            }])
        }
    }
}