• What is Drawing plugin
• Release History
• Plugin Installation and configuration
• User Manual
• Components settings
• Known issues and future development
• Calibration
• License
• Free support
• Commercial support

Pretius Drawing plugin is an Oracle APEX region plugin developed by Tomas Kucharzyk at Pretius. Plugin helps you draw interactive 2D plans and can be used for example as parking or workspace planner and more. Main features of the Pretius Drawing plugin are:

• Create drawings with easy drag & drop interface
• Modular components: User can add components and component types in table and use them without need to change the code
• Interactivity: User customizable functions for interactive plans
• Save and load from collection
• Render the plan in different scale based on region attribute (resize)

1.0: October 2023

• Initial version

1.1: October 2023

• Fixed compatibility with 22.2.
• Changed the logic of save and load to increase maximum count of used components
• Changed inputs in parking spots to text areas

1.2: November 2023

• Added left and top calibration into region attributes

1.3: December 2023

• Code changes, plugin can be now used multiple times on one page

First install SQL file with component tables and included components You can install the file in SQL Workshop-Scripts where you run it as new script or in your database:

 type_components.sql

Then import the plugin into your application from this file:

 region_type_plugin_pretius_drawing_plugin.sql

For the plugin configuration follow this steps:

1. Create region of type "Pretius Drawing Plugin"
2. Set collection name in region attributes
3. Choose if the plugin should be displayed with or without editor:
   1. If the editor is active, users can drag & drop components onto the plan and edit them
   2. Save button will save all the components into chosen collection
   3. When is editor option disabled, user can define onClick behavior in onClick column, so the plan can be interactive and users can for example book a place in an office or parking spot
4. Set the region query as below:

Example query:

select
	C001 as width,
	C002 as height,
	C003 as  top,
	C004 as left,
	C005 as class,
	C006 as  text,
	C007 as available,
	C008 as spot_id,
	C009 as rotate,
	case  
		when C005 like  '%workspace-seat%'  then  'selectSpot('|| C008 ||')'
		else  'alert('||C008||')'
	end  as onClick,
	c010 as innerHtml
from apex_collections
where collection_name = 'MY_COLLECTION'
order by seq_id;

Query contains columns that define component size, location and visualization. It does not have to use apex_collections, you can load saved results directly from the table.

• Width and Height: size of the component
• Top and Left: component position
• Class: CSS classes, define component visualization
• Text: if the component contains input field, it will be saved into Text column
• Available: can be used to restrict interactivity of the component
• Spot_id: auto generated id of the component, unique identifier
• Rotate: rotate CSS value in degrees
• Onclick: user defined function that will be triggered on click, example below add function selectSpot(id) to component that has class workspace-seat (Workplace component that visualize as office chair) and alert(id) for any other component

case 
    when C005 like  '%workspace-seat%'  then  'selectSpot('|| C008 ||')'
    else  'alert('||C008||')'
end  as onClick

• Innerhtml: this column contains any inner html from complicated components, when recreated, the inner html is inserted into main component div, so the visualization stays the same

To render the plan in different scale, the region editable attribute has to be set to No. Then you can change the scale with a number where 1 is 100%.

Link to User manual

All the components are in table PLAN_TYPE (category of the components) and TYPE_COMPONENT. You can create additional components / component types and add them into tables. Use code column for your HTML and CSS column for styling. It will be automatically loaded into the plugin and you can use it to create your visualizations.

1. Feature: Drag all selected items at once
2. Error: Some components get selected when draged around or resized

To enhance the precision of drag & drop, we have included Left and Top margin attributes in the region settings. This allows you to fine-tune the drop position. For more information, please refer to the User Manual: Link to User manual

Licensed under the MIT.

Pretius provides free support for the plugins at the GitHub platform. We monitor raised issues, prepare fixes, and answer your questions. However, please note that we deliver the plug-ins free of charge, and therefore we will not always be able to help you immediately.

Interested in better support?

• Become a contributor! We always prioritize the issues raised by our contributors and fix them for free.
• Consider comercial support. Options and benefits are described in the chapter below.

Have you found a bug or have an idea of additional features that the plugin could cover? Firstly, please check the Roadmap and Known issues sections. If your case is not on the lists, please open an issue on a GitHub page following these rules:

• issue should contain login credentials to the application at apex.oracle.com where the problem is reproduced;
• issue should include steps to reproduce the case in the demo application;
• issue should contain description about its nature.

If you encounter a problem during the plug-in implementation, please check out our demo application. We do our best to describe each possible use case precisely. If you can not find a solution or your problem is different, contact us: [email protected].

We consider our plugins as genuine open source products, and we encourage you to become a contributor. Help us improve plugins by fixing bugs and developing extra features. Comment one of the opened issues or register a new one, to let others know what you are working on. When you finish, create a new pull request. We will review your code and add the changes to the repository.

By contributing to this repository, you help to build a strong APEX community. We will prioritize any issues raised by you in this and any other plugins.

We are happy to share our experience for free, but we also realize that sometimes response time, quick implementation, SLA, and instant release for the latest version are crucial. That’s why if you need extended support for our plug-ins, please contact us at [email protected]. We offer:

• enterprise-level assistance;
• support in plug-ins implementation and utilization;
• dedicated contact channel to our developers;
• SLA at the level your organization require;
• priority update to next APEX releases and features listed in the roadmap.