Giter Club home page Giter Club logo

eflinventory-v2's Introduction

About EFLInventory-V2

EFLInventory V2 is a simple-to-use, web and PC inventory and point-of-sale application written in PHP using Laravel framework. It uses MySQL as the data backend and has a Bootstrap 4 material-like user interface. It is designed to assist small-scale retail stores with keeping track of items and inventory, and generate reports based on inventory, purchases and sales.

Well, What Can I Do With It?

  • Manage products and product variations
  • Manage product categories and sub-categories
  • Stock products by batch. Enables proper handling of product expiry date, product price change, e.t.c.
  • Record damaged products.
  • Generate a range of purchase and sales reports
  • Easily migrate from existing records (using a predefined Excel template)
  • Track and record major user actions such as create, update and delete. When you have more than 1 staff selling and/or managing products, you might one day want to know who did what.
  • Assign roles to users. Default available roles are "Manager" and "Employee". No much option for now. Future updates will allow custom roles and defining actions for such roles. You can also make a request if you really do need one and can't fix it on your own
  • Stock and sell products using a barcode scanner
  • Sell products from point-of-sale (POS) with good-looking UI and great options
  • Print sales receipt for every POS sale

Screenshots

Home Screen

POS Screen

Migrate Screen (Migrate from previous records using a predefined MS Excel template)

SEE MORE

Setup

  1. Easiest way to get started with this:
git clone https://github.com/chrisidakwo/eflinventory-v2.git
cd eflinventory-v2
  1. Run from command prompt
composer install
  1. Copy .env.example to .env. Update details to suit your server & DB setup.

  2. Generate application key using: php artisan key:generate

  3. To create database tables either run these two commands:

php artisan migrate

php artisan migrate:seed

or run the database.sql script.

If you're gonna be running the SQL script, please ensure to look through it before running. It's not a harmful script, but just be sure. The database.sql file is located within the bootstrap directory.

Manager login details:
Username: chrisidakwo
Password: secret

User Interface

Material Pro Admin Template is the UI theme used for this application.

Known Issues (as of 10th Aug 2020)

  • Unhandled exceptions for migration using Excel spreadsheets.

TODO

  • Frequent database backup to Google Drive or Dropbox

License

EFLInventory-V2 is an open-source software licensed under the GPU v3 License.

eflinventory-v2's People

Contributors

chrisidakwo avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

eflinventory-v2's Issues

installation issue

Hi I am getting this error
Fatal error: Uncaught Error: Call to a member function make() on array in D:\xampp\htdocs\p2\eflinventory-v2\artisan:33
Stack trace:
#0 {main}
thrown in D:\xampp\htdocs\p2\eflinventory-v2\artisan on line 33
Script @php artisan package:discover handling the post-autoload-dump event returned with error code 255

please help

Error Artisan

I'm trying to run the command php artisan migrate a it's generating these error bellow:

Illuminate\Database\QueryException : SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = inventory and table_name = migrations)

at /Users/euclidesmauro/code/Laravel/vmce/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
660| // If an exception occurs when attempting to run a query, we'll format the error
661| // message to include the bindings with SQL, which will make this exception a
662| // lot more helpful to the developer instead of just the database's errors.
663| catch (Exception $e) {

664| throw new QueryException(
665| $query, $this->prepareBindings($bindings), $e
666| );
667| }
668|

Exception trace:

1 PDOException::("SQLSTATE[HY000] [2002] No such file or directory")
/Users/euclidesmauro/code/Laravel/vmce/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:70

2 PDO::__construct("mysql:unix_socket=/var/run/mysqld/mysqld.sock;dbname=inventory", "root", "Admin@dev2019!", [])
/Users/euclidesmauro/code/Laravel/vmce/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:70

Please use the argument -v to see more details.

I don't understand why, cause my .env file is ok, I have configured the Database.php as well, do you have any idea why?

Unable to install and get it working

I have followed the steps mentioned in the Installation document.

I ran the .sql script directly and renamed necessary files. When I visit the browser and type http://localhost/eflinventory-v2 OR http://localhost/eflinventory-v2/public, nothing shows up. Its a 500 Internal Server Error. The DB works just fine.

I am new to Laravel. I later from terminal ran php artisan serve. And again, using the same URLs in the browser give me 500 Internal Server Error. Could you please help?

This is my .env file

APP_NAME=AppName
APP_ENV=production
APP_KEY=
APP_DEBUG=false
APP_LOG_LEVEL=debug
APP_URL=http://localhost/eflinventory-v2

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=emifoodlovers
DB_USERNAME=root
DB_PASSWORD=adminpass

BROADCAST_DRIVER=log
CACHE_DRIVER=file
SESSION_DRIVER=file
QUEUE_DRIVER=sync

REDIS_HOST=127.0.0.1
REDIS_PASSWORD=null
REDIS_PORT=6379

MAIL_DRIVER=smtp
MAIL_HOST=smtp.mailtrap.io
MAIL_PORT=2525
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ENCRYPTION=null

PUSHER_APP_ID=
PUSHER_APP_KEY=
PUSHER_APP_SECRET=

FILESYSTEM_CLOUD=google
GOOGLE_DRIVE_CLIENT_ID=
GOOGLE_DRIVE_CLIENT_SECRET=
GOOGLE_DRIVE_REFRESH_TOKEN=
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

This is my app.php file

env('APP_NAME', 'AppName'), /* |-------------------------------------------------------------------------- | Application Environment |-------------------------------------------------------------------------- | | This value determines the "environment" your application is currently | running in. This may determine how you prefer to configure various | services your application utilizes. Set this in your ".env" file. | */ 'env' => env('APP_ENV', 'production'), /* |-------------------------------------------------------------------------- | Application Debug Mode |-------------------------------------------------------------------------- | | When your application is in debug mode, detailed error messages with | stack traces will be shown on every error that occurs within your | application. If disabled, a simple generic error page is shown. | */ 'debug' => env('APP_DEBUG', false), /* |-------------------------------------------------------------------------- | Application URL |-------------------------------------------------------------------------- | | This URL is used by the console to properly generate URLs when using | the Artisan command line tool. You should set this to the root of | your application so that it is used when running Artisan tasks. | */ 'url' => env('APP_URL', 'http://localhost/eflinventory-v2'), /* |-------------------------------------------------------------------------- | Application Timezone |-------------------------------------------------------------------------- | | Here you may specify the default timezone for your application, which | will be used by the PHP date and date-time functions. We have gone | ahead and set this to a sensible default for you out of the box. | */ 'timezone' => 'UTC', /* |-------------------------------------------------------------------------- | Application Locale Configuration |-------------------------------------------------------------------------- | | The application locale determines the default locale that will be used | by the translation service provider. You are free to set this value | to any of the locales which will be supported by the application. | */ 'locale' => 'en', /* |-------------------------------------------------------------------------- | Application Fallback Locale |-------------------------------------------------------------------------- | | The fallback locale determines the locale to use when the current one | is not available. You may change the value to correspond to any of | the language folders that are provided through your application. | */ 'fallback_locale' => 'en', /* |-------------------------------------------------------------------------- | Encryption Key |-------------------------------------------------------------------------- | | This key is used by the Illuminate encrypter service and should be set | to a random, 32 character string, otherwise these encrypted strings | will not be safe. Please do this before deploying an application! | */ 'key' => env('APP_KEY'), 'cipher' => 'AES-256-CBC', /* |-------------------------------------------------------------------------- | Logging Configuration |-------------------------------------------------------------------------- | | Here you may configure the log settings for your application. Out of | the box, Laravel uses the Monolog PHP logging library. This gives | you a variety of powerful log handlers / formatters to utilize. | | Available Settings: "single", "daily", "syslog", "errorlog" | */ 'log' => env('APP_LOG', 'single'), 'log_level' => env('APP_LOG_LEVEL', 'debug'), /* |-------------------------------------------------------------------------- | Autoloaded Service Providers |-------------------------------------------------------------------------- | | The service providers listed here will be automatically loaded on the | request to your application. Feel free to add your own services to | this array to grant expanded functionality to your applications. | */ 'providers' => [ /* * Laravel Framework Service Providers... */ Illuminate\Auth\AuthServiceProvider::class, Illuminate\Broadcasting\BroadcastServiceProvider::class, Illuminate\Bus\BusServiceProvider::class, Illuminate\Cache\CacheServiceProvider::class, Illuminate\Foundation\Providers\ConsoleSupportServiceProvider::class, Illuminate\Cookie\CookieServiceProvider::class, Illuminate\Database\DatabaseServiceProvider::class, Illuminate\Encryption\EncryptionServiceProvider::class, Illuminate\Filesystem\FilesystemServiceProvider::class, Illuminate\Foundation\Providers\FoundationServiceProvider::class, Illuminate\Hashing\HashServiceProvider::class, Illuminate\Mail\MailServiceProvider::class, Illuminate\Notifications\NotificationServiceProvider::class, Illuminate\Pagination\PaginationServiceProvider::class, Illuminate\Pipeline\PipelineServiceProvider::class, Illuminate\Queue\QueueServiceProvider::class, Illuminate\Redis\RedisServiceProvider::class, Illuminate\Auth\Passwords\PasswordResetServiceProvider::class, Illuminate\Session\SessionServiceProvider::class, Illuminate\Translation\TranslationServiceProvider::class, Illuminate\Validation\ValidationServiceProvider::class, Illuminate\View\ViewServiceProvider::class, /* * Package Service Providers... */ /* * Application Service Providers... */ App\Providers\AppServiceProvider::class, App\Providers\AuthServiceProvider::class, // App\Providers\BroadcastServiceProvider::class, App\Providers\EventServiceProvider::class, App\Providers\RouteServiceProvider::class, Barryvdh\LaravelIdeHelper\IdeHelperServiceProvider::class, Intervention\Image\ImageServiceProvider::class, Darryldecode\Cart\CartServiceProvider::class, App\Providers\GoogleDriveServiceProvider::class ], /* |-------------------------------------------------------------------------- | Class Aliases |-------------------------------------------------------------------------- | | This array of class aliases will be registered when this application | is started. However, feel free to register as many as you wish as | the aliases are "lazy" loaded so they don't hinder performance. | */ 'aliases' => [ 'App' => Illuminate\Support\Facades\App::class, 'Artisan' => Illuminate\Support\Facades\Artisan::class, 'Auth' => Illuminate\Support\Facades\Auth::class, 'Blade' => Illuminate\Support\Facades\Blade::class, 'Broadcast' => Illuminate\Support\Facades\Broadcast::class, 'Bus' => Illuminate\Support\Facades\Bus::class, 'Cache' => Illuminate\Support\Facades\Cache::class, 'Config' => Illuminate\Support\Facades\Config::class, 'Cookie' => Illuminate\Support\Facades\Cookie::class, 'Crypt' => Illuminate\Support\Facades\Crypt::class, 'DB' => Illuminate\Support\Facades\DB::class, 'Eloquent' => Illuminate\Database\Eloquent\Model::class, 'Event' => Illuminate\Support\Facades\Event::class, 'File' => Illuminate\Support\Facades\File::class, 'Gate' => Illuminate\Support\Facades\Gate::class, 'Hash' => Illuminate\Support\Facades\Hash::class, 'Lang' => Illuminate\Support\Facades\Lang::class, 'Log' => Illuminate\Support\Facades\Log::class, 'Mail' => Illuminate\Support\Facades\Mail::class, 'Notification' => Illuminate\Support\Facades\Notification::class, 'Password' => Illuminate\Support\Facades\Password::class, 'Queue' => Illuminate\Support\Facades\Queue::class, 'Redirect' => Illuminate\Support\Facades\Redirect::class, 'Redis' => Illuminate\Support\Facades\Redis::class, 'Request' => Illuminate\Support\Facades\Request::class, 'Response' => Illuminate\Support\Facades\Response::class, 'Route' => Illuminate\Support\Facades\Route::class, 'Schema' => Illuminate\Support\Facades\Schema::class, 'Session' => Illuminate\Support\Facades\Session::class, 'Storage' => Illuminate\Support\Facades\Storage::class, 'URL' => Illuminate\Support\Facades\URL::class, 'Validator' => Illuminate\Support\Facades\Validator::class, 'View' => Illuminate\Support\Facades\View::class, 'Image' => Intervention\Image\Facades\Image::class, 'Cart' => Darryldecode\Cart\Facades\CartFacade::class ], ]; >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

404 not found

missing
/css/theme/app.css
/css/theme/custom.min.js

image

Problem with login and css on while trying to launch local server

Hi, thanks for your project, it's very interesting, I didn't yet managed to run it correctely

  • I created a local mysql database,
  • and used the database.sql script
  • then I added manually users into EFLInventory db

now I'm getting error while trying to login, I tried to disable password hashing but as I'm not good enough in php frameworks, I didn't maneged to fix this, it would have been easier if there was a signup page though.

Capture d’écran 2020-11-26 à 18 34 22

Composer Install returns error

Ubuntu 16.04
Php 7.2
MySql and Apache installed and working

I ran

  1. git clone https://github.com/chrisidakwo/eflinventory-v2.git
  2. cd eflinventory-v2
  3. composer install

Error :
Generating optimized autoload files

Illuminate\Foundation\ComposerScripts::postAutoloadDump
@php artisan package:discover

[Exception]
Unable to load the "app" configuration file.

Script @php artisan package:discover handling the post-autoload-dump event returned with error code 1
screenshot from 2019-03-05 20-08-21

Unable to install

Hello,

i follow the process but am unable to install , am getting this error:
[Exception]
Unable to load the "app" configuration file.

could you guide me on how to install it on a localhost server (Wamp)

Thanks

Failed to install

Every other step was successful till here...

C:\wamp64\www\EFLInventory-V2>php artisan key:generate

[Symfony\Component\Debug\Exception\FatalThrowableError]
Type error: Argument 2 passed to Illuminate\Routing\UrlGenerator::__construct() must be an instance of Illuminate\Http\Request, null given, called in C:\wamp64\www
\EFLInventory-V2\vendor\laravel\framework\src\Illuminate\Routing\RoutingServiceProvider.php on line 67

Screenshot (7)

Composer file missing from project

After cloning the repository and trying to install the composer dependencies, i realized that, there is no composer.json file in the project.

After running composer install in the terminal , i got this.

Composer could not find a composer.json file in /opt/lampp/htdocs/eflinventory-v2 To initialize a project, please create a composer.json file. See https://getcomposer.org/basic-usage
.

Problem on CSS

I have successfully installed the repo but when I successfully login but the CSS is not running that is why the display is not good.

Unable to login

Please I get this error when I login. The php artisan serve runs successfully though.

Screenshot (9)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.