kenken999/php
0
1<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">2<html lang="en">3 <head>4 <title>Chart: Tables Relations</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 <style type="text/css">9 .list_selectable { width: 100%; overflow: hidden; }10 .rel-container { padding: 0 10px; width: 98%; }11 #sql_query { display:none; }12 .sql-container { width: 80%; }13 #cur_table { border: 1px solid #ccc; padding: 2px; overflow: hidden; border-bottom-style: none; }14 #rel_list { min-width: 500px; width: 100%; }15 </style>16 {$h_includes}17 </head>18 <body class="{$wr_pagestylepath}">19 {$b_includes}20 {$header}21 <div class="rnr-page">22 <div class="rnr-top">23 <div class="rnr-s-1 {$wr_pagestylepath}">24 <div class="rnr-c rnr-cv">25 <div class="style2" align=center>26 Chart: Tables Relations{$chart_title}{$chart_table}27 </div>28 <div class="style1 rnr-b-wrapper">29 <div class="rnr-s-fields {$wr_pagestylepath}">30 <div class="rnr-c rnr-cv">31 <div class="style1">32 <table class="fieldGrid">33 <tr class="reportchart-editfields">34 <td colspan=4>35 </td>36 </tr>37 <tr class="reportchart-editfields">38 <td>39 Left Table40 </td>41 <td>42 <select id="left_tables" class="table_fields" name="left_tables" style="width:150px">43 <option selected value="-1">Select table</option>44 <option value="{$table_selected}">{$table_selected}</option>45 <!--46 {$tables}47 -->48 </select>49 </td>50 <td>51 Right Table52 </td>53 <td>54 <select id="right_tables" class="table_fields" name="right_tables" style="width:150px">55 <option selected value="-1">Select table</option>56 {$tables}57 </select>58 </td>59 </tr>60 <tr class="reportchart-editfields">61 <td>62 Left Field63 </td>64 <td>65 <select id="left_fields_1" class="fld_names" name="left_fields_1" style="width:150px">66 <!-- autocomplete -->67 </select>68 </td>69 <td>70 Right Field71 </td>72 <td>73 <select id="right_fields_1" class="fld_names" name="right_fields_1" style="width:150px">74 <!-- autocomplete -->75 </select>76 </td>77 </tr>78 <tr class="reportchart-editfields">79 <td>80 Join Type81 </td>82 <td>83 <select id="join_select" name="join_select" style="width:150px">84 <option selected="" value="INNER JOIN ">Inner Join</option>85 <option value="LEFT OUTER JOIN ">Left Join</option>86 <option value="RIGHT OUTER JOIN ">Right Join</option>87 <option value="FULL OUTER JOIN ">Full Outer Join</option>88 </select>89 </td>90 <td>91 </td>92 <td>93 </td>94 </tr>95 <tr class="reportchart-editfields">96 <td colspan=4 align=center>97 <a id="addrel_btn" name="addrel_btn" class="rnr-button" href="#">Add Relation</a>98 </td>99 </tr>100 <tr class="reportchart-editfields">101 <td align="center" colspan=4>102 <div class="rel-container"> 103 <textarea id="cur_table" disabled="true" class="list_selectable" rows="3">104 SELECT {$fields_table_selected}105 FROM {$table_selected}106 </textarea>107 <br/>108 <select name="rel_list" id="rel_list" size="10" align="left"></select>109 </div>110 </td>111 </tr>112 <tr class="reportchart-editfields">113 <td colspan=4 align=center>114 <a id="remrel_btn" name="remrel_btn" class="rnr-button" href="#">Remove Relation</a>115 </td>116 </tr>117 </table>118 </div>119 <div id="btns" class="style2" align=center>120 <a id="backbtn" name="backbtn" class="rnr-button" href="#">Back</a>121 <span style="position:absolute;" id="jumptospan"></span>122 <a id="jumpto" name="jumpto" class="rnr-button" href="#" onclick="event.cancelBubble = true;return false;" onmouseover="event.cancelBubble = true;return false;">Jump to ...</a>123 <a id="sqlbtn" name="sqlbtn" class="rnr-button" href="#">SQL Query</a>124 <a id="sql_query" class="various fancybox.iframe" href="web_query.php?type=webcharts&name=table_relations&ie=UTF-8&iframe"></a>125 <a id="nextbtn" name="nextbtn" class="rnr-button" href="#">Next</a>126 {BEGIN b_is_chart_save}127 <a id="saveasbtn" name="saveasbtn" class="rnr-button" href="#">Save as...</a>128 {END b_is_chart_save} 129 {BEGIN b_is_chart_name}130 <a id="savebtn" name="savebtn" class="rnr-button" href="#">Save</a>131 {END b_is_chart_name} 132 <a id="previewbtn" name="previewbtn" class="rnr-button" href="#">Preview</a>133 <a id="preview" class="various fancybox.iframe" href="dchart_preview.php?cname={$chart_name_preview}&ie=UTF-8&iframe"></a>134 </div>135 </div>136 </div>137 </div>138 </div>139 </div>140 </div>141 </div>142 {$footer}143 144 <style>145{literal}146 div.action { position: absolute; width: 170px; padding: 0;font-size:11px }147 td {font-size:11px;}148{/literal}149</style>150<iframe id="framejump" style="display:none;position:absolute;" scrolling="no" frameborder="0"></iframe>151<div id="menujump" class=action style="display:none;position:absolute;">152 <table width=100% cellpadding=5 cellspacing=0 border=0 style="background-color:#F4F7FB;border: solid 1px blue;">153 <tr><td id=row0 style="cursor:pointer;padding:5px;">Tables</td></tr>154 <tr><td id=row1 style="cursor:pointer;padding:5px;">Table Relations</td></tr>155 <tr><td id=row2 style="cursor:pointer;padding:5px;">Group By</td></tr>156 <tr><td id=row3 style="cursor:pointer;padding:5px;">Type</td></tr>157 <tr><td id=row4 style="cursor:pointer;padding:5px;">Parameters</td></tr>158 <tr><td id=row5 style="cursor:pointer;padding:5px;">Appearance</td></tr>159 <tr><td id=row6 style="cursor:pointer;padding:5px;">Chart Settings</td></tr>160 <tr><td id=row7 style="cursor:pointer;padding:5px;">Dynamic Permissions</td></tr>161 <tr><td id=row8 style="cursor:pointer;padding:5px;border-top:1px solid blue;">Back to Web Reports menu</td></tr>162 <tr><td id=row9 style="cursor:pointer;padding:5px;">Back to main application</td></tr>163 </table>164</div>165 166 <iframe id="aframe" style="display:none;position:absolute;" scrolling="no" frameborder="0"></iframe>167 <div id="alert">168 </div>169 </body>170</html>