Code: Select all
public function getCustomerDiscount($customer_id,$customer_group_id) {
$xml = '';
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "customer WHERE discount = '".(int)$discount."'");
$customer = $query->row;
foreach($export_items as $item){
if($item == 'discount'){$xml .= '<DISCOUNT>'.htmlspecialchars($customer['discount']).'</DISCOUNT>'."\n";}
}
return $xml;
}Code: Select all
public function getCustomerDiscount($customer_id, $customer_group_id){
$query = $this->db->query("SELECT discount FROM `" . DB_PREFIX . "customer` WHERE `customer_id` = '" . (int)$customer_id . "' and `customer_group_id` = '" . (int)$customer_group_id . "'");
$xml = '';
if (isset($query->row['discount'])) {
$xml .= '<DISCOUNT>' . htmlspecialchars($query->row['discount']) . '</DISCOUNT>' . "\n";
}
return $xml;
}Backup and learn how to recover before you make any changes!
Code: Select all
public function getCustomerDiscount($customer_id, $customer_group_id){
$query = $this->db->query("SELECT discount FROM `" . DB_PREFIX . "customer` WHERE `customer_id` = '" . (int)$customer_id . "' and `customer_group_id` = '" . (int)$customer_group_id . "'");
$xml = '';
if (isset($query->row['discount'])) {
$xml .= '<DISCOUNT>' . htmlspecialchars($query->row['discount']) . '</DISCOUNT>' . "\n";
}
return $xml;
}Code: Select all
public function getCustomerDiscount($customer_id){
$query = $this->db->query("SELECT discount FROM `" . DB_PREFIX . "customer` WHERE `customer_id` = '" . (int)$customer_id . "'");
if (isset($query->row['discount'])) {
return $query->row['discount'];
}
return false;
}Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces
“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.
Code: Select all
public function getCustomerDiscount($customer_id){
$query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "customer` WHERE `customer_id` = '" . (int)$customer_id . "'");
return $query->row['discount'];
}Code: Select all
// Admin
$this->load->model('customer/customer');
$customer = $this->model_customer_customer->getCustomer($customer_id);
echo $customer['discount'];
// Catalog
$this->load->model('account/customer');
$customer = $this->model_account_customer->getCustomer($customer_id);
echo $customer['discount'];Backup and learn how to recover before you make any changes!
The OP doesn't know what he is doing.not sure what OP is using it for
Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces
“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.
If I correctly understand you use module for export orders XML and another one extension for discount. (I saw the same question in stackoverflow). So if you need some suggestion, please upload your order XML module and tables structure where your discount is placed (in your case seems in "customer" table). Maybe someone will help you.feedermania wrote: ↑Sun Feb 23, 2020 1:45 amIm beginner. What is the right syntax? I want to get the discount.
Table: customer
Column: discount
Code: Select all
public function getCustomerDiscount($customer_id,$customer_group_id) { $xml = ''; $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "customer WHERE discount = '".(int)$discount."'"); $customer = $query->row; foreach($export_items as $item){ if($item == 'discount'){$xml .= '<DISCOUNT>'.htmlspecialchars($customer['discount']).'</DISCOUNT>'."\n";} } return $xml; }
Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here
Users browsing this forum: No registered users and 9 guests
