Hi! Fresh install with Silex-Skeleton, composer edited to require Doctrine DBAL and CRUDlex (which implies more recent versions of twig-bridge and translation):

"require": {
        "php": ">=5.5.9",
        "silex/silex": "~2.0",
        "silex/web-profiler": "~2.0",
        "symfony/asset": "~2.8|3.0.*",
        "symfony/browser-kit": "~2.8|3.0.*",
        "symfony/class-loader": "~2.8|3.0.*",
        "symfony/config": "~2.8|3.0.*",
        "symfony/console": "~2.8|3.0.*",
        "symfony/css-selector": "~2.8|3.0.*",
        "symfony/debug": "~2.8|3.0.*",
        "symfony/finder": "~2.8|3.0.*",
        "symfony/form": "~2.8|3.0.*",
        "symfony/monolog-bridge": "~2.8|3.0.*",
        "symfony/process": "~2.8|3.0.*",
        "symfony/security": "~2.8|3.0.*",
        "symfony/translation": "3.1.*",
        "symfony/twig-bridge": "~3.1",
        "symfony/validator": "~2.8|3.0.*",
        "doctrine/dbal": "~2.2"
    },

Doctrine and Web Profiler working fine.

Adding CRUDlex:

        "philiplb/crudlex": "0.10.x-dev"

Instanciating the MySQLDataFactory, ServiceProvider: OK

Mounting the ControllerProvider results in this error:

InvalidArgumentException in Container.php line 233:
Identifier "twig.loader.filesystem" does not contain an object definition.

I've tried to tweak the Twig instanciation, with no result. However when I comment the Web Profiler instanciation:

$app->register(new WebProfilerServiceProvider(), array(
    'profiler.cache_dir' => __DIR__.'/../var/cache/profiler',
));

Then the error disappears and I can use CRUDlex.

So, it looks like issue #41 is back with the latest version.

Any idea?

Hi

The idea is to allow to group multiple entities into one option of the menu, this is helpful when there are too many entities or want to group based on relation. There is a example of the result:

In the description feature example (first feature explained in Extended Features) are also other features that are explained later. At first sight is confusing to concentrate in the new feature example because the other two are above the new one, so it forces to read again the text.

First of all your congratulations for putting up CRUDlex!

CRUDlexSample deploys v.0.9.7 of ou the box. Adding Web Profiler works well also:

    "require": {
        "philiplb/crudlex": "0.9.7",
        "silex/web-profiler": "^1.0"
    }

Unfortunately upgrading to v0.9.9 conflicts with the Web Profiler:

Twig_Error_Syntax in ExpressionParser.php line 604:
Unknown "trans" filter in "@crud/list.twig" at line 22.

Downgrade to v0.9.8:

Twig_Error_Syntax in ExpressionParser.php line 604:
Unknown "trans" filter in "@crud/list.twig" at line 14.

Removing silex/web-profiler (v1.0.8) restores CRUDlex v0.9.8 - v0.9.9

Any hints?

Since CRUDlex version 0.12.0 all static files (css,js,...) - get mimetype "text/plain" and GoogleChrome/Firefox show warnings in console. Apache mimetypes - is ok, PHP fileinfo extension - installed. Screenshot ver. 0.12.0 Screenshot ver. 0.11.0 How can I resolve this bug to use CRUDlex with valid CSS and JS? Thank you very much! P.S. Sorry for my english)

Hi, I wanted to try CRUDlex, installed it, made the params in app.php.

When I add the line $app->mount('/crud', new CRUDlex\ControllerProvider()); is raises the exception

I tried with CRUDlex 0.11 and 0.12, I made my projet up to date and maybe CRUDlex is not compatible with Symfony 3. Here is my composer.json for information

{ "name": "fabpot/silex-skeleton", "description": "A pre-configured skeleton for the Silex microframework", "license": "MIT", "type": "project", "require": { "php": ">=5.5.9", "silex/silex": "~2.0", "silex/web-profiler": "~2.0", "symfony/asset": "~2.8|^3.0", "symfony/browser-kit": "~2.8|^3.0", "symfony/class-loader": "~2.8|^3.0", "symfony/config": "~2.8|^3.0", "symfony/console": "~2.8|^3.0", "symfony/css-selector": "~2.8|^3.0", "symfony/security-csrf": "^3.2", "symfony/dom-crawler": "~2.3", "symfony/debug": "~2.8|^3.0", "symfony/filesystem": "~2.3", "symfony/finder": "~2.8|^3.0", "symfony/form": "~2.8|^3.0", "symfony/monolog-bridge": "~2.8|^3.0", "symfony/process": "~2.8|^3.0", "symfony/security": "~2.8|^3.0", "symfony/serializer": "~2.3", "symfony/translation": "~2.8|^3.0", "symfony/twig-bridge": "~2.8|^3.0", "symfony/validator": "~2.8|^3.0", "doctrine/dbal": "~2.2", "swiftmailer/swiftmailer": "5.*", "twig/extensions": "^1.2", "symfony/http-kernel": "^3.3", "philiplb/crudlex": "0.12.x-dev" }, "autoload": { "psr-0": { "": "src/", "MyProject": "src/" } }, "extra": { "branch-alias": { "dev-master": "2.0.x-dev" } } } Thanks for the help

On a project that I worked on with my co-workers it made sense to display a reference or list of many references as tags

This PR add an option to crud.yml that backports this change

Normal behavior:

With hideId: true

Let's say I have a table produit and one field in the table is a reference to another table client.

On the productList page, I filter by the client_id field. The result gives me 2 pages. If I navigate to the page 2, the error occurs.

This the DBALException message:

An exception occurred while executing 'SELECT COUNT(id) FROM `produit` `produit` WHERE (`id_client` = ?) AND (deleted_at IS NULL)' with params [{"id":<UUID>"}]:

Notice: Array to string conversion

The URL of the page: crud/produit?crudPage=1&crudSortField=created_at&crudSortAscending=true&crudFilterid_client%5Bid%5D=<UUID>

As described in Silex documentation, there's a finish middleware that can execute tasks after the Response has been sent to the client. How could we do it for a particular route? Say for example: /crud/myTable/update/xxx

This is somehow related to Issue #44.

I would also like to fill a field in the database from inside a pushEvents.

I have made some tests in a separate controller and succeeded to access the database by invoking $data = $app['crud']->getData($entity); and then using CRUDlex's setters.

However when trying to do it from inside my pushEvents function, I can't access the $app object. Is there any recommended way to to use the API's functions inside a pushEvents callback?

Sample code tryings and error:

$xls2json = function(CRUDlex\CRUDEntity $entity) {
    global $app;
    $data = $app['crud']->getData($entity);
...
$app['crud']->getData('imports')->pushEvent('after', 'create', $xls2json);

or

$xls2json = function(CRUDlex\CRUDEntity $entity) use ($app) {
    $data = $app['crud']->getData($entity);
...
$app['crud']->getData('imports')->pushEvent('after', 'create', $xls2json);

both lead to:

ContextErrorException in CRUDServiceProvider.php line 289:
Warning: array_key_exists(): The first argument should be either a string or an integer

Well, broken or I don't know how to use them. Test from a fresh project sample both in v0.9.9 and v0.9.x-dev, I added this on line 38:

New syntax:

$app['crud']->getData('library')->pushEvent('before', 'create', function(Entity $entity) {
    // Do something with the entity which is about to be saved.
    return true;
});

Generates:

Catchable fatal error: Argument 1 passed to {closure}() must be an instance of Entity, instance of CRUDlex\Entity given, called in /CRUDlexSample-master/vendor/philiplb/crudlex/src/CRUDlex/Data.php on line 104 and defined in //CRUDlexSample-master/web/index.php on line 39

Old syntax:

$app['crud']->getData('library')->pushEvent('before', 'create', function(CRUDEntity $entity) {
    // Do something with the entity which is about to be saved.
    return true;
});

Generates:

Catchable fatal error: Argument 1 passed to {closure}() must be an instance of CRUDEntity, instance of CRUDlex\Entity given, called in //CRUDlexSample-master/vendor/philiplb/crudlex/src/CRUDlex/Data.php on line 104 and defined in /CRUDlexSample-master/web/index.php on line 40

when you submit a form and fields are not required –if the type is text– the values are an empty string. the getField function replace these empty string value by a null value which breaks the SQL schema of NOT NULL if the definition is VARCHAR

Allow an entity to be referenced by many others. The other way round of the reference type. It will use the same UI elements as a many-to-many relationship.