问如何在HTML web应用程序中计算费率
EN

Stack Overflow用户

提问于 2017-08-04 02:17:07

回答 1查看 90关注 0票数 1

如何在HTML web应用程序中使用一些公式计算费率

我已经在google script中创建了html web应用程序，我正在尝试提供一个选项来生成服务的速率(更像是计算器-使用乘法函数)

我已附加的html脚本时，用户输入的时间在“小时数”标签(C)的功能应该运行，它应该与“每小时费率”倍增，并应反映在“D”(总费率)

此外，它还应反映总计选项卡中的总比率

<!DOCTYPE html>
<html lang="en">
<head>
  <title>Bootstrap Example</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>
<body>
<nav class="navbar navbar-inverse">
  <div class="container-fluid">
    <div class="navbar-header">
      <img src="" alt="IIFL LOGO" style="width:100px;height:50px;">
    </div>
    <ul class="nav navbar-nav">
      <li class="active"><a href="">Home</a></li>
       <p class="navbar-text"></p>
       <p class="navbar-text"> </p>
       <li class="active"><a >Technology Team-Project Proposal Form</a></li>
   
      <p class="navbar-text">      </p>
      <p class="navbar-text">      </p>
      <p class="navbar-text">      </p>

    </ul>
    
    <form class="navbar-form navbar-left" onsubmit="return searchRequest();">
      <div class="form-group">
        <input type="text" id="requestID" class="form-control" placeholder="Search Requset Number">
       <button type="submit" class="btn btn-primary">Search</button>
      <button type="button" onclick="updateRequest()" id="updateBtn" class="btn btn-success">Save</button>
      <a href="https://script.google.com/a/macros/iifl.com/s/AKfycbyR7BzkYpbt2EKkIdoViJO1ZshPCXs9TBPv4P2eJGs/dev" class="btn btn-danger" role="button">Refresh</a>
      </div>
    </form>
  </div>
</nav>
<div class="container-fluid">
<div class="row">
    <div class="col-xs-3"><label for="usr"><p class="text-primary">Project Name</label><input type="text" class="form-control" id="requestNumber"></div>
</div>
 <hr style="height:2px;border-width:0;color:gray;background-color:gray">
  <div class="row">
    <div class="col-xs-3"><label for="usr"><p class="text-primary">Service Area</label><input type="text" class="form-control" id="Service Area"type="text" placeholder="Manager" disabled></div>
    <div class="col-xs-3"><label for="usr"><p class="text-primary">Per Hour Rate</label><input type="text" class="form-control" id="Per Hour Rate"type="text" placeholder="500" disabled></div>
    <div class="col-xs-3"><label for="usr"><p class="text-primary">Number Of Hours</label><input type="text" class="form-control" id="rTpe"></div>
    <div class="col-xs-3"><label for="usr"><p class="text-primary">Total Rate</label><input type="text" class="form-control" id="rFor"></div>
</div>
 <div class="row">
    <div class="col-xs-3"><label for="usr"><p class="text-primary">Service Area</label><input type="text" class="form-control" id="Service Area"type="text" placeholder="Project  Manager" disabled></div>
    <div class="col-xs-3"><label for="usr"><p class="text-primary">Per Hour Rate</label><input type="text" class="form-control" id="Per Hour Rate"type="text" placeholder="300" disabled></div>
    <div class="col-xs-3"><label for="usr"><p class="text-primary">Number Of Hours</label><input type="text" class="form-control" id="rTpe"></div>
    <div class="col-xs-3"><label for="usr"><p class="text-primary">Total Rate</label><input type="text" class="form-control" id="rFor"></div>
</div>
 <hr style="height:2px;border-width:0;color:gray;background-color:gray">
 <div class="row">
<div class="col-xs-3"><label for="usr"><p class="text-primary">Grand Total Rate</label><input type="text" class="form-control" id="rFor"></div>
</div>
<div class="container">
  <button type="button" class="btn btn-success active" onclick="updateRequest()" id="updateBtn" class="center">Save</button>    
</div>
</div>
</body>
</html>

google-apps-script

回答 1

Stack Overflow用户

回答已采纳

发布于 2017-08-04 02:50:17

参考下面的代码...

    $("#rTpe1").keyup(function(e){
      $("#rFor1").val(this.value * $("#PerHourRate1").val());
      $("#rFor3").val( Number($("#rFor1").val()) + Number($("#rFor2").val()))
    });
    
    $("#rTpe2").keyup(function(e){
      $("#rFor2").val(this.value * $("#PerHourRate2").val());
      $("#rFor3").val( Number($("#rFor1").val()) + Number($("#rFor2").val()))
    });

 <!DOCTYPE html>
    <html lang="en">
    <head>
      <title>Bootstrap Example</title>
      <meta charset="utf-8">
      <meta name="viewport" content="width=device-width, initial-scale=1">
      <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
      <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
      <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
    </head>
    <body>
    <nav class="navbar navbar-inverse">
      <div class="container-fluid">
        <div class="navbar-header">
          <img src="" alt="IIFL LOGO" style="width:100px;height:50px;">
        </div>
        <ul class="nav navbar-nav">
          <li class="active"><a href="">Home</a></li>
           <p class="navbar-text"></p>
           <p class="navbar-text"> </p>
           <li class="active"><a >Technology Team-Project Proposal Form</a></li>
       
          <p class="navbar-text">      </p>
          <p class="navbar-text">      </p>
          <p class="navbar-text">      </p>
    
        </ul>
        
        <form class="navbar-form navbar-left" onsubmit="return searchRequest();">
          <div class="form-group">
            <input type="text" id="requestID" class="form-control" placeholder="Search Requset Number">
           <button type="submit" class="btn btn-primary">Search</button>
          <button type="button" onclick="updateRequest()" id="updateBtn" class="btn btn-success">Save</button>
          <a href="https://script.google.com/a/macros/iifl.com/s/AKfycbyR7BzkYpbt2EKkIdoViJO1ZshPCXs9TBPv4P2eJGs/dev" class="btn btn-danger" role="button">Refresh</a>
          </div>
        </form>
      </div>
    </nav>
    <div class="container-fluid">
    <div class="row">
        <div class="col-xs-3"><label for="usr"><p class="text-primary">Project Name</label><input type="text" class="form-control" id="requestNumber"></div>
    </div>
     <hr style="height:2px;border-width:0;color:gray;background-color:gray">
      <div class="row">
        <div class="col-xs-3"><label for="usr"><p class="text-primary">Service Area</label><input type="text" class="form-control" id="Service Area"type="text" placeholder="Manager" disabled></div>
        <div class="col-xs-3"><label for="usr"><p class="text-primary">Per Hour Rate</label><input type="text" class="form-control" id="PerHourRate1"type="text" value="500" readonly></div>
        <div class="col-xs-3"><label for="usr"><p class="text-primary">Number Of Hours</label><input type="text" class="form-control" id="rTpe1"></div>
        <div class="col-xs-3"><label for="usr"><p class="text-primary">Total Rate</label><input type="text" class="form-control" id="rFor1"></div>
    </div>
     <div class="row">
        <div class="col-xs-3"><label for="usr"><p class="text-primary">Service Area</label><input type="text" class="form-control" id="Service Area"type="text" placeholder="Project  Manager" disabled></div>
        <div class="col-xs-3"><label for="usr"><p class="text-primary">Per Hour Rate</label><input type="text" class="form-control" id="PerHourRate2"type="text" value="300" readonly></div>
        <div class="col-xs-3"><label for="usr"><p class="text-primary">Number Of Hours</label><input type="text" class="form-control" id="rTpe2"></div>
        <div class="col-xs-3"><label for="usr"><p class="text-primary">Total Rate</label><input type="text" class="form-control" id="rFor2"></div>
    </div>
     <hr style="height:2px;border-width:0;color:gray;background-color:gray">
     <div class="row">
    <div class="col-xs-3"><label for="usr"><p class="text-primary">Grand Total Rate</label><input type="text" class="form-control" id="rFor3" readonly></div>
    </div>
    <div class="container">
      <button type="button" class="btn btn-success active" onclick="updateRequest()" id="updateBtn" class="center">Save</button>    
    </div>
    </div>
    
        </body>
    </html>

票数 0

页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持

原文链接：

https://stackoverflow.com/questions/45491756

复制

相似问题

问如何在HTML web应用程序中计算费率
EN

回答 1

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在HTML web应用程序中计算费率EN

回答 1

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在HTML web应用程序中计算费率
EN