/** * Sort all files of an item by name. * * @param Item $item * @param boolean $mixFileTypes * * @return void */ protected function _sortFiles($item, $mixFileTypes = false) { if ($item->fileCount() < 2) { return; } if ($mixFileTypes) { $list = $item->Files; BookReader_Creator::sortFilesByOriginalName($list, false); } else { $bookreader = new BookReader($item); // Get leaves and remove blank ones. $leaves = array_filter($bookreader->getLeaves()); $non_leaves = array_filter($bookreader->getNonLeaves()); // Manage the case where there is no BookReader data. if (empty($leaves) && empty($non_leaves)) { $list = $item->Files; BookReader_Creator::sortFilesByOriginalName($list, false); } else { // Order them separately. BookReader_Creator::sortFilesByOriginalName($leaves, false); BookReader_Creator::sortFilesByOriginalName($non_leaves, false); // Finally, merge them. $list = array_merge($leaves, $non_leaves); } } // To avoid issues with unique index when updating (order should be // unique for each file of an item), all orders are reset to null before // true process. $db = $this->_db; $bind = array($item->id); $sql = "\n UPDATE `{$db->File}` files\n SET files.order = NULL\n WHERE files.item_id = ?\n "; $db->query($sql, $bind); // To avoid multiple updates, a single query is used. foreach ($list as &$file) { $file = $file->id; } // The array is made unique, because a leaf can be repeated. $list = implode(',', array_unique($list)); $sql = "\n UPDATE `{$db->File}` files\n SET files.order = FIND_IN_SET(files.id, '{$list}')\n WHERE files.id in ({$list})\n "; $db->query($sql); }