|
Lines 155-160
canned reports and writing custom SQL reports.</p>
Link Here
|
| 155 |
</div> |
155 |
</div> |
| 156 |
</div> |
156 |
</div> |
| 157 |
|
157 |
|
|
|
158 |
[% IF report_converted %] |
| 159 |
<div class="dialog message"> |
| 160 |
The report "[% report_converted %]" has been converted. |
| 161 |
</div> |
| 162 |
[% END %] |
| 163 |
|
| 164 |
|
| 158 |
[% IF ( saved1 ) %] |
165 |
[% IF ( saved1 ) %] |
| 159 |
[% IF ( savedreports ) %]<h1>Saved reports</h1> |
166 |
[% IF ( savedreports ) %]<h1>Saved reports</h1> |
| 160 |
|
167 |
|
|
Lines 196-209
canned reports and writing custom SQL reports.</p>
Link Here
|
| 196 |
</div> |
203 |
</div> |
| 197 |
[% END %] |
204 |
[% END %] |
| 198 |
|
205 |
|
| 199 |
[% IF (Koha.Preference('Mana') == 1) %] |
|
|
| 200 |
<div id="mana_search" class="dialog message"> |
| 201 |
<p> You want more reports? Check the Mana Knowledge Base <p> <a style="cursor:pointer" data-toggle="modal" data-target="#mana_search_result">Quick Search</a></p> |
| 202 |
</div> |
| 203 |
[% END %] |
| 204 |
|
| 205 |
</script> |
206 |
</script> |
| 206 |
<h1> [% savedreport.sql %]</h1> |
207 |
|
| 207 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" id="reports_form" method="post"> |
208 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" id="reports_form" method="post"> |
| 208 |
<input type="hidden" name="phase" value="Delete Multiple" /> |
209 |
<input type="hidden" name="phase" value="Delete Multiple" /> |
| 209 |
<table id="table_reports"> |
210 |
<table id="table_reports"> |
|
Lines 243-249
canned reports and writing custom SQL reports.</p>
Link Here
|
| 243 |
[% IF ( CAN_user_reports_delete_reports ) %] <!-- not break CSS --> |
244 |
[% IF ( CAN_user_reports_delete_reports ) %] <!-- not break CSS --> |
| 244 |
<input type="checkbox" name="ids" value="[% savedreport.id | html %]" /> |
245 |
<input type="checkbox" name="ids" value="[% savedreport.id | html %]" /> |
| 245 |
[% END %] |
246 |
[% END %] |
| 246 |
<input hidden class="report_sql" value="[% savedreport.savedsql %]"> |
247 |
<input hidden class="report_sql" value="[% savedreport.savedsql |html %]"> |
| 247 |
</td> |
248 |
</td> |
| 248 |
<td class="report_id"><label for="ids">[% savedreport.id | html %]</label></td> |
249 |
<td class="report_id"><label for="ids">[% savedreport.id | html %]</label></td> |
| 249 |
<td class="report_name"> |
250 |
<td class="report_name"> |
|
Lines 1297-1306
canned reports and writing custom SQL reports.</p>
Link Here
|
| 1297 |
window.history.back(); |
1298 |
window.history.back(); |
| 1298 |
}); |
1299 |
}); |
| 1299 |
|
1300 |
|
| 1300 |
$(".mana_search_button").on("click",function(){ |
|
|
| 1301 |
mana_search($(this).prev().val()); |
| 1302 |
}); |
| 1303 |
|
| 1304 |
$(".ShareButton").on("click", function(){ |
1301 |
$(".ShareButton").on("click", function(){ |
| 1305 |
if($(this).closest("tr").find(".report_notes").text().length < 20 || $(this).closest("tr").find(".report_name").text().length < 20){ |
1302 |
if($(this).closest("tr").find(".report_notes").text().length < 20 || $(this).closest("tr").find(".report_name").text().length < 20){ |
| 1306 |
$("#shared_infos").hide(); |
1303 |
$("#shared_infos").hide(); |
|
Lines 1317-1326
canned reports and writing custom SQL reports.</p>
Link Here
|
| 1317 |
} |
1314 |
} |
| 1318 |
}); |
1315 |
}); |
| 1319 |
|
1316 |
|
| 1320 |
$('#search_form').submit(function () { |
|
|
| 1321 |
return false; |
| 1322 |
}); |
| 1323 |
|
| 1324 |
$("#addColumn").on("click",function(){ |
1317 |
$("#addColumn").on("click",function(){ |
| 1325 |
addColumn(); |
1318 |
addColumn(); |
| 1326 |
}); |
1319 |
}); |
|
Lines 1512-1614
canned reports and writing custom SQL reports.</p>
Link Here
|
| 1512 |
return confirmDelete(MSG_CONFIRM_DELETE); |
1505 |
return confirmDelete(MSG_CONFIRM_DELETE); |
| 1513 |
}); |
1506 |
}); |
| 1514 |
}); |
1507 |
}); |
| 1515 |
function mana_increment(mana_id, resourcename, fieldvalue, stepvalue = 1){ |
|
|
| 1516 |
$.ajax( { |
| 1517 |
type: "POST", |
| 1518 |
url: "/cgi-bin/koha/svc/mana/addvaluetofield", |
| 1519 |
data: {id: mana_id, field: fieldvalue, resource: resourcename, step: stepvalue}, |
| 1520 |
datatype: "json", |
| 1521 |
}).done( function() { |
| 1522 |
}).fail( function(){ }); |
| 1523 |
} |
| 1524 |
|
| 1525 |
function mana_use( mana_id ){ |
| 1526 |
$.ajax( { |
| 1527 |
type:"POST", |
| 1528 |
url: "/cgi-bin/koha/svc/mana/use", |
| 1529 |
data: {id:mana_id, resource: 'report', saveinbase: 1}, |
| 1530 |
dataType: "json", |
| 1531 |
}) |
| 1532 |
.done( function (result){ |
| 1533 |
window.location = ("/cgi-bin/koha/reports/guided_reports.pl?reports=").concat(result.id).concat("&phase=Show%20SQL"); |
| 1534 |
}) |
| 1535 |
.fail( function ( foo, msg, longmsg){ |
| 1536 |
}); |
| 1537 |
} |
| 1538 |
|
| 1539 |
function mana_search( textquery ){ |
| 1540 |
$.ajax({ |
| 1541 |
type: "POST", |
| 1542 |
url: "/cgi-bin/koha/svc/mana/search", |
| 1543 |
data: {biblionumber: $("#biblionumber").val(), resource: 'report', id: textquery, usecomments: 1}, |
| 1544 |
dataType: "html", |
| 1545 |
}) |
| 1546 |
.done( function( result ) { |
| 1547 |
$("#mana_search_result .modal-body").html(result); |
| 1548 |
$("#mana_search_result_label").text("Results from Mana Knowledge Base"); |
| 1549 |
$("#mana_results_datatable").dataTable($.extend(true, {}, dataTablesDefaults,{ |
| 1550 |
"sPaginationType":"four_button", |
| 1551 |
"autoWidth": false, |
| 1552 |
"columnDefs": [ |
| 1553 |
{ "width": "35%", "targets": 1 } |
| 1554 |
], |
| 1555 |
"aoColumnDefs": [ |
| 1556 |
{ 'bSortable': false, "bSearchable": false, 'aTargets': [ 'NoSort' ] }, |
| 1557 |
{ "sType": "title-string", "aTargets" : [ "title-string" ] }, |
| 1558 |
{ 'sType': "anti-the", 'aTargets' : [ 'anti-the'] } |
| 1559 |
] |
| 1560 |
})); |
| 1561 |
if($("td.dataTables_empty").length == 0){ |
| 1562 |
$("#mana_search").show(); |
| 1563 |
} |
| 1564 |
|
| 1565 |
$( "select[class='actionreport1']" ).show(); |
| 1566 |
$( "button[class='actionreport2']" ).hide(); |
| 1567 |
$("#CommentButton").on("click", function(){ |
| 1568 |
var resource_type = "report"; |
| 1569 |
var target_id = $("#selected_id").val(); |
| 1570 |
var manamsg = $("#manamsg").val(); |
| 1571 |
mana_comment(target_id, manamsg, resource_type); |
| 1572 |
$("#comment_box").modal("hide"); |
| 1573 |
}); |
| 1574 |
|
| 1575 |
$(".showbutton").on("click", function(){ |
| 1576 |
$(this).parent().hide(); |
| 1577 |
$(this).parent().next().show(); |
| 1578 |
}); |
| 1579 |
|
| 1580 |
$("a[class='hidebutton']").on("click", function(){ |
| 1581 |
$(this).parent().hide(); |
| 1582 |
$(this).parent().prev().show(); |
| 1583 |
}); |
| 1584 |
|
| 1585 |
$("#commentCloseButton").on("click", function(){ |
| 1586 |
$("#comment_box").modal("hide"); |
| 1587 |
}); |
| 1588 |
|
| 1589 |
$(".actionreport1").on("click", function(){ |
| 1590 |
$("#selectedcomment").val($(this).val()); |
| 1591 |
$(this).parent("select").hide(); |
| 1592 |
$(this).parent("select").next().show(); |
| 1593 |
}); |
| 1594 |
|
| 1595 |
$(".actionreport2").on("click", function(){ |
| 1596 |
$(this).hide(); |
| 1597 |
$(this).prev().show(); |
| 1598 |
mana_increment($("#selectedcomment").val(), 'resource_comment', 'nb', -1); |
| 1599 |
}); |
| 1600 |
}).fail( function( result ){ |
| 1601 |
}); |
| 1602 |
} |
| 1603 |
|
| 1604 |
function mana_comment( target_id, manamsg, resource_type ){ |
| 1605 |
$.ajax( { |
| 1606 |
type: "POST", |
| 1607 |
url: "/cgi-bin/koha/svc/mana/share", |
| 1608 |
data: {message: manamsg, resource: resource_type , resource_id: target_id}, |
| 1609 |
datatype: "json", |
| 1610 |
}) |
| 1611 |
} |
| 1612 |
|
1508 |
|
| 1613 |
function addColumn() { |
1509 |
function addColumn() { |
| 1614 |
$("#availableColumns option:selected").clone().appendTo("#selectedColumns").attr("selected", "selected"); |
1510 |
$("#availableColumns option:selected").clone().appendTo("#selectedColumns").attr("selected", "selected"); |