Scriptcase

Scriptcase can be used to create CRUD (Create, Read, Update and Delete) applications. It also enables to add custom code to manage business rules and validation. Scriptcase lets you create forms, queries in PHP, ranging from simple forms to forms having high level of complex elements to manipulate data from databases (MySQL, PostgreSQL, SQLite, Interbase, Firebird, Access, Oracle, MS SQLServer, DB2, SyBase, Informix and ODBC connections).

It permits development with JavaScript methods that can be used within the AJAX events and create applications with AJAX through a set of features and services with easy and fast hand coding, such as navigation between pages or sections, automatic validation of fields such as date, currency, zip code and social security number, among others.

The generated reports can be exported to MS Word, MS Excel, PDF or printed. Complex SQL statements can be used (sub-select, joins and even stored procedures). Scriptcase allows users to write PHP to handle exceptions and create more complex validation).

Scriptcase is Compatible with RTL (Right to Left) writing, support right to left writing prevalent on Arabic languages. It is also possible to create infrastructure such as menus, login screen and security system with authentication, create tabs to group forms or queries to be executed on the same page.

Platform development began in 2000. Since then, it has been receiving regular updates.[1]

It addresses Web Application Developers (both for desktops and for mobiles) in two ways: it enables starting developers with limited knowledge of programming (PHP, Java) and basic knowledge of databases (SQL) to build applications that read and updates data in Web Databases. But it also aims at the experienced developer, who can with Scriptcase put a lot more focus on business logic rather than editing forms, build database connections etc.[2]

The pricing model is about to shift from "buying the software" as till the end of 2016 to "lease as a service" from 2016 (due to a publication from the CEO to subscribers and current users of scriptcase from Nov 14th, 2016). Prices currently are 400-$600 for buying the software (depending on how many databases are supported) per developer.[3]

The platform development started in 2000. Since then, the tool has received periodic updates and improvements.

• 1.0 - Released 2000 - "Fossil Version".
  • Was sold only for some customers in beta mode.

• 2.0 – 2003
  • Big Changes in the interface.
  • Theme and CSS Editor
  • Creation of SQL builder
  • Export PDF
  • Macros
  • Security Module 1.0

• 3.0 - 2006
  • Native support for AJAX
  • Creation of the concept of Events
  • Stored procedure

• 4.0 - 2008
  • Internationalization support
  • Master-Detail Functionality
  • Editable Grid
  • HTML Editor
  • Helpcase (documentation generator)
  • New filter options
  • Navigation using tabs on the internal interface of Scriptcase

• 5.0 – 2009
  • Graphics in Flash
  • Creation of the container application
  • Express applications Creation
  • captcha security use
  • dynamic menus
  • Menu with "refresh" option
  • Tree Menu
  • New Security Module
  • Logging module

• 5.1 – 2010
  • New implementations such as JQuery support
  • Calendar
  • Google Maps
  • Quick Search
  • bar codes
  • flash graphics
  • Container
  • Field type YouTube
  • New Themes

• 5.2 – 2010
  • Focused on editing and field types, creating the option "edit fields"
  • Form: New field formatting, tabs, validation, among others.

• 6.0 – 2012
  • The biggest change was in performance, up to 5 times faster.
  • New graphics module
  • New security module
  • New log module
  • Database Manager

• 7.0 – 2013
  • Integration with PayPal
  • Integrated social media Buttons,
  • AJAX in Grids
  • Mobile Menu
  • New PDF generator
  • Tool bar for menus
  • Graphics in HTML 5

• 7.1 – 2013
  • Multi-Thread Processing
  • Change in interface
  • Graphics with navigation on the Toolbar
  • Friendly URL

• 8.0 – 2014
  Scriptcase consolidation as one of the strongest tools of BI (Business Intelligence), migrating some features that help the end-user to make decisions. For that, we made some major changes on the Grid Application, such as the option for your end-users to create their own Group By within the application based on the fields defined by the developer, add totals and create their own graphics. In addition, there is a new graphic application, added to simplify the creation of such applications.
  • New dynamic filter, and Group By Summary for Grid applications;
  • Interface to message between Scriptcase users;
  • Image Manager;
  • Editor for graphics themes;
  • A tool to import ACCESS, CSV and XLS in MySQL database, SQLite, Postgre and MSSQL;
  • New interface for settings on applications such as Form and grid;
  • Responsiveness to form and make the menu of mobile web applications;
  • Support for the TCPDF class in the application Report PDF;
  • Dynamic Research in form applications;
  • Grouping of option buttons to applications with the option of the toolbar;
  • Past, Present and Future new events in the calendar application.

• 8.1 – 2015
  Implemented new filter functionality, and dynamic summary in Grid applications. Created a new Graphic application with support for user-defined combined final graphics. New refined Filter restricting values according to the universe that exists in the database. Group of buttons for the new chart in the toolbar button editor.
  • New Tools
    • Sending messages between users in Scriptcase;
    • New tool for managing images in Scriptcase;
    • Tool for creating to-do list among users;
    • New tool for editing graphic themes;
    • Tool for importing ACCESS, CSV and XLS for MySQL, Postgre, SQLite and MSSQL;
    • New Library Manager;
    • New HelpCase generator;
    • New security module with listing of logged users and blocking by Brute Force;
  • Scriptcase Interface
    • Added new configuration interface of the form and Query applications;
    • Added new parameters in the theme editor Refined Filter;
    • Added new parameters in the theme editor for Menu tabs;
    • Added new parameters in the theme editor to the navigation path of the Menu;
    • Added option to background image in advanced settings for Menu theme;
  • New Technologies
    • Implemented mobile applications responsiveness form;
    • Added TCPDF class support in the implementation Report PDF;
    • Added new sc_webservice macro that supports soap services, curl, file_get_contents and sockets;
  • Application resources
    • Grouping of option buttons in applications that have toolbar;
    • Implemented improvements in the implementation timetable;
    • Added new path (breadcrumb) menu application browsing;
    • Added macros sc_url_library () and sc_include_library ();
    • Added new aggregation of type "weighted average";
    • Added new field for accumulation of values of other fields;
    • Added new Ajax type button.

• 9.0 – 2017
  Comes with important implementations on Business Intelligence (with a complete redesign on the charts, grids, abstracts – Pivot Tables and Dashboards), significant improvements in security, PDF Report module, Menu, interface redesign development and improvement of performance with PHP7, among other implementations.
  • Chart
    • New aggregate functions to graph metrics;
    • A new dimension of options for date fields;
    • Possibility of an analytic and synthetic combination of different sizes in the same graph;
    • Inclusion of a new type of filter (user filter)
    • Inclusion of function LIMIT that can be used to rank the values within the graphics.
    • New types of graphics: scatter and bubble, Gantt, semicircular and linear, funnel 2D and pyramid 2D;
    • New customization options specific to the graphics bar, column, pie, and gauge;
    • Possibility to export the graphs in PNG, JGP, PDF, SVG, and XLS;
  • Dashboard
    • New interface with drag and drop, for setting up widgets dynamically;
    • Responsiveness in the presentation of the widgets in the Dashboard;
    • New index widget to the presentation of KPIs (key performance indicators) within the dashboard;
  • Application of Grids (Reports and Pivot Tables)
    • New interface using drag and drop for defining the Grid breaks and the abstract;
    • New aggregate functions to graph metrics: Count, Distinct count, variance and standard deviation;
    • New dimension of options for date fields;
    • Inclusion of a new filter to the summary (user filter);
    • Inclusion of function LIMIT in the query and in the summary. Function can be used to rank the values.
    • New configuration options within the aggregation of the summary;
  • Layout application
    • Allows integration of forms with customized HTML and CSS or imported in the form of external library;
    • Body handling variables from HTML: visual can now be changed completely and adapted;
  • Report PDF Drag & Drop
    • New option of drawing with drag drop and dynamic configuration of & fields within the same interface;
  • Menu application
    • New option "menu structure" for customization of menu layout;
  • Scriptcase Interface
    • Great part of Scriptcase interface has been modified, thereby improving the usability of the tool for developers;
    • New interface for creating projects with search option;
    • New interface for creating application with multiple selection of tables, etc.
  • Environment and safety
    • PHP support 7.0;
    • Update ODP drivers (SQL Server, MySQL);
    • Addition of the PDO Dlib drive for SQL Server;
    • Addition of the new MySQLi for MySQL connections drive;
    • SSL for secure connections with MySQL;
    • New version of Apache 2.4.25;
    • Option to login with Google, Facebook and Twitter automatically by the safety module;
    • New options for the encryption password login application field (MD5, SHA1, SHA256, SHA512);
    • Security module Integration with the new option of free-form control with responsive templates.

• AJAX
• Editable grid
• Master / Detail
• Forms
• Consultations
• Reports
• Menus
• Tabs
• Customizable Layouts
• Documentation generator
• Data Dictionary
• Language Editor
• Import HTML template
• jQuery
• JavaScript

Scriptcase still allows the advanced settings for the generated applications meet the requirements of complex systems. There is also a documentation generator that can integrate the whole team.

• Scriptcase Official Site
• Samples
• Features
• Scriptcase Download
• Scriptcase Host