SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '{"id":1,"personal_id":12345678,"name":"mohammadkhallaf","clinic":"asd","start_date":"2022-12-20","phone":"0456204856","addres...' for column `optical_c`.`p_tests`.`customer_id`

 public function store(Request $request)
    {
        try {
            $this->validate($request, [
                'customer_id' => 'required|exists:customers,personal_id',
                'distance' => 'required|string',
                'right_eye_without_corr' => 'required|string',
                'left_eye_without_corr' => 'required|string',
                'right_eye_with_corr' => 'required|string',
                'left_eye_with_corr' => 'required|string',
                'vision_act_test' => 'required|string',
                'date' => 'required|date',
                // 'report' =>  'required_without:rid|file|mimes:csv,txt,xlx,xls,pdf|max:2048',
                'cost' => 'required|integer',
                'addedBy' => 'required|string',
                'correctedBy' => 'required|string',
                // 'attach'=>'required_without:aid|file||mimes:csv,txt,xlx,xls,pdf|max:2048',
                'test_id' => 'required|exists:tests,id',
            ]);

            $reportPath = null;
            if ($request->hasFile('report')) {
                $reportPath = $request->file('report')->storeAs(
                    'reports',
                    date_format(Carbon::now(), 'Ymd') . '_' . $request->personal_id . '_' . $request->test_id . '.' . $request->file('report')->getClientOriginalExtension(),
                    'public'
                );
            }

            // return $reportPath;

            $attachPath = null;
            if ($request->hasFile('attach')) {
                $attachPath = $request->file('attach')->storeAs(
                    'attachs',
                    date_format(Carbon::now(), 'Ymd') . '_' . $request->personal_id . '_' . $request->test_id . '.' . $request->file('attach')->getClientOriginalExtension(),
                    'public'
                );
}

                // dd($request->all());

                $ptest = PersonalTest::create([
                    'customer_id' => Customer::where('personal_id', $request->customer_id)->first(),
                    'distance' => $request->distance,
                    'right_eye_without_corr' => $request->right_eye_without_corr,
                    'left_eye_without_corr' => $request->left_eye_without_corr,
                    'right_eye_with_corr' => $request->right_eye_with_corr,
                    'left_eye_with_corr' => $request->left_eye_with_corr,
                    'date' =>$request->date,
                    'report' => $reportPath,
                    'cost' => $request->cost,

                    'vision_act_test' => $request->vision_act_test,
                    'addedBy' => $request->addedBy,
                    'correctedBy' => $request->correctedBy,
                    'attach' => $attachPath,
                    'test_id' => $request->test_id,
                ]);
            dd($request);
                return redirect()->route('admin.ptest')->with('success', 'تم اضافة فحص جديد');

        } catch (Exception $ex) {
            return $ex;
            return redirect()->route('admin.ptest')->with('error', '   حدث خطأ');
        }
    }