Answer the question
In order to leave comments, you need to log in
How to place rangeSelector at the bottom of the graph?
I think I've tried everything already. Yes, there are the following options:
buttonPosition: {
x: 100,
y: 200
}
Answer the question
In order to leave comments, you need to log in
most likely, the parent divok has
a piece of the range selector and disappears.
Sampling for all customer_ids, to clarify - add where p.user_id=33
for the user and / or where p.customer_id=2
for the customer.
Such a selection does NOT output null fields.
select p.customer_id, p.`status`, count(p.id)
from 247250_Products p
group by p.customer_id, p.`status`
select s.customer_id, s.status_name,
IFNULL((select count(id) from 247250_Products p where p.`status`= s.status_name),0) as 'count'
from 247250_Statuses s
hello
try this
$userArr = implode(",", $array(66,1,33,54));
SELECT s.id, s.customer_id, s.status, COUNT(s.status) AS count
FROM statuses AS s
INNER JOIN products AS p ON (p.status = s.status_name)
WHERE s.customer_id = 1 AND p.modified BETWEEN "2015-08-10" AND "2015-09-10" AND p.user_id IN ($userArr)
GROUP BY s.status
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question