Laracasts Member Profile

Oct

2 weeks ago

Started a new Conversation Use Form Builder Data In Another Field

Hello All,

I have a form builder (https://formbuilder.online/) which saves as json data in table. If i use that form and fill data, that data also saves in json format (refer form_data column data after save form). So my question is How can i use that/those data in another part of software?

**TABLE STRUCTURE - **

[before save form data]

table_name = form_builder_template

table_column_name = form_data

[{"type":"text","required":false,"label":"Text Field","className":"form-control","name":"text-1598897549353","access":false,"subtype":"text"}]
[{"type":"text","required":false,"label":"Text Field","className":"form-control","name":"text-1598897549353","access":false,"subtype":"text"}]
[{"type":"text","required":false,"label":"Text Field","className":"form-control","name":"text-1598897549353","access":false,"subtype":"text"}]
[{"type":"text","required":false,"label":"Text Field","className":"form-control","name":"text-1598897549353","access":false,"subtype":"text"}]
[{"type":"text","required":false,"label":"Text Field","className":"form-control","name":"text-1598897549353","access":false,"subtype":"text"}]

[after save data]

table_name = form_builder table_column_name = form_data

[{"type":"text","required":false,"label":"Text Field","className":"form-control","name":"text-1598897549353","access":false,"subtype":"text","userData":["AAA"]}]
[{"type":"text","required":false,"label":"Text Field","className":"form-control","name":"text-1598897549353","access":false,"subtype":"text","userData":["BBB"]}]
[{"type":"text","required":false,"label":"Text Field","className":"form-control","name":"text-1598897549353","access":false,"subtype":"text","userData":["CCC"]}]
[{"type":"text","required":false,"label":"Text Field","className":"form-control","name":"text-1598897549353","access":false,"subtype":"text","userData":["DDD"]}]
[{"type":"text","required":false,"label":"Text Field","className":"form-control","name":"text-1598897549353","access":false,"subtype":"text","userData":["EEE"]}]

So, I want to use userData AAA, BBB, CCC, DDD, EEE as a option in select in some another part of software.

Any help would be highly appreciated.

Sep

3 weeks ago

Started a new Conversation Compress Uploaded Image Not Resize In Laravel

Hello All,

I want to compress uploaded image without resizing it. There are several laravel packages available which provides image manipulation but none of them have the feature which i needed.

There are many online tools available which provides feature which i am talking about. Like i upload 3MB png image and after compress it gives me less than 3MB image depanding on image (Sometimes it doesn't compress much).

Some of websites are-

compressjpeg.com
tinyjpg.com and many more.

Any Suggestions?

Sep

1 month ago

Replied to Does Anybody Give Me An Idea To Making Proctoring System In Laravel?

@automica , ThankYou. I will let you know.

Replied to Does Anybody Give Me An Idea To Making Proctoring System In Laravel?

@automica

The project is already developed. Just need proctoring module to be added. But no leads yet.

Awarded Best Reply on Request File Validation Fails Not Redirecting To View Page In Which Form Is Submitting.

Thank You @mvd

Yes, i have just corrected the rules. But the problem is that page is not redirecting to view file again instead of giving this message-

{"message":"The given data was invalid.","errors":{"email":["The email has already been taken."]}}

any suggestions? Thanks in advance.

Sep

1 month ago

Replied to Does Anybody Give Me An Idea To Making Proctoring System In Laravel?

@automica Right. Could you ping me in mail for further details?

Sep

1 month ago

Replied to Does Anybody Give Me An Idea To Making Proctoring System In Laravel?

@automica , I'm looking for this feature in professional project. I am bit aware of its complexity. If you got any information about any existing systems in, Please tag me here. Thanks in advance.

Sep

1 month ago

Replied to Does Anybody Give Me An Idea To Making Proctoring System In Laravel?

Absolutely nothing. :(

Sep

1 month ago

Started a new Conversation Does Anybody Give Me An Idea To Making Proctoring System In Laravel?

I am working on online exam system where i need to implement advanced proctoring system where invigilator has an access of camera's of all candidates giving exams (it will something look like Zoom's Gallery view) (Please consider any third party subsciption if require).

Any suggestion would be highly appreciated and Thanks in advance.

Aug

1 month ago

Replied to Laravel-dompdf Thai Language Not Working

Thank you @sinnbeck ,

It worked. This is the working code -

<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
        <title>Laravel</title>
        <style>
        @font-face {
            font-family: 'THSarabunNew';
            font-style: normal;
            font-weight: bold;
            src: local('Quattrocento Sans Bold'), local('QuattrocentoSans-Bold'),url("{{ asset('http://164.115.33.174/awards_opdc/assets/fonts/THSarabunNew/THSarabunNew.ttf') }}") format('truetype');
        }
        @font-face {
            font-family: 'THSarabunNew';
            font-style: normal;
            font-weight: bold;
            src: local('Quattrocento Sans Bold'), local('QuattrocentoSans-Bold'), url("{{ asset('http://164.115.33.174/awards_opdc/assets/fonts/THSarabunNew/THSarabunNewBold.ttf') }}") format('truetype');
        }
        @font-face {
            font-family: 'THSarabunNew';
            font-style: normal;
            font-weight: bold;
            src: local('Quattrocento Sans Bold'), local('QuattrocentoSans-Bold'), url("{{ asset('http://164.115.33.174/awards_opdc/assets/fonts/THSarabunNew/THSarabunNewBoldItalic.ttf') }}") format('truetype');
        }
        @font-face {
            font-family: 'THSarabunNew';
            font-style: normal;
            font-weight: bold;
            src: local('Quattrocento Sans Bold'), local('QuattrocentoSans-Bold'), url("{{ asset('http://164.115.33.174/awards_opdc/assets/fonts/THSarabunNew/THSarabunNewItalic.ttf') }}") format('truetype');
        }

        body {
            font-family: 'THSarabunNew';
        }
        </style>
    </head>
    <body>
        <h1>
            แดชบอร์ด   {{-- NOW WORKING --}}
        </h1>
         
        <p>
            แดชบอร์ด    {{-- WORKING --}}
        </p>
    </body>
</html>

Replied to Laravel-dompdf Thai Language Not Working

Hello @sinnbeck ,

The problem is little bit weird. Text is not rendering because of h1 tag, but if i am writing same text within p or span tags, then it is working. I have 30+ pages where i am using dompdf. Any idea why it is happening.

Working code

<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
        <title>Laravel</title>
        <style>
        @font-face {
            font-family: 'THSarabunNew';
            font-style: normal;
            font-weight: normal;
            src: url("{{ asset('http://164.115.33.174/awards_opdc/assets/fonts/THSarabunNew/THSarabunNew.ttf') }}") format('truetype');
        }
        @font-face {
            font-family: 'THSarabunNew';
            font-style: normal;
            font-weight: normal;
            src: url("{{ asset('http://164.115.33.174/awards_opdc/assets/fonts/THSarabunNew/THSarabunNewBold.ttf') }}") format('truetype');
        }
        @font-face {
            font-family: 'THSarabunNew';
            font-style: normal;
            font-weight: normal;
            src: url("{{ asset('http://164.115.33.174/awards_opdc/assets/fonts/THSarabunNew/THSarabunNewBoldItalic.ttf') }}") format('truetype');
        }
        @font-face {
            font-family: 'THSarabunNew';
            font-style: normal;
            font-weight: normal;
            src: url("{{ asset('http://164.115.33.174/awards_opdc/assets/fonts/THSarabunNew/THSarabunNewItalic.ttf') }}") format('truetype');
        }

        body {
            font-family: 'THSarabunNew';
        }
        </style>
    </head>
    <body>
        <h1>
            แดชบอร์ด    // not working
        </h1>
         
        <p>
            แดชบอร์ด   //working
        </p>
    </body>
</html>

Replied to Laravel-dompdf Thai Language Not Working

Yes, I tried but didn't work.

For your information, i have copied /fonts folder within public, resources and storage directories just in case if it works.

this is font link - http://164.115.33.174/awards_opdc/assets/fonts/THSarabunNew/

And those fonts are linked correct because if i am downloading that font on button click then it is downloading means it is linked correctly, right?

Started a new Conversation Laravel-dompdf Thai Language Not Working

Hello Guys,

I'm using barryvdh/laravel-dompdf version 0.8.6. When i'm trying to print THAI language, instead of showing thai text it is showing ????? . I tried with font THSarabunNew.ttf but doesn't work. This is my code -

ROUTE -

Route::get('/print', function () {
    $pdf = PDF::loadView('print');
    return @$pdf->stream();
})->name('print');

VIEW (print.blade.php)

<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
        <title>Laravel</title>
        <style>
        @font-face {
            font-family: 'THSarabunNew';
            font-style: normal;
            font-weight: normal;
            src: url("{{ asset('fonts/THSarabunNew.ttf') }}") format('truetype');
        }
        body {
            font-family: 'THSarabunNew';
        }
        </style>
    </head>
    <body>
        <h1>
            แดชบอร์ด
        </h1>
    </body>
</html>

Any suggestion would be highly appreciated.

Replied to Trying To Get All Values From GroupBy

Thank you @silencebringer

It worked. :)

Aug

1 month ago

Started a new Conversation Trying To Get All Values From GroupBy

Hello Guys,

PROBLEM DEFINITION - i have 3 tables, namely - waitlists, waitlist_services, waitlist_service_times. I am joining these 3 tables like this -

$waitlist = Waitlist::with('waitlist_services')->select('waitlist_service_times.day', 'employee_sub_categories.id as emp_sub_cat_id', 'waitlist_services.service_request_id', 'waitlist_service_times.waitlist_services_id', 'waitlist_services.id as waitlist_ser_id', 'waitlist_services.waitlist_id' ,'waitlists.id', 'waitlists.date_joined', 'waitlists.priority', 'client_intakes.first_name', 'client_intakes.last_name', 'client_intakes.client_dob', 'waitlist_service_times.start_time','waitlist_service_times.end_time','waitlist_service_times.or_start_time','waitlist_service_times.or_end_time', 'employee_sub_categories.sub_cat_name')
            ->join('client_intakes', 'client_intakes.id', 'waitlists.client_intakes_id')
            ->join('waitlist_services', 'waitlists.id', 'waitlist_services.waitlist_id')
            ->join('waitlist_service_times', 'waitlist_services.id', 'waitlist_service_times.waitlist_services_id')
            ->join('employee_sub_categories', 'employee_sub_categories.id', 'waitlist_services.service_request_id');

$waitlist = $waitlist->groupBy('waitlists.id');
$waitlist = $waitlist->get();

CURRENT OUTPUT - if remove line $waitlist = $waitlist->groupBy('waitlists.id');

| waitlist_id | service_request_id's | day's |

| 1 | 1 | Monday |

| 1 | 2 | Tuesday |

EXPECTED OUTPUT -

| waitlist_id | service_request_id's | day's |

| 1 | 1,2 | Monday, Tuesday |

RELATIONS- waitlists has many waitlist_services , waitlist_services has many waitlist_service_times.

Any help would be appreciated.

Jul

3 months ago

Replied to Request File Validation Fails Not Redirecting To View Page In Which Form Is Submitting.

CONTROLLER-

public function store_company(RegisterCompany $request) {

}

this one you wanted to see? By the way i'm using a separate request file for validation. And complete code i have mentioned in very first question of this page. Please read again and then also you need to know something else and please let me know.

So my question is to why Request validation failture not redirecting me to view file?

Replied to Request File Validation Fails Not Redirecting To View Page In Which Form Is Submitting.

Thank You @mvd

Yes, i have just corrected the rules. But the problem is that page is not redirecting to view file again instead of giving this message-

{"message":"The given data was invalid.","errors":{"email":["The email has already been taken."]}}

any suggestions? Thanks in advance.

Started a new Conversation Request File Validation Fails Not Redirecting To View Page In Which Form Is Submitting.

PROBLEM

I am submitting a form using and for validation i'm using Request file. There i have given validation for email that it should be unique. When i am trying to insert same email it is showing error which is good but i wanted to redirect it back to view. This is my code

CONTROLLER-

public function store_company(RegisterCompany $request) {

}

REQUEST FILE -

namespace App\Http\Requests\Company;

use App\GoogleCaptchaSetting;

use App\Http\Requests\CoreRequest;

use App\Rules\Captcha;

class RegisterCompany extends CoreRequest {

public function rules()
{
    $google_captcha = GoogleCaptchaSetting::first();

    $rules =  [
        'business_name' => 'required',
        'email' => 'required|email',
        'contact' => 'required',
        'address' => 'required',
        'name' => 'required',
        'password' => 'required|min:6'
        ];

        if($google_captcha->status == 'active' && $google_captcha->v2_status == 'active' )
        {
            $rules['g-recaptcha-response'] = new Captcha();
        }

        return $rules;
}

}

ERROR -

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '[email protected]' for key 'users_email_unique' (SQL: insert into users (name, email, password, company_id, updated_at, created_at) values ([email protected], [email protected], $2y$10$odzYOR9Ox7SaB6KEfRFC3ulhbjOSb9.VFh58S1iSbsVaCKVoRRl1q, 106, 2020-07-21 08:37:10, 2020-07-21 08:37:10))

Jun

4 months ago

Replied to A Textual Day Could Not Be Found

Thanks @guybrush_threepwood

Jun

4 months ago

Replied to A Textual Day Could Not Be Found

Yes i know. But my application needed a multi language support.

any other suggestions would be highly appreciated.

Thanks

Started a new Conversation A Textual Day Could Not Be Found

VIEW CODE -

$('#start-date').datetimepicker( {

        format: 'D d M Y',
        locale: 'tr',
        allowInputToggle: true,
        defaultDate: moment().subtract(30, 'days'),
        icons: {
            time: "fa fa-clock-o",
            date: "fa fa-calendar",
            up: "fa fa-arrow-up",
            down: "fa fa-arrow-down",
            previous: "fa fa-angle-double-left",
            next: "fa fa-angle-double-right",
        }

})

CONTROLLER CODE-

// dd($request->startDate); Sal 12 May 2020

$startDate = Carbon::createFromFormat('D d M Y', $request->startDate);

the above line is giving an error mentioned below

ERROR LOG -

{ "message": "A textual day could not be found", "exception": "InvalidArgumentException", "file": "/home/froiden/Htdocs/appointo/vendor/nesbot/carbon/src/Carbon/Traits/Creator.php", "line": 576, "trace": [ { "file": "/home/froiden/Htdocs/appointo/vendor/nesbot/carbon/src/Carbon/Traits/Creator.php", "line": 598, "function": "rawCreateFromFormat", "class": "Carbon\Carbon", "type": "::" }, { "file": "/home/froiden/Htdocs/appointo/app/Http/Controllers/Admin/ShowDashboard.php", "line": 35, "function": "createFromFormat", "class": "Carbon\Carbon", "type": "::" }, { "function": "__invoke", "class": "App\Http\Controllers\Admin\ShowDashboard", "type": "->" }, { "file": "/home/froiden/Htdocs/appointo/vendor/laravel/framework/src/Illuminate/Routing/Controller.php", "line": 54, "function": "call_user_func_array" }

**JUST FOR INFORMATION **-

using bootstrap datepicker with multi language support (https://eonasdan.github.io/bootstrap-datetimepicker/)

Thanks in advance :)

amit028

Start Your Engines

First Thousand

One Year Member

Two Year Member

Three Year Member

Four Year Member

Five Year Member

School In Session

Welcome To The Community

Full Time Learner

Pay It Forward

Subscriber

Lifer

Laracasts Evangelist

Chatty Cathy

Laracasts Veteran

Ten Thousand Strong

Laracasts Master

Laracasts Tutor

Laracasts Sensei

Top 50

| waitlist_id | service_request_id's | day's |

| 1 | 1 | Monday |

| 1 | 2 | Tuesday |

| waitlist_id | service_request_id's | day's |

| 1 | 1,2 | Monday, Tuesday |

Want us to email you occasionally with Laracasts news?