delete(); DB::statement('ALTER TABLE letterhead_templates AUTO_INCREMENT = 1'); DB::statement('ALTER TABLE increments_promotions AUTO_INCREMENT = 1'); $company = Company::with(['currency' => function ($query) { return $query->withoutGlobalScope(CompanyScope::class); }, 'subscriptionPlan'])->where('is_global', 0)->first(); session(['company' => $company]); // Manually Dispatch Events LetterHeadTemplate::observe(LetterHeadTemplateObserver::class); $attendanceAwardTemplate = new LetterHeadTemplate(); $attendanceAwardTemplate->company_id = $company->id; $attendanceAwardTemplate->title = 'Attendance Award'; $attendanceAwardTemplate->description = '

##EMPLOYEE_NAME##

Employee ID : ##EMPLOYEE_ID##

Designation : ##EMPLOYEE_DESIGNATION##

Date : ##CURRENT_DATE##

Subject: Excellent Attendance Letter

Congratulations!

You have been provided an attendance award bonus, for your excellent attendance at work during the last 3 month’s. The effort you put into your job is more than what is required and ##COMPANY_NAME## Team is going to recognize you. Your enthusiasm and interest to work in the company, in spite of difficulties, have made a huge impact to our success.

You are a valuable employee to our company. We expect you to continue dedicated work and earn more such bonuses in upcoming months.

Signature of designated person

For ##COMPANY_NAME##

'; $attendanceAwardTemplate->save(); $attendanceAwardTemplate = new LetterHeadTemplate(); $attendanceAwardTemplate->company_id = $company->id; $attendanceAwardTemplate->title = 'Salary Letter'; $attendanceAwardTemplate->description = '

To Whom It May Concern,

This is to certify that ##EMPLOYEE_NAME## (##EMPLOYEE_ID##), holding the position of ##EMPLOYEE_DESIGNATION## at ##COMPANY_NAME##, has been receiving a monthly salary of INR xxxx (xxxx Rupees Only).

The details of the salary received for the period of October ##CURRENT_YEAR## to December ##CURRENT_YEAR## are as follows:

Month	Salary (INR)
October ##CURRENT_YEAR##	xxxx
November ##CURRENT_YEAR##	xxxx
December ##CURRENT_YEAR##	xxxx

This certificate is issued upon request for official purposes.

Signature of designated person

##COMPANY_NAME##

##CURRENT_DATE##

'; $attendanceAwardTemplate->save(); $attendanceAwardTemplate = new LetterHeadTemplate(); $attendanceAwardTemplate->company_id = $company->id; $attendanceAwardTemplate->title = 'Appreciation Letter'; $attendanceAwardTemplate->description = '

##EMPLOYEE_NAME##

Employee ID : ##EMPLOYEE_ID##

Designation : ##EMPLOYEE_DESIGNATION##

Date : ##CURRENT_DATE##

Subject: Appreciation Letter

Congratulations!

You have been provided a performance bonus, for your excellent performance in month of ##CURRENT_MONTH## ##CURRENT_YEAR##. We want to appreciate that because of your hard work, the company has increased in size and profitability. Your enthusiasm and interest to work in the company, in spite of difficulties, have made a huge impact to our success.

You are a valuable employee to our company. We expect you to continue dedicated work and earn more such bonuses in upcoming months.

Signature of designated person

For ##COMPANY_NAME##

'; $attendanceAwardTemplate->save(); $attendanceAwardTemplate = new LetterHeadTemplate(); $attendanceAwardTemplate->company_id = $company->id; $attendanceAwardTemplate->title = 'Increment Letter'; $attendanceAwardTemplate->description = '

##EMPLOYEE_NAME##

Employee ID : ##EMPLOYEE_ID##

Designation : ##EMPLOYEE_DESIGNATION##

Date : ##CURRENT_DATE##

Subject: Salary Increment

Congratulations!

We would like to gladly inform you that your salary will be increased by ₹XXXX starting 1st ##CURRENT_MONTH## ##CURRENT_YEAR## and your new salary will be ₹XXXX.

This increase is the result of excellent performance at Codraj and your continuous contribution to the success of this company. We recognize your efforts and would like to reward you for that.

We also hope this will encourage you to perform even better. There is always room for improvement. Keep up the good work.

Signature of designated person

For ##COMPANY_NAME##

'; $attendanceAwardTemplate->save(); } }