ContactCompanyTable::unbindAllContacts

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

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