Файловый менеджер

Файловый менеджер - Редактировать - /home/lmsyaran/public_html/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>', '', '');

| ver. 1.4 | Github | . | PHP 8.1.33 | Генерация страницы: 0 | proxy | phpinfo | Настройка