Skip to content

Instantly share code, notes, and snippets.

@adejorosam

adejorosam/gist:cca258b23a27b31c9e6aae03e86aaed9

Last active July 11, 2024 08:31
Show Gist options
  • Save adejorosam/cca258b23a27b31c9e6aae03e86aaed9 to your computer and use it in GitHub Desktop.
Save adejorosam/cca258b23a27b31c9e6aae03e86aaed9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
protected function getFormFields(): array {
return [
'epc-form' => [
'status' => [
"Pending Surveys" => ['value' => "pending", 'color' => $this->getStatusColor()['pending']],
"On Hold" => ['value' => 'on-hold', 'color' => $this->getStatusColor()['on-hold']],
"Payment Completed" => ['value' => 'payment-completed', 'color' => $this->getStatusColor()['payment-completed']],
"Survey Booked" => ['value' => 'survey-booked', 'color' => $this->getStatusColor()['survey-booked']],
'Pending Lodgement' => ['value' => "pending-lodgement", 'color' => $this->getStatusColor()['pending-lodgement']],
"Paid" => ['value' => "paid", 'color' => $this->getStatusColor()['paid']],
"Invoiced" => ['value' => "invoiced", 'color' => $this->getStatusColor()['invoiced']],
"Cancelled" => ['value' => 'cancelled', 'color' => $this->getStatusColor()['cancelled']],
],
'fields' => [
['header' => 'Name', 'field' => 'address', 'field_type' => 'text'],
['header' => 'Lead Source', 'field' => 'lead_source', 'field_type' => 'select', 'options' => ['Lead Source', 'Eco Scheme', 'EDF', 'Stuck', 'Consumer rights', 'The Eco Scheme']],
['header' => 'Status', 'field' => 'status', 'field_type' => 'select', 'options' => ['Done','CANCELLED', 'Paid', 'PENDING SURVEY BOOKING', 'Invoiced', 'Survey Complete Pending EPC Lodgement', 'Survey Booked', 'Payment Completed Pending Surveyor', 'On Hold']],
['header' => 'Postcode', 'field' => 'postcode', 'field_type' => 'text'],
['header' => 'Requested Date', 'field' => 'requested_date', 'field_type' => 'date'],
['header' => 'Customers Name', 'field' => 'customers_name', 'field_type' => 'text'],
['header' => 'Contact Number', 'field' => 'contact_number', 'field_type' => 'text'],
['header' => 'Email Address', 'field' => 'email', 'field_type' => 'email'],
['header' => 'Surveyor', 'field' => 'surveyor', 'field_type' => 'text'],
['header' => 'Surveyor Name', 'field' => 'surveyor_name', 'field_type' => 'text'],
['header' => 'Surveyor Note', 'field' => 'surveyors_note', 'field_type' => 'text'],
['header' => 'AM/PM Booking', 'field' => 'am_pm_booking', 'field_type' => 'text'],
['header' => 'AM/PM Callback', 'field' => 'am_pm_callback', 'field_type' => 'text'],
['header' => 'Property Type', 'field' => 'property_type', 'field_type' => 'select', 'options' => ['Property Type', 'Done', 'Flat', 'Working on it', 'Other', 'Stuck', 'N/A', 'Bungalow', 'Park Home', 'Maisonette', 'House']],
['header' => 'Wall Type', 'field' => 'wall_type', 'field_type' => 'select', 'options' => ['Wall Type', 'Done', 'Working on it', 'Stuck', 'Cavity', 'Timber Frame', 'Solid Brick', 'N/A', 'Stone: Granite or Whinstone', 'Stone: Sandstone or Limestone', 'System Build', 'Park Home', 'Cob', 'Thermal Transmittance']],
['header' => 'Detachment', 'field' => 'detachment', 'field_type' => 'select', 'options' => ['Detachment', 'Done', 'End-Terrace', 'Working on it', 'N/A', 'Stuck', 'Top Floor', 'Semi-Detached','Ground Floor', 'Detached', 'Mid Floor', 'Mid-Terrace','Basement']],
['header' => 'Number Of Bedrooms', 'field' => 'no_of_bedrooms', 'field_type' => 'number'],
['header' => 'Heating Source', 'field' => 'heating_source', 'field_type' => 'text'],
['header' => 'Notes', 'field' => 'notes', 'field_type' => 'text'],
['header' => 'Reasons For Cancellation', 'field' => 'reasons_for_cancellation', 'field_type' => 'textarea'],
['header' => "Is there anything else you'd like to tell us?", 'field' => 'suggestions', 'field_type' => 'textarea'],
['header' => 'By submitting this form, you agree to be contacted by EDF', 'field' => 'terms_accepted', 'field_type' => 'checkbox'],
['header' => 'People', 'field' => 'people', 'field_type' => 'text'],
// ['header' => 'Subitems', 'field' => 'subitems', 'field_type' => 'text'],
['header' => 'EPC Grade To Start', 'field' => 'epc_level', 'field_type' => 'text'],
['header' => 'RRN #', 'field' => 'rrn_number', 'field_type' => 'text'],
['header' => 'Finishing Grade', 'field' => 'finishing_grade', 'field_type' => 'text'],
['header' => 'Platform', 'field' => 'platform', 'field_type' => 'text'],
['header' => 'Tell us which improvements you are most likely to be interested in:', 'field' => 'interested_in', 'field_type' => 'text'],
],
],
'bcl-projects' => [
'status' => [
"Pending RA Surveys" => ['value' => "pending", 'color' => $this->getStatusColor()['pending']],
"On Hold" => ['value' => 'on-hold', 'color' => $this->getStatusColor()['on-hold']],
"Survey Booked" => ['value' => 'survey-booked', 'color' => $this->getStatusColor()['survey-booked']],
'Uploading to system' => ['value' => "system-upload", 'color' => $this->getStatusColor()['system-upload']],
"Coordination Open" => ['value' => "coordination-open", 'color' => $this->getStatusColor()['coordination-open']],
"Awaiting Tech Survey" => ['value' => "awaiting-tech-survey", 'color' => $this->getStatusColor()['awaiting-tech-survey']],
"Design Pending" => ['value' => 'design-pending', 'color' => $this->getStatusColor()['design-pending']],
"Pending Installation" => ['value' => 'pending-installation', 'color' => $this->getStatusColor()['pending-installation']],
"Installed" => ['value' => 'installed', 'color' => $this->getStatusColor()['installed']],
"Quality Check & Post EPC" => ['value' => 'quality-check', 'color' => $this->getStatusColor()['quality-check']],
"Complete Awaiting Lodgement" => ['value' => 'complete-awaiting-lodgement', 'color' => $this->getStatusColor()['complete-awaiting-lodgement']],
"Coordination Complete" => ['value' => 'coordination-complete', 'color' => $this->getStatusColor()['coordination-complete']],
"Steven To Check Off" => ['value' => 'steven-to-check-off', 'color' => $this->getStatusColor()['steven-to-check-off']],
"Paid" => ['value' => "paid", 'color' => $this->getStatusColor()['paid']],
"Cancelled" => ['value' => 'cancelled', 'color' => $this->getStatusColor()['cancelled']],
],
'fields' => [
['header' => 'Name', 'field' => 'address', 'field_type' => 'text'],
['header' => 'Subitems', 'field' => 'subitems', 'field_type' => 'select', 'options' => ['Subitems', 'Pulse Test']],
['header' => 'Postcode', 'field' => 'postcode', 'field_type' => 'text'],
['header' => 'Request Received', 'field' => 'request_received', 'field_type' => 'date'],
['header' => 'Customers Name', 'field' => 'customers_name', 'field_type' => 'text'],
['header' => 'Contact Number', 'field' => 'contact_number', 'field_type' => 'text'],
['header' => 'Mobile Number', 'field' => 'mobile_number', 'field_type' => 'text'],
['header' => 'Email Address', 'field' => 'email', 'field_type' => 'email'],
['header' => 'Survey Date & Time', 'field' => 'survey_date', 'field_type' => 'datetime-local'],
['header' => 'Measures', 'field' => 'measures', 'field_type' => 'text'],
['header' => 'Status', 'field' => 'status', 'field_type' => 'select', 'options' => ['PENDING SURVEY BOOKING','Pending install', 'Awaiting Upload','Installed','Status', 'Post Survey', 'Booked survey', 'Cancelled', 'Compliance check', 'Completed', 'Design pending', 'On Hold', 'Awaiting Tech Survey']],
['header' => 'Lead Source', 'field' => 'lead_source', 'field_type' => 'text'],
['header' => 'Surveyor', 'field' => 'surveyor', 'field_type' => 'select', 'options' => ['Surveyor', 'David Foggett', 'Steven Thomas', 'Dave Phillips', 'Ian Thomas', 'Kirill']],
['header' => 'INSTALLER', 'field' => 'installer', 'field_type' => 'select', 'options' => ['ZING','Envo Energy', 'UK Energy Save', 'Curtis Anstee', 'INSTALLER']],
['header' => 'FUNDING', 'field' => 'funding', 'field_type' => 'text'],
['header' => 'Notes', 'field' => 'notes', 'field_type' => 'text'],
['header' => 'PO #', 'field' => 'po_number', 'field_type' => 'text'],
['header' => 'Surveyors Notes', 'field' => 'surveyors_notes', 'field_type' => 'text'],
['header' => 'EPC Grade To Start', 'field' => 'epc_level', 'field_type' => 'text'],
['header' => 'Platform', 'field' => 'platform', 'field_type' => 'text'],
['header' => 'Progress', 'field' => 'progress', 'field_type' => 'text'],
['header' => 'Property Type', 'field' => 'property_type', 'field_type' => 'select', 'options' => ['House','Property Type', 'Bungalow', 'detached house', 'Flat', 'End Terrace', 'Maisonette']],
['header' => 'Wall Type', 'field' => 'wall_type', 'field_type' => 'select', 'options' => ['Wall Type','Solid Brick', 'Solid Stone', 'Cavity', 'Other', 'Stone: Granite or Whinstone']],
['header' => 'Detachment', 'field' => 'detachment', 'field_type' => 'select', 'options' => ['Detachment','Detached', 'End-Terrace', 'Semi-Detached', 'Mid-Terrace']],
['header' => 'Number of bedrooms', 'field' => 'no_of_bedrooms', 'field_type' => 'select', 'options' => ['4','Field not available from form', '3','Bedrooms','1', '2' ]],
['header' => 'Heating Source', 'field' => 'heating_source', 'field_type' => 'select', 'options' => ['Heating Source', 'Oil', 'Electric', 'ESH', 'SFF', 'ASHP']],
['header' => 'Book Survey', 'field' => 'book_survey', 'field_type' => 'select', 'options' => ['Book Survey']],
['header' => 'Floorplans', 'field' => 'floorplans', 'field_type' => 'select' , 'options' => ['Floorplans', 'Yes']],
['header' => 'Compliance Officer', 'field' => 'compliance_officer', 'field_type' => 'select', 'options' => ['Compliance Officer']],
['header' => 'Retrofit', 'field' => 'retrofit', 'field_type' => 'select', 'options' => ['Retrofit', 'Yes', 'RA + EPC', 'RA']],
['header' => 'Contribution', 'field' => 'contribution', 'field_type' => 'select', 'options' => ['Contribution']],
['header' => 'Installation Date', 'field' => 'installation_date', 'field_type' => 'select', 'options'=>['Installation Date']],
['header' => 'File EST/LA Flex', 'field' => 'file_est_la_flex', 'field_type' => 'select', 'options' => ['Files EST/LA Flex']],
['header' => 'Data Match', 'field' => 'data_match', 'field_type' => 'select', 'options' => ['Data Match']],
['header' => 'Surveyor Sign Off', 'field' => 'surveyor_sign_off', 'field_type' => 'select', 'options' => ['Surveyor Sign Off']],
['header' => 'Eligibility', 'field' => 'eligibility', 'field_type' => 'select', 'options' => ['Eligibility']],
['header' => 'Qualified', 'field' => 'qualified', 'field_type' => 'select', 'options' => ['Qualified']],
['header' => 'Utility Bill', 'field' => 'utility_bill', 'field_type' => 'select', 'options' => ['Utility Bill']],
['header' => 'Retrofit Assessment', 'field' => 'retrofit_assessment', 'field_type' => 'select', 'options' => ['Retrofit Assessment']],
['header' => 'VOA Check', 'field' => 'voa_check', 'field_type' => 'select', 'options' =>['VOA Check','Yes' ]],
['header' => 'Land Registry', 'field' => 'land_registry', 'field_type' => 'select', 'options' => ['Land Registry','NOT REGISTERED OWNER']],
['header' => 'EST Consent', 'field' => 'est_consent', 'field_type' => 'select', 'options' => ['EST Consent','No']],
['header' => 'Owned or Rented', 'field' => 'owned_or_rented', 'field_type' => 'select', 'options' => ['Owned or Rented','Owner']],
['header' => 'Landlord Consent', 'field' => 'landlord_consent', 'field_type' => 'select', 'options' => ['Landlord Consent']],
['header' => 'Tenancy Agreement', 'field' => 'tenancy_agreement', 'field_type' => 'select', 'options' => ['Tenancy Agreement']],
['header' => 'EPC', 'field' => 'epc', 'field_type' => 'select', 'options' =>['EPC', 'Yes'] ],
['header' => 'DSSY', 'field' => 'dssy', 'field_type' => 'select', 'options' => ['DSSY']],
['header' => 'Planning/Listed Check', 'field' => 'planning_listed_check', 'field_type' => 'select', 'options' => ['Planning/Listed Check', 'Active Planning Application']],
['header' => 'Assignees', 'field' => 'assignees', 'field_type' => 'select', 'options' => ['Assignees','Ryan Anstee', 'hannah bullock', 'Dawn David', 'Caine Curtis','chris jenkins', 'Rob Redshaw', 'Joshua Hamilton', 'Will Hair', 'Tristan', 'adam pearson', 'Hayley Phelan', 'Rob Redshaw', 'Joshua Hamilton', 'adam pearson', 'Hayley Phelan', 'Will Hair', 'adam pearson', 'Hayley Phelan', 'Joshua Hamilton', 'Will Hair', 'Tristan', 'Rob Redshaw', 'Joshua Hamilton', 'Will Hair', 'Hayley Phelan', 'Rob Redshaw', 'adam pearson', 'adam pearson', 'Hayley Phelan', 'Joshua Hamilton', 'Will Hair', 'Rob Redshaw', 'adam pearson', 'Hayley Phelan', 'Joshua Hamilton', 'Will Hair', 'Rob Redshaw', 'Tristan', 'Rob Redshaw', 'Joshua Hamilton', 'Will Hair', 'Tristan', 'adam pearson', 'Hayley Phelan', 'Rob Redshaw', 'Joshua Hamilton', 'Will Hair', 'adam pearson', 'Hayley Phelan', 'Rob Redshaw', 'Joshua Hamilton', 'adam pearson', 'Hayley Phelan', 'Will Hair', 'adam pearson', 'Hayley Phelan', 'Joshua Hamilton', 'Will Hair', 'Tristan', 'Rob Redshaw' ]],
['header' => 'Finishing EPC Grade', 'field' => 'finishing_epc_grade', 'field_type' => 'select', 'options' => ['Finishing EPC Grade']],
['header' => 'RRN #', 'field' => 'rrn_number', 'field_type' => 'select', 'options' => ['RRN #', 'House', 'Bungalow', 'detached house']],
['header' => 'RA Survey Invoiced', 'field' => 'ra_survey_invoiced', 'field_type' => 'text'],
['header' => 'RC Invoiced', 'field' => 'rc_invoiced', 'field_type' => 'text'],
['header' => 'Post Install Inspection', 'field' => 'post_install_inspection', 'field_type' => 'text'],
['header' => 'Pulse Test Pre', 'field' => 'pulse_test_pre', 'field_type' => 'text'],
['header' => 'Pulse Test Post', 'field' => 'pulse_test_post', 'field_type' => 'text'],
['header' => 'EPC Finished', 'field' => 'epc_finished', 'field_type' => 'text'],
],
],
'survey-booked' => [
'status' => [
"Survey Booked" => ['value' => 'survey-booked', 'color' => $this->getStatusColor()['survey-booked']],
'Uploaded Survey' => ['value' => "uploaded-survey", 'color' => $this->getStatusColor()['uploaded-survey']],
"Pre Compliance Check" => ['value' => "pre-compliance-check", 'color' => $this->getStatusColor()['pre-compliance-check']],
],
'fields' => [
['header' => 'Name', 'field' => 'address', 'field_type' => 'text'],
['header' => 'Subitems', 'field' => 'subitems', 'field_type' => 'text'],
['header' => 'Postcode', 'field' => 'postcode', 'field_type' => 'text'],
['header' => 'Request Received', 'field' => 'request_received', 'field_type' => 'date'],
['header' => 'Customers Name', 'field' => 'customers_name', 'field_type' => 'text'],
['header' => 'Contact Number', 'field' => 'contact_number', 'field_type' => 'text'],
['header' => 'Mobile Number', 'field' => 'mobile_number', 'field_type' => 'text'],
['header' => 'Email Address', 'field' => 'email', 'field_type' => 'email'],
['header' => 'Survey Date & Time', 'field' => 'survey_date', 'field_type' => 'datetime-local'],
['header' => 'People', 'field' => 'people', 'field_type' => 'text'],
['header' => 'Measures', 'field' => 'measures', 'field_type' => 'text'],
['header' => 'Status', 'field' => 'status', 'field_type' => 'select', 'options' => ['Status', 'Survey Complete', 'Cancelled', 'Survey Booked', 'Pending Confirmation']],
['header' => 'Lead Source', 'field' => 'lead_source', 'field_type' => 'text'],
['header' => 'Surveyor', 'field' => 'surveyor', 'field_type' => 'select', 'options' => ['Surveyor','Ian Thomas', 'David Fogget', 'Ruairi Walsh', 'Ian Fogget', 'James Illingworth', 'Eveco Solutions', 'Nicky Child', 'Steven Thomas', 'Neil Morris', 'Dave Phillips', 'Matthew Walton', 'Bradley Ray', 'Martin Edge']],
['header' => 'INSTALLER', 'field' => 'installer', 'field_type' => 'select', 'options' => ['INSTALLER', 'Envo Energy', 'Eveco Solutions', 'Baxter Kelly', 'ZING', 'UK Energy Save', 'Curtis Anstee']],
['header' => 'FUNDING', 'field' => 'funding', 'field_type' => 'text'],
['header' => 'Notes', 'field' => 'notes', 'field_type' => 'text'],
['header' => 'PO #', 'field' => 'po_number', 'field_type' => 'select', 'options' => ['PO #','N/A']],
['header' => 'Surveyors Notes', 'field' => 'surveyors_notes', 'field_type' => 'text'],
['header' => 'EPC Grade To Start', 'field' => 'epc_level', 'field_type' => 'select', 'options' => ['EPC Grade To Start','No EPC',' D','E','F']],
['header' => 'Platform', 'field' => 'platform', 'field_type' => 'select', 'options' => ['Platform', 'Elmhurst']],
['header' => 'Progress', 'field' => 'progress', 'field_type' => 'text'],
['header' => 'Property Type', 'field' => 'property_type', 'field_type' => 'select', 'options' => ['Property Type','House', 'Bungalow', 'detached house', 'End Terrace', 'Flat', 'Mid terrace house']],
['header' => 'Wall Type', 'field' => 'wall_type', 'field_type' => 'select', 'options'=>['Wall Type','Solid Brick', 'Solid Stone', 'Cavity', 'Other', 'Stone: Granite or Whinstone', 'Cavity (not known if filled)']],
['header' => 'Detachment', 'field' => 'detachment', 'field_type' => 'select', 'options' => ['Detachment','End-Terrace', 'Detached', 'Semi-Detached', 'Mid-Terrace']],
['header' => 'Number of bedrooms', 'field' => 'no_of_bedrooms', 'field_type' => 'select', 'options' => ['Bedrooms', '3','4' ,'Field not available from form']],
['header' => 'Heating Source', 'field' => 'heating_source', 'field_type' => 'select', 'options' => ['Heating Source', 'Oil','Electric','RDJ']],
['header' => 'Book Survey', 'field' => 'book_survey', 'field_type' => 'text'],
['header' => 'Floorplans', 'field' => 'floorplans', 'field_type' => 'select', 'options' => ['Floorplans', 'Anthony']],
['header' => 'Compliance Officer', 'field' => 'compliance_officer', 'field_type' => 'select', 'options' => ['Compliance Officer', 'daisy adams', 'aimee goodwin', 'Luci Hutt']],
['header' => 'Retrofit', 'field' => 'retrofit', 'field_type' => 'select', 'options' => ['Retrofit','Anthony']],
['header' => 'Contribution', 'field' => 'contribution', 'field_type' => 'text'],
['header' => 'Installation Date', 'field' => 'installation_date', 'field_type' => 'date'],
['header' => 'File EST/LA Flex', 'field' => 'file_est_la_flex', 'field_type' => 'text'],
['header' => 'Data Match', 'field' => 'data_match', 'field_type' => 'select', 'options' => ['Data Match', 'Matched', 'Not Required']],
['header' => 'Surveyor Sign Off', 'field' => 'surveyor_sign_off', 'field_type' => 'text'],
['header' => 'Eligibility', 'field' => 'eligibility', 'field_type' => 'select', 'options' => ['Eligibility','HHCRO EST']],
['header' => 'Qualified', 'field' => 'qualified', 'field_type' => 'select', 'options' => ['Qualified', 'Yes']],
['header' => 'Utility Bill', 'field' => 'utility_bill', 'field_type' => 'select', 'options' => ['Utility Bill','Yes']],
['header' => 'Retrofit Assessment', 'field' => 'retrofit_assessment', 'field_type' => 'select', 'options' => ['Retrofit Assessment','Yes']],
['header' => 'VOA Check', 'field' => 'voa_check', 'field_type' => 'select', 'options' => ['VOA Check','Mixed Use']],
['header' => 'Land Registry', 'field' => 'land_registry', 'field_type' => 'select', 'options' => ['Land Registry','YES']],
['header' => 'EST Consent', 'field' => 'est_consent', 'field_type' => 'select', 'options' => ['EST Consent','Yes']],
['header' => 'Owned or Rented', 'field' => 'owned_or_rented', 'field_type' => 'select', 'options' => ['Owned or Rented', 'Owner']],
['header' => 'Landlord Consent', 'field' => 'landlord_consent', 'field_type' => 'select', 'options' => ['Landlord Consent','N/A']],
['header' => 'Tenancy Agreement', 'field' => 'tenancy_agreement', 'field_type' => 'select', 'options' => ['Tenancy Agreement','N/A']],
['header' => 'EPC', 'field' => 'epc', 'field_type' => 'select', 'options' => ['EPC','Landlord: Mr Phil Thompson']],
['header' => 'DSSY', 'field' => 'dssy', 'field_type' => 'text'],
['header' => 'Planning/Listed Check', 'field' => 'planning_listed_check', 'field_type' => 'text'],
['header' => 'Assignees', 'field' => 'assignees', 'field_type' => 'select', 'options' => ['Assignees', 'Ryan Anstee', 'hannah bullock', 'Dawn David', 'Caine Curtis', 'chris jenkins', 'Adam Humphries', 'Sophie Pryce', '[email protected]', 'Kevin Ormerod']],
['header' => 'Finishing EPC Grade', 'field' => 'finishing_epc_grade', 'field_type' => 'text'],
['header' => 'RRN #', 'field' => 'rrn_number', 'field_type' => 'select', 'options' => ['RRN #', 'House', 'Bungalow', 'detached house']],
],
],
'ra-pre-survey' => [
'status' => [
"Lead Gen Portal" => ['value' => "lead-gen-portal", 'color' => $this->getStatusColor()['lead-gen-portal']],
'Direct Website Leads' => ['value' => "direct-website-leads", 'color' => $this->getStatusColor()['direct-website-leads']],
"Pending" => ['value' => "pending", 'color' => $this->getStatusColor()['pending']],
"Invoiced" => ['value' => "invoiced", 'color' => $this->getStatusColor()['invoiced']],
"Awaiting Customer Response" => ['value' => 'awaiting-customer-response', 'color' => $this->getStatusColor()['awaiting-customer-response']],
],
'fields' => [
['header' => 'Name', 'field' => 'address', 'field_type' => 'text'],
['header' => 'Subitems', 'field' => 'subitems', 'field_type' => 'text'],
['header' => 'Postcode', 'field' => 'postcode', 'field_type' => 'text'],
['header' => 'Request Received', 'field' => 'request_received', 'field_type' => 'date'],
['header' => 'Customers Name', 'field' => 'customers_name', 'field_type' => 'text'],
['header' => 'Contact Number', 'field' => 'contact_number', 'field_type' => 'text'],
['header' => 'Mobile Number', 'field' => 'mobile_number', 'field_type' => 'text'],
['header' => 'Email Address', 'field' => 'email', 'field_type' => 'email'],
['header' => 'Survey Date & Time', 'field' => 'survey_date', 'field_type' => 'datetime-local'],
['header' => 'Measures', 'field' => 'measures', 'field_type' => 'text'],
['header' => 'Status', 'field' => 'status', 'field_type' => 'select', 'options' => ['Status','PENDING SURVEY BOOKING', 'Cancelled', 'New', 'Pending Response', 'Survey Booked', 'On Hold', 'Awaiting Call']],
['header' => 'Lead Source', 'field' => 'lead_source', 'field_type' => 'text'],
['header' => 'Surveyor', 'field' => 'surveyor', 'field_type' => 'select', 'options' => ['Surveyor','Steven Thomas']],
['header' => 'INSTALLER', 'field' => 'installer', 'field_type' => 'select', 'options' => ['INSTALLER','Envo Energy', 'ZING', 'UK Energy Save', 'Curtis Anstee', 'Baxter Kelly', 'Solar & Heating Co']],
['header' => 'FUNDING', 'field' => 'funding', 'field_type' => 'text'],
['header' => 'Notes', 'field' => 'notes', 'field_type' => 'text'],
['header' => 'PO #', 'field' => 'po_number', 'field_type' => 'text'],
['header' => 'Surveyors Notes', 'field' => 'surveyors_notes', 'field_type' => 'text'],
['header' => 'EPC Grade To Start', 'field' => 'epc_level', 'field_type' => 'select', 'options' => ['Valid EPC','No EPC']],
['header' => 'Platform', 'field' => 'platform', 'field_type' => 'text'],
['header' => 'Progress', 'field' => 'progress', 'field_type' => 'text'],
['header' => 'People', 'field' => 'people', 'field_type' => 'text'],
['header' => 'Property Type', 'field' => 'property_type', 'field_type' => 'select', 'options' => ['Property Type', 'House', 'Bungalow', 'detached house', 'End Terrace']],
['header' => 'Wall Type', 'field' => 'wall_type', 'field_type' => 'select', 'options' => ['Wall Type', 'Other', 'Solid Brick', 'Solid Stone', 'Cavity', 'solid stone +one cavity wall(repair)', 'stone and cavity extension', 'solid', 'stone']],
['header' => 'Detachment', 'field' => 'detachment', 'field_type' => 'select', 'options' => ['Detachment', 'End-Terrace', 'Detached', 'Semi-Detached', 'Mid-Terrace']],
['header' => 'Number of bedrooms', 'field' => 'no_of_bedrooms', 'field_type' => 'select', 'options' => ['1700 BUILD', '1','2','3','4']],
['header' => 'Heating Source', 'field' => 'heating_source', 'field_type' => 'select', 'options' => ['Heating Source', 'Electric', 'Oil', 'Solid Fuel (e.g coal)', 'No Heating', 'LPG', 'Oil - non condensing', 'Oil', 'no epc/ 21 years old boiler', 'solid fuel', 'GAS']],
['header' => 'Book Survey', 'field' => 'book_survey', 'field_type' => 'text'],
['header' => 'Floorplans', 'field' => 'floorplans', 'field_type' => 'text'],
['header' => 'Compliance Officer', 'field' => 'compliance_officer', 'field_type' => 'text'],
['header' => 'Retrofit', 'field' => 'retrofit', 'field_type' => 'text'],
['header' => 'Contribution', 'field' => 'contribution', 'field_type' => 'text'],
['header' => 'Installation Date', 'field' => 'installation_date', 'field_type' => 'date'],
['header' => 'File EST/LA Flex', 'field' => 'file_est_la_flex', 'field_type' => 'text'],
['header' => 'Data Match', 'field' => 'data_match', 'field_type' => 'text'],
['header' => 'Surveyor Sign Off', 'field' => 'surveyor_sign_off', 'field_type' => 'text'],
['header' => 'Eligibility', 'field' => 'eligibility', 'field_type' => 'select', 'options' => ['Eligibility','LA Flex']],
['header' => 'Qualified', 'field' => 'qualified', 'field_type' => 'select', 'options' => ['Qualified','Not Sent']],
['header' => 'Utility Bill', 'field' => 'utility_bill', 'field_type' => 'text'],
['header' => 'Retrofit Assessment', 'field' => 'retrofit_assessment', 'field_type' => 'text'],
['header' => 'VOA Check', 'field' => 'voa_check', 'field_type' => 'text'],
['header' => 'Land Registry', 'field' => 'land_registry', 'field_type' => 'text'],
['header' => 'EST Consent', 'field' => 'est_consent', 'field_type' => 'text'],
['header' => 'Owned or Rented', 'field' => 'owned_or_rented', 'field_type' => 'select', 'options' => ['Owned or Rented', 'Owner']],
['header' => 'Landlord Consent', 'field' => 'landlord_consent', 'field_type' => 'text'],
['header' => 'Tenancy Agreement', 'field' => 'tenancy_agreement', 'field_type' => 'text'],
['header' => 'EPC', 'field' => 'epc', 'field_type' => 'text'],
['header' => 'DSSY', 'field' => 'dssy', 'field_type' => 'text'],
['header' => 'Planning/Listed Check', 'field' => 'planning_listed_check', 'field_type' => 'text'],
['header' => 'Assignees', 'field' => 'assignees', 'field_type' => 'select', 'options' => ['Assignees', 'chris jenkins', 'Ryan Anstee', 'hannah bullock', 'Dawn David', 'Caine Curtis']],
['header' => 'Finishing EPC Grade', 'field' => 'finishing_epc_grade', 'field_type' => 'text'],
['header' => 'RRN #', 'field' => 'rrn_number', 'field_type' => 'select', 'options' => ['RRN #', 'House', 'Bungalow', 'detached house']]
],
],
'compliance-board' => [
'status' => [
"Uploading To System" => ['value' => "uploading-to-system", 'color' => $this->getStatusColor()['uploading-to-system']],
"Signed Off & Ready For Compliance" => ['value' => 'ready-for-compliance', 'color' => $this->getStatusColor()['ready-for-compliance']],
"Actions Required" => ['value' => 'actions-required', 'color' => $this->getStatusColor()['actions-required']],
"Compliance Completed Except Missing Docs" => ['value' => 'compliance-completed-missing-docs', 'color' => $this->getStatusColor()['compliance-completed-missing-docs']],
'Flex Application' => ['value' => "flex-application", 'color' => $this->getStatusColor()['flex-application']],
"Compliance Completed Including All Docs" => ['value' => "compliance-completed", 'color' => $this->getStatusColor()['compliance-completed']],
"To Be Dealt With" => ['value' => "to-be-dealt-with", 'color' => $this->getStatusColor()['to-be-dealt-with']],
],
'fields' => [
['header' => 'Name', 'field' => 'address', 'field_type' => 'text'],
['header' => 'Subitems', 'field' => 'subitems', 'field_type' => 'text'],
['header' => 'Postcode', 'field' => 'postcode', 'field_type' => 'text'],
['header' => 'Request Received', 'field' => 'request_received', 'field_type' => 'date'],
['header' => 'Customers Name', 'field' => 'customers_name', 'field_type' => 'text'],
['header' => 'Contact Number', 'field' => 'contact_number', 'field_type' => 'text'],
['header' => 'Mobile Number', 'field' => 'mobile_number', 'field_type' => 'text'],
['header' => 'Email Address', 'field' => 'email', 'field_type' => 'email'],
['header' => 'Survey Date & Time', 'field' => 'survey_date', 'field_type' => 'datetime-local'],
['header' => 'Measures', 'field' => 'measures', 'field_type' => 'text'],
['header' => 'Status', 'field' => 'status', 'field_type' => 'text'],
['header' => 'Lead Source', 'field' => 'lead_source', 'field_type' => 'text'],
['header' => 'Surveyor', 'field' => 'surveyor', 'field_type' => 'text'],
['header' => 'INSTALLER', 'field' => 'installer', 'field_type' => 'text'],
['header' => 'FUNDING', 'field' => 'funding', 'field_type' => 'text'],
['header' => 'Notes', 'field' => 'notes', 'field_type' => 'text'],
['header' => 'PO #', 'field' => 'po_number', 'field_type' => 'text'],
['header' => 'Surveyors Notes', 'field' => 'surveyors_notes', 'field_type' => 'text'],
['header' => 'EPC Grade To Start', 'field' => 'epc_level', 'field_type' => 'text'],
['header' => 'Platform', 'field' => 'platform', 'field_type' => 'text'],
['header' => 'Progress', 'field' => 'progress', 'field_type' => 'text'],
['header' => 'Property Type', 'field' => 'property_type', 'field_type' => 'text'],
['header' => 'Wall Type', 'field' => 'wall_type', 'field_type' => 'text'],
['header' => 'Detachment', 'field' => 'detachment', 'field_type' => 'text'],
['header' => 'Number of bedrooms', 'field' => 'no_of_bedrooms', 'field_type' => 'number'],
['header' => 'Heating Source', 'field' => 'heating_source', 'field_type' => 'text'],
['header' => 'Book Survey', 'field' => 'book_survey', 'field_type' => 'text'],
['header' => 'Floorplans', 'field' => 'floorplans', 'field_type' => 'text'],
['header' => 'Compliance Officer', 'field' => 'compliance_officer', 'field_type' => 'text'],
['header' => 'Retrofit', 'field' => 'retrofit', 'field_type' => 'text'],
['header' => 'Contribution', 'field' => 'contribution', 'field_type' => 'text'],
['header' => 'Installation Date', 'field' => 'installation_date', 'field_type' => 'date'],
['header' => 'File EST/LA Flex', 'field' => 'file_est_la_flex', 'field_type' => 'text'],
['header' => 'People', 'field' => 'people', 'field_type' => 'text'],
['header' => 'Data Match', 'field' => 'data_match', 'field_type' => 'text'],
['header' => 'Surveyor Sign Off', 'field' => 'surveyor_sign_off', 'field_type' => 'text'],
['header' => 'Eligibility', 'field' => 'eligibility', 'field_type' => 'text'],
['header' => 'Qualified', 'field' => 'qualified', 'field_type' => 'text'],
['header' => 'Utility Bill', 'field' => 'utility_bill', 'field_type' => 'text'],
['header' => 'Retrofit Assessment', 'field' => 'retrofit_assessment', 'field_type' => 'text'],
['header' => 'VOA Check', 'field' => 'voa_check', 'field_type' => 'text'],
['header' => 'Land Registry', 'field' => 'land_registry', 'field_type' => 'text'],
['header' => 'EST Consent', 'field' => 'est_consent', 'field_type' => 'text'],
['header' => 'Owned or Rented', 'field' => 'owned_or_rented', 'field_type' => 'text'],
['header' => 'Landlord Consent', 'field' => 'landlord_consent', 'field_type' => 'text'],
['header' => 'Tenancy Agreement', 'field' => 'tenancy_agreement', 'field_type' => 'text'],
['header' => 'EPC', 'field' => 'epc', 'field_type' => 'text'],
['header' => 'DSSY', 'field' => 'dssy', 'field_type' => 'text'],
['header' => 'Planning/Listed Check', 'field' => 'planning_listed_check', 'field_type' => 'text'],
['header' => 'Assignees', 'field' => 'assignees', 'field_type' => 'text'],
['header' => 'Finishing EPC Grade', 'field' => 'finishing_epc_grade', 'field_type' => 'text'],
['header' => 'RRN #', 'field' => 'rrn_number', 'field_type' => 'text'],
['header' => 'RA Invoiced', 'field' => 'ra_invoiced', 'field_type' => 'text'],
['header' => 'Pulse Test Pre', 'field' => 'pulse_test_pre', 'field_type' => 'text'],
['header' => 'RA Survey', 'field' => 'ra_survey', 'field_type' => 'text'],
],
],
'post-compliance-board' => [
'status' => [
"Post Compliance" => ['value' => "post-compliance", 'color' => $this->getStatusColor()['post-compliance']],
"ESW" => ['value' => 'esw', 'color' => $this->getStatusColor()['esw']],
"Solar and Heating Co Ltd" => ['value' => 'solar-heating-co-ltd', 'color' => $this->getStatusColor()['solar-heating-co-ltd']],
'GRS Insulation' => ['value' => "grs-insulation", 'color' => $this->getStatusColor()['grs-insulation']],
"Wizard Eco" => ['value' => "wizard-eco", 'color' => $this->getStatusColor()['wizard-eco']],
"LMF" => ['value' => "lmf", 'color' => $this->getStatusColor()['lmf']],
"DK Hughes" => ['value' => 'dk-hughes', 'color' => $this->getStatusColor()['dk-hughes']],
"Eco4 Cheltenham" => ['value' => 'eco4-cheltenham', 'color' => $this->getStatusColor()['eco4-cheltenham']],
"Baxter Kelly" => ['value' => 'baxter-kelly', 'color' => $this->getStatusColor()['baxter-kelly']],
"Zing Energy" => ['value' => 'zing-energy', 'color' => $this->getStatusColor()['zing-energy']],
"ECO4 Renewable Heating" => ['value' => 'eco4-renewable-heating', 'color' => $this->getStatusColor()['eco4-renewable-heating']],
"Unused" => ['value' => 'unused', 'color' => $this->getStatusColor()['unused']],
"Installs Booked" => ['value' => 'installs-booked', 'color' => $this->getStatusColor()['installs-booked']],
"Invoice To Be Raised" => ['value' => 'invoice-to-be-raised', 'color' => $this->getStatusColor()['invoice-to-be-raised']],
"Awaiting Cancellation Sign Off" => ['value' => 'awaiting-cancellation-sign-off', 'color' => $this->getStatusColor()['awaiting-cancellation-sign-off']],
"Cancellation List To Be Invoiced" => ['value' => 'cancellation-list-to-be-invoiced', 'color' => $this->getStatusColor()['cancellation-list-to-be-invoiced']],
"Pending Payment, Invoice Raised" => ['value' => 'pending-payment-invoice-raised', 'color' => $this->getStatusColor()['pending-payment-invoice-raised']],
"Paid" => ['value' => 'paid', 'color' => $this->getStatusColor()['paid']],
"Stevens Due Diligence" => ['value' => 'stevens-due-diligence', 'color' => $this->getStatusColor()['stevens-due-diligence']],
"Confirm Cancelled" => ['value' => 'confirm-cancelled', 'color' => $this->getStatusColor()['confirm-cancelled']],
"Finished And Closed" => ['value' => 'finished-and-closed', 'color' => $this->getStatusColor()['finished-and-closed']],
],
'fields' => [
['header' => 'Name', 'field' => 'address', 'field_type' => 'text'],
['header' => 'Subitems', 'field' => 'subitems', 'field_type' => 'select', 'options' => ['Sureyor Paid', 'No Charge', 'Disputed'] ],
['header' => 'Postcode', 'field' => 'postcode', 'field_type' => 'text'],
['header' => 'Request Received', 'field' => 'request_received', 'field_type' => 'date'],
['header' => 'Customers Name', 'field' => 'customers_name', 'field_type' => 'text'],
['header' => 'Contact Number', 'field' => 'contact_number', 'field_type' => 'text'],
['header' => 'Mobile Number', 'field' => 'mobile_number', 'field_type' => 'text'],
['header' => 'Email Address', 'field' => 'email', 'field_type' => 'email'],
['header' => 'Survey Date & Time', 'field' => 'survey_date', 'field_type' => 'datetime-local'],
['header' => 'Measures', 'field' => 'measures', 'field_type' => 'text'],
['header' => 'Status', 'field' => 'status', 'field_type' => 'select', 'options' =>['Survey Complete', 'Status', 'Survey Booked', 'Cancelled', 'Invoice To Be Raised', 'Pre Instructed Coordination', 'PENDING SURVEY BOOKING', 'Passed To Installer', 'Compliance Complete', 'Steven’s Due Dilligence', 'RC Instructed', 'PAID', 'Finalised', 'Pending Payment', 'Install Booked' ]],
['header' => 'Lead Source', 'field' => 'lead_source', 'field_type' => 'text'],
['header' => 'Surveyor', 'field' => 'surveyor', 'field_type' => 'select', 'options' => ['Steven Thomas', 'Lee Robinson', 'James Illingworth', 'Syed Shah', 'Luci Hutt', 'Surveyor', 'Ruari Walsh', 'Mark Atkinson', 'Matt Boston', 'Dave Phillips', 'Steve Thomas', 'Ian Thomas', 'Nicholas Thomas', 'Kingley Rose', 'Neil Morris', 'Bradley Ray', 'Matthew Walton', 'Ethan Ball', 'Luke Ball', ' Dave Phillips', 'Steve Thomas', 'Robert Gammon', 'Martin Edge', 'Paul Eastwood', 'Ian Thomas', 'David Foggett', 'Claire Farr' ] ],
['header' => 'INSTALLER', 'field' => 'installer', 'field_type' => 'select', 'options' => [ 'ZING', 'BidConnector', 'Meg', 'Zenith Eco Solutions', 'Envo Energy', 'ESW', 'Wizard Eco', 'Zennith', 'UK Energy Save', '0800Repair', 'LMF/SES', 'GRS Insullation', 'EDF', 'Curtis Anstee', 'BidConnector Portal', 'SmartEnergy', 'DK Hughes', 'INSTALLER', 'K2 Eco', 'GRS', 'Eco4 Cheltenham', 'Baxter Kelly', 'Monza Installs', 'Solar & Heating Co', 'ARPG' ] ],
['header' => 'FUNDING', 'field' => 'funding', 'field_type' => 'text'],
['header' => 'Notes', 'field' => 'notes', 'field_type' => 'text'],
['header' => 'PO #', 'field' => 'po_number', 'field_type' => 'select', 'options' => [ 'N/A', 'PO#', 'Missing', 'Others', 'Mike Middleton', 'BIDCPO1608', 'ESH currently', 'BIDCPO1558', 'Pending', 'Ian Thomas', 'BIDCPO1616', 'BIDCPO1853', 'BIDCPO1860', 'BIDCPO1868', 'BIDCPO1801', 'BIDCPO1854', 'BIDCPO1799', 'BIDCPO1872', 'BIDCPO1788', 'BIDCPO1841', 'BIDCPO1861', 'BIDCPO1871', 'BIDCPO1839', 'Landlord Mr David Waters 0771615680', 'PLEASE PHONE LANDLORD TO ARRANGE SURVEY AS HE LIVES NEAR BY', 'SURVEY BOOKED 08/09/22 BY STEVEN', 'LPG Bottles', 'Landlord:Jennifer Edmonds 1548821358', 'BEN Davis Lead', 'John Fairclough', 'Alan King', 'Oil Boiler is over 20 years old']],
['header' => 'Surveyors Notes', 'field' => 'surveyors_notes', 'field_type' => 'text'],
['header' => 'EPC Grade To Start', 'field' => 'epc_level', 'field_type' => 'select', 'options' => ['No EPC', 'E', 'EPC Grade To Start', 'F', '1st Download', 'D', 'G', 'Others', 'Unregistered','Low E', 'EPC F', 'EPC D', '2nd Download', 'No EPC on property', 'ECO3T', 'E51', 'C', 'low D', 'High D', 'High E', 'N/A', 'CoreLogic', 'Check Invoice', 'F 38', 'E 39', 'B', 'NO EPC surrounding properties D grades', 'NO EPC (D-F ratings)', 'No EPC’s for postcode', 'NO EPC (E-F ratings)', 'E 46', 'E 47' ] ],
['header' => 'Platform', 'field' => 'platform', 'field_type' => 'select', 'options' => ['Elmhurst', 'Platform', 'CoreLogic', 'Jaffersons', 'Mel',' N/A', 'P - ST', 'NO EPC', 'Pashub', 'Pashub/Elmhurst', 'Elmhurst & Pashub', 'Elmhurst/Pashub', 'Ecosurv', 'Elmhurst/Ecosurv', ]],
['header' => 'Progress', 'field' => 'progress', 'field_type' => 'text'],
['header' => 'People', 'field' => 'people', 'field_type' => 'text'],
['header' => 'Property Type', 'field' => 'property_type', 'field_type' => 'select', 'options' => ['Property Type', 'House', 'Bungalow', 'Detached House', 'End Terrace', 'Flat', 'Mid Terrace House', 'Maisonnette', 'End Terrace House 2BD', 'End Terrace House', 'Semi Detached', 'Park Home', 'Ground Floor Flat', '3 Bed Demi Detached. Built in 1940', 'Semi Detached House', 'Detached', 'Detached Bungalow 3BD', 'Mid Terrace', 'Mid Terraced', 'End Terraced', '2 bed Semi', '3 bed detached house', '2 bed semi detached bungalows Built 1950’s', 'Detached Bungalow' ]],
['header' => 'Wall Type', 'field' => 'wall_type', 'field_type' => 'select', 'options' => ['Solid Brick', 'Solid Stone', 'Cavity', 'Wall Type', 'Other', 'Stone: Granite or WhinStone', 'Cavity (not known if filled)', 'Stone: SandStone or LimeStone', 'Don’t Know', 'Cavity Wall', 'Solid Wall(concrete, stone)', 'Timber Frame', 'Brick Cavity (not filled)', 'Brick Solid', 'Brick Cavity(Filled)', 'System Build', 'Solid Wall', 'Cob', 'SW', 'CW' ]],
['header' => 'Detachment', 'field' => 'detachment', 'field_type' => 'select', 'options' => ['End-Terrace', 'Detached', 'Semi-Detached', 'Detachment', 'Mid-Terrace', 'Mid-Terraced', 'End Terraced', 'Enclose End Terrace', 'Semi-Detached House','Enclosed Mid-Terrace']],
['header' => 'Number of bedrooms', 'field' => 'no_of_bedrooms', 'field_type' => 'number'],
['header' => 'Heating Source', 'field' => 'heating_source', 'field_type' => 'select', 'options' => ['Oil', 'Gas boiler', 'ESH', 'ASHP', 'Solid Fuel', 'Fan Storage Heaters', 'Electric', 'Bulk LPG', 'Gas', 'Oil Storage Heaters', 'Heating Source', 'LPG', 'NONE', 'Central Heating', 'Oil boiler', 'Bottled LPG', 'Wood Burner', 'RDJ', 'Others', 'ERH', 'No Heating','Electric boiler', 'Modern Slimeline ESH', 'Main Gas', 'Gas fire', 'Solid Fuel (e.g coal)', 'LPG boiler', 'Condensing Combi Boiler', 'Electric Room Heaters', 'Mains Gas', 'Electric Storage Heaters', 'Electric Boiler']],
['header' => 'Book Survey', 'field' => 'book_survey', 'field_type' => 'text'],
['header' => 'Floorplans', 'field' => 'floorplans', 'field_type' => 'select', 'options' => ['Anthony', 'Lee', 'Ian', 'Aaron', 'Marc', 'IT', 'Andy', 'Floorplans', 'Ruairi', 'Bethan', 'Luci - paid', 'Mark', 'Claire', 'Dave', 'Callum', 'Jafferson', 'Yes', 'Chad', 'Peter', 'DAN', 'SYED', 'N/A', 'Kingley', 'Kevin', 'CB', 'Bradley', 'CW', 'Luci', 'ROB', 'ST', 'OTHERS', 'Neil', 'Paul', 'Steve', 'Peter', 'Rob', '174'] ],
['header' => 'Compliance Officer', 'field' => 'compliance_officer', 'field_type' => 'select', 'options' => [ 'Luci Hutt', 'Aimee Goodwin', 'Compliance Officer', 'Daisy Adams', 'Aimee Goodwin', 'Daisy Adams', 'Lola Johnson', 'Luci Hutt', 'Luci Hutt', 'Daisy Adams', 'Aimee Goodwin', 'Daisy Adams' ]],
['header' => 'Retrofit', 'field' => 'retrofit', 'field_type' => 'select', 'options' => ['Anthony', 'Lee', 'Ian', 'Eco4', 'Rob - paid', 'CB', 'Lee', 'Retrofit', 'Ruairi', 'Rob', 'ECO4 Scheme', 'Andy', 'Kirills', 'Dave', 'Callum', 'Jafferson', 'Kingley', 'Chad', 'Claire', 'Ian', 'SYED', 'Steve', 'Kevin', 'DAN', 'Bradley', 'CW', 'N/A', 'PETER', 'ST', 'Neil', 'Paul', 'Aaron', 'MARC', 'IT', 'MATT']],
['header' => 'Contribution', 'field' => 'contribution', 'field_type' => 'select', 'options'=>['#23770', '£625.00', '£2184.48', '#36145', 'Contribution', '£2400 inc', '£3,215.52', 'Yes', '£1800.00', '#38577', '#38957', 'N/A', '£1900 inc', '#39362', '#39339', '£275.00/ £595.00k(IWI)', '2,200', '#32958', '#37613', '£0', '£1,503.74', '#10694', 'TBC']],
['header' => 'Installation Date', 'field' => 'installation_date', 'field_type' => 'select', 'options' => ['29/06/2021', 'NCHA66', '03/06/2021', '22/03/2021', '25/03/2021', '02/23/2022','Installation Date',' NCHA49', '15/06/2021', '08/04/2021', '03/03/2022', '27/04/2021', 'NCHA61', '04/06/2021', '28/06/2021(IWI)|' , '28/06/2021', '26/02/2022', 'June', 'NCHA54', '27/04/2021 (IWI) | ', '10/05/2021 (IWI) |', '22/06/2021', 'NCHA42', 'NCHA63', ' NCHA52', '10/06/2021 (LOFT) | 29/06/2021 (CWI)', '10/06/2021', 'NCHA33', 'TBC', '25/06/2021', '15TH MARCH', '18/03/2021', '11/06/2021', '19/01/2022', '01/30/1967 00.00.00' ]],
['header' => 'File EST/LA Flex', 'field' => 'file_est_la_flex', 'field_type' => 'text'],
['header' => 'Data Match', 'field' => 'data_match', 'field_type' => 'select', 'options' =>['Matched', 'Data Match', 'Not Required', 'Sent', 'Unmatched', 'Unverified' ] ],
['header' => 'Surveyor Sign Off', 'field' => 'surveyor_sign_off', 'field_type' => 'select', 'options' => ['Done', 'Surveyor Signoff']],
['header' => 'Eligibility', 'field' => 'eligibility', 'field_type' => 'select', 'options'=>[
'HHCRO EST', 'LA Flex', 'Child Benefit', 'Pension Credit', 'Carer’s Allowance', 'Personal Independence Payment',
'Disability Living Allowance','Income Based Job Seekers Allowance',
'Eligibility','Personal Independence Payment', 'Attendance Allowance',
'Tax Credits( Child Tax Credits and Working Tax Credit’)', 'DLA',
'Tax Credits( Child Tax Credits and Working Tax Credit’)', 'Universal Credit',
'Tax Credits( Child Tax Credits and Working Tax Credit’)', 'Universal Credit', 'Carer’s Allowance', 'Child Benefit',
'Disability Living Allowance,Personal Independence Payment', 'HHCRO Docs',
'Income-related Employment and Support Allowance',
'Tax Credits( Child Tax Credits, Working Tax Credit )', 'Universal Credit', 'Income Support',
'Tax Credits( Child Tax Credits and Working Tax Credit)', 'Universal Credit', 'Carer’s Allowance', 'Personal Independence Payment', 'Disability Living Allowance','Child Benefit',
'HOUSING BENEFIT', 'Income related Employment and Support Allowance', 'Personal Independence Payment', 'Infill', 'Child Benefit', 'Tax Credits( Child Tax Credits and Working Tax Credit)', 'Universal Credit',
'Income based job seeker Allowance', 'Disability Living Allowance', 'Universal Credit', 'Personal Independence Payment', 'Income related Employment and Support Allowance',
'Carer’s Allowance', 'Disability Living Allowance', 'Child Benefit', 'Tax Credits( Child Tax Credits and Working Tax Credit) Universal Credit',
'Guaranteed pension credits','Child Tax Credits'
]],
['header' => 'Qualified', 'field' => 'qualified', 'field_type' => 'select', 'options' => [ 'Yes', 'No', 'Qualified', 'Awaiting Result', 'Not Required' ]],
['header' => 'Utility Bill', 'field' => 'utility_bill', 'field_type' => 'select', 'options' => ['Yes', 'No', 'N/A', 'Utility Bill']],
['header' => 'Retrofit Assessment', 'field' => 'retrofit_assessment', 'field_type' => 'select', 'options' => ['Yes', 'No', 'N/A','Retrofit Assesment']],
['header' => 'VOA Check', 'field' => 'voa_check', 'field_type' => 'select', 'options' => ['VOA Checks','Yes', 'No', 'Mixed Use', 'Not on VOA','Not needed']],
['header' => 'Land Registry', 'field' => 'land_registry', 'field_type' => 'select', 'options' => ['Land Registry', 'Yes', 'No', 'N/A']],
['header' => 'EST Consent', 'field' => 'est_consent', 'field_type' => 'select', 'options' => ['Yes', 'No', 'N/A', 'EST Consent']],
['header' => 'Owned or Rented', 'field' => 'owned_or_rented', 'field_type' => 'select', 'options' => ['Owned or Rented', 'Owner', 'Rental', 'Owned Occupier', 'Home owner', 'Private Tenant', 'Social Housing' ]],
['header' => 'Landlord Consent', 'field' => 'landlord_consent', 'field_type' => 'select', 'options' => ['Land Lord Consent', 'Yes', 'No', 'N/A']],
['header' => 'Tenancy Agreement', 'field' => 'tenancy_agreement', 'field_type' => 'select', 'options' => ['Tenancy Agreement', 'Yes', 'No', 'N/A']],
['header' => 'EPC', 'field' => 'epc', 'field_type' => 'select', 'options' => ['Landlord: Mr Phil thompson','EPC', 'Yes', 'No', 'N/A', 'No EPC', 'Unknown', 'NO EPC ON PROPERTY', 'E 39', 'E 52', 'F 26', 'F 30', 'E 46', 'E 44', 'F 24', 'F 25', 'E 48', 'E 41' ]],
['header' => 'DSSY', 'field' => 'dssy', 'field_type' => 'text'],
['header' => 'Planning/Listed Check', 'field' => 'planning_listed_check', 'field_type' => 'select', 'options' => ['Yes', 'Active Planning Application', 'Planning/Listed Check', 'Article 4', 'Conservation area', 'Area of Natural Beauty', 'Listed Building', 'World Heritage Site', 'No', 'Previous planning', 'Not Needed']],
['header' => 'Assignees', 'field' => 'assignees', 'field_type' => 'select', 'options' => ['Ryan Anstee', 'hannah bullock', 'Dawn David', 'Caine Curtis', 'Luci Hutt', 'Andrew Richards', 'Hannah', 'Others', 'chris jenkins', 'Adam Humphries', 'Ben Davis', 'Sophie Pryce', '[email protected]', 'Kathryn Llanelly', 'Jessica Cimetta', 'carl jenkins', 'Carlo Bonomini', 'Sophie Wells', 'Ruscha Kotschi', 'Jessica-Louise caswell', 'Hitendra Thakur', 'Adam Brown', 'Assignees', 'Kevin Ormerod', 'Roxanne', 'Corine']],
['header' => 'Finishing EPC Grade', 'field' => 'finishing_epc_grade', 'field_type' => 'select', 'options' => ['A', 'c', 'Finishing EPC Grade', 'B', 'NO EPC', 'E', 'C', 'D', 'F', 'G', 'N/A']],
['header' => 'RRN #', 'field' => 'rrn_number', 'field_type' => 'select', 'options' => ['3437-2327-3200-0387-4296','RRN #', '6900-6146-0322-7200-3873', '7600-1420-0422-3222-3573', 'House', '1900-8095-0422-5201-3873', '9708-3029-3208-4297-2200', 'Bungalow', '4451-5931-9421-9922-5783', '2591-1112-6013-9236-3731', '2333-3024-9202-1407-2200', 'detached house', 'NO EPC', '8637-5228-4200-0421-9202', 'N/A', 'Customer wants IWI, ESH or ASHP and Solar PV', '3237-6823-7200-0205-8226', 'Park Home', 'Flat', '7091-3029-8203-5487-0200', '9765-3931-4200-0707-2204']],
['header' => 'RA Survey', 'field' => 'ra_survey', 'field_type' => 'text'],
['header' => 'RC Invoiced', 'field' => 'rc_invoiced', 'field_type' => 'text'],
['header' => 'Post Install Inspection', 'field' => 'post_install_inspection', 'field_type' => 'text'],
['header' => 'Pulse Test Pre', 'field' => 'pulse_test_pre', 'field_type' => 'text'],
['header' => 'Pulse Test Post', 'field' => 'pulse_test_post', 'field_type' => 'text'],
['header' => 'EPC Finished', 'field' => 'epc_finished', 'field_type' => 'text'],
['header' => 'Lodgement fee', 'field' => 'lodgement_fee', 'field_type' => 'decimal'],
['header' => 'Cancelled Invoiced', 'field' => 'cancelled_invoiced', 'field_type' => 'text'],
],
],
'coordination-board' => [
'status' => [
"Pre Installed Coordination" => ['value' => "pre-installed-coordination", 'color' => $this->getStatusColor()['pre-installed-coordination']],
"RC Instructed Coordination" => ['value' => 'rc-instructed-coordination', 'color' => $this->getStatusColor()['rc-instructed-coordination']],
"Awaiting Traditional Sign Off" => ['value' => 'awaiting-traditional-sign-off', 'color' => $this->getStatusColor()['awaiting-traditional-sign-off']],
"RC Passed To Install" => ['value' => 'rc-passed-to-install', 'color' => $this->getStatusColor()['rc-passed-to-install']],
"Install Booked" => ['value' => 'install-booked', 'color' => $this->getStatusColor()['install-booked']],
"Awaiting Remedials For Lodgement" => ['value' => 'awaiting-remedials-for-lodgement', 'color' => $this->getStatusColor()['awaiting-remedials-for-lodgement']],
"RC To Lodge" => ['value' => 'rc-to-lodge', 'color' => $this->getStatusColor()['rc-to-lodge']],
"RC Lodged" => ['value' => 'rc-lodged', 'color' => $this->getStatusColor()['rc-lodged']],
"RC Invoiced And Paid" => ['value' => 'rc-invoiced-and-paid', 'color' => $this->getStatusColor()['rc-invoiced-and-paid']],
"Cancelled" => ['value' => 'cancelled', 'color' => $this->getStatusColor()['cancelled']],
],
'fields' => [
['header' => 'Name', 'field' => 'address', 'field_type' => 'text'],
['header' => 'Subitems', 'field' => 'subitems', 'field_type' => 'text'],
['header' => 'Postcode', 'field' => 'postcode', 'field_type' => 'text'],
['header' => 'Request Received', 'field' => 'request_received', 'field_type' => 'date'],
['header' => 'Customers Name', 'field' => 'customers_name', 'field_type' => 'text'],
['header' => 'Contact Number', 'field' => 'contact_number', 'field_type' => 'text'],
['header' => 'Mobile Number', 'field' => 'mobile_number', 'field_type' => 'text'],
['header' => 'Email Address', 'field' => 'email', 'field_type' => 'email'],
['header' => 'Survey Date & Time', 'field' => 'survey_date', 'field_type' => 'datetime-local'],
['header' => 'Measures', 'field' => 'measures', 'field_type' => 'text'],
['header' => 'Status', 'field' => 'status', 'field_type' => 'select', 'options' => ['SURVEY COMPLETE', 'ALL COMPLETED', 'SURVEY BOOKED', 'PRE INSTRUCTED COORDINATION', 'PASSED TO INSTALLER', 'INSTALL BOOKED', 'RC LODGEMENT REQUIRED', 'RC LODGEMENT COMPLETE', 'CANCELLED']],
['header' => 'Lead Source', 'field' => 'lead_source', 'field_type' => 'text'],
['header' => 'Surveyor', 'field' => 'surveyor', 'field_type' => 'text'],
['header' => 'INSTALLER', 'field' => 'installer', 'field_type' => 'select', 'options' => ['INSTALLER', 'ZING', 'CURTIS ANSTEE', 'UK ENRGY SAVE', 'ENVO ENERGY', 'GRS', 'ECO4 SCHEME']],
['header' => 'FUNDING', 'field' => 'funding', 'field_type' => 'text'],
['header' => 'Notes', 'field' => 'notes', 'field_type' => 'text'],
['header' => 'PO #', 'field' => 'po_number', 'field_type' => 'text'],
['header' => 'Surveyors Notes', 'field' => 'surveyors_notes', 'field_type' => 'text'],
['header' => 'EPC Grade To Start', 'field' => 'epc_level', 'field_type' => 'select', 'options' => [ 'NO EPC', 'D', 'D (EXPIRED)', 'E47', 'E', 'N/A', 'NO EPC', 'EPC GRADE TO START', 'EXPIRED 2018', 'LOW E BUT PROB E AS OLD EPC', 'F', 'F 23', 'D 57 BUT HOUSE NOW HAS ERH NOT ESH SO', 'EPC RATING WOULD BE LOWER', 'SECOND DOWNLOAD', 'THEY WILL QUALIFY VIA FLEX AS THEY HAD CWI INSTALLED IN ECO3 VIA FLEX', 'SCHEME', 'NO EPC ON PROPERTY', 'EXPIRED', 'E53' ]],
['header' => 'Platform', 'field' => 'platform', 'field_type' => 'select', 'options' => ['PLATFORM', 'ELMHURST', 'DROPBOX', 'PASHUB' ]],
['header' => 'Progress', 'field' => 'progress', 'field_type' => 'text'],
['header' => 'Property Type', 'field' => 'property_type', 'field_type' => 'text'],
['header' => 'Wall Type', 'field' => 'wall_type', 'field_type' => 'select', 'options' => [ 'SOLID BRICK', 'SOLID STONE', 'CAVITY', 'WALL TYPE', 'OTHER', 'STONE (GRANITE OR WHINTONE )','CAVITY ( NOT KNOWN IF FILLED)', 'SYSTEM BUILD', 'COB' ]],
['header' => 'Detachment', 'field' => 'detachment', 'field_type' => 'select', 'options' => [ 'END-TERRACE', 'DETACHED', 'SEMI-DETACHED', 'DETACHMENT', 'MID-TERRACE', 'ENCLOSED END TERRACE', ]],
['header' => 'Number of bedrooms', 'field' => 'no_of_bedrooms', 'field_type' => 'number'],
['header' => 'Heating Source', 'field' => 'heating_source', 'field_type' => 'select', 'options' => [ 'OIL', 'ELECTRIC', 'HEATING SOURCE', 'RDJ', 'MAINS GAS', 'GAS', 'GAS BOILER', 'SOLID FUEL FIRE', 'RCJ', 'RGF FIRE', 'ESH', 'ERH', 'GAS FIRE', 'GAS ROOM HEATERS', 'LPGGAS NO HEATING', 'BULK LPG' ]],
['header' => 'Book Survey', 'field' => 'book_survey', 'field_type' => 'text'],
['header' => 'Floorplans', 'field' => 'floorplans', 'field_type' => 'select', 'options' => [ 'ANTHONY', 'FLOOR PLANS', 'BETHAN', 'N/A', 'DAVE', 'PAUL', 'LEE', 'IAN', 'KIRILLS', ]],
['header' => 'Compliance Officer', 'field' => 'compliance_officer', 'field_type' => 'select', 'options' => [ 'LUCI HUTT', 'DAISY ADAMS', 'DAISY ADAMS', 'AIMEE GODWIN' , 'AIMEE GODWIN' ]],
['header' => 'Retrofit', 'field' => 'retrofit', 'field_type' => 'select', 'options' => [ 'ANTHONY', 'RETROFIT', 'DALE', 'N/A', 'DAVE', 'PAUL', 'LEE', 'IAN', 'KIRILLS', ]],
['header' => 'Contribution', 'field' => 'contribution', 'field_type' => 'text'],
['header' => 'Installation Date', 'field' => 'installation_date', 'field_type' => 'date'],
['header' => 'File EST/LA Flex', 'field' => 'file_est_la_flex', 'field_type' => 'text'],
['header' => 'Data Match', 'field' => 'data_match', 'field_type' => 'select', 'options' => [ 'MATCHED', 'DATA MATCH', 'NOT REQUIRED', 'SENT', 'UNMATCHED', 'UNVERIFIED', ]],
['header' => 'Surveyor Sign Off', 'field' => 'surveyor_sign_off', 'field_type' => 'select', 'options' => [ 'DONE', 'SURVEYOR SIGNOFF' ]],
['header' => 'Eligibility', 'field' => 'eligibility', 'field_type' => 'select' , 'options' => ['HHCRO EST', 'ELIGIBILITY', 'TAX CREDITS(CHILD TAX CREDITS AND WORKING TASK CREDITS,)', 'UNIVERSAL CREDIT', 'CHILD BENEFIT', 'LA FLEX', 'UNIVERSAL CREDIT', 'HOUSING BENEFIT']],
['header' => 'Qualified', 'field' => 'qualified', 'field_type' => 'select', 'options' => ['YES', 'QUALIFIED', 'NOT REQUIRED', 'AWAITING RESULT', ]],
['header' => 'Utility Bill', 'field' => 'utility_bill', 'field_type' => 'select', 'options' => ['YES', 'N/A', 'NO', 'UTILITY BILL' ]],
['header' => 'Retrofit Assessment', 'field' => 'retrofit_assessment', 'field_type' => 'select', 'options' => ['YES', 'RETROFIT ASSESSMENT' ]],
['header' => 'VOA Check', 'field' => 'voa_check', 'field_type' => 'select', 'options' => ['YES','VOA CHECK', 'MIXED USE', 'NOT ON VOA' ]],
['header' => 'Land Registry', 'field' => 'land_registry', 'field_type' => 'select', 'options' => ['YES', 'NO', 'N/A ', 'LAND REGISTRY']],
['header' => 'EST Consent', 'field' => 'est_consent', 'field_type' => 'select', 'options' => ['YES', 'NO', 'EST CONSENT']],
['header' => 'Owned or Rented', 'field' => 'owned_or_rented', 'field_type' => 'select', 'options' => ['OWNER', 'RENTAL', 'PRIVATE TENANT']],
['header' => 'Landlord Consent', 'field' => 'landlord_consent', 'field_type' => 'select', 'options' => ['NO', 'YES', 'N/A', 'LANDLORD', 'CONSENT']],
['header' => 'Tenancy Agreement', 'field' => 'tenancy_agreement', 'field_type' => 'select', 'options' => ['NO', 'YES', 'N/A', 'TENANCY AGREEMENT']],
['header' => 'EPC', 'field' => 'epc', 'field_type' => 'select', 'options' => ['NO', 'YES', 'N/A', 'EPC', 'NO EPC', 'LANDLORD', 'MR PHILJACKSON']],
['header' => 'DSSY', 'field' => 'dssy', 'field_type' => 'text'],
['header' => 'Planning/Listed Check', 'field' => 'planning_listed_check', 'field_type' => 'select', 'options' => ['CONSERVATION AREA', 'PLANNING/LISTED', 'YES', 'ARTICLE 4', 'NO',]],
['header' => 'Assignees', 'field' => 'assignees', 'field_type' => 'select', 'options' => ['RYAN ANSTEE', 'HANNAH BULLOCK', 'DAWN DAVID', 'CAINE CURTIS', 'CHRIS JENKINS', 'ADAM HUMPHRIES', 'SOPHIE PRYCE', '[email protected]', 'KEVIN ORMEROD', 'RYAN ANSTEE', 'DAWN DAVID', 'CAINE CURTIS', 'HANNAH BULLOCK', 'ADAM BROWN', ]],
['header' => 'Finishing EPC Grade', 'field' => 'finishing_epc_grade', 'field_type' => 'text'],
['header' => 'RRN #', 'field' => 'rrn_number', 'field_type' => 'select', 'options' => ['HOUSE', 'BUNGALOW', 'DETACHED HOUSE','PARK', 'HOME']],
['header' => 'RA Invoiced', 'field' => 'ra_invoiced', 'field_type' => 'text'],
['header' => 'RC Invoiced', 'field' => 'rc_invoiced', 'field_type' => 'text'],
['header' => 'Post Install Inspection', 'field' => 'post_install_inspection', 'field_type' => 'text'],
['header' => 'Pulse Test Pre', 'field' => 'pulse_test_pre', 'field_type' => 'text'],
['header' => 'Pulse Test Post', 'field' => 'pulse_test_post', 'field_type' => 'text'],
['header' => 'EPC Finished', 'field' => 'epc_finished', 'field_type' => 'text'],
['header' => 'Lodgement fee', 'field' => 'lodgement_fee', 'field_type' => 'decimal'],
['header' => 'Sign Off Path C', 'field' => 'signoff_path_c', 'field_type' => 'text'],
],
],
'installation-board' => [
'status' => [
"Customers Interested" => ['value' => "customers-interested", 'color' => $this->getStatusColor()['customers-interested']],
"ESH" => ['value' => "esh", 'color' => $this->getStatusColor()['esh']],
"Customer Quoted" => ['value' => "customer-quoted", 'color' => $this->getStatusColor()['customer-quoted']],
"Quote Accepted" => ['value' => "quote-accepted", 'color' => $this->getStatusColor()['quote-accepted']],
"Install Booked" => ['value' => "install-booked", 'color' => $this->getStatusColor()['install-booked']],
"Completed" => ['value' => "completed", 'color' => $this->getStatusColor()['completed']],
"Cancelled" => ['value' => "cancelled", 'color' => $this->getStatusColor()['cancelled']],
],
'fields' => [
['header' => 'Name', 'field' => 'address', 'field_type' => 'text'],
['header' => 'Subitems', 'field' => 'subitems', 'field_type' => 'text'],
['header' => 'Postcode', 'field' => 'postcode', 'field_type' => 'text'],
['header' => 'Request Received', 'field' => 'request_received', 'field_type' => 'date'],
['header' => 'Customers Name', 'field' => 'customers_name', 'field_type' => 'text'],
['header' => 'Contact Number', 'field' => 'contact_number', 'field_type' => 'text'],
['header' => 'Mobile Number', 'field' => 'mobile_number', 'field_type' => 'text'],
['header' => 'Email Address', 'field' => 'email', 'field_type' => 'email'],
['header' => 'Survey Date & Time', 'field' => 'survey_date', 'field_type' => 'datetime-local'],
['header' => 'Measures', 'field' => 'measures', 'field_type' => 'text'],
['header' => 'Status', 'field' => 'status', 'field_type' => 'select', 'options' => ['STATUS', 'PENDING SURVEY BOOKING', 'CANCELLED','NEW' ]],
['header' => 'Lead Source', 'field' => 'lead_source', 'field_type' => 'text'],
['header' => 'Surveyor', 'field' => 'surveyor', 'field_type' => 'text'],
['header' => 'INSTALLER', 'field' => 'installer', 'field_type' => 'select', 'options' => ['INSTALLER', 'ZING', 'CURTIS ANSTEE', 'UK ENRGY SAVE', 'ENVO ENERGY', 'BAXTER KELLY']],
['header' => 'FUNDING', 'field' => 'funding', 'field_type' => 'text'],
['header' => 'Notes', 'field' => 'notes', 'field_type' => 'text'],
['header' => 'PO #', 'field' => 'po_number', 'field_type' => 'text'],
['header' => 'Surveyors Notes', 'field' => 'surveyors_notes', 'field_type' => 'text'],
['header' => 'EPC Grade To Start', 'field' => 'epc_level', 'field_type' => 'select', 'options' => ['NO EPC', 'VALID EPC' ]],
['header' => 'Platform', 'field' => 'platform', 'field_type' => 'text'],
['header' => 'Progress', 'field' => 'progress', 'field_type' => 'text'],
['header' => 'Property Type', 'field' => 'property_type', 'field_type' => 'select', 'options' => ['PROPERTY TYPE', 'HOUSE', 'BUNGALOW', 'DETACHED HOUSE', 'END TERRACE' ]],
['header' => 'Wall Type', 'field' => 'wall_type', 'field_type' => 'select', 'options' => ['WALL TYPE', 'SOLID BRICK', 'SOLID STONE', 'CAVITY', 'OTHER' ]],
['header' => 'Detachment', 'field' => 'detachment', 'field_type' => 'select', 'options' => ['END TERRACE', 'DETACHED', 'SEMI-DETACHED', 'DETACHMENT', 'MID TERRACE']],
['header' => 'Number of bedrooms', 'field' => 'no_of_bedrooms', 'field_type' => 'number'],
['header' => 'Heating Source', 'field' => 'heating_source', 'field_type' => 'select', 'options' => ['OIL', 'ELECTRIC', 'HEATING SOURCE', 'SOILD FUEL (E.G COAL)', 'NO HEATING', 'LPG' ]],
['header' => 'Book Survey', 'field' => 'book_survey', 'field_type' => 'text'],
['header' => 'Floorplans', 'field' => 'floorplans', 'field_type' => 'text'],
['header' => 'Compliance Officer', 'field' => 'compliance_officer', 'field_type' => 'text'],
['header' => 'Retrofit', 'field' => 'retrofit', 'field_type' => 'text'],
['header' => 'Contribution', 'field' => 'contribution', 'field_type' => 'text'],
['header' => 'Installation Date', 'field' => 'installation_date', 'field_type' => 'date'],
['header' => 'File EST/LA Flex', 'field' => 'file_est_la_flex', 'field_type' => 'text'],
['header' => 'Data Match', 'field' => 'data_match', 'field_type' => 'text'],
['header' => 'Surveyor Sign Off', 'field' => 'surveyor_sign_off', 'field_type' => 'text'],
['header' => 'Eligibility', 'field' => 'eligibility', 'field_type' => 'text'],
['header' => 'Qualified', 'field' => 'qualified', 'field_type' => 'text'],
['header' => 'Utility Bill', 'field' => 'utility_bill', 'field_type' => 'text'],
['header' => 'Retrofit Assessment', 'field' => 'retrofit_assessment', 'field_type' => 'text'],
['header' => 'VOA Check', 'field' => 'voa_check', 'field_type' => 'text'],
['header' => 'Land Registry', 'field' => 'land_registry', 'field_type' => 'text'],
['header' => 'EST Consent', 'field' => 'est_consent', 'field_type' => 'text'],
['header' => 'Owned or Rented', 'field' => 'owned_or_rented', 'field_type' => 'select', 'options' => ['OWNED', 'RENTED']],
['header' => 'Landlord Consent', 'field' => 'landlord_consent', 'field_type' => 'text'],
['header' => 'Tenancy Agreement', 'field' => 'tenancy_agreement', 'field_type' => 'text'],
['header' => 'EPC', 'field' => 'epc', 'field_type' => 'text'],
['header' => 'DSSY', 'field' => 'dssy', 'field_type' => 'text'],
['header' => 'Planning/Listed Check', 'field' => 'planning_listed_check', 'field_type' => 'text'],
['header' => 'Assignees', 'field' => 'assignees', 'field_type' => 'text'],
['header' => 'Finishing EPC Grade', 'field' => 'finishing_epc_grade', 'field_type' => 'text'],
['header' => 'RRN #', 'field' => 'rrn_number', 'field_type' => 'select', 'options' => ['HOUSE', 'RRN #', 'BUNGALOW', 'DETACHED HOUSE']],
],
],
'pulse-testing' => [
'status' => [
"Customers To Be Booked" => ['value' => "customers-to-be-booked", 'color' => $this->getStatusColor()['customers-to-be-booked']],
"Pulse Test Booked In" => ['value' => "pulse-test-booked-in", 'color' => $this->getStatusColor()['pulse-test-booked-in']],
"Pulse Test Completed" => ['value' => "pulse-test-completed", 'color' => $this->getStatusColor()['pulse-test-completed']],
"Pulse Test Lodged" => ['value' => "pulse-test-lodged", 'color' => $this->getStatusColor()['pulse-test-lodged']],
"Invoice Raised" => ['value' => "invoice-raised", 'color' => $this->getStatusColor()['invoice-raised']],
"Completed" => ['value' => "completed", 'color' => $this->getStatusColor()['completed']],
"Cancelled" => ['value' => "cancelled", 'color' => $this->getStatusColor()['cancelled']],
"Holidays" => ['value' => "holidays", 'color' => $this->getStatusColor()['holidays']],
],
'fields' => [
['header' => 'Name', 'field' => 'address', 'field_type' => 'text'],
['header' => 'Subitems', 'field' => 'subitems', 'field_type' => 'text'],
['header' => 'Postcode', 'field' => 'postcode', 'field_type' => 'text'],
['header' => 'Request Received', 'field' => 'request_received', 'field_type' => 'date'],
['header' => 'Customers Name', 'field' => 'customers_name', 'field_type' => 'text'],
['header' => 'Contact Number', 'field' => 'contact_number', 'field_type' => 'text'],
['header' => 'Mobile Number', 'field' => 'mobile_number', 'field_type' => 'text'],
['header' => 'Email Address', 'field' => 'email', 'field_type' => 'email'],
['header' => 'Survey Date & Time', 'field' => 'survey_date', 'field_type' => 'datetime-local'],
['header' => 'Measures', 'field' => 'measures', 'field_type' => 'text'],
['header' => 'Status', 'field' => 'status', 'field_type' => 'select', 'options' => [ 'STATUS', 'PENDING SURVEY BOOKING', 'CANCELLED', 'SURVEY BOOKED']],
['header' => 'Lead Source', 'field' => 'lead_source', 'field_type' => 'text'],
['header' => 'Surveyor', 'field' => 'surveyor', 'field_type' => 'text'],
['header' => 'INSTALLER', 'field' => 'installer', 'field_type' => 'select', 'options' => [ 'INSTALLER', 'ZING', 'CURTIS ANSTEE', 'UK ENRGY SAVE', 'ENVO ENERGY', 'BAXTER KELLY' ]],
['header' => 'FUNDING', 'field' => 'funding', 'field_type' => 'text'],
['header' => 'Notes', 'field' => 'notes', 'field_type' => 'text'],
['header' => 'PO #', 'field' => 'po_number', 'field_type' => 'select', 'options' => [ 'PO#', '' ]],
['header' => 'Surveyors Notes', 'field' => 'surveyors_notes', 'field_type' => 'text'],
['header' => 'EPC Grade To Start', 'field' => 'epc_level', 'field_type' => 'select', 'options' => [ 'NO EPC', 'VALID EPC' ]],
['header' => 'Platform', 'field' => 'platform', 'field_type' => 'text'],
['header' => 'Progress', 'field' => 'progress', 'field_type' => 'text'],
['header' => 'Property Type', 'field' => 'property_type', 'field_type' => 'select', 'options' => [ 'PROPERTY TYPE', 'HOUSE', 'BUNGALOW', 'DETACHED HOUSE', 'END TERRACE']],
['header' => 'Wall Type', 'field' => 'wall_type', 'field_type' => 'select', 'options' => [ 'WALL TYPE', 'SOLID BRICK', 'SOLID STONE', 'CAVITY', 'OTHER']],
['header' => 'Detachment', 'field' => 'detachment', 'field_type' => 'select', 'options' => [ 'END TERRACE', 'DETACHED', 'SEMI-DETACHED', 'DETACHMENT', 'MID TERRACE' ]],
['header' => 'Number of bedrooms', 'field' => 'no_of_bedrooms', 'field_type' => 'number'],
['header' => 'Heating Source', 'field' => 'heating_source', 'field_type' => 'select', 'options' => [ 'OIL', 'ELECTRIC', 'HEATING SOURCE', 'SOILC FUEL (E.G COAL)', 'NO HEATING', 'LPG' ]],
['header' => 'Book Survey', 'field' => 'book_survey', 'field_type' => 'text'],
['header' => 'Floorplans', 'field' => 'floorplans', 'field_type' => 'text'],
['header' => 'Compliance Officer', 'field' => 'compliance_officer', 'field_type' => 'text'],
['header' => 'Retrofit', 'field' => 'retrofit', 'field_type' => 'text'],
['header' => 'Contribution', 'field' => 'contribution', 'field_type' => 'text'],
['header' => 'Installation Date', 'field' => 'installation_date', 'field_type' => 'date'],
['header' => 'File EST/LA Flex', 'field' => 'file_est_la_flex', 'field_type' => 'text'],
['header' => 'Data Match', 'field' => 'data_match', 'field_type' => 'text'],
['header' => 'Surveyor Sign Off', 'field' => 'surveyor_sign_off', 'field_type' => 'text'],
['header' => 'Eligibility', 'field' => 'eligibility', 'field_type' => 'text'],
['header' => 'Qualified', 'field' => 'qualified', 'field_type' => 'text'],
['header' => 'Utility Bill', 'field' => 'utility_bill', 'field_type' => 'text'],
['header' => 'Retrofit Assessment', 'field' => 'retrofit_assessment', 'field_type' => 'text'],
['header' => 'VOA Check', 'field' => 'voa_check', 'field_type' => 'text'],
['header' => 'Land Registry', 'field' => 'land_registry', 'field_type' => 'text'],
['header' => 'EST Consent', 'field' => 'est_consent', 'field_type' => 'text'],
['header' => 'Owned or Rented', 'field' => 'owned_or_rented', 'field_type' => 'select', 'options' => [ 'OWNED', 'RENTED' ]],
['header' => 'Landlord Consent', 'field' => 'landlord_consent', 'field_type' => 'text'],
['header' => 'Tenancy Agreement', 'field' => 'tenancy_agreement', 'field_type' => 'text'],
['header' => 'EPC', 'field' => 'epc', 'field_type' => 'text'],
['header' => 'DSSY', 'field' => 'dssy', 'field_type' => 'text'],
['header' => 'Planning/Listed Check', 'field' => 'planning_listed_check', 'field_type' => 'text'],
['header' => 'Assignees', 'field' => 'assignees', 'field_type' => 'text'],
['header' => 'Finishing EPC Grade', 'field' => 'finishing_epc_grade', 'field_type' => 'text'],
['header' => 'Test Required', 'field' => 'test_required', 'field_type' => 'text'],
['header' => 'Tester ID', 'field' => 'tester_id', 'field_type' => 'select', 'options' => ['TIM JONES', 'TJ/IT', 'IAN THOMAS', 'STEVEN THOMAS', 'SURVEYOR' ]],
['header' => 'Invoiced', 'field' => 'invoiced', 'field_type' => 'text'],
['header' => 'RRN #', 'field' => 'rrn_number', 'field_type' => 'select', 'options' => ['HOUSE', 'RRN #', 'BUNGALOW', 'DETACHED HOUSE']],
],
]
];
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment