添加数据库表字段
oc_address 添加字段
- district
- street_name
- house_number
oc_order 添加字段
- doc_type
- doc_no
- payment_district
- payment_street_name
- payment_house_number
- shipping_district
- shipping_street_name
- shipping_house_number
oc_customer 添加字段
- doc_type
- doc_no
修改Model
catalog/model/account/address.php
public function addAddress($customer_id, $data) {
$this->db->query("INSERT INTO " . DB_PREFIX . "address SET customer_id = '" . (int)$customer_id . "', firstname = '" . $this->db->escape($data['firstname']) ... . "', district = '" . $this->db->escape($data['district']) . "', street_name = '" . $this->db->escape($data['street_name']) . "', house_number = '" . $this->db->escape($data['house_number']) ...);
...
}
public function editAddress($address_id, $data) {
$this->db->query("UPDATE " . DB_PREFIX . "address SET firstname = '" . $this->db->escape($data['firstname']) ... . "', district = '" . $this->db->escape($data['district']) . "', street_name = '" . $this->db->escape($data['street_name']) . "', house_number = '" . $this->db->escape($data['house_number']) ...);
...
}
public function getAddress($address_id) {
...
if ($address_query->num_rows) {
...
$address_data = array(
...
'district' => $address_query->row['district'],
'street_name' => $address_query->row['street_name'],
'house_number' => $address_query->row['house_number'],
...
}
public function getAddresses() {
...
foreach ($query->rows as $result) {
...
$address_data[$result['address_id']] = array(
...
'district' => $result['district'],
'street_name' => $result['street_name'],
'house_number' => $result['house_number'],
...
}catalog/model/account/order.php
public function getOrder($order_id) {
...
if ($order_query->num_rows) {
...
return array(
...
'doc_type' => $order_query->row['doc_type'],
'doc_no' => $order_query->row['doc_no'],
...
'payment_district' => $order_query->row['payment_district'],
'payment_street_name' => $order_query->row['payment_street_name'],
'payment_house_number' => $order_query->row['payment_house_number'],
...
'shipping_district' => $order_query->row['shipping_district'],
'shipping_street_name' => $order_query->row['shipping_street_name'],
'shipping_house_number' => $order_query->row['shipping_house_number'],
...
);catalog/model/account/customer.php
public function editCustomer($customer_id, $data) {
$this->db->query("UPDATE " . DB_PREFIX . "customer SET firstname = '" . $this->db->escape($data['firstname']) ... . "', doc_type = '" . $this->db->escape($data['doc_type']) . "', doc_no = '" . $this->db->escape($data['doc_no']) ...);
}opencart/catalog/model/checkout/order.php
public function addOrder($data) {
$this->db->query("INSERT INTO `" . DB_PREFIX . "order` SET invoice_prefix = '" . $this->db->escape($data['invoice_prefix']) ... . "', doc_type = '" . $this->db->escape($data['doc_type']) . "', doc_no = '" . $this->db->escape($data['doc_no']) ... . "', payment_district = '" . $this->db->escape($data['payment_district']) . "', payment_street_name = '" . $this->db->escape($data['payment_street_name']) . "', payment_house_number = '" . $this->db->escape($data['payment_house_number']) ... . "', shipping_district = '" . $this->db->escape($data['shipping_district']) . "', shipping_street_name = '" . $this->db->escape($data['shipping_street_name']) . "', shipping_house_number = '" . $this->db->escape($data['shipping_house_number']) ....);
...
}
public function editOrder($order_id, $data) {
...
$this->db->query("UPDATE `" . DB_PREFIX . "order` SET invoice_prefix = '" . $this->db->escape($data['invoice_prefix']) ... . "', doc_type = '" . $this->db->escape($data['doc_type']) . "', doc_no = '" . $this->db->escape($data['doc_no']) ... . "', payment_district = '" . $this->db->escape($data['payment_district']) . "', payment_street_name = '" . $this->db->escape($data['payment_street_name']) . "', payment_house_number = '" . $this->db->escape($data['payment_house_number']) ... . "', shipping_district = '" . $this->db->escape($data['shipping_district']) . "', shipping_street_name = '" . $this->db->escape($data['shipping_street_name']) . "', shipping_house_number = '" . $this->db->escape($data['shipping_house_number']) ...);
...
}
public function getOrder($order_id) {
...
if ($order_query->num_rows) {
...
$order_products = $this->db->query("SELECT `name`,`quantity` as `qty`,`price` FROM `" . DB_PREFIX . "order_product` WHERE order_id = $order_id");
...
return array(
'order_id' => $order_query->row['order_id'],
'products' => $order_products->rows,
...
'doc_type' => $order_query->row['doc_type'],
'doc_no' => $order_query->row['doc_no'],
...
'payment_district' => $order_query->row['payment_district'],
'payment_street_name' => $order_query->row['payment_street_name'],
'payment_house_number' => $order_query->row['payment_house_number'],
...
'shipping_district' => $order_query->row['shipping_district'],
'shipping_street_name' => $order_query->row['shipping_street_name'],
'shipping_house_number' => $order_query->row['shipping_house_number'],
...
}修改Language
catalog/language/en-gb/account/address.php
catalog/language/en-gb/checkout/checkout.php
修改Controller
catalog/controller/account/address.php
protected function getForm() {
...
if (isset($this->request->post['district'])) {
$data['district'] = $this->request->post['district'];
} elseif (!empty($address_info)) {
$data['district'] = $address_info['district'];
} else {
$data['district'] = '';
}
if (isset($this->request->post['city'])) {
$data['street_name'] = $this->request->post['street_name'];
} elseif (!empty($address_info)) {
$data['street_name'] = $address_info['street_name'];
} else {
$data['street_name'] = '';
}
if (isset($this->request->post['house_number'])) {
$data['house_number'] = $this->request->post['house_number'];
} elseif (!empty($address_info)) {
$data['house_number'] = $address_info['house_number'];
} else {
$data['house_number'] = '';
}
...
}catalog/controller/account/edit.php
public function index() {
...
if (($this->request->server['REQUEST_METHOD'] == 'POST') && $this->validate()) {
$this->model_account_customer->editCustomer($this->customer->getId(), $this->request->post);
$this->session->data['success'] = $this->language->get('text_success');
$this->response->redirect($this->url->link('account/account', '', true));
}
...
if (isset($this->error['doc_type'])) {
$data['error_doc_type'] = $this->error['doc_type'];
} else {
$data['error_doc_type'] = '';
}
if (isset($this->error['doc_no'])) {
$data['error_doc_no'] = $this->error['doc_no'];
} else {
$data['error_doc_no'] = '';
}
...
if (isset($this->request->post['doc_type'])) {
$data['doc_type'] = $this->request->post['doc_type'];
} elseif (!empty($customer_info)) {
$data['doc_type'] = $customer_info['doc_type'];
} else {
$data['doc_type'] = '';
}
if (isset($this->request->post['doc_no'])) {
$data['doc_no'] = $this->request->post['doc_no'];
} elseif (!empty($customer_info)) {
$data['doc_no'] = $customer_info['doc_no'];
} else {
$data['doc_no'] = '';
}
...
}catalog/controller/checkout/confirm.php
public function index() {
...
if (!$redirect) {
...
$this->load->model('account/customer');
if ($this->customer->isLogged()) {
$customer_info = $this->model_account_customer->getCustomer($this->customer->getId());
$order_data['customer_id'] = $this->customer->getId();
...
$order_data['doc_type'] = empty($customer_info['doc_type']) ? $this->session->data['doc_type'] : $customer_info['doc_type'];
$order_data['doc_no'] = empty($customer_info['doc_type']) ? $this->session->data['doc_no'] : $customer_info['doc_no'];
...
} elseif (isset($this->session->data['guest'])) {
$order_data['customer_id'] = 0;
...
$order_data['doc_type'] = $this->session->data['guest']['doc_type'];
$order_data['doc_no'] = $this->session->data['guest']['doc_no'];
...
}
...
$order_data['payment_district'] = $this->session->data['payment_address']['district'];
$order_data['payment_street_name'] = $this->session->data['payment_address']['street_name'];
$order_data['payment_house_number'] = $this->session->data['payment_address']['house_number'];
...
if ($this->cart->hasShipping()) {
...
$order_data['shipping_district'] = $this->session->data['shipping_address']['district'];
$order_data['shipping_street_name'] = $this->session->data['shipping_address']['street_name'];
$order_data['shipping_house_number'] = $this->session->data['shipping_address']['house_number'];
...
} else {
...
$order_data['shipping_district'] = '';
$order_data['shipping_street_name'] = '';
$order_data['shipping_house_number'] = '';
...
}修改Twig模板
catalog/view/theme/default/template/account/address_form.twig
catalog/view/theme/default/template/account/edit.twig
catalog/view/theme/default/template/checkout/payment_address.twig
