Tips Posts
Efficient and Fast Data Import with Laravel Jobs & QueuesLaravel

Efficient and Fast Data Import with Laravel Jobs & QueuesLaravel
Recently Spatie released a brand new package for multi-tenancy called laravel-multitenancy.
It comes with great support to work out of the box with sub-domains like,
https://zluck.infychat.com
https://infyom.infychat.com
https://vasundhara.infychat.com
It identifies the tenant based on the sub-domain and sets a database runtime for your tenant-specific models.
Recently, we used it in one of our clients for Snow Removal CRM. Here we have two models,
- Freemium Model - with no sub-domain (application will work on main domain only)
- Premium Model - where the tenant will get its subdomain
And a user can convert his account from Freemium to Premium at any point in time by just subscribing to the plan.
So what we want is, on the backend, we want to have a separate database for each tenant, but the application should run on main as well as a sub-domain.
So what we want to have is the ability to extend/customize the tenant detection mechanism. And Spatie does a very good job there where you can customize the logic.
You can create your own TenantFinder class and configure it in the config file of the package. And there is very good documentation for that here:herehttps://docs.spatie.be/laravel-multitenancy/v1/installation/determining-current-tenant/
To do that, what we did is, we have a field called tenant_id
in our users
table. All of our users are stored in the main database since we may have user access across the tenant.
And when any user does a login, we listen for the event Illuminate\Auth\Events\Login
which is documented in Laravel Docs over here.
When a user does a login, our listener will be called and will create a cookie called tenant
on the browser with the tenant id of the user. So our listener will look like,
<?php
namespace App\Listeners;
use App\Models\User;
use Cookie;
use Illuminate\Auth\Events\Login;
class LoginListener
{
public function handle(Login $event)
{
/* @var User $authUser /
$authUser = $event->user;
Cookie::forget('tenant');
Cookie::queue(Cookie::forever('tenant', encrypt($authUser->tenant_id)));
}
}
Also, we encrypt the cookie on our end, so we do not want Laravel to encrypt it again, so we added the tenant
cookie into except array of EncryptCookies
middleware as per documentation here. so our middleware looks like,
<?php
namespace App\Http\Middleware;
use Illuminate\Cookie\Middleware\EncryptCookies as Middleware;
class EncryptCookies extends Middleware
{
/**
The names of the cookies should not be encrypted.
@var array
/
protected $except = [undefined];
}
Now at the last point, we extended our logic to find a tenant and get it to work on the main domain as well as sub-domain.
We have created our own custom class called InfyChatTenantFinder
, which looks like,
<?php
namespace App\TenantFinder;
use App\Models\Account;
use App\Models\SubDomain;
use Illuminate\Http\Request;
use Spatie\Multitenancy\Models\Concerns\UsesTenantModel;
use Spatie\Multitenancy\Models\Tenant;
use Spatie\Multitenancy\TenantFinder\TenantFinder;
class InfyChatTenantFinder extends TenantFinder
{
use UsesTenantModel;
public function findForRequest(Request $request): ?Tenant
{
$host = $request->getHost();
list($subDomain) = explode('.', $host, 2);
// Get Tenant by subdomain if it's on subdomain
if (!in_array($subDomain, ["www", "admin", "infychat"])) {
return $this->getTenantModel()::whereDomain($host)->first();
}
// Get Tenant from user's account id if it's main domain
if (in_array($subDomain, ["www", "infychat"])) {
if ($request->hasCookie('tenant')) {
$accountId = $request->cookie('tenant');
$accountId = decrypt($accountId);
$account = $this->getTenantModel()::find($accountId);
if (!empty($account)) {
return $account;
}
\Cookie::forget('tenant');
}
}
return null;
}
}
So basically, first we check if the sub-domain is there, then find a tenant from the sub-domain.
If the domain is the main domain then get the tenant id from the cookie and return the account (tenant) model.
So this is how you can customize the logic the way you want to have a custom tenant identification system.
How to remove public path from URL in Laravel ApplicationLaravel

How to remove public path from URL in Laravel ApplicationLaravel
While hosting on the Laravel project on cPanel, the traditional problem that lots of developers get is, /public
path is appended to the URL. Because in most cases, we put a project directly into the public_html
folder, so public_html
is our root for the website and that's where our laravel application is also placed.
But to run the Laravel application, we need to point our domain root to the public
folder of the laravel. It is possible to do it with cPanel but you need to go through some steps which are not known by most of the people and also the tedious process. So to make it simple, what you can do is, there is a way we can do it via the .htaccess
file in our root folder.
We can copy the .htaccess
file from our public
folder and then make modifications to it to work with the direct root folder and route every request to the public
folder.
Here is the final .htaccess
file,
<IfModule mod_rewrite.c> <IfModule mod_negotiation.c> Options -MultiViews -Indexes </IfModule>
RewriteEngine On
# Handle Authorization MemberHeader
RewriteCond %{HTTP:Authorization} .
RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}]
# Redirect Trailing Slashes If Not A Folder...
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_URI} (.+)/$
RewriteRule ^ %1 [L,R=301]
# Remove public URL from the path
RewriteCond %{REQUEST_URI} !^/public/
RewriteRule ^(.*)$ /public/$1 [L,QSA]
# Handle Front Controller...
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^ index.php [L]
By adding the above file to the root folder we can use laravel projects without the public path. Check out the following two lines:
RewriteCond %{REQUEST_URI} !^/public/ RewriteRule ^(.*)$ /public/$1 [L,QSA]
These two lines make magic and our application will work without public
path in URL.
Custom path generation in Spatie Media Library while multi-tenantLaravel

Custom path generation in Spatie Media Library while multi-tenantLaravel
Recently we use Spatie laravel-multitenancy package in our of our client's CRM project along with spatie/laravel-medialibrary.
The default behavior of the media library package is, it generates a folder for each media with its ID in our configured disk, like a public folder or s3 or whatever disk we configured.
This works really great when you are dealing with a single-tenant application. But while using multi-tenant, you got a media table in each of your tenant databases. so this pattern simply doesn't work. Because then you will end up having multiple media files under the same folder from different tenants.
So what we want to do is, instead of having a structure like,
public -- media
---- 1
------ file.jpg
---- 2
------ file.jpg
...
What we want to achieve is, we want to have a folder structure where media of every tenant will be in a separate folder with tenant unique id,
public -- media
---- abcd1234
// tenant1 Id
------ 1
-------- file.jpg
------ 2
-------- file.jpg
---- efgh5678
// tenant2 Id
------ 1
-------- file.jpg
------ 2
-------- file.jpg
...
Spatie Media library is very configurable out of the box where you can write your own media library path generator. That is documented very well over here
So what we did is, we wrote our own Path Generator, which can store files into tenants folder. Here is how it looks like,
<?php
namespace App\MediaLibrary;
use Spatie\MediaLibrary\MediaCollections\Models\Media;
use Spatie\MediaLibrary\Support\PathGenerator\DefaultPathGenerator;
class InfyCRMMediaPathGenerator extends DefaultPathGenerator
{
/*
Get a unique base path for the given media.
/
protected function getBasePath(Media $media): string
{
$currentTenant = app('currentTenant');
return $currentTenant->unique_id.DIRECTORY_SEPARATOR.$media->getKey();
}
}
What we did here is, we just simply extended the Spatie\MediaLibrary\Support\PathGenerator\DefaultPathGenerator
of Media Library and override the function getBasePath
. We attached the prefix of the tenant's unique_id
to the path. so instead of 1/file.png
, it will return abcd1234/1/file.png
.
All you need to make sure is, whenever you are uploading a media, your application should be tenant aware. Otherwise, it will not able to get the current tenant.
Hope this helps while using spatie media library along with spatie multi-tenant.
Even if you are not using a spatie multi-tenant, still you can create your own PathGenerator and use it your own way to have a media structure you want.
Spatie Laravel Multi-Tenancy without Sub Domain (customize TenantFinder)Laravel

Spatie Laravel Multi-Tenancy without Sub Domain (customize TenantFinder)Laravel
Recently Spatie released a brand new package for multi-tenancy called laravel-multitenancy.
It comes with great support to work out of the box with sub-domains like,
https://zluck.infychat.com
https://infyom.infychat.com
https://vasundhara.infychat.com
It identifies the tenant based on the sub-domain and sets a database runtime for your tenant-specific models.
Recently, we used it in one of our clients for Snow Removal CRM. Here we have two models,
- Freemium Model - with no sub-domain (application will work on main domain only)
- Premium Model - where the tenant will get its subdomain
And a user can convert his account from Freemium to Premium at any point in time by just subscribing to the plan.
So what we want is, on the backend, we want to have a separate database for each tenant, but the application should run on main as well as a sub-domain.
So what we want to have is the ability to extend/customize the tenant detection mechanism. And Spatie does a very good job there where you can customize the logic.
You can create your own TenantFinder class and configure it in the config file of the package. And there is very good documentation for that here:https://docs.spatie.be/laravel-multitenancy/v1/installation/determining-current-tenant/
To do that, what we did is, we have a field called tenant_id
in our users
table. All of our users are stored in the main database since we may have user access across the tenant.
And when any user does a login, we listen for the event Illuminate\Auth\Events\Login
which is documented in Laravel Docs over here.
When a user does a login, our listener will be called and will create a cookie called tenant
on the browser with the tenant id of the user. So our listener will look like,
<?php
namespace App\Listeners;
use App\Models\User;
use Cookie;
use Illuminate\Auth\Events\Login;
class LoginListener
{
public function handle(Login $event)
{
/* @var User $authUser /
$authUser = $event->user;
Cookie::forget('tenant');
Cookie::queue(Cookie::forever('tenant', encrypt($authUser->tenant_id)));
}
}
Also, we encrypt the cookie on our end, so we do not want Laravel to encrypt it again, so we added the tenant
cookie into except array of EncryptCookies
middleware as per documentation here. so our middleware looks like,
<?php
namespace App\Http\Middleware;
use Illuminate\Cookie\Middleware\EncryptCookies as Middleware;
class EncryptCookies extends Middleware
{
/**
The names of the cookies should not be encrypted.
@var array
/
protected $except = [undefined];
}
Now at the last point, we extended our logic to find a tenant and get it to work on the main domain as well as sub-domain.
We have created our own custom class called InfyChatTenantFinder
, which looks like,
<?php
namespace App\TenantFinder;
use App\Models\Account;
use App\Models\SubDomain;
use Illuminate\Http\Request;
use Spatie\Multitenancy\Models\Concerns\UsesTenantModel;
use Spatie\Multitenancy\Models\Tenant;
use Spatie\Multitenancy\TenantFinder\TenantFinder;
class InfyChatTenantFinder extends TenantFinder
{
use UsesTenantModel;
public function findForRequest(Request $request): ?Tenant
{
$host = $request->getHost();
list($subDomain) = explode('.', $host, 2);
// Get Tenant by subdomain if it's on subdomain
if (!in_array($subDomain, ["www", "admin", "infychat"])) {
return $this->getTenantModel()::whereDomain($host)->first();
}
// Get Tenant from user's account id if it's main domain
if (in_array($subDomain, ["www", "infychat"])) {
if ($request->hasCookie('tenant')) {
$accountId = $request->cookie('tenant');
$accountId = decrypt($accountId);
$account = $this->getTenantModel()::find($accountId);
if (!empty($account)) {
return $account;
}
\Cookie::forget('tenant');
}
}
return null;
}
}
So basically, first we check if the sub-domain is there, then find a tenant from the sub-domain.
If the domain is the main domain then get the tenant id from the cookie and return the account (tenant) model.
So this is how you can customize the logic the way you want to have a custom tenant identification system.
toBase function in Laravel EloquentLaravel

toBase function in Laravel EloquentLaravel
Sometimes we need to load a large amount of data into memory. Like all the models we have in the database.
For e.g. PDF Printing, Perform some global updates, etc.
So the general practices we use in Laravel is to write the following code,
$users = User::all();
Just imagine I have 10,000 users in the database and when I load all the users in one shot.
But it takes a really high amount of memory to load all the records and prepare Laravel Model class objects. And sometimes we also load them in chunks to save the memory, but in some use cases, chunking can not be the option.
Here is the screenshot of mine when I load 10,000 users into memory with the above code.
It's using 37MB memory. Also, imagine the required memory if we are loading some relationships as well with these 10,000 records.
The Eloquent model is a great way to handle operations with lots of features like Mutators, Relationships, and much more.
But we really do not use these features all the time. We simply output or use the direct values which are stored in the table. So ideally, we do not need an eloquent model at all, if we are not going to use these features.
In those cases, Laravel also has a handy function toBase()
. By calling this function it will retrieve the data from the database but it will not prepare the Eloquent models, but will just give us raw data and help us to save a ton of memory.
So my revised code will look something like this,
$users = User::toBase()->get();
Check the revised memory screenshot after adding the toBase
function.
So it almost saves 50% of the memory. It's reduced from 35MB to 20MB and the application also works much much faster, because it doesn't need to spend time in preparing 10,000 Eloquent models.
So if you are not really going to use features of Eloquent and loading a large amount of data, then the toBase
function can be really useful.
Here you can find a full video tutorial for the same.
Make long path shorter in asset function in laravelLaravel

Make long path shorter in asset function in laravelLaravel
Recently, I've started working on one project where we follow modules patterns and for the same, we have different assets folders for the different modules and the folder named common for assets which are common across all the modules.
So our public folder looks like the following,
The problem that I started facing was everywhere I needed to give a full path to import/include any of the files from any of the folders. For e.g.
<img src="{{ asset('assets/tasks/images/delete.png') }}"alt="Delete Task">
Even if we have some folder in images to group similar images then it was even becoming longer. For e.g.
<img src="{{ asset('assets/tasks/images/social/facebook.png') }}" alt="Facebook">
The workaround that I used is, I created one file called helpers.php
and created dedicated asset functions for each of the modules. For e.g., for tasks,
if (!function_exists('tasks_asset')) {
/**
* Generate an asset path for the tasks module folder.
*
* @param string $path
* @param bool|null $secure
* @return string
*/
function tasks_asset($path, $secure = null){
$path = "assets/tasks/".$path;
return app('url')->asset($path, $secure);
}
}
With this function, I can use,
<img src="{{ tasks_asset('images/delete.png') }}" alt="Delete Task">
Other advantages it gives are,
- if in future if the path of tasks folder changed, then I do not need to go and update every single import/include.
- I (or any new developer) do not need to remember the long paths and can always use direct function names for modules.
Even I like this pattern so much, so I went further and created dedicated image function as well,
if (!function_exists('tasks_image')) {
/**
* Generate an asset path for the tasks module images folder.
*
* @param string $path
* @param bool|null $secure
* @return string
*/
function tasks_image($path, $secure = null){
$path = "images/".$path;
return tasks_asset($path, $secure);
}
}
So I can use it as,
<img src="{{ tasks_image('delete.png') }}" alt="Delete Task">
Simple and handy functions to use everywhere.
DateTimeLocal with LaravelCollective Model BindingLaravel

DateTimeLocal with LaravelCollective Model BindingLaravel
Last week, we were working on one project where we were using LaravelCollective for generating our form. LaravelCollective is a really awesome package and reduces lots of efforts, specifically for automatically binding old inputs to our forms.
Problem
With LaravelColletive when we pass null
as a second value, it tried to get old inputs if available and inject them. But for some reason, it was not working with datetimelocal
.
datetimelocal
need a date in Y-m-d\TH:i
Format. When I went into the code of FormBuilder.php it’s already managing that and tries to convert date into that format if you have passed DateTime
object.
So it was completely working fine while creating a record when you do not have any value.
But I have the same form which was used at both the time of Create and Update. And I was passing null
into the value field at both of the time and LaravelCollective injects it automatically from model or old inputs if there is some error. Something like the following,
<div class="form-group col-sm-6">
{!! Form::label('due_date', 'Due Date:') !!}
{!! Form::datetimeLocal('due_date', null, ['class' => 'form-control']) !!}
</div>
So, Due date will be automatically placed from the model. It’s working fine with all other fields except datetimelocal
.
Solution
The reason behind that is, the value is retrieved from model due_date field, but it comes in Carbon instance and when it converts to a date string, it’s converted into default format which is Y-m-d h:i:s
. So it will not work for datetimelocal
input since it requires Y-m-d\TH:i
format.
So as a solution, what change we did is, instead of passing null
value, we first check, if the model is there then pass the value directly to the input. Something like,
<div class="form-group col-sm-6">
{!! Form::label('due_date', 'Due Date:') !!}
{!! Form::datetimeLocal('due_date', (isset($task)) ? $task->due_date : null, ['class' => 'form-control']) !!}
</div>
So, I will check if I have passed the model $task
to the view and then I will pass a due_date value to input. So FormBuilder will convert it to the proper format and it will get displayed into an input.
Now, when we save the form, it will also return the date into Y-m-d\TH:i
format, so again we need to convert it to the proper format. For that, we created a mutate attribute for due_date
in my Task Model.
public function setDueDateAttribute($value)
{
$this->attributes['due_date'] = Carbon::parse($value);
}
And that’s it. Our datetimelocal
input gets working. I have seen lots of issues on stackoverflow for it. So hope it may help someone.
Things/Tips to Remember while submitting your first Envato CodeCyan AppEnvato

Things/Tips to Remember while submitting your first Envato CodeCyan AppEnvato
Last week we submitted our first app to Envato - CodeCyan called InfyLMS. InfyLMS is a full-fledged library management system to manage libraries built on Laravel+ReactJS.
But it was not just an easy upload. When you upload an item to CodeCyan, they have a dedicated team that tests your application and reviews the code quality of your app.
We have faced a few problems that I want to share, so if someone is uploading his first item to CodeCyan then he/she can review those points before submission and the chances of rejection can be reduced.
1. Do not use remote CDN
We have used Bootstrap in our system as a theme and we were using remote CDN URLs for JS and CSS. for e.g.
// CSS
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css"
// JS
All your assets need to be offline. so download all these files via either some package manager or just go and download it and put it under the respective asset folder.
2. Use Strict Mode in JS
All Javascript files need to be written into Strict mode.
For example, you can do this with jQuery as follows:
(function($) {
"use strict";
// Author code here
})(jQuery);
Or you can put
use "strict";
at the start of your file if they are generated via some webpack. There is a babel plugin available which you can use with a webpack.
3. Attach documentation into the main file
Attach documentation into the main file which you are uploading. Create a docs
folder into the root folder and attach full documentation to set up the application. Also, remember that this doc should work offline as well. so attach all your assets here as well.
4. Have Clear & Easy documentation for Non-Technical Users
All the customers or buyers do not have technical knowledge that needs to be there to set up an application. so try to make your application setup as easy as possible. for e.g, create a setup wizard which executes step by step and ask for details from customers.
Or create a dedicated section in your documentation for Non Technical users with clear, precise and minimal steps that needs to be performed.
If possible, then try to give two different zip files under your main zip file, like
- dist - Distribution which can be set up with minimal efforts for non-technical users
- source - Original source file for technical users
I hope this will help new Envato Authors who are uploading their very first item.