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>