public static function deletePendingContractByInvoiceID($invoiceID, $userSID, $productSID) { $contracts = SJB_DB::query("SELECT id FROM `contracts` WHERE `invoice_id` = ?s AND `user_sid` = ?s AND `product_sid` = ?n AND `status` = 'pending'", $invoiceID, $userSID, $productSID); foreach ($contracts as $contract) { SJB_ContractManager::deleteContractIDFromNotificationSended($contract['id']); } return SJB_DB::query("DELETE FROM `contracts` WHERE `invoice_id` = ?s AND `user_sid` = ?s AND `product_sid` = ?n AND `status` = 'pending'", $invoiceID, $userSID, $productSID); }