个人中心
gpt4 book ai didi

mysql - 在 AngularJS 中调用 NodeJS 函数

转载 作者：行者123 更新时间：2023-11-29 18:25:27 25 4
gpt4 key购买 nike 

app.get("/myDBfunction",getCommunicationDetails);    
function myDBfunction(req,res){
     var queryObject = url.parse(req.url,true).query;
         console.log("req.method ",req.method);

    var resultset={};
        resultset.result=[];


     var queryString = `select * from table..`
     connection.query(queryString, function(err, result) {
                    if (!err){
                var response = [];
                response.push({'result' : 'success'});
                if (result.length != 0) {
                    response.push({'data' : result});
                } else {
                    response.push({'msg' : 'No Result Found'});
                }

                res.setHeader('Content-Type', 'application/json');
                res.status(200).send(JSON.stringify(response));
            } else {
                res.status(400).send(err);
            }
    })
        };

我已经创建了Nodejs函数来连接mysql并能够以json格式显示。现在我想在 Angular JS 中调用这个函数并将我的 json 转换为 Excel 并下载报告。我是 Angular 的新手，请帮助我完成完整的步骤。提前致谢。

编辑 1:Firstpro.html 文件

<html ng-app="myApp">

  <head>

    <script data-require="angular.js@*" data-semver="2.0.0" src="https://code.angularjs.org/1.4.8/angular.js"></script>
    <script data-require="jquery@*" data-semver="2.1.4" src="https://code.jquery.com/jquery-2.1.4.js"></script>
  </head>

  <body ng-controller="MyCtrl">
  <script src="/app.js"></script>
    <h1>Export to Excel</h1>
    <button class="btn btn-link" ng-click="exportToExcel('#tableToExport')">
      <span class="glyphicon glyphicon-share"></span>
 Export to Excel
    </button>
    <div id="tableToExport">
      <table border="1">
        <thead>
          <tr class="table-header">
            <th>Team</th>
            <th>Process Type</th>
            <th>Cedent</th>
          </tr>
        </thead>
        <tbody>
          <tr ng-repeat="data in details">
            <td>{{data.team}}</td>
            <td>{{data.type}}</td>
            <td>{{data.cedent}}</td>
          </tr>
        </tbody>
      </table>
    </div>
  </body>

</html>

myCtrl.js 文件

myApp.controller('myController',funtion($scope,$http){
   $http.get("/Details").then(function(response){ 
       $scope.details = response.data; //You get your data here from nodejs API, and iterate details in your View
     });
});

app.js 文件

var myApp=angular.module("myApp",[]);
myApp.factory('Excel',function($window){
        var uri='data:application/vnd.ms-excel;base64,',
            template='<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>',
            base64=function(s){return $window.btoa(unescape(encodeURIComponent(s)));},
            format=function(s,c){return s.replace(/{(\w+)}/g,function(m,p){return c[p];})};
        return {
            tableToExcel:function(tableId,worksheetName){
                var table=$(tableId),
                    ctx={worksheet:worksheetName,table:table.html()},
                    href=uri+base64(format(template,ctx));
                return href;
            }
        };
    })
    .controller('myCtrl',function(Excel,$timeout,$scope,$http){
      //get data from Node api; For example i will using $timeout just to simulate api call; Also i am assuming your JSON would be like below that i have assigned

      $timeout(function(){
        $scope.details = [
           { 
             team:'v1',
             type:'v2',
             cedent:'v3'
           },
           { 
             team:'v1',
             type:'v2',
             cedent:'v3'
           },
           { 
             team:'v1',
             type:'v2',
             cedent:'v3'
           }
        ]
      },1000)

      //below is how you would do your HTTP call tp node js server. I have commented this codefor now just to simulate the dummy data above in $timeout.
      /*$http.get("/myDBfunction").then(function(response){ 
       $scope.details = response.data; //You get your data here from nodejs API, and iterate details in your View
      });*/


      $scope.exportToExcel=function(tableId){ // ex: '#my-table'
            var exportHref=Excel.tableToExcel(tableId,'WireWorkbenchDataExport');
            $timeout(function(){location.href=exportHref;},100); // trigger download
        }
    });

现在我已经运行了 myHTML 文件，输出如下:但它应该从 MYsql 表中获取。导出到 Excel

Export to Excel
Team    Process Type    Cedent
{{data.team}}   {{data.type}}   {{data.cedent}}

最佳答案

编辑2

要从 SQL 获取数据，请使用下面的代码而不是 $timeout

$http.get("/myDBfunction").then(function(response){ 
      console.log(response.data)
      $scope.details = response.data; // here you will get data
 },function(res){
      console.log("Error",res) //error occured
 });

编辑 See this HTML screenshot

您可以在 Controller 中像下面这样调用nodejs api，并可以使用“ng-repeat”以表格格式显示 JSON 结果

在你的 Controller 中:

myApp.controller('myController',funtion($scope,$http){
   $http.get("/myDBfunction").then(function(response){ 
       $scope.details = response.data; //You get your data here from nodejs API, and iterate details in your View
     });
});

并在 View 中重复该数据

<table>
   <tr ng-repeat="data in details track by $index" > // here I made changes
      <td> {{data.prop1}} //iterate over data here</td>
   </tr>
</table>

然后按照下面的代码导出到Excel 

// This will be your app.js file
var myApp=angular.module("myApp",[]);
myApp.factory('Excel',function($window){
        var uri='data:application/vnd.ms-excel;base64,',
            template='<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>',
            base64=function(s){return $window.btoa(unescape(encodeURIComponent(s)));},
            format=function(s,c){return s.replace(/{(\w+)}/g,function(m,p){return c[p];})};
        return {
            tableToExcel:function(tableId,worksheetName){
                var table=$(tableId),
                    ctx={worksheet:worksheetName,table:table.html()},
                    href=uri+base64(format(template,ctx));
                return href;
            }
        };
    })
    .controller('MyCtrl',function(Excel,$timeout,$scope,$http){
      //get data from Node api; For example i will using $timeout just to simulate api call; Also i am assuming your JSON would be like below that i have assigned
      
      $timeout(function(){
        $scope.details = [
           { 
             team:'v1',
             type:'v2',
             cedent:'v3'
           },
           { 
             team:'v1',
             type:'v2',
             cedent:'v3'
           },
           { 
             team:'v1',
             type:'v2',
             cedent:'v3'
           }
        ]
      },1000)
      
      //below is how you would do your HTTP call tp node js server. I have commented this codefor now just to simulate the dummy data above in $timeout.
      /*$http.get("/myDBfunction").then(function(response){ 
       $scope.details = response.data; //You get your data here from nodejs API, and iterate details in your View
      });*/
    
    
      $scope.exportToExcel=function(tableId){ // ex: '#my-table'
            var exportHref=Excel.tableToExcel(tableId,'WireWorkbenchDataExport');
            $timeout(function(){location.href=exportHref;},100); // trigger download
        }
    });
.table-header 
{
background-color: lightskyblue;  
}
<!-this is your HTML ->
<html ng-app="myApp">

  <head>
    
    <script data-require="angular.js@*" data-semver="2.0.0" src="https://code.angularjs.org/1.4.8/angular.js
"></script>
    <script data-require="jquery@*" data-semver="2.1.4" src="https://code.jquery.com/jquery-2.1.4.js"></script>
  </head>

  <body ng-controller="MyCtrl">
    <h1>Export to Excel</h1>
    <button class="btn btn-link" ng-click="exportToExcel('#tableToExport')">
      <span class="glyphicon glyphicon-share"></span>
 Export to Excel
    </button>
        <button class="btn btn-link" ng-click="exportToExcel('#another')">
      <span class="glyphicon glyphicon-share"></span>
 Export to Excel Plain JSON
    </button>
    <div id="tableToExport">
      <table border="1">
        <thead>
          <tr class="table-header">
            <th>Team</th>
            <th>Process Type</th>
            <th>Cedent</th>
          </tr>
        </thead>
        <tbody>
          <tr ng-repeat="data in details track by $index">
            <td>{{data.team}}</td>
            <td>{{data.type}}</td>
            <td>{{data.cedent}}</td>
          </tr>
        </tbody>
      </table>
    </div>
    <div id="another">
      {{details}}
    </div>
  </body>

</html>

关于mysql - 在 AngularJS 中调用 NodeJS 函数，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/46232310/

25 4 0
文章推荐： android - Android Studio:无法创建父目录
文章推荐： android - Android App如何查看设备是空闲还是移动？
文章推荐： android - 如何从联系人列表中获取姓名
文章推荐： php - 在 GET ajax 调用中传递 HEX 颜色
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com