Skip to main content ↑ ↓

Show Posts

This section allows you to view all Show Posts made by this member. Note that you can only see Show Posts made in areas you currently have access to.

Messages - xela05

2
Questions / Auto Update Pague After Edit
Hello guys,

So i have a ready projet that works as a dashboard with trucks schedule so that the aware knows wich trucks to load at wich time/date.

My question is, Im at the Office and i insert a new truck, how can I force the dashboard Page (opened on another PC at the wharehouse) to update based on the new information inserted on the backoffice?

3
Issues / Projeblem when using custum fields
Hello,

I've a table as on the image bellow where I've data from DB with quantity and price.
Them I creat a custom field where I multiply the quantity * price in order to get a total and I used the "format record field" along the columns in order to have them with the € sign.

I now want to have a "Field Footer Expression" on this custom field with the Sum of all the values I previously multiplied.

THE PROBLEM

If the multiplied field is configured as currency the "Field Footer Expression" SUM produces an error, but if it is configured as number I works ok and I can then configure the SUM as currency.
The thing is that I want both - The Costum Field with the multiplication - and the "Field Footer Expression" with the SUM of the multiplication with currency sign.

How can this be achived?
4
Issues / Re: wampserver problems
Many thanks in fact my bad, I was publishing the projet to the wrong folder...

Problem solved!
5
Issues / wampserver problems
Hello,

Just configured phprad with wamp server and rigth at the first publish I get this error on the image.
Can anyone help me out?
6
Issues / Re: USER ROLES
I dont want the user to change is "role" for example.

How can that be done?
7
Issues / USER ROLES
Hello,

I've configured user roles and although everything seems to work fine, the system simply wont assume the role definition for the user to wont be able to edit/list is account.

I wanto to have only the administrator to be able to edit acounts but for some reason even if not check on the option, a regular user can edit is account.

9
Issues / Re: Image Click
Has I told you, the problem is that PHP RAD is not uploading the pics to the folder.

If I manually place the pic on the folder everything works fine...


https://ibb.co/QQqqp6V -> image of console
10
Issues / Image Click
Hello,

The images wont upload to the server but they showned on the thumbnail, but when I click it, instead of a bigger version of the image, I just get a black screen...

Any ideia to solve this?

** UPDATE

When I refresh the page the image stops shoing on the thumbnail...

So two problems now...
11
Questions / Re: Generate Reference
Thanks for the answer, my problem is, how do I retrieve the category and subcategory code that I selected on the dropdown?
12
Questions / Generate Reference
Hello guys,

Maybe someone could give me a little help.

I've this tables

category
id_category
name
code_category

subcategory
id_subcategory
id_category
name
code_subcategory

product
id_product
id_category
id_subcategory
name
code_product


When I'm creating a new product, what I do is that I select a category, then a subcategory (filtered from categories), then give it a name.

What I'd like to do is to have an autogenerated product code with like this (category code + subcategory code + autoincrement number), them pass it to the database

Any Idea about how to achieve this?

Many thanks
13
Issues / PDF/PRINT Export error when using CONCAT with <br> TAG
Hello,

I'm facing a problem, I made a costum field where I CONCAT an adress that the user inputs as separated fields so that I can have something like this:

Adress1
Adress2
PostCode, City
Country

My costum field is like this:

CONCAT(adress1,'<br>',adress2,'<br>',postcode,' ',city,'<br>',country)

For some reason, when trying to export to PDF or Print it gives me an error that I think is coming from the use of the "<br>" tag, because if I leave the full adress on a single line withou line breaks everything works fine.

Any idea about whats hapening?
14
Issues / EXPORT ERROR
When exporting I'm having the following error:

Warning: DOMDocumentFragment::appendXML(): Entity: line 23: parser error : Entity 'Atilde' not defined in C:\MAMP\htdocs\inventarioam\system\BaseView.php on line 743

Warning: DOMDocumentFragment::appendXML(): &lt;td class=&quot;td-in_out&quot;&gt; Sa&Atilde; in C:\MAMP\htdocs\inventarioam\system\BaseView.php on line 743

Warning: DOMDocumentFragment::appendXML(): ^ in C:\MAMP\htdocs\inventarioam\system\BaseView.php on line 743

Warning: DOMDocumentFragment::appendXML(): Entity: line 23: parser error : Entity 'shy' not defined in C:\MAMP\htdocs\inventarioam\system\BaseView.php on line 743

Warning: DOMDocumentFragment::appendXML(): &lt;td class=&quot;td-in_out&quot;&gt; Sa&Atilde;&shy; in C:\MAMP\htdocs\inventarioam\system\BaseView.php on line 743

Warning: DOMDocumentFragment::appendXML(): ^ in C:\MAMP\htdocs\inventarioam\system\BaseView.php on line 743

Warning: DOMNode::appendChild(): Document Fragment is empty in C:\MAMP\htdocs\inventarioam\system\BaseView.php on line 745


Can anybody help?
15
Questions / Dynamic Lookup 3 fields
Hello,

I know how to have a dynamic lookup working but what if I want to have more than one lookup?

For example:

Select 1 - Client (select from clients table)
Select 2 - Year (Select from predefined values)
Select 3 - Project (Select projects from client X on year Y)