Coder Social home page Coder Social logo

baimard / gestion Goto Github PK

View Code? Open in Web Editor NEW
69.0 69.0 9.0 61.66 MB

Home Page: https://baimard.github.io/gestion

License: GNU Affero General Public License v3.0

Makefile 0.59% PHP 16.79% Less 0.12% JavaScript 81.85% CSS 0.32% Shell 0.34%
apps nextcloud

gestion's Introduction

Hi there 👋 I'm Benjamin
I do open source code, for a better world 😄

I am a cybersecurity consultant (which means everything and saying nothing), also specializing in nothing and bad in everything.
🔭 I’m currently working on simple company management system.

baimard Issues


gestion's People

Contributors

baimard avatar dependabot[bot] avatar nextcloud-bot avatar rakekniven avatar roliverio avatar timkrief avatar valdnet avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

gestion's Issues

[EN] Items "Actions"

At a lower screen resolution, the "Action" elements for "Quote" and "Invoice" overlap.

  • Quote:

obraz

  • Invoice:

obraz

App:
Gestion 1.2.2

[EN] Bank account name and number

If the payment is made by transfer of a bank account, the invoice should contain information about the name and number of the company bank account to which the bank transfer for the sale or service is to be made.

[EN] accents in folder names

if we create a folder where its name has accents (PT-PT language) after configuring the folder where we keep "quote" and "invoice" documents, the name of the folders is automatically changed to an encoding other than UTF8-BOM.

If by chance we need to delete or rename the folder configured as the destination of the files before pointing to a new destination folder, nextcloud is in loading mode (possible timeout) and then copies of the folders are created with the original name

[FR]Modification informations entreprise

Bonjour Benjamin,

Tout d'abord, bravo pour le travail accompli !

J'ouvre cet issue car j'ai beau chercher, je ne trouve pas où modifier les informations de mon entreprise une fois la saisie initiale effectuée.

De quelle manière puis-je m'y prendre ?

Merci !

[EN] Joining strings together is evil

"info": t('gestion', 'Showing')+' _START_ '+t('gestion', 'to')+' _END_ '+t('gestion', 'of')+' _TOTAL_ ' + t('gestion', 'entries'),

please do not join single strings to a sentence.
The translator at Transifex does not know about it until he looks at the source code. Only a few do.

And the worst: in some language the order of a sentence is different e.g. in german the verbs are often at the end. In chinese they are placed nearly at the beginning.

Solution:
Use placeholders like the many other apps do.

[EN] Add button

Adding a new customer, quote, invoice and product should not be done by:

obraz

Only the path should be here.

Adding new items should be done through a separate button.

Apps:
Nextcloud 22.2.3
Gestion 1.2.0

[EN] Apps: add product bug

Apps:
Nextcloud 22.2.3
Gestion 1.2.0
PHP 8.0

Creating a Product under "Product" using "Add Product" this error appears:

"Error: Too few arguments to function OCA\Gestion\Db\Bdd::insertProduit(), 1 passed in /var/www/nextcloud/apps/gestion/lib/Controller/PageController.php on line 241 and exactly 3 expected"

with the pop-up [object Object]
No product can be added

Originally posted by @Norbert-D in #55 (comment)

[EN] Search

The test string "Search" must be placed in the dialog box:

obraz

After change:

obraz

App:
Gestion 1.2.2

Error in logs

After installing the application, it does not start. I am getting a server error message.

Logs:

Error	index	ParseError: syntax error, unexpected 'String' (T_STRING), expecting function (T_FUNCTION) or const (T_CONST)

    /home/xxx/public_html/xxx/lib/composer/composer/ClassLoader.php - line 346:

    Composer\Autoload\includeFile("/home/xxx/p ... p")

    <<closure>>

    Composer\Autoload\ClassLoader->loadClass("OCA\\Gestion\\Db\\Bdd")

    <<closure>>

    spl_autoload_call("OCA\\Gestion\\Db\\Bdd")

    /home/xxx/public_html/xxx/lib/private/AppFramework/Utility/SimpleContainer.php - line 112:

    ReflectionClass->__construct("OCA\\Gestion\\Db\\Bdd")

    /home/xxx/public_html/xxx/lib/private/AppFramework/Utility/SimpleContainer.php - line 131:

    OC\AppFramework\Utility\SimpleContainer->resolve("OCA\\Gestion\\Db\\Bdd")

    /home/xxx/public_html/xxx/lib/private/AppFramework/DependencyInjection/DIContainer.php - line 460:

    OC\AppFramework\Utility\SimpleContainer->query("OCA\\Gestion\\Db\\Bdd")

    /home/xxx/public_html/xxx/lib/private/AppFramework/DependencyInjection/DIContainer.php - line 432:

    OC\AppFramework\DependencyInjection\DIContainer->queryNoFallback("OCA\\Gestion\\Db\\Bdd")

    /home/xxx/public_html/xxx/lib/private/AppFramework/Utility/SimpleContainer.php - line 87:

    OC\AppFramework\DependencyInjection\DIContainer->query("OCA\\Gestion\\Db\\Bdd", true)

    <<closure>>

    OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}("*** sensiti ... *")

    /home/xxx/public_html/xxx/lib/private/AppFramework/Utility/SimpleContainer.php - line 106:

    array_map(Closure {}, [ Reflection ... }])

    /home/xxx/public_html/xxx/lib/private/AppFramework/Utility/SimpleContainer.php - line 114:

    OC\AppFramework\Utility\SimpleContainer->buildClass(ReflectionCl ... "})

    /home/xxx/public_html/xxx/lib/private/AppFramework/Utility/SimpleContainer.php - line 131:

    OC\AppFramework\Utility\SimpleContainer->resolve("OCA\\Gestio ... r")

    /home/xxx/public_html/xxx/lib/private/AppFramework/DependencyInjection/DIContainer.php - line 460:

    OC\AppFramework\Utility\SimpleContainer->query("OCA\\Gestio ... r")

    /home/xxx/public_html/xxx/lib/private/AppFramework/DependencyInjection/DIContainer.php - line 432:

    OC\AppFramework\DependencyInjection\DIContainer->queryNoFallback("OCA\\Gestio ... r")

    /home/xxx/public_html/xxx/lib/private/AppFramework/App.php - line 143:

    OC\AppFramework\DependencyInjection\DIContainer->query("OCA\\Gestio ... r")

    /home/xxx/public_html/xxx/lib/private/Route/Router.php - line 301:

    OC\AppFramework\App::main("OCA\\Gestio ... r", "index", OC\AppFramew ... {}, { _route: "gestion.page.index"})

    /home/xxx/public_html/xxx/lib/base.php - line 1000:

    OC\Route\Router->match("/apps/gestion/")

    /home/xxx/public_html/xxx/index.php - line 36:

    OC::handleRequest()

Apps:

Nextcloud 22.0.0
Gestion 1.0.4

[EN] Long data loading

In my opinion it is too long to load data to the proportion of data in the database:

obraz

If you switch to another application while loading data, you get an error:

obraz

App:
Gestion 1.2.2

[EN] Polish law for a VAT invoice

In Polish tax law, pursuant to Art. 106e of the VAT Act, the invoice should contain the following elements:

  • Date of issue,
  • Consecutive number of the invoice in accordance with the adopted numbering,
  • Names and surnames or the name of the seller and buyer of the goods / services and their addresses,
  • NIP number of the taxpayer (seller),
  • NIP number by means of which the buyer is identified for the purposes of tax or value added tax,
  • The date of the delivery or completion of the delivery of the goods or the performance of the service or the date of receipt of payment, if specified and different from the date of invoice,
  • Name of the product or service,
  • Measurement unit and quantity of goods or services sold,
  • Net unit price of a good or service,
  • The amount of any rebates, discounts and rebates,
  • Net sales value,
  • VAT rate and tax value,
  • The sum of net sales, broken down into values ​​subject to individual tax rates and tax-free sales,
  • VAT amounts broken down into individual rates,
  • Total amount receivable.

I provide details that relate to the Polish law on VAT invoices. It may be useful to adapt the application so that it is also compliant with Polish law 😉.

[FR] Erreur DB id → 'Not null violation' - PostgresSQL

Bonjour Benjamin,

Merci pour l'application et le temps que tu passes. Je viens de finir sa mise en route sur PostgresSQL.

Je te fait remonter l'erreur suivante 'Not null violation' → 'id'. lors de la création de l'entreprise (oc_gestion_configuration) ou d'un insert dans une autre table.

L'id ne peut pas être défini sur NULL pour les bases de donnés PostgresSQL, il doit être défini sur 0 pour s'incrémenter.

Dans le fichier lib → Db → Bdd.php,
J'ai remplacé : INSER INTO x ('id',... ) VALUES (NULL, ....); par INSER INTO x ('id',... ) VALUES (0, ....);

Log de l'erreur :
#Doctrine\DBAL\Exception\NotNullConstraintViolationException: An exception occurred while executing a query: SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "id" violates not-null constraint DETAIL: Failing row contains (null, Nom, Prénom, Siret, Société, Téléphone, Email, Adresse, User).

Je pense que ça va aider des utilisateurs 👍


Hello Benjamin,

Tks for your application. I tried to install with PostgresSql but there is a bug.

ID null return an error so :

  • I change in lib/Db/Bdd.php ID value in INSERT request to 0 :
    Like this : INSER INTO x ('id',... ) VALUES (NULL, ....); par INSER INTO x ('id',... ) VALUES (0, ....);

[EN] Application does not open in nextcloud 22.2.0

I installed the app from the Nextcloud app store. But it doesn't open for nothing.
In log file:

"Exception":"ParseError","Message":"syntax error, unexpected 'String' (T_STRING), expecting function (T_FUNCTION) or const (T_CONST)",
Apache: 2.4.38-3+deb10u6
OS: Debian 11
PHP: 7.3

[EN] Invoice number and VAT rate

Since the application is not working properly on my instance and I cannot test it well, I have a question regarding the invoice number and VAT rates.

  • I noticed that the invoice numbering order is not generated automatically. I suggest that you can set the initial invoice number and a fixed value to keep the numbering continuous. I mean, that this value of variable xxx would be generated automatically, while the constant value yyy was assigned by the user and did not change.

Examples:
xxx/yyy - 1/2021
xxx/yyy - 2/2021
xxx/yyy - 3/2021

  • The second thing I wanted to ask about is the VAT rate setting. Is it possible to set VAT rates in advance, so that when adding goods, you can select only the VAT rates that were previously determined?

The next thing is that in Polish tax law there is an additional VAT rate "exempt" from VAT. This is nothing but 0 VAT, but the goods must be sold and marked "exempt".

Is it possible to add such a VAT rate?

[EN] Translations not complete

I've installed gestion into my Nextcloud 22.2, which, besides of #41, went pretty well.

Since I can't speak French, I rely on the English translations. There are many places where the translations are missing though. It'd be great if the English translations get prioritized and improved.

Once the English translation is 100%, I could also contribute a German translation.

[FR] Erreur à l'installation

Bonjour Benjamin, tout d'abord merci de prendre du temps pour développer cette application qui j'en suis sur me seras utile !

Seulement j'ai un problème à l'installation. J'ai d'abord tenté une install depuis NX 21.0.4 via le gestionnaire d'application puis après une mise à jour vers NX 22.1.1 j'ai la même erreur, je tombe sur une page d'erreur interne de Nextcloud et voici le log de cette même erreur :

`Error index ParseError: syntax error, unexpected 'String' (T_STRING), expecting function (T_FUNCTION) or const (T_CONST)

/home/nextcloud/html/nextcloud/lib/composer/composer/ClassLoader.php - line 346:

Composer\Autoload\includeFile("/home/nextc ... p")

<<closure>>

Composer\Autoload\ClassLoader->loadClass("OCA\\Gestion\\Db\\Bdd")

<<closure>>

spl_autoload_call("OCA\\Gestion\\Db\\Bdd")

/home/nextcloud/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php - line 112:

ReflectionClass->__construct("OCA\\Gestion\\Db\\Bdd")

/home/nextcloud/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php - line 131:

OC\AppFramework\Utility\SimpleContainer->resolve("OCA\\Gestion\\Db\\Bdd")

/home/nextcloud/html/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php - line 460:

OC\AppFramework\Utility\SimpleContainer->query("OCA\\Gestion\\Db\\Bdd")

/home/nextcloud/html/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php - line 432:

OC\AppFramework\DependencyInjection\DIContainer->queryNoFallback("OCA\\Gestion\\Db\\Bdd")

/home/nextcloud/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php - line 87:

OC\AppFramework\DependencyInjection\DIContainer->query("OCA\\Gestion\\Db\\Bdd", true)

<<closure>>

OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}("*** sensiti ... *")

/home/nextcloud/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php - line 106:

array_map(Closure {}, [ Reflection ... "])

/home/nextcloud/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php - line 114:

OC\AppFramework\Utility\SimpleContainer->buildClass(ReflectionCl ... "})

/home/nextcloud/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php - line 131:

OC\AppFramework\Utility\SimpleContainer->resolve("OCA\\Gestio ... r")

/home/nextcloud/html/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php - line 460:

OC\AppFramework\Utility\SimpleContainer->query("OCA\\Gestio ... r")

/home/nextcloud/html/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php - line 432:

OC\AppFramework\DependencyInjection\DIContainer->queryNoFallback("OCA\\Gestio ... r")

/home/nextcloud/html/nextcloud/lib/private/AppFramework/App.php - line 143:

OC\AppFramework\DependencyInjection\DIContainer->query("OCA\\Gestio ... r")

/home/nextcloud/html/nextcloud/lib/private/Route/Router.php - line 301:

OC\AppFramework\App::main("OCA\\Gestio ... r", "index", OC\AppFramew ... {}, { _route: "gestion.page.index"})

/home/nextcloud/html/nextcloud/lib/base.php - line 1000:

OC\Route\Router->match("/apps/gestion/")

/home/nextcloud/html/nextcloud/index.php - line 36:

OC::handleRequest()`

Si tu as une piste de solution je suis preneur !

Merci !

  • Nextcloud 21.0.4 / 22.1.1
  • Apache2 2.4
  • PHP 7.3 fpm-mod
  • MariaDB 10.3.27
  • Debian 10

[EN] How to add a product in "Quote"

When creating a Quote, by adding a product, I receive the following information:

obraz

The product is added.

After refreshing the page, the product is added first in the list. The next time you click the "Add product" button, the above message is displayed again. The same product appears again after the page has been loaded.
My guess is that the window with the selection of products to add does not open for me.

obraz

Then, when removing a product in Quote, I get the following information:

obraz

Apps:
Nextcloud 22.2.3
Gestion 1.2.0

[EN] Internal server error

Hi,
I tried to install your app, however I get the following error (in the logging section):
`OCP\AppFramework\QueryException: Could not resolve OCA\Gestion\Controller\PageController! Class OCA\Gestion\Db\Bdd does not exist

/var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php - line 126:

OC\AppFramework\Utility\SimpleContainer->resolve("OCA\\Gestio ... r")

/var/www/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php - line 455:

OC\AppFramework\Utility\SimpleContainer->query("OCA\\Gestio ... r")

/var/www/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php - line 427:

OC\AppFramework\DependencyInjection\DIContainer->queryNoFallback("OCA\\Gestio ... r")

/var/www/nextcloud/lib/private/AppFramework/App.php - line 139:

OC\AppFramework\DependencyInjection\DIContainer->query("OCA\\Gestio ... r")

/var/www/nextcloud/lib/private/Route/Router.php - line 308:

OC\AppFramework\App::main("OCA\\Gestio ... r", "index", OC\AppFramew ... {}, { action: nu ... "})

/var/www/nextcloud/lib/base.php - line 1008:

OC\Route\Router->match("/apps/gestion/")

/var/www/nextcloud/index.php - line 37:

OC::handleRequest()`

I assume I am missing some dependences?

[EN] Darkmode unusable

I'm using Nextcloud 22.2. Everything seems to be working, but the Darkmode of gestion is not working properly. Most of the times, texts are rendered gray on white when Nextclouds Darkmode theme is enabled. I've attached some screenshots.
I'm a Darkmode user and would consider gestion unusable in this state.
grafik
grafik
grafik
grafik

[EN] Repeating the "Welcome to GESTION" window

When selecting from the side menu, for example: "Customer", "Quote", "Invoice" or "Product", the "Welcome to GESTION" window appears for a moment each time.

Apps:
Nextcloud 22.2.3
Gestion 1.2.0

[EN] Add a Pro-form

A request to add the possibility to create a Pro-form. It is a non-fiscal document that is sent to the customer for prepayment to the future invoice.

[EN] special characters in adress, product name etc

Hi,
I came across the following problem:
When I use characters such as german uml like auts, but also something like an é, it will turn up as its html representation.
Eg ä becomes ä and é becomes é
Also newlines are removed. Is there a way to fix this?

[EN] Change position in table

For information on the name of your company and the client, I suggest to replace the column positions in the table. It should say "First Name" first, then "Name". It is more structured for the user of the application.

Table for in your company settings:

obraz

Table for the client's company:

obraz

[FR] Facture électronique

Bonjour,

Sera-t-il possible de générer des factures au format électronique ? Il existe une norme européenne : le format Factur-X qui est une facture PDF classique contenant un fichier XML permettant le traitement comptable automatisé du document.

Etant donné que dès 2025 toute société française devra être capable de générer des factures électroniques, je pense que c'est une fonctionnalité intéressante à apporter.

impossible de lancer l'application Gestion - Erreur Interne du Serveur

Bonjour :)

crash de l'application au lancement
"Erreur interne du serveur"

Erreur interne du serveur

Le serveur est incapable d'exécuter votre requête.

Si cela se reproduit, veuillez envoyer les détails techniques ci-dessous à l'administrateur du serveur.

Le fichier journal du serveur peut fournir plus de renseignements.
Renseignements techniques

Adresse distante : x.y.z.z
ID de la demande : axL7GfnFlklFPkw93vIp

[index] Error: ParseError: syntax error, unexpected 'String' (T_STRING), expecting function (T_FUNCTION) or const (T_CONST) at <>

  1. /var/www/nextcloud/lib/composer/composer/ClassLoader.php line 346
    Composer\Autoload\includeFile("/var/www/nextcl ... p")
  2. <>
    Composer\Autoload\ClassLoader->loadClass("OCA\Gestion\Db\Bdd")
  3. <>
    spl_autoload_call("OCA\Gestion\Db\Bdd")
  4. /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php line 107
    ReflectionClass->__construct("OCA\Gestion\Db\Bdd")
  5. /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php line 126
    OC\AppFramework\Utility\SimpleContainer->resolve("OCA\Gestion\Db\Bdd")
  6. /var/www/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php line 459
    OC\AppFramework\Utility\SimpleContainer->query("OCA\Gestion\Db\Bdd")
  7. /var/www/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php line 431
    OC\AppFramework\DependencyInjection\DIContainer->queryNoFallback("OCA\Gestion\Db\Bdd")
  8. /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php line 87
    OC\AppFramework\DependencyInjection\DIContainer->query("OCA\Gestion\Db\Bdd", true)
  9. <>
    OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}("*** sensitive parameters replaced ***")
  10. /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php line 101
    array_map(Closure {}, [ReflectionParam ... }])
  11. /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php line 109
    OC\AppFramework\Utility\SimpleContainer->buildClass(ReflectionClass ... "})
  12. /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php line 126
    OC\AppFramework\Utility\SimpleContainer->resolve("OCA\Gestion\C ... r")
  13. /var/www/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php line 459
    OC\AppFramework\Utility\SimpleContainer->query("OCA\Gestion\C ... r")
  14. /var/www/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php line 431
    OC\AppFramework\DependencyInjection\DIContainer->queryNoFallback("OCA\Gestion\C ... r")
  15. /var/www/nextcloud/lib/private/AppFramework/App.php line 144
    OC\AppFramework\DependencyInjection\DIContainer->query("OCA\Gestion\C ... r")
  16. /var/www/nextcloud/lib/private/Route/Router.php line 302
    OC\AppFramework\App::main("OCA\Gestion\C ... r", "index", OC\AppFramework\ ... {}, {_route: "gestion.page.index"})
  17. /var/www/nextcloud/lib/base.php line 993
    OC\Route\Router->match("/apps/gestion/")
  18. /var/www/nextcloud/index.php line 37
    OC::handleRequest()

GET /apps/gestion/
from x.y.z.z by _adm_XYZ at 2021-07-30T17:55:18+00:00

Nextcloud 21.0.3
NGinx
PHP-FPM 7.3
MariaDB

Apps List:
Accessibility
1.7.0
Mises en avant
Activity
2.14.3
Mises en avant
Announcement center
5.0.0
Mises en avant
Antivirus for files
3.2.1
AppOrder
0.13.0
Audio Player
3.1.0
Audio Player - ID3 Editor (add-on)
0.3.0
Breeze Dark
21.0.9
Calendar
2.3.1
Circles
0.21.3
Collabora Online
4.2.1
Collabora Online - Built-in CODE Server
6.4.1004
Collaborative tags
1.11.0
Comments
1.11.0
Contacts
4.0.1
Contacts Interaction
1.2.0
Cookbook
0.8.4
Dashboard
7.1.0
Data Request
1.8.0
Deleted files
1.11.0
Draw.io
1.0.1
EPUB/CBZ/PDF ebook reader
1.4.6
External sites
3.8.2
Extract
1.3.2
Federation
1.11.0
File sharing
1.13.1
First run wizard
2.10.0
Gestion
1.0.4
Google integration
1.0.2
Group folders
9.0.2
Log Reader
2.6.0
Mail
1.10.2
Maps
0.1.9
Metadata
0.14.0
Monitoring
1.11.0
Nextcloud announcements
1.10.0
Notes
4.1.0
Notifications
2.9.0
PDF viewer
2.1.0
Photos
1.3.0
Plain text editor
2.14.0
Privacy
1.5.0
Ransomware protection
1.11.0
Recommendations
1.0.0
Registration
1.3.0
Right click
1.0.0
Share by mail
1.11.0
Splash
1.2.3
Support
1.4.0
Talk
11.3.1
Text
3.2.0
Theming
1.12.0
Two-Factor TOTP Provider
6.1.0
Update notification
1.11.0
Usage survey
1.9.0
User status
1.1.1
Versions
1.14.0
Video converter
1.0.2
Video player
1.10.0
Weather
1.7.5
Weather status
1.1.0

d'avance merci pour le retour
et merci aussi pour le projet Gestion ;)
FM

[EN] Add the VAT rate for the product

The products have a different VAT rate (this is the case in Poland).

I suggest that you can set different VAT rates in the application settings.
Then, when adding a product, you should add the VAT rate selection for the product.

obraz

Ability to add reductions and price drop or price increase

In some cases, I would like to be able to add a promotion for my invoices/quotes. For instance -20%, or -20€ on some products or on the total. Plus, some of the products are "services" and the cost in that case is not always the same based on the work, it would be useful to be able to override the price of a product in the invoice/quote.

Great progress

Great progress has been made in your invoicing app. In order for us to use it legally in Norway, consecutive numbering of Invoices (not quotations) should be implemented. Opportunity for more visibility to add different product to offers. Opportunity to set VAT percentage on product. Opportunity to add several types of VAT codes to the company. Then a coffee is served.

[EN] Quote does not save in NC Error in comment

Gestion V 1.2.2
NC V 22.0.3
PHP V 8.0

When trying to save a quote to the NC I get an error
"Error: An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'comment' at row 1
POST /index.php/apps/gestion/update"

The comment only has to words "billed quaterly"
I also deleted the comment and checked the DB same error

Question:
The Quote Number is a longtext and comment 255 is this correct on the DB

Detail log:
"app":"index","method":"POST","url":"/index.php/apps/gestion/update","message":"An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'comment' at row 1","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:94.0) Gecko/20100101 Firefox/94.0","version":"22.2.3.0","exception":{"Exception":"Doctrine\\DBAL\\Exception\\DriverException","Message":"An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'comment' at row 1","Code":1406,"Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1780,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1719,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Statement.php","line":193,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/PreparedStatement.php","line":87,"function":"execute","class":"Doctrine\\DBAL\\Statement","type":"->"},{"file":"/var/www/nextcloud/apps/gestion/lib/Db/Bdd.php","line":245,"function":"execute","class":"OC\\DB\\PreparedStatement","type":"->"},{"file":"/var/www/nextcloud/apps/gestion/lib/Db/Bdd.php","line":141,"function":"execSQLNoData","class":"OCA\\Gestion\\Db\\Bdd","type":"->"},{"file":"/var/www/nextcloud/apps/gestion/lib/Controller/PageController.php","line":264,"function":"gestion_update","class":"OCA\\Gestion\\Db\\Bdd","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":217,"function":"update","class":"OCA\\Gestion\\Controller\\PageController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":126,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":156,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":1006,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":114,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'comment' at row 1","Code":1406,"Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":94,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Statement.php","line":189,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/PreparedStatement.php","line":87,"function":"execute","class":"Doctrine\\DBAL\\Statement","type":"->"},{"file":"/var/www/nextcloud/apps/gestion/lib/Db/Bdd.php","line":245,"function":"execute","class":"OC\\DB\\PreparedStatement","type":"->"},{"file":"/var/www/nextcloud/apps/gestion/lib/Db/Bdd.php","line":141,"function":"execSQLNoData","class":"OCA\\Gestion\\Db\\Bdd","type":"->"},{"file":"/var/www/nextcloud/apps/gestion/lib/Controller/PageController.php","line":264,"function":"gestion_update","class":"OCA\\Gestion\\Db\\Bdd","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":217,"function":"update","class":"OCA\\Gestion\\Controller\\PageController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":126,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":156,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":1006,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":26,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'comment' at row 1","Code":"22001","Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":92,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Statement.php","line":189,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/PreparedStatement.php","line":87,"function":"execute","class":"Doctrine\\DBAL\\Statement","type":"->"},{"file":"/var/www/nextcloud/apps/gestion/lib/Db/Bdd.php","line":245,"function":"execute","class":"OC\\DB\\PreparedStatement","type":"->"},{"file":"/var/www/nextcloud/apps/gestion/lib/Db/Bdd.php","line":141,"function":"execSQLNoData","class":"OCA\\Gestion\\Db\\Bdd","type":"->"},{"file":"/var/www/nextcloud/apps/gestion/lib/Controller/PageController.php","line":264,"function":"gestion_update","class":"OCA\\Gestion\\Db\\Bdd","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":217,"function":"update","class":"OCA\\Gestion\\Controller\\PageController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":126,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":156,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":1006,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":92}},"CustomMessage":"--"},"id":"61a0e6e1864a6"}

[EN] Means of payment

I propose to add a selection of predefined means of payment so that when issuing an invoice, it is possible to quickly select a payment method:

obraz

[EN] Misspelled in French quote

Hi, thanks for making this app,
image
I think what is supposed to be written is "Par TimKrief" not "PARTTIMKRIEF". But the "PART" seems intentional, maybe I'm missing something and "PART" is used on quotes and bills, but it feels strange to me. Anyways, even in that case, a space seems to be missing.

[FR] Réécriture lien

Bonjour,

J'ai un problème de réécriture dans les liens avec votre application.

image
image

Tout les liens sont incorrects dans l'application.

Merci pour votre aide

[EN] Add a mark setting for price

Currently, the sign that separates decimal numbers in the price is only a dot:

obraz

In my opinion, you should add a sign setting that is to separate decimals in the price. Different characters are used in different countries, e.g. in Poland it is a comma.

The setting should be in the currency options.

[EN] Change "Stats" to "Status"

I suggest changing the names "Stats" to "Status" for "Invoices" and "Quote" and choosing by defined status names.

  • Invoices

obraz

  • Quote

obraz

[EN] Error loading page after clicking "Mon entreprise"

After clicking "Mon entreprise" an internal server error occurred.

obraz

Logi:

Error	index	Exception: Wrong parameters for Doctrine\DBAL\Driver\PDO\Exception([string $message [, long $code [, Throwable $previous = NULL]]])

    /home/xxx/public_html/xxx/lib/private/AppFramework/App.php - line 156:

    OC\AppFramework\Http\Dispatcher->dispatch(OCA\Gestion\ ... {}, "config")

    /home/xxx/public_html/xxx/lib/private/Route/Router.php - line 301:

    OC\AppFramework\App::main("OCA\\Gestio ... r", "config", OC\AppFramew ... {}, { _route: "g ... "})

    /home/xxx/public_html/xxx/lib/base.php - line 1000:

    OC\Route\Router->match("/apps/gestion/config")

    /home/xxx/public_html/xxx/index.php - line 36:

    OC::handleRequest()

Spowodowany Error: Wrong parameters for Doctrine\DBAL\Driver\PDO\Exception([string $message [, long $code [, Throwable $previous = NULL]]])

    /home/xxx/public_html/xxx/3rdparty/doctrine/dbal/src/Driver/AbstractException.php - line 34:

    Exception->__construct("SQLSTATE[HY ... r", null, PDOException ... ]})

    /home/xxx/public_html/xxx/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php - line 26:

    Doctrine\DBAL\Driver\AbstractException->__construct("SQLSTATE[HY ... r", "HY000", null, PDOException ... ]})

    /home/xxx/public_html/xxx/3rdparty/doctrine/dbal/src/Driver/PDO/Result.php - line 123:

    Doctrine\DBAL\Driver\PDO\Exception::new(PDOException ... ]})

    /home/xxx/public_html/xxx/3rdparty/doctrine/dbal/src/Driver/PDO/Result.php - line 65:

    Doctrine\DBAL\Driver\PDO\Result->fetchAll(2)

    /home/xxx/public_html/xxx/3rdparty/doctrine/dbal/src/Result.php - line 107:

    Doctrine\DBAL\Driver\PDO\Result->fetchAllAssociative()

    /home/xxx/public_html/xxx/3rdparty/doctrine/dbal/src/Result.php - line 326:

    Doctrine\DBAL\Result->fetchAllAssociative()

    /home/xxx/public_html/xxx/lib/private/DB/ResultAdapter.php - line 58:

    Doctrine\DBAL\Result->fetchAll(2)

    /home/xxx/public_html/xxx/lib/private/DB/PreparedStatement.php - line 67:

    OC\DB\ResultAdapter->fetchAll(2)

    /home/xxx/public_html/xxx/apps/gestion/lib/Db/Bdd.php - line 196:

    OC\DB\PreparedStatement->fetchAll(2)

    /home/xxx/public_html/xxx/apps/gestion/lib/Db/Bdd.php - line 141:

    OCA\Gestion\Db\Bdd->execSQL("INSERT INTO ... ;", [ "xxx"])

    /home/xxx/public_html/xxx/apps/gestion/lib/Controller/PageController.php - line 75:

    OCA\Gestion\Db\Bdd->checkConfig("xxx")

    /home/xxx/public_html/xxx/lib/private/AppFramework/Http/Dispatcher.php - line 217:

    OCA\Gestion\Controller\PageController->config()

    /home/xxx/public_html/xxx/lib/private/AppFramework/Http/Dispatcher.php - line 126:

    OC\AppFramework\Http\Dispatcher->executeController(OCA\Gestion\ ... {}, "config")

    /home/xxx/public_html/xxx/lib/private/AppFramework/App.php - line 156:

    OC\AppFramework\Http\Dispatcher->dispatch(OCA\Gestion\ ... {}, "config")

    /home/xxx/public_html/xxx/lib/private/Route/Router.php - line 301:

    OC\AppFramework\App::main("OCA\\Gestio ... r", "config", OC\AppFramew ... {}, { _route: "g ... "})

    /home/xxx/public_html/xxx/lib/base.php - line 1000:

    OC\Route\Router->match("/apps/gestion/config")

    /home/xxx/public_html/xxx/index.php - line 36:

    OC::handleRequest()
Error	PHP	Error: Undefined offset: 1 at /home/xxx/public_html/xxx/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php#20

    /home/xxx/public_html/xxx/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php - line 20:

    OC\Log\ErrorHandler::onError(8, "Undefined offset: 1", "/home/xxx/p ... p", 20, { exception: ... "})

    /home/xxx/public_html/xxx/3rdparty/doctrine/dbal/src/Driver/PDO/Result.php - line 123:

    Doctrine\DBAL\Driver\PDO\Exception::new(PDOException ... ]})

    /home/xxx/public_html/xxx/3rdparty/doctrine/dbal/src/Driver/PDO/Result.php - line 65:

    Doctrine\DBAL\Driver\PDO\Result->fetchAll(2)

    /home/xxx/public_html/xxx/3rdparty/doctrine/dbal/src/Result.php - line 107:

    Doctrine\DBAL\Driver\PDO\Result->fetchAllAssociative()

    /home/xxx/public_html/xxx/3rdparty/doctrine/dbal/src/Result.php - line 326:

    Doctrine\DBAL\Result->fetchAllAssociative()

    /home/xxx/public_html/xxx/lib/private/DB/ResultAdapter.php - line 58:

    Doctrine\DBAL\Result->fetchAll(2)

    /home/xxx/public_html/xxx/lib/private/DB/PreparedStatement.php - line 67:

    OC\DB\ResultAdapter->fetchAll(2)

    /home/xxx/public_html/xxx/apps/gestion/lib/Db/Bdd.php - line 196:

    OC\DB\PreparedStatement->fetchAll(2)

    /home/xxx/public_html/xxx/apps/gestion/lib/Db/Bdd.php - line 141:

    OCA\Gestion\Db\Bdd->execSQL("INSERT INTO ... ;", [ "xxx"])

    /home/xxx/public_html/xxx/apps/gestion/lib/Controller/PageController.php - line 75:

    OCA\Gestion\Db\Bdd->checkConfig("xxx")

    /home/xxx/public_html/xxx/lib/private/AppFramework/Http/Dispatcher.php - line 217:

    OCA\Gestion\Controller\PageController->config()

    /home/xxx/public_html/xxx/lib/private/AppFramework/Http/Dispatcher.php - line 126:

    OC\AppFramework\Http\Dispatcher->executeController(OCA\Gestion\ ... {}, "config")

    /home/xxx/public_html/xxx/lib/private/AppFramework/App.php - line 156:

    OC\AppFramework\Http\Dispatcher->dispatch(OCA\Gestion\ ... {}, "config")

    /home/xxx/public_html/xxx/lib/private/Route/Router.php - line 301:

    OC\AppFramework\App::main("OCA\\Gestio ... r", "config", OC\AppFramew ... {}, { _route: "g ... "})

    /home/xxx/public_html/xxx/lib/base.php - line 1000:

    OC\Route\Router->match("/apps/gestion/config")

    /home/xxx/public_html/xxx/index.php - line 36:

    OC::handleRequest()

Error | PHP | Directive 'allow_url_include' is deprecated at Unknown#0

Apps:

Nextcloud 22.0.0
Gestion 1.0.4

PHP 7.4

[EN] l10n: Source strings need to be in english

The resource has been added to Transifex and now translators start to translate.

One thing has been reported multiple times today:
Many of the source strings are in french.

That is not valid. All source strings need to be in english.

Please change them to english.
Currently I locked the resource "gestion" for all languages/translators.
I will unlock it as soon as changes are done.

Thank you.

[EN] Error opening Invoices

when i open a Quote the link goes to: MYSITE.com/index.php/apps/gestion/devis/1/show and that is OK but when i try to open an invoice it goes to: MYSITE.com/apps/gestion/facture/1/show instead of MYSITE.com/index.php/apps/gestion/facture/1/show.

if i make a direct link with the correct one the invoice opens! so it's missing the index.php in the link to open correctly the invoice.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.