Access Disabled Custom Fields in Shipping Module

Code: Select all

// Custom Fields
$data['custom_fields'] = array();
$this->load->model('account/custom_field');
$custom_fields = $this->model_account_custom_field->getCustomFields($this->config->get('config_customer_group_id'));
foreach ($custom_fields as $custom_field) {
	if ($custom_field['location'] == 'account') {
		$data['custom_fields'][] = $custom_field;
	}
}
print_r($data['custom_fields']);

Code: Select all

$this->db->query("SELECT * FROM `" . DB_PREFIX . "custom_field` cf LEFT JOIN `" . DB_PREFIX . "custom_field_description` cfd ON (cf.custom_field_id = cfd.custom_field_id) LEFT JOIN `" . DB_PREFIX . "custom_field_customer_group` `cfcg` ON (`cfcg`.`custom_field_id` = `cfd`.`custom_field_id`) INNER JOIN `" . DB_PREFIX . "customer_group` `cg` ON (`cg`.`customer_group_id` = `cfcg`.`customer_group_id`) INNER JOIN `" . DB_PREFIX . "customer` `c` ON (`c`.`customer_group_id` = `cg`.`customer_group_id`) WHERE cfd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND `c`.`customer_id` = '" . (int)$this->customer->getId() . "' AND LENGTH(TRIM(`cf`.`value`)) > 0 AND `cfcg`.`required` = '1' ORDER BY cf.sort_order ASC");

Code: Select all

Fatal error: Uncaught exception 'Exception' with message 'Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''oc_custom_field' cf LEFT JOIN 'oc_custom_field_description' cfd ON (cf.custom_' at line 1<br />Error No: 1064<br /> SELECT * FROM 'oc_custom_field' cf LEFT JOIN 'oc_custom_field_description' cfd ON (cf.custom_field_id = cfd.custom_field_id) LEFT JOIN 'oc_custom_field_customer_group' 'cfcg' ON ('cfcg'.'custom_field_id' = 'cfd'.'custom_field_id') INNER JOIN 'oc_customer_group' cg' ON ('cg'.'customer_group_id' = 'cfcg'.'customer_group_id') INNER JOIN 'oc_customer' 'c' ON ('c'.'customer_group_id' = 'cg'.'customer_group_id') WHERE cfd.language_id = '1' AND 'c'.'customer_id' = '2' ORDER BY cf.sort_order ASC' in /home/omadamar/public_html/design/victory/system/library/db/mysqli.php:40 Stack trace: #0 /home/omadamar/public_html/design/victory/system/library/db.php(45): DB\MySQLi->query('\nSELECT * FROM ...') #1 /home/omadama in /home/test/system/library/db/mysqli.php on line 40

Code: Select all

Array(
	[custom_field_id] => 2
	[type] => checkbox
	[value] => 
	[validation] => 
	[location] => account
	[status] => 1
	[sort_order] => 1
	[language_id] => 1
	[name] => Local delivery
	[customer_group_id] => 2
	[required] => 0
	[approval] => 0
	[customer_id] => 2
	[store_id] => 0
	[firstname] => Test 
	[lastname] => Account
	[email] => test@test.com
	[telephone] => 1234567890
	[fax] => 
	[password] => 00000000000000000000000
	[salt] => 000000000
	[cart] => 
	[wishlist] => 
	[newsletter] => 0
	[address_id] => 2
	[custom_field] => {"3":["7"],"2":["6"]}
	[ip] => 000.000.000.000
	[safe] => 1
	[token] => 
	[code] => 
	[date_added] => 2018-08-12 11:21:18
)

Code: Select all

{% if custom_field.type == 'checkbox' %}
              <div class="form-group{% if custom_field.required %} required {% endif %} custom-field" data-sort="{{ custom_field.sort_order }}">
                <label class="col-sm-2 col-form-label">{{ custom_field.name }}</label>
                <div class="col-sm-10">
                  <div>
                    {% for custom_field_value in custom_field.custom_field_value %}
                      <div class="form-check">
                        {% if account_custom_field[custom_field.custom_field_id] and custom_field_value.custom_field_value_id in account_custom_field[custom_field.custom_field_id] %}
                          <label><input type="checkbox" name="custom_field[{{ custom_field.location }}][{{ custom_field.custom_field_id }}][]" value="{{ custom_field_value.custom_field_value_id }}" class="form-check-input" checked="checked"/>
                            {{ custom_field_value.name }}</label>
                        {% else %}
                          <label><input type="checkbox" name="custom_field[{{ custom_field.location }}][{{ custom_field.custom_field_id }}][]" value="{{ custom_field_value.custom_field_value_id }}" class="form-check-input"/>
                            {{ custom_field_value.name }}</label>
                        {% endif %}
                      </div>
                    {% endfor %}
                  </div>
                  {% if error_custom_field[custom_field.custom_field_id] %}
                    <div class="text-danger">{{ error_custom_field[custom_field.custom_field_id] }}</div>
                  {% endif %}
                </div>
              </div>
            {% endif %}