equotix / logic-invoice

User-friendly, powerful and feature rich accounting & invoicing solution.

Logic Invoice

Logic Invoice is an open source accounting and invoicing solution built with PHP. For more information, visit http://www.logicinvoice.com

Requirements

1. PHP 5.3 and above
2. MySQL database
3. Linux / Windows web server (Apache preferred)

Installation Instructions

1. Upload all the files INSIDE the 'upload' folder onto your web server.
2. Ensure the following folders are writable (0755 or 0777)
   • /
   • /admin/
   • /system/cache/
3. On your preferred web browser, load the application (www.your-website.com/)
4. Follow the installation instructions to complete the installation
5. Upon completing installation, set up a cron job to trigger admin/cron.php hourly / daily.
6. To use SEO URLs, rename .htaccess.txt to .htaccess (remove .txt extension)

Documentation

For more information on installation and administration, do use our documentation. Documentation is available at http://docs.logicinvoice.com.

Running with docker

WARNING: USE ONLY FOR DEVELOPMENT.

docker-compose up -d

MySQL hostname: database MySQL database: database MySQL user: root MySQL password: helloworld123

Reporting Bugs

Please report bugs through github.

Security

We take security very seriously at Logic Invoice. If you discover any major security flaw, please contact us directly and do not disclose publicly until the issue has been resolved.

License

Licensed under the GNU General Public License Version 3; you may not use this work except in compliance with the License. You may obtain a copy of the license in the LICENSE file.

logic-invoice's Issues

Update invoice status not sending email / adding history

http://forum.logicinvoice.com/viewtopic.php?f=4&t=434

Top Bar and H1 Text Overlaps On Scroll

The top bar will overlap the H1 text when you scroll down the page the first time the site loads. If you navigate to another page and scroll, you see that the top bar is solid and you won't be able to see your H1 text below it. Going back to the home page, the problem is resolved.

Ticket extension

Can I install this ticket extension to Logic? Thanks.

Fatal error: Class 'Registry' not found in /app/admin/index.php

Getting this error
Fatal error: Class 'Registry' not found in /app/admin/index.php on line 32
$loader = new Loader($registry);

The Quotation display

Its bugs of the quotation display with: payment_firstname, payment_lastname, payment_company, payment_address_1, payment_address_2, payment_city, payment_postcode, payment_country, payment_zone, payment_name, payment_description in:

application/view/theme/default/template/account/quotation_view.tpl
application/view/theme/default/template/account/quotation_quotation.tpl
application/controller/account/quotation.php

Mail Function Not Working

No mail notification is working even the new user registration details and forgot password mail. Kindly give details how to set up mail.

Error Installing

Hello,
Just tried installing getting a JSON error, please see image

Email template

Hello,

the mails i get are wrong and links dont work :/

[{Pro Clan servers}] New Recurring Payment #{1}
Hi {Matteo},
Recurring payment #{1} was recently added to your account with the following details:
Cycle: {Quarterly}
Status: {Enabled}
Recurring Payment ID: {1}
Total: {€40.00}
Date Added: {03/09/2015}
Date Due: {12/11/2015}
You can view all your recurring payments by clicking here.
Regards,
{Pro Clan servers}

any idea please?

thank you.

Inline updating for inventory

http://forum.logicinvoice.com/viewtopic.php?f=8&t=444

Translated to portuguese language

I translate the system version 1.1.1 into portuguese language. Interested contact me.

Admin Users

Admin users not listed. The following error logs were found:

PHP Notice:  Error: Unknown column 'u.name' in 'field list'<br />Error No: 1054<br />SELECT *, u.name AS name, ug.name AS user_group FROM `jbtpd_user` u LEFT JOIN jbtpd_user_group ug ON ug.user_group_id = u.user_group_id ORDER BY username ASC LIMIT 0,20 in C:\wamp\www\system\library\database\mysqli.php on line 40
PHP Notice:  Trying to get property of non-object in C:\wamp\www\admin\model\system\user.php on line 92
PHP Warning:  Invalid argument supplied for foreach() in C:\wamp\www\admin\controller\system\user.php on line 61

Logic Invoice Installation

Http 404 Error After Uploading Logic Invoice Apache working Fine

Erro Log - cron job

Ever that cron job is run appear these errors:
I don't know if is just with me, and believe that be important resolve.

2016-11-10 10:20:01 - PHP Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /system/startup.php:59) in /system/library/session.php on line 12
2016-11-10 10:20:01 - PHP Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /system/startup.php:59) in /system/library/session.php on line 12
2016-11-10 10:20:01 - PHP Warning: Cannot modify header information - headers already sent by (output started at /system/startup.php:59) in /admin/cron.php on line 174
2016-11-10 10:20:01 - PHP Notice: Undefined index: directory in /admin/cron.php on line 180
2016-11-10 10:20:01 - PHP Warning: Cannot modify header information - headers already sent by (output started at /system/startup.php:59) in /system/library/currency.php on line 45
2016-11-10 10:20:01 - PHP Fatal Error: Undefined index: SERVER_PORT in /system/startup.php on line 59

Combine the Back-end and Front-end language files

Hi,

Wouuw, beautiful software. Works like a charm.

Is it posible to combine the admin and user language files. That is easier to translate. Now there are double translations rows. For example $_['text_biennally'] we have to translate it in the back-end en front-end.

Double work... I don't like double work :-/

Best regards
Ocean

Text editor image manager

http://forum.logicinvoice.com/viewtopic.php?f=4&t=526

Can not login

after a successful installation, the system keeps sending me back to the login page with correct credentials. With wrong credentials I get the login page with an error message as expected.
If I disable the preactions Login and Permission checks I can see the dashboard.
I could not find the code to redirect to the dashboard after a successful authentication.
Any Help?

The Quantity of Products is not getting reduced from the Inventory

Hello There,

if we add few items in Invoice and save it, the inventory is not getting updated and quantity is not getting reduced with the added quantity in a invoice.

Blank page after submitting Invoice

Hi,
when i am creating an invoice and click on save, the response is blank. Can you please tell me what might be the issue.

Email Template text placeholders

Hi, I am new to Logic Invoice, and upon setup, have found that when emails are generated, the shortcodes aren't functioning properly.

What seems to be the case is where { } is used, the system doesn't acknowledge the brackets { }, instead just the word.

For example, if I created a new customer with the following credentials,
Name: Pear Shaped
Password: Banana2016

the email reads:
"
Welcome to {My Company}

 Hi {Pear Shaped},

 Welcome to {My Company}. You may login to your account by clicking here.

 Your Banana2016 is {Banana2016}.

 Regards,
 {My Company}

"
• Notice how all the { } are still in place, and where it should say Your password is Banana2016, the system has seen the work 'password' and replaced it with Your Banana2016 is {Banana2016}

Wrong Icon For Add Language

The icon for Add should be fa-plus but fa-save was used instead.

File path: admin/view/template/system/language_list.tpl

Incorrect recurring report

Reported here: http://forum.logicinvoice.com/viewtopic.php?f=5&t=462

Logic Invoice is dead?

Logic Invoice is dead?

Bug: model/billing/invoice.php : Do not show invoice

A small bug in admin/model/billing/invoice.php

line 153 shall be:
$query = $this->db->query("SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, ( SELECT name FROM " . DB_PREFIX . "status s WHERE s.status_id = i.status_id AND s.language_id = " . (int)$this->config->get('config_language_id') . ") AS status FROM " . DB_PREFIX . "invoice i LEFT JOIN " . DB_PREFIX . "customer c ON c.customer_id = i.customer_id WHERE invoice_id = '" . (int)$invoice_id . "'");

other wise sub sql ( DB_PREFIX_status )returns to many fields in multi lang setups !

Installation does not check for GD

I think this check should be included, as the admin breaks if GD is not enabled.

entery confiramtion issue

When we update any entry like invoice, general entry its not showing updated and coming back to page.
it not displaying any message after submitting.

incorrect function being used

http://forum.logicinvoice.com/viewtopic.php?f=5&t=428

in_array error

http://forum.logicinvoice.com/viewtopic.php?f=5&t=454

URL aliases are not deleted

The URL Alises are not deleted when deleting an article or a blog post.
I believe the problem is in admin/model/content/blog_category.php in deleteBlogCategory function, and admin/model/content/article.php in deleteArticle function.

The pagination is not working

Chart of Accounts did not updated

The Chart of Accounts report did not updated after I created a record of Journal Entries, you can see this issue on your demo page.

Illegal string offset

PHP Warning: Illegal string offset 'article_id' in C:\wamp\www\admin\view\template\content\article_form.tpl on line 81
PHP Warning: Illegal string offset 'title' in C:\wamp\www\admin\view\template\content\article_form.tpl on line 81

Quotation does not link to Journal Entries

I can not get link from Quotation to Journal Entries.

Customer ID doesn't change if customer from Select edited/erased

When you create an invoice, and enter a customer name, the input fetches the customers in Database.
Which is then using jquery put into a hidden field "Customer_ID" in invoice form.

So in case user decides he wants to create a new customer from the form, he erases the selected customer name from customer field, but the customer_ID is retained in the hidden input field.

This can be fixed by adding the following code in the invoice_form.tpl to remove the old fetched customer ID in the customer_id input field.

Edit:
Since the model actually checks Email field when figuring out whether to add new customer or not, I have updated the code to remove the value from the email input field as well, otherwise there is no point in just removing the value from customer_id.

$("#input-customer").bind("change paste keyup", function() {
   $('input[name=\'customer_id\']').val('');
   $('input[name=\'email\']').val('');

});

multiple undefined index errors

2015-06-23 7:12:44 - PHP Notice: Undefined variable: customer_id in application/model/billing/customer.php on line 49
2015-06-23 7:12:44 - PHP Notice: Undefined index: customer_id in application/model/billing/customer.php on line 56
2015-06-23 7:12:44 - PHP Notice: Undefined index: firstname in application/model/billing/customer.php on line 57
2015-06-23 7:12:44 - PHP Notice: Undefined index: lastname in application/model/billing/customer.php on line 58
2015-06-23 7:12:44 - PHP Notice: Undefined index: company in application/model/billing/customer.php on line 59
2015-06-23 7:12:44 - PHP Notice: Undefined index: website in application/model/billing/customer.php on line 60
2015-06-23 7:12:44 - PHP Notice: Undefined index: email in application/model/billing/customer.php on line 61
2015-06-23 7:12:44 - PHP Notice: Undefined index: status in application/model/billing/customer.php on line 62
2015-06-23 7:12:44 - PHP Notice: Undefined index: customer_id in application/model/billing/customer.php on line 71
2015-06-23 7:12:44 - PHP Notice: Undefined index: firstname in application/model/billing/customer.php on line 72
2015-06-23 7:12:44 - PHP Notice: Undefined index: lastname in application/model/billing/customer.php on line 73
2015-06-23 7:12:44 - PHP Notice: Undefined index: company in application/model/billing/customer.php on line 74
2015-06-23 7:12:44 - PHP Notice: Undefined index: website in application/model/billing/customer.php on line 75
2015-06-23 7:12:44 - PHP Notice: Undefined index: email in application/model/billing/customer.php on line 76
2015-06-23 7:12:44 - PHP Notice: Undefined index: status in application/model/billing/customer.php on line 77
2015-06-23 7:12:44 - PHP Notice: Undefined index: email in application/model/billing/customer.php on line 78

BUG invoice with multi lang

There is a error in admin/model/billing/invoice.php / application/model/billing/invoice.php in line 144 there is no check for multilang setup in the sub SQL so the should look like this:

$sql = "SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, (SELECT name FROM " . DB_PREFIX . "status s WHERE s.status_id = i.status_id AND s.language_id = " . (int)$this->config->get('config_language_id') . ") AS status FROM " . DB_PREFIX . "invoice i LEFT JOIN " . DB_PREFIX . "customer c ON c.customer_id = i.customer_id WHERE i.invoice_id = '" . (int)$invoice_id . "' AND i.status_id > 0";

insted
with: AND s.language_id = " . (int)$this->config->get('config_language_id') . " added

Undefined index

PHP Notice: Undefined index: transaction_accounts in C:\wamp\www\admin\controller\accounting\journal.php on line 393
PHP Warning: Invalid argument supplied for foreach() in C:\wamp\www\admin\controller\accounting\journal.php on line 393

Pagination not Working..!!!

Hi,

Pagination is not working front end side after active SEO URL.

Thank you.. :)

Cant select from Select Dropdown

Hi , this is fantastic app .
there are some bugs like while i select customer from customer dropdown while creating invoice , it shows dropdown but when i click on it , it doesnt work.
The selection is not working

Installer Assets Issues ++ Running full SSL everywhere

Do you have plans to allow full SSL everywhere? I have done some work with OC and OC2 regarding this. The most annoying part is the installer and trying to use forced SSL + HSTS...it blocks all the assets for the page(s). I don't wanna start on a mod/pull if you guys are already working on it, but if not, lemme know

New language refresh

So today I was translating this awesome invoice system my local language and found out that after I change the language in setting changes are not instantly visible. I had to delete cookies to see changes. I tried to find where is the problem in code but I haven't any luck so maybe somebody else can find it.

Issues with Journal Entries

No matter how you try to track your expenses or deposits I always get
"Debit and credit needs to be equal."

If this is the case, then you would never be able to track money going and and out.

Need Grouping

Common Grouping of customers,users and products as per branch or common branch or company

Quotation does not save to database

I add new Quotation but it does not save the information to database (Version 1.3.0a).

Undefined index

Reported by Waleed M

2016-07-31 12:08:47 - PHP Notice: Undefined index: directory in /home/htdocs/admin/model/system/language.php on line 92

How to integrate Opencart. It supplies whitepage in Opencart when try to export data from Opencart Module of Logic Invoice.

@logic Invoice Team
How to integrate Opencart. It supplies whitepage in Opencart 2.1.0.2 when try to export data from Opencart Module of Logic Invoice.

Missing items catalog for invoices

Stumbled on this piece of software recently and decided to give it a try. I can say that it's looking promising, but there are few things missing.
Currently there is no catalog for invoice items, eg. products, services, etc.
It's kind of annoying to always type the same text and prices for several invoices if the items is the same for all of them.

Transaction error

PHP Notice: Undefined index: transaction_accounts in C:\wamp\www\admin\model\accounting\transaction.php on line 10
PHP Warning: Invalid argument supplied for foreach() in C:\wamp\www\admin\model\accounting\transaction.php on line 10

Bug Change Theme

I can not change the theme, after the change in administration the site remains in default theme in logicinvoice 1.1.1 .
How to solve?

Fatal error: Call to undefined function imagecreatefrompng() in C:\Apache24\htdocs\LogicInvoice2\system\library\image.php on line 32

Hi
i have successfully installed LogicInvoice and able to login from admin page. but while opening settings, i am getting error. Please help me out to resolve the issue.

Fatal error: Call to undefined function imagecreatefrompng() in C:\Apache24\htdocs\LogicInvoice2\system\library\image.php on line 32

undefined index status

2015-06-22 8:44:20 - PHP Notice: Undefined index: status in admin/model/billing/invoice.php on line 12