UPDATE `hb_configuration` SET `value` = '4.9.6' WHERE `setting`= 'Version'; ########## ALTER TABLE `hb_invoices` CHANGE `status` `status` ENUM( 'Paid', 'Unpaid', 'Cancelled', 'Draft', 'Recurring', 'Refunded', 'Creditnote' ) NOT NULL; ########## REPLACE INTO `hb_language_locales` (`language_id`,`section`,`keyword`,`value`) SELECT id, 'global', 'creditnote','Credit Note' FROM hb_language UNION SELECT id, 'global', 'Creditnote','Credit Note' FROM hb_language UNION SELECT id, 'global', 'Creditnotes','Credit Notes' FROM hb_language UNION SELECT id, 'global', 'creditnote_date','Date issued' FROM hb_language UNION SELECT id, 'global', 'related_invoice','Related invoice' FROM hb_language UNION SELECT id, 'configuration', 'CNoteNumerationFormat','Credit note numeration format' FROM hb_language WHERE target!='user' UNION SELECT id, 'configuration', 'CNoteNumerationFrom', 'Next credit note number' FROM hb_language WHERE target!='user'; ########## CREATE TABLE `hb_creditnotes` ( `invoice_id` int(11) NOT NULL, `credit_note_id` int(11) NOT NULL, `invoice_item_id` int(11) NOT NULL DEFAULT '0', `credit_item_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`invoice_id`,`credit_note_id`,`invoice_item_id`), KEY `credit_item_id` (`credit_item_id`) ) ENGINE=InnoDB; ########## ALTER TABLE `hb_templates` CHANGE `target` `target` ENUM( 'admin', 'user', 'invoice', 'estimate', 'creditnote' ) NOT NULL; ########## INSERT INTO `hb_templates` ( `id` , `parent_id` , `name` , `target` , `created` , `updated` ) VALUES ( NULL , 0, 'Default', 'creditnote', NOW( ) , NOW( ) ); ########## INSERT INTO `hb_template_content` (`id`, `template_id`, `name`, `content`, `checksum`, `updated`) SELECT NULL, `id`, 'Default', '\r\n

\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n

{$companylogo} {$invoice.number}

\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n

{$lang.creditnote}	{$invoice.id}
{$lang.creditnote_date}	{$invoice.date}

\r\n

{$lang.invoice_to}
{$client.companyname}
{$client.firstname} {$client.lastname}
{$client.address1}
{$client.address2}
{$client.city}, {$client.state}{$client.postcode}
{$client.country}

{$lang.invoice_from}
HostBill Demo

\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n

{$lang.balance}:

{$transbalance}

\r\n

\r\n{$lang.related_invoice} {$invoice.related_invoice_number} {$lang.from} {$invoice.related_invoice_date}\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n

{$lang.invoice_desc}	{$lang.invoice_tax}	{$lang.unitcost}	{$lang.qty}	{$lang.price}
{$item.description}	{$item.taxed}	{$item.amount}	{$item.qty}	{$item.linetotal}
	{$lang.subtotal}		{$invoice.subtotal}
	{$lang.tax} ({$invoice.taxrate}%)		{$invoice.tax}
	{$lang.tax} ({$invoice.taxrate2}%)		{$invoice.tax2}
	{$lang.total}		{$invoice.total}

\r\n\r\n\r\n\r\n\r\n\r\n\r\n

{$invoice.notes}

\r\n\r\n\r\n\r\n\r\n\r\n\r\n

Invoice footer text

\r\n

', '93fc76301bc84500e071b1b69a73f098',NOW() FROM `hb_templates` WHERE `name`='Default' AND `target`='creditnote'; ########## REPLACE INTO hb_configuration (`setting`, `value`) SELECT 'CNoteTemplate', `id` FROM `hb_templates` WHERE `name`='Default' AND `target`='creditnote'; ########## REPLACE INTO hb_configuration (`setting`, `value`) SELECT 'CNoteTemplate', `id` FROM `hb_templates` WHERE `name`='Default' AND `target`='creditnote'; ########## REPLACE INTO `hb_configuration` (`setting`, `value`) VALUES ('CnoteEnable', 'off'), ('CNoteNumerationPaid', '1'), ('CNoteNumerationFormat', '{$number}/{$y}'); ########## INSERT INTO `hb_email_templates` (`id`, `tplname`, `group`, `for`, `language_id`, `subject`, `message`, `send`, `plain`, `system`, `hidden`) VALUES (NULL, 'CreditNote:New', 'Invoice', 'Client', 1, 'New Credit Note Created', 'Dear {$client.firstname} {$client.lastname}, \r\n\r\nCredit Note #{$invoice.id} \r\nAMOUNT: {$invoice.total|price:$currency}\r\nGENERATED ON: {$invoice.date|dateformat:$date_format}.\r\n\r\nItems\r\n{foreach from=$invoiceitems item=item}\r\n {$item.description} {if $item.qty}{$item.qty} x {/if}{$item.amount|price:$currency}\r\n{/foreach}\r\n\r\n', 1, 1, 1, 0); ########## ALTER TABLE `hb_client_activity_log` ADD COLUMN `admin_id` INT(11) NOT NULL DEFAULT '0' AFTER `client_id`, ADD COLUMN `admin_name` VARCHAR(50) NOT NULL DEFAULT '' AFTER `admin_id`, ADD COLUMN `event` VARCHAR(100) NOT NULL DEFAULT '' AFTER `admin_name`; ########## ALTER TABLE `hb_order_log` ADD COLUMN `type` VARCHAR(100) NOT NULL DEFAULT '' AFTER `date`;