// 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');
