//4-4-2019
INSERT INTO `permissions` (`id`, `label`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'CreateDaily Reports', 'reports.createdaily', 'web', NULL, NULL), (NULL, 'CreatePast Reports', 'reports.createpast', 'web', NULL, NULL);
INSERT INTO `permissions` (`id`, `label`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'GetDaily Reports', 'reports.getdaily', 'web', NULL, NULL), (NULL, 'CreateCustom Items', 'items.customcreate', 'web', NULL, NULL), (NULL, 'PrintSales Reports', 'reports.printsales', 'web', NULL, NULL), (NULL, 'GetAllSale Reports', 'reports.getsalereport', 'web', NULL, NULL);





INSERT INTO `general_settings` (`id`, `site_name`, `cur_text`, `cur_sym`, `email_from`, `mail_config`, `sms_config`, `global_shortcodes`, `created_at`, `updated_at`) VALUES
(1, 'Purewellness', 'KES', 'KES', 'notify@wstacks.com','{\"name\":\"smtp\",\"host\":\"uat.lifelinesafaris.com\",\"port\":\"587\",\"enc\":\"tls\",\"username\":\"adminlifeline@uat.lifelinesafaris.com\",\"password\":\"lifelineafrica@2023\"}', '{\"name\":\"messageBird\",\"clickatell\":{\"api_key\":\"----------------\"},\"infobip\":{\"username\":\"------------8888888\",\"password\":\"-----------------\"},\"message_bird\":{\"api_key\":\"-------------------\"},\"nexmo\":{\"api_key\":\"----------------------\",\"api_secret\":\"----------------------\"},\"sms_broadcast\":{\"username\":\"----------------------\",\"password\":\"-----------------------------\"},\"twilio\":{\"account_sid\":\"-----------------------\",\"auth_token\":\"---------------------------\",\"from\":\"----------------------\"},\"text_magic\":{\"username\":\"-----------------------\",\"apiv2_key\":\"-------------------------------\"},\"custom\":{\"method\":\"get\",\"url\":\"https:\\/\\/hostname\\/demo-api-v1\",\"headers\":{\"name\":[\"api_key\"],\"value\":[\"test_api 555\"]},\"body\":{\"name\":[\"from_number\"],\"value\":[\"5657545757\"]}}}', '{\n    \"site_name\":\"Name of your site\",\n    \"site_currency\":\"Currency of your site\",\n    \"currency_symbol\":\"Symbol of currency\"\n}', NULL, '2024-03-01 20:56:22');



CREATE TABLE `admin_notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `title` varchar(255) DEFAULT NULL,
  `read_status` tinyint(1) NOT NULL DEFAULT 0,
  `click_url` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



php artisan queue:work




INSERT INTO `notification_templates` (
    `id`,
    `name`,
    `subject`,
    `email_content`,
    `sms_content`,
    `shortcodes`,
      `created_at`,
    `updated_at`
) VALUES (
    1,
    'INVOICE_NOTIFICATION',
    'Invoice Notification',
    '<p>Dear {{customer_name}},</p><p>Your invoice has been generated with the following details:</p><p>Invoice Number: {{invoice_no}}</p><p>Amount: {{site_currency}}{{amount}}</p><p>Payment Date: {{payment_date}}</p><p>Units Consumed: {{units}}</p><p>Thank you for your prompt payment.</p><p>Best regards,</p><p>{{site_name}}</p>',
    'Dear {{customer_name}},\r\n\r\nYour invoice has been generated with Invoice Number: {{invoice_no}}. The total amount is {{site_currency}}{{amount}}. Payment Date: {{payment_date}}. Units Consumed: {{units}}.\r\n\r\nThank you for your prompt payment.\r\n\r\nBest regards,\r\n{{site_name}}',
    '{\"invoice_no\":\"Invoice number\",\"amount\":\"Amount to be paid\",\"payment_date\":\"Invoice Payment Date\",\"units\":\"Units consumed\",\"customer_name\":\"Customer name\",\"site_name\":\"Website name\",\"site_currency\":\"Currency symbol\"}',
    NOW(),
    NOW()
);



INSERT INTO `notification_templates` (
    `name`, `subject`, `email_content`, `sms_content`, `shortcodes`, `created_at`, `updated_at`
) VALUES (
    'INVOICE_NOTIFICATION_FOR_INSTALLATION',
    'Installation Invoice',
    '<p>Dear {{customer_name}},</p>
    <p>Your installation invoice ({{invoice_no}}) is ready.</p>
    <p>Amount: {{site_currency}}{{amount}}</p>
    <p>Account Number: {{account_number}}</p>
    <p><strong>Quick Payment:</strong> <a href="{{quick_pay_url}}" style="color: blue;">Click here to pay via M-Pesa STK Push</a></p>
    <p><strong>Manual Payment Details:</strong> {{manual_payment_details}}</p>
    <p>Please make payment at your earliest convenience.</p>
    <p>Regards,<br>{{site_name}}</p>',
    
    'Dear {{customer_name}}, your installation invoice {{invoice_no}} of {{site_currency}}{{amount}} is ready. 
    Account: {{account_number}}. 
    Quick Pay: {{quick_pay_url}}. 
    Manual Payment: {{manual_payment_details}}. 
    Regards, {{site_name}}',

    '{\"invoice_no\":\"Invoice number\",\"amount\":\"Amount to be paid\",\"customer_name\":\"Customer name\",\"account_number\":\"Meter or Account\",\"site_name\":\"Website name\",\"site_currency\":\"Currency symbol\",\"quick_pay_url\":\"URL for quick payment via STK push\",\"manual_payment_details\":\"Instructions for manual payment\"}',

    NOW(), NOW()
);

INSERT INTO `notification_templates` (
    `id`,
    `name`,
    `subject`,
    `email_content`,
    `sms_content`,
    `shortcodes`,
    `created_at`,
    `updated_at`
) VALUES (
    2,
    'PASSWORD_NOTIFICATION',
    'Your New Login Password',
    '<p>Dear {{customer_name}},</p><p>Your new login password is <strong>{{password}}</strong>. Please use this password to log in to your account.</p><p>For security reasons, we recommend changing your password after logging in.</p><p>Best regards,</p><p>{{site_name}}</p>',
    'Dear {{customer_name}},\r\n\r\nYour new login password is {{password}}. Please use this password to log in. For security reasons, we recommend changing your password after logging in.\r\n\r\nBest regards,\r\n{{site_name}}',
    '{\"password\":\"Temporary login password\",\"customer_name\":\"Customer name\",\"site_name\":\"Website name\"}',
    NOW(),
    NOW()
);


INSERT INTO `notification_templates` (
    `id`,
    `name`,
    `subject`,
    `email_content`,
    `sms_content`,
    `shortcodes`,
    `created_at`,
    `updated_at`
) VALUES (
    3,
    'REQUEST_COMPLETION_NOTIFICATION',
    'Commission Earned for Request #{{request_id}}',
    '<p>Dear {{customer_name}},</p><p>Your request #{{request_id}} has been fully completed.</p><p>You have earned a commission of <strong>KES {{commission_amount}}</strong>.</p><p>Thank you for your service.</p><p>Best regards,<br>{{site_name}}</p>',
    'Dear {{customer_name}}, your request #{{request_id}} has been completed. Commission earned: KES {{commission_amount}}. Thank you. - {{site_name}}',
    '{ "customer_name": "Name of the agent", "request_id": "Request number", "commission_amount": "Total commission earned", "site_name": "Website name" }',
    NOW(),
    NOW()
);


INSERT INTO `notification_templates` (
    `name`,
    `subject`,
    `email_content`,
    `sms_content`,
    `shortcodes`,
    `created_at`,
    `updated_at`
) VALUES (
    'ACTIVATION_NOTIFICATION',
    'Welcome! Your Account Has Been Activated',
    '<p>Dear {{customer_name}},</p><p>We are pleased to inform you that your account has been successfully activated on {{converted_at}}.</p><p><strong>Customer ID:</strong> {{uniquecustomer_id}}</p><p><strong>Meter Number:</strong> {{meter_number}}</p><p><strong>Initial Meter Reading:</strong> {{initial_reading}}</p><p>Thank you for choosing our services. Please contact us if you have any questions.</p><p>Best regards,<br>{{site_name}}</p>',
    'Dear {{customer_name}}, your account is activated. Customer ID: {{uniquecustomer_id}}, Meter: {{meter_number}}, Initial Reading: {{initial_reading}}. - {{site_name}}',
    '{ "customer_name": "Name of the customer", "uniquecustomer_id": "Unique customer identifier", "meter_number": "Assigned meter number", "initial_reading": "Initial meter reading value", "converted_at": "Date of account activation", "site_name": "Website name" }',
    NOW(),
    NOW()
);


INSERT INTO `notification_templates` (
    `name`,
    `subject`,
    `email_content`,
    `sms_content`,
    `shortcodes`,
    `created_at`,
    `updated_at`
) VALUES (
    'INSTALATION PAYMENT_NOTIFICATION',
    'Your Installation Payment Has Been Received',
    '<p>Dear {{customer_name}},</p><p>We have successfully received your payment for the installation invoice.</p><p><strong>Invoice Type:</strong> {{invoice_type}}</p><p><strong>Invoice Number:</strong> {{invoice_no}}</p><p><strong>Amount Paid:</strong> {{amount}}</p><p><strong>Account Number:</strong> {{account_number}}</p><p>Thank you for your payment. Please contact us if you have any questions.</p><p>Best regards,<br>{{site_name}}</p>',
    'Dear {{customer_name}}, your payment of {{amount}} for invoice {{invoice_no}} ({{invoice_type}}) has been received. Account: {{account_number}}. - {{site_name}}',
    '{ "customer_name": "Name of the customer", "invoice_type": "Type of the invoice", "invoice_no": "Invoice number", "amount": "Payment amount", "account_number": "Installation account number", "site_name": "Website name" }',
    NOW(),
    NOW()
);



INSERT INTO `notification_templates` (
    `name`,
    `subject`,
    `email_content`,
    `sms_content`,
    `shortcodes`,
    `created_at`,
    `updated_at`
) VALUES (
    'WATER_READING_NOTIFICATION',
    'New Water Meter Reading Recorded',
    '<p>Dear {{customer_name}},</p><p>A new meter reading has been recorded for your account.</p><p><strong>Account Number:</strong> {{account_number}}</p><p><strong>Invoice Number:</strong> {{invoice_no}}</p><p><strong>Amount Due:</strong> {{amount}}</p><p><strong>Units Consumed:</strong> {{units}}</p><p><strong>Reading Date:</strong> {{reading_date}}</p><p><strong>Payment Methods:</strong></p><p><strong>1. Quick Pay:</strong> Pay online instantly at <a href="{{quick_pay_url}}">{{quick_pay_url}}</a></p><p><strong>2. M-Pesa Paybill:</strong><br>- Paybill Number: {{paybill_number}}<br>- Account Number: {{account_number}}<br>- Amount: {{amount}}</p><p>Please make the payment at your earliest convenience. Contact us for any questions.</p><p>Best regards,<br>{{site_name}}</p>',
    'Dear {{customer_name}}, new meter reading for {{account_number}}. Invoice: {{invoice_no}}, {{units}} units, {{amount}} due. Date: {{reading_date}}. Pay via Quick Pay: {{quick_pay_url}} or M-Pesa Paybill {{paybill_number}}, A/C {{account_number}}. - {{site_name}}',
    '{ "customer_name": "Name of the customer", "account_number": "Customer meter number", "invoice_no": "Invoice number", "amount": "Invoice amount due", "units": "Units consumed", "reading_date": "Date of meter reading", "quick_pay_url": "URL for Quick Pay payment page", "paybill_number": "M-Pesa Paybill number", "site_name": "Website name" }',
    NOW(),
    NOW()
);


php artisan config:cache &&
php artisan route:clear &&  
php artisan view:clear && 
php artisan config:clear &&
php artisan cache:clear && 
php artisan clear-compiled



composer require barryvdh/laravel-dompdf


php artisan vendor:publish --provider="Barryvdh\DomPDF\ServiceProvider"


INSERT INTO `notification_templates` (
    `name`,
    `subject`,
    `email_content`,
    `sms_content`,
    `shortcodes`,
    `created_at`,
    `updated_at`
) VALUES (
    'CREDIT_NOTE_NOTIFICATION',
    'Credit Note Issued for Your Account',
    '<p>Dear {{customer_name}},</p><p>A credit note has been issued for your account.</p><p><strong>Account Number:</strong> {{account_number}}</p><p><strong>Credit Note Number:</strong> {{credit_note_number}}</p><p><strong>Invoice Number:</strong> {{invoice_no}}</p><p><strong>Credit Amount:</strong> {{amount}}</p><p><strong>Issue Date:</strong> {{issue_date}}</p><p><strong>Notes:</strong> {{notes}}</p><p>This credit has been applied to your account, reducing the balance of invoice {{invoice_no}}. For further details, contact us.</p><p>Best regards,<br>{{site_name}}</p>',
    'Dear {{customer_name}}, Credit Note {{credit_note_number}} issued for {{account_number}}. Invoice: {{invoice_no}}, Credit: {{amount}}, Date: {{issue_date}}. Notes: {{notes}}. Balance adjusted. - {{site_name}}',
    '{ "customer_name": "Name of the customer", "account_number": "Customer meter number", "credit_note_number": "Credit note number", "invoice_no": "Associated invoice number", "amount": "Credit note amount", "issue_date": "Date of credit note issuance", "notes": "Credit note notes", "site_name": "Website name" }',
    NOW(),
    NOW()
);



INSERT INTO `notification_templates` (
    `name`,
    `subject`,
    `email_content`,
    `sms_content`,
    `shortcodes`,
    `created_at`,
    `updated_at`
) VALUES (
    'WATER_TOKEN_GENERATION_NOTIFICATION',
    'New Water Token Generated',
    '<p>Dear {{customer_name}},</p><p>A new water token has been generated for your account {{account_number}}.</p><p><strong>Token:</strong> {{token}}</p><p><strong>Credits:</strong> {{credits}} liters</p><p><strong>Valid Until:</strong> {{expiry_date}}</p><p>Please use this token to load your smart meter. Contact us for any issues.</p><p>Best regards,<br>{{site_name}}</p>',
    'Dear {{customer_name}}, new token {{token}} generated for {{account_number}}. Credits: {{credits}} liters, valid until {{expiry_date}}. Load your meter. - {{site_name}}',
    '{ "customer_name": "Name of the customer", "account_number": "Customer meter number", "token": "Generated token", "credits": "Number of credits in liters", "expiry_date": "Token expiry date", "site_name": "Website name" }',
    NOW(),
    NOW()
);