// Use new method to retrieve records $data = array(); $data['select'] = $select; $data['where'] = $filter; $data['where'][] = 'o.deleted=0'; $data['order_by'] = $orderby; $data['limit'] = $this->ms['MODULES']['ORDERS_LISTING_LIMIT']; $data['offset'] = $offset; //$data['from'][]='tx_multishop_orders o left join tx_multishop_orders_status os on o.status=os.id left join tx_multishop_orders_status_description osd on (os.id=osd.orders_status_id AND o.language_id=osd.language_id)'; $data['from'][] = 'tx_multishop_orders o'; // Define section, so hooks can control the query $data['section'] = 'admin_orders'; if ($this->get['tx_multishop_pi1']['group_by']) { $data['group_by'][] = addslashes($this->get['tx_multishop_pi1']['group_by']); } $pageset = mslib_fe::getRecordsPageSet($data); $tmporders = $pageset['dataset']; if ($pageset['total_rows'] > 0) { require \TYPO3\CMS\Core\Utility\ExtensionManagementUtility::extPath('multishop') . 'scripts/admin_pages/includes/orders/orders_listing_table.php'; } else { $subpartArray = array(); $subpartArray['###LABEL_NO_RESULTS###'] = $this->pi_getLL('no_orders_found') . '.'; $no_results = $this->cObj->substituteMarkerArrayCached($subparts['orders_noresults'], array(), $subpartArray); } $payment_status_select = '<select name="payment_status" id="payment_status" class="order_select2"> <option value="">' . $this->pi_getLL('select_orders_payment_status') . '</option>'; if ($this->cookie['payment_status'] == 'paid_only') { $payment_status_select .= '<option value="paid_only" selected="selected">' . $this->pi_getLL('show_paid_orders_only') . '</option>'; } else { $payment_status_select .= '<option value="paid_only">' . $this->pi_getLL('show_paid_orders_only') . '</option>'; }
function renderInterface($params, &$that) { mslib_fe::init($that); //hook to let other plugins further manipulate the method if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_mslib_admin_interface.php']['renderInterfacePreProc'])) { foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_mslib_admin_interface.php']['renderInterfacePreProc'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } } // for pagination $this->get = $that->get; $this->post = $that->post; if ($this->post) { if ($params['postErno']) { if (count($params['postErno'])) { $returnMarkup = ' <div style="display:none" id="msAdminPostMessage"> <table class="table table-striped table-bordered"> <thead> <tr> <th class="text-center">Status</th> <th>Message</th> </tr> </thead> <tbody> '; foreach ($params['postErno'] as $item) { switch ($item['status']) { case 'error': $item['status'] = '<span class="fa-stack text-danger"><i class="fa fa-circle fa-stack-2x"></i><i class="fa fa-thumbs-down fa-stack-1x fa-inverse"></i></span>'; break; case 'info': $item['status'] = '<span class="fa-stack"><i class="fa fa-circle fa-stack-2x"></i><i class="fa fa-thumbs-up fa-stack-1x fa-inverse"></i></span>'; break; } $returnMarkup .= '<tr><td class="text-center">' . $item['status'] . '</td><td>' . $item['message'] . '</td></tr>' . "\n"; } $returnMarkup .= '</tbody></table></div>'; $tableContent .= $returnMarkup; $GLOBALS['TSFE']->additionalHeaderData[] = '<script type="text/javascript" data-ignore="1"> jQuery(document).ready(function ($) { $.confirm({ title: \'\', content: $(\'#msAdminPostMessage\').html() }); }); </script> '; } } } $updateCookie = 0; if ($that->get['Search'] and $that->get['limit'] != $that->cookie['limit']) { $that->cookie['limit'] = $that->get['limit']; $updateCookie = 1; } if ($that->get['Search'] and $that->get['display_all_records'] != $that->cookie['display_all_records']) { $that->cookie['display_all_records'] = $that->get['display_all_records']; $updateCookie = 1; } if ($updateCookie) { $GLOBALS['TSFE']->fe_user->setKey('ses', 'tx_multishop_cookie', $that->cookie); $GLOBALS['TSFE']->storeSessionData(); } if ($that->cookie['display_all_records']) { $that->get['display_all_records'] = $that->cookie['display_all_records']; } else { $that->get['display_all_records'] = ''; } if ($that->cookie['limit']) { $that->get['limit'] = $that->cookie['limit']; } else { $that->get['limit'] = 50; } $that->ms['MODULES']['PAGESET_LIMIT'] = $that->get['limit']; if ($params['settings']['limit'] && is_numeric($params['settings']['limit'])) { $that->ms['MODULES']['PAGESET_LIMIT'] = $params['settings']['limit']; } if (is_numeric($that->get['p'])) { $p = $that->get['p']; } $that->searchKeywords = array(); if ($that->get['tx_multishop_pi1']['keyword']) { // using $_REQUEST cause TYPO3 converts "Command & Conquer" to "Conquer" (the & sign sucks ass) $that->get['tx_multishop_pi1']['keyword'] = trim($that->get['tx_multishop_pi1']['keyword']); $that->get['tx_multishop_pi1']['keyword'] = $GLOBALS['TSFE']->csConvObj->utf8_encode($that->get['tx_multishop_pi1']['keyword'], $GLOBALS['TSFE']->metaCharset); $that->get['tx_multishop_pi1']['keyword'] = $GLOBALS['TSFE']->csConvObj->entities_to_utf8($that->get['tx_multishop_pi1']['keyword'], true); $that->get['tx_multishop_pi1']['keyword'] = mslib_fe::RemoveXSS($that->get['tx_multishop_pi1']['keyword']); $that->searchKeywords[] = $that->get['tx_multishop_pi1']['keyword']; $that->searchMode = '%keyword%'; } $limit_search_result_selectbox = '<select name="limit" class="form-control">'; $limits = array(); $limits[] = '10'; $limits[] = '15'; $limits[] = '20'; $limits[] = '25'; $limits[] = '30'; $limits[] = '40'; $limits[] = '50'; $limits[] = '100'; $limits[] = '150'; $limits[] = '200'; $limits[] = '250'; $limits[] = '300'; $limits[] = '350'; $limits[] = '400'; $limits[] = '450'; $limits[] = '500'; $limits[] = '600'; $limits[] = '700'; $limits[] = '800'; $limits[] = '900'; $limits[] = '1000'; $limits[] = '1500'; $limits[] = '2000'; $limits[] = '2500'; $limits[] = '3000'; $limits[] = '3500'; foreach ($limits as $limit) { $limit_search_result_selectbox .= '<option value="' . $limit . '"' . ($limit == $that->get['limit'] ? ' selected="selected"' : '') . '>' . $limit . '</option>'; } $limit_search_result_selectbox .= '</select>'; $queryData = array(); $queryData['where'] = array(); if (count($that->searchKeywords)) { $keywordOr = array(); $that->searchMode = '%keyword%'; foreach ($that->searchKeywords as $searchKeyword) { if ($searchKeyword) { switch ($that->searchMode) { case 'keyword%': $that->sqlKeyword = addslashes($searchKeyword) . '%'; break; case '%keyword%': default: $that->sqlKeyword = '%' . addslashes($searchKeyword) . '%'; break; } if (is_array($params['query']['keywordSearchByColumns']) && count($params['query']['keywordSearchByColumns'])) { foreach ($params['query']['keywordSearchByColumns'] as $col) { $keywordOr[] = $col . " like '" . $that->sqlKeyword . "'"; } } } } if (is_array($keywordOr) && count($keywordOr)) { $queryData['where'][] = "(" . implode(" OR ", $keywordOr) . ")"; } } if ($params['query']['where']) { if (is_array($params['query']['where'])) { $queryData['where'] = array_merge(array_values($queryData['where']), array_values($params['query']['where'])); } else { $queryData['where'][] = $params['query']['where']; } } switch ($that->get['tx_multishop_pi1']['order_by']) { default: if (is_array($params['query']['defaultOrderByColumns']) && count($params['query']['defaultOrderByColumns'])) { $order_by = implode(',', $params['query']['defaultOrderByColumns']); } break; } switch ($that->get['tx_multishop_pi1']['order']) { case 'a': $order = 'asc'; $order_link = 'd'; break; case 'd': $order = 'desc'; $order_link = 'a'; break; default: if ($params['query']['defaultOrder'] == 'asc') { $order = 'asc'; $order_link = 'd'; } else { $order = 'desc'; $order_link = 'a'; } break; } $orderby[] = $order_by . ' ' . $order; if (is_array($params['query']['select'])) { $queryData['select'] = implode(',', $params['query']['select']); } else { $queryData['select'] = $params['query']['select']; } if (is_array($params['query']['from'])) { $queryData['from'] = implode(',', $params['query']['from']); } else { $queryData['from'] = $params['query']['from']; } if (is_array($params['query']['group_by'])) { $queryData['group_by'] = implode(',', $params['query']['group_by']); } elseif ($params['query']['group_by']) { $queryData['group_by'][] = $params['query']['group_by']; } if (is_array($params['query']['having'])) { $queryData['having'] = $params['query']['having']; } elseif ($params['query']['having']) { $queryData['having'][] = $params['query']['having']; } $queryData['order_by'] = $orderby; $queryData['limit'] = $that->ms['MODULES']['PAGESET_LIMIT']; if (is_numeric($that->get['p'])) { $p = $that->get['p']; } if ($p > 0) { $queryData['offset'] = $p * $that->ms['MODULES']['PAGESET_LIMIT']; } else { $p = 0; $queryData['offset'] = 0; } if ($params['msDebug']) { $this->msDebug = 1; } //$this->msDebug=1; //echo print_r($queryData); //die(); $pageset = mslib_fe::getRecordsPageSet($queryData); if ($this->msDebug) { echo $this->msDebugInfo; die; } if ($params['returnResultsSet']) { return $pageset; } //echo print_r($queryData); //die(); if (count($pageset['dataset'])) { $tr_type = 'even'; if (!$params['settings']['disableForm']) { $tableContent .= '<form method="post" action="' . $params['postForm']['actionUrl'] . '" enctype="multipart/form-data">'; } $tableContent .= '<div class="table-responsive">'; $tableContent .= '<table class="table table-striped table-bordered" id="msAdminTableInterface">'; $tableContent .= '<tr><thead>'; if ($params['settings']['enableRowBasedCheckboxSelection']) { $headerData = ''; $headerData .= ' <script type="text/javascript"> jQuery(document).ready(function($) { $(\'#check_all_1\').click(function(){ $(\'td > div.checkbox > input:checkbox\').prop(\'checked\', this.checked); }); }); </script>'; $GLOBALS['TSFE']->additionalHeaderData[] = $headerData; $headerData = ''; $tableContent .= ' <th class="cellCheckbox"> <div class="checkbox checkbox-success checkbox-inline"> <input type="checkbox" id="check_all_1"> <label for="check_all_1"></label> </div> </th>'; } foreach ($params['tableColumns'] as $col => $valArray) { $tdClass = array(); if ($valArray['align']) { $tdClass[] = 'text-' . $valArray['align']; } if ($valArray['nowrap']) { $tdClass[] = 'cellNoWrap'; } if ($valArray['class']) { $tdClass[] = $valArray['class']; } $tableContent .= '<th' . (count($tdClass) ? ' class="' . implode(' ', $tdClass) . '"' : '') . '>' . $valArray['title'] . '</th>'; } $tableContent .= '</thead></tr><tbody>'; $summarize = array(); $recordCounter = 0; foreach ($pageset['dataset'] as $rowKey => $row) { $recordCounter++; if (!$tr_type or $tr_type == 'even') { $tr_type = 'odd'; } else { $tr_type = 'even'; } $tableContent .= '<tr class="' . $tr_type . '">'; if ($params['settings']['enableRowBasedCheckboxSelection'] && $params['settings']['rowBasedCheckboxSelectionKey']) { $headerData = ''; $headerData .= ' <script type="text/javascript"> jQuery(document).ready(function($) { $(\'#check_all_1\').click(function(){ $(\'td > div.checkbox > input:checkbox\').prop(\'checked\', this.checked); }); }); </script>'; $GLOBALS['TSFE']->additionalHeaderData[] = $headerData; $headerData = ''; $tableContent .= '<td class="cellCheckbox"> <div class="checkbox checkbox-success checkbox-inline"> <input type="checkbox" name="tx_multishop_pi1[tableOverviewSelection][]" id="tableOverviewSelectionCheckbox_' . $row[$params['settings']['rowBasedCheckboxSelectionKey']] . '" value="' . htmlspecialchars($row[$params['settings']['rowBasedCheckboxSelectionKey']]) . '"> <label for="tableOverviewSelectionCheckbox_' . $row[$params['settings']['rowBasedCheckboxSelectionKey']] . '"></label> </div> </td>'; } foreach ($params['tableColumns'] as $col => $valArray) { $originalValue = $row[$col]; switch ($valArray['valueType']) { case 'number_format_2_decimals': $row[$col] = round(number_format($row[$col], 2, '.', ''), 2); $summarize[$col] += $row[$col]; break; case 'number_format_thousand_seperator': $row[$col] = round(number_format($row[$col], 2, '.', ''), 2); break; case 'recordCounter': $row[$col] = $recordCounter; break; case 'download_invoice': $row[$col] = '<a href="uploads/tx_multishopexactonline/' . $row[$col] . '" target="_blank">' . $row[$col] . '</a>'; break; case 'currency': $summarize[$col] += $row[$col]; $row[$col] = mslib_fe::amount2Cents($row[$col], 0); break; case 'domain_name': if ($row[$col]) { $row[$col] = '<a href="http://' . $row[$col] . '" target="_blank">' . $row[$col] . '</a>'; } break; case 'datetime': if ($row[$col]) { $row[$col] = strftime("%x %X", strtotime($row[$col])); } else { $row[$col] = ''; } break; case 'timestamp': if (is_numeric($row[$col]) && $row[$col] > 0) { $row[$col] = strftime("%x %X", $row[$col]); } else { $row[$col] = ''; } break; case 'timestamp_to_day_date_time': if (is_numeric($row[$col]) && $row[$col] > 0) { $row[$col] = strftime("%a. %x<br/>%X", $row[$col]); } else { $row[$col] = ''; } break; case 'timestamp_to_date': if (is_numeric($row[$col]) && $row[$col] > 0) { $row[$col] = strftime("%x", $row[$col]); } else { $row[$col] = ''; } break; case 'form': $content = '<form method="'; switch ($valArray['formAction']) { case 'post': $content .= 'POST'; break; case 'get': default: $content .= 'GET'; break; } $content .= '" action="' . $valArray['actionUrl'] . '" enctype="multipart/form-data">'; if ($valArray['content']) { $content .= $valArray['content']; } if (is_array($valArray['hiddenFields'])) { foreach ($valArray['hiddenFields'] as $hiddenFieldKey => $hiddenFieldVal) { foreach ($row as $tmpCol => $tmpVal) { $hiddenFieldVal = str_replace('###' . $tmpCol . '###', $row[$tmpCol], $hiddenFieldVal); } $content .= '<input name="' . $hiddenFieldKey . '" type="hidden" value="' . $hiddenFieldVal . '" />'; } } $content .= '</form>'; $row[$col] = $content; break; case 'content': foreach ($row as $tmpCol => $tmpVal) { $valArray['content'] = str_replace('###' . $tmpCol . '###', $row[$tmpCol], $valArray['content']); } $row[$col] = $valArray['content']; break; case 'products_detail_page_link': $where = ''; if ($row['categories_id']) { // get all cats to generate multilevel fake url $level = 0; $cats = mslib_fe::Crumbar($row['categories_id']); $cats = array_reverse($cats); $where = ''; if (count($cats) > 0) { foreach ($cats as $cat) { $where .= "categories_id[" . $level . "]=" . $cat['id'] . "&"; $level++; } $where = substr($where, 0, strlen($where) - 1); $where .= '&'; } // get all cats to generate multilevel fake url eof } $product_detail_link = mslib_fe::typolink($this->conf['products_detail_page_pid'], '&' . $where . '&products_id=' . $row['products_id'] . '&tx_multishop_pi1[page_section]=products_detail', 1); $row[$col] = '<a href="' . $product_detail_link . '" target="_blank">' . htmlspecialchars($row['products_name']) . '</a>'; break; case 'boolean': $status_html = ''; if (!$row[$col]) { $status_html .= '<span class="admin_status_red" alt="' . $this->pi_getLL('no') . '"></span>'; } else { $status_html .= '<span class="admin_status_green" alt="' . $this->pi_getLL('yes') . '"></span>'; } $row[$col] = $status_html; break; case 'booleanToggle': $status_html = ''; if (!$row[$col]) { $status_html .= '<span class="admin_status_red" alt="' . $this->pi_getLL('disable') . '"></span>'; if ($valArray['hrefEnable']) { foreach ($row as $tmpCol => $tmpVal) { $valArray['hrefEnable'] = str_replace('###' . $tmpCol . '###', $row[$tmpCol], $valArray['hrefEnable']); } $status_html .= '<a href="' . $valArray['hrefEnable'] . '"><span class="admin_status_green disabled" alt="' . $this->pi_getLL('enabled') . '"></span></a>'; } } else { if ($valArray['hrefDisable']) { foreach ($row as $tmpCol => $tmpVal) { $valArray['hrefDisable'] = str_replace('###' . $tmpCol . '###', $row[$tmpCol], $valArray['hrefDisable']); } $status_html .= '<a href="' . $valArray['hrefDisable'] . '"><span class="admin_status_red disabled" alt="' . $this->pi_getLL('disabled') . '"></span></a>'; } $status_html .= '<span class="admin_status_green" alt="' . $this->pi_getLL('enable') . '"></span>'; } $row[$col] = $status_html; break; } $adjustedValue = $row[$col]; if ($valArray['href']) { foreach ($row as $tmpCol => $tmpVal) { $valArray['href'] = str_replace('###' . $tmpCol . '###', $row[$tmpCol], $valArray['href']); } $adjustedValue = '<a ' . ($valArray['hrefNoFollow'] ? ' rel="nofollow"' : '') . ' href="' . $valArray['href'] . '"' . ($valArray['href_target'] ? ' target="' . $valArray['href_target'] . '""' : '') . '>' . $adjustedValue . '</a>'; } if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_admin_interface.php']['tableColumnsPreProc'])) { $conf = array('col' => &$col, 'row' => &$row, 'originalValue' => &$originalValue, 'adjustedValue' => &$adjustedValue, 'params' => &$params, 'valArray' => &$valArray, 'summarize' => &$summarize); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_admin_interface.php']['tableColumnsPreProc'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $conf, $that); } } $tdClass = array(); if ($valArray['align']) { $tdClass[] = 'text-' . $valArray['align']; } if ($valArray['nowrap']) { $tdClass[] = 'cellNoWrap'; } if ($valArray['class']) { $tdClass[] = $valArray['class']; } $tableContent .= '<td' . (count($tdClass) ? ' class="' . implode(' ', $tdClass) . '"' : '') . '>' . $adjustedValue . '</td>'; } $tableContent .= '</tr>'; if ($params['settings']['returnResultSetAsArray']) { $pageset['dataset'][$rowKey] = $row; } } $tableContent .= '</tbody>'; if (!$params['settings']['skipSummarize']) { // Summarize footer $tableContent .= '<tfoot><tr>'; if ($params['settings']['enableRowBasedCheckboxSelection']) { $tableContent .= '<th></th>'; } foreach ($params['tableColumns'] as $col => $valArray) { switch ($valArray['valueType']) { case 'currency': $row[$col] = mslib_fe::amount2Cents($summarize[$col], 0); break; case 'number_format_2_decimals': $row[$col] = round(number_format($summarize[$col], 2, ',', '.'), 2); break; default: $row[$col] = $valArray['title']; break; } $tdClass = array(); if ($valArray['align']) { $tdClass[] = 'text-' . $valArray['align']; } if ($valArray['nowrap']) { $tdClass[] = 'cellNoWrap'; } if ($valArray['class']) { $tdClass[] = $valArray['class']; } $tableContent .= '<th' . (count($tdClass) ? ' class="' . implode(' ', $tdClass) . '"' : '') . '>' . $row[$col] . '</th>'; // $tableContent.='<th'.($valArray['align'] ? ' class="text-'.$valArray['align'].'"' : '').($valArray['nowrap'] ? ' nowrap' : '').'>'.$row[$col].'</th>'; } $tableContent .= '</tr></tfoot>'; } $tableContent .= '</table>'; if ($params['settings']['enableActionSelectionForm'] && is_array($params['settings']['tableSelectionActions']) && count($params['settings']['tableSelectionActions'])) { $actions = $params['settings']['tableSelectionActions']; if (count($actions)) { // custom page hook that can be controlled by third-party plugin eof $action_selectbox .= '<select name="tx_multishop_pi1[action]" id="msAdminTableAction" class="form-control"><option value="">' . htmlspecialchars($this->pi_getLL('choose_action')) . '</option>'; foreach ($actions as $key => $value) { $action_selectbox .= '<option value="' . htmlspecialchars($key) . '">' . htmlspecialchars($value) . '</option>'; } $action_selectbox .= '</select>'; $tableContent .= $action_selectbox; } } if ($params['settings']['contentBelowTable']) { $tableContent .= $params['settings']['contentBelowTable']; } if ($params['settings']['enableActionSelectionForm'] && is_array($params['settings']['tableSelectionActions']) && count($params['settings']['tableSelectionActions'])) { $tableContent .= '<div class="form-group"> <input class="btn btn-success" type="submit" name="submit" value="' . htmlspecialchars($this->pi_getLL('submit_form')) . '" /> </div>'; } $tableContent .= ' </div> '; if (!$params['settings']['disableForm']) { $tableContent .= '</form>'; } // pagination $paginationMarkup = ''; if (!$params['settings']['skipPaginationMarkup'] and $pageset['total_rows'] > $that->ms['MODULES']['PAGESET_LIMIT']) { $total_pages = ceil($pageset['total_rows'] / $that->ms['MODULES']['PAGESET_LIMIT']); require \TYPO3\CMS\Core\Utility\ExtensionManagementUtility::extPath('multishop') . 'scripts/admin_pages/includes/admin_pagination.php'; $paginationMarkup = $tmp; $tableContent .= $tmp; $tmp = ''; } // pagination eof } $content = ''; $content .= '<div class="panel panel-default">'; $content .= '<div class="panel-heading">'; if ($params['interfaceTitle']) { $interfaceTitle = $params['interfaceTitle']; } else { $interfaceTitle = $params['title']; } $content .= '<h3>' . htmlspecialchars($interfaceTitle) . '</h3>'; if (is_array($params['settings']['headingButtons'])) { $content .= '<div class="form-inline">'; foreach ($params['settings']['headingButtons'] as $headingButton) { $content .= '<a href="' . $headingButton['href'] . '" class="' . $headingButton['btn_class'] . '"' . ($headingButton['attributes'] ? ' ' . $headingButton['attributes'] : '') . '><i class="' . $headingButton['fa_class'] . '"></i> ' . htmlspecialchars($headingButton['title']) . '</a> '; } $content .= '</div>'; } $content .= '</div>'; $content .= '<div class="panel-body">'; if (!$params['settings']['skipTabMarkup']) { $GLOBALS['TSFE']->additionalHeaderData['msAdminTabJs'] = '<script type="text/javascript"> jQuery(document).ready(function ($) { $(\'.nav-tabs a:first\').tab(\'show\'); }); </script> '; $content .= ' <div id="tab-container"> <ul class="nav nav-tabs" id="admin_orders" role="tablist"> <li role="presentation"><a href="#CmsListing" aria-controls="profile" role="tab" data-toggle="tab">' . htmlspecialchars($params['title']) . '</a></li> </ul> <div class="tab-content"> '; } $searchForm = ''; if ($params['settings']['enableKeywordSearch']) { $searchForm = ' <form id="form1" name="form1" method="get" action="index.php"> <div class="well"> <div class="row formfield-container-wrapper"> '; foreach ($params['searchForm']['hiddenFields'] as $key => $val) { $searchForm .= '<input name="' . $key . '" type="hidden" value="' . htmlspecialchars($val) . '" />' . "\n"; } $searchForm .= ' <div class="col-sm-8 formfield-wrapper"> <div class="form-inline"> <label class="control-label">' . $that->pi_getLL('keyword') . '</label> <input type="text" name="tx_multishop_pi1[keyword]" class="form-control" value="' . htmlspecialchars($that->get['tx_multishop_pi1']['keyword']) . '" /> <input type="submit" name="Search" class="btn btn-success" value="' . $that->pi_getLL('search') . '" /> </div> </div> <div class="col-sm-4 formfield-wrapper"> <div class="pull-right form-inline"> <label class="control-label">' . $that->pi_getLL('limit_number_of_records_to') . '</label> ' . $limit_search_result_selectbox . ' </div> </div> </div> </div> </form> '; //hook to let other plugins further manipulate the method if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_mslib_admin_interface.php']['setAdminInterfaceSearchFormPostProc'])) { $interfaceKey =& $this->interfaceKey; $params_searchform = array('interfaceKey' => &$interfaceKey, 'searchForm' => &$searchForm, 'adminInterfaceParams' => &$params); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_mslib_admin_interface.php']['setAdminInterfaceSearchFormPostProc'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params_searchform, $this); } } } if (!$params['settings']['skipTabMarkup']) { $content .= ' <div role="tabpanel" id="CmsListing" class="tab-pane"> ' . $searchForm . ' ' . $tableContent . ' </div> </div> </div> '; } else { $content .= $searchForm . $tableContent; } if ($params['settings']['skipRecordCount'] || $params['settings']['skipRecordCountWhenZeroResults'] && !$pageset['total_rows']) { $skipRecordCount = 1; } if ($params['settings']['skipTotalCount'] || $params['settings']['skipTotalCountWhenZeroResults'] && !$params['summarizeData']['totalRecordsInTable']) { $skipTotalCount = 1; } if (!$skipRecordCount) { $content .= '<p class="text-center">' . $this->pi_getLL('found_records') . ': <strong>' . number_format($pageset['total_rows'], 0, '', '.') . '</strong></p>'; } if (!$skipTotalCount && isset($params['summarizeData']['totalRecordsInTable'])) { $content .= '<p class="text-center">' . $this->pi_getLL('total_records_in_database') . ': <strong>' . number_format($params['summarizeData']['totalRecordsInTable'], 0, '', '.') . '</strong></p>'; } if (!$params['settings']['skipFooterMarkup']) { $content .= '<hr><div class="clearfix"><a class="btn btn-success msAdminBackToCatalog" href="' . mslib_fe::typolink() . '"><span class="fa-stack"><i class="fa fa-circle fa-stack-2x"></i><i class="fa fa-arrow-left fa-stack-1x"></i></span> ' . $that->pi_getLL('admin_close_and_go_back_to_catalog') . '</a></div>'; } $content .= '</div>'; $content .= '</div>'; if ($params['settings']['returnOnlyWhenRecordsFound'] && !$pageset['total_rows']) { //return; } else { if ($params['settings']['returnResultSetAsArray']) { $array = array(); $array['searchForm'] = $searchForm; $array['paginationMarkup'] = $paginationMarkup; $array['dataset'] = $pageset['dataset']; return $array; } else { return $content; } } }
$orderby[] = $order_by . ' ' . $order; $queryData['where'][] = 'c.page_uid=\'' . $this->shop_pid . '\' and cd.language_id=' . $GLOBALS['TSFE']->sys_language_uid . ' and c.id=cd.id'; $queryData['select'][] = '*'; $queryData['from'][] = 'tx_multishop_cms c, tx_multishop_cms_description cd'; $queryData['order_by'] = $orderby; $queryData['limit'] = $this->ms['MODULES']['PAGESET_LIMIT']; if (is_numeric($this->get['p'])) { $p = $this->get['p']; } if ($p > 0) { $queryData['offset'] = $p * $this->ms['MODULES']['PAGESET_LIMIT']; } else { $p = 0; $queryData['offset'] = 0; } $pageset = mslib_fe::getRecordsPageSet($queryData); if (!count($pageset['dataset'])) { $subpartArray = array(); $subpartArray['###LABEL_NO_RESULTS###'] = $this->pi_getLL('no_records_found', 'No records found.'); $no_results = $this->cObj->substituteMarkerArrayCached($subparts['noresults'], array(), $subpartArray); } else { $tr_type = 'even'; $contentItem = ''; foreach ($pageset['dataset'] as $row) { if (!$tr_type or $tr_type == 'even') { $tr_type = 'odd'; } else { $tr_type = 'even'; } if (!$row['name']) { $row['name'] = $this->pi_getLL('admin_label_no_title');