';
$output .= '
';
}
return $output;
}
public function viewcustomer_thread()
{
global $cookie, $currentIndex;
if (!($thread = $this->loadObject()))
return;
$cookie->{'customer_threadFilter_cl!id_contact'} = $thread->id_contact;
$employees = Db::getInstance()->ExecuteS('
SELECT e.id_employee, e.firstname, e.lastname FROM '._DB_PREFIX_.'employee e
WHERE e.active = 1 ORDER BY e.lastname ASC');
echo '
'.$this->l('Messages').'
';
$messages = Db::getInstance()->ExecuteS('
SELECT ct.*, cm.*, cl.name subject, CONCAT(e.firstname, \' \', e.lastname) employee_name, CONCAT(c.firstname, \' \', c.lastname) customer_name, c.firstname
FROM '._DB_PREFIX_.'customer_thread ct
LEFT JOIN '._DB_PREFIX_.'customer_message cm ON (ct.id_customer_thread = cm.id_customer_thread)
LEFT JOIN '._DB_PREFIX_.'contact_lang cl ON (cl.id_contact = ct.id_contact AND cl.id_lang = '.(int)$cookie->id_lang.')
LEFT JOIN '._DB_PREFIX_.'employee e ON e.id_employee = cm.id_employee
LEFT JOIN '._DB_PREFIX_.'customer c ON (IFNULL(ct.id_customer, ct.email) = IFNULL(c.id_customer, c.email))
WHERE ct.id_customer_thread = '.(int)Tools::getValue('id_customer_thread').'
ORDER BY cm.date_add DESC');
echo '
';
if ($thread->id_customer)
{
$customer = new Customer($thread->id_customer);
$products = $customer->getBoughtProducts();
$orders = Order::getCustomerOrders($customer->id);
echo '
';
if ($orders AND sizeof($orders))
{
$totalOK = 0;
$ordersOK = array();
$tokenOrders = Tools::getAdminToken('AdminOrders'.(int)(Tab::getIdFromClassName('AdminOrders')).(int)($cookie->id_employee));
foreach ($orders as $order)
if ($order['valid'])
{
$ordersOK[] = $order;
$totalOK += $order['total_paid_real'];
}
if ($countOK = sizeof($ordersOK))
{
echo '
'.$this->l('Orders').'
| '.$this->l('ID').' |
'.$this->l('Date').' |
'.$this->l('Products').' |
'.$this->l('Total paid').' |
'.$this->l('Payment').' |
'.$this->l('State').' |
'.$this->l('Actions').' |
';
$irow = 0;
foreach ($ordersOK AS $order)
echo '
| '.$order['id_order'].' |
'.Tools::displayDate($order['date_add'], (int)($cookie->id_lang)).' |
'.$order['nb_products'].' |
'.Tools::displayPrice($order['total_paid_real'], new Currency((int)($order['id_currency']))).' |
'.$order['payment'].' |
'.$order['order_state'].' |
 |
';
echo '
'.$this->l('Validated Orders:').' '.$countOK.' '.$this->l('for').' '.Tools::displayPrice($totalOK, new Currency(_PS_CURRENCY_DEFAULT_)).'
';
}
}
if ($products AND sizeof($products))
{
echo '
'.$this->l('Products').'
| '.$this->l('Date').' |
'.$this->l('ID').' |
'.$this->l('Name').' |
'.$this->l('Quantity').' |
'.$this->l('Actions').' |
';
$irow = 0;
$tokenOrders = Tools::getAdminToken('AdminOrders'.(int)(Tab::getIdFromClassName('AdminOrders')).(int)($cookie->id_employee));
foreach ($products AS $product)
echo '
| '.Tools::displayDate($product['date_add'], (int)($cookie->id_lang), true).' |
'.$product['product_id'].' |
'.$product['product_name'].' |
'.$product['product_quantity'].' |
|
';
echo '
';
}
echo '
';
}
echo '
';
foreach ($messages AS $message)
echo $this->displayMsg($message);
echo '
';
}
private function displayButton($content)
{
return '
';
}
}