PageRenderTime 58ms CodeModel.GetById 16ms RepoModel.GetById 1ms app.codeStats 0ms

/app/models/ca_objects.php

https://bitbucket.org/Sinfin/pawtucket
PHP | 1171 lines | 828 code | 105 blank | 238 comment | 145 complexity | c495a080fd1fa7d38769206b6f350445 MD5 | raw file
Possible License(s): LGPL-3.0, GPL-3.0

Large files files are truncated, but you can click here to view the full file

    

  1. <?php

    2. 

  2. /** ---------------------------------------------------------------------

    3. 

  3.  * app/models/ca_objects.php : table access class for table ca_objects

    4. 

  4.  * ----------------------------------------------------------------------

    5. 

  5.  * CollectiveAccess

    6. 

  6.  * Open-source collections management software

    7. 

  7.  * ----------------------------------------------------------------------

    8. 

  8.  *

    9. 

  9.  * Software by Whirl-i-Gig (http://www.whirl-i-gig.com)

    10. 

  10.  * Copyright 2008-2011 Whirl-i-Gig

    11. 

  11.  *

    12. 

  12.  * For more information visit http://www.CollectiveAccess.org

    13. 

  13.  *

    14. 

  14.  * This program is free software; you may redistribute it and/or modify it under

    15. 

  15.  * the terms of the provided license as published by Whirl-i-Gig

    16. 

  16.  *

    17. 

  17.  * CollectiveAccess is distributed in the hope that it will be useful, but

    18. 

  18.  * WITHOUT ANY WARRANTIES whatsoever, including any implied warranty of 

    19. 

  19.  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  

    20. 

  20.  *

    21. 

  21.  * This source code is free and modifiable under the terms of 

    22. 

  22.  * GNU General Public License. (http://www.gnu.org/copyleft/gpl.html). See

    23. 

  23.  * the "license.txt" file for details, or visit the CollectiveAccess web site at

    24. 

  24.  * http://www.CollectiveAccess.org

    25. 

  25.  * 

    26. 

  26.  * @package CollectiveAccess

    27. 

  27.  * @subpackage models

    28. 

  28.  * @license http://www.gnu.org/copyleft/gpl.html GNU Public License version 3

    29. 

  29.  * 

    30. 

  30.  * ----------------------------------------------------------------------

    31. 

  31.  */

    32. 

  32.  

    33. 

  33.  /**

    34. 

  34.    *

    35. 

  35.    */

    36. 

  36. 

    37. 

  37. require_once(__CA_LIB_DIR__."/ca/IBundleProvider.php");

    38. 

  38. require_once(__CA_LIB_DIR__."/ca/BundlableLabelableBaseModelWithAttributes.php");

    39. 

  39. require_once(__CA_MODELS_DIR__."/ca_object_representations.php");

    40. 

  40. require_once(__CA_MODELS_DIR__."/ca_objects_x_object_representations.php");

    41. 

  41. 

    42. 

  42. 

    43. 

  43. BaseModel::$s_ca_models_definitions['ca_objects'] = array(

    44. 

  44.  	'NAME_SINGULAR' 	=> _t('object'),

    45. 

  45.  	'NAME_PLURAL' 		=> _t('objects'),

    46. 

  46.  	'FIELDS' 			=> array(

    47. 

  47. 		'object_id' => array(

    48. 

  48. 				'FIELD_TYPE' => FT_NUMBER, 'DISPLAY_TYPE' => DT_HIDDEN, 

    49. 

  49. 				'IDENTITY' => true, 'DISPLAY_WIDTH' => 10, 'DISPLAY_HEIGHT' => 1,

    50. 

  50. 				'IS_NULL' => false, 

    51. 

  51. 				'DEFAULT' => '',

    52. 

  52. 				'LABEL' => 'Object id', 'DESCRIPTION' => 'Unique identifier for the object.'

    53. 

  53. 		),

    54. 

  54. 		'parent_id' => array(

    55. 

  55. 				'FIELD_TYPE' => FT_NUMBER, 'DISPLAY_TYPE' => DT_OMIT, 

    56. 

  56. 				'DISPLAY_WIDTH' => 10, 'DISPLAY_HEIGHT' => 1,

    57. 

  57. 				'IS_NULL' => true, 

    58. 

  58. 				'DEFAULT' => '',

    59. 

  59. 				'LABEL' => 'Parent id', 'DESCRIPTION' => 'Identifier of parent object; is null if object is root of hierarchy.'

    60. 

  60. 		),

    61. 

  61. 		'hier_object_id' => array(

    62. 

  62. 				'FIELD_TYPE' => FT_NUMBER, 'DISPLAY_TYPE' => DT_OMIT, 

    63. 

  63. 				'DISPLAY_WIDTH' => 10, 'DISPLAY_HEIGHT' => 1,

    64. 

  64. 				'IS_NULL' => false, 

    65. 

  65. 				'DEFAULT' => '',

    66. 

  66. 				'LABEL' => 'Object hierarchy', 'DESCRIPTION' => 'Identifier of object that is root of the object hierarchy.'

    67. 

  67. 		),

    68. 

  68. 		'lot_id' => array(

    69. 

  69. 				'FIELD_TYPE' => FT_NUMBER, 'DISPLAY_TYPE' => DT_HIDDEN, 

    70. 

  70. 				'DISPLAY_WIDTH' => 10, 'DISPLAY_HEIGHT' => 1,

    71. 

  71. 				'IS_NULL' => true, 

    72. 

  72. 				'DEFAULT' => '',

    73. 

  73. 				'LABEL' => _t('Lot'), 'DESCRIPTION' => _t('Lot this object belongs to; is null if object is not part of a lot.')

    74. 

  74. 		),

    75. 

  75. 		'locale_id' => array(

    76. 

  76. 				'FIELD_TYPE' => FT_NUMBER, 'DISPLAY_TYPE' => DT_SELECT, 

    77. 

  77. 				'DISPLAY_WIDTH' => 40, 'DISPLAY_HEIGHT' => 1,

    78. 

  78. 				'IS_NULL' => true, 

    79. 

  79. 				'DISPLAY_FIELD' => array('ca_locales.name'),

    80. 

  80. 				'DEFAULT' => '',

    81. 

  81. 				'LABEL' => _t('Locale'), 'DESCRIPTION' => _t('The locale from which the object originates.')

    82. 

  82. 		),

    83. 

  83. 		'source_id' => array(

    84. 

  84. 				'FIELD_TYPE' => FT_NUMBER, 'DISPLAY_TYPE' => DT_SELECT, 

    85. 

  85. 				'DISPLAY_WIDTH' => 10, 'DISPLAY_HEIGHT' => 1,

    86. 

  86. 				'IS_NULL' => true, 

    87. 

  87. 				'DEFAULT' => '',

    88. 

  88. 				'LIST_CODE' => 'object_sources',

    89. 

  89. 				'LABEL' => _t('Source'), 'DESCRIPTION' => _t('Administrative source of object. This value is often used to indicate the administrative sub-division or legacy database from which the object originates, but can also be re-tasked for use as a simple classification tool if needed.')

    90. 

  90. 		),

    91. 

  91. 		'type_id' => array(

    92. 

  92. 				'FIELD_TYPE' => FT_NUMBER, 'DISPLAY_TYPE' => DT_SELECT, 

    93. 

  93. 				'DISPLAY_WIDTH' => 10, 'DISPLAY_HEIGHT' => 1,

    94. 

  94. 				'IS_NULL' => false, 

    95. 

  95. 				'DEFAULT' => '',

    96. 

  96. 				'LIST_CODE' => 'object_types',

    97. 

  97. 				'LABEL' => _t('Type'), 'DESCRIPTION' => _t('The type of the object. In CollectiveAccess every object has a single "instrinsic" type that determines the set of descriptive, technical and administrative metadata that can be applied to it. As such this type is "low-level" and directly tied to the form of the object - eg. photograph, book, analog video recording, etc.')

    98. 

  98. 		),

    99. 

  99. 		'idno' => array(

    100. 

  100. 				'FIELD_TYPE' => FT_TEXT, 'DISPLAY_TYPE' => DT_FIELD, 

    101. 

  101. 				'DISPLAY_WIDTH' => 40, 'DISPLAY_HEIGHT' => 1,

    102. 

  102. 				'IS_NULL' => false, 

    103. 

  103. 				'DEFAULT' => '',

    104. 

  104. 				'LABEL' => _t('Object identifier'), 'DESCRIPTION' => _t('A unique alphanumeric identifier for this object. This is usually equivalent to the "accession number" in museum settings.'),

    105. 

  105. 				'BOUNDS_LENGTH' => array(0,255)

    106. 

  106. 		),

    107. 

  107. 		'idno_sort' => array(

    108. 

  108. 				'FIELD_TYPE' => FT_TEXT, 'DISPLAY_TYPE' => DT_OMIT, 

    109. 

  109. 				'DISPLAY_WIDTH' => 40, 'DISPLAY_HEIGHT' => 1,

    110. 

  110. 				'IS_NULL' => false, 

    111. 

  111. 				'DEFAULT' => '',

    112. 

  112. 				'LABEL' => 'Sortable object identifier', 'DESCRIPTION' => 'Value used for sorting objects on identifier value.',

    113. 

  113. 				'BOUNDS_LENGTH' => array(0,255)

    114. 

  114. 		),

    115. 

  115. 		'item_status_id' => array(

    116. 

  116. 				'FIELD_TYPE' => FT_NUMBER, 'DISPLAY_TYPE' => DT_SELECT, 

    117. 

  117. 				'DISPLAY_WIDTH' => 40, 'DISPLAY_HEIGHT' => 1,

    118. 

  118. 				'IS_NULL' => true, 

    119. 

  119. 				'DEFAULT' => '',

    120. 

  120. 				'LIST_CODE' => 'object_statuses',

    121. 

  121. 				'LABEL' => _t('Accession status'), 'DESCRIPTION' => _t('Indicates accession/collection status of object. (eg. accessioned, pending accession, loan, non-accessioned item, etc.)')

    122. 

  122. 		),

    123. 

  123. 		'acquisition_type_id' => array(

    124. 

  124. 				'FIELD_TYPE' => FT_NUMBER, 'DISPLAY_TYPE' => DT_SELECT, 

    125. 

  125. 				'DISPLAY_WIDTH' => 40, 'DISPLAY_HEIGHT' => 1,

    126. 

  126. 				'IS_NULL' => true, 

    127. 

  127. 				'DEFAULT' => '',

    128. 

  128. 				'LIST_CODE' => 'object_acq_types',

    129. 

  129. 				'LABEL' => _t('Acquisition method'), 'DESCRIPTION' => _t('Indicates method employed to acquire the object.')

    130. 

  130. 		),

    131. 

  131. 		'source_info' => array(

    132. 

  132. 				'FIELD_TYPE' => FT_VARS, 'DISPLAY_TYPE' => DT_OMIT, 

    133. 

  133. 				'DISPLAY_WIDTH' => 88, 'DISPLAY_HEIGHT' => 15,

    134. 

  134. 				'IS_NULL' => false, 

    135. 

  135. 				'DEFAULT' => '',

    136. 

  136. 				'LABEL' => 'Source information', 'DESCRIPTION' => 'Serialized array used to store source information for object information retrieved via web services [NOT IMPLEMENTED YET].'

    137. 

  137. 		),

    138. 

  138. 		'hier_left' => array(

    139. 

  139. 				'FIELD_TYPE' => FT_NUMBER, 'DISPLAY_TYPE' => DT_OMIT, 

    140. 

  140. 				'DISPLAY_WIDTH' => 10, 'DISPLAY_HEIGHT' => 1,

    141. 

  141. 				'IS_NULL' => false, 

    142. 

  142. 				'DEFAULT' => '',

    143. 

  143. 				'LABEL' => 'Hierarchical index - left bound', 'DESCRIPTION' => 'Left-side boundary for nested set-style hierarchical indexing; used to accelerate search and retrieval of hierarchical record sets.'

    144. 

  144. 		),

    145. 

  145. 		'hier_right' => array(

    146. 

  146. 				'FIELD_TYPE' => FT_NUMBER, 'DISPLAY_TYPE' => DT_OMIT, 

    147. 

  147. 				'DISPLAY_WIDTH' => 10, 'DISPLAY_HEIGHT' => 1,

    148. 

  148. 				'IS_NULL' => false, 

    149. 

  149. 				'DEFAULT' => '',

    150. 

  150. 				'LABEL' => 'Hierarchical index - right bound', 'DESCRIPTION' => 'Right-side boundary for nested set-style hierarchical indexing; used to accelerate search and retrieval of hierarchical record sets.'

    151. 

  151. 		),

    152. 

  152. 		'extent' => array(

    153. 

  153. 				'FIELD_TYPE' => FT_NUMBER, 'DISPLAY_TYPE' => DT_FIELD, 

    154. 

  154. 				'DISPLAY_WIDTH' => 20, 'DISPLAY_HEIGHT' => 1,

    155. 

  155. 				'IS_NULL' => false, 

    156. 

  156. 				'DEFAULT' => '',

    157. 

  157. 				'LABEL' => _t('Extent'), 'DESCRIPTION' => _t('The extent of the object. This is typically the number of discrete items that compose the object represented by this record. It is stored as a whole number (eg. 1, 2, 3...).')

    158. 

  158. 		),

    159. 

  159. 		'extent_units' => array(

    160. 

  160. 				'FIELD_TYPE' => FT_TEXT, 'DISPLAY_TYPE' => DT_FIELD, 

    161. 

  161. 				'DISPLAY_WIDTH' => 20, 'DISPLAY_HEIGHT' => 1,

    162. 

  162. 				'IS_NULL' => false, 

    163. 

  163. 				'DEFAULT' => '',

    164. 

  164. 				'LABEL' => _t('Extent units'), 'DESCRIPTION' => _t('Units of extent value. (eg. pieces, items, components, reels, etc.)'),

    165. 

  165. 				'BOUNDS_LENGTH' => array(0,255)

    166. 

  166. 		),

    167. 

  167. 		'access' => array(

    168. 

  168. 				'FIELD_TYPE' => FT_NUMBER, 'DISPLAY_TYPE' => DT_SELECT, 

    169. 

  169. 				'DISPLAY_WIDTH' => 40, 'DISPLAY_HEIGHT' => 1,

    170. 

  170. 				'IS_NULL' => false, 

    171. 

  171. 				'DEFAULT' => 0,

    172. 

  172. 				'BOUNDS_CHOICE_LIST' => array(

    173. 

  173. 					_t('Not accessible to public') => 0,

    174. 

  174. 					_t('Accessible to public') => 1

    175. 

  175. 				),

    176. 

  176. 				'LIST' => 'access_statuses',

    177. 

  177. 				'LABEL' => _t('Access'), 'DESCRIPTION' => _t('Indicates if object is accessible to the public or not.')

    178. 

  178. 		),

    179. 

  179. 		'status' => array(

    180. 

  180. 				'FIELD_TYPE' => FT_NUMBER, 'DISPLAY_TYPE' => DT_SELECT, 

    181. 

  181. 				'DISPLAY_WIDTH' => 40, 'DISPLAY_HEIGHT' => 1,

    182. 

  182. 				'IS_NULL' => false, 

    183. 

  183. 				'DEFAULT' => 0,

    184. 

  184. 				'BOUNDS_CHOICE_LIST' => array(

    185. 

  185. 					_t('Newly created') => 0,

    186. 

  186. 					_t('Editing in progress') => 1,

    187. 

  187. 					_t('Editing complete - pending review') => 2,

    188. 

  188. 					_t('Review in progress') => 3,

    189. 

  189. 					_t('Completed') => 4

    190. 

  190. 				),

    191. 

  191. 				'LIST' => 'workflow_statuses',

    192. 

  192. 				'LABEL' => _t('Status'), 'DESCRIPTION' => _t('Indicates the current state of the object record.')

    193. 

  193. 		),

    194. 

  194. 		'deleted' => array(

    195. 

  195. 				'FIELD_TYPE' => FT_BIT, 'DISPLAY_TYPE' => DT_OMIT, 

    196. 

  196. 				'DISPLAY_WIDTH' => 10, 'DISPLAY_HEIGHT' => 1,

    197. 

  197. 				'IS_NULL' => false, 

    198. 

  198. 				'DEFAULT' => 0,

    199. 

  199. 				'LABEL' => _t('Is deleted?'), 'DESCRIPTION' => _t('Indicates if the object is deleted or not.'),

    200. 

  200. 				'BOUNDS_VALUE' => array(0,1)

    201. 

  201. 		),

    202. 

  202. 		'rank' => array(

    203. 

  203. 				'FIELD_TYPE' => FT_NUMBER, 'DISPLAY_TYPE' => DT_FIELD, 

    204. 

  204. 				'DISPLAY_WIDTH' => 10, 'DISPLAY_HEIGHT' => 1,

    205. 

  205. 				'IS_NULL' => false, 

    206. 

  206. 				'DEFAULT' => '',

    207. 

  207. 				'LABEL' => _t('Sort order'), 'DESCRIPTION' => _t('Sort order'),

    208. 

  208. 		)

    209. 

  209. 	)

    210. 

  210. );

    211. 

  211. 

    212. 

  212. class ca_objects extends BundlableLabelableBaseModelWithAttributes implements IBundleProvider {

    213. 

  213. 	# ---------------------------------

    214. 

  214. 	# --- Object attribute properties

    215. 

  215. 	# ---------------------------------

    216. 

  216. 	# Describe structure of content object's properties - eg. database fields and their

    217. 

  217. 	# associated types, what modes are supported, et al.

    218. 

  218. 	#

    219. 

  219. 

    220. 

  220. 	# ------------------------------------------------------

    221. 

  221. 	# --- Basic object parameters

    222. 

  222. 	# ------------------------------------------------------

    223. 

  223. 	# what table does this class represent?

    224. 

  224. 	protected $TABLE = 'ca_objects';

    225. 

  225. 	      

    226. 

  226. 	# what is the primary key of the table?

    227. 

  227. 	protected $PRIMARY_KEY = 'object_id';

    228. 

  228. 

    229. 

  229. 	# ------------------------------------------------------

    230. 

  230. 	# --- Properties used by standard editing scripts

    231. 

  231. 	# 

    232. 

  232. 	# These class properties allow generic scripts to properly display

    233. 

  233. 	# records from the table represented by this class

    234. 

  234. 	#

    235. 

  235. 	# ------------------------------------------------------

    236. 

  236. 

    237. 

  237. 	# Array of fields to display in a listing of records from this table

    238. 

  238. 	protected $LIST_FIELDS = array('idno');

    239. 

  239. 

    240. 

  240. 	# When the list of "list fields" above contains more than one field,

    241. 

  241. 	# the LIST_DELIMITER text is displayed between fields as a delimiter.

    242. 

  242. 	# This is typically a comma or space, but can be any string you like

    243. 

  243. 	protected $LIST_DELIMITER = ' ';

    244. 

  244. 

    245. 

  245. 	# What you'd call a single record from this table (eg. a "person")

    246. 

  246. 	protected $NAME_SINGULAR;

    247. 

  247. 

    248. 

  248. 	# What you'd call more than one record from this table (eg. "people")

    249. 

  249. 	protected $NAME_PLURAL;

    250. 

  250. 

    251. 

  251. 	# List of fields to sort listing of records by; you can use 

    252. 

  252. 	# SQL 'ASC' and 'DESC' here if you like.

    253. 

  253. 	protected $ORDER_BY = array('idno');

    254. 

  254. 

    255. 

  255. 	# Maximum number of record to display per page in a listing

    256. 

  256. 	protected $MAX_RECORDS_PER_PAGE = 20; 

    257. 

  257. 

    258. 

  258. 	# How do you want to page through records in a listing: by number pages ordered

    259. 

  259. 	# according to your setting above? Or alphabetically by the letters of the first

    260. 

  260. 	# LIST_FIELD?

    261. 

  261. 	protected $PAGE_SCHEME = 'alpha'; # alpha [alphabetical] or num [numbered pages; default]

    262. 

  262. 

    263. 

  263. 	# If you want to order records arbitrarily, add a numeric field to the table and place

    264. 

  264. 	# its name here. The generic list scripts can then use it to order table records.

    265. 

  265. 	protected $RANK = 'rank';

    266. 

  266. 	

    267. 

  267. 	# ------------------------------------------------------

    268. 

  268. 	# Hierarchical table properties

    269. 

  269. 	# ------------------------------------------------------

    270. 

  270. 	protected $HIERARCHY_TYPE				=	__CA_HIER_TYPE_ADHOC_MONO__;

    271. 

  271. 	protected $HIERARCHY_LEFT_INDEX_FLD 	= 	'hier_left';

    272. 

  272. 	protected $HIERARCHY_RIGHT_INDEX_FLD 	= 	'hier_right';

    273. 

  273. 	protected $HIERARCHY_PARENT_ID_FLD		=	'parent_id';

    274. 

  274. 	protected $HIERARCHY_DEFINITION_TABLE	=	'ca_objects';

    275. 

  275. 	protected $HIERARCHY_ID_FLD				=	'hier_object_id';

    276. 

  276. 	protected $HIERARCHY_POLY_TABLE			=	null;

    277. 

  277. 	

    278. 

  278. 	# ------------------------------------------------------

    279. 

  279. 	# Change logging

    280. 

  280. 	# ------------------------------------------------------

    281. 

  281. 	protected $UNIT_ID_FIELD = null;

    282. 

  282. 	protected $LOG_CHANGES_TO_SELF = true;

    283. 

  283. 	protected $LOG_CHANGES_USING_AS_SUBJECT = array(

    284. 

  284. 		"FOREIGN_KEYS" => array(

    285. 

  285. 			'lot_id'

    286. 

  286. 		),

    287. 

  287. 		"RELATED_TABLES" => array(

    288. 

  288. 		

    289. 

  289. 		)

    290. 

  290. 	);

    291. 

  291. 

    292. 

  292. 	# ------------------------------------------------------

    293. 

  293. 	# Labeling

    294. 

  294. 	# ------------------------------------------------------

    295. 

  295. 	protected $LABEL_TABLE_NAME = 'ca_object_labels';

    296. 

  296. 	

    297. 

  297. 	# ------------------------------------------------------

    298. 

  298. 	# Attributes

    299. 

  299. 	# ------------------------------------------------------

    300. 

  300. 	protected $ATTRIBUTE_TYPE_ID_FLD = 'type_id';			// name of type field for this table - attributes system uses this to determine via ca_metadata_type_restrictions which attributes are applicable to rows of the given type

    301. 

  301. 	protected $ATTRIBUTE_TYPE_LIST_CODE = 'object_types';	// list code (ca_lists.list_code) of list defining types for this table

    302. 

  302. 	

    303. 

  303. 	# ------------------------------------------------------

    304. 

  304. 	# Self-relations

    305. 

  305. 	# ------------------------------------------------------

    306. 

  306. 	protected $SELF_RELATION_TABLE_NAME = 'ca_objects_x_objects';

    307. 

  307. 	

    308. 

  308. 	# ------------------------------------------------------

    309. 

  309. 	# ID numbering

    310. 

  310. 	# ------------------------------------------------------

    311. 

  311. 	protected $ID_NUMBERING_ID_FIELD = 'idno';				// name of field containing user-defined identifier

    312. 

  312. 	protected $ID_NUMBERING_SORT_FIELD = 'idno_sort';		// name of field containing version of identifier for sorting (is normalized with padding to sort numbers properly)

    313. 

  313. 	

    314. 

  314. 	# ------------------------------------------------------

    315. 

  315. 	# Search

    316. 

  316. 	# ------------------------------------------------------

    317. 

  317. 	protected $SEARCH_CLASSNAME = 'ObjectSearch';

    318. 

  318. 	protected $SEARCH_RESULT_CLASSNAME = 'ObjectSearchResult';

    319. 

  319. 	

    320. 

  320. 	# ------------------------------------------------------

    321. 

  321. 	# $FIELDS contains information about each field in the table. The order in which the fields

    322. 

  322. 	# are listed here is the order in which they will be returned using getFields()

    323. 

  323. 

    324. 

  324. 	protected $FIELDS;

    325. 

  325. 	

    326. 

  326. 	# ------------------------------------------------------

    327. 

  327. 	# --- Constructor

    328. 

  328. 	#

    329. 

  329. 	# This is a function called when a new instance of this object is created. This

    330. 

  330. 	# standard constructor supports three calling modes:

    331. 

  331. 	#

    332. 

  332. 	# 1. If called without parameters, simply creates a new, empty objects object

    333. 

  333. 	# 2. If called with a single, valid primary key value, creates a new objects object and loads

    334. 

  334. 	#    the record identified by the primary key value

    335. 

  335. 	#

    336. 

  336. 	# ------------------------------------------------------

    337. 

  337. 	public function __construct($pn_id=null) {

    338. 

  338. 		parent::__construct($pn_id);

    339. 

  339. 	}

    340. 

  340. 	# ------------------------------------------------------

    341. 

  341. 	protected function initLabelDefinitions() {

    342. 

  342. 		parent::initLabelDefinitions();

    343. 

  343. 		$this->BUNDLES['ca_object_representations'] = array('type' => 'related_table', 'repeating' => true, 'label' => _t('Media representations'));

    344. 

  344. 		$this->BUNDLES['ca_objects'] = array('type' => 'related_table', 'repeating' => true, 'label' => _t('Related objects'));

    345. 

  345. 		$this->BUNDLES['ca_entities'] = array('type' => 'related_table', 'repeating' => true, 'label' => _t('Related entities'));

    346. 

  346. 		$this->BUNDLES['ca_places'] = array('type' => 'related_table', 'repeating' => true, 'label' => _t('Related places'));

    347. 

  347. 		$this->BUNDLES['ca_occurrences'] = array('type' => 'related_table', 'repeating' => true, 'label' => _t('Related occurrences'));

    348. 

  348. 		$this->BUNDLES['ca_collections'] = array('type' => 'related_table', 'repeating' => true, 'label' => _t('Related collections'));

    349. 

  349. 		$this->BUNDLES['ca_storage_locations'] = array('type' => 'related_table', 'repeating' => true, 'label' => _t('Related storage locations'));

    350. 

  350. 		$this->BUNDLES['ca_loans'] = array('type' => 'related_table', 'repeating' => true, 'label' => _t('Related loans'));

    351. 

  351. 		$this->BUNDLES['ca_movements'] = array('type' => 'related_table', 'repeating' => true, 'label' => _t('Related movements'));

    352. 

  352. 		

    353. 

  353. 		$this->BUNDLES['ca_object_lots'] = array('type' => 'related_table', 'repeating' => true, 'label' => _t('Related lot'));

    354. 

  354. 		$this->BUNDLES['ca_object_events'] = array('type' => 'related_table', 'repeating' => true, 'label' => _t('Related events'));

    355. 

  355. 		

    356. 

  356. 		$this->BUNDLES['ca_list_items'] = array('type' => 'related_table', 'repeating' => true, 'label' => _t('Related vocabulary terms'));

    357. 

  357. 		$this->BUNDLES['ca_sets'] = array('type' => 'special', 'repeating' => true, 'label' => _t('Sets'));

    358. 

  358. 		

    359. 

  359. 		$this->BUNDLES['hierarchy_navigation'] = array('type' => 'special', 'repeating' => false, 'label' => _t('Hierarchy navigation'));

    360. 

  360. 		$this->BUNDLES['hierarchy_location'] = array('type' => 'special', 'repeating' => false, 'label' => _t('Location in hierarchy'));

    361. 

  361. 	}

    362. 

  362. 	# ------------------------------------------------------

    363. 

  363. 	public function delete($pb_delete_related=false){

    364. 

  364. 		// nuke related representations

    365. 

  365. 		foreach($this->getRepresentations() as $va_rep){

    366. 

  366. 			$this->removeRepresentation($va_rep["representation_id"]);

    367. 

  367. 		}

    368. 

  368. 

    369. 

  369. 		return parent::delete($pb_delete_related);

    370. 

  370. 	}

    371. 

  371. 	# ------------------------------------------------------

    372. 

  372. 	/**

    373. 

  373. 	 * @param array $pa_options

    374. 

  374. 	 *		duplicate_media

    375. 

  375. 	 */

    376. 

  376. 	public function duplicate($pa_options=null) {

    377. 

  377. 		$vb_we_set_transaction = false;

    378. 

  378. 		if (!$this->inTransaction()) {

    379. 

  379. 			$this->setTransaction($o_t = new Transaction($this->getDb()));

    380. 

  380. 			$vb_we_set_transaction = true;

    381. 

  381. 		} else {

    382. 

  382. 			$o_t = $this->getTransaction();

    383. 

  383. 		}

    384. 

  384. 		

    385. 

  385. 		if ($t_dupe = parent::duplicate($pa_options)) {

    386. 

  386. 			$vb_duplicate_media = isset($pa_options['duplicate_media']) && $pa_options['duplicate_media'];

    387. 

  387. 		

    388. 

  388. 			if ($vb_duplicate_media) { 

    389. 

  389. 				// Try to link representations

    390. 

  390. 				$o_db = $this->getDb();

    391. 

  391. 				

    392. 

  392. 				$qr_res = $o_db->query("

    393. 

  393. 					SELECT *

    394. 

  394. 					FROM ca_objects_x_object_representations

    395. 

  395. 					WHERE object_id = ?

    396. 

  396. 				", (int)$this->getPrimaryKey());

    397. 

  397. 				

    398. 

  398. 				$va_reps = array();

    399. 

  399. 				while($qr_res->nextRow()) {

    400. 

  400. 					$va_reps[$qr_res->get('representation_id')] = $qr_res->getRow();

    401. 

  401. 				}

    402. 

  402. 				

    403. 

  403. 				$t_object_x_rep = new ca_objects_x_object_representations();

    404. 

  404. 				foreach($va_reps as $vn_representation_id => $va_rep) {

    405. 

  405. 					$t_object_x_rep->setMode(ACCESS_WRITE);

    406. 

  406. 					$va_rep['object_id'] = $t_dupe->getPrimaryKey();

    407. 

  407. 					$t_object_x_rep->set($va_rep);

    408. 

  408. 					$t_object_x_rep->insert();

    409. 

  409. 					

    410. 

  410. 					if ($t_object_x_rep->numErrors()) {

    411. 

  411. 						$this->errors = $t_object_x_rep->errors;

    412. 

  412. 						if ($vb_we_set_transaction) { $this->removeTransaction(false);}

    413. 

  413. 						return false;

    414. 

  414. 					}

    415. 

  415. 				}

    416. 

  416. 			}

    417. 

  417. 		}

    418. 

  418. 		

    419. 

  419. 		

    420. 

  420. 		if ($vb_we_set_transaction) { $this->removeTransaction(true);}

    421. 

  421. 		return $t_dupe;

    422. 

  422. 	}

    423. 

  423. 	# ------------------------------------------------------

    424. 

  424. 	

    425. 

  425.  	# ------------------------------------------------------

    426. 

  426.  	# Representations

    427. 

  427.  	# ------------------------------------------------------

    428. 

  428.  	/**

    429. 

  429.  	 * Returns information about representations linked to the currently loaded object. Use this if you want to get the urls, tags and other information for all representations associated with a given object.

    430. 

  430.  	 *

    431. 

  431.  	 * @param array $pa_versions An array of media versions to include information for. If you omit this then a single version, 'preview170', is assumed by default.

    432. 

  432.  	 * @param array $pa_version_sizes Optional array of sizes to force specific versions to. The array keys are version names; the values are arrays with two keys: 'width' and 'height'; if present these values will be used in lieu of the actual values in the database

    433. 

  433.  	 * @param array $pa_options An optional array of options to use when getting representation information. Supported options are:

    434. 

  434.  	 *		return_primary_only - If true then only the primary representation will be returned

    435. 

  435.  	 *		return_with_access - Set to an array of access values to filter representation through; only representations with an access value in the list will be returned

    436. 

  436.  	 *		checkAccess - synonym for return_with_access

    437. 

  437.  	 *		.. and options supported by getMediaTag() .. [they are passed through]

    438. 

  438.  	 *		

    439. 

  439.  	 */

    440. 

  440.  	public function getRepresentations($pa_versions=null, $pa_version_sizes=null, $pa_options=null) {

    441. 

  441.  		if (!($vn_object_id = $this->getPrimaryKey())) { return null; }

    442. 

  442.  		if (!is_array($pa_options)) { $pa_options = array(); }

    443. 

  443.  		

    444. 

  444.  		if (!is_array($pa_versions)) { 

    445. 

  445.  			$pa_versions = array('preview170');

    446. 

  446.  		}

    447. 

  447.  		

    448. 

  448.  		if (isset($pa_options['return_primary_only']) && $pa_options['return_primary_only']) {

    449. 

  449.  			$vs_is_primary_sql = ' AND (caoor.is_primary = 1)';

    450. 

  450.  		} else {

    451. 

  451.  			$vs_is_primary_sql = '';

    452. 

  452.  		}

    453. 

  453.  		

    454. 

  454.  		if ($pa_options['checkAccess']) { $pa_options['return_with_access'] = $pa_options['checkAccess']; }

    455. 

  455.  		if (is_array($pa_options['return_with_access']) && sizeof($pa_options['return_with_access']) > 0) {

    456. 

  456.  			$vs_access_sql = ' AND (caor.access IN ('.join(", ", $pa_options['return_with_access']).'))';

    457. 

  457.  		} else {

    458. 

  458.  			$vs_access_sql = '';

    459. 

  459.  		}

    460. 

  460.  		

    461. 

  461.  		$o_db = $this->getDb();

    462. 

  462.  		

    463. 

  463.  		$qr_reps = $o_db->query("

    464. 

  464.  			SELECT caor.representation_id, caor.media, caoor.is_primary, caor.access, caor.status, l.name, caor.locale_id, caor.media_metadata, caor.type_id, caor.idno, caor.idno_sort

    465. 

  465.  			FROM ca_object_representations caor

    466. 

  466.  			INNER JOIN ca_objects_x_object_representations AS caoor ON caor.representation_id = caoor.representation_id

    467. 

  467.  			LEFT JOIN ca_locales AS l ON caor.locale_id = l.locale_id

    468. 

  468.  			WHERE

    469. 

  469.  				caoor.object_id = ? 

    470. 

  470.  				{$vs_is_primary_sql}

    471. 

  471.  				{$vs_access_sql}

    472. 

  472.  			ORDER BY

    473. 

  473.  				caoor.rank, caoor.is_primary DESC

    474. 

  474.  		", (int)$vn_object_id);

    475. 

  475. 

    476. 

  476.  		$va_reps = array();

    477. 

  477.  		$t_rep = new ca_object_representations();

    478. 

  478.  		while($qr_reps->nextRow()) {

    479. 

  479.  			$vn_rep_id = $qr_reps->get('representation_id');

    480. 

  480.  			

    481. 

  481.  			$va_tmp = $qr_reps->getRow();

    482. 

  482.  			$va_tmp['tags'] = array();

    483. 

  483.  			$va_tmp['urls'] = array();

    484. 

  484.  			

    485. 

  485.  			$va_info = $qr_reps->getMediaInfo('media');

    486. 

  486.  			$va_tmp['info'] = array('original_filename' => $va_info['ORIGINAL_FILENAME']);

    487. 

  487.  			foreach ($pa_versions as $vs_version) {

    488. 

  488.  				if (is_array($pa_version_sizes) && isset($pa_version_sizes[$vs_version])) {

    489. 

  489.  					$vn_width = $pa_version_sizes[$vs_version]['width'];

    490. 

  490.  					$vn_height = $pa_version_sizes[$vs_version]['height'];

    491. 

  491.  				} else {

    492. 

  492.  					$vn_width = $vn_height = 0;

    493. 

  493.  				}

    494. 

  494.  				

    495. 

  495.  				if ($vn_width && $vn_height) {

    496. 

  496.  					$va_tmp['tags'][$vs_version] = $qr_reps->getMediaTag('media', $vs_version, array_merge($pa_options, array('viewer_width' => $vn_width, 'viewer_height' => $vn_height)));

    497. 

  497.  				} else {

    498. 

  498.  					$va_tmp['tags'][$vs_version] = $qr_reps->getMediaTag('media', $vs_version, $pa_options);

    499. 

  499.  				}

    500. 

  500.  				$va_tmp['urls'][$vs_version] = $qr_reps->getMediaUrl('media', $vs_version);

    501. 

  501.  				$va_tmp['paths'][$vs_version] = $qr_reps->getMediaPath('media', $vs_version);

    502. 

  502.  				$va_tmp['info'][$vs_version] = $qr_reps->getMediaInfo('media', $vs_version);

    503. 

  503.  				

    504. 

  504.  				$va_tmp['dimensions'][$vs_version] = caGetRepresentationDimensionsForDisplay($qr_reps, 'original', array());

    505. 

  505.  			}

    506. 

  506.  			

    507. 

  507.  				

    508. 

  508. 			if (isset($va_info['INPUT']['FETCHED_FROM']) && ($vs_fetched_from_url = $va_info['INPUT']['FETCHED_FROM'])) {

    509. 

  509. 				$va_tmp['fetched_from'] = $vs_fetched_from_url;

    510. 

  510. 				$va_tmp['fetched_on'] = (int)$va_info['INPUT']['FETCHED_ON'];

    511. 

  511. 			}

    512. 

  512.  			

    513. 

  513.  			$va_tmp['num_multifiles'] = $t_rep->numFiles($vn_rep_id);

    514. 

  514.  			$va_reps[$vn_rep_id] = $va_tmp;

    515. 

  515.  		}

    516. 

  516.  		

    517. 

  517.  		$va_labels = $t_rep->getPreferredDisplayLabelsForIDs(array_keys($va_reps));

    518. 

  518.  		foreach($va_labels as $vn_rep_id => $vs_label) {

    519. 

  519.  			$va_reps[$vn_rep_id]['label'] = $vs_label;

    520. 

  520.  		}

    521. 

  521.  		return $va_reps;

    522. 

  522.  	}

    523. 

  523.  	# ------------------------------------------------------

    524. 

  524.  	/**

    525. 

  525.  	 * Finds and returns information about representations meeting the specified criteria. Returns information in the same format as getRepresentations()

    526. 

  526.  	 *

    527. 

  527.  	 * @param array $pa_options Array of criteria options to use when selecting representations. Options include: 

    528. 

  528.  	 *		mimetypes = array of mimetypes to return

    529. 

  529.  	 *		sortby = if set, representations are return sorted using the criteria in ascending order. Valid values are 'filesize' (sort by file size), 'duration' (sort by length of time-based media)

    530. 

  530.  	 * @return array List of representations. Each entry in the list is an associative array of the same format as returned by getRepresentations() and includes properties, tags and urls for the representation.

    531. 

  531.  	 */

    532. 

  532.  	public function findRepresentations($pa_options) {

    533. 

  533.  		$va_mimetypes = array();

    534. 

  534.  		if (isset($pa_options['mimetypes']) && (is_array($pa_options['mimetypes'])) && (sizeof($pa_options['mimetypes']))) {

    535. 

  535.  			$va_mimetypes = array_flip($pa_options['mimetypes']);

    536. 

  536.  		}

    537. 

  537.  		

    538. 

  538.  		$vs_sortby = null;

    539. 

  539.  		if (isset($pa_options['sortby']) && $pa_options['sortby'] && in_array($pa_options['sortby'], array('filesize', 'duration'))) {

    540. 

  540.  			$vs_sortby = $pa_options['sortby'];

    541. 

  541.  		}

    542. 

  542.  		

    543. 

  543.  		$va_reps = $this->getRepresentations(array('original'));

    544. 

  544.  		$va_found_reps = array();

    545. 

  545.  		foreach($va_reps as $vn_i => $va_rep) {

    546. 

  546.  			if((sizeof($va_mimetypes)) && isset($va_mimetypes[$va_rep['info']['original']['MIMETYPE']])) {

    547. 

  547.  				switch($vs_sortby) {

    548. 

  548.  					case 'filesize':

    549. 

  549.  						$va_found_reps[$va_rep['info']['original']['FILESIZE']][] = $va_rep;

    550. 

  550.  						break;

    551. 

  551.  					case 'duration':

    552. 

  552.  						$vn_duration = $va_rep['info']['original']['PROPERTIES']['duration'];

    553. 

  553.  						$va_found_reps[$vn_duration][] = $va_rep;

    554. 

  554.  						break;

    555. 

  555.  					default:

    556. 

  556.  						$va_found_reps[] = $va_rep;

    557. 

  557.  						break;

    558. 

  558.  				}

    559. 

  559.  			}

    560. 

  560.  		}

    561. 

  561.  		

    562. 

  562.  		if ($vs_sortby) {

    563. 

  563.  			ksort($va_found_reps);

    564. 

  564.  			

    565. 

  565.  			$va_tmp = array();

    566. 

  566.  			foreach($va_found_reps as $va_found_rep_groups) {

    567. 

  567.  				foreach($va_found_rep_groups as $va_found_rep) {

    568. 

  568.  					$va_tmp[] = $va_found_rep;

    569. 

  569.  				}

    570. 

  570.  			}

    571. 

  571.  			$va_found_reps = $va_tmp;

    572. 

  572.  		}

    573. 

  573.  		

    574. 

  574.  		return $va_found_reps;

    575. 

  575.  	}

    576. 

  576.  	# ------------------------------------------------------

    577. 

  577.  	# Representations

    578. 

  578.  	# ------------------------------------------------------

    579. 

  579.  	/**

    580. 

  580.  	 *

    581. 

  581.  	 */

    582. 

  582.  	public function getRepresentationIDs($pa_options=null) {

    583. 

  583.  		if (!($vn_object_id = $this->getPrimaryKey())) { return null; }

    584. 

  584.  		if (!is_array($pa_options)) { $pa_options = array(); }

    585. 

  585.  		

    586. 

  586.  		if (!is_array($pa_versions)) { 

    587. 

  587.  			$pa_versions = array('preview170');

    588. 

  588.  		}

    589. 

  589.  		

    590. 

  590.  		if (isset($pa_options['return_primary_only']) && $pa_options['return_primary_only']) {

    591. 

  591.  			$vs_is_primary_sql = ' AND (caoor.is_primary = 1)';

    592. 

  592.  		} else {

    593. 

  593.  			$vs_is_primary_sql = '';

    594. 

  594.  		}

    595. 

  595.  		

    596. 

  596.  		if (is_array($pa_options['return_with_access']) && sizeof($pa_options['return_with_access']) > 0) {

    597. 

  597.  			$vs_access_sql = ' AND (caor.access IN ('.join(", ", $pa_options['return_with_access']).'))';

    598. 

  598.  		} else {

    599. 

  599.  			$vs_access_sql = '';

    600. 

  600.  		}

    601. 

  601. 

    602. 

  602.  		

    603. 

  603.  		$o_db = $this->getDb();

    604. 

  604.  		$qr_reps = $o_db->query("

    605. 

  605.  			SELECT caor.representation_id, caoor.is_primary

    606. 

  606.  			FROM ca_object_representations caor

    607. 

  607.  			INNER JOIN ca_objects_x_object_representations AS caoor ON caor.representation_id = caoor.representation_id

    608. 

  608.  			WHERE

    609. 

  609.  				caoor.object_id = ? 

    610. 

  610.  				{$vs_is_primary_sql}

    611. 

  611.  				{$vs_access_sql}

    612. 

  612.  		", (int)$vn_object_id);

    613. 

  613.  		

    614. 

  614.  		$va_rep_ids = array();

    615. 

  615.  		while($qr_reps->nextRow()) {

    616. 

  616.  			$va_rep_ids[$qr_reps->get('representation_id')] = ($qr_reps->get('is_primary') == 1) ? true : false;

    617. 

  617.  		}

    618. 

  618.  		return $va_rep_ids;

    619. 

  619.  	}

    620. 

  620.  	# ------------------------------------------------------

    621. 

  621.  	/**

    622. 

  622.  	 * Returns number of representations attached to the currently loaded object

    623. 

  623.  	 *

    624. 

  624.  	 * @param array $pa_options Optional array of options. Supported options include:

    625. 

  625.  	 *		return_with_type - A type to restrict the count to. Can be either an integer type_id or item_code string

    626. 

  626.  	 *		return_with_access - An array of access values to restrict counts to

    627. 

  627.  	 *

    628. 

  628.  	 * @return integer The number of representations

    629. 

  629.  	 */

    630. 

  630.  	public function getRepresentationCount($pa_options=null) {

    631. 

  631.  		if (!($vn_object_id = $this->getPrimaryKey())) { return null; }

    632. 

  632.  		if (!is_array($pa_options)) { $pa_options = array(); }

    633. 

  633.  		

    634. 

  634.  		$vs_type_sql = '';

    635. 

  635.  		if (isset($pa_options['return_with_type']) && $pa_options['return_with_type']) {

    636. 

  636.  			if (!is_numeric($pa_options['return_with_type'])) {

    637. 

  637.  				$t_list = new ca_lists();

    638. 

  638.  				$pa_options['return_with_type'] = $t_list->getItemIDFromList('object_representation_types', $pa_options['return_with_type']);

    639. 

  639.  			}

    640. 

  640.  			if (intval($pa_options['return_with_type']) > 0) {

    641. 

  641.  				$vs_type_sql = ' AND (caor.type_id = '.intval($pa_options['return_with_type']).')';

    642. 

  642.  			}

    643. 

  643.  		} 

    644. 

  644.  		

    645. 

  645.  		if (is_array($pa_options['return_with_access']) && sizeof($pa_options['return_with_access']) > 0) {

    646. 

  646.  			$vs_access_sql = ' AND (caor.access IN ('.join(", ", $pa_options['return_with_access']).'))';

    647. 

  647.  		} else {

    648. 

  648.  			$vs_access_sql = '';

    649. 

  649.  		}

    650. 

  650.  		

    651. 

  651.  		$o_db = $this->getDb();

    652. 

  652.  		

    653. 

  653.  		$qr_reps = $o_db->query("

    654. 

  654.  			SELECT count(*) c

    655. 

  655.  			FROM ca_object_representations caor

    656. 

  656.  			INNER JOIN ca_objects_x_object_representations AS caoor ON caor.representation_id = caoor.representation_id

    657. 

  657.  			LEFT JOIN ca_locales AS l ON caor.locale_id = l.locale_id

    658. 

  658.  			WHERE

    659. 

  659.  				caoor.object_id = ? 

    660. 

  660.  				{$vs_type_sql}

    661. 

  661.  				{$vs_access_sql}

    662. 

  662.  		", (int)$vn_object_id);

    663. 

  663. 

    664. 

  664. 		$qr_reps->nextRow();

    665. 

  665. 		

    666. 

  666. 		return (int)$qr_reps->get('c');

    667. 

  667.  	}

    668. 

  668.  	# ------------------------------------------------------

    669. 

  669.  	/**

    670. 

  670.  	 * Returns primary representation for the object; versions specified in $pa_versions are returned. See description

    671. 

  671.  	 * of getRepresentations() for a description of returned values.

    672. 

  672.  	 */

    673. 

  673.  	public function getPrimaryRepresentation($pa_versions=null, $pa_version_sizes=null, $pa_options=null) {

    674. 

  674.  		if (!is_array($pa_options)) { $pa_options = array(); }

    675. 

  675.  		if(is_array($va_reps = $this->getRepresentations($pa_versions, $pa_version_sizes, array_merge($pa_options, array('return_primary_only' => 1))))) {

    676. 

  676.  			return array_pop($va_reps);

    677. 

  677.  		}

    678. 

  678.  		return array();

    679. 

  679.  	}

    680. 

  680.  	# ------------------------------------------------------

    681. 

  681.  	/**

    682. 

  682.  	 * Returns representation_id of primary representation for the object.

    683. 

  683.  	 */

    684. 

  684.  	public function getPrimaryRepresentationID($pa_options=null) {

    685. 

  685.  		if (!is_array($pa_options)) { $pa_options = array(); }

    686. 

  686.  		$va_rep_ids = $this->getRepresentationIDs(array_merge($pa_options, array('return_primary_only' => 1)));

    687. 

  687.  		if (!is_array($va_rep_ids)) { return null; }

    688. 

  688.  		foreach($va_rep_ids as $vn_representation_id => $vb_is_primary) {

    689. 

  689.  			if ($vb_is_primary) { return $vn_representation_id; }

    690. 

  690.  		}

    691. 

  691.  		return null;

    692. 

  692.  	}

    693. 

  693.  	# ------------------------------------------------------

    694. 

  694.  	/**

    695. 

  695.  	 * Returns ca_object_representations instance loaded with primary representation for the current ca_objects row

    696. 

  696.  	 */

    697. 

  697.  	public function getPrimaryRepresentationInstance($pa_options=null) {

    698. 

  698.  		if (!is_array($pa_options)) { $pa_options = array(); }

    699. 

  699.  		if (!($vn_rep_id = $this->getPrimaryRepresentationID($pa_options))) { return null; }

    700. 

  700.  		

    701. 

  701.  		$t_rep = new ca_object_representations($vn_rep_id);

    702. 

  702.  		

    703. 

  703.  		return ($t_rep->getPrimaryKey()) ? $t_rep : null;

    704. 

  704.  	}

    705. 

  705.  	# ------------------------------------------------------

    706. 

  706.  	/** 

    707. 

  707.  	 * Add media represention to currently loaded object

    708. 

  708.  	 *

    709. 

  709.  	 * @param $ps_media_path - the path to the media you want to add

    710. 

  710.  	 * @param $pn_type_id - the item_id of the representation type, in the ca_list with list_code 'object_represention_types'

    711. 

  711.  	 * @param $pn_locale_id - the locale_id of the locale of the representation

    712. 

  712.  	 * @param $pn_status - the status code for the representation (as defined in item_value fields of items in the 'workflow_statuses' ca_list)

    713. 

  713.  	 * @param $pn_access - the access code for the representation (as defined in item_value fields of items in the 'access_statuses' ca_list)

    714. 

  714.  	 * @param $pb_is_primary - if set to true, representation is designated "primary." Primary representation are used in cases where only one representation is required (such as search results). If a primary representation is already attached to this object, then it will be changed to non-primary as only one representation can be primary at any given time. If no primary representations exist, then the new representation will always be marked primary no matter what the setting of this parameter (there must always be a primary representation, if representations are defined).

    715. 

  715.  	 * @param $pa_values - array of attributes to attach to new representation

    716. 

  716.  	 * @param $pa_options - an array of options passed through to BaseModel::set() when creating the new representation. Currently supported options:

    717. 

  717.  	 *		original_filename - the name of the file being uploaded; will be recorded in the database and used as the filename when the file is subsequently downloaded

    718. 

  718.  	 *		rank - a numeric rank used to order the representations when listed

    719. 

  719.  	 */

    720. 

  720.  	public function addRepresentation($ps_media_path, $pn_type_id, $pn_locale_id, $pn_status, $pn_access, $pb_is_primary, $pa_values=null, $pa_options=null) {

    721. 

  721.  		if (!($vn_object_id = $this->getPrimaryKey())) { return null; }

    722. 

  722.  		if (!$pn_locale_id) { $pn_locale_id = ca_locales::getDefaultCataloguingLocaleID(); }

    723. 

  723.  		

    724. 

  724.  		$t_rep = new ca_object_representations();

    725. 

  725.  		$t_rep->setMode(ACCESS_WRITE);

    726. 

  726.  		$t_rep->set('type_id', $pn_type_id);

    727. 

  727.  		$t_rep->set('locale_id', $pn_locale_id);

    728. 

  728.  		$t_rep->set('status', $pn_status);

    729. 

  729.  		$t_rep->set('access', $pn_access);

    730. 

  730.  		$t_rep->set('media', $ps_media_path, $pa_options);

    731. 

  731.  		

    732. 

  732.  		

    733. 

  733.  		if (is_array($pa_values)) {

    734. 

  734.  			if (isset($pa_values['idno'])) {

    735. 

  735.  				$t_rep->set('idno', $pa_values['idno']);

    736. 

  736.  			}

    737. 

  737. 			foreach($pa_values as $vs_element => $va_value) { 					

    738. 

  738. 				if (is_array($va_value)) {

    739. 

  739. 					// array of values (complex multi-valued attribute)

    740. 

  740. 					$t_rep->addAttribute(

    741. 

  741. 						array_merge($va_value, array(

    742. 

  742. 							'locale_id' => $pn_locale_id

    743. 

  743. 						)), $vs_element);

    744. 

  744. 				} else {

    745. 

  745. 					// scalar value (simple single value attribute)

    746. 

  746. 					if ($va_value) {

    747. 

  747. 						$t_rep->addAttribute(array(

    748. 

  748. 							'locale_id' => $pn_locale_id,

    749. 

  749. 							$vs_element => $va_value

    750. 

  750. 						), $vs_element);

    751. 

  751. 					}

    752. 

  752. 				}

    753. 

  753. 			}

    754. 

  754. 		}

    755. 

  755.  		

    756. 

  756.  		$t_rep->insert();

    757. 

  757.  		

    758. 

  758.  		if ($t_rep->numErrors()) {

    759. 

  759.  			$this->errors = array_merge($this->errors, $t_rep->errors());

    760. 

  760.  			return false;

    761. 

  761.  		}

    762. 

  762.  		

    763. 

  763.  		$vs_label = (isset($pa_values['name']) && $pa_values['name']) ? $pa_values['name'] : '['._t('BLANK').']';

    764. 

  764.  		

    765. 

  765.  		$t_rep->addLabel(array('name' => $vs_label), $pn_locale_id, null, true);

    766. 

  766.  		if ($t_rep->numErrors()) {

    767. 

  767.  			$this->errors = array_merge($this->errors, $t_rep->errors());

    768. 

  768.  			return false;

    769. 

  769.  		}

    770. 

  770.  		

    771. 

  771.  		$t_oxor = new ca_objects_x_object_representations();

    772. 

  772.  		$t_oxor->setMode(ACCESS_WRITE);

    773. 

  773.  		$t_oxor->set('object_id', $vn_object_id);

    774. 

  774.  		$t_oxor->set('representation_id', $t_rep->getPrimaryKey());

    775. 

  775.  		$t_oxor->set('is_primary', $pb_is_primary ? 1 : 0);

    776. 

  776.  		$t_oxor->set('rank', isset($pa_options['rank']) ? (int)$pa_options['rank'] : null);

    777. 

  777.  		$t_oxor->insert();

    778. 

  778.  		

    779. 

  779.  		

    780. 

  780.  		if ($t_oxor->numErrors()) {

    781. 

  781.  			$this->errors = array_merge($this->errors, $t_oxor->errors());

    782. 

  782.  			$t_rep->delete();

    783. 

  783.  			if ($t_rep->numErrors()) {

    784. 

  784.  				$this->errors = array_merge($this->errors, $t_rep->errors());

    785. 

  785.  			}

    786. 

  786.  			return false;

    787. 

  787.  		}

    788. 

  788.  		return $t_oxor->getPrimaryKey();

    789. 

  789.  	}

    790. 

  790.  	# ------------------------------------------------------

    791. 

  791.  	/**

    792. 

  792.  	 *

    793. 

  793.  	 */

    794. 

  794.  	public function editRepresentation($pn_representation_id, $ps_media_path, $pn_locale_id, $pn_status, $pn_access, $pb_is_primary, $pa_values=null, $pa_options=null) {

    795. 

  795.  		if (!($vn_object_id = $this->getPrimaryKey())) { return null; }

    796. 

  796.  		

    797. 

  797.  		$t_rep = new ca_object_representations();

    798. 

  798.  		if (!$t_rep->load(array('representation_id' => $pn_representation_id))) {

    799. 

  799.  			$this->postError(750, _t("Representation id=%1 does not exist", $pn_representation_id), "ca_objects->editRepresentation()");

    800. 

  800.  			return false;

    801. 

  801.  		} else {

    802. 

  802. 			$t_rep->setMode(ACCESS_WRITE);

    803. 

  803. 			$t_rep->set('locale_id', $pn_locale_id);

    804. 

  804. 			$t_rep->set('status', $pn_status);

    805. 

  805. 			$t_rep->set('access', $pn_access);

    806. 

  806. 			

    807. 

  807. 			if ($ps_media_path) {

    808. 

  808. 				$t_rep->set('media', $ps_media_path, $pa_options);

    809. 

  809. 			}

    810. 

  810. 			

    811. 

  811. 			if (is_array($pa_values)) {

    812. 

  812. 				if (isset($pa_values['idno'])) {

    813. 

  813. 					$t_rep->set('idno', $pa_values['idno']);

    814. 

  814. 				}

    815. 

  815. 				foreach($pa_values as $vs_element => $va_value) { 					

    816. 

  816. 					if (is_array($va_value)) {

    817. 

  817. 						// array of values (complex multi-valued attribute)

    818. 

  818. 						$t_rep->replaceAttribute(

    819. 

  819. 							array_merge($va_value, array(

    820. 

  820. 								'locale_id' => $pn_locale_id

    821. 

  821. 							)), $vs_element);

    822. 

  822. 					} else {

    823. 

  823. 						// scalar value (simple single value attribute)

    824. 

  824. 						if ($va_value) {

    825. 

  825. 							$t_rep->replaceAttribute(array(

    826. 

  826. 								'locale_id' => $pn_locale_id,

    827. 

  827. 								$vs_element => $va_value

    828. 

  828. 							), $vs_element);

    829. 

  829. 						}

    830. 

  830. 					}

    831. 

  831. 				}

    832. 

  832. 			}

    833. 

  833. 			

    834. 

  834. 			$t_rep->update();

    835. 

  835. 			

    836. 

  836. 			if ($t_rep->numErrors()) {

    837. 

  837. 				$this->errors = array_merge($this->errors, $t_rep->errors());

    838. 

  838.  				return false;

    839. 

  839. 			}

    840. 

  840. 			

    841. 

  841. 			$t_oxor = new ca_objects_x_object_representations();

    842. 

  842. 			if (!$t_oxor->load(array('object_id' => $vn_object_id, 'representation_id' => $pn_representation_id))) {

    843. 

  843. 				$this->postError(750, _t("Representation id=%1 is not related to object id=%2", $pn_representation_id, $vn_object_id), "ca_objects->editRepresentation()");

    844. 

  844. 				return false;

    845. 

  845. 			} else {

    846. 

  846. 				$t_oxor->setMode(ACCESS_WRITE);

    847. 

  847. 				$t_oxor->set('is_primary', $pb_is_primary ? 1 : 0);

    848. 

  848. 				

    849. 

  849. 				if (isset($pa_options['rank']) && ($vn_rank = (int)$pa_options['rank'])) {

    850. 

  850. 					$t_oxor->set('rank', $vn_rank);

    851. 

  851. 				}

    852. 

  852. 				

    853. 

  853. 				$t_oxor->update();

    854. 

  854. 				

    855. 

  855. 				if ($t_oxor->numErrors()) {

    856. 

  856. 					$this->errors = array_merge($this->errors, $t_oxor->errors());

    857. 

  857. 					return false;

    858. 

  858. 				}

    859. 

  859. 			}

    860. 

  860. 			

    861. 

  861. 			return true;

    862. 

  862. 		}

    863. 

  863. 		return false;

    864. 

  864.  	}

    865. 

  865.  	# ------------------------------------------------------

    866. 

  866.  	/**

    867. 

  867.  	 * Remove a single representation from the currently loaded object. Note that the representation will be removed from the database completed, so if it is also linked to other objects it will be removed from them as well.

    868. 

  868.  	 *

    869. 

  869.  	 * @param int $pn_representation_id The representation_id of the representation to remove

    870. 

  870.  	 * @return bool True if delete succeeded, false if there was an error. You can get the error messages by calling getErrors() on the ca_objects instance.

    871. 

  871.  	 */

    872. 

  872.  	public function removeRepresentation($pn_representation_id) {

    873. 

  873.  		if(!$this->getPrimaryKey()) { return null; }

    874. 

  874.  		

    875. 

  875.  		$t_rep = new ca_object_representations();

    876. 

  876.  		if (!$t_rep->load(array('representation_id' => $pn_representation_id))) {

    877. 

  877.  			$this->postError(750, _t("Representation id=%1 does not exist", $pn_representation_id), "ca_objects->removeRepresentation()");

    878. 

  878.  			return false;

    879. 

  879.  		} else {

    880. 

  880.  			$t_rep->setMode(ACCESS_WRITE);

    881. 

  881.  			$t_rep->delete(true);

    882. 

  882.  			

    883. 

  883.  			if ($t_rep->numErrors()) {

    884. 

  884.  				$this->errors = array_merge($this->errors, $t_rep->errors());

    885. 

  885.  				return false;

    886. 

  886.  			}

    887. 

  887.  			

    888. 

  888.  			return true;

    889. 

  889.  		}

    890. 

  890.  		

    891. 

  891.  		return false;

    892. 

  892.  	}

    893. 

  893.  	# ------------------------------------------------------

    894. 

  894.  	/**

    895. 

  895.  	 * Removes all representations from the currently loaded object.

    896. 

  896.  	 *

    897. 

  897.  	 * @return bool True if delete succeeded, false if there was an error. You can get the error messages by calling getErrors() on the ca_objects instance.

    898. 

  898.  	 */

    899. 

  899.  	public function removeAllRepresentations() {

    900. 

  900.  		if (is_array($va_reps = $this->getRepresentations())) {

    901. 

  901.  			foreach($va_reps as $vn_i => $va_rep_info) {

    902. 

  902.  				if (!$this->removeRepresentation($va_rep_info['representation_id'])) {

    903. 

  903.  					// Representation remove failed

    904. 

  904.  					return false;

    905. 

  905.  				}

    906. 

  906.  			}

    907. 

  907.  		}

    908. 

  908.  		return false;

    909. 

  909.  	}

    910. 

  910.  	# ------------------------------------------------------

    911. 

  911.  	#

    912. 

  912.  	# ------------------------------------------------------

    913. 

  913. 	/**

    914. 

  914. 	 * Return array containing information about all hierarchies, including their root_id's

    915. 

  915. 	 * For non-adhoc hierarchies such as places, this call returns the contents of the place_hierarchies list

    916. 

  916. 	 * with some extra information such as the # of top-level items in each hierarchy.

    917. 

  917. 	 *

    918. 

  918. 	 * For an ad-hoc hierarchy like that of an object, there is only ever one hierarchy to display - that of the current object.

    919. 

  919. 	 * So for adhoc hierarchies we just return a single entry corresponding to the root of the current object hierarchy

    920. 

  920. 	 */

    921. 

  921. 	 public function getHierarchyList($pb_dummy=false) {

    922. 

  922. 	 	$vn_pk = $this->getPrimaryKey();

    923. 

  923. 	 	if (!$vn_pk) { return null; }		// have to load a row first

    924. 

  924. 	 	

    925. 

  925. 	 	$vs_label = $this->getLabelForDisplay(false);

    926. 

  926. 	 	$vs_hier_fld = $this->getProperty('HIERARCHY_ID_FLD');

    927. 

  927. 	 	$vs_parent_fld = $this->getProperty('PARENT_ID_FLD');

    928. 

  928. 	 	$vn_hier_id = $this->get($vs_hier_fld);

    929. 

  929. 	 	

    930. 

  930. 	 	if ($this->get($vs_parent_fld)) { 

    931. 

  931. 	 		// currently loaded row is not the root so get the root

    932. 

  932. 	 		$va_ancestors = $this->getHierarchyAncestors();

    933. 

  933. 	 		if (!is_array($va_ancestors) || sizeof($va_ancestors) == 0) { return null; }

    934. 

  934. 	 		$t_object = new ca_objects($va_ancestors[0]);

    935. 

  935. 	 	} else {

    936. 

  936. 	 		$t_object =& $this;

    937. 

  937. 	 	}

    938. 

  938. 	 	

    939. 

  939. 	 	$va_children = $t_object->getHierarchyChildren(null, array('idsOnly' => true));

    940. 

  940. 	 	$va_object_hierarchy_root = array(

    941. 

  941. 	 		$t_object->get($vs_hier_fld) => array(

    942. 

  942. 	 			'object_id' => $vn_pk,

    943. 

  943. 	 			'name' => $vs_label,

    944. 

  944. 	 			'hierarchy_id' => $vn_hier_id,

    945. 

  945. 	 			'children' => sizeof($va_children)

    946. 

  946. 	 		),

    947. 

  947. 	 		'object_id' => $vn_pk,

    948. 

  948. 			'name' => $vs_label,

    949. 

  949. 			'hierarchy_id' => $vn_hier_id,

    950. 

  950. 			'children' => sizeof($va_children)

    951. 

  951. 	 	);

    952. 

  952. 	 	

    953. 

  953. 	 	return $va_object_hierarchy_root;

    954. 

  954. 	}

    955. 

  955. 	# ------------------------------------------------------

    956. 

  956. 	/**

    957. 

  957. 	 * Returns name of hierarchy for currently loaded row or, if specified, row identified by optional $pn_id parameter

    958. 

  958. 	 */

    959. 

  959. 	 public function getHierarchyName($pn_id=null) {

    960. 

  960. 	 	if (!$pn_id) { $pn_id = $this->getPrimaryKey(); }

    961. 

  961. 	 	

    962. 

  962. 		$va_ancestors = $this->getHierarchyAncestors($pn_id, array('idsOnly' => true));

    963. 

  963. 		if (is_array($va_ancestors) && sizeof($va_ancestors)) {

    964. 

  964. 			$vn_parent_id = array_pop($va_ancestors);

    965. 

  965. 			$t_object = new ca_objects($vn_parent_id);

    966. 

  966. 			return $t_object->getLabelForDisplay(false);

    967. 

  967. 		} else {			

    968. 

  968. 			if ($pn_id == $this->getPrimaryKey()) {

    969. 

  969. 				return $this->getLabelForDisplay(false);

    970. 

  970. 			} else {

    971. 

  971. 				$t_object = new ca_objects($pn_id);

    972. 

  972. 				return $t_object->getLabelForDisplay(false);

    973. 

  973. 			}

    974. 

  974. 		}

    975. 

  975. 	 }

    976. 

  976. 	 # ------------------------------------------------------------------

    977. 

  977. 	/**

    978. 

  978. 	 * Returns associative array, keyed by primary key value with values being

    979. 

  979. 	 * the preferred label of the row from a suitable locale, ready for display 

    980. 

  980. 	 * 

    981. 

  981. 	 * @param array $pa_ids indexed array of primary key values to fetch labels for

    982. 

  982. 	 * @param array $pa_versions

    983. 

  983. 	 * @param array $pa_options

    984. 

  984. 	 * @return array List of media

    985. 

  985. 	 */

    986. 

  986. 	public function getPrimaryMediaForIDs($pa_ids, $pa_versions, $pa_options = null) {

    987. 

  987. 		if (!is_array($pa_ids) || !sizeof($pa_ids)) { return array(); }

    988. 

  988. 		if (!is_array($pa_options)) { $pa_options = array(); }

    989. 

  989. 		$va_access_values = $pa_options["checkAccess"];

    990. 

  990. 		if (isset($va_access_values) && is_array($va_access_values) && sizeof($va_access_values)) {

    991. 

  991. 			$vs_access_where = ' AND orep.access IN ('.join(',', $va_access_values).')';

    992. 

  992. 		}

    993. 

  993. 		$o_db = $this->getDb();

    994. 

  994. 		$qr_res = $o_db->query("

    995. 

  995. 			SELECT oxor.object_id, orep.media

    996. 

  996. 			FROM ca_object_representations orep

    997. 

  997. 			INNER JOIN ca_objects_x_object_representations AS oxor ON oxor.representation_id = orep.representation_id

    998. 

  998. 			WHERE

    999. 

  999. 				(oxor.object_id IN (".join(',', $pa_ids).")) AND oxor.is_primary = 1 {$vs_access_where}

    1000. 

  1000. 		");

    1001. 

  1001. 		

    1002. 

  1002. 		$va_media = array();

    1003. 

  1003. 		while($qr_res->nextRow()) {

    1004. 

  1004. 			$va_media_tags = array();

    1005. 

  1005. 			foreach($pa_versions as $vs_version) {

    1006. 

  1006. 				$va_media_tags['tags'][$vs_version] = $qr_res->getMediaTag('ca_object_representations.media', $vs_version);

    1007. 

  1007. 				$va_media_tags['info'][$vs_version] = $qr_res->getMediaInfo('ca_object_representations.media', $vs_version);

    1008. 

  1008. 			}

    1009. 

  1009. 			$va_media[$qr_res->get('object_id')] = $va_media_tags;

    1010. 

  1010. 		}

    1011. 

  1011. 		return $va_media;

    1012. 

  1012. 	}

    1013. 

  1013.  	# ------------------------------------------------------

    1014. 

  1014. 	/**

    1015. 

  1015. 	 * Returns associative array of type names

    1016. 

  1016. 	 */

    1017. 

  1017. 	public function getTypeNamesForIDs($pa_ids) {

    1018. 

  1018. 		if (!is_array($pa_ids) || !sizeof($pa_ids)) { return array(); }

    1019. 

  1019. 		$o_db = $this->getDb();

    1020. 

  1020. 		$ids = join(',', $pa_ids);

    1021. 

  1021. 		$qr_res = $o_db->query("

    1022. 

  1022. 			SELECT objects.object_id id, labels.name_singular name, labels.locale_id locale

    1023. 

  1023. 				FROM ca_list_item_labels labels

    1024. 

  1024. 				INNER JOIN ca_objects objects ON objects.type_id = labels.item_id

    1025. 

  1025. 				WHERE (objects.object_id IN ({$ids}))

    1026. 

  1026. 		");

    1027. 

  1027. 		

    1028. 

  1028. 		$va_typeNames = array();

    1029. 

  1029. 		while($qr_res->nextRow()) {

    1030. 

  1030. 			$va_typeNames[$qr_res->get('id')] = $qr_res->get('name');

    1031. 

  1031. 		}

    1032. 

  1032. 		return $va_typeNames;

    1033. 

  1033. 	}

    1034. 

  1034.  	# ------------------------------------------------------	

    1035. 

  1035. 	public function getCollectionSiblings($count = 5, $type_ids = false, $pa_options = null) {

    1036. 

  1036. 		if (!is_array($pa_options)) { $pa_options = array(); }

    1037. 

  1037. 		if ($pa_options['checkAccess']) { $pa_options['return_with_access'] = $pa_options['checkAccess']; }

    1038. 

  1038. 		$access = $pa_options['return_with_access'];

    1039. 

  1039. 		$id = $this->get('ca_objects_x_collections.collection_id', array('returnAsArray' => true));

    1040. 

  1040. 		$siblings = array();

    1041. 

  1041. 		foreach ($id as $i) {

    1042. 

  1042. 			$t_collection = new ca_collections($i);

    1043. 

  1043. 			$siblings = array_merge($siblings, $t_collection->get('ca_objects_x_collections.object_id', array('returnAsArray' => true, 'checkAccess' => $access)));

    1044. 

  1044. 		}

    1045. 

  1045. 		foreach ($siblings as $n => $id) {

    1046. 

  1046. 			// unset own id

    1047. 

  1047. 			if ($id == $this->get('object_id')) {

    1048. 

  1048. 				unset($siblings[$n]);

    1049. 

  1049. 			}

    1050. 

  1050. 		}

    1051. 

  1051. 		if (count($siblings) == 0) {

    1052. 

  1052. 			// return random items

    1053. 

  1053. 			$ids = array_keys($this->getRandomItems(5, array('hasRepresentations' => 1, 'checkAccess' => $access)));

    1054. 

  1054. 			$siblings = array();

    1055. 

  1055. 			foreach ($ids as $id) {

    1056. 

  1056. 				$siblings[$id] = new ca_objects($id);

    1057. 

  1057. 			}

    1058. 

  1058. 			$return = $siblings;

    1059. 

  1059. 		} else {

    1060. 

  1060. 			// return siblings

    1061. 

  1061. 			if ($count > count($siblings)) { $count = count($siblings); }

    1062. 

  1062. 			$rk = array_rand($siblings, $count);

    1063. 

  1063. 			$t_siblings = array();

    1064. 

  1064. 			foreach ($rk as $v) {

    1065. 

  1065. 				$obj = new ca_objects($siblings[$v]);

    1066. 

  1066. 				$t_siblings[$obj->get('object_id')] = $obj;

    1067. 

  1067. 			}

    1068. 

  1068. 			if ($type_ids) {

    1069. 

  1069. 				$return = array('siblings' => $t_siblings, 'type_ids' => array());

    1070. 

  1070. 				foreach (array_keys($t_siblings) as $id) {

    1071. 

  1071. 					$return['type_ids'][$id] = $t_siblings[$id]->get('type_id');

    1072. 

  1072. 				}

    1073. 

  1073. 			} else {

    1074. 

  1074. 				$return = $t_siblings;

    1075. 

  1075. 			}

    1076. 

  1076. 		}

    1077. 

  1077. 		return $return;	

    1078. 

  1078. 	}

    1079. 

  1079.  	# ------------------------------------------------------	

    1080. 

  1080. 	public function getIdnoSiblings($pa_options = null) {

    1081. 

  1081. 		if (!is_array($pa_options)) { $pa_options = array(); }

    1082. 

  1082. 		if ($pa_options['checkAccess']) { $pa_options['return_with_access'] = $pa_options['checkAccess']; }

    1083. 

  1083. 		$idno = $this->get('idno');

    1084. 

  1084. 		$position = strpos($idno, '/');

    1085. 

  1085. 		// can we parse the idno?

    1086. 

  1086. 		if ($position) {

    1087. 

  1087. 			$idno = substr($idno, 0, -$position);

    1088. 

  1088. 			$access = $pa_options['return_with_access'];

    1089. 

  1089. 			if (sizeof($access)) {

    1090. 

  1090. 				$access = implode(', ', $access);

    1091. 

  1091. 			} else {

    1092. 

  1092. 				$access = $this->get('access');

    1093. 

  1093. 			}

    1094. 

  1094. 			$o_db = $this->getDb();

    1095. 

  1095. 			$qr_res = $o_db->query("

    1096. 

  1096. 				SELECT o.object_id id, o.idno idno

    1097. 

  1097. 					FROM ca_objects o

    1098. 

  1098. 					WHERE o.idno LIKE '{$idno}%'

    1099. 

  1099. 						AND o.access IN ({$access})

    1100. 

  1100. 					ORDER BY o.idno

    1101. 

  1101. 			");

    1102. 

  1102. 			$siblings = array();

    1103. 

  1103. 			while($qr_res->nextRow()) {

    1104. 

  1104. 				$siblings[] = $qr_res->getRow();

    1105. 

  1105. 			}

    1106. 

  1106. 			$n = 0;

    1107. 

  1107. 			while (isset($siblings[$n]) && intval($siblings[$n]['id']) != $this->get('object_id')) {

    1108. 

  1108. 				$n++;

    1109. 

  1109. 			}

    1110. 

  1110. 			$next = false; $prev = false;

    1111. 

  1111. 			if (isset($siblings[$n+1])) $next = $siblings[$n+1]['id']; 

    1112. 

  1112. 			if (isset($siblings[$n-1])) $prev = $siblings[$n-1]['id'];

    1113. 

  1113. 			// return 10 siblings

    1114. 

  1114. 			$objects = false;

    1115. 

  1115. 			if (sizeof($siblings) > 1) {

    1116. 

  1116. 				$objects = array();

    1117. 

  1117. 				if ($prev) $objects[] = new ca_objects($prev);

    1118. 

  1118. 				if ($next) {

    1119. 

  1119. 					$arr = array_slice($siblings, $n+1);

    1120. 

  1120. 					foreach ($arr as $key => $val) {

    1121. 

  1121. 						$arr[$key] = new ca_objects($val['id']);

    1122. 

  1122. 					}

    1123. 

  1123. 					$objects = array_slice(array_merge($objects, $arr), 0, 5);

    1124. 

  1124. 				}

    1125. 

  1125. 			}

    1126. 

  1126. 			$return = array(

    1127. 

  1127. 				'next_id' => $next,

    1128. 

  1128. 				'prev_id' => $prev,

    1129. 

  1129. 				'siblings' => $objects

    1130. 

  1130. 			);

    1131. 

  1131. 		} else {

    1132. 

  1132. 			$return = false;

    1133. 

  1133. 		}

    1134. 

  1134. 		return $return;

    1135. 

  1135. 	}	

    1136. 

  1136.  	# ------------------------------------------------------	

    1137. 

  1137. 	public function getCollectionHierarchy($locale, $pa_options = null) {

    1138. 

  1138. 		if (!is_array($pa_options)) { $pa_options = array(); }

    1139. 

  1139. 		if ($pa_options['checkAccess']) { $pa_options['return_with_access'] = $pa_options['checkAccess']; }

    1140. 

  1140. 		$access = $pa_options['return_with_access'];

    1141. 

  1141. 		$id = $this->get('ca_objects_x_collections.collection_id', array('returnAsArray' => true, 'checkAccess' => $access));

    1142. 

  1142. 		if (sizeof($id) == 0) return false;

    1143. 

  1143. 		if (sizeof($access) == 0) return false;

    1144. 

  1144. 		$access = implode(', ', $access);

    1145. 

  1145. 		$id = $id[0];

    1146. 

  1146. 		$t_collection = new ca_collections($id);

    1147. 

  1147. 		$left = $t_collection->get('hier_left');

    1148. 

  1148. 		$hier_id = $t_collection->get('hier_collection_id');

    1149. 

  1149. 		$lang_code = $locale;

    1150. 

  1150. 		$o_db = $this->getDb();

    1151. 

  1151. 		$qr_res = $o_db->query("

    1152. 

  1152. 			SELECT cl.name AS name, parent.collection_id

    1153. 

  1153. 			FROM ca_collections AS node JOIN ca_collections AS parent

    1154. 

  1154. 				JOIN ca_collection_labels AS cl ON parent.collection_id = cl.collection_id

    1155. 

  1155. 				JOIN ca_locales AS lo ON cl.locale_id = lo.locale_id				

    1156. 

  1156. 			WHERE node.hier_left BETWEEN parent.hier_left AND parent.hier_right

    1157. 

  1157. 				AND (parent.hier_collection_id = {$hier_id} AND node.hier_collection_id = {$hier_id})

    1158. 

  1158. 				AND parent.access IN ({$access})

    1159. 

  1159. 				AND lo.language = '{$lang_code}'

    1160. 

  1160. 				AND node.collection_id = {$id}

    1161. 

  1161. 			ORDER BY node.hier_left;

    1162. 

  1162. 		");

    1163. 

  1163. 		$tree = array();

    1164. 

  1164. 		while($qr_res->nextRow()) {

    1165. 

  1165. 			$tree[] = $qr_res->getRow();

    1166. 

  1166. 		}

    1167. 

  1167. 

    1168. 

  1168. 		return $tree;

    1169. 

  1169. 	}	

    1170. 

  1170. }

    1171. 

  1171. ?>
…
    1172.

Large files files are truncated, but you can click here to view the full file