Da

✏️ Editing: email_tempaltes.sql

INSERT INTO `email_templates` (`id`, `title`, `body`, `background_image`, `image`, `logo`, `icon`, `button_name`, `button_url`, `footer_text`, `copyright_text`, `type`, `email_type`, `email_template`, `privacy`, `refund`, `cancelation`, `contact`, `facebook`, `instagram`, `twitter`, `linkedin`, `pinterest`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Change Password Request', 'The following user has forgotten his password &amp; requested to change/reset their password.&nbsp;\r\n\r\n&nbsp;\r\n\r\nUser Name: {userName}', NULL, NULL, NULL, '2023-06-21-64928742ceb74.png', '', '', 'Footer Text Please contact us for any queries; we’re always happy to help.', '© 2023 StackFood. All rights reserved.', 'admin', 'forget_password', '5', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-20 18:19:43', '2023-06-21 00:14:42'),
(2, 'New Restaurant Registration Request', 'Please find below the details of the new Restaurant registration:\r\n\r\nRestaurant Name: {restaurantName}\r\n\r\nTo review the Restaurant from the respective Module, go to:&nbsp;\r\n\r\n&nbsp;\r\n\r\nOr you can directly review the Restaurant here &rarr;\r\n\r\n&nbsp;', NULL, '2023-06-21-649287b247980.png', '2023-06-21-649287b247c83.png', NULL, 'Review Request', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 StackFood. All rights reserved.', 'admin', 'restaurant_registration', '1', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-20 18:26:41', '2023-06-21 00:16:34'),
(3, 'New Deliveryman Registration Request', 'Please find below the details of the new Deliveryman registration:\r\n\r\n&nbsp;\r\n\r\nDeliveryman Name: {deliveryManName}\r\n\r\nTo review the Restaurant from the respective Module, go to:&nbsp;\r\n\r\nDeliveryman Management&rarr;New Deliveryman\r\n\r\n&nbsp;\r\n\r\nOr you can directly review the Restaurant here &rarr;\r\n\r\n&nbsp;', NULL, '2023-06-21-649287e9b49f8.png', '2023-06-21-649287e9b4d4a.png', NULL, 'Review Request', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 StackFood. All rights reserved.', 'admin', 'dm_registration', '1', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-20 18:35:57', '2023-06-21 00:18:47'),
(4, 'New Withdraw Request', 'Please find below the details of the new Withdraw Request:\r\n\r\n \r\nRestaurant Name: {restaurantName}\r\n\r\nTo review the Refund Request, go to:&nbsp; \r\nTransactions &amp; Reports&rarr;Withdraw Requests\r\n\r\nOr you can directly review the Restaurant here &rarr;', NULL, NULL, NULL, '2023-06-21-6492898f6f2aa.png', 'Review Request', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 Stackfood. All rights reserved.', 'admin', 'withdraw_request', '6', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 00:24:31', '2023-06-21 00:24:31'),
(5, '“BUY ONE GET ONE” Campaign Join Request', 'Please find below the details of the new Campaign Join Request:\r\n\r\n&nbsp;\r\n\r\nRestaurant Name: {restaurantName}\r\n\r\nTo review the Refund Request, go to:&nbsp;\r\n\r\nCampaigns&rarr;Basic Campaigns&rarr;Buy One Get One\r\n\r\n&nbsp;\r\n\r\nOr you can directly review the Restaurant here &rarr;\r\n\r\n&nbsp;', NULL, '2023-06-21-64928a71d990e.png', '2023-06-21-64928a71d9bca.png', NULL, 'Review Request', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 Stack Food. All rights reserved.', 'admin', 'campaign_request', '1', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 00:28:17', '2023-06-21 00:28:17'),
(6, 'You Have A Refund Request.', 'Please find below the details of the new Refund Request:\r\n\r\n&nbsp;\r\n\r\nCustomer Name: {userName}\r\n\r\nOrder ID: {orderId}\r\n\r\nReview the Restaurant here &rarr;\r\n\r\n&nbsp;', NULL, NULL, '2023-06-21-64928b0c3415a.png', NULL, 'Review Request', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 StackFood. All rights reserved.', 'admin', 'refund_request', '2', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 00:30:52', '2023-06-21 00:30:52'),
(7, 'Your Registration has been Submitted Success', 'Dear {userName},\r\n\r\n&nbsp;\r\n\r\nWe&rsquo;ve received your Restaurant Registration Request.&nbsp;\r\n\r\n&nbsp;\r\n\r\nSoon you&rsquo;ll know if your Restaurant registration is accepted or declined by the Admin.&nbsp;\r\n\r\n&nbsp;\r\n\r\nStay Tuned!\r\n\r\n&nbsp;', NULL, NULL, NULL, '2023-06-21-64928c23e1ee1.png', '', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 Stack Food. All rights reserved.', 'restaurant', 'registration', '5', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 00:35:31', '2023-06-21 00:36:15'),
(8, 'Congratulations! Your Registration is Approve', 'Dear {userName},\r\n\r\nYour registration is approved by the Admin.&nbsp;\r\n\r\nFirst, you need to log in to your Restaurant panel.&nbsp;\r\n\r\nAfter that, please set up your Restaurant and start selling!&nbsp;\r\n\r\n \r\nClick here &rarr; <a href=\"https://stackfood-admin.6amtech.com/restaurant-panel/business-settings/restaurant-setup\">https://stackfood-admin.6amtech.com/restaurant-panel/business-settings/restaurant-setup</a>', NULL, NULL, NULL, '2023-06-21-64928ccce5098.png', '', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 ستاكفود. كل الحقوق محفوظة.', 'restaurant', 'approve', '5', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 00:38:20', '2023-06-21 00:38:20'),
(9, 'Your Registration has been Rejected', 'Dear {userName} ,&nbsp;\r\n\r\nWe&rsquo;re sorry to announce that your Restaurant registration was rejected by the Admin.&nbsp;\r\n\r\nTo find out more, please contact us.&nbsp;', NULL, NULL, NULL, '2023-06-21-64928d568a579.png', '', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 Stackfood. All rights reserved.', 'restaurant', 'deny', '5', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 00:40:38', '2023-06-21 00:40:38'),
(10, 'Congratulations! Your Withdrawal is Approved!', 'Dear {userName},\r\n\r\n&nbsp;\r\n\r\nThe amount you requested to withdraw is approved by the Admin and transferred to your bank account.\r\n\r\n&nbsp;', NULL, NULL, NULL, '2023-06-21-64928df27058a.png', 'Review Request', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 StackFood. All rights reserved.', 'restaurant', 'withdraw_approve', '6', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 00:43:14', '2023-06-21 00:43:14'),
(11, 'Your Withdraw Request was Rejected.', 'Dear {userName} ,\r\n\r\n&nbsp;\r\n\r\nThe amount you requested to withdraw was rejected by the Admin.\r\n\r\nReason: Insufficient Balance.\r\n\r\n&nbsp;', NULL, NULL, NULL, '2023-06-21-64928ead57d52.png', 'Review Request', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 StackFood. All rights reserved.', 'restaurant', 'withdraw_deny', '6', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 00:46:21', '2023-06-21 00:46:21'),
(12, 'Your Request is Completed!', 'Dear {userName} ,\r\n\r\n&nbsp;\r\n\r\nWe&rsquo;ve received your Campaign Request.&nbsp;\r\n\r\n&nbsp;\r\n\r\nSoon you&rsquo;ll know if your request is approved or rejected by the Admin.&nbsp;\r\n\r\n&nbsp;\r\n\r\nStay Tuned!\r\n\r\n&nbsp;', NULL, '2023-06-21-64928f57d4793.png', '2023-06-21-64928f57d4a3e.png', NULL, 'See Status', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 Stack Food. All rights reserved.', 'restaurant', 'campaign_request', '1', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 00:49:11', '2023-06-21 00:50:03'),
(13, 'Congratulations! Your Request is Approved!', 'Dear {userName} ,\r\n\r\n&nbsp;\r\n\r\nYour request to join &lsquo;&rsquo;BUY ONE GET ONE&rdquo; campaign is approved by the Admin.\r\n\r\n&nbsp;', NULL, '2023-06-21-649290d86eb06.png', '2023-06-21-649290d86ede0.png', NULL, 'View Status', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 Stackfood. All rights reserved.', 'restaurant', 'campaign_approve', '1', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 00:55:36', '2023-06-21 00:55:36'),
(14, 'Your Campaign Join Request Was Rejected.', 'Dear {userName},\r\n\r\n&nbsp;\r\n\r\nYour request to join the &ldquo;Buy One Get One&rdquo; campaign was rejected by the admin.&nbsp;\r\n\r\n&nbsp;\r\n\r\nReason: Irrelevant Foods.\r\n\r\n&nbsp;', NULL, '2023-06-21-6492918e7d5f6.png', '2023-06-21-6492918e7da37.png', NULL, '', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 StackFood. All rights reserved.', 'restaurant', 'campaign_deny', '7', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 00:58:38', '2023-06-21 00:58:57'),
(15, 'Your Registration is Completed!', 'Dear {userName},\r\n\r\n&nbsp;\r\n\r\nWe&rsquo;ve received your Deliveryman Registration Request.&nbsp;\r\n\r\n&nbsp;\r\n\r\nSoon you&rsquo;ll know if your Deliveryman registration is accepted or declined by the Admin.&nbsp;\r\n\r\n&nbsp;\r\n\r\nStay Tuned!\r\n\r\n&nbsp;', NULL, NULL, NULL, '2023-06-21-649292352bbb1.png', '', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 Stack Food. All rights reserved.', 'dm', 'registration', '5', 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, '2023-06-21 01:01:25', '2023-06-21 01:01:25'),
(16, 'Congratulations! Your Registration is Approve', 'Dear {deliveryManName} ,\r\n\r\n&nbsp;\r\n\r\nYour registration is approved by the Admin.&nbsp;\r\n\r\n&nbsp;\r\n\r\nHere&rsquo;s what to do next:&nbsp;\r\n\r\n<ol>\r\n	<li>Download the Deliveryman app</li>\r\n	<li>Login with the below credentials.</li>\r\n</ol>\r\n\r\nAfter that, please set up your account and start delivery!&nbsp;\r\n\r\n \r\nClick here to download the app&rarr; Download link to the StackFood Deliveryman app', NULL, NULL, NULL, '2023-06-21-649292f1aa096.png', '', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 Stackfood. All rights reserved.', 'dm', 'approve', '5', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 01:04:33', '2023-06-21 01:04:47'),
(17, 'Your Registration has been Rejected', 'Dear {deliveryManName},\r\n\r\n&nbsp;\r\n\r\nWe&rsquo;re sorry to announce that your Deliveryman registration was rejected by the Admin.&nbsp;\r\n\r\n&nbsp;\r\n\r\nTo find out more, please contact us.\r\n\r\n&nbsp;', NULL, NULL, NULL, '2023-06-21-649293646ff54.png', '', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 StackFood. All rights reserved.', 'dm', 'deny', '5', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 01:06:28', '2023-06-21 01:06:28'),
(18, 'Your Account is Suspended.', 'Dear {deliveryManName},\r\n\r\n&nbsp;\r\n\r\nYour Deliveryman account has been suspended by the Admin/Restaurant.&nbsp;\r\n\r\n&nbsp;\r\n\r\nPlease contact the related person to know more.\r\n\r\n&nbsp;', NULL, '2023-06-21-649293fa34204.png', '2023-06-21-6492941da37bc.png', NULL, '', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 Stack Food. All rights reserved.', 'dm', 'suspend', '7', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 01:08:58', '2023-06-21 01:09:33'),
(19, 'Cash Collected.', 'Dear User,\r\n\r\n{transactionId}\r\n\r\nThe Admin has collected cash from you.&nbsp;\r\n\r\n&nbsp;\r\n\r\n&nbsp;', NULL, NULL, NULL, '2023-06-21-64929477319d2.png', 'See Details', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 Stack Food. All rights reserved.', 'dm', 'cash_collect', '6', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 01:11:03', '2023-06-21 01:11:03'),
(20, 'Reset Your Password', 'Please click on this link to reset your Password&nbsp;&rarr;', NULL, NULL, NULL, '2023-06-21-649294c9ca03d.png', '', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 StackFood. All rights reserved.', 'dm', 'forget_password', '4', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 01:12:25', '2023-06-21 01:12:25'),
(21, 'Your Registration is Successful!', 'Congratulations!\r\n\r\n&nbsp;\r\n\r\nYou&rsquo;ve successfully registered.\r\n\r\n&nbsp;', NULL, NULL, NULL, '2023-06-21-6492959c850ac.png', '', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 Stackfood. All rights reserved.', 'user', 'registration', '5', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 01:15:56', '2023-06-21 01:15:56'),
(22, 'Please Register with The OTP', 'ONE MORE STEP:&nbsp;\r\n\r\n&nbsp;\r\n\r\nPlease copy the following OTP &amp; paste it on your sign-up page to complete your registration.\r\n\r\n&nbsp;\r\n\r\n&nbsp;', NULL, NULL, NULL, '2023-06-21-6492967f1bfac.png', '', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 Stack Food. All rights reserved.', 'user', 'registration_otp', '4', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 01:19:43', '2023-06-21 01:19:43'),
(23, 'Confirm Your Login with OTP.', 'Please copy the following OTP &amp; paste it on your Log in page to confirm your account.\r\n\r\n&nbsp;\r\n\r\n&nbsp;', NULL, NULL, NULL, '2023-06-21-64929700e4548.png', '', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 ستاكفود. كل الحقوق محفوظة.', 'user', 'login_otp', '4', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 01:21:13', '2023-06-21 01:21:52'),
(24, 'Please Verify Your Delivery.', 'Please give the following OTP to your Deliveryman to ensure your order.', NULL, NULL, NULL, '2023-06-21-64929767a486d.png', '', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 Stackfood. All rights reserved.', 'user', 'order_verification', '4', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 01:23:35', '2023-06-21 01:23:35'),
(25, 'Your Order is Successful', 'Hi {userName},\r\n\r\nYour order is successful. Please find your invoice below.\r\n\r\n&nbsp;', NULL, NULL, NULL, NULL, 'Review Request', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 Stackfood. All rights reserved.', 'user', 'new_order', '3', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 01:25:02', '2023-06-21 01:25:02'),
(26, 'Refund Order', 'Hi {userName},\r\n\r\nWe&rsquo;ve refunded your requested amount. Please find your refund invoice below.\r\n\r\n&nbsp;', NULL, NULL, NULL, NULL, '', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 Stack Food. All rights reserved.', 'user', 'refund_order', '9', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 01:26:53', '2023-06-21 01:27:32'),
(27, 'Your Refund Request was Rejected.', 'Dear {userName} ,\r\n\r\n&nbsp;\r\n\r\nThe amount you requested for a refund was rejected by the Admin.&nbsp;\r\n\r\n&nbsp;\r\n\r\nTo know more, please contact us.\r\n\r\n&nbsp;', NULL, NULL, '2023-06-21-649298c0949c3.png', NULL, '', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 Stackfood. All rights reserved.', 'user', 'refund_request_deny', '8', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 01:29:20', '2023-06-21 01:29:20'),
(28, 'Reset Your Password', 'Please click on this link to reset your Password&nbsp;&rarr;', NULL, NULL, NULL, '2023-06-21-64929958a6442.png', '', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 StackFood. All rights reserved.', 'user', 'forget_password', '4', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 01:31:52', '2023-06-21 01:31:52'),
(29, 'Fund Added to your Wallet.', 'Dear {userName}\r\n\r\n&nbsp;\r\n\r\nThe Admin has sent funds to your Wallet.&nbsp;\r\n\r\n&nbsp;\r\n\r\n&nbsp;', NULL, NULL, NULL, '2023-06-21-649299ada7670.png', 'Review Request', '', 'Please contact us for any queries; we’re always happy to help.', '© 2023 StackFood. All rights reserved.', 'user', 'add_fund', '6', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2023-06-21 01:33:17', '2023-06-21 01:33:17');

📁 Sid Gifari File Manager