:~Spade Mini Shell~:

Spade
Mini Shell
Directory:~$ /home/lmsyaran/www/administrator/components/com_invoices/sql/updates/
Current File:~$ /home/lmsyaran/www/administrator/components/com_invoices/sql/updates/1.2.0.sql
ALTER TABLE  `#__invoices_contacts` ADD  `city` varchar(255) NOT NULL,
  ADD `state` varchar(255) NOT NULL,
  ADD `country` varchar(255) NOT NULL,
  ADD `vatid` varchar(255) NOT NULL,
  ADD `zipcode` varchar(255) NOT NULL ;

ALTER TABLE  `#__invoices_invoices` ADD  `discount` decimal(10,2) NOT NULL,
  ADD `invoice_duedate` datetime NOT NULL,
  ADD `admin_notes` text NOT NULL,
  ADD `to_city` varchar(255) NOT NULL,
  ADD `to_state` varchar(255) NOT NULL,
  ADD `to_country` varchar(255) NOT NULL,
  ADD `to_vatid` varchar(255) NOT NULL,
  ADD `to_zipcode` varchar(255) NOT NULL,
  ADD `rec_year` int(3) NOT NULL,
  ADD `rec_month` int(3) NOT NULL,
  ADD `rec_day` int(3) NOT NULL,
  ADD `rec_nextdate` date NOT NULL,
  ADD `is_recurrent` tinyint(1) NOT NULL ;

ALTER TABLE  `#__invoices_items` ADD  `discount` decimal(10,2) NOT NULL,
  ADD `ordering` int(11) NOT NULL ;

ALTER TABLE  `#__invoices_payments` ADD  `ordering` int(11) NOT NULL ;

ALTER TABLE  `#__invoices_taxes` ADD  `ordering` int(11) NOT NULL ;

ALTER TABLE  `#__invoices_templates` ADD  `payments2` text NOT NULL ;


INSERT INTO `#__invoices_templates` ( `name`, `content`, `items`, `taxes`,
`payments`, `payments2`) VALUES
( 'Default', '<table width="690"
style="width:690px; font-family:Helvetica;font-size:11px;" 
>\r\n  <tr>\r\n    <td valign="top"
style="vertical-align:top;"><img
src="http://www.joomlafinances.com/components/com_invoices/assets/images/logo.png"
/><br />\r\n      <br />\r\n     
<strong>{from_name}</strong> <br />\r\n     
{from_address} <br />\r\n      <br />\r\n      E-mail:
{from_email} <br />\r\n      Phone: {from_phone} <br />\r\n    
 Fiscal number: {from_num} </td>\r\n    <td valign="top"
style="vertical-align:top;" width="200"><div
style="background:#000; color:#FFF; padding:2px;">INVOICE
INFO</div>\r\n      <div style="border:1px solid #000;
padding:2px; border-top:none;">\r\n        <table>\r\n       
  <tr>\r\n            <td>Date: </td>\r\n           
<td>{invoice_date}</td>\r\n          </tr>\r\n         
<tr>\r\n            <td>Invoice number: </td>\r\n        
   <td>{invoice_num}</td>\r\n          </tr>\r\n       
</table>\r\n      </div>\r\n      <br />\r\n      <div
style="background:#000; color:#FFF; padding:2px;">BILL
TO</div>\r\n      <div style="border:1px solid #000;
padding:2px; border-top:none;">
<strong>{to_name}</strong> <br />\r\n        {to_company}
<br />\r\n        {to_address} <br />\r\n        {to_zipcode}
{to_city} <br />\r\n        {to_state} {to_country} <br />\r\n 
      <br />\r\n        VAT ID: {to_vatid}<br />\r\n       
E-mail: {to_email} <br />\r\n      </div></td>\r\n 
</tr>\r\n  <tr>\r\n    <td colspan="2"><br
/></td>\r\n  </tr>\r\n  <tr>\r\n    <td
colspan="2"><div style="background:#000; color:#FFF;
padding:2px;">ITEMS</div>\r\n      <div
style="border:1px solid #000; padding:2px;
border-top:none;">\r\n        <table width="100%" 
>\r\n          <tr>\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;">Price</th>\r\n         
</tr>\r\n          <tr >\r\n            <th
colspan="5"><hr /></th>\r\n         
</tr>\r\n          {items}\r\n          <tr >\r\n           
<td colspan="5"><hr /></td>\r\n         
</tr>\r\n          <tfoot>\r\n            <tr>\r\n       
      <td colspan="2"></td>\r\n              <td
colspan="2">Discount</td>\r\n              <td
align="right"
style="text-align:right;">{discount}</td>\r\n           
</tr>\r\n            <tr>\r\n              <td
colspan="2"></td>\r\n              <td
colspan="2">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="2"></td>\r\n            <td
colspan="3"><hr /></td>\r\n         
</tr>\r\n          <tr>\r\n            <td
colspan="2"></td>\r\n            <td
colspan="2"><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      </div></td>\r\n  </tr>\r\n 
<tr>\r\n    <td colspan="2"><br
/></td>\r\n  </tr>\r\n  <tr>\r\n    <td
colspan="2"><div style="background:#000; color:#FFF;
padding:2px;">PAYMENTS RECEIVED</div>\r\n      <div
style="border:1px solid #000; padding:2px;
border-top:none;">\r\n        <table width="100%" 
>\r\n          <tr>\r\n            <th
align="left">Payment date</th>\r\n            <th
align="left">Description</th>\r\n            <th
align="right"
style="text-align:right;">Amount</th>\r\n         
</tr>\r\n          <tr >\r\n            <th
colspan="3"><hr /></th>\r\n         
</tr>\r\n          {payments}\r\n          <tr >\r\n           
<td colspan="3"><hr /></td>\r\n         
</tr>\r\n          <tfoot>\r\n           \r\n           
<tr>\r\n              <td ></td>\r\n              <td
><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            \r\n          </tfoot>\r\n     
  </table>\r\n       \r\n      </div></td>\r\n 
</tr>\r\n  <tr>\r\n    <td colspan="2"><br
/></td>\r\n  </tr>\r\n  <tr>\r\n    <td
colspan="2"><div style="background:#000; color:#FFF;
padding:2px;">PENDING PAYMENTS</div>\r\n      <div
style="border:1px solid #000; padding:2px;
border-top:none;">\r\n        \r\n        <table
width="100%"  >\r\n          <tr>\r\n            <th
align="left">Due date</th>\r\n            <th
align="left">Description</th>\r\n            <th
align="left"></th>\r\n            <th
align="right"
style="text-align:right;">Amount</th>\r\n         
</tr>\r\n          <tr >\r\n            <th
colspan="4"><hr /></th>\r\n         
</tr>\r\n          {payments2}\r\n          <tr >\r\n          
 <td colspan="4"><hr /></td>\r\n         
</tr>\r\n          <tfoot>\r\n            \r\n           
<tr>\r\n              <td ></td>\r\n              <td
></td>\r\n              <td ><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        \r\n      </div></td>\r\n 
</tr>\r\n  <tr>\r\n    <td colspan="2"><br
/></td>\r\n  </tr>\r\n  <tr>\r\n    <td
colspan="2"><div
style="padding:2px;">Notes</div>\r\n      <div
style="border-top:1px solid #000; padding:2px;
">{notes}</div></td>\r\n 
</tr>\r\n</table>',
'<tr><td>\r\n<strong>{name}</strong><br
/>{desc}\r\n</td>\r\n<td align="right"
style="text-align:right;">\r\n{value}\r\n</td>\r\n<td
align="right"
style="text-align:right;">\r\n{amount}\r\n</td>\r\n<td
align="right"
style="text-align:right;">\r\n{discount}\r\n</td>\r\n<td
align="right"
style="text-align:right;">\r\n{item_total}\r\n</td>\r\n</tr>',
'<tr>\r\n<td colspan="2"></td>\r\n<td
colspan="2">{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 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<a
href="{payment_link}">Pay
now</a>\r\n</td>\r\n<td align="right"
style="text-align:right;">\r\n{amount}\r\n</td>\r\n</tr>'),
( 'Default (without payments)', '<table
width="690" style="width:690px; font-family:Helvetica;"
 >\r\n  <tr>\r\n    <td valign="top"
style="vertical-align:top;"><img
src="http://www.joomlafinances.com/components/com_invoices/assets/images/logo.png"
/><br />\r\n      <br />\r\n     
<strong>{from_name}</strong> <br />\r\n     
{from_address} <br />\r\n      <br />\r\n      E-mail:
{from_email} <br />\r\n      Phone: {from_phone} <br />\r\n    
 Fiscal number: {from_num} </td>\r\n    <td valign="top"
style="vertical-align:top;" width="200"><div
style="background:#000; color:#FFF; padding:2px;">INVOICE
INFO</div>\r\n      <div style="border:1px solid #000;
padding:2px; border-top:none;">\r\n        <table>\r\n       
  <tr>\r\n            <td>Date: </td>\r\n           
<td>{invoice_date}</td>\r\n          </tr>\r\n         
<tr>\r\n            <td>Invoice number: </td>\r\n        
   <td>{invoice_num}</td>\r\n          </tr>\r\n       
</table>\r\n      </div>\r\n      <br />\r\n      <div
style="background:#000; color:#FFF; padding:2px;">BILL
TO</div>\r\n      <div style="border:1px solid #000;
padding:2px; border-top:none;">
<strong>{to_name}</strong> <br />\r\n        {to_company}
<br />\r\n        {to_address} <br />\r\n        {to_zipcode}
{to_city} <br />\r\n        {to_state} {to_country} <br />\r\n 
      <br />\r\n        VAT ID: {to_vatid}<br />\r\n       
E-mail: {to_email} <br />\r\n      </div></td>\r\n 
</tr>\r\n  <tr>\r\n    <td colspan="2"><br
/></td>\r\n  </tr>\r\n  <tr>\r\n    <td
colspan="2"><div style="background:#000; color:#FFF;
padding:2px;">ITEMS</div>\r\n      <div
style="border:1px solid #000; padding:2px;
border-top:none;">\r\n        <table width="100%" 
>\r\n          <tr>\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;">Price</th>\r\n         
</tr>\r\n          <tr >\r\n            <th
colspan="5"><hr /></th>\r\n         
</tr>\r\n          {items}\r\n          <tr >\r\n           
<td colspan="5"><hr /></td>\r\n         
</tr>\r\n          <tfoot>\r\n            <tr>\r\n       
      <td colspan="2"></td>\r\n              <td
colspan="2">Discount</td>\r\n              <td
align="right"
style="text-align:right;">{discount}</td>\r\n           
</tr>\r\n            <tr>\r\n              <td
colspan="2"></td>\r\n              <td
colspan="2">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="2"></td>\r\n            <td
colspan="3"><hr /></td>\r\n         
</tr>\r\n          <tr>\r\n            <td
colspan="2"></td>\r\n            <td
colspan="2"><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      </div></td>\r\n  </tr>\r\n  \r\n 
<tr>\r\n    <td colspan="2"><br
/></td>\r\n  </tr>\r\n  <tr>\r\n    <td
colspan="2"><div
style="padding:2px;">Notes</div>\r\n      <div
style="border-top:1px solid #000; padding:2px;
">{notes}</div></td>\r\n 
</tr>\r\n</table>',
'<tr><td>\r\n<strong>{name}</strong><br
/>{desc}\r\n</td>\r\n<td align="right"
style="text-align:right;">\r\n{value}\r\n</td>\r\n<td
align="right"
style="text-align:right;">\r\n{amount}\r\n</td>\r\n<td
align="right"
style="text-align:right;">\r\n{discount}\r\n</td>\r\n<td
align="right"
style="text-align:right;">\r\n{item_total}\r\n</td>\r\n</tr>',
'<tr>\r\n<td colspan="2"></td>\r\n<td
colspan="2">{name}</td>\r\n<td
align="right"
style="text-align:right;">{value}</td>\r\n</tr>',
'', '');