| 1 | {*\r |
| 2 | +--------------------------------------------------------------------+\r |
| 3 | | CiviCRM version 4.7 |\r |
| 4 | +--------------------------------------------------------------------+\r |
| 5 | | Copyright CiviCRM LLC (c) 2004-2015 |\r |
| 6 | +--------------------------------------------------------------------+\r |
| 7 | | This file is a part of CiviCRM. |\r |
| 8 | | |\r |
| 9 | | CiviCRM is free software; you can copy, modify, and distribute it |\r |
| 10 | | under the terms of the GNU Affero General Public License |\r |
| 11 | | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. |\r |
| 12 | | |\r |
| 13 | | CiviCRM is distributed in the hope that it will be useful, but |\r |
| 14 | | WITHOUT ANY WARRANTY; without even the implied warranty of |\r |
| 15 | | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |\r |
| 16 | | See the GNU Affero General Public License for more details. |\r |
| 17 | | |\r |
| 18 | | You should have received a copy of the GNU Affero General Public |\r |
| 19 | | License and the CiviCRM Licensing Exception along |\r |
| 20 | | with this program; if not, contact CiviCRM LLC |\r |
| 21 | | at info[AT]civicrm[DOT]org. If you have questions about the |\r |
| 22 | | GNU Affero General Public License or the licensing of CiviCRM, |\r |
| 23 | | see the CiviCRM license FAQ at http://civicrm.org/licensing |\r |
| 24 | +--------------------------------------------------------------------+\r |
| 25 | *}\r |
| 26 | {*\r |
| 27 | \r |
| 28 | ***** IMPORTANT *************\r |
| 29 | Quickbooks allows almost NO variation in formatting. If editing this file pay\r |
| 30 | close attention to whitespace, empty lines, and invisible characters. In\r |
| 31 | particular, since the coding standard means sometimes people's editors replace\r |
| 32 | tabs with spaces, always use the $tabchar var below instead of an actual tab\r |
| 33 | character. And watch out for editors that add spaces/tabs at the end of lines.\r |
| 34 | (I'm wondering if it's better not to use smarty for this.)\r |
| 35 | \r |
| 36 | ****************** BE CAREFUL !!!!!!!!!! ***********************\r |
| 37 | \r |
| 38 | *}\r |
| 39 | {assign var='tabchar' value=9|chr}\r |
| 40 | {if !empty($accounts)}\r |
| 41 | !ACCNT{$tabchar}NAME{$tabchar}REFNUM{$tabchar}TIMESTAMP{$tabchar}ACCNTTYPE{$tabchar}OBAMOUNT{$tabchar}DESC{$tabchar}ACCNUM\r |
| 42 | {* I don't think we need these fields - SCD BANKNUM EXTRA HIDDEN DELCOUNT USEID WKPAPERREF\r |
| 43 | \r |
| 44 | *}\r |
| 45 | {foreach from=$accounts key=account_id item=acct}\r |
| 46 | ACCNT{$tabchar}{$acct.name}{$tabchar}{$tabchar}{$tabchar}{$acct.type}{$tabchar}{$tabchar}{$acct.description}{$tabchar}{$acct.account_code}\r |
| 47 | {/foreach}\r |
| 48 | {/if}\r |
| 49 | {if !empty($contacts)}\r |
| 50 | !CUST{$tabchar}NAME{$tabchar}REFNUM{$tabchar}TIMESTAMP{$tabchar}BADDR1{$tabchar}BADDR2{$tabchar}BADDR3{$tabchar}BADDR4{$tabchar}BADDR5{$tabchar}SADDR1{$tabchar}SADDR2{$tabchar}SADDR3{$tabchar}SADDR4{$tabchar}SADDR5{$tabchar}PHONE1{$tabchar}PHONE2{$tabchar}FAXNUM{$tabchar}EMAIL{$tabchar}NOTE{$tabchar}CONT1{$tabchar}CONT2{$tabchar}CTYPE{$tabchar}TERMS{$tabchar}TAXABLE{$tabchar}SALESTAXCODE{$tabchar}LIMIT{$tabchar}RESALENUM{$tabchar}REP{$tabchar}TAXITEM{$tabchar}NOTEPAD{$tabchar}SALUTATION{$tabchar}COMPANYNAME{$tabchar}FIRSTNAME{$tabchar}MIDINIT{$tabchar}LASTNAME{$tabchar}CUSTFLD1{$tabchar}CUSTFLD2{$tabchar}CUSTFLD3{$tabchar}CUSTFLD4{$tabchar}CUSTFLD5{$tabchar}CUSTFLD6{$tabchar}CUSTFLD7{$tabchar}CUSTFLD8{$tabchar}CUSTFLD9{$tabchar}CUSTFLD10{$tabchar}CUSTFLD11{$tabchar}CUSTFLD12{$tabchar}CUSTFLD13{$tabchar}CUSTFLD14{$tabchar}CUSTFLD15{$tabchar}JOBDESC{$tabchar}JOBTYPE{$tabchar}JOBSTATUS{$tabchar}JOBSTART{$tabchar}JOBPROJEND{$tabchar}JOBEND{$tabchar}HIDDEN{$tabchar}DELCOUNT{$tabchar}PRICELEVEL\r |
| 51 | {foreach from=$contacts key=contact_id item=contact}\r |
| 52 | CUST{$tabchar}{$contact.name}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$contact.first_name}{$tabchar}{$tabchar}{$contact.last_name}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}{$tabchar}\r |
| 53 | {/foreach}\r |
| 54 | {/if}\r |
| 55 | {if !empty($journalEntries)}\r |
| 56 | !TRNS{$tabchar}TRNSID{$tabchar}TRNSTYPE{$tabchar}DATE{$tabchar}ACCNT{$tabchar}NAME{$tabchar}CLASS{$tabchar}AMOUNT{$tabchar}DOCNUM{$tabchar}MEMO{$tabchar}PAYMETH\r |
| 57 | !SPL{$tabchar}SPLID{$tabchar}TRNSTYPE{$tabchar}DATE{$tabchar}ACCNT{$tabchar}NAME{$tabchar}CLASS{$tabchar}AMOUNT{$tabchar}DOCNUM{$tabchar}MEMO{$tabchar}PAYMETH\r |
| 58 | !ENDTRNS\r |
| 59 | {foreach from=$journalEntries key=id item=je}\r |
| 60 | TRNS{$tabchar}{$je.to_account.trxn_id}{$tabchar}GENERAL JOURNAL{$tabchar}{$je.to_account.trxn_date}{$tabchar}{$je.to_account.account_name}{$tabchar}{$je.to_account.contact_name}{$tabchar}{$tabchar}{$je.to_account.amount}{$tabchar}{$je.to_account.check_number}{$tabchar}{$tabchar}{$je.to_account.payment_instrument}\r |
| 61 | {foreach from=$je.splits key=spl_id item=spl}\r |
| 62 | SPL{$tabchar}{$spl.spl_id}{$tabchar}GENERAL JOURNAL{$tabchar}{$spl.trxn_date}{$tabchar}{$spl.account_name}{$tabchar}{$spl.contact_name}{$tabchar}{$tabchar}{$spl.amount}{$tabchar}{$spl.check_number}{$tabchar}{$spl.description}{$tabchar}{$spl.payment_instrument}\r |
| 63 | {/foreach}\r |
| 64 | ENDTRNS\r |
| 65 | {/foreach}\r |
| 66 | {/if}\r |