digitaldreams / laracrud Goto Github PK

View Code? Open in Web Editor NEW

332.0 21.0 54.0 4.84 MB

Laravel Code Generator based on MySQL Database

License: MIT License

PHP 95.73% Blade 4.27%

php laravel-crud laravel-5-package laravel-framework crud-generator laracrud laravel code-generator laravel-application

laracrud's People

Contributors

Stargazers

Watchers

Forkers

mahfuz1991 rap2hpoutre atouiahmed soitun fsuuaas itshimelkazi technokid angujo macagoraga kidsk dfroberg kallbuloso sayyidisal javiergomezve code-generators aelmasry jrinconcol alexeykostenko zaghadon georgescugabriel faysalmahamud sachinganesh kalpeshpatelbyk krolnoeurn bertrandaltylya obitel-generators cnngraphics shoemoney sanhar-php manojkirana kenionatan ijattechnologies dalalsunil1986 githubgobi vhdang2302 sophannareth edsonjorgef1 bperreault witcherdevelopment vexa256 nuzulfikrie saidelghamri mo7amed3la2 matthiscock a-mourad saidbakr muisawe nionsisre ajunlonglive balasubrahmanyamd alithedev tomalibianca apachesep steffessonatype

laracrud's Issues

Undefined property: App\Models\.... on line 101 in ...\lluminate\Database\Eloquent\Relations\BelongsTo.php

With the command

php artisan laracrud:controller Issuance --api

I'm getting the error:

Undefined property: App\Models\Issuance::$weeklynetorderid on line 101 in C:\xampp2\htdocs\myapp\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Relations\BelongsTo.php

weeklynetorderid is the foreign key pointing to an id column in another table. The function within the Issuance model is

public function weeklynetorderid()
{
    return $this->belongsTo(WeeklyNetorder::class,'weeklynetorderid');
}

I generated WeeklyNetorder model already which is being referred to.

My searches for this error seems to indicate when there is confusion between weeklynetorderid as a function or as a property but it hasn't made a solution clearer to me.

How can I troubleshoot?

Give them user option to Give name of File and Class

Route Resource compatible Controller

Rewrite controller Methods and make it compatible with Route::resource

Dev or production Dependency?

I noticed this shows up under require rather than require-dev in composer.json.

Is there any reason?

Latest release PHP 8 compatability

Remove Middleware from Route Group

Remove middleware index from Route group. So it can be works fine in Laravel 5.1

supporting laravel 9?

Just wanting to know if this will be upgraded to support Laravel 9?

Unable to generate controllers

Hello,

I've generated models from the tables using the steps that were outlined. However, when it comes to generating the controller, I'm getting the below error:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'where `id` is null' at line 1 (Connection: mysql, SQL: update `users` set  where `id` is null) on line 760 in /vendor/laravel/framework/src/Illuminate/Database/Connection.php

I cannot fathom the source of this issue. Clearly the value between set and where is missing. But, I don't know where or why a query is being executed.

Any help will be appreciated.

Thanks!

Add options --only and --except to get or remove columns

Developer can easily pass which column they need to show in view by passing --only or --except

Like laracrud:model users --only=id,name,email

Or
laracrud:model users --except=remember_token.

Also developer can able to create observer and policy for model by passing --observer and --policy respectively .

Create Chart based on database table rows

Programmer can easily able to create a chart with a simple command.
Input
Table One or more.
Chart Type
Options

Create a demo project

Create a demo project and display all possible option so user can see how this tool can help before using it.

Multiple relationship to same table, Cannot redeclare App\Models\...

Hello,

When there is a relationship like a table A to table B in field A1, and with table B in field A2, it will result in getB defined twice, the proposed solution is to concatenate the field name: getBA1 and getBA2

I would happy if you give some guide to locate the part of the code responsible to define the method/function names for relationships in order to fork the project, fix and submit a pull request.

Here is the output

php artisan laracrud:mvc usuarios

   Symfony\Component\ErrorHandler\Error\FatalError

  Cannot redeclare App\Models\Usuario::avantelInventarioSimcards()

  at ...\app\Models\Usuario.php:196
    192▕     * avantelInventarioSimcards
    193▕     *
    194▕     * @return \Illuminate\Database\Eloquent\Relations\HasMany
    195▕     */
  ➜ 196▕     public function avantelInventarioSimcards()
    197▕     {
    198▕         return $this->hasMany(AvantelInventarioSimcard::class,'usuario_ult_edicion');
    199▕     }
    200▕

Because there is an uncaught fatal error, the script stopped generating anything else.

Templates not Created - Customize Code Template

The templates outlined in the readme section

Customize Code Template

Are not created

Duplicated fileds

There are duplicated files when created a model from DB. The last filed is duplicated.

Create Config file

Load all possible value from configuration file.

Create ServiceProvider Class

Add search box in index page

Add a search box named q in index page.

Check Laravel Version and load appropriate config and Route Group middleware

  $laravel  = app();
  $version  = $laravel::VERSION;

MVC create not working

on php artisan laracrud:mvc fields
it product this error.

Class \App\App\Field does not exist

Also view and controller does not working.

add search Scope in Model

API

Create necessary files and class to make RestFul API

Add docs to Model

Add additional docs to the header of Model to define relations as property of Model also scopes as a method of Model. So it can be auto suggested while accessing model from Object Context

It is compatible with lumen 5.6.+?

After add "digitaldream/laracrud": "3.*" on composer.json

composer update
Loading composer repositories with package information
Updating dependencies (including require-dev)
Package operations: 5 installs, 2 updates, 24 removals
  - Removing illuminate/console (v5.6.20)
  - Removing illuminate/routing (v5.6.20)
  - Removing illuminate/session (v5.6.20)
  - Removing illuminate/view (v5.6.20)
  - Removing illuminate/validation (v5.6.20)
  - Removing illuminate/translation (v5.6.20)
  - Removing illuminate/support (v5.6.20)
  - Removing illuminate/queue (v5.6.20)
  - Removing illuminate/pipeline (v5.6.20)
  - Removing illuminate/pagination (v5.6.20)
  - Removing illuminate/log (v5.6.20)
  - Removing illuminate/http (v5.6.20)
  - Removing illuminate/hashing (v5.6.20)
  - Removing illuminate/filesystem (v5.6.20)
  - Removing illuminate/events (v5.6.20)
  - Removing illuminate/encryption (v5.6.20)
  - Removing illuminate/container (v5.6.20)
  - Removing illuminate/config (v5.6.20)
  - Removing illuminate/cache (v5.6.20)
  - Removing illuminate/bus (v5.6.20)
  - Removing illuminate/broadcasting (v5.6.20)
  - Removing illuminate/mail (v5.6.20)
  - Removing illuminate/database (v5.6.20)
  - Removing illuminate/auth (v5.6.20)
  - Updating nesbot/carbon (1.27.0 => 1.25.0): Loading from cache
  - Installing digitaldream/dbreader (1.4): Downloading (100%)         
  - Installing paragonie/random_compat (v2.0.12): Loading from cache
  - Installing ramsey/uuid (3.7.3): Loading from cache
  - Installing league/flysystem (1.0.44): Loading from cache
  - Updating laravel/framework (v5.6.20 => v5.6.20): Downloading (100%)         
  - Installing digitaldream/laracrud (3.1.1): Downloading (100%)         
paragonie/random_compat suggests installing ext-libsodium (Provides a modern crypto API that can be used to generate random bytes.)
ramsey/uuid suggests installing ircmaxell/random-lib (Provides RandomLib for use with the RandomLibAdapter)
ramsey/uuid suggests installing ext-libsodium (Provides the PECL libsodium extension for use with the SodiumRandomGenerator)
ramsey/uuid suggests installing ext-uuid (Provides the PECL UUID extension for use with the PeclUuidTimeGenerator and PeclUuidRandomGenerator)
ramsey/uuid suggests installing moontoast/math (Provides support for converting UUID to 128-bit integer (in string form).)
ramsey/uuid suggests installing ramsey/uuid-doctrine (Allows the use of Ramsey\Uuid\Uuid as Doctrine field type.)
ramsey/uuid suggests installing ramsey/uuid-console (A console application for generating UUIDs with ramsey/uuid)
league/flysystem suggests installing league/flysystem-aws-s3-v2 (Allows you to use S3 storage with AWS SDK v2)
league/flysystem suggests installing league/flysystem-aws-s3-v3 (Allows you to use S3 storage with AWS SDK v3)
league/flysystem suggests installing league/flysystem-azure (Allows you to use Windows Azure Blob storage)
league/flysystem suggests installing league/flysystem-cached-adapter (Flysystem adapter decorator for metadata caching)
league/flysystem suggests installing league/flysystem-eventable-filesystem (Allows you to use EventableFilesystem)
league/flysystem suggests installing league/flysystem-rackspace (Allows you to use Rackspace Cloud Files)
league/flysystem suggests installing league/flysystem-sftp (Allows you to use SFTP server storage via phpseclib)
league/flysystem suggests installing league/flysystem-webdav (Allows you to use WebDAV storage)
league/flysystem suggests installing league/flysystem-ziparchive (Allows you to use ZipArchive adapter)
league/flysystem suggests installing spatie/flysystem-dropbox (Allows you to use Dropbox storage)
league/flysystem suggests installing srmklive/flysystem-dropbox-v2 (Allows you to use Dropbox storage for PHP 5 applications)
digitaldream/laracrud suggests installing intervention/image (For Image)
digitaldream/laracrud suggests installing tymon/jwt-auth (For API authentication)
digitaldream/laracrud suggests installing dingo/api (To make API)
Writing lock file
Generating autoload files
marcodasilva@LAPTOP-MADSA01:/data/www/eureka/APJ-api$ php artisan
PHP Fatal error:  Uncaught ReflectionException: Class path.storage does not exist in /data/www/eureka/APJ-api/vendor/laravel/framework/src/Illuminate/Container/Container.php:767
Stack trace:
#0 /data/www/eureka/APJ-api/vendor/laravel/framework/src/Illuminate/Container/Container.php(767): ReflectionClass->__construct('path.storage')
#1 /data/www/eureka/APJ-api/vendor/laravel/framework/src/Illuminate/Container/Container.php(646): Illuminate\Container\Container->build('path.storage')
#2 /data/www/eureka/APJ-api/vendor/laravel/framework/src/Illuminate/Container/Container.php(601): Illuminate\Container\Container->resolve('path.storage', Array)
#3 /data/www/eureka/APJ-api/vendor/laravel/lumen-framework/src/Application.php(221): Illuminate\Container\Container->make('path.storage', Array)
#4 /data/www/eureka/APJ-api/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php(119): Laravel\Lumen\Application->make('path.storage', Array)
#5 /data/www/eureka/APJ-api/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php(874): a in /data/www/eureka/APJ-api/vendor/laravel/framework/src/Illuminate/Container/Container.php on line 767

In Container.php line 767:
                                                                                                                                                                    
  Uncaught ReflectionException: Class path.storage does not exist in /data/www/eureka/APJ-api/vendor/laravel/framework/src/Illuminate/Container/Container.php:767   
  Stack trace:                                                                                                                                                      
  #0 /data/www/eureka/APJ-api/vendor/laravel/framework/src/Illuminate/Container/Container.php(767): ReflectionClass->__construct('path.storage')                    
  #1 /data/www/eureka/APJ-api/vendor/laravel/framework/src/Illuminate/Container/Container.php(646): Illuminate\Container\Container->build('path.storage')           
  #2 /data/www/eureka/APJ-api/vendor/laravel/framework/src/Illuminate/Container/Container.php(601): Illuminate\Container\Container->resolve('path.storage', Array)  
  #3 /data/www/eureka/APJ-api/vendor/laravel/lumen-framework/src/Application.php(221): Illuminate\Container\Container->make('path.storage', Array)                  
  #4 /data/www/eureka/APJ-api/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php(119): Laravel\Lumen\Application->make('path.storage', Array)

Problem with routes generation

Hi, congratulations for the job, I only have one problem the routes are not generated even though the terminal is successful.

Can only be run by console

It is possible that the command can be executed directly in a controller?

Example:

Artisan::call('laracrud:model Test');

When running from a controller:
The command "laracrud:model" does not exist.

Call to undefined functions

Running Laravel 6, PHP Version 7.2 I received the following errors when trying to use Laracrud:

php artisan laracrud:model users

Symfony\Component\Debug\Exception\FatalThrowableError : Call to undefined function LaraCrud\Helpers\str_singular() at C:\laragon\www\goalsetter\vendor\digitaldream\laracrud\src\lara-crud\Helpers\Helper.php:87

php artisan laracrud:controller UserSettings

Symfony\Component\Debug\Exception\FatalThrowableError : Call to undefined function LaraCrud\Crud\camel_case() at C:\laragon\www\goalsetter\vendor\digitaldream\laracrud\src\lara-crud\Crud\Controller.php:185

Add dateTime picker to dates columns

Is it possible to support multiple database configuration???

I have to connect an external database and I thanked that I can create all model with your tool but i don't see the possibility to choose the database.
Have you a plan to implement it?
Thanks
Alessandro

Update Route names in View and controller

Update route names in views and controllers to make it work with Route Resource

Namespace issues

I am getting namespace conflicts on "Model" or "Controller":

php artisan laracrud:model activity_type ActivityType
PHP Fatal error:  Cannot use LaraCrud\Crud\Model as Model because the name is already in use in C:\**********\vendor\digitaldream\laracrud\src\lara-crud\Console\View.php on line 7

In View.php line 7:

  Cannot use LaraCrud\Crud\Model as Model because the name is already in use

I updated Console\View.php to import like:

use LaraCrud\Crud\Model as ModelCrud;

But then I just get this one.

php artisan laracrud:model activity_type ActivityType

PHP Fatal error:  Cannot use LaraCrud\Crud\Controller as Controller because the name is already in use in C:\*********\vendor\digitaldream\laracrud\src\lara-crud\Console\Mvc.php on line 7

In Mvc.php line 7:

  Cannot use LaraCrud\Crud\Controller as Controller because the name is already in use

Have you encountered this before? PHP version 5.6.37 and my composer requires look like this:

"require": {
      "php": ">=5.6.4",
      "laravel/framework": "5.4.*",
      "laravel/tinker": "~1.0",
      "digitaldream/laracrud": "3.*"
    },

Error during the migration generation

I am getting an error when trying to generate migration from DB.

vendor\digitaldream\laracrud\src\lara-crud\Crud\MigrationCrud.php:222
218| * @throws \Exception
219| */
220| public function generateClassName($table)
221| {

222| $class = 'create' . ucfirst(camel_case($table)) . 'Table';
223|
224| if (class_exists($class)) {
225| throw new \Exception('Migration for table ' . $table . ' already exists');
226| }

Exception trace:

1 LaraCrud\Crud\MigrationCrud::generateClassName("users")
vendor\digitaldream\laracrud\src\lara-crud\Crud\MigrationCrud.php:94

2 LaraCrud\Crud\MigrationCrud::template()
vendor\digitaldream\laracrud\src\lara-crud\Crud\MigrationCrud.php:110

Please use the argument -v to see more details.

Doesn't work on Laravel 7.x, PHP 7.4

# php artisan laracrud:package Laracrud
mkdir(): No such file or directory on line 67 in /application/vendor/digitaldream/laracrud/src/lara-crud/Crud/Package.php

# php artisan laracrud:mvc users --api
in_array() expects parameter 2 to be array, null given

# php -v
PHP 7.4.4 (cli) (built: Mar 20 2020 13:47:45) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
    with Zend OPcache v7.4.4, Copyright (c), by Zend Technologies

# composer info | grep laravel/
laravel/framework                     v7.18.0    The Laravel Framework.
laravel/horizon                       v4.3.3     Dashboard and code-driven configuration for Laravel queues.
laravel/passport                      v9.3.0     Laravel Passport provides OAuth2 server support to Laravel.
laravel/tinker                        v2.4.0     Powerful REPL for the Laravel framework.
laravel/ui                            v2.1.0     Laravel UI utilities and presets.

add commands in serviceprovider see comment

Hi, didn't wanna create a pull request otherwise I have to fork your repository and dont want that.

You can register your commands by doing like is done in my package. Use it as an example:

https://github.com/filipveschool/packagegenerator/blob/master/src/PackagerServiceProvider.php

I hope this is clear and can help you. It is not a very good package if people have to register the commands by themself is it :) ;).