/**
* Add new transaction.
*
* @access public
* @param string $status
* @param integer $invoiceNumber
* @param integer $invoiceCurrency
* @param integer $invoiceAmount
* @param string $contactTitle
* @param string $contactForename
* @param string $contactSurname
* @param string $contactCompany
* @param string $contactStreet
* @param string $contactPostcode
* @param string $contactPlace
* @param integer $contactCountry
* @param string $contactPhone
* @param string $contactEmail
* @return integer id of inserted record
* @return boolean status of insertion
*/
public function add($status, $invoiceNumber, $invoiceCurrency, $invoiceAmount, $contactTitle, $contactForename, $contactSurname, $contactCompany, $contactStreet, $contactPostcode, $contactPlace, $contactCountry, $contactPhone, $contactEmail)
{
$objResult = $this->objDatabase->Execute('
INSERT INTO `' . DBPREFIX . 'module_checkout_transactions`
(
`time`,
`status`,
`invoice_number`,
`invoice_currency`,
`invoice_amount`,
`contact_title`,
`contact_forename`,
`contact_surname`,
`contact_company`,
`contact_street`,
`contact_postcode`,
`contact_place`,
`contact_country`,
`contact_phone`,
`contact_email`
)
VALUES
(
' . time() . ',
"' . contrexx_raw2db($status) . '",
"' . contrexx_raw2db($invoiceNumber) . '",
' . intval($invoiceCurrency) . ',
' . intval($invoiceAmount * 100) . ',
"' . contrexx_raw2db($contactTitle) . '",
"' . contrexx_raw2db($contactForename) . '",
"' . contrexx_raw2db($contactSurname) . '",
"' . contrexx_raw2db($contactCompany) . '",
"' . contrexx_raw2db($contactStreet) . '",
"' . contrexx_raw2db($contactPostcode) . '",
"' . contrexx_raw2db($contactPlace) . '",
' . intval($contactCountry) . ',
"' . contrexx_raw2db($contactPhone) . '",
"' . contrexx_raw2db($contactEmail) . '"
)
');
if ($objResult) {
return $this->objDatabase->Insert_ID();
} else {
return false;
}
}
