Spade

Mini Shell

Directory:~$ /home/lmsyaran/www/administrator/components/com_invoices/sql/updates/
Upload File

[Home] [System Details] [Kill Me]
Current File:~$ /home/lmsyaran/www/administrator/components/com_invoices/sql/updates/1.3.0.sql

ALTER TABLE  `#__invoices_invoices` ADD  `to_phone` VARCHAR( 255 ) NOT NULL
, ADD  `external_type` VARCHAR( 255 ) NOT NULL , ADD  `external_id` INT( 11
) NOT NULL , ADD  `type` INT( 3 ) NOT NULL DEFAULT  '1', ADD 
`rec_email` TINYINT( 1 ) NOT NULL , ADD  `auth_code` VARCHAR( 255 ) NOT
NULL, ADD  `computed_status` VARCHAR( 255 ) NOT NULL, ADD  `computed_total`
DECIMAL( 10, 2 ) NOT NULL;

ALTER TABLE `#__invoices_items` ADD  `tax` DECIMAL( 10, 2 ) NOT NULL, ADD 
`sku` VARCHAR( 255 ) NOT NULL, ADD  `external_type` VARCHAR( 255 ) NOT NULL
, ADD  `product_id` INT( 11 ) NOT NULL;

ALTER TABLE `#__invoices_contacts` ADD  `phone` VARCHAR( 255 ) NOT NULL;

ALTER TABLE  `#__invoices_templateitems` ADD  `tax` DECIMAL( 10, 2 ) NOT
NULL , ADD  `sku` VARCHAR( 255 ) NOT NULL;

INSERT INTO `#__invoices_templates` (`id`, `name`, `content`, `items`,
`taxes`, `payments`, `payments2`, `styles`, `content_pdf`) VALUES
(NULL, 'Invoice (Bootstrap)', '<div
style="font-family:Helvetica;"  >\r\n  <div
class="row-fluid">\r\n    <div class="span6">
<img src="http://www.joomlathat.com/images/joomlathat3.png"
/><br />\r\n      <br />\r\n      <dl
class="dl-horizontal">\r\n       
<dt>From</dt>\r\n        <dd>
<strong>{from_name}</strong> </dd>\r\n       
<dt>Address</dt>\r\n        <dd>\r\n         
<address>\r\n          {from_address}\r\n         
</address>\r\n        </dd>\r\n       
<dt>e-mail</dt>\r\n        <dd> {from_email}
</dd>\r\n        <dt>Fiscal number</dt>\r\n       
<dd> {from_num} </dd>\r\n      </dl>\r\n   
</div>\r\n    <div class="span6">\r\n      <div
class="well well-small">\r\n        <dl
class="dl-horizontal">\r\n          <dt>Invoice
number</dt>\r\n          <dd>{invoice_num}</dd>\r\n      
   <dt>Invoice date</dt>\r\n         
<dd>{invoice_date}</dd>\r\n          <dt>Due
date</dt>\r\n          <dd>{invoice_duedate}</dd>\r\n    
     <dt>Invoice total</dt>\r\n         
<dd>{total}</dd>\r\n          <dt>Status</dt>\r\n  
       <dd>{status}</dd>\r\n        </dl>\r\n     
</div>\r\n      <div class="well well-small">\r\n    
   <dl class="dl-horizontal">\r\n          <dt>Bill
to</dt>\r\n          <dd>
<strong>{to_name}</strong> </dd>\r\n         
<dt>Address</dt>\r\n          <dd>\r\n           
<address>\r\n            {to_company} <br />\r\n           
{to_address} <br />\r\n            {to_zipcode} {to_city} <br
/>\r\n            {to_state} {to_country}\r\n           
</address>\r\n          </dd>\r\n         
<dt>e-mail</dt>\r\n         
<dd>{to_email}</dd>\r\n          <dt>VAT
ID</dt>\r\n          <dd>{to_vatid}</dd>\r\n         
<dt>Phone</dt>\r\n          <dd>{to_phone}</dd>\r\n
       </dl>\r\n      </div>\r\n    </div>\r\n 
</div>\r\n  <h2
class="invoice_header">Items</h2>\r\n  <table
width="100%" class="table table-striped"   >\r\n   
<thead>\r\n      <tr>\r\n        <th
align="left">SKU</th>\r\n        <th
align="left">Description</th>\r\n        <th
align="right" style="text-align:right;">Unit
cost</th>\r\n        <th align="right"
style="text-align:right;">Quantity</th>\r\n       
<th align="right"
style="text-align:right;">Discount</th>\r\n       
<th align="right"
style="text-align:right;">Tax</th>\r\n        <th
align="right"
style="text-align:right;">Price</th>\r\n     
</tr>\r\n    </thead>\r\n    <tbody>\r\n    \r\n   
{items}\r\n    </tbody>\r\n    \r\n    <tfoot>\r\n     
<tr>\r\n        <td colspan="4"></td>\r\n      
 <td colspan="2" align="right"
style="text-align:right;">Discount</td>\r\n       
<td align="right"
style="text-align:right;">{discount}</td>\r\n     
</tr>\r\n      <tr>\r\n        <td
colspan="4"></td>\r\n        <td
colspan="2" align="right"
style="text-align:right;">Subtotal</td>\r\n       
<td align="right"
style="text-align:right;">{subtotal}</td>\r\n     
</tr>\r\n    {taxes}\r\n    <tr>\r\n      <td
colspan="4"></td>\r\n      <td colspan="2"
align="right"
style="text-align:right;"><strong>Total</strong></td>\r\n
     <td align="right"
style="text-align:right;"><strong>{total}</strong></td>\r\n
   </tr>\r\n    </tfoot>\r\n    \r\n  </table>\r\n 
<ul class="nav nav-tabs">\r\n    <li><a
href="#payments_received" data-toggle="tab">Payments
received {num_payments_received}</a></li>\r\n    <li
class="active"><a href="#pending_payments"
data-toggle="tab">Pending payments
{num_pending_payments}</a></li>\r\n  </ul>\r\n  <div
class="tab-content">\r\n    <div class="tab-pane
" id="payments_received">\r\n      <table
width="100%" class="table table-striped "
style="table-layout:fixed;" >\r\n        <thead>\r\n    
     <tr>\r\n            <th align="left">Payment
date</th>\r\n            <th
align="left">Description</th>\r\n            <th
align="left">Status</th>\r\n            <th
align="left"></th>\r\n            <th
align="right"
style="text-align:right;">Amount</th>\r\n         
</tr>\r\n        </thead>\r\n        <tbody>\r\n       
\r\n        {payments}\r\n        </tbody>\r\n        \r\n       
<tfoot>\r\n          <tr>\r\n            <td
></td>\r\n            <td ></td>\r\n            <td
></td>\r\n            <td align="right"
style="text-align:right;"><strong>Total amount
paid</strong></td>\r\n            <td
align="right"
style="text-align:right;"><strong>{total_payments}</strong></td>\r\n
         </tr>\r\n        </tfoot>\r\n      </table>\r\n 
  </div>\r\n    <div class="tab-pane active"
id="pending_payments">\r\n      <table
width="100%" class="table table-striped table-hover"
style="table-layout:fixed;">\r\n        <thead>\r\n     
    <tr>\r\n            <th align="left">Due
date</th>\r\n            <th
align="left">Description</th>\r\n            <th
align="left">Status</th>\r\n            <th
align="left"></th>\r\n            <th
align="right"
style="text-align:right;">Amount</th>\r\n         
</tr>\r\n        </thead>\r\n        <tbody>\r\n       
\r\n        {payments2}\r\n        </tbody>\r\n        \r\n       
<tfoot>\r\n          <tr>\r\n            <td
></td>\r\n            <td ></td>\r\n            <td
></td>\r\n            <td align="right"
style="text-align:right;"><strong>Amount
outstanding</strong></td>\r\n            <td
align="right"
style="text-align:right;"><strong>{amount_outstanding}</strong></td>\r\n
         </tr>\r\n        </tfoot>\r\n      </table>\r\n 
  </div>\r\n  </div>\r\n  \r\n  <!--h2
class="invoice_header">Payments received</h2--> \r\n 
\r\n  <!--h2 class="invoice_header">Pending
payments</h2-->\r\n  \r\n  <div
style="padding:2px;">Notes</div>\r\n  <div
style="border-top:1px solid #000; padding:2px; "
class="muted"><small>{notes}</small></div>\r\n</div>',
'<tr>\r\n<td>{sku}</td>\r\n<td><strong>{name}</strong><br
/>{desc}</td>\r\n<td align="right"
style="text-align:right;">{value}</td>\r\n<td
align="right"
style="text-align:right;">{amount}</td>\r\n<td
align="right"
style="text-align:right;">{discount}</td>\r\n<td
align="right"
style="text-align:right;">{tax}</td>\r\n<td
align="right"
style="text-align:right;">{item_total}</td>\r\n</tr>',
'<tr>\r\n<td colspan="4"></td>\r\n<td
colspan="2" align="right"
style="text-align:right;">{name}</td>\r\n<td
align="right"
style="text-align:right;">{value}</td>\r\n</tr>',
'<tr><td>\r\n{payment_datetime}\r\n</td>\r\n<td
>\r\n{description}\r\n</td>\r\n<td
>\r\n{payment_status}\r\n</td>\r\n<td align="right"
style="text-align:right;">\r\n<a
href="{payment_link}" class="btn btn-mini"><i
class="icon-eye-open"></i> View
details</a>\r\n</td>\r\n<td align="right"
style="text-align:right;">\r\n{amount}\r\n</td>\r\n</tr>',
'<tr><td>\r\n{duedate}\r\n</td>\r\n<td
>\r\n{description}\r\n</td>\r\n<td
>\r\n{payment_status}\r\n</td>\r\n<td align="right"
style="text-align:right;">\r\n<a
href="{payment_link}" target="_parent" class="btn
btn-info btn-mini"><i class="icon-arrow-right
icon-white"></i> Pay now</a>\r\n</td>\r\n<td
align="right"
style="text-align:right;">\r\n{amount}\r\n</td>\r\n</tr>',
'.clearfix{*zoom:1;}.clearfix:before,.clearfix:after{display:table;content:"";line-height:0;}\r\n.clearfix:after{clear:both;}\r\n.hide-text{font:0/0
a;color:transparent;text-shadow:none;background-color:transparent;border:0;}\r\n\r\ndl{margin-bottom:20px;}\r\ndt,dd{line-height:20px;}\r\ndt{font-weight:bold;}\r\ndd{margin-left:10px;}\r\n.dl-horizontal{*zoom:1;}.dl-horizontal:before,.dl-horizontal:after{display:table;content:"";line-height:0;}\r\n.dl-horizontal:after{clear:both;}\r\n.dl-horizontal
dt{float:left;width:120px;clear:left;text-align:right;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;}\r\n.dl-horizontal
dd{margin-left:140px;}\r\nhr{margin:20px 0;border:0;border-top:1px solid
#eeeeee;border-bottom:1px solid
#ffffff;}\r\nabbr[title],abbr[data-original-title]{cursor:help;border-bottom:1px
dotted
#999999;}\r\nabbr.initialism{font-size:90%;text-transform:uppercase;}\r\n\r\nq:before,q:after,blockquote:before,blockquote:after{content:"";}\r\naddress{display:block;margin-bottom:20px;font-style:normal;line-height:20px;}\r\n\r\ntable{max-width:100%;background-color:transparent;border-collapse:collapse;border-spacing:0;}\r\n.table{width:100%;margin-bottom:20px;}.table
th,.table
td{padding:8px;line-height:20px;text-align:left;vertical-align:top;border-top:1px
solid #dddddd;}\r\n.table th{font-weight:bold;}\r\n.table thead
th{vertical-align:bottom;}\r\n.table caption+thead tr:first-child th,.table
caption+thead tr:first-child td,.table colgroup+thead tr:first-child
th,.table colgroup+thead tr:first-child td,.table thead:first-child
tr:first-child th,.table thead:first-child tr:first-child
td{border-top:0;}\r\n.table tbody+tbody{border-top:2px solid
#dddddd;}\r\n.table .table{background-color:#ffffff;}\r\n.table-condensed
th,.table-condensed td{padding:4px 5px;}\r\n.table-bordered{border:1px
solid
#dddddd;border-collapse:separate;*border-collapse:collapse;border-left:0;-webkit-border-radius:4px;-moz-border-radius:4px;border-radius:4px;}.table-bordered
th,.table-bordered td{border-left:1px solid #dddddd;}\r\n.table-bordered
caption+thead tr:first-child th,.table-bordered caption+tbody
tr:first-child th,.table-bordered caption+tbody tr:first-child
td,.table-bordered colgroup+thead tr:first-child th,.table-bordered
colgroup+tbody tr:first-child th,.table-bordered colgroup+tbody
tr:first-child td,.table-bordered thead:first-child tr:first-child
th,.table-bordered tbody:first-child tr:first-child th,.table-bordered
tbody:first-child tr:first-child td{border-top:0;}\r\n.table-bordered
thead:first-child tr:first-child>th:first-child,.table-bordered
tbody:first-child tr:first-child>td:first-child,.table-bordered
tbody:first-child
tr:first-child>th:first-child{-webkit-border-top-left-radius:4px;-moz-border-radius-topleft:4px;border-top-left-radius:4px;}\r\n.table-bordered
thead:first-child tr:first-child>th:last-child,.table-bordered
tbody:first-child tr:first-child>td:last-child,.table-bordered
tbody:first-child
tr:first-child>th:last-child{-webkit-border-top-right-radius:4px;-moz-border-radius-topright:4px;border-top-right-radius:4px;}\r\n.table-bordered
thead:last-child tr:last-child>th:first-child,.table-bordered
tbody:last-child tr:last-child>td:first-child,.table-bordered
tbody:last-child tr:last-child>th:first-child,.table-bordered
tfoot:last-child tr:last-child>td:first-child,.table-bordered
tfoot:last-child
tr:last-child>th:first-child{-webkit-border-bottom-left-radius:4px;-moz-border-radius-bottomleft:4px;border-bottom-left-radius:4px;}\r\n.table-bordered
thead:last-child tr:last-child>th:last-child,.table-bordered
tbody:last-child tr:last-child>td:last-child,.table-bordered
tbody:last-child tr:last-child>th:last-child,.table-bordered
tfoot:last-child tr:last-child>td:last-child,.table-bordered
tfoot:last-child
tr:last-child>th:last-child{-webkit-border-bottom-right-radius:4px;-moz-border-radius-bottomright:4px;border-bottom-right-radius:4px;}\r\n.table-bordered
tfoot+tbody:last-child tr:last-child
td:first-child{-webkit-border-bottom-left-radius:0;-moz-border-radius-bottomleft:0;border-bottom-left-radius:0;}\r\n.table-bordered
tfoot+tbody:last-child tr:last-child
td:last-child{-webkit-border-bottom-right-radius:0;-moz-border-radius-bottomright:0;border-bottom-right-radius:0;}\r\n.table-bordered
caption+thead tr:first-child th:first-child,.table-bordered caption+tbody
tr:first-child td:first-child,.table-bordered colgroup+thead tr:first-child
th:first-child,.table-bordered colgroup+tbody tr:first-child
td:first-child{-webkit-border-top-left-radius:4px;-moz-border-radius-topleft:4px;border-top-left-radius:4px;}\r\n.table-bordered
caption+thead tr:first-child th:last-child,.table-bordered caption+tbody
tr:first-child td:last-child,.table-bordered colgroup+thead tr:first-child
th:last-child,.table-bordered colgroup+tbody tr:first-child
td:last-child{-webkit-border-top-right-radius:4px;-moz-border-radius-topright:4px;border-top-right-radius:4px;}\r\n.table-striped
tbody>tr:nth-child(odd)>td,.table-striped
tbody>tr:nth-child(odd)>th{background-color:#f9f9f9;}\r\n.table-hover
tbody tr:hover>td,.table-hover tbody
tr:hover>th{background-color:#f5f5f5;}\r\ntable
td[class*="span"],table th[class*="span"],.row-fluid
table td[class*="span"],.row-fluid table
th[class*="span"]{display:table-cell;float:none;margin-left:0;}\r\n.table
td.span1,.table th.span1{float:none;width:44px;margin-left:0;}\r\n.table
td.span2,.table th.span2{float:none;width:124px;margin-left:0;}\r\n.table
td.span3,.table th.span3{float:none;width:204px;margin-left:0;}\r\n.table
td.span4,.table th.span4{float:none;width:284px;margin-left:0;}\r\n.table
td.span5,.table th.span5{float:none;width:364px;margin-left:0;}\r\n.table
td.span6,.table th.span6{float:none;width:444px;margin-left:0;}\r\n.table
td.span7,.table th.span7{float:none;width:524px;margin-left:0;}\r\n.table
td.span8,.table th.span8{float:none;width:604px;margin-left:0;}\r\n.table
td.span9,.table th.span9{float:none;width:684px;margin-left:0;}\r\n.table
td.span10,.table th.span10{float:none;width:764px;margin-left:0;}\r\n.table
td.span11,.table th.span11{float:none;width:844px;margin-left:0;}\r\n.table
td.span12,.table th.span12{float:none;width:924px;margin-left:0;}\r\n.table
tbody tr.success>td{background-color:#dff0d8;}\r\n.table tbody
tr.error>td{background-color:#f2dede;}\r\n.table tbody
tr.warning>td{background-color:#fcf8e3;}\r\n.table tbody
tr.info>td{background-color:#d9edf7;}\r\n.table-hover tbody
tr.success:hover>td{background-color:#d0e9c6;}\r\n.table-hover tbody
tr.error:hover>td{background-color:#ebcccc;}\r\n.table-hover tbody
tr.warning:hover>td{background-color:#faf2cc;}\r\n.table-hover tbody
tr.info:hover>td{background-color:#c4e3f3;}\r\n\r\n.well{min-height:20px;padding:19px;margin-bottom:20px;background-color:#f5f5f5;border:1px
solid
#e3e3e3;-webkit-border-radius:4px;-moz-border-radius:4px;border-radius:4px;-webkit-box-shadow:inset
0 1px 1px rgba(0, 0, 0, 0.05);-moz-box-shadow:inset 0 1px 1px rgba(0, 0, 0,
0.05);box-shadow:inset 0 1px 1px rgba(0, 0, 0, 0.05);}.well
blockquote{border-color:#ddd;border-color:rgba(0, 0, 0,
0.15);}\r\n.well-large{padding:24px;-webkit-border-radius:6px;-moz-border-radius:6px;border-radius:6px;}\r\n.well-small{padding:9px;-webkit-border-radius:3px;-moz-border-radius:3px;border-radius:3px;}\r\n\r\ntable.dl-table
td{line-height:20px;}\r\ntd.invoice_label{text-align:right;font-weight:bold;\r\nwidth:120px;
padding-right:20px;line-height:20px;}', '<div
style="font-family:Helvetica; font-size:12px;"  >\r\n 
<table width="100%">\r\n    <tr>\r\n      <td
width="50%"  valign="top"><img
src="http://www.joomlathat.com/images/joomlathat3.png"
/><br />\r\n        <br />\r\n        <table
class="dl-table">\r\n          <tr>\r\n           
<td class="invoice_label"
valign="top">From</td>\r\n            <td
valign="top"><strong>{from_name}</strong></td>\r\n
         </tr>\r\n          <tr>\r\n            <td
class="invoice_label"
valign="top">Address</td>\r\n            <td
valign="top"><address>\r\n             
{from_address}\r\n              </address></td>\r\n         
</tr>\r\n          <tr>\r\n            <td
class="invoice_label"
valign="top">e-mail</td>\r\n            <td
valign="top">{from_email}</td>\r\n         
</tr>\r\n          <tr>\r\n            <td
class="invoice_label" valign="top">Fiscal
number</td>\r\n            <td
valign="top">{from_num}</td>\r\n         
</tr>\r\n        </table></td>\r\n      <td
width="50%"  valign="top"><div class="well
well-small">\r\n          <table
class="dl-table">\r\n            <tr>\r\n             
<td class="invoice_label" valign="top">Invoice
number</td>\r\n              <td
valign="top">{invoice_num}</td>\r\n           
</tr>\r\n            <tr>\r\n              <td
class="invoice_label" valign="top">Invoice
date</td>\r\n              <td
valign="top">{invoice_date}</td>\r\n           
</tr>\r\n            <tr>\r\n              <td
class="invoice_label" valign="top">Due
date</td>\r\n              <td
valign="top">{invoice_duedate}</td>\r\n           
</tr>\r\n            <tr>\r\n              <td
class="invoice_label" valign="top">Invoice
total</td>\r\n              <td
valign="top">{total}</td>\r\n            </tr>\r\n
           <tr>\r\n              <td
class="invoice_label"
valign="top">Status</td>\r\n              <td
valign="top">{status}</td>\r\n           
</tr>\r\n          </table>\r\n        </div>\r\n       
<div class="well well-small">\r\n          <table
class="dl-table">\r\n            <tr>\r\n             
<td class="invoice_label" valign="top">Bill
to</td>\r\n              <td
valign="top"><strong>{to_name}</strong></td>\r\n
           </tr>\r\n            <tr>\r\n              <td
class="invoice_label"
valign="top">Address</td>\r\n              <td
valign="top"><address>\r\n                {to_company}
<br />\r\n                {to_address} <br />\r\n              
 {to_zipcode} {to_city} <br />\r\n                {to_state}
{to_country}\r\n                </address></td>\r\n           
</tr>\r\n            <tr>\r\n              <td
class="invoice_label"
valign="top">e-mail</td>\r\n              <td
valign="top">{to_email}</td>\r\n           
</tr>\r\n            <tr>\r\n              <td
class="invoice_label" valign="top">VAT
ID</td>\r\n              <td
valign="top">{to_vatid}</td>\r\n           
</tr>\r\n            <tr>\r\n              <td
class="invoice_label"
valign="top">Phone</td>\r\n              <td
valign="top">{to_phone}</td>\r\n           
</tr>\r\n          </table>\r\n       
</div></td>\r\n    </tr>\r\n  </table>\r\n  <h2
class="invoice_header">Items</h2>\r\n  <table
width="100%" class="table table-striped"   >\r\n   
<thead>\r\n      <tr>\r\n        <th
align="left">SKU</th>\r\n        <th
align="left">Description</th>\r\n        <th
align="right" style="text-align:right;">Unit
cost</th>\r\n        <th align="right"
style="text-align:right;">Quantity</th>\r\n       
<th align="right"
style="text-align:right;">Discount</th>\r\n       
<th align="right"
style="text-align:right;">Tax</th>\r\n        <th
align="right"
style="text-align:right;">Price</th>\r\n     
</tr>\r\n    </thead>\r\n    <tbody>\r\n    \r\n   
{items}\r\n    </tbody>\r\n    \r\n    <tfoot>\r\n     
<tr>\r\n        <td colspan="4"></td>\r\n      
 <td colspan="2" align="right"
style="text-align:right;">Discount</td>\r\n       
<td align="right"
style="text-align:right;">{discount}</td>\r\n     
</tr>\r\n      <tr>\r\n        <td
colspan="4"></td>\r\n        <td
colspan="2" align="right"
style="text-align:right;">Subtotal</td>\r\n       
<td align="right"
style="text-align:right;">{subtotal}</td>\r\n     
</tr>\r\n    {taxes}\r\n    <tr>\r\n      <td
colspan="4"></td>\r\n      <td colspan="2"
align="right"
style="text-align:right;"><strong>Total</strong></td>\r\n
     <td align="right"
style="text-align:right;"><strong>{total}</strong></td>\r\n
   </tr>\r\n    </tfoot>\r\n    \r\n  </table>\r\n 
<h2 class="invoice_header">Payments received</h2>\r\n
 <table width="100%" class="table table-striped "
style="table-layout:fixed;" >\r\n    <thead>\r\n     
<tr>\r\n        <th align="left">Payment
date</th>\r\n        <th
align="left">Description</th>\r\n        <th
align="left">Status</th>\r\n        <th
align="left"></th>\r\n        <th
align="right"
style="text-align:right;">Amount</th>\r\n     
</tr>\r\n    </thead>\r\n    <tbody>\r\n    \r\n   
{payments}\r\n    </tbody>\r\n    \r\n    <tfoot>\r\n     
<tr>\r\n        <td ></td>\r\n        <td
></td>\r\n        <td ></td>\r\n        <td
align="right"
style="text-align:right;"><strong>Total amount
paid</strong></td>\r\n        <td align="right"
style="text-align:right;"><strong>{total_payments}</strong></td>\r\n
     </tr>\r\n    </tfoot>\r\n  </table>\r\n  <h2
class="invoice_header">Pending payments</h2>\r\n 
<table width="100%" class="table table-striped
table-hover" style="table-layout:fixed;">\r\n   
<thead>\r\n      <tr>\r\n        <th
align="left">Due date</th>\r\n        <th
align="left">Description</th>\r\n        <th
align="left">Status</th>\r\n        <th
align="left"></th>\r\n        <th
align="right"
style="text-align:right;">Amount</th>\r\n     
</tr>\r\n    </thead>\r\n    <tbody>\r\n    \r\n   
{payments2}\r\n    </tbody>\r\n    \r\n    <tfoot>\r\n     
<tr>\r\n        <td ></td>\r\n        <td
></td>\r\n        <td ></td>\r\n        <td
align="right"
style="text-align:right;"><strong>Amount
outstanding</strong></td>\r\n        <td
align="right"
style="text-align:right;"><strong>{amount_outstanding}</strong></td>\r\n
     </tr>\r\n    </tfoot>\r\n  </table>\r\n  <div
style="padding:2px;">Notes</div>\r\n  <div
style="border-top:1px solid #000; padding:2px; "
class="muted"><small>{notes}</small></div>\r\n</div>'),
(NULL, 'Quote (Bootstrap)', '<div
style="font-family:Helvetica;"  >\r\n  <div
class="row-fluid">\r\n    <div class="span6">
<img src="http://www.joomlathat.com/images/joomlathat3.png"
/><br />\r\n      <br />\r\n      <dl
class="dl-horizontal">\r\n       
<dt>From</dt>\r\n        <dd>
<strong>{from_name}</strong> </dd>\r\n       
<dt>Address</dt>\r\n        <dd>\r\n         
<address>\r\n          {from_address}\r\n         
</address>\r\n        </dd>\r\n       
<dt>e-mail</dt>\r\n        <dd> {from_email}
</dd>\r\n        <dt>Fiscal number</dt>\r\n       
<dd> {from_num} </dd>\r\n      </dl>\r\n   
</div>\r\n    <div class="span6">\r\n      <div
class="well well-small">\r\n        <dl
class="dl-horizontal">\r\n          <dt>Quote
number</dt>\r\n          <dd>{invoice_num}</dd>\r\n      
   <dt>Quote date</dt>\r\n         
<dd>{invoice_date}</dd>\r\n          <dt>Due
date</dt>\r\n          <dd>{invoice_duedate}</dd>\r\n    
     <dt>Quote total</dt>\r\n         
<dd>{total}</dd>\r\n          <dt>Status</dt>\r\n  
       <dd>{status}</dd>\r\n        </dl>\r\n     
</div>\r\n      <div class="well well-small">\r\n    
   <dl class="dl-horizontal">\r\n          <dt>Bill
to</dt>\r\n          <dd>
<strong>{to_name}</strong> </dd>\r\n         
<dt>Address</dt>\r\n          <dd>\r\n           
<address>\r\n            {to_company} <br />\r\n           
{to_address} <br />\r\n            {to_zipcode} {to_city} <br
/>\r\n            {to_state} {to_country}\r\n           
</address>\r\n          </dd>\r\n         
<dt>e-mail</dt>\r\n         
<dd>{to_email}</dd>\r\n          <dt>VAT
ID</dt>\r\n          <dd>{to_vatid}</dd>\r\n         
<dt>Phone</dt>\r\n          <dd>{to_phone}</dd>\r\n
       </dl>\r\n      </div>\r\n    </div>\r\n 
</div>\r\n  <h2
class="invoice_header">Items</h2>\r\n  <table
width="100%" class="table table-striped"   >\r\n   
<thead>\r\n      <tr>\r\n        <th
align="left">SKU</th>\r\n        <th
align="left">Description</th>\r\n        <th
align="right" style="text-align:right;">Unit
cost</th>\r\n        <th align="right"
style="text-align:right;">Quantity</th>\r\n       
<th align="right"
style="text-align:right;">Discount</th>\r\n       
<th align="right"
style="text-align:right;">Tax</th>\r\n        <th
align="right"
style="text-align:right;">Price</th>\r\n     
</tr>\r\n    </thead>\r\n    <tbody>\r\n    \r\n   
{items}\r\n    </tbody>\r\n    \r\n    <tfoot>\r\n     
<tr>\r\n        <td colspan="4"></td>\r\n      
 <td colspan="2" align="right"
style="text-align:right;">Discount</td>\r\n       
<td align="right"
style="text-align:right;">{discount}</td>\r\n     
</tr>\r\n      <tr>\r\n        <td
colspan="4"></td>\r\n        <td
colspan="2" align="right"
style="text-align:right;">Subtotal</td>\r\n       
<td align="right"
style="text-align:right;">{subtotal}</td>\r\n     
</tr>\r\n    {taxes}\r\n    <tr>\r\n      <td
colspan="4"></td>\r\n      <td colspan="2"
align="right"
style="text-align:right;"><strong>Total</strong></td>\r\n
     <td align="right"
style="text-align:right;"><strong>{total}</strong></td>\r\n
   </tr>\r\n    </tfoot>\r\n    \r\n  </table>\r\n  \r\n 
<div style="padding:2px;">Notes</div>\r\n  <div
style="border-top:1px solid #000; padding:2px; "
class="muted"><small>{notes}</small></div>\r\n</div>',
'<tr>\r\n<td>{sku}</td>\r\n<td><strong>{name}</strong><br
/>{desc}</td>\r\n<td align="right"
style="text-align:right;">{value}</td>\r\n<td
align="right"
style="text-align:right;">{amount}</td>\r\n<td
align="right"
style="text-align:right;">{discount}</td>\r\n<td
align="right"
style="text-align:right;">{tax}</td>\r\n<td
align="right"
style="text-align:right;">{item_total}</td>\r\n</tr>',
'<tr>\r\n<td colspan="4"></td>\r\n<td
colspan="2" align="right"
style="text-align:right;">{name}</td>\r\n<td
align="right"
style="text-align:right;">{value}</td>\r\n</tr>',
'', '',
'.clearfix{*zoom:1;}.clearfix:before,.clearfix:after{display:table;content:"";line-height:0;}\r\n.clearfix:after{clear:both;}\r\n.hide-text{font:0/0
a;color:transparent;text-shadow:none;background-color:transparent;border:0;}\r\n\r\ndl{margin-bottom:20px;}\r\ndt,dd{line-height:20px;}\r\ndt{font-weight:bold;}\r\ndd{margin-left:10px;}\r\n.dl-horizontal{*zoom:1;}.dl-horizontal:before,.dl-horizontal:after{display:table;content:"";line-height:0;}\r\n.dl-horizontal:after{clear:both;}\r\n.dl-horizontal
dt{float:left;width:120px;clear:left;text-align:right;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;}\r\n.dl-horizontal
dd{margin-left:140px;}\r\nhr{margin:20px 0;border:0;border-top:1px solid
#eeeeee;border-bottom:1px solid
#ffffff;}\r\nabbr[title],abbr[data-original-title]{cursor:help;border-bottom:1px
dotted
#999999;}\r\nabbr.initialism{font-size:90%;text-transform:uppercase;}\r\n\r\nq:before,q:after,blockquote:before,blockquote:after{content:"";}\r\naddress{display:block;margin-bottom:20px;font-style:normal;line-height:20px;}\r\n\r\ntable{max-width:100%;background-color:transparent;border-collapse:collapse;border-spacing:0;}\r\n.table{width:100%;margin-bottom:20px;}.table
th,.table
td{padding:8px;line-height:20px;text-align:left;vertical-align:top;border-top:1px
solid #dddddd;}\r\n.table th{font-weight:bold;}\r\n.table thead
th{vertical-align:bottom;}\r\n.table caption+thead tr:first-child th,.table
caption+thead tr:first-child td,.table colgroup+thead tr:first-child
th,.table colgroup+thead tr:first-child td,.table thead:first-child
tr:first-child th,.table thead:first-child tr:first-child
td{border-top:0;}\r\n.table tbody+tbody{border-top:2px solid
#dddddd;}\r\n.table .table{background-color:#ffffff;}\r\n.table-condensed
th,.table-condensed td{padding:4px 5px;}\r\n.table-bordered{border:1px
solid
#dddddd;border-collapse:separate;*border-collapse:collapse;border-left:0;-webkit-border-radius:4px;-moz-border-radius:4px;border-radius:4px;}.table-bordered
th,.table-bordered td{border-left:1px solid #dddddd;}\r\n.table-bordered
caption+thead tr:first-child th,.table-bordered caption+tbody
tr:first-child th,.table-bordered caption+tbody tr:first-child
td,.table-bordered colgroup+thead tr:first-child th,.table-bordered
colgroup+tbody tr:first-child th,.table-bordered colgroup+tbody
tr:first-child td,.table-bordered thead:first-child tr:first-child
th,.table-bordered tbody:first-child tr:first-child th,.table-bordered
tbody:first-child tr:first-child td{border-top:0;}\r\n.table-bordered
thead:first-child tr:first-child>th:first-child,.table-bordered
tbody:first-child tr:first-child>td:first-child,.table-bordered
tbody:first-child
tr:first-child>th:first-child{-webkit-border-top-left-radius:4px;-moz-border-radius-topleft:4px;border-top-left-radius:4px;}\r\n.table-bordered
thead:first-child tr:first-child>th:last-child,.table-bordered
tbody:first-child tr:first-child>td:last-child,.table-bordered
tbody:first-child
tr:first-child>th:last-child{-webkit-border-top-right-radius:4px;-moz-border-radius-topright:4px;border-top-right-radius:4px;}\r\n.table-bordered
thead:last-child tr:last-child>th:first-child,.table-bordered
tbody:last-child tr:last-child>td:first-child,.table-bordered
tbody:last-child tr:last-child>th:first-child,.table-bordered
tfoot:last-child tr:last-child>td:first-child,.table-bordered
tfoot:last-child
tr:last-child>th:first-child{-webkit-border-bottom-left-radius:4px;-moz-border-radius-bottomleft:4px;border-bottom-left-radius:4px;}\r\n.table-bordered
thead:last-child tr:last-child>th:last-child,.table-bordered
tbody:last-child tr:last-child>td:last-child,.table-bordered
tbody:last-child tr:last-child>th:last-child,.table-bordered
tfoot:last-child tr:last-child>td:last-child,.table-bordered
tfoot:last-child
tr:last-child>th:last-child{-webkit-border-bottom-right-radius:4px;-moz-border-radius-bottomright:4px;border-bottom-right-radius:4px;}\r\n.table-bordered
tfoot+tbody:last-child tr:last-child
td:first-child{-webkit-border-bottom-left-radius:0;-moz-border-radius-bottomleft:0;border-bottom-left-radius:0;}\r\n.table-bordered
tfoot+tbody:last-child tr:last-child
td:last-child{-webkit-border-bottom-right-radius:0;-moz-border-radius-bottomright:0;border-bottom-right-radius:0;}\r\n.table-bordered
caption+thead tr:first-child th:first-child,.table-bordered caption+tbody
tr:first-child td:first-child,.table-bordered colgroup+thead tr:first-child
th:first-child,.table-bordered colgroup+tbody tr:first-child
td:first-child{-webkit-border-top-left-radius:4px;-moz-border-radius-topleft:4px;border-top-left-radius:4px;}\r\n.table-bordered
caption+thead tr:first-child th:last-child,.table-bordered caption+tbody
tr:first-child td:last-child,.table-bordered colgroup+thead tr:first-child
th:last-child,.table-bordered colgroup+tbody tr:first-child
td:last-child{-webkit-border-top-right-radius:4px;-moz-border-radius-topright:4px;border-top-right-radius:4px;}\r\n.table-striped
tbody>tr:nth-child(odd)>td,.table-striped
tbody>tr:nth-child(odd)>th{background-color:#f9f9f9;}\r\n.table-hover
tbody tr:hover>td,.table-hover tbody
tr:hover>th{background-color:#f5f5f5;}\r\ntable
td[class*="span"],table th[class*="span"],.row-fluid
table td[class*="span"],.row-fluid table
th[class*="span"]{display:table-cell;float:none;margin-left:0;}\r\n.table
td.span1,.table th.span1{float:none;width:44px;margin-left:0;}\r\n.table
td.span2,.table th.span2{float:none;width:124px;margin-left:0;}\r\n.table
td.span3,.table th.span3{float:none;width:204px;margin-left:0;}\r\n.table
td.span4,.table th.span4{float:none;width:284px;margin-left:0;}\r\n.table
td.span5,.table th.span5{float:none;width:364px;margin-left:0;}\r\n.table
td.span6,.table th.span6{float:none;width:444px;margin-left:0;}\r\n.table
td.span7,.table th.span7{float:none;width:524px;margin-left:0;}\r\n.table
td.span8,.table th.span8{float:none;width:604px;margin-left:0;}\r\n.table
td.span9,.table th.span9{float:none;width:684px;margin-left:0;}\r\n.table
td.span10,.table th.span10{float:none;width:764px;margin-left:0;}\r\n.table
td.span11,.table th.span11{float:none;width:844px;margin-left:0;}\r\n.table
td.span12,.table th.span12{float:none;width:924px;margin-left:0;}\r\n.table
tbody tr.success>td{background-color:#dff0d8;}\r\n.table tbody
tr.error>td{background-color:#f2dede;}\r\n.table tbody
tr.warning>td{background-color:#fcf8e3;}\r\n.table tbody
tr.info>td{background-color:#d9edf7;}\r\n.table-hover tbody
tr.success:hover>td{background-color:#d0e9c6;}\r\n.table-hover tbody
tr.error:hover>td{background-color:#ebcccc;}\r\n.table-hover tbody
tr.warning:hover>td{background-color:#faf2cc;}\r\n.table-hover tbody
tr.info:hover>td{background-color:#c4e3f3;}\r\n\r\n.well{min-height:20px;padding:19px;margin-bottom:20px;background-color:#f5f5f5;border:1px
solid
#e3e3e3;-webkit-border-radius:4px;-moz-border-radius:4px;border-radius:4px;-webkit-box-shadow:inset
0 1px 1px rgba(0, 0, 0, 0.05);-moz-box-shadow:inset 0 1px 1px rgba(0, 0, 0,
0.05);box-shadow:inset 0 1px 1px rgba(0, 0, 0, 0.05);}.well
blockquote{border-color:#ddd;border-color:rgba(0, 0, 0,
0.15);}\r\n.well-large{padding:24px;-webkit-border-radius:6px;-moz-border-radius:6px;border-radius:6px;}\r\n.well-small{padding:9px;-webkit-border-radius:3px;-moz-border-radius:3px;border-radius:3px;}\r\n\r\ntable.dl-table
td{line-height:20px;}\r\ntd.invoice_label{text-align:right;font-weight:bold;\r\nwidth:120px;
padding-right:20px;line-height:20px;}', '<div
style="font-family:Helvetica; font-size:12px;"  >\r\n 
<table width="100%">\r\n    <tr>\r\n      <td
width="50%"  valign="top"><img
src="http://www.joomlathat.com/images/joomlathat3.png"
/><br />\r\n        <br />\r\n        <table
class="dl-table">\r\n          <tr>\r\n           
<td class="invoice_label"
valign="top">From</td>\r\n            <td
valign="top"><strong>{from_name}</strong></td>\r\n
         </tr>\r\n          <tr>\r\n            <td
class="invoice_label"
valign="top">Address</td>\r\n            <td
valign="top"><address>\r\n             
{from_address}\r\n              </address></td>\r\n         
</tr>\r\n          <tr>\r\n            <td
class="invoice_label"
valign="top">e-mail</td>\r\n            <td
valign="top">{from_email}</td>\r\n         
</tr>\r\n          <tr>\r\n            <td
class="invoice_label" valign="top">Fiscal
number</td>\r\n            <td
valign="top">{from_num}</td>\r\n         
</tr>\r\n        </table></td>\r\n      <td
width="50%"  valign="top"><div class="well
well-small">\r\n          <table
class="dl-table">\r\n            <tr>\r\n             
<td class="invoice_label" valign="top">Quote
number</td>\r\n              <td
valign="top">{invoice_num}</td>\r\n           
</tr>\r\n            <tr>\r\n              <td
class="invoice_label" valign="top">Quote
date</td>\r\n              <td
valign="top">{invoice_date}</td>\r\n           
</tr>\r\n            <tr>\r\n              <td
class="invoice_label" valign="top">Due
date</td>\r\n              <td
valign="top">{invoice_duedate}</td>\r\n           
</tr>\r\n            <tr>\r\n              <td
class="invoice_label" valign="top">Quote
total</td>\r\n              <td
valign="top">{total}</td>\r\n            </tr>\r\n
           <tr>\r\n              <td
class="invoice_label"
valign="top">Status</td>\r\n              <td
valign="top">{status}</td>\r\n           
</tr>\r\n          </table>\r\n        </div>\r\n       
<div class="well well-small">\r\n          <table
class="dl-table">\r\n            <tr>\r\n             
<td class="invoice_label" valign="top">Bill
to</td>\r\n              <td
valign="top"><strong>{to_name}</strong></td>\r\n
           </tr>\r\n            <tr>\r\n              <td
class="invoice_label"
valign="top">Address</td>\r\n              <td
valign="top"><address>\r\n                {to_company}
<br />\r\n                {to_address} <br />\r\n              
 {to_zipcode} {to_city} <br />\r\n                {to_state}
{to_country}\r\n                </address></td>\r\n           
</tr>\r\n            <tr>\r\n              <td
class="invoice_label"
valign="top">e-mail</td>\r\n              <td
valign="top">{to_email}</td>\r\n           
</tr>\r\n            <tr>\r\n              <td
class="invoice_label" valign="top">VAT
ID</td>\r\n              <td
valign="top">{to_vatid}</td>\r\n           
</tr>\r\n            <tr>\r\n              <td
class="invoice_label"
valign="top">Phone</td>\r\n              <td
valign="top">{to_phone}</td>\r\n           
</tr>\r\n          </table>\r\n       
</div></td>\r\n    </tr>\r\n  </table>\r\n  <h2
class="invoice_header">Items</h2>\r\n  <table
width="100%" class="table table-striped"   >\r\n   
<thead>\r\n      <tr>\r\n        <th
align="left">SKU</th>\r\n        <th
align="left">Description</th>\r\n        <th
align="right" style="text-align:right;">Unit
cost</th>\r\n        <th align="right"
style="text-align:right;">Quantity</th>\r\n       
<th align="right"
style="text-align:right;">Discount</th>\r\n       
<th align="right"
style="text-align:right;">Tax</th>\r\n        <th
align="right"
style="text-align:right;">Price</th>\r\n     
</tr>\r\n    </thead>\r\n    <tbody>\r\n    \r\n   
{items}\r\n    </tbody>\r\n    \r\n    <tfoot>\r\n     
<tr>\r\n        <td colspan="4"></td>\r\n      
 <td colspan="2" align="right"
style="text-align:right;">Discount</td>\r\n       
<td align="right"
style="text-align:right;">{discount}</td>\r\n     
</tr>\r\n      <tr>\r\n        <td
colspan="4"></td>\r\n        <td
colspan="2" align="right"
style="text-align:right;">Subtotal</td>\r\n       
<td align="right"
style="text-align:right;">{subtotal}</td>\r\n     
</tr>\r\n    {taxes}\r\n    <tr>\r\n      <td
colspan="4"></td>\r\n      <td colspan="2"
align="right"
style="text-align:right;"><strong>Total</strong></td>\r\n
     <td align="right"
style="text-align:right;"><strong>{total}</strong></td>\r\n
   </tr>\r\n    </tfoot>\r\n    \r\n  </table>\r\n  \r\n 
<div style="padding:2px;">Notes</div>\r\n  <div
style="border-top:1px solid #000; padding:2px; "
class="muted"><small>{notes}</small></div>\r\n</div>');