--[[----------------------------------------------------------------------------

WFCatSortByFileName.lua

--------------------------------------------------------------------------------

ADOBE CONFIDENTIAL
------------------
Copyright 2018 Adobe Systems Incorporated
All Rights Reserved.

NOTICE: All information contained herein is, and remains the property of
Adobe Systems Incorporated and its suppliers, if any. The intellectual and
technical concepts contained herein are proprietary to Adobe Systems
Incorporated and its suppliers and are protected by all applicable
intellectual property laws, including trade secret and copyright laws.
Dissemination of this information or reproduction of this material is
strictly forbidden unless prior written permission is obtained from
Adobe Systems Incorporated.

----------------------------------------------------------------------------]]--

--==============================================================================

local WFCatSortByFileName = {}

--------------------------------------------------------------------------------

function WFCatSortByFileName.executeSort( wfCatalog, assetIds, order )

	if order ~= "ASC" then
		order = "DESC"
	end
	
	local sqlString = string.format(
			[[ SELECT assets.docId, assets.fileNameLC
				FROM TEMP_ids 
				LEFT JOIN assets ON assets.docId = TEMP_ids.docId 
				ORDER BY assets.filenameLC COLLATE i18n_collate %s, assets.docId %s ]],
				order, order )

	return wfCatalog:indexStore():query( {
			sql = sqlString,
			tempIds = assetIds,
			calm = 1,
		} )
	
end
	

--==============================================================================

return WFCatSortByFileName
