Falcon Space. HOWTO General
How can I quickly transfer a solution (tables, forms, pages) to another database?
There are 2 ways to do this:
- Through the transfer package. Specify in the package which procedures, database tables, forms, tables, pages are included in the package and generate a single SQL migration script.
- Single transfer - for tables, forms and pages (on the page editing page), click the generate SQL button and it gives the SQL to be executed on another database.
How to quickly edit pages and component parameters
To quickly edit components, use the icons next to the name.
To quickly edit the page, there is an icon on the right in breadcrumbs.
However, keep in mind that on the table column Management page, this button works for the system table “table column”, and not for the entity that you are currently configuring.
How to make a specific action button
Use the forms in the modal window to do this (see the documentation for forms):
- Place the button,
- you attach a form to it with the output of some information for reading via GetItem.
- when saveItem executes the operation.
Animation of elements. How to work with animation
To do this, in the GetLayout procedure, enable animation in SELECT 1:
1 EnableAnimation
Animation applies by default to the following elements:
- Opening/closing modal Windows
- Appearance of headlines
- Messages about the results of operations.
You can also use your own animation. To do this, the element in the class must specify animated bounce.
bounce - this is the animation type and can be changed. All types of animations - https://daneden.github.io/animate.css/
Example:
<div class="animated zoomIn"></div>
How to animate icons
To do this, specify a special class on the icon: faa-[type] animated
Change the speed - faa-slow, faa-fast.
For animation when hovering over the parent button - use classes faa-parent
and animated-hover
Example:
<a href="#" class="faa-parent animated-hover">
<i class="fas fa-wrench faa-wrench"></i>
faa-wrench
</a>
Documentation for all types of icon animation - https://l-lin.github.io/font-awesome-animation/
How to make hotkeys for events (pressing a button)
Fill in the section Hot keys (table as_hotkeys) key combination and specify jQuery selector the button that should be called with this key combination.
Note. By default, Ctrl+ Alt + [Num] acts as a call to the quick menu drop-down items (Fast Add Links).
Where can I edit the search procedure, the procedure for common Layout elements, the procedure for periodic launch, and so on?
In the System stored procedures section (/home/p/sysSP), you can edit the specified procedures.
How do I show the user's balance at the top of my dashboard?
Specifying The system SQL (falcon_getLayoutInfo) elements BalanceSum, BalanceText, BalanceLink and BalanceIcon.
How to make lazy loading for images
Use the img tag instead of src data-src. When loading these images, the script (as.ark.imageLazyLoading) will run and load the src attribute.
How to change the message display duration:
In the as.ark.options settings, you need to set the parameters:
- alertSuccessDelay: 10000,
- alertWarningDelay: 120000,
- alertDangerDelay: 240000
How can I add dynamic items (such as Projects) to the menu?
To do this, do union with the current content in the stored procedure pg_getMepuPages.
The added items will automatically be assigned as child items in the menu based on the parentID.
How to send an Email, SMS, or notification to a user
Use for this 2 SELECT in SaveItem in form. If you specify the correct parameters, you can immediately send a message using the specified parameters.
Where to get a user's photo
The user's photo can be requested at this address /Controls/Resource/GetFile?code=userPhoto&user=demo1
How to create subdomains with different languages for a site
- All domains are directed to 1 application and specify a license for each in web.config.
- Specifying the GetLayout setting defaultLang depending on the @url variable.
How to manage the page “404 Page not found”
To do this, use the standard page code - notFound. Creating a page with this URL (notFound) and prepared document for it.
The page will issue a 404 http status.
Note. You may also need to set the Error Pages parameters in IIS: IIS / Site / Error Pages / Edit Feature Settings / put Redirect and Detailed Errors
How to create a new website design theme
The site theme is a separate css file for SB Admin Template.
- In Visual studio, changing the file \Content\sb-admin\scss\_variables.scss (color lines).
- Executing the task sb-admin-css in the task Manager.
- Create a folder with the theme code in /uploads and put the settings file in it _variables.scss and the generated css file (located at \Content\sb-admin\css\sb-admin-2.min.css).
- In procedure GetlayoutInfo specify the code of the theme (the First SELECT option Theme).
Tracking all user actions in the system
You can capture all calls from the user. They will be saved in the trace table with the code action.
To do this, in the web.config of the project in the appSettings section, specify the parameter logUserAction=”1”.
Tracking changes to stored procedures and pages (logChanges)
Logging changes to stored procedures and some other fields are done in the table as_changeLog. You can disable this option in Configuration/logChanges
How to set up the Cabinet menu
The Cabinet menu consists of pages that have a check mark Display in the menu, as well as on the basis of access to the pages of the current user.
The parent element sets the nesting of the menu.
Order sets the order of menu items.
You can also set an icon for a menu item.
Maximum nesting level of the menu - 2.
Creating new components, custom development for the project.
If the project is deployed in Solution mode, you can create your own business logic managers (in the Web project in the BLL folder, for example DemoManager).
Such business logic will be available in the controller via the webMng property (the controller must inherit from BaseController).
How to create functionality:
- Creating an interface similar with IDemoManager
- Creating a class similar with DemoManager
- Creating a link with WebManager (editing the IWebmanager interface and the Webmanager class)
- Creating a controller in Area with the project name and inheriting from BaseController
- Create your own JS in the /js/falcon/ folder (it can be minified using the ready-made GULP command, the final JS file will be located in /JS/Falcon-min/)
How to set up a help chat for users
Using replain chats - https://replain.cc/
Get the key and specify it in the GetLayoutInfo procedure in the HelpChatKey parameter (you can simply insert it as a key, or as replain:{key}).
The chat icon will load in the lower right corner.
Messages will be sent to your Telegram (or Facebook messenger) associated with this replay chat.
Note. Check and delete the connection replain.cc in the settings in CommonScripts (previously, the connection was there).
How to withdraw money data
To do this, use the function dbo.as_num(str, digits) - this will allow you to output numbers divided by digits.
How to spice up the interface and make it more attractive
It is important that the user likes the interface. For this:
- Use the buttons styles:
- btn-outline-primary - contour buttons
- btn-gradient - buttons with a gradient (non-native Bootstrap class)
- icons in buttons
- Use cards
- Use the shape and gradient background styles bg-success, bg-gradient-warning
- Use the element shadow shadow-lg
- Use badge and pills (badge badge-pill badge-primary)
- Use the appearance animation. Classes animated bounceIn delay-3s. https://daneden.github.io/animate.css/
How to show an element enlarged when hovering (for example, a table cell)
To do this, specify the class as-zoom the element. When hovering, the element will increase by 1.5 times in place.
How to disable swipe to open the menu
You must set BodyClass = as-disableSlideoutMenu in GetLayout. In this case, the menu will open only by clicking the button (swipe will not work).
How can I allow some roles to enter html in forms?
By default, only roles can enter html admin, editor, siteManager
in Web.Config / AppSettings specify disableAntiXSSRoles="user,admin,editor,siteManager"
What should I do if an open tab is reset when the page is reloaded?
On the page in the js field, connect the script:
$(document).ready(function(){
$('a[data-toggle="tab"]').on('show.bs.tab', function(e) {
localStorage.setItem('activeTab', $(e.target).attr('href'));
});
var activeTab = localStorage.getItem('activeTab');
if(activeTab){
$('#myTab a[href="' + activeTab + '"]').tab('show');
}
});
The tab layout itself should look like this:
<ul class="nav nav-tabs nav-fill" id="myTab">
<li class="nav-item">
<a class="nav-link active" data-toggle="tab" href="#projects">Projects</a>
</li>
<li class="nav-item">
<a class="nav-link" data-toggle="tab" href="#reviews">Reviews</a>
</li>
<li class="nav-item">
<a class="nav-link" data-toggle="tab" href="#bids">Bets</a>
</li>
</ul>
<div class="tab-content">
<div class="tab-pane active mt-2" id="projects">
<div class="as-table" data-code="modProjects"></div>
</div>
<div class="tab-pane mt-2 fade" id="reviews">
<div class="as-table" data-code="modReviews"></div>
</div>
<div class="tab-pane mt-2 fade" id="bids">
<div class="as-table" data-code="modBids"></div>
</div>
</div>
Examples of how Falcon Space platform components work
Examples of convenient tables and forms Examples of dashboards Examples of graphs and charts Example of a calendar Table with API data Example of displaying a map with points Types of form fields Example of a statistics widget Example of a hierarchy tree Example of the Time line component Example of a product card Example of resource load tracking Example of a Kanban board Example of a master form Example of uploading Excel/Word documents Example of filling in TIN data- Management
- Falcon Space Foundation
- Basic components
- Falcon Space Features
- Subsystems
- Additional component
- Integrations
- HOWTO Pages. How to add bread crumbs Pages. How to do redirect to another page when loading Pages. To change the text on the home page Pages. How to use advanced settings on a page Pages. How to display these lists in the page body (repeater) Pages. Page settings for creating the main menu Pages. I need the itemID parameter in the URL, but it's being passed because of entities InstanceID Pages. How to implement a landing page with your own template and styles Pages. How to make a master of functional description of the page SQL. Safe development using SQL (try catch) SQL. Internal SQL functions and helper stored procedures SQL. How to work with dates SQL. How to avoid problems with naming stored procedures. SQL. How to move to a new line in a string variable in SQL SQL. Debugging stored procedures and identifying the causes of errors SQL. Quick search for stored procedures and tables in ManagementStudio SQL. Safe type casting SQL. Creating a database structure through diagrams SQL. Output HTML markup in crude form (as tags) in SQL SQL. How to specify links in SQL SQL. Getting null when concatenating line SQL. The problem with the access database table SQL. Error Table:String or binary data would be truncated. The statement has been terminated. SQL. Newline translation when generating a line in SQL SQL. How to enter a date in a string in the desired format SQL. How to use select from Storage SQL. How to write a number in SQL in words SQL. The Cabinet interface is not the CRUD repository methods! SQL. How to give limited access to an external database on the same server (only for individual stored procedures) SQL. How to massively upload data to a Database table via CSV (Excel) JS. How to disable global JS error handling How to add an event to your Google calendar How do I identify an anonymous user (cookies)? HOWTO. How can I quickly transfer a solution (tables, forms, pages) to another database? HOWTO. How to quickly edit pages and component parameters HOWTO. How to make a specific action button HOWTO. Animation of elements. How to work with animation HOWTO. How to animate icons HOWTO. How to make hot key for events (pressing a button) HOWTO. Where can I edit the search procedure, the Layout common elements procedure, the periodic launch procedure, and so on? HOWTO. How do I show the user's balance at the top of my Cabinet? HOWTO. How to do lazy loading for separate image HOWTO. How can I add dynamic elements (such as Projects) to the menu? HOWTO. How to send an Email, SMS, or notification to a user HOWTO. Where to get a user's photo HOWTO. How to create subdomains with different languages for a site HOWTO. How to manage a page "404 Page not found” HOWTO. How to create a new site design theme HOWTO. Tracking all user actions in the system HOWTO. Tracking changes to stored procedures and pages (logChanges) HOWTO. How to set up the Cabinet menu HOWTO. Creating new components, custom development for the project. HOWTO. How to set up a help chat for users HOWTO. How to output money data HOWTO. How to revive the interface and make it more attractive HOWTO. How to show an element enlarged when hovering (for example, a table cell) HOWTO. How to disable swipe to open the menu HOWTO. How do I allow some roles to enter html in forms? HOWTO. What should I do if an open tab is reset when the page is reloaded? SQL. How to transfer a complex data type How to make a sticky panel on the top of a page Falcon Space. HOWTO General Migrating components between Databases SQL. How to output plural endings (5 orders, 3 orders) Falcon Space. Dictionary of terms SQL. How to convert a date from JS to an SQL date How to make a push notification Custom markup of the top panel (TopMakeup) Попап (popup) окна - показ модальной формы по событию или таймауту Modal link (as-modal) How to customize menus on smartphones at the bottom of the screen How to make a separate universal search How to implement a notification window about the use of cookies Displaying a barcode and QR code on the page Layout. How to swap columns on a smartphone To increase the size of downloads How to embed a table of contents in a text How to put test data in a SQL Server table Managing animation for forms and tables Logging changes to objects using stored procedures as an example Отпимизация по загрузке картинок How to insert a universal search anywhere on a page Как сделать основное меню горизонтальным Как логировать клики на определенных элементах в системе Управление иконкой в окне alert справа вверху окна How to do tree sorting with Drag and Drop Multiple cursors
- HOWTO Tables
- HOWTO Forms
- HOWTO JS
- HOWTO CSS
- HOWTO Layout
- Solve problems
Falcon Space Platform
This is a reduction in the cost of ownership
at the expense of fewer people to support
This is a quick change
while using the program
This is a modern interface
full adaptation for mobile devices
- Falcon Space Video
- Platform features demo will allow you to understand how this or that component looks and works
- Have a question? Write to the chat at the bottom right