FNI Configurations
Import Fields
Import Fields (PDC)
Brand/Model/Variant
Dealer Contacts
>Required Fields
BRAND
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 2 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
MODEL
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 3 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
VARIANT
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 4 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Place / CS Number
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 1 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Company
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 9 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Dealer
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 10 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Customer Mobile
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 6 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Customer Email
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 7 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Customer Fullname
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 5 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Customer Full Address
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 8 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Insurance Company
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 11 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Policy No.
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 12 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Policy Issue Date
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 13 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Policy Start Date
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 14 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Policy End Date
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 15 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Insurance Type
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 16 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Bank
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 17 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
SC Fullname
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 18 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Locked In
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 19 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Locked In Years
*
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 20 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Paid Amount
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 21 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Terms
return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 22 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "
".$data['name']."
"; } ?>
Company
*
return_result("SELECT `name` FROM `source_finance_pdc_fields_name` WHERE `finance_field_pdc_id` = (SELECT id FROM source_finance_pdc_fields WHERE id = 1 LIMIT 1) ORDER BY name ASC "); foreach($field AS $data){ echo "
".$data['name']."
"; } ?>
Dealer
*
return_result("SELECT `name` FROM `source_finance_pdc_fields_name` WHERE `finance_field_pdc_id` = (SELECT id FROM source_finance_pdc_fields WHERE id = 2 LIMIT 1) ORDER BY name ASC "); foreach($field AS $data){ echo "
".$data['name']."
"; } ?>
Brand
*
return_result("SELECT `name` FROM `source_finance_pdc_fields_name` WHERE `finance_field_pdc_id` = (SELECT id FROM source_finance_pdc_fields WHERE id = 3 LIMIT 1) ORDER BY name ASC "); foreach($field AS $data){ echo "
".$data['name']."
"; } ?>
Model
*
return_result("SELECT `name` FROM `source_finance_pdc_fields_name` WHERE `finance_field_pdc_id` = (SELECT id FROM source_finance_pdc_fields WHERE id = 4 LIMIT 1) ORDER BY name ASC "); foreach($field AS $data){ echo "
".$data['name']."
"; } ?>
Insurance Company
*
return_result("SELECT `name` FROM `source_finance_pdc_fields_name` WHERE `finance_field_pdc_id` = (SELECT id FROM source_finance_pdc_fields WHERE id = 5 LIMIT 1) ORDER BY name ASC "); foreach($field AS $data){ echo "
".$data['name']."
"; } ?>
Policy Number
*
return_result("SELECT `name` FROM `source_finance_pdc_fields_name` WHERE `finance_field_pdc_id` = (SELECT id FROM source_finance_pdc_fields WHERE id = 6 LIMIT 1) ORDER BY name ASC "); foreach($field AS $data){ echo "
".$data['name']."
"; } ?>
Client Name
*
return_result("SELECT `name` FROM `source_finance_pdc_fields_name` WHERE `finance_field_pdc_id` = (SELECT id FROM source_finance_pdc_fields WHERE id = 7 LIMIT 1) ORDER BY name ASC "); foreach($field AS $data){ echo "
".$data['name']."
"; } ?>
Client Mobile
*
return_result("SELECT `name` FROM `source_finance_pdc_fields_name` WHERE `finance_field_pdc_id` = (SELECT id FROM source_finance_pdc_fields WHERE id = 8 LIMIT 1) ORDER BY name ASC "); foreach($field AS $data){ echo "
".$data['name']."
"; } ?>
Client Email
*
return_result("SELECT `name` FROM `source_finance_pdc_fields_name` WHERE `finance_field_pdc_id` = (SELECT id FROM source_finance_pdc_fields WHERE id = 9 LIMIT 1) ORDER BY name ASC "); foreach($field AS $data){ echo "
".$data['name']."
"; } ?>
Bank / Branch
*
return_result("SELECT `name` FROM `source_finance_pdc_fields_name` WHERE `finance_field_pdc_id` = (SELECT id FROM source_finance_pdc_fields WHERE id = 10 LIMIT 1) ORDER BY name ASC "); foreach($field AS $data){ echo "
".$data['name']."
"; } ?>
Check Date
*
return_result("SELECT `name` FROM `source_finance_pdc_fields_name` WHERE `finance_field_pdc_id` = (SELECT id FROM source_finance_pdc_fields WHERE id = 11 LIMIT 1) ORDER BY name ASC "); foreach($field AS $data){ echo "
".$data['name']."
"; } ?>
Check Number
*
return_result("SELECT `name` FROM `source_finance_pdc_fields_name` WHERE `finance_field_pdc_id` = (SELECT id FROM source_finance_pdc_fields WHERE id = 12 LIMIT 1) ORDER BY name ASC "); foreach($field AS $data){ echo "
".$data['name']."
"; } ?>
Check Amount
*
return_result("SELECT `name` FROM `source_finance_pdc_fields_name` WHERE `finance_field_pdc_id` = (SELECT id FROM source_finance_pdc_fields WHERE id = 13 LIMIT 1) ORDER BY name ASC "); foreach($field AS $data){ echo "
".$data['name']."
"; } ?>
Plate / CS Number
*
return_result("SELECT `name` FROM `source_finance_pdc_fields_name` WHERE `finance_field_pdc_id` = (SELECT id FROM source_finance_pdc_fields WHERE id = 14 LIMIT 1) ORDER BY name ASC "); foreach($field AS $data){ echo "
".$data['name']."
"; } ?>
Brands
return_result($query); foreach($brand AS $data){ ?>
Brands
Brand Name
Brand Status
Added by:
Date added:
Last modified by:
Models
Models
Model Name
Model Status
Model's brand
Specify Model's Brand
return_result($query); foreach($brand AS $data){ ?>
Added by:
Date added:
Last modified by:
Variants
Variants
Variant Name
Variant Status
Variant's model
Specify Variant's Model
return_result($query); foreach($model AS $data){ ?>
Added by:
Date added:
Last modified by:
Dealers
return_result($query); foreach($dealer as $data){ ?>
Contact
Contact Person
Mobile Phone 1
Mobile Phone 2
Added by:
Date added:
Last modified by:
CUSTOMER NUMBER
Required in:
Importing
Manual adding
Updating
CUSTOMER EMAIL
Required in:
Importing
Manual adding
Updating
POLICY NUMBER
Required in:
Importing
Manual adding
Updating
Add Brand
×
Brand Name
Add Model
×
Brand
SELECT MODEL'S BRAND
return_result($query); foreach($brand AS $row){ echo "
".$row['name']."
"; } ?>
Model Name
Add Variant
×
Brand
SELECT MODEL'S BRAND
return_result($query); foreach($brand AS $row){ echo "
".$row['name']."
"; } ?>
Model
SELECT MODEL'S BRAND
Variant Name
Add Dealer
×
Choose dealer to be added
sql_query("SELECT dealer_id FROM finance"); foreach($finance_dealer_list AS $row){ $company_item = $row['dealer_id']; if(!(in_array($company_item, $company_arr))){ array_push($company_arr, $company_item); } } $companies = implode(',', $company_arr); $query = " SELECT id, name FROM source_dealer WHERE id != 0 AND status != 0"; $dealer = $db->return_result($query); foreach($dealer AS $data){ ?>
Contact Person:
Mobile Number 1:
Mobile Number 2: