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 - ewwgee

1
General Discussion / Re: New release?
New version is VERY ambitious, so makes sense there are last minute problems ( i would say last hour and last day too )
2
Suggestions / Re: be able to add charts to tab pages
It's totally possible, but you have to do in a slightly different way.

Instead of trying to add the row/colum structure to the tab directly, you have to create a new page, have all the structure there and then insert that page in the tab. That way it works flawless.

1. Go to pages tab
2. Create a new page, type = view
(I suggest avoiding Duplicate page, it might be faster at first, but trust me, best to do the whole process from zero)
3. Go to Page design
4. Edit that new page you just created
(remove header, footer, etc if you are going to insert it.. etc)
5. In Page Design, find the tab you wanted to use as container
6. Add the new page from the Subpages tree
3
General Discussion / Re: Select with UseAjaxSearch under CentOS
If you're developing in XAMPP and moving to production in Centos (or any other live server) I would really check first that all paths are correct across your project.

Unfortunatelly to move from 2.6 to 2.7 you must create a new project. Considering you already have one, it's not as hard as starting from zero, but it's not as a easy as an import would have made it.
9
Questions / Re: Multiple Lookup values in the same form
I have tested with multiple parameters, and it works sequentially when they are values, but for some reason the lookups don't work when having more than one in the parameter box.
10
Questions / Re: Multiple Lookup values in the same form
Thanks.

#2 about Gmail was probably for someone else.

I've tried multiple combinations with Query Params in the form of  $lookup_idSomethingHere  and with one param they work fine, but never with 2.

Just a quick example, assuming we're using the same DB and fields for this example. And 1 and 2 work fine, but 3, using the same data, doesn't.

Query box:
"SELECT DISTINCT id AS value,name AS label FROM brand WHERE idSomethingOne= ? "
Params box:
$lookup_idSomethingOne
This works

Query box:
"SELECT DISTINCT id AS value,name AS label FROM brand WHERE idSomethingTwo= ? "
Params box:
$lookup_idSomethingTwo
This works

Query box:
"SELECT DISTINCT id AS value,name AS label FROM brand WHERE idSomethingOne= ? AND idSomethingTwo= ?"
Params box:
$lookup_idSomethingOne, $lookup_idSomethingTwo
This does not work
11
Questions / Re: Button to run a query
I've tried to make this work in Product page (example) to create a new Product and works fine. But if I try to use it in Product page to create (for instance) a new order based on that product (ie filling the product details in order page) it's not working. Returns Undefined index: notices in some of the bound fields. But others work fine. And all those fields are basically the same type INT(11)
12
Questions / Multiple Lookup values in the same form
I assume this can be done, as the Query Params can be separated by commas, but how do you associate the Query params with the '?' in the query builder? Is it just sequential ? 1st '?' corresponds to first Parameter in the Params box below?

To elaborate a bit more, what I would like to accomplish in this test is this:

Tables : [Country] [Company] [Brand] [Product] and a [Order] table where the selection is made

One Company has several brands that are present in several countries, but all products are not available in all countries, even they share the same company/brand.

US - Company A - Brand 1 - Product USA1
US - Company A - Brand 2 - Product USA2
UK - Company A - Brand 1 - Product UKA1
UK - Company A - Brand 3 - Product UKA3

So, with the current lookup form, I can just select one Dynamic Select Field to define the Where clause. In this case, the ideal would be to use all 3: country, company and brand .. to display only the products that match all 3 conditions.

With simple linear selections, can be done, but the problem comes when a product can be available in more than one country, but not all.. or when same brands are in different countries and have different products for each country.
13
General Discussion / Re: Spanish tutorial PHP Rad (Tutorial en Español)
Very good attempt.

But the translation has many mistakes. For instance in some cases you translate Table as Mesa (any spanish knows in this case the proper translation for this is Tabla) ot Tick as Garrapata (an insect) when should be "marcar"
15
Questions / Re: permisos de usuarios
Lo que buscas es lo que se llama una app "multi-tenant". Con PHPRad puedes hacerlo, pero tienes que desarrollarlo por tu cuenta, no tiene una forma "automatica" de hacerlo.

Por otro lado, este foro es basicamente en ingles, y creo que lanzar una pregunta en español no es demasiado cortes con el resto de los usuarios, además de que no hay mucha gente que te pudiera responder.

-

So the OP was asking how to develop a multi-tenant solution using PHPRad. Essentially a multi company, multi user, multi role system, where certain user roles could see everything "below" them. He tried the role system already in Phprad, but that only limits pages and menu items. I pointed him in the multi-tenant direction.