private function deleteInvoice()
{
if ($this->invMdl->remove($this->id) === false) {
return false;
}
$itemMdl = new SaleItemsModel();
if ($itemMdl->removeBySale($this->id) === false) {
return false;
}
$payMdl = new SalePaymentsModel();
if ($payMdl->removeBySale($this->id) === false) {
return false;
}
$voidMdl = new SaleVoidsModel();
if ($voidMdl->removeBySale($this->id) === false) {
return false;
}
$histMdl = new TransHistModel();
if ($histMdl->removeBySale($this->id) === false) {
return false;
}
return true;
}
/**
* Remove all records associated with a transaction
* @return bool
*/
private function deleteTransactionRecords()
{
$transMdl = new TransactionsModel();
if ($transMdl->remove($this->data->id) === false) {
return false;
}
$itemMdl = new SaleItemsModel();
if ($itemMdl->removeBySale($this->data->id) === false) {
return false;
}
$payMdl = new SalePaymentsModel();
if ($payMdl->removeBySale($this->data->id) === false) {
return false;
}
$voidMdl = new SaleVoidsModel();
if ($voidMdl->removeBySale($this->data->id) === false) {
return false;
}
$histMdl = new TransHistModel();
if ($histMdl->removeBySale($this->data->id) === false) {
return false;
}
return true;
}
/**
* Remove all transaction records associated with a sale
* @return bool
*/
private function removeTransactionRecords()
{
$itemsMdl = new SaleItemsModel();
$payMdl = new SalePaymentsModel();
if ($this->salesMdl->remove($this->id) !== false) {
if ($payMdl->removeBySale($this->id) !== false) {
if ($itemsMdl->removeBySale($this->id) !== false) {
return true;
}
}
}
return false;
}
/**
* Removes the transaction record and all associated records
* @param $saleid
* @return bool|int Returns false on failure or number of rows affected on success
*/
public function remove($saleid)
{
$sql = "DELETE FROM `sales` WHERE `id` = :saleid";
$placeholders = [":saleid" => $saleid];
// Remove associated records
$saleItemsMdl = new SaleItemsModel();
$salePaymentsMdl = new SalePaymentsModel();
$saleVoidMdl = new SaleVoidsModel();
if (($result = $saleVoidMdl->removeBySale($saleid)) !== false) {
if (($result = $salePaymentsMdl->removeBySale($saleid)) !== false) {
$result = $saleItemsMdl->removeBySale($saleid);
}
}
if ($result !== false) {
return $this->delete($sql, $placeholders);
} else {
return $result;
}
}
