Not everyone likes the standard login window in Vtiger CRM. Especially with advertising. I want something simple, with a laconic and minimalist design. Moreover, it is very easy to do it. It is enough to edit only one file - layouts / v7 / modules / Users / Login.tpl. Below is an example of my file, which I most often use when setting up Vtiger CRM for my clients. On the screenshot for this post, you can see an example of How the authorization window looks after the edits.

Often in the process of developing APIs with Vtiger CRM, I had to deal with one very unpleasant situation - we delete any record from CRM, while related records are not deleted. They have to be removed separately through additional requests. And this makes the process of deleting all records very long and hard to implement.

PostgreSQL supports various types of data that are stored in the database and processed using SQL. Different data types are used in a wide variety of situations: for optimal use of data types when describing table attributes, for processing data using standard functions, for creating logical constraints in accordance with the business logic of the project.

There is an interesting module in vtiger called Webforms. It can generate special html forms, which you can then easely insert into your site and receive leads directly to vtiger. Forms can be integrated with various modules - leads, contacts, counterparties, deals.

In practice, any developer or system administrator encounters a terrible problem - the database slows down. The server is running slowly, something strange is happening, users are complaining, the client is angry. It was not for nothing that I wrote that the problem is terrible, first of all because the solution here will not be obvious and it does not lie on the surface. Many parameters can affect database performance.