Skip to content
/ sfdb Public

Application build in Laravel with Spatie (User Roles and Permission setup) along with polymorphic complex database relationship, Database Seeder, Modular application (Different set of code for Frontend and backend of the app)

Notifications You must be signed in to change notification settings

jainsubh/sfdb

Repository files navigation

regex:/^(?=.?[A-Z])(?=.?[a-z])(?=.?[0-9])(?=.?[#?!@$%^&*-]).{6,}$/' Should have At least one Uppercase letter. At least one Lower case letter. Also,At least one numeric value. And, At least one special character. Must be more than 8 characters long.

use mews/captcha package In LoginController I have to override validate methods to get that captcha working for Login Screen

php artisan db:seed -- This will re-generate all database structure -- Also will create all user roles -- Create one administrator, few managers and analyst -- Default permissions will be assign to manager and analyst -- Default conuntires and locations will be added -- Default Report Templates layout management will be add

php artisan db:seed --class=UserSeeder

-- Under mail configuration, if we want to turn off mail then Pretend should be true

php artisan module:make-controller {name} {module_name} //to make controller in module php artisan module:make-model {name} {module_name} //to make model in module

php artisan migrate php artisan make:migration {migration_name} eg: create_global_keywords_table php artisan migrate --path=/database/migrations/test/

php artisan auth:permission {name} php artisan auth:permission {name} --remove

php artisan make:seeder {filename} //make a seeder class php artisan db:seed //run all migration and its seeders alover again php artisan db:seed --class={filename} //run single seeder file

composer update //To update the composer with latest packages installed

composer install --ignore-platform-reqs //skip php requirement and update composer composer dump-autoload //It just regenerates the list of all classes that need to be included in the project

php artisan config:clear //remove the configuration cache file php artisan cache:forget spatie.permission.cache //to clear permissions cache

php artisan activitylog:clean

cd Extract-PDF-Crawl-Script source venv/bin/activate cd pdf/spiders/ python ORM.py # This command to be run only once which creates the db tables - pdf, proxy and url cd /home/sfuser/Extract-PDF-Crawl-Script scrapy crawl root -a use_proxies=false

SELECT count(*) as Total_Records, deliver_status as Status_Code FROM tbl_results group by deliver_status UPDATE tbl_results SET deliver_status= NULL WHERE deliver_status = 400

composer update composer require rap2hpoutre/fast-excel
composer require doctrine/dbal composer dump-autoload

'FastExcel' => Rap2hpoutre\FastExcel\Facades\FastExcel::class

which pdftotext If it is installed it will return the path to the binary. which you have to define as in constant

apt-get install poppler-utils

brew install poppler

yum install poppler-utils

km - KnowledgeMap Automatic Institute script crawl - Extract-PDF-Crawl-Script twends - Twitter API

/usr/local/bin/wkhtmltopdf --zoom .75 http://sf.mgdsw.info/pdf-pages-table/report-1.html example3.pdf

/home/sfuser/env_original_20201004

TRUNCATE TABLE tbl_sites; TRUNCATE TABLE tbl_site_categories; TRUNCATE TABLE tbl_categories; TRUNCATE TABLE tbl_globals; TRUNCATE TABLE tbl_topics; TRUNCATE TABLE tbl_topic_categories;

TRUNCATE TABLE tbl_results; TRUNCATE TABLE tbl_crawl_events; TRUNCATE TABLE tbl_crawl_logs;

Before doing steps, set the db migration as per required (User & permissions, MetaData, ReportTemplates)

  1. Take pull of the latest Code
  2. Make changes to env file
  3. composer install or update
  4. php artisan db:seed

In case facing any Permission issues in db seed

  1. Try to clear cache with php artisan config:cache or php aritsan cache:clear, php aritsan config:clear

  2. Try to clear permissions cache php artisan cache:forget spatie.permission.cache

  3. Give access to app/storage folder in order to prevent from file_put_contents failed to open stream permission denied error

About

Application build in Laravel with Spatie (User Roles and Permission setup) along with polymorphic complex database relationship, Database Seeder, Modular application (Different set of code for Frontend and backend of the app)

Topics

Resources

Stars

Watchers

Forks

Packages

No packages published