Subversion Repositories SmartDukaan

<div class="modal-header">

    <button type="button" class="close" data-dismiss="modal">&times;</button>

    <h4 class="modal-title"></h4>

</div>

<div class="modal-body">

    <div id="table"></div>

    <pre></pre>

    <code></code>

</div>

<div class="modal-footer">

    <button type="button" data-dismiss="modal" class="btn btn-default download-report">Download</button>

</div>

    #*#if ($content)

        <ul>

            #foreach($row in $content.entrySet())

                <li>

                    <strong>$row.key:</strong>

                    #if ($row.value)

                        <ul>

                            #set($content = $row.value)

                            #parse("reportico/content.vm")

                        </ul>

                    #else

                        $row.value

                    #end

                </li>

            #end

        </ul>

    #else

        <p>No data to display.</p>

    #end*#

<script>

    var obj = $content;

    var { Format, Datasource, EntryForm, Assignments, Criteria, Output } = obj.ReportQuery;

    //var regex = /\[\s*and\s+(\w+)\s+(\S+)\s+\{[^,]+,[^}]+\}\s+and\s+\{[^,]+,[^}]+\}\s*\]/;

    var regex = /\[\s*and\s+([\w.]+)?\s*(\S+)?\s*\{[^}]*\}\s*(?:and\s+\{[^}]*\})?\s*\]|\{\s*([^}]+)\s*\}/;

    var sqlQuery = EntryForm.Query.SQL.SQLRaw;

    console.log('EntryForm',EntryForm)

    $('.modal-title').text(Format.ReportTitle);

    $('code').text(sqlQuery.replace(regex, "REPLACE_QUERY_HERE"));

    $('pre').text(JSON.stringify(obj.ReportQuery, null, 2));

    var table = '<table border="1" width="100%"><tr>';

    console.log('EntryForm.Query.QueryColumns',EntryForm.Query.QueryColumns.QueryColumn)

    for (var index in EntryForm.Query.QueryColumns.QueryColumn) {

        table += '<td>'+EntryForm.Query.QueryColumns.QueryColumn[index].Name+'</td>';

    }

    table += '</tr></table>';

    $('#table').html(table);

</script>