Manage Vtiger Menu

How Manage and customize Vtiger Menu

You need to modify the function getAppMenuList in the file modules/Vtiger/models/MenuStructure.php

'JS_YEARS' => 'anni',
'JS_TODAY' => 'oggi',
'JS_TOMORROW' => 'domani',
'JS_YESTERDAY' => 'ieri',
'JS_CREATE_TASK' => 'Creare Attività',

Add the new Item voice
public static function getAppMenuList(){
return array('MARKETING','SALES','INVENTORY','SUPPORT','PROJECT','YOUR_APP_MENU_NAME');
}

public static function getAppIcons() { $appImageIcons = array( 'MARKETING' => 'fa-users', 'SALES' => 'fa-dot-circle-o', 'SUPPORT' => 'fa-life-ring', 'INVENTORY' => 'vicon-inventory', 'PROJECT' => 'fa-briefcase', 'TOOLS' => 'fa-wrench' ,'YOUR_APP_MENU_NAME' => 'fa-life-ring' ); return $appImageIcons;
}

The UDF Repository for MySQL

The UDF repository for MySQL is a community project that aims to offer an organized collection of open source MySQL user defined functions.
MySQL UDFs offer a powerful way to extend the functionality of your MySQL database. The UDFs on this site are all free: free to use, free to distribute, free to modify and free of charge, even for commercial projects.

Mysql cumulated sum

Sometimes we need to obtain a cumulative sum of a columns in a query. How we can do it?
Suppose you have this simple table

id|in|out
----------
1  5  0
2  0  6
3  2  0
4  3  0
5  0  4

and you want obtain the cumulative sum  of the column (in+out) like this

id|in|out|sum
-------------
1  5  0   5
2  0  6   11
3  2  0   13
4  3  0   16
5  0  4   20

This following query to do this

SELECT a.id, a.in, a.out,

-- this is the new column called sum
( SELECT SUM( in + out )
  FROM mytable b
  WHERE b.id <= a.id

) AS sum

FROM mytable a
ORDER BY id

Best chart libraries

Charts are an indispensable part of any data visualization work. People can grok visual representation of data easily than a textual variety. Today there are a huge number of free chart libraries available to display visualizations on websites. Below is a small list of  some of the libraries available for displaying charts using php.

pChart - a PHP class to build charts

pChart is a PHP class oriented framework designed to create aliased charts. Most of todays chart libraries have a cost, our project is intended to be free. Data can be retrieved from SQL queries, CSV files, or manually provided. This project is still under development and new features or fix are made every week.

Focus has been put on rendering quality introducing an aliasing algorithm to draw eye candy graphics. Rendering speed has been dramatically enhanced since the first version, we'll still continue optimising the code! 

JpGraph

 

JpGraph is an Object-Oriented Graph creating library for PHP >= 5.1 The library is completely written in PHP and ready to be used in any PHP scripts (both CGI/APXS/CLI versions of PHP are supported).

Libchart Simple PHP chart drawing library

Libchart is a free chart creation PHP library, that is easy to use. 

This new version features multiple datasets for horizontal, vertical bar charts and line charts. The API got a facelift so be sure to check the examples so you don't miss anything.

FusionCharts

FusionCharts helps you create great-looking animated and interactive Flash charts for your PHP applications. It provides you a complete reporting experience with features like drill-down, one-click chart export and full AJAX support. With an easy-to-use PHP API and lots of code samples, it makes chart generation a breeze, and needs no knowledge of Flash whatsoever. So no matter whether you are building reports, dashboards, polls, analytics or any other application, FusionCharts can add both meaning and glamor to your data....
(show more)

Advanced Graphs and Charts for PHP

Add Powerful reporting features to your Web / Intranet pages and applications. With advanced graphing you will be quickly adding impressive and dynamic charting capabilities bringing your data alive ! The PHP graphing scripts provide a very easy way to embed dynamically generated graphs and charts into PHP applications and HTML web pages.Very easy to use and add professional quality graphing to web pages / applications in minutes.
Many new chart styles added to the Extented Collection.

VisualVM - All in one Java Troubleshooting Tool

VisualVM is a visual tool integrating several commandline JDK tools and lightweight profiling capabilities. Designed for both production and development time use, it further enhances the capability of monitoring and performance analysis for the Java SE platform. Go to VisualVM or see screencast.

Lucid desktop

Lucid desktop, A web operating system (WebOS) software that allow you setup own web desktop OS online. This open source WebOS is built with PHP and uses a SQL database for storing data. Plus more, Lucid Desktop WebOS is a multi-user application, which is very modular with the support for installable applications.

With Lucid desktop WebOS, you can access your media, office documents, and other files anywhere. Meanwhile, user can stay up to date with Twitter, RSS feeds, and what’s happening on the web. Plus more, Lucid Desktop already comes with lots of applications like text editor, calculator, image viewer, simple games, web browser, feed reader, music player and more.
With the help of a file manager, you can add-edit-delete files and folders (a context menu makes these steps easier), change the appearance of the desktop with theme support and auto-update the OS to the latest version.

Lucid Desktop Main Features:

• Extremely customizable: Lucid allows you to pick your own theme, panel layout, and more! Themes and wallpaper can be customized, and additional themes can be installed. You can customize your desktop even more by creating/moving panels, and adding applets to panels. The intensity of effects can also be customized, which can be used to disable animations for slower browsers.
• Multiple language support: Your locale is automatically detected, and text will appear in your native language. Lucid will even format dates, time, and currency according to your locale. If Lucid does not support your language yet, it will default to English.
• Easy-to-use file management: Lucid’s file manager acts like any other file manager. It supports drag-and-drop, and copy/paste. You can upload files, and create folders. You can also double-click a file to open it in an application.
• Take your files with you on the go: You can access any files on Lucid from your mobile phone, using the mobile file browser. Just navigate to your installation, and add /mobile/ to the end.
• Powerful user management: With Lucid, you can get down to the nitty-gritty when it comes to user management. It has powerful permissions system that allow administrators to limit features such as administration, cross-site requests, and the ability to login. It also has filesystem quotas, to limit how much disk space a user can use. You can also organize users with groups. Permissions and quotas can be set on a per-user, per-group, or global level, which makes user management simple.
• Easy to create applications: Lucid has everything you need to write powerful applications with ease. You can use the built-in IDE to rapidly develop applications from within the desktop itself. The best part is, you don’t have to write a single line of server-side code! Applications can be written completely in javascript using the Dojo Toolkit, and can even have their own custom widgets.

Building Lucid Desktop WebOS is simple, all you need is follow the installation instruction (pretty straight forward) and prepare  a web server that supports PHP5 and some sort of database support in PHP such as  (mySQL, pgSQL, etc.), as well as SQLite.

sqldf: SQL select on R data frames

sqldf is an R package for runing SQL statements on R data frames, optimized for convenience. The user simply specifies an SQL statement in R using data frame names in place of table names and a database with appropriate table layouts/schema is automatically created, the data frames are automatically loaded into the database, the specified SQL statement is performed, the result is read back into R and the database is deleted all automatically behind the scenes making the database's existence transparent to the user who only specifies the SQL statement. Surprisingly this can at times be faster than the corresponding pure R calculation (although the purpose of the project is convenience and not speed). sqldf is free software published under the GNU General Public License that can be downloaded from CRAN.