having_query_panel.twig 5.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138
  1. <table id="query_having" class="hide" width="5%" cellpadding="0" cellspacing="0">
  2. <tbody>
  3. <tr>
  4. <td class="frams1" width="10px">
  5. </td>
  6. <td class="frams5" width="99%" >
  7. </td>
  8. <td class="frams2" width="10px">
  9. <div class="bor">
  10. </div>
  11. </td>
  12. </tr>
  13. <tr>
  14. <td class="frams8">
  15. </td>
  16. <td class="input_tab">
  17. <table width="168" class="center" cellpadding="2" cellspacing="0">
  18. <thead>
  19. <tr>
  20. <td colspan="2" class="center nowrap">
  21. <strong>
  22. HAVING
  23. </strong>
  24. </td>
  25. </tr>
  26. </thead>
  27. <tbody id="rename_to">
  28. <tr>
  29. <td width="58" class="nowrap">
  30. {% trans 'Operator' %}
  31. </td>
  32. <td width="102">
  33. <select name="hoperator" id="hoperator">
  34. <option value="---" selected="selected">
  35. ---
  36. </option>
  37. <option value="None" >
  38. None
  39. </option>
  40. <option value="sum" >
  41. SUM
  42. </option>
  43. <option value="min">
  44. MIN
  45. </option>
  46. <option value="max">
  47. MAX
  48. </option>
  49. <option value="avg">
  50. AVG
  51. </option>
  52. <option value="count">
  53. COUNT
  54. </option>
  55. </select>
  56. </td>
  57. </tr>
  58. <tr>
  59. <tr>
  60. <td width="58" class="nowrap">
  61. {% trans 'Operator' %}
  62. </td>
  63. <td width="102">
  64. <select name="hrel_opt" id="hrel_opt">
  65. <option value="--" selected="selected">
  66. --
  67. </option>
  68. <option value="=">
  69. =
  70. </option>
  71. <option value="&gt;">
  72. &gt;
  73. </option>
  74. <option value="&lt;">
  75. &lt;
  76. </option>
  77. <option value="&gt;=">
  78. &gt;=
  79. </option>
  80. <option value="&lt;=">
  81. &lt;=
  82. </option>
  83. <option value="NOT">
  84. NOT
  85. </option>
  86. <option value="IN">
  87. IN
  88. </option>
  89. <option value="EXCEPT">
  90. {% trans 'Except' %}
  91. </option>
  92. <option value="NOT IN">
  93. NOT IN
  94. </option>
  95. </select>
  96. </td>
  97. </tr>
  98. <tr>
  99. <td class="nowrap">
  100. {% trans 'Value' %}
  101. <br />
  102. {% trans 'subquery' %}
  103. </td>
  104. <td>
  105. <textarea id="hQuery" cols="18">
  106. </textarea>
  107. </td>
  108. </tr>
  109. </tbody>
  110. <tbody>
  111. <tr>
  112. <td colspan="2" class="center nowrap">
  113. <input type="button" id="ok_edit_having" class="butt"
  114. name="Button" value="{% trans 'OK' %}" />
  115. <input id="query_having_button" type="button"
  116. class="butt"
  117. name="Button"
  118. value="{% trans 'Cancel' %}" />
  119. </td>
  120. </tr>
  121. </tbody>
  122. </table>
  123. </td>
  124. <td class="frams6">
  125. </td>
  126. </tr>
  127. <tr>
  128. <td class="frams4">
  129. <div class="bor">
  130. </div>
  131. </td>
  132. <td class="frams7">
  133. </td>
  134. <td class="frams3">
  135. </td>
  136. </tr>
  137. </tbody>
  138. </table>