Hi @JamesMahy
There was indeed a problem on the lines you mentioned.
It should be better with this fix: phpMv/ubiquity@7c6e58a
There was indeed a problem on the lines you mentioned.
It should be better with this fix: phpMv/ubiquity@7c6e58a
I installed Ubiquity by:
composer global require phpmv/ubiquity-devtools
composer global require phpmv/ubiquity-devtools
but it is not globally available
on my Ubuntu-1804-bionic-64-minimal
I found it at $HOME/.config/composer/vendor/phpmv/ubiquity-devtools/src/Ubiquity
Hey @jcheron it's your favourite annoying dev again :) Was wondering if there's a method to retrieve a twig view into a string instead of rendering it with $this->loadView
I would like to use Twig to parse my mail templates so that I don't have to build a seperate template parser
Hi @JamesMahy ,
You should use the third parameter of the loadview method:
$str=$this->loadView('viewName',['datas'=>$datas],true);
how does the community compare with rails?
/**
* @id
* @column("name"=>"id1","nullable"=>false,"dbType"=>"int(11)")
* @validator("id","constraints"=>array("autoinc"=>false))
*/
private $id1;
/**
* @id
* @column("name"=>"id2","nullable"=>false,"dbType"=>"int(11)")
* @validator("id","constraints"=>array("autoinc"=>false))
*/
private $id2;
or even better
SELECT
roles.id,
roles.name,
roles.description,
permissions.id as permission
FROM roles
LEFT JOIN roles_permissions ON id = role_id
LEFT JOIN permissions on permissions.id = permission_id
WHERE
roles.enabled = 1
AND
permissions.enabled = 1;Hi @JamesMahy
No sorry, this is not possible.
There is no queryBuilder like with Doctrine, it's a design choice, DAO is only object-oriented.
Besides, if it were possible, how would you make the difference in an object-oriented approach between permissions assigned to the role and those that are not?
On the other hand, it may be interesting to add a method that does the equivalent, i.e. load all the permissions, marking those assigned to the role in your case.
a method
a method
getLeftMany($role, 'permissions') returning something like [[perm1,true], [perm2,false]...]
In the meantime, you can easily get the equivalent data in an object logic :
//The role permissions:
$permsRole=$role->getPermissions();
//All permissions:
$allPerms=DAO::getAll(Permission::class, 'enabled=?',false,[true]);
//The permissions not assigned to the role :
$permNot=\array_diff_keys($allPerms,$permsRole);
With an Asynchronous server (Swoole for example), we can assume that all permissions are already loaded and globally accessible, and this object solution will have better performance than the SQL solution with left join.
I'm not entirely sure I follow how devtools can be used to setup Ubiquity project if
base\UIntrospection is required by the CLI (which can be installed globally) but at the same time it can only be found in the framework itself (which is supposed to be pulled by the CLI when setting up a project)
Hello everyone, I wonder if anyone happens to have any examples on defining middlewares with the uibiquity framework router?
Hi @andrei-dascalu
The Ubiquity router does not implement the Middleware concept (see in the future).
You can nevertheless get around this lack by using dependency injection or the initialize or finalize methods of the controllers...
Hi, what is the best practice for putting model specific properties? If I put them in the model itself, "Ubiquity model" command, after some alteration to the DB table, overwrites them. The app/config/config.php is suggested to be slim. If I make my own model which extends the generated model, "Ubiquity init-cache", and use it instead of the generated model, I got errors because its cache does not have annotation related information like #fieldNames.
Thanks @jcheron. I don't think it should persist in DB. It is like a config value for a model. It is a minimum sequencial value for every user's special code like prefix + sequencial numbers + suffix. At present I put it as a property of ControllerBase class, but it would be better if the property is only visible to user related controllers. What would you do in this situation?
If they are configuration variables, that can be modified, you can add them in
But if they concern only a part of the application, and you want to avoid loading them unnecessarily when they are not used, you can create a specific configuration file in
app/config/config.php.But if they concern only a part of the application, and you want to avoid loading them unnecessarily when they are not used, you can create a specific configuration file in
app/config/, and load this file in the concerned part ( base controller for the users).class UsersBaseController extends BaseController {
private $config;
public function __construct() {
parent::__construct();
$this->config = include \ROOT . 'config/users.php';
}
}
If, on the contrary, these values are not subject to change, a constant in the relevant controller will do the trick:
class UsersBaseController extends BaseController {
private const CONFIG = [
'prefix' => 'u_'
];
public function index() {
print_r( self::CONFIG);
}
}
Hello there! I found ubiquity pretty awesome! Trying to get msaccess odbc connection to have easy relationships for my models. Is it possible? How to fill dropdowns with table data, maby some ready grid or example iteration? How to easy deploy public in production server? Trying to find an easy frontend framework, that automaticaly find, say date fields and create fast ui. Please an example for many to many auto select drop down fields, that shows text related field from pivots. Nice to meet you!
UI
For the UI and Front-End part, Ubiquity uses by default phpMv-UI (PHP components library based on Semantic-UI and jQuery)
So to generate a Semantic UI dropdown from a model, you can do :
public function clientsDropDownTest(){
$clients=DAO::getAll(\models\Client::class);
$form=$this->jquery->semantic()->htmlForm('frm');
$form->addDropdown('clients',JArray::modelArray($clients,'getId','__toString'));
$this->loadView('ddTest.html');
}In the associated view, you can display the form:
{{ q['frm'] | raw }}
CRUD scaffolding can give you an idea of the possibilities.
Deployment
For the deployment, everything depends on the available server solution. I advise you to read the Servers and Optimization parts of the guide.And to come back to me if you have other questions
ManyToMany and Dropdown
The easiest first step is to create a CRUD controller for the model, and see if you can get the desired result by customizing it.
Can I DAO::save() same instance twice (the first one will insert and the second one should update)? The Ubiquity\orm\parser\Reflexion's static variable $classProperties stores the first time (insert) properties, which lack primary key, so the second DAO::save(), which needs primary key to update, fails with "SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens" error.