--
-- Dumping data for table `email_templates`
--
INSERT INTO `email_templates` (`id`, `name`, `slug`, `subject`, `bcc`, `html`, `keywords`, `status`, `attachments`, `created_at`, `updated_at`) VALUES
(2, 'Client Referral', 'client-referral', 'Client Referral Link!', 'pradip@coretechno.com.au', '\r\n\r\n \r\n\r\n\r\nHi ##email##,
\r\n\r\nClient Referral Link
\r\n\r\nLink: ##link##
\r\n\r\nThank You,
\r\n\r\n##email_signature_company_name##
\r\n\r\n', 'email_signature_company_name\r\nlink\r\nemail', 1, NULL, '2022-02-07 16:32:45', '2022-02-07 17:38:58'),
(3, 'STAFF LEAVE REQUEST MANAGEMENT', 'staff-leave-request-management', 'STAFF LEAVE REQUEST ##name##', NULL, '\r\n\r\n \r\n\r\n\r\nHi All,
\r\n\r\nLeave Requested
\r\n\r\nRequested From : ##name##
\r\n\r\nUser Reason : ##user_reason##
\r\n\r\n##leave_details_table##
\r\n\r\nThank You,
\r\n\r\n##email_signature_company_name##
\r\n\r\n', 'name\r\nemail\r\nuser_reason\r\nleave_details_table\r\nemail_signature_company_name', 1, NULL, '2022-02-11 13:18:44', '2022-02-11 14:09:31'),
(4, 'STAFF LEAVE REQUEST', 'staff-leave-request', 'STAFF LEAVE REQUEST ##name##', 'pradip@coretechno.com.au', '\r\n\r\n \r\n\r\n\r\nHi ##name##,
\r\n\r\nLeave Requested
\r\n\r\nRequested From : ##name##
\r\n\r\nUser Reason : ##user_reason##
\r\n\r\n##leave_details_table##
\r\n\r\nThank You,
\r\n\r\n##email_signature_company_name##
\r\n\r\n', 'name\r\nemail\r\nuser_reason\r\nleave_details_table\r\nemail_signature_company_name', 1, NULL, '2022-02-11 13:18:44', '2022-02-11 14:24:09'),
(5, 'STAFF LEAVE REQUEST APPROVE', 'staff-leave-request-approve', 'Leave Request ##leave_status##', 'pradip@coretechno.com.au', '\r\n\r\n \r\n\r\n\r\nHi ##name##,
\r\n\r\nLeave request approved,
\r\n\r\n##leave_details_table##
\r\n\r\nThank You,
\r\n\r\n##email_signature_company_name##
\r\n\r\n', 'name\r\nleave_details_table\r\nemail_signature_company_name\r\nleave_status', 1, NULL, '2022-02-11 13:18:44', '2022-02-11 14:33:37'),
(6, 'STAFF LEAVE REQUEST REJECTED', 'staff-leave-request-rejected', 'Leave Request ##leave_status##', 'pradip@coretechno.com.au', '\r\n\r\n \r\n\r\n\r\nHi ##name##,
\r\n\r\nLeave request rejected,
\r\n\r\n##leave_details_table##
\r\n\r\nThank You,
\r\n\r\n##email_signature_company_name##
\r\n\r\n', 'name\r\nleave_details_table\r\nemail_signature_company_name\r\nleave_status', 1, NULL, '2022-02-11 13:18:44', '2022-02-11 14:36:57'),
(7, 'Document Expiry Reminder', 'certificate-expiry-reminder', 'Document Expiry Reminder - ##date##', 'pradip@coretechno.com.au', '\r\n\r\n \r\n\r\n\r\nHi ##email##,
\r\n\r\nAs per the records your certificate - ##certificate_name## is expiring on ##expiry_date##. Can you please share the updated/new certificate to the management team and inform them to update the details on the portal.
\r\n\r\nThank You,
\r\n\r\n##email_signature_company_name##
\r\n\r\n', 'date\r\nemail\r\ncertificate_name\r\nexpiry_date', 1, NULL, '2022-02-07 16:32:45', '2022-02-11 14:57:49'),
(8, 'Incident Report', 'incident-report', 'Incident Report for ##client_name##', 'pradip@coretechno.com.au', '\r\n\r\n \r\n\r\n\r\nHi ##email##,
\r\n\r\n#Incident Report Details as below#
\r\n\r\n##incident_details_table##
\r\n\r\nThank You,
\r\n\r\n##email_signature_company_name##
\r\n\r\n', 'client_name\r\nemail\r\nincident_details_table\r\nemail_signature_company_name', 1, NULL, '2022-02-07 16:32:45', '2022-02-11 16:24:41'),
(9, 'Management Meeting', 'management-meeting', 'Management Meeting for ##client_name##', 'pradip@coretechno.com.au', '\r\n\r\n \r\n\r\n\r\nHi ##email##,
\r\n\r\n#Management Meeting#
\r\n\r\n##details_table##
\r\n\r\nThank You,
\r\n\r\n##email_signature_company_name##
\r\n\r\n', 'client_name\r\nemail\r\ndetails_table\r\nemail_signature_company_name', 1, NULL, '2022-02-07 16:32:45', '2022-02-11 16:24:41'),
(10, 'Staff Meeting', 'staff-meeting', 'Staff Meeting for ##client_name##', 'pradip@coretechno.com.au', '\r\n\r\n \r\n\r\n\r\nHi ##email##,
\r\n\r\n#Staff Meeting#
\r\n\r\n##details_table##
\r\n\r\nThank You,
\r\n\r\n##email_signature_company_name##
\r\n\r\n', 'client_name\r\nemail\r\ndetails_table\r\nemail_signature_company_name', 1, NULL, '2022-02-07 16:32:45', '2022-02-11 16:24:41'),
(11, 'Roster Add', 'roster-add', 'New Roster Assigned ##date##', 'pradip@coretechno.com.au', '\r\n\r\n \r\n\r\n\r\nHi ##email##,
\r\n\r\n#Please check your account. You have assigned new roster.#
\r\n\r\n##details_table##
\r\n\r\nThank You,
\r\n\r\n##email_signature_company_name##
\r\n\r\n', 'email\r\ndetails_table\r\nemail_signature_company_name\r\ndate', 1, NULL, '2022-02-07 16:32:45', '2022-02-11 16:24:41'),
(12, 'Roster Update', 'roster-update', 'Update Roster with cover staff ##date##', 'pradip@coretechno.com.au', '\r\n\r\n \r\n\r\n\r\nHi ##email##,
\r\n\r\n#Please check your account. You have assigned cover shift in this roster.#
\r\n\r\n##details_table##
\r\n\r\nThank You,
\r\n\r\n##email_signature_company_name##
\r\n\r\n', 'email\r\ndetails_table\r\nemail_signature_company_name\r\ndate', 1, NULL, '2022-02-07 16:32:45', '2022-02-11 16:24:41'),
(13, 'Roster Cancel', 'roster-cancel', 'Cancel shift in Roster ##date##', 'pradip@coretechno.com.au', '\r\n\r\n \r\n\r\n\r\nHi ##email##,
\r\n\r\n#Please check your account. You shift has been removed in this roster.#
\r\n\r\n##details_table##
\r\n\r\nThank You,
\r\n\r\n##email_signature_company_name##
\r\n\r\n', 'email\r\ndetails_table\r\nemail_signature_company_name\r\ndate', 1, NULL, '2022-02-07 16:32:45', '2022-02-11 16:24:41'),
(14, 'Training Assigned', 'new-training-assigned', 'New Training Assigned ##date##', 'pradip@coretechno.com.au', '\r\n\r\n \r\n\r\n\r\nHi ##email##,
\r\n\r\nYou have been assigned with the new training.
\r\nTo check more details with regards to the training, please visit the portal and select MY TRAINING from the menu.
\r\n\r\nThank You,
\r\n\r\n##email_signature_company_name##
\r\n\r\n', 'date\r\nemail\r\nemail_signature_company_name', 1, NULL, '2022-02-07 16:32:45', '2022-02-07 17:38:58'),
(15, 'House Meeting', 'weekly-house-meeting', 'House Meeting for ##client_name##', 'pradip@coretechno.com.au', '\r\n\r\n \r\n\r\n\r\nHi ##email##,
\r\n#House Meeting#
\r\n##details_table##\r\n\r\nThank You,
\r\n\r\n##email_signature_company_name##
\r\n\r\n', 'details_table\r\nemail\r\nclient_name\r\nemail_signature_company_name', 1, NULL, '2022-02-07 16:32:45', '2022-02-07 17:38:58');