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;
}
public function save($params, $payment_id = 0)
{
$returnArray = array();
// Adjust the params for the further DB usage.
foreach ($params as $key => $value) {
$params[$key] = $this->db->res($value);
}
util_UtilFunctions::p($params);
$validationArray = $this->validate($params);
if (empty($validationArray) === FALSE) {
$returnArray['result'] = FALSE;
$returnArray['error'] = implode(' ', $validationArray);
} else {
// Check if we are adding a new Payment or updating an old one.
if ((int) $payment_id > 0) {
$query = '
UPDATE payment
SET
date = ' . $this->db->quote(util_UtilFunctions::dateFormat($params['date'], 'sql')) . ',
paid_amount = ' . (double) $params['paid_amount'] . ',
bank_name = ' . $this->db->quote($params['bank_name']) . ',
extras = ' . $this->db->quote($params['extras']) . '
WHERE id = ' . (int) $payment_id . '
';
} else {
$query = '
INSERT INTO payment (id, date, paid_amount, bank_name, extras)
VALUES (
DEFAULT,
' . $this->db->quote(util_UtilFunctions::dateFormat($params['date'], 'sql')) . ',
' . (double) $params['paid_amount'] . ',
' . $this->db->quote($params['bank_name']) . ',
' . $this->db->quote($params['extras']) . '
)';
}
$result = $this->db->query($query);
$returnArray = array();
$returnArray['result'] = $result;
$returnArray['error'] = $this->db->error();
}
return $returnArray;
}
public function save($params, $shipment_id = 0)
{
$returnArray = array();
// Adjust the params for the further DB usage.
foreach ($params as $key => $value) {
$params[$key] = $this->db->res($value);
}
$validationArray = $this->validate($params);
if (empty($validationArray) === FALSE) {
$returnArray['result'] = FALSE;
$returnArray['error'] = implode(' ', $validationArray);
} else {
// Check if we are adding a new Customer or updating an old one.
if ((int) $shipment_id > 0) {
$query = '
UPDATE shipment SET
number = ' . $this->db->quote($params['number']) . ',
date = ' . $this->db->quote(util_UtilFunctions::dateFormat($params['date'], 'sql')) . ',
transport_charge = ' . (double) $params['transport_charge'] . ',
extras = ' . $this->db->quote($params['extras']) . '
WHERE id = ' . (int) $shipment_id . '';
} else {
$query = '
INSERT INTO shipment (id, number, date, transport_charge, extras)
VALUES (
DEFAULT,
' . $this->db->quote($params['number']) . ',
' . $this->db->quote(util_UtilFunctions::dateFormat($params['date'], 'sql')) . ',
' . (double) $params['transport_charge'] . ',
' . $this->db->quote($params['extras']) . '
)';
}
$result = $this->db->query($query);
$returnArray = array();
$returnArray['result'] = $result;
$returnArray['error'] = $this->db->error();
}
return $returnArray;
}
/**
* @return string
*/
public function generateHTML($options = array())
{
$string = '<select id=\'' . $this->id . '\' name=\'' . $this->name . '\' class=\'' . $this->css_class . '\'>';
if (empty($options) === FALSE) {
foreach ($options as $index => $row) {
if ((int) $this->selected_id === (int) $row['id']) {
$string .= '<option selected=\'selected\' value=\'' . $row['id'] . '\'>' . $row['sf_option'] . '</option>';
} else {
$string .= '<option value=\'' . $row['id'] . '\'>' . $row['sf_option'] . '</option>';
}
}
}
$string .= '</select>';
$script = '$(function() {
$(\'#' . $this->id . '\').select2({
placeholder: \'' . $this->placeHolder . '\'
});
});';
$string .= '<script>' . $script . '</script>';
util_UtilFunctions::p($string);
return $string;
}
public function save($params, $deal_id = 0)
{
$returnArray = array();
// Adjust the params for the further DB usage.
foreach ($params as $key => $value) {
$params[$key] = $this->db->res($value);
}
util_UtilFunctions::p($params);
$validationArray = $this->validate($params);
if (empty($validationArray) === FALSE) {
$returnArray['result'] = FALSE;
$returnArray['error'] = implode(' ', $validationArray);
} else {
// Check if we are adding a new Customer or updating an old one.
if ((int) $deal_id > 0) {
$query = '
UPDATE deal SET
customer_id = ' . (int) $params['customer_id'] . ',
article_id = ' . (int) $params['article_id'] . ',
amount = ' . (int) $params['amount'] . ',
total_price = ' . (double) $params['total_price'] . ',
platform_name = ' . $this->db->quote($params['platform_name']) . ',
commented = ' . (int) $params['commented'] . ',
status = ' . (int) $params['status'] . ',
extras = ' . $this->db->quote($params['extras']) . '
WHERE id = ' . (int) $deal_id . '
';
} else {
// Save deal with shipment and payment.
$query = '
INSERT INTO shipment (id, number, date, transport_charge, extras)
VALUES (
DEFAULT,
0,
\'0000-00-00\',
0,
\'\'
)';
$result = $this->db->query($query);
if ($result === FALSE) {
$returnArray = array();
$returnArray['result'] = $result;
$returnArray['error'] = $this->db->error();
return $returnArray;
}
$last_shipment_id = $this->db->getLastId();
$query = '
INSERT INTO payment (id, date, paid_amount, bank_name, extras)
VALUES (
DEFAULT,
\'0000-00-00\',
0,
\'\',
\'\'
)';
$result = $this->db->query($query);
if ($result === FALSE) {
$returnArray = array();
$returnArray['result'] = $result;
$returnArray['error'] = $this->db->error();
return $returnArray;
}
$last_payment_id = $this->db->getLastId();
$query = '
INSERT INTO deal (id, customer_id, article_id, payment_id, shipment_id, amount, total_price, platform_name, commented, status, extras)
VALUES (
DEFAULT,
' . (int) $params['customer_id'] . ',
' . (int) $params['article_id'] . ',
' . (int) $last_payment_id . ',
' . (int) $last_shipment_id . ',
' . (int) $params['amount'] . ',
' . (double) $params['total_price'] . ',
' . $this->db->quote($params['platform_name']) . ',
' . (int) $params['commented'] . ',
' . (int) $params['status'] . ',
' . $this->db->quote($params['extras']) . '
)';
}
$result = $this->db->query($query);
$returnArray = array();
$returnArray['result'] = $result;
$returnArray['error'] = $this->db->error();
}
return $returnArray;
}
public function getResult()
{
$return = array('messages' => array('info' => '', 'success' => '', 'danger' => ''));
$target_dir = "images/article/";
$image_name = strtolower(basename($this->params["input_image"]["name"]));
util_UtilFunctions::p($image_name);
$image_name = strtolower(end(explode('/', $this->params["input_image"]["name"])));
util_UtilFunctions::p($image_name);
$target_file = $target_dir . $image_name;
$uploadOk = 1;
$imageFileType = strtolower(pathinfo($target_file, PATHINFO_EXTENSION));
// Check if image file is a actual image or fake image
if (isset($_POST["submit"])) {
$check = getimagesize($this->params["input_image"]["tmp_name"]);
if ($check !== false) {
$return['messages']['info'] = "File is an image - " . $check["mime"] . ".";
$uploadOk = 1;
} else {
$return['messages']['danger'] = "File is not an image. ";
$uploadOk = 0;
}
}
// Check if file already exists
if (file_exists($target_file)) {
$return['messages']['danger'] .= "Sorry, file already exists. ";
$uploadOk = 0;
}
// Check file size
if ($this->params["input_image"]["size"] > 5000000) {
$return['messages']['danger'] .= "Sorry, your file is too large. ";
$uploadOk = 0;
}
// Allow certain file formats
if ($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg" && $imageFileType != "gif") {
$return['messages']['danger'] .= "Sorry, only JPG, JPEG, PNG & GIF files are allowed. ";
$uploadOk = 0;
}
// Check if $uploadOk is set to 0 by an error
if ($uploadOk == 0) {
$return['messages']['danger'] .= "Sorry, your file was not uploaded. ";
// if everything is ok, try to upload file
} else {
if (move_uploaded_file($this->params["input_image"]["tmp_name"], $target_file)) {
$return['messages']['success'] = "The file " . basename($this->params["input_image"]["name"]) . " has been uploaded. ";
$uploadOk = 1;
} else {
$return['messages']['danger'] .= "Sorry, there was an error uploading your file.";
}
}
// Add a reference to the DB.
$query = 'UPDATE article
SET
image_path = \'article/' . $image_name . '\'
WHERE id = ' . $this->params['article_id'] . '
';
$result = $this->db->query($query);
if ($result === TRUE) {
$return['messages']['success'] .= "The reference was successfully added to the article.";
} else {
$return['messages']['danger'] .= "Couldn't assign a reference to the image in the DB.";
}
return json_encode($return);
}