1
0

BxBaseGrid.php 27 KB

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