SmartCost
/
YangHuOperation


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200
							<!DOCTYPE html>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <title>Report Demo!</title>
</head>
<body>
    <!--
    <script src="https://code.jquery.com/jquery-3.1.1.min.js"></script>
    -->

    <script src="/lib/jquery/jquery.min.js"></script>
    <script type="text/javascript" src="/web/maintain/report/js/jpc_output_value_define.js"></script>
    <script type="text/javascript" src="/web/maintain/report/js/jpc_output.js"></script>
    <table id="forPrintHide">
        <tr>
            <td width="5"></td>
            <td>
                <select name="select1" id="select_k1" onchange="ajaxCall()">
                    <option value="2">07-1表</option>
                    <option value="1">08-2表</option>
                    <option value="3">计量-清单支付09表</option>
                    <option value="88">多流水测试报表</option>
                </select>
                <select name="select2" id="select_k2" onchange="ajaxCall()">
                    <option value="A4">A4</option>
                    <option value="A3">A3</option>
                </select>
            </td>
            <td>
                <input type="button" value="显示报表" onclick="ajaxCall()"/>
                <input type="button" value="< 前一页" onclick="showPage(-1)"/>
                <input type="button" value="后一页 >" onclick="showPage(1)"/>
                <input type="button" value="打印" onclick="printCurrentPage()"/>
                <input type="button" value="Excel" onclick="getExcel()"/>
                <input type="button" value="ExcelInOneBook" onclick="getExcelInOneBook()"/>
                <input type="button" value="PDF" onclick="getPDF()"/>
                <label>
                    <input type="checkbox" id="isOneSheetChk" onclick="isOneSheet = this.checked;">
                    Excel单页输出
                </label>
                <label>
                    <input type="checkbox" id="outputOptionChk">
                    连续输出
                </label>
            </td>
        </tr>
    </table>
    <canvas id="myCanvas" width="2000" height="1280">
    </canvas>
</body>
<style>
    body {
        margin: 0px;
        padding: 0px;
    }
    #myCanvas {
        border: 0px solid #9C9898;
    }
</style>
<script>
    let currentPage = 1;
    let pageRst = null;
    let currentRptTpl = null;
    let maxPages = 20;
    let rpt_id = null;
    let rpt_size = null;
    let isOneSheet = false;

    function printCurrentPage() {
        if (currentRptTpl) {
            //$("table#forPrintHide").css
            $("table#forPrintHide").css("display","none");
            window.print();
            //$("canvas#myCanvas").printArea();
        }
    }

    function getScreenDPI() {
        let me = this, arrDPI = [];
        if (window.screen.deviceXDPI != undefined) {
            arrDPI.push(window.screen.deviceXDPI);
            arrDPI.push(window.screen.deviceYDPI);
        } else {
            let tmpNode = document.createElement("DIV");
            tmpNode.style.cssText = "width:1in;height:1in;position:absolute;left:0px;top:0px;z-index:99;visibility:hidden";
            document.body.appendChild(tmpNode);
            arrDPI.push(parseInt(tmpNode.offsetWidth));
            arrDPI.push(parseInt(tmpNode.offsetHeight));
            tmpNode.parentNode.removeChild(tmpNode);
        }
        return arrDPI;
    }

    function setupReport() {
        let rst = false;
        let rpt = document.getElementById("select_k1");
        let size = document.getElementById("select_k2");
        if (rpt.selectedIndex >= 0 && size.selectedIndex >= 0) {
            rpt_id = rpt.options[rpt.selectedIndex].value;
            rpt_size = size.options[size.selectedIndex].value;
            rst = true;
        }
        return rst;
    }

    function showPage(pageStep, cv) {
        if (currentPage + pageStep >= 1 && currentPage + pageStep <= maxPages) {
            currentPage = currentPage + pageStep;
            let canvas = null;
            if (cv) {
                canvas = cv;
            } else canvas = document.getElementById("myCanvas");
            JpcCanvasOutput.cleanCanvas(canvas);
            JpcCanvasOutput.drawPageBorder(currentRptTpl, canvas, getScreenDPI());
            JpcCanvasOutput.drawToCanvas(pageRst, canvas, currentPage);
        }
    }

    function getDummyExcel() {
        let id = "dummy_request_id";
        let p1 = "dummy_paramm_2";
        let url =  "/report_api/getDummyExcel/" + id + "/" + p1;
        window.location = url;//这里不能使用get方法跳转，否则下载不成功
    }

    function getExcel() {
        let rpt = document.getElementById("select_k1");
        let size = document.getElementById("select_k2");
        let optionChk = document.getElementById("outputOptionChk");
        let rpt_name = rpt.options[rpt.selectedIndex].text;
        if (rpt.selectedIndex >= 0 && size.selectedIndex >= 0) {
            rpt_id = rpt.options[rpt.selectedIndex].value;
            rpt_size = size.options[size.selectedIndex].value;
        }
        let url =  "/report_api/getTestExcel/" + rpt_id + "/" + rpt_size + "/" + rpt_name + "/" + isOneSheet + "/" + (optionChk.checked?'infinity':'normal');
        window.location = url;//这里不能使用get方法跳转，否则下载不成功
    }

    function getExcelInOneBook() {
        let rptIds = "2,3";
        let size = "A4";
        let rpt_name = 'OneBook';
        let optionChk = document.getElementById("outputOptionChk");
        let url =  "/report_api/getTestExcelInOneBook/" + rptIds + "/" + size + "/" + rpt_name + "/" + (optionChk.checked?'infinity':'normal');
        window.location = url;//这里不能使用get方法跳转，否则下载不成功
    }

    function getPDF() {
        let rpt = document.getElementById("select_k1");
        let size = document.getElementById("select_k2");
        let rpt_name = rpt.options[rpt.selectedIndex].text;
        if (rpt.selectedIndex >= 0 && size.selectedIndex >= 0) {
            rpt_id = rpt.options[rpt.selectedIndex].value;
            rpt_size = size.options[size.selectedIndex].value;
        }
        let url =  "/report_api/getTestPDF/" + rpt_id + "/" + rpt_size + "/" + rpt_name;
        window.location = url;
    }

    function ajaxCall() {
        if (setupReport()) {
            let canvas = document.getElementById("myCanvas");
            canvas.style.cursor = "wait";
            $.ajax({
                type:"POST",
                url: 'report_api/getTestReport',
                data: {"ID": rpt_id, "pageSize": rpt_size},
                dataType: 'json',
                cache: false,
                timeout: 15000,
                success: function(result){
                    canvas.style.cursor = "default";
                    currentPage = 1;
                    pageRst = result.data;
                    if (pageRst) {
                        //console.log(JSON.stringify(pageRst));
                        maxPages = pageRst.items.length;
                        currentRptTpl = pageRst;
                        if (rpt_size === "A4") {
                            canvas.width = 1200;
                            canvas.height = 900;
                        } else if (rpt_size === "A3") {
                            canvas.width = 1880;
                            canvas.height = 1200;
                        }
                        showPage(0, canvas);
                    }
                },
                error: function(jqXHR, textStatus, errorThrown){
                    canvas.style.cursor = "default";
                    alert('error ' + textStatus + " " + errorThrown);
                }
            });
        }
    }

</script>

</html>