Recently in one of our client's project, we want to load the count of relation in laravel. But we do not want to retrieve original records.

For example,

We have the following Models,

1. Category
2. Products
3. Orders

For that, we have categories, products, orders, order_items table. Where in the order_items table, we got the following fields

• order_id
• product_id
• quantity

So the requirement was, In the Products table, we want to display the total number of orders placed with that item regardless of the quantity in each order. All we need is a number of orders where the product is purchased.

1st way: Query via Relationship

$products = Product::all();
$productsArr = $products->map(function (Product $product) {
    $productObj = $product->toArray();
    $productObj['orders_count'] = $product->orders()->count();
    return $productObj;
});

But the problem with this approach was, we are firing queries to the database for every single product. so if I'm retrieving 100 Products from the database then it will fire 100 additional queries to the database. Imagine if we have thousands of products.

2nd way: Eager Load Relationship and Calculate Count

$products = Product::with('orders')->get();
$productsArr = $products->map(function (Product $product) {
    $productObj = $product->toArray();
    $productObj['orders_count'] = $product->orders->count();
    return $productObj;
});

so this way, we are only firing two queries to the database. But the problem here is, we are loading all the Orders of each product which we don't need at all. so it will consume lots of memory since we are loading lots of orders. so imaging if we retrieve 100 products, and each product has 10 orders, then we are loading 1000 Orders into memory without any need.

3rd way: Use withCount function

The third powerful approach of using withCount function in Laravel. so we refactored our code like,

$products = Product::withCount('orders')->get();
$productsArr = $products->map(function (Product $product) {
    $productObj = $product->toArray();
    $productObj['orders_count'] = $product->getAttribute('orders_count');
    return $productObj;
});

In this approach, we are firing two queries but no Order models are loaded into memory.

4th Bonus: Using in a nested relationship while multiple eager loading

You can even use it with nested relationships. Imagine a case, where you want to retrieve categories along with its products with orders count.

$categories = Category::with([
    'products' => function ($query) {
        $query->withCount('orders');
    },
    'someOtherEagerLoading1',
    'someOtherEagerLoading2'
])->get();
$categoriesArr = $categories->map(function (Category $category) {
    $categoryObj = $category->toArray();
    $categoryObj['products'] = $category->products->map(function (Product $product) {
        $productObj = $product->toArray();
        $productObj['orders_count'] = $product->getAttribute('orders_count');
        return $productObj;
    });
    return $categoryObj;
});

Hope this will help you to retrieve the count of relationship data without retrieving actual relation data.

The replacement for the 'called' modules is known as 'Stubs' and is also used when the software needs to interact with an external system.

• Reduces errors in the newly developed functions or reduces errors when changing the existing functionality. 
•  Reduces test costs as errors are detected at a very early stage.
•   Improves the design and allows for better code redesign.
•   Unit tests also show the quality of the build when integrated into Build. 

Unit Testing Techniques:

• Black Box Testing - Using which the user interface, input and output are tested.
• White Box Testing - used to test each one of those functions' behavior is tested.
• Gray Box Testing - Used to execute tests, risks and assessment methods. 

 

• Identify the business-critical functions that a product must perform.  
• Design and run the basic functions of the application. 
•  Make sure the smoke test passes each and every build to continue testing.  
• Smoke testing enables obvious errors to be revealed, saving time and effort .
• Smoking testing can be manual or automated. 

• Check that communication between systems is done correctly
•  Check if all supported hardware / software has been tested 
• Check if all related documents are supported / open on all platforms
•  Check security requirements or encryption when communicating between  application server systems 

• Final Regression Tests: - A "final regression testing" is performed to validate the build that hasn't changed for a period of time. This build is deployed or shipped to customers.
• Regression Tests: - A normal regression testing is performed to verify if the build has NOT broken any other parts of the application by the recent code changes for defect fixing or for enhancement.

• Requires knowledge of the system and its effects on the existing functions.  
• Tests are selected based on the area of ​​common failure. 
•  Tests are chosen to include the area where code changes have been made multiple times. 
•  Tests are selected based on the criticality of the features. 

• Regression tests are the ideal cases of automation which results in better Return On Investment (ROI).
• Select the regression tests.
•   Choose apt tool and automate regression testing. 
•  Verify applications with checkpoints. 
•  Manage regression testing and update as needed.
•   Schedule tests.
•   Integrate with builds.

• Evaluate performance acceptance criteria.
•  Identify critical scenarios.
•  Design the workload model.
• Identify target load levels.
•  Design the tests.
•  Run the tests.
• Analyze the results 

• Response time.
•  Resource usage rate.
•  Maximum user load.
• Work-related metrics 

• This allows the test team to monitor the performance of the system during failures. 
• To check if the system saved data before crashing or NOT. 
• To check if the system is printing messages  Significant error during a failure or if it has printed random exceptions 
• To check whether unexpected failures do not lead to safety issues 

• Monitor the behavior of the system when the maximum number of  'users are logged in at the same time
•  All users performing critical operations at the same time
•  All users Accessing the same file
•  Hardware issues such as the downed database server or some of the servers in a downing farm  breakdown. 

• Operating system Compatibility Testing - Linux, macOS, Windows
• Database Compatibility Testing - Oracle SQL Server
• Browser Compatibility Testing - IE, Chrome, Firefox
• Other System Software - Web server, networking/ messaging tool, etc.

• White Box Testing
• Black Box Testing
• Grey Box Testing

• Unit Testing
• Integration Testing
• System Testing

• Software malfunction.
•  Error in interface.
•  Errors in concepts.
•  Errors related to the database.
• Performance or behavior errors.
• Errors in product startup or termination 

• Integration Testing
• System Testing
• Acceptance Testing

• Sound & Effective Organisation
• Opportunity to rise 
• Remuneration 
• Personal attributes
• satisfaction level
• Supervision level
• Nature of work

• Ask the right question 
• Don’t ask anything in annoying way
• Follow the performance data first 
• Take the employee of the clock 
• Listen to what they say
• Keep eye on their project 

Lots of people ask me frequently, "Which are the laravel packages that you use in almost all projects?" when we meet in Meetup or any other events regardless of its online or physical events.

Let me describe today some of the packages that we almost use in all of the projects.

We are working in Laravel for almost 7+ years and in these years we have used lots of packages, some from the community and some of our own.

I am categorizing these into 2 categories.

1. Must used packages
2. Common Need/Functionality specific packages

Must used packages

These are the packages which are must be included in all of our projects. No Excuses.

barryvdh/laravel-ide-helper

Laravel exposes a lot of magic methods and properties. IDE Helper is a very good package when it comes to auto-complete those properties and methods. Even it does an amazing job while refactoring properties or methods of the model.

barryvdh/laravel-debugbar

The second one is from the same author, debugbar helps to debug the request in terms of the number of queries fired, time taken by each query, number models retrieved from db, time taken by each request, and much more.

imanghafoori/laravel-microscope

Laravel Microscope improves the readability of your code. Early returns, unnecessary else statements, and many more. so your code looks clean and efficient in terms of execution as well.

beyondcode/laravel-query-detector

One of the problems that we face is, missing eager loading. In ongoing development, sometimes we add relationships objects in the loops, and then laravel fires tons of queries to the database. Laravel Query Detector detects that and gives warning while development environment.

InfyOmLabs/laravel-generator

No application can be ever built without few CRUDs. CRUDs are essential in almost all web applications. Also, APIs of that CRUDs are essentials while building a backend for Mobile or Frontend apps. Laravel Generator is our own developed package that we use in all of the applications to make the CRUD building process faster. It can be used with two themes right now, AdminLTE and CoreUI. But it's also frontend framework agnostic.

Common Need/Functionality specific packages

These are the packages that are used when we particularly need that kind of functionality in the application.

• Single Page application without JS - Livewire
• Role Permissions - spatie/laravel-permission
• Media Management - spatie/laravel-medialibrary
• Full Text Search - Laravel Scout
• Payment - Laravel Cashier
• Frontend Scaffolding - Laravel UI AdminLTE & Laravel UI CoreUI
• APIs token management - Laravel Sanctum
• Realtime Apps - Laravel Echo with Pusher & Laravel Echo Server
• One Signal - Shailesh OneSignal

Will keep this list updating.

Step 1: Selection of your Subject

select any selection tool for selection but select the Quick selection tool.
select your subject and press select and mask

Step 2: Edit your Subject

1. open property and select onion skin and transparency 50%
2. refine edge brush tool and then refine edge
3. Set contrasts 9%
4. output setting on
5. tick decontaminate colors amount 100%
6. output to a new layer with layer mask then press OK

Step 3: Crop Upper part of the subject

select layer mask and press ctrl + click for selection and new cut out the upper part to polygonal lasso tool. select perfectly then select layer and ctrl+j for duplicate layer

Step 4: create an effect for Background

create Ctrl+G for group layer select the last layer and create color lookup effect.
then 3D lut file and select moonlight.3dl. and then Create a new effect black & white
Opacity set 50%

Step 5: Create Effect for Main Subject

select the group layer and convert this layer to a Smart Object.
then create this layer duplicate. then create a color style to the top layer in linear Dodge(Add).
then go to the

1.filter - blur - Gaussian blur Create radius - 5 for soft edges
2.Create a duplicate layer and double click on the smart filter and Create a radius of 100

3.again Create a duplicate layer and double click on the smart filter and Create a radius of 250
4. again Create duplicate layer and double click on the smart filter and **Create a radius of 500

then add hue/saturation adjustment layer
and click on create clipping mask then click on colorize and increase the saturation to your perfect and choose a color

Step 6: Create All effect in the subject

select main layer mask image and create effect curves.
and click on create effect curves and click on create clipping mask and curves per requirement select layer mask and select the brush tool. and set property
opacity 100%
flow 30%

create duplicate hue/saturation effect layer and set this layer is bottom of the main object and select this layer and open property and click ok create a clipping mask.
and select the mask and make sure the foreground color is white.
and give shade to the object and you can also adjust the opacity.

Step 7: Add the sparkle and give effect

let's add sparkle and change the blending yo screen.

then add a mask and convert to invert the layer and select brush tool.
set foreground color is white and creates an effect in the main object after creating effect open blending mode and create a level and click on create clipping mask and set property per requirement.
then open blending mode and select color lookup and set 3dlutfile to crisp_warm: look and set opacity as per requirement.
now finally ready to glow effect

Introduction

You can only develop products and services that are very effective if you pay attention to the needs of your customers and prospects. One way to understand exactly what your customers want is through research and surveys.

1. Understand your customers

You can only develop products and services that will be a big hit if you pay attention to the needs of your customers and prospects. One way to understand exactly what your customers want is through research and surveys. You should constantly invite them to give honest, brutal feedback.

Reviews and surveys are the best way to get into the minds of your customers. This makes it easier for you to develop products and services that are appropriate to the current demands of the market. Moreover, it helps you understand the area in which your company needs to improve.

2. Improving customer service

If you do not provide quality customer service, it will be difficult to satisfy your customers even if you have an excellent product or service. This aspect of the business is about taking extra steps to make them feel special. Let your customers know that they have value. If they have a problem, make sure you address them immediately. If they have questions, take the time to answer.

They should not feel that things are difficult for them if they raise specific issues. Social media is the best way to listen to and understand your customers. If they find customer service satisfactory, they may also recommend buying others from your business.

3. Establish loyalty

It takes time to encourage customers to come and buy what you offer. But just buying them is not enough. You need to promote loyalty. Considering there are other competitors who can offer them better, you want them to stay loyal to you. Don’t be satisfied just because you already have a lot of loyal customers.

They can easily be attracted to other options and they can leave you. Provide loyalty rewards. If there are discounts and discounts, let these most loyal customers be the first to know. You must make sure your customers know they are appreciated.

4. Focus on professional development

The success of your business also depends on the quality of the employees you hire. Building an effective team is the key to making sure your business grows.

One of the best ways to motivate hardworking employees is to give them a sense of purpose. They should not feel that they have to work just to work.

5. Understand your customers

Find ways to increase the sales of your existing customers It's much cheaper than finding a new one. Even if you can't expand your product line, you can still sell more of your existing product or service to a client you already have. An easy way to do this is by volume discount.

6. Participate in networking events

Take the time to build your networks - it's not what you know but who you know. Networking allows you to build relationships with other people and encourage customers to refer to you through words.

7. Give back to your community

Creating brand awareness in your local community is a great way to attract new business. Consider participating in a sponsorship or community event to enhance your business profile.

We will see more points in our next tutorial.

Most of the developers are facing select2 styles removing issue when livewire render the component.

We can resolve this issue by using a livewire javascript hook.

Here is my screen with select2 before livewire component rendering.

And when the livewire component is refreshed means re-render the select2 style is gone ☹️

How to Fix it ?? 🤔

document.addEventListener('livewire:load', function (event) {
    window.livewire.hook('afterDomUpdate', () => {
        $('#select2ID').select2();
    });
});

• Setup livewire with component example
• How to use livewire pagination