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