Our Black Friday sale is now live! All individual subscriptions are 50% OFF. This week only!

jinsonjose

jinsonjose

Member Since 1 Year Ago

Experience Points
29,480
Total
Experience

520 experience to go until the next level!

In case you were wondering, you earn Laracasts experience when you:

  • Complete a lesson — 100pts
  • Create a forum thread — 50pts
  • Reply to a thread — 10pts
  • Leave a reply that is liked — 50pts
  • Receive a "Best Reply" award — 500pts
Lessons Completed
272
Lessons
Completed
Best Reply Awards
0
Best Reply
Awards
  • start your engines Created with Sketch.

    Start Your Engines

    Earned once you have completed your first Laracasts lesson.

  • first-thousand Created with Sketch.

    First Thousand

    Earned once you have earned your first 1000 experience points.

  • 1-year Created with Sketch.

    One Year Member

    Earned when you have been with Laracasts for 1 year.

  • 2-years Created with Sketch.

    Two Year Member

    Earned when you have been with Laracasts for 2 years.

  • 3-years Created with Sketch.

    Three Year Member

    Earned when you have been with Laracasts for 3 years.

  • 4-years Created with Sketch.

    Four Year Member

    Earned when you have been with Laracasts for 4 years.

  • 5-years Created with Sketch.

    Five Year Member

    Earned when you have been with Laracasts for 5 years.

  • school-in-session Created with Sketch.

    School In Session

    Earned when at least one Laracasts series has been fully completed.

  • welcome-newcomer Created with Sketch.

    Welcome To The Community

    Earned after your first post on the Laracasts forum.

  • full-time-student Created with Sketch.

    Full Time Learner

    Earned once 100 Laracasts lessons have been completed.

  • pay-it-forward Created with Sketch.

    Pay It Forward

    Earned once you receive your first "Best Reply" award on the Laracasts forum.

  • subscriber Created with Sketch.

    Subscriber

    Earned if you are a paying Laracasts subscriber.

  • lifer Created with Sketch.

    Lifer

    Earned if you have a lifetime subscription to Laracasts.

  • evangelist Created with Sketch.

    Laracasts Evangelist

    Earned if you share a link to Laracasts on social media. Please email [email protected] with your username and post URL to be awarded this badge.

  • chatty-cathy Created with Sketch.

    Chatty Cathy

    Earned once you have achieved 500 forum replies.

  • lara-veteran Created with Sketch.

    Laracasts Veteran

    Earned once your experience points passes 100,000.

  • 10k-strong Created with Sketch.

    Ten Thousand Strong

    Earned once your experience points hits 10,000.

  • lara-master Created with Sketch.

    Laracasts Master

    Earned once 1000 Laracasts lessons have been completed.

  • laracasts-tutor Created with Sketch.

    Laracasts Tutor

    Earned once your "Best Reply" award count is 100 or more.

  • laracasts-sensei Created with Sketch.

    Laracasts Sensei

    Earned once your experience points passes 1 million.

  • top-50 Created with Sketch.

    Top 50

    Earned once your experience points ranks in the top 50 of all Laracasts users.

Level 6
29,480 XP
Nov
12
1 week ago
Activity icon

Started a new Conversation Query Too Slow , How To Optimize This Any Idea?

too slow when using this where condition (around 26 seconds time taken) where([ ['incidents.base_type_id', '=', $basetype], ['incidents.case_flag', '=', $caseflag], ['incidents.added_by', '=', Auth::user()->id] ])

but when using 2 where condition lods in 1 second (combination of the above 3 to 2 like below) where([ ['incidents.case_flag', '=', $caseflag], ['incidents.added_by', '=', Auth::user()->id] ])



$result=Incident::where([
                                        ['incidents.base_type_id', '=', $basetype],
                                        ['incidents.case_flag', '=', $caseflag],
                                        ['incidents.added_by', '=', Auth::user()->id]
                                    ])->join('incident_notes', 'incidents.id', '=', 'incident_notes.incident_id')
                                                ->select('incidents.task_number')
                                                ->leftJoin('statuses', 'statuses.id', '=', 'incidents.status_id')
                                                ->leftJoin('incident_types', 'incident_types.id', '=', 'incidents.type_id')
                                                ->leftJoin('team_leaders', 'team_leaders.id', '=', 'incidents.team_leader_id')
                                                ->leftJoin('users', 'users.id', '=', 'incidents.team_member_id1') 
                                                ->leftJoin('users as b', 'b.id', '=', 'incidents.team_member_id2')
                                                
                                                ->orderBy($field, $sort)
                                                ->groupBy('incidents.id') 
                                                ->with('teamlead.Members')
                                                ->limit($this->perPage)
                                                ->get(); ```
Nov
02
3 weeks ago
Oct
30
3 weeks ago
Activity icon

Replied to Query Too Slow When Operating With 1 Million Data On Table

@automica


$user = User::where('users.type', 'member')->with('userProfiles')->whereHas(
    'userProfiles', function ($query) {
        $query->where('profile_status', 'approved');
    }
)->select('users.name', 'users.email',
    'users.location', 'users.type', 'users.ip', 'users.last_login', 'users.created_at', 'users.id',
    'user_profiles.profile_status')->skip(($page - 1) * $this->perPage)->limit($this->perPage)->get();

this query returns error:

    "message": "Call to undefined method App\User::userProfiles()",
    "exception": "BadMethodCallException",
Activity icon

Replied to Query Too Slow When Operating With 1 Million Data On Table

@michaloravec yes i am facing the millions rows data issue in table query take much time for load that data!

Activity icon

Replied to Query Too Slow When Operating With 1 Million Data On Table

@automica in user table have 10 lakhs data its take around 15 seconds for that query to result

Activity icon

Started a new Conversation Query Too Slow When Operating With 1 Million Data On Table

How to optimize the query? any idea?

How to speed up this query ??

$members = DB::table('users') ->where('users.type', 'member') ->join('user_profiles', 'users.id', '=', 'user_profiles.user_id') ->where('user_profiles.profile_status', 'approved') ->select('users.name', 'users.email', 'users.location', 'users.type', 'users.ip', 'users.last_login', 'users.created_at', 'users.id', 'user_profiles.profile_status') ->skip(($page - 1) * $this->perPage) ->limit($this->perPage) ->get();

Oct
03
1 month ago
Activity icon

Replied to V-calender Attribute With Big Data Issue

any method for monitoring the month or year change in v-calender??

https://docs.vcalendar.io/

Activity icon

Started a new Conversation V-calender Attribute With Big Data Issue

i am using v-calender with vuejs

<calendar :attributes='attrs'> </calendar>

when attaching attribute with big data size page around(5mb) page is going to be a hang mode how to avoid this situation but i want to display all the data with popovers on v-calender

or how to know month is changed or not in a function in vue js

or any other alternative method for this

can u help me to resolve this situation

Sep
18
2 months ago
Activity icon

Replied to How Reduce Size Of App.js And Vendor.js Or How To Split Vendor To Different Chunks

@niush thanks for the wonderfull solution its working fine and reduce the size to kb

i applied the lazy loading techniques on vue router exactly i am looking this one https://router.vuejs.org/guide/advanced/lazy-loading.html

thanks

Sep
16
2 months ago
Activity icon

Replied to How Reduce Size Of App.js And Vendor.js Or How To Split Vendor To Different Chunks

import { LMap, LTileLayer, LMarker } from 'vue2-leaflet';

used in different components and and each component its imported

is that right way ??

is not please suggest another way

Activity icon

Replied to How Reduce Size Of App.js And Vendor.js Or How To Split Vendor To Different Chunks

@niush import { LMap, LTileLayer, LMarker, LPopup } from 'vue2-leaflet';

only using the required modules on 'vue2-leaflet'

also like v-calendar & moment

can you suggest any other option

how to reduce this mb to kb whats the right method any idea?

Sep
15
2 months ago
Activity icon

Replied to How Reduce Size Of App.js And Vendor.js Or How To Split Vendor To Different Chunks

@bobbybouwmann 2mb is after running npm run prod

is it have any method for splitting the vendor.js

(vue cli is not used in this project)

Activity icon

Started a new Conversation How Reduce Size Of App.js And Vendor.js Or How To Split Vendor To Different Chunks

in production its size shows big and take time on loading how to reduce size of this files

in webpack.mix.js

mix.js('resources/js/app.js', 'public/js') .sass('resources/sass/app.scss', 'public/css').extract();

extracted to seperated files

vendor.js files size is 2.04mb how can i reduce the size

it shows affect the speed

package.json file below

{ "private": true, "scripts": { "dev": "npm run development", "development": "cross-env NODE_ENV=development node_modules/webpack/bin/webpack.js --progress --hide-modules --config=node_modules/laravel-mix/setup/webpack.config.js", "watch": "npm run development -- --watch", "watch-poll": "npm run watch -- --watch-poll", "hot": "cross-env NODE_ENV=development node_modules/webpack-dev-server/bin/webpack-dev-server.js --inline --hot --config=node_modules/laravel-mix/setup/webpack.config.js", "prod": "npm run production", "production": "cross-env NODE_ENV=production node_modules/webpack/bin/webpack.js --no-progress --hide-modules --config=node_modules/laravel-mix/setup/webpack.config.js" }, "devDependencies": { "axios": "^0.19.2", "bootstrap": "^4.5.0", "cross-env": "^5.1", "jquery": "^3.5.1", "laravel-mix": "^4.0.7", "lodash": "^4.17.19", "popper.js": "^1.16.1", "resolve-url-loader": "^2.3.1", "sass": "^1.26.10", "sass-loader": "7.*", "vue": "^2.6.11", "vue-template-compiler": "^2.6.10" }, "dependencies": { "bootstrap-vue": "^2.15.0", "chart.js": "^2.9.3", "jspdf": "^2.1.1", "jspdf-autotable": "^3.5.12", "leaflet": "^1.6.0", "moment": "^2.27.0", "run": "^1.4.0", "sweetalert2": "^9.15.3", "v-calendar": "^1.0.8", "vform": "^1.0.1", "vue-css-donut-chart": "^1.3.0", "vue-google-charts": "^0.3.3", "vue-loading-overlay": "^3.3.2", "vue-plain-pagination": "^0.3.0", "vue-router": "^3.3.4", "vue-search-select": "^2.9.3", "vue-sweet-calendar": "^0.3.1", "vue2-datepicker": "^3.6.0", "vue2-leaflet": "^2.5.2", "vue2-leaflet-markercluster": "^3.1.0" } }

Jun
18
5 months ago
Activity icon

Started a new Conversation How To Create Breadcumbs On Laravel

how to create a breadcumbs on blade in laravel

i used this package composer require davejamesmiller/laravel-breadcrumbs:5.x

but its showing 500 error on that route page {{ Breadcrumbs::render('home') }}

how to handle this i am using "laravel/framework": "^6.2"

can you help ??

Jun
15
5 months ago
Activity icon

Replied to How To Create A Pagination In Vue + Laravel

@Snapey how to handle this?? can u give an idea

Jun
11
5 months ago
Activity icon

Started a new Conversation How To Create A Pagination In Vue + Laravel

i want a pagination like < 1-10 of 189 > like this how to handle this in vue ??

any package to handle this??

can you help??