public function generateResponse()
{
$columns = array();
$rows = array();
$columns[] = array('sTitle' => 'Покупатель', 'aTargets' => array('0'), 'mData' => 'customer_name', 'sType' => 'string');
$columns[] = array('sTitle' => 'Дата', 'aTargets' => array('1'), 'mData' => 'date', 'sType' => 'date', 'sClass' => 'right');
$columns[] = array('sTitle' => 'Сумма', 'aTargets' => array('2'), 'mData' => 'paid_amount', 'sClass' => 'right', 'bSum' => TRUE);
$columns[] = array('sTitle' => 'Банк', 'aTargets' => array('3'), 'mData' => 'bank_name', 'sType' => 'string');
$columns[] = array('sTitle' => 'Доп. инфо', 'aTargets' => array('4'), 'mData' => 'extras', 'sType' => 'string');
$query = 'SELECT payment.id,
(
CONCAT(customer.last_name, \' \', customer.first_name, \', \', email)
) AS customer_name,
DATE_FORMAT(payment.date,\'%d.%m.%Y\') AS date,
payment.paid_amount,
payment.bank_name,
payment.extras
FROM deal
JOIN payment ON payment.id = deal.payment_id
JOIN customer ON customer.id = deal.customer_id
WHERE deal.status = 1
ORDER BY id';
$rows = $this->db->select($query);
$headerClasses = array();
$headerClasses = util_UtilFunctions::getTHClasses($columns);
$return['headerClasses'] = $headerClasses;
$return['rows'] = $rows;
$return['columns'] = $columns;
return $return;
}
public function generateResponse()
{
$columns = array();
$rows = array();
$columns[] = array('sTitle' => 'ФИО', 'aTargets' => array('0'), 'mData' => 'full_name', 'sType' => 'string');
$columns[] = array('sTitle' => 'Ник', 'aTargets' => array('1'), 'mData' => 'nick_name', 'sType' => 'string');
$columns[] = array('sTitle' => 'email', 'aTargets' => array('2'), 'mData' => 'email', 'sType' => 'string');
$columns[] = array('sTitle' => 'Адрес', 'aTargets' => array('3'), 'mData' => 'full_address', 'sType' => 'string');
$columns[] = array('sTitle' => 'Телефон', 'aTargets' => array('4'), 'mData' => 'phone', 'sType' => 'number');
$columns[] = array('sTitle' => 'Доп. инфо', 'aTargets' => array('5'), 'mData' => 'extras', 'sType' => 'string');
$query = 'SELECT
customer.id,
customer.last_name,
customer.first_name,
customer.middle_name,
(
CONCAT (customer.last_name, \' \', customer.first_name, \' \', customer.middle_name)
) AS full_name,
customer.nick_name,
customer.email,
customer.extras,
contact.street,
contact.street_number,
contact.room_number,
contact.city,
contact.zip_code,
contact.country,
(
CONCAT (
contact.street,
\' \',
contact.street_number,
\', кв. \',
contact.room_number,
\', \',
contact.city,
\', \',
contact.zip_code,
\', \',
contact.country)
) AS full_address,
contact.phone
FROM customer
LEFT OUTER JOIN contact ON contact.customer_id = customer.id
ORDER BY customer.id';
$rows = $this->db->select($query);
$headerClasses = array();
$headerClasses = util_UtilFunctions::getTHClasses($columns);
$return['headerClasses'] = $headerClasses;
$return['rows'] = $rows;
$return['columns'] = $columns;
return $return;
}
