DealContactTable::unbindAllDeals

static function unbindAllDeals($contactID)
{
	$contactID = (int)$contactID;
	if($contactID <= 0)
	{
		throw new Main\ArgumentException('Must be greater than zero', 'contactID');
	}

	$connection = Main\Application::getConnection();
	$connection->queryExecute(
	/** @lang text */
		"DELETE FROM b_crm_deal_contact WHERE CONTACT_ID = {$contactID}"
	);
	$connection->queryExecute(
	/** @lang text */
		"UPDATE b_crm_deal SET CONTACT_ID =
		(SELECT MIN(CONTACT_ID) FROM b_crm_deal_contact t WHERE t.DEAL_ID = b_crm_deal.ID)
		WHERE CONTACT_ID = {$contactID}"
	);
}