File: /var/www/vhosts/creativefellows.nl/mygeomil.creativefellows.nl/03072023/config/settings.php
<?php
// Error reporting for production
//setlocale(LC_ALL, 'nl_NL');
function d($str)
{
echo "<pre>";
print_r($str);
echo "</pre>";
}
/*
* Query for updating duplicaties articles in db
*
* UPDATE articles a1 INNER JOIN articles a2 SET a1.status = 0 WHERE a1.article_id > a2.article_id AND a1.geomil_article_id = a2.geomil_article_id;
*/
//////////
// OFFICE 365 oauth implememntatie
// https://github.com/PHPMailer/PHPMailer/wiki/Microsoft-Azure-and-XOAUTH2-setup-guide
//////////
// Timezone
date_default_timezone_set('Europe/Amsterdam');
// Settings
$settings = [];
// Global
$settings['root'] = dirname(__DIR__);
$settings['temp'] = $settings['root'] . '/tmp';
$settings['public'] = $settings['root'] . '/public';
$settings['upload_dir'] = $settings['root'] . '/public/content/';
$settings['template_path'] = $settings['root'] . '/views/';
$settings['resources'] = $settings['root'] . '/resources/';
$settings['upload_user_dir'] = $settings['root'] . '/public/content/upload/';
$settings['upload_secure_dir'] = $settings['root'] . '/upload/';
$settings["hash"] = "a7ffc6f8bf1ed76651c14756a061d662f580ff4de43b49fa82d80a4b80f8434a";
$settings['domain_name'] = '/';
$settings['domain_path'] = 'http://mygeomil.creativefellows.nl';
$settings["pagination"] = 30;
$settings['email_from'] = [
"email"=> "service@geomil.com",
"name" => "Geomil Equipment"
];
$settings['survey_mailbox'] = [
"username" => "mygeomil@creativefellows.nl",
"password" => "Lnl20^5r2",
"server" => "imap.creativefellows.nl",
"port" => 993,
];
// Form fields
$settings["fields"] = [
"survey_trade" => [
"action" => "survey.post",
"fields" => [
"question_1_header" => ["id" => "question_1_header", "label" => "How happy are you with the communication and information provided with this trade order?", "type" => "group", "size" => "small-12"],
"question_1" => ["id" => "question_1", "label" => "question_1", "type" => "csat", "size" => "small-12","required" => true],
"question_2_header" => ["id" => "question_2_header", "label" => "How happy are you happy with the quality of the supplied articles?", "type" => "group", "size" => "small-12"],
"question_2" => ["id" => "question_2", "label" => "question_1", "type" => "csat", "size" => "small-12","required" => true],
"question_3_header" => ["id" => "question_3_header", "label" => "How happy are you with the speed of processing, from order intake to delivery? ", "type" => "group", "size" => "small-12"],
"question_3" => ["id" => "question_3", "label" => "question_1", "type" => "csat", "size" => "small-12","required" => true],
//"score_header" => ["id" => "score_header", "label" => "Average rating", "type" => "group", "size" => "small-12"],
"score" => ["id" => "score", "label" => "Overall score", "label"=> "Average rating", "type" => "score", "value" => "", "size" => "small-12", "required" => false, "custom" => null],
"feedback_header" => ["id" => "feedback_header", "label" => "How can we improve your experience with Geomil Equipment?", "type" => "group", "size" => "small-12"],
"feedback" => ["id" => "feedback", "label" => "How can we improve your experience with Geomil Equipment?", "label"=> false, "type" => "text", "value" => "", "size" => "small-12", "required" => false, "custom" => null, "placeholder" => "Any additional feedback?"],
"complete" => ["id" => "complete", "label" => "Submit survey", "type" => "button", "class" => "secondary small-only-expanded", "size" => "small-12 medium-6", "required" => false],
],
],
"survey_service" => [
"action" => "survey.post",
"fields" => [
"question_1_header" => ["id" => "question_1_header", "label" => "How happy are you with the communication and information provided with this service order?", "type" => "group", "size" => "small-12"],
"question_1" => ["id" => "question_1", "label" => "question_1", "type" => "csat", "size" => "small-12","required" => true],
"question_2_header" => ["id" => "question_2_header", "label" => "How happy are you happy with the quality of the service provided?", "type" => "group", "size" => "small-12"],
"question_2" => ["id" => "question_2", "label" => "question_1", "type" => "csat", "size" => "small-12","required" => true],
"question_3_header" => ["id" => "question_3_header", "label" => "How happy are you with the speed of processing, from service intake to closing? ", "type" => "group", "size" => "small-12"],
"question_3" => ["id" => "question_3", "label" => "question_1", "type" => "csat", "size" => "small-12","required" => true],
"score" => ["id" => "score", "label" => "Overall score", "label"=> "Average rating", "type" => "score", "value" => "", "size" => "small-12", "required" => false, "custom" => null],
"feedback_header" => ["id" => "feedback_header", "label" => "How can we improve your experience with Geomil Equipment?", "type" => "group", "size" => "small-12"],
"feedback" => ["id" => "feedback", "label" => "How can we improve your experience with Geomil Equipment?", "label"=> false, "type" => "text", "value" => "", "size" => "small-12", "required" => false, "custom" => null, "placeholder" => "Any additional feedback?"],
"complete" => ["id" => "complete", "label" => "Submit survey", "type" => "button", "class" => "secondary", "size" => "small-12 medium-6", "required" => false],
],
],
"files_email" => [
"action" => "files.list",
"fields" => [
"email_header" => ["id" => "email_header", "label" => "Client notification email", "type" => "group", "size" => "small-12"],
"email_to" => ["id" => "email_to", "label" => "Email recipient", "type" => "email", "size" => "small-12", "value" => "naam@mail.com"],
"email_subject" => ["id" => "email_subject", "label" => "Email subject", "type" => "input", "size" => "small-12", "value" => "New Knowledge Notification"],
"email_body" => ["id" => "email_body", "label" => "Message", "type" => "texteditor", "value" => "<h2><strong>Dear <span class=\"ql-label\" contenteditable=\"false\">{full_name}</span></strong>,</h2><p contenteditable=\"true\">New files have been added to your My Geomil account. Login into your account to view the details.</p>", "size" => "small-12 medium-8", "required" => false],
"complete" => ["id" => "complete", "label" => "Send notification", "type" => "button", "class" => "", "size" => "small-12 medium-6", "required" => false],
],
],
"cart" =>[
"action" => "order.post",
"fields" => [
"shipping" => ["id" => "shipping", "label" => "Shipping", "type" => "select", "options" => ["" => "- Select shipping -", 1 => "Ex-works",2 => "Economy", 3 => "Express", 4 => "Urgent"], "size" => "small-12 medium-4", "required" => true],
"shipping_type" => ["id" => "shipping_type", "label" => "Shipping type", "type" => "select", "options" => ["When applicable","Airfreight","Seafreight"], "size" => "small-12 medium-4"],
"order_processing" => ["id" => "order_processing", "label" => "Order processing", "type" => "select", "options" => ["" => "- Select -", 1 => "Quotation", 2 => "Order acknowledgement"], "size" => "small-12 medium-4", "required" => true],
//"delivery" => ["id" => "delivery", "label" => "Delivery Address", "type" => "address","value" => 0, "size" => "small-12", "required" => false, "custom" => null],
"reference" => ["id" => "reference", "label" => "Order reference", "type" => "input", "size" => "small-12", "required" => false],
"address" => ["id" => "address", "label" => "Delivery address", "type" => "text", "value" => "", "size" => "small-12 medium-4", "required" => false, "custom" => null, "placeholder" => "Delivery address if different from default"],
"additional" => ["id" => "additional", "label" => "Additional requests","type" => "text", "value" => "", "size" => "small-12 medium-8", "required" => false],
//"form_spacer" => ["id" => "form_spacer", "type" => "spacer", "size" => "small-12"],
"form_message" => ["id" => "form_message", "type" => "message", "size" => "small-12", "value" => "<p class=\"terms-conditions\">All business transactions are subject to the Terms and Conditions of the Metaalunie as filed with the Registry of the Court of Rotterdam on 1 January 2019.</p>"],
"complete" => ["id" => "complete", "label" => "Submit order request", "type" => "button", "class" => "", "size" => "small-12 medium-6", "required" => false],
],
],
"service" =>[
"action" => "service.confirm",
"submit"=> "service.submit",
"fields" => [
// intro
"header_form" => ["id" => "header", "label" => "Service request type", "type" => "group", "size" => "small-12 form-field__header", "required" => false],
"service_type" => [
"id" => "service_type",
"label" => "Service request",
"type" => "radio",
"legend" => false,
"toggle_fields" => true,
"size" => "small-12",
"options" => [
3 => [
"value" => "Electro: cones, cables, digital acquisition system",
"data-show" => "elektro_header,elektro_conerow,service_complete,request_additional,service_header,service_date_turnin,service_contact,service_contact_phone,service_contact_email,request_upload,request_spacer,service_delivery_address",
"data-hide" => true,
"data-occupancy" => 0
],
2 => [
"value" => "Workshop: equipment maintenance",
"data-show" => "maintenance_header,maintenance_machinetype,maintenance_machineserialno,maintenance_enginehours,maintenance_options,service_complete,request_additional,service_header,service_date_turnin,service_contact,service_contact_phone,service_contact_email,request_upload,maintenance_servicetype,request_spacer,maintenance_price,maintenance_rebate,maintenance_netto,maintenance_custom,maintenance_warranty,service_location,service_address",
"data-hide" => true,
"data-occupancy" => 1
],
1 => [
"value" => "Workshop: equipment repair",
"data-show" => "repair_header,repair_machinetype,repair_machineserialno,repair_enginehours,repair_priority,request_additional,service_header,service_date_turnin,service_contact,service_contact_phone,service_contact_email,request_upload,service_complete,request_spacer,service_location,service_address",
"data-hide" => true,
"data-occupancy" => 1
],
]
],
"subject" => ["id" => "subject", "label" => "Subject", "type" => "input", "size" => "small-12", "required" => false],
// "occupancy" => ["id" => "occupancy", "label" => "Occupancy", "type" => "occupancy", "size" => "small-12", "required" => false, "placeholder" => "dd-mm-yyyy"],
// repair
"repair_header" => ["id" => "repair_header", "label" => "Repair", "type" => "group", "size" => "small-12"],
//"repair_subject" => ["id" => "repair_subject", "label" => "Subject", "type" => "input", "size" => "small-12", "required" => false],
"repair_machinetype" => ["id" => "repair_machinetype", "label" => "Machine", "type" => "input", "size" => "small-12 medium-4", "required" => false],
"repair_machineserialno" => ["id" => "repair_machineserialno", "label" => "Serial number", "type" => "input", "size" => "small-12 medium-4", "required" => false,"tooltip" => "Insert your four digit serial number"],
//"repair_enginemonths" => ["id" => "repair_enginemonths", "label" => "Engine Months", "type" => "input", "size" => "small-12 medium-3", "required" => false],
"repair_enginehours" => ["id" => "repair_enginehours", "label" => "Engine hours", "type" => "input", "size" => "small-12 medium-4", "required" => false],
"repair_priority" => ["id" => "repair_priority", "label" => "Priority", "type" => "radio", "options" => [
0 => ["value" => "Low", "data-desc" => "Machine experiences a small problem. Geomil action required within 5 working days."],
1 => ["value" => "Medium", "data-desc" => "Machine experiences a problem that might lead to a disturbance within the next days. Geomil action required within 3 working days."],
2 => ["value" => "High", "data-desc" => "Machine experiences a serious problem that might lead to a stand-still. Geomil action required within 1 working day. Emergency tariff may apply."],
3 => ["value" => "Emergency", "data-desc" => "Machine has a stand-still. Assistance required within one hours on working days(CET). Geomil action required within 1 hour. Emergency tariff may apply."]
], "size" => "small-12"],
// maintenance
"maintenance_header" => ["id" => "maintenance_header", "label" => "Maintenance", "type" => "group", "size" => "small-12"],
"maintenance_custom" => [
"id" => "maintenance_custom",
"label" => "Maintenance type",
"type" => "radio",
"size" => "small-12",
"required" => false,
"toggle_fields" => true,
"tooltip" => "Select if you want to use one of our 4 standard maintenance programs or choose a custom program",
"options" => [
1 => ["value" => "Standard service", "checked" => true,"data-show" => "maintenance_servicetype,maintenance_price,maintenance_rebate,maintenance_netto,maintenance_options", "data-hide" => false],
2 => ["value" => "Custom service (issue not described within service details)", "data-show" => "maintenance_servicetype,maintenance_price,maintenance_rebate,maintenance_netto,maintenance_options", "data-hide" => true]
]
],
//"maintenance_subject" => ["id" => "maintenance_subject", "label" => "Subject", "type" => "input", "size" => "small-12", "required" => false],
"maintenance_machinetype" => ["id" => "maintenance_machinetype", "label" => "Machine", "type" => "select", "size" => "small-12 medium-6", "required" => false, "options" => ["Lynx-100" => "Lynx-100","Lynx-200" => "Lynx-200","Panther-100" => "Panther-100","Panther-130" => "Panther-130", "Panther-170" => "Panther-170","Kodiak-170" => "Kodiak-170","Grizzly-200" => "Grizzly-200"]],
"maintenance_alias" => ["id" => "maintenance_alias", "label" => "Machine alias", "type" => "input", "size" => "small-12 medium-6", "required" => false],
"maintenance_machineserialno" => ["id" => "maintenance_machineserialno", "label" => "Serial number", "type" => "input", "size" => "small-12 medium-3", "required" => false,"tooltip" => "Insert your four digit serial number"],
"maintenance_warranty" => ["id" => "maintenance_warranty", "label" => "Warranty", "type" => "date_hidden", "size" => "small-12 medium-3", "required" => false, "value" => "No warranty"],
"maintenance_servicetype" => ["id" => "maintenance_servicetype", "label" => "Service type", "type" => "select", "size" => "small-12 medium-6", "required" => false, "options" => ["First" => "First service", "Interim" => "Interim service", "Plus" => "Plus service", "Complete" => "Full service"]],
"maintenance_enginehours" => ["id" => "maintenance_enginehours", "label" => "Engine hours", "type" => "input", "size" => "small-12 medium-6", "required" => false],
/*
* temporarily deactivate pricing for maintenance
*
"maintenance_price" => ["id" => "maintenance_price", "label" => "Amount gross", "type" => "price", "size" => "small-12 medium-4", "required" => false],
"maintenance_rebate" => ["id" => "maintenance_rebate", "label" => "Service rebate", "type" => "price", "size" => "small-12 medium-4", "required" => false],
"maintenance_netto" => ["id" => "maintenance_netto", "label" => "Amount nett", "type" => "price", "size" => "small-12 medium-4", "required" => false],
*/
"service_custom" => [
"id" => "service_custom",
"label" => "Select/deselect service details",
"type" => "checkbox",
"options" => [
1 => ["value" => "Base", "checked" => true],
2 => ["value" => "Regular", "checked" => true],
3 => ["value" => "Hydraulic system", "checked" => true],
4 => ["value" => "Electric system", "checked" => true],
5 => ["value" => "Mechanical system", "checked" => true],
6 => ["value" => "Unit", "checked" => true],
],
"size" => "small-12 hide"
],
"maintenance_options" => ["id" => "maintenance_options", "label" => "Maintenance options", "type" => "maintenance", "size" => "small-12", "required" => false],
//"maintenance_enginemonths" => ["id" => "maintenance_enginemonths", "label" => "Service Months", "type" => "select", "size" => "small-12 medium-4", "required" => false, "options" => ["3 months","6 months","12 months","24 months","72 months",]],
// electro
"elektro_header" => ["id" => "elektro_header", "label" => "Electro maintenance & calibration", "type" => "group", "size" => "small-12"],
//"elektro_subject" => ["id" => "elektro_subject", "label" => "Subject", "type" => "input", "size" => "small-12", "required" => false],
"elektro_conerow" => [
"id" => "elektro_conerow",
"label" => "Select type",
"type" => "duplicate",
"size" => "small-12",
"fields" => [
"elektro_service_type" => [
"type" => "select",
"size" => "small-12 medium-4",
"label" => "Select type",
"required" => false,
"options" => [
"" => "Select type",
"Inspection + mechanical revision" => "Inspection + mechanical revision",
"Measuring head" => "Measuring head",
"Cone calibration" => "Cone calibration",
"Calibration of data acquisition system" => "Calibration of data acquisition system",
"Repair of CPT cable" => "Repair of CPT cable",
"Repair of data acquisition system" => "Repair of data acquisition system"
],
],
"elektro_service_serial" => [
"id" => "elektro_serial",
"label" => "Serial number",
"type" => "input",
"size" => "small-12 medium-3",
"tooltip" => "Serial number locations:<br>- Cones: on contact block<br>- Cables: on connector<br>- Measuring heads: on the side<br>- GME/GSN: at the backside",
"required" => false,
],
"elektro_service_remarks" => [
"id" => "elektro_remarks",
"label" => "Remarks",
"type" => "input",
"size" => "small-12 medium-4",
"placeholder" => "Provide a short problem description",
"required" => false,
],
],
],
// general information
"service_header" => ["id" => "service_header", "label" => "General information", "type" => "group", "size" => "small-12","tooltip" => "Provide your contact details in case they differ from the customary details"],
"service_date_turnin" => ["id" => "service_date_turnin", "label" => "Preferred turn in date", "type" => "occupancy", "size" => "small-12 medium-6", "required" => false,"placeholder" => "dd-mm-yyyy","tooltip" => "Go to the calendar and select the date you expect the equipment to return at Geomil in Moordrecht. Access availability status: green, orange or red. Tap on the date to select the preferred date"],
"service_contact" => ["id" => "service_contact", "label" => "Contact", "type" => "input", "size" => "small-12 medium-6", "required" => true],
"service_contact_phone" => ["id" => "service_contact_phone", "label" => "Phone number", "type" => "input", "size" => "small-12 medium-6", "required" => false],
"service_contact_email" => ["id" => "service_contact_email", "label" => "E-mail", "type" => "input", "size" => "small-12 medium-6", "required" => true],
"service_location" => [
"id" => "service_location",
"label" => "Location",
"type" => "radio",
"size" => "small-12",
"required" => false,
"toggle_fields" => true,
"options" => [
2 => ["value" => "Service at Geomil","checked" => true, "data-show" => "service_address", "data-hide" => true, "data-direction" => "hide"],
1 => ["value" => "Service at location", "data-show" => "service_address", "data-hide" => false],
]
],
"request_additional" => ["id" => "request_additional", "label" => "Additional information","type" => "text", "size" => "small-12", "required" => false],
"service_address" => ["id" => "service_address", "label" => "Address and contact for service at location","type" => "text", "size" => "small-12", "required" => false],
"service_delivery_address" => ["id" => "service_delivery_address", "label" => "Delivery address","type" => "text", "size" => "small-12", "required" => false,"placeholder" => "Delivery address if different from default"],
"request_upload" => ["id" => "request_upload", "label" => "Upload files", "type" => "upload", "size" => "small-12", "multiple" => "multiple", "required" => false],
// complete
"request_spacer" => ["id" => "request_spacer", "type" => "spacer", "size" => "small-12"],
"service_complete" => ["id" => "service_complete", "label" => "Complete service request", "type" => "post", "class" => "expanded", "size" => "small-12", "required" => false,"action_url" => "/service/save"],
],
],
];
// knowledge-center
$settings["knowledge_center"] = [
"types" => [
1 => "general",
0 => "calibration files",
2 => "installations",
3 => "service certificates",
4 => "training certificates",
]
];
// survey labels
$settings["survey"] = [
"labels" => [
"trade" => [
"survey_type_label" => "organization",
"order_label" => "order",
],
"service" => [
"survey_type_label" => "services",
"order_label" => "service order",
]
]
];
// Error Handling Middleware settings
$settings['error'] = [
'display_error_details' => true,
'log_errors' => true,
'log_error_details' => true,
];
// default labels
$settings["labels"] = [
"logo" => '<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 121.75 37.75"><defs><style>.b{fill:#006fba}.c{fill:#231f20}</style></defs><path fill="#ffcc00" d="M0 23.79h26.91v13.83H0z"/><path class="b" d="M68.69 21.24h-12.2C53 21.24 52 19.78 52 16.53v-6.17c0-3.25 1-4.71 4.52-4.71h12.2c3.52 0 4.51 1.46 4.51 4.71v6.17c-.03 3.25-1.02 4.71-4.54 4.71zm1-11.28c0-.89-.27-1.26-1.2-1.26H56.62c-.86 0-1.13.37-1.13 1.26v7c0 .89.27 1.26 1.13 1.26h11.87c.93 0 1.2-.37 1.2-1.26zM101.74 21.24V9.83c0-.93-.29-1.13-1-1.13h-8.45v12.54h-3.52V8.7h-9.85v12.54h-3.51V5.65h26c2.45 0 3.84 1.19 3.84 4.11v11.48zM108 21.24V5.65h3.51v15.59zm0-17.78V0h3.38v3.46zM118.72 21.26c-2.48 0-4.64-1-4.64-4.88V0h3.52v16.94c0 1 .16 1.27 1.56 1.27h2.26v3.05zM50 15.14v-4.78c0-3.42-.8-4.71-4.51-4.71H33.61c-3.71 0-4.51 1.46-4.51 4.71v6.17c0 3.28 1 4.71 4.51 4.71h12c2.85 0 4-1 4.39-3H34.41c-1.26 0-1.79-.47-1.79-1.59v-1.51zM32.62 10c0-.89.26-1.26 1.12-1.26h11.85c.86 0 1.12.37 1.12 1.26v2.12H32.62zM5 3.06h22C26.61 1 25.42 0 22.57 0h-18C1.25 0 .06 2.1.06 4.72v11.81c0 2.88 1.49 4.71 4.51 4.71h18c2.85 0 4.39-.95 4.39-3V8.53H15.17v3.38h8.45v6.27H5.33c-1.26 0-1.79-.47-1.79-1.59v-12A1.51 1.51 0 0 1 5 3.06z"/><path class="c" d="M31.43 34.08c-1.53 0-2-.63-2-2v-2.73c0-1.42.34-2.05 2-2.05h5.18c1.61 0 2 .56 2 2.05v2.07H31v.64c0 .49.23.69.78.69h6.79c-.15.92-.67 1.33-1.91 1.33zm5.7-4.91c0-.39-.12-.55-.49-.55h-5.15c-.38 0-.49.16-.49.55v.93h6.13zM48.27 36.64v-2.56h-5.45A1.89 1.89 0 0 1 40.68 32v-2.6a1.88 1.88 0 0 1 2.14-2.1h7v9.34zm0-8h-5.58c-.33 0-.48.15-.48.52v3.09c0 .37.15.52.48.52h5.58zM54.36 34.08c-1.6 0-2.26-1-2.26-2.47V27.3h1.53v4.89c0 .41.14.56.56.56h5.55V27.3h1.53v6.78zM63.66 34.08V27.3h1.53v6.78zm0-7.73v-1.5h1.47v1.5zM74.56 34.08h-5.45v2.56h-1.53V27.3h7a1.88 1.88 0 0 1 2.14 2.1V32a1.89 1.89 0 0 1-2.16 2.08zm.61-4.94c0-.37-.15-.52-.48-.52h-5.58v4.13h5.58c.33 0 .48-.15.48-.52zM90.45 34.08v-5c0-.4-.13-.49-.42-.49h-3.69v5.46h-1.53v-5.43h-4.28v5.46H79V27.3h11.32c1.06 0 1.67.52 1.67 1.79v5zM113.23 34.08v-5c0-.34-.06-.49-.42-.49h-5.68v5.46h-1.53V27.3h7.4c1.17 0 1.72.5 1.72 1.81v5zM119.17 34.08c-1.08 0-2-.44-2-2.12v-6.13h1.53v1.47h2.56v1.32h-2.56v3.58c0 .43.07.55.68.55h2.07v1.33zM96.25 34.08c-1.53 0-2-.63-2-2v-2.73c0-1.42.35-2.05 2-2.05h5.18c1.61 0 2 .56 2 2.05v2.07h-7.61v.64c0 .49.23.69.78.69h6.79c-.15.92-.67 1.33-1.91 1.33zm5.7-4.91c0-.39-.12-.55-.49-.55h-5.15c-.38 0-.49.16-.49.55v.93H102z"/></svg>',
"404" => [
"title" => "Page not found (404)",
"description" => "Sorry, we can’t seem to find what you’re looking for"
],
"403" => [
"title" => "Forbidden (403)",
"description" => "You do not have permission to download this file, as this is a licensed file to be downloaded only once",
]
];
$settings['logger'] = [
'name' => 'app',
'path' => $settings['root'] . '/logs',
'filename' => 'app.log',
'level' => \Monolog\Logger::DEBUG,
'file_permission' => 0775,
];
$settings['db'] = [
'driver' => 'mysql',
'host' => 'localhost',
'database' => 'admin_mygeomil_production',//Fellows_my_geomil
'username' => 'admin_mygeomil_usr', //Fellows_mygeo_usr
'password' => 'j^cNn1751', //kP8fv1@9
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'flags' => [
// Turn off persistent connections
PDO::ATTR_PERSISTENT => false,
// Enable exceptions
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
// Emulate prepared statements
PDO::ATTR_EMULATE_PREPARES => true,
// Set default fetch mode to array
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
// Set character set
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci'
],
];
return $settings;