BxBaseGrid.php 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645
  1. <?php defined('BX_DOL') or die('hack attempt');
  2. /**
  3. * Copyright (c) UNA, Inc - https://una.io
  4. * MIT License - https://opensource.org/licenses/MIT
  5. *
  6. * @defgroup UnaBaseView UNA Base Representation Classes
  7. * @{
  8. */
  9. /**
  10. * Grid representation.
  11. * @see BxDolGrid
  12. */
  13. class BxBaseGrid extends BxDolGrid
  14. {
  15. protected $_oTemplate;
  16. protected $_aPopupOptions = false;
  17. protected $_aQueryAppend = false;
  18. protected $_aQueryReset = false;
  19. protected $_aConfirmMessages = false;
  20. protected $_bSelectAll = false;
  21. protected $_isDisplayPopupOnTextOverflow = true;
  22. public function __construct ($aOptions, $oTemplate)
  23. {
  24. parent::__construct ($aOptions);
  25. if ($oTemplate)
  26. $this->_oTemplate = $oTemplate;
  27. else
  28. $this->_oTemplate = BxDolTemplate::getInstance();
  29. $this->_aQueryReset = array('filter', 'order_field', 'order_dir', $this->_aOptions['paginate_get_start'], $this->_aOptions['paginate_get_per_page']);
  30. }
  31. public function performActionDisplay()
  32. {
  33. require_once(BX_DIRECTORY_PATH_INC . "design.inc.php");
  34. echoJson(array('grid' => $this->getCode(false)));
  35. }
  36. public function performActionReorder()
  37. {
  38. $this->_replaceMarkers ();
  39. $aOrder = bx_get($this->_sObject . '_row');
  40. $iOrder = 0;
  41. foreach ($aOrder as $mixedId)
  42. $this->_updateOrder($mixedId, ++$iOrder);
  43. echoJson(array());
  44. }
  45. public function performActionDelete()
  46. {
  47. $this->_replaceMarkers ();
  48. $iAffected = 0;
  49. $aIds = bx_get('ids');
  50. if (!$aIds || !is_array($aIds)) {
  51. echoJson(array());
  52. exit;
  53. }
  54. foreach ($aIds as $mixedId)
  55. $iAffected += $this->_delete($mixedId) ? 1 : 0;
  56. echo echoJson(array_merge(
  57. array(
  58. 'grid' => $this->getCode(false),
  59. ),
  60. $iAffected ? array() : array('msg' => _t("_sys_grid_delete_failed"))
  61. ));
  62. }
  63. public function performActionEnable()
  64. {
  65. $this->_replaceMarkers ();
  66. $aIds = bx_get('ids');
  67. if (!$aIds || !is_array($aIds)) {
  68. echoJson(array());
  69. exit;
  70. }
  71. $aAffectedIds = array ();
  72. foreach ($aIds as $mixedId)
  73. if ($this->_enable($mixedId, (int)bx_get('checked')))
  74. $aAffectedIds[] = $mixedId;
  75. $sAction = (int)bx_get('checked') ? 'enable' : 'disable';
  76. echo echoJson(array($sAction => $aAffectedIds));
  77. }
  78. public function getCode ($isDisplayHeader = true)
  79. {
  80. $this->_replaceMarkers ();
  81. if ($isDisplayHeader && empty($this->_aOptions['paginate_url'])) {
  82. // reset page query params if grid is just initialized and it uses AJAX paginate
  83. $this->resetQueryParams();
  84. }
  85. $sPaginate = '';
  86. $aData = array();
  87. $sIdWrapper = 'bx-grid-wrap-' . $this->_sObject;
  88. $sIdContainer = 'bx-grid-cont-' . $this->_sObject;
  89. $sIdTable = 'bx-grid-table-' . $this->_sObject;
  90. $sFilter = bx_unicode_urldecode(bx_process_input(bx_get('filter')));
  91. $sOrderField = bx_unicode_urldecode(bx_process_input(bx_get('order_field')));
  92. $sOrderDir = 0 === strcasecmp('desc', bx_get('order_dir')) ? 'DESC' : 'ASC';
  93. if ($this->_aOptions['paginate_get_start'])
  94. $iStart = (int)bx_get($this->_aOptions['paginate_get_start']);
  95. else
  96. $iStart = 0;
  97. if ($this->_aOptions['paginate_get_per_page'] && (int)bx_get($this->_aOptions['paginate_get_per_page']) > 0)
  98. $iPerPage = (int)bx_get($this->_aOptions['paginate_get_per_page']);
  99. elseif ($this->_aOptions['paginate_per_page'])
  100. $iPerPage = (int)$this->_aOptions['paginate_per_page'];
  101. else
  102. $iPerPage = 10;
  103. if ($this->_aOptions['paginate_get_start']) {
  104. $aData = $this->_getData ($sFilter, $sOrderField, $sOrderDir, $iStart, $iPerPage + 1);
  105. $sPageUrl = false;
  106. if (!empty($this->_aOptions['paginate_url'])) {
  107. $sPageUrl = $this->_aOptions['paginate_url'];
  108. $aParamsAppend = array();
  109. if ($sFilter) {
  110. $aParamsAppend['filter'] = bx_process_input(bx_get('filter'));
  111. }
  112. if ($sOrderField) {
  113. $aParamsAppend['order_field'] = bx_process_input(bx_get('order_field'));
  114. $aParamsAppend['order_dir'] = bx_process_input(bx_get('order_dir'));
  115. }
  116. if ($aParamsAppend)
  117. $sPageUrl = bx_append_url_params($sPageUrl, $aParamsAppend);
  118. }
  119. $aPaginateParams = array(
  120. 'start' => $iStart,
  121. 'per_page' => $iPerPage,
  122. 'page_url' => $sPageUrl ? $sPageUrl : "javascript:glGrids." . $this->_sObject . ".reload('{start}'); void(0);",
  123. );
  124. $oPaginate = new BxTemplPaginate($aPaginateParams, $this->_oTemplate);
  125. $oPaginate->setNumFromDataArray($aData);
  126. if (isset($this->_aOptions['paginate_simple']) && false !== $this->_aOptions['paginate_simple'])
  127. $sPaginate = $oPaginate->getSimplePaginate($this->_aOptions['paginate_simple']);
  128. else
  129. $sPaginate = $oPaginate->getPaginate();
  130. } else {
  131. $aData = $this->_getData ($sFilter, $sOrderField, $sOrderDir, $iStart, $iPerPage);
  132. }
  133. $sPopupOptions = '{}';
  134. if (!empty($this->_aPopupOptions) && is_array($this->_aPopupOptions))
  135. $sPopupOptions = json_encode($this->_aPopupOptions);
  136. $aQueryAppend = array_merge(is_array($this->_aQueryAppend) ? $this->_aQueryAppend : array(), is_array($this->_aMarkers) ? $this->_aMarkers : array());
  137. $sQueryAppend = '{}';
  138. if (!empty($aQueryAppend) && is_array($aQueryAppend))
  139. $sQueryAppend = json_encode($aQueryAppend);
  140. $sConfirmMessages = '{}';
  141. if (!empty($this->_aConfirmMessages) && is_array($this->_aConfirmMessages))
  142. $sConfirmMessages = json_encode($this->_aConfirmMessages);
  143. $iColumns = count($this->_aOptions['fields']);
  144. $aVarsHead = $this->_getRowHead();
  145. $aVars = array (
  146. 'object' => $this->_sObject,
  147. 'id_table' => $sIdTable,
  148. 'id_cont' => $sIdContainer,
  149. 'id_wrap' => $sIdWrapper,
  150. 'sortable' => empty($this->_aOptions['field_order']) ? 0 : 1,
  151. 'sorting' => empty($this->_aOptions['sorting_fields']) ? 0 : 1,
  152. 'sorting_field' => $sOrderField,
  153. 'sorting_dir' => $sOrderDir,
  154. 'bx_if:display_head' => array(
  155. 'condition' => !empty($aVarsHead),
  156. 'content' => array(
  157. 'bx_repeat:row_header' => $aVarsHead,
  158. 'columns' => $iColumns,
  159. )
  160. ),
  161. 'bx_repeat:rows_data' => $this->_getRowsDataDesign ($aData),
  162. 'paginate_get_start' => $this->_aOptions['paginate_get_start'],
  163. 'paginate_get_per_page' => $this->_aOptions['paginate_get_per_page'],
  164. 'start' => $iStart,
  165. 'per_page' => $iPerPage,
  166. 'filter' => bx_js_string($sFilter, BX_ESCAPE_STR_APOS),
  167. 'order_field' => bx_js_string($sOrderField, BX_ESCAPE_STR_APOS),
  168. 'order_dir' => bx_js_string($sOrderDir, BX_ESCAPE_STR_APOS),
  169. 'popup_options' => $sPopupOptions,
  170. 'query_append' => $sQueryAppend,
  171. 'confirm_messages' => $sConfirmMessages,
  172. 'columns' => $iColumns,
  173. 'bx_if:display_footer' => array(
  174. 'condition' => !empty($this->_aOptions['actions_bulk']) || !empty($sPaginate),
  175. 'content' => array(
  176. 'bx_if:actions_bulk' => array (
  177. 'condition' => !empty($this->_aOptions['actions_bulk']),
  178. 'content' => array(
  179. 'actions_bulk' => $this->_getActions ('bulk'),
  180. ),
  181. ),
  182. 'paginate' => $sPaginate,
  183. )
  184. ),
  185. 'bx_if:display_header' => array (
  186. 'condition' => $isDisplayHeader,
  187. 'content' => array (
  188. 'bx_if:actions_independent' => array (
  189. 'condition' => !empty($this->_aOptions['actions_independent']),
  190. 'content' => array(
  191. 'actions_independent' => $this->_getActions ('independent'),
  192. ),
  193. ),
  194. 'bx_if:filter' => array (
  195. 'condition' => !empty($this->_aOptions['filter_fields']) || !empty($this->_aOptions['filter_fields_translatable']),
  196. 'content' => array(
  197. 'controls' => $this->_getFilterControls(),
  198. ),
  199. ),
  200. ),
  201. ),
  202. );
  203. $this->_addJsCss();
  204. return $this->_oTemplate->parseHtmlByName('grid.html', $aVars);
  205. }
  206. /**
  207. * Reset query params, like filter and page number
  208. */
  209. public function resetQueryParams()
  210. {
  211. foreach ($this->_aQueryReset as $sKey) {
  212. unset($_GET[$sKey]);
  213. unset($_POST[$sKey]);
  214. }
  215. }
  216. protected function _getRowHead ()
  217. {
  218. $aRet = array();
  219. foreach ($this->_aOptions['fields'] as $sKey => $a) {
  220. $sMethod = '_getCellHeaderDefault';
  221. $sCustomMethod = '_getCellHeader' . $this->_genMethodName($sKey);
  222. if (method_exists($this, $sCustomMethod))
  223. $sMethod = $sCustomMethod;
  224. $aRet[] = array('header_cell' => $this->$sMethod($sKey, $a));
  225. }
  226. return $aRet;
  227. }
  228. protected function _getCellHeaderDefault ($sKey, $aField)
  229. {
  230. $sHeader = bx_process_output($aField['title']);
  231. if (!empty($this->_aOptions['sorting_fields']) && is_array($this->_aOptions['sorting_fields']) && in_array($sKey, $this->_aOptions['sorting_fields'])) {
  232. $sHeader = '<a href="javascript:void(0);" class="bx-grid-sort-handle">' . $sHeader . '</a><span class="bx-grid-sort-indi"></span>';
  233. $aField['attr_head']['bx_grid_sort_head'] = $sKey;
  234. }
  235. $sAttr = $this->_convertAttrs(
  236. $aField, 'attr_head',
  237. 'bx-def-padding-sec-bottom bx-def-padding-sec-top bx-grid-header-' . $sKey, // add default classes
  238. isset($aField['width']) ? 'width:' . $aField['width'] : false // add default styles
  239. );
  240. return $this->_getCellHeaderWrapper ($sKey, $aField, $sHeader, $sAttr);
  241. }
  242. protected function _getCellHeaderCheckbox ($sKey, $aField)
  243. {
  244. $aAttr = array(
  245. 'type' => 'checkbox',
  246. 'id' => $this->_sObject . '_check_all',
  247. 'name' => $this->_sObject . '_check_all',
  248. 'onclick' => "$('input[name=" . $this->_sObject . "_check]:not([disabled])').attr('checked', this.checked)"
  249. );
  250. if($this->_bSelectAll)
  251. $aAttr['checked'] = 'checked';
  252. $aField['attr'] = isset($aField['attr']) && is_array($aField['attr']) ? array_merge($aAttr, $aField['attr']) : $aAttr;
  253. $sAttrHead = $this->_convertAttrs(
  254. $aField, 'attr_head',
  255. 'bx-def-padding-sec-bottom bx-def-padding-sec-top bx-grid-header-' . $sKey, // add default classes
  256. isset($aField['width']) ? 'width:' . $aField['width'] : false // add default styles
  257. );
  258. return $this->_getCellHeaderWrapper ($sKey, $aField, ' <input ' . $this->_convertAttrs($aField, 'attr') . ' /> ', $sAttrHead);
  259. }
  260. protected function _getCellHeaderWrapper ($sKey, $aField, $sHeader, $sAttr)
  261. {
  262. return '<th ' . $sAttr . '>' . $sHeader . '</th>';
  263. }
  264. /**
  265. * Check if the whole row is disabled.
  266. * When row is disabled - checkbox is not selectable, actions aren't clickable and text is grayed out.
  267. * By default all rows aren't disabled.
  268. * @param $aRow row array
  269. * @return boolean
  270. */
  271. protected function _isRowDisabled($aRow)
  272. {
  273. if (isset($aRow[$this->_aOptions['field_active']]) && !$this->_switcherState2Checked($aRow[$this->_aOptions['field_active']]))
  274. return true;
  275. return false;
  276. }
  277. /**
  278. * Determine how actions are disabled when whole row is disabled.
  279. * @param $aRow row array
  280. * @return null - disable/enable actions when row is disabled/enabled, true - actions are always disabled, false - actions are always enabled
  281. */
  282. protected function _getActionsDisabledBehavior($aRow)
  283. {
  284. return null;
  285. }
  286. /**
  287. * Check if the checkbox is disabled.
  288. * @param $aRow row array
  289. * @return boolean
  290. */
  291. protected function _isCheckboxDisabled($aRow)
  292. {
  293. return $this->_isRowDisabled($aRow);
  294. }
  295. /**
  296. * Is checkbox checked by default ?
  297. * By default no one checkbox is selected.
  298. * @return boolean
  299. */
  300. protected function _isCheckboxSelected($mixedValue, $sKey, $aField, $aRow)
  301. {
  302. return $this->_bSelectAll;
  303. }
  304. /**
  305. * Is switcher on by default ?
  306. * By default no one switcher is on.
  307. * @return boolean
  308. */
  309. protected function _isSwitcherOn($mixedValue, $sKey, $aField, $aRow)
  310. {
  311. return $this->_switcherState2Checked($mixedValue);
  312. }
  313. /**
  314. * Convert switcher checked status to the actual value ?
  315. * @return boolean
  316. */
  317. protected function _switcherChecked2State($isChecked)
  318. {
  319. return $isChecked ? 1 : 0;
  320. }
  321. /**
  322. * Convert switcher value to checked(boolean) value ?
  323. * @return boolean
  324. */
  325. protected function _switcherState2Checked($mixedState)
  326. {
  327. return $mixedState ? true : false;
  328. }
  329. protected function _getRowsDataDesign (&$aData)
  330. {
  331. $aGrid = array();
  332. if (empty($aData)) {
  333. $aGrid[] = array(
  334. 'row' => '<td class="bx-def-padding-sec-bottom bx-def-padding-sec-top" colspan="' . count($this->_aOptions['fields']) . '">' . _t('_Empty') . '</td>',
  335. 'id_row' => 0,
  336. 'row_class' => 'bx-grid-table-row-empty',
  337. );
  338. } else {
  339. foreach ($aData as $aRow) {
  340. $sRow = '';
  341. foreach ($this->_aOptions['fields'] as $sKey => $aField)
  342. $sRow .= $this->_getCellDesign($sKey, $aField, $aRow);
  343. $aGrid[] = array(
  344. 'row' => $sRow,
  345. 'id_row' => $this->_sObject . '_row_' . $aRow[$this->_aOptions['field_id']],
  346. 'row_class' => $this->_isRowDisabled($aRow) ? 'bx-grid-table-row-disabled bx-def-font-grayed' : '',
  347. );
  348. }
  349. }
  350. return $aGrid;
  351. }
  352. protected function _getCellDesign($sKey, $aField, $aRow)
  353. {
  354. $sMethod = '_getCellDefault';
  355. if ($this->_aOptions['field_order'] == $sKey)
  356. $sMethod = '_getCellOrder';
  357. $sCustomMethod = '_getCell' . $this->_genMethodName($sKey);
  358. if (method_exists($this, $sCustomMethod))
  359. $sMethod = $sCustomMethod;
  360. $mixedValue = $this->_getCellData($sKey, $aField, $aRow);
  361. if ($aField['translatable'])
  362. $mixedValue = _t($mixedValue);
  363. $mixedValue = $this->_limitMaxLength($mixedValue, $sKey, $aField, $aRow, $this->_isDisplayPopupOnTextOverflow);
  364. return $this->$sMethod($mixedValue, $sKey, $aField, $aRow);
  365. }
  366. protected function _getCellCheckbox ($mixedValue, $sKey, $aField, $aRow)
  367. {
  368. $sAttr = $this->_convertAttrs(
  369. $aField, 'attr_cell',
  370. 'bx-def-padding-sec-bottom bx-def-padding-sec-top', // add default classes
  371. isset($aField['width']) ? 'width:' . $aField['width'] : false // add default styles
  372. );
  373. $sDisabled = ($this->_isCheckboxDisabled($aRow) ? 'disabled="disabled"' : '');
  374. $sSelected = ($this->_isCheckboxSelected($mixedValue, $sKey, $aField, $aRow) ? 'checked="checked"' : '');
  375. $sVal = $aRow[$this->_aOptions['field_id']];
  376. return '<td ' . $sAttr . '><input type="checkbox" name="'. $this->_sObject . '_check" value="' . $sVal . '" ' . $sDisabled . ' ' . $sSelected . '/></td>';
  377. }
  378. protected function _getCellSwitcher ($mixedValue, $sKey, $aField, $aRow)
  379. {
  380. $sAttr = $this->_convertAttrs(
  381. $aField, 'attr_cell',
  382. 'bx-def-padding-sec-bottom bx-def-padding-sec-top', // add default classes
  383. isset($aField['width']) ? 'width:' . $aField['width'] : false // add default styles
  384. );
  385. $oForm = new BxTemplFormView(array(), $this->_oTemplate);
  386. $oForm->addCssJs();
  387. $aInput = array(
  388. 'type' => 'switcher',
  389. 'name' => $this->_sObject . '_switch_' . $aRow[$this->_aOptions['field_id']],
  390. 'caption' => '',
  391. 'attrs' => array (
  392. 'bx_grid_action_single' => 'enable',
  393. 'bx_grid_action_confirm' => '',
  394. 'bx_grid_action_data' => $aRow[$this->_aOptions['field_id']],
  395. ),
  396. 'value' => $aRow[$this->_aOptions['field_id']],
  397. 'checked' => $this->_isSwitcherOn(isset($aRow[$this->_aOptions['field_active']]) ? $aRow[$this->_aOptions['field_active']] : false, $sKey, $aField, $aRow),
  398. );
  399. $sSwitcher = $oForm->genInput($aInput);
  400. return '<td ' . $sAttr . '>' . $sSwitcher . '</td>';
  401. }
  402. protected function _getCellOrder ($mixedValue, $sKey, $aField, $aRow)
  403. {
  404. $sAttr = $this->_convertAttrs(
  405. $aField, 'attr_cell',
  406. 'bx-def-padding-sec-bottom bx-def-padding-sec-top', // add default classes
  407. isset($aField['width']) ? 'width:' . $aField['width'] : false // add default styles
  408. );
  409. return '<td ' . $sAttr . '><div id="' . $this->_sObject . '_cell_' . $aRow[$this->_aOptions['field_id']] . '" class="bx-grid-drag-handle"><i class="sys-icon align-justify"></i></div></td>';
  410. }
  411. protected function _getCellActions ($mixedValue, $sKey, $aField, $aRow)
  412. {
  413. $sAttr = $this->_convertAttrs(
  414. $aField, 'attr_cell',
  415. 'bx-def-padding-sec-bottom bx-def-padding-sec-top', // add default classes
  416. isset($aField['width']) ? 'width:' . $aField['width'] : false // add default styles
  417. );
  418. $mixedDisabledBehavior = $this->_getActionsDisabledBehavior($aRow);
  419. $sActions = $this->_getActions('single', $aRow[$this->_aOptions['field_id']], false, null === $mixedDisabledBehavior ? $this->_isRowDisabled($aRow) : $mixedDisabledBehavior, null !== $mixedDisabledBehavior, $aRow);
  420. return '<td ' . $sAttr . '><div class="bx-grid-cell-single-actions-wrapper bx-def-margin-thd-neg">' . $sActions . '</div></td>';
  421. }
  422. protected function _getCellDefault ($mixedValue, $sKey, $aField, $aRow)
  423. {
  424. $sAttr = $this->_convertAttrs(
  425. $aField, 'attr_cell',
  426. 'bx-def-padding-sec-bottom bx-def-padding-sec-top', // add default classes
  427. isset($aField['width']) ? 'width:' . $aField['width'] : false // add default styles
  428. );
  429. return '<td ' . $sAttr . '>' . $mixedValue . '</td>';
  430. }
  431. protected function _getActions ($sType, $sActionData = false, $isSmall = false, $isDisabled = false, $isPermanentState = false, $aRow = array())
  432. {
  433. $sActionsType = 'actions_' . $sType;
  434. if (empty($this->_aOptions[$sActionsType]) || !is_array($this->_aOptions[$sActionsType]))
  435. return '';
  436. $sRet = '';
  437. foreach ($this->_aOptions[$sActionsType] as $sKey => $a) {
  438. $sFunc = '_getAction' . $this->_genMethodName($sKey);
  439. if (!method_exists($this, $sFunc))
  440. $sFunc = empty($a) ? '_getActionDivider' : '_getActionDefault';
  441. if (!isset($a['attr']['bx_grid_action'])) {
  442. $a['attr']['bx_grid_action_' . $sType] = $sKey;
  443. if (!empty($sActionData))
  444. $a['attr']['bx_grid_action_data'] = $sActionData;
  445. if (isset($a['confirm']))
  446. $a['attr']['bx_grid_action_confirm'] = $a['confirm'] ? 1 : 0;
  447. $a['attr']['bx_grid_action_reset_paginate'] = false === strpos($sKey, 'delete') ? 0 : 1; // reset paginate after deleting row
  448. }
  449. if ($isPermanentState && !isset($a['attr']['bx_grid_permanent_state']))
  450. $a['attr']['bx_grid_permanent_state'] = 1;
  451. $sRet .= $this->$sFunc($sType, $sKey, $a, $isSmall, $isDisabled, $aRow);
  452. }
  453. return $sRet;
  454. }
  455. protected function _getActionDefault ($sType, $sKey, $a, $isSmall = false, $isDisabled = false, $aRow = array())
  456. {
  457. if ($a['icon_only'] && empty($a['attr']['title']) && !empty($a['title']))
  458. $a['attr']['title'] = $a['title'];
  459. $sAttr = $this->_convertAttrs(
  460. $a, 'attr',
  461. 'bx-btn bx-def-margin-thd' . ($isSmall ? ' bx-btn-small' : '') . ($isDisabled ? ' bx-btn-disabled' : '') // add default classes
  462. );
  463. $sIcon = '';
  464. $sImage = '';
  465. if (!empty($a['icon'])) {
  466. if (false === strpos($a['icon'], '.'))
  467. $sIcon = '<i class="sys-icon ' . $a['icon'] . '"></i>';
  468. elseif ($sIconUrl = $this->_oTemplate->getIconUrl($a['icon']))
  469. $sImage = '<img style="background-image:url(' . $sIconUrl . ');" src="' . $this->_oTemplate->getIconUrl('spacer.gif') .'" />';
  470. }
  471. return '<button ' . $sAttr . '>' . $sIcon . $sImage . ($a['icon_only'] || empty($a['title']) ? '' : '<u>' . $a['title'] . '</u>') . '</button>';
  472. }
  473. protected function _getActionDivider ($sType, $sKey, $a, $isSmall = false, $isDisabled = false, $aRow = array())
  474. {
  475. return '<div class="bx-grid-actions-divider bx-def-margin-sec-left"> | </div>';
  476. }
  477. protected function _getFilterControls ()
  478. {
  479. $oForm = new BxTemplStudioFormView(array());
  480. $aInput = array(
  481. 'type' => 'text',
  482. 'name' => 'keyword',
  483. 'attrs' => array(
  484. 'id' => 'bx-grid-search-' . $this->_sObject
  485. )
  486. );
  487. $this->_oTemplate->addCss('forms.css');
  488. return $oForm->genRow($aInput);
  489. }
  490. protected function _limitMaxLength ($mixedValue, $sKey, $aField, $aRow, $isDisplayPopupOnTextOverflow, $bReturnString = true)
  491. {
  492. if ($aField['chars_limit'] > 0)
  493. $mixedValue = BxTemplFunctions::getInstance()->getStringWithLimitedLength($mixedValue, $aField['chars_limit'], $isDisplayPopupOnTextOverflow, $bReturnString);
  494. return $mixedValue;
  495. }
  496. protected function _convertAttrs ($aField, $sAttrName, $sClasses = false, $sStyles = false)
  497. {
  498. return bx_convert_array2attrs(
  499. isset($aField[$sAttrName]) && is_array($aField[$sAttrName]) ? $aField[$sAttrName] : array(),
  500. $sClasses,
  501. $sStyles
  502. );
  503. }
  504. protected function _updateOrder($mixedId, $iOrder)
  505. {
  506. $oDb = BxDolDb::getInstance();
  507. $sTable = $this->_aOptions['table'];
  508. $sFieldId = $this->_aOptions['field_id'];
  509. $sFieldOrder = $this->_aOptions['field_order'];
  510. $sQuery = $oDb->prepare("UPDATE `{$sTable}` SET `{$sFieldOrder}` = ? WHERE `{$sFieldId}` = ?", $iOrder, $mixedId);
  511. return $oDb->query($sQuery);
  512. }
  513. protected function _delete ($mixedId)
  514. {
  515. $oDb = BxDolDb::getInstance();
  516. $sTable = $this->_aOptions['table'];
  517. $sFieldId = $this->_aOptions['field_id'];
  518. $sQuery = $oDb->prepare("DELETE FROM `{$sTable}` WHERE `{$sFieldId}` = ?", $mixedId);
  519. return $oDb->query($sQuery);
  520. }
  521. protected function _enable ($mixedId, $isChecked)
  522. {
  523. $oDb = BxDolDb::getInstance();
  524. $sTable = $this->_aOptions['table'];
  525. $sFieldId = $this->_aOptions['field_id'];
  526. $sFieldActive = $this->_aOptions['field_active'];
  527. $sQuery = $oDb->prepare("UPDATE `{$sTable}` SET `$sFieldActive` = ? WHERE `{$sFieldId}` = ?", $this->_switcherChecked2State($isChecked), $mixedId);
  528. return $oDb->query($sQuery);
  529. }
  530. protected function _addJsCss()
  531. {
  532. if ($this->_aOptions['field_order']) {
  533. $this->_oTemplate->addJs(array(
  534. 'jquery-ui/jquery.ui.core.min.js',
  535. 'jquery-ui/jquery.ui.widget.min.js',
  536. 'jquery-ui/jquery.ui.mouse.min.js',
  537. 'jquery-ui/jquery.ui.sortable.min.js',
  538. ));
  539. }
  540. $this->_oTemplate->addJs('BxDolGrid.js');
  541. $this->_oTemplate->addCss('grid.css');
  542. $this->_oTemplate->addJsTranslation('_sys_grid_confirmation');
  543. }
  544. }
  545. /** @} */