- android - 多次调用 OnPrimaryClipChangedListener
- android - 无法更新 RecyclerView 中的 TextView 字段
- android.database.CursorIndexOutOfBoundsException : Index 0 requested, 光标大小为 0
- android - 使用 AppCompat 时,我们是否需要明确指定其 UI 组件(Spinner、EditText)颜色
所以我有一个 HTML 表格,每个单元格中有 10 个单选按钮(除了标题单元格)。选择完单选按钮后,单击底部的导出到 Excel 按钮。这将为您下载一个包含您的单选按钮选择的 Excel 文件。
现在我要做的是检测在前 5 个单元格中选择了多少个单选按钮,每行都有单选按钮。如果介于 1
之间& 5
我想要一个简单的 <div>
弹出窗口显示满足这些条件的行列表及其 data-id
属性。在那个弹出窗口中,我只需要它有一个确定 和取消 按钮。当用户单击确定 时,它会下载 Excel 文件;否则,如果用户单击取消 按钮,它不会下载 Excel 文件。
我知道我需要在我的 tableToExcel
中插入类似这样的内容功能:
var checkedItems = row.find(":checked:not(:radio[name='attendance'])")
if (checkedItems.length >= 1 && < 5) {
<em>enter code here</em>
}
然后运行 tableToExcel
的其余部分当用户在弹出窗口中选择 Okay 时编写代码,但我不确定如何调用 data-id
的 <tr>
的 满足条件并为弹出窗口汇集它们的列表。
这是 fiddle片段如下:
var overall = $('#overall');
$(document).ready(function() {
$(':radio').change(function(e) {
var row = $(this).closest('.item');
var checkedItems = row.find(":checked:not(:radio[name='attendance'])")
if (e.target.name != "attendance") {
if (checkedItems.length == 5) {
row.find("td.overall").html(getOverall(checkedItems));
}
} else {
row.find("td.attendance").html("x " + parseFloat($(this).val() / 10).toFixed(1));
}
})
function getOverall(_checkedItems) {
var total = 0;
_checkedItems.each(function() {
total += parseFloat($(this).val());
});
return total;
}
});
var tableToExcel = (function() {
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 function(table, name) {
if (!table.nodeType) {
table = document.getElementById(table)
}
var cloned = $('#copyTable').clone().appendTo('.hidden_table')
cloned.find('input[type="radio"]:not(:checked) + span').remove();
var ctx = {
worksheet: name || 'Worksheet',
table: cloned.html()
}
cloned.remove();
window.location.href = uri + base64(format(template, ctx));
}
})();
table {
font-family: arial, sans-serif;
border-collapse: collapse;
width: 115%;
}
td,
th {
border: 1px solid #dddddd;
text-align: center;
}
tr:nth-child(even) {
background-color: #dddddd;
}
.hidden_table {
/*display:none*/
}
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<table id="copyTable">
<thead>
<tr>
<th>Team</th>
<th>Player</th>
<th>Number</th>
<th>Position</th>
<th>Skating</th>
<th>Shooting</th>
<th>Passing</th>
<th>Puck Control</th>
<th>Game Understanding</th>
<th>Attendance</th>
<th>Overall</th>
<th>Attendance <br>Factor</th>
</tr>
</thead>
<tbody>
<tr class="item" data-id="1">
<td></td>
<td></td>
<td></td>
<td></td>
<td>
<form action="">
<input type="radio" name="skating" value="1"><span>1</span>
<input type="radio" name="skating" value="2"><span>2</span>
<input type="radio" name="skating" value="3"><span>3</span>
<input type="radio" name="skating" value="4"><span>4</span>
<input type="radio" name="skating" value="5"><span>5</span>
<br>
<input type="radio" name="skating" value="6"><span>6</span>
<input type="radio" name="skating" value="7"><span>7</span>
<input type="radio" name="skating" value="8"><span>8</span>
<input type="radio" name="skating" value="9"><span>9</span>
<input type="radio" name="skating" value="10"><span>10</span>
</form>
</td>
<td>
<form action="">
<input type="radio" name="shooting" value="1"><span>1</span>
<input type="radio" name="shooting" value="2"><span>2</span>
<input type="radio" name="shooting" value="3"><span>3</span>
<input type="radio" name="shooting" value="4"><span>4</span>
<input type="radio" name="shooting" value="5"><span>5</span>
<br>
<input type="radio" name="shooting" value="6"><span>6</span>
<input type="radio" name="shooting" value="7"><span>7</span>
<input type="radio" name="shooting" value="8"><span>8</span>
<input type="radio" name="shooting" value="9"><span>9</span>
<input type="radio" name="shooting" value="10"><span>10</span>
</form>
</td>
<td>
<form action="">
<input type="radio" name="passing" value="1"><span>1</span>
<input type="radio" name="passing" value="2"><span>2</span>
<input type="radio" name="passing" value="3"><span>3</span>
<input type="radio" name="passing" value="4"><span>4</span>
<input type="radio" name="passing" value="5"><span>5</span>
<br>
<input type="radio" name="passing" value="6"><span>6</span>
<input type="radio" name="passing" value="7"><span>7</span>
<input type="radio" name="passing" value="8"><span>8</span>
<input type="radio" name="passing" value="9"><span>9</span>
<input type="radio" name="passing" value="10"><span>10</span>
</form>
</td>
<td>
<form action="">
<input type="radio" name="puck_control" value="1"><span>1</span>
<input type="radio" name="puck_control" value="2"><span>2</span>
<input type="radio" name="puck_control" value="3"><span>3</span>
<input type="radio" name="puck_control" value="4"><span>4</span>
<input type="radio" name="puck_control" value="5"><span>5</span>
<br>
<input type="radio" name="puck_control" value="6"><span>6</span>
<input type="radio" name="puck_control" value="7"><span>7</span>
<input type="radio" name="puck_control" value="8"><span>8</span>
<input type="radio" name="puck_control" value="9"><span>9</span>
<input type="radio" name="puck_control" value="10"><span>10</span>
</form>
</td>
<td>
<form action="">
<input type="radio" name="team_play" value="1"><span>1</span>
<input type="radio" name="team_play" value="2"><span>2</span>
<input type="radio" name="team_play" value="3"><span>3</span>
<input type="radio" name="team_play" value="4"><span>4</span>
<input type="radio" name="team_play" value="5"><span>5</span>
<br>
<input type="radio" name="team_play" value="6"><span>6</span>
<input type="radio" name="team_play" value="7"><span>7</span>
<input type="radio" name="team_play" value="8"><span>8</span>
<input type="radio" name="team_play" value="9"><span>9</span>
<input type="radio" name="team_play" value="10"><span>10</span>
</form>
</td>
<td>
<form action="">
<input type="radio" name="attendance" value="1"><span>1</span>
<input type="radio" name="attendance" value="2"><span>2</span>
<input type="radio" name="attendance" value="3"><span>3</span>
<input type="radio" name="attendance" value="4"><span>4</span>
<input type="radio" name="attendance" value="5"><span>5</span>
<br>
<input type="radio" name="attendance" value="6"><span>6</span>
<input type="radio" name="attendance" value="7"><span>7</span>
<input type="radio" name="attendance" value="8"><span>8</span>
<input type="radio" name="attendance" value="9"><span>9</span>
<input type="radio" name="attendance" value="10"><span>10</span>
</form>
</td>
<td class="overall" id="overall">
</td>
<td class="attendance" id="attendance"></td>
</tr>
<tr class="item" data-id="2">
<td></td>
<td></td>
<td></td>
<td></td>
<td>
<form action="">
<input type="radio" name="skating" value="1"><span>1</span>
<input type="radio" name="skating" value="2"><span>2</span>
<input type="radio" name="skating" value="3"><span>3</span>
<input type="radio" name="skating" value="4"><span>4</span>
<input type="radio" name="skating" value="5"><span>5</span>
<br>
<input type="radio" name="skating" value="6"><span>6</span>
<input type="radio" name="skating" value="7"><span>7</span>
<input type="radio" name="skating" value="8"><span>8</span>
<input type="radio" name="skating" value="9"><span>9</span>
<input type="radio" name="skating" value="10"><span>10</span>
</form>
</td>
<td>
<form action="">
<input type="radio" name="shooting" value="1"><span>1</span>
<input type="radio" name="shooting" value="2"><span>2</span>
<input type="radio" name="shooting" value="3"><span>3</span>
<input type="radio" name="shooting" value="4"><span>4</span>
<input type="radio" name="shooting" value="5"><span>5</span>
<br>
<input type="radio" name="shooting" value="6"><span>6</span>
<input type="radio" name="shooting" value="7"><span>7</span>
<input type="radio" name="shooting" value="8"><span>8</span>
<input type="radio" name="shooting" value="9"><span>9</span>
<input type="radio" name="shooting" value="10"><span>10</span>
</form>
</td>
<td>
<form action="">
<input type="radio" name="passing" value="1"><span>1</span>
<input type="radio" name="passing" value="2"><span>2</span>
<input type="radio" name="passing" value="3"><span>3</span>
<input type="radio" name="passing" value="4"><span>4</span>
<input type="radio" name="passing" value="5"><span>5</span>
<br>
<input type="radio" name="passing" value="6"><span>6</span>
<input type="radio" name="passing" value="7"><span>7</span>
<input type="radio" name="passing" value="8"><span>8</span>
<input type="radio" name="passing" value="9"><span>9</span>
<input type="radio" name="passing" value="10"><span>10</span>
</form>
</td>
<td>
<form action="">
<input type="radio" name="puck_control" value="1"><span>1</span>
<input type="radio" name="puck_control" value="2"><span>2</span>
<input type="radio" name="puck_control" value="3"><span>3</span>
<input type="radio" name="puck_control" value="4"><span>4</span>
<input type="radio" name="puck_control" value="5"><span>5</span>
<br>
<input type="radio" name="puck_control" value="6"><span>6</span>
<input type="radio" name="puck_control" value="7"><span>7</span>
<input type="radio" name="puck_control" value="8"><span>8</span>
<input type="radio" name="puck_control" value="9"><span>9</span>
<input type="radio" name="puck_control" value="10"><span>10</span>
</form>
</td>
<td>
<form action="">
<input type="radio" name="team_play" value="1"><span>1</span>
<input type="radio" name="team_play" value="2"><span>2</span>
<input type="radio" name="team_play" value="3"><span>3</span>
<input type="radio" name="team_play" value="4"><span>4</span>
<input type="radio" name="team_play" value="5"><span>5</span>
<br>
<input type="radio" name="team_play" value="6"><span>6</span>
<input type="radio" name="team_play" value="7"><span>7</span>
<input type="radio" name="team_play" value="8"><span>8</span>
<input type="radio" name="team_play" value="9"><span>9</span>
<input type="radio" name="team_play" value="10"><span>10</span>
</form>
</td>
<td>
<form action="">
<input type="radio" name="attendance" value="1"><span>1</span>
<input type="radio" name="attendance" value="2"><span>2</span>
<input type="radio" name="attendance" value="3"><span>3</span>
<input type="radio" name="attendance" value="4"><span>4</span>
<input type="radio" name="attendance" value="5"><span>5</span>
<br>
<input type="radio" name="attendance" value="6"><span>6</span>
<input type="radio" name="attendance" value="7"><span>7</span>
<input type="radio" name="attendance" value="8"><span>8</span>
<input type="radio" name="attendance" value="9"><span>9</span>
<input type="radio" name="attendance" value="10"><span>10</span>
</form>
</td>
<td class="overall" id="overall">
</td>
<td class="attendance" id="attendance"></td>
</tr>
</tbody>
</table>
<div class="hidden_table" id="hidden_table"></div>
<div align="center">
<input type="button" onclick="tableToExcel('copyTable', 'Player_scores')" value="Export to Excel">
</div>
最佳答案
这有效。
我刚刚在模态对话框中显示了 data-id
。
要了解我是如何创建模态对话框的,See my answer here
var overall = $('#overall');
var rows = [];
var toggleDialog = function()
{
var dialog = document.getElementById("modal_container");
dialog.style.display = (dialog.style.display=="none"?"block":"none");
}
var populateModalData = function()
{
$("#modaldata").html(rows.join(","));
toggleDialog();
}
$(document).ready(function() {
$(':radio').change(function(e) {
var row = $(this).closest('.item');
var checkedItems = row.find(":checked:not(:radio[name='attendance'])")
if (e.target.name != "attendance")
{
var id = row.data("id");
if (checkedItems.length == 5)
{
if(rows.indexOf(id)<0) rows.push(id);
row.find("td.overall").html(getOverall(checkedItems));
populateModalData();
}
else
{
if(rows.indexOf(id)>-1) rows.splice(rows.indexOf(id),1);
}
} else {
row.find("td.attendance").html("x " + parseFloat($(this).val() / 10).toFixed(1));
}
})
function getOverall(_checkedItems) {
var total = 0;
_checkedItems.each(function() {
total += parseFloat($(this).val());
});
return total;
}
});
var tableToExcel = (function() {
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 function(table, name) {
if (!table.nodeType) {
table = document.getElementById(table)
}
var cloned = $('#copyTable').clone().appendTo('.hidden_table')
cloned.find('input[type="radio"]:not(:checked) + span').remove();
var ctx = {
worksheet: name || 'Worksheet',
table: cloned.html()
}
cloned.remove();
window.location.href = uri + base64(format(template, ctx));
}
})();
table {
font-family: arial, sans-serif;
border-collapse: collapse;
width: 115%;
}
td,
th {
border: 1px solid #dddddd;
text-align: center;
}
tr:nth-child(even) {
background-color: #dddddd;
}
.hidden_table {
/*display:none*/
}
/*modal start*/
#modal_container
{
position:fixed;
height: 100%;
width:100%;
margin: 0;
top: 0;
left: 0;
background: #9e9c9c;
z-index:100000;
}
#modal
{
position: absolute;
height: 200px;
width: 500px;
background: #fff;
border-radius: 10px;
margin: auto;
vertical-align: middle;
top:0;
left: 0;
right: 0;
bottom: 0;
text-align: center;
}
.closebtn
{
position: absolute;
top:10px;
right:10px;
cursor: pointer;
}
.buttongroup
{
position: absolute;
left: 0;
right: 0;
bottom: 20px;
}
/* modal end */
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<table id="copyTable">
<thead>
<tr>
<th>Team</th>
<th>Player</th>
<th>Number</th>
<th>Position</th>
<th>Skating</th>
<th>Shooting</th>
<th>Passing</th>
<th>Puck Control</th>
<th>Game Understanding</th>
<th>Attendance</th>
<th>Overall</th>
<th>Attendance <br>Factor</th>
</tr>
</thead>
<tbody>
<tr class="item" data-id="1">
<td></td>
<td></td>
<td></td>
<td></td>
<td>
<form action="">
<input type="radio" name="skating" value="1"><span>1</span>
<input type="radio" name="skating" value="2"><span>2</span>
<input type="radio" name="skating" value="3"><span>3</span>
<input type="radio" name="skating" value="4"><span>4</span>
<input type="radio" name="skating" value="5"><span>5</span>
<br>
<input type="radio" name="skating" value="6"><span>6</span>
<input type="radio" name="skating" value="7"><span>7</span>
<input type="radio" name="skating" value="8"><span>8</span>
<input type="radio" name="skating" value="9"><span>9</span>
<input type="radio" name="skating" value="10"><span>10</span>
</form>
</td>
<td>
<form action="">
<input type="radio" name="shooting" value="1"><span>1</span>
<input type="radio" name="shooting" value="2"><span>2</span>
<input type="radio" name="shooting" value="3"><span>3</span>
<input type="radio" name="shooting" value="4"><span>4</span>
<input type="radio" name="shooting" value="5"><span>5</span>
<br>
<input type="radio" name="shooting" value="6"><span>6</span>
<input type="radio" name="shooting" value="7"><span>7</span>
<input type="radio" name="shooting" value="8"><span>8</span>
<input type="radio" name="shooting" value="9"><span>9</span>
<input type="radio" name="shooting" value="10"><span>10</span>
</form>
</td>
<td>
<form action="">
<input type="radio" name="passing" value="1"><span>1</span>
<input type="radio" name="passing" value="2"><span>2</span>
<input type="radio" name="passing" value="3"><span>3</span>
<input type="radio" name="passing" value="4"><span>4</span>
<input type="radio" name="passing" value="5"><span>5</span>
<br>
<input type="radio" name="passing" value="6"><span>6</span>
<input type="radio" name="passing" value="7"><span>7</span>
<input type="radio" name="passing" value="8"><span>8</span>
<input type="radio" name="passing" value="9"><span>9</span>
<input type="radio" name="passing" value="10"><span>10</span>
</form>
</td>
<td>
<form action="">
<input type="radio" name="puck_control" value="1"><span>1</span>
<input type="radio" name="puck_control" value="2"><span>2</span>
<input type="radio" name="puck_control" value="3"><span>3</span>
<input type="radio" name="puck_control" value="4"><span>4</span>
<input type="radio" name="puck_control" value="5"><span>5</span>
<br>
<input type="radio" name="puck_control" value="6"><span>6</span>
<input type="radio" name="puck_control" value="7"><span>7</span>
<input type="radio" name="puck_control" value="8"><span>8</span>
<input type="radio" name="puck_control" value="9"><span>9</span>
<input type="radio" name="puck_control" value="10"><span>10</span>
</form>
</td>
<td>
<form action="">
<input type="radio" name="team_play" value="1"><span>1</span>
<input type="radio" name="team_play" value="2"><span>2</span>
<input type="radio" name="team_play" value="3"><span>3</span>
<input type="radio" name="team_play" value="4"><span>4</span>
<input type="radio" name="team_play" value="5"><span>5</span>
<br>
<input type="radio" name="team_play" value="6"><span>6</span>
<input type="radio" name="team_play" value="7"><span>7</span>
<input type="radio" name="team_play" value="8"><span>8</span>
<input type="radio" name="team_play" value="9"><span>9</span>
<input type="radio" name="team_play" value="10"><span>10</span>
</form>
</td>
<td>
<form action="">
<input type="radio" name="attendance" value="1"><span>1</span>
<input type="radio" name="attendance" value="2"><span>2</span>
<input type="radio" name="attendance" value="3"><span>3</span>
<input type="radio" name="attendance" value="4"><span>4</span>
<input type="radio" name="attendance" value="5"><span>5</span>
<br>
<input type="radio" name="attendance" value="6"><span>6</span>
<input type="radio" name="attendance" value="7"><span>7</span>
<input type="radio" name="attendance" value="8"><span>8</span>
<input type="radio" name="attendance" value="9"><span>9</span>
<input type="radio" name="attendance" value="10"><span>10</span>
</form>
</td>
<td class="overall" id="overall">
</td>
<td class="attendance" id="attendance"></td>
</tr>
<tr class="item" data-id="2">
<td></td>
<td></td>
<td></td>
<td></td>
<td>
<form action="">
<input type="radio" name="skating" value="1"><span>1</span>
<input type="radio" name="skating" value="2"><span>2</span>
<input type="radio" name="skating" value="3"><span>3</span>
<input type="radio" name="skating" value="4"><span>4</span>
<input type="radio" name="skating" value="5"><span>5</span>
<br>
<input type="radio" name="skating" value="6"><span>6</span>
<input type="radio" name="skating" value="7"><span>7</span>
<input type="radio" name="skating" value="8"><span>8</span>
<input type="radio" name="skating" value="9"><span>9</span>
<input type="radio" name="skating" value="10"><span>10</span>
</form>
</td>
<td>
<form action="">
<input type="radio" name="shooting" value="1"><span>1</span>
<input type="radio" name="shooting" value="2"><span>2</span>
<input type="radio" name="shooting" value="3"><span>3</span>
<input type="radio" name="shooting" value="4"><span>4</span>
<input type="radio" name="shooting" value="5"><span>5</span>
<br>
<input type="radio" name="shooting" value="6"><span>6</span>
<input type="radio" name="shooting" value="7"><span>7</span>
<input type="radio" name="shooting" value="8"><span>8</span>
<input type="radio" name="shooting" value="9"><span>9</span>
<input type="radio" name="shooting" value="10"><span>10</span>
</form>
</td>
<td>
<form action="">
<input type="radio" name="passing" value="1"><span>1</span>
<input type="radio" name="passing" value="2"><span>2</span>
<input type="radio" name="passing" value="3"><span>3</span>
<input type="radio" name="passing" value="4"><span>4</span>
<input type="radio" name="passing" value="5"><span>5</span>
<br>
<input type="radio" name="passing" value="6"><span>6</span>
<input type="radio" name="passing" value="7"><span>7</span>
<input type="radio" name="passing" value="8"><span>8</span>
<input type="radio" name="passing" value="9"><span>9</span>
<input type="radio" name="passing" value="10"><span>10</span>
</form>
</td>
<td>
<form action="">
<input type="radio" name="puck_control" value="1"><span>1</span>
<input type="radio" name="puck_control" value="2"><span>2</span>
<input type="radio" name="puck_control" value="3"><span>3</span>
<input type="radio" name="puck_control" value="4"><span>4</span>
<input type="radio" name="puck_control" value="5"><span>5</span>
<br>
<input type="radio" name="puck_control" value="6"><span>6</span>
<input type="radio" name="puck_control" value="7"><span>7</span>
<input type="radio" name="puck_control" value="8"><span>8</span>
<input type="radio" name="puck_control" value="9"><span>9</span>
<input type="radio" name="puck_control" value="10"><span>10</span>
</form>
</td>
<td>
<form action="">
<input type="radio" name="team_play" value="1"><span>1</span>
<input type="radio" name="team_play" value="2"><span>2</span>
<input type="radio" name="team_play" value="3"><span>3</span>
<input type="radio" name="team_play" value="4"><span>4</span>
<input type="radio" name="team_play" value="5"><span>5</span>
<br>
<input type="radio" name="team_play" value="6"><span>6</span>
<input type="radio" name="team_play" value="7"><span>7</span>
<input type="radio" name="team_play" value="8"><span>8</span>
<input type="radio" name="team_play" value="9"><span>9</span>
<input type="radio" name="team_play" value="10"><span>10</span>
</form>
</td>
<td>
<form action="">
<input type="radio" name="attendance" value="1"><span>1</span>
<input type="radio" name="attendance" value="2"><span>2</span>
<input type="radio" name="attendance" value="3"><span>3</span>
<input type="radio" name="attendance" value="4"><span>4</span>
<input type="radio" name="attendance" value="5"><span>5</span>
<br>
<input type="radio" name="attendance" value="6"><span>6</span>
<input type="radio" name="attendance" value="7"><span>7</span>
<input type="radio" name="attendance" value="8"><span>8</span>
<input type="radio" name="attendance" value="9"><span>9</span>
<input type="radio" name="attendance" value="10"><span>10</span>
</form>
</td>
<td class="overall" id="overall">
</td>
<td class="attendance" id="attendance"></td>
</tr>
</tbody>
</table>
<div class="hidden_table" id="hidden_table"></div>
<div align="center">
<input type="button" onclick="populateModalData()" value="Export to Excel">
</div>
<div id="modal_container" style="display: none">
<div id="modal">
<span class="closebtn" onclick="toggleDialog()">Close</span>
<div id="modaldata"></div>
<div class="buttongroup">
<button onclick="tableToExcel('copyTable', 'Player_scores')">Okay</button>
<button onclick="toggleDialog()">Cancel</button>
</div>
</div>
</div>
关于javascript - 满足条件时拉取数据属性列表,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/48326659/
我正在努力处理查询的 WHERE 部分。查询本身包含一个基于两个表中都存在的 ID 的 LEFT JOIN。但是,我要求 where 语句仅返回其中一列中存在的最大单个结果。目前我返回连接中的所有值,
我有这个代码来改变文件系统的大小。问题是,即使满足 if 条件,它也不会进入 if 条件,而我根本没有检查 if 条件。它直接进入 else 条件。 运行代码后的结果 post-install-ray
假设我有一个包含 2 列的 Excel 表格:单元格 A1 到 A10 中的日期和 B1 到 B10 中的值。 我想对五月日期的所有值求和。我有3种可能性: {=SUM((MONTH(A1:A10)=
伪代码: SELECT * FROM 'table' WHERE ('date' row.date 或 ,我们在Stack Overflow上找到一个类似的问题: https://stackove
我有下面这行代码做一个简单的查询 if ($this->fulfilled) $criteria->addCondition('fulfilled ' . (($this->fulfilled
如果在数据库中找到用户输入的键,我将尝试显示“表”中的数据。目前我已将其设置为让数据库检查 key 是否存在,如下所示: //Select all from table if a key entry
关闭。此题需要details or clarity 。目前不接受答案。 想要改进这个问题吗?通过 editing this post 添加详细信息并澄清问题. 已关闭 5 年前。 Improve th
在MYSQL中可以吗 一共有三个表 任务(task_id、task_status、...) tasks_assigned_to(ta_id、task_id、user_id) task_suggeste
我想先根据用户的状态然后根据用户名来排序我的 sql 请求。该状态由 user_type 列设置: 1=活跃,2=不活跃,3=创始人。 我会使用此请求来执行此操作,但它不起作用,因为我想在“活跃”成员
下面两个函数中最专业的代码风格是什么? 如果函数变得更复杂和更大,例如有 20 个检查怎么办? 注意:每次检查后我都需要做一些事情,所以我不能将所有内容连接到一个 if 语句中,例如: if (veh
我在 C# 项目中使用 EntityFramework 6.1.3 和 SQL Server。我有两个查询,基本上应该执行相同的操作。 1. Exams.GroupBy(x=>x.SubjectID)
我试图在 case when 语句中放入两个条件,但我在 postgresql 中遇到语法错误 case when condition 1 and condition 2 then X else Y
我正在构建一个连接多个表的查询,一个表 prodRecipe 将包含某些行的数据,但不是全部,但是 tmp_inv1 将包含所有行的计数信息。问题是,tmp_inv1.count 取决于某个项目是否在
我有一个涉及 couples of rows which have a less-than-2-hours time-difference 的查询(~0.08333 天): SELECT mt1.*,
我有一个包含许多这样的 OR 条件的代码(工作正常)来检查其中一个值是否为空,然后我们抛出一条错误消息(所有这些都必须填写) } elsif ( !$params{'account'}
我有一个名为 spGetOrders 的存储过程,它接受一些参数:@startdate 和 @enddate。这将查询“订单”表。表中的一列称为“ClosedDate”。如果订单尚未关闭,则此列将保留
在代码中,注释部分是我需要解决的问题...有没有办法在 LINQ 中编写这样的查询?我需要这个,因为我需要根据状态进行排序。 var result = ( from contact in d
我正在尝试创建一个允许省略参数的存储过程,但如果提供了参数,则进行 AND 操作: CREATE PROCEDURE MyProcedure @LastName Varchar(30)
我正在寻找一种方法来过滤我的主机文件中的新 IP 地址。我创建了一个脚本,每次我用来自矩阵企业管理器的数据调用它时都会更新我的主机文件。它工作正常。但是我必须找到一个解决方案,只允许更新 10.XX.
所以我正在做一种 slider ,当它完全向下时隐藏向下按钮,反之亦然,当向上按钮隐藏时,我遇到了问题。 var amount = $('slide').attr('number'); $('span
我是一名优秀的程序员,十分优秀!