diff options
Diffstat (limited to 'public/catalog/model/account/custom_field.php')
| -rw-r--r-- | public/catalog/model/account/custom_field.php | 47 |
1 files changed, 47 insertions, 0 deletions
diff --git a/public/catalog/model/account/custom_field.php b/public/catalog/model/account/custom_field.php new file mode 100644 index 0000000..8d5a48c --- /dev/null +++ b/public/catalog/model/account/custom_field.php @@ -0,0 +1,47 @@ +<?php +class ModelAccountCustomField extends Model { + public function getCustomField($custom_field_id) { + $query = $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) WHERE cf.status = '1' AND cf.custom_field_id = '" . (int)$custom_field_id . "' AND cfd.language_id = '" . (int)$this->config->get('config_language_id') . "'"); + + return $query->row; + } + + public function getCustomFields($customer_group_id = 0) { + $custom_field_data = array(); + + if (!$customer_group_id) { + $custom_field_query = $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) WHERE cf.status = '1' AND cfd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND cf.status = '1' ORDER BY cf.sort_order ASC"); + } else { + $custom_field_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "custom_field_customer_group` cfcg LEFT JOIN `" . DB_PREFIX . "custom_field` cf ON (cfcg.custom_field_id = cf.custom_field_id) LEFT JOIN `" . DB_PREFIX . "custom_field_description` cfd ON (cf.custom_field_id = cfd.custom_field_id) WHERE cf.status = '1' AND cfd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND cfcg.customer_group_id = '" . (int)$customer_group_id . "' ORDER BY cf.sort_order ASC"); + } + + foreach ($custom_field_query->rows as $custom_field) { + $custom_field_value_data = array(); + + if ($custom_field['type'] == 'select' || $custom_field['type'] == 'radio' || $custom_field['type'] == 'checkbox') { + $custom_field_value_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "custom_field_value cfv LEFT JOIN " . DB_PREFIX . "custom_field_value_description cfvd ON (cfv.custom_field_value_id = cfvd.custom_field_value_id) WHERE cfv.custom_field_id = '" . (int)$custom_field['custom_field_id'] . "' AND cfvd.language_id = '" . (int)$this->config->get('config_language_id') . "' ORDER BY cfv.sort_order ASC"); + + foreach ($custom_field_value_query->rows as $custom_field_value) { + $custom_field_value_data[] = array( + 'custom_field_value_id' => $custom_field_value['custom_field_value_id'], + 'name' => $custom_field_value['name'] + ); + } + } + + $custom_field_data[] = array( + 'custom_field_id' => $custom_field['custom_field_id'], + 'custom_field_value' => $custom_field_value_data, + 'name' => $custom_field['name'], + 'type' => $custom_field['type'], + 'value' => $custom_field['value'], + 'validation' => $custom_field['validation'], + 'location' => $custom_field['location'], + 'required' => empty($custom_field['required']) || $custom_field['required'] == 0 ? false : true, + 'sort_order' => $custom_field['sort_order'] + ); + } + + return $custom_field_data; + } +}
\ No newline at end of file |