projekt kivitendo

<div class="wrapper ">

    <div class="input-panel control-panel">

    <table class="tbl-plain wi-moderate">

      <tbody>

          <td>[% LxERP.t8("Variable Name") %]</td>

          <td>[% LxERP.t8("Type") %]</td>

          <td>[% LxERP.t8("Value") %]</td>

          <td>[% LxERP.t8("Description") %]</td>

</div>

    <colgroup>

      <col class="wi-normal">

      <col>

    </colgroup>

        <td>[% IF query.description %][% query.description %][% END %]</td>

[% USE HTML %][% USE L %][% USE LxERP %]

<h1>[% FORM.title %] — [% LxERP.t8("Step #1/#2", 1, 2) %] — [% LxERP.t8("Basic Data") %]</h1>

<div class="wrapper">

  [%- INCLUDE 'common/flash.html' %]

  <form method="post" action="controller.pl" id="form">

    [% L.hidden_tag("id", SELF.query.id) %]

    <div class="input-panel control-panel">

      <table class="tbl-horizontal wi-moderate">

        <tr>

          <th align="right">[%- LxERP.t8("Name") %]</th>

          <td>[% L.input_tag("query.name", SELF.query.name, style="width: 800px", "data-validate"="required") %]</td>

        </tr>

        <tr>

          <th align="right">[%- LxERP.t8("Required access right") %]</th>

          <td>[% L.select_tag("query.access_right", SELF.access_rights, default=SELF.query.access_right, style="width: 800px") %]</td>

        </tr>

        <tr>

          <th valign="top" align="right">[%- LxERP.t8("Description") %]</th>

          <td valign="top">[% L.textarea_tag("query.description", SELF.query.description, rows=5, style="width: 800px") %]</td>

        </tr>

        <tr>

          <th valign="top" align="right">[%- LxERP.t8("SQL query") %]</th>

          <td valign="top">[% L.textarea_tag("query.sql_query", SELF.query.sql_query, rows=20, style="width: 800px", "data-validate"="required") %]</td>

        </tr>

      </table>

    </div>

  </form>

  <p>

  [% LxERP.t8("The SQL query can be parameterized with variables named as follows: <%name%>.") %]

  [% LxERP.t8("On the next page the type of all variables can be set.") %]

  [% LxERP.t8("Note that parameter names must not be quoted.") %]

  [% LxERP.t8("Example") %]:

  </p>

  <pre>

SELECT extract(YEAR FROM oe.transdate) AS "Jahr", SUM(oe.amount) AS "Angebotssumme"

FROM oe

LEFT JOIN employee ON (oe.employee_id = employee.id)

WHERE (oe.customer_id IS NOT NULL)

  AND COALESCE(oe.quotation, FALSE)

  AND (employee.login = <%Benutzer-Login%>)

GROUP BY "Jahr"

ORDER BY "Jahr"

  </pre>

</div>

[% USE HTML %][% USE L %][% USE LxERP %]

<h1>[% FORM.title %] — [% LxERP.t8("Step #1/#2", 2, 2) %] — [% LxERP.t8("Query parameters") %]</h1>

<div class="wrapper">

  [%- INCLUDE 'common/flash.html' %]

  <form method="post" action="controller.pl" id="form">

    [% L.hidden_tag("id", SELF.query.id) %]

    [% L.hidden_tag("query.name", SELF.query.name) %]

    [% L.hidden_tag("query.access_right", SELF.query.access_right) %]

    [% L.hidden_tag("query.description", SELF.query.description) %]

    [% L.hidden_tag("query.sql_query", SELF.query.sql_query) %]

    [% IF !PARAMETERS.size %]

    <p>

    [% LxERP.t8("The SQL query does not contain any parameter that need to be configured.") %]

    </p>

    [% ELSE %]

    <div class="input-panel control-panel">

      <table class="tbl-plain condensed"> 

        <tbody>

          <tr>

            <td>[% LxERP.t8("Variable Name") %]</td>

            <td>[% LxERP.t8("Type") %]</td>

            <td>[% LxERP.t8("Description") %]</td>

            <td colspan="2">[% LxERP.t8("Default value") %]</td>

          </tr>

          [% FOREACH parameter = PARAMETERS %]

          <tr>

            <td>

              [% L.hidden_tag("parameters[+].name", parameter.name) %]

              [% HTML.escape(parameter.name) %]

            </td>

            <td>

              [% L.select_tag("parameters[].parameter_type", [ [ "text", LxERP.t8("Text") ], [ "number", LxERP.t8("Number") ], [ "date", LxERP.t8("Date") ] ], default=parameter.parameter_type) %]

            </td>

            <td>[% L.input_tag("parameters[].description", parameter.description, class="wi-verywide") %]</td>

            <td>

              [% L.select_tag("parameters[].default_value_type",

              [ [ "none", LxERP.t8("No default value") ], [ "current_user_login", LxERP.t8("Current user's login") ], [ "sql_query", LxERP.t8("Result of SQL query") ],

              [ "fixed_value", LxERP.t8("Fixed value") ] ],

              default=parameter.default_value_type,

              id="default_value_type_" _ loop.count) %]

            </td>

            <td>

              [% SET disabled = (parameter.default_value_type == "none") || (parameter.default_value_type == "current_user_login") ? "disabled" : "" %]

              [% L.textarea_tag("parameters[].default_value", parameter.default_value, id="default_value_" _ loop.count, cols=80, rows=3, disabled=disabled) %]

            </td>

          </tr>

          [% END %]

        </tbody>

        [% END %]

      </table>

    </div>

  </form>

</div>

[% USE HTML %][% USE L %][% USE LxERP %]

<h1>[% FORM.title %]</h1>

<div class="wrapper">

  [%- INCLUDE 'common/flash.html' %]

  [% IF !SELF.queries.size %]

  <p>

  [%- LxERP.t8("No custom data exports have been created yet.") %]

  </p>

  [%- ELSE %]

  <table class="tbl-list moderate">

    <colgroup>

      <col class="wi-wide">

      <col>

    </colgroup>

    <thead>

      <tr class="listheading">

        <th>[% LxERP.t8("Name") %]</th>

        <th>[% LxERP.t8("Description") %]</th>

      </tr>

    </thead>

    <tbody>

      [%- FOREACH query = SELF.queries %]

      <tr class="listrow">

        <td>[% L.link(SELF.url_for(action="edit", id=query.id), query.name) %]</td>

        <td>[% IF query.description %][% query.description %][% END %]</td>

      </tr>

      [%- END %]

    </tbody>

  </table>

  [%- END %]

</div>