View | Details | Raw Unified | Return to bug 17047
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/mana_03-add_mana_autoshare.sql (-1 / +1 lines)
Lines 1-2 Link Here
1
INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
1
INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
2
('AutoShareWithMana','subscription','','defines datas automatically shared with mana','multiple');
2
('AutoShareWithMana','','','defines datas automatically shared with mana','multiple');
(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/mana/mana-report-search-result.inc (-1 / +1 lines)
Lines 30-36 Link Here
30
                    [% END %]
30
                    [% END %]
31
                    <input hidden class="rowid" value="[% report.id %]">
31
                    <input hidden class="rowid" value="[% report.id %]">
32
                    <td>[% IF ( report.report_name ) %][% report.report_name %][% END %]</td>
32
                    <td>[% IF ( report.report_name ) %][% report.report_name %][% END %]</td>
33
                    <td title="[% report.savedsql %]"><div>
33
                    <td title="[% report.savedsql |html %]"><div>
34
                        [% IF report.notes.length > 200 %]
34
                        [% IF report.notes.length > 200 %]
35
                            [% report.notes.substr(0,200) %]<a class="showbutton">Show More</a></div><div hidden>
35
                            [% report.notes.substr(0,200) %]<a class="showbutton">Show More</a></div><div hidden>
36
                        [% END %]
36
                        [% END %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/reports-toolbar.inc (-1 / +147 lines)
Lines 5-10 Link Here
5
            <ul class="dropdown-menu">
5
            <ul class="dropdown-menu">
6
                <li id="newmenuc"><a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new">New guided report</a> </li>
6
                <li id="newmenuc"><a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new">New guided report</a> </li>
7
                <li id="newsql"><a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Create%20report%20from%20SQL">New SQL report</a> </li>
7
                <li id="newsql"><a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Create%20report%20from%20SQL">New SQL report</a> </li>
8
                [% IF Koha.Preference('Mana')==1 %]
9
                <li id="newsql"><a href="" data-toggle="modal" data-target="#mana_search_result">New SQL from Mana</a> </li>
10
                [% END %]
8
            </ul>
11
            </ul>
9
        </div>
12
        </div>
10
    [% END %]
13
    [% END %]
Lines 64-75 Link Here
64
    [% END %]
67
    [% END %]
65
</div>
68
</div>
66
69
70
71
[% IF Koha.Preference('Mana')==1 %]
72
    <div id="mana_search_result" class="modal fade container-fluid" tabindex="-1" role="dialog" aria-labelledby="mana_search_result_label" style="width: 100%; left:0%; margin-left: auto; display: none;">
73
        <div class="modal-dialog modal-lg">
74
            <div class="modal-content">
75
                <div class="modal-header">
76
                    <button type="button" class="closebtn" data-dismiss="modal" aria-hidden="true">×</button>
77
                    <h3 id="mana_search_result_label"> Mana Search</h3>
78
                </div>
79
                <div>
80
                    <form id="search_form" style="margin-left: 5%">
81
                        Please enter a few key words:
82
                        <input type=text id=mana_search_field>
83
                        <input type=button class="mana_search_button" value="Search">
84
                    </form>
85
                    <div class="modal-body">
86
                    </div>
87
                </div>
88
            </div>
89
        </div>
90
    </div>
91
[% END %]
92
93
94
67
<script type="text/javascript">
95
<script type="text/javascript">
68
var MSG_CONFIRM_DELETE = _("Are you sure you want to delete this report? This cannot be undone.");
96
var MSG_CONFIRM_DELETE = _("Are you sure you want to delete this report? This cannot be undone.");
69
70
$(document).ready(function(){
97
$(document).ready(function(){
71
    $(".delete").on("click",function(){
98
    $(".delete").on("click",function(){
72
        return confirmDelete(MSG_CONFIRM_DELETE);
99
        return confirmDelete(MSG_CONFIRM_DELETE);
73
    });
100
    });
74
});
101
});
75
</script>
102
</script>
103
104
<script type="text/javascript">
105
    $(document).ready( function(){
106
        $(".mana_search_button").on("click",function(){
107
            mana_search($("#mana_search_field").val());
108
        });
109
    });
110
111
    $('#search_form').on( "submit", function(event) {
112
        event.preventDefault();
113
        mana_search($(this).children("#mana_search_field").val());
114
    });
115
116
    function mana_increment(mana_id, resourcename, fieldvalue, stepvalue = 1){
117
        $.ajax( {
118
            type: "POST",
119
            url: "/cgi-bin/koha/svc/mana/addvaluetofield",
120
            data: {id: mana_id, field: fieldvalue, resource: resourcename, step: stepvalue},
121
            datatype: "json",
122
        }).done( function() {
123
        }).fail( function(){ alert("") });
124
    }
125
126
    function mana_use( mana_id ){
127
        $.ajax( {
128
            type:"POST",
129
            url: "/cgi-bin/koha/svc/mana/use",
130
            data: {id:mana_id, resource: 'report', saveinbase: 1},
131
            dataType: "json",
132
        })
133
        .done( function (result){
134
            if ( result.errmsg ){
135
                alert( result.errmsg );
136
            }
137
            else{
138
                window.location = ("/cgi-bin/koha/reports/guided_reports.pl?reports=").concat(result.id).concat("&amp;phase=Show%20SQL&mana_success=1");
139
            }
140
        })
141
        .fail( function ( foo, msg, longmsg, bla ){
142
        });
143
    }
144
145
    function mana_search( textquery ){
146
        $.ajax({
147
            type: "POST",
148
            url: "/cgi-bin/koha/svc/mana/search",
149
            data: {biblionumber: $("#biblionumber").val(), resource: 'report', id: textquery, usecomments: 1},
150
            dataType: "html",
151
        })
152
        .done( function( result ) {
153
            $("#mana_search_result .modal-body").html(result);
154
            $("#mana_search_result_label").text("Results from Mana Knowledge Base");
155
            $("#mana_results_datatable").dataTable($.extend(true, {}, dataTablesDefaults,{
156
                "sPaginationType":"four_button",
157
                "autoWidth": false,
158
                "columnDefs": [
159
                    { "width": "35%", "targets": 1 }
160
                ],
161
                "aoColumnDefs": [
162
                    { 'bSortable': false, "bSearchable": false, 'aTargets': [ 'NoSort' ] },
163
                    { "sType": "title-string", "aTargets" : [ "title-string" ] },
164
                    { 'sType': "anti-the", 'aTargets' : [ 'anti-the'] }
165
                ]
166
            }));
167
            if($("td.dataTables_empty").length == 0){
168
                 $("#mana_search").show();
169
            }
170
171
            $( "select[class='actionreport1']" ).show();
172
            $( "button[class='actionreport2']" ).hide();
173
            $("#CommentButton").on("click", function(){
174
                var resource_type = "report";
175
                var target_id = $("#selected_id").val();
176
                var manamsg = $("#manamsg").val();
177
                mana_comment(target_id, manamsg, resource_type);
178
                $("#comment_box").modal("hide");
179
            });
180
181
            $(".showbutton").on("click", function(){
182
                $(this).parent().hide();
183
                $(this).parent().next().show();
184
            });
185
186
            $("a[class='hidebutton']").on("click", function(){
187
                $(this).parent().hide();
188
                $(this).parent().prev().show();
189
            });
190
191
            $("#commentCloseButton").on("click", function(){
192
                $("#comment_box").modal("hide");
193
            });
194
195
            $(".actionreport1").on("click", function(){
196
                $("#selectedcomment").val($(this).val());
197
                $(this).parent("select").hide();
198
                $(this).parent("select").next().show();
199
            });
200
201
            $(".actionreport2").on("click", function(){
202
                $(this).hide();
203
                $(this).prev().show();
204
                mana_increment($("#selectedcomment").val(), 'resource_comment', 'nb', -1);
205
            });
206
        }).fail( function( result ){
207
        });
208
    }
209
210
    function mana_comment( target_id, manamsg, resource_type ){
211
        $.ajax( {
212
            type: "POST",
213
            url: "/cgi-bin/koha/svc/mana/share",
214
            data: {message: manamsg, resource: resource_type , resource_id: target_id},
215
            datatype: "json",
216
        })
217
    }
218
219
220
221
</script>
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt (-113 / +14 lines)
Lines 88-97 $(".goback").on("click",function(e){ Link Here
88
    window.history.back();
88
    window.history.back();
89
});
89
});
90
90
91
$(".mana_search_button").on("click",function(){
92
    mana_search($(this).prev().val());
93
});
94
95
$(".ShareButton").on("click", function(){
91
$(".ShareButton").on("click", function(){
96
    if($(this).closest("tr").find(".report_notes").text().length < 20 || $(this).closest("tr").find(".report_name").text().length < 20){
92
    if($(this).closest("tr").find(".report_notes").text().length < 20 || $(this).closest("tr").find(".report_name").text().length < 20){
97
        $("#shared_infos").hide();
93
        $("#shared_infos").hide();
Lines 108-116 $(".ShareButton").on("click", function(){ Link Here
108
    }
104
    }
109
});
105
});
110
106
111
$('#search_form').submit(function () {
112
    return false;
113
});
114
107
115
$("#addColumn").on("click",function(){
108
$("#addColumn").on("click",function(){
116
    addColumn();
109
    addColumn();
Lines 296-399 $("#delColumn").on("click",function(){ Link Here
296
[% END %]
289
[% END %]
297
});
290
});
298
291
299
function mana_increment(mana_id, resourcename, fieldvalue, stepvalue = 1){
300
    $.ajax( {
301
        type: "POST",
302
        url: "/cgi-bin/koha/svc/mana/addvaluetofield",
303
        data: {id: mana_id, field: fieldvalue, resource: resourcename, step: stepvalue},
304
        datatype: "json",
305
    }).done( function() {
306
    }).fail( function(){ });
307
}
308
309
function mana_use( mana_id ){
310
    $.ajax( {
311
        type:"POST",
312
        url: "/cgi-bin/koha/svc/mana/use",
313
        data: {id:mana_id, resource: 'report', saveinbase: 1},
314
        dataType: "json",
315
    })
316
    .done( function (result){
317
        window.location = ("/cgi-bin/koha/reports/guided_reports.pl?reports=").concat(result.id).concat("&amp;phase=Show%20SQL");
318
    })
319
    .fail( function ( foo, msg, longmsg){
320
    });
321
}
322
323
function mana_search( textquery ){
324
    $.ajax({
325
        type: "POST",
326
        url: "/cgi-bin/koha/svc/mana/search",
327
        data: {biblionumber: $("#biblionumber").val(), resource: 'report', id: textquery, usecomments: 1},
328
        dataType: "html",
329
    })
330
    .done( function( result ) {
331
        $("#mana_search_result .modal-body").html(result);
332
        $("#mana_search_result_label").text("Results from Mana Knowledge Base");
333
        $("#mana_results_datatable").dataTable($.extend(true, {}, dataTablesDefaults,{
334
            "sPaginationType":"four_button",
335
            "autoWidth": false,
336
            "columnDefs": [
337
                { "width": "35%", "targets": 1 }
338
            ],
339
            "aoColumnDefs": [
340
                { 'bSortable': false, "bSearchable": false, 'aTargets': [ 'NoSort' ] },
341
                { "sType": "title-string", "aTargets" : [ "title-string" ] },
342
                { 'sType': "anti-the", 'aTargets' : [ 'anti-the'] }
343
            ]
344
        }));
345
        if($("td.dataTables_empty").length == 0){
346
             $("#mana_search").show();
347
        }
348
349
        $( "select[class='actionreport1']" ).show();
350
        $( "button[class='actionreport2']" ).hide();
351
        $("#CommentButton").on("click", function(){
352
            var resource_type = "report";
353
            var target_id = $("#selected_id").val();
354
            var manamsg = $("#manamsg").val();
355
            mana_comment(target_id, manamsg, resource_type);
356
            $("#comment_box").modal("hide");
357
        });
358
359
        $(".showbutton").on("click", function(){
360
            $(this).parent().hide();
361
            $(this).parent().next().show();
362
        });
363
364
        $("a[class='hidebutton']").on("click", function(){
365
            $(this).parent().hide();
366
            $(this).parent().prev().show();
367
        });
368
369
        $("#commentCloseButton").on("click", function(){
370
            $("#comment_box").modal("hide");
371
        });
372
373
        $(".actionreport1").on("click", function(){
374
            $("#selectedcomment").val($(this).val());
375
            $(this).parent("select").hide();
376
            $(this).parent("select").next().show();
377
        });
378
379
        $(".actionreport2").on("click", function(){
380
            $(this).hide();
381
            $(this).prev().show();
382
            mana_increment($("#selectedcomment").val(), 'resource_comment', 'nb', -1);
383
        });
384
    }).fail( function( result ){
385
    });
386
}
387
388
function mana_comment( target_id, manamsg, resource_type ){
389
    $.ajax( {
390
        type: "POST",
391
        url: "/cgi-bin/koha/svc/mana/share",
392
        data: {message: manamsg, resource: resource_type , resource_id: target_id},
393
        datatype: "json",
394
    })
395
}
396
397
292
398
293
399
</script>
294
</script>
Lines 505-510 canned reports and writing custom SQL reports.</p> Link Here
505
    </div>
400
    </div>
506
</div>
401
</div>
507
402
403
[% IF report_converted %]
404
    <div class="dialog message">
405
        The report "[% report_converted %]" has been converted.
406
    </div>
407
[% END %]
408
409
508
[% IF ( saved1 ) %]
410
[% IF ( saved1 ) %]
509
[% IF ( savedreports ) %]<h1>Saved reports</h1>
411
[% IF ( savedreports ) %]<h1>Saved reports</h1>
510
412
Lines 529-542 canned reports and writing custom SQL reports.</p> Link Here
529
    </div>
431
    </div>
530
    [% END %]
432
    [% END %]
531
433
532
   [% IF (Koha.Preference('Mana') == 1) %]
533
    <div id="mana_search" class="dialog message">
534
        <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>
535
    </div>
536
    [% END %]
537
538
</script>
434
</script>
539
<h1> [% savedreport.sql %]</h1>
435
540
<form action="/cgi-bin/koha/reports/guided_reports.pl" id="reports_form" method="post">
436
<form action="/cgi-bin/koha/reports/guided_reports.pl" id="reports_form" method="post">
541
<input type="hidden" name="phase" value="Delete Multiple" />
437
<input type="hidden" name="phase" value="Delete Multiple" />
542
        <table id="table_reports">
438
        <table id="table_reports">
Lines 567-573 canned reports and writing custom SQL reports.</p> Link Here
567
                            [% IF ( CAN_user_reports_delete_reports ) %] <!-- not break CSS -->
463
                            [% IF ( CAN_user_reports_delete_reports ) %] <!-- not break CSS -->
568
                                <input type="checkbox" name="ids" value="[% savedreport.id %]" />
464
                                <input type="checkbox" name="ids" value="[% savedreport.id %]" />
569
                            [% END %]
465
                            [% END %]
570
                        <input hidden class="report_sql" value="[% savedreport.savedsql %]">
466
                        <input hidden class="report_sql" value="[% savedreport.savedsql |html %]">
571
                        </td>
467
                        </td>
572
                        <td class="report_id"><label for="ids">[% savedreport.id %]</label></td>
468
                        <td class="report_id"><label for="ids">[% savedreport.id %]</label></td>
573
                        <td class="report_name">
469
                        <td class="report_name">
Lines 1293-1298 Sub report:<select name="subreport"> Link Here
1293
[% END %]
1189
[% END %]
1294
1190
1295
[% IF ( showsql ) %]
1191
[% IF ( showsql ) %]
1192
    [% IF mana_success %]
1193
        <fieldset>
1194
            Shared Successfully, thanks for your contribution!
1195
        </fieldset>
1196
    [% END %]
1296
<fieldset class="rows">
1197
<fieldset class="rows">
1297
    <legend>[% reportname %]</legend>
1198
    <legend>[% reportname %]</legend>
1298
    <ol>
1199
    <ol>
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/subscription-add.tt (-6 / +15 lines)
Lines 406-411 function show_page_2() { Link Here
406
}
406
}
407
407
408
function mana_search() {
408
function mana_search() {
409
    $("#mana_search").html("<p>Mana kb is being asked for your subscription..</p>");
410
    $("#mana_search").show();
411
409
    $.ajax({
412
    $.ajax({
410
        type: "POST",
413
        type: "POST",
411
        url: "/cgi-bin/koha/svc/mana/search",
414
        url: "/cgi-bin/koha/svc/mana/search",
Lines 414-419 function mana_search() { Link Here
414
    })
417
    })
415
    .done( function( result ) {
418
    .done( function( result ) {
416
        $("#mana_search_result .modal-body").html(result);
419
        $("#mana_search_result .modal-body").html(result);
420
debugger;
417
        $("#mana_search_result_label").text("Results from Mana Knowledge Base");
421
        $("#mana_search_result_label").text("Results from Mana Knowledge Base");
418
        $("#mana_results_datatable").dataTable($.extend(true, {}, dataTablesDefaults, {
422
        $("#mana_results_datatable").dataTable($.extend(true, {}, dataTablesDefaults, {
419
            "sPaginationType": "four_button",
423
            "sPaginationType": "four_button",
Lines 429-436 function mana_search() { Link Here
429
            ]
433
            ]
430
        }));
434
        }));
431
        if( $("#mana_results_datatable").length && $("td.dataTables_empty").length == 0){
435
        if( $("#mana_results_datatable").length && $("td.dataTables_empty").length == 0){
432
            $("#mana_search").show();
436
            $("#mana_search").html("<p>Subscription found on Mana Knowledge Base:</p><p> <a style='cursor:pointer' data-toggle='modal' data-target='#mana_search_result'>Quick fill</a></p>");
437
        }
438
        else if ( $("#mana_results_datatable").length ){
439
            $("#mana_search").html("<p>No subscription found on Mana Knowledge Base :(</p><p> Please feel free to share you pattern with all others librarians once you are done</p>");
433
        }
440
        }
441
        else{
442
            $("#mana_search").html( result );
443
        }
444
        $("#mana_search").show();
434
        $( "select[class='actionreport1']" ).show();
445
        $( "select[class='actionreport1']" ).show();
435
        $( "button[class='actionreport2']" ).hide();
446
        $( "button[class='actionreport2']" ).hide();
436
447
Lines 458-464 function mana_search() { Link Here
458
            mana_increment($("#selectedcomment").val(), 'resource_comment', 'nb', -1);
469
            mana_increment($("#selectedcomment").val(), 'resource_comment', 'nb', -1);
459
        });
470
        });
460
471
461
    }).fail(function(result){
472
    }).fail(function(result, msg, longmsg){
473
        console.log( msg );
474
        console.log( longmsg );
462
    });
475
    });
463
}
476
}
464
477
Lines 566-574 $(document).ready(function() { Link Here
566
579
567
580
568
    mana_search();
581
    mana_search();
569
    $("#myid").on("click", function(){
570
        debugger;
571
    })
572
    $("#displayexample").hide();
582
    $("#displayexample").hide();
573
    $("#mana_search_result").modal("hide");
583
    $("#mana_search_result").modal("hide");
574
    $("#aqbooksellerid").on('keypress', function(e) {
584
    $("#aqbooksellerid").on('keypress', function(e) {
Lines 914-920 $(document).ready(function() { Link Here
914
                [% END %]
924
                [% END %]
915
925
916
                        <div hidden id="mana_search" class="dialog message">
926
                        <div hidden id="mana_search" class="dialog message">
917
                            <p>Subscription found on Mana Knowledge Base:</p><p> <a style="cursor:pointer" data-toggle="modal" data-target="#mana_search_result">Quick fill</a></p>
918
                        </div>
927
                        </div>
919
                        <div id="subscription_form_planning">
928
                        <div id="subscription_form_planning">
920
                            <fieldset class="rows">
929
                            <fieldset class="rows">
(-)a/reports/guided_reports.pl (+1 lines)
Lines 181-186 elsif ( $phase eq 'Show SQL'){ Link Here
181
        'notes'      => $report->{notes},
181
        'notes'      => $report->{notes},
182
	'sql'     => $report->{savedsql},
182
	'sql'     => $report->{savedsql},
183
	'showsql' => 1,
183
	'showsql' => 1,
184
        'mana_success' => $input->param('mana_success'),
184
    );
185
    );
185
}
186
}
186
187
(-)a/svc/mana/share (-1 / +19 lines)
Lines 45-47 $content->{resource_id} = $input->param("resource_id"); Link Here
45
$content->{resource_type} = $input->param("resource");
45
$content->{resource_type} = $input->param("resource");
46
$content->{message} = $input->param("message");
46
$content->{message} = $input->param("message");
47
Koha::SharedContent::manaPostRequest('resource_comment', $content);
47
Koha::SharedContent::manaPostRequest('resource_comment', $content);
48
- 
48
    my $package = "Koha::".ucfirst($input->param('resource'));
49
    my $resource;
50
    my $result;
51
eval{
52
    $result = Koha::SharedContent::manaGetRequestWithId($input->param('resource'), $input->param('id') );
53
};
54
if ( $@ or $result->{code} == 500 ){
55
    $resource->{errmsg} =  "Error: mana access got broken, please try again later\n\n ( error: $@ )";
56
}
57
else{
58
    if ( $input->param( 'saveinbase' )) {
59
        $resource = { id => $package->new_from_mana($result->{data})->id };
60
    }
61
    else{
62
        $resource = $result->{data};
63
    }
64
}
65
66
print(to_json($resource));

Return to bug 17047