kenken999/php
0
1<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">2<html lang="en">3 <head>4 <title>Chart: Group By</title>5 <meta http-equiv="X-UA-Compatible" content="IE=Edge">6 <link type="text/css" href="styles/default.css" rel="stylesheet">7 <link type="text/css" href="styles/{$wr_pagestylepath}/style.css" rel="stylesheet">8 9 {$h_includes}10 <style>11 .rnr-page { 12 margin: auto;13 width: 950px;14 }15 </style>16 </head>17 <body class="{$wr_pagestylepath}">18 {$b_includes}19 {$header}20 <div class="rnr-page">21 <div class="rnr-top">22 <div class="rnr-s-1 {$wr_pagestylepath}">23 <div class="rnr-c rnr-cv">24 <div class="style2" align=center>25 Chart: Group By{$chart_title}{$chart_table}26 </div>27 <div class="style1 rnr-b-wrapper">28 <div class="rnr-s-fields {$wr_pagestylepath}">29 <div class="rnr-c rnr-cv">30 <div class="style1"> 31 <table class="fieldGrid" id="table_wh">32 <tr>33 <td align=center>Column</td>34 <td align=center>Filter</td>35 <td align=center>OR...</td>36 <td align=center>OR...</td>37 <td align=center>OR...</td>38 <td align=center>Sort type</td>39 <td align=center>Sort order</td>40 <td align=center>41 <input type="checkbox" name="group_by_toggle" id="group_by_toggle"/>42 <label for="group_by_toggle">Group By</label>43 </td>44 <td align=center>Having</td>45 </tr>46 <tr class="condition-row" id="cond_row_0">47 <td class="field_value">48 <select id="field_opt" name="field_opt">49 <option selected="" value="-1"/>50 {$fields}51 </select>52 </td>53 <td class="filter_value">54 <input type="text" name="filter_value" id="filter_value" size="9"/>55 </td>56 <td class="first_or_value">57 <input type="text" name="first_or_value" id="first_or_value" size="9"/>58 </td>59 <td class="second_or_value">60 <input type="text" name="second_or_value" id="second_or_value" size="9"/>61 </td>62 <td class="third_or_value">63 <input type="text" name="third_or_value" id="third_or_value" size="9"/>64 </td>65 <td class="sort_dir">66 <select id="sort_dir" name="sort_dir">67 <option value="-1"></option>68 <option value="ASC">Ascending</option>69 <option value="DESC">Descending</option>70 </select> 71 </td>72 <td class="sort_order">73 <select id="sort_order" name="sort_order" style="display:none">74 <option selected="" value="-1"/>75 </select> 76 </td>77 <td class="group_by_value">78 <select id="group_by_value" name="group_by_value" disabled="">79 <option selected="" value="-1"/>80 <option value="GROUP BY">GROUP BY</option>81 <option value="SUM">SUM</option>82 <option value="MIN">MIN</option>83 <option value="MAX">MAX</option>84 <option value="AVG">AVG</option>85 <option value="COUNT">COUNT</option>86 </select> 87 </td>88 <td class="having_value">89 <input type="text" name="having_value" id="having_value" size="9" disabled=""/>90 </td>91 </tr>92 </table>93 </div>94 <div id="btns" class="style2" align=center>95 <a id="backbtn" name="backbtn" class="rnr-button" href="#">Back</a>96 <span style="position:absolute;" id="jumptospan"></span>97 <a id="jumpto" name="jumpto" class="rnr-button" href="#" onclick="event.cancelBubble = true;return false;" onmouseover="event.cancelBubble = true;return false;">Jump to ...</a>98 <a id="sqlbtn" name="sqlbtn" class="rnr-button" href="#">SQL Query</a>99 <a id="sql_query" class="various fancybox.iframe" href="web_query.php?type=webcharts&name=group_by_condition&ie=UTF-8&iframe"></a>100 <a id="nextbtn" name="nextbtn" class="rnr-button" href="#">Next</a>101 {BEGIN b_is_chart_save}102 <a id="saveasbtn" name="saveasbtn" class="rnr-button" href="#">Save as...</a>103 {END b_is_chart_save} 104 {BEGIN b_is_chart_name}105 <a id="savebtn" name="savebtn" class="rnr-button" href="#">Save</a>106 {END b_is_chart_name} 107 <a id="previewbtn" name="previewbtn" class="rnr-button" href="#">Preview</a>108 <a id="preview" class="various fancybox.iframe" href="dchart_preview.php?cname={$chart_name_preview}&ie=UTF-8&iframe"></a>109 </div>110 </div>111 </div>112 </div>113 </div>114 </div>115 </div>116 </div>117 {$footer}118 119 <style>120{literal}121 div.action { position: absolute; width: 170px; padding: 0;font-size:11px }122 td {font-size:11px;}123{/literal}124</style>125<iframe id="framejump" style="display:none;position:absolute;" scrolling="no" frameborder="0"></iframe>126<div id="menujump" class=action style="display:none;position:absolute;">127 <table width=100% cellpadding=5 cellspacing=0 border=0 style="background-color:#F4F7FB;border: solid 1px blue;">128 <tr><td id=row0 style="cursor:pointer;padding:5px;">Tables</td></tr>129 <tr><td id=row1 style="cursor:pointer;padding:5px;">Table Relations</td></tr>130 <tr><td id=row2 style="cursor:pointer;padding:5px;">Group By</td></tr>131 <tr><td id=row3 style="cursor:pointer;padding:5px;">Type</td></tr>132 <tr><td id=row4 style="cursor:pointer;padding:5px;">Parameters</td></tr>133 <tr><td id=row5 style="cursor:pointer;padding:5px;">Appearance</td></tr>134 <tr><td id=row6 style="cursor:pointer;padding:5px;">Chart Settings</td></tr>135 <tr><td id=row7 style="cursor:pointer;padding:5px;">Dynamic Permissions</td></tr>136 <tr><td id=row8 style="cursor:pointer;padding:5px;border-top:1px solid blue;">Back to Web Reports menu</td></tr>137 <tr><td id=row9 style="cursor:pointer;padding:5px;">Back to main application</td></tr>138 </table>139</div>140 <iframe id="aframe" style="display:none;position:absolute;" scrolling="no" frameborder="0"></iframe> 141 <div id="alert">142 </div>143 </body>144</html>