Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 4c0ec910

Von Werner Hahn vor fast 2 Jahren hinzugefügt

  • ID 4c0ec910151d62bf85f3a0eecf831ebac16811c1
  • Vorgänger d5349045
  • Nachfolger 4c46e52d

Design 4.0: Customer_Vendor_Turnover Dateien kopiert

Unterschiede anzeigen:

templates/design40_webpages/customer_vendor_turnover/_list_open_items.html
1
[%- USE T8 %]
2
[%- USE LxERP %]
3
[%- USE L %]
4
[%- USE HTML %]
5

  
6
<div id="sales_report">
7
  <table width="100%">
8
    <caption class="listtop">[%- HTML.escape(title) %]</caption>
9
    <tbody>
10
      <tr>
11
        <td class="listheading">[% 'Type' | $T8 %]</td>
12
        <td class="listheading">[% 'Invoice Number' | $T8 %]</td>
13
        <td class="listheading">[% 'Invoice Date' | $T8 %]</td>
14
        <td class="listheading">[% 'Amount' | $T8 %]</td>
15
        <td class="listheading">[% 'Inv. Duedate' | $T8 %]</td>
16
        <td class="listheading">[% 'Paid' | $T8 %]</td>
17
        <td class="listheading">[% 'Open Amount' | $T8 %]</td>
18
        [% IF FORM.db == 'customer' %]
19
          <td class="listheading">[% 'Dunnings (Id -- Dunning Date --Dunning Level -- Dunning Fee)' | $T8 %]</td>
20
        [% END %]
21
      </tr>
22

  
23
      [%- FOREACH row = OPEN_ITEMS %]
24
        [% IF FORM.db == 'customer' %]
25
          [% IF row.type == 'invoice' %]
26
            [% SET type = 'Invoice (one letter abbreviation)' %]
27
            [% SET link = 'is.pl' %]
28
          [% ELSIF row.type == 'credit_note' %]
29
            [% SET type = 'Credit note (one letter abbreviation)' %]
30
            [% SET link = 'is.pl' %]
31
          [% ELSE %]
32
            [% SET type = 'AR Transaction (abbreviation)' %]
33
            [% SET link = 'ar.pl' %]
34
          [% END %]
35
        [% ELSE %]
36
          [% IF row.invoice %]
37
            [% SET type = 'Invoice (one letter abbreviation)' %]
38
            [% SET link = 'ir.pl' %]
39
          [% ELSE %]
40
            [% SET type = 'AP Transaction (abbreviation)' %]
41
            [% SET link = 'ap.pl' %]
42
          [% END %]
43
        [% END %]
44
        <tr class="listrow[% loop.count % 2 %]">
45
          <td>[% type | $T8 %]</td>
46
          <td><a href="[% link %]?action=edit&id=[% row.id %]">[% row.invnumber | html %]</a></td>
47
          <td>[% row.transdate.to_kivitendo | html %]</td>
48
          <td class="numeric">[%- LxERP.format_amount(row.amount, 2) %]</td>
49
          <td>[% row.duedate.to_kivitendo | html %]</td>
50
          <td class="numeric">[%- LxERP.format_amount(row.paid, 2) %]</td>
51
          <td class="numeric">[%- LxERP.format_amount(row.amount - row.paid,2) %]
52
          [% IF FORM.db == 'customer' %]
53
            <td>
54
            [%- IF row.dunning_config_id != '' %]
55
              [%- FOREACH dun = row.dunnings %]
56
              [% dun.dunning_id | html %] -- [% dun.transdate.to_kivitendo | html %] -- [% dun.dunning_level | html %] -- [%- LxERP.format_amount(dun.fee, 2) %]<br>
57
              [% END %]
58
            [% END %]
59
            </td>
60
          [% END %]
61
        </tr>
62
      [% END %]
63
    </tbody>
64
  </table>
65
</div>
templates/design40_webpages/customer_vendor_turnover/_list_open_orders.html
1
[%- USE T8 %]
2
[%- USE LxERP %]
3
[%- USE L %]
4
[%- USE HTML %]
5

  
6
<div id="orders_report">
7
  <table width="100%">
8
    <caption class="listtop">[%- HTML.escape(title) %]</caption>
9
    <tbody>
10
      <tr>
11
        <td class="listheading">[% 'Type' | $T8 %]</td>
12
        <td class="listheading">[% 'Order/RFQ Number' | $T8 %]</td>
13
        <td class="listheading">[% 'Date' | $T8 %]</td>
14
        <td class="listheading">[% 'Amount' | $T8 %]</td>
15
        <td class="listheading">[% 'Salesman' | $T8 %]</td>
16
        <td class="listheading">[% 'Transaction description' | $T8 %]</td>
17
      </tr>
18

  
19
      [%- FOREACH row = orders %]
20
      <tr class="listrow[% loop.count % 2 %]">
21
        <td>[% IF row.quotation %]
22
          [% IF FORM.db == 'customer' %][% 'Sales quotation' | $T8 %][% ELSE %][% 'RFQ' | $T8 %][% END %]</td>
23
              [%- IF INSTANCE_CONF.get_feature_experimental_order -%]
24
                <td>[% IF row.id %]<a href='controller.pl?action=Order/edit&type=[% IF FORM.db == "customer" %]sales_quotation[% ELSE %]request_quotation[% END %]&id=[% HTML.escape(row.id) %]'>
25
                    [% END %][% HTML.escape(row.quonumber)   || '&nbsp;' %][% IF row.id %]</a>[% END %]</td>
26
              [%- ELSE -%]
27
                <td>[% IF row.id %]<a href='oe.pl?action=edit&type=[% IF FORM.db == "customer" %]sales_quotation[% ELSE %]request_quotation[% END %]&vc=[% FORM.db %]&id=[% HTML.escape(row.oe_id) %]'>
28
                    [% END %][% HTML.escape(row.quonumber)   || '&nbsp;' %][% IF row.id %]</a>[% END %]</td>
29
              [%- END -%]
30
            [% ELSE %]
31
            [% IF FORM.db == 'customer' %][% 'Sales Order' | $T8 %][% ELSE %][% 'Purchase Order' | $T8 %][% END %]</td>
32
              [%- IF INSTANCE_CONF.get_feature_experimental_order -%]
33
                <td>[% IF row.id %]<a href='controller.pl?action=Order/edit&type=[% IF FORM.db == "customer" %]sales_order[% ELSE %]purchase_order[% END %]&id=[% HTML.escape(row.id) %]'>
34
                    [% END %][% HTML.escape(row.ordnumber)   || '&nbsp;' %][% IF row.id %]</a>[% END %]</td>
35
              [%- ELSE -%]
36
                <td>[% IF row.id %]<a href='oe.pl?action=edit&type=[% IF FORM.db == "customer" %]sales_order[% ELSE %]purchase_order[% END %]&vc=[% FORM.db %]&id=[% HTML.escape(row.oe_id) %]'>
37
                    [% END %][% HTML.escape(row.ordnumber)   || '&nbsp;' %][% IF row.id %]</a>[% END %]</td>
38
              [%- END -%]
39
            [% END %]
40
        <td>[% row.transdate.to_kivitendo | html %]</td>
41
        <td class="numeric">[%- LxERP.format_amount(row.amount, 2) %]</td>
42
        <td>[% row.employee.name | html %]</td>
43
        <td>[% row.transaction_description | html %]</td>
44
      </tr>
45
      [% END %]
46
    </tbody>
47
  </table>
48
</div>
templates/design40_webpages/customer_vendor_turnover/_statistic_tabs.html
1
[%- USE T8 %]
2
[%- USE LxERP %]
3
[%- USE L %]
4
[%- USE HTML %]
5
<script type="text/javascript">
6
  $(function() {
7
    $ ( "#statistic_tabs" ).tabs();
8
  });
9
</script>
10
<div class="tabwidget" id="statistic_tabs">
11
  <ul>
12
    [% IF FORM.db == "customer" %]<li><a href="#dun_stat">[% 'Dunningstatistic' | $T8 %]</a></li>[% END %]
13
    <li><a href="#quotations">[% IF FORM.db == "customer" %][% 'Sales Quotations' | $T8 %][% ELSE %][% 'Request Quotations' | $T8 %][% END %]</a></li>
14
    <li><a href="#orders" onclick="kivi.CustomerVendorTurnover.get_orders();">[% 'Orders' | $T8 %]</a></li>
15
    <li><a href="#invoices" onclick="kivi.CustomerVendorTurnover.get_invoices();">[% 'Invoices' | $T8 %]</a></li>
16
    <li><a href="#mails" onclick="kivi.CustomerVendorTurnover.get_mails();">[% 'Mails' | $T8 %]</a></li>
17
    <li><a href="#letters" onclick="kivi.CustomerVendorTurnover.get_letters();">[% 'Letters' | $T8 %]</a></li>
18
  </ul>
19
  <div id="dun_stat">[% PROCESS "customer_vendor_turnover/dun_statistic.html" %]</div>
20
  <div id="quotations"></div>
21
  <div id="orders"></div>
22
  <div id="invoices"></div>
23
  <div id="mails"></div>
24
  <div id="letters"></div>
25
</div>
templates/design40_webpages/customer_vendor_turnover/count_open_items_by_year.html
1
[%- USE T8 %]
2
[%- USE LxERP %]
3
[%- USE L %]
4
[%- USE HTML %]
5
<div id="dun_statistic">
6
  <table width="100%">
7
    <tbody>
8
      <tr>
9
        <td class="listheading">[% 'Month/Year' | $T8 %]</td>
10
        <td class="listheading">[% 'Dunnings' | $T8 %]</td>
11
        <td class="listheading">[% 'Highest Dunninglevel' | $T8 %]</td>
12
      </tr>
13

  
14
      [%- FOREACH row = SELF.dun_statistic %]
15
      <tr class="listrow[% loop.count % 2 %]">
16
        <td>[% row.date_part | html %]</td>
17
        <td>[% row.count | html %]</td>
18
        <td>[% row.max | html %]</td>
19
      </tr>
20
      [% END %]
21
    </tbody>
22
  </table>
23
</div>
templates/design40_webpages/customer_vendor_turnover/count_turnover.html
1
[%- USE T8 %]
2
[%- USE LxERP %]
3
[%- USE L %]
4
[%- USE HTML %]
5
<div id="turnover_statistic">
6
  <table width="100%">
7
    <tbody>
8
      <tr>
9
        <td class="listheading">[% 'Month/Year' | $T8 %]</td>
10
        <td class="listheading">[% 'Invoices' | $T8 %]</td>
11
        <td class="listheading">[% 'Turnover' | $T8 %]</td>
12
        <td class="listheading">[% 'Net.Turnover' | $T8 %]</td>
13
        <td class="listheading">[% 'Paid' | $T8 %]</td>
14
      </tr>
15
      [%- FOREACH row = SELF.turnover_statistic %]
16
      <tr class="listrow[% loop.count % 2 %]">
17
        <td>[% row.date_part | html %]</td>
18
        <td>[% row.count | html %]</td>
19
        <td class="numeric">[%- LxERP.format_amount(row.amount,2) %]</td>
20
        <td class="numeric">[%- LxERP.format_amount(row.netamount,2) %]</td>
21
        <td class="numeric">[%- LxERP.format_amount(row.paid,2) %]</td>
22
      </tr>
23
      [% END %]
24

  
25
    </tbody>
26
  </table>
27
</div>
templates/design40_webpages/customer_vendor_turnover/dun_statistic.html
1
[%- USE T8 %]
2
[%- USE LxERP %]
3
[%- USE L %]
4
[%- USE HTML %]
5

  
6
<p>
7
[% L.radio_button_tag('period', value='year', label= LxERP.t8('Year'), onclick='kivi.CustomerVendorTurnover.show_dun_stat("y");') %]
8

  
9
[% L.radio_button_tag('period', value='month', label= LxERP.t8('Month'), onclick='kivi.CustomerVendorTurnover.show_dun_stat("m");') %]
10
</p>
11
<div id="duns"></div>
templates/design40_webpages/customer_vendor_turnover/email_statistic.html
1
[%- USE T8 %]
2
[%- USE LxERP %]
3
[%- USE L %]
4
[%- USE HTML %]
5
[%- USE Dumper %]
6

  
7
<div id="invoice_statistic">
8
  <table width="100%">
9
    <tbody>
10
      <tr>
11
        <td class="listheading">[% 'Sent on' | $T8 %]</td>
12
        <td class="listheading">[% 'Subject' | $T8 %]</td>
13
        <td class="listheading">[% 'Record Type' | $T8 %]</td>
14
        <td class="listheading">[% 'Record number' | $T8 %]</td>
15
        <td class="listheading">[% 'From' | $T8 %]</td>
16
        <td class="listheading">[% 'To' | $T8 %]</td>
17
        <td class="listheading">[% 'Status' | $T8 %]</td>
18
      </tr>
19

  
20
      [%- FOREACH row = emails %]
21
      <tr class="listrow[% loop.count % 2 %]">
22
        <td>[% row.sent_on | html %]</td>
23
        <td>
24
          <a href="[% SELF.url_for(controller='controller.pl', action => 'EmailJournal/show', id => row.id, back_to => SELF.get_callback) %]">
25
           [%- HTML.escape(row.subject) %]
26
          </a></td>
27
        <td>[% row.type | $T8 %]</td>
28
        <td>[% row.recordnumber | html %]</td>
29
        <td>[% row.from %]</td>
30
        <td>[% row.recipients %]</td>
31
        <td>[% row.status %]</td>
32
      </tr>
33
      [% END %]
34
    </tbody>
35
  </table>
36

  
37

  
38
    </tbody>
39
  </table>
40
</div>
templates/design40_webpages/customer_vendor_turnover/invoices_statistic.html
1
[%- USE T8 %]
2
[%- USE LxERP %]
3
[%- USE L %]
4
[%- USE HTML %]
5
<div id="invoice_statistic">
6
  <table width="100%">
7
    <tbody>
8
      <tr>
9
        <td class="listheading">[% 'Type' | $T8 %]</td>
10
        <td class="listheading">[% 'Invoice Number' | $T8 %]</td>
11
        <td class="listheading">[% 'Invoice Date' | $T8 %]</td>
12
        <td class="listheading">[% 'Amount' | $T8 %]</td>
13
        <td class="listheading">[% 'Inv. Duedate' | $T8 %]</td>
14
        <td class="listheading">[% 'Paid' | $T8 %]</td>
15
        <td class="listheading">[% 'Open Amount' | $T8 %]</td>
16
      </tr>
17

  
18
      [%- FOREACH row = invoices %]
19
        [% IF FORM.db == 'customer' %]
20
          [% IF row.type == 'invoice' %]
21
            [% SET type = 'Invoice (one letter abbreviation)' %]
22
            [% SET link = 'is.pl' %]
23
          [% ELSIF row.type == 'credit_note' %]
24
            [% SET type = 'Credit note (one letter abbreviation)' %]
25
            [% SET link = 'is.pl' %]
26
          [% ELSE %]
27
            [% SET type = 'AR Transaction (abbreviation)' %]
28
            [% SET link = 'ar.pl' %]
29
          [% END %]
30
        [% ELSE %]
31
          [% IF row.invoice %]
32
            [% SET type = 'Invoice (one letter abbreviation)' %]
33
            [% SET link = 'ir.pl' %]
34
          [% ELSE %]
35
            [% SET type = 'AP Transaction (abbreviation)' %]
36
            [% SET link = 'ap.pl' %]
37
          [% END %]
38
        [% END %]
39
        <tr class="listrow[% loop.count % 2 %]">
40
          <td>[% type | $T8 %]</td>
41
          <td><a href="[% link %]?action=edit&id=[% row.id %]">[% row.invnumber | html %]</a></td>
42
          <td>[% row.transdate.to_kivitendo | html %]</td>
43
          <td class="numeric">[%- LxERP.format_amount(row.amount, 2) %]</td>
44
          <td>[% row.duedate.to_kivitendo | html %]</td>
45
          <td class="numeric">[%- LxERP.format_amount(row.paid, 2) %]</td>
46
          <td class="numeric">[%- LxERP.format_amount(row.amount - row.paid, 2) %]
47
        </tr>
48
      [% END %]
49
    </tbody>
50
  </table>
51

  
52

  
53
    </tbody>
54
  </table>
55
</div>
templates/design40_webpages/customer_vendor_turnover/letter_statistic.html
1
[%- USE T8 %]
2
[%- USE LxERP %]
3
[%- USE L %]
4
[%- USE HTML %]
5
[%- USE Dumper %]
6

  
7
<div id="invoice_statistic">
8
  <table width="100%">
9
    <tbody>
10
      <tr>
11
        <td class="listheading">[% 'Date' | $T8 %]</td>
12
        <td class="listheading">[% 'Subject' | $T8 %]</td>
13
        <td class="listheading">[% 'Letternumber' | $T8 %]</td>
14
        <td class="listheading">[% 'Contact' | $T8 %]</td>
15
        <td class="listheading">[% 'Author' | $T8 %]</td>
16
      </tr>
17

  
18
      [%- FOREACH row = letters %]
19
      [% IF row.customer_id %]
20
        [% SET is_sales = 1 %]
21
      [% ELSE %]
22
        [% SET is_sales = 0 %]
23
      [% END %]
24
      <tr class="listrow[% loop.count % 2 %]">
25
        <td>[% row.date.to_kivitendo | html %]</td>
26
        <td>
27
          <a href="[% SELF.url_for(controller='controller.pl', action => 'Letter/edit', 'letter.id' => row.id, is_sales=is_sales, back_to => SELF.get_callback) %]">
28
           [%- HTML.escape(row.subject) %]
29
          </a>
30
        </td>
31
        <td>
32
          <a href="[% SELF.url_for(controller='controller.pl', action => 'Letter/edit', 'letter.id' => row.id, is_sales=is_sales, back_to => SELF.get_callback) %]">
33
          [% row.letternumber | html %]
34
          </a>
35
        </td>
36
        <td>[% row.contact.cp_givenname %] [% row.contact.cp_name %]</td>
37
        <td>[% row.employee.name %]</td>
38
      </tr>
39
      [% END %]
40
    </tbody>
41
  </table>
42

  
43

  
44
    </tbody>
45
  </table>
46
</div>
templates/design40_webpages/customer_vendor_turnover/order_statistic.html
1
[%- USE T8 %]
2
[%- USE LxERP %]
3
[%- USE L %]
4
[%- USE HTML %]
5
<div id="invoice_statistic">
6
  <table width="100%">
7
    <tbody>
8
      <tr>
9
        <td class="listheading">[% 'Order Number' | $T8 %]</td>
10
        <td class="listheading">[% 'Order Date' | $T8 %]</td>
11
        <td class="listheading">[% 'Amount' | $T8 %]</td>
12
        <td class="listheading">[% 'Delivery Date' | $T8 %]</td>
13
        <td class="listheading">[% 'Transaction description' | $T8 %]</td>
14
      </tr>
15

  
16
      [%- FOREACH row = orders %]
17
      <tr class="listrow[% loop.count % 2 %]">
18
        [%- IF INSTANCE_CONF.get_feature_experimental_order -%]
19
          <td>[% IF row.id %]<a href='controller.pl?action=Order/edit&type=[% IF FORM.db == "customer" %]sales_order[% ELSE %]purchase_order[% END %]&id=[% HTML.escape(row.id) %]'>[% END %][% HTML.escape(row.ordnumber)   || '&nbsp;' %][% IF row.id %]</a>[% END %]</td>
20
        [%- ELSE -%]
21
          <td>[% IF row.id %]<a href='oe.pl?action=edit&type=[% IF FORM.db == "customer" %]sales_order[% ELSE %]purchase_order[% END %]&vc=[% FORM.db %]&id=[% HTML.escape(row.id) %]'>[% END %][% HTML.escape(row.ordnumber)   || '&nbsp;' %][% IF row.id %]</a>[% END %]</td>
22
        [%- END -%]
23
        <td>[% row.transdate.to_kivitendo | html %]</td>
24
        <td class="numeric">[%- LxERP.format_amount(row.amount, 2) %]</td>
25
        <td>[% row.reqdate.to_kivitendo | html %]</td>
26
        <td>[% row.transaction_description %]</td>
27
      </tr>
28
      [% END %]
29
    </tbody>
30
  </table>
31

  
32

  
33
    </tbody>
34
  </table>
35
</div>
templates/design40_webpages/customer_vendor_turnover/quotation_statistic.html
1
[%- USE T8 %]
2
[%- USE LxERP %]
3
[%- USE L %]
4
[%- USE HTML %]
5
<div id="invoice_statistic">
6
  <table width="100%">
7
    <tbody>
8
      <tr>
9
        <td class="listheading">[% IF FORM.db == 'customer' %][% 'Quotation Number' | $T8 %][% ELSE %][% 'RFQ Number' | $T8 %][% END %]</td>
10
        <td class="listheading">[% IF FORM.db == 'customer' %][% 'Quotation Date' | $T8 %][% ELSE %][% 'RFQ Date' | $T8 %][% END %]</td>
11
        <td class="listheading">[% 'Amount' | $T8 %]</td>
12
        <td class="listheading">[% 'Delivery Date' | $T8 %]</td>
13
        <td class="listheading">[% 'Transaction description' | $T8 %]</td>
14
      </tr>
15

  
16
      [%- FOREACH row = orders %]
17
      <tr class="listrow[% loop.count % 2 %]">
18
        [%- IF INSTANCE_CONF.get_feature_experimental_order -%]
19
          <td>[% IF row.id %]<a href='controller.pl?action=Order/edit&type=[% IF FORM.db == "customer" %]sales_quotation[% ELSE %]request_quotation[% END %]&id=[% HTML.escape(row.id) %]'>
20
              [% END %][% HTML.escape(row.quonumber)   || '&nbsp;' %][% IF row.id %]</a>[% END %]</td>
21
        [%- ELSE -%]
22
          <td>[% IF row.id %]<a href='oe.pl?action=edit&type=[% IF FORM.db == "customer" %]sales_quotation[% ELSE %]request_quotation[% END %]&vc=[% FORM.db %]&id=[% HTML.escape(row.id) %]'>
23
              [% END %][% HTML.escape(row.quonumber)   || '&nbsp;' %][% IF row.id %]</a>[% END %]</td>
24
        [%- END -%]
25
        <td>[% row.transdate.to_kivitendo | html %]</td>
26
        <td class="numeric">[%- LxERP.format_amount(row.amount, 2) %]</td>
27
        <td>[% row.reqdate.to_kivitendo | html %]</td>
28
        <td>[% row.transaction_description %]</td>
29
      </tr>
30
      [% END %]
31
    </tbody>
32
  </table>
33

  
34

  
35
    </tbody>
36
  </table>
37
</div>
templates/design40_webpages/customer_vendor_turnover/turnover.html
1
[%- USE T8 %]
2
[%- USE LxERP %]
3
[%- USE L %]
4
[%- USE HTML %]
5
[%- USE JavaScript -%]
6

  
7
[%- IF open_items %]
8
[% open_items %]
9
[% END %]
10

  
11
[%- IF open_orders %]
12
[% open_orders %]
13
[% END %]
14

  
15
[% PROCESS "customer_vendor_turnover/_statistic_tabs.html" %]
templates/design40_webpages/customer_vendor_turnover/turnover_statistic.html
1
[%- USE T8 %]
2
[%- USE LxERP %]
3
[%- USE L %]
4
[%- USE HTML %]
5
<div class="chart-container" id="turnovers_chart_container" style="position: relative;">
6
  [%- LxERP.t8("Loading...") %]
7
</div>
8
<div id="turnovers"></div>

Auch abrufbar als: Unified diff