xxxxxxxxxx
return [
'supplier_id' => 'required|exists:suppliers,id',
'invoice_number' => 'required|string|unique:your_table_name,invoice_number,NULL,id,invoice_date,' . request('invoice_date'),
'invoice_date' => 'required|date|date_format:Y-m-d',
'remark' => 'nullable|string',
'total_ramle' => 'required|numeric',
'total_labor_usd' => 'required|numeric',
'with_gold' => 'required|boolean',
'with_silver' => 'required|boolean',
'with_diamond' => 'required|boolean',
'cash_usd' => 'required|numeric',
'ramle_gold' => 'required|numeric',
'ramle_usd' => 'required|numeric',
], [
'invoice_number.unique' => 'An invoice with this number and date already exists.',
];
xxxxxxxxxx
'exam_category_id' => Rule::unique('exams')->where(function ($query) use ($request) {
return $query->where('exam_name', $request->exam_name)
->where('exam_year', $request->exam_year)
->where('student_id', $request->student_id);
})
xxxxxxxxxx
'mobile_no'
=> 'unique:users,mobile_no,NULL,id,country_id,'.request('country_id');
xxxxxxxxxx
'name' => 'required|max:150|unique:course_lessons,name,NULL,id,course_id,' . request('course_id'),
"<input_filed_name>" => "valiadtionRule"|"ValidationRule"|"unique:<tableName>,<validateableField>,<ignoreableID>,<tablePrimaryKey>,<column1>,<column1Value>,<column2>,<column2Value>"
xxxxxxxxxx
public function rules(): array
{
return [
'date' => [
'required',
'unique:expenses,date',
Rule::unique('expenses', 'date')->where('user_id', $this->input('user_id')),
],
];
}
public function messages()
{
return [
'date.unique' => 'Expense for selected user on selected date already exists.',
];
}