Search found 16 matches

Page 1 of 1

Search found 16 matches

What is the right SQL syntax?

Hi. What is the right sql syntax? I want to filter for 4 id.

Code: Select all

$sql .= " AND order_status_id = '22''20''24''23'";
Now, Im only see the order_status_id 22.

Jump to post
  • Mon Feb 24, 2020 9:51 pm
  • Replies 4
  • Views 189
Re: Customer Discount (%) to my XML Order Export

okay i see. and how to query the customer table too with the order table? i want only the discount value from customer table :S

Jump to post
  • Sun Feb 23, 2020 3:53 am
  • Replies 4
  • Views 363
Re: Add new line from customer table to XML Order Export link

okay i see. and how to query the customer table too with the order table? i want only the discount value from customer table :S

Jump to post
  • Sun Feb 23, 2020 3:53 am
  • Replies 7
  • Views 349
[EXTENSION] XML ORDER EXPORT

I want to get one value from other table. how can i do it? oc3.0.3.1 Here is the start code: $sql = "SELECT * FROM `" . DB_PREFIX . "order` WHERE 1 = 1"; i want the 'order' table and the 'discount' (FLOAT(16,2)) value from 'customer' table. The 'discount' value is from 'customer' table. if($item == ...

Jump to post
  • Sun Feb 23, 2020 3:30 am
  • Replies 1
  • Views 181
SQL Query right syntax

Im beginner. What is the right syntax? I want to get the discount. Table: customer Column: discount public function getCustomerDiscount($customer_id,$customer_group_id) { $xml = ''; $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "customer WHERE discount = '".(int)$discount."'"); $customer ...

Jump to post
  • Sun Feb 23, 2020 1:45 am
  • Replies 5
  • Views 332
Add new line from customer table to XML Order Export link

Hello guys. im very beginner. I have a discount value on my customer table (for all products). I want to add the discount line to an XML link. I tried a lot, but i dont know what im doing.. :) if($item == 'discount'){$xml .= ''.htmlspecialchars($order['discount']).''."\n";} Example: 31.03 (this valu...

Jump to post
  • Fri Feb 21, 2020 11:35 pm
  • Replies 7
  • Views 349
Opencart Discount price see only at the product page

I have an extension. Customer discount. I want to see the discounted product price at the cart and at the bill. How can i do it? :S see what i want: http://www.kepfeltoltes.eu/images/2020/02/21/689K_pkiv_g_s.png class ModelExtensionTotalCustomerDiscount extends Model { public function getTotal($tota...

Jump to post
  • Fri Feb 21, 2020 11:20 pm
  • Replies 2
  • Views 119
Customer Discount (%) to my XML Order Export

Hello. I have a discount line what is in the oc_customer table. Name: discount Type: float(16,2) Value: 33.33 I have an XML Order Export and i want to display that value. I see the DISCOUNT line but the velue not visible. $export_items['xml_export_order_items'][] = 'products'; $sql = "SELECT * FROM ...

Jump to post
  • Fri Feb 21, 2020 4:25 pm
  • Replies 4
  • Views 363
Re: Different text for different customer group

Maybe you have not customer_group_id there, try something like this: {% if order.customer_group_id is defined %} it is defined {% else %} it is not defined {% endif %} if it is not defined, you need to add it in your controller file. i changed to this, now i see only text_invoice_1 for every custom...

Jump to post
  • Thu Oct 10, 2019 4:37 am
  • Replies 4
  • Views 289
Re: Different text for different customer group

doesnt work :/

DigitCart wrote:
Thu Oct 10, 2019 3:33 am
Hi
use:

Code: Select all

{% if order.customer_group_id == '1' %}

Jump to post
  • Thu Oct 10, 2019 3:50 am
  • Replies 4
  • Views 289
Different text for different customer group

This code is right? OC.3.0.3.1 Invoice - Different text for different customer groups. order_invoice.twig {% for order in orders %} <div style="page-break-after: always;"> {% if customer_group_id == '1' %} <h6 align="center" style="text-align:center;">{{ text_invoice }}</h6> {% endif %} {% if custom...

Jump to post
  • Thu Oct 10, 2019 2:56 am
  • Replies 4
  • Views 289
How do I print different text for different customer groups?

Hello! How do I print different text for different customer group? OC3.0.3.1
At the product page or invoice. Anywhere.

Example:
Customer_Group1 text: Welcome Reseller ("or my Friend")!
Customer_Group2 text: Welcome simple customer!

Jump to post
  • Thu Oct 10, 2019 2:04 am
  • Replies 1
  • Views 188
Re: VQMOD Extension FATAL ERROR OC3

Thy! I want to delete the vqmod cache files, but i get error. I cant delete.

Jump to post
  • Sun Apr 07, 2019 2:18 pm
  • Replies 17
  • Views 782
VQMOD Extension FATAL ERROR OC3

I dont know how to resolve.. OC 3.0.3.1 When i refreshed modifications my site is broken: Fatal error: Uncaught ArgumentCountError: Too few arguments to function Template::__construct(), 1 passed in /var/www/clients/client1/web1/web/vqmod/vqcache/vq2-system_engine_loader.php on line 119 and exactly ...

Jump to post
  • Sat Apr 06, 2019 11:39 pm
  • Replies 17
  • Views 782

Page 1 of 1

Search found 16 matches