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; }