summaryrefslogtreecommitdiff
path: root/IkiWiki/Plugin/table.pm
blob: e782fc238dbd40b628f8675fefa36942d9be520c (plain)
  1. package IkiWiki::Plugin::table;
  2. # by Victor Moral <victor@taquiones.net>
  3. use warnings;
  4. use strict;
  5. use Encode;
  6. use IkiWiki 2.00;
  7. sub import { #{{{
  8. hook(type => "getsetup", id => "table", call => \&getsetup);
  9. hook(type => "preprocess", id => "table", call => \&preprocess);
  10. } # }}}
  11. sub getsetup () { #{{{
  12. return
  13. plugin => {
  14. safe => 1,
  15. rebuild => undef,
  16. },
  17. } #}}}
  18. sub preprocess (@) { #{{{
  19. my %params =(
  20. format => 'auto',
  21. header => 'row',
  22. @_
  23. );
  24. if (exists $params{file}) {
  25. if (! $pagesources{$params{file}}) {
  26. error gettext("cannot find file");
  27. }
  28. $params{data} = readfile(srcfile($params{file}));
  29. add_depends($params{page}, $params{file});
  30. }
  31. if (lc $params{format} eq 'auto') {
  32. # first try the more simple format
  33. if (is_dsv_data($params{data})) {
  34. $params{format} = 'dsv';
  35. }
  36. else {
  37. $params{format} = 'csv';
  38. }
  39. }
  40. my @data;
  41. if (lc $params{format} eq 'csv') {
  42. @data=split_csv($params{data},
  43. defined $params{delimiter} ? $params{delimiter} : ",",);
  44. # linkify after parsing since html link quoting can
  45. # confuse CSV parsing
  46. if (! exists $params{file}) {
  47. @data=map {
  48. [ map {
  49. IkiWiki::linkify($params{page},
  50. $params{destpage}, $_);
  51. } @$_ ]
  52. } @data;
  53. }
  54. }
  55. elsif (lc $params{format} eq 'dsv') {
  56. # linkify before parsing since wikilinks can contain the
  57. # delimiter
  58. if (! exists $params{file}) {
  59. $params{data} = IkiWiki::linkify($params{page},
  60. $params{destpage}, $params{data});
  61. }
  62. @data=split_dsv($params{data},
  63. defined $params{delimiter} ? $params{delimiter} : "|",);
  64. }
  65. else {
  66. error gettext("unknown data format");
  67. }
  68. my $header;
  69. if (lc($params{header}) eq "row" || IkiWiki::yesno($params{header})) {
  70. $header=shift @data;
  71. }
  72. if (! @data) {
  73. error gettext("empty data");
  74. }
  75. my @lines;
  76. push @lines, defined $params{class}
  77. ? "<table class=\"".$params{class}.'">'
  78. : '<table>';
  79. push @lines, "\t<thead>",
  80. genrow(\%params, "th", @$header),
  81. "\t</thead>" if defined $header;
  82. push @lines, "\t<tbody>" if defined $header;
  83. push @lines, genrow(\%params, "td", @$_) foreach @data;
  84. push @lines, "\t</tbody>" if defined $header;
  85. push @lines, '</table>';
  86. my $html = join("\n", @lines);
  87. if (exists $params{file}) {
  88. return $html."\n\n".
  89. htmllink($params{page}, $params{destpage}, $params{file},
  90. linktext => gettext('Direct data download'));
  91. }
  92. else {
  93. return $html;
  94. }
  95. } #}}}
  96. sub is_dsv_data ($) { #{{{
  97. my $text = shift;
  98. my ($line) = split(/\n/, $text);
  99. return $line =~ m{.+\|};
  100. }
  101. sub split_csv ($$) { #{{{
  102. my @text_lines = split(/\n/, shift);
  103. my $delimiter = shift;
  104. eval q{use Text::CSV};
  105. error($@) if $@;
  106. my $csv = Text::CSV->new({
  107. sep_char => $delimiter,
  108. binary => 1,
  109. allow_loose_quotes => 1,
  110. }) || error("could not create a Text::CSV object");
  111. my $l=0;
  112. my @data;
  113. foreach my $line (@text_lines) {
  114. $l++;
  115. if ($csv->parse($line)) {
  116. push(@data, [ map { decode_utf8 $_ } $csv->fields() ]);
  117. }
  118. else {
  119. debug(sprintf(gettext('parse fail at line %d: %s'),
  120. $l, $csv->error_input()));
  121. }
  122. }
  123. return @data;
  124. } #}}}
  125. sub split_dsv ($$) { #{{{
  126. my @text_lines = split(/\n/, shift);
  127. my $delimiter = shift;
  128. $delimiter="|" unless defined $delimiter;
  129. my @data;
  130. foreach my $line (@text_lines) {
  131. push @data, [ split(/\Q$delimiter\E/, $line, -1) ];
  132. }
  133. return @data;
  134. } #}}}
  135. sub genrow ($@) { #{{{
  136. my %params=%{shift()};
  137. my $elt = shift;
  138. my @data = @_;
  139. my $page=$params{page};
  140. my $destpage=$params{destpage};
  141. my $type=pagetype($pagesources{$page});
  142. my @ret;
  143. push @ret, "\t\t<tr>";
  144. for (my $x=0; $x < @data; $x++) {
  145. my $cell=IkiWiki::htmlize($page, $destpage, $type,
  146. IkiWiki::preprocess($page, $destpage, $data[$x]));
  147. # automatic colspan for empty cells
  148. my $colspan=1;
  149. while ($x+1 < @data && $data[$x+1] eq '') {
  150. $x++;
  151. $colspan++;
  152. }
  153. # check if the first column should be a header
  154. my $e=$elt;
  155. if ($x == 0 && lc($params{header}) eq "column") {
  156. $e="th";
  157. }
  158. if ($colspan > 1) {
  159. push @ret, "\t\t\t<$e colspan=\"$colspan\">$cell</$e>"
  160. }
  161. else {
  162. push @ret, "\t\t\t<$e>$cell</$e>"
  163. }
  164. }
  165. push @ret, "\t\t</tr>";
  166. return @ret;
  167. } #}}}
  168. 1
>
  • << /S /GoTo /D (subsection.6.1) >>
  • endobj
  • 260 0 obj
  • (Basic AP Concepts)
  • endobj
  • 261 0 obj
  • << /S /GoTo /D (subsection.6.2) >>
  • endobj
  • 264 0 obj
  • (Vendors)
  • endobj
  • 265 0 obj
  • << /S /GoTo /D (subsection.6.3) >>
  • endobj
  • 268 0 obj
  • (AP Transactions)
  • endobj
  • 269 0 obj
  • << /S /GoTo /D (subsection.6.4) >>
  • endobj
  • 272 0 obj
  • (AP Invoices)
  • endobj
  • 273 0 obj
  • << /S /GoTo /D (subsubsection.6.4.1) >>
  • endobj
  • 276 0 obj
  • (Correcting an AP Invoice)
  • endobj
  • 277 0 obj
  • << /S /GoTo /D (subsection.6.5) >>
  • endobj
  • 280 0 obj
  • (Cash payment And Check Printing)
  • endobj
  • 281 0 obj
  • << /S /GoTo /D (subsubsection.6.5.1) >>
  • endobj
  • 284 0 obj
  • (Rapid Payment Entry Screen)
  • endobj
  • 285 0 obj
  • << /S /GoTo /D (subsection.6.6) >>
  • endobj
  • 288 0 obj
  • (Transaction/Invoice Reporting)
  • endobj
  • 289 0 obj
  • << /S /GoTo /D (subsubsection.6.6.1) >>
  • endobj
  • 292 0 obj
  • (Transactions Report)
  • endobj
  • 293 0 obj
  • << /S /GoTo /D (subsubsection.6.6.2) >>
  • endobj
  • 296 0 obj
  • (Outstanding Report)
  • endobj
  • 297 0 obj
  • << /S /GoTo /D (subsubsection.6.6.3) >>
  • endobj
  • 300 0 obj
  • (AP Aging Report)
  • endobj
  • 301 0 obj
  • << /S /GoTo /D (subsubsection.6.6.4) >>
  • endobj
  • 304 0 obj
  • (Tax Paid and Non-taxable Report)
  • endobj
  • 305 0 obj
  • << /S /GoTo /D (subsection.6.7) >>
  • endobj
  • 308 0 obj
  • (Vendor Reporting)
  • endobj
  • 309 0 obj
  • << /S /GoTo /D (subsubsection.6.7.1) >>
  • endobj
  • 312 0 obj
  • (Vendor Search)
  • endobj
  • 313 0 obj
  • << /S /GoTo /D (subsubsection.6.7.2) >>
  • endobj
  • 316 0 obj
  • (Vendor History)
  • endobj
  • 317 0 obj
  • << /S /GoTo /D (section.7) >>
  • endobj
  • 320 0 obj
  • (AR)
  • endobj
  • 321 0 obj
  • << /S /GoTo /D (subsection.7.1) >>
  • endobj
  • 324 0 obj
  • (Customers)
  • endobj
  • 325 0 obj
  • << /S /GoTo /D (subsubsection.7.1.1) >>
  • endobj
  • 328 0 obj
  • (Customer Price Matrix)
  • endobj
  • 329 0 obj
  • << /S /GoTo /D (subsection.7.2) >>
  • endobj
  • 332 0 obj
  • (AR Transactions)
  • endobj
  • 333 0 obj
  • << /S /GoTo /D (subsection.7.3) >>
  • endobj
  • 336 0 obj
  • (AR Invoices)
  • endobj
  • 337 0 obj
  • << /S /GoTo /D (subsection.7.4) >>
  • endobj
  • 340 0 obj
  • (Cash Receipt)
  • endobj
  • 341 0 obj
  • << /S /GoTo /D (subsubsection.7.4.1) >>
  • endobj
  • 344 0 obj
  • (Cash Receipts for multiple customers)
  • endobj
  • 345 0 obj
  • << /S /GoTo /D (subsection.7.5) >>
  • endobj
  • 348 0 obj
  • (AR Transaction Reporting)
  • endobj
  • 349 0 obj
  • << /S /GoTo /D (subsubsection.7.5.1) >>
  • endobj
  • 352 0 obj
  • (AR Transactions Report)
  • endobj
  • 353 0 obj
  • << /S /GoTo /D (subsubsection.7.5.2) >>
  • endobj
  • 356 0 obj
  • (AR Aging Report)
  • endobj
  • 357 0 obj
  • << /S /GoTo /D (subsection.7.6) >>
  • endobj
  • 360 0 obj
  • (Customer Reporting)
  • endobj
  • 361 0 obj
  • << /S /GoTo /D (section.8) >>
  • endobj
  • 364 0 obj
  • (Projects)
  • endobj
  • 365 0 obj
  • << /S /GoTo /D (subsection.8.1) >>
  • endobj
  • 368 0 obj
  • (Project Basics)
  • endobj
  • 369 0 obj
  • << /S /GoTo /D (subsection.8.2) >>
  • endobj
  • 372 0 obj
  • (Timecards)
  • endobj
  • 373 0 obj
  • << /S /GoTo /D (subsection.8.3) >>
  • endobj
  • 376 0 obj
  • (Projects and Invoices)
  • endobj
  • 377 0 obj
  • << /S /GoTo /D (subsection.8.4) >>
  • endobj
  • 380 0 obj
  • (Reporting)
  • endobj
  • 381 0 obj
  • << /S /GoTo /D (subsubsection.8.4.1) >>
  • endobj
  • 384 0 obj
  • (Timecard Reporting)
  • endobj
  • 385 0 obj
  • << /S /GoTo /D (subsubsection.8.4.2) >>
  • endobj
  • 388 0 obj
  • (Project Transaction Reporting)
  • endobj
  • 389 0 obj
  • << /S /GoTo /D (subsubsection.8.4.3) >>
  • endobj
  • 392 0 obj
  • (List of Projects)
  • endobj
  • 393 0 obj
  • << /S /GoTo /D (subsection.8.5) >>
  • endobj
  • 396 0 obj
  • (Possibilities for Using Projects)
  • endobj
  • 397 0 obj
  • << /S /GoTo /D (section.9) >>
  • endobj
  • 400 0 obj
  • (Quotations and Order Management)
  • endobj
  • 401 0 obj
  • << /S /GoTo /D (subsection.9.1) >>
  • endobj
  • 404 0 obj
  • (Sales Orders)
  • endobj
  • 405 0 obj
  • << /S /GoTo /D (subsection.9.2) >>
  • endobj
  • 408 0 obj
  • (Quotations)
  • endobj
  • 409 0 obj
  • << /S /GoTo /D (subsection.9.3) >>
  • endobj
  • 412 0 obj
  • (Shipping)
  • endobj
  • 413 0 obj
  • << /S /GoTo /D (subsection.9.4) >>
  • endobj
  • 416 0 obj
  • (AR Work Flow)
  • endobj
  • 417 0 obj
  • << /S /GoTo /D (subsubsection.9.4.1) >>
  • endobj
  • 420 0 obj
  • (Service Example)
  • endobj
  • 421 0 obj
  • << /S /GoTo /D (subsubsection.9.4.2) >>
  • endobj
  • 424 0 obj
  • (Single Warehouse Example)
  • endobj
  • 425 0 obj
  • << /S /GoTo /D (subsubsection.9.4.3) >>
  • endobj
  • 428 0 obj
  • (Multiple Warehouse Example)
  • endobj
  • 429 0 obj
  • << /S /GoTo /D (subsection.9.5) >>
  • endobj
  • 432 0 obj
  • (Requests for Quotation \(RFQ\))
  • endobj
  • 433 0 obj
  • << /S /GoTo /D (subsection.9.6) >>
  • endobj
  • 436 0 obj
  • (Purchase Orders)
  • endobj
  • 437 0 obj
  • << /S /GoTo /D (subsection.9.7) >>
  • endobj
  • 440 0 obj
  • (Receiving)
  • endobj
  • 441 0 obj
  • << /S /GoTo /D (subsection.9.8) >>
  • endobj
  • 444 0 obj
  • (AP Work Flow)
  • endobj
  • 445 0 obj
  • << /S /GoTo /D (subsubsection.9.8.1) >>
  • endobj
  • 448 0 obj
  • (Bookkeeper entering the received items, order completed in full)
  • endobj
  • 449 0 obj
  • << /S /GoTo /D (subsubsection.9.8.2) >>
  • endobj
  • 452 0 obj
  • (Bookkeeper entering received items, order completed in part)
  • endobj
  • 453 0 obj
  • << /S /GoTo /D (subsubsection.9.8.3) >>
  • endobj
  • 456 0 obj
  • (Receiving staff entering items)
  • endobj
  • 457 0 obj
  • << /S /GoTo /D (subsection.9.9) >>
  • endobj
  • 460 0 obj
  • (Generation and Consolidation)
  • endobj
  • 461 0 obj
  • << /S /GoTo /D (subsubsection.9.9.1) >>
  • endobj
  • 464 0 obj
  • (Generation)
  • endobj
  • 465 0 obj
  • << /S /GoTo /D (subsubsection.9.9.2) >>
  • endobj
  • 468 0 obj
  • (Consolidation)
  • endobj
  • 469 0 obj
  • << /S /GoTo /D (subsection.9.10) >>
  • endobj
  • 472 0 obj
  • (Reporting)
  • endobj
  • 473 0 obj
  • << /S /GoTo /D (subsection.9.11) >>
  • endobj
  • 476 0 obj
  • (Shipping Module: Transferring Inventory between Warehouses)
  • endobj
  • 477 0 obj
  • << /S /GoTo /D (section.10) >>
  • endobj
  • 480 0 obj
  • (HR)
  • endobj
  • 481 0 obj
  • << /S /GoTo /D (section.11) >>
  • endobj
  • 484 0 obj
  • (POS)
  • endobj
  • 485 0 obj
  • << /S /GoTo /D (subsection.11.1) >>
  • endobj
  • 488 0 obj
  • (Sales Screen)
  • endobj
  • 489 0 obj
  • << /S /GoTo /D (subsection.11.2) >>
  • endobj
  • 492 0 obj
  • (Possibilities for Data Entry)
  • endobj
  • 493 0 obj
  • << /S /GoTo /D (subsection.11.3) >>
  • endobj
  • 496 0 obj
  • (Hardware Support)
  • endobj
  • 497 0 obj
  • << /S /GoTo /D (subsection.11.4) >>
  • endobj
  • 500 0 obj
  • (Reports)
  • endobj
  • 501 0 obj
  • << /S /GoTo /D (subsubsection.11.4.1) >>
  • endobj
  • 504 0 obj
  • (Open Invoices)
  • endobj
  • 505 0 obj
  • << /S /GoTo /D (subsubsection.11.4.2) >>
  • endobj
  • 508 0 obj
  • (Receipts)
  • endobj
  • 509 0 obj
  • << /S /GoTo /D (section.12) >>
  • endobj
  • 512 0 obj
  • (General Ledger)
  • endobj
  • 513 0 obj
  • << /S /GoTo /D (subsection.12.1) >>
  • endobj
  • 516 0 obj
  • (GL Basics)
  • endobj
  • 517 0 obj
  • << /S /GoTo /D (subsubsection.12.1.1) >>
  • endobj
  • 520 0 obj
  • (Paper-based accounting systems and the GL)
  • endobj
  • 521 0 obj
  • << /S /GoTo /D (subsubsection.12.1.2) >>
  • endobj
  • 524 0 obj
  • (Double Entry Examples on Paper)
  • endobj
  • 525 0 obj
  • << /S /GoTo /D (subsubsection.12.1.3) >>
  • endobj
  • 528 0 obj
  • (The GL in Ledger-SMB)
  • endobj
  • 529 0 obj
  • << /S /GoTo /D (subsection.12.2) >>
  • endobj
  • 532 0 obj
  • (Cash Transfer)
  • endobj
  • 533 0 obj
  • << /S /GoTo /D (subsection.12.3) >>
  • endobj
  • 536 0 obj
  • (GL Transactions)
  • endobj
  • 537 0 obj
  • << /S /GoTo /D (subsection.12.4) >>
  • endobj
  • 540 0 obj
  • (Payroll as a GL transaction)
  • endobj
  • 541 0 obj
  • << /S /GoTo /D (subsection.12.5) >>
  • endobj
  • 544 0 obj
  • (Reconciliation)
  • endobj
  • 545 0 obj
  • << /S /GoTo /D (subsection.12.6) >>
  • endobj
  • 548 0 obj
  • (Reports)
  • endobj
  • 549 0 obj
  • << /S /GoTo /D (subsubsection.12.6.1) >>
  • endobj
  • 552 0 obj
  • (GL as access to almost everything else)
  • endobj
  • 553 0 obj
  • << /S /GoTo /D (section.13) >>
  • endobj
  • 556 0 obj
  • (Recurring Transactions)
  • endobj
  • 557 0 obj
  • << /S /GoTo /D (section.14) >>
  • endobj
  • 560 0 obj
  • (Financial Statements and Reports)
  • endobj
  • 561 0 obj
  • << /S /GoTo /D (subsection.14.1) >>
  • endobj
  • 564 0 obj
  • (Cash v. Accrual Basis)
  • endobj
  • 565 0 obj
  • << /S /GoTo /D (subsection.14.2) >>
  • endobj
  • 568 0 obj
  • (Viewing the Chart of Accounts and Transactions)
  • endobj
  • 569 0 obj
  • << /S /GoTo /D (subsection.14.3) >>
  • endobj
  • 572 0 obj
  • (Trial Balance)
  • endobj
  • 573 0 obj
  • << /S /GoTo /D (subsubsection.14.3.1) >>
  • endobj
  • 576 0 obj
  • (The Paper-based function of a Trial Balance)
  • endobj
  • 577 0 obj
  • << /S /GoTo /D (subsubsection.14.3.2) >>
  • endobj
  • 580 0 obj
  • (Running the Trial Balance Report)
  • endobj
  • 581 0 obj
  • << /S /GoTo /D (subsubsection.14.3.3) >>
  • endobj
  • 584 0 obj
  • (What if the Trial Balance doesn't Balance?)
  • endobj
  • 585 0 obj
  • << /S /GoTo /D (subsubsection.14.3.4) >>
  • endobj
  • 588 0 obj
  • (Trial Balance as a Summary of Account Activity)
  • endobj
  • 589 0 obj
  • << /S /GoTo /D (subsubsection.14.3.5) >>
  • endobj
  • 592 0 obj
  • (Trial Balance as a Budget Planning Tool)
  • endobj
  • 593 0 obj
  • << /S /GoTo /D (subsection.14.4) >>
  • endobj
  • 596 0 obj
  • (Income Statement)
  • endobj
  • 597 0 obj
  • << /S /GoTo /D (subsubsection.14.4.1) >>
  • endobj
  • 600 0 obj
  • (Uses of an Income Statement)
  • endobj
  • 601 0 obj
  • << /S /GoTo /D (subsection.14.5) >>
  • endobj
  • 604 0 obj
  • (Balance Sheet)
  • endobj
  • 605 0 obj
  • << /S /GoTo /D (subsection.14.6) >>
  • endobj
  • 608 0 obj
  • (What if the Balance Sheet doesn't balance?)
  • endobj
  • 609 0 obj
  • << /S /GoTo /D (subsection.14.7) >>
  • endobj
  • 612 0 obj
  • (No Statement of Owner Equity?)
  • endobj
  • 613 0 obj
  • << /S /GoTo /D (section.15) >>
  • endobj
  • 616 0 obj
  • (The Template System)
  • endobj
  • 617 0 obj
  • << /S /GoTo /D (subsection.15.1) >>
  • endobj
  • 620 0 obj
  • (Text Templates)
  • endobj
  • 621 0 obj
  • << /S /GoTo /D (subsection.15.2) >>
  • endobj
  • 624 0 obj
  • (HTML Templates)
  • endobj
  • 625 0 obj
  • << /S /GoTo /D (subsection.15.3) >>
  • endobj
  • 628 0 obj
  • (LaTeX Templates)
  • endobj
  • 629 0 obj
  • << /S /GoTo /D (subsubsection.15.3.1) >>
  • endobj
  • 632 0 obj
  • (What is LaTeX ?)
  • endobj
  • 633 0 obj
  • << /S /GoTo /D (subsubsection.15.3.2) >>
  • endobj
  • 636 0 obj
  • (Using LyX to Edit LaTeX Templates)
  • endobj
  • 637 0 obj
  • << /S /GoTo /D (subsection.15.4) >>
  • endobj
  • 640 0 obj
  • (Customizing Logos)
  • endobj
  • 641 0 obj
  • << /S /GoTo /D (subsection.15.5) >>
  • endobj
  • 644 0 obj
  • (How are They Stored in the Filesystem?)
  • endobj
  • 645 0 obj
  • << /S /GoTo /D (subsection.15.6) >>
  • endobj
  • 648 0 obj
  • (Upgrade Issues)
  • endobj
  • 649 0 obj
  • << /S /GoTo /D (part.2) >>
  • endobj
  • 652 0 obj
  • (II Technical Overview)
  • endobj
  • 653 0 obj
  • << /S /GoTo /D (section.16) >>
  • endobj
  • 656 0 obj
  • (Basic Architecture)
  • endobj
  • 657 0 obj
  • << /S /GoTo /D (subsection.16.1) >>
  • endobj
  • 660 0 obj
  • (The Software Stack)
  • endobj
  • 661 0 obj
  • << /S /GoTo /D (subsection.16.2) >>
  • endobj
  • 664 0 obj
  • (Capacity Planning)
  • endobj
  • 665 0 obj
  • << /S /GoTo /D (subsubsection.16.2.1) >>
  • endobj
  • 668 0 obj
  • (Scalability Strategies)
  • endobj
  • 669 0 obj
  • << /S /GoTo /D (subsubsection.16.2.2) >>
  • endobj
  • 672 0 obj
  • (Database Maintenance)
  • endobj
  • 673 0 obj
  • << /S /GoTo /D (subsubsection.16.2.3) >>
  • endobj
  • 676 0 obj
  • (Known issues)
  • endobj
  • 677 0 obj
  • << /S /GoTo /D (section.17) >>
  • endobj
  • 680 0 obj
  • (Customization Possibilities)
  • endobj
  • 681 0 obj
  • << /S /GoTo /D (subsection.17.1) >>
  • endobj
  • 684 0 obj
  • (Brief Guide to the Source Code)
  • endobj
  • 685 0 obj
  • << /S /GoTo /D (subsection.17.2) >>
  • endobj
  • 688 0 obj
  • (Data Entry Screens)
  • endobj
  • 689 0 obj
  • << /S /GoTo /D (subsubsection.17.2.1) >>
  • endobj
  • 692 0 obj
  • (Examples)
  • endobj
  • 693 0 obj
  • << /S /GoTo /D (subsection.17.3) >>
  • endobj
  • 696 0 obj
  • (Extensions)
  • endobj
  • 697 0 obj
  • << /S /GoTo /D (subsubsection.17.3.1) >>
  • endobj
  • 700 0 obj
  • (Examples)
  • endobj
  • 701 0 obj
  • << /S /GoTo /D (subsection.17.4) >>
  • endobj
  • 704 0 obj
  • (Templates)
  • endobj
  • 705 0 obj
  • << /S /GoTo /D (subsubsection.17.4.1) >>
  • endobj
  • 708 0 obj
  • (Examples)
  • endobj
  • 709 0 obj
  • << /S /GoTo /D (subsection.17.5) >>
  • endobj
  • 712 0 obj
  • (Reports)
  • endobj
  • 713 0 obj
  • << /S /GoTo /D (subsubsection.17.5.1) >>
  • endobj
  • 716 0 obj
  • (Examples)
  • endobj
  • 717 0 obj
  • << /S /GoTo /D (section.18) >>
  • endobj
  • 720 0 obj
  • (Integration Possibilities)
  • endobj
  • 721 0 obj
  • << /S /GoTo /D (subsection.18.1) >>
  • endobj
  • 724 0 obj
  • (Reporting Tools)
  • endobj
  • 725 0 obj
  • << /S /GoTo /D (subsubsection.18.1.1) >>
  • endobj
  • 728 0 obj
  • (Examples)
  • endobj
  • 729 0 obj
  • << /S /GoTo /D (subsection.18.2) >>
  • endobj
  • 732 0 obj
  • (Line of Business Tools on PostgreSQL)
  • endobj
  • 733 0 obj
  • << /S /GoTo /D (subsubsection.18.2.1) >>
  • endobj
  • 736 0 obj
  • (Known Issues)
  • endobj
  • 737 0 obj
  • << /S /GoTo /D (subsubsection.18.2.2) >>
  • endobj
  • 740 0 obj
  • (Strategies)
  • endobj
  • 741 0 obj
  • << /S /GoTo /D (subsubsection.18.2.3) >>
  • endobj
  • 744 0 obj
  • (Examples)
  • endobj
  • 745 0 obj
  • << /S /GoTo /D (subsection.18.3) >>
  • endobj
  • 748 0 obj
  • (Line of Business Tools on other RDBMS's)
  • endobj
  • 749 0 obj
  • << /S /GoTo /D (subsubsection.18.3.1) >>
  • endobj
  • 752 0 obj
  • (Strategies)
  • endobj
  • 753 0 obj
  • << /S /GoTo /D (subsubsection.18.3.2) >>
  • endobj
  • 756 0 obj
  • (Integration Products and Open Source Projects)
  • endobj
  • 757 0 obj
  • << /S /GoTo /D (section.19) >>
  • endobj
  • 760 0 obj
  • (Customization Guide)
  • endobj
  • 761 0 obj
  • << /S /GoTo /D (subsection.19.1) >>
  • endobj
  • 764 0 obj
  • (General Information)
  • endobj
  • 765 0 obj
  • << /S /GoTo /D (subsection.19.2) >>
  • endobj
  • 768 0 obj
  • (Customizing Templates)
  • endobj
  • 769 0 obj
  • << /S /GoTo /D (subsubsection.19.2.1) >>
  • endobj
  • 772 0 obj
  • (Page Breaks in LaTeX)
  • endobj
  • 773 0 obj
  • << /S /GoTo /D (subsubsection.19.2.2) >>
  • endobj
  • 776 0 obj
  • (Conditionals)
  • endobj
  • 777 0 obj
  • << /S /GoTo /D (subsubsection.19.2.3) >>
  • endobj
  • 780 0 obj
  • (Loops)
  • endobj
  • 781 0 obj
  • << /S /GoTo /D (subsubsection.19.2.4) >>
  • endobj
  • 784 0 obj
  • (File Inclusion)
  • endobj
  • 785 0 obj
  • << /S /GoTo /D (subsubsection.19.2.5) >>
  • endobj
  • 788 0 obj
  • (Cross-referencing and multiple passes of LaTeX)
  • endobj
  • 789 0 obj
  • << /S /GoTo /D (subsubsection.19.2.6) >>
  • endobj
  • 792 0 obj
  • (Variable Substitution)
  • endobj
  • 793 0 obj
  • << /S /GoTo /D (subsection.19.3) >>
  • endobj
  • 796 0 obj
  • (Customizing Forms)
  • endobj
  • 797 0 obj
  • << /S /GoTo /D (subsection.19.4) >>
  • endobj
  • 800 0 obj
  • (Customizing Modules)
  • endobj
  • 801 0 obj
  • << /S /GoTo /D (subsubsection.19.4.1) >>
  • endobj
  • 804 0 obj
  • (Database Access)
  • endobj
  • 805 0 obj
  • << /S /GoTo /D (subsection.19.5) >>
  • endobj
  • 808 0 obj
  • (Examples)
  • endobj
  • 809 0 obj
  • << /S /GoTo /D (subsubsection.19.5.1) >>
  • endobj
  • 812 0 obj
  • (Adding a New Report for Sales Data)
  • endobj
  • 813 0 obj
  • << /S /GoTo /D (subsubsection.19.5.2) >>
  • endobj
  • 816 0 obj
  • (Truncating Number of Invoices on a Check Stub)
  • endobj
  • 817 0 obj
  • << /S /GoTo /D (subsubsection.19.5.3) >>
  • endobj
  • 820 0 obj
  • (Adding the a Check ID flag for Alcohol Purchases)
  • endobj
  • 821 0 obj
  • << /S /GoTo /D (part.3) >>
  • endobj
  • 824 0 obj
  • (III Appendix)
  • endobj
  • 825 0 obj
  • << /S /GoTo /D (section.A) >>
  • endobj
  • 828 0 obj
  • (Where to Go for More Information)
  • endobj
  • 829 0 obj
  • << /S /GoTo /D (section.B) >>
  • endobj
  • 832 0 obj
  • (Quick Tips)
  • endobj
  • 833 0 obj
  • << /S /GoTo /D (subsection.B.1) >>
  • endobj
  • 836 0 obj
  • (Understanding Shipping Addresses and Carriers)
  • endobj
  • 837 0 obj
  • << /S /GoTo /D (subsection.B.2) >>
  • endobj
  • 840 0 obj
  • (Handling bad debts)
  • endobj
  • 841 0 obj
  • << /S /GoTo /D (section.C) >>
  • endobj
  • 844 0 obj
  • (Step by Steps for Vertical Markets)
  • endobj
  • 845 0 obj
  • << /S /GoTo /D (subsection.C.1) >>
  • endobj
  • 848 0 obj
  • (Common Installation Errors)
  • endobj
  • 849 0 obj
  • << /S /GoTo /D (subsection.C.2) >>
  • endobj
  • 852 0 obj
  • (Retail With Light Manufacturing)
  • endobj
  • 853 0 obj
  • << /S /GoTo /D (section.D) >>
  • endobj
  • 856 0 obj
  • (Glossary)
  • endobj
  • 857 0 obj
  • << /S /GoTo /D (section.E) >>
  • endobj
  • 860 0 obj
  • (GNU Free Documentation License)
  • endobj
  • 861 0 obj
  • << /S /GoTo /D (section*.3) >>
  • endobj
  • 864 0 obj
  • (1. APPLICABILITY AND DEFINITIONS)
  • endobj
  • 865 0 obj
  • << /S /GoTo /D (section*.3) >>
  • endobj
  • 867 0 obj
  • (2. VERBATIM COPYING)
  • endobj
  • 868 0 obj
  • << /S /GoTo /D (section*.3) >>
  • endobj
  • 870 0 obj
  • (3. COPYING IN QUANTITY)
  • endobj
  • 871 0 obj
  • << /S /GoTo /D (section*.3) >>
  • endobj
  • 873 0 obj
  • (4. MODIFICATIONS)
  • endobj
  • 874 0 obj
  • << /S /GoTo /D (section*.3) >>
  • endobj
  • 876 0 obj
  • (5. COMBINING DOCUMENTS)
  • endobj
  • 877 0 obj
  • << /S /GoTo /D (section*.3) >>
  • endobj
  • 879 0 obj
  • (6. COLLECTIONS OF DOCUMENTS)
  • endobj
  • 880 0 obj
  • << /S /GoTo /D (section*.3) >>
  • endobj
  • 882 0 obj
  • (7. AGGREGATION WITH INDEPENDENT WORKS)
  • endobj
  • 883 0 obj
  • << /S /GoTo /D (section*.3) >>
  • endobj
  • 885 0 obj
  • (8. TRANSLATION)
  • endobj
  • 886 0 obj
  • << /S /GoTo /D (section*.3) >>
  • endobj
  • 888 0 obj
  • (9. TERMINATION)
  • endobj
  • 889 0 obj
  • << /S /GoTo /D (section*.3) >>
  • endobj
  • 891 0 obj
  • (10. FUTURE REVISIONS OF THIS LICENSE)
  • endobj
  • 892 0 obj
  • << /S /GoTo /D (section*.3) >>
  • endobj
  • 894 0 obj
  • (ADDENDUM: How to use this License for your documents)
  • endobj
  • 895 0 obj
  • << /S /GoTo /D [896 0 R /Fit ] >>
  • endobj
  • 898 0 obj <<
  • /Length 2793
  • /Filter /FlateDecode
  • >>
  • stream
  • xÚí\KwÛºÞçWp)ŸS!xƒ8ÝÔv½mr›Sû¶‹¦ Z¢mžèáJTÿû;